This is the scripts for +50, +100, +255 itemsets Equipments for all classes in shopping mall, all you have to do is edit the item id's to your own ones.
+50 ItemSet:
Code:
INSERT INTO `cq_action` VALUES ('70000524', '70000525', '70000539', '1001', '0', 'profession == 10'); INSERT INTO `cq_action` VALUES ('70000525', '70000526', '0000', '0502', '1021083', ''); INSERT INTO `cq_action` VALUES ('70000526', '70000527', '0000', '0501', '440244', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000527', '70000528', '0000', '0501', '165134', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000528', '70000529', '0000', '0501', '135154', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000529', '70000530', '0000', '0501', '145154', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000530', '70000531', '0000', '0501', '125154', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000531', '70000532', '0000', '0501', '115154', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000532', '70000533', '0000', '1010', '2005', 'Congratulations! You got your Super+50 Items!'); INSERT INTO `cq_action` VALUES ('70000533', '0', '0000', '0506', '0', '1021083 1021083 1'); INSERT INTO `cq_action` VALUES ('70000539', '70000540', '70000547', '1001', '0', 'profession == 20'); INSERT INTO `cq_action` VALUES ('70000540', '70000541', '0000', '0502', '1021083', ''); INSERT INTO `cq_action` VALUES ('70000541', '70000542', '0000', '0501', '420244', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000542', '70000543', '0000', '0501', '161134', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000543', '70000544', '0000', '0501', '131154', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000544', '70000545', '0000', '0501', '141154', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000545', '70000546', '0000', '0501', '121154', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000546', '70000532', '0000', '0501', '111154', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000547', '70000548', '0000', '1001', '0', 'profession == 30'); INSERT INTO `cq_action` VALUES ('70000548', '70000549', '0000', '0502', '1021083', ''); INSERT INTO `cq_action` VALUES ('70000549', '70000550', '0000', '0501', '490244', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000550', '70000551', '0000', '0501', '163134', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000551', '70000552', '0000', '0501', '133144', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000552', '70000553', '0000', '0501', '143154', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000553', '70000554', '0000', '0501', '123144', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000554', '70000532', '0000', '0501', '113144', '0 0 0 18 18 0 0 50 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('70000520', '70000521', '70000522', '0508', '0', '6 0 50'); INSERT INTO `cq_action` VALUES ('70000521', '70000524', '70000523', '0508', '0', '1 0 52'); INSERT INTO `cq_action` VALUES ('70000522', '0000', '0000', '1010', '2005', 'Please~leve~6~free~invetory~slots'); INSERT INTO `cq_action` VALUES ('70000523', '0000', '0000', '1010', '2005', 'asks~your~excellency~to~recognize~that~the~Eudemons~egg~knapsack~has~1~space,~because~we~will~deliver~a~lovable~baby~to~give~yo'); INSERT INTO `cq_itemtype` VALUES ('1021083', 'Top50Gears', '0', '0', '0', '0', '0', '0', '0', '0', '17', '0', '0', '70000520', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '500000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
Code:
INSERT INTO `cq_action` VALUES ('80000524', '80000525', '80000539', '1001', '0', 'profession == 10'); INSERT INTO `cq_action` VALUES ('80000525', '80000526', '0000', '0502', '1021084', ''); INSERT INTO `cq_action` VALUES ('80000526', '80000527', '0000', '0501', '440244', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000527', '80000528', '0000', '0501', '165134', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000528', '80000529', '0000', '0501', '135154', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000529', '80000530', '0000', '0501', '145154', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000530', '80000531', '0000', '0501', '125154', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000531', '80000532', '0000', '0501', '115154', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000532', '80000533', '0000', '1010', '2005', 'Congratulations! You got your Super+100 Items!'); INSERT INTO `cq_action` VALUES ('80000533', '0', '0000', '0506', '0', '1021084 1021084 1'); INSERT INTO `cq_action` VALUES ('80000539', '80000540', '80000547', '1001', '0', 'profession == 20'); INSERT INTO `cq_action` VALUES ('80000540', '80000541', '0000', '0502', '1021084', ''); INSERT INTO `cq_action` VALUES ('80000541', '80000542', '0000', '0501', '420244', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000542', '80000543', '0000', '0501', '161134', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000543', '80000544', '0000', '0501', '131154', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000544', '80000545', '0000', '0501', '141154', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000545', '80000546', '0000', '0501', '121154', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000546', '80000532', '0000', '0501', '111154', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000547', '80000548', '0000', '1001', '0', 'profession == 30'); INSERT INTO `cq_action` VALUES ('80000548', '80000549', '0000', '0502', '1021084', ''); INSERT INTO `cq_action` VALUES ('80000549', '80000550', '0000', '0501', '490244', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000550', '80000551', '0000', '0501', '163134', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000551', '80000552', '0000', '0501', '133144', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000552', '80000553', '0000', '0501', '143154', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000553', '80000554', '0000', '0501', '123144', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000554', '80000532', '0000', '0501', '113144', '0 0 0 18 18 0 0 100 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('80000520', '80000521', '80000522', '0508', '0', '6 0 50'); INSERT INTO `cq_action` VALUES ('80000521', '80000524', '80000523', '0508', '0', '1 0 52'); INSERT INTO `cq_action` VALUES ('80000522', '0000', '0000', '1010', '2005', 'Please~leve~6~free~invetory~slots'); INSERT INTO `cq_action` VALUES ('80000523', '0000', '0000', '1010', '2005', 'asks~your~excellency~to~recognize~that~the~Eudemons~egg~knapsack~has~1~space,~because~we~will~deliver~a~lovable~baby~to~give~yo'); INSERT INTO `cq_itemtype` VALUES ('1021084', 'Top100Gears', '0', '0', '0', '0', '0', '0', '0', '0', '17', '0', '0', '80000520', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '1000000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
Code:
INSERT INTO `cq_action` VALUES ('6000524', '6000525', '6000539', '1001', '0', 'profession == 10'); INSERT INTO `cq_action` VALUES ('6000525', '6000526', '0000', '0502', '729012', ''); INSERT INTO `cq_action` VALUES ('6000526', '6000527', '0000', '0501', '440244', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000527', '6000528', '0000', '0501', '165134', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000528', '6000529', '0000', '0501', '135154', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000529', '6000530', '0000', '0501', '145154', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000530', '6000531', '0000', '0501', '125154', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000531', '6000532', '0000', '0501', '115154', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000532', '6000533', '0000', '1010', '2005', 'Congratulations! You got your Super+255 Items!'); INSERT INTO `cq_action` VALUES ('6000533', '0', '0000', '0506', '0', '729012 729012 1'); INSERT INTO `cq_action` VALUES ('6000539', '6000540', '6000547', '1001', '0', 'profession == 20'); INSERT INTO `cq_action` VALUES ('6000540', '6000541', '0000', '0502', '729012', ''); INSERT INTO `cq_action` VALUES ('6000541', '6000542', '0000', '0501', '420244', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000542', '6000543', '0000', '0501', '161134', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000543', '6000544', '0000', '0501', '131154', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000544', '6000545', '0000', '0501', '141154', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000545', '6000546', '0000', '0501', '121154', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000546', '6000532', '0000', '0501', '111154', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000547', '6000548', '0000', '1001', '0', 'profession == 30'); INSERT INTO `cq_action` VALUES ('6000548', '6000549', '0000', '0502', '729012', ''); INSERT INTO `cq_action` VALUES ('6000549', '6000550', '0000', '0501', '490244', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000550', '6000551', '0000', '0501', '163134', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000551', '6000552', '0000', '0501', '133144', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000552', '6000553', '0000', '0501', '143154', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000553', '6000554', '0000', '0501', '123144', '0 0 0 18 18 0 0 255 0 1024 0 0'); INSERT INTO `cq_action` VALUES ('6000554', '6000532', '0000', '0501', '113144', '0 0 0 18 18 0 0 255 0 1024 0 0');
*For +50 and +100 ItemSets you have to create two items in itemtype.dat with id 1021083(for +50) and 1021084(for +100)
*Add all those three to the mall on cq_goods with owner 1207 if you want them available for sale.
Client side, ANI files:
ItemMinIcon
Code:
[Item1021083] FrameAmount=1 Frame0=data/ItemMinIcon/729000.dds [Item1021084] FrameAmount=1 Frame0=data/ItemMinIcon/729000.dds
Code:
[1021083] FrameAmount=1 Frame0=data/MapItemIcon/729000.dds [1021084] FrameAmount=1 Frame0=data/MapItemIcon/729000.dds