AAC PowerGamers (BIGINT UNSIGNED)

[Kownikuzyt]

Hello, I have a problem,
there is a bug every now and then.

Mistake:

string(434) "SELECT a.id, b.player_id, a.name, a.vocation, a.level, a.group_id, a.experience, b.exphist_lastexp, b.exphist1, b.exphist2, b.exphist3, b.exphist4, b.exphist5, b.exphist6, b.exphist7, (a.experience - b.exphist_lastexp) AS expdiff FROM players a JOIN znote_players b ON a.id = b.player_id WHERE a.group_id < 2 ORDER BY expdiff DESC LIMIT 3"
(query - SQL error)
Type: select_multi (select multiple rows from database)

BIGINT UNSIGNED value is out of range in '(global.a.experience - global.b.exphist_lastexp)'

Używam: ZnoteAAC/Lua/TFS_10/globalevent powergamers at master · Znote/ZnoteAAC (https://github.com/Znote/ZnoteAAC/tree/master/Lua/TFS_10/globalevent%20powergamers)

 

[rexgandi]

I have the same problem, but i use TFS 0.4.

 

[pink_panther]

You need to make sure your players.experience is a signed bigint so it allows negitive values if someone dies


ALTER TABLE players MODIFY experience BIGINT NOT NULL;