DEEPHOLM SPIRIT HEALERS - SQL Injections

[Krowten]

There is only one spirit healer in Deepholm. Insert these into your 'creature' table and you should be fine. I'll post more if my Beta testers find them. We have a team of 60 people testing this core. If you're interested let me know.


INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (10347256, 39660, 646, 5042, 5330, 1, 65535, 0, 0, 443.09, 1636.47, 349.063, 1.32501, 300, 0, 0, 4120, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (10347256, 39660, 646, 5042, 5330, 1, 65535, 0, 0, 443.09, 1636.47, 349.063, 1.32501, 300, 0, 0, 4120, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (10346904, 39660, 646, 5042, 5302, 1, 65535, 0, 0, 997.186, -871.433, 283.165, 0.481495, 300, 0, 0, 4120, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (10345816, 39660, 646, 5042, 5350, 1, 65535, 0, 0, 1253.07, 1647.59, 174.679, 5.86138, 300, 0, 0, 4120, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (10345752, 39660, 646, 5042, 5394, 1, 65535, 0, 0, 186.745, 825.501, 52.5093, 2.1386, 300, 0, 0, 4120, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (10345745, 39660, 646, 5042, 5354, 1, 65535, 0, 0, 8.46137, -164.952, 204.485, 4.84241, 300, 0, 0, 4120, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO `creature` (`guid`, `id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`, `saiscriptflag`) VALUES (10345054, 39660, 646, 5042, 5335, 1, 65535, 0, 0, 854.266, 638.137, -68.2874, 2.23584, 300, 0, 0, 4120, 0, 0, 0, 0, 0, 0, 0);


**** YOU MAY NEED TO CHANGE THE GUID NUMBERS You will need to restart your server for this to be implemented. More to come guys... ****

 

[Blackvision]

Thanks mate
You're doing a great job!

 

[Damieninabox]

You can just export it without guid numbers, the database will insert them on it's own + other people can avoid struggles with that.
Just as a hint

 

[Krowten]

You can just export it without guid numbers, the database will insert them on it's own + other people can avoid struggles with that.
Just as a hint

TY for the advice Damien!

 

[ExO]

Should be fixed now.