[Release] DarksTeam Official Season 3 Episode 2 - Beta 25

cyberiano · Jul 16, 2009

hydramu said:
its OFF now but problem i cant create what is the problem ((

try this editor, just create account

There is no editor compatible with these files

cyberiano · Jul 16, 2009

hydramu said:
problem solved now i whant to turn off the md5 on muserver how ???

joinserver not use md5

REGNAL · Jul 17, 2009

To fix uses all mu editors aply the this query in query analizer.

Ps.: this action clean all data the your memb_info table.
Without MD5

Code:

USE [MuOnline]
GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_MEMB_INFO_mail_chek]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MEMB_INFO] DROP CONSTRAINT [DF_MEMB_INFO_mail_chek]
END

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_MEMB_INFO_jf]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MEMB_INFO] DROP CONSTRAINT [DF_MEMB_INFO_jf]
END

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_MEMB_INFO_partation]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MEMB_INFO] DROP CONSTRAINT [DF_MEMB_INFO_partation]
END

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF__memb_info__serve__0FCDF5FA]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MEMB_INFO] DROP CONSTRAINT [DF__memb_info__serve__0FCDF5FA]
END

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF__memb_info__usedt__10C21A33]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MEMB_INFO] DROP CONSTRAINT [DF__memb_info__usedt__10C21A33]
END

GO

USE [MuOnline]
GO

/****** Object:  Table [dbo].[MEMB_INFO]    Script Date: 07/17/2009 10:23:21 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MEMB_INFO]') AND type in (N'U'))
DROP TABLE [dbo].[MEMB_INFO]
GO

USE [MuOnline]
GO

/****** Object:  Table [dbo].[MEMB_INFO]    Script Date: 07/17/2009 10:23:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[MEMB_INFO](
	[memb_guid] [int] IDENTITY(1,1) NOT NULL,
	[memb___id] [varchar](10) NOT NULL,
	[memb__pwd] [varchar](14) NOT NULL,--column altered withot md5
	[memb_name] [varchar](10) NOT NULL,
	[sno__numb] [char](18) NOT NULL,--column altered
	[post_code] [char](6) NULL,
	[addr_info] [varchar](50) NULL,
	[addr_deta] [varchar](50) NULL,
	[tel__numb] [varchar](20) NULL,
	[phon_numb] [varchar](18) NULL,
	[mail_addr] [varchar](50) NULL,
	[fpas_ques] [varchar](50) NULL,
	[fpas_answ] [varchar](50) NULL,
	[job__code] [char](2) NULL,
	[appl_days] [datetime] NULL,
	[modi_days] [datetime] NULL,
	[out__days] [datetime] NULL,
	[true_days] [datetime] NULL,
	[mail_chek] [char](1) NULL,
	[bloc_code] [char](1) NOT NULL,
	[ctl1_code] [char](1) NOT NULL,
	[vip_free] [tinyint] NULL,
	[member] [int] NULL,
	[ZY] [int] NULL,
	[jf] [int] NULL,
	[rcb] [int] NULL,
	[vip] [tinyint] NULL,
	[Expired] [datetime] NULL,
	[sms_t] [nvarchar](15) NULL,
	[last_ip] [nvarchar](20) NULL,
	[last_s] [nvarchar](15) NULL,
	[bloc_date] [smalldatetime] NULL,
	[TOPACC] [varchar](20) NULL,
	[TOPJP] [varchar](200) NULL,
	[QXENDTIME] [datetime] NULL,
	[LINZBSJ] [datetime] NULL,
	[LGONGZHISJ] [datetime] NULL,
	[STOPINFO] [nvarchar](100) NULL,
	[STOPTIME] [datetime] NULL,
	[QX] [char](1) NULL,
	[partation] [int] NULL,
	[servercode] [int] NULL,
	[usedtime] [int] NULL,
	[cspoints] [int] NULL,
 CONSTRAINT [PK_MEMB_INFO_1] PRIMARY KEY NONCLUSTERED 
(
	[memb_guid] DESC
)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

ALTER TABLE [dbo].[MEMB_INFO] ADD  CONSTRAINT [DF_MEMB_INFO_mail_chek]  DEFAULT ((0)) FOR [mail_chek]
GO

ALTER TABLE [dbo].[MEMB_INFO] ADD  CONSTRAINT [DF_MEMB_INFO_jf]  DEFAULT ((0)) FOR [jf]
GO

ALTER TABLE [dbo].[MEMB_INFO] ADD  CONSTRAINT [DF_MEMB_INFO_partation]  DEFAULT ((0)) FOR [partation]
GO

ALTER TABLE [dbo].[MEMB_INFO] ADD  CONSTRAINT [DF__memb_info__serve__0FCDF5FA]  DEFAULT ((0)) FOR [servercode]
GO

ALTER TABLE [dbo].[MEMB_INFO] ADD  CONSTRAINT [DF__memb_info__usedt__10C21A33]  DEFAULT ((0)) FOR [usedtime]
GO

With MD5

Code:

USE [MuOnline]
GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_MEMB_INFO_mail_chek]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MEMB_INFO] DROP CONSTRAINT [DF_MEMB_INFO_mail_chek]
END

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_MEMB_INFO_jf]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MEMB_INFO] DROP CONSTRAINT [DF_MEMB_INFO_jf]
END

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_MEMB_INFO_partation]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MEMB_INFO] DROP CONSTRAINT [DF_MEMB_INFO_partation]
END

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF__memb_info__serve__0FCDF5FA]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MEMB_INFO] DROP CONSTRAINT [DF__memb_info__serve__0FCDF5FA]
END

GO

IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF__memb_info__usedt__10C21A33]') AND type = 'D')
BEGIN
ALTER TABLE [dbo].[MEMB_INFO] DROP CONSTRAINT [DF__memb_info__usedt__10C21A33]
END

GO

USE [MuOnline]
GO

/****** Object:  Table [dbo].[MEMB_INFO]    Script Date: 07/17/2009 10:23:21 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MEMB_INFO]') AND type in (N'U'))
DROP TABLE [dbo].[MEMB_INFO]
GO

USE [MuOnline]
GO

/****** Object:  Table [dbo].[MEMB_INFO]    Script Date: 07/17/2009 10:23:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[MEMB_INFO](
	[memb_guid] [int] IDENTITY(1,1) NOT NULL,
	[memb___id] [varchar](10) NOT NULL,
	[memb__pwd] [varbinary](16) NOT NULL,column altered with md5
	[memb_name] [varchar](10) NOT NULL,
	[sno__numb] [char](18) NOT NULL--column altered
	[post_code] [char](6) NULL,
	[addr_info] [varchar](50) NULL,
	[addr_deta] [varchar](50) NULL,
	[tel__numb] [varchar](20) NULL,
	[phon_numb] [varchar](18) NULL,
	[mail_addr] [varchar](50) NULL,
	[fpas_ques] [varchar](50) NULL,
	[fpas_answ] [varchar](50) NULL,
	[job__code] [char](2) NULL,
	[appl_days] [datetime] NULL,
	[modi_days] [datetime] NULL,
	[out__days] [datetime] NULL,
	[true_days] [datetime] NULL,
	[mail_chek] [char](1) NULL,
	[bloc_code] [char](1) NOT NULL,
	[ctl1_code] [char](1) NOT NULL,
	[vip_free] [tinyint] NULL,
	[member] [int] NULL,
	[ZY] [int] NULL,
	[jf] [int] NULL,
	[rcb] [int] NULL,
	[vip] [tinyint] NULL,
	[Expired] [datetime] NULL,
	[sms_t] [nvarchar](15) NULL,
	[last_ip] [nvarchar](20) NULL,
	[last_s] [nvarchar](15) NULL,
	[bloc_date] [smalldatetime] NULL,
	[TOPACC] [varchar](20) NULL,
	[TOPJP] [varchar](200) NULL,
	[QXENDTIME] [datetime] NULL,
	[LINZBSJ] [datetime] NULL,
	[LGONGZHISJ] [datetime] NULL,
	[STOPINFO] [nvarchar](100) NULL,
	[STOPTIME] [datetime] NULL,
	[QX] [char](1) NULL,
	[partation] [int] NULL,
	[servercode] [int] NULL,
	[usedtime] [int] NULL,
	[cspoints] [int] NULL,
 CONSTRAINT [PK_MEMB_INFO_1] PRIMARY KEY NONCLUSTERED 
(
	[memb_guid] DESC
)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

ALTER TABLE [dbo].[MEMB_INFO] ADD  CONSTRAINT [DF_MEMB_INFO_mail_chek]  DEFAULT ((0)) FOR [mail_chek]
GO

ALTER TABLE [dbo].[MEMB_INFO] ADD  CONSTRAINT [DF_MEMB_INFO_jf]  DEFAULT ((0)) FOR [jf]
GO

ALTER TABLE [dbo].[MEMB_INFO] ADD  CONSTRAINT [DF_MEMB_INFO_partation]  DEFAULT ((0)) FOR [partation]
GO

ALTER TABLE [dbo].[MEMB_INFO] ADD  CONSTRAINT [DF__memb_info__serve__0FCDF5FA]  DEFAULT ((0)) FOR [servercode]
GO

ALTER TABLE [dbo].[MEMB_INFO] ADD  CONSTRAINT [DF__memb_info__usedt__10C21A33]  DEFAULT ((0)) FOR [usedtime]
GO

DarkMaster · Jul 17, 2009

updated to beta 10

alenchaplin · Jul 17, 2009

and it will turn DBS into NO MD5?

Wolf · Jul 17, 2009

this is a new ini

Code:

[Commands]
EnablePost = 1
PostMinLevel = 1
PostCost = 10000
EnableAddCommand = 1
AddMinLevel = 1
AddCost = 10000

[Customs]
BkSmElfPointsPerLevel = 5
MgPointsPerLevel = 7
MarlonBonusPoints = 1
MaxLevel = 400
MaxLevelNoExp = 401
65kMaxStats = 1

[Rates]
SoulWithoutLuckSuccessRate = 50
SoulWithLuckSuccessRate = 75
LifeSuccessRate = 50
ChaosMix10SuccessRate = 60
ChaosMix11SuccessRate = 45
ChaosMix12SuccessRate = 45
ChaosMix13SuccessRate = 45

[ManaShield]
MSAgility = 30
MSEnergy = 200

[GreaterFortitude]
BkBuffEnergy = 20
BkBuffVitality = 100

[Events]
ChaosCastleMinPlayers = 1
IllusionTempleMinPlayers = 2

[PartyFormula]
Party2Exp = 160
Party3Exp = 180
Party3Exp = 200
Party5Exp = 220
SetParty3Exp = 230
SetParty4Exp = 270
SetParty5Exp = 300

[Skills]
TwistingSlashMinLevel = 80
RagefulMinLevel = 170
DeathStabMinLevel = 160
ImpaleMinLevel = 28
InnerStrMinLevel = 120
PenetrationMinLevel = 130

but.. this optionsf from old releases??

Code:

[Rings]
TransformationRing1 = 2
TransformationRing2 = 7
TransformationRing3 = 14
TransformationRing4 = 8
TransformationRing5 = 9
TransformationRing6 = 41

[ElfOrbs]
ElfOrbSummon1 = 23
ElfOrbSummon2 = 32
ElfOrbSummon3 = 21
ElfOrbSummon4 = 20
ElfOrbSummon5 = 10
ElfOrbSummon6 = 150
ElfOrbSummon7 = 151

[Prices]
BlessPrice = 6000000
SoulPrice = 9000000
ChaosPrice = 810000
LifePrice = 45000000
CreationPrice = 36000000
GuardianPrice = 60000000
DarkHorsePrice = 5000000
DarkSpiritPrice = 1000000
BlessPotion = 960000
SoulPotion = 450000

[Events]
ChaosCastleMinPlayers = 1
IllusionTempleMinPlayers = 2
BCItemID = 15
BCItemGroup = 12

[Customs]
ElfSoldierBuffMaxLvl = 100
GuildAllianceMinPlayers = 20
[COLOR="Red"]GSUdpPort = 60006[/COLOR]
MarlonBonus = 1
MaxZenInChar = 2000000000
MaxZenInVault = 1000000000
BkSmElfPointsPerLevel = 5
MGPointsPerLevel = 7
DLPointsPerLevel = 7
65kMaxStats = 0

[SuccessRates]
[COLOR="Red"]SoulSuccessRate = 100
SoulWithLuckSuccessRate = 100
LifeSuccessRate = 100
DarkHorseMix = 60
DarkSpiritMix = 100
DinorantMix = 70
BlessPotionMix = 100
SoulPotionMix = 100
LifeStoneMix = 100
CircleMix = 90
[/COLOR]
[Drop]
[COLOR="Red"]ExcDropRate = 2000
ExcSkillRate = 100
ExcLuckRate = 1
SkillDropRate = 6
LuckDropRate = 4[/COLOR]

|-(

DarkMaster · Jul 17, 2009

Wolf said:

this is a new ini

Code:

[Commands]
EnablePost = 1
PostMinLevel = 1
PostCost = 10000
EnableAddCommand = 1
AddMinLevel = 1
AddCost = 10000

[Customs]
BkSmElfPointsPerLevel = 5
MgPointsPerLevel = 7
MarlonBonusPoints = 1
MaxLevel = 400
MaxLevelNoExp = 401
65kMaxStats = 1

[Rates]
SoulWithoutLuckSuccessRate = 50
SoulWithLuckSuccessRate = 75
LifeSuccessRate = 50
ChaosMix10SuccessRate = 60
ChaosMix11SuccessRate = 45
ChaosMix12SuccessRate = 45
ChaosMix13SuccessRate = 45

[ManaShield]
MSAgility = 30
MSEnergy = 200

[GreaterFortitude]
BkBuffEnergy = 20
BkBuffVitality = 100

[Events]
ChaosCastleMinPlayers = 1
IllusionTempleMinPlayers = 2

[PartyFormula]
Party2Exp = 160
Party3Exp = 180
Party3Exp = 200
Party5Exp = 220
SetParty3Exp = 230
SetParty4Exp = 270
SetParty5Exp = 300

[Skills]
TwistingSlashMinLevel = 80
RagefulMinLevel = 170
DeathStabMinLevel = 160
ImpaleMinLevel = 28
InnerStrMinLevel = 120
PenetrationMinLevel = 130

but.. this optionsf from old releases??

Code:

[Rings]
TransformationRing1 = 2
TransformationRing2 = 7
TransformationRing3 = 14
TransformationRing4 = 8
TransformationRing5 = 9
TransformationRing6 = 41

[ElfOrbs]
ElfOrbSummon1 = 23
ElfOrbSummon2 = 32
ElfOrbSummon3 = 21
ElfOrbSummon4 = 20
ElfOrbSummon5 = 10
ElfOrbSummon6 = 150
ElfOrbSummon7 = 151

[Prices]
BlessPrice = 6000000
SoulPrice = 9000000
ChaosPrice = 810000
LifePrice = 45000000
CreationPrice = 36000000
GuardianPrice = 60000000
DarkHorsePrice = 5000000
DarkSpiritPrice = 1000000
BlessPotion = 960000
SoulPotion = 450000

[Events]
ChaosCastleMinPlayers = 1
IllusionTempleMinPlayers = 2
BCItemID = 15
BCItemGroup = 12

[Customs]
ElfSoldierBuffMaxLvl = 100
GuildAllianceMinPlayers = 20
[COLOR=Red]GSUdpPort = 60006[/COLOR]
MarlonBonus = 1
MaxZenInChar = 2000000000
MaxZenInVault = 1000000000
BkSmElfPointsPerLevel = 5
MGPointsPerLevel = 7
DLPointsPerLevel = 7
65kMaxStats = 0

[SuccessRates]
[COLOR=Red]SoulSuccessRate = 100
SoulWithLuckSuccessRate = 100
LifeSuccessRate = 100
DarkHorseMix = 60
DarkSpiritMix = 100
DinorantMix = 70
BlessPotionMix = 100
SoulPotionMix = 100
LifeStoneMix = 100
CircleMix = 90
[/COLOR]
[Drop]
[COLOR=Red]ExcDropRate = 2000
ExcSkillRate = 100
ExcLuckRate = 1
SkillDropRate = 6
LuckDropRate = 4[/COLOR]

|-(

i will add the old options soon

Wolf · Jul 17, 2009

DarkMaster said:
i will add the old options soon

ok man, thx for all ^^

Slay4o · Jul 17, 2009

Dark command /drop /item work?

DarkMaster · Jul 17, 2009

Slay4o said:
Dark command /drop /item work?

nop

REGNAL · Jul 17, 2009

alenchaplin said:
and it will turn DBS into NO MD5?

man look de my post i add 2 query to db with md5 and db without md5

neon-blade · Jul 17, 2009

I Only need testore MuOnline and MuLog Db?

MuOnline database is in md5 right? I will use it in MD5

alenchaplin · Jul 17, 2009

REGNAL said:
man look de my post i add 2 query to db with md5 and db without md5

Sorry man i think you misunderstand i was asking if i can use this to change DBs.

Tks anyway

Drake · Jul 17, 2009

You Not Make This Commond For GS_CS?

REGNAL · Jul 17, 2009

alenchaplin said:
Sorry man i think you misunderstand i was asking if i can use this to change DBs.

Tks anyway

This query will create the table again memb_info the database muonline, pointing out that running this query you will lose all the records inserted in memb_info ... ok?

Drake said:
You Not Make This Commond For GS_CS?

for now only the GS Normal has changed ...

Wolf · Jul 17, 2009

exeletn release!!, now the GS is More stable, ( no autocrash xD), nice man , good work =)

PD: i find into DLL

"ConnectNotice =" =P

lordmelvin · Jul 17, 2009

nice very god =P

M4rVe · Jul 17, 2009

DarkMaster said:
...

this dbs is SQL2000? i have problems in Restore

lordmelvin · Jul 17, 2009

is the DBs
DOWNLOAD

DarkMaster · Jul 17, 2009

Wolf said:
exeletn release!!, now the GS is More stable, ( no autocrash xD), nice man , good work =)

PD: i find into DLL

"ConnectNotice =" =P

ive forgot to add it in DarksTeam.ini ;P

M4rVe said:
this dbs is SQL2000? i have problems in Restore

yes

[Release] DarksTeam Official Season 3 Episode 2 - Beta 25

New Member

Attachments

New Member

Attachments

New Member

Administrator

New Member

New Member

Administrator

New Member

New Member

Administrator

New Member

New Member

New Member

New Member

New Member

New Member

New Member

New Member

New Member

Administrator

Similar threads