Exp Table Bug?

XloverBoy7X

LOMCN Veteran
Veteran
Dec 4, 2010
416
101
70
Dundee
When a player reach lvl 60 he cannot level up anymore. The experience goes to - %

Exp and max Exp in sql is set to big int, max level is set to 65k.
IT used to work previously but lately i changed the table a bit to make higher requirements for level up and somehow it got ****ed. any ideas?

59=2000000000
60=2300000000
61=2700000000
62=3200000000

any ideas?
 
Last edited:

twisterdmk

LOMCN Veteran
Veteran
May 13, 2009
759
28
115
USA
You shouldn't modify anything experience wise in sql. Only the levelup.txt, try changing it back to normal one and test if leveling is working properly. If not, it's sql side more than likely. Sometimes level will hang like that when it is set too 2 billion.
 
Upvote 0

XloverBoy7X

LOMCN Veteran
Veteran
Dec 4, 2010
416
101
70
Dundee
I modified crueldragon3g.ini and the table there, since then all characters who get till lvl 60 cannot level up more and the max exp lookes likes -9218312737232 whatever instead of 2300000000, i checked the txt i dont see any spaces etc. there, but i think i will just get a new ini original one and change it again replace and try hehe.
 
Upvote 0

Skunkmeister

LOMCN VIP
VIP
Jul 10, 2007
203
19
105
if i remember correctly the max value for int/bigint/insert-random-t-sql-data-type is 2.4 billion which would make sense since your exp table exceeds that for lvl 61 not lvl 60

its 2.1 odd billion actually... http://msdn.microsoft.com/en-us/library/ms187745.aspx, and thats for int, as you can see bigint is huge, so maybe the server/client cant handle it for the same reason, wrong/badly-chosen data type
 
Upvote 0

XloverBoy7X

LOMCN Veteran
Veteran
Dec 4, 2010
416
101
70
Dundee
so u think bigint is actually too big for the server to handle?

well if i have to limit my table to 2.1bil now it changes my server completly cos the next lvls will be same easy as the
lvl now even easier cos players get rebirths, lose some lvls yes but get em back asap.

thanks for help, now i need to find some idea how to make it harder for the lvl 60+ if not table so somehow no idea omg!! nightmare!
 
Upvote 0

mercury71

Dedicated Member
Dedicated Member
Apr 3, 2006
155
3
64
i would control the amount of exp given by a mob, ie make a smaller exp given when they kill a certain mob but to make them wanna go kill those mobs put some good kit dropping from them
 
Upvote 0

XloverBoy7X

LOMCN Veteran
Veteran
Dec 4, 2010
416
101
70
Dundee
its too late for that:) cant lover exp on my server,

but i will make a script in default00.txt to make the player lose 2 levels at lvl 65 to 63 with flags so he doesnt lose the second time, then on 68 to 65, then on 71 to 67 etc. and that would solve my issue.

kinda ****ed up funny way but well i dont see any other option:)
 
Upvote 0