+- ExaySRO Forums (https://forum.exaysro.com)
+-- Forum: General (https://forum.exaysro.com/forumdisplay.php?fid=40)
+--- Forum: General discussion forum (https://forum.exaysro.com/forumdisplay.php?fid=75)
+--- Thread: Guild ranking (/showthread.php?tid=731)
Guild ranking - THOMASO - 05-31-2013
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
RE: Guild ranking - Admin - 05-31-2013
Ok now hex edit Gameserver to accept SP as bigint lol, because it work only with INT and crash when this value is changed, you think I didn't try?
RE: Guild ranking - THOMASO - 05-31-2013
Didn't knew that
Eheh, I don't not know where you working at, but it's nice that you gave it a try.
Sorry for the disturb.
RE: Guild ranking - Admin - 05-31-2013
It's ok =)
Just need to find that value with odbg, but I'm not too good with hex edit.
RE: Guild ranking - THOMASO - 05-31-2013
Me neither.
I'm trying to learn it, but it's hard. It is different from other languages such as C # and C + +