v15 In-Depth Setup Guide /w Support

[Intelligence]

@thefore1990 - yeah, that's what I am gonna do it as well mate. hope someone will help you for upgrading it :) or someone will share 'how to switch it to v17/18/etc'

[pepitogwapo]

i was able to start the game and everything went smoothly with this guide, my only problem is when i add cash points in account.tbl mssql, it doesn't appear in-game so i'm not able to buy from the cash shop.

what i do is go to dbo.account.tbl then edit top 200 rows, change the cash on my account. nothing happens when i do this.

thanks in advance for the help.

[RivRawr]

@thefore1990 - yeah, that's what I am gonna do it as well mate. hope someone will help you for upgrading it :) or someone will share 'how to switch it to v17/18/etc'

Yea, im new to this but i figured if i were to draw some players to my private server when it's up v18 would do it. aha If i hear of the links anywhere ill be sure to tell you, im always on the look.

[sheercold33]

Now its ODBC time, open up run.exe and type in odbcad32.exe
and hit run.

Nevermind. Found it...
If you're running a Vista/W7 OS and have issues on this, go to your search and type in ODBC
It should instantly come up.
Everything else has been going smoothly, so I'd like to take the time to thank you for taking your time to post this guide.

Edit:
Also, just had a little trouble finding the scripts for creating the account, so here they are:


Navigate to Databases\ACCOUNT_DBF
Click New Query in the upper left corner and run this script as is:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[createaccount]
@account VARCHAR(15),
@password VARCHAR(32)

AS

SET NOCOUNT ON

DECLARE @DateActivated AS CHAR(8)

IF NOT EXISTS (SELECT account FROM ACCOUNT_TBL WHERE account = @account) BEGIN
INSERT INTO ACCOUNT_TBL (account, [password], id_no2, isuse, member, realname)
VALUES (@account, @password, @password, 'T', 'A', 'F')

SET @DateActivated = CONVERT(CHAR(8), GETDATE()-1, 112 ) --Is the date today - 1
--UPDATE ACCOUNT_TBL_DETAIL SET BlockTime = @DateYesterday WHERE account = @userid
--INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
-- VALUES (@account, 'A000', '2', 'F', GETDATE(), '20990101', '20990101', '20050101', 'O')

INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
VALUES (@account, 'A000', '2', 'F', GETDATE(), @DateActivated, '20990101', '20050101', 'O')

END

Click Execute. Close and restart.
Open MSSSQL again and do the same as before except copy + paste this script
DO NOT execute it yet!

USE [ACCOUNT_DBF]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[createaccount]
@account = N'user',
@password = N'pass in md5(serus+pass)'

SELECT 'Return Value' = @return_value

GO

Where 'user' is, put in your username you would like to create
Where 'pass' is, type in the md5hash gen: serus+Your password here

so an example like in the tutorial would be:

serusadmin

serus is the Salt, it is REQUIRED in the hash.
admin is your password. So when you log in, all you need to type for your password is admin or whatever you entered. You do NOT need to type serus.

Clears things up? I guess so. I'm new to this and the tutorial was already understandable.

[brent2421]

can i ask something where is the serverfiles?sory im newbie

[Stigmatized]

Hello everyone, i have started to create a p.server and i have finished some steps and now my problem is this,

http://i837.photobucket.com/albums/z...12/problem.png

I already run it as administrator but still it wont work please help me

[brent2421]

Hello everyone, i have started to create a p.server and i have finished some steps and now my problem is this,

http://i837.photobucket.com/albums/z...12/problem.png

I already run it as administrator but still it wont work please help me

try to restore your databases

[Stigmatized]

try to restore your databases

What do you mean try to restore your database?

you mean at the MSQL? i will restore again?

I already restored these at first:

Spoiler:

ACCOUNT_DBF
CHARACTER_01_DBF
EoCRM_DBF
EoCRM_DBF_R
ITEM_DBF
LOGGING_01_DBF
MANAGE_DBF
RANKING_DBF

What else will i restore?

please help

[Mic]

all links are dead , any new link ??? thanks

[Cuvvvie]

all links are dead , any new link ??? thanks

You don't need any of the links. Use the official source to compile your own exes, and then use the official v15 client. This guide is fine to follow for setting it up, but don't use these files.

Here are the databases/resource folder if you need them:
v15 (no client).7z
Password: 1f2bf7ac9a4bd69d1af5bd1eb6b4be0f
Those are all the files you need, and I can guarantee you that they work for clean v15. If they don't, you're messing something up.

And client dl link
Flyff Fly For Fun | Files | Flyff US Client v15 | Clients | Game Front
http://88.191.118.113/Flyff/FlyffUsaSetup_v15.exe

And remember to use the bulk res extractor located here to place & extract data.res, dataSub1.res, dataSub2.res, and the Model/World folders of the client into the Resource folder.

[Mic]

In final step , when i opened NeuzUnique.exe then my computer auto restart ?????
i'm bad in English ="=

[raventh1984]

hmm never heard of that.

Well unless it gives you an BSOD to check if you will have an BSOD check this if you have windows 7

Prevent Windows 7 From Automatic Restart After System Failure

If you have done that then fire up the neuz. If it crashes then you will see an BSOD.

BSOD = Blue Screen Of Death

[Mic]

None , i'm using windows xp
after restart , my computer is using normal
____
Yes , it crashes , what i should i do now ?

[Cuvvvie]

None , i'm using windows xp
after restart , my computer is using normal
____
Yes , it crashes , what i should i do now ?

Compile your own server/neuz.

[Mic]

profile_20130330.txt

2013/03/30	03:06:07
Root
---> 100.00%  CRunObject::Run(),  <22439.371 ms>,  <20 calls>,  <1121.968555 ms/call>
  |---> 100.00%  g_DPCoreClient.ReceiveMessage(),  <22439.342 ms>,  <1 calls>,  <22439.342499 ms/call>
  |  |---> 0.54%  CDPCoreClient::UserMessageHandler(0x00001000),  <122.083 ms>,  <1 calls>,  <122.083463 ms/call>
  |  |---> 99.46%  CDPCoreClient::UserMessageHandler(0x00000003),  <22317.120 ms>,  <1 calls>,  <22317.119598 ms/call>
  |  |---> 0.00%  CDPCoreClient::UserMessageHandler(0x00000004),  <0.084 ms>,  <1 calls>,  <0.084278 ms/call>
  |  |---> 0.00%  CDPCoreClient::UserMessageHandler(0x0000000b),  <0.005 ms>,  <1 calls>,  <0.004930 ms/call>
  |---> 0.00%  g_DPSrvr.ReceiveMessage(),  <0.009 ms>,  <1 calls>,  <0.009060 ms/call>
  |---> 0.00%  CWorldMng::Process(),  <0.000 ms>,  <0 calls>,  <0.000000 ms/call>


2013/03/30	03:06:35
Root
---> 100.00%  CRunObject::Run(),  <27613.567 ms>,  <2 calls>,  <13806.783676 ms/call>
  |---> 0.70%  1SEC_Process,  <193.205 ms>,  <2 calls>,  <96.602559 ms/call>
  |  |---> 0.00%  CPCBang::ProcessPCBang(),  <0.002 ms>,  <2 calls>,  <0.000903 ms/call>
  |---> 97.59%  g_WorldMng.Respawn(),  <26949.053 ms>,  <2 calls>,  <13474.526405 ms/call>
  |---> 1.60%  g_dpDBClient.ReceiveMessage(),  <441.740 ms>,  <2 calls>,  <220.870152 ms/call>
  |  |---> 0.00%  CDPDatabaseClient::UserMessageHandler(0xffffff3c),  <0.000 ms>,  <1 calls>,  <0.000455 ms/call>
  |  |---> 0.00%  CDPDatabaseClient::UserMessageHandler(0xf000f712),  <0.001 ms>,  <1 calls>,  <0.000590 ms/call>
  |  |---> 0.00%  CDPDatabaseClient::UserMessageHandler(0xf000d021),  <1.340 ms>,  <1 calls>,  <1.340288 ms/call>
  |  |---> 0.03%  CDPDatabaseClient::UserMessageHandler(0x0000001e),  <8.647 ms>,  <1 calls>,  <8.647152 ms/call>
  |  |---> 0.00%  CDPDatabaseClient::UserMessageHandler(0x70000111),  <0.008 ms>,  <1 calls>,  <0.007550 ms/call>
  |  |---> 0.03%  CDPDatabaseClient::UserMessageHandler(0x70001000),  <8.603 ms>,  <1 calls>,  <8.603338 ms/call>
  |  |---> 0.00%  CDPDatabaseClient::UserMessageHandler(0xf000f803),  <0.010 ms>,  <1 calls>,  <0.009875 ms/call>
  |  |---> 0.00%  CDPDatabaseClient::UserMessageHandler(0x70006010),  <0.556 ms>,  <1 calls>,  <0.556129 ms/call>
  |  |---> 0.00%  CDPDatabaseClient::UserMessageHandler(0x8ffff004),  <0.001 ms>,  <1 calls>,  <0.001455 ms/call>
  |  |---> 0.00%  CDPDatabaseClient::UserMessageHandler(0xf000f005),  <0.052 ms>,  <1 calls>,  <0.051969 ms/call>
  |  |---> 0.00%  CDPDatabaseClient::UserMessageHandler(0xf000d005),  <0.002 ms>,  <1 calls>,  <0.001510 ms/call>
  |  |---> 0.00%  CDPDatabaseClient::UserMessageHandler(0xf000d004),  <0.001 ms>,  <1 calls>,  <0.001425 ms/call>
  |  |---> 1.52%  CDPDatabaseClient::UserMessageHandler(0xf000d003),  <420.629 ms>,  <1 calls>,  <420.628965 ms/call>
  |  |---> 0.01%  CDPDatabaseClient::UserMessageHandler(0x8fff0007),  <1.812 ms>,  <1 calls>,  <1.812189 ms/call>
  |---> 0.00%  g_DPCoreClient.ReceiveMessage(),  <0.100 ms>,  <2 calls>,  <0.049924 ms/call>
  |  |---> 0.00%  CDPCoreClient::UserMessageHandler(0xf000d026),  <0.007 ms>,  <1 calls>,  <0.006685 ms/call>
  |  |---> 0.00%  CDPCoreClient::UserMessageHandler(0x00001000),  <0.000 ms>,  <0 calls>,  <0.000000 ms/call>
  |  |---> 0.00%  CDPCoreClient::UserMessageHandler(0x00000003),  <0.000 ms>,  <0 calls>,  <0.000000 ms/call>
  |  |---> 0.00%  CDPCoreClient::UserMessageHandler(0x00000004),  <0.083 ms>,  <1 calls>,  <0.082618 ms/call>
  |  |---> 0.00%  CDPCoreClient::UserMessageHandler(0x0000000b),  <0.000 ms>,  <0 calls>,  <0.000000 ms/call>
  |---> 0.00%  g_DPSrvr.ReceiveMessage(),  <0.002 ms>,  <2 calls>,  <0.000783 ms/call>
  |---> 0.10%  CWorldMng::Process(),  <26.724 ms>,  <2 calls>,  <13.361756 ms/call>
  |  |---> 0.00%  CMover::Process(),  <0.008 ms>,  <232 calls>,  <0.000033 ms/call>

error_20130330.txt

2013/ 3/30   03:05:44   OP: 1545498, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2013/ 3/30   03:06:07   OP: 22439, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0


2013/ 3/30   03:06:35   OP: 27114, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0