المشاركة الأصلية كتبت بواسطة holakoo55
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
مطلوب Procedures
كامله لل vsro multi tools
لان مفهاش send notice
ولا حاجات كتيره
ياريت object كامل
اهو
كود PHP:
Use [SRO_VT_SHARDLOG] --# write database name [Whatever] *Written database name must be exists. Go Create Table [dbo].[iLegend_Tool] -- common table ([ID][Int] NOT NULL Primary Key Identity , [Service][Int] NOT NULL , [Type][Varchar](50) NOT NULL , [Target][Varchar](60) , [Message][Varchar](Max) , [RefMobID][Varchar](10) , [RefItemID][Varchar](10) , [Amount][Varchar](4) , [OptLvl][Varchar](3) , [RegionID][Varchar](50) , [PosX][Varchar](50) , [PosY][Varchar](50) , [PosZ][Varchar](50) , [WorldID][Varchar](50) , [CapeColor][Varchar](10) , [StallTitle][Varchar](100) , [StallGreating][Varchar](100) , [StallSlot][Varchar](1) , [InvSlot][Varchar](3) , [ItemCount][Varchar](10) , [ItemPrice][Varchar](20) , [Date][Varchar](100) NOT NULL);
Go Create Table [dbo].[_IncomingGlobalChat] -- global log table ([ID][Int] NOT NULL Primary Key Identity , [CharName][Varchar](60) NOT NULL , [GlobalChat][Varchar](Max) NOT NULL , [Date][Varchar](100) NOT NULL);
Go Create Table [dbo].[_IncomingPrivateChat] -- private chat log table ([ID][Int] NOT NULL Primary Key Identity , [CharName][Varchar](60) NOT NULL , [Chat][Varchar](Max) NOT NULL , [Date][Varchar](100) NOT NULL);
Go Create Table [dbo].[_UniquesLog] ([ID][Int] NOT NULL Primary Key Identity , -- unique log table [Type][Int] NOT NULL , [CodeName128][Varchar](128) NOT NULL , [Killer][Varchar](60) , [Date][Varchar](100) NOT NULL);
Go Create table [dbo].[StallItemBuyers] ([ID][Int] NOT NULL Primary Key Identity , -- stall buyers table [BuyerName][Varchar](50) NOT NULL , [StallSlot][INT] NOT NULL , [Date][Varchar](100) NOT NULL)
Go Create table [dbo].[ExecQuery] ([ID][Int] NOT NULL Primary Key Identity , -- execute queries table [Day][Varchar](50) NOT NULL , [Time][Varchar](50) NOT NULL , [DatabaseIndex][INT] NOT NULL , [Query][Varchar](8000) NOT NULL)
Go Create Procedure [dbo].[_Add_IncomingChat] -- save incoming chat procedure @Type [Varchar](60) , @CharName [Varchar](60) , @Message [Varchar](Max) As -------------------------------------------------------------------------------------------------------------------------- -- @Type = 1 means private chat -- @Type = 2 means global chat
IF @Type = 1 Begin Insert Into [dbo].[_IncomingPrivateChat] (CharName,Chat,Date) Values (@CharName,@Message,GETDATE()) End
IF @Type = 2 Begin Insert Into [dbo].[_IncomingGlobalChat] (CharName,GlobalChat,Date) Values (@CharName,@Message,GETDATE()) End
Go Create Procedure [dbo].[_Add_UniqueLog] -- save unique log procedure @Type [Varchar](1) , @RefMonsterID [Int] , @Killer [Varchar](60) As Declare @CodeName Varchar(128) = (Select CodeName128 From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where ID = @RefMonsterID) -------------------------------------------------------------------------------------------------------------------------- -- @Type = 1 means Spawned -- @Type = 2 means Killed
Insert Into [dbo].[_UniquesLog] (Type,CodeName128,Killer,Date) Values (@Type,@CodeName,@Killer,GETDATE())
GO Create Procedure [dbo].[_ExecuteAfterTime] @CoolTime Varchar(10) , -- For example '00:00:05' (for execute query after 5 seconds from time now) @Query Varchar(Max)
As -------------------------------------------------------------------------------------------------------------------------- Declare @Time Time(0) , @ID Varchar(20)
Set @Time = Getdate() + @CoolTime Set @ID = (Select Max(ID) From [dbo].[ExecQuery]) IF @ID Is Null Set @ID = 1 ELSE Set @ID = @ID + 1 Set @Query = @Query + ' Delete From [dbo].[ExecQuery] Where ID = ' + @ID
Set Identity_Insert [dbo].[ExecQuery] ON Insert into ExecQuery (ID,Day,Time,DatabaseIndex,Query) Values (@ID,'Always',@Time,1,@Query) Set Identity_Insert [dbo].[ExecQuery] OFF
المشاركة الأصلية كتبت بواسطة DarkTeam
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
اهو
كود PHP:
Use [SRO_VT_SHARDLOG] --# write database name [Whatever] *Written database name must be exists.
Go
Create Table [dbo].[iLegend_Tool] -- common table
([ID][Int] NOT NULL Primary Key Identity ,
[Service][Int] NOT NULL ,
[Type][Varchar](50) NOT NULL ,
[Target][Varchar](60) ,
[Message][Varchar](Max) ,
[RefMobID][Varchar](10) ,
[RefItemID][Varchar](10) ,
[Amount][Varchar](4) ,
[OptLvl][Varchar](3) ,
[RegionID][Varchar](50) ,
[PosX][Varchar](50) ,
[PosY][Varchar](50) ,
[PosZ][Varchar](50) ,
[WorldID][Varchar](50) ,
[CapeColor][Varchar](10) ,
[StallTitle][Varchar](100) ,
[StallGreating][Varchar](100) ,
[StallSlot][Varchar](1) ,
[InvSlot][Varchar](3) ,
[ItemCount][Varchar](10) ,
[ItemPrice][Varchar](20) ,
[Date][Varchar](100) NOT NULL);
Go
Create Table [dbo].[_IncomingGlobalChat] -- global log table
([ID][Int] NOT NULL Primary Key Identity ,
[CharName][Varchar](60) NOT NULL ,
[GlobalChat][Varchar](Max) NOT NULL ,
[Date][Varchar](100) NOT NULL);
Go
Create Table [dbo].[_IncomingPrivateChat] -- private chat log table
([ID][Int] NOT NULL Primary Key Identity ,
[CharName][Varchar](60) NOT NULL ,
[Chat][Varchar](Max) NOT NULL ,
[Date][Varchar](100) NOT NULL);
Go
Create Table [dbo].[_UniquesLog]
([ID][Int] NOT NULL Primary Key Identity , -- unique log table
[Type][Int] NOT NULL ,
[CodeName128][Varchar](128) NOT NULL ,
[Killer][Varchar](60) ,
[Date][Varchar](100) NOT NULL);
Go
Create table [dbo].[StallItemBuyers]
([ID][Int] NOT NULL Primary Key Identity , -- stall buyers table
[BuyerName][Varchar](50) NOT NULL ,
[StallSlot][INT] NOT NULL ,
[Date][Varchar](100) NOT NULL)
Go
Create table [dbo].[ExecQuery]
([ID][Int] NOT NULL Primary Key Identity , -- execute queries table
[Day][Varchar](50) NOT NULL ,
[Time][Varchar](50) NOT NULL ,
[DatabaseIndex][INT] NOT NULL ,
[Query][Varchar](8000) NOT NULL)
Go
Create Procedure [dbo].[_Add_IncomingChat] -- save incoming chat procedure
@Type [Varchar](60) ,
@CharName [Varchar](60) ,
@Message [Varchar](Max)
As
--------------------------------------------------------------------------------------------------------------------------
-- @Type = 1 means private chat
-- @Type = 2 means global chat
IF @Type = 1
Begin
Insert Into [dbo].[_IncomingPrivateChat] (CharName,Chat,Date) Values (@CharName,@Message,GETDATE())
End
IF @Type = 2
Begin
Insert Into [dbo].[_IncomingGlobalChat] (CharName,GlobalChat,Date) Values (@CharName,@Message,GETDATE())
End
Go
Create Procedure [dbo].[_Add_UniqueLog] -- save unique log procedure
@Type [Varchar](1) ,
@RefMonsterID [Int] ,
@Killer [Varchar](60)
As
Declare @CodeName Varchar(128) = (Select CodeName128 From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where ID = @RefMonsterID)
--------------------------------------------------------------------------------------------------------------------------
-- @Type = 1 means Spawned
-- @Type = 2 means Killed
Insert Into [dbo].[_UniquesLog] (Type,CodeName128,Killer,Date) Values (@Type,@CodeName,@Killer,GETDATE())
GO
Create Procedure [dbo].[_ExecuteAfterTime]
@CoolTime Varchar(10) , -- For example '00:00:05' (for execute query after 5 seconds from time now)
@Query Varchar(Max)
As
--------------------------------------------------------------------------------------------------------------------------
Declare @Time Time(0) , @ID Varchar(20)
Set @Time = Getdate() + @CoolTime
Set @ID = (Select Max(ID) From [dbo].[ExecQuery])
IF @ID Is Null Set @ID = 1 ELSE Set @ID = @ID + 1
Set @Query = @Query + ' Delete From [dbo].[ExecQuery] Where ID = ' + @ID
Set Identity_Insert [dbo].[ExecQuery] ON
Insert into ExecQuery (ID,Day,Time,DatabaseIndex,Query) Values (@ID,'Always',@Time,1,@Query)
Set Identity_Insert [dbo].[ExecQuery] OFF