[Help] Teleporter NPC SQL

[Performer]

Hello All,

I have this Teleporter NPC SQL file but i get an error message.

The SQL File is:

insert into `creature_names`(`entry`,`name`,`subname`,`Flags1`,`type`,`family`,`rank`,`unk4`,`spelldataid`,`male_displayid`,`female_displayid`,`male_displayid2`,`female_displayid2`,`unknown_float1`,`unknown_float2`,`civilian`,`leader`) values (123456,'Mor\'Thas','Teleporter',0,0,0,0,4,0,0,15945,0,0,0,0,0,0,1);

INSERT INTO `creature_proto` (`entry`,`minlevel`,`maxlevel`,`faction`,`minhealth`,`maxhealth`,`mana`,`scale`,`npcflags`,`attacktime`,`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 ('123456','90','90','35','9999','9999','9999','1','5','10','999','9999','0','0','0','0','0','0','0','0','0','0','0','0','0','15000','0','0','0','0','0','0','0','0','0','0','1','0','0','0','20','40','50','0');

And the error is:

[Err] 1136 - Column count doesn't match value count at row 1
[Err] insert into `creature_names`(`entry`,`name`,`subname`,`Flags1`,`type`,`family`,`rank`,`unk4`,`spelldataid`,`male_displayid`,`female_displayid`,`male_displayid2`,`female_displayid2`,`unknown_float1`,`unknown_float2`,`civilian`,`leader`) values (123456,'Mor\'Thas','Teleporter',0,0,0,0,4,0,0,15945,0,0,0,0,0,0,1);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Please Help

If anyone could correct that SQL for me i will give you rep

thanks,
mtthwclinton

[Spartansp]

its a problem with the rev you are using cause there have been updates in the tables tell me which one you are using maybe that can help a little bit not sure but can be

[Moederkoek]

You've got 17 colum's, there are 18. One sec while I look it up.

EDIT: insert into `creature_names`(`entry`,`name`,`subname`,`mouseflags`,`Flags1`,`type`,`family`, `rank`,`unk4`,`spelldataid`,`male_displayid`,`female_displayid`,`male_displayid2 `,`female_displayid2`,`unknown_float1`,`unknown_float2`,`civilian`,`leader`) values (123456,'Mor\'Thas','Teleporter',0,0,0,0,0,4,0,0,15945,0,0,0,0,0,0,1);

Should work

[King Shaun]

I know what is wrong. I have the exact same file but I fixed it. If you still want to know what to do then read this below, I put a new code there!

insert into `creature_names`(`entry`,`name`,`subname`,`Flags1`,`type`,`family`,`rank`,`unk4` ,`spelldataid`,`male_displayid`,`female_displayid`,`male_displayid2`,`female_dis playid2`,`unknown_float1`,`unknown_float2`,`civilian`,`leader`) values (99890,'Mor\'Thas','Teleporter',0,0,0,0,4,0,0,15945,0,0,0,0,0,0,1);

INSERT INTO `creature_proto` (`entry`,`minlevel`,`maxlevel`,`faction`,`minhealth`,`maxhealth`,`mana`,`scale`, `npcflags`,`attacktime`,`mindamage`,`maxdamage`,`rangedattacktime`,`rangedmindam age`,`rangedmaxdamage`,`mountdisplayid`,`equipmodel1`,`equipinfo1`,`equipslot1`, `equipmodel2`,`equipinfo2`,`equipslot2`,`equipmodel3`,`equipinfo3`,`equipslot3`, `respawntime`,`armor`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`r esistance5`,`resistance6`,`combat_reach`,`bounding_radius`,`auras`,`boss`,`money `,`invisibility_type`,`death_state`,`walk_speed`,`run_speed`,`fly_speed`,`extra_ a9_flags`) VALUES ('99890','90','90','35','9999','9999','9999','1','5','10','999','9999','0','0',' 0','0','0','0','0','0','0','0','0','0','0','15000','0','0','0','0','0','0','0',' 0','0','0','1','0','0','0','20','40','50','0');
There is the new code. Just execute that, it should work.

If it does please rep me like you said. Because I need to get out of this ****ing leecher status. Lmao!