Reborn System

[xKOUP]

can anyone help me to add reborn system ?
info.
working with scroll ( operation 16 )
reset level to 1
reset skill to 0
add +3 points every reborn
max reborn 10!
note: db cap level 130

any help ?

[athena1410]

Originally Posted by Ahmeds

can anyone help me to add reborn system ?
info.
working with scroll ( operation 16 )
reset level to 1
reset skill to 0
add +3 points every reborn
max reborn 10!
note: db cap level 130

any help ?

i write it but not test

[NorseGodTyr]

Originally Posted by Ahmeds

can anyone help me to add reborn system ?
info.
working with scroll ( operation 16 )
reset level to 1
reset skill to 0
add +3 points every reborn
max reborn 10!
note: db cap level 130

any help ?

i have only normal Reborn Scroll work 1 times also int str ( more times used change only the level back to 1 )

RefObjCommon

PHP Code:

1    50135    ITEM_VALTYR_REBORN    ?????    xxx    SN_ITEM_VALTYR_REBORN    SN_ITEM_VALTYR_REBORN_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    255    0    1    0    0    1    0    250    0    0    0    0    0    -1    0    -1    0    -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\reborn.ddj    xxx    xxx    61661 


RefObjItem

PHP Code:

61661    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    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    1000    COOLTIME:0x00000000    -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    0 


Shardlog _AddLogItem

PHP Code:

 -- Valtyr Reborn Scrolls
IF ( [MENTION=1059401]operation[/MENTION] = '41') AND [MENTION=1134588]item[/MENTION]RefID = '50135'
BEGIN
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET Strength = 20 + 20, Intellect = 20 + 20, HP = 200 + 200, MP = 200 + 200, MaxLevel = 1, CurLevel = 1, ExpOffset = 0, RemainStatPoint = 0 WHERE CharID=@CharID
end 


[xKOUP]

thanks anyway but its will not work due to this line
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET Strength = 20 + 20, Intellect = 20 + 20, HP = 200 + 200, MP = 200 + 200, MaxLevel = 1, CurLevel = 1, ExpOffset = 0, RemainStatPoint = 0 WHERE CharID=@CharID
that's mean he will ost the 3 extra points too

[NorseGodTyr]

Originally Posted by Ahmeds

thanks anyway but its will not work due to this line
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET Strength = 20 + 20, Intellect = 20 + 20, HP = 200 + 200, MP = 200 + 200, MaxLevel = 1, CurLevel = 1, ExpOffset = 0, RemainStatPoint = 0 WHERE CharID=@CharID
that's mean he will ost the 3 extra points too

-- Valtyr Reborn Scrolls
IF ( operation = '41') AND itemRefID = '50135'
BEGIN
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET Strength = 20 + 3, Intellect = 20 + 3, MaxLevel = 1, CurLevel = 1, ExpOffset = 0, RemainStatPoint = 0 WHERE CharID=@CharID
end

add a new scroll and change RefObjCommon ID also my is 50135 change to your ID

use this code give only 1x more int str 3 and level will be back to 1

[NorseGodTyr]

Originally Posted by elshaaer

can anyone help me to add reborn system ?
info.
working with scroll ( operation 16 )
reset level to 1
reset skill to 0
add +3 points every reborn
max reborn 10!
note: db cap level 130

any help ?

Create a Table and add CharID & RebornLimit
example for a procedure

DECLARE @Limit TINYINT
SET @Limit = 10 -- limit here
IF ((SELECT COUNT(CharID) FROM [_TableReborn] WHERE CharID = @D) >= @Limit)
BEGIN
RETURN 0
END

[xKOUP]

Originally Posted by mialuisa

Create a Table and add CharID & RebornLimit
example for a procedure

DECLARE @Limit TINYINT
SET @Limit = 10 -- limit here
IF ((SELECT COUNT(CharID) FROM [_TableReborn] WHERE CharID = @D) >= @Limit)
BEGIN
RETURN 0
END

thanks for help but we cant add somthing to make it have 10 reborns ?

Originally Posted by Ahmeds

thanks for help but we cant add somthing to make it have 10 reborns ?

i mean if we add like ( if ) in a query ti handle it