[Guide] Most of vsro files problem solved here

Page 87 of 193 « First 37778586 87 888997137187 Last »
09/17/2011 19:33 cardoso125874#1291
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?
[Only registered and activated users can see links. Click Here To Register...]
09/17/2011 19:39 tegadil#1292
Quote:
Originally Posted by catafx View Post
[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

help connect for 2 min and help me DC
yes i have same error please help us
09/17/2011 19:40 ger580#1293
Quote:
Originally Posted by abdelfattah View Post
---------------------------------------------------------------
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"
09/17/2011 19:43 rushcrush#1294
Quote:
Originally Posted by tegadil View Post
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;" 
09/17/2011 19:56 octage#1295
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 shit.... I guess I should check the DB... can someone give me any tip?
Cheers...
09/17/2011 19:59 catafx#1296
Quote:
Originally Posted by rushcrush View Post
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

%>
09/17/2011 20:28 ger580#1297
@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?
09/17/2011 20:40 Ferpa_#1298
Quote:
Originally Posted by Gundalf313 View Post
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
open the 3- CustomCertification.bat
and change the port of GlobalManager from 32001 to 32000
09/17/2011 20:51 Lupin*#1299
ERROR #1 : [Only registered and activated users can see links. Click Here To Register...]

ERROR #2 : [Only registered and activated users can see links. Click Here To Register...]

i checked everything and i can not find the problem in my configs any idea
09/17/2011 20:52 ✗EpicSoul✗#1300
can anybody give me the _PrivilegedIP new query ??
09/17/2011 21:20 ger580#1301
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?
09/17/2011 21:23 Lupin*#1302
Quote:
Originally Posted by ✗EpicSoul✗ View Post
can anybody give me the _PrivilegedIP new query ??
check on the Guide Server posted by abdel there is the query
09/17/2011 21:28 pezant#1303
Quote:
Originally Posted by ✗EpicSoul✗ View Post
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')
09/17/2011 21:38 Lupin*#1304
can someone please could help me i tried everything and i still get this godamn error:(


ERROR #1 : [Only registered and activated users can see links. Click Here To Register...]

ERROR #2 : [Only registered and activated users can see links. Click Here To Register...]

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 : [Only registered and activated users can see links. Click Here To Register...]
09/17/2011 21:49 muhkuhdeluxe#1305
Ive got this error:
[Only registered and activated users can see links. Click Here To Register...]
Page 87 of 193 « First 37778586 87 888997137187 Last »