[Release] zTeam Season 8 Episode 2 (Source)

[BlackNewz]

How to fix You can Create Party Only with your Guild.

[clerigz]

for those players want the exc drop will be high rate just edit this lines in commonserver.cfg

instead of ExcDropPerc change that to MonsterExcellentItemRollRate

because there are some ppl that they didn't change the source code and it was the default in the source code

//=====================================
// Item option rates from monsters
//=====================================
MonsterLuckItemRollRate = 150 //-> Range: 1~10000, 0: disable luck from monster
MonsterSkillItemRollRate = 150 //-> Range: 1~10000, 0: disable skill from monster
MonsterOptionItemRollRate = 50 //-> Range: 1~10000, 0: disable option from monster
ExcDropPerc = 2000 //-> Range: 1~10000

[SmileYzn]

Hello folks, Rankingserver is not running at some of 2 MultiServer..

Put this to fix:

[Ranking]
Enabled			 	= 1
TCPPort				= 44455
DSN				= Ranking

[jeffzkie69]

does anyone can help me guild name can't see inside valley of loren and inside castle thnx!


and also guildmate can't enter land of trial

[SmileYzn]

Table T_GENS_SETTING missing??

[jeffzkie69]

Table T_GENS_SETTING missing??

buddy if you refering to exdb log yes T_GENS_SETTING is error here is error log "[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'T_GENS_SETTING'" hope my problem on guild name will be fix thank you buddy!

[xtreme17]

i have some tables if you need :) i dont know if that tables need for this MuOnline DB or not :)

T_MineSystem

USE [MuOnline]
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[T_MineSystem](
	[CharacterName] [varchar](10) NOT NULL,
	[TwinkleType] [int] NOT NULL,
	[CurrentStage] [int] NOT NULL,
 CONSTRAINT [PK_T_MineSystem] PRIMARY KEY CLUSTERED 
(
	[CharacterName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

T_PentagramInfo

USE [MuOnline]
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[T_PentagramInfo](
	[UserGuid] [int] NOT NULL,
	[AccountID] [varchar](10) NOT NULL,
	[Name] [varchar](10) NULL,
	[JewelPos] [tinyint] NOT NULL,
	[JewelIndex] [smallint] NOT NULL,
	[ItemType] [smallint] NOT NULL,
	[ItemIndex] [int] NOT NULL,
	[MainAttribute] [smallint] NOT NULL,
	[JewelLevel] [smallint] NOT NULL,
	[Rank1] [tinyint] NOT NULL,
	[Rank1Level] [tinyint] NULL,
	[Rank2] [tinyint] NOT NULL,
	[Rank2Level] [tinyint] NULL,
	[Rank3] [tinyint] NOT NULL,
	[Rank3Level] [tinyint] NULL,
	[Rank4] [tinyint] NOT NULL,
	[Rank4Level] [tinyint] NULL,
	[Rank5] [tinyint] NOT NULL,
	[Rank5Level] [tinyint] NULL,
	[RegDate] [datetime] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_JewelIndex]  DEFAULT ((255)) FOR [JewelIndex]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_ItemType]  DEFAULT ((255)) FOR [ItemType]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_ItemIndex]  DEFAULT ((511)) FOR [ItemIndex]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_MainAttribute]  DEFAULT ((255)) FOR [MainAttribute]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_Rank1]  DEFAULT ((255)) FOR [Rank1]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_Rank2]  DEFAULT ((255)) FOR [Rank2]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_Rank3]  DEFAULT ((255)) FOR [Rank3]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_Rank4]  DEFAULT ((255)) FOR [Rank4]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_Rank5]  DEFAULT ((255)) FOR [Rank5]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_RegDate]  DEFAULT (getdate()) FOR [RegDate]
GO

i have some araca battles tables + stored procedures if you need PM ME :)

[ianvalls90]

i have some tables if you need :) i dont know if that tables need for this MuOnline DB or not :)

T_MineSystem

USE [MuOnline]
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[T_MineSystem](
[CharacterName] [varchar](10) NOT NULL,
[TwinkleType] [int] NOT NULL,
[CurrentStage] [int] NOT NULL,
 CONSTRAINT [PK_T_MineSystem] PRIMARY KEY CLUSTERED 
(
[CharacterName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

T_PentagramInfo

USE [MuOnline]
GO
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[T_PentagramInfo](
[UserGuid] [int] NOT NULL,
[AccountID] [varchar](10) NOT NULL,
[Name] [varchar](10) NULL,
[JewelPos] [tinyint] NOT NULL,
[JewelIndex] [smallint] NOT NULL,
[ItemType] [smallint] NOT NULL,
[ItemIndex] [int] NOT NULL,
[MainAttribute] [smallint] NOT NULL,
[JewelLevel] [smallint] NOT NULL,
[Rank1] [tinyint] NOT NULL,
[Rank1Level] [tinyint] NULL,
[Rank2] [tinyint] NOT NULL,
[Rank2Level] [tinyint] NULL,
[Rank3] [tinyint] NOT NULL,
[Rank3Level] [tinyint] NULL,
[Rank4] [tinyint] NOT NULL,
[Rank4Level] [tinyint] NULL,
[Rank5] [tinyint] NOT NULL,
[Rank5Level] [tinyint] NULL,
[RegDate] [datetime] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_JewelIndex]  DEFAULT ((255)) FOR [JewelIndex]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_ItemType]  DEFAULT ((255)) FOR [ItemType]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_ItemIndex]  DEFAULT ((511)) FOR [ItemIndex]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_MainAttribute]  DEFAULT ((255)) FOR [MainAttribute]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_Rank1]  DEFAULT ((255)) FOR [Rank1]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_Rank2]  DEFAULT ((255)) FOR [Rank2]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_Rank3]  DEFAULT ((255)) FOR [Rank3]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_Rank4]  DEFAULT ((255)) FOR [Rank4]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_Rank5]  DEFAULT ((255)) FOR [Rank5]
GO

ALTER TABLE [dbo].[T_PentagramInfo] ADD  CONSTRAINT [DF_T_PentagramInfo_RegDate]  DEFAULT (getdate()) FOR [RegDate]
GO

i have some araca battles tables + stored procedures if you need PM ME :)

Maybe You could just post them all... instead of asking people to pm you.

[Jose Rodas]

started error code 107 ? solution? please please , thanks

[xtreme17]

Maybe You could just post them all... instead of asking people to pm you.

I will try to post all :)

[SmileYzn]

I have exported MuOnline DB into a .sql script, maybe can help someone to add or remove some things from script...


Ps. Exported with SQL Server 2012, maybe will need to use sql 2005+

No scripts for SQL server 2000 shits

[xtreme17]

Arca Battle Database ! :)

Download : https://mega.nz/#!mR8WnTjC!qDOXbywpk...NLchSUzRDIHBNY

[SmileYzn]

Arca Battle Database ! :)

Download : https://mega.nz/#!mR8WnTjC!qDOXbywpk...NLchSUzRDIHBNY

EDIT: No :D I will try to import and export again to topic.

EDIT²: Database Updated

[BlackNewz]

Bug
- Monster in map Acheron not regen.
- Party bug
1.Character no guild can't party with character has guild
2.Character GuildA can't party with Character GuildB
- Personal Shop only in lorenmarket
- Kundun greed not work

[clerigz]

Bug
- Monster in map Acheron not regen.
- Party bug
1.Character no guild can't party with character has guild
2.Character GuildA can't party with Character GuildB
- Personal Shop only in lorenmarket
- Kundun greed not work

just see in commonserver.cfg for the - Personal Shop only in lorenmarket

2.Character GuildA can't party with Character GuildB = is your both char have the same gens or not?