need fix bug scroll reset stat

[M@hmoud]

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

        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

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	***	SN_ITEM_MALL_STATS_POINT_RECALL_A_TT_DESC	***	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

[devdash]

Credits to HECKT0R he made it a long time ago

here yo go



Hope this help you.

[sonzenbi]

Originally Posted by alydandy

Credits to HECKT0R he made it a long time ago

here yo go



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:

 Spoiler

USE [LOG_DB]
GO

/****** Object: Table [dbo].[RESET_STAT] Script Date: 2/21/2020 12:31:52 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[RESET_STAT](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Charname] [varchar](50) NULL,
[Charid] [int] NULL,
[Time] [datetime] NULL,
[TT] [int] NULL,
CONSTRAINT [PK_RESET_STAT] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

 Spoiler

if(@JobID = '37416' )
begin
insert into LOG_DB..RESET_SKILL (Charname,CharID,Time,TT) Values (@CharName16 @D,GETDATE(),0)
return -3
end

 Spoiler

IF(@EventID = 6)
BEGIN
if exists ( select CharID from LOG_DB..RESET_STAT where Charid = @D and TT = 0)
begin
declare @ smallint
declare @ smallint
declare @ tinyint
declare @tatPoint smallint
select @ = MaxLevel from SRO_VT_SHARD.._Char where CharID = @D
set @tatPoint = @*3)-3
set @ = @+19
UPDATE SRO_VT_SHARD.._Char SET Strength @, Intellect @, RemainStatPoint @tatPoint WHERE CharID @D
update LOG_DB..RESET_STAT set TT = 1 where CharID = @D
end
end

[M@hmoud]

Originally Posted by alydandy

Credits to HECKT0R he made it a long time ago

here yo go



Hope this help you.

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

Originally Posted by sonzenbi

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:

 Spoiler

USE [LOG_DB]
GO

/****** Object: Table [dbo].[RESET_STAT] Script Date: 2/21/2020 12:31:52 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[RESET_STAT](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Charname] [varchar](50) NULL,
[Charid] [int] NULL,
[Time] [datetime] NULL,
[TT] [int] NULL,
CONSTRAINT [PK_RESET_STAT] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

 Spoiler

if(@JobID = '37416' )
begin
insert into LOG_DB..RESET_SKILL (Charname,CharID,Time,TT) Values @16 @D,GETDATE(),0)
return -3
end

 Spoiler

IF(@EventID = 6)
BEGIN
if exists ( select CharID from LOG_DB..RESET_STAT where Charid = @D and TT = 0)
begin
declare @ smallint
declare @ smallint
declare @ tinyint
declare @tatPoint smallint
select @ = MaxLevel from SRO_VT_SHARD.._Char where CharID = @D
set @tatPoint = @*3)-3
set @ = @+19
UPDATE SRO_VT_SHARD.._Char SET Strength @, Intellect @, RemainStatPoint @tatPoint WHERE CharID @D
update LOG_DB..RESET_STAT set TT = 1 where CharID = @D
end
end

where put this code

[sonzenbi]

#M@hmoud
SRO_VT_SHARD.._AddTimedJob
SRO_VT_LOG.._AddLogChar

[M@hmoud]

Originally Posted by sonzenbi

#M@hmoud
SRO_VT_SHARD.._AddTimedJob
SRO_VT_LOG.._AddLogChar

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

Msg 102, Level 15, State 1, Procedure _AddTimedJob, Line 250
Incorrect syntax near   [MENTION=3898309]charname[/MENTION]16'.

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

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]'.

[ZαKuRα]

this could work for you

SRO_VT_LOG.dbo._AddLogItem

if(@ItemRefID = '51624') --- remove stats
begin
declare @ int
declare @ int
declare @ int
declare @tatPoint int
select @ = MaxLevel from SRO_VT_SHARD.dbo._Char where CharID = @D
set @tatPoint = @*3)-3
set @ = @+19
UPDATE SRO_VT_SHARD.dbo._Char SET Strength @, Intellect @, RemainStatPoint @tatPoint WHERE CharID @D
end

[M@hmoud]

Originally Posted by ZαKuRα

this could work for you

SRO_VT_LOG.dbo._AddLogItem

if(@ItemRefID = '51624') --- remove stats
begin
declare @ int
declare @ int
declare @ int
declare @tatPoint int
select @ = MaxLevel from SRO_VT_SHARD.dbo._Char where CharID = @D
set @tatPoint = @*3)-3
set @ = @+19
UPDATE SRO_VT_SHARD.dbo._Char SET Strength @, Intellect @, RemainStatPoint @tatPoint WHERE CharID @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'.

[NorseGodTyr]

Originally Posted by M@hmoud

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 @'.

learn to write a query man
and never forget to add @ = 41 this was if you are using the scroll


IF ( @ = 41 and @RefID = 51624)
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
DELETE FROM [SRO_VT_SHARD].[dbo].[_CharSkill] Where SkillID between '8092' And '8119' and CharID = @D
end

and about Skill ID 8092 - 8119

is snow shield he will delete the skills if you have a server with int request on snow shield

[M@hmoud]

Originally Posted by NorseGodTyr

learn to write a query man
and never forget to add @ = 41 this was if you are using the scroll


IF ( @ = 41 and @RefID = 51624)
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
DELETE FROM [SRO_VT_SHARD].[dbo].[_CharSkill] Where SkillID between '8092' And '8119' and CharID = @D
end

and about Skill ID 8092 - 8119

give me this msg

Msg 102, Level 15, State 1, Procedure _AddLogItem, Line 1018
Incorrect syntax near '@maxlevel'.

[devdash]

i would recommend to use @ method

[M@hmoud]

Originally Posted by alydandy

i would recommend to use @ method

but give me error bro not work

Msg 102, Level 15, State 1, Procedure _AddTimedJob, Line 250
Incorrect syntax near @16'.

[XxGhostSpiriTxX]

Originally Posted by M@hmoud

but give me error bro not work

Msg 102, Level 15, State 1, Procedure _AddTimedJob, Line 250
Incorrect syntax near @16'.

 Spoiler

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_Scroll_Name] Script Date: 2/23/2020 1:43:29 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[_Scroll_Name]
@d int
as
begin

Declare @ varchar(20), @ttle int

set @ttle = (select IsBattleField from SRO_VT_SHARD.dbo._RefRegion where wRegionID =
(Select LatestRegion from SRO_VT_SHARD.dbo._Char where CharID @d ))

-- Check if char ouside town dont tp him for non job cheating and other stuff ... !
if( @ttle ='1')
begin
Insert Into iLegendBot..iLegend_Tool (Service,Type,Target,Message,Date) values
(1,'Private' @,'sorry but you are not in town ',Getdate())
END
-- End of anti-cheating
else
begin
print 'ITEM_MALL_STATUS'
end
end

[M@hmoud]

Originally Posted by esteve458

 Spoiler

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_Scroll_Name] Script Date: 2/23/2020 1:43:29 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[_Scroll_Name]
@d int
as
begin

Declare @ varchar(20), @ttle int

set @ttle = (select IsBattleField from SRO_VT_SHARD.dbo._RefRegion where wRegionID =
(Select LatestRegion from SRO_VT_SHARD.dbo._Char where CharID @d ))

-- Check if char ouside town dont tp him for non job cheating and other stuff ... !
if( @ttle ='1')
begin
Insert Into iLegendBot..iLegend_Tool (Service,Type,Target,Message,Date) values
(1,'Private' @,'sorry but you are not in town ',Getdate())
END
-- End of anti-cheating
else
begin
print 'ITEM_MALL_STATUS'
end
end

scroll work out town bro this proc not work
i need proc work good and clos scroll out town

[devdash]

Originally Posted by M@hmoud

error bro give me this msg

Msg 102, Level 15, State 1, Procedure _Scroll_Name, Line 16
Incorrect syntax near @d'.
Msg 102, Level 15, State 1, Procedure _Scroll_Name, Line 22
Incorrect syntax near @'.

 Spoiler

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_Scroll_Name] Script Date: 2/23/2020 1:43:29 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[_Scroll_Name]
@d int
as
begin

Declare @ varchar(20), @ttle int

set @ttle = (select IsBattleField from SRO_VT_SHARD.dbo._RefRegion where wRegionID =
(Select LatestRegion from SRO_VT_SHARD.dbo._Char where CharID = @d ))

-- Check if char ouside town dont tp him for non job cheating and other stuff ... !
if( @ttle ='1')
begin
Insert Into iLegendBot..iLegend_Tool (Service,Type,Target,Message,Date) values
(1,'Private' @,'sorry but you are not in town ',Getdate())
END
-- End of anti-cheating
else
begin
print 'ITEM_MALL_STATUS'
end
end

this should work