Major Bug: Large User IDs Do Not Work (ie 302044006)

[imported_silkroad]

[BUG]

Hello,

Our forums have large user ids for many users (for example, 302044006) and none of these IDs will work in our forums correctly.

For example, I tried to add the Guest User from a new account with a high number, and each time it converted the big user id to something smaller.

In addition, users with the big ids cannot save scores, etc.

The code need to be upgraded to permit the maximum size of user ids permitted in vBulletin.

--------------- Added 1213982775 at 1213982775 ---------------

Note to developer:

All these large user ids are truncated / transformed to the user id 8388607 when saved as the user id of the guest user.

(just FYI).

--------------- Added 1213985072 at 1213985072 ---------------

See also, reply from Steve back at vBulletin.com ....

http://www.vbulletin.com/forum/showthread.php?p=1583363

--------------- Added 1213986405 at 1213986405 ---------------

vBulletin user IDs seem to be unsigned integers, where the unsigned range of user IDs is 0 to 4294967295.

ipProArcade uses signed mediumints for user IDs, where the range of user IDs is -8388608 to 8388607.

Ref: http://www.ispirer.com/doc/sqlways38...ays-1-190.html

[MrZeropage]

try to run the following queries:

ALTER TABLE " . TABLE_PREFIX . "games_champs MODIFY champ_mid INT(10) DEFAULT '0' NOT NULL

ALTER TABLE " . TABLE_PREFIX . "games_list MODIFY bestmid INT(10) DEFAULT '0' NOT NULL

ALTER TABLE " . TABLE_PREFIX . "games_session MODIFY mid INT(10) DEFAULT '0' NOT NULL


Please let me know if this fixes the problem, as it will be part of v2.6.8+ then :)

[imported_silkroad]

Hi Mr. ZeroPage,

Thank you for posting a fix. From memory, our team recalls changing these, in fact we think we changed all of the "mid" columns to "bigints" which should have more or less the same effect.

http://www.unix.com/arcade.php

[MrZeropage]

*fix included in next release*