[Release][Fix] No more get stuck at 32767 exp when you log in

Everytime you logged back into the game, you swear you remembered having like 1024012 exp right? but now its 32747!! well worry no longer! Here's the fix:

1. Open Player.h

2. Replace:

Code:

---

        int getExp(){
                return this->exp;
        }

---

with:

Code:

---

        unsigned long int getExp(){
                return this->exp;
        }

---

Save Player.h

3. Open up Player.cpp

4. Replace:

Code:

---

exp = (short)MySQL::getInt("characters", getPlayerid(), "exp");

---

with:

Code:

---

exp = (unsigned long)MySQL::getInt("characters", getPlayerid(), "exp");

---

Save Player.cpp

5. Go to whatever MySQL browser you use and execute the following:

Code:

---

ALTER TABLE  `characters` CHANGE  `exp`  `exp` BIGINT( 10 ) NULL DEFAULT  '0'

---

credits to me :) and now the max exp i think you can get is: 4,294,967,295

MapleStoryServer - 869 error(s), 0 warning(s)
0_O WTF!

EDIT:
lol fixed it :P.
though

Code:

---

1>c:\documents and settings\mariokiller64\desktop\gga source\maplestoryserver\levels.cpp(43) : warning C4018: '<=' : signed/unsigned mismatch
1>c:\documents and settings\mariokiller64\desktop\gga source\maplestoryserver\levels.cpp(87) : warning C4018: '>' : signed/unsigned mismatch

---

anything to worry bout that? 0_o

Work Great!

Isn't exp maxed to 2.1 Bil? and thanks for the fix =)

hmm you can try find out, i dont honestly know...

Working Great!

How about levels greater than 255?

thats already been fixed somewhere else, dig through the forum and search for it

ty dude
it's great

Seems good. Got no compiling errors so thank you.

THanks for this :).

the correct sql code is

ALTER TABLE `characters` CHANGE `exp` `exp` BIGINT( 10 ) NULL DEFAULT '0';

Quote:

---

Originally Posted by resinate

the correct sql code is

ALTER TABLE `characters` CHANGE `exp` `exp` BIGINT( 10 ) NULL DEFAULT '0';

---

i got an error with mysql browser
1 row affected by the last command, no resultset returned. help plz?

Quote:

---

Originally Posted by mariokiller64

MapleStoryServer - 869 error(s), 0 warning(s)
0_O WTF!

EDIT:
lol fixed it :P.
though

Code:

---

1>c:\documents and settings\mariokiller64\desktop\gga source\maplestoryserver\levels.cpp(43) : warning C4018: '<=' : signed/unsigned mismatch
1>c:\documents and settings\mariokiller64\desktop\gga source\maplestoryserver\levels.cpp(87) : warning C4018: '>' : signed/unsigned mismatch

---

anything to worry bout that? 0_o

---

how did u fix it?

would this fix the lvl 31 glitch?