The Official Taiwan SRO Server files v1.258 // CSRO-R Server Files

[Isoline]

using vsro queries? no way... tw have more tables that need some clean.
do it manualy

thats is correct, as i said guys use your brains !, not everything is like vsro!

[Kaspars Erglis]

How about auto update cant get it to work for these files
edit: Fixed

[RenePunik]

I need query for clean databases, i've made one, but it's have too much errors.

[Kaspars Erglis]

Looks like FGW 101-110 not working!

- - - Updated - - -

Looks like FGW 101-110 not working!
About auto update- If not working. change Content ID in DB from 11 to 22 and Media folder change to media with small -m

[Caosfox]

is working...

[RenePunik]

@Caosfox, DC button doesn't work, have you fixed it? @Isoline, please release the fix of dc button.

[MGProjects]

@Caosfox, DC button doesn't work, have you fixed it? @Isoline, please release the fix of dc button.

download sro_client he working

http://www.srodev.com/index.php?action=tsro

[RenePunik]

download sro_client he working

http://www.srodev.com/index.php?action=tsro

After Test ~ Unfortunately, doesn't work

[Caosfox]

yup, dc not always work

[RenePunik]

yup, dc not always work

So, Isoline said he will release fix for it.

New error on GameServer

 An Exception occurred in CGame::ProcessMessage() MsgID : bc10

@Caosfox, PMs not work.

- - - Updated - - -

New crash has found : When you teleport inside Jangan Fortress you will get instantly crash.

[Blacksheep25]

@Caosfox, PMs not work.

PM's are disabled client side, go into the settings ingame and change it

[RenePunik]

Thanks @blacksheep25

Missing Table :

USE [SRO_TW_SHARD]
GO


/****** Object:  Table [dbo].[_RefAlchemy_MK_ToolTip]    Script Date: 01/06/2015 20:28:20 ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


SET ANSI_PADDING ON
GO


CREATE TABLE [dbo].[_RefAlchemy_MK_ToolTip](
    [Service] [tinyint] NOT NULL,
    [RC_CodeName] [varchar](129) NOT NULL,
    [Description] [varchar](129) NOT NULL,
    [Material_StrName1] [varchar](129) NOT NULL,
    [Material_StrName1_Count] [int] NOT NULL,
    [Material_StrName2] [varchar](129) NOT NULL,
    [Material_StrName2_Count] [int] NOT NULL,
    [Material_StrName3] [varchar](129) NOT NULL,
    [Material_StrName3_Count] [int] NOT NULL,
    [Material_StrName4] [varchar](129) NOT NULL,
    [Material_StrName4_Count] [int] NOT NULL,
    [Material_StrName5] [varchar](129) NOT NULL,
    [Material_StrName5_Count] [int] NOT NULL,
    [Material_StrName6] [varchar](129) NOT NULL,
    [Material_StrName6_Count] [int] NOT NULL,
    [ResultType] [tinyint] NOT NULL,
    [ResultItem_StrName] [varchar](129) NOT NULL,
    [ResultItem_Count] [int] NOT NULL,
    [ResultItem_ToolTip] [varchar](129) NOT NULL,
    [ResultItem_Icon] [varchar](129) NOT NULL
) ON [PRIMARY]


GO


SET ANSI_PADDING OFF
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Descr__7152C524]  DEFAULT ('') FOR [Description]
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Mater__7246E95D]  DEFAULT ('xxx') FOR [Material_StrName1]
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Mater__733B0D96]  DEFAULT ('xxx') FOR [Material_StrName2]
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Mater__742F31CF]  DEFAULT ('xxx') FOR [Material_StrName3]
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Mater__75235608]  DEFAULT ('xxx') FOR [Material_StrName4]
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Mater__76177A41]  DEFAULT ('xxx') FOR [Material_StrName5]
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Mater__770B9E7A]  DEFAULT ('xxx') FOR [Material_StrName6]
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Resul__77FFC2B3]  DEFAULT ('') FOR [ResultItem_ToolTip]
GO

Download This File and Import it to Media\server_dep\silkroad\textdata ~ btw, you can copy the lines from refalchemy_mk_tooltip.txt file to database table DOWNLOAD IT FROM HERE

[Kaspars Erglis]

Thanks @blacksheep25

Missing Table :

USE [SRO_TW_SHARD]
GO


/****** Object:  Table [dbo].[_RefAlchemy_MK_ToolTip]    Script Date: 01/06/2015 20:28:20 ******/
SET ANSI_NULLS ON
GO


SET QUOTED_IDENTIFIER ON
GO


SET ANSI_PADDING ON
GO


CREATE TABLE [dbo].[_RefAlchemy_MK_ToolTip](
    [Service] [tinyint] NOT NULL,
    [RC_CodeName] [varchar](129) NOT NULL,
    [Description] [varchar](129) NOT NULL,
    [Material_StrName1] [varchar](129) NOT NULL,
    [Material_StrName1_Count] [int] NOT NULL,
    [Material_StrName2] [varchar](129) NOT NULL,
    [Material_StrName2_Count] [int] NOT NULL,
    [Material_StrName3] [varchar](129) NOT NULL,
    [Material_StrName3_Count] [int] NOT NULL,
    [Material_StrName4] [varchar](129) NOT NULL,
    [Material_StrName4_Count] [int] NOT NULL,
    [Material_StrName5] [varchar](129) NOT NULL,
    [Material_StrName5_Count] [int] NOT NULL,
    [Material_StrName6] [varchar](129) NOT NULL,
    [Material_StrName6_Count] [int] NOT NULL,
    [ResultType] [tinyint] NOT NULL,
    [ResultItem_StrName] [varchar](129) NOT NULL,
    [ResultItem_Count] [int] NOT NULL,
    [ResultItem_ToolTip] [varchar](129) NOT NULL,
    [ResultItem_Icon] [varchar](129) NOT NULL
) ON [PRIMARY]


GO


SET ANSI_PADDING OFF
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Descr__7152C524]  DEFAULT ('') FOR [Description]
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Mater__7246E95D]  DEFAULT ('xxx') FOR [Material_StrName1]
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Mater__733B0D96]  DEFAULT ('xxx') FOR [Material_StrName2]
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Mater__742F31CF]  DEFAULT ('xxx') FOR [Material_StrName3]
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Mater__75235608]  DEFAULT ('xxx') FOR [Material_StrName4]
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Mater__76177A41]  DEFAULT ('xxx') FOR [Material_StrName5]
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Mater__770B9E7A]  DEFAULT ('xxx') FOR [Material_StrName6]
GO


ALTER TABLE [dbo].[_RefAlchemy_MK_ToolTip] ADD  CONSTRAINT [DF___RefAlche__Resul__77FFC2B3]  DEFAULT ('') FOR [ResultItem_ToolTip]
GO

Download This File and Import it to Media\server_dep\silkroad\textdata ~ btw, you can copy the lines from refalchemy_mk_tooltip.txt file to database table DOWNLOAD IT FROM HERE

Can I use SkillEffect.txt file from vsro's media?

All fortress are bugged.

Is this fixing FW?
NWM got it!

[RenePunik]

#Fixed

[Kaspars Erglis]

What about this warning?
Anyone else getting this on their FarmManager?

unhandled msg received CFarmManagerMainProcess : (Massive)Ack:0x306 (10), 32932195

I dont want to use vsro farmmanager(full with viruss)

- - - Updated - - -

Is this fixing FW?
NWM got it!

cant manual get this file refalchemy_mk_tooltip.txt in media!--.Fixed