...Link Görebilmek İçin Mesaj Yazınız...
[/url]PANEL RESİM:
- Kod:
SQL İŞLENMESİ GEREKEN KOD:
CREATE TABLE [b4tu] (
[title] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ipadresi] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[savas] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[event] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[adminmsn] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[duyuru] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[forum] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[serveradi] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
insert into b4tu values ('************* Empire' , '127.0.0.1' , 'Henüz Belirlenmemis.' , 'Henüz Belirlenmemis.' , 'enes_knight16@hotmail.com' , '[Linkleri görebilmek için üye olun veya giriş yapın.] Knight Pvp Server Tanıtıma Sitesi' , 'http://www.server-tanitimi.blogspot.com//' , 7)
CREATE TABLE [b4tumodul] (
[login] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[b4tudetay] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ticket] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[usergoster] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[clangoster] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[cezagoster] [nvarchar] (999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
insert into b4tumodul values ( 'acik' , 'acik' , 'acik' , 50 , 50 , 50 )
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
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]
CREATE TABLE [dbo].[MYKOL](
[StrAccountID] [varchar](50) NULL,
[MyKOLSoru] [varchar](50) NULL,
[MyKOLCevap] [varchar](50) NULL
) ON [PRIMARY]
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[_ANKETS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[_ANKETS]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[_DOWNLOADS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[_DOWNLOADS]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[_MYKOL]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[_MYKOL]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[_VOTELOGS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[_VOTELOGS]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[_VOTES]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[_VOTES]
GO
CREATE TABLE [dbo].[_ANKETS] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[AnketName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[_DOWNLOADS] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[strTitle] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[strLink] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[_VOTELOGS] (
[StrAccountID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[oyid] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[_VOTES] (
[oyid] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[anketid] [int] NULL ,
[Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[oysayisi] [int] NULL
) ON [PRIMARY]
GO