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!

[NA - 2008] Server Files & Guide

Status
Not open for further replies.
Newbie Spellweaver
Joined
Jan 19, 2013
Messages
88
Reaction score
16
Re: Server Files + Guide

And how do I let my brother play on my server :D?
 
Joined
Jan 24, 2013
Messages
828
Reaction score
351
Re: Server Files + Guide

And how do I let my brother play on my server :D?

127.0.0.1 is your local ip address, meaning only your computer can connect to it. Buy a dedi or set it up in a different way using Lugaphas guide OR use Hamachi. Since it'll be a small server I suggest using Hamachi. Replace "127.0.0.1" in your server config and in your .exe to the Hamachi IP. You can download Hamachi from their website.
 
Newbie Spellweaver
Joined
Jan 19, 2013
Messages
88
Reaction score
16
Re: Server Files + Guide

What u want with this poop ? use the new files^^
If I knew how lol, there is only 1 tutorial I understood and they were with old files so I have no idea how to make a server with new files
 
Newbie Spellweaver
Joined
Dec 1, 2012
Messages
10
Reaction score
2
Re: Server Files + Guide

Is this guide still working and all links good?
 
Newbie Spellweaver
Joined
Jun 30, 2011
Messages
37
Reaction score
2
Re: Server Files + Guide

I have same question with him..hope some1 can answer please ^_^

The databases were created and dumped on MSSQL 2008 so therefore the structure is different so mostly not backwards compatible with older versions of MSSQL. If you insist on using it install VMWare on your PC with windows and MSSQL 2008, import the DB's then export them as plain SQL files (it will take you forver because you have to do every stored procedure as well as table)
 
Initiate Mage
Joined
May 3, 2013
Messages
2
Reaction score
0
Re: Server Files + Guide

This thread is really old. Can anyone help me out?

This is the log file for AccountLog, If I start the service it says "The _AccountLog DB Server service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs."
000000 2013-06-20 15:50:48 C:\Fiesta\Fiesta Files\Server\AccountLog
000001 2013-06-20 15:50:48 -------------------------------------------------------
000002 2013-06-20 15:50:48 Launching the server.....
000003 2013-06-20 15:50:48 Local Time 20/6/2013 3:50:48 PM
000004 2013-06-20 15:50:48 System Time(UTC) 20/6/2013 7:50:48 AM
000005 2013-06-20 15:50:48 <SUCCESSED SCRIPTOR READ> config.txt
000006 2013-06-20 15:50:48 <I AM THE _AccountLog DB Server, SERVER_ID_DB_ACCOUNTLOG, WorldNo=0, ZoneNo=0>
000007 2013-06-20 15:50:48 Service start(no parameter)
000008 2013-06-20 15:50:48 <IOCP WORKTHREAD #0 RUNNING>
000009 2013-06-20 15:50:48 <IOCP WORKTHREAD #1 RUNNING>
000010 2013-06-20 15:50:48 <IOCP WORKTHREAD #2 RUNNING>
000011 2013-06-20 15:50:48 <IOCP WORKTHREAD #3 RUNNING>
000012 2013-06-20 15:50:48 <IOCP WORKTHREAD #4 RUNNING>
000013 2013-06-20 15:50:48 <IOCP WORKTHREAD #5 RUNNING>
000014 2013-06-20 15:50:48 <IOCP WORKTHREAD #6 RUNNING>
000015 2013-06-20 15:50:49 <IOCP WORKTHREAD #7 RUNNING>
000016 2013-06-20 15:50:49 <IOCP WORKTHREAD #8 RUNNING>
000017 2013-06-20 15:50:49 <IOCP WORKTHREAD #9 RUNNING>
000018 2013-06-20 15:50:49 <IOCP WORKTHREAD #10 RUNNING>
000019 2013-06-20 15:50:49 <IOCP WORKTHREAD #11 RUNNING>
000020 2013-06-20 15:50:49 <IOCP WORKTHREAD #12 RUNNING>
000021 2013-06-20 15:50:49 <IOCP WORKTHREAD #13 RUNNING>
000022 2013-06-20 15:50:49 <IOCP WORKTHREAD #14 RUNNING>
000023 2013-06-20 15:50:49 <IOCP WORKTHREAD #15 RUNNING>
000024 2013-06-20 15:50:49 <IOCP WORKTHREAD #16 RUNNING>
000025 2013-06-20 15:50:49 <IOCP WORKTHREAD #17 RUNNING>
000026 2013-06-20 15:50:49 <IOCP WORKTHREAD #18 RUNNING>
000027 2013-06-20 15:50:49 <IOCP WORKTHREAD #19 RUNNING>
000028 2013-06-20 15:50:49 <IOCP WORKTHREAD #20 RUNNING>
000029 2013-06-20 15:50:49 <IOCP WORKTHREAD #21 RUNNING>
000030 2013-06-20 15:50:49 <IOCP WORKTHREAD #22 RUNNING>
000031 2013-06-20 15:50:49 <IOCP WORKTHREAD #23 RUNNING>
000032 2013-06-20 15:50:49 <IOCP WORKTHREAD #24 RUNNING>
000033 2013-06-20 15:50:49 <IOCP WORKTHREAD #25 RUNNING>
000034 2013-06-20 15:50:49 <IOCP WORKTHREAD #26 RUNNING>
000035 2013-06-20 15:50:50 <IOCP WORKTHREAD #27 RUNNING>
000036 2013-06-20 15:50:50 <IOCP WORKTHREAD #28 RUNNING>
000037 2013-06-20 15:50:50 <IOCP WORKTHREAD #29 RUNNING>
000038 2013-06-20 15:50:50 <IOCP WORKTHREAD #30 RUNNING>
000039 2013-06-20 15:50:50 <IOCP WORKTHREAD #31 RUNNING>
000040 2013-06-20 15:50:50 <IOCP WORKTHREAD #32 RUNNING>
000041 2013-06-20 15:50:50 <IOCP WORKTHREAD #33 RUNNING>
000042 2013-06-20 15:50:50 <IOCP WORKTHREAD #34 RUNNING>
000043 2013-06-20 15:50:50 <IOCP WORKTHREAD #35 RUNNING>
000044 2013-06-20 15:50:50 <IOCP WORKTHREAD #36 RUNNING>
000045 2013-06-20 15:50:50 <IOCP WORKTHREAD #37 RUNNING>
000046 2013-06-20 15:50:50 <IOCP WORKTHREAD #38 RUNNING>
000047 2013-06-20 15:50:50 <IOCP WORKTHREAD #39 RUNNING>
000048 2013-06-20 15:50:50 <NUMBER OF 40 IOCP WORKTHREAD STARTED, 8 CPU DETECTED>
000049 2013-06-20 15:50:51 DB_Init FAILED = DSN=Statistics;UID=sa; PWD=0525
000050 2013-06-20 15:50:51 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000051 2013-06-20 15:50:51 < END OF MAIN = 0 >
000052 2013-06-20 15:50:51 <IOCP WORKTHREAD #9 FREE>
000054 2013-06-20 15:50:51 <IOCP WORKTHREAD #11 FREE>
000055 2013-06-20 15:50:51 <IOCP WORKTHREAD #30 FREE>
000056 2013-06-20 15:50:51 <IOCP WORKTHREAD #28 FREE>
000057 2013-06-20 15:50:51 <IOCP WORKTHREAD #27 FREE>
000060 2013-06-20 15:50:51 <IOCP WORKTHREAD #25 FREE>
000061 2013-06-20 15:50:51 <IOCP WORKTHREAD #29 FREE>
000058 2013-06-20 15:50:51 <IOCP WORKTHREAD #6 FREE>
000062 2013-06-20 15:50:51 <IOCP WORKTHREAD #4 FREE>
000059 2013-06-20 15:50:51 <IOCP WORKTHREAD #10 FREE>
000053 2013-06-20 15:50:51 <IOCP WORKTHREAD #12 FREE>
000063 2013-06-20 15:50:51 <IOCP WORKTHREAD #26 FREE>
000073 2013-06-20 15:50:51 <IOCP WORKTHREAD #7 FREE>

and this is the OBDC INFO in _CONF/config.txt

; NAME nDBID nWorldNoConnection INFO Startup Command
ODBC_INFO "Account", 0, 0, "DSN=Account; UID=sa; PWD=12345678", "USE Account; SET LOCK_TIMEOUT 5000"
ODBC_INFO "AccountLog", 1, 0, "DSN=AccountLog;UID=sa; PWD=12345678", "USE AccountLog; SET LOCK_TIMEOUT 5000"
ODBC_INFO "Statistics", 2, 0, "DSN=Statistics;UID=sa; PWD=12345678", "USE Statistics; SET LOCK_TIMEOUT 5000"
ODBC_INFO "OPTool", 3, 0, "DSN=OPTool; UID=sa; PWD=12345678", "USE OPTool; SET LOCK_TIMEOUT 5000"
ODBC_INFO "Character", 10, 0, "DSN=Character; UID=sa; PWD=12345678", "USE World00_Character; SET LOCK_TIMEOUT 5000"
ODBC_INFO "GameLog", 11, 0, "DSN=GameLog; UID=sa; PWD=12345678", "USE World00_GameLog; SET LOCK_TIMEOUT 5000"
 
Last edited:
☺☺Just Ask The Pope☺☺
Joined
Jul 19, 2009
Messages
585
Reaction score
93
Re: Server Files + Guide

looking in your log i can see this line

000049 2013-06-20 15:50:51 DB_Init FAILED = DSN=Statistics;UID=sa; PWD=0525

0525 as your password but your other password is

12345678"

try fixing that error check all ur db passwords match.
 
Initiate Mage
Joined
Jul 5, 2013
Messages
1
Reaction score
0
Re: Server Files + Guide

hey i need help plase 1 of my teleport dont work in rumen when i wanna go in ... and can who plase send me mobinfoserver.shn server files that my frends lvl more slow (they dont get so much XP of animals) plase conatct me ! or email miha-jelencek@hotmail.com
 
☺☺Just Ask The Pope☺☺
Joined
Jul 19, 2009
Messages
585
Reaction score
93
Re: Server Files + Guide

mobinfoserver will be of no use to you as u will need more files than just that..

check field.txt and make sure your gate is set right also correct in ur shn's

your friends should level the same as you do..
 
Initiate Mage
Joined
Jul 10, 2013
Messages
4
Reaction score
0
Re: Server Files + Guide

Setting up the database
Fiesta Database runs on MSSQL. I recommend SQL 2008 Express. Make sure you choose "Mixed Mode for easier setup.

Open "SQL Management Studio" login with the details you set while installing.
Right click Databases and choose restore database.
Enter the database name and choose "From File" otherwise it won't work. Browser to and choose a database .bak file.
Restore the following databases:
- Account
- OperatorTool
- AccountLog
- World00_Character
- StatisticsData
- World00_GameLog


Installing the ODBC Connectors
There are different ways for 64 bit computers then there are for 86 bit.

86bit Computer
Open ODBC Management the way you normally would.

64bit Computer
If your running on a 64 bit computer. Then open run and type in or browse to
"%SystemRoot%\sysWOW64\odbcad32.exe"

Go to the System-DSN tab. Click Add and select SQL Server.
Enter your SQL Server Name (Ex. Doodlebob\SQLEXPRESS)

Link the following DSNs to their database:
-Account
-AccountLog
-Character
-GameLog
-OPTool
-Statistics

Serverfiles Setup
Open your server files folder
Open "_CONF\config.txt".
Edit the ODBC info at the end of the file.
Also edit the IPs if your making it public.

The Exe's will make services of themselves. So just run them and wait for a notice box.
If your under Vista or Windows 7 then run as Administrator.
"Account\Account.exe",
"AccountLog\AccountLog.exe",
"Login\Login.exe",
"World00_Character\Character.exe",
"World00_GameLog\GameLog.exe",
"World00_WorldManager\WorldManager.exe",
"World00_Zone\Zone.exe",
"World00_Zone1\Zone.exe",
"World00_Zone2\Zone.exe",

They should all say 'Service Upload OK'.

Starting the Server
Go to your services manager.
Now, start all the services in the same order you installed them.
If the server doesn't run, check the log files for errors. (DebugMessage folder)

The Client
I recommend you use the Athens-Fiesta client.
You can start the client by right clicking Athens.exe and going to properties.
Add "-i 127.0.0.1" to the end of the target or replace it with your IP.

Downloads



Update:
Added a Registration Script.
Credits go to CSharp of KryptoDev for the registration script.


Having trouble getting the athens client. looking for help with the actual name of the client if it differs from the name athens cause i keep getting it as a pdf reader [h=4] [/h]
[h=4] [/h]
[h=4] [/h]
 
Initiate Mage
Joined
Jul 10, 2013
Messages
4
Reaction score
0
Re: Server Files + Guide

on the sql i keep getting an authentication error when i get to the configuration . how can i fix this?
 
Newbie Spellweaver
Joined
Feb 11, 2013
Messages
5
Reaction score
0
Re: Server Files + Guide

I can't start service : Account, AccountLog, character and gamelog.


000002 2013-08-16 23:13:55 Launching the server.....000003 2013-08-16 23:13:55 Local Time 8/16/2013 11:13:55 PM
000004 2013-08-16 23:13:55 System Time(UTC) 8/16/2013 4:13:55 PM
000005 2013-08-16 23:13:55 <SUCCESSED SCRIPTOR READ> config.txt
000006 2013-08-16 23:13:55 <I AM THE _Account DB Server, SERVER_ID_DB_ACCOUNT, WorldNo=0, ZoneNo=0>
000007 2013-08-16 23:13:55 Service start(no parameter)
000008 2013-08-16 23:13:55 <IOCP WORKTHREAD #0 RUNNING>
000009 2013-08-16 23:13:55 <IOCP WORKTHREAD #1 RUNNING>
000010 2013-08-16 23:13:55 <IOCP WORKTHREAD #2 RUNNING>
000011 2013-08-16 23:13:55 <IOCP WORKTHREAD #3 RUNNING>
000012 2013-08-16 23:13:55 <IOCP WORKTHREAD #4 RUNNING>
000013 2013-08-16 23:13:55 <IOCP WORKTHREAD #5 RUNNING>
000014 2013-08-16 23:13:55 <IOCP WORKTHREAD #6 RUNNING>
000015 2013-08-16 23:13:55 <IOCP WORKTHREAD #7 RUNNING>
000016 2013-08-16 23:13:55 <IOCP WORKTHREAD #8 RUNNING>
000017 2013-08-16 23:13:55 <IOCP WORKTHREAD #9 RUNNING>
000018 2013-08-16 23:13:55 <IOCP WORKTHREAD #10 RUNNING>
000019 2013-08-16 23:13:56 <IOCP WORKTHREAD #11 RUNNING>
000020 2013-08-16 23:13:56 <IOCP WORKTHREAD #12 RUNNING>
000021 2013-08-16 23:13:56 <IOCP WORKTHREAD #13 RUNNING>
000022 2013-08-16 23:13:56 <IOCP WORKTHREAD #14 RUNNING>
000023 2013-08-16 23:13:56 <IOCP WORKTHREAD #15 RUNNING>
000024 2013-08-16 23:13:56 <IOCP WORKTHREAD #16 RUNNING>
000025 2013-08-16 23:13:56 <IOCP WORKTHREAD #17 RUNNING>
000026 2013-08-16 23:13:56 <IOCP WORKTHREAD #18 RUNNING>
000027 2013-08-16 23:13:56 <IOCP WORKTHREAD #19 RUNNING>
000028 2013-08-16 23:13:56 <NUMBER OF 20 IOCP WORKTHREAD STARTED, 4 CPU DETECTED>
000029 2013-08-16 23:13:56 DB_Init FAILED = DSN=Account; UID=sa; PWD=123456789
000030 2013-08-16 23:13:56 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000031 2013-08-16 23:13:56 < END OF MAIN = 0 >
000032 2013-08-16 23:13:56 <IOCP WORKTHREAD #0 FREE>
000033 2013-08-16 23:13:56 <IOCP WORKTHREAD #19 FREE>
000034 2013-08-16 23:13:56 <IOCP WORKTHREAD #17 FREE>
000035 2013-08-16 23:13:56 <IOCP WORKTHREAD #18 FREE>
000036 2013-08-16 23:13:56 <IOCP WORKTHREAD #16 FREE>
000038 2013-08-16 23:13:56 <IOCP WORKTHREAD #14 FREE>
000037 2013-08-16 23:13:56 <IOCP WORKTHREAD #15 FREE>
000039 2013-08-16 23:13:56 <IOCP WORKTHREAD #13 FREE>
000040 2013-08-16 23:13:56 <IOCP WORKTHREAD #12 FREE>
000041 2013-08-16 23:13:56 <IOCP WORKTHREAD #11 FREE>
000042 2013-08-16 23:13:56 <IOCP WORKTHREAD #10 FREE>
000043 2013-08-16 23:13:56 <IOCP WORKTHREAD #8 FREE>
000044 2013-08-16 23:13:56 <IOCP WORKTHREAD #7 FREE>
000045 2013-08-16 23:13:56 <IOCP WORKTHREAD #6 FREE>
000046 2013-08-16 23:13:56 <IOCP WORKTHREAD #9 FREE>
000047 2013-08-16 23:13:56 <IOCP WORKTHREAD #4 FREE>
000048 2013-08-16 23:13:56 <IOCP WORKTHREAD #5 FREE>

config.txt

; NAME nDBID nWorldNoConnection INFO Startup CommandODBC_INFO "Account", 0, 0, "DSN=Account; UID=sa; PWD=123456789", "USE Account; SET LOCK_TIMEOUT 5000"
ODBC_INFO "AccountLog", 1, 0, "DSN=AccountLog;UID=sa; PWD=123456789", "USE AccountLog; SET LOCK_TIMEOUT 5000"
ODBC_INFO "Statistics", 2, 0, "DSN=Statistics;UID=sa; PWD=123456789", "USE StatisticsData; SET LOCK_TIMEOUT 5000"
ODBC_INFO "OPTool", 3, 0, "DSN=OPTool; UID=sa; PWD=123456789", "USE OperatorTool; SET LOCK_TIMEOUT 5000"
ODBC_INFO "Character", 10, 0, "DSN=Character; UID=sa; PWD=123456789", "USE World00_Character; SET LOCK_TIMEOUT 5000"
ODBC_INFO "GameLog", 11, 0, "DSN=GameLog; UID=sa; PWD=123456789", "USE World00_GameLog; SET LOCK_TIMEOUT 5000"


#END

help me Please!!!
 
Newbie Spellweaver
Joined
Feb 11, 2013
Messages
5
Reaction score
0
Re: Server Files + Guide

i made ODBC connection, but i can't start services. My password of user sa is "123456789".
although I have follow the guidelines
 
Newbie Spellweaver
Joined
Feb 11, 2013
Messages
5
Reaction score
0
Re: Server Files + Guide

And you used the correct Odbcad32.exe? If you've got 64bit then you've gotta use the one that's in SysWOW64, not system32.[SUP]​[/SUP]

Thank you very much!!!
i have a problem: "server is full ". How to fix ?
 
Last edited:
Status
Not open for further replies.
Back
Top