Sunzuke Posted June 24, 2013 Group: Members Topic Count: 17 Topics Per Day: 0.00 Content Count: 76 Reputation: 3 Joined: 02/24/12 Last Seen: October 19, 2013 Share Posted June 24, 2013 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) Quote Link to comment Share on other sites More sharing options...
itemxp Posted March 17, 2014 Group: Members Topic Count: 0 Topics Per Day: 0 Content Count: 5 Reputation: 0 Joined: 06/07/12 Last Seen: May 8, 2020 Share Posted March 17, 2014 link dead pls reupload Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.