[NA - 2008] Server Files & Guide

[Supicioso]

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

You must be registered to see links

You must be registered to see links

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

 

[Organic]

Re: Server Files + Guide

Yay, time to set these up.

 

[wellmonster]

Re: Server Files + Guide

How can I add more accounts to the server? i'm assuming someware in the Accounts db? thx.

 

[terzo]

Re: Server Files + Guide

Try that,

INSERT INTO tUser (sUserID, sUserPW, sUserName) VALUES ('user', 'passwd', 'user')

 

[Supicioso]

Re: Server Files + Guide

Added a reg script.

 

[wellmonster]

Re: Server Files + Guide

verry nice guide btw JaredT

 

[Kerelmans]

Re: Server Files + Guide

Thanks for leaking my guide (;
and giving me credits for... registration script?
LOL'd

 

[exclamatio]

Re: Server Files + Guide

Thanks for leaking my guide (;
and giving me credits for... registration script?
LOL'd

can you prove this is yours?

 

[Trimatic]

Re: Server Files + Guide

He's CSharp from KryptoDev, he coded the emulator.

 

[Kerelmans]

Re: Server Files + Guide

can you prove this is yours?

On your demand:

You must be registered to see links

 

[jM2.me]

Re: Server Files + Guide

Umm don't forget credits to me since server files repack is mine

 

[Supicioso]

Re: Server Files + Guide

Thanks for leaking my guide (;
and giving me credits for... registration script?
LOL'd

There's no such thing as "leaking" a guide, I wrote my own. wth are you talking about?

and no this is not your repack. The links in that thread didn't even work when I tried them, and I doubt they do now.

 

[Trimatic]

Re: Server Files + Guide

They still don't work.

 

[Makloud]

Re: Server Files + Guide

When I clicked it to start the services of this error message, what can it be?

 

[Supicioso]

Re: Server Files + Guide

Did you try the stuff posted above?

 

[Makloud]

Re: Server Files + Guide

Yes exactly posted above.

 

[terzo]

Re: Server Files + Guide

Please post your logs and i will try to help you;

 

[Makloud]

Re: Server Files + Guide

Looking at the error logs I found this:

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

I wonder what went wrong in ODBC?

 

[jM2.me]

Re: Server Files + Guide

Jezus crist it wuld be better for me not to remind exclaminto about fiesta section.

P.S. I know it has nothing to do with it but, come on, seriously?

@JaredT:
Yes it is my server files repack and my databse repack so stfu.
This repack was made by me for Athens Fiesta and was used by Athens Fiesta.
Then released by cSharp and afterwards released by me on ragezone.

If you think they dont work then you might be a noob.

Edit:
Hahahah even when you restore databses it says DAN-PC which is name of my computer.

Reporting...

Edit 2:
Now I know whos owner of xeno fiesta

 

[Makloud]

Re: Server Files + Guide

I've checked where I was wrong, and sorry for posting in wrong place