[HELP] Creature Spawn

[Jonthe838]

HELP! ^^
can someone help me fix this creature spawn?
its for a dk that is bugged and im trying to fix so it works...
i want to spawn Unworthy Initiate at x: 2443.189941 Y: -5585.970215 Z: 415.242004 O: 6.091200 at map: 609

Here is the info i have been trying to get to work:

INSERT INTO `creature_spawns` VALUES ('369158', '29519', '609', '2443.189941', '-5585.970215', '415.242004', '6.091200', '0', '25355', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0');

[Ironmage]

Don't forget:

INSERT INTO `Creature_proto `

[Jonthe838]

huh? ^^ hahah i already have the npc in the DB but i need to fix a spawn for him ^^

[Ironmage]

huh? ^^ hahah i already have the npc in the DB but i need to fix a spawn for him ^^

Lol ohhhh, but dude if you have the creature in the DB already then just go to were you want to spawn him then .npc spawn <ID>

[Jonthe838]

i know but im trying to help other ppl so they dont have to do that?? so they just can run my sql file :P

[Sireddie]

Might be able to help if you say whats not working.

[Flake0207]

um that doesnt make to much since run ur SQL file? why cant they just go to the place they want him to be spawned and do it it like 12 letters????

[Jonthe838]

Idk dont know whats not working ^^ haha its only says thats something is wrong at row 1 xD

[kreegoth]

Well.. You have 19 fields in your Values.. My Creature_spawns table which loads properly and has all the Sqls working off 1888 patch has 24.. You might be missing some values if your trying to load it into a Current DB.

[latruwski]

isn't there already an entry for that NPC? if so just change those values... if not then you have to enter your own... use DB documentation from wiki sites if needed

[Jonthe838]

ok :I) ty ^^ will take a look again ^^