27-11-2015, 04:30 PM
|
#4
|
|
• الانـتـسـاب » Jan 2014
|
• رقـم العـضـويـة » 116041
|
• المشـــاركـات » 2,589
|
• الـدولـة » Gizaaa
|
• الـهـوايـة » SilkRoad4Arab Only One <3
|
• اسـم الـسـيـرفـر » Private Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 26
|
|
|
رد: Remove Item From All Player
جرب دي كدا
Work 100%
كود PHP:
USE [SRO_VT_SHARD] --- Coded by [] Declare @ItemCodeName Varchar (129) Set @ItemCodeName = 'CodeName128' --- write here the item codename128 that u want to remove it from all players. Update _Chest Set ItemID = 0 where ItemID in ( Select ID64 From _Items where RefItemID = (Select ID From _RefObjCommon where CodeName128 = @ItemCodeName )) Update _Inventory Set ItemID = 0 where ItemID in ( Select ID64 From _Items where RefItemID = (Select ID From _RefObjCommon where CodeName128 = @ItemCodeName )) Update _InvCOS Set ItemID = 0 where ItemID in ( Select ID64 From _Items where RefItemID = (Select ID From _RefObjCommon where CodeName128 = @ItemCodeName ))
|
|
|