Reset Stats scroll Problem

02/25/2018 11:53 devdash#1

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

02/26/2018 03:32 athena1410#2

Quote:

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

Code:

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

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

Code:

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

02/26/2018 04:24 devdash#3

Quote:
Originally Posted by athena1410
You can do like this
Code:
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 @[Only registered and activated users can see links. Click Here To Register...]RefID = 46357 -- Stat Reset Scroll
BEGIN
declare @[Only registered and activated users can see links. Click Here To Register...] int
declare @[Only registered and activated users can see links. Click Here To Register...] int
declare @[Only registered and activated users can see links. Click Here To Register...] int
declare @[Only registered and activated users can see links. Click Here To Register...]tatPoint int
select @[Only registered and activated users can see links. Click Here To Register...] = MaxLevel from _Char where CharID = @[Only registered and activated users can see links. Click Here To Register...]D
set @[Only registered and activated users can see links. Click Here To Register...]tatPoint = @[Only registered and activated users can see links. Click Here To Register...]*3)-3
set @[Only registered and activated users can see links. Click Here To Register...] = @[Only registered and activated users can see links. Click Here To Register...]+19
UPDATE _Char SET Strength @[Only registered and activated users can see links. Click Here To Register...], Intellect @[Only registered and activated users can see links. Click Here To Register...], RemainStatPoint @[Only registered and activated users can see links. Click Here To Register...]tatPoint WHERE CharID @[Only registered and activated users can see links. Click Here To Register...]D
END

But i think DC is best choice for anti bug stats scroll.
Code:
-------_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