[Guides, HowTo & Programs] Beginners' knowledge

[BMLucian]

AD: Mt2009 - Mobile & PC - 30 January 2026 CHECK THE PRESENTATION!

Main programs needed to
develop or edit a server:​

---

- SSH PuTTY:

To see the download links, Log in or register now.

- WinSCP:

To see the download links, Log in or register now.

- Navicat Premium 16.2.5:

To see the download links, Log in or register now.

- Notepad++:

To see the download links, Log in or register now.

- Paint.NET:

To see the download links, Log in or register now.

- Visual Studio 2013/2019/2022:

To see the download links, Log in or register now.

​

---

Let's start the explanation of each program and what it is used for
in a more beginner's mode to understand the basics.
​

---

SSH PuTTY:


Once you have entered your username press enter and you will be prompted to enter your password, you will enter the password from the host.
To put the password copy it with CTRL+C and put it with right click in the putty console (the password will not appear, but press enter directly).

Now that you are inside the putty console, there are a lot of commands to execute, but I will list the most basic ones to run a server already installed in winscp.
(This tutorial will be next, about how to upload archives in winscp, and how to archive, unarchive and backup)​

---

TO START THE SERVER:
cd usr/home/game && sh start.sh

TO STOP THE SERVER:
cd usr/home/game && sh close.sh

(you have to choose the path where the "start.sh" or "close.sh" file is in), you'll have an example on winscp tutorial.​

---

RESET MYSQL PASSWORD:

Stop mysql server:

/usr/local/etc/rc.d/mysql-server stop

Start mysql server without root password:

mysqld_safe --skip-grant-tables &

We connect as root to the mysql server:

mysql -u root

Run the following commands, which will reset the root password:

use mysql;
update user set password=PASSWORD("HERE YOU PUT THE NEW PASSWORD") where User='root';
flush privileges;
quit
/usr/local/etc/rc.d/mysql-server stop
/usr/local/etc/rc.d/mysql-server start
reboot

DONE.

Now the password to the database with the name "root" has been reset with the password you put above.
We are waiting for the server to start up and we'll get started!
​

---

In this publication I will post in the next few days new updates and continuations on how to use the programs, installations,
compilations, and many other details for beginners.
With this publication I wanted you to understand on what concept this tutorial will be created,
it will be closed so that everything will be organized and beginners can learn easily.

This is not a tutorial for advanced users!



​

 

[BMLucian]

WinSCP:



In WinSCP we will have all the server archives on the quests side, server source, mysql, libs, GNU Compiler, etc..
We enter all the data and save the data so we can log in much easier every time we want to log in.​

---

To save the password:

Enter the arrow next to "Save" and check the following boxes.
We check the box to Create a desktop shortcut, so we create a file easier to access on the main screen.


​

---

Once we are in WinSCP we will have all the host archives


​

---

To install GAME server archives:

1. Enter the folder named "usr"

2. We take the downloaded server archive called "home.tar.gz" and drag it into WinSCP
(I should mention that sometimes the file is named differently, leave it as it is named by the creator
because some archives may not run correctly because the files will read the path it was created with.)

3. When the .tar.gz archive has finished uploading to winscp,
we open PuTTY, enter the vps data and run the following commands to unload the server:

cd /usr/
tar -zxvf game.tar.gz (or the name of the file you have .tar.gz)

4. Now a folder will be created in WinSCP (cd /usr/) named "Home", "Game" depending on the downloaded server.
There are all the server archives on the winscp side. (Example: quests)
​

---

To install MySQL server archives:

1. Enter the folder named "var" then "db"

2. We take the downloaded server archive called "mysql.tar.gz" and drag it into WinSCP
(I should mention that sometimes the file is named differently, leave the archive as it is,
even if it has another name because it will unzip with the name "mysql" no matter what name it has .tar.gz)

3. When the .tar.gz archive has finished uploading to winscp,
we open PuTTY, enter the vps data and run the following commands to unload the server:

cd /var/db
rm -rf mysql
tar -zxvf mysql.tar.gz (or the name of the file you have .tar.gz)

4. Now a folder will be created in WinSCP (cd /var/db) named "mysql".
There are all the mysql server archives on the winscp side.​

---

In this publication I will post in the next few days new updates and continuations on how to use the programs, installations,
compilations, and many other details for beginners.
With this publication I wanted you to understand on what concept this tutorial will be created,
it will be closed so that everything will be organized and beginners can learn easily.

This is not a tutorial for advanced users!






​

 

[BMLucian]

NAVICAT PREMIUM 16.2.5:



This program is used to modify files from the server database. For example: create account, delete account, add a gm, etc...​

---

To log-in:

Enter "Connection" then "MySQL" and fill the following boxes.



After logging into the database, all the server files will open where you can change various things related to the database.




​

---

To create a new account or modify existent:

1. Enter the table named "account" - "tables" - "account"
In this table you will see all the accounts created on the server, with the account name and login password.



2. To test the server we can just change the account password, or create a new account.
To create a new account click on the "+" at the bottom of Navicat.

- In the "ID" table: we leave blank to generate the following code (note, the id cannot be repeated)
In the "LOGIN" table: add the account name for login
In the "PASSWORD" table: add the encrypted password of the account

3. Program needed to create encrypted passwords for the database:

To see the download links, Log in or register now.

​

---

How to use MySQL Hasher?

We open the program, choose the desired language and in the "Text for conversion" box we add the desired password,
then we press the "Encrypt SHA1" button and it will generate an encrypted password.
We copy it and add it to the account in the database. This program will generate a file with all the generated password history.



​

---

To make a GM account:

1. Enter the folder named "common" - "tables" - "gmlist"


Here we have a list of all accounts with access to the GM function

2. To create a new account click on the "+" at the bottom of Navicat.

In the "ID" table: we leave blank to generate the following code (note, the id cannot be repeated)
In the "mAccount" table: add the account name for login
In the "mName" table: add player name in the game
In the "mAuthority" table: Add the desired function for that player. "IMPLEMENTOR" is the most important function of the server

Now we save, restart the server and that account will become GM.​

---

In this publication I will post in the next few days new updates and continuations on how to use the programs, installations,
compilations, and many other details for beginners.
With this publication I wanted you to understand on what concept this tutorial will be created,
it will be closed so that everything will be organized and beginners can learn easily.

This is not a tutorial for advanced users!






​