DevCore ADM Tool

[Only registered and activated users can see links. Click Here To Register...]

GER
Hey ho,
heute stelle ich euch ein Server ADM Tool vor.

Funktionen

Alle Standardfunktionen wie alle Tools
Direkte Verbindung zur DB
Eigenen DB login
Backup Funktion
Keine Listen mehr n�tig
Spieler z�hler
Server Nachrichten
Internen Team Chat / Notize
Spieler Bann System (Chat, Spiel)
etc.

(Es darf bei der Eng �bersetzung verbessert werden :rolleyes: )

ENG
Hey ho,
today I introduce you a server ADM tool.

Features

All standard functions like all tools
Direct connection to DB
Own DB login
Backup function
No more lists needed
Player counter
Server messages
Internal team chat / notification
Player Bann System (chat, game)
etc.

** GER **

Spoiler

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

Ok, kommen wir zu Konfiguration der DB und Sicherheit.
Das meiste erkl�rt sich durch die Bilder.

1) SQL DB+Login

Spoiler

Code:

CREATE DATABASE [DevCoreTool]
 CONTAINMENT = NONE
go

-- Login: DevCoreUser / PW: 1234
CREATE LOGIN [DevCoreUser] WITH PASSWORD = 0x02000A437319E90AC25CB68D8393A4307AB3C2D6BF4ECCCA7DC23FEB6A01A9E20A22F0A550E88E6BC29A4FF50401DF6A1D0B3C721BFDCC6ABC71E9FED424F7F9213DC654C44C HASHED, SID = 0x7E8F6EA8DD3B984EBE419D8F2DF0F40D, DEFAULT_DATABASE = [DevCoreTool], CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF

--=============================================================================
--===============*****=====******===*========*=================================
--===============*====*====*=========*======*==================================
--===============*=====*===******====*======*==================================
--===============*=====*===*==========*====*===================================
--===============*====*====*===========*==*====================================
--===============*****=====******=======**=====================================
--=============================================================================




USE [DevCoreTool]
GO
/****** Object:  Table [dbo].[BackupTime]    Script Date: 12.09.2017 15:27:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER DATABASE [DevCoreTool] SET ANSI_NULL_DEFAULT OFF 
GO

ALTER DATABASE [DevCoreTool] SET ANSI_NULLS OFF 
GO

ALTER DATABASE [DevCoreTool] SET ANSI_PADDING OFF 
GO

ALTER DATABASE [DevCoreTool] SET ANSI_WARNINGS OFF 
GO

ALTER DATABASE [DevCoreTool] SET ARITHABORT OFF 
GO

ALTER DATABASE [DevCoreTool] SET AUTO_CLOSE OFF 
GO

ALTER DATABASE [DevCoreTool] SET AUTO_SHRINK OFF 
GO

ALTER DATABASE [DevCoreTool] SET AUTO_UPDATE_STATISTICS ON 
GO

ALTER DATABASE [DevCoreTool] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO

ALTER DATABASE [DevCoreTool] SET CURSOR_DEFAULT  GLOBAL 
GO

ALTER DATABASE [DevCoreTool] SET CONCAT_NULL_YIELDS_NULL OFF 
GO

ALTER DATABASE [DevCoreTool] SET NUMERIC_ROUNDABORT OFF 
GO

ALTER DATABASE [DevCoreTool] SET QUOTED_IDENTIFIER OFF 
GO

ALTER DATABASE [DevCoreTool] SET RECURSIVE_TRIGGERS OFF 
GO

ALTER DATABASE [DevCoreTool] SET  DISABLE_BROKER 
GO

ALTER DATABASE [DevCoreTool] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO

ALTER DATABASE [DevCoreTool] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO

ALTER DATABASE [DevCoreTool] SET TRUSTWORTHY OFF 
GO

ALTER DATABASE [DevCoreTool] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO

ALTER DATABASE [DevCoreTool] SET PARAMETERIZATION SIMPLE 
GO

ALTER DATABASE [DevCoreTool] SET READ_COMMITTED_SNAPSHOT OFF 
GO

ALTER DATABASE [DevCoreTool] SET HONOR_BROKER_PRIORITY OFF 
GO

ALTER DATABASE [DevCoreTool] SET RECOVERY SIMPLE 
GO

ALTER DATABASE [DevCoreTool] SET  MULTI_USER 
GO

ALTER DATABASE [DevCoreTool] SET PAGE_VERIFY CHECKSUM  
GO

ALTER DATABASE [DevCoreTool] SET DB_CHAINING OFF 
GO

ALTER DATABASE [DevCoreTool] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO

ALTER DATABASE [DevCoreTool] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO

ALTER DATABASE [DevCoreTool] SET DELAYED_DURABILITY = DISABLED 
GO

ALTER DATABASE [DevCoreTool] SET  READ_WRITE 
GO


CREATE TABLE [dbo].[BackupTime](
	[d_date] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Benutzer]    Script Date: 12.09.2017 15:27:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Benutzer](
	[Name] [nchar](10) NOT NULL,
	[Password] [nchar](10) NOT NULL,
	[permission] [nchar](10) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Notize]    Script Date: 12.09.2017 15:27:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Notize](
	[Notize] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
INSERT [dbo].[BackupTime] ([d_date]) VALUES (CAST(N'' AS DateTime))
INSERT [dbo].[Benutzer] ([Name], [Password], [permission]) VALUES (N'Test01', N'Test01', N'100')
INSERT [dbo].[Benutzer] ([Name], [Password], [permission]) VALUES (N'Test02', N'Test02', N'50')
INSERT [dbo].[Notize] ([Notize]) VALUES (N'DevConTool Online')

2) Konfiguration - Arcadia

Spoiler

3) Konfiguration - Telecaster

Spoiler

4) Konfiguration - auth

Spoiler

5) Konfiguration - DevCoreTool

Spoiler

6) Konfiguration - Backup Funktion

Spoiler

User | PW | DB | Port

Spoiler

** ENG **

Spoiler

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

Since my SQL is in german, I have to explain the steps somewhat more

Ok, we come to configuration the DB and security.
Most of the pictures are explained.

1) SQL DB+Login

Spoiler

Code:

CREATE DATABASE [DevCoreTool]
 CONTAINMENT = NONE
go

-- Login: DevCoreUser / PW: 1234
CREATE LOGIN [DevCoreUser] WITH PASSWORD = 0x02000A437319E90AC25CB68D8393A4307AB3C2D6BF4ECCCA7DC23FEB6A01A9E20A22F0A550E88E6BC29A4FF50401DF6A1D0B3C721BFDCC6ABC71E9FED424F7F9213DC654C44C HASHED, SID = 0x7E8F6EA8DD3B984EBE419D8F2DF0F40D, DEFAULT_DATABASE = [DevCoreTool], CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF

--=============================================================================
--===============*****=====******===*========*=================================
--===============*====*====*=========*======*==================================
--===============*=====*===******====*======*==================================
--===============*=====*===*==========*====*===================================
--===============*====*====*===========*==*====================================
--===============*****=====******=======**=====================================
--=============================================================================




USE [DevCoreTool]
GO
/****** Object:  Table [dbo].[BackupTime]    Script Date: 12.09.2017 15:27:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER DATABASE [DevCoreTool] SET ANSI_NULL_DEFAULT OFF 
GO

ALTER DATABASE [DevCoreTool] SET ANSI_NULLS OFF 
GO

ALTER DATABASE [DevCoreTool] SET ANSI_PADDING OFF 
GO

ALTER DATABASE [DevCoreTool] SET ANSI_WARNINGS OFF 
GO

ALTER DATABASE [DevCoreTool] SET ARITHABORT OFF 
GO

ALTER DATABASE [DevCoreTool] SET AUTO_CLOSE OFF 
GO

ALTER DATABASE [DevCoreTool] SET AUTO_SHRINK OFF 
GO

ALTER DATABASE [DevCoreTool] SET AUTO_UPDATE_STATISTICS ON 
GO

ALTER DATABASE [DevCoreTool] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO

ALTER DATABASE [DevCoreTool] SET CURSOR_DEFAULT  GLOBAL 
GO

ALTER DATABASE [DevCoreTool] SET CONCAT_NULL_YIELDS_NULL OFF 
GO

ALTER DATABASE [DevCoreTool] SET NUMERIC_ROUNDABORT OFF 
GO

ALTER DATABASE [DevCoreTool] SET QUOTED_IDENTIFIER OFF 
GO

ALTER DATABASE [DevCoreTool] SET RECURSIVE_TRIGGERS OFF 
GO

ALTER DATABASE [DevCoreTool] SET  DISABLE_BROKER 
GO

ALTER DATABASE [DevCoreTool] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO

ALTER DATABASE [DevCoreTool] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO

ALTER DATABASE [DevCoreTool] SET TRUSTWORTHY OFF 
GO

ALTER DATABASE [DevCoreTool] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO

ALTER DATABASE [DevCoreTool] SET PARAMETERIZATION SIMPLE 
GO

ALTER DATABASE [DevCoreTool] SET READ_COMMITTED_SNAPSHOT OFF 
GO

ALTER DATABASE [DevCoreTool] SET HONOR_BROKER_PRIORITY OFF 
GO

ALTER DATABASE [DevCoreTool] SET RECOVERY SIMPLE 
GO

ALTER DATABASE [DevCoreTool] SET  MULTI_USER 
GO

ALTER DATABASE [DevCoreTool] SET PAGE_VERIFY CHECKSUM  
GO

ALTER DATABASE [DevCoreTool] SET DB_CHAINING OFF 
GO

ALTER DATABASE [DevCoreTool] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
GO

ALTER DATABASE [DevCoreTool] SET TARGET_RECOVERY_TIME = 0 SECONDS 
GO

ALTER DATABASE [DevCoreTool] SET DELAYED_DURABILITY = DISABLED 
GO

ALTER DATABASE [DevCoreTool] SET  READ_WRITE 
GO


CREATE TABLE [dbo].[BackupTime](
	[d_date] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Benutzer]    Script Date: 12.09.2017 15:27:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Benutzer](
	[Name] [nchar](10) NOT NULL,
	[Password] [nchar](10) NOT NULL,
	[permission] [nchar](10) NOT NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Notize]    Script Date: 12.09.2017 15:27:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Notize](
	[Notize] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
INSERT [dbo].[BackupTime] ([d_date]) VALUES (CAST(N'' AS DateTime))
INSERT [dbo].[Benutzer] ([Name], [Password], [permission]) VALUES (N'Test01', N'Test01', N'100')
INSERT [dbo].[Benutzer] ([Name], [Password], [permission]) VALUES (N'Test02', N'Test02', N'50')
INSERT [dbo].[Notize] ([Notize]) VALUES (N'DevConTool Online')

2) Configuration- Arcadia

Spoiler

3) Configuration - Telecaster

Spoiler

4) Configuration - auth

Spoiler

5) Configuration - DevCoreTool

Spoiler

6) Configuration - Backup Function

Spoiler

User | PW | DB | Port

Spoiler