vSro Paylaşım vSRO Otomatik Max Level Ödül Sistemi (Top 100 Silk Ödülü)

USE [SRO_VT_LOG]
GO

IF OBJECT_ID('dbo._EventMaxLevelChar', 'U') IS NOT NULL
    DROP TABLE dbo._EventMaxLevelChar
GO

CREATE TABLE dbo._EventMaxLevelChar(
    [ID] INT IDENTITY(1,1) NOT NULL,
    [UserJID] INT NULL,
    [CharID] INT NULL,
    [CharName] VARCHAR(16) NULL,
    [Sira] INT NULL,
    [SilkAmount] INT NULL,
    [Active] INT DEFAULT 0,
    [Zaman] DATETIME DEFAULT GETDATE(),
    CONSTRAINT [PK__EventMaxLevelChar] PRIMARY KEY CLUSTERED ([ID] ASC)
)
GO

USE [SRO_VT_LOG]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE OR ALTER PROCEDURE dbo._EventMaxLevel
    @CharID INT
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @Charname16 VARCHAR(16)
    DECLARE @JID INT

    -- Karakter ve Kullanıcı JID Bilgisini Çek
    SELECT @Charname16 = C.CharName16, @JID = U.UserJID
    FROM SRO_VT_SHARD.dbo._Char AS C
    INNER JOIN SRO_VT_SHARD.dbo._User AS U ON C.CharID = U.CharID
    WHERE C.CharID = @CharID

    DECLARE @EventLevel INT = 100 -- Hedef Seviye Sınırı (Cap)

    -- Karakter daha önce bu ödülü almadıysa işleme başla
    IF NOT EXISTS (SELECT 1 FROM dbo._EventMaxLevelChar WHERE CharID = @CharID)
    BEGIN
        -- Mevcut kayıtlı kişi sayısına göre sıralamayı hesapla
        DECLARE @Sira INT = (SELECT COUNT(ID) FROM dbo._EventMaxLevelChar) + 1

        -- Sadece ilk 100 kişiyi ödüllendir
        IF (@Sira <= 100)
        BEGIN
            DECLARE @SilkAmount INT = 0

            -- Kademeli Silk Ödül Dağılımı
            IF (@Sira = 1)                 SET @SilkAmount = 300
            ELSE IF (@Sira BETWEEN 2 AND 10)   SET @SilkAmount = 200
            ELSE IF (@Sira BETWEEN 11 AND 20)  SET @SilkAmount = 140
            ELSE IF (@Sira BETWEEN 21 AND 30)  SET @SilkAmount = 130
            ELSE IF (@Sira BETWEEN 31 AND 40)  SET @SilkAmount = 120
            ELSE IF (@Sira BETWEEN 41 AND 50)  SET @SilkAmount = 110
            ELSE IF (@Sira BETWEEN 51 AND 60)  SET @SilkAmount = 100
            ELSE IF (@Sira BETWEEN 61 AND 70)  SET @SilkAmount = 90
            ELSE IF (@Sira BETWEEN 71 AND 80)  SET @SilkAmount = 80
            ELSE IF (@Sira BETWEEN 81 AND 90)  SET @SilkAmount = 70
            ELSE IF (@Sira BETWEEN 91 AND 100) SET @SilkAmount = 60

            -- Tabloya kayıt aç
            INSERT INTO dbo._EventMaxLevelChar (UserJID, CharID, CharName, Sira, SilkAmount, Active, Zaman)
            VALUES (@JID, @CharID, @Charname16, @Sira, @SilkAmount, 1, GETDATE())

            -- Silk Yükleme İşlemi (SK_Silk)
            IF EXISTS (SELECT 1 FROM SRO_VT_ACCOUNT.dbo.SK_Silk WHERE JID = @JID)
            BEGIN
                UPDATE SRO_VT_ACCOUNT.dbo.SK_Silk 
                SET silk_own = silk_own + @SilkAmount 
                WHERE JID = @JID
            END
            ELSE
            BEGIN
                INSERT INTO SRO_VT_ACCOUNT.dbo.SK_Silk (JID, silk_own, silk_gift, silk_point) 
                VALUES (@JID, @SilkAmount, 0, 0)
            END

            -- MaxiGuard Notice Bildirimi
            DECLARE @Message NVARCHAR(500) = '[' + CAST(@Sira AS VARCHAR(5)) + ']. Karakter ' + CAST(@EventLevel AS VARCHAR(5)) + ' Seviyeye Ulaştı: [' + @Charname16 + '] ' + CAST(@SilkAmount AS VARCHAR(10)) + ' Silk Kazandı!'
            
            INSERT INTO MaxiGuard_User.._BridgeCommands (CommandID, Executor, Data1, Data2, Data3, [Date])
            VALUES (500, 'Sistem', '17', @Message, 'Duyuru', GETDATE())

            -- 100. Kişiye Ulaşıldığında Etkinlik Bitiş Notice'i
            IF (@Sira = 100)
            BEGIN
                DECLARE @EndMsg NVARCHAR(500) = 'TOP 100 (' + CAST(@EventLevel AS VARCHAR(5)) + ' Cap) Seviye Etkinliği Tamamlanmıştır.'
                INSERT INTO MaxiGuard_User.._BridgeCommands (CommandID, Executor, Data1, Data2, Data3, [Date])
                VALUES (500, 'Sistem', '17', @EndMsg, 'Duyuru', GETDATE())
            END
        END
    END
END
GO

-- ===================================================================
-- MAX LEVEL LOG TETİKLEYİCİSİ
-- @Data2: Karakterin ulaştığı yeni leveli temsil eder (Örn: 100)
-- ===================================================================
IF (@EventID = 22 AND @Data2 = 100)
BEGIN
    EXEC dbo._EventMaxLevel @CharID
END