+1, HOW? atleast with 2 machines?Quote:
Originally Posted by kobimodel
Printable View
+1, HOW? atleast with 2 machines?Quote:
Originally Posted by kobimodel
First of all i want to thank you for your free time in building this files and second i would like to see more succesfully MMO like this thread.
http://i26.lulzimg.com/bf6d5b.jpg
what is wrong ?
im pressed start from launcher.
and after i get this error
Gameserver crashes after loading
i diabled all regions except china.
logs:
http://picload.org/image/iorwla/gs2.jpg
http://picload.org/image/iorwop/sl2.jpg
any idea?
can someone tell me why i get dc after login? something with billing? but what!!??!??^^
we need change password script and forgot password script any one can share here,
we can add rb system , if yes then how,
and how to add silk on account by webpage that it
thanks
Hi
I have a problem with SR_ShardManager.exe and SR_GameServer.exe
In both, there is a fatal warning "DB Connection Failed"
I don't know what is the problem :(
there is my srShard and srGlobalService:
srGlobalService.ini
[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=PREZES-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa_acc;PWD=1234;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697
srShard.ini
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=PREZES-PC\SQLEXPRESS;UID=sa_db;PWD=1234;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=PREZES-PC\SQLEXPRESS;DSN=SRO_VT_LOG;UID=sa_log;PWD=1234;DATABASE=SRO_VT_LOG
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
I just setup the server everything is starting fine .Client Start button is active,i can select the server from server list, login with sro_gm1 account,creating a new char(china).But when i select the new char and press 'start' ,the game start loading and in the end of loading line client, just crash.I am using only CHINA region.I am using client version 1.188
Thanks in advance for any solution.
Regards
There is my setting:
server.cfg
srGlobalService.iniPHP Code:Common {
debug_option_debugger_present{
DEBUG_OPTION_ASSERT_SHOW_MESSAGEBOX_OKCANCEL,
DEBUG_OPTION_ASSERT_ADVANCE_BREAK,
DEBUG_OPTION_ASSERT_CANCEL_EXIT
}
debug_option_stand_alone{
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}
netengine_debug_option_debugger_present{
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}
netengine_debug_option_stand_alone{
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
}
}
////////////////////////////////////////////////////////////////////////////////////////////
GlobalManager {
Certification "192.168.0.79", 32000
LoginFailureTolerance 3
IBUVFailureTolerance 3
LoginFailureBlockTimeMin 0
IBUVFailureBlockTimeMin 0
AutomatedPunisher "AutomatedPunisher"
LoginPunishmentGuide "Blocked for 10 minutes due to incorrect password entered 3 times"
LoginPunishmentDescription "Blocked for 10 minutes due to incorrect password entered 3 times"
IBUVPunishmentGuide "Blocked for 10 minutes due to incorrect code entered 3 times"
IBUVPunishmentDescription "Blocked for 10 minutes due to incorrect code entered 3 times"
}
GatewayServer {
LastFullVersion_SR_Client 130
Certification "192.168.0.79", 15880
IBUVQueueReserveCount 20000
IBUVQueuePrepareRatio 0.10
IBUVFailureIPTolerance 0
IBUVStringSize 1
IBUVCharacterSet "ABCDEF1234567890"
}
DownloadServer {
Certification "192.168.0.79", 15880
}
FarmManager {
Certification "192.168.0.79", 15880
}
AgentServer {
Certification "192.168.0.79", 15882 //no global manager running lol
//traffic_filter_activity "service_off"
//MaxUser 5000
//SockTCPCount 15000
MaxConnectionsPerServer "5000"
MaxConnectionsPer1_OServer "5000"
}
MachineManager {
Certification "192.168.0.79", 15880
CERTIFICATION_IP_BIND "192.168.0.79"
}
SR_GameServer {
Certification "192.168.0.79", 15882
SockTCPCount "5000"
ExpRatio "35000"
ExpRatioParty "35000"
DropItemRatio "5000"
DropGoldAmountCoef "15000"
HwanGainFactor "250"
ShowFormulaDetail "1"
//WINTER_EVENT_2009 EVENT_ON
//EUBUSINESS_EVENT EVENT_ON
//GOLDEN_PIG_FEBRUARY_EVENT EVENT_ON
//THANKS_GIVING_EVENT EVENT_ON
//LIBERATION_EVENT EVENT_ON
LOCALE LOCALE_VIETNAM
//#ifdef OPEN_MARKET_SYSTEM
SET_FEE_RATE "0,5,5,5"
SELL_FEE_RATE "0,10,10,10"
//#endif OPEN_MARKET_SYSTEM
//RE FTW
DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL "OFF"
ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED "OFF"
}
SR_ShardManager {
Certification "192.168.0.79", 15882
BILLING_SERVER_URL "http://192.168.0.79:80/"
CREST_FTP_URL "ftp://abdo:123456@192.168.0.79/"
ChristmasEvent2007 1
SERVER_EVENT_SYSTEM ON
LOCALE LOCALE_VIETNAM
FlagEvent 1
//HourForMeterRateLevelFirst 24
//HourForMeterRateLevelSecond 0
BattleArenaRandom 1
BattleArenaParty 1
BattleArenaGuild 1
BattleArenaJob 1
ArenaMatchOccupy 1
ArenaMatchFlag 1
ArenaMatchPoint 1
}
srNodeData.iniPHP Code:[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=.\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=12345;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697
srNodeLink.iniPHP Code:[global]
count=9
[entry0]
node_id=697
operation_type=22
global_operation_id=0
associated_shard_id=0
node_type=335
service_type=2
certification_node_id=1
port=15880
node_icon=4
u1=144
u2=22
u3=24
u4=1
u5=248
u6=146
u7=19
u8=1
u9=64
u10=160
u11=17
u12=1
u13=0
u14=0
u15=0
u16=0
u17=0
u18=0
u19=0
u20=0
[entry1]
node_id=1
operation_type=0
global_operation_id=0
associated_shard_id=0
node_type=335
service_type=1
certification_node_id=0
port=32000
node_icon=5
u1=40
u2=22
u3=24
u4=1
u5=216
u6=99
u7=19
u8=1
u9=0
u10=0
u11=0
u12=0
u13=0
u14=0
u15=0
u16=0
u17=0
u18=0
u19=0
u20=0
[entry2]
node_id=698
operation_type=22
global_operation_id=0
associated_shard_id=0
node_type=335
service_type=4
certification_node_id=697
port=15779
node_icon=0
u1=96
u2=23
u3=24
u4=1
u5=48
u6=148
u7=19
u8=1
u9=64
u10=160
u11=17
u12=1
u13=0
u14=0
u15=0
u16=0
u17=0
u18=0
u19=0
u20=0
[entry3]
node_id=699
operation_type=22
global_operation_id=0
associated_shard_id=0
node_type=335
service_type=11
certification_node_id=697
port=25880
node_icon=0
u1=56
u2=26
u3=24
u4=1
u5=48
u6=148
u7=19
u8=1
u9=64
u10=160
u11=17
u12=1
u13=0
u14=0
u15=0
u16=0
u17=0
u18=0
u19=0
u20=0
[entry4]
node_id=700
operation_type=22
global_operation_id=0
associated_shard_id=0
node_type=335
service_type=3
certification_node_id=697
port=15881
node_icon=0
u1=248
u2=22
u3=24
u4=1
u5=96
u6=147
u7=19
u8=1
u9=64
u10=160
u11=17
u12=1
u13=0
u14=0
u15=0
u16=0
u17=0
u18=0
u19=0
u20=0
[entry5]
node_id=704
operation_type=22
global_operation_id=20
associated_shard_id=0
node_type=335
service_type=5
certification_node_id=697
port=15882
node_icon=0
u1=200
u2=23
u3=24
u4=1
u5=152
u6=148
u7=19
u8=1
u9=64
u10=160
u11=17
u12=1
u13=0
u14=0
u15=17
u16=1
u17=0
u18=0
u19=0
u20=0
[entry6]
node_id=705
operation_type=22
global_operation_id=20
associated_shard_id=64
node_type=335
service_type=7
certification_node_id=704
port=15883
node_icon=0
u1=152
u2=24
u3=24
u4=1
u5=0
u6=149
u7=19
u8=1
u9=64
u10=160
u11=17
u12=1
u13=0
u14=0
u15=17
u16=1
u17=168
u18=102
u19=18
u20=1
[entry7]
node_id=707
operation_type=22
global_operation_id=20
associated_shard_id=64
node_type=335
service_type=6
certification_node_id=704
port=15884
node_icon=0
u1=48
u2=24
u3=24
u4=1
u5=104
u6=149
u7=19
u8=1
u9=64
u10=160
u11=17
u12=1
u13=0
u14=0
u15=17
u16=1
u17=168
u18=102
u19=18
u20=1
[entry8]
node_id=713
operation_type=22
global_operation_id=20
associated_shard_id=64
node_type=335
service_type=8
certification_node_id=704
port=15885
node_icon=0
u1=0
u2=25
u3=24
u4=1
u5=160
u6=150
u7=19
u8=1
u9=64
u10=160
u11=17
u12=1
u13=0
u14=0
u15=17
u16=1
u17=168
u18=102
u19=18
u20=1
srNodeType.iniPHP Code:[global]
count=11
[entry0]
id=1227
child_node_id=697
parent_node_id=1
p_label=0
u1=0
u2=0
u3=0
u4=0
u5=0
[entry1]
id=1228
child_node_id=698
parent_node_id=697
p_label=0
u1=0
u2=0
u3=0
u4=0
u5=0
[entry2]
id=1229
child_node_id=699
parent_node_id=697
p_label=0
u1=0
u2=0
u3=0
u4=0
u5=0
[entry3]
id=1230
child_node_id=700
parent_node_id=697
p_label=0
u1=0
u2=0
u3=0
u4=0
u5=0
[entry4]
id=1234
child_node_id=704
parent_node_id=697
p_label=1
u1=0
u2=0
u3=0
u4=0
u5=0
[entry5]
id=1235
child_node_id=705
parent_node_id=704
p_label=0
u1=0
u2=0
u3=0
u4=0
u5=0
[entry6]
id=1237
child_node_id=707
parent_node_id=704
p_label=1
u1=0
u2=0
u3=0
u4=0
u5=0
[entry7]
id=1239
child_node_id=713
parent_node_id=704
p_label=0
u1=0
u2=0
u3=0
u4=0
u5=0
[entry8]
id=1241
child_node_id=707
parent_node_id=713
p_label=1
u1=0
u2=0
u3=0
u4=0
u5=0
[entry9]
id=1245
child_node_id=707
parent_node_id=705
p_label=1
u1=0
u2=0
u3=0
u4=0
u5=0
[entry10]
id=1256
child_node_id=713
parent_node_id=705
p_label=0
u1=0
u2=0
u3=0
u4=0
u5=0
srShard.iniPHP Code:[global]
count=1
[entry0]
id=335
operation_type=22
name=SRO Vietnam TestLocal
wip=192.168.0.79
nip=192.168.0.79
machine_manager_node_id=699
PHP Code:[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=ServerName
query=DRIVER={SQL Server};SERVER=.\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=12345;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=.\SQLEXPRESS;DSN=SRO_VT_SHARDLOG;UID=sa;PWD=12345;DATABASE=SRO_VT_SHARDLOG
capacity=50
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
Edit:My problem is solved!The problem was in the way of patching of Media.pk file.I was too lazy and used a media patcher.That is the reason of lost 2 days to try to solve the problem (DC after character select>loading just in the end of progress bar)
So DO NOT USE media patcher,just edit you meria.pk with some HEX editor ,like XVI32 (in 1st page of this tutorial) or UltraEdit,WinHex etc.
polileusz about ur problem.Why you are using 3 different user names for databases?
UID=sa_acc
UID=sa_db
UID=sa_log
Do u have 3 different usernames?Try to make it only with one 'sa' , UID=sa
Hey guys,
can you tell me how i can change:
-level cap
-max skill level
-exp rate
-sp rate
-gold rate
Could any1 help me?
srGlobalService.ini
Quote:
[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=LUÍS-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=mypw;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697
http://img600.imageshack.us/img600/8286/errornd.pngQuote:
srShard.ini
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=LUÍS-PC\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=mypw;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=LUÍS-PC\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=mypw;DATABASE=Log_DB
capacity=10
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
Probably u have a problem with ODBC connection.In the record 'PWD=mypw' u must put ur 'SA' password like ex.;PWD=12345 (or the password that u set for 'sa' user)Quote:
Originally Posted by Valynzilex
Quote:
Originally Posted by hexcode
Thanks for the reply. Can you tell me how to sign only "sa" users to those 3 databases?
When you setup SQL Server if you chose mixed authentication mode then you would have set a password for the 'sa' account.Quote:
Originally Posted by polileusz
Although I would not suggest using sa for all of these connections in a production environment, I am sure most people are just fiddling around.
So for the UID in the connection strings put 'sa' and the password you assigned it. If you used just windows authentication then you will need to use your windows user and password you used when setting up SQL Server.
Thanks for the reply. I have the "sa"user, but how can I assign "sa"user to 3 different databases?Quote:
Originally Posted by kontroversy
You do not need to assign sa to any database, it is the SQL System Admin account and has full access to every database on the server.Quote:
Originally Posted by polileusz