SQL Quries in need.

[Sir Shutter]

Hello otland, I need some SQL queries if I can get them

I need sql queries which does :-

1. delete player name like DELETE FROM PLAYERS NAME = blabla - blabla - blabla so i write names and they delete instantly instead of searching then delete searchin then delete..

2. sql querie that deletes a special item from houses like an item with id 9029 (example) to delete it if it exists in house

3. sql querie that delete a special item from depots

4. sql querie that delete a special item from players

5. sql querie that delete a special item from monsters if possible

I'll rep++ you ofcorse! ^_^

 

[Fragdonut]

I'll rep also, It's cool to have :]
5. Is not possible tho.

 

[Fare]

1. delete player name like DELETE FROM PLAYERS NAME = blabla - blabla - blabla so i write names and they delete instantly instead of searching then delete searchin then delete..

DELETE FROM `players` WHERE `name` == 'Write_Here_Player_Name';

2. sql querie that deletes a special item from houses like an item with id 9029 (example) to delete it if it exists in house

DELETE FROM `tile_items` WHERE `itemtype` = 9029;

3. sql querie that delete a special item from depots

DELETE FROM `player_depotitems` WHERE `itemtype` = 9029;

4. sql querie that delete a special item from players

DELETE FROM `player_items` WHERE `itemtype` = 9029;

5. sql querie that delete a special item from monsters if possible

Ctrl+F, in monsters forder, and search for files contains id of item, and then delete it manually

 

[Chris]

Fare, you should stick with ` when it comes to fields and tables. The straight apostrophes are meant for values.

 

[Sir Shutter]

Thank you fare rep++

edit : must spread before give u again xD

 

[freak15]

Thankz Fare! very helpfull!

 

[Fare]

Fare, you should stick with ` when it comes to fields and tables. The straight apostrophes are meant for values.

So ` for fields and tables, and ' for values? right?

Thanks