• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

AAC PowerGamers (BIGINT UNSIGNED)

Kownikuzyt

Member
Joined
Feb 11, 2020
Messages
170
Solutions
1
Reaction score
8
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)
 
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;
 
Back
Top