elbattawy1st
31-05-2016, 02:01 AM
الــــــســـــــــــلام عـــــــــلــــــيــــــــــكــــــم و رحــــــــمــــــه الـــلـــــه وبـــــــربــــــــكــــــاتــــــه
السيستم دا عباره عن انو بيمنع spy الابيحصل فى FTW
فكره السيستم :
اول ما Master Guild يشوف spy عندة فى FTW هيقوم مكلم اكونت جى ام الا انت فاتحو
بالبرنامج و هيقولو الكلمة دى Spy System الاكونت جى ام هيبعتلو Guide علشان يعرف
يشغل السييتم
وبعد كده تكتب اسم كاركتر الا بيعمل SPY هتكتب اسم (كاركتر بس) وتبعتو لجى ام
اول مره هيعمل Spy الكاركتر هياخد DC
وتانى مره هيعمل Spy الكاكتر هياخد DC و Ban من السيرفر
علشان الاعب يعرف شغل السيستم :
1- لازم يكون Master Guild
2- لازم يكونو Master Guild و الكاركتر الا هياخد Ban فى نفس الجيلد
-------------------------- Version 1 -------------------------------------
هتعمل دا
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Trigger [dbo].[SPY] Script Date: 5/31/2016 12:52:14 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Abdelrhman Elbattawy
-- =============================================
CREATE TRIGGER [dbo].[SPY]
ON [dbo].[_IncomingPrivateChat]
after insert
as
-----------------------------------------------------------------------------------------------------
DECLARE @CharNameMaster varchar(60) , @Chat varchar(MAX) ,@Question nvarchar(MAX) ,@CharNameReal varchar(60) ,@USERID varchar(25)
,@GuildIDMaster int ,@GuildIDMember int ,@Permission int ,@CharIDMaster int ,@CharIDMember int ,@Times int ,@USERJID int
BEGIN
Select @CharNameMaster=CharName ,@Chat=Chat From _IncomingPrivateChat
/***************************************** Start System ************************************************** *************/
IF(@Chat='SPY System')
Begin
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@CharNameMaster,'This System For Master Guild Only if u are real Master Guild',Getdate())
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@CharNameMaster,'Write a Correct name of char which u wann to ban him',Getdate())
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@CharNameMaster,'Pm me With Name Only (Correct Name)',Getdate())
END
--------------------------- require part (Select varaibles) --------------------------------------------
SET @CharIDMaster =(Select CharID From [SRO_VT_SHARD].[dbo].[_Char] where CharName16=@CharNameMaster)
SET @CharIDMember =(Select CharID From [SRO_VT_SHARD].[dbo].[_Char] where CharName16=@Chat)
SET @Permission =(Select Permission From [SRO_VT_SHARD].[dbo].[_GuildMember] where CharID=@CharIDMaster)
SET @GuildIDMaster =(Select GuildID From [SRO_VT_SHARD].[dbo].[_Char] where CharName16=@CharNameMaster)
SET @GuildIDMember =(Select GuildID From [SRO_VT_SHARD].[dbo].[_Char] where CharName16=@Chat)
SET @Times =(Select Times From FTW_SPY where CharName=@Chat)
SET @USERJID =(SELECT userjid FROM [SRO_VT_SHARD].[dbo].[_User] where CharID = @CharIDMember)
SET @USERID =(Select StrUserID FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] where JID = @USERJID)
-------------------------- Part to Excu Sys Warring (1) ------------------------------------------------------------
IF (@Chat in (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char]) And @Permission = '-1' And @GuildIDMaster = @GuildIDMember And @Times is NULL)
Begin
Insert Into iLegend_Tool (Service,Type,Target,Date) Values (1,'Disconnect',@Chat,Getdate())
Insert Into FTW_SPY (CharName,Times) Values (@Chat,'1')
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@CharNameMaster,'Secussfully ban .... ',Getdate())
END
-------------------------- Part to Excu Sys Warring (2) ------------------------------------------------------------
IF (@Chat in (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char]) And @Permission = '-1' And @GuildIDMaster = @GuildIDMember And @Times = '1')
Begin
Insert Into iLegend_Tool (Service,Type,Target,Date) Values (1,'Disconnect',@Chat,Getdate())
UPDATE FTW_SPY Set Times=2 where CharName=@Chat
Insert Into [SRO_VT_ACCOUNT].[dbo].[_Punishment] (UserJID,Type,Executor,Shard,CharName,CharInfo,Pos Info,Guide,Description,RaiseTime,BlockStartTime,Bl ockEndTime,PunishTime,Status)
Values (@USERJID,'1','Elbattawy','0',@chat,'1','1','Banne d','Trying to break FTW system',Getdate(),Getdate(),'2040-01-01 00:00:00.000','2040-01-01 00:00:00.000','0')
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@CharNameMaster,'Secussfully ban .... ',Getdate())
Insert Into [SRO_VT_ACCOUNT].[dbo].[_BlockedUser] (UserJID,UserID,Type,SerialNo,timeBegin,timeEnd) Values (@USERJID,@USERID,'1','1',Getdate(),'2040-01-01 00:00:00.000')
END
------------------------------ wrong INFO... ----------------------------------------------------------------------
IF (@Chat in (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char]) And @Permission = '0')
Begin
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@CharNameMaster,'u are not Master Guild Sorry Man ..... ',Getdate())
END
IF (@Chat in (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char]) And @Permission = '-1' And @GuildIDMaster != @GuildIDMember And @Times is NULL)
Begin
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@CharNameMaster,'Sorry Man this Char Not With u in Guild .........',Getdate())
END
/***************************************** End System ************************************************** *************/
END
GO
Table
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[FTW_SPY] Script Date: 5/31/2016 12:55:01 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FTW_SPY](
[CharName] [varchar](60) NOT NULL,
[Times] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
Program
لينك البرنامج من الموضوع الاصلى
Here (https://mega.nz/#!GQ4ilLzb!g3IqD_Qs0CCFTz7lWfzPAoQL1dktL3jZgyhYx_b oShQ)
DataBase (https://mega.nz/#!jpcngJDJ!CSJx5A3a8uUT1_2wR_FOQmryudC1GNpoLA2ZCOL UW7w)
فك الضغط هتلاقى 2 كويرى اعملهم و ظبط الاعدادات فى Config الموجود فى البرنامج
ودا لينك الموضوع الاصلى بتاع البرنامج هتلاقى فية الشرح البرنامج بتفصيل
Here (http://www.silkroad4arab.com/vb/showthread.php?t=599404)
-------------------------------- Version 2 ----------------------------------------
Logs :
1- تم حل بعض المشاكل الاكانت بتحصل فى اسم الكاركتر الا بتاخد ban
2- تم اضافه ان سيستم يشتغل فى وقت FTW بس
3- تم اضافه ان السيستم يشتغل بس فى Regions FTW
4- تم اضافه خاصيه block user (بمعنى مش كل شويه master guild هيدي ban لشخصيه الا هتعمل spy فاعلشان انا كدا انا حبيت اضيف حاجه جديده عن الاكان موجود فى version 1 الافى version 2 دا لما الشخصيه تعمل 2 spy هياخد block user لمده FTW بس بعد كدا هيتفك block)
5- تم منع ان Master Guild يدي نفسه DC علشان Cheat
6- تم تظبيط PMs (بمعنى لو char مش موجود فى الجيم هيجيلو رساله انو مش موجود , ولو مش فى ميعاد FTW هيجيلو رساله , ولو مش فى منطقه FTW هيجيلو رساله , ولو كاركتر واخد block user هيجيلو رساله , ولو هيدى نفسه dc هيجيلو رساله )
Downloads :
لازم تكون شغال بفيرجن الجديد بتاع برنامج Vsro Multi Tools
Tables :
FTW_SPY (https://mega.nz/#!mkdgiYIK!IDLDQ3pD6kgPgaqqWKo-Cr6jGOlNO6LmKn5IAd8VDro)
SPY_BLOCKUSER (https://mega.nz/#!ygl01IoZ!Oc0-WWYJlqbwBAvaXMmdKWEi8rogUutTu8BLRHvfVSE)
SPY_SERVICE (https://mega.nz/#!vwFwgR4C!IW_yFdWK8Drhs_s-jXgmkPqJ8PPaXCPWbu4gvyi7YpI)
SPY_REGIONS (https://mega.nz/#!C1MVTKZR!vYN-Dzmqzgf0jE3vJCLY5wD-_GBgdX0zejNsZVePamc)
Proc :
Main (https://mega.nz/#!fxFxyIQD!X9yY_6D9GacqYgTbIPmB6rPqU5Be5Ov_j5ypsXI RgbY)
ELBATTAWY_FTW_SPY (https://mega.nz/#!PtVihA4I!eDWcyAbrkcKEAn60OLLhaRKrF29OmEF0P2KxT9j Ofk4)
Guide :
بعد ما تعمل Exec للحاجات الا فوق
هتضيف Lines دى فى تابل Spy_Service
Spy System NULL
هتضيف Lines دى فى تابل Spy_Regions
14660
14661
14662
14663
14664
14916
14917
14918
14919
14920
15172
15173
15174
15175
15176
15428
15429
15430
15431
15432
15684
15685
15686
15687
15688
15940
15941
15942
15943
15944
16196
16197
16198
16199
16200
16452
16453
16454
16455
16456
17221
17222
17223
17224
17225
17229
17230
17231
17232
17477
17478
17479
17480
17481
17485
17486
17487
17488
17733
17734
17735
17736
17737
17741
17742
17743
17744
17989
17990
17991
17992
17993
17997
17998
17999
18000
هتضيف lines دى فى تابل ExecQuery
1 Friday 21:00:00 1 exec.[dbo].[ELBATTAWY_SPY_FTW] 0
2 Friday 23:00:00 1 exec.[dbo].[ELBATTAWY_SPY_FTW] 1
اول سطر وقت بدايه ال FTW
تانى سطر وقت نهايه ال FTW
Vedio
bXFxh2grGDM
السيستم دا عباره عن انو بيمنع spy الابيحصل فى FTW
فكره السيستم :
اول ما Master Guild يشوف spy عندة فى FTW هيقوم مكلم اكونت جى ام الا انت فاتحو
بالبرنامج و هيقولو الكلمة دى Spy System الاكونت جى ام هيبعتلو Guide علشان يعرف
يشغل السييتم
وبعد كده تكتب اسم كاركتر الا بيعمل SPY هتكتب اسم (كاركتر بس) وتبعتو لجى ام
اول مره هيعمل Spy الكاركتر هياخد DC
وتانى مره هيعمل Spy الكاكتر هياخد DC و Ban من السيرفر
علشان الاعب يعرف شغل السيستم :
1- لازم يكون Master Guild
2- لازم يكونو Master Guild و الكاركتر الا هياخد Ban فى نفس الجيلد
-------------------------- Version 1 -------------------------------------
هتعمل دا
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Trigger [dbo].[SPY] Script Date: 5/31/2016 12:52:14 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Abdelrhman Elbattawy
-- =============================================
CREATE TRIGGER [dbo].[SPY]
ON [dbo].[_IncomingPrivateChat]
after insert
as
-----------------------------------------------------------------------------------------------------
DECLARE @CharNameMaster varchar(60) , @Chat varchar(MAX) ,@Question nvarchar(MAX) ,@CharNameReal varchar(60) ,@USERID varchar(25)
,@GuildIDMaster int ,@GuildIDMember int ,@Permission int ,@CharIDMaster int ,@CharIDMember int ,@Times int ,@USERJID int
BEGIN
Select @CharNameMaster=CharName ,@Chat=Chat From _IncomingPrivateChat
/***************************************** Start System ************************************************** *************/
IF(@Chat='SPY System')
Begin
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@CharNameMaster,'This System For Master Guild Only if u are real Master Guild',Getdate())
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@CharNameMaster,'Write a Correct name of char which u wann to ban him',Getdate())
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@CharNameMaster,'Pm me With Name Only (Correct Name)',Getdate())
END
--------------------------- require part (Select varaibles) --------------------------------------------
SET @CharIDMaster =(Select CharID From [SRO_VT_SHARD].[dbo].[_Char] where CharName16=@CharNameMaster)
SET @CharIDMember =(Select CharID From [SRO_VT_SHARD].[dbo].[_Char] where CharName16=@Chat)
SET @Permission =(Select Permission From [SRO_VT_SHARD].[dbo].[_GuildMember] where CharID=@CharIDMaster)
SET @GuildIDMaster =(Select GuildID From [SRO_VT_SHARD].[dbo].[_Char] where CharName16=@CharNameMaster)
SET @GuildIDMember =(Select GuildID From [SRO_VT_SHARD].[dbo].[_Char] where CharName16=@Chat)
SET @Times =(Select Times From FTW_SPY where CharName=@Chat)
SET @USERJID =(SELECT userjid FROM [SRO_VT_SHARD].[dbo].[_User] where CharID = @CharIDMember)
SET @USERID =(Select StrUserID FROM [SRO_VT_ACCOUNT].[dbo].[TB_User] where JID = @USERJID)
-------------------------- Part to Excu Sys Warring (1) ------------------------------------------------------------
IF (@Chat in (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char]) And @Permission = '-1' And @GuildIDMaster = @GuildIDMember And @Times is NULL)
Begin
Insert Into iLegend_Tool (Service,Type,Target,Date) Values (1,'Disconnect',@Chat,Getdate())
Insert Into FTW_SPY (CharName,Times) Values (@Chat,'1')
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@CharNameMaster,'Secussfully ban .... ',Getdate())
END
-------------------------- Part to Excu Sys Warring (2) ------------------------------------------------------------
IF (@Chat in (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char]) And @Permission = '-1' And @GuildIDMaster = @GuildIDMember And @Times = '1')
Begin
Insert Into iLegend_Tool (Service,Type,Target,Date) Values (1,'Disconnect',@Chat,Getdate())
UPDATE FTW_SPY Set Times=2 where CharName=@Chat
Insert Into [SRO_VT_ACCOUNT].[dbo].[_Punishment] (UserJID,Type,Executor,Shard,CharName,CharInfo,Pos Info,Guide,Description,RaiseTime,BlockStartTime,Bl ockEndTime,PunishTime,Status)
Values (@USERJID,'1','Elbattawy','0',@chat,'1','1','Banne d','Trying to break FTW system',Getdate(),Getdate(),'2040-01-01 00:00:00.000','2040-01-01 00:00:00.000','0')
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@CharNameMaster,'Secussfully ban .... ',Getdate())
Insert Into [SRO_VT_ACCOUNT].[dbo].[_BlockedUser] (UserJID,UserID,Type,SerialNo,timeBegin,timeEnd) Values (@USERJID,@USERID,'1','1',Getdate(),'2040-01-01 00:00:00.000')
END
------------------------------ wrong INFO... ----------------------------------------------------------------------
IF (@Chat in (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char]) And @Permission = '0')
Begin
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@CharNameMaster,'u are not Master Guild Sorry Man ..... ',Getdate())
END
IF (@Chat in (Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char]) And @Permission = '-1' And @GuildIDMaster != @GuildIDMember And @Times is NULL)
Begin
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@CharNameMaster,'Sorry Man this Char Not With u in Guild .........',Getdate())
END
/***************************************** End System ************************************************** *************/
END
GO
Table
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[FTW_SPY] Script Date: 5/31/2016 12:55:01 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FTW_SPY](
[CharName] [varchar](60) NOT NULL,
[Times] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
Program
لينك البرنامج من الموضوع الاصلى
Here (https://mega.nz/#!GQ4ilLzb!g3IqD_Qs0CCFTz7lWfzPAoQL1dktL3jZgyhYx_b oShQ)
DataBase (https://mega.nz/#!jpcngJDJ!CSJx5A3a8uUT1_2wR_FOQmryudC1GNpoLA2ZCOL UW7w)
فك الضغط هتلاقى 2 كويرى اعملهم و ظبط الاعدادات فى Config الموجود فى البرنامج
ودا لينك الموضوع الاصلى بتاع البرنامج هتلاقى فية الشرح البرنامج بتفصيل
Here (http://www.silkroad4arab.com/vb/showthread.php?t=599404)
-------------------------------- Version 2 ----------------------------------------
Logs :
1- تم حل بعض المشاكل الاكانت بتحصل فى اسم الكاركتر الا بتاخد ban
2- تم اضافه ان سيستم يشتغل فى وقت FTW بس
3- تم اضافه ان السيستم يشتغل بس فى Regions FTW
4- تم اضافه خاصيه block user (بمعنى مش كل شويه master guild هيدي ban لشخصيه الا هتعمل spy فاعلشان انا كدا انا حبيت اضيف حاجه جديده عن الاكان موجود فى version 1 الافى version 2 دا لما الشخصيه تعمل 2 spy هياخد block user لمده FTW بس بعد كدا هيتفك block)
5- تم منع ان Master Guild يدي نفسه DC علشان Cheat
6- تم تظبيط PMs (بمعنى لو char مش موجود فى الجيم هيجيلو رساله انو مش موجود , ولو مش فى ميعاد FTW هيجيلو رساله , ولو مش فى منطقه FTW هيجيلو رساله , ولو كاركتر واخد block user هيجيلو رساله , ولو هيدى نفسه dc هيجيلو رساله )
Downloads :
لازم تكون شغال بفيرجن الجديد بتاع برنامج Vsro Multi Tools
Tables :
FTW_SPY (https://mega.nz/#!mkdgiYIK!IDLDQ3pD6kgPgaqqWKo-Cr6jGOlNO6LmKn5IAd8VDro)
SPY_BLOCKUSER (https://mega.nz/#!ygl01IoZ!Oc0-WWYJlqbwBAvaXMmdKWEi8rogUutTu8BLRHvfVSE)
SPY_SERVICE (https://mega.nz/#!vwFwgR4C!IW_yFdWK8Drhs_s-jXgmkPqJ8PPaXCPWbu4gvyi7YpI)
SPY_REGIONS (https://mega.nz/#!C1MVTKZR!vYN-Dzmqzgf0jE3vJCLY5wD-_GBgdX0zejNsZVePamc)
Proc :
Main (https://mega.nz/#!fxFxyIQD!X9yY_6D9GacqYgTbIPmB6rPqU5Be5Ov_j5ypsXI RgbY)
ELBATTAWY_FTW_SPY (https://mega.nz/#!PtVihA4I!eDWcyAbrkcKEAn60OLLhaRKrF29OmEF0P2KxT9j Ofk4)
Guide :
بعد ما تعمل Exec للحاجات الا فوق
هتضيف Lines دى فى تابل Spy_Service
Spy System NULL
هتضيف Lines دى فى تابل Spy_Regions
14660
14661
14662
14663
14664
14916
14917
14918
14919
14920
15172
15173
15174
15175
15176
15428
15429
15430
15431
15432
15684
15685
15686
15687
15688
15940
15941
15942
15943
15944
16196
16197
16198
16199
16200
16452
16453
16454
16455
16456
17221
17222
17223
17224
17225
17229
17230
17231
17232
17477
17478
17479
17480
17481
17485
17486
17487
17488
17733
17734
17735
17736
17737
17741
17742
17743
17744
17989
17990
17991
17992
17993
17997
17998
17999
18000
هتضيف lines دى فى تابل ExecQuery
1 Friday 21:00:00 1 exec.[dbo].[ELBATTAWY_SPY_FTW] 0
2 Friday 23:00:00 1 exec.[dbo].[ELBATTAWY_SPY_FTW] 1
اول سطر وقت بدايه ال FTW
تانى سطر وقت نهايه ال FTW
Vedio
bXFxh2grGDM