Need Help Here!

08/24/2010 12:29 AziQ#1
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?
08/24/2010 14:24 CharmedOne#2
i think yes just try run 1st but make sure you backup your DB 1st before doing any changing
08/24/2010 23:05 King_Arthur#3
Quote:
Originally Posted by speederbodo123 View Post
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.