This is not meant to inspire anyone to build spawn tables for the current versions, but instead to give those anxious admins out there something to do with their time while we find us some data. Say you want to spawn ol Naggy in Antonica, and keep him there even after you shut down and restart your world. As I posted elsewhere, the spawn routines are in place and working (respawns, maybe not, since you can't kill anything yet).
Here's how you set up an NPC (generic)... Note all these values are arbitrary, and not accurate at all. This is just a sample
npcs:
First, let's make an NPC, in this case, my buddy Lord Nagafen...
Code: Select all
INSERT INTO `npcs` (`id`, `name`, `min_level`, `max_level`, `enc_level`, `race`, `race_type`, `class_`, `gender`, `min_group_size`, `max_group_size`, `show_name`, `attackable`, `show_level`, `targetable`, `show_command_icon`, `display_hand_icon`, `command_list_type`, `command_list_subtype`, `faction_id`, `hair_type_id`, `facial_hair_type_id`, `wing_type_id`, `chest_type_id`, `legs_type_id`, `soga_hair_type_id`, `soga_facial_hair_type_id`) VALUES (1000, 'Lord Nagafen ', 1, 50, 0, 275, 275, 33, 1, 0, 0, 1, 1, 1, 1, 1, 0, 'NPC', '', 0, 0, 0, 0, 0, 0, 0, 0);Creating the spawn point --
spawngroup:
In the DB, find the table: `spawngroup` and enter a new spawngroup for your mob:
Code: Select all
INSERT INTO `spawngroup` (`id`, `name`) VALUES (1, 'Lord_Nagafen');spawnentry:
Open the table: `spawnentry`. and enter new spawnentry details:
Code: Select all
INSERT INTO `spawnentry` (`id`, `npcid`, `objectid`, `spawngroupid`, `spawnpercentage`) VALUES (1, 196, 0, 1, 100);npcid = npcs table `id` value (1000 in this case)
spawngroupid = spawngroup table `id` value (1 in this case)
spawnpercentage = 100%, without the '%' sign
spawns:
Open the table: `spawns`. and enter new spawn 'point' for your npc (you can get the x,y,z by typing /loc in game where you want your guy to pop) --
Code: Select all
INSERT INTO `spawns` (`id`, `zone_id`, `spawngroup_id`, `x`, `y`, `z`, `x_offset`, `y_offset`, `z_offset`, `heading`, `respawn`, `location_id`) VALUES (1, 12, 1, -100, -15, 0, 0, 0, 0, 270, 3600, 0);zone_id = from table: `zones` where you want the mob to spawn (12 = Antonica)
spawngroup_id = again, the `id` value from spawngroup table
x, y, z, heading = your /loc from in game
respawn = prolly does nothing yet
location_id = leave ZERO, since it seems to crash my client if > 0.
Restart your world, log in, and if you used my coords above, you should have a retarded red dragon standing in a corn field, amazed at the puffs of smoke coming from his own nostrils.
Everyone, please add, change, debunk, or flame away. I know this is not important information, but for those interested in persisting spawns until the team gets the DB rolling, have fun.
Oh, and export/backup your work often, since I am not sure if feeds from the world startup will nuke your tables
