Setting up Microsoft SQL 2005
1. Download Microsoft Server SQL 2005
a) Run it, 'Accept Terms and Conditions' On the Next Page click 'Install'
b) It'll then install files you need to install the server.
c) Click Next.
d) It will then check your 'computers configuration' And then run a check.
e) If there's no ERRORS (Warnings are okay) then click Next.
f) Fill in your Name 'Company Isn't needed I set it to Home though.'
---REMEMBER TO UNCHECK 'Hide advanced configuration options'---
g) Click on Database Services and do 'Entire Feature Will be installed on Local HD'
h) Do the same for Client Components. (There should be no Red X Marks on anything)
i) Use 'Named Instance' And name it SQLExpress
j) Leave everything the same on the Next Page. (Just Click Next.)
Use the built-in System Account: Network Service
Start Services at the end of Startup (Make sure only SQL Server is checked.)
k) On the Authentication Mode Page, Check mark the 'Mixed Mode (Windows Authentication and SQL Server Authentication.)'
l) Enter a password, one you'll remember OR just use root. (After this you can just hit next through everything, No other changes are needed.)
m) On the Collation Settings Page, Just hit next.
n) In the Configuration Options, Just Hit Next Again.
o) Let it Install, Then Click Next, and then Finish, and you're all done with MsSQL 2005.
Setting up the Data Base
1. You'll need to have Installed Microsoft Server SQL Already.
a) Download the All In One V14 Database.:
http://www.********e.com/?3yvdyjbmdrj
--Remember This DB is for v14 only.
b) Now run SQL Server Management Studio Express (Use the Search function or Windows key+R (Brings up the 'Run' Box.) And type in ssmsee
c) Login to the server, Use Windows Authentication.
d) Then Go to File, Open-File.
e) Open the AllInOne DB you downloaded before.
f) You'll then need to 'Execute' The DB. There's a button on the bar above where all the text is. Also you can Right Click the Text in the middle and click Execute (This is what I prefer)
g) There might be some errors Execute the script TWICE
h) You should then be able to click on 'Databases' Click the Refresh button, and see all the databases, you should see ACCOUNT_DBF, CHARACTER_01_DBF, ITEM_DBF, LOG_01_DBF, LOGGING_01_DBF, and RANKING_DBF
i) If you see all these, move onto the next step.
ODBC Connection Guide:
Please Remember, these settings will not work correctly in all circumstances, or on all Operating systems.
Well open the ODBC panel, by going to start the search bar type in 'ODBC' Open it.
OR Goto 'run' type in odbcad32 and click enter. (Run or windows key + R)
You'll have to add three things here.
1.character01
2.login
3.log01
1. character01
A) Click 'Add' on the 'User DSN' Tab.
B) Select SQL Native Client and click Finish.
C) Name: character01
D) Description: Leave blank.
E) Server:-your MsSQL Server name.- For Example Mines: "ANDREW-PC\SQLEXPRESS"
F) Then click 'Next'. Use 'With Integrated Windows authentication'.
G) And also make sure Connect to SQL Server to obtain..... Then click Next.
H) Make sure Change the default database to: CHARACTER_01_DBF
I) Click next, and then finish.
2. login
A) Click 'Add' on the 'User DSN' Tab.
B) Select SQL Native Client and click Finish.
C) Name: login
D) Description: Leave blank.
E) Server:-your MsSQL Server name.- For Example Mines: "ANDREW-PC\SQLEXPRESS"
F) Then click 'Next'. Use 'With Integrated Windows authentication'.
G) And also make sure Connect to SQL Server to obtain..... Then click Next.
H) Make sure Change the default database to: ACCOUNT_DBF
I) Click next, and then finish.
3. log01
A) Click 'Add' on the 'User DSN' Tab.
B) Select SQL Native Client and click Finish.
C) Name: log01
D) Description: Leave blank.
E) Server:-your MsSQL Server name.- For Example Mines: "ANDREW-PC\SQLEXPRESS"
F) Then click 'Next'. Use 'With Integrated Windows authentication'.
G) And also make sure Connect to SQL Server to obtain..... Then click Next.
H) Make sure Change the default database to: LOG_01_DBF
I) Click next, and then finish
Setting up the Server Files
This guide is mainly for v14 That's what this section will be for.
1. You'll need to Download the Server Files V14 Server Files here:
blahggins.com
a. Extract them to a place where you can access them.
b. Go to the Script Folder, open Databaseserver.ini.
c. Where it says ResourceFolder "CHANGE THIS TO YOUR RESOURCE FOLDER PATH"
d. Change it to the path where the Resource folder is located. For Me it's Code:
ResourceFolder "C:\Users\Andrew\Desktop\Server Files\Resource"
e. You'll also need to do this for WorldServer.ini. Then you're done setting the files up. I like to make shortcuts and put them in the server files to make it easier to start the server. Run the Programs in this order.
Code:
1. AccountServer
2. DatabaseServer
3. CoreServer
4. Certifier
5. LoginServer
6. CacheServer
7. WorldServer
f. You'll be the only one able to connect to the server right now i'll add a guide on how to let others connect later.
Creating an Account (v14 and v11)
Open SQL Server Management Studio Express, go to your ACCOUNT_DBF.
You'll see Programmability. Then 'Stored Procedures'. Then right click dbo.createaccount. 'Execute Stored Procedure.'
You'll See
@account row
@password row
@account row under the Value is the account name 'make it lowercase'
@password value is the password -REMEMBER THAT THIS NEEDS TO BE Salt+Password (AS MD5 HASH)
Default Salts:
v11: nForceisGay
v14: kikugalanet
So if you want your password to be apples. you'll have to do
nForceisGayapples (For v11)
and kikugalanetapples (For v14)
Text to MD5 Hash
v11 md5 hash for apples: d386d27157bcb483427d488b47c5cd47
v14 md5 hash for appples: ab57eb732e27dff2a6f212699ea8888c
How to Let Others Connect to Your Server
Server File Settings
1. Fixing the Server Files to allow others to connect.
a. You'll need to go in to your Program Folder.
b. Open AccountServer.ini You'll need to change the IP in BOTH to your IP address. (To find your IP Address Go to WhatIsMyIp.com)
Code:
AddTail( -1, 1, "Test", "127.0.0.1", 0, 1, 0 );
AddTail( 1, 1, "Chan 1", "127.0.0.1", 1, 1, 600 );
To
Code:
AddTail( -1, 1, "Test", "YOUR IP ADDRESS", 0, 1, 0 );
AddTail( 1, 1, "Chan 1", "YOUR IP ADDRESS", 1, 1, 600 );
c. After that Save and Close.
d. Now Open loginserver.ini
e. THE ONLY IP YOU HAVE TO CHANGE IS AddCache( "127.0.0.1" );
Change it to your IP AddCache( "YOUR IP HERE" );
f. You're all done changing the server files, Next if your behind a router you'll need to forward ports.
Please Remember When you Run the AccountServer You'll need to Set it to Allow External Connections
g. To Do this, open AccountServer.exe In 'Tool(T)' Just make sure its Checked to Allow (Check this everytime you restart the server.)
Forwarding Ports
The Ports you Need to Forward are.
World 15400
Char 23000
Login 28000
----THE NEXT PART IS FOR LINKSYS----
If you don't have linksys, Google how to forward ports for your router. and forward the ports above.
1. Go to your Browser and type in 192.168.1.1
a. It should bring up a login menu (If you know the Username and Password Enter it.)
b. If not check Linksys Default Users and Passwords
Code:
Default user names:
* Linksys BEFW11S4, WRT54G: admin
* Linksys EtherFast Cable/DSL Ethernet routers: Administrator
* Linksys Comcast routers: comcast
* All other Linksys routers: [none]
Default passwords:
* Linksys BEFW11S4: [none]
* Linksys Comcast routers: 1234
* All other Linksys routers: admin
c. Then go to the tab Applications & Gaming.
d. You should see a table named 'Port Range'
e. The World port Settings will be.
Application: World
Start: 15400
End: 15400
Protocol: Both
IP Address: Your Computers Local IP.
Enable: Make Sure its checked.
f.
Application: Char
Start: 23000
End: 23000
Protocol: Both
IP Address: Your Computers Local IP.
Enable: Make Sure its checked.
g.
Application: Login
Start: 28000
End: 28000
Protocol: Both
IP Address: Your Computers Local IP.
Enable: Make Sure its checked.
h. Save Settings.
I. To find your computers local ip Run CMD, WindowsKey+R Type in CMD then type in /ipconfig, You should see IPv4 Address..........(This ip is Your computers IP).
Credits:
exos58 - FlyFF ResEditor
Microsoft - Excel + Word.
pipelli - O3d Converter
AMD - The Compressonator
Kimmy Andersson - DYO Manager
GalaNet - FlyFF
GlaphanKing - For compiling the server file thread and keeping our wonderful FlyFF section going.
AllinOne DB - Don't know the name (If someone finds the original poster let me know.)
ServerFiles - ????? (Don't know the name for these files.)
aldieri - Original poster of this guide