25-07-2015, 09:23 PM
|
#2
|
|
مـديـر عـام
|
|
• الانـتـسـاب » Dec 2007
|
|
• رقـم العـضـويـة » 6993
|
|
• المشـــاركـات » 7,017
|
|
• الـدولـة » Cairo
|
|
• الـهـوايـة » Helping ppl
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 92
|
|
|
|
رد: للناس المحتاجه queries
الموضوع يعتبر مكرر . بس تمت الموفقة علشان مجهودك. تسلم ايدك
وبخصوص Title lvl استخدم دي
كود:
use SRO_VT_SHARD
Update _Char
set HwanLevel = '43'
where CharName16 = 'Hamza'
و 11-remove item from players
الكيوري بتاعك مش شغال استخدم دة وضيفة لموضوعك الرئيسي
كود:
USE [SRO_VT_SHARD]
/* ***** Hamza * ***** */
DECLARE @Codename128 VARCHAR(128)SET @Codename128 = 'ITEM_MALL_GLOBAL_CHATTING' -- Write code to delete item
UPDATE _Inventory SET ItemID = 0 FROM _Inventory JOIN _Items ON _Items.ID64 = _Inventory.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _Chest SET ItemID = 0 FROM _Chest JOIN _Items ON _Items.ID64 = _Chest.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _GuildChest SET ItemID = 0 FROM _GuildChest JOIN _Items ON _Items.ID64 = _GuildChest.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
UPDATE _InvCOS SET ItemID = 0 FROM _InvCOS JOIN _Items ON _Items.ID64 = _InvCOS.ItemID JOIN _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID WHERE _RefObjCommon.CodeName128 = @Codename128
|
|
|
|