[Epic Release] Jonthe's Quest SQL Creator!

[Somedeveloperguy]

can you post it on another site as well? media fire gives me a javascript error

[Glorianglorre]

Thx man i will use this. But i think evoultionwow quest maker is bether.

[Hardball]

This is a good program however you have an issue. You are not able to create quests with an ' in the name. For example. If i were to put something in the text along the lines of

You must obtain the Ancient's Key. Only then will you get the power.


A line like this will break the entire query. I beleive when you coded this you forgot to make sure that the querys are wrapped in quote(") tags not apostrophe tags('). or use the proper \ commands for MySQL. If you can fix that I will plus rep the program - and you left a line to be created when you generate the SQL below the NPC's quest query there is still the line:

INSERT INTO quests VALUES()

[chaoticd35]

Excellent program, I love the way you did this, awesome.

Do you think you could make a version that works with aspire/Hearthstone? You wouldn't have to edit the Quest starter and finisher because it works fine.

Below is an example sql from Aspire(if you need this)

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for quests
-- ----------------------------
CREATE TABLE `quests` (
  `entry` int(11) unsigned NOT NULL,
  `ZoneId` int(11) NOT NULL default '0',
  `sort` int(11) NOT NULL default '0',
  `flags` int(11) unsigned NOT NULL default '0',
  `MinLevel` int(11) unsigned NOT NULL default '0',
  `questlevel` int(11) unsigned NOT NULL default '0',
  `Type` int(11) NOT NULL default '0',
  `RequiredRaces` int(11) NOT NULL default '0',
  `RequiredClass` int(11) NOT NULL default '0',
  `RequiredTradeskill` int(11) NOT NULL default '0',
  `RequiredTradeskillValue` int(11) NOT NULL default '0',
  `RequiredRepFaction` int(11) NOT NULL default '0',
  `RequiredRepValue` int(11) NOT NULL default '0',
  `SuggestedPlayers` int(11) unsigned NOT NULL default '0',
  `LimitTime` int(11) NOT NULL default '0',
  `SpecialFlags` int(11) unsigned NOT NULL default '0',
  `PrevQuestId` int(11) unsigned NOT NULL default '0',
  `NextQuestId` int(11) unsigned NOT NULL default '0',
  `srcItem` int(11) unsigned NOT NULL default '0',
  `SrcItemCount` int(11) unsigned NOT NULL default '0',
  `Title` text NOT NULL,
  `Details` text NOT NULL,
  `Objectives` text NOT NULL,
  `CompletionText` text NOT NULL,
  `IncompleteText` text NOT NULL,
  `EndText` text NOT NULL,
  `ObjectiveText1` text NOT NULL,
  `ObjectiveText2` text NOT NULL,
  `ObjectiveText3` text NOT NULL,
  `ObjectiveText4` text NOT NULL,
  `ReqItemId1` int(11) unsigned NOT NULL default '0',
  `ReqItemId2` int(11) unsigned NOT NULL default '0',
  `ReqItemId3` int(11) unsigned NOT NULL default '0',
  `ReqItemId4` int(11) unsigned NOT NULL default '0',
  `ReqItemCount1` int(11) unsigned NOT NULL default '0',
  `ReqItemCount2` int(11) unsigned NOT NULL default '0',
  `ReqItemCount3` int(11) unsigned NOT NULL default '0',
  `ReqItemCount4` int(11) unsigned NOT NULL default '0',
  `ReqKillPlayer` int(10) unsigned NOT NULL default '0',
  `ReqKillMobOrGOId1` bigint(11) NOT NULL default '0',
  `ReqKillMobOrGOId2` bigint(11) NOT NULL default '0',
  `ReqKillMobOrGOId3` bigint(11) NOT NULL default '0',
  `ReqKillMobOrGOId4` bigint(11) NOT NULL default '0',
  `ReqKillMobOrGOCount1` int(11) unsigned NOT NULL default '0',
  `ReqKillMobOrGOCount2` int(11) unsigned NOT NULL default '0',
  `ReqKillMobOrGOCount3` int(11) unsigned NOT NULL default '0',
  `ReqKillMobOrGOCount4` int(11) unsigned NOT NULL default '0',
  `ReqCastSpellId1` int(11) NOT NULL default '0',
  `ReqCastSpellId2` int(11) NOT NULL default '0',
  `ReqCastSpellId3` int(11) NOT NULL default '0',
  `ReqCastSpellId4` int(11) NOT NULL default '0',
  `RewChoiceItemId1` int(11) unsigned NOT NULL default '0',
  `RewChoiceItemId2` int(11) unsigned NOT NULL default '0',
  `RewChoiceItemId3` int(11) unsigned NOT NULL default '0',
  `RewChoiceItemId4` int(11) unsigned NOT NULL default '0',
  `RewChoiceItemId5` int(11) unsigned NOT NULL default '0',
  `RewChoiceItemId6` int(11) unsigned NOT NULL default '0',
  `RewChoiceItemCount1` int(11) unsigned NOT NULL default '0',
  `RewChoiceItemCount2` int(11) unsigned NOT NULL default '0',
  `RewChoiceItemCount3` int(11) unsigned NOT NULL default '0',
  `RewChoiceItemCount4` int(11) unsigned NOT NULL default '0',
  `RewChoiceItemCount5` int(11) unsigned NOT NULL default '0',
  `RewChoiceItemCount6` int(11) unsigned NOT NULL default '0',
  `RewItemId1` int(10) unsigned NOT NULL default '0',
  `RewItemId2` int(10) unsigned NOT NULL default '0',
  `RewItemId3` int(10) unsigned NOT NULL default '0',
  `RewItemId4` int(10) unsigned NOT NULL default '0',
  `RewItemCount1` int(10) unsigned NOT NULL default '0',
  `RewItemCount2` int(10) unsigned NOT NULL default '0',
  `RewItemCount3` int(10) unsigned NOT NULL default '0',
  `RewItemCount4` int(10) unsigned NOT NULL default '0',
  `RewRepFaction1` int(10) unsigned NOT NULL default '0',
  `RewRepFaction2` int(10) unsigned NOT NULL default '0',
  `RewRepFaction3` int(11) NOT NULL default '0',
  `RewRepFaction4` int(11) NOT NULL default '0',
  `RewRepFaction5` int(11) NOT NULL default '0',
  `RewRepValue1` int(10) NOT NULL default '0',
  `RewRepValue2` int(10) NOT NULL default '0',
  `RewRepValue3` int(11) NOT NULL default '0',
  `RewRepValue4` int(11) NOT NULL default '0',
  `RewRepValue5` int(11) NOT NULL default '0',
  `RewRepLimit` int(10) unsigned NOT NULL default '0',
  `RewTitle` int(11) unsigned NOT NULL default '0',
  `RewMoney` int(10) NOT NULL default '0',
  `RewBonusHonor` int(10) unsigned NOT NULL default '0',
  `RewXP` int(10) unsigned NOT NULL default '0',
  `RewSpell` int(10) unsigned NOT NULL default '0',
  `RewTalent` int(11) unsigned NOT NULL default '0',
  `CastSpell` int(10) unsigned NOT NULL default '0',
  `PointMapId` int(10) unsigned NOT NULL default '0',
  `PointX` float NOT NULL default '0',
  `PointY` float NOT NULL default '0',
  `PointOpt` int(10) unsigned NOT NULL default '0',
  `RequiredMoney` int(11) unsigned NOT NULL default '0',
  `ExploreTrigger1` int(10) unsigned NOT NULL default '0',
  `ExploreTrigger2` int(10) unsigned NOT NULL default '0',
  `ExploreTrigger3` int(10) unsigned NOT NULL default '0',
  `ExploreTrigger4` int(10) unsigned NOT NULL default '0',
  `RequiredQuest1` int(10) unsigned NOT NULL default '0',
  `RequiredQuest2` int(10) unsigned NOT NULL default '0',
  `RequiredQuest3` int(10) unsigned NOT NULL default '0',
  `RequiredQuest4` int(10) unsigned NOT NULL default '0',
  `RequiredQuest_and_or` int(3) NOT NULL default '0',
  `ReceiveItemId1` int(10) unsigned NOT NULL default '0',
  `ReceiveItemId2` int(10) unsigned NOT NULL default '0',
  `ReceiveItemId3` int(10) unsigned NOT NULL default '0',
  `ReceiveItemId4` int(10) unsigned NOT NULL default '0',
  `ReceiveItemCount1` int(10) unsigned NOT NULL default '0',
  `ReceiveItemCount2` int(10) unsigned NOT NULL default '0',
  `ReceiveItemCount3` int(10) unsigned NOT NULL default '0',
  `ReceiveItemCount4` int(10) unsigned NOT NULL default '0',
  `IsRepeatable` int(11) NOT NULL default '0',
  PRIMARY KEY  (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Quests System';

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `quests` VALUES ('5741', '405', '0', '8', '30', '33', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6027', '0', '0', 'Sceptre of Light', 'The Burning Blade in Thunder Axe Fortress to the east is rumored to have acquired the Sceptre of Light from the Naga. Legend tells that the sceptre is able to sink entire cities under the great seas. The Burning Blade must not be allowed to possess such power.$B$BTo that end, you must retrieve the sceptre yourself!  It is held by a Burning Blade seer, who studies the sceptre from atop one of the Thunder Axe watchtowers.\r\n', 'Get the Sceptre of Light and then return it to Azore Aldamort at the tower in Ethel Rethor.\r\n', 'The elusive Sceptre of Light!  Your acquisition of it has removed a grave threat to the world.  Well done, $C, well done.', 'Do you have the Sceptre of Light?', '', '', '', '', '', '15750', '0', '0', '0', '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', '0', '0', '0', '0', '0', '529', '0', '0', '0', '0', '500', '0', '0', '0', '0', '0', '0', '3500', '0', '2900', '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');

The below sql is an example sql i edited to work for aspire/Hearthstone.

INSERT INTO `quests` VALUES ('14000', '0', '0', '2', '70', '80', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'Defend the raceway!', 'Slay 20 Lightning clouds to recieve 1 death token that can be used to exchange for custom weapons and armor.', 'The local raceway is in need of major help!! The Lightning clouds are endangering the surrounding area!
Please race to their aid and destroy this vile and wicked creatures.', 'Thank you, $N, so much.  Thank you for helping, the world wil be a safer place due to heros like you!!', 'Have you slain 20 yet?', '', '', '', '', '', '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', '609', '0', '0', '0', '0', '150', '0', '0', '0', '0', '0', '0', '0', '0', '750', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '6122', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

[Exacute]

Nice, +Rep
You should try to add a function with required race & class to it.. would make it perfect..

[Vakknah]

where do i put it? when i try to run it i just get an error. App failed to start properly

[Leadx]

If you can, could you make the quest ID's larger in the next update because one quest I want to have it as chain quest has a way too big ID for this program. If you could, it would be cool.

[puffr]

Great release

[hagii]

cool gonna try it out

[Jonthe838]

Hi! thx for all the great feedback. My computer was down for 1.5month and now its down again -.- I'm working on fixing it. I think i need to buy a new motherboard but im going to try to fi it without a new :P I Still have the files for this so the projec aint lost. As soon as i get my comouter working i will update thsi L( thanks for ur understanding.
I will create a aspire version, and add a few new options too

[djen11]

freat work

[caeon]

column count doesnt match value count at row 1 Please help Thx! for quest maker but need it to work!

[heldrake]

Thanks alot I am gonna give it a whirl lol. I hope I have the brain power to get it to work lol.

[baagel]

yeah you should either wrap them in

"

or

`

[Tanner]

[Err] 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 's your prize!', 'Get to the top!', 'Grats!', '', '', '', '', '0', '0', '0', '0',' at line 1

that's the error I get, can anyone help? I don't understand it