Manipulating MSSQL Columns

[blapanda]

Some of us try to add new stuff, but apparently it won't work somehow.
For my situation, I am adding some new quests, which should entertain my players on my server.

Tho for this kind of quests, I need to set the int value to bigint, and this will cause an overlap inside the gameserver. Does anyone know how to set it correctly and permanent (without codecaving stuff)?

E.g. unlike C++ with int and unsigned int, MSSQL has just general int and other declarations.
I need to alter the "Gold" column from int to bigint being able to reward more than 2,147,483,648+ gold at one time.
Bigint has its cap at "9,223,372,036,854,775,807"
So anyone made experience with it already?

Following errors when manipulating the column declaration on MSSQL:
Invalid Region!![ID:39][ObjName128:?????? (?)]
Invalid Region!![ID:40][ObjName128:?????? (?)]
local overlap job exception!! : CServerProcessOverlap

Obviously, the server tools are not able to handle it, as it seems like.

Unsigned int (4,294,967,295) isn't working either.

[MentaL]

[Caosfox]

i tried to do that, but failed (like you, overlap)

fast solution i found, create a "note" worth 2 bill gold, and give notes as reward, they can npc it and get the money (or trade it if they want with another player)

[blapanda]

Ah ok. So this is just a way to "fix" it.

Kinda silly, but well, its Joymax's mistake hardcoding pretty stupidly everything, without being modifying anything :(

Same goes for stuff like immediately rewarding quests (like the last part of hwans or beginner quests).



Thanks for the hint!

[Caosfox]

exactly... is joymax, what you expect?

[blapanda]

And I guess there isn't any kind of exp, sp, spexp parameters built in... Guess I will stick to my SP scripting. There wasn't a mastery/skill unlocker either and I just made one which fits my purpose. Is there any kind of check and add, like "check for column and saved value, add additional value at it by 500" on mssql available? Simple "overwriting that value with 500 and teleport" causes unnecessary long SP scripts with lots of checks.

[Caosfox]

you mean it on real time? you can use sql triggers to check everytime a new value is record to the db, if is xxx change it for xxx + 500? is something like that what you mean?

[blapanda]

Yea exactly. If e.g. like you said, rewarding a reward.note-item which can be exchanged for e.g. 500 Skillpoints, on usage:

Joymax Mechanics: it should automatically add it to the current Skillpoints of that player (and I guess Joymax didn't add such things, yet)

MSSQL Mechanics: a query should check the current Skillpoints value of a player inside the _Char table (e.g. player do own 15000 SP), and adding immediately 500 points at it, or as used to be adding 500 SP and teleporting for an update of stats (like changing stuff on the _Char table, e.g. from lv 1 to 140 - need to teleport to update and show the new level).

Hope thats not that confusing by reading :D


Okay, never mind. Just figured out ... "[...] Update bla bla SET @CurSPamount = @CurSPamount - #numbric_value " ... so freaking simple.
Another fitting query ^-^