Thread: Database Schema
View Single Post
  #11  
Old 06-18-2003, 06:49 AM
Jrodo
Fire Beetle
 
Join Date: Jun 2003
Posts: 4
Default

Your database schema looks great !... don't happen to have a relationship chart by chance? ( many to one , one to many type chart? etc) It might help me with a problem I am having...

PROBLEM 1 :I make new spawns with the #NPCtypespawn command then use the #npcspawn add command to put in database. NP so far, now I add a custom mob like Drovlog Captian, so I have to use the "#NPCSpawn Drovlog_Captian ...etc... x x x x x " command to create the mob then use "#NPCSpawn add" command to put in database. Everything looks good, database has the new mobs in sp2, spawnentry and spawngroup tables. BUT when I restart my server only the NPCtype spawns show up the custom mobs are gone....They are still in the database though. I must be missing a link or something somewhere. Can anyone help me?

PROBLEM 2:Also, was gonna populate spiders and dogs in Velks but can find them anywhere in the database table NPC_types. I thought all the mobs were in there?

Doing great gang... Keep up the good work!

Specific command example I used..
#npctypespawn 3084 spawns a Kobald.
#npcspawn add adds targeted mob to database

and then custom mob:
#spawn Giant_rat 36 1 0 16 2 1 0 0 0 spawns custom rat
#npcspawn add adds targeted mob to database

Then reload server.. only the NPCtypespawns show up the custom one are gone!
Reply With Quote