[Guide] Most of vsro files problem solved here

cardoso125874 · 09/17/2011, 19:33

hey why i cant change ip of my cert?

i put other in ini and server.cfg files but when i open global manager start other ip?

why no change?

tegadil · 09/17/2011, 19:39

Quote:

Originally Posted by catafx

help connect for 2 min and help me DC

yes i have same error please help us

ger580 · 09/17/2011, 19:40

Quote:

Originally Posted by abdelfattah

---------------------------------------------------------------
chernobyl write :

So, since vsro has such a "nice" thing like green/red/black books, i've made a simple solution for this, temporary, through.

So, You have to open your GlobalManager.exe, and search for this HEX code

PHP Code:

7570646174652054425F555345522073657420416363506C617954696D65

Which means

PHP Code:

update TB_USER set AccPlayTime

Now just change AccPlayTime part to a some another name, for example, OnlineTime. After you are done, save the file, and open sql server management studio, open SRO_VT_ACCOUNT database, TB_User table, set all AccPlayTime field values to 0, and create a new column named "OnlineTime" (int).

Simple as that, but not the best solution. Users will have to relogin in order to be able to gain experience once green book appears (it will just reset).

You can use nearly any hex editor for this. I'd preffer Hex Workshop, or XVI32.

create a new column named "OnlineTime" (int).

How? sry with sro i use MSSQL 2005 for the first time before i worked a little bit with wit Mysql

AND after the create of OnlinteTime Change value to 0? or "NULL"

~~rushcrush~~ · 09/17/2011, 19:43

Quote:

Originally Posted by tegadil

yes i have same error please help us

Check your DBConnect.asp in wwwroot Folder
it must be like this

PHP Code:


			
"Provider=SQLOLEDB;Data Source=-pc name\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=username;password=password;"

octage · 09/17/2011, 19:56

I've set up the server everithing is working..... just one problem.... I can't telport to Downhang... all the downhang areea and tarim basim is unnaccesible iven with reverse scroll or any other ****.... I guess I should check the DB... can someone give me any tip?
Cheers...

catafx · 09/17/2011, 19:59

Quote:

Originally Posted by rushcrush

Check your DBConnect.asp in wwwroot Folder
it must be like this

PHP Code:

"Provider=SQLOLEDB;Data Source=-pc name\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=username;password=password;"

mi DBconnect.asp

<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=SERVIDOR-PC\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=12345;"
DBConnA.Open strConnectA

%>

ger580 · 09/17/2011, 20:28

@abdelfattah

I tested this

ALTER TABLE dbo.TB_User
ADD OnlineTime varchar(int);

And This

ALTER TABLE dbo.TB_User
ADD OnlineTime (int);

But doesnt work where is my Fail?

Ferpa_ · 09/17/2011, 20:40

Quote:

Originally Posted by Gundalf313

Looked there but i dont know what to search.
And when i wait after every .exe file i still have the same problem.
And what does that "request server certification" means?

server.cfg

Spoiler

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

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

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

AgentServer {
Certification "5.207.95.127", 32000
}

MachineManager {
Certification "5.207.95.127", 32000
}

SR_GameServer {
Certification "5.207.95.127", 32000

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.207.95.127", 32000
BILLING_SERVER_URL "http://5.207.95.127:80/"
CREST_FTP_URL "ftp://sa:[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
}

open the 3- CustomCertification.bat
and change the port of GlobalManager from 32001 to 32000

Lupin* · 09/17/2011, 20:51

ERROR #1 :

ERROR #2 :

i checked everything and i can not find the problem in my configs any idea

✗EpicSoul✗ · 09/17/2011, 20:52

can anybody give me the _PrivilegedIP new query ??

ger580 · 09/17/2011, 21:20

Can anyone help me pls?

I tested this

ALTER TABLE dbo.TB_User
ADD OnlineTime varchar(int);

And This

ALTER TABLE dbo.TB_User
ADD OnlineTime (int);

But doesnt work where is my Fail?

Lupin* · 09/17/2011, 21:23

Quote:

Originally Posted by ✗EpicSoul✗

can anybody give me the _PrivilegedIP new query ??

check on the Guide Server posted by abdel there is the query

pezant · 09/17/2011, 21:28

Quote:

Originally Posted by ✗EpicSoul✗

can anybody give me the _PrivilegedIP new query ??

I assume you mean the query that you would run after you cleared out the old data with:

Code:

USE [SRO_VT_ACCOUNT]
GO
/****** Object:  Table [dbo].[_PrivilegedIP]    Script Date: 09/13/2011 08:35:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
drop table _PrivilegedIP
CREATE TABLE [dbo].[_PrivilegedIP](
    [IP1] [tinyint] NOT NULL,
    [IP2] [tinyint] NOT NULL,
    [IP3] [tinyint] NOT NULL,
    [IP4] [tinyint] NOT NULL,
    [IP5] [tinyint] NOT NULL,
    [IP6] [tinyint] NOT NULL,
    [IP7] [tinyint] NOT NULL,
    [IP8] [tinyint] NOT NULL
) ON [PRIMARY]
GO

Code:

Insert into _PrivilegedIP
Values ('#', '#', '#', '#', '#', '#', '#', '#')

Replace the # with the IP range.
Example:
Values ('192', '168', '1', '1', '192', '168', '1', '255')

Lupin* · 09/17/2011, 21:38

can someone please could help me i tried everything and i still get this godamn error

ERROR #1 :

ERROR #2 :

i checked everything and i can not find the problem in my configs

11-09-17 12:29:31 [GlobalManager] server cord established : 1 (192.168.1.101:32000)
2011-09-17 12:29:31 [GlobalManager] GlobalManager is initialized successfully
2011-09-17 12:29:34 [GlobalManager] server cord established : 2 (192.168.1.101:51157)
2011-09-17 12:29:35 IBUV: StringSize: 1, CharSet: ABCDEF1234567890
2011-09-17 12:29:35 IBUV: CharSet(ABCDEF1234567890)
2011-09-17 12:29:35 IBUV: Preserved image created : (dwImageCount)
2011-09-17 12:29:50 [GlobalManager] server cord established : 3 (192.168.1.101:51158)
2011-09-17 12:29:55 [GlobalManager] server cord established : 4 (192.168.1.101:51159)
2011-09-17 12:30:03 [GlobalManager] server cord established : 5 (192.168.1.101:51160)
2011-09-17 12:30:03 [FarmManager] server cord established : 1 (192.168.1.101:15880)
2011-09-17 12:30:03 [FarmManager] FarmManager is initialized successfully
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [FarmManager] server cord established : 2 (192.168.1.101:51161)
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-17 12:30:09 [SR_ShardManager] server cord established : 1 (192.168.1.101:15882)
2011-09-17 12:30:20 [SR_ShardManager] Query Error!!! Query Result : -1, Query : SELECT AssociationCodeName,Reputation,PriorOccupation FROM _AssociationReputation WHERE AssociationCodeName = 'TraderHunter' and AssociationTypeName = 'TEMPLE_ANUBIS'
2011-09-17 12:30:20 [SR_ShardManager] SQL Error State:42000, Native Error Code: AD7, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The code page 949 is not supported by the server.

2011-09-17 12:30:20 [SR_ShardManager] SELECT AssociationCodeName,Reputation,PriorOccupation FROM _AssociationReputation WHERE AssociationCodeName = 'TraderHunter' and AssociationTypeName = 'TEMPLE_ANUBIS'
2011-09-17 12:30:20 [SR_ShardManager] SQL Error State:42000, Native Error Code: 4231, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared.
2011-09-17 12:30:20 [SR_ShardManager] SELECT AssociationCodeName,Reputation,PriorOccupation FROM _AssociationReputation WHERE AssociationCodeName = 'TraderHunter' and AssociationTypeName = 'TEMPLE_ANUBIS'
2011-09-17 12:30:35 [FarmManager] server cord established : 3 (192.168.1.101:51162)
2011-09-17 12:30:35 [SR_GameServer] server cord established : 1 (192.168.1.101:15882)
2011-09-17 12:30:37 [SR_ShardManager] server cord established : 2 (192.168.1.101:51163)
2011-09-17 12:30:37 [SR_GameServer] server cord established : 2 (192.168.1.101:15883)
2011-09-17 12:30:55 [SR_ShardManager] OnExit() Called
2011-09-17 12:30:55 [FarmManager] server cord closed : 2
2011-09-17 12:30:56 [SR_GameServer] OnExit() Called
2011-09-17 12:30:56 [FarmManager] server cord closed : 3
2011-09-17 12:30:57 [GlobalManager] server cord closed : 5
2011-09-17 12:30:57 [GlobalManager] server cord closed : 3
2011-09-17 12:30:58 [GlobalManager] server cord closed : 2
2011-09-17 12:31:02 [GlobalManager] server cord closed : 4

srShard.ini

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=Test
query=DRIVER={SQL Server};SERVER=XERTOSRO\SQLEXPRESS;DSN=SRO_VT_SHAR D;UID=sa;PWD=1234;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=XERTOSRO\SQLEXPRESS;DSN=SRO_VT_LOG; UID=sa;PWD=1234;DATABASE=SRO_VT_LOG
capacity=50
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0

ODBC :

muhkuhdeluxe · 09/17/2011, 21:49

Ive got this error: