Need some MySQL queries!

[zieworski denero]

Hello!

I need some MySql queries:

1.

How do I remove a certain item from everyone's houses, all tiles, from dp and from bps etc..

2.

How do I remove all player's skulls and frag time?

Thanks!

 

[Strasxni]

This remove skulls and frags

  UPDATE `players` SET `redskulltime`=0;

 

[zieworski denero]

UP, ty but actually the second point is:

UPDATE `players` SET `skulltime`=0;
UPDATE `players` SET `skull`=0;

still need help with the first one though..

 

[Strasxni]

UP, ty but actually the first point is:

UPDATE `players` SET `skulltime`=0;
UPDATE `players` SET `skull`=0;

still need help with the second one though..

ah, yes mine one remove just red skull...

 

[Cykotitan]

ah, yes mine one remove just red skull...

no, yours would only work on TFS 0.3.4 or older.

 

[Strasxni]

To remove items from houses, i think you need to remove all items from title_items...
You can try this

TRUNCATE TABLE `tile_items`

no, yours would only work on TFS 0.3.4 or older.

Didn't know that. Thanks for the tip.

 

[Cykotitan]

DELETE FROM player_depotitems, player_items, tile_items WHERE itemtype = XXXX;

 

[zieworski denero]

Maybe But I need to remove it... basically from the WHOLE server.

EDIT:

Thanks cyko

 

[zieworski denero]

oh, this error comes up when i execute the script:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE itemtype = 2159' at line 1

 

[Strasxni]

oh, this error comes up when i execute the script:

Try this way

DELETE FROM  `player_depotitems` WHERE `itemtype` = '2195';
DELETE FROM  `player_items` WHERE `itemtype` = '2195';
DELETE FROM  `tile_items` WHERE `itemtype` = '2195';

 

[zieworski denero]

worked thanks guys