[Guide] Most of vsro files problem solved here

Quote:

Originally Posted by tancau1 I have this error ! I have read 100 pages, i did all kind of thinks, i make the certification again server. cfg again... In the Global Manager wont connect to DB ! My Error :[Only registered and activated users can see links. Click Here To Register...] My configuration : srGlobalService : Code: [global] count=1 [entry0] operation_type=17 name=SRO_GameOn_Official query=DRIVER={SQL Server};ADMIN-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=123456;DATABASE=SRO_VT_ACCOUNT global_manager_node_id=697 srNodeType: Code: [global] count=8 [entry0] id=335 operation_type=17 name=GMGS wip=5.29.28.68 nip=5.29.28.68 machine_manager_node_id=0 [entry1] id=336 operation_type=17 name=DN1 wip=5.29.28.68 nip=5.29.28.68 machine_manager_node_id=701 [entry2] id=338 operation_type=17 name=GWS1 wip=5.29.28.68 nip=5.29.28.68 machine_manager_node_id=699 [entry3] id=339 operation_type=17 name=FMGS1 wip=5.29.28.68 nip=5.29.28.68 machine_manager_node_id=0 [entry4] id=340 operation_type=17 name=SDMGS1 wip=5.29.28.68 nip=5.29.28.68 machine_manager_node_id=706 [entry5] id=341 operation_type=17 name=SD1AGS1 wip=5.29.28.68 nip=5.29.28.68 machine_manager_node_id=708 [entry6] id=344 operation_type=17 name=SD1GAS1 wip=5.29.28.68 nip=5.29.28.68 machine_manager_node_id=714 [entry7] id=133 operation_type=0 name=Certification Manager wip=5.29.28.68 nip=5.29.28.68 machine_manager_node_id=0 srShard: Code: [global] count=1 [entry0] id=64 global_operation_id=20 operation_type=17 name=KOUGA query=DRIVER={SQL Server};SERVER=ADMIN-PC\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=123456;DATABASE=SRO_VT_SHARD_INIT query_log=DRIVER={SQL Server};ADMIN-PC\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=123456;DATABASE=Log_DB capacity=2300 shard_manager_node_id=705 u1=240 u2=208 u3=17 u4=1 u5=0 u6=0 u7=0 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 "5.29.28.68", 32001 Certification "5.29.28.68", 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.29.28.68", 32000 IBUVQueueReserveCount 20000 // IBUV¸¦ À§ÇØ ¹Ì¸® »ý¼ºÇØ ³õÀ» À̹ÌÁö °¹¼ö IBUVQueuePrepareRatio 0.05 // ¾ÆÀ̵é ŸÀÓ¿¡ À̹ÌÁö »ý¼ºÇÒ ºñÀ² IBUVFailureIPTolerance 0 // ÇÑ IP´ç IBUV ½ÇÆи¦ Çã¿ëÇÒ ÃÖ´ë ¿À·ù Çã¿ëÄ¡, 0ÀÌ¸é ºí·° ¾ÈÇÏ°Ú´Ù´Â °ÅÁö. // Ãß°¡µÈ ³ÑÀÌ´Ù!!!!! ////////////////////////////////////////////////////////// IBUVStringSize 6 // ÇÑ±Û Ä³¸¯Åͼ »ç¿ë ½Ã 3, ¾ËÆĺª ij¸¯ÅÍ ¼Â¸¸ »ç¿ëÇÏ´Â °æ¿ì 6 À¸·Î ¼¼ÆÃÇÑ´Ù. IBUVCharacterSet "ABCDEFGHLMNQRTabdehimn2345678" ////////////////////////////////////////////////////////// } DownloadServer { Certification "5.29.28.68", 32000 } FarmManager { Certification "5.29.28.68", 32000 } AgentServer { Certification "5.29.28.68", 32004 } MachineManager { Certification "5.29.28.68", 32000 } SR_GameServer { Certification "5.29.28.68", 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 "5.29.28.68", 32004 BILLING_SERVER_URL "http://5.29.28.68:8080/" CREST_FTP_URL "ftp://sergyu:123456@5.29.28.68/" 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 } Can anyone help me ? Thanks !

use this code and test

[global]
count=1
[entry0]
operation_type=17
name=SRO_GameOn_Official
query=DRIVER={SQL Server};SERVER=ADMIN-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=123456 ;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697

How to fix C9 Error at Login?

Hey..
I have little Problems with my server anyone can help me via Team Viewer?

Yok Arkadaşım bugu bulup ayrılanlardan olmicam ben işte buda bu foruma olan borcumdur.. Serveri burdaki arkadaşlar sayesinde kurdum her zamans öyledim toplamda 4 post attım zaten neden az çünkü ben formu okumaya başladığımda zaten item bugundaydı herkes 3 post sizi yakalayana kadar geçti son noktayıda ben koyuyorum inş zaten problemde sadece bir noktadan kaynaklanıyomuş meğerse

anlatıma geçelim problemli olan prosedürün ismini veriyorum _STRG_DEL_ITEM_NoTX buraya nerden ulaşırız derseniz

SRO_VT_SHARD_INIT/Programmability/stored procedures/_STRG_DEL_ITEM_NoTX yol bu

Prosedürün içine girdiğimizde (Sağ tık Modify yaparak )

aşağıdaki bloğu resimde bulun ve mavi ile göstediğim yere dikkat edin

if (@DelFromPC_Inv = 1)
select @ItemToDel = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot
else if ( @DelFromPC_Inv = 2 )
select @itemToDel = ItemID FROM _InventoryForLinkedStorage WHERE LinkedItemID = @CharID AND Slot = @Slot
else
select @ItemToDel = ItemID FROM _InvCOS WHERE COSID = @CharID AND Slot = @Slot
Resmi Orjinal Boyutunda Görüntülemek İçin Buraya Tıklayın 1024x819px.


diğer @ItemToDel değişkenlerinden farklı olarak bu küçük i kullanılmış aslında editörde zaten uyarı vermiş altında hatalı yazım olduğuna dair kırmızı çizgi var yapacağımız iş bu @itemToDel değişkeni @ItemToDel arkadaşlar yaklaşık 1 saatte yaptım ben sql bilgim olmadığı için belki çok kolay bi yolu da vardır bi çoğunuz biliyodurda belki ben size mantığını verdim benim yapma şeklim şöyle oldu

1 _STRG_DEL_ITEM_NoTX procedürnü tamamen sildim
2 SRO_VT_SHARD_INIT mause sağ tuş a basarak New Query çıkan editöre aşağıdaki kodları yapışıtın ve exucute yapın herkese kolay gelsin umarım faydamız olmuştur. Teşekküre gerek yok ama oldu ve ya olmadı die bilgi verirseniz sevinirim...


USE [SRO_VT_SHARD_INIT]
GO
/****** Object: StoredProcedure [dbo].[_STRG_DEL_ITEM_NoTX] Script Date: 09/24/2011 16:29:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO





CREATE PROCEDURE [dbo].[_STRG_DEL_ITEM_NoTX]
@DelFromPC_Inv AS TINYINT,
@CharID AS BIGINT, -- ¸ÅÁ÷ Å¥ºê Ãß°¡·Î ÀÎÇØ È®Àå
@Slot AS TINYINT

as
declare @Rvalue int
declare @ItemToDel bigint

if (@DelFromPC_Inv = 1)
select @ItemToDel = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot
else if ( @DelFromPC_Inv = 2 )
select @itemToDel = ItemID FROM _InventoryForLinkedStorage WHERE LinkedItemID = @CharID AND Slot = @Slot
else
select @ItemToDel = ItemID FROM _InvCOS WHERE COSID = @CharID AND Slot = @Slot

if (@ItemToDel IS NULL or @ItemToDel = 0)
return -1

----------------------------------------
-- Á¹¶ó ÀÌ ¾Æ·¡ÂÊ ¼øÀüÈ÷ Æê ¼Òȯ¾ÆÀÌÅÛ ¶§¹®¿¡
-- µé¾î°£ ÄÚµåÀÌ´Ù. ºÐ¸í overheadÀ̱ä ÇÏÁö¸¸
-- _STRG_DEL_ITEM ÀÇ ½Å·Úµµ¿Í °ÔÀÓ¼*¹ö ÄÚµå º¹Àâµµ
-- Áõ°¡¸¦ À¯¹ßÇÏÁö ¾Ê±â À§ÇØ ¾î¿ ¼ö ¾ø´Â ÆÇ´ÜÀ̾ú´Ù. T_T
----------------------------------------
declare @BoundCOS int
declare @RefItemID int
select @RefItemID = RefItemID, @BoundCOS = Data from _Items where ID64 = @ItemToDel
if (@@ROWCOUNT = 0)
return -2

----------------------------------------
-- Ȥ½Ã ÀÌ´® PET ¼Òȯ¾ÆÀÌÅÛÀΰ¡?
----------------------------------------
declare @TypeID1 tinyint
declare @TypeID2 tinyint
declare @TypeID3 tinyint
select @TypeID1 = TypeID1, @TypeID2 = TypeID2, @TypeID3 = TypeID3 from _RefObjCommon where ID = @RefItemID
if (@TypeID1 = 3 and @TypeID2 = 2 and @TypeID3 = 1 )
begin
----------------------------------------
-- ¿«¿©ÀÖ´Â PET ÀÌ ÀÖÀ¸¸é ±×³Ñ »èÁ¦
----------------------------------------
if (@BoundCOS <> 0)
begin
exec @Rvalue = _DeleteCharCOS_NoTX @BoundCOS
if (@Rvalue < 0)
return @Rvalue
end
end

----------------------------------------
-- Ȥ½Ã ÀÌ´® LinkedStorage¾ÆÀÌÅÛÀΰ¡?
----------------------------------------
else if( @TypeID1 = 3 and @TypeID2 = 2 and @TypeID3 = 3 )
begin
----------------------------------------
-- ¿«¿©ÀÖ´Â Storage ÀÖÀ¸¸é ±×³Ñ »èÁ¦
----------------------------------------
if (@BoundCOS <> 0)
begin
IF( NOT EXISTS( select LinkedItemID from _InventoryForLinkedStorage where LinkedItemID = @ItemToDel ) )
BEGIN return -1000 END
IF( EXISTS( select top 1 ItemID from _InventoryForLinkedStorage where LinkedItemID = @ItemToDel and ItemID <> 0 and ItemID IS NOT NULL ) )
BEGIN
update _ItemPool Set InUse = 0 from _ItemPool as IP join _InventoryForLinkedStorage as IFLS on IP.ItemID = IFLS.ItemID
where IFLS.LinkedItemID = @ItemToDel AND IFLS.ItemID <> 0
END
DELETE FROM _InventoryForLinkedStorage where LinkedItemID = @ItemToDel
IF( @@ERROR <> 0 )
BEGIN return -2 END
end
end


----------------------------------------------------------
-- ½½·Ô ºñ¿ì±â
----------------------------------------------------------
if (@DelFromPC_Inv = 1 )
update _Inventory SET ItemID = 0 WHERE CharID = @CharID AND Slot = @Slot
else if (@DelFromPC_Inv = 2 )
update _InventoryForLinkedStorage SET ItemID = 0 WHERE LinkedItemID = @CharID AND Slot = @Slot
else
update _InvCOS SET ItemID = 0 WHERE COSID = @CharID AND Slot = @Slot

if (@@error <> 0 OR @@rowcount = 0)
return -3

----------------------------------------------------------
-- »èÁ¦ ´ë»ó ¾ÆÀÌÅÛ¿¡ ¹*ÀÎ ÀÓ´ë Á¤º¸ »èÁ¦
----------------------------------------------------------
if exists (select 1 from _RentItemInfo with (nolock) where nItemDBID = @ItemToDel)
begin
delete from _RentItemInfo where nItemDBID = @ItemToDel
if (@@ERROR <> 0 OR @@ROWCOUNT = 0)
begin
rollback transaction
return -6
end
end

----------------------------------------------------------
-- ÇØ´ç ¾ÆÀÌÅÛ »èÁ¦
----------------------------------------------------------
exec @Rvalue = _STRG_FREE_ITEM_NoTX @ItemToDel
if (@Rvalue < 0)
return -4

return 1

item bug fixxxx yeahhhh :D

Quote:

Originally Posted by roko36 use this code and test [global] count=1 [entry0] operation_type=17 name=SRO_GameOn_Official query=DRIVER={SQL Server};SERVER=ADMIN-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=123456 ;DATABASE=SRO_VT_ACCOUNT global_manager_node_id=697

Not working :(

plis post 1 video all configurate plis

i have big problem plis help me
[Only registered and activated users can see links. Click Here To Register...]

Uploaded with [Only registered and activated users can see links. Click Here To Register...]I was on the same video because I have this so?

shardlog:
gameserverlog
gameserver closes instantly
i disabled all regions except china in database
anyone can help me please?

Guys is there any chacne to increase the magic pop rate?

SQL Error State:42000, Native Error Code: AFC, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure '_STRG_ALLOC_ITEM_NoTX'. PLS HELP NEW CHARD OPEN EROR SHARD SQL Error State:42000, Native Error Code: AFC, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure '_STRG_ALLOC_ITEM_NoTX'. CODE PLS HELP

gm cant login help me!!

I can login in normal player,but I made sec_primary and sec_content 1 or 2 cant login

Can someone help me out? I'm getting this error:

I've searched tirelessly for a solution but had no luck.

can anyone help me on fixing this?

服务器现在已经正常运行，但是客户端在选择服务器的时候，提示：维护 ！ 这是什么问题？

help plz why get error[Only registered and activated users can see links. Click Here To Register...]

any know how to active Fortress/CTF?

how to fix C9 at login?