Hi everyone,
I hope you are all doing well. I wrote a procedure for rewarding the players who reach the max level. This procedure will let you reward limited number of players.
Reward will be given by Maxiguard filter. If you use any other filter just replace with your codes
Rewards,
1- Silk reward
2 PLVL Expert reward (you can change)
Let's run the first query for creating a new table. It's gonna save the logs here to limit maximum player number for rewards
USE [SRO_VT_SHARDLOG]
_AddLogChar Procedure
_RefHWANLevel
textuisystem.txt
I hope you are all doing well. I wrote a procedure for rewarding the players who reach the max level. This procedure will let you reward limited number of players.
Reward will be given by Maxiguard filter. If you use any other filter just replace with your codes
Rewards,
1- Silk reward
2 PLVL Expert reward (you can change)
Let's run the first query for creating a new table. It's gonna save the logs here to limit maximum player number for rewards
USE [SRO_VT_SHARDLOG]
PHP Code:
CREATE TABLE Arbys_Top_Levellers(
[Toplam] [int] NOT NULL,
[charID] [int] NOT NULL,
[Charname] [varchar](255) NOT NULL,
[Charlevel] [int] NOT NULL
) ON [PRIMARY]
Insert into Arbys_Top_Levellers(Toplam,charID,Charname,Charlevel)Values ('0','0','0','0')
GO
PHP Code:
If(@EventID=22 AND @Data2=80)/* Data2= 'Required level'*/
declare @Charname16 varchar(64) = (select CharName16 from SRO_VT_SHARD.._Char where CharID = @CharID)
declare @maxtoplam int
declare @msg varchar(200)
set @maxtoplam= (select MAX(Toplam)+1 from ..Arbys_Top_Levellers)
select @maxtoplam
set @msg = 'Congratulations, you are the top 3 Leveller in ... Online. 500 Silk added to your account as a Reward' /* Reward message */
BEGIN
IF @maxtoplam <= 3 /* @maxtoplam <= limit player*/
BEGIN
IF not exists (select Charname from SRO_VT_SHARDLOG..Arbys_Top_Levellers where Charname=@Charname16) BEGIN
Insert into Arbys_Top_Levellers(Toplam,charID,Charname,Charlevel) Values(@maxtoplam,@CharID,@Charname16,@Data2)
Insert into MaxiGuard_User.._BridgeCommands (CommandID,Executor,Data1,Data2,Data3,DATE) values (56,'Arbys',@Charname16,'0','500',GETDATE()) /* '500' = Silk*/
Insert into MaxiGuard_User.._BridgeCommands (CommandID,Executor,Data1,Data2,DATE) values (52,'Arbys',@Charname16,'7',GETDATE()) /* '7' = hwan level*/
Insert into MaxiGuard_User.._BridgeCommands (CommandID,Executor,Data1,Data2,DATE) values (57,'Arbys',@Charname16,'7',GETDATE()) /* '7' = hwan level*/
Insert into MaxiGuard_User.._BridgeCommands (CommandID,Executor,Data1,Data2,Data3,DATE) values (500,'Arbys','4',@msg,@Charname16,GETDATE())
END
END
END
_RefHWANLevel
PHP Code:
7 1397769301 200 1145127506 35 0 0 0 0 0 0 xxx UIO_SECOND_HWAN_CH_NAME_LEVEL_7 UIO_SECOND_HWAN_EU_NAME_LEVEL_7
PHP Code:
1 UIO_SECOND_HWAN_CH_NAME_LEVEL_7 PLVL Expert
1 UIO_SECOND_HWAN_EU_NAME_LEVEL_7 PLVL Expert
