hello ,,
-------------------------------------------------------------
Please Read First my ReadMe.txt in attachemnt (
)
-------------------------------------------------------------
First most problems i collect them and make small guide to make files works fine
--------------------------------------------------------------------------------------------------------
Most of problems solved here
&
--------------------------------------------------------------------------------------------------------
First problem :
who use xp or vista or 7 and need to open vsro files he will find problem (agent server and FarmManager and DownloadServer) never work and so sr shared and sr gamesserver won't work 2
Solve
(do that for all .exe in vsro files like FarmManager and DownloadServer and GateWay & soo)
right click Then
properties Then
Choose
Compatibility
In Compatibility mode
Check
Run this program in Compatibility mode For :
and choose
Windows 2000
--------------------------------------------
Secound problem :
SR_ShardManager.exe
billing dead and closed
solve
in server.cfg
PHP Code:
SR_ShardManager {
Certification "123.30.200.70", 15882
BILLING_SERVER_URL "http://123.30.200.70:8080/"
CREST_FTP_URL "ftp://sro_logo:[email protected]/"
change it to
PHP Code:
SR_ShardManager {
Certification "YourIp", 32004
BILLING_SERVER_URL "http://YourIp:80/"
CREST_FTP_URL "ftp://ID:pass@YourIp/"
ID & PASS of ur FTP server
and don't forgot
change 8080 to 80 only
or if u setup ur iss to access on port 8080 u can make it like original
or check that more info
Something will help to make files works fine
----------------------------------------------------
last error
establish ip error (writeing port 32003 and so) & MachineManger.exe problem
fix verry easy just open files in right way
* 01.Cert
* 02.GlobalManager
* 03.DownloadServer
* 04.MachineManager
* 05.GatewayServer
* 06.FarmManager
* 07.SR_ShardManager
* 08.SR_GameServer
* 09.MachineManager
* 10.AgentServer
* 11.start client
Then u can Run ur client
don't forgot to w8 while each exe loading 100% then open the next exe ...
Some error in connect with db just try to search on google for topics to learn u how to use mssql ^^
if u got DC or error why u lanch client try to open vsro client from another machine (not the machine u host vsro files on it)
------------------------------------------------
i Forgot
SK_gamebang_ip problem
PHP Code:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SK_gamebang_ip](
[nID] [smallint] NOT NULL,
[ip] [int] NOT NULL,
[capacity] [smallint] NOT NULL
) ON [PRIMARY]
GO
create this db in SRO_VT_ACCOUNT database
Another losted db
Srry Guys delete _ExistsServiceOffRentItem db and execute this new one
PHP Code:
/****** 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
and don't forgot to set vsro databases to sql server 2000 if u use mssql 2005 or 2008 or follow
------------------------------------------------
when u open SR_GameServer.exe or SR_ShardManager.exe just w8 mints while it loading 100% u will find (Cert) changes to online monitor so it's ready now and u can open the next exe file
Check
-----------------------------------------------
Fixing SMC_Independent
open ServiceManager.cfg
new port
15880
when use my Patch 1
PHP Code:
/*
*/
SMC {
DivisionManager "192.168.x.x",15880
}
ModulePatch
{
SrcPath ".\Patch_Internal"
DestPath ".\Patch_Internal_Comp"
}
and u can open SMC after open GlobalManager
ID:sro_gm1
PW:hn2006
and leave SSNumber2 empty
-----------------------------------------------------------------------------
For People who can't opening Certification Server
Open
CustomCertificationServer Folder
then (bin) folder
then open 1 - decompile.bat
when finish press enter to exit it then u will find ini folder appear to u
open ini folder
then we must edit :
srGlobalService.ini
PHP Code:
DRIVER={SQL Server};SERVER=Your MachineName\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=123456;DATABASE=SRO_VT_ACCOUNT
&
srNodeType.ini
Edit
wip=
nip=
Replace the old ip with ur machine ip like 192.168.0.1 etc ..
Last
srShard.ini
name=
Ur Server Name
PHP Code:
query=DRIVER={SQL Server};SERVER=Your MachineName\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=123456;DATABASE=SRO_VT_SHARD_INIT
PHP Code:
query_log=DRIVER={SQL Server};SERVER=Your MachineName\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=123456;DATABASE=Log_DB
capacity=
2300
DSN= (better to right database name)
now we save out work then open
2 - compile.bat
when finish press enter to exit
then open
3 - CustomCertificationServer.bat
it works fine and it's the CertificationServer
not the CustomCertificationServer.exe one
----------------------------------------------------------------
For People who Needs 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 "127.0.0.1", 32001
Certification "127.0.0.1", 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 "127.0.0.1", 32000
IBUVQueueReserveCount 20000 // IBUV¸¦ À§ÇØ ¹Ì¸® »ý¼ºÇØ ³õÀ» À̹ÌÁö °¹¼ö
IBUVQueuePrepareRatio 0.05 // ¾ÆÀ̵é ŸÀÓ¿¡ À̹ÌÁö »ý¼ºÇÒ ºñÀ²
IBUVFailureIPTolerance 0 // ÇÑ IP´ç IBUV ½ÇÆи¦ Çã¿ëÇÒ ÃÖ´ë ¿À·ù Çã¿ëÄ¡, 0ÀÌ¸é ºí·° ¾ÈÇÏ°Ú´Ù´Â °ÅÁö.
// Ãß°¡µÈ ³ÑÀÌ´Ù!!!!!
//////////////////////////////////////////////////////////
IBUVStringSize 6 // ÇÑ±Û Ä³¸¯Åͼ »ç¿ë ½Ã 3, ¾ËÆĺª ij¸¯ÅÍ ¼Â¸¸ »ç¿ëÇÏ´Â °æ¿ì 6 À¸·Î ¼¼ÆÃÇÑ´Ù.
IBUVCharacterSet "ABCDEFGHLMNQRTabdehimn2345678"
//////////////////////////////////////////////////////////
}
DownloadServer {
Certification "127.0.0.1", 32000
}
FarmManager {
Certification "127.0.0.1", 32000
}
AgentServer {
Certification "127.0.0.1", 32004
}
MachineManager {
Certification "127.0.0.1", 32000
}
SR_GameServer {
Certification "127.0.0.1", 32004
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 "127.0.0.1", 32004
BILLING_SERVER_URL "http://127.0.0.1:8080/"
CREST_FTP_URL "ftp://id:[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
}
Use that Config ,but
Just change
127.0.0.1 ips
to Your machine ip
{Some Times SR_ShardManager.exe or SR_GameServer.exe closed suddnly while they were works with out errors that's cuz of ur small RAM or prossecor}
Solve error in read and write with mssql user
-----------------------------------------------------------
------------------------------------------------------------------------------------
How To Change rates (EXP SP PT EXP GOLD DROP ITEM DROP ETC)
enter here :
------------------------------------------------------------------------------------
Some Usefull things after setup ur server
enter here:
----------------------------------------------------------------------------------------
Forgot this
-----------------------------------------------------------------------
MachineManager Problem Solved
MachineManager Patch :
Download patch and replace with old files then edit ur info (db info , ip , etc..)
and now MachineManager works fine
-------------------------------------------------------------------------------------
DC Fix
-----------------------------------------------------------------------------
ODBC errors
------------------------------------------------------------------------------------------
C++ runtime library error
SRO_VT_SHARD > _RefRegionBindAssocServer.DB open and CHINA except all 0 register
------------------------------------------------------------------------------------------
Fix Item sell bug
-------------------------------------------------------------------------------
Patch 2 Has Released
Hot Fix For CertificationServer
u can now open server with out any problem (respawn mobs or item bugs or kill unique bug or ...)
download from
don't forget to reconfig ini folder for your database info and ips
& don't forget to read (verry verry verry important READ.txt) in patch folder
Waring : u must download before use patch 2
--------------------------------------------------------------------------------
{Released/Guide} Patch 2.1(2.2) Hot Fix + new options
Release New Patch Fix what we are working on
(Vsro CertificationServer)
+ Guide how to setup files on 2 or 3 machines
First of all i made a verry hard work for that so please support me
(any problem report it & hope any coder help me!)
Now Download patch 2.1
(not musted to download the old patches)
& Download Patch 2.2
> for more servers in server list !!(add 2 more servers only ,, for more add tell me
)
----------------------------------------------------------------
Explain for Patch 2.1
download the patch and replace files
then open ini folder to config
first
open srGlobalOperation.ini and change YourMainPCName to ur machine name (main machine)
and save
next
open srGlobalService.ini and change YourMainPCName to ur machine name (main machine)
and save
next
open srNodeType.ini
PHP Code:
[entry0]
id=335
operation_type=22
name=MyMainPC
wip=192.168.0.72
nip=192.168.0.72
machine_manager_node_id=0
change MainPC to ur machine name (main machine)
then
PHP Code:
wip=yourMainMachineIP (change to your ip)
nip=yourMainMachineIP (change to your ip)
PHP Code:
[entry1]
id=336
operation_type=22
name=SecoundNamePC
wip=192.168.0.73
nip=192.168.0.73
machine_manager_node_id=700
Change SecoundNamePC to ur secound machine name (2nd machine)
then
wip=yourSecoundMachineIP
nip=yourSecoundMachineIP
PHP Code:
[entry2]
id=337
operation_type=22
name=TheirdNamePC
wip=192.168.0.74
nip=192.168.0.74
machine_manager_node_id=701
it's optinal (not musted) but musted if u have 3rd machine and need to have more 1000 slot in ur server
change TheirdNamePC to ur 3rd machine name (3nd machine)
then
wip=your3rdMachineIP
nip=your3rdMachineIP
then
save
next
open srShard.ini and change YourServerName to ur main machine name
save
warring : don't forget to change database info to ur database info..
Now open 2 - compile.bat and w8 while it succes then click enter to close it
Now replace
Server.cfg
and
schedule.cfg
with the old one ..
open Server.cfg and change all ips to your machine main IP and don't forget to reconfig your ftp info
and save
now u can open 3 - CustomCertificationServer.bat and start ur server files
Main Machine : (By this arrange)
Crest
globalmanager
downloadmanager
gatewaymanager
frammanager
sr sharedmanager
sr gameserver
agentserver
2nd Machine : (By this arrange)
Machinemanager
gatewaymanager
download manager
sr gameserver
agentserver
3rd Machine : (By this arrange) Optinal not Musted if ur slots lower than 1000
Machinemanager
sr gameserver
agentserver
Copy server files to your 2nd and 3rd machine and just open they will work normally
At Last open smc on main machine
and start service
------------------------------------------------------------
Explain for Patch 2.2 (Must read Explain for patch 2.1 first
)
Same as Patch 2.1 exept some point
in ini folder open srShard.ini
PHP Code:
[global]
count=3
[entry0]
id=64
global_operation_id=20
operation_type=22
name=YourServerName
query=DRIVER={SQL Server};SERVER=ABDELFATTAH\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=abdooo;PWD=abdo123456;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=ABDELFATTAH\SQLEXPRESS;DSN=Log_DB;UID=abdooo;PWD=abdo123456;DATABASE=Log_DB
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
[entry1]
id=65
global_operation_id=20
operation_type=22
name=YourServerName2
query=DRIVER={SQL Server};SERVER=ABDELFATTAH\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=abdooo;PWD=abdo123456;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=ABDELFATTAH\SQLEXPRESS;DSN=Log_DB;UID=abdooo;PWD=abdo123456;DATABASE=Log_DB
capacity=1000
shard_manager_node_id=706
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
[entry2]
id=66
global_operation_id=20
operation_type=22
name=YourServerName3
query=DRIVER={SQL Server};SERVER=ABDELFATTAH\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=abdooo;PWD=abdo123456;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=ABDELFATTAH\SQLEXPRESS;DSN=Log_DB;UID=abdooo;PWD=abdo123456;DATABASE=Log_DB
capacity=1000
shard_manager_node_id=707
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
change YourServerName to ur first server name and YourServerName2 to ur secound server name and YourServerName3 to ur third server name ..
then save
now open your sql manager
open database SRO_VT_ACCOUNT
in table _ShardService
make as in this pic
shard ID ServiceType
64 0
65 0
66 0
save
Now ur server is ready
Main Machine : (By this arrange)
Crest
globalmanager
downloadmanager
gatewaymanager
frammanager
sr sharedmanager
sr gameserver
agentserver
2nd Machine : (By this arrange)
Machinemanager
gatewaymanager
download manager
sr sharedmanager
sr gameserver
agentserver
3rd Machine : (By this arrange) Optinal not Musted if ur slots lower than 1000
Machinemanager
sr sharedmanager
sr gameserver
agentserver
i do my best ,, was verry hard work and hope u like it
Notic : MachineManager not work any more in Main machine (that's the right machinemanager needs only in slave machines Only)
-----------------------------------------------------------------------------------
Create Char problem :
Solve :
If ( sec_primary = 1,sec_content = 1 ) and = Account GM then Creat new character
set ur state to 0
------------------------------------------------------------------------------
FiX DEP Problem IN Windows Server 2000 ~ 2003 ~ 2008 ~ 2008 R2
(i upload pic in attachment
to protect them from loseing !)
1.jpg
open Computer properties
2.jpg
then advanced system settings
then advanced
then settings
3.jpg
select data execution prevention
select expt those (option)
click on add and add the same list u see in pic
4.jpg
when click add , browse the files place then click on open (and don't forget smc)
then click Ok & Ok >> finish
Hope that helps
------------------------------------------------------------------
---------------------------------------------------------------
-------------------------------------------------------------------
Full problems FiX here
-------------------------------------------------------------
Make ur server without hamachi if u have static ip
Thread is in update for new problems
have fun, any problem post please
![[Guide] Most of vsro files problem solved here](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/guide-most-vsro-files-problem-solved-here_ltr.gif){kind=small}
.....and that is REAL SHIT .......just ask around bro
