An usefull query needed . +Repx2 if i get it : )

[Arugos]

Hello ,i am creating a Pre TBC repack, but i wanna make it 100% Pre TBC , nothing wich require level 61-70. So here i am asking someone who have time to do it , could someone create a Query wich look for items,spells(trained by trainers),skills (trained too),creatures proto and names with a lvl ranging 61-70 and delete everything found

Any + would be very gratefull too , like something to remove TBC quests and everything wich is include in TBC.

Thanks in advance ,i am pretty sure i wont be the only one using this query.

I will give x2Rep for it

[kreegoth]

Why not just disable TBC accounts? and set max level to lvl 60? they wont have access to the TBC Content and wont be able to level higher than 60 anyways..

Im almost positive you arent going to be able to do this with a single SQL.. Many sqls designed specifically using a Select * from `tablename` where `Leveltypeusedintable` =<60

But youd have to Change where it says Leveltypeusedintable to be IE requiredlevel for Items table ya know?

[Arugos]

I know they wont have access , but i prefer removing everything , it will make my server database smaller and most likely will increase perfomance

[kreegoth]

Backup database first ofc..

Try running these one by one ... if you get the results you want .. Change the SELECT at the front to DELETE.. and you should have what you wanted,


Select * FROM `creature_proto` WHERE `minlevel`=>61;
Select * FROM `creature_proto` WHERE `maxlevel`=>61;
Select * FROM `Trainer_spells` WHERE `reqlevel`=>61;
Select * FROM `Quests` WHERE `MinLevel`=>61;

Then
DELETE FROM `creature_names` WHERE `entry` not in (SELECT `entry` from `creature_proto`);

[Arugos]

Thanks you +Repx2

Must spread first ; (

[Performer]

Oooh ill use that query to Thanks Kreegoth +Rep

[TheSpidey]

You can remove all items which require level 61 and up from the DB;
But there are many items (3993 according to wowhead) that have been added in TBC which have their max level set up to 60, so combine it with the following method:

Assemble wowhead lists of items which have been added in TBC and have their max level as up-to-60, and rip the entries from the pages you get.
Remember that wowhead only shows the first 200 items, so you'll have to categorize them. Instead of having this and missing 42 weapons, divide them, say, by qualities: One list for poor and common and another for everything else. Then just feed it to a ripper and assemble each list into a DELETE statement.

[Sounddead]

Do you know where I could find a ripper Spidey? Or is it kind of a go make it yourself answer.

[TheSpidey]

Either script it yourself or wait till I release mine :P