Aga Panel v3 Manual Kurulum

Bazı Kurulumlarda DB`den DB ye gore Degistigi icin Hatalar olu?maktadır.
Sorunsuz Kurulum için


Kod:

drop table [dbo].[_MENU]


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


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


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


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


CREATE TABLE [dbo].[_MENU] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[LinkName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Url] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


CREATE TABLE [dbo].[_NEWS] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[NewsName] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[News] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[NewsDate] [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]


CREATE TABLE [dbo].[_PANELSETTINGS] (
[Title] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ServerName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[IPNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[EbenezerPort] [int] NULL ,
[FTPAdress] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Theme] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Lang] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[kRankUser] [int] NULL ,
[cRankUser] [int] NULL ,
[UserItemsProfile] [int] NULL
) ON [PRIMARY]


CREATE TABLE [dbo].[_TICKETPOSTS] (
[cid] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[tid] [int] NULL ,
[StrAccountID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Post] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Date] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


CREATE TABLE [dbo].[_TICKETS] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[StrAccountID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Date] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Subject] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Message] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Cat] [int] NULL ,
[Status] [int] NULL
) ON [PRIMARY]



insert into _MENU (LinkName, Url) VALUES ('Register', 'index.php?page=register')
insert into _MENU (LinkName, Url) VALUES ('User Ranks', 'index.php?page=ksiralama')
insert into _MENU (LinkName, Url) VALUES ('Clan Ranks', 'index.php?page=clansiralama')
insert into _MENU (LinkName, Url) VALUES ('Who Ýs Online?', 'index.php?page=kimleroyunda')
insert into _MENU (LinkName, Url) VALUES ('Panel Settings', 'index.php?page=usersettings')
insert into _PANELSETTINGS (Title, ServerName, IPNumber, EbenezerPort, FtpAdress, Theme, Lang, kRankUser, cRankUser, UserItemsProfile) VALUES ('BilmemneKO Web Sitesi', 'BilmemneKO', '127.0.0.1', '15001', '127.0.0.1', 'default', 'tr', '25', '25', '1')
insert into _NEWS (NewsName, News, NewsDate, Views, Type) VALUES ('KOPanel Yenilendi', 'Selamlar, <br> Bu KOPanel RoTrKO tarafýndan Cracklanmýþtýr, <br> KOPaneli Indirebilmek için : WwW.PvP-Kenti.CoM Girebilirsiniz', '04-12-2009', '0', 'Yenilik')


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


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


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


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]


CREATE TABLE [dbo].[_VOTELOGS] (
[StrAccountID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[oyid] [int] NULL
) ON [PRIMARY]


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]



insert into _ANKETS (AnketName) VALUES ('KOPanel Nasýl?')
insert into _VOTES (anketid, Name, oysayisi) VALUES ('1', 'Süper!', '0')
insert into _VOTES (anketid, Name, oysayisi) VALUES ('1', 'Ýdare Eder!', '0')
insert into _VOTES (anketid, Name, oysayisi) VALUES ('1', 'Kötü!', '0')


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


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


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


CREATE TABLE [dbo].[_NCSLOGS] (
[StrOldName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[StrNewName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[StrDate] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


CREATE TABLE [dbo].[_PUSITEMS] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[ItemID] [int] NULL ,
[ItemName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Cash] [int] NULL ,
[Count] [int] NULL
) ON [PRIMARY]


CREATE TABLE [dbo].[_PUSSETTINGS] (
[NCSCash] [int] NULL ,
[NTSCash] [int] NULL ,
[PUSStatus] [int] NULL ,
[NCSStatus] [int] NULL ,
[NTSStatus] [int] NULL ,
[ItemsStatus] [int] NULL,
[ClassCash] [int] NULL ,
[ClassStatus] [int] NULL
) ON [PRIMARY]


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

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

CREATE TABLE [dbo].[_CHAT] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[StrAccountID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Tarih] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Yazi] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[_ONLINEUSERS] (
[StrAccountID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[StrIP] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[StrTime] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[StrAuthority] [int] NULL ,
[Page] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[_FORUMLINKS]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[_FORUMLINKS]
GO

CREATE TABLE [dbo].[_FORUMLINKS] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[Link] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO




ALTER TABLE TB_USER ADD Question int;
ALTER TABLE TB_USER ADD Answer varchar(50);
ALTER TABLE TB_USER ADD ProfilNot varchar(500);