my db got pkt bug.it cant change map after 30 minutes,cant claim prizes and so on .i've found this query using search mode .
Code:
PkTour Boxes Fix: By Noneatall
use my;
delete from cq_action where id ='3911910';
delete from cq_action where id ='3911911';
delete from cq_action where id ='3911912';
delete from cq_action where id ='3911913';
delete from cq_action where id ='3911914';
delete from cq_action where id ='3911915';
delete from cq_action where id ='3911916';
delete from cq_action where id ='3911940';
delete from cq_action where id ='3911941';
delete from cq_action where id ='3911942';
delete from cq_action where id ='3911943';
delete from cq_action where id ='3911944';
delete from cq_action where id ='3911945';
delete from cq_action where id ='3911946';
delete from cq_action where id ='3911200';
delete from cq_action where id ='3911201';
delete from cq_action where id ='3911202';
delete from cq_action where id ='3911203';
delete from cq_action where id ='3911204';
delete from cq_action where id ='3911205';
delete from cq_action where id ='3911206';
delete from cq_action where id ='3911207';
delete from cq_action where id ='3911208';
delete from cq_action where id ='3911209';
delete from cq_action where id ='3911210';
delete from cq_action where id ='3911211';
delete from cq_action where id ='3911970';
delete from cq_action where id ='3911971';
delete from cq_action where id ='3911972';
delete from cq_action where id ='3911973';
delete from cq_action where id ='3911974';
delete from cq_action where id ='3911975';
delete from cq_action where id ='3911976';
delete from cq_action where id ='3911977';
delete from cq_action where id ='3912000';
delete from cq_action where id ='3912001';
delete from cq_action where id ='3912002';
delete from cq_action where id ='3912003';
delete from cq_action where id ='3912004';
delete from cq_action where id ='3912005';
delete from cq_action where id ='3912006';
delete from cq_action where id ='3912007';
delete from cq_action where id ='3912008';
delete from cq_action where id ='3912009';
delete from cq_action where id ='3912010';
delete from cq_action where id ='3912011';
delete from cq_action where id ='3912030';
delete from cq_action where id ='3912031';
delete from cq_action where id ='3912032';
delete from cq_action where id ='3912033';
delete from cq_action where id ='3912034';
delete from cq_action where id ='3912035';
delete from cq_action where id ='3912036';
delete from cq_action where id ='3912037';
delete from cq_action where id ='3912038';
delete from cq_action where id ='3912060';
delete from cq_action where id ='3912061';
delete from cq_action where id ='3912062';
delete from cq_action where id ='3912063';
delete from cq_action where id ='3912064';
delete from cq_action where id ='3912065';
delete from cq_action where id ='3912066';
delete from cq_action where id ='3912067';
delete from cq_action where id ='3912068';
delete from cq_action where id ='3912090';
delete from cq_action where id ='3912091';
delete from cq_action where id ='3912092';
delete from cq_action where id ='3912093';
delete from cq_action where id ='3912094';
delete from cq_action where id ='3912095';
delete from cq_action where id ='3912096';
delete from cq_action where id ='3912097';
delete from cq_action where id ='3912098';
delete from cq_action where id ='3912099';
delete from cq_action where id ='3912100';
delete from cq_action where id ='3912101';
delete from cq_action where id ='3912120';
delete from cq_action where id ='3912121';
delete from cq_action where id ='3912122';
delete from cq_action where id ='3912123';
delete from cq_action where id ='3912124';
delete from cq_action where id ='3912125';
delete from cq_action where id ='3912126';
delete from cq_action where id ='3912127';
delete from cq_action where id ='3912128';
delete from cq_action where id ='3912129';
delete from cq_action where id ='3912130';
delete from cq_action where id ='3912131';
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(3911910, 3911911, 3911915, 508, 0, '2 0 50');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(3911911, 3911912, 0000, 502, 729217, '');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(3911912, 3911913, 0000, 501, 724024, '');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(3911913, 3911914, 0000, 501, 724040, '');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(3911914, 0000, 0000, 126, 0, 'Congratulations~you~won~the~tourney');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(3911915, 0000, 0000, 126, 0, 'leave~2~slots~in~your~inventory~free');
INSERT INTO cq_action
(`id`, `id_next`, `id_nextfail`, `type`, `data`, `param`)
VALUES
(3911940, 3911941, 3911945, 508, 0, '2 0 50');
Can i ask something?is this query for fix pkt bug?
my db got pkt bug.it cant change map after 30 minutes,cant claim prizes and so on .i've found this query using search mode .
...
Can i ask something?is this query for fix pkt bug?
If you read the first line, it says it fixes pkt boxes which are the items you get after you win or place. It is not a fix for the actual tournament.
