vSRO vSRO Max Level Query

vSRO_LoveR · 16 Ara 2025

SQL Query

SQL
IF (@EventID = 22 and @Data2 = 100) ---- Data2 = 100 olarak ayarlandı istediğiniz seviyeye Göre ayarlayabilirisniz. BEGIN Exec sro_vt_log.._EventMaxLevel @CharID END

SQLanoya kopyala
USE [SRO_VT_LOG] GO /****** Nesne: StoredProcedure [dbo].[_EventMaxLevel] Script Tarihi: 5.09.2023 15:43:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[_EventMaxLevel] @CharID INT AS BEGIN DECLARE @Charname16 VARCHAR(16) DECLARE @JID INT SELECT @Charname16 = C.CharName16, @JID = U.UserJID FROM SRO_VT_SHARD.._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 --- Seviye Sınırı Bildirim IF NOT EXISTS (SELECT CharName FROM _EventMaxLevelChar WHERE CharName = @Charname16) BEGIN INSERT INTO _EventMaxLevelChar (UserJID, CharID, CharName, '1', '0', GETDATE()) VALUES (@JID, @CharID, @Charname16, '1', '0', GETDATE()) END DECLARE @Total INT = (SELECT SUM(Total) FROM _EventMaxLevelChar) DECLARE @Active INT = (SELECT Active FROM _EventMaxLevelChar WHERE CharName = @Charname16) IF @Total <= 100 BEGIN DECLARE @SilkAmount INT IF (@Total = 1) SET @SilkAmount = 300 ELSE IF (@Total BETWEEN 2 AND 10) SET @SilkAmount = 200 ELSE IF (@Total BETWEEN 11 AND 20) SET @SilkAmount = 140 ELSE IF (@Total BETWEEN 21 AND 30) SET @SilkAmount = 130 ELSE IF (@Total BETWEEN 31 AND 40) SET @SilkAmount = 120 ELSE IF (@Total BETWEEN 41 AND 50) SET @SilkAmount = 110 ELSE IF (@Total BETWEEN 51 AND 60) SET @SilkAmount = 100 ELSE IF (@Total BETWEEN 61 AND 70) SET @SilkAmount = 90 ELSE IF (@Total BETWEEN 71 AND 80) SET @SilkAmount = 80 ELSE IF (@Total BETWEEN 81 AND 90) SET @SilkAmount = 70 ELSE IF (@Total BETWEEN 91 AND 100) SET @SilkAmount = 60 IF (@Active = 0) BEGIN IF EXISTS (SELECT * 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 DECLARE @Message NVARCHAR(MAX) = FORMATMESSAGE('[%s]. Karakter Seviye %s : [%s] %s kadar Silk kazandı.', @Total, @EventLevel, @Charname16, @SilkAmount) INSERT INTO MaxiGuard_User.._BridgeCommands (CommandID, Executor, Data1, Data2, Data3, Date) VALUES (500, 'Sistem', '17', @Message, 'Duyuru', GETDATE()) UPDATE _EventMaxLevelChar SET Active = 1 WHERE CharID = @CharID IF (@Total = 100) BEGIN INSERT INTO MaxiGuard_User.._BridgeCommands (CommandID, Executor, Data1, Data2, Data3, Date) VALUES (500, 'Sistem', '17', 'TOP 100 ('+CAST(@EventLevel AS VARCHAR(20))+') Seviye Etkinliği sona erdi.', 'Duyuru', GETDATE()) END END END END

SQL:
USE [SRO_VT_LOG] GO /****** Object: Table [dbo].[_EventMaxLevelChar] Script Date: 5.09.2023 16:05:27 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[_EventMaxLevelChar]( [ID] [int] IDENTITY(1,1) NOT NULL, [UserJID] [int] NULL, [CharID] [int] NULL, [CharName] [varchar](16) NULL, [Total] [int] NULL, [Active] [int] NULL, [Zaman] [datetime] NULL, CONSTRAINT [PK__EventMaxLevel] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO

vSRO vSRO Max Level Query

vSRO_LoveR

Ekli dosyalar