[Guide] Most of vsro files problem solved here

ByMnkn · 09/17/2011, 04:01

Quote:

0042714C F6C4 50 TEST AH,42
Party experience ratio

PHP Code:
004271F5 F6C4 42 TEST AH,42
Item drop rate

PHP Code:
004272A0 F6C4 42 TEST AH,42
Gold drop amount rate

PHP Code:
00427349 F6C4 42 TEST AH,42
HWLAN (berserker) gain factor

PHP Code:
004273CA |. F6C4 44 TEST AH,42
To do it, follow this screenshots. Open the file using OllyDBG (F3)

Do same for all addresses.

I do not understand?

Dr.Abdelfattah · 09/17/2011, 04:10

Writed By

So, some people might have problems even at such basic stuff as cracking a experience limit.

Gameserver reads rates as (real rate * 1000), it means, if you set rates to
35000, experience gain coefficent will be 35x. By default, gameserver forbidds making them more than 250 (2.5 x), but it's easy to crack.

So, open your SR_GameServer executable using OllyDBG, and patch the following addresses with following assembly codes.

================================================== ===========================
Individual experience ratio

PHP Code:


			
0042714C   F6C4 50          TEST AH,42

================================================== ===========================
Party experience ratio

PHP Code:


			
004271F5   F6C4 42          TEST AH,42

================================================== ===========================
Item drop rate

PHP Code:


			
004272A0   F6C4 42          TEST AH,42

================================================== ===========================
Gold drop amount rate

PHP Code:


			
00427349   F6C4 42          TEST AH,42

================================================== ===========================
HWLAN (berserker) gain factor

PHP Code:


			
004273CA  |. F6C4 44        TEST AH,42

================================================== ===========================
Bypass creation of huge .dmp files (less lags)

PHP Code:


			
00964060     81EC 6C060000  SUB ESP,66C

change command to

PHP Code:


			
jmp 009642FD

================================================== ===========================

To do it, follow this screenshots. Open the file using OllyDBG (F3)

Double-click the line you were jumped to, and...

Do same for all addresses.
-------------------------------------------------------------------

Quote:

Originally Posted by ByMnkn

I do not understand?

download OllyDBG
then open by OllyDBG SR_GameServer.exe
then do what in the post

tmfpkendrick21 · 09/17/2011, 04:12

everytime i open smc_independent it closes, already did all the inis and configs right so i know its not that.

i type in sro_gm1:hn2006 then it comes up says smc_independent stopped working

Dr.Abdelfattah · 09/17/2011, 04:17

Quote:

Originally Posted by tmfpkendrick21

everytime i open smc_independent it closes, already did all the inis and configs right so i know its not that.

i type in sro_gm1:hn2006 then it comes up says smc_independent stopped working

need screenshout

~~rushcrush~~ · 09/17/2011, 04:18

so anyone know the fix of this error? -.-
iam using dedi server and ports already opend
so when i try to click start on the luancher i get this error(iam using 15779 port)
so why i get this error?

the_belgian · 09/17/2011, 04:19

I have same error you using bsro client right?

Dr.Abdelfattah · 09/17/2011, 04:22

Quote:

Originally Posted by rushcrush

so anyone know the fix of this error? -.-
iam using dedi server and ports already opend
so when i try to click start on the luancher i get this error(iam using 15779 port)
so why i get this error?

what media pk2 u use in vsro client ?

Quote:

Originally Posted by the_belgian

I have same error you using bsro client right?

use bsro client with old media not the new one

~~rushcrush~~ · 09/17/2011, 04:26

Quote:

Originally Posted by abdelfattah

what media pk2 u use in vsro client ?

using classonline sro media.pk2

Dr.Abdelfattah · 09/17/2011, 04:28

Quote:

Originally Posted by rushcrush

using classonline sro media.pk2

try to use old bloodysro media (don't forget old one)

~~rushcrush~~ · 09/17/2011, 04:46

Quote:

Originally Posted by abdelfattah

try to use old bloodysro media (don't forget old one)

well yeah i have the first client of bsro with the bugged mastry up media.pk2
that's the right one?
Edit: or 2908Media?

Tazdingo7 · 09/17/2011, 04:46

Quote:

Originally Posted by abdelfattah

try to use old bloodysro media (don't forget old one)

Share links please.

New client + Old media ?

I have old client + old media = c9

Dr.Abdelfattah · 09/17/2011, 04:52

Use this query to clean out old data from VT_ACCOUNT tables.

PHP Code:


			
USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SilkGoods]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_paygate_trans]

If you need to create your own GM account:

PHP Code:


			
1. You need a md5 hasher. (can google it)
2. Go to TB_Users table
3. Fill the form like this:

    JID: Fills automatically
    StrUserID: Username
    password: password
    status: can leave blank
    GMRank: Set this to 1 (Server Dev) 2 (content administrator) 3 (content user) 4 (content marketer) 5 (content monitor) 6 (Content GM) 7 (content GM Leader)
    sec_primary - set it to 1 (3 is normal user)
    sec_content - set it to 1 (3 is normal user)


4. You can fill in the other neccesary fields like email, adress so on, but they're not really neccesary.

This will clean up Log database instantly.

PHP Code:


			
USE [SRO_VT_LOG]
GO
TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent]

Use this to prune all old character data from shard.

PHP Code:


			
//..basically you need to delete these manually.

~~rushcrush~~ · 09/17/2011, 04:54

Quote:

Originally Posted by abdelfattah

Use this query to clean out old data from VT_ACCOUNT tables.

PHP Code:

USE [SRO_VT_ACCOUNT] GO TRUNCATE TABLE [dbo].[TB_User] TRUNCATE TABLE [dbo].[TB_User_Bak] TRUNCATE TABLE [dbo].[SK_CharRenameLog] TRUNCATE TABLE [dbo].[_Punishment] TRUNCATE TABLE [dbo].[_ServiceManagerLog] TRUNCATE TABLE [dbo].[Test_HN] TRUNCATE TABLE [dbo].[_BlockedUser] TRUNCATE TABLE [dbo].[_CasGMChatLog] TRUNCATE TABLE [dbo].[_Notice] TRUNCATE TABLE [dbo].[_SMCLog] TRUNCATE TABLE [dbo].[QuaySoEpoint] TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog] TRUNCATE TABLE [dbo].[SK_ItemSaleLog] TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog] TRUNCATE TABLE [dbo].[SK_PK_UpdateLog] TRUNCATE TABLE [dbo].[SK_ResetSkillLog] TRUNCATE TABLE [dbo].[SK_Silk] TRUNCATE TABLE [dbo].[SK_SilkBuyList] TRUNCATE TABLE [dbo].[SK_SilkGoods] TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS] TRUNCATE TABLE [dbo].[SR_ShardCharNames] TRUNCATE TABLE [dbo].[TB_Net2e] TRUNCATE TABLE [dbo].[TB_Net2e_Bak] TRUNCATE TABLE [dbo].[tb_paygate_trans]

If you need to create your own GM account:

PHP Code:

1. You need a md5 hasher. (can google it) 2. Go to TB_Users table 3. Fill the form like this: JID: Fills automatically StrUserID: Username password: password status: can leave blank GMRank: Set this to 1 (Server Dev) 2 (content administrator) 3 (content user) 4 (content marketer) 5 (content monitor) 6 (Content GM) 7 (content GM Leader) sec_primary - set it to 1 (3 is normal user) sec_content - set it to 1 (3 is normal user) 4. You can fill in the other neccesary fields like email, adress so on, but they're not really neccesary.

This will clean up Log database instantly.

PHP Code:

USE [SRO_VT_LOG] GO TRUNCATE TABLE [dbo].[_LogCashItem] TRUNCATE TABLE [dbo].[_LogEventChar] TRUNCATE TABLE [dbo].[_LogEventItem] TRUNCATE TABLE [dbo].[_LogEventSiegeFortress] TRUNCATE TABLE [dbo].[_LogSchedule] TRUNCATE TABLE [dbo].[_LogServerEvent]

Use this to prune all old character data from shard.

PHP Code:

//..basically you need to delete these manually.

sorry but what this will do with my problem? ^^

Tazdingo7 · 09/17/2011, 05:00

Same here

Cant connect to the server via loader or via launcher.

I try already with ports 15779,15778 and 32002 (32002 said in the ini file).

I tried patching the media with media patchers and hex editor and nathing works. Always i get that error in me pc or in another pc.

srNodeData.ini

PHP 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=32002
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

srShard.ini

PHP Code:


			
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=Test
query=DRIVER={SQL Server};SERVER=.\SQLExpress;DSN=SRO_VT_SHARD_INIT;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=.\SQLExpress;DSN=Log_DB;DATABASE=Log_DB
capacity=300
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0

srNodeType.ini

PHP Code:


			
[global]
count=1
[entry0]
id=335
operation_type=22
name=SRO Vietnam TestLocal
wip=192.168.1.101
nip=192.168.1.101
machine_manager_node_id=699

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.101", 32001
    Certification "192.168.1.101", 32000
    
    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 "192.168.1.101", 15880
    IBUVQueueReserveCount        20000    // IBUV¸¦ À§ÇØ ¹Ì¸® »ý¼ºÇØ ³õÀ» ÀÌ¹ÌÁö °¹¼ö    
    IBUVQueuePrepareRatio        0.05    // ¾ÆÀÌµé Å¸ÀÓ¿¡ ÀÌ¹ÌÁö »ý¼ºÇÒ ºñÀ²
    IBUVFailureIPTolerance        0    // ÇÑ IP´ç IBUV ½ÇÆÐ¸¦ Çã¿ëÇÒ ÃÖ´ë ¿À·ù Çã¿ëÄ¡, 0ÀÌ¸é ºí·° ¾ÈÇÏ°Ú´Ù´Â °ÅÁö.

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

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

AgentServer {
    Certification "192.168.1.101", 15882
}

MachineManager {
    Certification "192.168.1.101", 15880
}

SR_GameServer {
    Certification "192.168.1.101", 15882

    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 "192.168.1.101", 15882
    BILLING_SERVER_URL "http://192.168.1.101:8080/"
    CREST_FTP_URL "ftp://crest:[email protected]/SRO_CREST"
        ExtraExpRatio        0.1
        ChristmasEvent2007 0
    //SERVER_EVENT_SYSTEM             OFF
       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
}

All me ini files :

What im doing wrong ?

I try too with patch of abdel but didnt work, sad u.u

ByMnkn · 09/17/2011, 05:00

Uniq Kill and not kill notice ?