This release contains a complete Athena Filter system for Silkroad Online private servers (vSRO), including player logging, item point calculation, guild synchronization, event tracking, and database extensions.


The system is designed for high-performance server environments and fully supports event-based logic processing.

---

Features Overview

✔ Player login & event logging system
✔ ItemPoints calculation engine
✔ Guild ItemPoints synchronization
✔ Kill / death event tracking
✔ Fortress kill logging system
✔ Wanted system integration
✔ Skill update procedure system
✔ Item add by name procedure
✔ Silk web purchase system fix
✔ Custom event cleanup handlers

---

1) AddLogChar + Player Logging System

Tracks player activity and logs account-related data.



IF(@EventID = 6)
BEGIN
DECLARE @StrUserID varchar(64) =
(SELECT DISTINCT StrUserID
FROM [SRO_VT_ACCOUNT].[dbo].[TB_User]
WHERE JID =
(SELECT DISTINCT UserJID
FROM [SRO_VT_SHARD].[dbo].[_User]
WHERE CharID = @CharID))

EXEC VSRO.._LogPlayers @StrUserID, 'non', 0, 'non', 'non', 'non', 'non', 0
END

---

2) ItemPoints System

Calculates total character power based on equipped items.


✔ Rare item scaling
✔ Option value calculation
✔ Enhancement level bonus



UPDATE _Char
SET ItemPoints = (
SELECT SUM(
CASE
WHEN Common.CodeName128 LIKE '%_A_RARE' THEN ReqLevel1 + 5
WHEN Common.CodeName128 LIKE '%_B_RARE' THEN ReqLevel1 + 10
WHEN Common.CodeName128 LIKE '%_C_RARE' THEN ReqLevel1 + 15
ELSE ReqLevel1
END
)

• SUM(ISNULL(Binding.nOptValue, 0))
• SUM(ISNULL(OptLevel, 0))

FROM _Inventory
JOIN _Items ON _Items.ID64 = _Inventory.ItemID
JOIN _RefObjCommon Common ON _Items.RefItemId = Common.ID
LEFT JOIN _BindingOptionWithItem Binding ON Binding.nItemDBID = _Items.ID64
WHERE _Inventory.CharID = _Char.CharID
)
WHERE _Char.CharID = @CharID

---

3) Guild ItemPoints Sync

Automatically updates guild power based on member ItemPoints.



IF (@GuildID > 0)
BEGIN
UPDATE _Guild
SET ItemPoints = (
SELECT SUM(ItemPoints)
FROM _Char
WHERE GuildID = _Guild.ID
)
WHERE _Guild.ID = @GuildID
END

---

4) Kill / Event Tracking System

Handles job kills, fortress fights, and global events.


✔ Trader / Hunter / Thief tracking
✔ Fortress kill counter
✔ PvP event logging



IF (@strPos LIKE '%Fortress%')
BEGIN
DECLARE @GUILD varchar(25)

SELECT @GUILD = Name
FROM _Guild G
INNER JOIN _GuildMember GM ON G.ID = GM.GuildID
WHERE GM.CharID = @CharID

IF NOT EXISTS (SELECT * FROM VSRO.._FW_KILLS_LOG WHERE CHARNAME = @CharID)
INSERT INTO VSRO.._FW_KILLS_LOG VALUES (@CharID,1,@GUILD)
ELSE
UPDATE VSRO.._FW_KILLS_LOG SET [KILL] += 1, Guild=@GUILD
WHERE CHARNAME = @CharID
END

---

5) Death Tracking System

Monitors player death events and logs them accordingly.



IF @EventID = '20'
BEGIN
IF (@strPos LIKE '%(0x5cb6)%')
EXEC VSRO.._ROS_CheckPlayerDead @charid,@desc

ELSE IF (@strPos LIKE '%(0x63ec)%')
EXEC VSRO.._MD_KillFetch @Desc
END

---

6) Database Patch

Adds required columns for full system support.



ALTER TABLE _Char ADD ItemPoints int NOT NULL DEFAULT 0;
ALTER TABLE _Char ADD Reward int NOT NULL DEFAULT 0;
ALTER TABLE _Guild ADD ItemPoints int NOT NULL DEFAULT 0;

---

7) Skill Update Procedure

Automatically rebuilds character skills based on mastery levels.


✔ Removes invalid skills
✔ Inserts valid mastery skills
✔ Maintains default skill integrity

---

8) Item Add System

Procedure for spawning items by character name.


✔ Inventory slot detection
✔ Serial generation system
✔ Item validation check

---

9) Silk Web Purchase System Fix

Fixes Silk purchase transactions and prevents duplicate orders.


✔ Transaction safety
✔ Order validation
✔ Silk logging system

---

10) UI / Event Text System

Custom global messages for unique monsters and events:

• Tiger Girl appeared
• Cerberus spawned
• Uruchi spawned
• Isyutaru spawned
• Lord Yarkan spawned
• Demon Shaitan spawned

---

FINAL RESULT

This Athena Filter system provides:


✔ Full server event framework
✔ Player & guild progression system
✔ Advanced logging system
✔ PvP & fortress tracking
✔ Economy & silk integration
✔ Stable database architecture