Stat point / skill point recall

[FuriousRage]

Hello,

I wish to add the Stat point and Skill point recall to the game, however the question is how this will work. Stat and skill recall is already added in the DB till level 81, but the question is how to get them work.

Downloaded latest client of KSRO and found "refrollbook.txt" which is clearly linked to these new items.

To be able to get it work, we must add a new table that is linked to refrollbook.txt (but which values, how the table is built etc is the question)

And at last, we must make a STORED PROCEDURE which will link to THE Item, and when use reset the stats / skills and then "recall" the user (teleport) to take effect.. anyone wanna help to develop this?

Unless SR_GameServer.exe is in need of a edit, this could be quiet easy (if you know sql well and how the table should be built..)

The stored procedure should be simple, to reset the hp/mp/str/int depending on the items restore level, for e.g. 120 stat recall, would be reset hp/mp to "200" and str to 120 and int to 120 and stat to 360 ? Just some ideas...

[MentaL]

[Madelyn]

To reset all is hard but can use a line that determine the lvl and use deafault parameters as.. (example) Max = 360 Min = 20 and Check what raze in the char or determine whats skills have and reset it to 0. But hp/mp is depends fron the int/and str. U need work in what is the str/int that have each char by lvl. Other variables will be the Stat Points. Cuz if a char haven't used the 3 stats.p. by lvl can be a bad result. I think that is a hard work but.. posible.. :) ANy way good luck..

[FuriousRage]

To reset all is hard but can use a line that determine the lvl and use deafault parameters as.. (example) Max = 360 Min = 20 and Check what raze in the char or determine whats skills have and reset it to 0. But hp/mp is depends fron the int/and str. U need work in what is the str/int that have each char by lvl. Other variables will be the Stat Points. Cuz if a char haven't used the 3 stats.p. by lvl can be a bad result. I think that is a hard work but.. posible.. :) ANy way good luck..

Hmm, yeah, well, we will see how it works out, it would be great if I could find the procedure of SKILL_RESTORATION potion, then I could see how they built it up and possible change the data to be used to reset stats.. :P

[nzamkdh]

i just get this from ksro

1	38759	ITEM_MALL_STATS_POINT_RECALL_A	스탯 회수(1~ 100)	xxx	SN_ITEM_MALL_STATS_POINT_RECALL_A	SN_ITEM_MALL_STATS_POINT_RECALL_A_TT_DESC	1	0	3	3	13	13	180000	3	0	1	1	1	255	1	1	0	0	129	0	0	0	0	0	0	0	1	1	1	100	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	item\etc\mall_stats_point_recall_a.ddj	xxx	xxx	1	2	0	0	1	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	2	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	38760	ITEM_MALL_STATS_POINT_RECALL_B	스탯 회수(101~ 120)	xxx	SN_ITEM_MALL_STATS_POINT_RECALL_B	SN_ITEM_MALL_STATS_POINT_RECALL_B_TT_DESC	1	0	3	3	13	13	180000	3	0	1	1	1	255	1	1	0	0	129	0	0	0	0	0	0	0	1	101	1	120	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	item\etc\mall_stats_point_recall_b.ddj	xxx	xxx	1	2	0	0	1	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	2	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0

1	38763	ITEM_MALL_SKILL_POINT_RECALL_A	스킬 완전 초기화(1~ 100)	xxx	SN_ITEM_MALL_SKILL_POINT_RECALL_A	SN_ITEM_MALL_SKILL_POINT_RECALL_A_TT_DESC	1	0	3	3	13	13	180000	3	0	1	1	1	255	1	1	0	0	129	0	0	0	0	0	0	0	1	1	1	100	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	item\etc\mall_skill_point_recall_a.ddj	xxx	xxx	1	2	0	0	1	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5	TYPEID5	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0
1	38764	ITEM_MALL_SKILL_POINT_RECALL_B	스킬 완전 초기화(101~ 120)	xxx	SN_ITEM_MALL_SKILL_POINT_RECALL_B	SN_ITEM_MALL_SKILL_POINT_RECALL_B_TT_DESC	1	0	3	3	13	13	180000	3	0	1	1	1	255	1	1	0	0	129	0	0	0	0	0	0	0	1	101	1	120	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	item\etc\mall_skill_point_recall_b.ddj	xxx	xxx	1	2	0	0	1	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5	TYPEID5	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0

[Over Limit]

they working on overlimit online
try to get them from it

[xxNukertube]

--'
Over Limit

who brags too ends in disaster

[Over Limit]

--'
Over Limit

who brags too ends in disaster

lol what
i said something wrong?
i just helped by telling him go take it from their client -.-

[PlayerSRO]

Its database not client ....

[sladlejrhfpq]

Its database not client ....

facepalm.jpg

[Caipi]

They are really working on OL.. passively xD But they are!