للناس المحتاجه queries

[Hamza FiGo]

الموضوع يعتبر مكرر . بس تمت الموفقة علشان مجهودك. تسلم ايدك

وبخصوص 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

[amr 15000]

المشاركة الأصلية كتبت بواسطة Hamza FiGo عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

الموضوع يعتبر مكرر . بس تمت الموفقة علشان مجهودك. تسلم ايدك

وبخصوص 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

ماشي يا باشا وشكرا :)

[Dev Ahmed]

المشاركة الأصلية كتبت بواسطة Hamza FiGo عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

الموضوع يعتبر مكرر . بس تمت الموفقة علشان مجهودك. تسلم ايدك

وبخصوص 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

تمام و شكرا ليــك