Can Öcalan 1
Can Öcalan
mavzermete 1
mavzermete
farkmt2official 1
farkmt2official
Sevdamsın 1
Sevdamsın
Hikaye Ekle

Vsro Files Hatalar Ve Çözümleri

  • Konuyu başlatan Konuyu başlatan Hack114
  • Başlangıç tarihi Başlangıç tarihi
  • Cevaplar Cevaplar 11
  • Görüntüleme Görüntüleme 13K

Ayyıldız2 | 2008 TR Yapısı • 1-99 Orta Emek Destan • Oto Avsız • 10 Temmuz 21:00 HEMEN TIKLA!

GameServerle EXP Ratelerini Ayarlama

OllyBG açın Ordan GameServeri Açın

================================================== ===========================
PHP:
Exp Rate
0042714C Bunu Aratın anltındakini
TEST AH,42 Bu Hale Getirin

F6C4 50 Daha Sonra Altındaki "100000" i "75000000" Yapın Bu x75 orandır
================================================== ===========================
PT exp Rate

PHP:
004271F5  Aratın altındakini Böle Yapacaksınız
F6C4 42          
TEST AH,42
Bu Şekilde Daha Sonra Altında Party Exp Ratio Diye Birşe Göreceksiniz "100000" i "85000000" Yapın Buda Party Oranını x85 Yapar
================================================== ===========================
İtem Rate


PHP:
004272A0   Aratın
F6C4 42          
TEST AH,42
Önce Bu Şekilde Değiştirin Bunun Altındaki İtem Drop Ratio yu "100000" i "75000000" Yapın
x75 İtem Oranı Yapar
================================================== ===========================
Gold Rate


PHP:
00427349   
F6C4 42          
TEST AH,42
Bunu Bu Halde Değiştireceksiniz Daha Sonra Altındaki "100000" i "75000000" Yapın x75 Gold Rate Oldu
================================================== ===========================
Zerk gelme Oranı


PHP:
004273CA  |. F6C4 44        TEST AH,42
Böyle Yapın Daha Sonra Altındaki "100000" i "3000000" Yapın x3 Zerk Gelme Oranı
================================================== ===========================
Lagdan Kurtarma

PHP:
00964060     81EC 6C060000  SUB ESP,66C

Bu Şekilde Ayarlayıp Sağ Tıklayın Save Deyin Sonra Yaptıgınız Şeyleri Farklı kaydedin Bir Yer Seçmenizi İsteyecek Ordanda Bir Yer Seçin Oraya Bir Program Atacak Onu Açarsanız Exp Ve Diğerleri Fixlenmiş Oldu

Başlangıç Ayarları İDEAL

PHP:
SRO_VT_SHARD -> Programmability -> Stored Procedures -> _AddNewChar (Sağ tık -> Modify)
Başlangıç ayarları :
Değiştirmeniz Gereken Kod ;


PHP:
INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect,  LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,                 
 LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint,  RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber,  WorldID)     
VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID,  @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 109,                 
 GetDate(), 1, 1, 0, 0, 0, 200,200, 1, 1, 1, 1)

SMC Ayarları
db query failed çözümü

SRO_VT_SHARD_INIT-->Programmability-->Stored Procedures-->_SMC_EDIT_ITEM-->Sağ klik-->Modify

PHP:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO

ALTER  procedure [dbo].[_SMC_EDIT_ITEM]
----------------------------------------------------- params to find target item
	@TargetStorage	int,				/* 0 = inventory, 1 = chest, 2 = guild chest, 3 = Avatar Inventory */
	@OwnerName	varchar(128),		/* account id or char id */
	@Slot			int,
	@ItemIDToEdit	bigint,	/* just for check validity */
	----------------------------------------------------- params to modify the item
	@RefItemID		int,
	@OptLvl			tinyint,
	@Variance		bigint,
	@Data			int,
	@szCreater		varchar(32),
	@MagParamNum	int,
	@MagParam1	bigint,
	@MagParam2	bigint,
	@MagParam3	bigint,
	@MagParam4	bigint,
	@MagParam5	bigint,
	@MagParam6	bigint,
	@MagParam7	bigint,
	@MagParam8	bigint,
	@MagParam9	bigint,
	@MagParam10	bigint,
	@MagParam11	bigint,
	@MagParam12	bigint
as
	----------------------------------------------------
	-- step 1. check validity of parameters
	----------------------------------------------------
	if (@TargetStorage <> 0 and @TargetStorage <> 1 and @TargetStorage <> 2 and @TargetStorage <> 3)
	begin
		select -1	-- invalid target storage
		return
	end
	declare @ownerid int
	declare @ItemID bigint
	set @ownerid = 0
	set @ItemID = 0
	if (@TargetStorage = 0)
	begin
		select @ownerid = charid from _char where charname16 = @OwnerName
		if (@@rowcount = 0 or @ownerid = 0 or @ownerid is null)
		begin
			select -2	-- can't find owner
			return
		end
		select @ItemID = ItemID from _inventory where charid = @ownerid and slot = @slot
	end
	else if (@TargetStorage = 1)
	begin
		select @ownerid = JID from _AccountJID where AccountID = @ownername
		if (@@rowcount = 0 or @ownerid = 0 or @ownerid is null)
		begin
			select -2	-- can't find owner
			return
		end
		select @ItemID = itemid from _chest where userjid = @ownerid and slot = @slot
	end
	else if (@TargetStorage = 2)
	begin
		select @ownerid = [id] from _guild where [name] = @ownername
		if (@@rowcount = 0 or @ownerid = 0 or @ownerid is null)
		begin
			select -2	-- can't find owner
			return
		end
		select @ItemID = itemid from _guildchest where guildid = @ownerid and slot = @slot
	end
	else
	begin
		select @ownerid = charid from _char where charname16 = @OwnerName
		if (@@rowcount = 0 or @ownerid = 0 or @ownerid is null)
		begin
			select -2	-- can't find owner
			return
		end
		select @ItemID = ItemID from _InventoryForAvatar where charid = @ownerid and slot = @slot
	end

	if (@ItemID = 0 or @ItemID is null)
	begin
		select -3	-- can't find the item
		return
	end
	if (@ItemID <> @ItemIDToEdit)
	begin
		select -4	-- it's not the one that you wanna edit
		return 
	end
	declare @tid1 int
	declare @tid2 int
	select @tid1 = TypeID1, @tid2 = TypeID2 from _RefObjCommon where ID = @RefItemID
	if (@tid1 <> 3)
	begin
		select -5	-- about to assign non-item object
		return
	end
	if (@tid2 <> 1)		-- is equipment
	begin
		-- can't assign magic param or optlevel to non-equip item
		if (@MagParamNum > 0 or @OptLvl > 0)
		begin
			select -6
			return
		end
	end
	
	----------------------------------------------------
	-- step 2. correct some non-critical parameters
	----------------------------------------------------
	if (@OptLvl > 12)
	begin
		set @OptLvl = 12	-- clamp optlevel to 12 
	end	
	if (LEN(@szCreater) = 0)
		set @szCreater = NULL
	
	----------------------------------------------------
	-- step 3. modify target item to desired values
	----------------------------------------------------
	if (@MagParamNum = 0)
	begin
		update _Items 
		set RefItemID = @RefItemID, OptLevel = @OptLvl, Variance = @Variance, Data = @Data, CreaterName = @szCreater, MagParamNum = 0 
		where ID64 = @ItemID
	end
	else
	begin
		update _Items 
		set  RefItemID = @RefItemID, OptLevel = @OptLvl, Variance = @Variance, Data = @Data, CreaterName = @szCreater, MagParamNum = @MagParamNum,
			MagParam1 = @MagParam1, MagParam2 = @MagParam2, MagParam3 = @MagParam3, MagParam4 = @MagParam4,
			MagParam5 = @MagParam5, MagParam6 = @MagParam6, MagParam7 = @MagParam7, MagParam8 = @MagParam8,
			MagParam9 = @MagParam9, MagParam10 = @MagParam10, MagParam11 = @MagParam11, MagParam12 = @MagParam12
		where ID64 = @ItemID
	end
		
	if (@@error <> 0 or @@rowcount = 0)
	begin
		select -7
		return
	end
	select 1
	return
Kullanıcıya item ekleme hatası çözümü:
PHP:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO


----------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------
-- 20_SMC__ShardDB.sql  _SMC_ADD_ITEM ¼öÁ¤ 
----------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------

 -----------------------------------------------------------------------  
ALTER       procedure [dbo].[_SMC_ADD_ITEM]  
----------------------------------------------------- params to find target item  
 @TargetStorage int,  /* 0 = inventory, 1 = chest , 2 = guild chest, 3 = Avatar Inventory */  
 @OwnerName varchar(128),  
 ----------------------------------------------------- params to modify the item  
 @RefItemID  int,  
 @OptLvl   tinyint,  
 @Variance  bigint,  
 @Data   int,  
 @szCreater  varchar(32),  
 @MagParamNum int,  
 @MagParam1 bigint,  
 @MagParam2 bigint,  
 @MagParam3 bigint,  
 @MagParam4 bigint,  
 @MagParam5 bigint,  
 @MagParam6 bigint,  
 @MagParam7 bigint,  
 @MagParam8 bigint,  
 @MagParam9 bigint,  
 @MagParam10 bigint,  
 @MagParam11 bigint,  
 @MagParam12 bigint  
as  
 ----------------------------------------------------  
 -- step 1. check validity of parameters  
 ----------------------------------------------------  
 if (@TargetStorage <> 0 and @TargetStorage <> 1 and @TargetStorage <> 2 and @TargetStorage <> 3)  
 begin  
  select -1, cast(0 as bigint), cast(0 as bigint) -- invalid target storage  
  return  
 end  
 declare @ownerid int  
 declare @ItemID bigint  
 set @ownerid = 0  
 set @ItemID = 0  
 declare @empty_slot int  
 set @empty_slot = -1  
 if (@TargetStorage = 0)  
 begin  
  select @ownerid = charid from _char where charname16 = @OwnerName  
  if (@@rowcount = 0 or @ownerid = 0 or @ownerid is null)  
  begin  
   select -2, cast(0 as bigint), cast(0 as bigint)-- can't find owner  
   return  
  end  
  
  select top 1 @empty_slot = slot from _inventory   
  where charid = @ownerid and slot >= 13   
   and itemid = 0   
   and slot < (select top 1 InventorySize from _Char where CharID = @ownerid)  
  order by slot asc  
  
  if (@@rowcount = 0)  
  begin  
   select -3, cast(0 as bigint), cast(0 as bigint) -- inventory full  
   return  
  end  
 end  
 else if (@TargetStorage = 1)  
 begin  
  select @ownerid = JID from _AccountJID where AccountID = @ownername  
  if (@@rowcount = 0 or @ownerid = 0 or @ownerid is null)  
  begin  
   select -2, cast(0 as bigint), cast(0 as bigint) -- can't find owner  
   return  
  end  
  select top 1 @empty_slot = slot from _chest where userjid = @ownerid and (ItemID = 0 or ItemID is null) order by slot asc  
  if (@@rowcount = 0)  
  begin  
   select -3, cast(0 as bigint), cast(0 as bigint) -- chest full  
   return  
  end  
 end  
 else if (@TargetStorage = 2)  
 begin  
  select @ownerid = [ID] from _guild where [name] = @ownername  
  if (@@rowcount = 0 or @ownerid = 0 or @ownerid is null)  
  begin  
   select -2, cast(0 as bigint), cast(0 as bigint) -- can't find owner  
   return  
  end   
  select top 1 @empty_slot = slot from _guildchest where guildid = @ownerid and (ItemID = 0 or ItemID is null) order by slot asc  
  if (@@rowcount = 0)  
  begin  
   select -3, cast(0 as bigint), cast(0 as bigint) -- chest full  
   return  
  end   
    
  -- ±æµå ·¹º§¿¡ µû¸¥ ±æµå ½½·Ô¼ö Á¦ÇÑÀ» È®ÀÎÇÏÀÚ.  
  declare @lvl tinyint  
  declare @max_slot tinyint  
  select @lvl = Lvl from _guild where [id] = @ownerid  
  set @max_slot = 30 * (@lvl - 1) - 1  
  
  if @empty_slot > @max_slot   
  begin  
   select -3, cast(0 as bigint), cast(0 as bigint) -- chest full  
   return  
  end      
 end  
 else  
 begin  
  select @ownerid = charid from _char where charname16 = @OwnerName  
  if (@@rowcount = 0 or @ownerid = 0 or @ownerid is null)  
  begin  
   select -2, cast(0 as bigint), cast(0 as bigint)-- can't find owner  
   return  
  end  
  
  select top 1 @empty_slot = slot from _InventoryForAvatar  
  where charid = @ownerid  
   and ItemID = 0   
   and slot < 4     -- ÇÁ·Î½ÃÁ® ÇϵåÄÚµù(¾Æ¹ÙŸ ½½·ÔÀº 0, 1, 2, 3ÀÌ´Ù.)  
  order by slot asc  
  
  if (@@rowcount = 0)  
  begin  
   select -3, cast(0 as bigint), cast(0 as bigint) -- inventory full  
   return  
  end  
 end  
   
  
 if (@empty_slot < 0 or @empty_slot is null)  
 begin   
  select -4, cast(0 as bigint), cast(0 as bigint)  -- unknown error ???  
  return  
 end  
   
 declare @tid1 int  
 declare @tid2 int  
 declare @tid3 int  
  declare @tid4 int  
   
 select @tid1 = TypeID1, @tid2 = TypeID2, @tid3 = TypeID3, @tid4 = TypeID4 from _RefObjCommon where ID = @RefItemID  
 if (@tid1 <> 3)  
 begin  
  select -5, cast(0 as bigint), cast(0 as bigint) -- about to assign non-item object  
  return  
 end  
 if (@tid2 <> 1)  -- is not equipment  
 begin  
  -- can't assign magic param or optlevel to non-equip item  
  if (@MagParamNum > 0 or @OptLvl > 0)  
  begin  
   select -6, cast(0 as bigint), cast(0 as bigint)  
   return  
  end  
 end  
   
 ----------------------------------------------------  
 -- step 2. correct some non-critical parameters  
 ----------------------------------------------------  
 if (@tid2 = 3 and @Data = 0) -- can't assign overlap count 0 to expendable item  
 begin  
  set @Data = 1  
 end  
  
 if (LEN(@szCreater) = 0)  
  set @szCreater = NULL  
  
 ----------------------------------------------------  
 -- step add. equip and pet @data setting  
 ----------------------------------------------------  
 declare @IS_EQUIP int  
 declare @IS_PET int  
  
 set @IS_EQUIP = 0  
 set @IS_PET = 0  
  
 if (@tid1 = 3 and @tid2 = 1)  
  set @IS_EQUIP = 1  
 else if (@tid1 = 3 and @tid2 = 2 and @tid3 = 1 and (@tid4 = 1 or @tid4 = 2))  
  set @IS_PET = 1  
  
 if (@IS_EQUIP = 1)  
 begin  
  
	-- Àß ¸øµÈ ID·Î select Çϰí ÀÖÀ½. ¼öÁ¤ (by binu 2008-10-17)
	--	select @Data = Dur_L from _RefObjItem where ID =  @RefItemID
    select @Data = Dur_L from _RefObjItem where ID = (select Link from _RefObjCommon where ID = @RefItemID )
    
   if (@OptLvl < 0)  
    set @OptLvl = 0  
   else if (@OptLvl > 12)  
    set @OptLvl = 12  
  
 end  
 else  
 begin  
  
  if( @IS_PET = 1 )  
   set @Data = 0  
  else  
  begin  
   declare @MaxCount int  
   select @MaxCount = MaxStack from _RefObjItem where ID = @RefItemID  
   
   if (@Data <= 0 or @Data > @MaxCount)    
    set @Data = @MaxCount    
  end  
  
  set @OptLvl = 0  
 end  
  
  
 ----------------------------------------------------------  
 -- Step3. create item and set to associated storage  
 ----------------------------------------------------------  
 set xact_abort on  
begin transaction  
   
 declare @NewItemID  bigint  
 declare @Serial64 bigint  
 set @NewItemID  = 0  
 set @Serial64 = 0  
 exec @NewItemID = _STRG_ALLOC_ITEM_NoTX @Serial64 OUTPUT  
 if (@NewItemID = 0)  
 begin  
  rollback transaction  
  select -7, cast(0 as bigint), cast(0 as bigint)  
  return  
 end  
 if (@MagParamNum = 0)  
 begin  
  update _Items set RefItemID = @RefItemID, OptLevel = @OptLvl, Variance = @Variance, Data = @Data, MagParamNum = 0, Serial64 = @Serial64   
  where ID64 = @NewItemID  
 end  
 else  
 begin  
  update _Items set RefItemID = @RefItemID, OptLevel = @OptLvl, Variance = @Variance, Data = @Data, MagParamNum = @MagParamNum,   
    MagParam1 = @MagParam1, MagParam2 = @MagParam2, MagParam3 = @MagParam3, MagParam4 = @MagParam4,  
    MagParam5 = @MagParam5, MagParam6 = @MagParam6, MagParam7 = @MagParam7, MagParam8 = @MagParam8,  
    MagParam9 = @MagParam9, MagParam10= @MagParam10, MagParam11 = @MagParam11, MagParam12 = @MagParam12, Serial64 = @Serial64  
  where ID64 = @NewItemID  
 end  
 if (@@error <> 0)  
 begin  
  rollback transaction  
  select -8, cast(0 as bigint), cast(0 as bigint)  
  return  
 end  
 if (@TargetStorage = 0)  
  update _Inventory set ItemID = @NewItemID where CharID = @ownerid and Slot = @empty_slot  
 else if (@TargetStorage = 1)  
  update _chest set ItemID = @NewItemID where UserJID = @ownerid and slot = @empty_slot  
 else if (@TargetStorage = 2)  
  update _guildchest set ItemID = @NewItemID where guildid = @ownerid and slot = @empty_slot  
 else  
  update _InventoryForAvatar set ItemID = @NewItemID where CharID = @ownerid and Slot = @empty_slot  
   
 if (@@rowcount = 0 or @@error <> 0)  
 begin  
  rollback transaction  
  select -9, cast(0 as bigint), cast(0 as bigint)  
  return  
 end  
   
 commit transaction  
 select @empty_slot, @NewItemID, @Serial64  
 return

Kullanıcı itemi silme hatası çözümü
PHP:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO



-----------------------------------------------------------------------
ALTER   procedure [dbo].[_SMC_DEL_ITEM]
----------------------------------------------------- params to find target item
	@TargetStorage	int,		/* 0 = inventory, 1 = chest, 2 = guild chest, 3 = Avatar Inventory */
	@OwnerName	varchar(128),
	----------------------------------------------------- params to modify the item
	@Slot			int
as
	----------------------------------------------------
	-- step 1. check validity of parameters
	----------------------------------------------------
	if (@TargetStorage <> 0 and @TargetStorage <> 1 and @TargetStorage <> 2 and @TargetStorage <> 3)
	begin
		select -1
		return
	end
	declare @ownerid int
	declare @ItemToDel bigint
	set @ownerid = 0
	set @ItemToDel = 0
	if (@TargetStorage = 0)
	begin
		select @ownerid = charid from _char where charname16 = @OwnerName
		if (@@rowcount = 0 or @ownerid = 0 or @ownerid is null)
		begin
			select -2
			return
		end
		select @ItemToDel = ItemID from _inventory where charid = @ownerid and slot = @Slot
		if (@@rowcount = 0 or @ItemToDel = 0)
		begin
			select -3
			return
		end
	end
	else if (@TargetStorage = 1)
	begin
		select @ownerid = JID from _AccountJID where AccountID = @ownername
		if (@@rowcount = 0 or @ownerid = 0 or @ownerid is null)
		begin
			select -2
			return
		end
		select @ItemToDel = ItemID from _Chest where UserJID = @ownerid and slot = @Slot
		if (@@rowcount = 0 or @ItemToDel = 0)
		begin
			select -3
			return
		end
	end
	else if (@TargetStorage = 2)
	begin
		select @ownerid = [id] from _guild where [name] = @ownername
		if (@@rowcount = 0 or @ownerid = 0 or @ownerid is null)
		begin
			select -2
			return
		end	
		select @ItemToDel = ItemID from _GuildChest where GuildID = @ownerid and slot = @Slot
		if (@@rowcount = 0 or @ItemToDel = 0)
		begin
			select -3
			return
		end
	end
	else
	begin
		select @ownerid = charid from _char where charname16 = @OwnerName
		if (@@rowcount = 0 or @ownerid = 0 or @ownerid is null)
		begin
			select -2
			return
		end
		select @ItemToDel = ItemID from _InventoryForAvatar where charid = @ownerid and slot = @Slot
		if (@@rowcount = 0 or @ItemToDel = 0)
		begin
			select -3
			return
		end
	end

	if (@ItemToDel = 0 or @ItemToDel is null)
	begin 
		select -4
		return
	end
	
BEGIN TRANSACTION
	----------------------------------------------------------
	-- Step2. ½½·Ô ºñ¿ì±â
	----------------------------------------------------------	
	if (@TargetStorage = 0)
	BEGIN
		UPDATE _Inventory SET ItemID = 0 WHERE CharID = @ownerid AND Slot = @Slot
	END
	ELSE IF (@TargetStorage = 1)
	BEGIN
		UPDATE _Chest SET ItemID = 0 WHERE UserJID = @ownerid AND Slot = @Slot
	END
	ELSE IF (@TargetStorage = 2)
	BEGIN
		UPDATE _GuildChest SET ItemID = 0 WHERE GuildID = @ownerid AND Slot = @Slot
	END
	ELSE
	BEGIN
		UPDATE _InventoryForAvatar SET ItemID = 0 WHERE CharID = @ownerid AND Slot = @Slot
	END

	IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
	BEGIN
		ROLLBACK TRANSACTION
		SELECT -5
		RETURN
	END
	
	----------------------------------------------------------  
	-- »èÁ¦ ´ë»ó ¾ÆÀÌÅÛ¿¡ ¹*ÀÎ ÀÓ´ë Á¤º¸ »èÁ¦
	----------------------------------------------------------  
	if exists (select 1 from _RentItemInfo with (nolock) where nItemDBID = @ItemToDel)
	begin
		delete from _RentItemInfo where nItemDBID = @ItemToDel
		if (@@ERROR <> 0 OR @@ROWCOUNT = 0)
		begin
			rollback transaction
			select -6
			return
		end
	end
	
	----------------------------------------------------------
	-- Step3. ÇØ´ç ¾ÆÀÌÅÛ »èÁ¦ 
	----------------------------------------------------------
	DECLARE @Rvalue INT
	EXEC @Rvalue = _STRG_FREE_ITEM_NoTX  @ItemToDel
	IF (@Rvalue < 0)
	BEGIN
		ROLLBACK TRANSACTION
		SELECT -6
		RETURN
	END
	----------------------------------------------------------
	-- Step4. COMMIT
	----------------------------------------------------------	
	COMMIT TRANSACTION
	SELECT 1
	RETURN
=============================================================================
Gameserver Green Book Fixleme:
OllyDebugger ile GameServer i Açın
PHP:
Sağ Tıklayın -- > Search For --> Constant
Hex Yazan Yere Tıklayıp Silin Ve 3122 Yazın ve Ok Diyin
Sağ Tık -- > Search For --> Next Diyin
Karşınıza PUSH 3122 Gelecek Üzerine Çift Tıklayıp Açın ve Hepsini Silip RETN Yazın ve Assemble Diyin
Sonra Sağ tık -- > Copy to executable -- > All Modifications Diyin
Yeni Açılan Pencereden Sağ Tık --> Save File
Diyip Kaydedin.

===============================================================================
Gameserver Quest:RaiseEvent Hatası Fixleme:
OllyDebugger ile Gameserveri Açın
PHP:
005805C8   .  56            push    esi
005805C9   .  68 C4D8AF00   push    00AFD8C4
005805CE   .  68 00000001   push    1000000
005805D3   .  E8 68603B00   call    00936640
005805D8   .  83C4 0C       add     esp, 0C
Bunları Teker Teker NOP Yapın Bitmiştir.
===============================================================================
(F1-2-3-4) Slot Bugu Fix Query
SRO_VT_SHARD_INIT e İşletin;
PHP:
UPDATE _RefCharDefault_Quest SET Service = 1
DELETE FROM _CharQuest WHERE QuestID = 1
INSERT INTO _CharQuest (CharID, QuestID, Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2) SELECT CharID, 1,5,0, '2012-04-13 20:44:00','2013-07-30 13:55:00',31458135,0 FROM _CHAR where CharID > 0
===============================================================================
Mob Respawn Fix
İndirme linki
PHP:
Öncelikle Verdiğim Dosyayı Linkten İndirin ve 'C:\' dizinine Çıkarın

Sonra Bu Kodu SQL işletin
PHP:
DELETE FROM [SRO_VT_SHARD_INIT].[dbo].[Tab_RefNest] USE [SRO_VT_SHARD_INIT] 
GO 
BULK INSERT Tab_RefNest FROM 'C:\RefNest.txt' WITH (FIELDTERMINATOR = '\t')
===============================================================================
Job Rate Arttırma
PHP:
USE [SRO_VT_SHARD_INIT]
GO

UPDATE dbo._RefObjCommon
SET Price = 383*20
WHERE Price = 383

UPDATE dbo._RefObjCommon
SET SellPrice = 191*20
WHERE SellPrice = 191

UPDATE dbo._RefPricePolicyOfItem
SET Cost = 383*20
WHERE Cost = 383
===============================================================================
GameServer Max 110 dan Sonra Çökmesi Fix
PHP:
Aratın
004E5471      817C24 20 B40>cmp     DWORD PTR [ESP+20], 1B4

DWORD PTR [ESP+20], 1B4

Değiştir

DWORD PTR [ESP+20], 1E0
 
Son düzenleme:
Videolu Anlatımlar!
================================================== =====================
Gameserver Rate Ayarlama

================================================== =====================
SMC Edit İtem Hatası Fix
 
Son düzenleme:
SMC Add Item Hatası Fix

================================================== =====================
SMC Delete Item Hatası Fix
 
GameServer Green Book Fixleme (Kaldırma!)!

================================================== =====================
GameServer Quest:RaiseEvent Fixleme!
 

Şu an konuyu görüntüleyenler (Toplam : 0, Üye: 0, Misafir: 0)

Geri
Üst