DevCore ADM Tool

[1c3x]

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 )

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

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

1) SQL DB+Login

 Spoiler

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

Schritt 1.

--------------------------------------------------
Schritt 2.

--------------------------------------------------
Schritt 3.

--------------------------------------------------
Schritt 4.

--------------------------------------------------
Schritt 5.

--------------------------------------------------
Schritt 6.


Wichtig
Schritt 4 - 6
wiederholen mit:
- dbo.ItemResource
- dbo.StringResource
- dbo.StateResource
- dbo.JobResource
- dbo.MonsterResource

3) Konfiguration - Telecaster

 Spoiler

Schritt 1.


--------------------------------------------------
Schritt 2.


--------------------------------------------------
Schritt 3.


--------------------------------------------------
Schritt 4.


--------------------------------------------------
Schritt 5.


--------------------------------------------------
Schritt 6. (dbo.Item)


--------------------------------------------------
Schritt 7. (dbo.Character)

4) Konfiguration - auth

 Spoiler

Schritt 1.


--------------------------------------------------
Schritt 2.


--------------------------------------------------
Schritt 3.


--------------------------------------------------
Schritt 4.


--------------------------------------------------
Schritt 5.


--------------------------------------------------
Schritt 6.

5) Konfiguration - DevCoreTool

 Spoiler

Schritt 1.


--------------------------------------------------
Schritt 2.


--------------------------------------------------
Schritt 3.


--------------------------------------------------
Schritt 4.


--------------------------------------------------
Schritt 5.


--------------------------------------------------
Schritt 6.


Wichtig
Schritt 4 - 6
wiederholen mit:

- dbo.BackupTime
- dbo.Benutzer
- dbo.Notize

6) Konfiguration - Backup Funktion

 Spoiler

Schritt 1.


--------------------------------------------------
Schritt 2.


Wichtig
Schritt 1 - 2
wiederholen mit:

- Arcadia
- Telecaster
- auth
- DevCoreTool


--------------------------------------------------
Schritt 3. (erstellen)

User | PW | DB | Port

 Spoiler

• Tool Test Benutzer:
• Benutzer: Test01 Passwort: Test01 Mit Permission: 100
• Benutzer: Test02 Passwort: Test02 Mit Permission: 50
  
• DB - DevCoreTool (Ok)
• User - DevCoreUser (Ok)
• User - PW = 1234
• Port - Euer SQL TCP muss frei gegeben werden (Firewall)
  - 1433
  - 49172
  - 1566
  was auch immer ihr benutzt... (mein test port 1433)
  Anleitung:

Bei weiteren Fragen bzw. verschärfte Sicherheitsmaßnahmen durch die freigabe des Ports: pn Skype

** ENG **

 Spoiler

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

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

Step 1. (Arcadia -> new user)

--------------------------------------------------
Step 2.

--------------------------------------------------
Step 3.

--------------------------------------------------
Step 4.

--------------------------------------------------
Step 5.

--------------------------------------------------
Step 6. (show definition and select)


Important
Step 4 - 6
repeat with:
- dbo.ItemResource
- dbo.StringResource
- dbo.StateResource
- dbo.JobResource
- dbo.MonsterResource

3) Configuration - Telecaster

 Spoiler

Step 1. (Telecaster -> new user)


--------------------------------------------------
Step 2.


--------------------------------------------------
Step 3.


--------------------------------------------------
Step 4.


--------------------------------------------------
Step 5.


--------------------------------------------------
Step 6. (dbo.Item) (refresh and change and select and show definition and insert and delete)


--------------------------------------------------
Step 7. (dbo.Character)(select and show definition)

4) Configuration - auth

 Spoiler

Step 1. (auth -> new user)


--------------------------------------------------
Step 2.


--------------------------------------------------
Step 3.


--------------------------------------------------
Step 4.


--------------------------------------------------
Step 5.


--------------------------------------------------
Step 6. (refresh and change and select and show definition and insert and delete)

5) Configuration - DevCoreTool

 Spoiler

Step 1. (DevCoreTool -> new user)


--------------------------------------------------
Step 2.


--------------------------------------------------
Step 3.


--------------------------------------------------
Step 4.


--------------------------------------------------
Step 5.


--------------------------------------------------
Step 6. (refresh and change and select and show definition and insert and delete)


Important
Step 4 - 6
repeat with:

- dbo.BackupTime
- dbo.Benutzer
- dbo.Notize

6) Configuration - Backup Function

 Spoiler

Step 1. [/COLOR]


--------------------------------------------------
Step 2. (Database backup)


Important
Step 1 - 2
repeat with:

- Arcadia
- Telecaster
- auth
- DevCoreTool


--------------------------------------------------
Step 3. (create)

User | PW | DB | Port

 Spoiler

• Tool Test User:
• User: Test01 Password: Test01 With Permission: 100
• User: Test02 Password: Test02 With Permission: 50
  
• DB - DevCoreTool (Ok)
• User - DevCoreUser (Ok)
• User - PW = 1234
• Port - Your SQL TCP must be released (firewall)
  - 1433
  - 49172
  - 1566
  what ever you used ... (my test port 1433)
  manual:

[miwi2602]

Finde es Lustig das es "DevCore" heißt scheint wohl ein neuer Trend zu sein sich jetzt core zu nennen ? xD

[1c3x]

Klar, rauf auf die Welle ^^ sei kein Spießer

[SilentWisdom]

Normally I don't do this but....



I would never trust a tool that needed so many permissions and also required you to open your db ports.

That being said, some constructive criticism:

1. Lose the crazy high contrast color scheme. It is very hard on the eyes and remember when coding a tool it's not about your personal preference but that of the potential user.

2. Give user option to use trusted connection to db:

        private static string connectionString
        {
            get
            {
                string conString = string.Format("Server={0};Database={1};", OPT.GetString("db.ip"), OPT.GetString("db.world.name"));
                if (OPT.GetString("db.trusted.connection") == "1") { conString += "Trusted_Connection=True;"; }
                else { conString += string.Format("uid={0};pwd={1};", OPT.GetString("db.world.user"), OPT.GetString("db.world.password")); }

                return conString;
            }
        }

Above is an example of a property I use in my Database class present in many of my tools. This way the user can specify if they want to define a user/pass or just use Trusted.

Remember trusted is almost always the most secure method of accessing table contents!

3. Understand that there is no true reason for making schema based roles for a program such as this any well setup server is already using schema based database users to begin with and by using Trusted_Connection you bypass any need to login with a user at all.

Nice release and good luck with your future projects!

[1c3x]

@ SilentWisdom
Thanks for the hints, I will look at the variant

[PetTrainer]

setup DevCore.rar funktioniert nicht mehr =(
Beim entpacken kommt eine Meldung : Keine Datein zum entpacken vorhanden ?
kann das mal pls jemand neu hochladen ?

[PetTrainer]

????? Reupload pls =(

[ThunderNikk]

They are attachments.

[PetTrainer]

Unzip doesn't work... that's the reason, why i ask for reupload

[solo69]

re-upload plz