Userid's in Anarchy Online too large for id db fields

[Thomas Juberg]

http://bebot.shadow-realm.org/bebot-0-6-support/bot_logon-column-not-large-enough/

According to this user the userid's returned by Anarchy Online for new characters at least on one dimension now contains more characters than can be stored in the current database schema.

This means we will most likely have to alter the schema for all tables storing userid.

Note:

This affects 64bit platforms where the int's for userid's does NOT overflow to become signed int's.
This also means that database entries for users created on 32bit php installs won't be recognized when run on 64bit installs and vice versa.

We will likely have to fix this properly at some point forcing userid's to be float.
For reference: http://www.mysqlperformanceblog.com/2008/01/10/php-vs-bigint-vs-float-conversion-caveat/

[Thomas Juberg (thomas-juberg)]

Fixed for 0.6.4 release by using BIGINT for col's.
Internal userid handling will not be fixed for 0.6 branch most likely.