Hey you all, what's up?
Well, I need some help.. i think u already know.. haha
I'm using PhoOwned's script to add attribute to items bought in website.
I need a script that delete from database items that have X id and no attribute(my server was hacked, and the hacker created many vip items in command /i, so it don't have attribute.)
In my server, boots vip, for sample, is ID 2641, and to delete all cloned boots vip, i want to use a mysql code that delete the items 2641 that has attributes = [BLOB - 0Bytes]
i made a script like this:
DELETE FROM player_items WHERE itemtype = 2641 AND 'attributes' = '[BLOB - 0Bytes]'
but it doesn't work, (deletes 0 lines)
can anybody help me to make a script to do that?
and, if i'm not abusing, the script may delete from player_items, player_depotitems, tile_items ?
Well, I need some help.. i think u already know.. haha
I'm using PhoOwned's script to add attribute to items bought in website.
I need a script that delete from database items that have X id and no attribute(my server was hacked, and the hacker created many vip items in command /i, so it don't have attribute.)
In my server, boots vip, for sample, is ID 2641, and to delete all cloned boots vip, i want to use a mysql code that delete the items 2641 that has attributes = [BLOB - 0Bytes]
i made a script like this:
DELETE FROM player_items WHERE itemtype = 2641 AND 'attributes' = '[BLOB - 0Bytes]'
but it doesn't work, (deletes 0 lines)
can anybody help me to make a script to do that?
and, if i'm not abusing, the script may delete from player_items, player_depotitems, tile_items ?