View Single Post
  #3  
Old 10-20-2008, 02:30 PM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

The rest are going to require a lot of time. A lot. The only easy one out of that above list is to change all mobs to never respawn for indoor dungeon zones. Take the following query and modify the zone name to whichever dungeon you choose:

Code:
UPDATE spawn2 SET respawntime = 31276800 WHERE zone = 'gukbottom';
That would give everything in the zone a respawn time of one year, which might as well be never.

And yes, these are all queries that you can save and source into any fresh database, so long as the column names match. Should be fine between either PEQ or Angelox's database. In fact, I run the query to remove the NO DROP flags every time I do an update to PEQ's latest database.

Hope this helps. Good luck with the rest, too much work for me to do. Or else I'm not thinking of an easier way to do them, which someone else could maybe help with.
Reply With Quote