[NEED HELP]Mangos server!

[gory]

I am using Reaper Mangos 4703 SD2 156 UDB FULL and i wanna know how can i create custom NPC's for the GMisland, and custom portals, that work for all races, to the main citys.

If somebody knows please tell me how, i really wanna know!

[MentaL]

[Rowb]

I am using Reaper Mangos 4703 SD2 156 UDB FULL and i wanna know how can i create custom NPC's for the GMisland, and custom portals, that work for all races, to the main citys.

If somebody knows please tell me how, i really wanna know!

mmmm not is solo from Ascent???

[Paco44]

Just use Ascent.

[tr4shm4n]

Yes it can be done . Im out oof mangos for an while so i dunno how exactly to do it but it can be done thats for shure

Why people always reply with use ascent if an topic is for mangos . Dont reply if you cant help out with the topic .

[Paco44]

Mangos is so useless now that Ascent is constantly being updated. It's shoving mangos out the window of a 55 story building.

[tr4shm4n]

Both have there ups and downs ofiacly mangos can go beyond level 70 if you make the lvl tables where ascent have hard coded lvl70 cap . Besides that both are good to work with and it is what people prefer for themselof not what others prefer . If i had an mutch bether server system than i have now i would use mangos simply becose the db is bether . But thats not what he asked he asked if you can make custom portals in mangos and yes you can .

Here you go an example thnx to gray on silvermoon forums :

This is an example for the Gurubashi Arena, I have used type: 22 spellcaster and at sound0 i put an unused spell 4801 Teleport - Spells - World of Warcraft (make sure this number is not taken already and must be an UNUSED SPELLID)
after addgo dont forget to restart server or the object will not show after awhile.

CODE

INSERT INTO gameobject_template
(entry, type, displayId, name, faction, flags, size, sound0, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, sound10, sound11, sound12, sound13, sound14, sound15, sound16, sound17, sound18, sound19, sound20, sound21, sound22, sound23, ScriptName)
VALUES
(999000, 22, 4396, "PVP ARENA", 0, 0, 1, 4801, 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 areatrigger_template
(id, name, required_level, trigger_map, trigger_position_x, trigger_position_y, trigger_position_z, target_map, target_position_x, target_position_y, target_position_z, target_orientation)
VALUES
(4801, "PVP ARENA", 0, 0, "-13152,9", "342,729", "52,1328", 0, "-13152,9", "342,729", "52,1328", 0);

[tr4shm4n]

Here is an other one by dutchman also on silvermoon forums :

This is a small Tutorial of how to make custom portals. Yes it's posible without modifying any DBC file !
You just need a little knowledge and have to read carefully

What Tables do we need to modify ?
spell_teleport
gameobject

I will try to explain it with an Example

I needed portals for not working ship routes, so here is an Example for a portal to Ratchet.

1st We need an unused Spell ID.
This is the most important part ! Go to a website like Wowhead: It's all about elegance.. Find an unused spell, Be carefull ! Some uncatigorized spells are used by scriptdev,
Search carefull so you don't mess up anything !
I will use an exsisting teleport spell ID how not used by any other source. It's called [PH] Teleport to Undercity
[PH] Teleport to Undercity - Spells - World of Warcraft

2nd Modfiy the Database entry to the right postion the spell should teleport you
`id` = Spell ID <<< This must be an unused Excisting spell ID !
`target_map` = Map Id where you have to be teleporte to
``target_position_x`,`target_position_y`,`target_position_z` = x,y,z, position of the Teleport
`target_orientation` = orientation of view after teleport

To get the current position of you char press .gps. Below values are from Undercity.


SQL
Delete from `spell_teleport` where=5000;
INSERT INTO `spell_teleport` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
(5000, 0, 2063.6, 272.2, 94.1, 4.4);


Ok the spell is ready, if you would use this one ingame now u will be teleportet to the suggested position.

3rd Create an gameobject to use for the Teleport.
I will only give a small information about the used values, because you have to find out by yourself what the other entrys do
The Most important entry are:
`entry` = Guid value of the object in your gameobject_template
`type` = The type of Gameobject, in this case ''SPELLCASTER" so the value must be 22 !
`displayId` = The display id you want the object to look like, i use an portal so value will be 1327
`name` = The name of the Gameobject
`faction` = This value Must be 115, mostly other will not work.
`flags` = Must be 0, other will not work
`sound0` = This is the spell ID you just filled in into `spell_teleport`, in my example its 5000

So you will now get the Gameobject insert query:

SQL
delete from `gameobject_template` where `entry`=666501;
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `faction`, `flags`, `size`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `sound10`, `sound11`, `sound12`, `sound13`, `sound14`, `sound15`, `sound16`, `sound17`, `sound18`, `sound19`, `sound20`, `sound21`, `sound22`, `sound23`, `ScriptName`) Values
(666501, 22, 1327, 'Portal to Undercity', 115, 0, 1, 5000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');


So the spell and the object are done
The only thing you have to do is to spawn the object in the world. If you interact with the gameobject, you will be teleportet to Undercity

Have Fun !

If something of the Tutorial is not clear, please post suggestions so i can update this post.

For the leasy people out there , here you have all needed Gameobjects + Spell entry + Spawn of the portals to use insted of the ships/zepelins

These are all needed spell entrys:

SQL
Delete from `spell_teleport` where `id` in (4996, 5000, 4998, 4997, 4999, 6348, 42527, 6719, 6483, 6484, 16787);
INSERT INTO `spell_teleport` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES
(4996, 1, 1331.9, -4650.3, 53.5, 0.8),
(5000, 0, 2063.6, 272.2, 94.1, 4.4),
(4998, 0, -12424.3, 208.4, 31.3, 4.6),
(4997, 0, -14289.9, 542.7, 8.8, 3.9),
(4999, 1, -978.8, -3790.4, 5.3, 1.0),
(6348, 0, -3747.1, -621.8, 7.7, 0.7),
(42527, 1, 6497.9, 788.2, 8.2, 1.3),
(6719, 1, -3852.5, -4613.4, 9.2, 5.1),
(6483, 1, -4271.4, 3287.2, 11.0, 3.1),
(6484, 1, -4346.1, 2375.5, 8.5, 4.6),
(16787, 530, -4255.6, -11433.9, 9, 1.6);


This ones are the portal (objects)

SQL
delete from `gameobject_template` where `entry` in (666500,666501,666502,666503,666504,666505,666506,666507,666509,666510,666511);
INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `faction`, `flags`, `size`, `sound0`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `sound10`, `sound11`, `sound12`, `sound13`, `sound14`, `sound15`, `sound16`, `sound17`, `sound18`, `sound19`, `sound20`, `sound21`, `sound22`, `sound23`, `ScriptName`) Values
(666500, 22, 1327, 'Portal to Orgrimmar', 115, 0, 1, 4996, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666501, 22, 1327, 'Portal to Undercity', 115, 0, 1, 5000, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666502, 22, 1327, 'Portal to Grom Gol Base Camp', 115, 0, 1, 4998, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666503, 22, 1327, 'Portal to Booty Bay', 115, 0, 1, 4997, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666504, 22, 1327, 'Portal to Ratchet', 115, 0, 1, 4999, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666505, 22, 1327, 'Portal to Minithel Habour', 115, 0, 1, 6348, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666506, 22, 1327, 'Portal to Darkshore', 115, 0, 3, 42527, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666507, 22, 1327, 'Portal to Theramore Island', 115, 0, 1, 6719, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666509, 22, 1327, 'Portal to Feathermoon', 115, 0, 1, 6483, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666510, 22, 1327, 'Portal to Feralas', 115, 0, 1, 6484, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, ''),
(666511, 22, 1327, 'Portal to Exodar Habour', 115, 0, 1, 16787, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '');


And here are the spawn locations

SQL
delete from `gameobject` where `id` in (666500,666501,666502,666503,666504,666505,666506,666507,666509,666510,666511);
INSERT INTO `gameobject` (`id`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `loot`, `spawntimesecs`, `animprogress`, `dynflags`) VALUES
(666502, 1, 1355.6, -4635.4, 53.6, 1.4, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- org to grom
(666500, 0, -12449.7, 214.1, 31.3, 3.1, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- grom to org
(666504, 0, -14280.3, 552.6, 8.9, 0.9, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- Booty Bay To Ratchet
(666503, 1, -988.6, -3824.5, 5.7, 6.2, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- Ratchet To Booty Bay
(666506, 0, -3732.3, -579.6, 6.1, 4.9, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- Menethil Habor To Darkshore
(666507, 0, -3882.2, -598.0, 5.8, 1.2, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- Menethil Habor To Theramore
(666505, 1, -4002.1, -4728.1, 5.0, 1.3, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- Theramore To Menethil
(666505, 1, 6425.3, 815.8, 5.5, 4.0, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- Darkshore To Menethil
(666511, 1, 6536.5, 924.9, 5.9, 4.7, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- Darkshore To Exodar
(666506, 530, -4260.5, -11331.2, 5.5, 1.0, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- Exodar To Darkshore
(666510, 1, -4220.0, 3288.8, 7.4, 3.2, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- feathermoon to feralas (666509, 1, -4352.6, 2422.1, 7.5, 4.7, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- feralas to feathermoon
(666500, 0, 2070.5, 287.8, 97.0, 1.2, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0), -- uc to org
(666501, 1, 1323.9, -4655.2, 53.6, 0.8, 0, 0, 0.943353, -0.331792, 0, 25, 0, 0); -- org to uc


Tested and working 100% with client 2.2.3 Have Fun and don't forget to delete the WDB cache after you made the DB changes !
Thanks for reading

[gory]

Ok thanks a lot guys i will try this. Sorry but i was gone for a while and now i'm back.
And as for the guides if I want to create a creature that teleports me where ever i want how do i do that?

[tr4shm4n]

That is an bit harder but i belive it can be done when you know c++ then you can make an porter script for scripdev and compile it in but dint found an clear solution for it yet .

[gory]

I have managed to create the npc...but when i click on him he shows me no teleport locations...know what i can do to fix him?


i think that this picture explains what i wanna say....
please can somebody give me some suggestions?
thank you!

INSERT INTO creature_template VALUES (99001, 18, 0, 18, 0, "WingMan", "The Teleport Guy", 59, 61, 6700, 24000, 5598, 5875, 20, 35, 35,1,1.48, 0, 170, 182, 0, 1235, 1400, 1900, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, "", 1, 3, 0, 1, 0 );

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400124, 99001, 0, 0, 0, -14477.4, 462.267, 36.4485, 0.419071, 25, 0, 0, -14477.4, 462.267, 36.4485, 0, 24000, 5875, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400131, 99001, 0, 0, 0, -11090.6, -3452.55, 64.954, 2.28984, 25, 0, 0, -11090.6, -3452.55, 64.954, 0, 24000, 5875, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400114, 99001, 0, 0, 0, -10615.2, 1030.16, 34.1929, 2.20226, 25, 0, 0, -10615.2, 1030.16, 34.1929, 0, 24000, 5875, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400118, 99001, 0, 0, 0, -10520.4, -1258.46, 41.1286, 5.64894, 25, 0, 0, -10520.4, -1258.46, 41.1286, 0, 24000, 5875, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400116, 99001, 0, 0, 0, -9430.88, -2234.03, 68.7113, 5.04211, 25, 0, 0, -9430.88, -2234.03, 68.7113, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400110, 99001, 0, 0, 0, -8844.54, 485.869, 109.599, 0.723, 25, 0, 0, -8844.54, 485.869, 109.599, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400137, 99001, 0, 0, 0, -8368.43, -2741.08, 185.762, 0.474757, 25, 0, 0, -8368.43, -2741.08, 185.762, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400128, 99001, 1, 0, 0, -7225.87, -3747.09, 8.88085, 1.33898, 25, 0, 0, -7225.87, -3747.09, 8.88085, 0, 24000, 5875, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400139, 99001, 1, 0, 0, -6766.27, 771.904, 90.1627, 6.24712, 25, 0, 0, -6766.27, 771.904, 90.1627, 0, 24000, 5875, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400130, 99001, 0, 0, 0, -6559.29, -1169.16, 309.804, 6.25674, 25, 0, 0, -6559.29, -1169.16, 309.804, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400113, 99001, 0, 0, 0, -5428.87, -2923.09, 347.28, 5.67926, 25, 0, 0, -5428.87, -2923.09, 347.28, 0, 24000, 5875, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400107, 99001, 0, 0, 0, -4817.29, -1161.6, 502.211, 4.10833, 25, 0, 0, -4817.29, -1161.6, 502.211, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400126, 99001, 1, 0, 0, -4486.29, -774.453, -39.0427, 3.30356, 25, 0, 0, -4486.29, -774.453, -39.0427, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400127, 99001, 1, 0, 0, -4364.19, 3342.42, 12.2985, 3.25334, 25, 0, 0, -4364.19, 3342.42, 12.2985, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400111, 99001, 530, 0, 0, -4062.25, -11802.9, 8.78122, 6.24219, 25, 0, 0, -4062.25, -11802.9, 8.78122, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400152, 99001, 530, 0, 0, -3979.32, 2166.26, 105.439, 2.06952, 25, 0, 0, -3979.32, 2166.26, 105.439, 0, 15350, 5736, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400125, 99001, 1, 0, 0, -3820.48, -4509.44, 11.1166, 4.48159, 25, 0, 0, -3820.48, -4509.44, 11.1166, 0, 15350, 5736, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400117, 99001, 0, 0, 0, -3788.31, -768.553, 8.14358, 5.27374, 25, 0, 0, -3788.31, -768.553, 8.14358, 0, 15350, 5736, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400147, 99001, 530, 0, 0, -2999.59, 3868.3, 9.53208, 0.11868, 25, 0, 0, -2999.59, 3868.3, 9.53208, 0, 15350, 5736, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400148, 99001, 530, 0, 0, -2716.43, 7303.78, 88.5313, 3.02946, 25, 0, 0, -2716.43, 7303.78, 88.5313, 0, 15350, 5736, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400115, 99001, 530, 0, 0, -1925.22, -11950.1, 57.942, 3.49458, 25, 0, 0, -1925.22, -11950.1, 57.942, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400122, 99001, 0, 0, 0, -1234.5, -2512.91, 22.7353, 3.43319, 25, 0, 0, -1234.5, -2512.91, 22.7353, 0, 15350, 5736, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400120, 99001, 0, 0, 0, -702.477, -529.298, 25.3794, 2.23732, 25, 0, 0, -702.477, -529.298, 25.3794, 0, 24000, 5875, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400142, 99001, 530, 0, 0, -667.922, 2710.9, 94.2735, 2.23184, 25, 0, 0, -667.922, 2710.9, 94.2735, 0, 24000, 5875, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400143, 99001, 530, 0, 0, -337.224, 1014.43, 54.2301, 0.418008, 25, 0, 0, -337.224, 1014.43, 54.2301, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400123, 99001, 1, 0, 0, 130.5, 1326.7, 193.499, 6.07288, 25, 0, 0, 130.5, 1326.7, 193.499, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400144, 99001, 530, 0, 0, 195.109, 4236.46, 121.812, 1.22688, 25, 0, 0, 195.109, 4236.46, 121.812, 0, 15350, 5736, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400145, 99001, 530, 0, 0, 211.696, 6055.57, 148.318, 0.775364, 25, 0, 0, 211.696, 6055.57, 148.318, 0, 15350, 5736, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400141, 99001, 530, 0, 0, 271.428, 1491.53, -16.7188, 5.56455, 25, 0, 0, 271.428, 1491.53, -16.7188, 0, 15350, 5736, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400129, 99001, 0, 0, 0, 292.225, -2012.3, 194.126, 2.34645, 25, 0, 0, 292.225, -2012.3, 194.126, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400136, 99001, 0, 0, 0, 934.957, -1429.35, 64.7667, 3.79328, 25, 0, 0, 934.957, -1429.35, 64.7667, 0, 15350, 5736, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400146, 99001, 530, 0, 0, 959.637, 7409.94, 30.0363, 6.04146, 25, 0, 0, 959.637, 7409.94, 30.0363, 0, 15350, 5736, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400150, 99001, 530, 0, 0, 1854.51, 5526.39, 277.245, 1.12339, 25, 0, 0, 1854.51, 5526.39, 277.245, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400149, 99001, 530, 0, 0, 2184.03, 6804.33, 183.154, 4.41481, 25, 0, 0, 2184.03, 6804.33, 183.154, 0, 24000, 5875, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400140, 99001, 0, 0, 0, 2276.86, -5340.98, 88.1639, 3.11457, 25, 0, 0, 2276.86, -5340.98, 88.1639, 0, 15350, 5736, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400121, 99001, 1, 0, 0, 2688.5, 1455.77, 233.421, 2.54418, 25, 0, 0, 2688.5, 1455.77, 233.421, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400135, 99001, 1, 0, 0, 2723.51, -3884.03, 100.823, 1.36648, 25, 0, 0, 2723.51, -3884.03, 100.823, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400119, 99001, 1, 0, 0, 2825.8, -301.303, 107.675, 1.84557, 25, 0, 0, 2825.8, -301.303, 107.675, 0, 15350, 5736, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400132, 99001, 1, 0, 0, 6208.27, -1955.82, 571.764, 2.22088, 25, 0, 0, 6208.27, -1955.82, 571.764, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400112, 99001, 1, 0, 0, 6326.32, 549.122, 15.8432, 0.709687, 25, 0, 0, 6326.32, 549.122, 15.8432, 0, 6700, 5598, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400138, 99001, 1, 0, 0, 6800.8, -4751.08, 701.498, 1.49194, 25, 0, 0, 6800.8, -4751.08, 701.498, 0, 15350, 5736, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400133, 99001, 1, 0, 0, 7459.14, -2495.92, 462.615, 1.71961, 25, 0, 0, 7459.14, -2495.92, 462.615, 0, 24000, 5875, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400134, 99001, 1, 0, 0, 7797.54, -2404.98, 488.484, 3.61722, 25, 0, 0, 7797.54, -2404.98, 488.484, 0, 24000, 5875, 0, 1, "");

INSERT INTO creature
  (guid, id, map, modelid, equipment_id, position_x, position_y, position_z, orientation, spawntimesecs, spawndist, currentwaypoint, spawn_position_x, spawn_position_y, spawn_position_z, spawn_orientation, curhealth, curmana, DeathState, MovementType, auras)
VALUES
  (1400108, 99001, 1, 0, 0, 8649.88, 841.263, 23.2573, 3.19395, 25, 0, 0, 8649.88, 841.263, 23.2573, 0, 15350, 5736, 0, 1, "");

this is what i've managed to get up to if you were wondering adout the sql script...


PLEASE HELP ME!!!!