الـجـروب الـرسـمـي لـلـمـنـتـدى Silkroad4arab Facebook | Official Group

**keshk2007** · 05-01-2017, 01:31 AM

ممكن حضرتك ال DB لـ SQl 2008

**CritYouDown** · 06-01-2017, 09:20 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة keshk2007 عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

ممكن حضرتك ال DB لـ SQl 2008

اعمل Database اسمها JGuard
و اعمل دول

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_CurrentOnline]    Script Date: 1/6/2017 8:12:11 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_CurrentOnline](
	[Num] [int] IDENTITY(1,1) NOT NULL,
	[Charname] [varchar](max) NULL,
	[StrUserID] [varchar](64) NOT NULL,
	[JID] [int] NULL,
	[IP] [varchar](64) NULL,
	[Onlinefrom] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_FortressReward]    Script Date: 1/6/2017 8:13:01 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_FortressReward](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Machine] [varchar](max) NULL,
	[CharName] [varchar](20) NOT NULL,
	[Guildname] [varchar](max) NULL,
	[time] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_HWID]    Script Date: 1/6/2017 8:13:19 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_HWID](
	[StrUserID] [varchar](64) NULL,
	[HWID] [varchar](64) NULL,
	[last_seen] [datetime] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_HWID_BANS]    Script Date: 1/6/2017 8:13:35 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_HWID_BANS](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[HWID] [varchar](64) NOT NULL,
	[last_seen] [datetime] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_HWID_LOG]    Script Date: 1/6/2017 8:13:50 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_HWID_LOG](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[StrUserID] [varchar](64) NULL,
	[HWID] [varchar](64) NULL,
	[log_time] [datetime] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_ItemName]    Script Date: 1/6/2017 8:14:03 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_ItemName](
	[CodeName128] [varchar](50) NOT NULL,
	[Name] [varchar](500) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_JobSys]    Script Date: 1/6/2017 8:14:21 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_JobSys](
	[No] [int] IDENTITY(1,1) NOT NULL,
	[Charname] [varchar](max) NULL,
	[Type] [varchar](max) NULL,
	[Machine] [varchar](max) NULL,
 CONSTRAINT [PK__JobSys] PRIMARY KEY CLUSTERED 
(
	[No] 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 [JGuard]
GO

/****** Object:  Table [dbo].[_LOG_CHAT_ALL]    Script Date: 1/6/2017 8:14:36 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_LOG_CHAT_ALL](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CharName] [varchar](255) NULL,
	[Message] [varchar](255) NULL,
	[Time] [datetime] NULL,
 CONSTRAINT [PK_AllChat] 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

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_LOG_CHAT_GLOBAL]    Script Date: 1/6/2017 8:15:17 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_LOG_CHAT_GLOBAL](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CharName] [varchar](255) NULL,
	[Message] [varchar](255) NULL,
	[Time] [datetime] NULL,
 CONSTRAINT [PK_GlobalChat] 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

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_LOG_CHAT_PRIVATE]    Script Date: 1/6/2017 8:15:33 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_LOG_CHAT_PRIVATE](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Sender] [varchar](255) NULL,
	[Receiver] [varchar](255) NULL,
	[Message] [varchar](255) NULL,
	[Time] [datetime] NULL,
 CONSTRAINT [PK_PrivateChat] 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

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_LOG_UNIQUE]    Script Date: 1/6/2017 8:15:45 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_LOG_UNIQUE](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CharID] [int] NULL,
	[CharName] [varchar](255) NULL,
	[MonsterCodeName] [varchar](255) NULL,
	[MonsterID] [int] NULL,
	[Time] [datetime] NULL,
 CONSTRAINT [PK_UniqueKills] 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

كود:

USE [JGuard]
GO
/****** Object:  StoredProcedure [dbo].[_HWIDCHECK]    Script Date: 1/6/2017 8:16:01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_HWIDCHECK] 
	@StrUserID VARCHAR(50),
	@HWID VARCHAR(64)
AS

--- DECLARE
	DECLARE @Value int = 0;

/* Check if @StrUserID AND @IP is not empty */
IF (LEN(@StrUserID) > 0 AND LEN(@HWID) > 0)
BEGIN
		--- LOGGING
		INSERT INTO [JGuard].[dbo].[_HWID_LOG] (StrUserID, HWID, log_time) VALUES(@StrUserID, @HWID, GETDATE());

		--- Banned HWIDS? :D
		IF EXISTS(SELECT HWID FROM [JGuard].[dbo].[_HWID_BANS] WHERE HWID like @HWID)
		BEGIN
			SET @Value = 0;

			-- UPDATE last_seen on bans.
			UPDATE [JGuard].[dbo].[_HWID_BANS] SET last_seen = GETDATE() WHERE HWID like @HWID;
			
			-- Ban new account if HWID banned?
			IF(NOT EXISTS(SELECT UserID FROM SRO_VT_ACCOUNT.[dbo].[_BlockedUser] WHERE UserID = @StrUserID AND SerialNo = 1))
			BEGIN
				INSERT INTO SRO_VT_ACCOUNT.[dbo].[_BlockedUser] (UserJID, UserID, [Type], SerialNo, timeBegin, timeEnd) VALUES((SELECT JID FROM SRO_VT_ACCOUNT.[dbo].[TB_User] WHERE StrUserID = @StrUserID), @StrUserID, 1, 1, GETDATE(), '2116-02-23 03:29:26.000');
				INSERT INTO SRO_VT_ACCOUNT.[dbo].[_Punishment] (UserJID, [Type], Executor, Shard, CharName, CharInfo, PosInfo, Guide, [Description], RaiseTime, BlockStartTime, BlockEndTime, PunishTime, [Status]) 
				VALUES((SELECT JID FROM SRO_VT_ACCOUNT.[dbo].[TB_User] WHERE StrUserID = @StrUserID), 1, 1, 64, '', '', '', 'You have been banned from this server', 'You have been banned from this server', GETDATE(), GETDATE(), '2116-02-23 03:29:26.000', GETDATE(), 0);
			END
		END
		ELSE
		BEGIN
			--- First time connected? good!
			IF NOT EXISTS(SELECT StrUserID FROM [JGuard].[dbo].[_HWID] WHERE StrUserID = @StrUserID)
			BEGIN
				INSERT INTO [JGuard].[dbo].[_HWID] (StrUserID, HWID, last_seen) VALUES(@StrUserID, @HWID, GETDATE());
				SET @Value = 1;
			END

			-- UPDATE THEIR HWID.
			ELSE IF EXISTS(SELECT StrUserID from [JGuard].[dbo].[_HWID] WHERE StrUserID = @StrUserID and HWID is null) 
			BEGIN
				UPDATE [JGuard].[dbo].[_HWID] SET HWID = @HWID WHERE StrUserID = @StrUserID;
				SET @Value = 0;
			END

			--- HWID exists, UPDATE Last seen!
			ELSE IF EXISTS(SELECT StrUserID FROM [JGuard].[dbo].[_HWID] WHERE StrUserID = @StrUserID and HWID like @HWID)
			BEGIN
				UPDATE [JGuard].[dbo].[_HWID] SET last_seen = GETDATE() WHERE StrUserID = @StrUserID;
				SET @Value = 1;
			END

			--- HWID OLD, NOT UPDATED!
			ELSE IF EXISTS(SELECT StrUserID FROM [JGuard].[dbo].[_HWID] WHERE StrUserID = @StrUserID and last_seen < DATEADD(HOUR, -5, GETDATE()))
				/* EXAMPLES ^
					MINUTE, -4 // MINUTES HERE
					HOUR, -4 // HOURS HERE
					DAY, -4 // DAYS HERE
					WEEK, -1 // WEEKS HERE
				*/
			BEGIN
				UPDATE [JGuard].[dbo].[_HWID] SET HWID = @HWID, last_seen = GETDATE() WHERE StrUserID = @StrUserID;
				SET @Value = 1;
			END

			--- Trying to bypass, fuck off.
			ELSE IF NOT EXISTS(SELECT StrUserID FROM [JGuard].[dbo].[_HWID] WHERE StrUserID = @StrUserID and HWID like @HWID)
			BEGIN
				SET @Value = 0;
			END
	END

	--- Final countdown <3
	SELECT @Value;
END
ELSE
BEGIN
	SELECT @Value;
END

كود:

USE [JGuard]
GO
/****** Object:  StoredProcedure [dbo].[_STALLFILTER]    Script Date: 1/6/2017 8:16:44 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[_STALLFILTER] 
	@CharName VARCHAR(64),
	@Slot TINYINT = 0
AS

/* Variable declarations */
DECLARE @CharID INT, @ItemID BIGINT = 0, @RefItemID BIGINT = 0, @Value INT = 0;

/*
 * Get shits
 */
SELECT DISTINCT @CharID = a.CharID, @ItemID = b.ItemID, @RefItemID = c.RefItemID
	FROM SRO_VT_SHARD.[dbo].[_Char] a WITH (NOLOCK)
	JOIN SRO_VT_SHARD.[dbo].[_Inventory] b ON a.CharID = b.CharID
	JOIN SRO_VT_SHARD.[dbo].[_Items] c ON b.ItemID = c.ID64
	WHERE LTRIM(RTRIM(a.CharName16)) LIKE LTRIM(RTRIM(@CharName)) AND b.Slot = @Slot

	/* Example query for blocking (Stall, Exchange, Consigment) on RefItemID from _RefObjCommon aka ID.
		IF(@RefItemID > 0)
		BEGIN
			IF(@RefItemID in (1,2,3,4,5))
			BEGIN
				SET @Value = 1;
				-- Value 1, means you can't do shit with these items.
			END
		END

	*/

	--- Check if item has advanced.
	IF EXISTS(SELECT nSlot FROM SRO_VT_SHARD.[dbo].[_BindingOptionWithItem] WHERE nItemDBID = @ItemID)
	BEGIN
		-- Check ItemID's
		IF(@RefItemID in (4109)) 
		BEGIN
			-- Return true if ItemID in ^ and has adv.
			SET @Value = 1;
		END
	END

SELECT @Value;

كود:

USE [JGuard]
GO
/****** Object:  StoredProcedure [dbo].[_UnionLimit]    Script Date: 1/6/2017 8:17:03 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[_UnionLimit] 
	@CharName VARCHAR(64)
AS

/* Variable declarations */
DECLARE @CharID INT, @Value int, @GuildID INT, @UnionID INT = 0, @GuildCount INT = 0, @UnionCount INT = 0;
SELECT DISTINCT @CharID = a.CharID, @GuildID = a.GuildID , @UnionID = e.Alliance
	FROM [SRO_VT_SHARD].[dbo].[_Char] a WITH (NOLOCK)
	INNER JOIN [SRO_VT_SHARD].[dbo].[_User] b ON a.CharID = b.CharID
	JOIN [SRO_VT_SHARD].[dbo].[_Guild] e ON e.ID = a.GuildID
	WHERE LTRIM(RTRIM(a.CharName16)) LIKE LTRIM(RTRIM(@CharName))
	--- Count union guilds ---
	IF (@GuildID is not null AND @GuildID > 0)
	BEGIN
		--- Mike coding
		DECLARE @Ally2 int = 0, @Ally3 int = 0, @Ally4 int = 0, @Ally5 int = 0, @Ally6 int = 0, @Ally7 int = 0, @Ally8 int = 0;

		-- Selection of doom
		SELECT DISTINCT @Ally2 = a.Ally2, @Ally3 = a.Ally3, @Ally4 = a.Ally4, 
		@Ally5 = a.Ally5, @Ally6 = a.Ally6, @Ally7 = a.Ally7, @Ally8 = a.Ally8
		FROM [SRO_VT_SHARD].[dbo].[_AlliedClans] a WITH (NOLOCK)
		WHERE ID = @UnionID;

		--- OWNER GUILD
		if(@Ally2 > 0)
			SET @UnionCount = @UnionCount + 1;
		if(@Ally3 > 0)
			SET @UnionCount = @UnionCount + 1;
		if(@Ally4 > 0)
			SET @UnionCount = @UnionCount + 1;
		if(@Ally5 > 0)
			SET @UnionCount = @UnionCount + 1;
		if(@Ally6 > 0)
			SET @UnionCount = @UnionCount + 1;
		if(@Ally7 > 0)
			SET @UnionCount = @UnionCount + 1;
		if(@Ally8 > 0)
			SET @UnionCount = @UnionCount + 1;
	END
SELECT @UnionCount

**stafherp** · 04-04-2017, 03:31 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة CritYouDown عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

اعمل Database اسمها JGuard
و اعمل دول

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_CurrentOnline]    Script Date: 1/6/2017 8:12:11 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_CurrentOnline](
	[Num] [int] IDENTITY(1,1) NOT NULL,
	[Charname] [varchar](max) NULL,
	[StrUserID] [varchar](64) NOT NULL,
	[JID] [int] NULL,
	[IP] [varchar](64) NULL,
	[Onlinefrom] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_FortressReward]    Script Date: 1/6/2017 8:13:01 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_FortressReward](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Machine] [varchar](max) NULL,
	[CharName] [varchar](20) NOT NULL,
	[Guildname] [varchar](max) NULL,
	[time] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_HWID]    Script Date: 1/6/2017 8:13:19 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_HWID](
	[StrUserID] [varchar](64) NULL,
	[HWID] [varchar](64) NULL,
	[last_seen] [datetime] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_HWID_BANS]    Script Date: 1/6/2017 8:13:35 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_HWID_BANS](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[HWID] [varchar](64) NOT NULL,
	[last_seen] [datetime] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_HWID_LOG]    Script Date: 1/6/2017 8:13:50 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_HWID_LOG](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[StrUserID] [varchar](64) NULL,
	[HWID] [varchar](64) NULL,
	[log_time] [datetime] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_ItemName]    Script Date: 1/6/2017 8:14:03 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_ItemName](
	[CodeName128] [varchar](50) NOT NULL,
	[Name] [varchar](500) NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_JobSys]    Script Date: 1/6/2017 8:14:21 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_JobSys](
	[No] [int] IDENTITY(1,1) NOT NULL,
	[Charname] [varchar](max) NULL,
	[Type] [varchar](max) NULL,
	[Machine] [varchar](max) NULL,
 CONSTRAINT [PK__JobSys] PRIMARY KEY CLUSTERED 
(
	[No] 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 [JGuard]
GO

/****** Object:  Table [dbo].[_LOG_CHAT_ALL]    Script Date: 1/6/2017 8:14:36 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_LOG_CHAT_ALL](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CharName] [varchar](255) NULL,
	[Message] [varchar](255) NULL,
	[Time] [datetime] NULL,
 CONSTRAINT [PK_AllChat] 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

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_LOG_CHAT_GLOBAL]    Script Date: 1/6/2017 8:15:17 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_LOG_CHAT_GLOBAL](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CharName] [varchar](255) NULL,
	[Message] [varchar](255) NULL,
	[Time] [datetime] NULL,
 CONSTRAINT [PK_GlobalChat] 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

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_LOG_CHAT_PRIVATE]    Script Date: 1/6/2017 8:15:33 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_LOG_CHAT_PRIVATE](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[Sender] [varchar](255) NULL,
	[Receiver] [varchar](255) NULL,
	[Message] [varchar](255) NULL,
	[Time] [datetime] NULL,
 CONSTRAINT [PK_PrivateChat] 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

كود:

USE [JGuard]
GO

/****** Object:  Table [dbo].[_LOG_UNIQUE]    Script Date: 1/6/2017 8:15:45 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_LOG_UNIQUE](
	[ID] [bigint] IDENTITY(1,1) NOT NULL,
	[CharID] [int] NULL,
	[CharName] [varchar](255) NULL,
	[MonsterCodeName] [varchar](255) NULL,
	[MonsterID] [int] NULL,
	[Time] [datetime] NULL,
 CONSTRAINT [PK_UniqueKills] 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

كود:

USE [JGuard]
GO
/****** Object:  StoredProcedure [dbo].[_HWIDCHECK]    Script Date: 1/6/2017 8:16:01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_HWIDCHECK] 
	@StrUserID VARCHAR(50),
	@HWID VARCHAR(64)
AS

--- DECLARE
	DECLARE @Value int = 0;

/* Check if @StrUserID AND @IP is not empty */
IF (LEN(@StrUserID) > 0 AND LEN(@HWID) > 0)
BEGIN
		--- LOGGING
		INSERT INTO [JGuard].[dbo].[_HWID_LOG] (StrUserID, HWID, log_time) VALUES(@StrUserID, @HWID, GETDATE());

		--- Banned HWIDS? :D
		IF EXISTS(SELECT HWID FROM [JGuard].[dbo].[_HWID_BANS] WHERE HWID like @HWID)
		BEGIN
			SET @Value = 0;

			-- UPDATE last_seen on bans.
			UPDATE [JGuard].[dbo].[_HWID_BANS] SET last_seen = GETDATE() WHERE HWID like @HWID;
			
			-- Ban new account if HWID banned?
			IF(NOT EXISTS(SELECT UserID FROM SRO_VT_ACCOUNT.[dbo].[_BlockedUser] WHERE UserID = @StrUserID AND SerialNo = 1))
			BEGIN
				INSERT INTO SRO_VT_ACCOUNT.[dbo].[_BlockedUser] (UserJID, UserID, [Type], SerialNo, timeBegin, timeEnd) VALUES((SELECT JID FROM SRO_VT_ACCOUNT.[dbo].[TB_User] WHERE StrUserID = @StrUserID), @StrUserID, 1, 1, GETDATE(), '2116-02-23 03:29:26.000');
				INSERT INTO SRO_VT_ACCOUNT.[dbo].[_Punishment] (UserJID, [Type], Executor, Shard, CharName, CharInfo, PosInfo, Guide, [Description], RaiseTime, BlockStartTime, BlockEndTime, PunishTime, [Status]) 
				VALUES((SELECT JID FROM SRO_VT_ACCOUNT.[dbo].[TB_User] WHERE StrUserID = @StrUserID), 1, 1, 64, '', '', '', 'You have been banned from this server', 'You have been banned from this server', GETDATE(), GETDATE(), '2116-02-23 03:29:26.000', GETDATE(), 0);
			END
		END
		ELSE
		BEGIN
			--- First time connected? good!
			IF NOT EXISTS(SELECT StrUserID FROM [JGuard].[dbo].[_HWID] WHERE StrUserID = @StrUserID)
			BEGIN
				INSERT INTO [JGuard].[dbo].[_HWID] (StrUserID, HWID, last_seen) VALUES(@StrUserID, @HWID, GETDATE());
				SET @Value = 1;
			END

			-- UPDATE THEIR HWID.
			ELSE IF EXISTS(SELECT StrUserID from [JGuard].[dbo].[_HWID] WHERE StrUserID = @StrUserID and HWID is null) 
			BEGIN
				UPDATE [JGuard].[dbo].[_HWID] SET HWID = @HWID WHERE StrUserID = @StrUserID;
				SET @Value = 0;
			END

			--- HWID exists, UPDATE Last seen!
			ELSE IF EXISTS(SELECT StrUserID FROM [JGuard].[dbo].[_HWID] WHERE StrUserID = @StrUserID and HWID like @HWID)
			BEGIN
				UPDATE [JGuard].[dbo].[_HWID] SET last_seen = GETDATE() WHERE StrUserID = @StrUserID;
				SET @Value = 1;
			END

			--- HWID OLD, NOT UPDATED!
			ELSE IF EXISTS(SELECT StrUserID FROM [JGuard].[dbo].[_HWID] WHERE StrUserID = @StrUserID and last_seen < DATEADD(HOUR, -5, GETDATE()))
				/* EXAMPLES ^
					MINUTE, -4 // MINUTES HERE
					HOUR, -4 // HOURS HERE
					DAY, -4 // DAYS HERE
					WEEK, -1 // WEEKS HERE
				*/
			BEGIN
				UPDATE [JGuard].[dbo].[_HWID] SET HWID = @HWID, last_seen = GETDATE() WHERE StrUserID = @StrUserID;
				SET @Value = 1;
			END

			--- Trying to bypass, fuck off.
			ELSE IF NOT EXISTS(SELECT StrUserID FROM [JGuard].[dbo].[_HWID] WHERE StrUserID = @StrUserID and HWID like @HWID)
			BEGIN
				SET @Value = 0;
			END
	END

	--- Final countdown <3
	SELECT @Value;
END
ELSE
BEGIN
	SELECT @Value;
END

كود:

USE [JGuard]
GO
/****** Object:  StoredProcedure [dbo].[_STALLFILTER]    Script Date: 1/6/2017 8:16:44 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[_STALLFILTER] 
	@CharName VARCHAR(64),
	@Slot TINYINT = 0
AS

/* Variable declarations */
DECLARE @CharID INT, @ItemID BIGINT = 0, @RefItemID BIGINT = 0, @Value INT = 0;

/*
 * Get shits
 */
SELECT DISTINCT @CharID = a.CharID, @ItemID = b.ItemID, @RefItemID = c.RefItemID
	FROM SRO_VT_SHARD.[dbo].[_Char] a WITH (NOLOCK)
	JOIN SRO_VT_SHARD.[dbo].[_Inventory] b ON a.CharID = b.CharID
	JOIN SRO_VT_SHARD.[dbo].[_Items] c ON b.ItemID = c.ID64
	WHERE LTRIM(RTRIM(a.CharName16)) LIKE LTRIM(RTRIM(@CharName)) AND b.Slot = @Slot

	/* Example query for blocking (Stall, Exchange, Consigment) on RefItemID from _RefObjCommon aka ID.
		IF(@RefItemID > 0)
		BEGIN
			IF(@RefItemID in (1,2,3,4,5))
			BEGIN
				SET @Value = 1;
				-- Value 1, means you can't do shit with these items.
			END
		END

	*/

	--- Check if item has advanced.
	IF EXISTS(SELECT nSlot FROM SRO_VT_SHARD.[dbo].[_BindingOptionWithItem] WHERE nItemDBID = @ItemID)
	BEGIN
		-- Check ItemID's
		IF(@RefItemID in (4109)) 
		BEGIN
			-- Return true if ItemID in ^ and has adv.
			SET @Value = 1;
		END
	END

SELECT @Value;

كود:

USE [JGuard]
GO
/****** Object:  StoredProcedure [dbo].[_UnionLimit]    Script Date: 1/6/2017 8:17:03 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[_UnionLimit] 
	@CharName VARCHAR(64)
AS

/* Variable declarations */
DECLARE @CharID INT, @Value int, @GuildID INT, @UnionID INT = 0, @GuildCount INT = 0, @UnionCount INT = 0;
SELECT DISTINCT @CharID = a.CharID, @GuildID = a.GuildID , @UnionID = e.Alliance
	FROM [SRO_VT_SHARD].[dbo].[_Char] a WITH (NOLOCK)
	INNER JOIN [SRO_VT_SHARD].[dbo].[_User] b ON a.CharID = b.CharID
	JOIN [SRO_VT_SHARD].[dbo].[_Guild] e ON e.ID = a.GuildID
	WHERE LTRIM(RTRIM(a.CharName16)) LIKE LTRIM(RTRIM(@CharName))
	--- Count union guilds ---
	IF (@GuildID is not null AND @GuildID > 0)
	BEGIN
		--- Mike coding
		DECLARE @Ally2 int = 0, @Ally3 int = 0, @Ally4 int = 0, @Ally5 int = 0, @Ally6 int = 0, @Ally7 int = 0, @Ally8 int = 0;

		-- Selection of doom
		SELECT DISTINCT @Ally2 = a.Ally2, @Ally3 = a.Ally3, @Ally4 = a.Ally4, 
		@Ally5 = a.Ally5, @Ally6 = a.Ally6, @Ally7 = a.Ally7, @Ally8 = a.Ally8
		FROM [SRO_VT_SHARD].[dbo].[_AlliedClans] a WITH (NOLOCK)
		WHERE ID = @UnionID;

		--- OWNER GUILD
		if(@Ally2 > 0)
			SET @UnionCount = @UnionCount + 1;
		if(@Ally3 > 0)
			SET @UnionCount = @UnionCount + 1;
		if(@Ally4 > 0)
			SET @UnionCount = @UnionCount + 1;
		if(@Ally5 > 0)
			SET @UnionCount = @UnionCount + 1;
		if(@Ally6 > 0)
			SET @UnionCount = @UnionCount + 1;
		if(@Ally7 > 0)
			SET @UnionCount = @UnionCount + 1;
		if(@Ally8 > 0)
			SET @UnionCount = @UnionCount + 1;
	END
SELECT @UnionCount

اخر 3 كويرى بيجيبو ايرور
Msg 208, Level 16, State 6, Procedure _UnionLimit, Line 2
Invalid object name 'dbo._UnionLimit'.

**CritYouDown** · 04-04-2017, 05:26 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة stafherp عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

اخر 3 كويرى بيجيبو ايرور
Msg 208, Level 16, State 6, Procedure _UnionLimit, Line 2
Invalid object name 'dbo._UnionLimit'.

ALTER PROCEDURE [dbo].[_UnionLimit]
خليها
CREATE PROCEDURE [dbo].[_UnionLimit]

**keshk2007** · 06-01-2017, 09:50 PM

تسلم بجد على تعاونك

**CritYouDown** · 06-01-2017, 10:37 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة keshk2007 عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

تسلم بجد على تعاونك

تحت امرك و اسف اتأخرت عليك

**mido35** · 12-01-2017, 05:31 PM

انا عوز البرنامج ممكن فيس او رقم تليفون

**CritYouDown** · 25-01-2017, 12:27 AM

كود:

Jan-24-2017 > Version 1.0.1.2
-New windows form application
-Add PC/IP Limitation for fortress
-Fix new exploit
-Add new unique reward system
-Bug fixed
-New config.ini

**Mr.deltanet** · 25-01-2017, 08:55 PM

الله ينور التحديث الجديد دا جامد

**sindbad_2010** · 27-01-2017, 03:40 AM

fe bug fe el Zerk ae 7d bedrb Zerk bea5od DC
lma bst5dm el Filter tb3n be7sl kda

**CritYouDown** · 27-01-2017, 06:15 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة sindbad_2010 عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

fe bug fe el Zerk ae 7d bedrb Zerk bea5od DC
lma bst5dm el Filter tb3n be7sl kda

تمام هشوف المشكله و اعمل update

**keshk2007** · 28-01-2017, 07:36 PM

لو سمحت ممكن طريق اقفال الثغرة الموجود فى الــ FTW
الى عن طريقها ممكن ماستر الجيلد الى واخد الــ FTW يعمل ايتمز زى الجى ام و اكتر كمان

الثغره فى About Guild

**ruxana** · 01-02-2017, 11:42 AM

طي دلوقتي هو مش راضي يفتح ال SQL succcess و في licence اكتب فيه حاجه و لا زم اشحن البرنامج منك

**CritYouDown** · 04-02-2017, 04:59 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة ruxana عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

طي دلوقتي هو مش راضي يفتح ال SQL succcess و في licence اكتب فيه حاجه و لا زم اشحن البرنامج منك

لا مش لازم بس عندك مشكله فى الـ setting بتاع الـ time

اقتباس:

المشاركة الأصلية كتبت بواسطة keshk2007 عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

لو سمحت ممكن طريق اقفال الثغرة الموجود فى الــ FTW
الى عن طريقها ممكن ماستر الجيلد الى واخد الــ FTW يعمل ايتمز زى الجى ام و اكتر كمان

الثغره فى About Guild

معلش مقدرش اطلع حاجه من السورس

**TheBold** · 04-02-2017, 05:48 PM

هووو هيييييييييه يا ولااااا
عااااااااااش

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
Program : iGaurd Packet Filter	Dev. iLegend	قسم المواضيع المكررة و المخالفة	18	06-03-2017 08:48 PM
Packet Filter and Editor fix Exploid Gateway and Agent	™Dev Microsoft™	قسم الحماية والاوتوايفنت للسيرفرات الخاصه	5	22-08-2015 09:55 PM

	ط§ظ„ط¨ظ‚ط§ط، ظ…ط³ط¬ظ„ ط¯ط§ط¦ظ…ط¢

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)