warp npc spawns

[rampage]

I created this table to help with spawning WarpNpcs and Teleporters
It places your warper at the location you recall to.


I took the locations from the recall table and modified to suit.
Ive also used the teleporter from moon++ for my creature as a test.
You can use whatever entry id you want just modify as you like.(even change the creature id)

(change the highligted ids to your own) (Red - creatureID Green - Display ID)

insert into creature_names values ( 55555,'Teleporter NPC','Moon Plus Plus',0,0,0,0,3,0,NULL,0,20748,0,0,1,1,0,NULL);
insert into creature_proto values (55555,70,70,35,100000,100000,100,1.5,1,1500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,36000,0,0 ,0,0,0,0,0,1,0,0,0,0,0,0,2.5,8,14,0);


backup your recall table as a SQL File.
Open in wordpad

Change This Line from your recall table

inser into recall values ('754', 'Garden', '0', '-8616', '-498.258', '149.601');
Delete Location Name.

Add your creature id (Replace ( with (55555, or whatever your id is)
Add Remaing details (Replace ); with ,0,0,18495,1741,0,0,0,0,0,0,0,0,0);

(Creature ID,169,-4227.23,-660.221,121.248,0,0,18495,1741,0,0,0,0,0,0,0,0,0);

Change it to this.
insert into `creature_spawns (`entry`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`movetype`,` displayid`,`faction`,`flags`,`bytes`,`bytes2`,`emote_state`,`npc_respawn_link`,` channel_spell`,`channel_target_sqlid`,`channel_target_sqlid_creature`,`standstat e`) values (55555,0,-8616,-498.258,149.601,0,0,18495,1741,0,0,0,0,0,0,0,0,0)



Hope you find this useful