K2D K.E(USKO Still + Atlantis pvp) Panel Lisanssız.

**Forum Yöneticisi**

Reklam

'[Linkleri görebilmek için üye olun veya giriş yapın.]' PaneL...!!!
--------------------------

Demo Atlantis Panel: [Linkleri görebilmek için üye olun veya giriş yapın.]

Link: [Linkleri görebilmek için üye olun veya giriş yapın.]

Rar Şifresi ; Valante
Buyrun Buda SQL KODLARI
--------------------------------------------------------------------
//// K2D ADMIN TB_User Gerekli Table //

//Başlangıç

ALTER TABLE TB_USER
ADD CashPoint int
ALTER TABLE TB_USER
ADD StrSoru varchar(500)
ALTER TABLE TB_USER
ADD StrYanit varchar(500)
ALTER TABLE TB_USER
ADD Nick varchar(21)
ALTER TABLE TB_USER
ADD Access varchar(12)
ALTER TABLE TB_USER
ADD ulke varchar (50)

/// K2D Siteye Admin Ekleme

update tb_user set access='5',cashpoint='99999999' where straccountid='Giriş ID'

//Bitiş

/// K2D GEREKLİ TABLO BAŞLANGIC //

CREATE TABLE [_Anket] (
[Anket_ID] [int] IDENTITY (1, 1) NOT NULL ,
[Konu] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Madde1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Madde2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Madde3] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Oy1] [int] NOT NULL CONSTRAINT [DF_Anket_Oy1] DEFAULT (0),
[Oy2] [int] NOT NULL CONSTRAINT [DF_Anket_Oy2] DEFAULT (0),
[Oy3] [int] NOT NULL CONSTRAINT [DF_Anket_Oy3] DEFAULT (0),
[Tarih] [smalldatetime] NULL CONSTRAINT [DF_Anket_Tarih] DEFAULT (getdate()),
[Haber_ID] [int] NULL CONSTRAINT [DF_Anket_Haber_ID] DEFAULT (0),
[Yer] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Anket_Yer] DEFAULT ('N')
) ON [PRIMARY]
GO

CREATE TABLE [_Anket_Oylayanlar] (
[Oy_Kullanan] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Anket_ID] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [_Aktivite] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[konu] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[aktivite] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[tarih] [smalldatetime] NOT NULL CONSTRAINT [DF_aktivite_tarih] DEFAULT (getdate()),
CONSTRAINT [PK_Aktivite] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [_K2DLoyalty] (
[Clan_Sid] [int] NULL ,
[Clan_Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[strUserID] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Loyalty] [int] NULL ,
[Sayi] [int] NULL CONSTRAINT [DF_K2DLoyalty_Sayi] DEFAULT (1),
[Tarih] [smalldatetime] NOT NULL CONSTRAINT [DF_K2DLoyalty_Tarih] DEFAULT (getdate()),
[Son_Tarih] [smalldatetime] NOT NULL CONSTRAINT [DF_K2DLoyalty_Son_Tarih] DEFAULT (getdate())
) ON [PRIMARY]
GO

CREATE TABLE [_Haber] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[konu] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[haber] [varchar] (5000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[tarih] [smalldatetime] NOT NULL CONSTRAINT [DF_news_tarih] DEFAULT (getdate()),
CONSTRAINT [PK_NEWS] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [_IP_Engelliler] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[ip] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[strAccountID] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Char_1] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Char_2] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Char_3] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Tarih_Default] [smalldatetime] NOT NULL CONSTRAINT [DF_IP_ENGELLILER_Tarih] DEFAULT (getdate()),
[Tarih] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Silinme_Tarihi] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [_Link] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[adi] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[link] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[indirilme] [int] NOT NULL CONSTRAINT [DF_LINK_downsay] DEFAULT (0),
[tarih] [smalldatetime] NOT NULL CONSTRAINT [DF_dosyalar_tarih] DEFAULT (getdate())
) ON [PRIMARY]
GO

/* Kullanmadım.. */
CREATE TABLE [_Mail] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[gonderen] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[gonderilen] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[msj] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[tarih] [smalldatetime] NOT NULL CONSTRAINT [DF_MAIL_tarih] DEFAULT (getdate()),
[okundu] [int] NULL CONSTRAINT [DF_MAIL_okundu] DEFAULT (0),
CONSTRAINT [PK_MAIL] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [_Sifre_Degistir] (
[strAccountId] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[strEmail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[strAccMD5] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[strCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Tarih] [smalldatetime] NULL CONSTRAINT [DF__Sifre_Degiştir_Tarih] DEFAULT (getdate()),
[Durum] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__Sifre_Degistir_Durum] DEFAULT ('Pasif')
) ON [PRIMARY]
GO

CREATE TABLE [_Sikayet] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[eden] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[zanli] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[aciklama] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[resim] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[dosya] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[tarih] [smalldatetime] NULL CONSTRAINT [DF_sikayet_tarih] DEFAULT (getdate()),
CONSTRAINT [PK_sikayet] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [_Ticket] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[ticket_type] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[aciliyet] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ticket] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[kim] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[tarih] [smalldatetime] NULL CONSTRAINT [DF__Ticket_tarih] DEFAULT (getdate()),
[durum] [int] NULL CONSTRAINT [DF__Ticket_durum] DEFAULT (1)
) ON [PRIMARY]
GO

CREATE TABLE [_Ticket_Cevap] (
[Ticket_Id] [int] NULL ,
[Cevaplayan] [varchar] (21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Cevap] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Tarih] [smalldatetime] NULL CONSTRAINT [DF__Ticket_Cevap_Tarih] DEFAULT (getdate())
) ON [PRIMARY]
GO

/// K2D TABLO BİTİŞ //