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

vitalik123 · 10/31/2011, 10:08

Quote:

Originally Posted by xSasuke16x

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:

is there a tutorial how to ? ...

probably you have selected wrong default language for SQL user (sa for default)
shoud be English.

yeixon · 11/21/2011, 00:33

How i can configure my server with hamachi? I got crash machinemanager.exe with ip hamachi please answer me

mafiatek2 · 11/21/2011, 17:35

i have big proplem please help me when i open Global Manager see

Uploaded with

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:[email protected]/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
........

Dr.Abdelfattah · 11/23/2011, 13:18

Quote:

Originally Posted by mafiatek2

i have big proplem please help me when i open Global Manager see

Uploaded with

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:[email protected]/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

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:[email protected]/"
        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
}

penelopee · 11/26/2011, 01:39

You are full kral

I love this turkish-enlish word ^_^

ra7al_lover · 11/26/2011, 23:09

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

magamio · 12/02/2011, 01:22

Who can tell me what path can host at one PC whith VMWARE ? what path need to start all regions?

oxmox1 · 12/19/2011, 00:59

Quote:

Originally Posted by Dr.Abdelfattah

First view this

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:[email protected]/" 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

asd1 · 12/29/2011, 16:49

ah day

Reddox1993 · 01/14/2012, 15:57

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 !

♥

BlackG2k · 01/21/2012, 03:34

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

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 ?

lucky117 · 01/27/2012, 17:08

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

Uploaded with

~~ronaldini~~ · 02/15/2012, 15:17

plz help me

SQL Error 3241

killercom · 02/15/2012, 17:22

Help me with this

otlviem · 02/19/2012, 08:52

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
(

)
Thank You!