Code for phpmyadmin

[Luciano]

I'm on itouch so
I'll write a litle
I need one Thing to I execute that
delet Ids X Y Z A W H r from playersdepotitems, playersitems, and tilesiyems
but delet ALL
thanks
rep+++

 

[xavierek]

hmm whats is xyzawh ?

TRUNCATE `player_depotitems`;

its make empty table player_deotitems

 

[bolero]

Explain more please

 

[Luciano]

like.... delet all items (example) 2300, 2395, 2123, 2355, 6565 from playersdepotitems, playersitems, and tilesitems

 

[Cykotitan]

DELETE FROM player_depotitems WHERE itemtype IN (2300, 2395, 2123, 2355, 6565);
DELETE FROM player_items WHERE itemtype IN (2300, 2395, 2123, 2355, 6565);
DELETE FROM tile_items WHERE itemtype IN (2300, 2395, 2123, 2355, 6565);

 

[Luciano]

Ty love u
;x

 

[xavierek]

i dont understud some ppl in php myadmin all can make you are dont need know mysql language to remove it

 

[Cykotitan]

i dont understud some ppl in php myadmin all can make you are dont need know mysql language to remove it

He wanted only to remove specific ID's, so it's easier with queries.

 

[xavierek]

Yeh or better idea download mysql menager for noob :S or big project and ther is Query generator xD

 

[Luciano]

its a time waste to go in depot items and remove one per one,them go playeritems and one per one, them tile items and one per one.... that isnt bad if is only ONE item, but i need remove like 30 items lol