27-04-2021, 02:06 AM
|
#2
|
|
|
• الانـتـسـاب » Aug 2019
|
|
• رقـم العـضـويـة » 144048
|
|
• المشـــاركـات » 610
|
|
• الـدولـة » بيلف الارض
|
|
• الـهـوايـة » *-Developer-*
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 22
|
|
|
|
.gif)
رد: Invalid Inventory Information! SR_GameServer Crach!
lمسح الايتيم دي من كل البلاير
كود PHP:
USE [SRO_VT_SHARD] --- Coded by [iLegend]
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 ))
|
|
|
|