EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)
-   -   A fast way to populate a zone (https://www.eqemulator.org/forums/showthread.php?t=5026)

mudman 02-03-2003 02:59 PM

A fast way to populate a zone
 
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


All times are GMT -4. The time now is 11:28 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.