[Guide] Most of vsro files problem solved here

~~nansif2~~ · 09/16/2011, 03:06

can u help me with missing table

Quote:

/****** Object: StoredProcedure [dbo].[_ExistsServiceOffRentItem] Script Date: 09/13/2011 12:03:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE procedure [dbo].[_ExistsServiceOffRentItem]
as

if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
begin
return -1
end

GO

i think because this i have error

.Spectre. · 09/16/2011, 03:11

Quote:

Originally Posted by MesselyQc

v

Its normal , continue opening files

Yes everything is working but , when I lauch my Silkroad.exe , it say

Memory (and chinese symbol)

Image:

Do I need to use the same IP as my Global manager ? Wich IP do I need to use and wich port ?

your problem easy to fix ..

i need web server program for windows xp

Lupin* · 09/16/2011, 03:12

Quote:

Originally Posted by .Spectre.

your problem easy to fix ..

i need web server program for windows xp

at less tell him what to do

~~nansif2~~ · 09/16/2011, 03:13

Quote:

Originally Posted by thetbot

at less tell him what to do

same for me i have same error lol

.Spectre. · 09/16/2011, 03:23

do u use Edit pk2 ?
just tell me program name .

~~nansif2~~ · 09/16/2011, 03:26

Quote:

Originally Posted by .Spectre.

do u use Edit pk2 ?
just tell me program name .

media patcher

and i still with this error

if any with team view can help me

Tazdingo7 · 09/16/2011, 03:39

I have the server working but ...

I cant conect via loader or launcher , i tried ports 15778,15779 and 32002.

What is the problem ? :S

.Spectre. · 09/16/2011, 03:56

Quote:

Originally Posted by nansif2

media patcher

and i still with this error

if any with team view can help me

which port u use ?

upload ur server.cfg

cardoso125874 · 09/16/2011, 04:00

what this wrong?

srGlobalService

[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=TEST-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=saveir ogti;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697

srShard

[global]
count=1
[entry0]
id=99
global_operation_id=20
operation_type=22
name=Test
query=DRIVER={SQL Server};SERVER=TEST-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=saveirog ti;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=TEST-PC\SQLEXPRESS;DSN=SRO_VT_LOG;UID=sa;PWD=saveirogti ;DATABASE=SRO_VT_LOG
capacity=300
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0

srNodeType

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

server.cfg

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.180.13.234", 32000
LoginFailureTolerance 3
IBUVFailureTolerance 3
LoginFailureBlockTimeMin 0
IBUVFailureBlockTimeMin 0
AutomatedPunisher "AutomatedPunisher"
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.180.13.234", 15880
IBUVQueueReserveCount 20000
IBUVQueuePrepareRatio 0.10
IBUVFailureIPTolerance 0
IBUVStringSize 1
IBUVCharacterSet "ABCDEF1234567890"
}

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

AgentServer {
Certification "5.180.13.234", 15882 //no global manager running lol
//traffic_filter_activity "service_off"
//MaxUser 5000
//SockTCPCount 15000
MaxConnectionsPerServer "5000"
MaxConnectionsPer1_OServer "5000"
}

MachineManager {
Certification "5.180.13.234", 15880
CERTIFICATION_IP_BIND "5.180.13.234"
}

SR_GameServer {
Certification "5.180.13.234", 15882
SockTCPCount "5000"
ExpRatio "35000"
ExpRatioParty "35000"
DropItemRatio "5000"
DropGoldAmountCoef "15000"
HwanGainFactor "250"
ShowFormulaDetail "1"

//WINTER_EVENT_2009 EVENT_ON
//EUBUSINESS_EVENT EVENT_ON
//GOLDEN_PIG_FEBRUARY_EVENT EVENT_ON
//THANKS_GIVING_EVENT EVENT_ON
//LIBERATION_EVENT EVENT_ON
LOCALE LOCALE_VIETNAM

//#ifdef OPEN_MARKET_SYSTEM
SET_FEE_RATE "0,5,5,5"
SELL_FEE_RATE "0,10,10,10"
//#endif OPEN_MARKET_SYSTEM
//RE FTW

DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL "OFF"
ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED "OFF"

}

SR_ShardManager {
Certification "5.180.13.234", 15882
BILLING_SERVER_URL "http://5.180.13.234:8080/"
CREST_FTP_URL "ftp://crest:[email protected]"
ChristmasEvent2007 1
SERVER_EVENT_SYSTEM ON
LOCALE LOCALE_VIETNAM
FlagEvent 1
//HourForMeterRateLevelFirst 24
//HourForMeterRateLevelSecond 0

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

when i try login with ip of hamashi client say server off
and with ip 127.0.0.1 got c9
Port: 15779

Tazdingo7 · 09/16/2011, 04:03

Quote:

Originally Posted by cardoso125874

what this wrong?

when i try login with ip of hamashi client say server off
and with ip 127.0.0.1 got c9

Same as me :S , if you can fix it please share the solution

the_belgian · 09/16/2011, 04:03

turn off your firewall

cardoso125874 · 09/16/2011, 04:04

Quote:

Originally Posted by the_belgian

turn off your firewall

my firewall this disabled

btbaotrung90 · 09/16/2011, 04:06

plz hepl me

my Server.cfg

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.0.79", 32001
		LoginFailureTolerance		3
		IBUVFailureTolerance		3
		LoginFailureBlockTimeMin	10
		IBUVFailureBlockTimeMin		10
		AutomatedPunisher			"AutomatedPunisher"
		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.0.79", 32000
		IBUVQueueReserveCount		20000
		IBUVQueuePrepareRatio		0.05
		IBUVFailureIPTolerance		0
		IBUVStringSize				5
		IBUVCharacterSet			"ABCDEF1234567890"
	}
	DownloadServer {
		Certification 				"192.168.0.79", 32000
	}
	FarmManager {
		Certification 				"192.168.0.79", 32000 
	}
	MachineManager {
		Certification 				"192.168.0.79", 32000
	}
	AgentServer {
		Certification 				"192.168.0.79", 32004
	}
	SR_GameServer {
		Certification 				"192.168.0.79", 32004
		ExpRatio             		500
		ExpRatioParty        		500
		DropItemRatio       		0,5
		DropGoldAmountCoef   		0,5	
		LOCALE 						LOCALE_VIETNAM
		SET_FEE_RATE           		"0,5,5,5"
		SELL_FEE_RATE           	"0,10,10,10"
		//#ifdef OPEN_MARKET_SYSTEM
		//#endif OPEN_MARKET_SYSTEM
		//WINTER_EVENT_2009			EVENT_ON
		//EUBUSINESS_EVENT			EVENT_ON
		//GOLDEN_PIG_FEBRUARY_EVENT	EVENT_ON Open all file
		//THANKS_GIVING_EVENT		EVENT_ON
		//LIBERATION_EVENT			EVENT_ON
	}
	SR_ShardManager {
		Certification 				"192.168.0.79", 32004
		BILLING_SERVER_URL 			"http://192.168.0.79:80/"
		CREST_FTP_URL 				"ftp://bt90:[email protected]/Crest"
		ExtraExpRatio				0.1
		ChristmasEvent2007 			0
		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
		//SERVER_EVENT_SYSTEM		ON
	}
}

and when run SMC, CPU emits sound pip pip

(

Lupin* · 09/16/2011, 04:23

hey if i used the odbc that has been released by Mitiki or something do i need to create ODBC or not anymore?

Unrealx420 · 09/16/2011, 05:17

Quote:

Originally Posted by Tazdingo7

I have the server working but ...

I cant conect via loader or launcher , i tried ports 15778,15779 and 32002.

What is the problem ? :S

I have this same problem as well, I am not sure what this is but im sure its something simple.. if anybody has a solution for this please tell