I don't like to disturb members of a forum (you are guys very helped many people), but now I couldn't find the solution of the problem.
When I choose the character there is a MassageBox: "Cannot connect to the game. Please Check the network."
1. I use all files from:
3. Problem with "ranking dbo" in worldserver I solved with
Quote:
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [53].
Code:
USE [master] GO EXEC master.dbo.sp_addlinkedserver @server = N'RANKING', @srvproduct=N'RANKING', @provider=N'SQLNCLI', @datasrc=N'**SERVER NAME**' GO EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'collation compatible', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'data access', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'rpc', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'rpc out', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'connect timeout', @optvalue=N'30' GO EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'collation name', @optvalue=null GO EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'query timeout', @optvalue=N'45' GO EXEC master.dbo.sp_serveroption @server=N'RANKING', @optname=N'use remote collation', @optvalue=N'true' GO USE [master] GO EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'RANKING', @locallogin = N'sa', @useself = N'False', @rmtuser = N'sa', @rmtpassword = N'**PASSWORD**' GO USE [master] GO EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'RANKING', @locallogin = NULL , @useself = N'False', @rmtuser = N'sa', @rmtpassword = N'**PASSWORD**' GO
6. I want test the server on localhost)
7. All ports aren't blocked by a firewall. the server and neuz are started with the rights of the administrator
8. In ODBC working Windows Authentication mode.
Details:
ini's:
AccountServer.ini
CacheServer.ini
Certifier.ini
Coreserver.ini
Loginserver.ini
Database.ini
Worldserver.ini
In neuz ini:
IP: 127.0.0.1
-------------------------------------------------
Logs:
Client network Log:
Client error log:
/Program folder log 1:
/Program folder log 2:
Worldserver log:
----------------------------------------
Neuz string table:
AccountServer.ini
TEST
AddTail( -1, 1, "WTF", "127.0.0.1", 0, 1, 0 );
AddTail( 1, 1, "WTF", "127.0.0.1", 0, 1, 600 );
DSN_NAME_LOGIN "login"
DB_ADMIN_ID_LOGIN "login"
DSN_NAME_LOG "log01"
DB_ADMIN_ID_LOG "log01"
SKIP_TRACKING
MSG_VER "20070712"
DB_PWD_LOGIN "12345"
DB_PWD_LOG "12345"
AddTail( -1, 1, "WTF", "127.0.0.1", 0, 1, 0 );
AddTail( 1, 1, "WTF", "127.0.0.1", 0, 1, 600 );
DSN_NAME_LOGIN "login"
DB_ADMIN_ID_LOGIN "login"
DSN_NAME_LOG "log01"
DB_ADMIN_ID_LOG "log01"
SKIP_TRACKING
MSG_VER "20070712"
DB_PWD_LOGIN "12345"
DB_PWD_LOG "12345"
Core "127.0.0.1"
Port 15400
Port 15400
Account "127.0.0.1"
DSN_NAME_LOGIN "sa"
DB_PWD_LOGIN "12345"
DSN_NAME_LOGIN "sa"
DB_PWD_LOGIN "12345"
Sys 1
Database "127.0.0.1"
PartyExpRate "10"
1252
{
1 0 0 30 30 00 00
2 0 0 5 5 00 00
3 0 0 5 5 00 00
4 0 0 5 5 00 00
21 0 0 1 1 00 00
22 0 0 1 1 00 00
23 0 0 1 1 00 00
24 0 0 1 1 00 00
25 0 0 1 1 00 00
121 0 0 5 5 00 00
122 0 0 5 5 00 00
123 0 0 10 10 00 00
124 0 0 5 5 00 00
125 0 0 5 5 00 00
126 0 0 5 5 00 00
127 0 0 5 5 00 00
128 0 0 5 5 00 00
129 0 0 1 1 00 00
130 0 0 1 1 00 00
131 0 0 1 1 00 00
132 0 0 1 1 00 00
133 0 0 1 1 00 00
134 0 0 1 1 00 00
135 0 0 1 1 00 00
151 0 0 2 2 00 00
152 0 0 2 2 00 00
153 0 0 2 2 00 00
154 0 0 2 2 00 00
155 0 0 2 2 00 00
156 0 0 2 2 00 00
157 0 0 2 2 00 00
158 0 0 2 2 00 00
159 0 0 2 2 00 00
160 0 0 2 2 00 00
161 0 0 2 2 00 00
162 0 0 2 2 00 00
163 0 0 2 2 00 00
164 0 0 2 2 00 00
165 0 0 2 2 00 00
166 0 0 2 2 00 00
167 0 0 2 2 00 00
200 0 0 5 5 00 00
201 0 0 5 5 00 00
202 0 0 5 5 00 00
203 0 0 3 3 00 00
204 0 0 5 5 00 00
205 0 0 2 2 00 00
206 0 0 2 2 00 00
207 0 0 2 2 00 00
208 0 0 2 2 00 00
209 0 0 1 1 00 00
210 0 0 1 1 00 00
211 0 0 5 5 00 00
212 0 0 1 1 00 00
213 0 0 1 1 00 00
214 0 0 1 1 00 00
220 0 0 1 1 00 00
230 0 0 1 1 00 00
231 0 0 5 5 00 00
241 0 0 1 1 00 00
242 0 0 1 1 00 00
243 0 0 1 1 00 00
244 0 0 1 1 00 00
}
Database "127.0.0.1"
PartyExpRate "10"
1252
{
1 0 0 30 30 00 00
2 0 0 5 5 00 00
3 0 0 5 5 00 00
4 0 0 5 5 00 00
21 0 0 1 1 00 00
22 0 0 1 1 00 00
23 0 0 1 1 00 00
24 0 0 1 1 00 00
25 0 0 1 1 00 00
121 0 0 5 5 00 00
122 0 0 5 5 00 00
123 0 0 10 10 00 00
124 0 0 5 5 00 00
125 0 0 5 5 00 00
126 0 0 5 5 00 00
127 0 0 5 5 00 00
128 0 0 5 5 00 00
129 0 0 1 1 00 00
130 0 0 1 1 00 00
131 0 0 1 1 00 00
132 0 0 1 1 00 00
133 0 0 1 1 00 00
134 0 0 1 1 00 00
135 0 0 1 1 00 00
151 0 0 2 2 00 00
152 0 0 2 2 00 00
153 0 0 2 2 00 00
154 0 0 2 2 00 00
155 0 0 2 2 00 00
156 0 0 2 2 00 00
157 0 0 2 2 00 00
158 0 0 2 2 00 00
159 0 0 2 2 00 00
160 0 0 2 2 00 00
161 0 0 2 2 00 00
162 0 0 2 2 00 00
163 0 0 2 2 00 00
164 0 0 2 2 00 00
165 0 0 2 2 00 00
166 0 0 2 2 00 00
167 0 0 2 2 00 00
200 0 0 5 5 00 00
201 0 0 5 5 00 00
202 0 0 5 5 00 00
203 0 0 3 3 00 00
204 0 0 5 5 00 00
205 0 0 2 2 00 00
206 0 0 2 2 00 00
207 0 0 2 2 00 00
208 0 0 2 2 00 00
209 0 0 1 1 00 00
210 0 0 1 1 00 00
211 0 0 5 5 00 00
212 0 0 1 1 00 00
213 0 0 1 1 00 00
214 0 0 1 1 00 00
220 0 0 1 1 00 00
230 0 0 1 1 00 00
231 0 0 5 5 00 00
241 0 0 1 1 00 00
242 0 0 1 1 00 00
243 0 0 1 1 00 00
244 0 0 1 1 00 00
}
DB "127.0.0.1"
Core "127.0.0.1"
AddCache ( "127.0.0.1" );
MSG_VER "20070712"
Core "127.0.0.1"
AddCache ( "127.0.0.1" );
MSG_VER "20070712"
ResourceFolder "D:\BLESSED\Blessed Flyff\Resource"
Sys 1
Account "127.0.0.1"
DSN_NAME_CHARACTER "character01"
DB_ADMIN_ID_CHARACTER "sa"
DSN_NAME_LOG "log01"
DB_ADMIN_ID_LOG "sa"
//DSN_NAME_ITEMUPDATE "item"
//DB_ADMIN_ID_ITEMUPDATE "item"
//ITEMUPDATE
//BankToItemSendTbl
//InventoryToItemSendTbl
//ConvStartItem
//REMOVEITEM µЪїЎ 1АМёй ѕЖАМЕЫёё »иБ¦ 2ёй ѕЖАМЕЫ јцёёЕ* БцєТ.
//REMOVEITEM 2
//PIERCING_CONFIRM
//SAVE_TEXT
//__ITEM_REMOVE0203 // itemremove.txt ѕЖАМЕЫ Б¦°Е
//Conv
DB_PWD_LOG "12345"
DB_PWD_CHARACTER "12345"
DB_PWD_BACKEND "12345"
DB_PWD_ITEMUPDATE "12345"
//REMOVE_QUEST
//ITEM_ID
//RESTORE_PET
Sys 1
Account "127.0.0.1"
DSN_NAME_CHARACTER "character01"
DB_ADMIN_ID_CHARACTER "sa"
DSN_NAME_LOG "log01"
DB_ADMIN_ID_LOG "sa"
//DSN_NAME_ITEMUPDATE "item"
//DB_ADMIN_ID_ITEMUPDATE "item"
//ITEMUPDATE
//BankToItemSendTbl
//InventoryToItemSendTbl
//ConvStartItem
//REMOVEITEM µЪїЎ 1АМёй ѕЖАМЕЫёё »иБ¦ 2ёй ѕЖАМЕЫ јцёёЕ* БцєТ.
//REMOVEITEM 2
//PIERCING_CONFIRM
//SAVE_TEXT
//__ITEM_REMOVE0203 // itemremove.txt ѕЖАМЕЫ Б¦°Е
//Conv
DB_PWD_LOG "12345"
DB_PWD_CHARACTER "12345"
DB_PWD_BACKEND "12345"
DB_PWD_ITEMUPDATE "12345"
//REMOVE_QUEST
//ITEM_ID
//RESTORE_PET
ResourceFolder "D:\BLESSED\Blessed Flyff\Resource"
Key 1252
Core "127.0.0.1"
DB "127.0.0.1"
Account "127.0.0.1"
LANG 1
Heartbeat 10101
Proc 2
GUILDWAR
PK
STEAL
DROPITEM_REMOVE
WORMON
GUILDBANK
GUILDCOMBAT
ARENA
SECRETROOM 1
RAINBOWRACE 1
RECOMMEND
Key 1252
Core "127.0.0.1"
DB "127.0.0.1"
Account "127.0.0.1"
LANG 1
Heartbeat 10101
Proc 2
GUILDWAR
PK
STEAL
DROPITEM_REMOVE
WORMON
GUILDBANK
GUILDCOMBAT
ARENA
SECRETROOM 1
RAINBOWRACE 1
RECOMMEND
IP: 127.0.0.1
-------------------------------------------------
Logs:
Client network Log:
Thu Aug 08 01:25:07 2013
0 - CERT_CONNECTED
Thu Aug 08 01:25:07 2013
2 - CERT_SRVR_LIST
Thu Aug 08 01:25:08 2013
4 - LOGIN_CONNECTED
Thu Aug 08 01:25:08 2013
8 - LOGIN_CACHE_ADDR
Thu Aug 08 01:25:08 2013
15 - CERT_DISCONNECT
network error:64
Thu Aug 08 01:25:08 2013
6 - LOGIN_PLAYER_LIST
Thu Aug 08 01:25:45 2013
6 - LOGIN_PLAYER_LIST
Thu Aug 08 01:25:46 2013
9 - CACHE_CONNECTED
Thu Aug 08 01:25:47 2013
11 - LOGIN_REQ_PREJOIN
Thu Aug 08 01:25:47 2013
12 - LOGIN_ACK_PREJOIN
Thu Aug 08 01:25:47 2013
17 - CACHE_DISCONNECT
network error:64
0 - CERT_CONNECTED
Thu Aug 08 01:25:07 2013
2 - CERT_SRVR_LIST
Thu Aug 08 01:25:08 2013
4 - LOGIN_CONNECTED
Thu Aug 08 01:25:08 2013
8 - LOGIN_CACHE_ADDR
Thu Aug 08 01:25:08 2013
15 - CERT_DISCONNECT
network error:64
Thu Aug 08 01:25:08 2013
6 - LOGIN_PLAYER_LIST
Thu Aug 08 01:25:45 2013
6 - LOGIN_PLAYER_LIST
Thu Aug 08 01:25:46 2013
9 - CACHE_CONNECTED
Thu Aug 08 01:25:47 2013
11 - LOGIN_REQ_PREJOIN
Thu Aug 08 01:25:47 2013
12 - LOGIN_ACK_PREJOIN
Thu Aug 08 01:25:47 2013
17 - CACHE_DISCONNECT
network error:64
2013/ 8/ 8 01:24:58 ::LoadTextureFromRes : Theme\English\DUNGEON_WdHeaven01.dds not found
2013/ 8/ 8 01:24:59 CTexture::LoadTexture : Theme\English\DUNGEON_WdHeaven01.dds read error
2013/ 8/ 8 01:24:59 ::LoadTextureFromRes : Theme\English\DUNGEON_WdHeaven02.dds not found
2013/ 8/ 8 01:24:59 CTexture::LoadTexture : Theme\English\DUNGEON_WdHeaven02.dds read error
2013/ 8/ 8 01:24:59 ::LoadTextureFromRes : Theme\English\DUNGEON_WdHeaven03.dds not found
2013/ 8/ 8 01:24:59 CTexture::LoadTexture : Theme\English\DUNGEON_WdHeaven03.dds read error
2013/ 8/ 8 01:24:59 ::LoadTextureFromRes : Theme\English\DUNGEON_WdHeaven04.dds not found
2013/ 8/ 8 01:24:59 CTexture::LoadTexture : Theme\English\DUNGEON_WdHeaven04.dds read error
2013/ 8/ 8 01:24:59 ::LoadTextureFromRes : Theme\English\DUNGEON_WdHeaven05.dds not found
2013/ 8/ 8 01:24:59 CTexture::LoadTexture : Theme\English\DUNGEON_WdHeaven05.dds read error
2013/ 8/ 8 01:24:59 CTexture::LoadTexture : Theme\English\DUNGEON_WdHeaven01.dds read error
2013/ 8/ 8 01:24:59 ::LoadTextureFromRes : Theme\English\DUNGEON_WdHeaven02.dds not found
2013/ 8/ 8 01:24:59 CTexture::LoadTexture : Theme\English\DUNGEON_WdHeaven02.dds read error
2013/ 8/ 8 01:24:59 ::LoadTextureFromRes : Theme\English\DUNGEON_WdHeaven03.dds not found
2013/ 8/ 8 01:24:59 CTexture::LoadTexture : Theme\English\DUNGEON_WdHeaven03.dds read error
2013/ 8/ 8 01:24:59 ::LoadTextureFromRes : Theme\English\DUNGEON_WdHeaven04.dds not found
2013/ 8/ 8 01:24:59 CTexture::LoadTexture : Theme\English\DUNGEON_WdHeaven04.dds read error
2013/ 8/ 8 01:24:59 ::LoadTextureFromRes : Theme\English\DUNGEON_WdHeaven05.dds not found
2013/ 8/ 8 01:24:59 CTexture::LoadTexture : Theme\English\DUNGEON_WdHeaven05.dds read error
2013/ 8/ 7 20:57:25
CDPCoreClient.OnJoin: server not found id: 1 account: jesse player: Jesse world: 1
2013/ 8/ 7 22:30:44
CDPCoreClient.OnJoin: server not found id: 1 account: jesse player: Jesse world: 1
2013/ 8/ 7 23:03:17
CDPCoreClient.OnJoin: server not found id: 1 account: jesse player: Jesse world: 1
CDPCoreClient.OnJoin: server not found id: 1 account: jesse player: Jesse world: 1
2013/ 8/ 7 22:30:44
CDPCoreClient.OnJoin: server not found id: 1 account: jesse player: Jesse world: 1
2013/ 8/ 7 23:03:17
CDPCoreClient.OnJoin: server not found id: 1 account: jesse player: Jesse world: 1
2013/ 8/ 7 22:55:19 Not Addr :
2013/ 8/ 7 23:46:18 Not Addr :
2013/ 8/ 7 23:46:33 Not Addr :
2013/ 8/ 7 23:50:38 Not TransServer Connect
2013/ 8/ 7 23:52:03 Not Addr :
2013/ 8/ 7 23:54:11 Not Addr :
2013/ 8/ 7 23:46:18 Not Addr :
2013/ 8/ 7 23:46:33 Not Addr :
2013/ 8/ 7 23:50:38 Not TransServer Connect
2013/ 8/ 7 23:52:03 Not Addr :
2013/ 8/ 7 23:54:11 Not Addr :
2013/ 8/ 8 00:02:32 OP: 38358491, 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/ 8/ 8 00:02:35 OP: 3432, 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/ 8/ 8 00:02:39 OP: 3316, 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/ 8/ 8 01:21:04 OP: 1170023, 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/ 8/ 8 01:21:54 OP: 50685, 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/ 8/ 8 01:21:59 OP: 4071, 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/ 8/ 8 00:02:35 OP: 3432, 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/ 8/ 8 00:02:39 OP: 3316, 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/ 8/ 8 01:21:04 OP: 1170023, 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/ 8/ 8 01:21:54 OP: 50685, 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/ 8/ 8 01:21:59 OP: 4071, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0
Neuz string table:
STRINGTABLE
LANGUAGE LANG_KOREAN, 0x1
{
1, "127.0.0.1"
2, "1"
3, "0"
4, "1"
5, "1"
6, "20070712"
7, "15400"
8, "5000"
9, "5"
10, "1252"
11, "0"
}
LANGUAGE LANG_KOREAN, 0x1
{
1, "127.0.0.1"
2, "1"
3, "0"
4, "1"
5, "1"
6, "20070712"
7, "15400"
8, "5000"
9, "5"
10, "1252"
11, "0"
}
Please Help) I'm very very tired. I try to solve this problem three days, again and again, again and again...