Item errors/ID changes

[Zinc]

I'm now running TFS 0.2 patch 6(or current)

I was running Geisors TFS rev ~1000 with the 8.11 items or what not...

any way some items that were custom before, are now a Wall, etc.. cause the IDs changed.

i see in PHPMYADMIN that you can view player items..

but it's hard to view them all in 1 player..

i'm going to try to remove the items from the player from within PHPmyadmin but I want to know is their a better way? .. easier? lol

 

[EvulMastah]

Umm...

DELETE * FROM player_items WHERE item_id = 'itemid'

idk if its item_id

 

[Zinc]

Sounds good. I'll look into it more

Thanks

 

[Zinc]

found one i shoulda looked harder lol

DELETE FROM player_depotitems WHERE itemtype = 2160;
DELETE FROM player_items WHERE itemtype = 2160;
DELETE FROM tile_items WHERE itemtype = 2160;

 

[Wasted]

You all set with this?