Help

11/22/2010 14:10 !Razor#1
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]
I using this, but i can`t :

Mobs buggy
Crashes
Euros don`t work

and much moree. help
11/22/2010 14:10 !Razor#2
prem+ doesn`t work too

and much more..
11/22/2010 17:12 [GM]#3
use rev 74 it works fine euros,etc
11/22/2010 17:16 !Razor#4
can you .rar your folder, and upload it?

i will change all infos and so.. please?
11/23/2010 00:13 Monaiz#5
#Request Close