Reset Stats scroll Problem

[devdash]

my Reset stats scroll have to disconnect players from the server , but i see in alot of servers now they have auto teleport one that after teleport all the stats reseted without dc the player, so how can i do that or is there's any files about it or any topic around that i can take it from it ? its serious problem,
Thanks in advance

[athena1410]

Originally Posted by alydandy

my Reset stats scroll have to disconnect players from the server , but i see in alot of servers now they have auto teleport one that after teleport all the stats reseted without dc the player, so how can i do that or is there's any files about it or any topic around that i can take it from it ? its serious problem,
Thanks in advance

You can do like this

Media-------------------
1	46357	ITEM_STATS_RESET_SCROLL	?? ???	xxx	SN_ITEM_STATS_RESET_SCROLL	SN_ITEM_STATS_RESET_SCROLL_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_ch_eventbox.bsr	premium\etc\mall_server_change_scroll.ddj	xxx	xxx	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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	SN_ITEM_STATS_RESET_SCROLL								Stat Reset Scroll						
1	SN_ITEM_STATS_RESET_SCROLL_TT_DESC								abcxyz

DB----------------------
1	46357	ITEM_STATS_RESET_SCROLL	?? ???	xxx	SN_ITEM_STATS_RESET_SCROLL	SN_ITEM_STATS_RESET_SCROLL_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_ch_eventbox.bsr	premium\etc\mall_server_change_scroll.ddj	xxx	xxx	60006
60006	1	2	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5000	????	1	??????                                                                                                                           	-1	RESURRECT	-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	0

 Spoiler

_AddLogItem-Sro.Vt.Log
IF (@Operation = 16) AND @RefID = 46357 -- Stat Reset Scroll
BEGIN
declare @ int
declare @ int
declare @ int
declare @tatPoint int
select @ = MaxLevel from _Char where CharID = @D
set @tatPoint = @*3)-3
set @ = @+19
UPDATE _Char SET Strength @, Intellect @, RemainStatPoint @tatPoint WHERE CharID @D
END

But i think DC is best choice for anti bug stats scroll.

-------_AddLogChar-Sro.Vt.Log----- Anti bug stat
IF (@EventID = 4)
    BEGIN
	UPDATE SRO_VT_SHARD.dbo._Char SET RemainStatPoint = (MaxLevel - 1) * 3, Strength = (MaxLevel + 19) , Intellect = (MaxLevel + 19) WHERE (Strength+Intellect+RemainStatPoint) <> (MaxLevel + 19)*2 + (MaxLevel - 1) * 3
    END

[devdash]

Originally Posted by athena1410

You can do like this

Media-------------------
1	46357	ITEM_STATS_RESET_SCROLL	?? ???	xxx	SN_ITEM_STATS_RESET_SCROLL	SN_ITEM_STATS_RESET_SCROLL_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_ch_eventbox.bsr	premium\etc\mall_server_change_scroll.ddj	xxx	xxx	1	2	0	0	3	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	5000	????	1	??????	-1	RESURRECT	-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	SN_ITEM_STATS_RESET_SCROLL								Stat Reset Scroll						
1	SN_ITEM_STATS_RESET_SCROLL_TT_DESC								abcxyz

DB----------------------
1	46357	ITEM_STATS_RESET_SCROLL	?? ???	xxx	SN_ITEM_STATS_RESET_SCROLL	SN_ITEM_STATS_RESET_SCROLL_TT_DESC	1	0	3	3	3	1	180000	3	0	1	1	1	255	3	1	0	0	1	0	15000	0	0	0	150	4500	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_ch_eventbox.bsr	premium\etc\mall_server_change_scroll.ddj	xxx	xxx	60006
60006	1	2	0	0	3	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	5000	????	1	??????                                                                                                                           	-1	RESURRECT	-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	0

 Spoiler

_AddLogItem-Sro.Vt.Log
IF (@Operation = 16) AND @RefID = 46357 -- Stat Reset Scroll
BEGIN
declare @ int
declare @ int
declare @ int
declare @tatPoint int
select @ = MaxLevel from _Char where CharID = @D
set @tatPoint = @*3)-3
set @ = @+19
UPDATE _Char SET Strength @, Intellect @, RemainStatPoint @tatPoint WHERE CharID @D
END

But i think DC is best choice for anti bug stats scroll.

-------_AddLogChar-Sro.Vt.Log----- Anti bug stat
IF (@EventID = 4)
    BEGIN
	UPDATE SRO_VT_SHARD.dbo._Char SET RemainStatPoint = (MaxLevel - 1) * 3, Strength = (MaxLevel + 19) , Intellect = (MaxLevel + 19) WHERE (Strength+Intellect+RemainStatPoint) <> (MaxLevel + 19)*2 + (MaxLevel - 1) * 3
    END

i will try that now and i will be back with the results.

not working , can you upload for me everything for it like itemdata,RefObjCommon,RefObjItem,RefSkill,RefSkill Group,Skilldata_enc,SkillEffect,Textdata_object,Ad dLogItem, can you please!, i searched alot i searched everywhere but its always end with some lines ,
Thanks in advance