Alright, i said i´ll make a guide for all who got problems with setting up these files.
I won´t post/upload any files without the permission from Muno or Stu and i won´t post/upload any edited files, you have to learn to do things on your own, thats where we ALL started!
This guide will be updated & improved from time to time.
This guide is only for advanced user!
This guide is only for the basic-setup, it won´t help you if you never set up a fiesta server, because there are requirements you need to do with 2008 files first!
This quote describes it very good:
Originally Posted by Wolfy5079
I recommend learning how to use the old files first and getting them to run. These files aren't exactly for those who are new to the pserver scene. Go back to the old files. Learn how to set that up and make it run. familiarize yourself with the files and how they work and then try and setup these new files.
Please use these threads instead:
Important threads & downloads
Fiesta Online 2008 Install Guide
Before i start, i wanna let you know that i´m german, so please have understanding that there can be spelling/grammar mistakes, send me a PM or post it here. You can also send me suggestions for improvements.
I would also like to ask you to report me every mistake, whether if it is a typing error or something that you think is wrong like a wrong ODBC or database restore name.
Thanks in advance ~
Thanks to Kreain who fixed the base files (Dusk | Link to post) and of course i want to thanks Muno and Stu for this awesome release. Without you this wouldn´t be possible! Even if you left, you will leave your footprints in this scene forever! (Too much drama? xD)
News
2012.11.28 | Guide & Login Tool Update, Client Fix and ReaLife timeout
Many people got problems with the client manipulation error. Tis is caused by a difference between the server- and the clientfiles. The "Odin Installer.exe" isn´t patched, but the serverfiles contain the latest patch.
I don´t want to get spammed by these error, so i decided to release the my raw "ressystem" and "Shine" folder to fix this. Check out Step #1 requirements.
Nothing is edited, deal with it.
The other part of this news post is my timeout. My RL always got priority number one! Thatswhy i´ll timeout from fiesta-scene. I do not know for how long, if there are problems post them in the help-scetion or in one of my threads, someone will help you out.
Last but no least: With this news post the guide is now updated to version 1.3.1! I alos will release an update for my Odin Login Tool, check out the thread!
In advance , i wish you nice x-mas and a happy new year party :D
Regards,
ChubbyCrab
Code:
Guide Version=1.3.1
Last updated=2012.11.28 12:38pm
Author=ChubbyCrab
Skype=chubbycrab
This guide was created for Ragezone. Do not post it elsewhere without my permission. I see everything ~
Credits
Server&Client files + Odin Tools
"Stu" (iStu) View Profile
"Muno" (munozvo5) View Profile
Base server files (Dusk)
Kreain View Profile
SHN-Editor
"CSharp"
"Grammar N4z1" & mistake killer :D
Crystalz View Profile
Chestyx3 View Profile
Wise words ;p
Wolfy5079 View Profile
Everyone else who made this possible!
If there are problems post them here or add me in skype!
Changelogs
Spoiler:
v1.3.1
Shortened some hyperlinks
Guide-Version number is now three digits long
Sorted required donwloads and added optional options
Improved some general descriptions
Improved description at Step #8.5
->Make sure to click in another field before you save the file!
Fixed amount of "ItemInfo.shn"-words (Step #9)
Fixed some grammar/spelling/typing mistakes
Fixed description about Odin REST server port (Step #8.5)
->REST server ONLY runs on port 80, do not change it!
Fixed the double Step #6, second one renamed to "Step #6.1"
Added direct-links to names and downloads
Added News-section
->News added: 2012.11.28 | Client Fix and ReaLife timeout
Added some lines to seperate sections
Added warning at Step #10.3
->Make sure there is no # at the beginning of the line!
Added warning at Step #8.4
->Make sure the IP is set to "127.0.0.1", also if you want to run the server on Hamachi!
Added information at Step #10
->REST server only able to work if the host-file was edited correctly!
Added warning at Step #17
->Every account must have an unique ID and token!
v1.2
Improved some descriptions
The changelogs now sorted by the latest
Fixed some grammar/spelling/typing mistakes
Fixed the link to client | Thanks to Chestyx3; Link to post
Fixed some empty lines
Fixed [CODE],
[LIST] & [URL] tag errors | Thanks to Crystalz; Link to post
Fixed some incorrectly expressed descriptions
Fixed a bug in the SQL account script (Step #15) | Thanks to Crystalz; reported via PM
Added new headline in credit section
Added recommendation for the deletion of the old databases and ODBC settings (Step #4 & Step #6)
Added recommendation for the port of the RESR server | Thanks to Stu; Link to post
Added color highlighting to some codes
v1.1
Fixed some grammar/spelling mistakes
Fixed typing error in batch script
Added "Known errors"
Added "[CODE]" tags for codes
Added "[I]" tags for file & specific names
Changed font for path names
v1.0
Release of the Odin Install Guide
Known errors
Spoiler:
Some undetected spelling/grammar/typing errors :D
In some parts are too many empty lines
Some mysterious and random space-chars behind sentences :O
Step #1
Requirements:
READ EVERYTHING ATTENTIVELY AND DO NOT SKIP STEPS!
Make sure you have administrator rights
Base knowledge about the functionality of fiesta server services
Base knowledge about the functionality of MSSQL-Servers
Working SQL-Server & ODBC from Fiesta 2008 files
Base knowledge about the file format "SHN" and the SHN-Editor
Base knowledge about Hex-Editing
Base knowledge about the general use of an computer =)
Odin-Server files & Odin-Client files
Odin-Client
Server-Services (including Database & Updated RESTServer-Service & Fixed ItemInfo.shn)
Client Manipulation FIX
Hex-Editor, i recommend "HxD"
SHN-Editor
[OPTIONAL]ChubbyCrab`s Odin Login Tool
[OPTIONAL]Extrinsic Studio Products (Public server only)
[OPTIONAL]Notepadd ++, best text editor ever ~
Step #2
You should now have these files:
Odin Server.rar
Odin Client.rar
OdinInstaller.exe
Odin.rar
ItemInfo.shn
OdinRestServer.exe
If you don´t have them, got back to Step #1 and download them from the linked threads.
Put all these files into one folder, so you don´t have to search them all the time when they are needed.
Step #3
Start your SQL-Server and delete all fiesta related databases that are in the "Database"-folder.
This is not necessary, but it prevents errors and confusions!
Account
AccountLog
OperatorTool
StatisticsData
World00_Character
World00_GameLog
Do NOT delete "System Databases"! (Just saying ~)
Now unpack "Odin.rar", rename it to "Odin" (called "rar" if you unpack it) and restore all the databases.
Database name Backup filename
AccountLog AccountLog.bak
OdinAccounts OdinAccount.bak
OperatorTool OperatorTool.bak
StatisticsData StatisticsData.bak
w00_character w00_character.bak
w00_GameLog w00_GameLog.bak
Step #4
Time to set up the ODBC. To obtain a better overview, you can delete all fiesta related System-DNS you created for the 2008 files.
New ODBC names:
ODBC name Standard database name
AccountLog AccountLog
OdinAccount OdinAccounts
OPTool OperatorTool
Statistics StatisticsData
w00_character w00_character
w00_GameLog w00_GameLog
Step #5
Go to your main folder and rename the "ItemInfo.shn" into "ItemInfG.shn". You can rename it to whatever you want AS LONG AS THE NUMBER OF CHARACTERS REMAINS THE SAME!
Examples:
ItemInf0
ItemInf2
ItemBoob
If there are more then 8 characters in the name your server won´t work!
Step #6
Open your service-window (Start->Execute->"services.msc") and check out if there are old services from 2008 files. I recommend to delete them, it only irritates you and also prevents errors.
Use this batch script to delete all fiesta related services, it also contains new services:
Code:
sc delete PG_AccountDB_Server
sc delete PG_AccountLogDB_Server
sc delete PG_Login_Server
sc delete PG_World00_Character_DB_Server
sc delete PG_World00_GameLog_DB_Server
sc delete PG_World00_Manager_Server
sc delete PG_Zone_Server
sc delete PG_Zone_Server0
sc delete PG_Zone_Server1
sc delete PG_Zone_Server2
sc delete PG_Zone_Server3
sc delete AccountLogDB_Server
sc delete Character_DB_Server0
sc delete GameLog_DB_Server0
sc delete Login_Server
sc delete Manager_Server0
sc delete AESIRGAMES_OdinRestServer
sc delete Zone_Server00
sc delete Zone_Server01
sc delete Zone_Server02
sc delete Zone_Server03
Step #6.1
Unpack "Odin Server.rar" and copy the "Shine" folder into "Odin\9Data", overwrite everything.
Step #7
Copy the renamed "ItemInfo.shn" (called my one "ItemInfG", "G" for GameLog, you´ll see it in the next steps why) from Step #5 and paste it into "Odin\9data\Shine".
You should now have the normal "ItemInfo.shn" (ca. 3855 KB) and the renamed one "ItemInfG.shn"(or whatever you named it, ca. 2868 KB).
Step #8
Copy the "OdinRestServer.exe" into "Odin\REST\", overwrite the existing one.
Step #8.1
Now open the "OdinRestServerSettings.shn" with the SHN-Editor. Use "v3d" or "v1"! Any other version will bug your files!
Add a new row and paste the following:
Column "Setting"
Code:
OdinServer.TokenManager.EnforceExpireDate
Column "Value"
Code:
False
Step #8.2
Now you have to set the correct servername at "DatabaseManager.DataSource.Server" (First column). It consists of the name of your computer and the name of your SQL-Server.
Synthax: <ComputerName>\<SQL-ServerName>
Example: TEST-PC\SQLEXPRESS
Step #8.3
Make sure that the value of "DatabaseManager.DataSource.AccountTable" (Third column) is "OdinAccounts". Look for the "s" at the end, it is easy to overlook.
Step #8.4
Make sure that the value of "OdinServer.Socket.IP" (Sixth coulmn) is set to the IP of your server, in general its 127.0.0.1
IF YOU PLAN TO RUN THE SERVER ON HAMACHI, THE IP ALSO HAVE TO BE "127.0.0.1"! ELSE THE SERVER WON´T WORK ON HAMACHI, DO NOT REPLACE IT WITH THE HAMACHI-IP!
Step #8.5
Make sure the value of "OdinServer.Socket.Port"(Seventh coulmn) is "80".
DO NOT CHANGE IT! REST-SERVER IS ONLY ABLE TO RUN ON THIS PORT!
Close all other applications that use the port 80 like Skype!
It should now look similar like this:
CLICK IN ANOTHER FIELD BEFORE YOU SAFE THE FILE! ELSE YOU CHANGES WON´T BE SAVED!
One of the most errors is, that user editing the file correctly, but forget to click on another field! Also many forget to save, the editor won´t save your changes automatically when you close it!
Step #9
Open your Hex-Editor ( i really recommend to use "HxD", its free, not overloaded with unnecessary functions, creates automatically backups and works stable). Open the "GameLog Release.exe" out of "Odin\GameLog".
Now serach for "ItemInfo.shn". There are four at all!
Change it so it matches to the name of your renamed file ("ItemInfG.shn").
DO NOT PRESS BACKSPACE OR DELETE! ONLY MARK THE CHARACTER YOU WANT TO CHANGE AND THEN PRESS THE CORRESPONDING BUTTON!
Else you will change the size of the .exe and it´ll be bugged/destroyed! ("HxD"-Editor will warn you if you want to do it)
Hint: You can press "F3" to search for the next, so you dont have to open the search-windows all the time ;p
If you renamed all SAVE the file!
Step #10
To prevent problems with the OdinRestServer, you have to edit the host file
hosts (file) - Wikipedia, the free encyclopedia
The Odin REST server ist only able to work if you edited the host-file correctly!
Step #10.1
Go to Start and search for "notepad". Right-click it and RUN AS ADMINISTRATOR (Only Win7, i think in XP it should work without administrator-mode).
Step #10.2
Now open your hosts file, its located here:
%systemroot%\system32\drivers\etc
(Systemroot means the drive-letter you installed your operating system) (Just saying ~)
Step #10.3
Copy this into a new line at the end of the file:
Code:
127.0.0.1 stubedore.t
MAKE SURE THAT THERE IS NO "#" AT THE BEGINNING OF THE LINE, LINES WITH THIS ARE COMMENTS AND WON´T BE READ BY THE SYSTEM!
DO NOT DELETE ANY SPACES, THERE MUST BE ONE BETWEEN THE IP AND THE NAME!
Step #11
Ok, this step is only for the one who will run the server/game on XP/Server 2003/Server 2008 or Windows 7 without administrator rights. This is to prevent an communication error between the MSSQL-Server and the OdinRestServer.
Step #11.1
Login to your MSSQL Database. Open up "Security" -> "Logins"
Right-click on "NT AUTHORITY\SYSTEM" -> "Properties"
Step #11.2
Now click on "User Mapping", put a hook at "OdinAccounts" and hook all the options at "Database role membership for: OdinAccounts"
Step #12
It´s time to install the Client now. Right-click on "OdinInstaller.exe" and "Run as Administrator".
Wait till it is finished and go on to the next step.
Step #13
Unpack "Odin Client.rar" and copy it into the root of your client (which you installed in the previous step). Overwrite everything.
Step #14
Now you need to check if the configuration file of each service is in the same folder as the service exe´s.
YOU HAVE TO ACTIVATE "SHOW HIDDEN FILES" IN YOUR EXPLORER, ELSE YOU WON`T SEE THEM! THIS ALSO INCLUDES SOME SERVICE EXE´S! (Show hidden files)
Folder name Configuration file name
AccountLog DataServerInfo_AccountLog.txt
Character DataServerInfo_Character.txt
GameLog DataServerInfo_GameLog.txt
Login LoginServerInfo.txt
World00 WMServerInfo.txt
Zone00 ZoneConf.txt
Zone00 ZoneConf.txt
Zone00 ZoneConf.txt
Zone00 ZoneConf.txt
If everythings there, go on. Else copy out the missing files from the "Odin.rar".
Step #14.1
Go to "Odin\9Data\ServerInfo". There are two files called "test_Manager_ServerInfo.txt" and "test_ServerInfo.txt".
The following edits have to be done IN BOTH FILES!
Now you have to check if all the lines where NO semicolon(;) is at the beginning of the line[/U]!
All lines that start with an semicolon(;) are commented out and will be ignored by the server!
Hint: I recommend to use Notepad++ for this step, it really reprents these files clear and sorted, its easier to edit them this way.
You have to replace all the IPs with the IP from your server now, in general its "127.0.0.1".
Hint: Use the "Search and Replace" function of your editor.
Now you have to replace the Username and Password with the ones from your MSSQl database too! This is very important, else the services can´t connect to the database!
In these configuration files the user is set as "fiesta32" (UID=fiesta32) and the password to "***" (PWD=***)
Description Named in the file
Username UID
Password PWD
If you forgot your username try "sa" for it. This is the standard user when you install an MSSQL Server. If you forgot your password you have to google if there are possibilities to restore/reset it. If not, i recommend to reinstalling the MSSQL Server and write down the password somewhere safe ( Steganos LockNote - Download - CHIP Online | free, AES256), or on any piece of paper ;p
Step #15
Now you have to create an account. Login into your MSSQL database, go to
Databases -> OdinAccounts -> Tables -> dbo.tAccounts
and create an account manually OR use the following query:
Code:
INSERT INTO OdinAccounts.dbo.tAccounts (nEMID, sUsername, sUserPass, sUserPassSalt, sEmail, sIP)
VALUES ('1', 'admin', 'admin', 'admin', 'admin@localserver.com', '127.0.0.1')
Step #16
Now you have to register all the services. The service exe´s are in the "Odin" folder, one in each folder, except "Client" and "Databases". There are 10 services overall.
YOU HAVE TO RIGHT-CLICK AND "RUN AS ADMINISTRATOR", ELSE THEY WON´T REGISTER OR END UP IN ERRORS!
Step #17
To connect your client to the server, you need to set an token in the database. Go to
Databases -> OdinAccounts -> Tables -> dbo.tTokens
and create an token manually. Make sure to set the "nEMID" to the same as your account!
OR use the following query:
Code:
INSERT INTO OdinAccounts.dbo.tTokens (nEMID, sToken)
VALUES ('1', 'IL1k3t0sh1tH4rD')
EVERY ACCOUNT MUST HAVE A UNIQUE nEMID AND A UNIQUE TOKEN,ELSE THIS WILL CRASH YOUR SERVER!
Step #18
This is the last step before you can enjoy the new game feeling :D
To log into the game you need to create an batch/vb/java script, which starts the "Odin.exe" with some attributes.
Synthax:
Code:
Odin.exe -osk_server <IP of your server here> -osk_token <the token you created in the database> -osk_store <URL to your store or a random URL>
Here´s a example with the token from Step #17:
Code:
Odin.exe -osk_server 127.0.0.1 -osk_token IL1k3t0sh1tH4rD -osk_store Google
Save it as <RandomName>.bat (Example: LOCAL_START.bat)
Start your Odin services.
Thats it!
Enjoy the updated server files!
ChubbyCrab
Ragezone