Greetings to everyone from a sleepless night,
I recently started working on Silkroad as a hobby and have been learning SQL for a while now. As of today, I have written my first comprehensive procedure and wanted to share it with the forum.
There is a topic on the forum about giving a reward when you reach level 100, but that procedure and this one are not the same. This procedure gives a reward to the first players to reach the level we have determined, not to everyone. All tests have been done completely, you can use it with peace of mind.
'''The procedure was written entirely by me, no references were made to any source.'''
Now I'm explaining the system. For example, we open a server with a difficult level, such as 1x exp rate. When the first 10, 50, 100... people reach the maximum level, they win a prize according to the number of players we determine.
Rewards given by the procedure (The system sends a message to the person to whom the rewards are given)
- Rewards you with a certain amount of Silk
- PLVL gives Expert rank
Important Information =
- The procedure records the players it has rewarded in the table and does not reward the player it has saved again.
- It adds up the records it has made into the table, and when it reaches the number we want, it gives the reward and leaves the data to enter ( do not delete the row starting with 0 in the table ).
NOTE= The procedure was written in a way that is compatible with MaxiGuard ( @sarkolata 
) because I use it. If we use different guards, you will need to make changes where necessary.
1- Let's run the Query codes we shared by saying 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 has awarded here.
*** Hidden text: cannot be quoted. ***
