API tools faq
paste
Emistry

InComplete Mission Board

Emistry
May 1st, 2012
345
0
Never
1
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.21 KB | None | 0 0
raw download clone embed print report
  1.  
  2. /*
  3.  
  4.  
  5. CREATE TABLE IF NOT EXISTS `QuestList` (
  6. `Quest_ID` int(10) unsigned NOT NULL auto_increment,
  7. `Quest_Name` text,
  8. `Quest_Desc` text,
  9. `Min_Lv` smallint(11) unsigned NOT NULL default '0',
  10. `Max_Lv` smallint(11) unsigned NOT NULL default '0',
  11. `Type` smallint(11) unsigned NOT NULL default '0',
  12.  
  13. `Time` bigint(20) unsigned NOT NULL default '0',
  14.  
  15. `Tar1_ID` int(10) unsigned NOT NULL default '0',
  16. `Tar1_Qty` int(10) unsigned NOT NULL default '0',
  17.  
  18. `Tar2_ID` int(10) unsigned NOT NULL default '0',
  19. `Tar2_Qty` int(10) unsigned NOT NULL default '0',
  20.  
  21. `Tar3_ID` int(10) unsigned NOT NULL default '0',
  22. `Tar3_Qty` int(10) unsigned NOT NULL default '0',
  23.  
  24. `Tar4_ID` int(10) unsigned NOT NULL default '0',
  25. `Tar4_Qty` int(10) unsigned NOT NULL default '0',
  26.  
  27. `Tar5_ID` int(10) unsigned NOT NULL,
  28. `Tar5_Qty` int(10) unsigned NOT NULL default '0',
  29.  
  30.  
  31. `Item1_ID` int(10) unsigned NOT NULL default '0',
  32. `Item1_Qty` int(10) unsigned NOT NULL default '0',
  33.  
  34. `Item2_ID` int(10) unsigned NOT NULL default '0',
  35. `Item2_Qty` int(10) unsigned NOT NULL default '0',
  36.  
  37. `Item3_ID` int(10) unsigned NOT NULL default '0',
  38. `Item3_Qty` int(10) unsigned NOT NULL default '0',
  39.  
  40. `Item4_ID` int(10) unsigned NOT NULL default '0',
  41. `Item4_Qty` int(10) unsigned NOT NULL default '0',
  42.  
  43. `Item5_ID` int(10) unsigned NOT NULL,
  44. `Item5_Qty` int(10) unsigned NOT NULL default '0',
  45.  
  46.  
  47. `Prz1_Name` int(10) unsigned NOT NULL,
  48. `Prz1_Qty` int(10) unsigned NOT NULL default '0',
  49.  
  50. `Prz2_Name` int(10) unsigned NOT NULL,
  51. `Prz2_Qty` int(10) unsigned NOT NULL default '0',
  52.  
  53. `Prz3_Name` int(10) unsigned NOT NULL,
  54. `Prz3_Qty` int(10) unsigned NOT NULL default '0',
  55.  
  56. `Prz4_Name` int(10) unsigned NOT NULL,
  57. `Prz4_Qty` int(10) unsigned NOT NULL default '0',
  58.  
  59. `Prz5_Name` int(10) unsigned NOT NULL,
  60. `Prz5_Qty` int(10) unsigned NOT NULL default '0',
  61.  
  62. PRIMARY KEY (`Quest_ID`)
  63. ) ENGINE=MyISAM;
  64.  
  65.  
  66.  
  67.  
  68. CREATE TABLE IF NOT EXISTS `CharQuest` (
  69. `Char_ID` int(11) unsigned NOT NULL,
  70. `Quest_ID` int(10) unsigned NOT NULL,
  71.  
  72. `TimeLeft` bigint(20) unsigned NOT NULL default '0',
  73.  
  74. `Tar1_ID` int(10) unsigned NOT NULL default '0',
  75. `Tar1_Qty` int(10) unsigned NOT NULL default '0',
  76.  
  77. `Tar2_ID` int(10) unsigned NOT NULL default '0',
  78. `Tar2_Qty` int(10) unsigned NOT NULL default '0',
  79.  
  80. `Tar3_ID` int(10) unsigned NOT NULL default '0',
  81. `Tar3_Qty` int(10) unsigned NOT NULL default '0',
  82.  
  83. `Tar4_ID` int(10) unsigned NOT NULL default '0',
  84. `Tar4_Qty` int(10) unsigned NOT NULL default '0',
  85.  
  86. `Tar5_ID` int(10) unsigned NOT NULL,
  87. `Tar5_Qty` int(10) unsigned NOT NULL default '0',
  88.  
  89. `Item1_ID` int(10) unsigned NOT NULL default '0',
  90. `Item1_Qty` int(10) unsigned NOT NULL default '0',
  91.  
  92. `Item2_ID` int(10) unsigned NOT NULL default '0',
  93. `Item2_Qty` int(10) unsigned NOT NULL default '0',
  94.  
  95. `Item3_ID` int(10) unsigned NOT NULL default '0',
  96. `Item3_Qty` int(10) unsigned NOT NULL default '0',
  97.  
  98. `Item4_ID` int(10) unsigned NOT NULL default '0',
  99. `Item4_Qty` int(10) unsigned NOT NULL default '0',
  100.  
  101. `Item5_ID` int(10) unsigned NOT NULL,
  102. `Item5_Qty` int(10) unsigned NOT NULL default '0',
  103.  
  104. PRIMARY KEY (`Char_ID`)
  105. ) ENGINE=MyISAM;
  106.  
  107.  
  108.  
  109.  
  110. */
  111.  
  112.  
  113. prontera,155,181,5 script Quest Board 757,{
  114.  
  115. function TimeConvert;
  116.  
  117.  
  118.  
  119. if( getgmlevel() < .MinGMLevel )
  120. goto PlayerMenu;
  121. else goto GM_MENU;
  122. end;
  123.  
  124.  
  125.  
  126. OnInit:
  127. set .MinGMLevel,90;
  128. set .MaxQuest,4;
  129. end;
  130.  
  131.  
  132.  
  133. GM_MENU:
  134. mes "How can i help you today ?";
  135. switch( select( "View My Quest",
  136. "Add New Quest",
  137. "Cancel" )){
  138.  
  139. Case 1:
  140. query_sql("SELECT `Quest_ID`,`Quest_Name` FROM `CharQuest` WHERE `Char_ID` = '"+getcharid(0)+"' LIMIT "+.MaxQuest+"",.@QuestID,.@QuestName$ );
  141. for( set .@i,1; .@i <= .MaxQuest; set .@i,.@i + 1 )
  142. set .@Menu$,.@Menu$ + (( .@QuestName$[.@i] == "" )?"^FF0000Empty Slot^000000":.QuestName$[.@i] )+":";
  143. set .@Slot,select( .@Menu$ );
  144. if( .@QuestName$[.@Slot] != "" ){
  145. next;
  146. switch( select("Complete Quest:Delete Quest") ){
  147. Case 1:
  148. query_sql("SELECT `TimeLeft`,`Tar1_ID`,`Tar1_Qty`,`Tar2_ID`,`Tar2_Qty`,`Tar3_ID`,`Tar3_Qty`,`Tar4_ID`,`Tar4_Qty`,`Tar5_ID`,`Tar5_Qty`,`Item1_ID`,`Item1_Qty`,`Item2_ID`,`Item2_Qty`,`Item3_ID`,`Item3_Qty`,`Item4_ID`,`Item4_Qty`,`Item5_ID`,`Item5_Qty`, FROM `CharQuest`WHERE `Char_ID`='"+getcharid(0)+"' AND `Quest_ID` = '"+.@QuestID[.@Slot]+"'",
  149. .@TimeLeft,.@Tar1_ID,.@Tar1_Qty,.@Tar2_ID,.@Tar2_Qty,.@Tar3_ID,.@Tar3_Qty,.@Tar4_ID,.@Tar4_Qty,.@Tar5_ID,.@Tar5_Qty,.@Item1_ID,.@Item1_Qty,.@Item2_ID,.@Item2_Qty,.@Item3_ID,.@Item3_Qty,.@Item4_ID,.@Item4_Qty,.@Item5_ID,.@Item5_Qty );
  150.  
  151. if( .@TimeLeft < 1 ){
  152. mes "Sorry the Quest has been Expired, and i will remove the Quest from you since it is not removed from your current Quest Lists.";
  153. query_sql("DELETE FROM `CharQuest` WHERE `Quest_ID` = '"+.@QuestID[.@Slot]+"'");
  154. }else{
  155. for( set .@i,1; .@i <= 5; set .@i,.@i + 1 )
  156. if( getd(".@Tar"+.@i+"_ID") < getd(".@Tar"+.@i+"_Qty") ){
  157. mes "[ "+getd(".@Tar"+.@i+"_ID")+"/"+getd(".@Tar"+.@i+"_Qty")+" ] "+getitemname( getd(".@Tar"+.@i+"_ID") );
  158. set .@Insufficient,1;
  159. }
  160. if( countitem( getd(".@Item"+.@i+"_ID") ) < getd(".@Tar"+.@i+"_Qty") ){
  161. mes "[ "+countitem( getd(".@Tar"+.@i+"_ID") )+"/"+getd(".@Tar"+.@i+"_Qty")+" ] "+getitemname( getd(".@Tar"+.@i+"_ID") );
  162. set .@Insufficient,1;
  163. }
  164.  
  165. break;
  166. Case 2:
  167. query_sql("DELETE FROM `CharQuest` WHERE `Quest_ID` = '"+.@QuestID[.@Slot]+"'");
  168. mes "Quest has been Removed from your Quest List.";
  169. break;
  170. }
  171.  
  172.  
  173.  
  174.  
  175.  
  176.  
  177.  
  178.  
  179.  
  180.  
  181.  
  182.  
  183.  
  184. }else{
  185.  
  186. }
  187. close;
  188.  
  189.  
  190.  
  191.  
  192.  
  193.  
  194. if( !.@quest ){
  195. mes "Sorry didnt have Available Quest";
  196. close;
  197. }
  198. mes "Choose your Desired Quest.";
  199. for( set .@i,0; .@i < .@quest; set .@i,.@i + 1 )
  200. set .@Menu$,.@Menu$ + .@AvailQuestName$[.@i]+":";
  201. next;
  202. set .@select,select( .@Menu$ ) - 1;
  203. query_sql("SELECT `Quest_Desc`,`Min_Lv`,`Max_Lv`,`Type`,`Time`,`Tar1_ID`,`Tar1_Qty`,`Tar2_ID`,`Tar2_Qty`,`Tar3_ID`,`Tar3_Qty`,`Tar4_ID`,`Tar4_Qty`,`Tar5_ID`,`Tar5_Qty`,`Item1_ID`,`Item1_Qty`,`Item2_ID`,`Item2_Qty`,`Item3_ID`,`Item3_Qty`,`Item4_ID`,`Item4_Qty`,`Item5_ID`,`Item5_Qty`,`Prz1_Name`,`Prz1_Qty`,`Prz2_Name`,`Prz2_Qty`,`Prz3_Name`,`Prz3_Qty`,`Prz4_Name`,`Prz4_Qty`,`Prz5_Name`,`Prz5_Qty` FROM `QuestList` WHERE `Quest_Name` = '"+.@AvailQuestName$[.@select]+"'", .@Desc$,.@Minlv,.@Maxlv,.@Type,.@Time,.@TarID1,.@TarIDQty1,.@TarID2,.@TarIDQty2,.@TarID3,.@TarIDQty3,.@TarID4,.@TarIDQty4,.@TarID5,.@TarIDQty5,.@ItmID1,.@ItmIDQty1,.@ItmID2,.@ItmIDQty2,.@ItmID3,.@ItmIDQty3,.@ItmID4,.@ItmIDQty4,.@ItmID5,.@ItmIDQty5,.@PrzID1,.@PrzIDQty1,.@PrzID2,.@PrzIDQty2,.@PrzID3,.@PrzIDQty3,.@PrzID4,.@PrzIDQty4,.@PrzID5,.@PrzIDQty5 );
  204. mes "Current Quest Info :";
  205. mes "^00FF00_______________________________^000000";
  206. mes "^0000FFQuest Name :^000000 "+.@AvailQuestName$[.@select];
  207. mes "^00FF00_______________________________^000000";
  208. mes "^0000FFDescription :^000000 "+.@Desc$;
  209. mes "^00FF00_______________________________^000000";
  210. switch( .@Type ){
  211. Case 1: mes "^0000FFQuest Type :^000000 Party"; break;
  212. Case 2: mes "^0000FFQuest Type :^000000 Guild"; break;
  213. Case 3: mes "^0000FFQuest Type :^000000 Personal"; break;
  214. default: break;
  215. }
  216. mes "^0000FFLevel Limitation :^000000 "+.@Minlv+" - "+.@Maxlv;
  217. TimeConvert( .@Time );
  218. if( .@TarID1 != 0 ){
  219. mes "^00FF00_______________________________^000000";
  220. mes "^0000FFTargeted Monster :^000000";
  221. for( set .@i,1; .@i <= 5 && getd( ".@TarID"+.@i ) != 0; set .@i,.@i + 1 )
  222. mes " "+getd( ".@TarIDQty"+.@i )+" x "+getmonsterinfo( getd( ".@TarID"+.@i ),0 );
  223. mes "^00FF00_______________________________^000000";
  224. }
  225. if( .@ItmID1 != 0 ){
  226. mes "^0000FFQuest Items :^000000";
  227. for( set .@i,1; .@i <= 5 && getd( ".@ItmID"+.@i ) != 0; set .@i,.@i + 1 )
  228. mes " "+getd( ".@ItmIDQty"+.@i )+" x "+getitemname( getd( ".@ItmID"+.@i ) );
  229. mes "^00FF00_______________________________^000000";
  230. }
  231. if( .@PrzID1 != 0 ){
  232. mes "^0000FFQuest Items :^000000";
  233. for( set .@i,1; .@i <= 5 && getd( ".@PrzID"+.@i ) != 0; set .@i,.@i + 1 )
  234. mes " "+getd( ".@PrzIDQty"+.@i )+" x "+getitemname( getd( ".@PrzID"+.@i ) );
  235. mes "^00FF00_______________________________^000000";
  236. }
  237.  
  238. set .@Option,select( "Accept Quest",
  239. ( getgmlevel() < .MinGMLevel )?"":"Modify Quest",
  240. ( getgmlevel() < .MinGMLevel )?"":"Delete Quest" );
  241.  
  242. query_sql("SELECT `Quest_ID` FROM `QuestList` WHERE `Quest_Name` = '"+.@AvailQuestName$[.@select]+"'",.@QuestID);
  243.  
  244. switch( .@Option ){
  245. Case 1:
  246. if( !getcharid( ( .@Type == 3 )?0:.@Type ) ){
  247. mes "Sorry this is a ";
  248. switch( .@Type ){
  249. Case 1: mes "^0000FFParty Quest^000000, so you need to have Party to pick this Quests"; break;
  250. Case 2: mes "^0000FFGuild Quest^000000, so you need to have Guild to pick this Quests"; break;
  251. Case 3: mes "^0000FFPersonal Quest^000000, so you need to have Character to pick this Quests"; break;
  252. default: break;
  253. }
  254. }else if( BaseLevel > .@Maxlv || BaseLevel < .@Minlv ){
  255. mes "Sorry, Base Level of Character must in the range of "+.@Minlv+" ~ "+.@Maxlv+" Level";
  256. }else if( query_sql("SELECT `*` WHERE `Char_ID` = '"+getcharid(0)+"' AND `Quest_ID` = '"+.@QuestID+"'") ){
  257. mes "Sorry, you have taken this Quest already.";
  258. }
  259.  
  260.  
  261.  
  262. break;
  263. Case 2:
  264. break;
  265. Case 3:
  266. query_sql("DELETE FROM `QuestList` WHERE `Quest_ID` = '"+.@QuestID+"'");
  267. // query_sql("DELETE FROM `CharQuest` WHERE `Quest_ID` = '"+.@QuestID+"'");
  268. mes "Quest has been Removed.";
  269. break;
  270.  
  271.  
  272.  
  273.  
  274.  
  275.  
  276. }
  277. close;
  278.  
  279. Case 2:
  280. do{
  281. next;
  282. mes "Current Quest Info :";
  283. mes "^00FF00_______________________________^000000";
  284. if( .@QuestName$ != "" ){
  285. mes "^0000FFQuest Name :^000000 "+.@QuestName$;
  286. mes "^00FF00_______________________________^000000";
  287. }
  288. if( .@QuestDesc$ != "" ){
  289. mes "^0000FFDescription :^000000 "+.@QuestDesc$;
  290. mes "^00FF00_______________________________^000000";
  291. }
  292. switch( .@QuestType ){
  293. Case 1: mes "^0000FFQuest Type :^000000 Party"; break;
  294. Case 2: mes "^0000FFQuest Type :^000000 Guild"; break;
  295. Case 3: mes "^0000FFQuest Type :^000000 Personal"; break;
  296. default: break;
  297. }
  298. if( getarraysize( .@QuestLvl ) ) mes "^0000FFLevel Limitation :^000000 "+.@QuestLvl[0]+" - "+.@QuestLvl[1];
  299. if( .@QuestTime ) TimeConvert( .@QuestTime );
  300. if( .@QuestType || getarraysize( .@QuestLvl ) || .@QuestTime ) mes "^00FF00_______________________________^000000";
  301.  
  302. if( getarraysize( .@QuestMobs ) ){
  303. mes "^0000FFTargeted Monster :^000000";
  304. for( set .@i,0; .@i < getarraysize( .@QuestMobs ) && .@QuestMobs[.@i] != 0; set .@i,.@i + 1 )
  305. mes " "+.@QuestMobsQty[.@i]+" x "+getmonsterinfo( .@QuestMobs[.@i],0 );
  306. mes "^00FF00_______________________________^000000";
  307. }
  308. if( getarraysize( .@QuestItems ) ){
  309. mes "^0000FFQuest Items :^000000";
  310. for( set .@i,0; .@i < getarraysize( .@QuestItems ) && getitemname( .@QuestItems[.@i] ) != "null"; set .@i,.@i + 1 )
  311. mes " "+.@QuestItemsQty[.@i]+" x "+getitemname( .@QuestItems[.@i] );
  312. mes "^00FF00_______________________________^000000";
  313. }
  314. if( getarraysize( .@Prizes ) && .@Prizes[0] ){
  315. mes "^0000FFQuest Rewards :^000000";
  316. for( set .@i,0; .@i < getarraysize( .@Prizes ) && .@Prizes[0]; set .@i,.@i + 1 )
  317. mes " "+.@PrizesQty[.@i]+" x "+getitemname( .@Prizes[.@i] );
  318. mes "^00FF00_______________________________^000000";
  319. }
  320. next;
  321. set .@QuestSetup,select(( .@QuestName$ == "" )?"^FF0000Name":"[ ^0000FFComplete^000000 ] Name",
  322. ( .@QuestDesc$ == "" )?"^FF0000Description":"[ ^0000FFComplete^000000 ] Description",
  323. ( !getarraysize( .@QuestLvl ) )?"^FF0000Level Limitation":"[ ^0000FFComplete^000000 ] Level Limitation",
  324. ( !.@QuestType )?"^FF0000Quest Type":"[ ^0000FFComplete^000000 ] Quest Type",
  325. ( !.@QuestTime )?"^FF0000Time Limitation":"[ ^0000FFComplete^000000 ] Time Limitation",
  326. ( !getarraysize( .@QuestMobs ) )?"^FF0000Required Monsters":"[ ^0000FFComplete^000000 ] Required Monsters",
  327. ( !getarraysize( .@QuestItems ) )?"^FF0000Required Items":"[ ^0000FFComplete^000000 ] Required Items",
  328. ( !getarraysize( .@Prizes ) || !.@Prizes[0] )?"^FF0000Rewards":"[ ^0000FFComplete^000000 ] Rewards",
  329. ( .@QuestName$ == "" || .@QuestDesc$ == "" || !.@QuestLvl[1] || .@QuestType < 0 || .@QuestTime < 0 ||
  330. ( !.@QuestMobs[0] && !.@QuestItems[0] ) || !.@Prizes[0] )?"":"^FF0000Publish Completed Quest" );
  331.  
  332. switch( .@QuestSetup ){
  333. Case 1:
  334. mes "Input the Name of the Quest.";
  335. input .@QuestName$;
  336. break;
  337. Case 2:
  338. mes "Input a Description for your Quests.";
  339. set .@a,0;
  340. do{
  341. mes "Description "+(.@a+1)+"...";
  342. input getd(".@Desc"+.@a+"$");
  343. set .@QuestDesc$,.@QuestDesc$+" "+ getd(".@Desc"+.@a+"$");
  344. set .@a,.@a + 1;
  345. }while( select("Next Description:^0000FFFinish^000000") == 1 );
  346. break;
  347. Case 3:
  348. do{
  349. mes "Input the Minimum Level Requirement";
  350. input .@QuestLvl[0],1,getbattleflag("max_lv");
  351. mes "Input the Maximum Level Requirement";
  352. input .@QuestLvl[1],.@QuestLvl[0],getbattleflag("max_lv");
  353. if( .@QuestLvl[1] < .@QuestLvl[0] ){
  354. mes "^FF0000Please make sure Max. Level is Higher than Min. Level^000000";
  355. next;
  356. }
  357. }while( .@QuestLvl[1] < .@QuestLvl[0] );
  358. break;
  359. Case 4:
  360. mes "Select Quest Type :";
  361. mes "1 - Party";
  362. mes "2 - Guild";
  363. mes "3 - Player";
  364. input .@QuestType,1,3;
  365. break;
  366. Case 5:
  367. mes "Insert Quest Time Limitation";
  368. mes "0 - 365 Days ? ";
  369. input .@Time[0],0,365;
  370. mes "0 - 23 Hours ?";
  371. input .@Time[1],0,23;
  372. mes "0 - 59 Minutes ?";
  373. input .@Time[2],0,59;
  374. set .@QuestTime,( .@Time[2] * 60 ) + ( .@Time[1] * 3600 ) + ( .@Time[0] * 86400 );
  375. break;
  376. Case 6:
  377. dispbottom "[ Quest Setup Reminder ] : Wrong / Invalid Data will SPAM your server with ERROR Message.";
  378. for( set .@i,0; .@i < 5; set .@i,.@i + 1 ){
  379. mes "Input ^FF0000Monster "+( .@i+1 )+"^000000 ID :";
  380. mes "0 = Cancel / Stop";
  381. do{
  382. input .@QuestMobs[.@i];
  383. if( !.@QuestMobs[.@i] ) break;
  384. }while(getmonsterinfo( .@QuestMobs[.@i],0 ) == "null" || getmonsterinfo( .@QuestMobs[.@i],0 ) == "" );
  385. if( !.@QuestMobs[.@i] ) break;
  386. mes "Required ^FF0000"+getmonsterinfo( .@QuestMobs[.@i],0 )+"^000000 Kill :";
  387. input .@QuestMobsQty[.@i],1,30000;;
  388. next;
  389. }
  390. break;
  391. Case 7:
  392. dispbottom "[ Quest Setup Reminder ] : Wrong / Invalid Data will SPAM your server with ERROR Message.";
  393. for( set .@i,0; .@i < 5; set .@i,.@i + 1 ){
  394. mes "Input ^FF0000Item "+( .@i+1 )+"^000000 ID :";
  395. mes "0 = Cancel / Stop";
  396. do{
  397. input .@QuestItems[.@i];
  398. if( !.@QuestItems[.@i] ) break;
  399. }while( getitemname( .@QuestItems[.@i] ) == "null" || getitemname( .@QuestItems[.@i] ) == "" );
  400. if( !.@QuestItems[.@i] ) break;
  401. mes "Required ^FF0000"+getitemname( .@QuestItems[.@i] )+"^000000 Amount :";
  402. input .@QuestItemsQty[.@i],1,30000;;
  403. next;
  404. }
  405. break;
  406. Case 8:
  407. dispbottom "[ Quest Setup Reminder ] : Wrong / Invalid Data will SPAM your server with ERROR Message.";
  408. for( set .@i,0; .@i < 5; set .@i,.@i + 1 ){
  409. mes "Input ^FF0000Prize "+( .@i+1 )+"^000000 ID :";
  410. mes "0 = Cancel / Stop";
  411. do{
  412. input .@Prizes[.@i];
  413. if( !.@Prizes[.@i] ) break;
  414. }while( getitemname( .@Prizes[.@i] ) == "null" );
  415. if( !.@Prizes[.@i] ) break;
  416. mes "Input Prize Amount :";
  417. input .@PrizesQty[.@i],1,30000;
  418. next;
  419. }
  420. break;
  421.  
  422. default: break;
  423. break;
  424. }
  425.  
  426. }while( .@QuestSetup != 9 );
  427. query_sql("INSERT INTO `QuestList` (`Quest_Name`, `Quest_Desc`, `Min_Lv`, `Max_Lv`, `Type`, `Time`,`Tar1_ID`, `Tar1_Qty`, `Tar2_ID`, `Tar2_Qty`, `Tar3_ID`, `Tar3_Qty`, `Tar4_ID`, `Tar4_Qty`, `Tar5_ID`, `Tar5_Qty`,`Item1_ID`, `Item1_Qty`, `Item2_ID`, `Item2_Qty`, `Item3_ID`, `Item3_Qty`, `Item4_ID`, `Item4_Qty`, `Item5_ID`, `Item5_Qty`,`Prz1_Name`, `Prz1_Qty`, `Prz2_Name`, `Prz2_Qty`, `Prz3_Name`, `Prz3_Qty`, `Prz4_Name`, `Prz4_Qty`, `Prz5_Name`, `Prz5_Qty`)VALUES ('"+.@QuestName$+"', '"+.@QuestDesc$+"', "+.@QuestLvl[0]+", "+.@QuestLvl[1]+", "+.@QuestType+", "+.@QuestTime+","+.@QuestMobs[0]+", "+.@QuestMobsQty[0]+", "+.@QuestMobs[1]+", "+.@QuestMobsQty[1]+","+.@QuestMobs[2]+", "+.@QuestMobsQty[2]+","+.@QuestMobs[3]+", "+.@QuestMobsQty[3]+","+.@QuestMobs[4]+", "+.@QuestMobsQty[4]+","+.@QuestItems[0]+", "+.@QuestItemsQty[0]+", "+.@QuestItems[1]+", "+.@QuestItemsQty[1]+","+.@QuestItems[2]+", "+.@QuestItemsQty[2]+","+.@QuestItems[3]+", "+.@QuestItemsQty[3]+","+.@QuestItems[4]+", "+.@QuestItemsQty[4]+","+.@Prizes[0]+", "+.@PrizesQty[0]+", "+.@Prizes[1]+", "+.@PrizesQty[1]+","+.@Prizes[2]+", "+.@PrizesQty[2]+","+.@Prizes[3]+", "+.@PrizesQty[3]+","+.@Prizes[4]+", "+.@PrizesQty[4]+" ); ");
  428. message strcharinfo(0),"New Quest has been Added.";
  429. break;
  430.  
  431. Case 3:
  432. default:
  433. break;
  434. }
  435.  
  436. close;
  437.  
  438.  
  439. function TimeConvert {
  440. set .@left,getarg(0);
  441. set .@day, .@left / 86400;
  442. set .@hour, .@left % 86400 / 3600;
  443. set .@min, .@left % 3600 / 60;
  444. set .@sec, .@left % 60;
  445. mes "^0000FFTime Limit :^FF0000 "+( (.@day < 10)?"0"+.@day+" Day":.@day+" Day" )+" : ^FF0000"+( (.@hour < 10)?"0"+.@hour:.@hour )+":"+( (.@min < 10)?"0"+.@min:.@min )+":"+( (.@sec < 10)?"0"+.@sec:.@sec )+"^000000";
  446.  
  447. return;
  448. }
  449.  
  450. }
Advertisement
Comments
  • User was banned
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!