Stat point / skill point recall

Results 1 to 10 of 10
  1. #1
    Valued Member FuriousRage is offline
    MemberRank
    Nov 2011 Join Date
    128Posts

    Stat point / skill point recall

    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...


  2. #2
    † Working in Secret † Madelyn is offline
    MemberRank
    Jun 2011 Join Date
    San CristóbalLocation
    658Posts

    Re: Stat point / skill point recall

    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..

  3. #3
    Valued Member FuriousRage is offline
    MemberRank
    Nov 2011 Join Date
    128Posts

    Re: Stat point / skill point recall

    Quote Originally Posted by new2121 View Post
    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

  4. #4
    Proficient Member nzamkdh is offline
    MemberRank
    Feb 2009 Join Date
    AsianLocation
    173Posts

    Re: Stat point / skill point recall

    i just get this from ksro

    Code:
    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

  5. #5
    Member Over Limit is offline
    MemberRank
    May 2012 Join Date
    70Posts

    Re: Stat point / skill point recall

    they working on overlimit online
    try to get them from it

  6. #6
    NewEvolust.Com xxNukertube is offline
    MemberRank
    Jul 2012 Join Date
    Ceres, Goias, BLocation
    215Posts

    Re: Stat point / skill point recall

    --'
    Over Limit

    who brags too ends in disaster

  7. #7
    Member Over Limit is offline
    MemberRank
    May 2012 Join Date
    70Posts

    Re: Stat point / skill point recall

    Quote Originally Posted by xxNukertube View Post
    --'
    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 -.-

  8. #8
    Member PlayerSRO is offline
    MemberRank
    Jul 2012 Join Date
    73Posts

    Re: Stat point / skill point recall

    Its database not client ....

  9. #9
    Developer sladlejrhfpq is offline
    MemberRank
    Oct 2011 Join Date
    671Posts

    Re: Stat point / skill point recall

    Quote Originally Posted by PlayerSRO View Post
    Its database not client ....
    facepalm.jpg

  10. #10
    #Yummi.sql Caipi is offline
    MemberRank
    Sep 2011 Join Date
    GermanyLocation
    403Posts

    Re: Stat point / skill point recall

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



Advertisement