Register for your free account! | Forgot your password?

You last visited: Today at 10:40

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



System

Discussion on System within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1

 
Worshiper's Avatar
 
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
Worshiper is offline  
Old 06/23/2020, 02:56   #2
 
nemo08's Avatar
 
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] [intNULL,
    [
Data2] [tinyintNULL,
ON [PRIMARY]

GO

CREATE TABLE 
[dbo].[_Top200](
    [
CharID] [intNULL,
    [
Data2] [tinyintNULL,
ON [PRIMARY]

GO

CREATE TABLE 
[dbo].[_Top300](
    [
CharID] [intNULL,
    [
Data2] [tinyintNULL,
ON [PRIMARY]

GO

CREATE TABLE 
[dbo].[_ToplevelsReward](
    [
Silk1] [smallintNULL,
    [
Silk2] [smallintNULL,
    [
Silk3] [smallintNULL,
    [
Reward1Top100] [varchar](50NULL,
    [
Reward1Count100] [smallintNULL,
    [
Reward2Top100] [varchar](50NULL,
    [
Reward2Count100] [smallintNULL,
    [
Reward3Top100] [varchar](50NULL,
    [
Reward3Count100] [smallintNULL,
    [
Reward1Top200] [varchar](50NULL,
    [
Reward1Count200] [smallintNULL,
    [
Reward2Top200] [varchar](50NULL,
    [
Reward2Count200] [smallintNULL,
    [
Reward3Top200] [varchar](50NULL,
    [
Reward3Count200] [smallintNULL,
    [
Reward1Top300] [varchar](50NULL,
    [
Reward1Count300] [smallintNULL,
    [
Reward2Top300] [varchar](50NULL,
    [
Reward2Count300] [smallintNULL,
    [
Reward3Top300] [varchar](50NULL,
    [
Reward3Count300] [smallintNULL
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[/MENTIONvarchar(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(NOLOCKINNER JOIN SRO_VT_SHARD.dbo._User U2 WITH(NOLOCKON U.JID U2.UserJID WHERE CharID = @CharID
Declare  [
MENTION=368275]top[/MENTIONsmallint = (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 And sec_primary 
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[/MENTIONBetween 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[/MENTIONBetween 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(CharIDFrom 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 And sec_primary ))) 
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]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 ).
nemo08 is offline  
Thanks
1 User
Old 06/23/2020, 03:05   #3

 
Worshiper's Avatar
 
elite*gold: 134
Join Date: May 2017
Posts: 1,119
Received Thanks: 245
Quote:
Originally Posted by nemo08 View Post
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] [intNULL,
    [
Data2] [tinyintNULL,
ON [PRIMARY]

GO

CREATE TABLE 
[dbo].[_Top200](
    [
CharID] [intNULL,
    [
Data2] [tinyintNULL,
ON [PRIMARY]

GO

CREATE TABLE 
[dbo].[_Top300](
    [
CharID] [intNULL,
    [
Data2] [tinyintNULL,
ON [PRIMARY]

GO

CREATE TABLE 
[dbo].[_ToplevelsReward](
    [
Silk1] [smallintNULL,
    [
Silk2] [smallintNULL,
    [
Silk3] [smallintNULL,
    [
Reward1Top100] [varchar](50NULL,
    [
Reward1Count100] [smallintNULL,
    [
Reward2Top100] [varchar](50NULL,
    [
Reward2Count100] [smallintNULL,
    [
Reward3Top100] [varchar](50NULL,
    [
Reward3Count100] [smallintNULL,
    [
Reward1Top200] [varchar](50NULL,
    [
Reward1Count200] [smallintNULL,
    [
Reward2Top200] [varchar](50NULL,
    [
Reward2Count200] [smallintNULL,
    [
Reward3Top200] [varchar](50NULL,
    [
Reward3Count200] [smallintNULL,
    [
Reward1Top300] [varchar](50NULL,
    [
Reward1Count300] [smallintNULL,
    [
Reward2Top300] [varchar](50NULL,
    [
Reward2Count300] [smallintNULL,
    [
Reward3Top300] [varchar](50NULL,
    [
Reward3Count300] [smallintNULL
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[/MENTIONvarchar(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(NOLOCKINNER JOIN SRO_VT_SHARD.dbo._User U2 WITH(NOLOCKON U.JID U2.UserJID WHERE CharID = @CharID
Declare  [
MENTION=368275]top[/MENTIONsmallint = (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 And sec_primary 
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[/MENTIONBetween 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[/MENTIONBetween 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(CharIDFrom 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 And sec_primary ))) 
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]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
Worshiper is offline  
Thanks
1 User
Old 06/23/2020, 08:23   #4
 
nemo08's Avatar
 
elite*gold: 393
Join Date: Feb 2009
Posts: 694
Received Thanks: 414
Quote:
Originally Posted by [GM]Dejo View Post
Thanks for your help dude
NP mate I hope it will work well with u ^^
nemo08 is offline  
Old 06/23/2020, 20:23   #5
 
Skedaddle!'s Avatar
 
elite*gold: 0
Join Date: May 2020
Posts: 46
Received Thanks: 22
Quote:
Originally Posted by nemo08 View Post
NP mate I hope it will work well with u ^^
You didn't help him, you just killed his host's CPU
Skedaddle! is offline  
Old 06/23/2020, 20:40   #6

 
Worshiper's Avatar
 
elite*gold: 134
Join Date: May 2017
Posts: 1,119
Received Thanks: 245
Quote:
Originally Posted by Skedaddle! View Post
You didn't help him, you just killed his host's CPU
if you have a better one share it if you can
Worshiper is offline  
Reply


Similar Threads Similar Threads
Class Reborn Cap 110 - Dg 11- Pvp System- Uniques System -Job System- Coin System
04/09/2018 - SRO PServer Advertising - 17 Replies
http://i.epvpimg.com/HXIucab.jpg http://i.epvpimg.com/Ht37fab.png https://www.youtube.com/watch?v=1vJSSpEqTZw http://i.epvpimg.com/Ht37fab.png Site ClassReborn Online
Class Reborn Cap 110 - Dg 11- Pvp System- Uniques System -Job System- Coin System
02/18/2018 - SRO PServer Advertising - 2 Replies
http://i.epvpimg.com/HXIucab.jpg http://i.epvpimg.com/Ht37fab.png Site Download
110 Cap D11 Pve new Uninques new System / new Job System / Free Silk / Easy System
05/26/2013 - SRO PServer Advertising - 19 Replies
AT the Frist i will give Info about the game Server will start lv 1 Max Lv 110 Free Silk 500K New System for Job Egy A CaN Get From FGW So Easy :) Egy B Can Get From Uniques FGW Set Egy A Distraction With Coin Set Egy B Immortality With Coin



All times are GMT +1. The time now is 10:41.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.