Özellikleri:
Anasayfadan Bir Resim:
SQL KODLARI:
PHP- Kodu:
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 Yapmak İçin:
PHP- Kodu:
update tb_user set StrAuthority = '5' where StrAccountID = 'KullanıcıAdı'
- nDesign KOPanel v4.2 üye üzerine temellendirildi!
- Usko Tasarımı üzerine Twostars KOPanel grafikleri eklenerek geliştirildi.
- Ajax Clan ve User Sıralaması eklendi.
- Aylık Pointte göre Aylık Sıralaması eklendi.
- Admin Paneline Download Manager Eklendi. (Download linklerini Menüye ordan ekleyebilirsiniz.)
- Seo Sistemi Eklendi.
Anasayfadan Bir Resim:
SQL KODLARI:
PHP- Kodu:
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 Yapmak İçin:
PHP- Kodu:
update tb_user set StrAuthority = '5' where StrAccountID = 'KullanıcıAdı'