[Guide] Most of vsro files problem solved here

[ichigo14000]

SMC -CANNOT start smnet:9 what?

[ByMnkn]

now red with ?

[Dr.Abdelfattah]

For People who can't opening Certification Server

Open
CustomCertificationServer Folder
then (bin) folder
then open 1 - decompile.bat
when finish press enter to exit it then u will find ini folder appear to u
open ini folder
then we must edit :
srGlobalService.ini

PHP Code:

DRIVER={SQL Server};SERVER=Your MachineName\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=123456;DATABASE=SRO_VT_ACCOUNT 


&
srNodeType.ini
Edit
wip=
nip=
Replace the old ip with ur machine ip like 192.168.0.1 etc ..

Last
srShard.ini

name=Ur Server Name

PHP Code:

query=DRIVER={SQL Server};SERVER=Your MachineName\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=123456;DATABASE=SRO_VT_SHARD_INIT 


PHP Code:

query_log=DRIVER={SQL Server};SERVER=Your MachineName\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=123456;DATABASE=Log_DB 


capacity=2300


DSN= (better to right database name)

now we save out work then open
2 - compile.bat
when finish press enter to exit

then open
3 - CustomCertificationServer.bat
it works fine and it's the CertificationServer
not the CustomCertificationServer.exe one

Hope i help







------------------------------------------------------------------------------------------------

Originally Posted by maestrow

please post what do i put on config.cfg and the files in custom certification ^^

thanks

For People who can't opening Certification Server

Open
CustomCertificationServer Folder
then (bin) folder
then open 1 - decompile.bat
when finish press enter to exit it then u will find ini folder appear to u
open ini folder
then we must edit :
srGlobalService.ini

PHP Code:

DRIVER={SQL Server};SERVER=Your MachineName\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=123456;DATABASE=SRO_VT_ACCOUNT 


&
srNodeType.ini
Edit
wip=
nip=
Replace the old ip with ur machine ip like 192.168.0.1 etc ..

Last
srShard.ini

name=Ur Server Name

PHP Code:

query=DRIVER={SQL Server};SERVER=Your  MachineName\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=123456;DATABASE=SRO_VT_SHARD_INIT 


PHP Code:

query_log=DRIVER={SQL  Server};SERVER=Your  MachineName\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=123456;DATABASE=Log_DB 


capacity=2300


DSN= (better to right database name)

now we save out work then open
2 - compile.bat
when finish press enter to exit

then open
3 - CustomCertificationServer.bat
it works fine and it's the CertificationServer
not the CustomCertificationServer.exe one

Hope i help

and config.cfg give me mint

-----------------------------------------------

Originally Posted by ichigo14000

SMC -CANNOT start smnet:9 what?

Fixing SMC_Independent

open ServiceManager.cfg
in
PHP Code:

SMC {
DivisionManager "127.0.0.1",15880
}

change 127.0.0.1 to ur IP
and port 15880 change it to 32000

and u can open SMC after open GlobalManager

ID:sro_gm1
PW:hn2006

and leave SSNumber2 empty

---------------------------------------------

Originally Posted by ByMnkn

now red with ?

So we have a good Step and we are working to solve that

[formatme]

k i got iss working but its a picture but when i go to
it works fine but 127.0.0.1 is a picture

[Dr.Abdelfattah]

For People who Needs server.cfg

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 "127.0.0.1", 32001
    Certification "127.0.0.1", 32001
    
    LoginFailureTolerance        3                // Ãִ렷α×ÀΠÆнº¿öµå ¿À·ù Çã¿ëÄ¡
    IBUVFailureTolerance        3                // ÃÖ´ë À̹ÌÁö ÀÎÁõ ¿À·ù Çã¿ëÄ¡
    LoginFailureBlockTimeMin    10                // ºí·° ½Ã°£(ºÐ) - ·Î±×ÀΠÆнº¿öµå ¿À·ù 
    IBUVFailureBlockTimeMin        10                // ºí·° ½Ã°£(ºÐ) - À̹ÌÁö ÀÎÁõ ¿À·ù 
    AutomatedPunisher        "AutomatedPunisher"        // ºí·° ÁÖü À̸§ (±âÁ¸ ºí·°Àº gm ¸í)
    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", 32000
    IBUVQueueReserveCount        20000    // IBUV¸¦ À§ÇØ ¹Ì¸® »ý¼ºÇØ ³õÀ» À̹ÌÁö °¹¼ö    
    IBUVQueuePrepareRatio        0.05    // ¾ÆÀ̵é Å¸ÀÓ¿¡ À̹ÌÁö »ý¼ºÇÒ ºñÀ²
    IBUVFailureIPTolerance        0    // ÇÑ IP´ç IBUV ½ÇÆи¦ Çã¿ëÇÒ ÃÖ´ë ¿À·ù Çã¿ëÄ¡, 0ÀÌ¸é ºí·° ¾ÈÇϰڴٴ °ÅÁö.

    // Ãß°¡µÈ ³ÑÀÌ´Ù!!!!!
    //////////////////////////////////////////////////////////
    IBUVStringSize            6     // Çѱ۠ij¸¯Åͼ »ç¿ë ½Ã 3, ¾ËÆĺª Ä³¸¯ÅÍ ¼Â¸¸ »ç¿ëÇϴ °æ¿ì 6 À¸·Î ¼¼ÆÃÇÑ´Ù.
    IBUVCharacterSet        "ABCDEFGHLMNQRTabdehimn2345678"
    //////////////////////////////////////////////////////////
}

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

AgentServer {
    Certification "127.0.0.1", 32004
}

MachineManager {
    Certification "127.0.0.1", 32000
}

SR_GameServer {
    Certification "127.0.0.1", 32004

    ExpRatio             100
        ExpRatioParty        100
      
    DropItemRatio       0,1
        DropGoldAmountCoef   0,1    
        //WINTER_EVENT_2009        EVENT_ON    // 2009³â °Ü¿ï À̺¥Æ®
    //EUBUSINESS_EVENT        EVENT_ON
        //GOLDEN_PIG_FEBRUARY_EVENT    EVENT_ON
    //THANKS_GIVING_EVENT        EVENT_ON
    //LIBERATION_EVENT        EVENT_ON
    LOCALE LOCALE_VIETNAM    // for Helper mark 
       
         //#ifdef OPEN_MARKET_SYSTEM
        SET_FEE_RATE            "0,5,5,5"
        SELL_FEE_RATE           "0,10,10,10"
         //#endif OPEN_MARKET_SYSTEM
}

SR_ShardManager {
    Certification "127.0.0.1", 32004
    BILLING_SERVER_URL "http://127.0.0.1:8080/"
    CREST_FTP_URL "ftp://id:[email protected]/"
        ExtraExpRatio        0.1
        ChristmasEvent2007 0
    //SERVER_EVENT_SYSTEM             ON
       LOCALE LOCALE_VIETNAM
       FlagEvent             0
       FlagEvent                        1
       HourForMeterRateLevelFirst    22
       HourForMeterRateLevelSecond    23

    BattleArenaRandom 1
    BattleArenaParty 1
    BattleArenaGuild 1
    BattleArenaJob 1
    ArenaMatchOccupy 1
    ArenaMatchFlag 1
    ArenaMatchPoint 1
} 


Use that Config ,but
Just change
127.0.0.1 ips
to Your machine ip




-----------------------------------------------------------------

Originally Posted by formatme

k i got iss working but its a picture but when i go to
it works fine but 127.0.0.1 is a picture

now download iis manager 6 and edit the files and ftp of ur machine
link download :

[oliok]

Originally Posted by abdelfattah

i Forgot

SK_gamebang_ip problem

PHP Code:

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SK_gamebang_ip](
[nID] [smallint] NOT NULL,
[ip] [int] NOT NULL,
[capacity] [smallint] NOT NULL
) ON [PRIMARY]

GO 


PHP Code:

[ip] [varchar] NOT NULL 


also SR_ShardManager.exe billing dead issue isn't about server.cfg.
it's about the db... stored procedure called "_ExistsServiceOffRentItem" was deleted.

now, looking at globalmanager module, i saw
Query Error!!! Query Result : -1, Query : exec _AddCurrentUserCount 64, 0, '2011-9-13 3:57:6' - Error converting data type varchar to datetime..
which table and field has to change?

[Dr.Abdelfattah]

Originally Posted by oliok

PHP Code:

[ip] [varchar] NOT NULL 


also SR_ShardManager.exe billing dead issue isn't about server.cfg.
it's about the db... stored procedure called "_ExistsServiceOffRentItem" was deleted.

now, looking at globalmanager module, i saw
Query Error!!! Query Result : -1, Query : exec _AddCurrentUserCount 64, 0, '2011-9-13 3:57:6' - Error converting data type varchar to datetime..
which table and field has to change?

let me try to make db named _ExistsServiceOffRentItem and see if error gone or ..
then we must see _AddCurrentUserCount

[formatme]

ok i fixed my SR_ShardManager

but MachineManager is still closing

[oliok]

Originally Posted by formatme

ok i fixed my SR_ShardManager

but MachineManager is still closing

how did u fixed the issue? (deadbilling)

[ichigo14000]

my gate wayserver not work and global say cANNOT estabilis sessin blabla

[Dr.Abdelfattah]

Originally Posted by ichigo14000

my gate wayserver not work and global say cANNOT estabilis sessin blabla

check ur ips and db connection

[badibatu22]

Originally Posted by abdelfattah

check ur ips and db connection

how can i check my db connection ?

[ichigo14000]

192.168.103 to cerfation true?
192.168.1.103:32001

[ByMnkn]

who finised MachManegar error ?

[utku1676]

ı cant open download server or other only global maneger,



can u help me ?