[Release] Usefull Database Queries [Part 2]

[latruwski]

Well if you want everything on your server free, then do this:

UPDATE `items` SET buyprice = 0 WHERE `entry` BETWEEN '1' and '99999999';

UPDATE `items` SET buyprice = 0;

looks better and works also :P

[Lich King]

Latruwski, could you make one that deletes from creature_spawns, lowest id is 226410 and highest id is 226501

[waymirec]

DELETE FROM `creature_spawns` WHERE `id` BETWEEN 226410 and 226501

[Lich King]

I tried that, it didn't work

[latruwski]

I tried that, it didn't work

delete from creature_spawns where id between 226410 and 226501;

should work perfectly....

if not try this:

delete from creature_spawns where id in(226410,226411,226412,226413);

replace the numbers colored with the numbers from 226410 to 226501 (yes lot of work but it should work...) seperate all numbers with a cumma... like in the example...

grtz

[Lich King]

Nvm, I got it to work

[Power of Illuminati]

First of, +Rep, this has been very very useful for me. And learning too.

Second of all. I'm trying to make a query that change the buyprice from every entry in the item_extendedcost. And I got till this, but it just conitnue to change on all items for me.

UPDATE items SET buyprice = '15' WHERE entry IN (SELECT entry FROM items_extendedcost);

[Ballwinkle]

was looking for theese....thanx for reposting this :O +Rep

[latruwski]

was looking for theese....thanx for reposting this :O +Rep

np, i am glad people still use this