lvl up item

12/10/2010 09:01 track19#1
can someone tell me the query how to get up 1 or 5 lvl potion
12/10/2010 09:08 San-Goku#2
why wont u use search button

Code:
-- ----------------------------
-- 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
12/10/2010 09:10 ~Sword~Stalker~.#3
Quote:
Originally Posted by track19 View Post
can someone tell me the query how to get up 1 or 5 lvl potion
Query :

Code:
-- ----------------------------
-- 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

[Only registered and activated users can see links. Click Here To Register...]


Regards
12/10/2010 09:10 track19#4
do i have to add anything to client
12/10/2010 09:14 San-Goku#5
god u so N**B

[Only registered and activated users can see links. Click Here To Register...]

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

USE SEARCH BUTTON
12/10/2010 09:24 track19#6
oo sorry
12/10/2010 10:17 magewarior2#7
may i ask why this?

Code:
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 ....
12/11/2010 00:34 alxandr2#8
good work thanks
12/11/2010 23:47 T.h.u.n.d.e.r#9
Quote:
Originally Posted by magewarior2 View Post
may i ask why this?

Code:
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
12/13/2010 11:36 magewarior2#10
so why not use | > 251 | ???
12/13/2010 19:13 T.h.u.n.d.e.r#11
Quote:
Originally Posted by magewarior2 View Post
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 :)