05-31-2013, 18:19 PM
Hee hee,
When you look at the guild ranking and look to the field with GatheredSP you see that the max is 2147483647. This is coming because it is a int(integer) column in SQL I think.
But when you make it a bigint(integer) you can go to the 2^63-1 (9,223,372,036,854,775,807). So the ranks will be a much more fun, to work on it!:angel:
The solution how to change this in your sql is:
ALTER TABLE [tablename] ALTER COLUMN [columnname] bigint.
(Tested on my own)
Idk know if it work when you have relations with that column, but I think it is worth a try.
Regards,
Thomas
When you look at the guild ranking and look to the field with GatheredSP you see that the max is 2147483647. This is coming because it is a int(integer) column in SQL I think.
But when you make it a bigint(integer) you can go to the 2^63-1 (9,223,372,036,854,775,807). So the ranks will be a much more fun, to work on it!:angel:
The solution how to change this in your sql is:
ALTER TABLE [tablename] ALTER COLUMN [columnname] bigint.
(Tested on my own)
Idk know if it work when you have relations with that column, but I think it is worth a try.
Regards,
Thomas