This will make the respawn rates 0 for all the mobs inside of the following pre-bc instances - ZG/AQ/NAXX/ONY/MC/BWL
NCDB has their respawns set to a really fast rate so this really helps pre-bc servers out.
Me and Metalfreak a gm from my server put this together.
The query line was thanks to The Betrayer
http://pastebin.com/f209d688e
Just execute the .sql file to your world database.
OR
copy and paste if you want. (below)
Code:
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11673 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11671 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11668 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12099 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11666 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11669 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11667 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11661 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11664 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11663 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11662 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12119 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11665 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12076 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12100 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12101 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11659 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11658 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16018 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16142 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16167 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15975 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16698 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16573 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15978 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16156 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16861 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16158 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16390 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16146 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16145 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16163 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16803 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16451 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16056 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16157 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15974 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16024 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16236 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16290 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15930 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16036 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16441 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16244 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15977 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16021 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16020 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 17055 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16365 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16297 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15981 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15980 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16505 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16506 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16165 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16452 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16453 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16368 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16017 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16034 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16983 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16982 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16448 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16446 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16447 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16981 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16984 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16154 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16057 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16375 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16164 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16193 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16067 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16029 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16429 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16148 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16149 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16150 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16127 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16449 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15929 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16025 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16168 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16022 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15979 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16194 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16215 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16216 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16125 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16126 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16124 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 16428 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15976 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12129 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 14265 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 14456 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12416 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12420 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12458 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 13996 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12459 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 14261 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 14605 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12467 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12422 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12463 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 14263 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12468 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12461 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12464 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12460 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 12465 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 14262 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 14264 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 14882 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11368 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 14965 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11350 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 14750 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11352 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11353 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11356 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11351 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11340 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11830 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11339 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11831 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15111 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15146 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11372 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11373 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 14821 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11357 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11359 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 14883 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 14825 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11347 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11348 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15043 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11360 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15068 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11365 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15101 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15067 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 11361 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15355 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15538 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15537 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15505 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15389 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15391 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15392 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15390 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15385 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15335 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15319 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15318 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15521 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15934 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15555 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15323 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15320 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15327 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15546 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15336 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15325 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15473 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15471 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15388 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15386 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15527 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15338 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15324 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15343 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15387 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15461 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15462 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15344 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15277 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15264 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15538 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15311 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15537 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15262 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15312 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15718 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15247 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15252 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15249 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15246 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15250 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15622 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15300 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15962 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15240 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15229 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15235 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15230 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15236 LIMIT 1;
UPDATE `creature_proto` SET `respawntime` = '0' WHERE `entry` = 15504 LIMIT 1;