Hello, I'm trying to use this script: http://otland.net/threads/gesior-acc-maker-tfs-0-3-5-powergamers-and-online-time-stats.44762/
But there is problem with this line:
I have these errors:
I've changed column exphist_lastexp in DB - I've set attribute Unsigned but it haven't helped.
How can it be fixed?
But there is problem with this line:
Code:
db.executeQuery("UPDATE `players` SET `exphist7`=players.exphist6, `exphist6`=players.exphist5, `exphist5`=players.exphist4, `exphist4`=players.exphist3, `exphist3`=players.exphist2, `exphist2`=players.exphist1, `exphist1`=players.experience-players.exphist_lastexp, `exphist_lastexp`=players.experience;")
I have these errors:
Code:
mysql_real_query(): UPDATE `players` SET
`exphist7`=players.exphist6, `exphist6`=players.exphist5, `exphist5`=players.exphist4,
`exphist4`=players.exphist3, `exphist3`=players.exphist2, `exphist2`=players.exphist1,
`exphist1`= players.experience-players.exphist_lastexp, `exphist_lastexp`=players.experience;
- MYSQL ERROR: BIGINT UNSIGNED value is out of range in
'(`ot`.`players`.`experience` - `ot`.`players`.`exphist_lastexp`)' (1690)
I've changed column exphist_lastexp in DB - I've set attribute Unsigned but it haven't helped.
How can it be fixed?