View Single Post
  #10  
Old 12-24-2003, 08:26 AM
Lurker_005
Demi-God
 
Join Date: Jan 2002
Location: Tourist town USA
Posts: 1,671
Default

I highly recomend finding formulas like these to globably set a lot of the default values. Then also making another sql script that goes back and sets things like named spawns or other exceptions to the rules.

Something similar to
Code:
UPDATE npc_types SET maxdmg = 500 where (name like '%sleeper%' and zone like 'sleepers');
That way you can always reapply your hand tweeks to... well any DB actually. And don't feel limited to doing so aginst single spawns with fixed vaues.
Code:
UPDATE npc_types SET loottable_id = 30 where (name like '%skeleton%' and level < 20);
set loot to bone chips ect...

It will add a tremendous consistancy to the DB, and still keep the customized stuff.
__________________
Please read the forum rules and look at reacent messages before posting.
Reply With Quote