Cant view things on NPC

[Ziddy1337]

I have tried making my own Warp npc, and i have compiled the dll and it works fine, however i cant correctly get the npc into the database.

I can spawn the npc ingame but when i speak to it, it just says hello, and doesnt have any options.

Here is the code im using:

INSERT INTO `creature_names` VALUES ('99230', 'FlashWoW NPC', 'Teleporter', '0', '0', '4', '4', '0', '0', '0', '20306', '20306', '0', '0', '1', '1', '1', '1');

INSERT INTO `creature_proto` VALUES ('99230', '200', '200', '35', '20000', '20000', '1', '1', '1', '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', '2. 

Also, when i try and put the sql query into my database, i get this error@

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2.' at line 1
(0 ms taken) 

Does anybody know how i can fix this, so the teleport option appear properly?

+Rep and much love to all who reply (If its a decent reply)

[zsolt333]

Try this one

INSERT INTO `creature_names` VALUES ('99230', 'FlashWoW NPC', 'Teleporter', '0', '0', '4', '4', '0', '0', '0', '20306', '20306', '0', '0', '1', '1', '1', '1');

INSERT INTO `creature_proto` VALUES ('99230', '200', '200', '35', '20000', '20000', '1', '1', '1', '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', '2');

in your script your warp ID is 99230?

[Ziddy1337]

With that code im getting this error:

Error Code : 1136
Column count doesn't match value count at row 1
(0 ms taken)

If it helps, im using ArcEmu, and SQLYog.

[zsolt333]

Then modify The name and display ID for thosone

on my arcemu ... whydb this works fine

INSERT INTO `creature_names` (`name`, `subname`, `info_str`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `civilian`, `Leader`, `entry`) VALUES ('C4 WoW Teleporter', '', '', '0', '0', '3', '0', '21661', '0', NULL, '55555');
INSERT INTO `creature_proto` (`minlevel`, `maxlevel`, `Faction`, `minhealth`, `maxhealth`, `mana`, `Scale`, `npcflags`, `attacktime`, `mindamage`, `maxdamage`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `combat_reach`, `boss`, `equipmodel1`, `equipmodel2`, `equipmodel3`, `respawntime`, `auras`, `invisibility_type`, `death_state`, `entry`) VALUES ('100', '100', '35', '999999999', '999999999', '999999999', '1', '1', '1500', '0', '50000', '100000', '0', '0', '1', '0', '0', '0', '0', '60', '0', '0', '0', '55555');

[mager1794]

make sure this is your query

INSERT INTO `creature_names` VALUES ('99230', 'FlashWoW NPC', 'Teleporter', '0', '0', '4', '4', '0', '0', '0', '20306', '20306', '0', '0', '1', '1', '1', '1'); 

INSERT INTO `creature_proto` VALUES ('99230', '200', '200', '35', '20000', '20000', '1', '1', '1', '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', 2.

k now go into your warpNPC script
now scroll to the bottom

make sure its like this

void SetupGlobalNPC(ScriptMgr * mgr)
{
        GossipScript * gs = (GossipScript*) new GlobalNPC();
    mgr->register_gossip_script(99230, gs);
}

if this doesn't work then post your warpNPC script and ill fix it