Page 1 of 1
FIX THE Negative Naq
Posted: Fri May 30, 2008 4:39 am
by GeneralChaos
Can admin please fix this negative naq bug that is still floating about the game, incase he hadn't noticed there is a server war going on, and if this bug isnt sorted now, there could be alot of people being banned for something they have no control over, so unless admin is going to sit online 24/7 for the next 6 months to unban these innocent people, a fix is needed.
Its been going on to long now come on.....
Re: FIX THE Negative Naq
Posted: Sat May 31, 2008 10:09 pm
by Strenoth
maybe if you describe the negative NAQ bug in detail it would help...
Re: FIX THE Negative Naq
Posted: Sun Jun 01, 2008 8:40 am
by Mystikal Fever
Strenoth wrote:maybe if you describe the negative NAQ bug in detail it would help...
I'd say 95% of the active people in main server know what it is..
Re: FIX THE Negative Naq
Posted: Mon Jun 02, 2008 6:21 am
by ~Odin~
Mystikal Fever wrote:Strenoth wrote:maybe if you describe the negative NAQ bug in detail it would help...
I'd say 95% of the active people in main server know what it is..
I have no clue about it....i just heard someoe mention it....it still have no real clue about it....
Re: FIX THE Negative Naq
Posted: Mon Jun 02, 2008 8:39 am
by urogard
tbh genchaos, everyone knows it's annoying and everyone would like it seeing fixed.
so as far as i can see it, unless you actually have an idea on HOW to fix it, and not just make another thread pointing out the obvious which everyone knows i fail to see the reason for this thread
trust me, if it were that easy to fix admin would do it, although now that i think of it i know how it would be possible to change
Re: FIX THE Negative Naq
Posted: Thu Jun 05, 2008 10:37 am
by Vertigo1
Strenoth wrote:maybe if you describe the negative NAQ bug in detail it would help...
Basically, if someone gets hit at the same time by one, or more people, you get neg naq. Atleast thats my understanding of the bug.
Re: FIX THE Negative Naq
Posted: Thu Jun 05, 2008 12:13 pm
by RobinInDaHood
urogard wrote:tbh genchaos, everyone knows it's annoying and everyone would like it seeing fixed.
so as far as i can see it, unless you actually have an idea on HOW to fix it, and not just make another thread pointing out the obvious which everyone knows i fail to see the reason for this thread
trust me, if it were that easy to fix admin would do it, although now that i think of it i know how it would be possible to change
It can be fixed easily but Admin will have to upgrade the MySQL server he's using to at least 5.x, if not already using it. Then, he's going to have to implement SQL transactions on key areas of the game, such as the attack/farm query set. That will completely eliminate this problem as well as a host of other bugs he's put kludgy patches in to fix.
This is pseudocode, although most of it is valid SQL.
Code: Select all
BEGIN
SET @FarmedNaq = 0;
SELECT (@FarmedNaq:=NaqAvailable) FROM PlayerTable WHERE PlayerName = 'RobinInDaHood';
IF @FarmedNaq > 0 THEN
UPDATE PlayerTable SET NaqAvailable = @FarmedNaq WHERE PlayerName = 'SomeDumbNoob';
UPDATE PlayerTable SET NaqAvailable = 0 WHERE PlayerName = 'RobinInDaHood';
ENDIF
COMMIT
Re: FIX THE Negative Naq
Posted: Thu Jun 05, 2008 2:21 pm
by GeneralChaos
RobinInDaHood wrote:urogard wrote:tbh genchaos, everyone knows it's annoying and everyone would like it seeing fixed.
so as far as i can see it, unless you actually have an idea on HOW to fix it, and not just make another thread pointing out the obvious which everyone knows i fail to see the reason for this thread
trust me, if it were that easy to fix admin would do it, although now that i think of it i know how it would be possible to change
It can be fixed easily but Admin will have to upgrade the MySQL server he's using to at least 5.x, if not already using it. Then, he's going to have to implement SQL transactions on key areas of the game, such as the attack/farm query set. That will completely eliminate this problem as well as a host of other bugs he's put kludgy patches in to fix.
This is pseudocode, although most of it is valid SQL.
Code: Select all
BEGIN
SET @FarmedNaq = 0;
SELECT (@FarmedNaq:=NaqAvailable) FROM PlayerTable WHERE PlayerName = 'RobinInDaHood';
IF @AvailableNaq > 0 THEN
UPDATE PlayerTable SET NaqAvailable = FarmedNaq WHERE PlayerName = 'SomeDumbNoob';
UPDATE PlayerTable SET NaqAvailable = 0 WHERE PlayerName = 'RobinInDaHood';
ENDIF
COMMIT
Maybe admin should just give you a job.
Re: FIX THE Negative Naq
Posted: Thu Jun 05, 2008 2:50 pm
by RobinInDaHood
GeneralChaos wrote:Maybe admin should just give you a job.
He couldn't afford me.
Re: FIX THE Negative Naq
Posted: Thu Jun 05, 2008 10:52 pm
by Mystikal Fever
RobinInDaHood wrote:GeneralChaos wrote:Maybe admin should just give you a job.
He couldn't afford me.
How can a 14 year old know all that?
Re: FIX THE Negative Naq
Posted: Fri Jun 06, 2008 1:40 am
by RobinInDaHood
Mystikal Fever wrote:RobinInDaHood wrote:GeneralChaos wrote:Maybe admin should just give you a job.
He couldn't afford me.
How can a 14 year old know all that?
I've known some pretty smart 14 year olds in my life but as you point out, never met one that was proficient with SQL.
I'm not 14.
Re: FIX THE Negative Naq
Posted: Fri Jun 06, 2008 2:57 am
by deathguard
my mate codes and hes 15 no idea if its at that standard though
Re: FIX THE Negative Naq
Posted: Sat Jun 07, 2008 1:22 am
by Mystikal Fever
RobinInDaHood wrote:Mystikal Fever wrote:RobinInDaHood wrote:GeneralChaos wrote:Maybe admin should just give you a job.
He couldn't afford me.
How can a 14 year old know all that?
I've known some pretty smart 14 year olds in my life but as you point out, never met one that was proficient with SQL.
I'm not 14.
Ahh, i thought you mentioned in a thread you were 14.
I apologize
Re: FIX THE Negative Naq
Posted: Sat Jun 07, 2008 2:26 am
by RobinInDaHood
Mystikal Fever wrote:RobinInDaHood wrote:Mystikal Fever wrote:RobinInDaHood wrote:GeneralChaos wrote:Maybe admin should just give you a job.
He couldn't afford me.
How can a 14 year old know all that?
I've known some pretty smart 14 year olds in my life but as you point out, never met one that was proficient with SQL.
I'm not 14.
Ahh, i thought you mentioned in a thread you were 14.
I apologize
No worries, I had posted that I was 14 but later said I was kidding. It has seemed to stick around more tenaciously than I expected.
