need fix bug scroll reset stat

Page 1 of 2 1 2
02/20/2020 13:23 M@hmoud#1
need fix bug scroll reset stat
some player make bug with scroll reset stat
go attack mobs and use scroll reset stat will add new stat with old stat int / str
i need fix this bug or make this scroll work in town only
this my Procedure

Code:
        if(@JobID = '34137') 
        begin 
            declare  [MENTION=314361]strength[/MENTION] int 
            declare  [MENTION=5100626]Intellect[/MENTION] int 
            declare  [MENTION=1017443]maxlevel[/MENTION] int 
            declare  [MENTION=3093238]remains[/MENTION]tatPoint int 
            select  [MENTION=1017443]maxlevel[/MENTION] = MaxLevel from _Char where CharID =  [MENTION=395373]Chari[/MENTION]D 
            set  [MENTION=3093238]remains[/MENTION]tatPoint =   [MENTION=1017443]maxlevel[/MENTION]*3)-3 
            set  [MENTION=1017443]maxlevel[/MENTION] =  [MENTION=1017443]maxlevel[/MENTION]+19 
            UPDATE _Char SET Strength  [MENTION=1017443]maxlevel[/MENTION], Intellect  [MENTION=1017443]maxlevel[/MENTION], RemainStatPoint  [MENTION=3093238]remains[/MENTION]tatPoint WHERE CharID  [MENTION=395373]Chari[/MENTION]D 
            return -3 
        end
this refskill

Code:
1	34137	1061	SKILL_MALL_STATS_POINT_RECALL_A	???? ????	SKILL_MALL_STATS_POINT_RECALL_A	0	1	1	0	0	0	0	0	1000	0	0	0	3599	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	255	255	0	0	0	0	0	255	255	255	255	item\etc\recall_skills_point_scroll.ddj	SN_ITEM__MALL_STATS_POINT_RECALL_A	xxx	SN_ITEM_MALL_STATS_POINT_RECALL_A_TT_DESC	xxx	0	0	3	1667396966	1851946342	1685418593	1500	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
02/20/2020 16:11 devdash#2
Credits to HECKT0R he made it a long time ago

here yo go

[Only registered and activated users can see links. Click Here To Register...]

Hope this help you.
02/20/2020 18:35 sonzenbi#3
Quote:
Originally Posted by alydandy View Post
Credits to HECKT0R he made it a long time ago

here yo go

[Only registered and activated users can see links. Click Here To Register...]

Hope this help you.
My English is bad so it's hard to explain but it won't 100% anti-cheating.
You can still cheat in another way.
This is my way:
02/20/2020 21:48 M@hmoud#4
Quote:
Originally Posted by alydandy View Post
Credits to HECKT0R he made it a long time ago

here yo go

[Only registered and activated users can see links. Click Here To Register...]

Hope this help you.
Code:
USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_Scroll_Name]    Script Date: 20/02/2020 11:35:25 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[_Scroll_Name]
 [MENTION=395373]Chari[/MENTION]d int
as
begin

    Declare [MENTION=3898309]charname[/MENTION] varchar(20), [MENTION=4891778]isba[/MENTION]ttle int 
    
    set [MENTION=4891778]isba[/MENTION]ttle = (select IsBattleField from SRO_VT_SHARD.dbo._RefRegion where wRegionID =
                    (Select LatestRegion from SRO_VT_SHARD.dbo._Char where CharID  [MENTION=395373]Chari[/MENTION]d ))

-- Check if char ouside town dont tp him for non job cheating and other stuff ... !
    if( [MENTION=4891778]isba[/MENTION]ttle ='1')
        begin 
             Insert into Notice (Service,Type,Target,Message,Date) values 
                        (1,'Private' [MENTION=3898309]charname[/MENTION],'sorry but you are not in town :) ',Getdate()) 
        END
--  End of anti-cheating 
    else
        begin
            print 'ITEM_MALL_STATS_POINT_RECALL_A'
        end
end
but scroll work out town u have any fix

Quote:
Originally Posted by sonzenbi View Post
My English is bad so it's hard to explain but it won't 100% anti-cheating.
You can still cheat in another way.
This is my way:
where put this code
02/21/2020 07:00 sonzenbi#5
#M@hmoud
SRO_VT_SHARD.._AddTimedJob
SRO_VT_LOG.._AddLogChar
02/21/2020 16:48 M@hmoud#6
Quote:
Originally Posted by sonzenbi View Post
#M@hmoud
SRO_VT_SHARD.._AddTimedJob
SRO_VT_LOG.._AddLogChar
Code:
if(@JobID = '34137' )
begin
insert into SRO_VT_SHARDLOG..RESET_SKILL (Charname,CharID,Time,TT) Values  [MENTION=3898309]charname[/MENTION]16  [MENTION=395373]Chari[/MENTION]D,GETDATE(),0)
return -3
end
give me error
Code:
Msg 102, Level 15, State 1, Procedure _AddTimedJob, Line 250
Incorrect syntax near   [MENTION=3898309]charname[/MENTION]16'.
Code:
IF(@EventID = 6)
BEGIN
if exists ( select CharID from SRO_VT_SHARDLOG..RESET_STAT where Charid = [MENTION=395373]Chari[/MENTION]D and TT = 0)
begin
declare [MENTION=314361]strength[/MENTION] smallint
declare [MENTION=5100626]Intellect[/MENTION] smallint
declare [MENTION=1017443]maxlevel[/MENTION] tinyint
declare [MENTION=3093238]remains[/MENTION]tatPoint smallint
select [MENTION=1017443]maxlevel[/MENTION] = MaxLevel from SRO_VT_SHARD.._Char where CharID = [MENTION=395373]Chari[/MENTION]D
set [MENTION=3093238]remains[/MENTION]tatPoint = [MENTION=1017443]maxlevel[/MENTION]*3)-3
set [MENTION=1017443]maxlevel[/MENTION] = [MENTION=1017443]maxlevel[/MENTION]+19
UPDATE SRO_VT_SHARD.._Char SET Strength [MENTION=1017443]maxlevel[/MENTION], Intellect [MENTION=1017443]maxlevel[/MENTION], RemainStatPoint [MENTION=3093238]remains[/MENTION]tatPoint WHERE CharID [MENTION=395373]Chari[/MENTION]D
update SRO_VT_SHARDLOG..RESET_STAT set TT = 1 where CharID = [MENTION=395373]Chari[/MENTION]D
end
end
give error
Code:
Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 361
Incorrect syntax near ')'.
Msg 102, Level 15, State 1, Procedure _AddLogChar, Line 363
Incorrect syntax near  [MENTION=1017443]maxlevel[/MENTION]'.
02/22/2020 03:59 ZαKuRα#7
this could work for you :rollsafe:

SRO_VT_LOG.dbo._AddLogItem

if(@ItemRefID = '51624') --- remove stats
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 SRO_VT_SHARD.dbo._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 SRO_VT_SHARD.dbo._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
02/22/2020 12:49 M@hmoud#8
Quote:
Originally Posted by ZαKuRα View Post
this could work for you :rollsafe:

SRO_VT_LOG.dbo._AddLogItem

if(@ItemRefID = '51624') --- remove stats
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 SRO_VT_SHARD.dbo._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 SRO_VT_SHARD.dbo._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
give me this msg
Msg 102, Level 15, State 1, Procedure _AddLogItem, Line 1015
Incorrect syntax near ')'.
Msg 102, Level 15, State 1, Procedure _AddLogItem, Line 1017
Incorrect syntax near '@maxlevel'.
02/22/2020 13:27 NorseGodTyr#9
Quote:
Originally Posted by M@hmoud View Post
give me this msg
Msg 102, Level 15, State 1, Procedure _AddLogItem, Line 1015
Incorrect syntax near ')'.
Msg 102, Level 15, State 1, Procedure _AddLogItem, Line 1017
Incorrect syntax near @[Only registered and activated users can see links. Click Here To Register...]'.
:facepalm:
learn to write a query man
and never forget to add @[Only registered and activated users can see links. Click Here To Register...] = 41 this was if you are using the scroll


IF ( @[Only registered and activated users can see links. Click Here To Register...] = 41 and @[Only registered and activated users can see links. Click Here To Register...]RefID = 51624)
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
DELETE FROM [SRO_VT_SHARD].[dbo].[_CharSkill] Where SkillID between '8092' And '8119' and CharID = @[Only registered and activated users can see links. Click Here To Register...]D
end

and about Skill ID 8092 - 8119
Quote:
is snow shield he will delete the skills if you have a server with int request on snow shield
02/22/2020 13:57 M@hmoud#10
Quote:
Originally Posted by NorseGodTyr View Post
:facepalm:
learn to write a query man
and never forget to add @[Only registered and activated users can see links. Click Here To Register...] = 41 this was if you are using the scroll


IF ( @[Only registered and activated users can see links. Click Here To Register...] = 41 and @[Only registered and activated users can see links. Click Here To Register...]RefID = 51624)
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
DELETE FROM [SRO_VT_SHARD].[dbo].[_CharSkill] Where SkillID between '8092' And '8119' and CharID = @[Only registered and activated users can see links. Click Here To Register...]D
end

and about Skill ID 8092 - 8119
give me this msg :D

Msg 102, Level 15, State 1, Procedure _AddLogItem, Line 1018
Incorrect syntax near '@maxlevel'.
02/22/2020 16:43 devdash#11
i would recommend to use @[Only registered and activated users can see links. Click Here To Register...] method
02/22/2020 23:13 M@hmoud#12
Quote:
Originally Posted by alydandy View Post
i would recommend to use @[Only registered and activated users can see links. Click Here To Register...] method
but give me error bro not work

Msg 102, Level 15, State 1, Procedure _AddTimedJob, Line 250
Incorrect syntax near @[Only registered and activated users can see links. Click Here To Register...]16'.
02/23/2020 01:43 XxGhostSpiriTxX#13
Quote:
Originally Posted by M@hmoud View Post
but give me error bro not work

Msg 102, Level 15, State 1, Procedure _AddTimedJob, Line 250
Incorrect syntax near @[Only registered and activated users can see links. Click Here To Register...]16'.
02/24/2020 13:24 M@hmoud#14
Quote:
Originally Posted by esteve458 View Post
scroll work out town bro this proc not work
i need proc work good and clos scroll out town
02/24/2020 13:33 devdash#15
Quote:
Originally Posted by M@hmoud View Post
error bro give me this msg

Msg 102, Level 15, State 1, Procedure _Scroll_Name, Line 16
Incorrect syntax near @[Only registered and activated users can see links. Click Here To Register...]d'.
Msg 102, Level 15, State 1, Procedure _Scroll_Name, Line 22
Incorrect syntax near @[Only registered and activated users can see links. Click Here To Register...]'.

this should work
Page 1 of 2 1 2