Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Guild ranking
#1
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
Reply
#2
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?
Reply
#3
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.
Reply
#4
It's ok =)
Just need to find that value with odbg, but I'm not too good with hex edit.
Reply
#5
Me neither.
I'm trying to learn it, but it's hard. It is different from other languages ​​such as C # and C + +
Reply
 


Forum Jump:


Users browsing this thread: 3 Guest(s)

About ExaySRO

GAME Cap: 130, Skills: 130

EXP: 999x, GOLD: 75x, DROP: 50x, FREE Silks 4 Vote, Winter Events, Reborn system, D14, Baghdad, Starter Pack