[Guide] Most of vsro files problem solved here

Quote:

Originally Posted by emptyz How to make xtrap allow local connections?

Quote:

Originally Posted by rushcrush [Only registered and activated users can see links. Click Here To Register...] that's my problem and cuz it the MachineManager.exe wont open i think o.o so how i fix this?

Quote:

Originally Posted by HaGsTeR Well creating that table didnt help Code: 2011-09-13 12:44:24 [SR_ShardManager] SQL Error State:42000, Native Error Code: AF9, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The request for procedure '_ExistsServiceOffRentItem' failed because '_ExistsServiceOffRentItem' is a table object.

Quote:

Originally Posted by ByMnkn Hey. help me SR_ShardManager closed 1-2 min later ? ip 192.168.1.xx change ? 127.0.0.1

Quote:

Originally Posted by Ninja_Stylez [Only registered and activated users can see links. Click Here To Register...] Dahm.. Tryed few things in the "ini"s but.. nothing worked any ideas ? PLEASEEEEE! [Only registered and activated users can see links. Click Here To Register...] -Thanks in advance..

Quote:

D & PASS of ur FTP server and don't forgot [Only registered and activated users can see links. Click Here To Register...] change 8080 to 80 only or if u setup ur iss to access on port 8080 u can make it like original [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by abdelfattah billing dead and closed solve in server.cfg PHP Code: SR_ShardManager { Certification "123.30.200.70", 15882 BILLING_SERVER_URL "http://123.30.200.70:8080/" CREST_FTP_URL "ftp://sro_logo:net2e1@123.30.200.70/" change it to PHP Code: SR_ShardManager { Certification "YourIp", 32004 BILLING_SERVER_URL "http://YourIp:80/" CREST_FTP_URL "ftp://ID:pass@YourIp/" ID & PASS of ur FTP server [Only registered and activated users can see links. Click Here To Register...] and don't forgot [Only registered and activated users can see links. Click Here To Register...] change 8080 to 80 only [Only registered and activated users can see links. Click Here To Register...] or if u setup ur iss to access on port 8080 u can make it like original [Only registered and activated users can see links. Click Here To Register...] or check that more info [Only registered and activated users can see links. Click Here To Register...] Something will help to make files works fine Quote: Originally Posted by Miki Maus [Only registered and activated users can see links. Click Here To Register...] [Only registered and activated users can see links. Click Here To Register...] what database u choose for extract that table? else try to extract it in the 3 databases .. if it was works fine after loading 100% so ur ram or prossecor is small if was loading maybe billing dead problem ... wrong config entry (maybe id or pass) or another solusion i will make small guide for it now ;)

Quote:

Originally Posted by buriko_0007 Yes same problem. How to bypass Xtrap ? I open server ; [Only registered and activated users can see links. Click Here To Register...] Server List coming and Client Xtrap Error How to fix or Bypass Xtrap ?? [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by abdelfattah Something worng in ur configs !! What is wrong check it :=) 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 "5.3.164.148", 32001 Certification "5.3.164.148", 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 "5.3.164.148", 32000 IBUVQueueReserveCount 20000 // IBUV¸¦ À§ÇØ ¹Ì¸® »ı¼ºÇØ ³õÀ» À̹ÌÁö °¹¼ö IBUVQueuePrepareRatio 0.05 // ¾ÆÀ̵é ŸÀÓ¿¡ À̹ÌÁö »ı¼ºÇÒ ºñÀ² IBUVFailureIPTolerance 0 // ÇÑ IP´ç IBUV ½ÇÆи¦ Çã¿ëÇÒ ÃÖ´ë ¿À·ù Çã¿ëÄ¡, 0ÀÌ¸é ºí·° ¾ÈÇÏ°Ú´Ù´Â °ÅÁö. // Ãß°¡µÈ ³ÑÀÌ´Ù!!!!! ////////////////////////////////////////////////////////// IBUVStringSize 6 // ÇÑ±Û Ä³¸¯Åͼ »ç¿ë ½Ã 3, ¾ËÆĺª ij¸¯ÅÍ ¼Â¸¸ »ç¿ëÇÏ´Â °æ¿ì 6 À¸·Î ¼¼ÆÃÇÑ´Ù. IBUVCharacterSet "ABCDEFGHLMNQRTabdehimn2345678" ////////////////////////////////////////////////////////// } DownloadServer { Certification "5.3.164.148", 32000 } FarmManager { Certification "5.3.164.148", 32000 } AgentServer { Certification "5.3.164.148", 32004 } MachineManager { Certification "5.3.164.148", 32003 } SR_GameServer { Certification "5.3.164.148", 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 "5.3.164.148", 32004 BILLING_SERVER_URL "http://5.3.164.148:80/" CREST_FTP_URL "ftp://sro_logo:net2e1@5.3.164.148/" 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 }

Quote:

Originally Posted by paradise1992 [Only registered and activated users can see links. Click Here To Register...] how to opened [CERT] Ty abdelfattah

Quote:

Originally Posted by kobi92 *Same here.

Quote:

Originally Posted by abdelfattah [B][COLOR=Red] what database u choose for extract that table? else try to extract it in the 3 databases ..

Quote:

Originally Posted by Gunna did ur put this ip (5.3.164.148) in ini Certification configs must be ip or port wrong or check ur firewall !! i got solve but need time cuz i will make some pic

Quote:

Originally Posted by Ninja_Stylez BTW Thanks for the tut u gonna make but can u explain with 2-3 pics how to put those codes for the lost tables into the DB cuz i cant find it .. thanks :)

Quote:

Originally Posted by DaD2 Hello Every Body When i Put in server.cfg and SrNodeType.ini 127.0.0.1 The Globalmanger is runing Well Without problems but when i put 192.168.x.x or Hamachi Ip i found this error when i open GlobalManger After Editing For Hamachi ip or this ip 192.168.x.x [Only registered and activated users can see links. Click Here To Register...] srNodeType.ini PHP Code: [global] [global] count=8 [entry0] id=335 operation_type=17 name=GMGS wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=0 [entry1] id=336 operation_type=17 name=DN1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=701 [entry2] id=338 operation_type=17 name=GWS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=699 [entry3] id=339 operation_type=17 name=FMGS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=0 [entry4] id=340 operation_type=17 name=SDMGS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=706 [entry5] id=341 operation_type=17 name=SD1AGS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=708 [entry6] id=344 operation_type=17 name=SD1GAS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=714 [entry7] id=133 operation_type=0 name=Certification Manager wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=0 [entry8] id=343 operation_type=17 name=SD1AGS3 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=712 [entry9] id=344 operation_type=17 name=SD1GAS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=714 [entry10] id=345 operation_type=17 name=SD1GAS2 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=716 [entry11] id=386 operation_type=17 name=SDMGS2 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=801 [entry12] id=387 operation_type=17 name=SD2AGS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=803 [entry13] id=388 operation_type=17 name=SD2AGS2 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=805 [entry14] id=389 operation_type=17 name=SD2AGS3 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=807 [entry15] id=390 operation_type=17 name=SD2GAS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=809 [entry16] id=391 operation_type=17 name=SD2GAS2 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=811 [entry17] id=392 operation_type=17 name=SDMGS3 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=813 [entry18] id=393 operation_type=17 name=SD3AGS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=815 [entry19] id=394 operation_type=17 name=SD3AGS2 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=817 [entry20] id=395 operation_type=17 name=SD3AGS3 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=819 [entry21] id=396 operation_type=17 name=SD3GAS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=821 [entry22] id=397 operation_type=17 name=SD3GAS2 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=823 [entry23] id=401 operation_type=17 name=SDMGS4 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=837 [entry24] id=402 operation_type=17 name=SD4AGS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=839 [entry25] id=403 operation_type=17 name=SD4AGS2 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=841 [entry26] id=404 operation_type=17 name=SD4AGS3 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=843 [entry27] id=405 operation_type=17 name=SD4GAS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=845 [entry28] id=406 operation_type=17 name=SD4GAS2 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=847 [entry29] id=446 operation_type=17 name=SDMGS5 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=950 [entry30] id=447 operation_type=17 name=SD5AGS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=952 [entry31] id=448 operation_type=17 name=SD5AGS2 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=954 [entry32] id=449 operation_type=17 name=SD5AGS3 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=956 [entry33] id=450 operation_type=17 name=SD5GAS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=958 [entry34] id=451 operation_type=17 name=SD5GAS2 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=960 [entry35] id=819 operation_type=17 name=SD1GAS3 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=1901 [entry36] id=820 operation_type=17 name=SD2GAS3 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=1902 [entry37] id=821 operation_type=17 name=SD3GAS3 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=1903 [entry38] id=822 operation_type=17 name=SD4GAS3 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=1904 [entry39] id=823 operation_type=17 name=SD5GAS3 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=1905 [entry40] id=824 operation_type=17 name=SDMGS6 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=1913 [entry41] id=825 operation_type=17 name=SD6AGS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=1914 [entry42] id=826 operation_type=17 name=SD6AGS2 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=1915 [entry43] id=828 operation_type=17 name=SD6AGS3 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=1916 [entry44] id=829 operation_type=17 name=SD6GAS1 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=1917 [entry45] id=830 operation_type=17 name=SD6GAS2 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=1918 [entry46] id=831 operation_type=17 name=SD6GAS3 wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=1919 [entry47] id=133 operation_type=0 name=Certification Manager wip=127.0.0.1 nip=127.0.0.1 machine_manager_node_id=0  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 "192.168.1.2", 32001       Certification "192.168.1.2", 32001          LoginFailureTolerance        3                // ??´ë ·I±×AI ??½???µ? ?A·ù C??ë??     IBUVFailureTolerance        3                // ??´ë A?¹??? AI?? ?A·ù C??ë??     LoginFailureBlockTimeMin    10                // ??·° ½?°£(??) - ·I±×AI ??½???µ? ?A·ù      IBUVFailureBlockTimeMin        10                // ??·° ½?°£(??) - A?¹??? AI?? ?A·ù      AutomatedPunisher        "AutomatedPunisher"        // ??·° ???¼ A?¸§ (±â?¸ ??·°A? gm ¸?)     LoginPunishmentGuide        "Blocked for 10 minutes due to incorrect  password entered 3 times"    // ??½???µ? ?A·ù?? ´ëC? ??·° °?A?µ?     LoginPunishmentDescription    "Blocked for 10 minutes due to  incorrect password entered 3 times"    // ??½???µ? ?A·ù?? ´ëC? ??·° ¼³¸?     IBUVPunishmentGuide        "Blocked for 10 minutes due to incorrect  code entered 3 times"        // A?¹??? AI?? ?A·ù?? ´ëC? ??·° °?A?µ?     IBUVPunishmentDescription    "Blocked for 10 minutes due to  incorrect code entered 3 times"        // A?¹??? AI?? ?A·ù?? ´ëC? ??·°  ¼³¸? } GatewayServer {     LastFullVersion_SR_Client 130     Certification "192.168.1.2", 32000     IBUVQueueReserveCount        20000    // IBUV¸¦ A§C? ¹?¸® »?¼?C? ³?A» A?¹??? °¹¼?         IBUVQueuePrepareRatio        0.05    // ¾?A?µé ?¸A??? A?¹??? »?¼?C? ??A²     IBUVFailureIPTolerance        0    // C? IP´ç IBUV ½C??¸¦ C??ëC? ??´ë ?A·ù C??ë??, 0A?¸é ??·° ¾ECI°?´U´A °???.     // ??°?µE ³?A?´U!!!!!     //////////////////////////////////////////////////////////     IBUVStringSize            6     // C?±U ?³¸¯??¼A »ç?ë ½? 3, ¾E???? ?³¸¯?? ¼A¸¸ »ç?ëCI´A °??? 6 A¸·I ¼¼??C?´U.     IBUVCharacterSet        "ABCDEFGHLMNQRTabdehimn2345678"     ////////////////////////////////////////////////////////// } DownloadServer {         Certification "192.168.1.2", 32000 } FarmManager {     Certification "192.168.1.2", 32000 } AgentServer {     Certification "192.168.1.2", 32004 } MachineManager {     Certification "192.168.1.2", 32000 } SR_GameServer {     Certification "192.168.1.2", 32004     ExpRatio             100         ExpRatioParty        100            DropItemRatio       0,1         DropGoldAmountCoef   0,1             //WINTER_EVENT_2009        EVENT_ON    // 2009³â °U?ï A??¥?®     //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 "192.168.1.2", 32004     BILLING_SERVER_URL "http://192.168.1.2:8080/"     CREST_FTP_URL "ftp://id:pass@192.168.1.2/"         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 }  srGlobalService.ini [global] count=1 [entry0] operation_type=17 name=SRO_GameOn_Official query=DRIVER={SQL Server};SERVER=ELAMY-PC\ELAMY;DSN=Silkroad_ACC;DATABASE=SRO_VT_ACCOUNT global_manager_node_id=697 [/php] srShard.ini PHP Code: [global] [global] count=1 [entry0] id=64 global_operation_id=20 operation_type=17 name=KOUGA query=DRIVER={SQL Server};SERVER=ELAMY-PC\ELAMY;DSN=Silkroad_Shard;DATABASE=SRO_VT_SHARD query_log=DRIVER={SQL Server};SERVER=ELAMY-PC\ELAMY;DSN=Account_DB;DATABASE=SRO_VT_LOG capacity=2300 shard_manager_node_id=705 u1=240 u2=208 u3=17 u4=1 u5=0 u6=0 u7=0

Quote:

Originally Posted by HaGsTeR Didn't work. ^^

Quote:

Originally Posted by Gunna I dont edit ftp id and pw.How can i open ftp id and pw ? with filezilla?

Quote:

Originally Posted by rushcrush can i use any FTP server info?