Warper NPC Edit

[moltn]

Can anybody can make a Warp NPC that has a port to everywhere? IE: Cities, Raids, Instances, etc. And I want a little update with it so people can enter the mall / be ported around the mall, too. Theres three sections in the mall. 1. Mall 2. Vendors 3. Professions

Codes / Configs (Which ever you wanna call it.)

DELETE FROM `creature_names` WHERE `entry` between '200000' and '200002';
DELETE FROM `creature_proto` WHERE `entry` between '200000' and '200002';
DELETE FROM `npc_text` WHERE `entry` between '200000' and '200002';
DELETE FROM `creature_spawns` WHERE `entry` between '200000' and '200002';

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) values('200002','X46: Ackhole Mall Guard','Mall Warper','','0','0','0','3','0','0','2634','2634','0','0','1','1','0','0');
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) values('200001','X45: Lucifer','Mall Warper','','0','0','0','3','0','0','18662','18662','0','0','1','1','0','0');
insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) values('200000','X44: Bungle','Warp Patroller','','0','0','0','3','0','0','18662','18662','0','0','1','1','0','0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('200002','100','100','1741','1000000','1000000','1000000','1','1','1000','0','1000','1000','0','0','0','0','0','0','0','0','0','0','0','0','0','1','5','5','5','5','5','5','5','1','1','','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('200001','100','100','1741','1000000','1000000','1000000','1','1','1000','0','1000','1000','0','0','0','0','0','0','0','0','0','0','0','0','0','1','5','5','5','5','5','5','5','1','1','','0','0','0','0','2.5','8','14','0');
insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `mountdisplayid`, `equipmodel1`, `equipinfo1`, `equipslot1`, `equipmodel2`, `equipinfo2`, `equipslot2`, `equipmodel3`, `equipinfo3`, `equipslot3`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`) values('200000','100','100','1741','1000000','1000000','1000000','1','1','1000','0','1000','1000','0','0','0','0','0','0','0','0','0','0','0','0','0','1','5','5','5','5','5','5','5','1','1','0','0','0','0','0','2.5','8','14','0');


INSERT INTO `npc_text` 
(`entry`, `prob0`, `text0_0`, `text0_1`, `lang0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `prob1`, 
`text1_0`, `text1_1`, `lang1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `prob2`, `text2_0`, `text2_1`, 
`lang2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `prob3`, `text3_0`, `text3_1`, `lang3`, `em3_0`, 
`em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `prob4`, `text4_0`, `text4_1`, `lang4`, `em4_0`, `em4_1`, `em4_2`, 
`em4_3`, `em4_4`, `em4_5`, `prob5`, `text5_0`, `text5_1`, `lang5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, 
`em5_5`, `prob6`, `text6_0`, `text6_1`, `lang6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `prob7`, 
`text7_0`, `text7_1`, `lang7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`)
VALUES
(200000, 1, 'Welcome to the X44 warp patroller system.','The warp system is still very experimental thus the X44 cannot be held responsible for any loss of limbs','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0'),
(200001, 1, 'Welcome to the X45 Mall Warper system.','The warp system is still very experimental thus the X45 cannot be held responsible for any loss of limbs','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0'),
(200002, 1, 'Welcome to the X46 Ackhole Guard system.','The Guard system is still very experimental thus the X46 cannot be held responsible for any loss of limbs','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0','0','','','0','0','0','0','0','0','0');


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`, `standstate`) values('200000','169','-4346.91','-572.798','127.719','5.69492','0','18662','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200000','169','-4346.87','-627.64','123.129','0.3652','0','18662','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200001','169','-4178.14','-616.796','128.208','2.46772','0','18662','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200001','169','-4273.27','-628.137','119.816','2.32084','0','18662','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200001','169','-4153.03','-740.208','125.914','4.6959','0','18662','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4310.57','-592.492','122.698','4.73437','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4270.95','-582.916','119.431','3.13373','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4277.54','-627.608','120.167','2.83135','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4218.16','-619.784','124.178','4.77914','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4185.17','-580.574','123.768','2.93425','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4145.55','-581.673','118.09','3.04734','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4116.95','-602.671','119.183','1.46948','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4114.53','-649.52','120.647','1.61242','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4174.84','-651.339','124.06','0.0117776','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4218.02','-652.217','120.872','0.0102072','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4147.16','-818.51','118.732','0.154337','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4148.78','-815.133','118.19','0.772829','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4120.43','-776.332','122.903','4.61343','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4181.36','-764.671','119.8','4.6582','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4119.78','-713.06','121.568','3.16987','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4181.31','-712.511','119.317','4.75166','0','2634','35','0','0','0','0','0','0','0','0','0');
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`, `standstate`) values('200002','169','-4120.83','-775.571','122.853','1.46398','0','2634','35','0','0','0','0','0','0','0','0','0');



UPDATE creature_names set info_str="";

+Rep (maybe 2 or 4 times) if somebody can do this for me, thanks. =)

[Supah]

Don't you need to compile for this to work ?

If so did you compile ?

[Cursed]

This is just the SQL... Where is the .cpp?

[volitle]

you need to do it yourself because you have to compile it with you core, wouldnt work if we did it then handed it to you and for the WarpNPC just use Gastrics bound to be around here somewhere

[moltn]

I don't know anything about compiling Warp NPCs. =( You can actually tell because I posted something about it. My server is up and everything but the warp NPC doesn't work. It only came with a config. D:

[volitle]

lol just make a few portals then and learn to compile in the mean time il go get you a guide

[moltn]

Thanks very much, Volitle. +Rep for trying to help me. :P

[volitle]

here is one on how to compile the warpNPC/GlobalNPC
http://www.mmowned.com/forums/emulat...dll-video.html

and this is how to compile
http://www.mmowned.com/forums/emulat...le-ascent.html

this is for portals if you need it
http://www.mmowned.com/forums/ascent...-winckler.html

and thanks

[moltn]

..omg - Sigh, Idk if my little brain and can take it. XD (MSN: [email protected] if anybody wants to help me from computer to computer. Not force asking / begging - just saying. Haha) and you are welcome, Volitle.



Edit: Lol - this is for portals if you need it
http://www.mmowned.com/forums/ascent...-winckler.html (How To Make A Custom Portal easy Newb Friendy Tutorial pWd By Winckler) (Seems too easy. I just might make portals. <.< Hehe. :B)