Newbie Spellweaver
- Joined
- Dec 27, 2006
- Messages
- 5
- Reaction score
- 0
Guide Key:
Black Font - The Actual Guides
Blue Font - Extra information
Red Font - File Downloads
Green Font - Website Link
Orange Font - Picture View
*All neccessary files are at the end of this post.*
First Step - Attaching Database:
1: Open Enterprise Manager.
(Or Download MSQL, I reccomend Advanced -
You must be registered to see links
)2: Keep clicking on the + till u see Databases.
3: Now right click and goto All Tasks/Attach Database.
4: Locate the Database files u downloaded.(SQL DB Download -
You must be registered to see links
)5: Click OK.
6: Step 1 Completed!
7: Picture -
You must be registered to see links
(Using another program like MSQLExpress/Business Studio?)
(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 -
You must be registered to see links
) 2: Search for 61.218.244.18 (Line 7C050)
3: Change to your IP. (
You must be registered to see links
)4: Do not change the second one.
5: Save.
6: Step 2 Completed!
7: Picture -
You must be registered to see links
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.(Picture Step 1)
5: Click Add. (Picture Step 1)
6: Scroll down the the bottom and double click on SQL Server. (Picture Step 2)
7: In Name type AglaiaSQL. (Picture Step 3)
8: In Description LEAVE BLANK.
9: In Server type in your IP and click Next. (Or enter your MSQL Name)
10: Choose Windows Authentification and click Next. (Picture Step 4)
(If it doesn't work then start your Service Manager. See Picture)
11: Tick Change the default databse to: and select AglaiaSQL, Click Next. (Picture Step 5)
12: Click Next then Next again then OK. (Picture Step 6 & 7)
13: Step 3 Completed!
14: Picture -
You must be registered to see links
,
You must be registered to see links
Fourth Step - SQL Login:
1: Open Enterprise Manager.
2: Click all the + till u 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 Databse 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!
8: Picture -
You must be registered to see links
Sixth Step - Account Creation:
1: Open Enterprise Manager. (Or MSQLExpress)
2: Keep clicking on the + till u 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!
You must be registered to see links
)13: Close the window, don't worry it save as you change it.
14: Step 6 Completed!
15: Picture -
You must be registered to see links
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.)
10: Pictures -
You must be registered to see links
,
You must be registered to see links
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!
9: Pictures -
You must be registered to see links
,
You must be registered to see links
My FTP File Downloads-
You must be registered to see links
Files needed to play the game.(Translated Message.txt)
You must be registered to see links
AuthServer, GameServer(Translated Message.txt), LoginServer, PatchServer, DB Files.
You must be registered to see links
Made for quick & easy editing of your account db.
You must be registered to see links
Allows you to edit game sprites.
-For the record, this is just information I've gathered from all the aglaia posts I've read. I'm a bit of a neat freak, and prefer things to be organized. This helps my wife and I to ensure everything is working properly, and if something isn't then it's not hard to backtrack. We've decided to host a server, and develop it as far as we can. Sharing everything along the way!
Credit for this Guide goes to every user who has posted in the Aglaia section.
Last edited: