[Procedure] Vsro procedure for rewarding players who reach max level

[Arbys]

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]

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 


_AddLogChar Procedure

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 


textuisystem.txt

PHP Code:

1    UIO_SECOND_HWAN_CH_NAME_LEVEL_7                                PLVL Expert
1    UIO_SECOND_HWAN_EU_NAME_LEVEL_7                                PLVL Expert 


[XxGhostSpiriTxX]

Thanks for shared

[Arbys]

Originally Posted by XxGhostSpiriTxX

Thanks for shared

You're welcome

[thetamebewolf]

Thanks

[Arbys]

Originally Posted by thetamebewolf

Thanks

No worries

[jameli]

Thank you for this

[Arbys]

Originally Posted by jameli

Thank you for this

You are welcome mate

[RevaOnline]

copy past from data working with maxiguard filter,, and who not use this filter what will do

[painmaker_]

not bad as for newbies

[Arbys]

Originally Posted by RevaOnline

copy past from data working with maxiguard filter,, and who not use this filter what will do

It's not copy paste. I wrote the procedure from scratch. I said in post " if you use any other filter you can replace with yours". I don't care which filter you use, i am giving you the procedure which is saving logs and checking for max levellers

Giving reward is the easiest part of it .It's not my job to write code for every single filter in the industry.You'll do that part

Don't confuse me with yourself about doing copy paste. When you do it , it doesn't mean others do the same. There are many people out that write their own codes

If you don't like, write your own procedure you dumb.