DB No Complete .. !! I Use Moving a DC
DB No Complete .. !! I Use Moving a DC
Valeu por mais este realease Statiic! Irei testar e posto o resultado. Obrigado
I got DC too if i use moving speed (drug of typoon etc.)
Think of a moreOriginally Posted by crater96
its give me too this error
and kanift query dont fix it.
Can somone who have fast internet upload the importend files ?
itemdata and the others
thanks but i am first one made this is Database :P
pffffffffffffffff heyy my problem new char created
Waiting anxiously fix the problem by creating the characterHere is u dream! complete 120 cap database + a simply d13 (Weapons + Stones)
Update v5.5
120_Complete+D13@Statiic@.rar
Pw
Spoiler:
SMC D13
Pw
Spoiler:
Media
Media@Statiic@.part1.rar
Media@Statiic@.part2.rar
Pw
Spoiler:
kSro Data.pk2 already extracted
Pw
Spoiler:
Work in this update:
Database
Jupiter 100% (Dungeons Too)
Jupiter Spawns 100% (Chapions and Giants too)
Skills Normal and of the mobs 100%
Drops lvl 111+ Normal and Sox 100%
Somes avatars add...
Media.pk2
Fixed Glows Normal and Sox (D13)
Somes Avatars Add to item mall
Icons D13
.txt are of the servers WingSRO and FenixSRO.
Some Pictures:
Spoiler:
OKE? its a clean database so no bugs ^^ but if u found post it here.
Database Owners : Statiic :)
Like + Rep Thanks! ^^
ok sry @kanift it works fine mobs higher 115+ all cave room's work
but i dont set all area's on 1 gameserver
btw. now the problem with speed drug ( super scrolls ) i dont know with normal but i think same other guy here say the same
but it is a very fucking NICE rels Statiic thnx bro
@BlackG2k
can u upload the importent txt files ? because i have abd internet cnnection :S
Update v6
Complete_120Cap+D13_v6@Statiic@.rar
Pw
Spoiler:
Fixed erro when creat a new char and Dc when buy a item of item mall
@Done!
fix the problem with speed drug too ?
@BlackNova statiic have do it ^^( v.6 )
is error (ID) Duplicated go your SRO_VT_SHARD > Delete _Char, _AccountJID, _Items and re-add
USE [SRO_VT_SHARD]
GO
/****** Object: Table [dbo].[_AccountJID] Script Date: 01/28/2012 11:20:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_AccountJID](
[AccountID] [varchar](128) NOT NULL,
[JID] [int] NOT NULL,
[Gold] [bigint] NOT NULL CONSTRAINT [DF___AccountJI__Gold__37D02F05] DEFAULT (0),
CONSTRAINT [PK__AccountJID] PRIMARY KEY CLUSTERED
(
[AccountID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY],
CONSTRAINT [IX__AccountJID] UNIQUE NONCLUSTERED
(
[JID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFFUSE [SRO_VT_SHARD]
GO
/****** Object: Table [dbo].[_Char] Script Date: 01/28/2012 11:20:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_Char](
[CharID] [int] IDENTITY(1,1) NOT NULL,
[Deleted] [tinyint] NOT NULL CONSTRAINT [DF__Char_Deleted] DEFAULT (0),
[RefObjID] [int] NOT NULL CONSTRAINT [DF__Char_RefObjID] DEFAULT (0),
[CharName16] [varchar](64) NOT NULL,
[NickName16] [varchar](17) NOT NULL CONSTRAINT [DF__Char_NickName16] DEFAULT (''),
[Scale] [tinyint] NOT NULL,
[CurLevel] [tinyint] NOT NULL CONSTRAINT [DF__Char_CurLevel] DEFAULT (1),
[MaxLevel] [tinyint] NOT NULL CONSTRAINT [DF__Char_MaxLevel] DEFAULT (1),
[ExpOffset] [bigint] NOT NULL CONSTRAINT [DF__Char_ExpOffset] DEFAULT (0),
[SExpOffset] [int] NOT NULL CONSTRAINT [DF__Char_SExpOffset] DEFAULT (0),
[Strength] [smallint] NOT NULL CONSTRAINT [DF__Char_Strength] DEFAULT (0),
[Intellect] [smallint] NOT NULL CONSTRAINT [DF__Char_Intellect] DEFAULT (0),
[RemainGold] [bigint] NOT NULL CONSTRAINT [DF__Char_RemainGold] DEFAULT (0),
[RemainSkillPoint] [int] NOT NULL CONSTRAINT [DF__Char_RemainSkillPoint] DEFAULT (0),
[RemainStatPoint] [smallint] NOT NULL CONSTRAINT [DF__Char_RemainStatPoint] DEFAULT (0),
[RemainHwanCount] [tinyint] NOT NULL CONSTRAINT [DF__Char_RemainHwanCount] DEFAULT (0),
[GatheredExpPoint] [int] NOT NULL CONSTRAINT [DF__Char_GatheredExpPoint] DEFAULT (0),
[HP] [int] NOT NULL CONSTRAINT [DF__Char_HP] DEFAULT (200),
[MP] [int] NOT NULL CONSTRAINT [DF__Char_MP] DEFAULT (200),
[LatestRegion] [smallint] NOT NULL CONSTRAINT [DF__Char_LatestRegion] DEFAULT (0),
[PosX] [real] NOT NULL,
[PosY] [real] NOT NULL,
[PosZ] [real] NOT NULL,
[AppointedTeleport] [int] NOT NULL CONSTRAINT [DF__Char_AppointedTeleport] DEFAULT (0),
[AutoInvestExp] [tinyint] NOT NULL CONSTRAINT [DF__Char_AutoInvestExp] DEFAULT (1),
[InventorySize] [int] NOT NULL CONSTRAINT [DF__Char_EngagedCOS] DEFAULT (0),
[DailyPK] [tinyint] NOT NULL CONSTRAINT [DF__Char_DailyPK] DEFAULT (0),
[TotalPK] [smallint] NOT NULL CONSTRAINT [DF__Char_TotalPK] DEFAULT (0),
[PKPenaltyPoint] [int] NOT NULL CONSTRAINT [DF__Char_PKPenaltyPoint] DEFAULT (0),
[TPP] [int] NOT NULL CONSTRAINT [DF__Char_TPP] DEFAULT (0),
[PenaltyForfeit] [int] NOT NULL CONSTRAINT [DF__Char_PenaltyForfeit] DEFAULT (0),
[JobPenaltyTime] [int] NOT NULL CONSTRAINT [DF__Char_PenaltyTime] DEFAULT (0),
[JobLvl_Trader] [tinyint] NOT NULL CONSTRAINT [DF__Char_JobLvl_Trader] DEFAULT (1),
[Trader_Exp] [int] NOT NULL CONSTRAINT [DF__Char_Trader_Exp] DEFAULT (0),
[JobLvl_Hunter] [tinyint] NOT NULL CONSTRAINT [DF__Char_JobLvl_Hunter] DEFAULT (1),
[Hunter_Exp] [int] NOT NULL CONSTRAINT [DF__Char_Hunter_Exp] DEFAULT (0),
[JobLvl_Robber] [tinyint] NOT NULL CONSTRAINT [DF__Char_JobLvl_Robber] DEFAULT (1),
[Robber_Exp] [int] NOT NULL CONSTRAINT [DF__Char_Robber_Exp] DEFAULT (0),
[GuildID] [int] NULL CONSTRAINT [DF__Char_GuildID] DEFAULT (0),
[LastLogout] [smalldatetime] NOT NULL,
[TelRegion] [smallint] NOT NULL CONSTRAINT [DF___char__TelRegion__4C2C2D6D] DEFAULT (0),
[TelPosX] [real] NOT NULL CONSTRAINT [DF___char__TelPosX__4D2051A6] DEFAULT (0),
[TelPosY] [real] NOT NULL CONSTRAINT [DF___char__TelPosY__4E1475DF] DEFAULT (0),
[TelPosZ] [real] NOT NULL CONSTRAINT [DF___char__TelPosZ__4F089A18] DEFAULT (0),
[DiedRegion] [smallint] NOT NULL CONSTRAINT [DF___char__DiedRegio__4FFCBE51] DEFAULT (0),
[DiedPosX] [real] NOT NULL CONSTRAINT [DF___char__DiedPosX__50F0E28A] DEFAULT (0),
[DiedPosY] [real] NOT NULL CONSTRAINT [DF___char__DiedPosY__51E506C3] DEFAULT (0),
[DiedPosZ] [real] NOT NULL CONSTRAINT [DF___char__DiedPosZ__52D92AFC] DEFAULT (0),
[WorldID] [smallint] NOT NULL CONSTRAINT [DF__Char__WorldID] DEFAULT (1),
[TelWorldID] [smallint] NOT NULL CONSTRAINT [DF__Char__TelWorldID] DEFAULT (1),
[DiedWorldID] [smallint] NOT NULL CONSTRAINT [DF__Char__DiedWorldID] DEFAULT (1),
[HwanLevel] [tinyint] NOT NULL DEFAULT (0),
CONSTRAINT [PK__Char_1] PRIMARY KEY CLUSTERED
(
[CharID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY],
CONSTRAINT [IX__Char] UNIQUE NONCLUSTERED
(
[CharName16] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFFon speedy id should be in errorUSE [SRO_VT_SHARD]
GO
/****** Object: Table [dbo].[_Items] Script Date: 01/28/2012 11:20:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_Items](
[ID64] [bigint] IDENTITY(1,1) NOT NULL,
[RefItemID] [int] NOT NULL,
[OptLevel] [tinyint] NULL,
[Variance] [bigint] NULL,
[Data] [int] NOT NULL,
[CreaterName] [varchar](64) NULL,
[MagParamNum] [tinyint] NOT NULL CONSTRAINT [DF__Items_MagParamNum] DEFAULT (0),
[MagParam1] [bigint] NULL,
[MagParam2] [bigint] NULL,
[MagParam3] [bigint] NULL,
[MagParam4] [bigint] NULL,
[MagParam5] [bigint] NULL,
[MagParam6] [bigint] NULL,
[MagParam7] [bigint] NULL,
[MagParam8] [bigint] NULL,
[MagParam9] [bigint] NULL,
[MagParam10] [bigint] NULL,
[MagParam11] [bigint] NULL,
[MagParam12] [bigint] NULL,
[Serial64] [bigint] NOT NULL CONSTRAINT [DF___Items__Serial64__469D7149] DEFAULT (0),
CONSTRAINT [PK__Items] PRIMARY KEY CLUSTERED
(
[ID64] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
_RefObjCommon, _RefObjItem in SRO_VT_SHARD
and itemdata_5000.txt A itemdata_45000.txt in PK2
Hey angrybird... can you give me a hint on where could I get the resource of all D13 staff...Cuz in my point its better to stay in 110 cap.. i will just make D13 as D12(sun) type 2.. If you could provide me that would be better... Thanks in advance...
Fixed.
