Title: [Request / Share] In-Game Premium Silk Scroll System — SQL Trigger & Procedure
Hi epvp community,
I am currently setting up an in-game tradable Silk Scroll system so players can right-click to instantly redeem Silk into their accounts.
Here are the IDs and CodeNames from _RefObjCommon:
43475 - ITEM_PRE_MALL_RIGID_PREMIUM_SILK_01 (50 Silk)
43476 - ITEM_PRE_MALL_RIGID_PREMIUM_SILK_02 (100 Silk)
43477 - ITEM_PRE_MALL_RIGID_PREMIUM_SILK_03 (200 Silk)
43478 - ITEM_PRE_MALL_RIGID_PREMIUM_SILK_04 (300 Silk)
43479 - ITEM_PRE_MALL_RIGID_PREMIUM_SILK_05 (400 Silk)
43480 - ITEM_PRE_MALL_RIGID_PREMIUM_SILK_06 (500 Silk)
I am looking for an optimized trigger or stored procedure hook (preferably via _LogEventItem or shard item logs) that updates SK_Silk in the ACCOUNT database cleanly.
Key points I want to ensure:
Exploit & Dupe Prevention: Safe against rapid-click/spamming, rollbacks, or deadlocks.
Performance: Lightweight execution without causing GameServer lag or log table bottlenecks.
In-game Notice: Cleanest method to notify the character (private notice/whisper) immediately upon consumption.
If anyone has a tested, battle-proof script or query structure for this scroll set, please share your code and recommendations. Any advice is greatly appreciated!
Hi epvp community,
I am currently setting up an in-game tradable Silk Scroll system so players can right-click to instantly redeem Silk into their accounts.
Here are the IDs and CodeNames from _RefObjCommon:
43475 - ITEM_PRE_MALL_RIGID_PREMIUM_SILK_01 (50 Silk)
43476 - ITEM_PRE_MALL_RIGID_PREMIUM_SILK_02 (100 Silk)
43477 - ITEM_PRE_MALL_RIGID_PREMIUM_SILK_03 (200 Silk)
43478 - ITEM_PRE_MALL_RIGID_PREMIUM_SILK_04 (300 Silk)
43479 - ITEM_PRE_MALL_RIGID_PREMIUM_SILK_05 (400 Silk)
43480 - ITEM_PRE_MALL_RIGID_PREMIUM_SILK_06 (500 Silk)
I am looking for an optimized trigger or stored procedure hook (preferably via _LogEventItem or shard item logs) that updates SK_Silk in the ACCOUNT database cleanly.
Key points I want to ensure:
Exploit & Dupe Prevention: Safe against rapid-click/spamming, rollbacks, or deadlocks.
Performance: Lightweight execution without causing GameServer lag or log table bottlenecks.
In-game Notice: Cleanest method to notify the character (private notice/whisper) immediately upon consumption.
If anyone has a tested, battle-proof script or query structure for this scroll set, please share your code and recommendations. Any advice is greatly appreciated!