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].[news]
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].[news] (
[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!' , '<b><br> Bu KOPanel Ko-Cuce.Com Ekibi Tarafindan kodlanmistir. <br> Sizde edinmek isterseniz , www.ko-cuce.com BekleriZ!' , '08-11-2021' , 'ganks' , 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')
insert into PUS_ITEMLERI values (26 , 'kiyafet' , '* Priest Chitin Shell Boots (+9)' , 1900 , 1 , 286005509 , 'PriestBoot.jpg' , 1 , 'asd')