Make your server Pre-TBC

[2dgreengiant]

Quite a few people want their server to be pre-Tbc, this should free up your database and the time ascent takes to load etc

Here is a few SQL queries and ways to make it Pre-Tbc

SQL Queries

For Items: (Execute these all separately into your database not in one go)

DELETE FROM items WHERE requiredlevel = 61
DELETE FROM items WHERE requiredlevel = 62
DELETE FROM items WHERE requiredlevel = 63
DELETE FROM items WHERE requiredlevel = 64
DELETE FROM items WHERE requiredlevel = 65
DELETE FROM items WHERE requiredlevel = 66
DELETE FROM items WHERE requiredlevel = 67
DELETE FROM items WHERE requiredlevel = 68
DELETE FROM items WHERE requiredlevel = 69
DELETE FROM items WHERE requiredlevel = 70

For Creatures: (this will only delete the proto of them)

DELETE FROM creature_proto WHERE minlevel = 61
DELETE FROM creature_proto WHERE minlevel = 62
DELETE FROM creature_proto WHERE minlevel = 63
DELETE FROM creature_proto WHERE minlevel = 64
DELETE FROM creature_proto WHERE minlevel = 65
DELETE FROM creature_proto WHERE minlevel = 66
DELETE FROM creature_proto WHERE minlevel = 67
DELETE FROM creature_proto WHERE minlevel = 68
DELETE FROM creature_proto WHERE minlevel = 69
DELETE FROM creature_proto WHERE minlevel = 70

For the accounts to ake them Pre-Tbc:

UPDATE accounts SET flags = 0 WHERE flags = 8

Playercreateinfo:

 DELETE FROM playercreateinfo WHERE race = 10
DELETE FROM playercreateinfo WHERE race = 11
DELETE FROM playercreateinfo_bars WHERE race = 11
DELETE FROM playercreateinfo_bars WHERE race = 10

Quests:

DELETE FROM quests WHERE MinLevel = 61
DELETE FROM quests WHERE MinLevel = 62
DELETE FROM quests WHERE MinLevel = 63
DELETE FROM quests WHERE MinLevel = 64
DELETE FROM quests WHERE MinLevel = 65
DELETE FROM quests WHERE MinLevel = 66
DELETE FROM quests WHERE MinLevel = 67
DELETE FROM quests WHERE MinLevel = 68
DELETE FROM quests WHERE MinLevel = 69
DELETE FROM quests WHERE MinLevel = 70

Overall this should reduce the loading time as a load of creatures etc are missing and it removed the tbc related creatures, quests, create and makes all accounts pre-tbc

Remember execute these separately in Navicat/Sqlyog or else it will error

As usual any problems comment below~2d~

By ultra Spidey:

DELETE FROM items WHERE requiredlevel > 60
DELETE FROM creature_proto WHERE minlevel > 60
DELETE FROM quests WHERE MinLevel > 60
UPDATE accounts SET flags = 0 WHERE flags = 8
DELETE FROM playercreateinfo WHERE race >= 10
DELETE FROM playercreateinfo_bars WHERE race >= 10

[*Alexz*]

nice one +rep alot of people have been asking how to do this
EDIT- STILL need to spread lol

[Succy]

Nice Guide, Even if I think TBC is okay Would give you rep if I could

[2dgreengiant]

i like and prefer tbc myself but there some old school pplz

[TheSpidey]

Nice, can be reduced to these 6 statements:

DELETE FROM items WHERE requiredlevel > 60
DELETE FROM creature_proto WHERE minlevel > 60
DELETE FROM quests WHERE MinLevel > 60
UPDATE accounts SET flags = 0 WHERE flags = 8
DELETE FROM playercreateinfo WHERE race >= 10
DELETE FROM playercreateinfo_bars WHERE race >= 10

[2dgreengiant]

thanks, i cba with the more than and less than sign, ill add it

[~ViVo~]

GG thx. +rep if I can

[Lakelog]

If you run the SQL to delete the creatures above level 60, wouldn't that delete pre-TBC elites that range from level 61-63, aswell as some bosses?

[2dgreengiant]

If you run the SQL to delete the creatures above level 60, wouldn't that delete pre-TBC elites that range from level 61-63, aswell as some bosses?

ill look into this, if your that worried just execute the say 65+ range