Code:
[spoiler]
/****** Object: Table [dbo].[users] Script Date: 11/12/2010 00:58:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[users](
[userid] [int] IDENTITY(1,1) NOT NULL,
[id] [varchar](50) NOT NULL,
[password] [varchar](50) NOT NULL,
[online] [tinyint] NOT NULL,
[unknown] [tinyint] NULL,
[unknown2] [int] NULL,
[silk] [int] NULL,
[gold] [bigint] NULL,
CONSTRAINT [PK_users] PRIMARY KEY CLUSTERED
(
[userid] 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
/****** Object: Table [dbo].[storage_items] Script Date: 11/12/2010 00:58:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[storage_items](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [int] NULL,
[itemid] [int] NULL,
[itemnumber] [varchar](50) NULL,
[plusvalue] [tinyint] NULL CONSTRAINT [DF_storage_items_plusvalue] DEFAULT ((0)),
[slot] [tinyint] NULL,
[type] [tinyint] NULL CONSTRAINT [DF_storage_items_type] DEFAULT ((0)),
[quantity] [smallint] NULL CONSTRAINT [DF_storage_items_quantity] DEFAULT ((1)),
[durability] [int] NULL CONSTRAINT [DF_storage_items_durability] DEFAULT ((30)),
CONSTRAINT [PK_storage_items] PRIMARY KEY CLUSTERED
(
[id] 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
/****** Object: Table [dbo].[server] Script Date: 11/12/2010 00:58:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[server](
[id] [int] NOT NULL,
[serverid] [smallint] NULL,
[name] [varchar](50) NULL,
[users_current] [smallint] NULL,
[users_max] [smallint] NULL,
[state] [tinyint] NULL,
[ip] [varchar](20) NULL,
[port] [smallint] NULL,
[type] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[saved_skills] Script Date: 11/12/2010 00:58:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[saved_skills](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [varchar](50) NULL,
[skillid] [int] NULL,
CONSTRAINT [PK_saved_skills] PRIMARY KEY CLUSTERED
(
[id] 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
/****** Object: Table [dbo].[pets] Script Date: 11/12/2010 00:58:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[pets](
[id] [int] IDENTITY(1,1) NOT NULL,
[playerid] [varchar](50) NULL,
[pet_id] [int] NULL,
[pet_type] [tinyint] NULL,
[pet_name] [varchar](50) NULL,
[pet_state] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[news] Script Date: 11/12/2010 00:58:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[news](
[id] [int] IDENTITY(1,1) NOT NULL,
[head] [text] NULL,
[text] [text] NULL,
[Year] [smallint] NULL,
[month] [smallint] NULL,
CONSTRAINT [PK_news] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
/****** Object: Table [dbo].[mastery] Script Date: 11/12/2010 00:58:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mastery](
[id] [int] NULL,
[owner] [int] NULL,
[mastery] [int] NULL,
[level] [tinyint] NULL CONSTRAINT [DF_mastery_level] DEFAULT ((0))
) ON [PRIMARY]
/****** Object: Table [dbo].[guild_storage] Script Date: 11/12/2010 00:58:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[guild_storage](
[id] [int] IDENTITY(1,1) NOT NULL,
[guild_id] [int] NULL,
[storage_id] [int] NULL,
[item_id] [int] NULL,
[item_plus] [tinyint] NULL,
[item_durability] [int] NULL,
[item_slot] [tinyint] NULL,
[item_type] [tinyint] NULL,
[item_quantity] [smallint] NULL
) ON [PRIMARY]
/****** Object: Table [dbo].[guild] Script Date: 11/12/2010 00:57:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[guild](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [varchar](50) NULL,
[name] [varchar](50) NULL,
[level] [tinyint] NULL,
[storageid] [int] NULL,
[Grant_name] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[character_jobs] Script Date: 11/12/2010 00:57:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[character_jobs](
[id] [int] IDENTITY(1,1) NOT NULL,
[character_name] [varchar](50) NULL,
[job_alias] [varchar](50) NULL,
[job_type] [tinyint] NULL,
[job_experience] [int] NULL,
[job_rank] [tinyint] NULL,
[job_state] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[character_guides] Script Date: 11/12/2010 00:57:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[character_guides](
[id] [int] IDENTITY(1,1) NOT NULL,
[Guide_Name] [varchar](50) NULL,
[Guide_Owner] [varchar](50) NULL,
[Guide_Status] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[character] Script Date: 11/12/2010 00:57:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[character](
[id] [int] IDENTITY(1,1) NOT NULL,
[account] [nvarchar](50) NOT NULL,
[name] [nvarchar](50) NOT NULL,
[chartype] [int] NOT NULL,
[volume] [tinyint] NOT NULL,
[level] [tinyint] NOT NULL CONSTRAINT [DF_karakterler_level] DEFAULT ((1)),
[strength] [smallint] NOT NULL CONSTRAINT [DF_karakterler_strength] DEFAULT ((20)),
[intelligence] [smallint] NOT NULL CONSTRAINT [DF_karakterler_intelligence] DEFAULT ((20)),
[attribute] [smallint] NOT NULL CONSTRAINT [DF_karakterler_attribute] DEFAULT ((0)),
[hp] [int] NOT NULL CONSTRAINT [DF_karakterler_hp] DEFAULT ((200)),
[mp] [int] NOT NULL CONSTRAINT [DF_karakterler_mp] DEFAULT ((200)),
[gold] [bigint] NOT NULL CONSTRAINT [DF_karakterler_gold] DEFAULT ((0)),
[experience] [bigint] NOT NULL CONSTRAINT [DF_karakterler_expirience] DEFAULT ((0)),
[spbar] [int] NOT NULL CONSTRAINT [DF_karakterler_sbpar] DEFAULT ((0)),
[sp] [int] NOT NULL CONSTRAINT [DF_karakterler_sp] DEFAULT ((0)),
[gm] [tinyint] NOT NULL CONSTRAINT [DF_karakterler_gm] DEFAULT ((0)),
[xsect] [tinyint] NULL CONSTRAINT [DF_karakterler_xsect] DEFAULT ((168)),
[ysect] [tinyint] NULL CONSTRAINT [DF_karakterler_ysect] DEFAULT ((97)),
[unknown3] [nvarchar](50) NULL,
[xpos] [int] NULL CONSTRAINT [DF_karakterler_xpos] DEFAULT ((911)),
[ypos] [int] NULL CONSTRAINT [DF_karakterler_ypos] DEFAULT ((1083)),
[zpos] [int] NULL CONSTRAINT [DF_karakterler_zpos] DEFAULT ((-32)),
[s_hp] [int] NOT NULL CONSTRAINT [DF_karakterler_s_hp] DEFAULT ((200)),
[s_mp] [int] NOT NULL CONSTRAINT [DF_karakterler_s_mp] DEFAULT ((200)),
[min_phyatk] [int] NULL,
[max_phyatk] [int] NULL,
[min_magatk] [int] NULL,
[max_magatk] [int] NULL,
[phydef] [smallint] NULL,
[magdef] [smallint] NULL,
[hit] [smallint] NULL,
[parry] [smallint] NULL,
[unknown] [nvarchar](50) NULL,
[walkspeed] [int] NULL CONSTRAINT [DF_karakterler_walkspeed] DEFAULT ((15)),
[runspeed] [int] NULL CONSTRAINT [DF_karakterler_runspeed] DEFAULT ((50)),
[berserkspeed] [int] NULL CONSTRAINT [DF_karakterler_berserkerspeed] DEFAULT ((50)),
[berserkbar] [tinyint] NULL CONSTRAINT [DF_karakterler_berserkerbar] DEFAULT ((0)),
[unknown2] [nvarchar](50) NULL,
[mag_absord] [smallint] NULL CONSTRAINT [DF_karakterler_mag_absord] DEFAULT ((0)),
[phy_absord] [smallint] NULL CONSTRAINT [DF_karakterler_phy_absord] DEFAULT ((0)),
[savearea] [tinyint] NULL CONSTRAINT [DF_karakterler_savearea] DEFAULT ((3)),
[title] [tinyint] NULL CONSTRAINT [DF_karakterler_title] DEFAULT ((0)),
[deleted] [tinyint] NULL CONSTRAINT [DF_karakterler_deleted] DEFAULT ((0)),
[deletedtime] [datetime] NULL CONSTRAINT [DF_karakterler_deletedtime] DEFAULT ('10.10.2010'),
[Slots] [int] NULL CONSTRAINT [DF_karakterler_Slots] DEFAULT ((45)),
[Pvpstate] [tinyint] NULL CONSTRAINT [DF_character_Pkstate] DEFAULT ((0))
) ON [PRIMARY]
/****** Object: Table [dbo].[char_items] Script Date: 11/12/2010 00:57:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[char_items](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [int] NULL,
[itemid] [int] NULL CONSTRAINT [DF_char_items_itemid] DEFAULT ((0)),
[itemnumber] [varchar](50) NULL,
[plusvalue] [tinyint] NULL CONSTRAINT [DF_char_items_plusvalue] DEFAULT ((0)),
[slot] [tinyint] NULL,
[type] [tinyint] NULL CONSTRAINT [DF_char_items_type] DEFAULT ((0)),
[quantity] [smallint] NULL CONSTRAINT [DF_char_items_quantity] DEFAULT ((1)),
[durability] [int] NULL CONSTRAINT [DF_char_items_durability] DEFAULT ((30)),
[inavatar] [bigint] NULL CONSTRAINT [DF_char_items_inavatar] DEFAULT ((0)),
CONSTRAINT [PK_char_items] PRIMARY KEY CLUSTERED
(
[id] 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
[/spoiler]
Mobs buggy
Crashes
Euros don`t work
and much moree. help
