### [nDesign v4.1] • [Gelişmiş PaneL Sistemi] ###

update tb_user set StrAuthority = '5' where StrAccountID = 'KullanıcıAdı'

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Ticket](
[TicketNumara] [nvarchar](999) NULL,
[Oyuncu] [nvarchar](999) NULL,
[Ticketi] [nvarchar](999) NULL,
[durumu] [nvarchar](999) NULL,
[seviye] [nvarchar](999) NULL,
[Cevap] [nvarchar](999) NULL,
[admin] [nvarchar](999) NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Ticket] ADD  CONSTRAINT [DF_Ticket_durumu]  DEFAULT ((1)) FOR [durumu]
GO 

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PUS_ITEMLERI]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PUS_ITEMLERI]


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[news]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Haber]


CREATE TABLE [dbo].[PUS_ITEMLERI] (
    [id] [int] NOT NULL ,
    [type] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [itemismi] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [ucret] [int] NULL ,
    [adet] [smallint] NULL ,
    [itemkodu] [int] NULL ,
    [resim] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [alindi] [int] NULL ,
    [detay] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


CREATE TABLE [dbo].[Haber] (
    [id] [int] IDENTITY (1, 1) NOT FOR REPLICATION  NOT NULL ,
    [konu] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [news] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [tarih] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [gonderen] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
    [type] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

ALTER TABLE TB_USER
 ADD CashPoint int
ALTER TABLE TB_USER
 ADD StrSoru varchar(500)
ALTER TABLE TB_USER
 ADD StrYanit varchar(500)
 
 
insert into news values ('Ko Panel Yenilendi!' , 'Bu KOPanel Metin304 Tarafindan kodlanmistir.Güle Güle Kullanın...' , '08-11-2008' , 'Metin304' , 3)

insert into PUS_ITEMLERI values (1 , 'silah' , '*  Elixir Staff +9' , 1000 , 1 , 181110059 , 'elixir.jpg' , 1 , 'asdasda')
insert into PUS_ITEMLERI values (2 , 'silah' , '* Iron Impact +9' , 1000 , 1 , 146210059 , 'ironimpact.GIF' , 10 , 'asdasd')
insert into PUS_ITEMLERI values (3 , 'silah' , '* Priest Impact +9 ' , 1000 , 1 , 191110059 , 'priestimpact.jpg' , 2 , 'asdasd')
insert into PUS_ITEMLERI values (4 , 'silah' , '*  Raptor +9' , 1000 , 1 , 156210009 , 'raptor.jpg' , 33 , 'asdasd')
insert into PUS_ITEMLERI values (5 , 'silah' , '*  Shard +9' , 1000 , 1 , 111210009 , 'shard.jpg' , 22 , 'asdasd')
insert into PUS_ITEMLERI values (6 , 'kiyafet' , '* Warrior Chitin Shell Boots (+9)' , 2000 , 1 , 206005018 , 'WariorBoot.jpg' , 1 , 'asdasd')
insert into PUS_ITEMLERI values (8 , 'kiyafet' , '* Warrior Chitin Shell Gauntlet (+9)' , 2000 , 1 , 206004019 , 'WariorGauntlet.jpg' , 1 , 'asd')
insert into PUS_ITEMLERI values (9 , 'kiyafet' , '* Warrior Chitin Shell Helmet (+9)' , 2000 , 1 , 206003019 , 'WariorHelmet.jpg' , 1 , 'asdasd')
insert into PUS_ITEMLERI values (10 , 'kiyafet' , '* Warrior Chitin Shell Pads (+9)' , 2000 , 1 , 206002019 , 'WariorPad.jpg' , 1 , 'asdasd')
insert into PUS_ITEMLERI values (11 , 'kiyafet' , '* Warrior Chitin Shell Pauldron (+9)' , 2000 , 1 , 206001019 , 'WariorPauldron.jpg' , 1 , 'asdas')
insert into PUS_ITEMLERI values (12 , 'kiyafet' , '* Rogue Chitin Shell Pads (+9)' , 2000 , 1 , 246002519 , 'RoguePad.jpg' , 1 , 'asdasd')
insert into PUS_ITEMLERI values (13 , 'kiyafet' , '* Rogue Chitin Shell Pauldron (+9)' , 2000 , 1 , 246001519 , 'RoguePauldron.jpg' , 1 , 'asdasd')
insert into PUS_ITEMLERI values (14 , 'kiyafet' , '* Rogue Chitin Shell Helmet (+9)' , 2000 , 1 , 246003519 , 'RogueHelmet.jpg' , 1 , 'asdasd')
insert into PUS_ITEMLERI values (15 , 'kiyafet' , '* Rogue Chitin Shell Gauntlet (+9)' , 2000 , 1 , 246004519 , 'RogueGauntlet.jpg' , 1 , 'asdasdas')
insert into PUS_ITEMLERI values (16 , 'kiyafet' , '* Rogue Chitin Shell Boots (+9)' , 2000 , 1 , 246005519 , 'RogueBoot.jpg' , 1 , 'asdasd')
insert into PUS_ITEMLERI values (17 , 'kiyafet' , '* Complete Robe (+9)' , 1800 , 1 , 266001509 , 'MageRobe.jpg' , 1 , 'asdasd')
insert into PUS_ITEMLERI values (18 , 'kiyafet' , '* Complete Pants (+9)' , 1800 , 1 , 266002509 , 'MagePanth.jpg' , 1 , 'asdasd')
insert into PUS_ITEMLERI values (19 , 'kiyafet' , '* Complete Helmet (+9)' , 1800 , 1 , 266003509 , 'MageHelmet.jpg' , 1 , 'asdasd')
insert into PUS_ITEMLERI values (20 , 'kiyafet' , '* Complete Glove (+9)' , 1800 , 1 , 266004509 , 'MageGauntlet.jpg' , 1 , 'asdasd')
insert into PUS_ITEMLERI values (21 , 'kiyafet' , '* Complete Boots (+9)' , 1800 , 1 , 266005509 , 'MageBoot.jpg' , 1 , 'asdasd')
insert into PUS_ITEMLERI values (22 , 'kiyafet' , '* Priest Chitin Shell Pauldron (+9)' , 1900 , 1 , 286001509 , 'PriestPauldron.jpg' , 1 , 'asdasd')
insert into PUS_ITEMLERI values (23 , 'kiyafet' , '* Priest Chitin Shell Pads (+9)' , 1900 , 1 , 286002509 , 'PriestPad.jpg' , 1 , 'asdasd')
insert into PUS_ITEMLERI values (24 , 'kiyafet' , '* Priest Chitin Shell Helmet (+9)' , 1900 , 1 , 286003509 , 'PriestHelmet.jpg' , 1 , 'adasd')
insert into PUS_ITEMLERI values (25 , 'kiyafet' , '* Priest Chitin Shell Gauntlet (+9)' , 1900 , 1 , 286004509 , 'PriestGauntlet.jpg' , 1 , 'asd')