| blackdragonsdg |
08-17-2011 04:32 PM |
A little visual aid might help or confuse you even more.
/* Server_Greeter */
Code:
delete from npc_types where id = 700886;
delete from spawn2 where id = 700886;
delete from spawnentry where npcID = 700886;
delete from spawngroup where id = 700886;
INSERT INTO `spawnentry` (`spawngroupID`, `npcID`, `chance`) VALUES (700886, 700886, 100);
INSERT INTO `spawngroup` (`id`, `name`, `spawn_limit`, `dist`, `max_x`, `min_x`, `max_y`, `min_y`, `delay`) VALUES (700886, '700886', 0, 0, 0, 0, 0, 0, 0);
INSERT INTO `spawn2` (`id`, `spawngroupID`, `zone`, `version`, `x`, `y`, `z`, `heading`, `respawntime`, `variance`, `pathgrid`, `_condition`, `cond_value`) VALUES (700886, 700886, 'poknowledge', 0, 491.5, 403.5, -123.9, 125.9, 0, 0, 0, 0, 1);
INSERT INTO `npc_types` (`id`, `name`, `lastname`, `level`, `race`, `class`, `bodytype`, `hp`, `gender`, `texture`, `helmtexture`, `size`, `hp_regen_rate`, `mana_regen_rate`, `loottable_id`, `merchant_id`, `npc_spells_id`, `npc_faction_id`, `adventure_template_id`, `trap_template`, `mindmg`, `maxdmg`, `npcspecialattks`, `aggroradius`, `face`, `luclin_hairstyle`, `luclin_haircolor`, `luclin_eyecolor`, `luclin_eyecolor2`, `luclin_beardcolor`, `luclin_beard`, `drakkin_heritage`, `drakkin_tattoo`, `drakkin_details`, `armortint_id`, `armortint_red`, `armortint_green`, `armortint_blue`, `d_meele_texture1`, `d_meele_texture2`, `runspeed`, MR, CR, DR, FR, PR, `see_invis`, `see_invis_undead`, `qglobal`, AC, `npc_aggro`, `spawn_limit`, `attack_speed`, `findable`, STR, STA, DEX, AGI, _INT, WIS, CHA, `see_hide`, `see_improved_hide`, `trackable`, `isbot`, `exclude`, ATK, `Accuracy`, `slow_mitigation`, `version`) VALUES (700886, 'Server_Greeter', '', 85, 456, 1, 1, 1200000, 2, 8, 0, 15, 500, 0, 0, 0, 0, 0, 0, 0, 15000, 20000, 'UMCNIDABWO', 70, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3.25, 49, 49, 49, 49, 49, 0, 1, 0, 1714, 0, 1, -19, 1, 300, 300, 300, 300, 300, 300, 300, 0, 0, 1, 0, 1, 0, 0, 0, 0);
That will spawn an npc named Server Greeter in PoKnowledge beside main bank. It should appear as a large red sporali or as a human depending on your client.
The delete statements are optional it just helps clear out anything currently using those id values. |