[Guide] Most of vsro files problem solved here

Page 58 of 193 « First 8485657 58 596068108158 Last »
09/16/2011 03:06 nansif2#856
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
09/16/2011 03:11 .Spectre.#857
Quote:
Originally Posted by MesselyQc View Post
v


Its normal , continue opening files



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

Memory (and chinese symbol)

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


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
09/16/2011 03:12 Lupin*#858
Quote:
Originally Posted by .Spectre. View Post
your problem easy to fix ..

i need web server program for windows xp
at less tell him what to do
09/16/2011 03:13 nansif2#859
Quote:
Originally Posted by thetbot View Post
at less tell him what to do
same for me i have same error lol
09/16/2011 03:23 .Spectre.#860
do u use Edit pk2 ?
just tell me program name .
09/16/2011 03:26 nansif2#861
Quote:
Originally Posted by .Spectre. View Post
do u use Edit pk2 ?
just tell me program name .
media patcher

and i still with this error

[Only registered and activated users can see links. Click Here To Register...]
if any with team view can help me
09/16/2011 03:39 Tazdingo7#862
I have the server working but ...

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

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

What is the problem ? :S
09/16/2011 03:56 .Spectre.#863
Quote:
Originally Posted by nansif2 View Post
media patcher

and i still with this error

[Only registered and activated users can see links. Click Here To Register...]
if any with team view can help me
which port u use ?

upload ur server.cfg
09/16/2011 04:00 cardoso125874#864
what this wrong?

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

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

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

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

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

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

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

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

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

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

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

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

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:crest@5.180.13.234"
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
09/16/2011 04:03 Tazdingo7#865
Quote:
Originally Posted by cardoso125874 View Post
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 :)
09/16/2011 04:03 the_belgian#866
turn off your firewall
09/16/2011 04:04 cardoso125874#867
Quote:
Originally Posted by the_belgian View Post
turn off your firewall
my firewall this disabled
09/16/2011 04:06 btbaotrung90#868
plz hepl me
[Only registered and activated users can see links. Click Here To Register...]

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:123@192.168.0.79/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 :((
09/16/2011 04:23 Lupin*#869
hey if i used the odbc that has been released by Mitiki or something do i need to create ODBC or not anymore?
09/16/2011 05:17 Unrealx420#870
Quote:
Originally Posted by Tazdingo7 View Post
I have the server working but ...

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

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 :)
Page 58 of 193 « First 8485657 58 596068108158 Last »