Module - Player Statistics

Back

Price $75
Module
name: addon.player_statistics
config: player_statistics.json
extra: stat_monster_records.csv
extra: stat_dungeon_records.csv
extra: stat_box_records.csv
extra: stat_enchant_records.csv
extra: stat_potion_records.csv
Short Description
Add a ranking system that rewards the 1st place player (daily/weekly/monthly) with a special effect from the ResourceItem.
The following module must be enabled: addon.player.effect & addon.pvp_potion
addon.player.effect for displaying an aura for 1st place.
addon.pvp_potion is used to record data based on potion usage.

• The player statistic ranking table in a game displays various statistics and ranks players based on their performance in different aspects/categories of the game.
• This ranking includes statistics such as TOP level, TOP PVP points, TOP CPT, TOTAL kills, TOTAL dungeons opened, TOTAL monsters killed, upgrade failures (+5, +6, +7), upgrade successes (+5, +6, +7), TOTAL boxes opened, TOTAL potions consumed, and fastest level-up.
• Players can view their own ranking compared to others, adding a competitive element to the game and motivating players to improve their performance.
• By reaching the top spot in the daily / weekly / monthly rankings, player can earn an bonus effect (1 resource effects and Aura) *effect only applied to a player from ranking by all races.
• Top 1 Rank (Best of the Best) is calculated from Rank of every enabled aspect/categories (except : Speedrun)
• You can choose which aspect/categories gonna be enabled and the effect given from player_statistics.json

If using player statistic module, must add these in order to working correctly.
SQL Server Management Studio > right click SQL Server Agent > New > Job...
Schedules > type: Recurring, Occurs: Daily, Occurs every: 3~10 minutes | Steps > Step name: job_update_positon, Database: RF_World, Command: (check below)

exec pGameStat_ResetDeletedPlayer;
exec pGameStat_UpdatePositionDay;
exec pGameStat_UpdatePositionWeek;
exec pGameStat_UpdatePositionMonth;
exec pGameStat_UpdateBestOfTheBest;
                        
Schedules > type: Recurring, Occurs: Daily, Occurs once at: 12:00:00 AM | Steps > Step name: job_reset_day, Database: RF_World, Command: (check below)

exec pGameStat_ResetDay;
				    	
Schedules > type: Recurring, Occurs: Weekly, Recurs every: 1 week, Monday (only), Occurs once at: 12:00:00 AM | Steps > Step name: job_reset_week, Database: RF_World, Command: (check below)

exec pGameStat_ResetWeek;
				    	
Schedules > type: Recurring, Occurs: Monthly, Day: 1 of every 1 month, Occurs once at: 12:00:00 AM | Steps > Step name: job_reset_month, Database: RF_World, Command: (check below)

exec pGameStat_ResetMonth;