Greetings to everyone from a sleepless night,
I recently started working on Silkroad as a hobby and I have been learning the SQL language for a while. As of today, I have written my first comprehensive procedure and I wanted to share it with the forum.
There is a topic in the forum about giving rewards when you reach 100lvl, but that procedure and its working logic are not the same. This procedure gives rewards to the players who reach the specified level first, not to everyone. All tests have been completed completely, you can use it with peace of mind.
'''The procedure was written entirely by me, no sources were quoted.'''
Now I am explaining the system. For example, we open a server with a difficult level, such as 1x exp rate. The first 10, 50, 100... people receive a reward when they reach the maximum level according to the number of players we have determined.
Rewards given by the procedure (The system sends a message to the person to whom the rewards are given)
- It rewards us with the amount of Silk we set.
- Gives PLVL Expert rank
Important Information =
- The procedure records the players it awards to the table and does not award the same player again.
- It collects the records in the table as many records as entered, and when it reaches the number we want, it gives rewards and leaves the data to be entered ( do not delete the row of the table that starts with 0 ).
NOTE= Since I use MaxiGuard ( @sarkolata 
), the procedure was written in a way that is compatible with it. If we use different guards, you will need to make changes where necessary.
1- Let's run the Query codes we shared by calling New Query. It will create a special table in SRO_VT_SHARDLOG to control max players. Our procedure will enter the information of the players it awards here.
*** Hidden text: cannot be quoted. ***
