PHP Code:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[char_items]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[char_items]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[hotkeys]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[hotkeys]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[karakterler]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[karakterler]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[news]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[news]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[saved_skills]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[saved_skills]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[server]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[server]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[serverlar]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[serverlar]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[users]
GO
CREATE TABLE [dbo].[char_items] (
[owner] [varchar] (50) COLLATE Turkish_CI_AS NULL ,
[itemnumber] [int] NULL ,
[quantity] [int] NULL ,
[itemid] [int] NULL ,
[type] [int] NULL ,
[slot] [int] NULL ,
[inavatar] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[hotkeys] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[owner] [varchar] (15) COLLATE Turkish_CI_AS NOT NULL ,
[slot] [int] NOT NULL ,
[type] [int] NOT NULL ,
[hotkeyid] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[karakterler] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[account] [varchar] (20) COLLATE Turkish_CI_AS NULL ,
[name] [varchar] (45) COLLATE Turkish_CI_AS NULL ,
[chartype] [int] NULL ,
[volume] [int] NULL ,
[level] [int] NULL ,
[strength] [int] NULL ,
[intelligence] [int] NULL ,
[attribute] [int] NULL ,
[hp] [int] NULL ,
[mp] [int] NULL ,
[s_hp] [int] NULL ,
[s_mp] [int] NULL ,
[gold] [int] NULL ,
[experience] [int] NULL ,
[sp] [int] NULL ,
[gm] [int] NULL ,
[xsect] [int] NULL ,
[ysect] [int] NULL ,
[xpos] [int] NULL ,
[ypos] [int] NULL ,
[zpos] [int] NULL ,
[min_phyatk] [int] NULL ,
[max_phyatk] [int] NULL ,
[min_magatk] [int] NULL ,
[max_magatk] [int] NULL ,
[phydef] [int] NULL ,
[magdef] [int] NULL ,
[hit] [int] NULL ,
[parry] [int] NULL ,
[walkspeed] [int] NULL ,
[runspeed] [int] NULL ,
[berserkspeed] [int] NULL ,
[berserkbar] [int] NULL ,
[skillpointbar] [int] NULL ,
[berserking] [int] NULL ,
[pvp] [int] NULL ,
[maxitemslot] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[news] (
[head] [char] (10) COLLATE Turkish_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[saved_skills] (
[owner] [varchar] (50) COLLATE Turkish_CI_AS NULL ,
[AmountSkill] [int] NULL ,
[Skill] [varchar] (50) COLLATE Turkish_CI_AS NULL ,
[skillid] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[server] (
[id] [int] NOT NULL ,
[serverid] [int] NOT NULL ,
[name] [varchar] (50) COLLATE Turkish_CI_AS NOT NULL ,
[users_current] [int] NOT NULL ,
[users_max] [int] NOT NULL ,
[state] [int] NOT NULL ,
[ip] [varchar] (50) COLLATE Turkish_CI_AS NOT NULL ,
[port] [int] NOT NULL ,
[status] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[serverlar] (
[serverid] [int] NULL ,
[name] [char] (16) COLLATE Turkish_CI_AS NULL ,
[user_current] [char] (10) COLLATE Turkish_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[users] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[username] [varchar] (20) COLLATE Turkish_CI_AS NULL ,
[password] [varchar] (20) COLLATE Turkish_CI_AS NULL ,
[blocked] [bit] NULL ,
[connected] [bit] NULL ,
[online] [char] (10) COLLATE Turkish_CI_AS NULL
) ON [PRIMARY]
GO
Cry noobs, need to fix some kind of values there.. that's my version of db..
who know what i must type in "users" table?