Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Server Setup | FAQ | Troubleshooting Guide

Initiate Mage
Joined
Jul 7, 2006
Messages
39
Reaction score
2
Introduction to Aglaia Online

Aglaia Online is a massively multiplayer online role-playing game developed by a Taiwan group called KiwiGame, the website and company has since a year ago been shut down.
Six professions with many specialization - Alchemist, Warrior, Wizard, Priest, Hunter and Worker mixed together with five races - Human, Elf, Dwarf, Pixie and Orc. The game features a complete 'alchemy system and gather system' allowing players to make up to 800 item, pk system that allow 1 vs 1 or team battle of 16 vs. 16 and a shop system.


Table of contents

Compiled by
Axel Hansson.
Credits to Avarant - MMan - Dovac - taarna23.
 
Last edited:
Initiate Mage
Joined
Jul 7, 2006
Messages
39
Reaction score
2
[1] List of tools and files

Development related
*
* AglaiaPak (Pre-made database)
* (SQL Manager, used to handle playerdata)

* (txbcon lets you extract the images contains within the different .txb of the game, and create .txb from your images.)
* (zlibtxtcon works mostly the same way, but with text strings from the game.)

Client related
*
*


* (Replaces the original Aglaia Patcher - Readme and support can be found here.)

Links
 
Last edited:
Initiate Mage
Joined
Jul 7, 2006
Messages
39
Reaction score
2
[2] Server Setup Guide

First Step - Attaching Database
1: Open Enterprise Manager.
(Or Download MSQL, I recommend Advanced - )
2: Keep clicking on the + till you see Databases.
3: Now right click and goto All Tasks/Attach Database.
4: Locate the Database files you downloaded - Aglaia Pak (Here)
5: Click OK.
6: Step 1 Completed!
(Then save the DB files into C:\Program Files\Microsoft SQLServer\MSSQL.1\MSSQL\Data)


Second Step - Hex'ing Gamerserver

1: Open Game Server v20.exe with a hex editor.
(Best Freeware Hex Editor - )
2: Search for 61.218.244.18 (Line 7C050)
3: Change to your IP. ( )
4: Do not change the second one.
5: Save.
6: Step 2 Completed!


Third Step - ODBC Resource Manager
1: Open Control Panel.
2: Open Administrative Tools. (Can't find it? Try using the Windows Classic View.)
3: Open Data Sources. (ODBC)
4: Click on System DSN.
5: Click Add.
6: Scroll down the the bottom and double click on SQL Server.
7: In Name type AglaiaSQL.
8: In Description LEAVE BLANK.
9: In Server type in your IP and click Next. (Or enter your MSSQL Name)
10: Choose Windows Authentication and click Next.
(If it doesn't work then start your Service Manager.)
11: Tick Change the default database to: and select AglaiaSQL, Click Next.
12: Click Next then Next again then OK.
13: Step 3 Completed!


Fourth Step - SQL Login
1: Open Enterprise Manager.
2: Click all the + till you see Security.
3: Click on Security and right click on it and select New Login.
4: In Name type in your name.
5: Click SQL Server Authentication and enter a password.
6: Change Database to AglaiaSQL.
7: Click Server Roles at the top.
8: Check all the boxes.
9: Click Database Access at the Top.
10: Check AglaiaSQL.
11: Check the last 4 boxes in Database roles for `AglaiaSQL`.
12: Clock OK and enter the same password u entered in part 5.
13: Step 4 Completed, or Skipped!
(MSQLExpress has a default login of sa, and password you decide at setup. Skip this!)


Fifth Step - Changing IP's
1: Goto Authorization Server folder.
2: Open AuthorizationData and create an ID and PASS. (*USED IN STEP 6*)
3: Save & Close.
4: Goto Login Server folder.
5: Open LoginIPData and change ServerIP to your IP
6: Save & Close.

7: Step 5 Completed!


Sixth Step - Account Creation
1: Open Enterprise Manager. (Or MSQLExpress)
2: Keep clicking on the + till you see AglaiaSQL.
3: Click again so u can see Tables.
4: Click on Tables.
5: Then you'll be able to see Account in right side window.
6: Then right click on Account, select Open Table.
7: Then simply insert any ID and PASS, this is how you make accounts.
(Make an ID and PASS identical to the ones you used in Step 5:2)
8: Close that window.
9: Next click on Stroke Point.
10: Then right click again and select Open Table.
11: Insert the ID of an account you've created.
12: Fill the rest of the fields as such: 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1
(Each number is a different field in the Stroke Point Table!)
13: Close the window, don't worry it saves as you change it.
14: Step 6 Completed!

Seventh Step - Running The Server
1: Launch Login Server using the SQL Name and Pass u used in Part 4.
(MSQLExpress users this is the account sa, with password you chose.)
2: Click Start.
3: Launch Authorization Server
4: Click Start
5: Launch Game Server (Takes a minute or two for it to load.)
6: Change Auth ID & PW to what u used in Step 5:2.
7: Change SQL ID & PW to what u used in Step 4:5.
8: Click Start.
9: Step 7 Completed!

(The top of the program should say Read Save Complete after its done loading.)


Eighth Step - Playing The Server
1: Open the Aglaia Client Folder.
2: Open IPData-ori.ini with Notepad or Wordpad.
3: Change all Server IP's to your IP Address.
4: Change all Server Ports to 2000.
5: Save & Close.
6: Run the Aglaia.exe program.
7: Login with a username and password you created in Step 6.
(Do not use the one also in the AuthorizationData file, Step 5)
8: Step 8 Completed!

Written by AVARANT.
Edited by Axel Hansson.
 
Initiate Mage
Joined
Jul 7, 2006
Messages
39
Reaction score
2
[3] Frequently Asked Questions (FAQ)

------------------------------------------------------------------------
Q: Where did all the player data go when my server crashed?
A: Sadly, Aglaia Online has problems saving the game properly. Well, it doesn't save at all unless you shut it down manually. Recommended tactic is a daily serversave.
------------------------------------------------------------------------
Q: The game isn't translated!
A: Translation depends on the amount of people working on it. To get the latest translation head over to
------------------------------------------------------------------------
Q: I did everything the guide said but can't connect!
A: Then do it again.
------------------------------------------------------------------------
Q: Why do I get the message "Version does not match"?
A: Your using the incorrect version for your server, or you have the *VERSION parameter with the wrong client value there.
-------------------------------------------------------------------------
Q: Uh, How do I make an account?
A: Use a register script or tool, makes your day much easier. Check "[1] List of tools and files."
-------------------------------------------------------------------------
Q: How do I setup the Aglaia GamePatcher?
A: Read: http://forum.ragezone.com/f96/aglaia-gamepatcher-patch-server-361602/
-------------------------------------------------------------------------
Q: What are the GM Commands? How to make a GM?
A: The GM Commands are unknown for the moment. A guide how-to create a GM character can be found at http://forum.ragezone.com/f96/thanks-mman-aegis-boards-how-make-yourself-gm-33424/
---------------------------------------------------------------------------
Q: Why doesn't everyone help me!
A: Because they're here to share, and if your just taking, why help you?
---------------------------------------------------------------------------
Q: If I want to seriously host a server, what should I do?
A: Get a dedicated team, either get dedicated hosting or get a good computer at home (512Mb Ram, 1Ghz+ processor) on its own DSL (30 - 40 people), T1 (50 - 80 people) or a FiOS line (100+ people).
---------------------------------------------------------------------------
Q: I've read all the guides, I've read this FAQ, I even bugged 30 people to death on MSN and I can't figure any of this out!
A: May I suggest you give up?
---------------------------------------------------------------------------

Taken from SiK's pristontale guide found at http://forum.ragezone.com/f286/guide-any-files-server-setup-faq-troubleshooting-guide-245772/
 
Initiate Mage
Joined
Jul 7, 2006
Messages
39
Reaction score
2
[4] Troubleshooting Guide

------------------------------------------------------------------------
Q: SetRenderEnv Error
A: http://forum.ragezone.com/f96/if-you-get-setrenderenv-error-look-here-fix-25337/
------------------------------------------------------------------------
Q: Game Server stays at standby (Server state)
A: Most likely you haven't followed the guide correctly. Though, If you have there's a chance that you haven't set your IP properly. Remember that if you have a dynamic IP and no router you will have to change to your current IP for it to work. You can't use services as DynDNS and you will need to contact your ISP and obtain a static IP (Usually costs a small sum).
------------------------------------------------------------------------
 
Last edited:
Initiate Mage
Joined
Feb 13, 2008
Messages
1
Reaction score
0
very sweet tutorial, already downloading the files to give it al an try :)
 
Initiate Mage
Joined
Jul 7, 2006
Messages
39
Reaction score
2
If you get into any problems post here and I'll see what I can do.
 
Last edited:
Initiate Mage
Joined
Aug 31, 2006
Messages
61
Reaction score
1
There are a lot of people who have followed this guide and faced some problems.

Here are the (my) research, hope they help.

1. You can use MS_SQL2000 instead of 2005 Express. You can set it up by using Mixed mode and use "sa" as default admin user and you can set the password by your own.

2. After you have launched all Authen, Login, Game server, you can notice that your server status is still "standby", don't worry it is OK.

The problem of many people faced is they can not log in the server. It appeared as "connecting" for around 10 sec. and then appeared an error message of something about cannot connect and try again later. (sorry for the exact error, i forgot)

The resolution is that, you must use :
- When you launch Game server, before launching, set the server port to 11030.
- In login server .ini, you have to specify the port to be 11030.
- Then, in client, you change ipdata.ini , and set all patch server ports to 11030 and all login server ports to 11031.

- Authenrized ID and password which you have set into the Authen server, I think it may be the GM ID or whatever. Anyone has idea, please share.

I have done that and then I can go inside Aglaia world. Hope it helps. Don't give up. they (Aglaia) are not fully dead yet.
 
Initiate Mage
Joined
Nov 11, 2007
Messages
66
Reaction score
25
Im so happy when i see aglaia online its not dead, im do it the best to translate aglaia into english and spanish, im from chile and im a dev of sAthena (spanish athena), and im do it my best to do a aglaia online community.
 
Initiate Mage
Joined
Apr 5, 2009
Messages
8
Reaction score
0
I noticed the directions are written for MS SQL 2000, not 2005. Also for step 3.9 I had to enter my SLQ server name, entering my IP returned with a error screen. There's also a problem when you hex the game_server_v20.exe, if your IP has more characters then the default IP, if you insert a string it causes a problem with the program rendering it unusable. You have to delete a 00 value after the default IP so you can insert a new string.
 
Initiate Mage
Joined
Apr 22, 2008
Messages
4
Reaction score
0
Hey if it makes anyone feel better, I am here, and I just got my aglaia sever working today = ), Aglaia will never die.
 
Initiate Mage
Joined
Mar 27, 2010
Messages
3
Reaction score
0
hello bro
i was going to say thanks for the server files
and i was going to ask ca you make some screen shots for example
the "2: Keep clicking on the + till you see AglaiaSQL." i really don't understand the +
 
Junior Spellweaver
Joined
Mar 26, 2011
Messages
194
Reaction score
13
@DogZern Someone has the database link working Unfortunately I did not find any links working.

Locate the Database files you downloaded - Aglaia Pak (Here) ? link not working
 
Back
Top