Ü
skill mastery kastettim ch eu o scrola basınca misal fire scrola basınca fireyi 120 yapıp tüm skilleri maxlayacak
MEGA provides free cloud storage with convenient and powerful always-on privacy. Claim your free 20GB nowmega.nz
vSRO Paylaşım Addlogitem prosedürleri işinize yarayabilir...
- Konuyu Başlatan vsroorg
- Başlangıç tarihi
Ü
prosedur 110 ve 120 yazıyorya burdaki kodları nereye yapıştırıyoruz shard mı log mu hangisi ?MEGA provides free cloud storage with convenient and powerful always-on privacy. Claim your free 20GB now
Bu da benden olsun belirlenen Levele ulaşınca hediye verme. Tablo bug yapılmaması için önemlidir.
USE [SRO_VT_LOG]
GO
/****** Object: Table [dbo].[_MaxLevelGift] Script Date: 22.04.2019 00:38:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_MaxLevelGift](
[CharName] [varchar](max) NULL,
[Zaman] [datetime] NULL,
[index] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK__MaxLevelGift] PRIMARY KEY CLUSTERED
(
[index] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
GO
/****** Object: Table [dbo].[_MaxLevelGift] Script Date: 22.04.2019 00:38:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_MaxLevelGift](
[CharName] [varchar](max) NULL,
[Zaman] [datetime] NULL,
[index] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK__MaxLevelGift] PRIMARY KEY CLUSTERED
(
[index] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
if (@EventID = 22)
BEGIN
if (@Data2 = 90)
BEGIN
DECLARE @Date VARCHAR(100) = (SELECT GETDATE())
DECLARE @AccountID_1 varchar(128) = (Select AccountID From SRO_VT_SHARD.dbo._AccountJID as J inner join SRO_VT_SHARD.dbo._User as U ON J.JID = U.UserJID where CharID = @CharID)
if not exists (select CharName from _MaxLevelGift where CharName = @Charname16)
begin
insert into _MaxLevelGift values (@Charname16,@Date)
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_EVENT_GLOBAL_CHATTING', 1, 0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_EVENT_REVERSE_RETURN_SCROLL', 1, 0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_COS_T_BUFFALO_SCROLL',1,1
END
end
END
BEGIN
if (@Data2 = 90)
BEGIN
DECLARE @Date VARCHAR(100) = (SELECT GETDATE())
DECLARE @AccountID_1 varchar(128) = (Select AccountID From SRO_VT_SHARD.dbo._AccountJID as J inner join SRO_VT_SHARD.dbo._User as U ON J.JID = U.UserJID where CharID = @CharID)
if not exists (select CharName from _MaxLevelGift where CharName = @Charname16)
begin
insert into _MaxLevelGift values (@Charname16,@Date)
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_EVENT_GLOBAL_CHATTING', 1, 0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_EVENT_REVERSE_RETURN_SCROLL', 1, 0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_COS_T_BUFFALO_SCROLL',1,1
END
end
END
Ü
100 Levele ulaştınız (20/100)
misal 100 kişilik svde 20 kişi ulaşmış sende buna dahilsin gibi bir oyunda görmüştüm notice atıyordu yukarda ardından ışınlan hediyeni al gibi birşey yazıyordu onun query nedir ?
Elinize emeğinize sağlık, harika anlatım ve güzel eklemeler yapılmış takipçi arkadaşlarımız tarafından. Herkese teşekkürler 
Kodlar biraz karışık oldu ama olsun, gecenin bu saatinde anca bu kadar olur.Tabloları ve prosedürü eksiksiz eklediğiz zaman herhangi bir bug ve sıkıntı çıkmamaktadır.
Gerekli yerleri kendinize göre düzenleyip kullanabilirsiniz.
Notice sistemi için MultiTool v1.8 programı kullanılmıştır.
USE [SRO_VT_LOG]
GO
/****** Object: Table [dbo].[_MaxLevelGift] Script Date: 22.04.2019 03:05:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_MaxLevelGift](
[CharName] [varchar](max) NULL,
[Zaman] [datetime] NULL,
[Service1] [int] NULL,
[index] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK__MaxLevelGift] PRIMARY KEY CLUSTERED
(
[index] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
GO
/****** Object: Table [dbo].[_MaxLevelGift] Script Date: 22.04.2019 03:05:52 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_MaxLevelGift](
[CharName] [varchar](max) NULL,
[Zaman] [datetime] NULL,
[Service1] [int] NULL,
[index] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK__MaxLevelGift] PRIMARY KEY CLUSTERED
(
[index] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [SRO_VT_LOG]
GO
/****** Object: Table [dbo].[_MaxLevelKontrol] Script Date: 22.04.2019 03:05:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_MaxLevelKontrol](
[CharName] [varchar](max) NULL,
[Zaman] [datetime] NULL,
[index] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK__MaxLevelKontrol] PRIMARY KEY CLUSTERED
(
[index] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
GO
/****** Object: Table [dbo].[_MaxLevelKontrol] Script Date: 22.04.2019 03:05:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_MaxLevelKontrol](
[CharName] [varchar](max) NULL,
[Zaman] [datetime] NULL,
[index] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK__MaxLevelKontrol] PRIMARY KEY CLUSTERED
(
[index] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
---------------------------------------------MAX Lv Reward
IF (@EventID=9 or @EventID=4)
DECLARE @Date VARCHAR(100) = (SELECT GETDATE())
DECLARE @Service INT
SET @Service = (SELECT TOP 1 Service1 FROM _MaxLevelGift WHERE CharName = @Charname16)
DECLARE @AccountID_1 varchar(128) = (Select AccountID From SRO_VT_SHARD.dbo._AccountJID as J inner join SRO_VT_SHARD.dbo._User as U ON J.JID = U.UserJID where CharID = @CharID)
begin
if not exists (select CharName from _MaxLevelGift where CharName = @Charname16)
insert into _MaxLevelGift (CharName,Zaman,Service1) values (@Charname16,@Date,0)
if (@EventID = 22)
BEGIN
if (@Data2 = 90)
BEGIN
IF (SELECT COUNT(*) FROM _MaxLevelGift WHERE [Service1]=1)<100
BEGIN
UPDATE _MaxLevelGift SET [Service1]=1 WHERE CharName = @Charname16
DECLARE @MaxLvSayi VARCHAR (100)
SET @MaxLvSayi = (SELECT COUNT(*) FROM _MaxLevelGift WHERE [Service1]=1)
begin
if not exists (select CharName from _MaxLevelKontrol where CharName = @Charname16)
begin
insert into _MaxLevelKontrol values (@Charname16,@Date)
insert into SRO_VT_MULTITOOLS..iLegend_Tool (Service,Type,Message,Date) values ('1','Notice','Tebrikler '+@CharName16+' son Seviyeye ulaştınız. ['+@MaxLvSayi+'/100]',GETDATE())
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_EVENT_GLOBAL_CHATTING', 1, 0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_EVENT_REVERSE_RETURN_SCROLL', 1, 0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_COS_T_BUFFALO_SCROLL',1,1
end
end
end
end
END
end
--------------------------------------MAX Lv Reward END-----------------------
IF (@EventID=9 or @EventID=4)
DECLARE @Date VARCHAR(100) = (SELECT GETDATE())
DECLARE @Service INT
SET @Service = (SELECT TOP 1 Service1 FROM _MaxLevelGift WHERE CharName = @Charname16)
DECLARE @AccountID_1 varchar(128) = (Select AccountID From SRO_VT_SHARD.dbo._AccountJID as J inner join SRO_VT_SHARD.dbo._User as U ON J.JID = U.UserJID where CharID = @CharID)
begin
if not exists (select CharName from _MaxLevelGift where CharName = @Charname16)
insert into _MaxLevelGift (CharName,Zaman,Service1) values (@Charname16,@Date,0)
if (@EventID = 22)
BEGIN
if (@Data2 = 90)
BEGIN
IF (SELECT COUNT(*) FROM _MaxLevelGift WHERE [Service1]=1)<100
BEGIN
UPDATE _MaxLevelGift SET [Service1]=1 WHERE CharName = @Charname16
DECLARE @MaxLvSayi VARCHAR (100)
SET @MaxLvSayi = (SELECT COUNT(*) FROM _MaxLevelGift WHERE [Service1]=1)
begin
if not exists (select CharName from _MaxLevelKontrol where CharName = @Charname16)
begin
insert into _MaxLevelKontrol values (@Charname16,@Date)
insert into SRO_VT_MULTITOOLS..iLegend_Tool (Service,Type,Message,Date) values ('1','Notice','Tebrikler '+@CharName16+' son Seviyeye ulaştınız. ['+@MaxLvSayi+'/100]',GETDATE())
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_EVENT_GLOBAL_CHATTING', 1, 0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_EVENT_REVERSE_RETURN_SCROLL', 1, 0
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN_CHEST @AccountID_1, 'ITEM_COS_T_BUFFALO_SCROLL',1,1
end
end
end
end
END
end
--------------------------------------MAX Lv Reward END-----------------------
Buyrun arkadaşlar belki işinize yarar...
EXEC komutunun yönlendirdiği SRO_VT_LOG.dbo._Scroll olmadan bazıları hic bir ise yaramaz.
Bu konuyu görüntüleyen kullanıcılar
Benzer konular
- Kilitli
- Soru
