[CLUB]
[/CLUB]
SQL:
Prosedür için CharID ve İtem Seri numaralarını Oto Aktaracak Tablomuzu oluşturalım.
USE [SRO_VT_LOG]
GO
/****** Object: Table [dbo].[_ItemsDrop] Script Date: 8.09.2023 21:43:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_ItemsDrop](
[CharID] [int] NULL,
[Serial64] [bigint] NULL
) ON [PRIMARY]
GO
SQL:
-------------------SOS MOON SUN NOTİCE---------------
--if @Operation in(30,114) and not exists (select * from SRO_VT_LOG.._ItemsDrop where Serial64=@ItemSerial) begin
--declare @rare int=(select count(*) from SRO_VT_SHARD.._RefObjCommon where ID=@ItemRefID and CodeName128 like '%C_RARE%')
--declare @charname varchar(64)=(select CharName16 from SRO_VT_SHARD.._Char where CharID=@CharID)
--if @rare>0 begin
--insert into SRO_VT_LOG.._ItemsDrop values (@CharID,@ItemSerial)
--declare @itemname varchar(128)=(select EndTextString from Panel.._EquipName a inner join SRO_VT_SHARD.._RefObjCommon b on b.NameStrID128=a.TextString where b.ID=@ItemRefID)
--insert into SRO_VT_SHARDLOG..iLegend_Tool (Service,Type,Target,Message,Date) values (1,'Global',@CharName16,'['+@charname+'] karakteri ['+@itemname+'(Sun)] itemini elde etmiştir.' ,GETDATE())
--end
--end
