{Guide/Release} SQL Server configuration For vsro files & Patches options

10/31/2011 10:08 vitalik123#196
Quote:
Originally Posted by xSasuke16x View Post
Dr.Abdelfattah you are the prince and you would be the King when you help me :)
I want make 2 Gamseserver on two different stable roots... but I get this error:
[Only registered and activated users can see links. Click Here To Register...]
is there a tutorial how to ? ...
probably you have selected wrong default language for SQL user (sa for default)
shoud be English.
11/21/2011 00:33 yeixon#197
How i can configure my server with hamachi? I got crash machinemanager.exe with ip hamachi please answer me
11/21/2011 17:35 mafiatek2#198
i have big proplem please help me when i open Global Manager see

[Only registered and activated users can see links. Click Here To Register...]

Uploaded with [Only registered and activated users can see links. Click Here To Register...]

this my [ Server.cfg ] File

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 "127.0.0.1", 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 "127.0.0.1", 15880
IBUVQueueReserveCount 20000
IBUVQueuePrepareRatio 0.10
IBUVFailureIPTolerance 0
IBUVStringSize 1
IBUVCharacterSet "ABCDEF1234567890"
}

DownloadServer {
Certification "127.0.0.1", 15880
}
FarmManager {
Certification "127.0.0.1", 15880
}

AgentServer {
Certification "127.0.0.1", 15882 //no global manager running lol
//traffic_filter_activity "service_off"
//MaxUser 5000
//SockTCPCount 15000
MaxConnectionsPerServer "5000"
MaxConnectionsPer1_OServer "5000"
}

MachineManager {
Certification "127.0.0.1", 15880
CERTIFICATION_IP_BIND "127.0.0.1"
}

SR_GameServer {
Certification "127.0.0.1", 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 "127.0.0.1", 15882
BILLING_SERVER_URL "http://127.0.0.1:8080/"
CREST_FTP_URL "ftp://RA7AL:123456789@127.0.0.1/SRO_CREST/"
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
}
..............

Plz Help Me Fast
........
11/23/2011 13:18 Dr.Abdelfattah#199
Quote:
Originally Posted by mafiatek2 View Post
i have big proplem please help me when i open Global Manager see

[Only registered and activated users can see links. Click Here To Register...]

Uploaded with [Only registered and activated users can see links. Click Here To Register...]

this my [ Server.cfg ] File

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 "127.0.0.1", 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 "127.0.0.1", 15880
IBUVQueueReserveCount 20000
IBUVQueuePrepareRatio 0.10
IBUVFailureIPTolerance 0
IBUVStringSize 1
IBUVCharacterSet "ABCDEF1234567890"
}

DownloadServer {
Certification "127.0.0.1", 15880
}
FarmManager {
Certification "127.0.0.1", 15880
}

AgentServer {
Certification "127.0.0.1", 15882 //no global manager running lol
//traffic_filter_activity "service_off"
//MaxUser 5000
//SockTCPCount 15000
MaxConnectionsPerServer "5000"
MaxConnectionsPer1_OServer "5000"
}

MachineManager {
Certification "127.0.0.1", 15880
CERTIFICATION_IP_BIND "127.0.0.1"
}

SR_GameServer {
Certification "127.0.0.1", 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 "127.0.0.1", 15882
BILLING_SERVER_URL "http://127.0.0.1:8080/"
CREST_FTP_URL "ftp://RA7AL:123456789@127.0.0.1/SRO_CREST/"
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
}
..............

Plz Help Me Fast
........
First view this
[Only registered and activated users can see links. Click Here To Register...]

then use this Server.cfg in server files

PHP 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

11/26/2011 01:39 penelopee#200
You are full kral :)

I love this turkish-enlish word ^_^
11/26/2011 23:09 ra7al_lover#201
3la fkra ya basha enta mlkash 7d rbna ykremak .. el moshkela et7let bs fe moshkela tnya el global manager byshta5.l kowayes we kol 7aga bs el download server msh byfta7 msh 3aref leh
12/02/2011 01:22 magamio#202
Who can tell me what path can host at one PC whith VMWARE ? what path need to start all regions?
12/19/2011 00:59 oxmox1#203
Quote:
Originally Posted by Dr.Abdelfattah View Post
First view this
[Only registered and activated users can see links. Click Here To Register...]

then use this Server.cfg in server files

PHP 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

i have this error to and i do this but still give me this error and i close Dm so what i must do agian please no ignor me my Error is Bsojb Plug in when i Start Globalmanager
12/29/2011 16:49 asd1#204
[Only registered and activated users can see links. Click Here To Register...]

ah day
01/14/2012 15:57 Reddox1993#205
Abdelfattah ? Im Daniel from your Facebook Friendlist.

I wrote you sometimes but you never answer. So I have to try it here.

I can start all exe.īs but when I want to start "SMC" I get following Message = "SMC.... has stopped working blablablba "

Any Solution ?

Would be awesome if you could help me !


Thx to this great Community !

01/21/2012 03:34 BlackG2k#206
anyone have a fix for the server to server port problem ?

example: ( teleport from jangan to dw if "server 1 jangan" and "dw server 2" )

all ppl say same problem but no have a helpfull answer

Quote:
Originally Posted by BlackG2k View Post
anyone have a fix for the server to server port problem ?

example: ( teleport from jangan to dw if "server 1 jangan" and "dw server 2" )

all ppl say same problem but no have a helpfull answer
no one ?
01/27/2012 17:08 lucky117#207
Hello;

I am using Patch 5.0 but i am receiving error on FarmManager when i clicked Start Button..

Unhandled msg received CFarmManagerMainProcess : IP:192.168.1.182 NoDir:0x0209 (0x3020) (MsgType:2), 14 - 14

NOTE : I haven't problem with FarmManager when i used 1x GameServer

[Only registered and activated users can see links. Click Here To Register...]

Uploaded with [Only registered and activated users can see links. Click Here To Register...]
02/15/2012 15:17 ronaldini#208
[Only registered and activated users can see links. Click Here To Register...]
plz help me

SQL Error 3241
02/15/2012 17:22 killercom#209
[Only registered and activated users can see links. Click Here To Register...]

Help me with this
02/19/2012 08:52 otlviem#210
I have lost a file "Patch Fixes V2.rar" I tried to download but the link was broken
who is up and please share me with
or send me by mail Nhe
([Only registered and activated users can see links. Click Here To Register...])
Thank You!