Reborn System

01/31/2018 23:19 xKOUP#1

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 ?

02/02/2018 06:35 athena1410#2

Quote:

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 :D
[Only registered and activated users can see links. Click Here To Register...]

02/02/2018 10:13 NorseGodTyr#3

Quote:

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

02/03/2018 22:48 xKOUP#4

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 ;)

02/03/2018 23:20 NorseGodTyr#5

Quote:

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

02/04/2018 00:45 NorseGodTyr#6

Quote:

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 @[Only registered and activated users can see links. Click Here To Register...]Limit TINYINT
SET @[Only registered and activated users can see links. Click Here To Register...]Limit = 10 -- limit here
IF ((SELECT COUNT(CharID) FROM [_TableReborn] WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]D) >= @[Only registered and activated users can see links. Click Here To Register...]Limit)
BEGIN
RETURN 0
END

02/07/2018 22:18 xKOUP#7

Quote:

Originally Posted by mialuisa

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

DECLARE @[Only registered and activated users can see links. Click Here To Register...]Limit TINYINT
SET @[Only registered and activated users can see links. Click Here To Register...]Limit = 10 -- limit here
IF ((SELECT COUNT(CharID) FROM [_TableReborn] WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]D) >= @[Only registered and activated users can see links. Click Here To Register...]Limit)
BEGIN
RETURN 0
END

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

Quote:

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