|
You last visited: Today at 10:40
Advertisement
System
Discussion on System within the SRO Private Server forum part of the Silkroad Online category.
06/22/2020, 21:12
|
#1
|
elite*gold: 134
Join Date: May 2017
Posts: 1,119
Received Thanks: 245
|
System
searching for System Reward For Top 300 Player's working if anyone can share it from his Database
|
|
|
06/23/2020, 02:56
|
#2
|
elite*gold: 393
Join Date: Feb 2009
Posts: 694
Received Thanks: 414
|
Here you are ..
NOTICE : DONT TEST IT AS A GM YOU MUST BE NORMAL PLAYER
First of all Create this table :
PHP Code:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[_Top100] Script Date: 12/24/2017 12:54:52 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_Top100](
[CharID] [int] NULL,
[Data2] [tinyint] NULL,
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[_Top200](
[CharID] [int] NULL,
[Data2] [tinyint] NULL,
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[_Top300](
[CharID] [int] NULL,
[Data2] [tinyint] NULL,
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[_ToplevelsReward](
[Silk1] [smallint] NULL,
[Silk2] [smallint] NULL,
[Silk3] [smallint] NULL,
[Reward1Top100] [varchar](50) NULL,
[Reward1Count100] [smallint] NULL,
[Reward2Top100] [varchar](50) NULL,
[Reward2Count100] [smallint] NULL,
[Reward3Top100] [varchar](50) NULL,
[Reward3Count100] [smallint] NULL,
[Reward1Top200] [varchar](50) NULL,
[Reward1Count200] [smallint] NULL,
[Reward2Top200] [varchar](50) NULL,
[Reward2Count200] [smallint] NULL,
[Reward3Top200] [varchar](50) NULL,
[Reward3Count200] [smallint] NULL,
[Reward1Top300] [varchar](50) NULL,
[Reward1Count300] [smallint] NULL,
[Reward2Top300] [varchar](50) NULL,
[Reward2Count300] [smallint] NULL,
[Reward3Top300] [varchar](50) NULL,
[Reward3Count300] [smallint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
Then Create this procedure :
PHP Code:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[TopLevelsReward] Script Date: 12/24/2017 1:24:22 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[TopLevelsReward]
@CharID int,
[MENTION=336745]DaTa[/MENTION]2 tinyint
as
---------------////////////////************///////////////---------------------
Declare [MENTION=890760]silk1[/MENTION]Reward smallint , [MENTION=292158]Silk[/MENTION]2Reward smallint , [MENTION=2852760]silk3[/MENTION]Reward smallint
[MENTION=1064142]reward[/MENTION]1Top100 varchar(50) [MENTION=1064142]reward[/MENTION]2Top100 varchar(50) [MENTION=1401497]reward3[/MENTION]Top100 varchar(50) [MENTION=1064142]reward[/MENTION]1Count100 smallint [MENTION=1064142]reward[/MENTION]2Count100 smallint [MENTION=1401497]reward3[/MENTION]Count100 smallint
[MENTION=1064142]reward[/MENTION]1Top200 varchar(50) [MENTION=1064142]reward[/MENTION]2Top200 varchar(50) [MENTION=1401497]reward3[/MENTION]Top200 varchar(50) [MENTION=1064142]reward[/MENTION]1Count200 smallint [MENTION=1064142]reward[/MENTION]2Count200 smallint [MENTION=1401497]reward3[/MENTION]Count200 smallint
[MENTION=1064142]reward[/MENTION]1Top300 varchar(50) [MENTION=1064142]reward[/MENTION]2Top300 varchar(50) [MENTION=1401497]reward3[/MENTION]Top300 varchar(50) [MENTION=1064142]reward[/MENTION]1Count300 smallint [MENTION=1064142]reward[/MENTION]2Count300 smallint [MENTION=1401497]reward3[/MENTION]Count300 smallint
Declare [MENTION=3898309]charname[/MENTION] varchar(64) = (select CharName16 from SRO_VT_SHARD.dbo._Char Where CharID = @CharID)
DECLARE [MENTION=292919]user[/MENTION]JID varchar(10) = (SELECT JID FROM SRO_VT_ACCOUNT.dbo.TB_User U WITH(NOLOCK) INNER JOIN SRO_VT_SHARD.dbo._User U2 WITH(NOLOCK) ON U.JID = U2.UserJID WHERE CharID = @CharID)
Declare [MENTION=368275]top[/MENTION] smallint = (Select Count(*) From SRO_VT_SHARD.dbo._Char inner Join SRO_VT_SHARD.dbo._User on SRO_VT_SHARD.dbo._Char.CharID = SRO_VT_SHARD.dbo._User.CharID inner join SRO_VT_ACCOUNT.dbo.TB_User on SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID Where sec_content = 3 And sec_primary = 3 )
Select [MENTION=890760]silk1[/MENTION]Reward=Silk1 [MENTION=292158]Silk[/MENTION]2Reward=Silk2 [MENTION=2852760]silk3[/MENTION]Reward=Silk3 [MENTION=1064142]reward[/MENTION]1Top100=Reward1Top100 [MENTION=1064142]reward[/MENTION]2Top100=Reward2Top100 [MENTION=1401497]reward3[/MENTION]Top100=Reward3Top100 [MENTION=1064142]reward[/MENTION]1Top200=Reward1Top200 [MENTION=1064142]reward[/MENTION]2Top200=Reward2Top200 [MENTION=1401497]reward3[/MENTION]Top200=Reward3Top200 [MENTION=1064142]reward[/MENTION]1Top300=Reward1Top300 [MENTION=1064142]reward[/MENTION]2Top300=Reward2Top300 [MENTION=1401497]reward3[/MENTION]Top300=Reward3Top300 [MENTION=1064142]reward[/MENTION]1Count100=Reward1Count100 [MENTION=1064142]reward[/MENTION]2Count100=Reward2Count100 [MENTION=1401497]reward3[/MENTION]Count100=Reward3Count100 [MENTION=1064142]reward[/MENTION]1Count200=Reward1Count200 [MENTION=1064142]reward[/MENTION]2Count200=Reward2Count200 [MENTION=1401497]reward3[/MENTION]Count200=Reward3Count200 [MENTION=1064142]reward[/MENTION]1Count300=Reward1Count300 [MENTION=1064142]reward[/MENTION]2Count300=Reward2Count300 [MENTION=1401497]reward3[/MENTION]Count300=Reward3Count300 From SRO_VT_SHARDLOG.dbo._ToplevelsReward
IF [MENTION=368275]top[/MENTION] < 100
Begin
if not exists (select CharID,Data2 From SRO_VT_SHARDLOG.dbo._Top100 Where CharID = @CharID and Data2 = [MENTION=336745]DaTa[/MENTION]2)
begin
insert into SRO_VT_SHARDLOG.dbo._Top100 values (@CharID [MENTION=336745]DaTa[/MENTION]2)
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]1Top100 [MENTION=1064142]reward[/MENTION]1Count100,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]2Top100 [MENTION=1064142]reward[/MENTION]2Count100,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1401497]reward3[/MENTION]Top100 [MENTION=1401497]reward3[/MENTION]Count100,1
Update SRO_VT_ACCOUNT.dbo.SK_Silk Set silk_own = silk_own + [MENTION=890760]silk1[/MENTION]Reward Where JID [MENTION=292919]user[/MENTION]JID
End
End
IF [MENTION=368275]top[/MENTION] Between 100 and 200
Begin
if not exists (select CharID,Data2 From _Top200 Where CharID = @CharID and Data2 = [MENTION=336745]DaTa[/MENTION]2)
begin
insert into SRO_VT_SHARDLOG.dbo._Top200 values (@CharID [MENTION=336745]DaTa[/MENTION]2)
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]1Top200 [MENTION=1064142]reward[/MENTION]1Count200,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]2Top200 [MENTION=1064142]reward[/MENTION]2Count200,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1401497]reward3[/MENTION]Top200 [MENTION=1401497]reward3[/MENTION]Count200,1
Update SRO_VT_ACCOUNT.dbo.SK_Silk Set silk_own = silk_own + [MENTION=292158]Silk[/MENTION]2Reward Where JID [MENTION=292919]user[/MENTION]JID
End
End
IF [MENTION=368275]top[/MENTION] Between 200 and 300
Begin
if not exists (select CharID,Data2 From _Top300 Where CharID = @CharID and Data2 = [MENTION=336745]DaTa[/MENTION]2)
begin
insert into SRO_VT_SHARDLOG.dbo._Top300 values (@CharID [MENTION=336745]DaTa[/MENTION]2)
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]1Top300 [MENTION=1064142]reward[/MENTION]1Count300,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]2Top300 [MENTION=1064142]reward[/MENTION]2Count300,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1401497]reward3[/MENTION]Top300 [MENTION=1401497]reward3[/MENTION]Count300,1
Update SRO_VT_ACCOUNT.dbo.SK_Silk Set silk_own = silk_own + [MENTION=2852760]silk3[/MENTION]Reward Where JID [MENTION=292919]user[/MENTION]JID
End
End
GO
Last add this to "AddLogChar" Procedure and dont forget to change @ 2 = 110) 110 = level to what ever you want :
PHP Code:
--======================--
--Top Levels Reward System--
--======================--
Declare [MENTION=291440]Limit[/MENTION]Reward int , @GM tinyint
Set [MENTION=291440]Limit[/MENTION]Reward = (Select Count(CharID) From SRO_VT_SHARD.dbo._Char Where CurLevel = 110 And CharID in (Select CharID From SRO_VT_SHARD.dbo._User Where UserJID in (Select JID From SRO_VT_ACCOUNT.dbo.TB_User Where sec_content = 3 And sec_primary = 3 )))
Set @GM = (Select sec_content From SRO_VT_ACCOUNT.dbo.TB_User Where JID in (Select UserJID From SRO_VT_SHARD.dbo._User Where CharID =@CharID))
IF (@EventID = 22) And [MENTION=336745]DaTa[/MENTION]2 = 110) And [MENTION=291440]Limit[/MENTION]Reward < 300) And (@GM =3)
begin
exec [SRO_VT_SHARDLOG].[dbo].[TopLevelsReward] @CharID , [MENTION=336745]DaTa[/MENTION]2
end
----------------------------------------------------------------------------
adding Rewards :
as you see in this picture
Silk 1 = Reward silk for first 100 --> add the number of silk what ever you want ..
Silk 2 = Reward silk for second 100 --> add the number of silk what ever you want ..
Silk 3 = Reward silk for third 100 --> add the number of silk what ever you want ..
Reward1Top100 = Reward item for first 100 --> add the 'codename128' of any item like "ITEM_ETC_....."
Reward1Count100 = The Item Quantity ( how many ).
Reward2Top100 = Reward item for Second 100 --> add the 'codename128' of any item like "ITEM_ETC_....."
Reward2Count100 = The Item Quantity ( how many ).
Reward3Top100 = Reward item for Third 100 --> add the 'codename128' of any item like "ITEM_ETC_....."
Reward3Count100 = The Item Quantity ( how many ).
|
|
|
06/23/2020, 03:05
|
#3
|
elite*gold: 134
Join Date: May 2017
Posts: 1,119
Received Thanks: 245
|
Quote:
Originally Posted by nemo08
Here you are ..
NOTICE : DONT TEST IT AS A GM YOU MUST BE NORMAL PLAYER
First of all Create this table :
PHP Code:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[_Top100] Script Date: 12/24/2017 12:54:52 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_Top100](
[CharID] [int] NULL,
[Data2] [tinyint] NULL,
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[_Top200](
[CharID] [int] NULL,
[Data2] [tinyint] NULL,
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[_Top300](
[CharID] [int] NULL,
[Data2] [tinyint] NULL,
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[_ToplevelsReward](
[Silk1] [smallint] NULL,
[Silk2] [smallint] NULL,
[Silk3] [smallint] NULL,
[Reward1Top100] [varchar](50) NULL,
[Reward1Count100] [smallint] NULL,
[Reward2Top100] [varchar](50) NULL,
[Reward2Count100] [smallint] NULL,
[Reward3Top100] [varchar](50) NULL,
[Reward3Count100] [smallint] NULL,
[Reward1Top200] [varchar](50) NULL,
[Reward1Count200] [smallint] NULL,
[Reward2Top200] [varchar](50) NULL,
[Reward2Count200] [smallint] NULL,
[Reward3Top200] [varchar](50) NULL,
[Reward3Count200] [smallint] NULL,
[Reward1Top300] [varchar](50) NULL,
[Reward1Count300] [smallint] NULL,
[Reward2Top300] [varchar](50) NULL,
[Reward2Count300] [smallint] NULL,
[Reward3Top300] [varchar](50) NULL,
[Reward3Count300] [smallint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
Then Create this procedure :
PHP Code:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[TopLevelsReward] Script Date: 12/24/2017 1:24:22 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[TopLevelsReward]
@CharID int,
[MENTION=336745]DaTa[/MENTION]2 tinyint
as
---------------////////////////************///////////////---------------------
Declare [MENTION=890760]silk1[/MENTION]Reward smallint , [MENTION=292158]Silk[/MENTION]2Reward smallint , [MENTION=2852760]silk3[/MENTION]Reward smallint
[MENTION=1064142]reward[/MENTION]1Top100 varchar(50) [MENTION=1064142]reward[/MENTION]2Top100 varchar(50) [MENTION=1401497]reward3[/MENTION]Top100 varchar(50) [MENTION=1064142]reward[/MENTION]1Count100 smallint [MENTION=1064142]reward[/MENTION]2Count100 smallint [MENTION=1401497]reward3[/MENTION]Count100 smallint
[MENTION=1064142]reward[/MENTION]1Top200 varchar(50) [MENTION=1064142]reward[/MENTION]2Top200 varchar(50) [MENTION=1401497]reward3[/MENTION]Top200 varchar(50) [MENTION=1064142]reward[/MENTION]1Count200 smallint [MENTION=1064142]reward[/MENTION]2Count200 smallint [MENTION=1401497]reward3[/MENTION]Count200 smallint
[MENTION=1064142]reward[/MENTION]1Top300 varchar(50) [MENTION=1064142]reward[/MENTION]2Top300 varchar(50) [MENTION=1401497]reward3[/MENTION]Top300 varchar(50) [MENTION=1064142]reward[/MENTION]1Count300 smallint [MENTION=1064142]reward[/MENTION]2Count300 smallint [MENTION=1401497]reward3[/MENTION]Count300 smallint
Declare [MENTION=3898309]charname[/MENTION] varchar(64) = (select CharName16 from SRO_VT_SHARD.dbo._Char Where CharID = @CharID)
DECLARE [MENTION=292919]user[/MENTION]JID varchar(10) = (SELECT JID FROM SRO_VT_ACCOUNT.dbo.TB_User U WITH(NOLOCK) INNER JOIN SRO_VT_SHARD.dbo._User U2 WITH(NOLOCK) ON U.JID = U2.UserJID WHERE CharID = @CharID)
Declare [MENTION=368275]top[/MENTION] smallint = (Select Count(*) From SRO_VT_SHARD.dbo._Char inner Join SRO_VT_SHARD.dbo._User on SRO_VT_SHARD.dbo._Char.CharID = SRO_VT_SHARD.dbo._User.CharID inner join SRO_VT_ACCOUNT.dbo.TB_User on SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID Where sec_content = 3 And sec_primary = 3 )
Select [MENTION=890760]silk1[/MENTION]Reward=Silk1 [MENTION=292158]Silk[/MENTION]2Reward=Silk2 [MENTION=2852760]silk3[/MENTION]Reward=Silk3 [MENTION=1064142]reward[/MENTION]1Top100=Reward1Top100 [MENTION=1064142]reward[/MENTION]2Top100=Reward2Top100 [MENTION=1401497]reward3[/MENTION]Top100=Reward3Top100 [MENTION=1064142]reward[/MENTION]1Top200=Reward1Top200 [MENTION=1064142]reward[/MENTION]2Top200=Reward2Top200 [MENTION=1401497]reward3[/MENTION]Top200=Reward3Top200 [MENTION=1064142]reward[/MENTION]1Top300=Reward1Top300 [MENTION=1064142]reward[/MENTION]2Top300=Reward2Top300 [MENTION=1401497]reward3[/MENTION]Top300=Reward3Top300 [MENTION=1064142]reward[/MENTION]1Count100=Reward1Count100 [MENTION=1064142]reward[/MENTION]2Count100=Reward2Count100 [MENTION=1401497]reward3[/MENTION]Count100=Reward3Count100 [MENTION=1064142]reward[/MENTION]1Count200=Reward1Count200 [MENTION=1064142]reward[/MENTION]2Count200=Reward2Count200 [MENTION=1401497]reward3[/MENTION]Count200=Reward3Count200 [MENTION=1064142]reward[/MENTION]1Count300=Reward1Count300 [MENTION=1064142]reward[/MENTION]2Count300=Reward2Count300 [MENTION=1401497]reward3[/MENTION]Count300=Reward3Count300 From SRO_VT_SHARDLOG.dbo._ToplevelsReward
IF [MENTION=368275]top[/MENTION] < 100
Begin
if not exists (select CharID,Data2 From SRO_VT_SHARDLOG.dbo._Top100 Where CharID = @CharID and Data2 = [MENTION=336745]DaTa[/MENTION]2)
begin
insert into SRO_VT_SHARDLOG.dbo._Top100 values (@CharID [MENTION=336745]DaTa[/MENTION]2)
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]1Top100 [MENTION=1064142]reward[/MENTION]1Count100,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]2Top100 [MENTION=1064142]reward[/MENTION]2Count100,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1401497]reward3[/MENTION]Top100 [MENTION=1401497]reward3[/MENTION]Count100,1
Update SRO_VT_ACCOUNT.dbo.SK_Silk Set silk_own = silk_own + [MENTION=890760]silk1[/MENTION]Reward Where JID [MENTION=292919]user[/MENTION]JID
End
End
IF [MENTION=368275]top[/MENTION] Between 100 and 200
Begin
if not exists (select CharID,Data2 From _Top200 Where CharID = @CharID and Data2 = [MENTION=336745]DaTa[/MENTION]2)
begin
insert into SRO_VT_SHARDLOG.dbo._Top200 values (@CharID [MENTION=336745]DaTa[/MENTION]2)
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]1Top200 [MENTION=1064142]reward[/MENTION]1Count200,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]2Top200 [MENTION=1064142]reward[/MENTION]2Count200,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1401497]reward3[/MENTION]Top200 [MENTION=1401497]reward3[/MENTION]Count200,1
Update SRO_VT_ACCOUNT.dbo.SK_Silk Set silk_own = silk_own + [MENTION=292158]Silk[/MENTION]2Reward Where JID [MENTION=292919]user[/MENTION]JID
End
End
IF [MENTION=368275]top[/MENTION] Between 200 and 300
Begin
if not exists (select CharID,Data2 From _Top300 Where CharID = @CharID and Data2 = [MENTION=336745]DaTa[/MENTION]2)
begin
insert into SRO_VT_SHARDLOG.dbo._Top300 values (@CharID [MENTION=336745]DaTa[/MENTION]2)
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]1Top300 [MENTION=1064142]reward[/MENTION]1Count300,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1064142]reward[/MENTION]2Top300 [MENTION=1064142]reward[/MENTION]2Count300,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION] [MENTION=1401497]reward3[/MENTION]Top300 [MENTION=1401497]reward3[/MENTION]Count300,1
Update SRO_VT_ACCOUNT.dbo.SK_Silk Set silk_own = silk_own + [MENTION=2852760]silk3[/MENTION]Reward Where JID [MENTION=292919]user[/MENTION]JID
End
End
GO
Last add this to "AddLogChar" Procedure and dont forget to change @ 2 = 110) 110 = level to what ever you want :
PHP Code:
--======================--
--Top Levels Reward System--
--======================--
Declare [MENTION=291440]Limit[/MENTION]Reward int , @GM tinyint
Set [MENTION=291440]Limit[/MENTION]Reward = (Select Count(CharID) From SRO_VT_SHARD.dbo._Char Where CurLevel = 110 And CharID in (Select CharID From SRO_VT_SHARD.dbo._User Where UserJID in (Select JID From SRO_VT_ACCOUNT.dbo.TB_User Where sec_content = 3 And sec_primary = 3 )))
Set @GM = (Select sec_content From SRO_VT_ACCOUNT.dbo.TB_User Where JID in (Select UserJID From SRO_VT_SHARD.dbo._User Where CharID =@CharID))
IF (@EventID = 22) And [MENTION=336745]DaTa[/MENTION]2 = 110) And [MENTION=291440]Limit[/MENTION]Reward < 300) And (@GM =3)
begin
exec [SRO_VT_SHARDLOG].[dbo].[TopLevelsReward] @CharID , [MENTION=336745]DaTa[/MENTION]2
end
----------------------------------------------------------------------------
adding Rewards :
as you see in this picture
Silk 1 = Reward silk for first 100 --> add the number of silk what ever you want ..
Silk 2 = Reward silk for second 100 --> add the number of silk what ever you want ..
Silk 3 = Reward silk for third 100 --> add the number of silk what ever you want ..
Reward1Top100 = Reward item for first 100 --> add the 'codename128' of any item like "ITEM_ETC_....."
Reward1Count100 = The Item Quantity ( how many ).
Reward2Top100 = Reward item for Second 100 --> add the 'codename128' of any item like "ITEM_ETC_....."
Reward2Count100 = The Item Quantity ( how many ).
Reward3Top100 = Reward item for Third 100 --> add the 'codename128' of any item like "ITEM_ETC_....."
Reward3Count100 = The Item Quantity ( how many ).
|
Thanks for your help dude
|
|
|
06/23/2020, 08:23
|
#4
|
elite*gold: 393
Join Date: Feb 2009
Posts: 694
Received Thanks: 414
|
Quote:
Originally Posted by [GM]Dejo
Thanks for your help dude
|
NP mate I hope it will work well with u ^^
|
|
|
06/23/2020, 20:23
|
#5
|
elite*gold: 0
Join Date: May 2020
Posts: 46
Received Thanks: 22
|
Quote:
Originally Posted by nemo08
NP mate I hope it will work well with u ^^
|
You didn't help him, you just killed his host's CPU
|
|
|
06/23/2020, 20:40
|
#6
|
elite*gold: 134
Join Date: May 2017
Posts: 1,119
Received Thanks: 245
|
Quote:
Originally Posted by Skedaddle!
You didn't help him, you just killed his host's CPU
|
if you have a better one share it if you can
|
|
|
All times are GMT +1. The time now is 10:41.
|
|