[Tutorial] Making all skills and lvls required 0

[Jackbhoy]

Ok, i'm doing this tutorial using HeidiSQL as i belive it's the most commonly used, and easiest :P

Part Oneoh wait...there is only one part! :)
Firstly you want to start MySQL, then connect to you server with HeidiSQL.

After you've done that, open up the 'Ascent' Database and then open the items table.
http://www.imagehosting.com/out.php/t1186405_Tutorial1.JPG (http://www.imagehosting.com/out.php/i1186405_Tutorial1.JPG)

Next, we type into the 'Query' Part
UPDATE `items` SET `RequiredSkill`=0
http://www.imagehosting.com/out.php/t1186421_Tutorial2.JPG (http://www.imagehosting.com/out.php/i1186421_Tutorial2.JPG)
And click 'Execute SQL' (F9 is default shortcut)

Ok, simple, and to make Required Level 0, all we do is type in
UPDATE `items` SET `requiredlevel`=0
into our 'Query' and again, click on Execute SQL or press F9

(Please remember to delete your Cache or you wont see any of thse changes! :) )

And thats it, now all your items dont need a required level or a required skill lvl

Happy WoW'ing!

From Jackbhoy

[bladeknight]

sweet thanks.

[desertsoulz]

Thanks this helped

save alot of time

[Bastar]

should require a ";" at query end in order to work.