[Release] Auto Reward System for Max Level Players – Top 300 System
Automatically reward the first X players who reach max level!
Introduction
Hello everyone,
While browsing my database, I came across this very useful system and decided to share it with you. It's an automated reward system that gives gifts to players when they reach the maximum level – but
only for a limited number of players.
How it works:
- When a player hits max level (e.g., level 100), they automatically receive a set of rewards.
- The system stops after a certain number of players have been rewarded (default is 300 players).
- You can easily change the max player count, the rewards, and the silk amounts.
This is perfect for encouraging competition and rewarding your most dedicated players.
System Overview
The system consists of:
- A new database – SRO_VT_SYSTEMS (you need to create this)
- Two tables – _Top300 and _Top300Reward
- A stored procedure – _Top300Sys
- A trigger/event – added to _AddLogChar to detect when a player reaches max level
Step 1: Create the Systems Database
*** Hidden text: cannot be quoted. ***
Important Notes
BACKUP YOUR DATABASE BEFORE MAKING CHANGES!
- Make sure the Silk procedure CGI_WebPurchaseSilkPServer exists in your SRO_VT_ACCOUNT database. If not, you may need to adapt the silk giving part.
- Test the system on a test server first to ensure everything works as expected.
- The event ID 22 might be different in your files. Confirm it by checking what events are logged in your _AddLogChar procedure.
Final Words
This system is a great way to reward your active players and create healthy competition. Feel free to modify it to fit your server's needs.
If you found this useful, please leave a comment or feedback below.
– Dev.S3oDy
