Easy SQL Quest Template for everyone

[yakuu]

Hey there, 

 

 

You need basis knowledge to edit / import tabels in mysql.

 

• Quest based on SQL ( dont need reloadscript if the main npc exists)
• Easy adding / removeing Items in/out of the Quest
• Item check how much left to complette
• GMs see ItemIDs in Quest to fix fast
• Loging who has complete wich Item

 

//===========SCREENSHOTS===============================

 

 

 

 

 

 

 

 

 

 

// ===========MAIN=NPC====================================

That will be the file for your "Quest Arena"

the_quest.txt

// ======================================================

 

// ===============DONT=EDIT=only=import=it===================

*Warning* dont edit this file if you dont know what you do!*

default_script.txt.txt

// ======================================================

 

// ==================SQL=================================

With 3 Examples just edit or Add the rows..

quest_template.sql

// ======================================================

 

 

 

//=================================================

Guide how to Add a Item to the NPC and than to the require.

 

You allready have include all the files on your import files and changed the map of the Main Quest NPC

than you will see that the NPC allready got items.

 

INSERT INTO `customquest` (`item`, `itemname`, `description`, `require`, `amount`, `npc`) VALUES
('20001', 'AnyName-Wings_001', 'kA', '', '', 'quest_001-middle'),
('20001', 'Jellopy_require', '', '909', '5000', ''),

('20002', 'AnyName-Upper_001', 'kA', '', '', 'quest_001-upper'),
('20002', 'Jellopy_require', '', '909', '5000', ''),

('20003', 'AnyName-Lower_001', 'kA', '', '', 'quest_001-lower'),
('20003', 'Jellopy_require', '', '909', '5000', '');

 

Right, item 20001 in Middle Wings, 20002 in Upper and 20003 in Lower.
Require get 5k Jellopy for the Custom wow..

 

Okai bored, we need to add a Item and edit the 5k to 350 its to much for one custom..

All What we need for that is only that line!

 

('20001', 'Jellopy_require', '', '909', '5000', ''),

to

('20001', 'Jellopy_require', '', '909', '350', ''),

 

Now we need 350 Jellopys when we update that in our SQL table

The update is mark becouse when the row with 5k jellopys will not deleted it will ask 2x for the item.

 

Adding 3 carat Diamon on the Quest of item 20001

 

INSERT INTO `customquest` (`item`, `itemname`, `description`, `require`, `amount`, `npc`) VALUES

('20001', '3carat Diamond', '', '732', '150', '');

 

 

Adding new Custom to the quest_001-upper

 

INSERT INTO `customquest` (`item`, `itemname`, `description`, `require`, `amount`, `npc`) VALUES

('20004', 'AnyName-Upper_001', 'kA', '', '', 'quest_001-upper');

 

dont forgott to add a require on the Item else you will get it for free~

 

INSERT INTO `customquest` (`item`, `itemname`, `description`, `require`, `amount`, `npc`) VALUES

('20004', '3carat Diamond', '', '732', '150', '');

 

Done.

 

 

The description tables unused only for the overall view and a small php-script that i write(if someone interessted PM).

 

 

 

 

 

 

 

 

 

 

 

 

 

Edited February 19, 2013 by yakuu