Help I Need query ...........................

08/28/2011 14:35 Sam[PM]#1
Hello Every One I Need query Gears 255+ And query High Compsing
08/28/2011 14:50 javairc#2
use search button..
08/28/2011 15:00 MoŽtalKing#3
wrong section i will help you this once but try to post ur question in right section next time

gears +255

Code:
[COLOR="Blue"]delete from cq_action where id >= 6000524 and id <= 6000532;
delete from cq_action where id >= 6000539 and id <= 6000546;
delete from cq_action where id >= 6000547 and id <= 6000554;



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', '135114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000528', '6000529', '0000', '0501', '115114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000529', '6000530', '0000', '0501', '125114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000530', '6000531', '0000', '0501', '145114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000531', '6000532', '0000', '0501', '165094', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000532', '0', '0000', '1010', '2005', 'Congratulations! You got your Super+255 Gift Items!');
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', '131114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000543', '6000544', '0000', '0501', '111114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000544', '6000545', '0000', '0501', '121114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000545', '6000546', '0000', '0501', '141114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000546', '6000532', '0000', '0501', '161094', '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', '163094', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000550', '6000551', '0000', '0501', '143114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000551', '6000552', '0000', '0501', '133114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000552', '6000553', '0000', '0501', '123114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000553', '6000554', '0000', '0501', '113114', '0 0 0 18 18 0 0 255 0 1024 0 0');
INSERT INTO `cq_action` VALUES ('6000554', '6000532', '0000', '0501', '490244', '0 0 0 18 18 0 0 255 0 1024 0 0');

delete from cq_itemtype where id >= 1021085 and id <= 1021085;
INSERT INTO `cq_itemtype` VALUES ('1021085', 'Top255Gears', '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');[/COLOR]
composs rate

Code:
[COLOR="Blue"]UPDATE `cq_eudemon_rbn_rqr` SET max = max + [COLOR="Red"]5[/COLOR];
UPDATE `cq_eudemon_rbn_rqr` SET min = min + [COLOR="Red"]5[/COLOR];[/COLOR]
red color is the additional mark .. like ur composs rate is 20 this query will make it 25 and if you want it less change (+) to (-)

credits to CyberServer (+255 gears) and pradevil (composs rate query )
08/29/2011 00:21 pretzel666#4
What Mortal Said lol =P
And GoodLuck Sam :)
08/29/2011 08:37 Marcus*#5
sam in future when asking questions [Only registered and activated users can see links. Click Here To Register...] because the part of the forum you keep asking in atm is only for guides and releases