[SQL] Quest NPC

[Sunzuke]

Download: http://download.host-z.net/extension/sqlquest.txt

Online View: http://www.host-z.net/download/npcs/sqlquest.txt

Idea: http://rathena.org/board/topic/53521-quest-npc-function/

 

This script creates a new table in your sql db called questnpc

in this table you can simply add your new quests to one npc

 

this table has the columns itemid and questitems

 

itemid is the ID of the itemreward

 

questitems are the required items for the itemid

it is build like:

ItemID,ItemID2 <- 2 different items required for the reward

ItemID:AMT <- AMT Items required for reward

1:AMT <- AMT zeny required for reward

 

ItemID1,ItemID2:AMT,1:AMT2 <- 1x ItemID1; AMTx ItemID2, AMT2 Zeny

 

, defines another item : defines the amt

 

Example:
    INSERT INTO `questnpc` (`itemid`, `questitems`) VALUES ('2795', '1:1000,512:10');
    Makes a new Apple Ring (2795) Quest for 1000 Zeny and 10 Apples (512)

[itemxp]

link dead

pls reupload