FIX THE Negative Naq

[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.....

[Strenoth]

maybe if you describe the negative NAQ bug in detail it would help...

[Mystikal Fever]

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..

[~Odin~]

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....

[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

[Vertigo1]

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.

[RobinInDaHood]

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

[GeneralChaos]

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.

[RobinInDaHood]

Maybe admin should just give you a job.

He couldn't afford me.

[Mystikal Fever]

Maybe admin should just give you a job.

He couldn't afford me.

How can a 14 year old know all that?

[RobinInDaHood]

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.

[deathguard]

my mate codes and hes 15 no idea if its at that standard though

[Mystikal Fever]

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

[RobinInDaHood]

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.