View Single Post
  #1  
Old 02-01-2004, 06:38 AM
Monrezz's Avatar
Monrezz
Dragon
 
Join Date: Mar 2003
Location: #loc
Posts: 745
Default SQL Statements for DB Fixes

Compiled a little SQL together containing a few useful SQL Statements people have come up with. Simply source this into your database and it will:

Give all mobs with instant respawn a respawn time of 1000;
Give most newbie mobs loot appropriate to their race (rats drop rat items, skeletons drop bone chips etc);
Fix the damage for all mobs (no more level 1 mobs hitting for 400 etc);
Fix the HP for all mobs (no more level 24 mobs with 2k HP etc);
Fix the aggro radius so lower levels have smaller radius;
Fix most classes (no more merchants where there should be a GM);
Fix all starting items;
Fix all zone points;

Note - Most queries will only affect mobs with either "a_" or "an_" in their name to prevent customs and boss mobs from being affected, however some custom data might still be changed. Better to create a backup so if this does mess things up you can restore.

You can download the file from:
www.arnold11.karoo.net/Fixes.zip
(Any future updates will be announced here but keep same URL)

If it messes everything up, don't blame me. Just trying to help.

Good luck, Monrezz.
__________________

kRPG Profile
Reply With Quote