Help with NPC Code

[Fuynuns93]

Can you tell me what wrong with this code?

INSERT INTO creature_names (entry, name, subname, info_str, Flags1, type, family, rank, male_displayid, female_displayid, male_displayid2, female_displayid2, civilian, leader) VALUES ('600001','WoW Zone','Starter','','2','7','0','3','15369','0','0','0','1','1')

INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipmodel2, equipmodel3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, auras, boss, money, invisibility_type, death_state, walk_speed, run_speed, fly_speed) VALUES ('600001','70','70','35','1000000','1000000','100','2','1500','0','0','0','0','0 ','0','0','0','0','60','0','0','0','0','0','0','0','0','0','0','1','0','0','2.5' ,'8','14')

And

UPDATE creature_names SET name = 'WoW Zone', subname = 'Starter', info_str = '', Flags1 = '2', type = '7', family = '0', rank = '3', male_displayid = '15369', female_displayid = '0', male_displayid2 = '0', female_displayid2 = '0', civilian = '1', leader = '1' WHERE entry = '600001'

UPDATE creature_proto SET minlevel = '70', maxlevel = '70', faction = '35', minhealth = '1000000', maxhealth = '1000000', mana = '100', scale = '1', npcflags = '2', attacktime = '1500', mindamage = '0', maxdamage = '0', rangedattacktime = '0', rangedmindamage = '0', rangedmaxdamage = '0', mountdisplayid = '0', equipmodel1 = '0', equipmodel2 = '0', equipmodel3 = '0', respawntime = '60', armor = '0', resistance1 = '0', resistance2 = '0', resistance3 = '0', resistance4 = '0', resistance5 = '0', resistance6 = '0', combat_reach = '0', auras = '0', boss = '0', money = '1', invisibility_type = '0', death_state = '0', walk_speed = '2.5', run_speed = '8', fly_speed = '14' WHERE entry = '600001'

[Lets See2]

Well Im Not Sure Buddy ;(

Why Dont I Try It!

[Fuynuns93]

okay sure go ahead

[Fuynuns93]

Anyone know whats wrong? +rep to helper!!

[TheSpidey]

First thing that's wrong: You double posting. Forum != Chat.

Also, you haven't ran the SQL updates. Do so.

[Fuynuns93]

First thing that's wrong: You double posting. Forum != Chat.

Also, you haven't ran the SQL updates. Do so.

What updates??

[TheSpidey]

The updates in the SQL directory of the SVN!!

[backlash52]

you know what would really help? telling me, what it tells you, when you try to insert it. that would be VERY helpful and i could prolly tell you whats wrong and what to change.

Edit: ok after inspecting you insert into creature proto line i can tell you its screwed. now you are missing fields of data from it so you're going to have to rewrite the file. i recommend going into your navicat and manually entering the numbers into the table yourself. just create a new entry in the creature proto table and enter in the info you had on that query string and it'll work. also the top line works fine so you can still use that if you want.