lvl up item

[track19]

can someone tell me the query how to get up 1 or 5 lvl potion

[San-Goku]

why wont u use search button

-- ----------------------------
-- cq_itemtype
-- ----------------------------


INSERT INTO `cq_itemtype` VALUES ('742000', 'WarSoul+1', '0', '0', '0', '0', '0', '0', '0', '0', '28', '0', '0', '15000000', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '100000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('742001', 'WarSoul+5', '0', '0', '0', '0', '0', '0', '0', '0', '28', '0', '0', '15000005', '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');


-- ----------------------------
-- cq_action
-- ----------------------------


delete from cq_action where id >= 15000000 and id <= 150000009;
INSERT INTO `cq_action` VALUES ('15000000', '15000004', '15000001', '1001', '0', 'level == 255');
INSERT INTO `cq_action` VALUES ('15000001', '15000002', '0', '1001', '0', 'level += 1');
INSERT INTO `cq_action` VALUES ('15000002', '15000003', '0', '0502', '742000', '0');
INSERT INTO `cq_action` VALUES ('15000003', '0', '0', '126', '0', 'Congratulations,~you~gain~1~extra~level!');
INSERT INTO `cq_action` VALUES ('15000004', '0', '0', '126', '0', 'You~have~reached~max~Level!!');
INSERT INTO `cq_action` VALUES ('15000005', '15000009', '15000006', '1001', '0', 'level == 255 level == 251 level == 251 level == 251 level == 251');
INSERT INTO `cq_action` VALUES ('15000006', '15000007', '0', '1001', '0', 'level += 5');
INSERT INTO `cq_action` VALUES ('15000007', '15000008', '0', '0502', '742001', '0');
INSERT INTO `cq_action` VALUES ('15000008', '0', '0', '126', '0', 'Congratulations,~you~gain~5~extra~levels!');
INSERT INTO `cq_action` VALUES ('15000009', '0', '0', '126', '0', 'Your~level~almost~max.~Please~use~WarSoul+1l!!');


-- ----------------------------
-- Add in itemtype.dat id 742000 and 742001 and ur done.
-- ----------------------------

zzzzzzzzzzzzzzz

[~Sword~Stalker~.]

Originally Posted by track19

can someone tell me the query how to get up 1 or 5 lvl potion

Query :

-- ----------------------------
-- cq_itemtype
-- ----------------------------


INSERT INTO `cq_itemtype` VALUES ('742000', 'WarSoul+1', '0', '0', '0', '0', '0', '0', '0', '0', '28', '0', '0', '15000000', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '00', '00', '00', '0000', '0000', '0', '0', '100000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `cq_itemtype` VALUES ('742001', 'WarSoul+5', '0', '0', '0', '0', '0', '0', '0', '0', '28', '0', '0', '15000005', '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');


-- ----------------------------
-- cq_action
-- ----------------------------


delete from cq_action where id >= 15000000 and id <= 150000009;
INSERT INTO `cq_action` VALUES ('15000000', '15000004', '15000001', '1001', '0', 'level == 255');
INSERT INTO `cq_action` VALUES ('15000001', '15000002', '0', '1001', '0', 'level += 1');
INSERT INTO `cq_action` VALUES ('15000002', '15000003', '0', '0502', '742000', '0');
INSERT INTO `cq_action` VALUES ('15000003', '0', '0', '126', '0', 'Congratulations,~you~gain~1~extra~level!');
INSERT INTO `cq_action` VALUES ('15000004', '0', '0', '126', '0', 'You~have~reached~max~Level!!');
INSERT INTO `cq_action` VALUES ('15000005', '15000009', '15000006', '1001', '0', 'level == 255 level == 251 level == 251 level == 251 level == 251');
INSERT INTO `cq_action` VALUES ('15000006', '15000007', '0', '1001', '0', 'level += 5');
INSERT INTO `cq_action` VALUES ('15000007', '15000008', '0', '0502', '742001', '0');
INSERT INTO `cq_action` VALUES ('15000008', '0', '0', '126', '0', 'Congratulations,~you~gain~5~extra~levels!');
INSERT INTO `cq_action` VALUES ('15000009', '0', '0', '126', '0', 'Your~level~almost~max.~Please~use~WarSoul+1l!!');


-- ----------------------------
-- Add in itemtype.dat id 742000 and 742001 and ur done.
-- ----------------------------

and u need to go and download the file




Regards

[track19]

do i have to add anything to client

[San-Goku]

*** u so N**B



already release...zzzzzzz.............

USE SEARCH BUTTON

[track19]

oo sorry

[magewarior2]

may i ask why this?

INSERT INTO `cq_action` VALUES ('15000005', '15000009', '15000006', '1001', '0', '[COLOR="Red"]level == 255 level == 251 level == 251 level == 251 level == 251[/COLOR]');

some 1 explains? I`ve never seen it before ....

[alxandr2]

good work thanks

[T.h.u.n.d.e.r]

Originally Posted by magewarior2

may i ask why this?

INSERT INTO `cq_action` VALUES ('15000005', '15000009', '15000006', '1001', '0', '[COLOR="Red"]level == 255 level == 251 level == 251 level == 251 level == 251[/COLOR]');

some 1 explains? I`ve never seen it before ....

This would help in +5 lvls potion and this mean thats you cant use this item in this lvls which is 255 .254 .253 .252 and 251 which mean you can use it in all existing lvls but cant with those lvls apove

[magewarior2]

so why not use | > 251 | ???

[T.h.u.n.d.e.r]

Originally Posted by magewarior2

so why not use | > 251 | ???

Yup this is easier than the one apove also have the same effect can be used under this lvl , every one has his own style