[Request] NPC with Quest

[Gadella]

What i need is a NPC which got a quest whhich will grant 123912391293 xp (To level 70) and give 10000 gold

The one who makes will ofc receive +Rep

[Spartansp]

here you go....

INSERT INTO `creature_names` VALUES ('111111111', 'Lv 70 Quester', 'Ubber Training', '0', '0', '0', '0', '3', '0', '0', '16732', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO `creature_proto` VALUES ('111111111', '70', '70', '35', '10000000', '100000000', '1000000000', '1', '2', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '36000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.5', '8', '14', '0');
INSERT INTO `creature_quest_starter` VALUES ('111111111', '111111111');
INSERT INTO `creature_quest_finisher` VALUES ('111111111', '111111111');
INSERT INTO `quests` VALUES ('111111111', '0', '0', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Talk Me to get lvl70', 'Talk me again to get lvl 70', 'talk me', ' ', ' ', ' ', 'Talk me', 'Talk me', 'Talk me', 'Talk me', '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', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100000000', '1239123912', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

[Gadella]

Thanks man BUt i just repped you 1 min ago for ya city -.-'
How bout i rep you when i spreaded?

[Spartansp]

lol no problem mate hope this one works cause im using an old NCDB ... :S

[Gadella]

Dam dam dam daaaam!

error occured at:2008-02-06 19:08:15
Line no.:2
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 'Rar!' at line 1
Query:
INSERT INTO `creature_proto` VALUES ('111111111', '70', '70', '35', '10000000', '100000000', '1000000000', '1', '2', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '36000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.5', '8', '14', '0')
Error occured at:2008-02-06 19:58:11
Line no.:2
Error Code: 1136 - Column count doesn't match value count at row 1

[Spartansp]

Column count doesn't match value count at row 1

thats what i told you... the NCDB im using is a bit old lol...

[Gadella]

Well thanks for doin' try =)

[Knife]

Here u go :

INSERT INTO `quests` VALUES ('150000', '0', '0', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '4', '0', '0', '0', '0', 'Level 70 Quest', 'As a gift for joining us talk with me if u want your gift', 'Speak again to me and youl get you`re gift', '', '', 'Your ready to begin your Journey through our awesome Realms', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '150000', '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', '0', '0', '0', '0', '0', '100000000', '1239123912', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `creature_names` VALUES ('150000', 'Mystic Gifter', 'Join Rewarder', '', '0', '7', '0', '3', '0', null, '18743', '0', '0', '0', '1', '1', '0', '0');
INSERT INTO `creature_proto` VALUES ('150000', '70', '70', '35', '100000', '100000', '100000', '1', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '0', '0', '0', '0', '0', '0', '0', '1', '0', '', '0', '0', '0', '0', '2.5', '8', '14', '0');
INSERT INTO `creature_quest_starter` VALUES ('150000', '150000');
INSERT INTO `creature_quest_finisher` VALUES ('150000', '150000');

Hope u like it :P

[Gadella]

rror occured at:2008-02-06 19:58:11
Line no.:2
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO `creature_proto` VALUES ('150000', '70', '70', '35', '100000', '100000', '100000', '1', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '100', '0', '0', '0', '0', '0', '0', '0', '1', '0', '', '0', '0', '0', '0', '2.5', '8', '14', '0')
Error occured at:2008-02-06 21:31:41
Line no.:3
Error Code: 1136 - Column count doesn't match value count at row 1

[Knife]

I use NCDB1067 what are you using?

[Gadella]

NCDB1067
Ya mean ver? O.o otherwise i dont know

[Knife]

Lol we use same thing and dont work ? for me worked i dunno...what the problem is

[vb4evr]

I'm guessing you have an additional column in your creature_proto. Fixed easily enough. Again I am assuming here... try this for the creature_proto, the rest would be the same from spartan's code from above.

Just used spartans insert and added an extra entry.

INSERT INTO `creature_proto` VALUES ('111111111', '70', '70', '35', '10000000', '100000000', '1000000000', '1', '2', '2000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '36000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2.5', '8', '14', '0', '0');