Creating your eAthena server with SQL.

CAUTION:
This guide teaches you how to create a SQL Server ONLY!
——————
[Contents]

    Chapter 1 – Required Programs
    Chapter 2 – Installing and Setting up No-IP
    Chapter 3 – Installing and configuring Xampp
    Chapter 4 – Configuring Your Server
    Chapter 5 – Adding NPCs
    Chapter 6 – Creating your own GM
    Chapter 7 – Additional Settings

——————

[Chapter 1]

Software Required:

No-IP: The IP-IP Redirector
eAthena SQL: [Jaguar] eAthena SQL
Xampp:
Mirror 1
Mirror 2
[Chapter 2]

Installing and Setting up No-IP.

What is No-IP?

No-IP is an IP forwarding service in which you create a endereçoo by which people can connect to your machine more easily (because it is an “IP” with host name, it is easier to remember).

Making a record in the No-IP:
Click on “Follow-up!” and fill out the form with your data. Email is highly necessary and must be TRUE if you want to actually placing the order, because after clicking the confirmation will be sent to their email a link you must click to activate your account.

After validating your registration, you will be sent to the configuration page of your account
you will see a front page divided into 4 basic parts:
Top = Quick access to your options, help, alternative services (and paid), and finally downloads the information about the No-IP.

Now display the menu on the left menu and click the Hosts / Redirects, having done that click “Add”

Will appear on your screen now which is a form:
Hostname: nomedoseuservirdor

Do not fill out the form nothing.

Now click on Create Host and ready: D

Now that you’ve created your host will install and configure your No-IP.

Click the ducsetup.exe and just click Next> Next> Yes> Next> Next and expect to finish installing.

When installation is complete the image will appear:

http://img477.imageshack.us/img477/2709/tutosql7og.png

In the window you put your email address and password, and so a window will appear:

http://img468.imageshack.us/img468/6209/tutosql4oc.jpg

Click in the window side of the face, and wait for it to do the update of your host.

If everything is correct, such a message will appear:

Very Happy seuserver.no-ip.info: DNS update successful

[Chapter 3]

Installing and configuring Xampp.

Click on the Zip or Exe.
After clicking, select one of the mirrors, and click Download.

When finished downloading, extract the files in C: (Or any other place you like.)
Once the installation is finished, go to C: (Or the folder you extracted the Xampp) and open the folder called xampplite.

Opening this folder, look for setup_xampp.bat and double-click.

Picture File:
http://img413.imageshack.us/img413/8954/setupxampppic4ms.png

Setup_xampp.bat When you start something like this should appear:

http://img107.imageshack.us/img107/7880/openingsetup3tk.png

Expect to carry up the message “Press any key to continue”.
Soon after, press any key to close the window.

After all this, go to the folder xampplite again, and click xampp_control.exe

Something like this will appear:

http://img107.imageshack.us/img107/5922/controlpanel9mg.png

Now click the Start Button Apache MySQL, circled in red.

After you click, something will appear:

http://img413.imageshack.us/img413/9071/controlpanel23lj.png
Now click the “X” to close this window, but note well, that will NOT end the xampp, look on the taskbar and you’ll see an orange icon, xampp is there, running perfectly.
Now, we will record your xampp.

Go to http://127.0.0.1
Now select a language, preferably one that you understand xP
After that, click “Security” left panel and something like this will appear:

http://img401.imageshack.us/img401/5308/nextlink5cb.png

You see this picture? Yes, of course, now see it down there, a link circulated.
Yeah, see? Click on it and something will appear:

http://img127.imageshack.us/img127/3015/xampphs6.jpg

NOTE: Select your Root password BEFORE selecting the directory for the Protection of Xampp, be sure to use long and secure passwords.

* Tip:

Add to your favorites:
http://127.0.0.1/xampp as “CP Xampp”
http://127.0.0.1 accom “Website”
http://127.0.0.1/phpmyadmin as “CP MySQL.”
Use your root password you chose to log in before PMA.

Now do the following, download your eAthena, and put it inside the Xampp folder.

Ex: C: xampplite eAthena

Now, go to the folder C: xampplite eAthena conf

And inter_athena.conf open the file and look for this:
Note: Do not modify the part of the TXT -> SQL Convertors unless you know WHAT you are doing.

Now let the most annoying and complicated.

In the “Create new database” type in ragnarok and click “Create”

Note: WITH HOME IN SMALL, BUT IT WILL LEAD TO AN ERROR!

If all goes well this will appear:

http://img439.imageshack.us/img439/6673/tutosql28on.jpg

Now let’s import the tables.

To import the tables you have to do the following:

Make sure your database is empty ragnarok where it appears the (-) sign “-” means that it is intact.

Now click the “SQL”.

In Pop-Up window click “Import files”. and then click search.

Go to the SQL-files folder of your eAthena MAIN.SQL and select the file and click Run …
If you did right, this window should appear:

http://img421.imageshack.us/img421/8287/tutosql36qn.jpg

“Db_tables.sql”, “item_db.sql” “mob_db.sql”, “mob_db2.sql”, “MAIL.sql”, “logs.sql” and “convert_engine” *

* Convert Engine is used to convert InnoDB tables to MyISAM.

DO ALL THIS SAME ORDER!

Do not confuse with MAIN.sql MAIL.sql, this will cause a big problem.

NOTE: Only the table MAIN.sql is required to run the server, the above tables are used as supplementary tables for those who use the SQL tables and not the txts.

But wait, you’re not done.

In an F5 on your browser and check the database “ragnarok” appears the number 79.

If it did not appear or give a smaller number, that’s OK, but if you want to use SQL tables instead of txts, do it all again.

Type again:

http://127.0.0.1/phpmyadmin

Enter your name if necessary and then click “privileges.”

Do not select the item ROUTER, and click Run.

Now click “Add New User”.

In the “User Name” type: ragnarok
In the “Server” tab select the item: Local (localhost)
In the “Password” field type: ragnarok
And in the “Re-Enter” re-enter: ragnarok

After this click the “Check All” and click Run at the bottom.

And your server is ready, but NOT RUN IT YET!
Now we’ll configure your server!

[Chapter 4]

Configuring your server

First I will present a simple FAQ.

Battle.conf

This is where you define some of the penalties and delay of some skills.

————————————————– ———————————–
Client.conf

This is where you set things from players like Max and Max Level Stats.

————————————————– ———————————–

Drops.conf

This is where you define the settings for items.

————————————————– ———————————–

Exp.conf

This is where you set the rates of your server and type of experience for special cases.

————————————————– ———————————–

GM.conf

This is where the settings for the chars of the GMs are activated.

————————————————– ———————————–

Guild.conf

This is where you define the settings for your WoE and guilds.

————————————————– ———————————–

Homunc.conf

This is where you define the settings for your homunculus

————————————————– ———————————–

Items.conf

This is where you define the settings for some special items.

————————————————– ———————————–

Misc.conf

This is where you define the basics of server, such as the duration of day and night.

————————————————– ———————————–

Monster.conf

This is where you define the settings for the mobs.

————————————————– ———————————–

Party.conf

This is where you configure the settings for your party’s server.

————————————————– ———————————–

Pet.conf

This is where you configure the server of your pets to attack and so on …

————————————————– ———————————–

Player.conf

This is where you configure basic things for players like HP and SP rate.

————————————————– ———————————–

Skill.conf

This is where you define the settings that influence the skills such as Delay, etc. ..

————————————————– ———————————–

Status.conf

This is where you define the settings that will influence skills, such as effects caused and etc. ..

————————————————– ———————————–
Ready! After this mini FAQ will configure your server!

Now we will define the rates, the Max Level, Max Stats etc …

Configuring the client!

Open the folder eAthena conf battle and follow all steps.

Note: If you do not have a folder but a CONF CONF-tmpl just rename.

Open client.conf and search for:
Redeem for 255, with that your server will have 255 as max level and not worry about the above description, remember to edit your Exp Table, check out the Guide to Changing the Exp table in Chapter 6 where it has the Additional Settings.
Here you set the maximum number of pallets.

Note: Just change max_hair_style and max_cloth_color and make sure you have the same number of pallets that you put in the settings!

Now close and save changes and open the player.conf and look for this:
Change 99 & 80 for the number you want

Note: Do not recommend more than 999 of Stats.

Now close and save changes and open the drops.conf and look for this:
Change the Rates of all the things you want, such as drop equips and cards etc …

Recalling that 1x = 100 | | 1000 = 10x | | 100x = 10000 | | 100000 = 10000x and so on …
Now close and save changes and open the exp.conf and look for this:
Here you change the rates of Base and Job Level of your server.

Recalling that 1x = 100 | | 1000 = 10x | | 100x = 10000 | | 100000 = 10000x and so on …

Now you do not level up to a level at a time find that:

and change to YES, so he uTo more than one level at a time.

Now close and save changes and open the skill.conf and look for this:
Here you set the minimum to have dex Instant Cast, and to cancel the search for this delay:

Change to Yes and

Now for some additional settings:

Whether your PK server?

Open the file and look for MISC.conf:
Change to YES to unlock.

Change to NO to disable the MUTE players.
Set the minimum level so that it can participate in the PK.

Do you want to show the HP of the monsters?

MONSTER.conf Open the file and look for this:

Change to YES the HP of the monster appears.
Okay, after doing all that, let’s configure the server IP.

Leave the folder eAthena conf folder and go to battle eAthena conf

Open char_athena.conf.

Change the name of your server just above and then look for this:
Now change the IPs in red to your host at No-IP, so I would be:
Note: DO NOT FORGET TO REMOVE THE DOUBLE Barry / / OR SETTING WILL NOT RUN.

Now open the file map_athena.conf.

And change the IPS in red again for your host in the No-IP.
So would:
Note: DO NOT FORGET TO REMOVE THE DOUBLE Barry / / OR SETTING WILL NOT RUN.

Subnet_athena.conf Now open the file and find this:

Here you put your netmask, and No-IP host, then would be:
Now open the GRF-files.txt and find this:
Usually looks like this:
And see if you put the path of GRFs correctly, otherwise your eAthena not load any map.

Ready your emulator is configured!

Then just adjust according to the request of the users … xD

[Chapter 5]

Adding NPCs

Adding NPCs?

If you want to insert NPC Reset Girl and Etc. .. Open the file scripts_custom.conf.
Find it:

And just remove the / / like this:
Now if you want to add scripts that you did save the NPCs in your npc folder custom.

Now go to your folder and open scripts_custom.conf NPC.

Find it:
And add this:
And you added your NPCs!

[Chapter 6]

Creating your account GM.

1 Open your PMA.

2 Select your database “ragnarok”

3 º Open Table .. Login

http://img224.imageshack.us/img224/3170/gmacc4fn1to.png

Click to view the 4th and that window will open:

http://img209.imageshack.us/img209/3605/gmacc13tc.png

5 Find the account you want to edit

6 Click the lapizinho ^ ^

7 In the edit level for the tag number corresponding to the level of GM

8 Then click Run on the bottom of the page!

[Adding Machine GM]

Now that’s the easy part …
You have to go in the DATA folder in your Ragnarok directory .. find the sclientinfo.xml and open it with Notepad.

You will get something like this:
In Blue is the place for you to put the ID in the table you axou Login to your PMA.

Assuming that the ID is 2000000, then looks like this:
[Chapter 7]

[Additional Settings]

    Installing Crucible by ROCP
    Installing Crucible by Ceres CP [Alternative and Recommended]
    Configuring Firewall by newtcv
    Making Your Banned by Hexed
    Creating Custom Items by dex
    Exp Editing Your Table by Mr. Sapphire

    Important: The Control Panels are to be added in the C: xampplite htdocs so they can work!

Additional Notes:

If the emulator says he has a s1/p1 error with the password, you can change the password on the table and login Login Server account easily.

Click on the database “ragnarok” and then view the log table.

Tag in the login and password, change it to something easy to remember and difficult to hack.

So this is done, Open the file and the file char_athena.conf map_athena.conf find this:
And change for the same thing you put in the login table and the same in both files.

Note: The tutorial was created with Version eAthena SQL SVN TRUNK 9930