How to setup a Flyff Private server*Updated to v14*

Flyff (Fly For Fun) Discuss, How to setup a Flyff Private server*Updated to v14* at Games Discussion and Hacks #1 forum; I updated this guide because it was needed. Setting up Microsoft SQL 2005 1. Download Microsoft Server SQL 2005 a) ...


Go Back   Gamerz Needs - For All Your Gaming Needs! > Games Discussion and Hacks #1 > Flyff (Fly For Fun)
Forgot Password? | Sign Up!



Reply
 
Bookmark this Thread Tools Display Modes
  #1  
Old 02-11-2010, 10:25 AM
xAkuma's Avatar
Freaky
is Flyff *-*
 
I am: Yeehaw
 
Last Online: 11-16-2013 05:46 AM
Join Date: Aug 2009
Posts: 216
Post Thanks / Like
Thanks (Given): 48
Thanks (Received): 114
Likes (Given): 8
Likes (Received): 11
Send a message via ICQ to xAkuma
How to setup a Flyff Private server*Updated to v14*

I updated this guide because it was needed.


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 uthentication 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.: AllInOne.rar
--Remember This DB is for v14 only.
b) Now run SQL Server 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: http://blahggins.com/Downloads/Server%20Files.rar
a. Extract them to a place where you can access them.
b. Go to the Script Folder, open Databaseserver.ini.
c. Where it says Resour***older "CHANGE THIS TO YOUR RESOURCE FOLDER PATH"
d. Change it to the path where the Resource folder is located. For Me it's Code:
Resour***older "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 Computer 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.)
xAkuma- Original poster of this guide
----If I forgot anyone just let me know.----

Last edited by xAkuma; 02-11-2010 at 10:29 AM. Reason: Forget Something!
Reply With Quote
  #2  
Old 02-11-2010, 03:29 PM
Wood Axe
This user has no status.
 
----
 
Last Online: 09-03-2011 03:28 PM
Join Date: Nov 2007
Posts: 6
Post Thanks / Like
Thanks (Given): 14
Thanks (Received): 0
Likes (Given): 0
Likes (Received): 0
very good tutorial, but can u post any hacks for flyff private server
Reply With Quote
  #3  
Old 02-11-2010, 05:49 PM
Chick
This user has no status.
 
----
 
Last Online: 02-17-2010 06:17 PM
Join Date: Jan 2010
Posts: 3
Post Thanks / Like
Thanks (Given): 0
Thanks (Received): 0
Likes (Given): 0
Likes (Received): 0
Question i can't see any server in the server list

sir, why i can't see any server in the server list when i log in into my server... can u help me make how to insert server in the server list.
Reply With Quote
  #4  
Old 02-12-2010, 09:47 AM
xAkuma's Avatar
Freaky
is Flyff *-*
 
I am: Yeehaw
 
Last Online: 11-16-2013 05:46 AM
Join Date: Aug 2009
Posts: 216
Post Thanks / Like
Thanks (Given): 48
Thanks (Received): 114
Likes (Given): 8
Likes (Received): 11
Send a message via ICQ to xAkuma
Quote:
Originally Posted by exeakatz View Post
sir, why i can't see any server in the server list when i log in into my server... can u help me make how to insert server in the server list.
Maybe you make something wrong at you login_server.ini ... But i am not shure.

~xAkuma


Reply With Quote
  #5  
Old 02-12-2010, 07:25 PM
Chick
This user has no status.
 
----
 
Last Online: 02-17-2010 06:17 PM
Join Date: Jan 2010
Posts: 3
Post Thanks / Like
Thanks (Given): 0
Thanks (Received): 0
Likes (Given): 0
Likes (Received): 0
.....

can u post it here the code of the login_server.ini ,,,, and when i create another account it says wrong password when i log in it.. i use kikugalanet md5 generator for my password... and i try also the other one but its the same problem.
tnx...

Last edited by exeakatz; 02-13-2010 at 04:18 AM.
Reply With Quote
  #6  
Old 02-13-2010, 01:09 AM
xAkuma's Avatar
Freaky
is Flyff *-*
 
I am: Yeehaw
 
Last Online: 11-16-2013 05:46 AM
Join Date: Aug 2009
Posts: 216
Post Thanks / Like
Thanks (Given): 48
Thanks (Received): 114
Likes (Given): 8
Likes (Received): 11
Send a message via ICQ to xAkuma
Quote:
Originally Posted by exeakatz View Post
can u post it here the code of the login_server.ini
tnx...
This is the code for login_server.ini:
Code:
[server] 
ip = 127.0.0.1 
port = 23000 
minAccessLevel = 0 
id = 1 
name = Login Server  Your Name For Login Server
use_flyff_a = 1 
 
[isc] 
ip = 127.0.0.1 
port = 29,300 
 
[mysql]  Add here your MySQL files
server = localhost 
database = flyff    
username = root   
password = 1234
I hope your server will work now...

~xAkuma
________________
Reply With Quote
  #7  
Old 02-13-2010, 04:24 AM
Chick
This user has no status.
 
----
 
Last Online: 02-17-2010 06:17 PM
Join Date: Jan 2010
Posts: 3
Post Thanks / Like
Thanks (Given): 0
Thanks (Received): 0
Likes (Given): 0
Likes (Received): 0
still i cant see any server... sorry sir..... and login_server.ini does not exist in the server files.

Last edited by exeakatz; 02-13-2010 at 08:22 PM.
Reply With Quote
  #8  
Old 02-14-2010, 05:42 AM
Chick
This user has no status.
 
----
 
Last Online: 02-14-2010 05:42 AM
Join Date: Feb 2010
Posts: 1
Post Thanks / Like
Thanks (Given): 0
Thanks (Received): 0
Likes (Given): 0
Likes (Received): 0
help

my v14 data base for sql studio express when i execute the file it wont let all the db's you mentioned through it says its not there or i dont have permission so pls help me im dessperete:cra p:
Reply With Quote
  #9  
Old 02-14-2010, 09:11 PM
Chick
This user has no status.
 
----
 
Last Online: 02-14-2010 09:11 PM
Join Date: Sep 2008
Posts: 1
Post Thanks / Like
Thanks (Given): 0
Thanks (Received): 0
Likes (Given): 0
Likes (Received): 0
course he cant help you he didnt even write this guide originally it was written at ragezone and just like so many leeches he just copyed and pasted it ffs you left all the credits and changed the creator name example GlaphanKing - For compiling the server file thread and keeping our wonderful FlyFF section going. ya WRONG forums bud...lol
if u need help try there

---------- Post added at 10:11 PM ---------- Previous post was at 10:06 PM ----------

no ones saying your a theif for using others work no no but when u say its yours.....well thats when it becomes plagiarism and thats just bs

Last edited by wisp66; 02-14-2010 at 09:10 PM.
Reply With Quote
  #10  
Old 02-14-2010, 11:54 PM
xAkuma's Avatar
Freaky
is Flyff *-*
 
I am: Yeehaw
 
Last Online: 11-16-2013 05:46 AM
Join Date: Aug 2009
Posts: 216
Post Thanks / Like
Thanks (Given): 48
Thanks (Received): 114
Likes (Given): 8
Likes (Received): 11
Send a message via ICQ to xAkuma
Quote:
Originally Posted by wisp66 View Post
course he cant help you he didnt even write this guide originally it was written at ragezone and just like so many leeches he just copyed and pasted it ffs you left all the credits and changed the creator name example GlaphanKing - For compiling the server file thread and keeping our wonderful FlyFF section going. ya WRONG forums bud...lol
if u need help try there

---------- Post added at 10:11 PM ---------- Previous post was at 10:06 PM ----------

no ones saying your a theif for using others work no no but when u say its yours.....well thats when it becomes plagiarism and thats just bs

Well, I didn't copy any Thread. This post was writing by ME and when you find the same Text in an other Forum:
I have an account at other Forums too. And I write this Text in the Forum.

Maybe you see a thread by at an other Forum.

xAkuma

Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -8. The time now is 12:17 AM.