Orlando V1 %100 Sorunsuz Panel Açıksız

Ana sayfa görünüm:

Sorunsuz çalışması için aşşağıdaki kodu QA ya girin.

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

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

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

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

CREATE TABLE [dbo].[_HABER] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[haberadi] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[haber] [varchar] (1500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[date] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[views] [int] NULL ,
[type] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

insert into _HABER (haberadi, haber, date, views, type) VALUES (‘KOPanel Yenilendi’, ‘Merhaba, Bu KOPanel Orlando tarafından <b>KO-CÜCE ve TÜRKKE</b> için kodlanmıştır.’, ’19/11/2010′, ’1′, ’4′)

CREATE TABLE [dbo].[MYKOL](
[StrAccountID] [varchar](50) NULL,
[MyKOLSoru] [varchar](50) NULL,
[MyKOLCevap] [varchar](50) NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[_DOWNLOAD] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[linkadi] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[linkurl] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

CREATE TABLE [dbo].[_TICKET](
[TicketNumara] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Oyuncu] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Ticketi] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[durumu] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[seviye] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Cevap] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[admin] [varchar](999) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]

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

ALTER TABLE TB_USER
ADD CashPoint int
ALTER TABLE TB_USER
ADD StrSoru varchar(500)
ALTER TABLE TB_USER
ADD StrYanit varchar(500)

Admin eklemek için (QA ya girin )

update tb_user set StrAuthority = ’5′ where StrAccountID = ‘KullanıcıAdı‘

LİNK:TIKLA İNDİR