Squish the squash (SQL Help)
Posted: Tue Mar 02, 2010 5:49 pm
If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:
Hello. ive just put all the files for the squish the squash event into my database but the sql doesnt want to go in. ive tried tweaking it but still wont go in. would anyone please have alook for me thanks.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:
Hello. ive just put all the files for the squish the squash event into my database but the sql doesnt want to go in. ive tried tweaking it but still wont go in. would anyone please have alook for me thanks.
Code: Select all
REPLACE INTO `etcitem` VALUES (6389,'Squash Seed','false','none','0','stackable','paper','none','-1','-1','0','0','true','false','true','true','SummonItems','2003-1;'),REPLACE INTO `etcitem` VALUES (6390,'Large Squash Seed','false','none',0,'stackable','paper','none',-1,-1,0,0,'true','false','true','true','SummonItems','2004-1;'),REPLACE INTO `etcitem` VALUES (6391,'Nectar','false','none',0,'stackable','paper','none',-1,-1,0,0,'true','true','true','true','ItemSkills','2005-1;'); REPLACE INTO `npc` VALUES (12774, 12774, 'Young Squash', 0, '', 0, 'NPC.drop_gourd_50_sm', 11.00, 11.00, 85, 'etc', 'L2Monster', 40, 1580, 0, 1.42, 0.00, 40, 43, 30, 21, 20, 10, 0, 0, 4, 41, 3, 33, 278, 0, 333, 0, 0, 0, 1, 1, 'NULL', 0, 1, 0, 'LAST_HIT', 0, 0, 0, 'balanced', 'false'),REPLACE INTO `npc` VALUES (12775, 12775, 'High Quality Squash', 0, '', 0, 'NPC.drop_gourd', 25.00, 25.00, 85, 'etc', 'L2Monster', 40, 2050, 0, 1.42, 0.00, 40, 43, 30, 21, 20, 10, 0, 0, 4, 41, 3, 33, 278, 0, 333, 0, 0, 0, 0, 0, 'NULL', 0, 1, 0, 'LAST_HIT', 0, 0, 0, 'balanced', 'false'),REPLACE INTO `npc` VALUES (12776, 12776, 'Low Quality Squash', 0, '', 0, 'NPC.drop_gourd_25_sm', 18.00, 18.00, 85, 'etc', 'L2Monster', 40, 2050, 0, 1.42, 0.00, 40, 43, 30, 21, 20, 10, 0, 0, 4, 41, 3, 33, 278, 0, 333, 0, 0, 0, 0, 0, 'NULL', 0, 1, 0, 'LAST_HIT', 0, 0, 0, 'balanced', 'false'),REPLACE INTO `npc` VALUES (12777, 12777, 'Large Young Squash', 0, '', 0, 'NPC.drop_gourd', 25.00, 25.00, 85, 'etc', 'L2Monster', 40, 1580, 0, 1.42, 0.00, 40, 43, 30, 21, 20, 10, 0, 0, 4, 41, 3, 33, 278, 0, 333, 0, 0, 0, 1, 1, 'NULL', 0, 1, 0, 'LAST_HIT', 0, 0, 0, 'balanced', 'false'),REPLACE INTO `npc` VALUES (12778, 12778, 'High Quality Large Squash', 0, '', 0, 'NPC.drop_gourd_50_bi', 40.00, 40.00, 85, 'etc', 'L2Monster', 40, 2050, 0, 1.42, 0.00, 40, 43, 30, 21, 20, 10, 0, 0, 4, 41, 3, 33, 278, 0, 333, 0, 0, 0, 0, 0, 'NULL', 0, 1, 0, 'LAST_HIT', 0, 0, 0, 'balanced', 'false'),REPLACE INTO `npc` VALUES (12779, 12779, 'Low Quality Large Squash', 0, '', 0, 'NPC.drop_gourd_25_bi', 32.00, 32.00, 85, 'etc', 'L2Monster', 40, 2050, 0, 1.42, 0.00, 40, 43, 30, 21, 20, 10, 0, 0, 4, 41, 3, 33, 278, 0, 333, 0, 0, 0, 0, 0, 'NULL', 0, 1, 0, 'LAST_HIT', 0, 0, 0, 'balanced', 'false'),REPLACE INTO `npc` VALUES (13016, 13016, 'King Squash', 0, '', 0, 'NPC.drop_gourd', 25.00, 25.00, 85, 'etc', 'L2Monster', 40, 4608, 1896, 80.58, 3.09, 40, 43, 30, 21, 20, 10, 7133, 810, 2255, 534, 1731, 433, 278, 0, 333, 0, 0, 0, 0, 0, 'NULL', 0, 0, 0, 'LAST_HIT', 0, 0, 0, 'balanced', 'false'),REPLACE INTO `npc` VALUES (13017, 13017, 'Emperor Squash', 0, '', 0, 'NPC.drop_gourd_50_bi', 40.00, 40.00, 85, 'etc', 'L2Monster', 40, 4608, 1896, 80.58, 3.09, 40, 43, 30, 21, 20, 10, 7557, 858, 2255, 534, 1731, 433, 278, 0, 333, 0, 0, 0, 0, 0, 'NULL', 0, 0, 0, 'LAST_HIT', 0, 0, 0, 'balanced', 'false'); UPDATE weapon SET p_dam = 50 WHERE item_id = 4202,UPDATE weapon SET p_dam = 50 WHERE item_id = 5133,UPDATE weapon SET p_dam = 50 WHERE item_id = 5817,UPDATE weapon SET p_dam = 50 WHERE item_id = 7058,UPDATE weapon SET p_dam = 50 WHERE item_id = 8350; INSERT INTO `npc` VALUES ('90010', '32100', 'Squash Cat', '1', 'Event Manager', '1', 'Monster2.queen_of_cat', '8.00', '15.00', '70', 'female', 'L2Merchant', '40', '3862', '1493', NULL , NULL , '40', '43', '30', '21', '20', '10', '0', '0', '1314', '470', '780', '382', '278', '0', '253', '0', '0', '0', '80', '120', NULL , '0', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false');