Register for your free account! | Forgot your password?

You last visited: Today at 18:35

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Need Help Here!

Discussion on Need Help Here! within the EO PServer Hosting forum part of the Eudemons Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Mar 2010
Posts: 399
Received Thanks: 514
Need Help Here!

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?
AziQ is offline  
Thanks
2 Users
Old 08/24/2010, 14:24   #2
 
elite*gold: 0
Join Date: Jun 2010
Posts: 62
Received Thanks: 12
i think yes just try run 1st but make sure you backup your DB 1st before doing any changing
CharmedOne is offline  
Thanks
1 User
Old 08/24/2010, 23:05   #3
 
King_Arthur's Avatar
 
elite*gold: 246
Join Date: Jan 2008
Posts: 1,712
Received Thanks: 895
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.
King_Arthur is offline  
Thanks
1 User
Reply




All times are GMT +2. The time now is 18:35.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.