[RELEASE] 9D Account Creation Tool

02/06/2014 20:35 [Arceus]#1
A small tool for those who followed ZeroBurner's tutorial on Rage Zone.

This tool is simply to ease the account creation process for your private servers.
Before you can use it you have to create a specific stored procedure on your database. I have provided the .SQL file for this in the folder.

New in my stored procedure compared to ZeroBurners stored procedure is:
- You can create accounts even if the DB is empty.
- It checks for existing accounts with same ID and does nothing if it exists.
- Account creation additionally ajusts GameConnect table and MaxAuid table.
- And there are several extra functions (like creating special class account if you use 'ndtester' as User ID, etc.)

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


GUIDE:

1. Before first usage: Log into your DB and execute the SQL-File with SQL Server Management Tool
-> This will create the needed Stored Procedure.


2. Start 9Dragons Account Creator Tool.


3. Type in the DB credentials for the System Administrator (SA).
->Login info gets saved into config file so you do not have to type them in future creations.


4. Type in Username/Password you wish to create.


5. Press "Create" button.


6. Log into 9D and enjoy!

ADDITIONAL INFO: This Tool is not necessary for any kind of creation since you can easily do it by query. I just programmed it for self-use a while ago and decided to share it.

DOWNLOAD-LINK:

02/06/2014 20:49 Adek#2
Didn't check that app so far, but you probably started the noob war.

"What is this"-like questions will be even more annoying than always.

[Only registered and activated users can see links. Click Here To Register...]
02/06/2014 21:00 [Arceus]#3
Quote:
Originally Posted by adek1994 View Post
Didn't check that app so far, but you probably started the noob war.

"What is this"-like questions will be even more annoying than always.

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

People who know how to use it might appreciate it. Even if it's just small Tool to speed things up.
02/06/2014 21:21 Adek#4
Quote:
Originally Posted by Tony-Yayo View Post
Probably xD.

People who know how to use it will appreciate it. Even if it's just small Tool to speed things up.
i know the thing, but I still prefer DB's query. ^^ but still, good job. ofc if it's working xDD
02/06/2014 21:40 [Arceus]#5
Quote:
Originally Posted by adek1994 View Post
i know the thing, but I still prefer DB's query. ^^ but still, good job. ofc if it's working xDD
It does work :).
I actually programed it for self-use a while ago. Wrote it in a process of like 30 minutes.
I decided to share it here if people find use for it.
It's ofcourse not necessary since you can easily do it by query as you mentioned.
02/07/2014 06:52 dudu0014#6
I prefer create by php =D

[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...]

after I finish my project I'll share the template
02/07/2014 15:56 Adek#7
Nice idea, but just gonna check OC1 char with done 2nd role :D
02/09/2014 07:01 xtJamie#8
The store procedure application is a good idea but what prevents someone decompiling or deobfuscating the
.exe to view the procedures? If you're going to use something like this for a live server, please look into CRUD to handle the permissions of users.

Also, the person who wrote their application in php, i assume you're using pdo for the mssql because mysqli and mysql_connect extensions are really only for mysql database connections.

I have been building ours using PDO. The use of prepared statements and escaping with htmlentities helps a lot with security. It's also a good idea to look into session fixation and CSFR/XSFR using completely randomised tokens. That and PDO supports the sql driver and makes classes a lot easier to work with.
02/28/2014 13:36 [Arceus]#9
Quote:
Originally Posted by xtJamie View Post
The stored procedure application is a good idea but what prevents someone decompiling or deobfuscating the
.exe to view the procedures? If you're going to use something like this for a live server, please look into CRUD to handle the permissions of users.
I did not obfuscate the application on purpose since the tool is only suitable for Database System Administrators and not for distribution to regular players.

I could make a tool containing the DB Credentials in the code so it's not needed to type them in the tool and obfuscate it if any one wishes too. Despite obfuscation it'd be risky to distribute to players since crackers can still find the DB credentials inside the source code.
07/03/2014 14:31 MontanaTT#10
Came here from Rage Zone. Awesome Tool including special Accounts too^^ been looking fir this since the sql code from sheik was too much trouble. Thanks.
07/12/2014 14:17 Tenge500#11
And why should I give a fuck about your account creation tool? Name one good reason, please. Just one.
07/21/2014 16:12 [Arceus]#12
Quote:
Originally Posted by Tenge500 View Post
And why should I give a fuck about your account creation tool? Name one good reason, please. Just one.
Lol did you really think this tool has been made to give fucks about it? It is supposed that people dont give fucks and whoever does is a a fucktard
07/22/2014 08:10 Tenge500#13
Blablabla
07/30/2014 09:52 anhthu2k#14
i can't download.
08/11/2014 11:05 [Arceus]#15
Quote:
Originally Posted by anhthu2k View Post
i can't download.
Actually it's still up so downloading should work.

If you don't know how most hosters work:

Either you have a premium account and can download immediately or you wait few seconds (In this case 30 sec) until the download link gets provided.