[Request / Share] SQL Trigger & Procedure for Premium Silk Scrolls (ITEM_PRE_MALL_RIG

[tuanchelsea]

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!

[Devsome]

#moved