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
================================================== ===========================
F6C4 50 Daha Sonra Altındaki "100000" i "75000000" Yapın Bu x75 orandır
================================================== ===========================
PT exp Rate
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
Önce Bu Şekilde Değiştirin Bunun Altındaki İtem Drop Ratio yu "100000" i "75000000" Yapın
x75 İtem Oranı Yapar
================================================== ===========================
Gold Rate
Bunu Bu Halde Değiştireceksiniz Daha Sonra Altındaki "100000" i "75000000" Yapın x75 Gold Rate Oldu
================================================== ===========================
Zerk gelme Oranı
Böyle Yapın Daha Sonra Altındaki "100000" i "3000000" Yapın x3 Zerk Gelme Oranı
================================================== ===========================
Lagdan Kurtarma
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
Başlangıç ayarları :
Değiştirmeniz Gereken Kod ;
SMC Ayarları
db query failed çözümü
SRO_VT_SHARD_INIT-->Programmability-->Stored Procedures-->_SMC_EDIT_ITEM-->Sağ klik-->Modify
Kullanıcıya item ekleme hatası çözümü:
Kullanıcı itemi silme hatası çözümü
=============================================================================
Gameserver Green Book Fixleme:
OllyDebugger ile GameServer i Açın
===============================================================================
Gameserver Quest:RaiseEvent Hatası Fixleme:
OllyDebugger ile Gameserveri Açın
===============================================================================
(F1-2-3-4) Slot Bugu Fix Query
SRO_VT_SHARD_INIT e İşletin;
===============================================================================
Mob Respawn Fix
İndirme linki
Sonra Bu Kodu SQL işletin
===============================================================================
Job Rate Arttırma
===============================================================================
GameServer Max 110 dan Sonra Çökmesi Fix
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
================================================== ===========================
İtem Rate
PHP:
004272A0 Aratın
F6C4 42
TEST AH,42
x75 İtem Oranı Yapar
================================================== ===========================
Gold Rate
PHP:
00427349
F6C4 42
TEST AH,42
================================================== ===========================
Zerk gelme Oranı
PHP:
004273CA |. F6C4 44 TEST AH,42
================================================== ===========================
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)
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
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
Linkleri görebilmek için Turkmmo Forumuna ÜYE olmanız gerekmektedir.
PHP:
Öncelikle Verdiğim Dosyayı Linkten İndirin ve 'C:\' dizinine Çıkarın
Linkleri görebilmek için Turkmmo Forumuna ÜYE olmanız gerekmektedir.
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
================================================== =====================
Gameserver Rate Ayarlama
================================================== =====================
SMC Edit İtem Hatası Fix
Son düzenleme:
SMC Add Item Hatası Fix
================================================== =====================
SMC Delete Item Hatası Fix
================================================== =====================
SMC Delete Item Hatası Fix
GameServer Green Book Fixleme (Kaldırma!)!
================================================== =====================
GameServer Quest:RaiseEvent Fixleme!
================================================== =====================
GameServer Quest:RaiseEvent Fixleme!
Şu an konuyu görüntüleyenler (Toplam : 0, Üye: 0, Misafir: 0)
Benzer konular
- Cevaplar
- 5
- Görüntüleme
- 99