Ok im pretty bored so i decided to make a guide on how to do some changes to the database without looking everything up, this can really spare u some time.
Lets say u want to remove something then it would be
DELETE from <tablename> where <collum> = <ID of what u want removed>; <-- the ";" simple just stops the query allowing u to upload more queries at the time
Example:
DELETE from items where entry = 31332;
the query above would complety remove Blinkstrike from the game
Lets take another example:
DELETE from vendors where item = 31332;
the query above would complety remove Blinkstrike from all vendors, but it would still be able to get by drops.
Ok now a how to add queries to the database
INSERT into <Tablename> ('<first collum>, '<second cullom>') values (<what u want in the first cullom>, <..in the secound cullom>,);
Example:
insert into `spell_disable` (`spellid`, `replacement_spellid`) values (5, 0);
You can also do it the abit "faster" way but that wouldnt match all revs
Insert into spell_disable VALUES (5, 0);
the query above inserts a spell into the spell_disable table which would be disabled and unable to be used
----
Now how to update rows
UPDATE items set sellprice = 10000 where entry = 31332;
the query above would set the sellprice for blinkstrike to 10000copper
Now if u want to set the sellprice to 10000copper for every single item
UPDATE items set sellprice = 10000 where entry between 1 and 9999999999;
You can also use the query above to remove the cost from all spells and skills (nice for funservers)
I guess thats all you need to know feel free to ask questions
Written by R0flz0r and only R0flz0r | Credits to R0flz0r and only R0flz0r