Guild War & Rewards System

VSRO Guild War & Rewards System - Complete Guild Competition Platform

Tutorial Video

What is Guild War & Rewards System?

Guild War & Rewards System is a comprehensive guild competition platform that tracks PVP kills, deaths, damage, and guild war performance. Guilds compete for rankings across seasons, with automatic reward distribution to top-performing guilds. Unite your members, dominate the battlefield, and claim prestigious rewards!

How It Works

Point-Based Guild Ranking

  • Every PVP kill earns points for your guild automatically
  • Deaths subtract points, creating strategic risk-reward gameplay
  • Fortress kills and guild war victories grant bonus points
  • Real-time point tracking with live leaderboard updates

Seasonal Competition System

  • Compete across configurable season durations (weekly, monthly, custom)
  • Rankings reset at season end with automatic reward distribution
  • Season history preserved with winner records and statistics
  • Current season ID and countdown displayed in rankings interface

Automatic Reward Distribution

  • Top-ranked guilds receive rewards automatically at season end
  • Configurable rewards per rank: Silk, Gold, Items, or custom prizes
  • Individual member rewards distributed via in-game mail
  • Complete reward log tracking with delivery confirmation

Database Architecture

Core Tables (5 Tables)

  • GuildWar_Settings: System configuration, point values, and season management
  • GuildWar_Rankings: Guild statistics, points, kills, deaths, and rank positions
  • GuildWar_Log: Complete event log for all guild war activities
  • GuildWar_RewardConfig: Reward definitions for each rank position
  • GuildWar_RewardDistributionLog: Reward delivery tracking and history

Point System Configuration

  • PointsPerKill: Points earned for each PVP kill (positive value)
  • PointsPerDeath: Points lost for each death (negative value)
  • PointsPerFortressKill: Bonus points for fortress battle kills
  • PointsPerGuildWarKill: Bonus points for official guild war kills

Key Features

Advanced Ranking Interface

  • Multi-Column Display: Rank, Guild Name, Level, Members, Kills, Deaths, Points
  • Search Functionality: Find any guild instantly by name
  • Pagination System: Browse through all ranked guilds efficiently
  • Auto-Refresh: Configurable automatic updates every N seconds

Flexible Reward System

  • Multiple Reward Types: Silk, Gold, Arena Coins, or custom items
  • Rank-Based Configuration: Different rewards for each rank position (1st, 2nd, 3rd, etc.)
  • Item Rewards: Configure items with Plus levels (e.g., +7 weapons)
  • Enable/Disable Toggle: Activate or deactivate specific reward tiers

Comprehensive Logging

  • Event Tracking: Log every PVP kill, death, fortress battle, and guild war
  • Damage Recording: Track total damage dealt by each player and guild
  • Region Tracking: Record which regions/areas events occurred in
  • Reward History: Complete log of all distributed rewards with timestamps

Configuration Options

GuildWarRanking.json Settings

  • IsEnabled: Enable/disable entire guild war ranking system (true/false)
  • EnableAutoRefresh: Automatic ranking updates (true/false)
  • AutoRefreshIntervalSeconds: Update frequency (default: 300 = 5 minutes)
  • SeasonResetEnabled: Enable automatic season resets (true/false)
  • SeasonResetIntervalSeconds: Season duration in seconds
  • SendResetNotice: Broadcast season reset messages (true/false)
  • ResetNoticeMessage: Custom message displayed during reset
  • EnableLogging: Enable detailed console logging (true/false)

Database Settings Configuration

  • PointsPerKill: Points awarded for each kill (e.g., 100)
  • PointsPerDeath: Points deducted for each death (e.g., -50)
  • PointsPerFortressKill: Bonus for fortress kills (e.g., 200)
  • PointsPerGuildWarKill: Bonus for guild war kills (e.g., 150)
  • MinMembersRequired: Minimum guild members to qualify for rankings

Professional Tips

For Guild Leaders

  • Coordinate Attacks: Organize guild members for coordinated PVP sessions
  • Monitor Rankings: Check Guild War tab regularly to track competition
  • Minimize Deaths: Deaths cost points - teach members defensive tactics
  • Fortress Strategy: Target fortress battles for high bonus points
  • Season Timing: Plan major pushes near season end for final rank boost

For Administrators

  • Balanced Point Values: Set kill points higher than death penalties for active gameplay
  • Attractive Rewards: Configure valuable rewards for top 3-5 guilds
  • Season Duration: 1-2 week seasons maintain high engagement
  • Minimum Members: Set requirement (e.g., 10 members) to prevent abuse
  • Monitor Logs: Review GuildWar_Log table for suspicious activity

Practical Example

Scenario: Your guild wants to climb to rank 1 and claim top rewards

  1. Check Current Rank: Open Guild War tab to see your current position and points
  2. Calculate Gap: Determine how many points needed to reach next rank
  3. Organize Guild: Coordinate PVP sessions with 10+ active members
  4. Focus Tactics: Target high-point events like fortress battles
  5. Claim Victory: Receive automatic rewards when season ends!

Technical Implementation

GameServer Integration

  • Automatic Kill Tracking: Server logs every PVP kill/death automatically
  • Real-Time Processing: Filter processes events and updates rankings immediately
  • Event Types: Supports PVP_KILL, DEATH, FORTRESS_KILL, GUILDWAR_KILL
  • Guild Resolution: Automatically retrieves player guild from _Char table

Performance Optimization

  • Auto-Refresh Control: Configurable update intervals to balance freshness and load
  • Indexed Queries: TotalPoints column indexed for fast ranking calculations
  • Pagination Support: Efficient data transfer with page-based loading
  • Cached Guild Data: Guild info cached to reduce Shard database queries

Reward Distribution Logic

  • Automatic Processing: Rewards distributed when season reset triggers
  • Per-Member Delivery: Each guild member receives configured reward
  • Delivery Tracking: IsSent flag prevents duplicate reward distribution
  • Multiple Reward Types: Supports Silk/Gold (database) and Items (mail system)

Summary

Guild War & Rewards System creates a competitive guild ecosystem that rewards teamwork, strategy, and PVP excellence with automatic seasonal prizes.

Core Benefits

🏰

Guild competition

📊

Real-time rankings

🎁

Automatic rewards

⚔️

PVP point system

Unite your guild, dominate the battlefield, and claim seasonal glory with automatic rewards!

by X9 Filter New Feature!

Enhancing your Silkroad Online experience