A fast way to populate a zone

[mudman]

I am using excel to make a long list of spawns,

by copy and pasting a tons of rows of similar spawns, and just changing the main numbers


then after i use http://ems-hitech.com/mysqlutils/ to convert the tables live to mysql

Since each table has nearly the same main numbers its just a question of copy and past.

TO:
spawn2
npc_types
spawngroups
npcfaction
spawnentry

after that each table gets imported back into mysql, boom add a couple hundred spawns in an hour.

Mudman
Defender