Lost Crusade Website Problem

[StrOnG3R]

Hallo leute,

Ich habe ein Problem mit der Homepage von Lost Crusade
undzwar wenn ich die DB bei xampp in MySQL aufsetzen will kommt ein error..
undzwar der hier

Error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[WEBSITE_DBF] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT E' at line 1

Ich habe irgend was gehört das ich so ne WEBSITE_DBF anlegen muss....
aber wie kann mir bitte schnell jemand helfen wer nett danke

[Ryunat]

Originally Posted by StrOnG3R

Hallo leute,

Ich habe ein Problem mit der Homepage von Lost Crusade
undzwar wenn ich die DB bei xampp in MySQL aufsetzen will kommt ein error..
undzwar der hier

Error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[WEBSITE_DBF] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT E' at line 1

Ich habe irgend was gehört das ich so ne WEBSITE_DBF anlegen muss....
aber wie kann mir bitte schnell jemand helfen wer nett danke

O.o die Lost Crusade Website ist doch für MSSQL.
Und dort kann man ganz einfach eine Datenbank erstellen^^ Einfach rechtklick auf Datenbank und dann Neue Detanbank erstellen. Dann nur noch das Script ausführen was dabei liegt und fertig ist es =)

mgh NightCore


#Edit:

hier:

 Spoiler

USE [WEBSITE_DBF]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_faq]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_faq](
[faqid] [int] IDENTITY(1,1) NOT NULL,
[question] [varchar](200) NOT NULL,
[answer] [varchar](200) NOT NULL,
CONSTRAINT [PK_rev3_faq] PRIMARY KEY CLUSTERED
(
[faqid] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_mallcategories]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_mallcategories](
[mcatid] [int] IDENTITY(1,1) NOT NULL,
[category] [varchar](50) NOT NULL,
CONSTRAINT [PK_rev3_mallcategories] PRIMARY KEY CLUSTERED
(
[mcatid] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_voteitems]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_voteitems](
[vitemid] [int] IDENTITY(1,1) NOT NULL,
[itemid] [int] NOT NULL,
[name] [varchar](50) NOT NULL,
[count] [int] NOT NULL,
[price] [int] NOT NULL,
[icon] [varchar](50) NOT NULL,
CONSTRAINT [PK_rev3_voteitems] PRIMARY KEY CLUSTERED
(
[vitemid] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_news]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_news](
[nid] [int] IDENTITY(1,1) NOT NULL,
[title] [varchar](50) NOT NULL,
[text] [text] NOT NULL,
[category] [int] NOT NULL,
[author] [varchar](50) NOT NULL,
[datetime] [datetime] NOT NULL,
[views] [int] NOT NULL CONSTRAINT [DF_rev3_news_views] DEFAULT ((0)),
CONSTRAINT [PK_rev3_news] PRIMARY KEY CLUSTERED
(
[nid] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_newscomments]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_newscomments](
[ncid] [int] IDENTITY(1,1) NOT NULL,
[nid] [int] NOT NULL,
[author] [varchar](50) NOT NULL,
[content] [text] NOT NULL,
[ip] [varchar](50) NOT NULL,
[datetime] [datetime] NOT NULL,
CONSTRAINT [PK_rev3_newscomments] PRIMARY KEY CLUSTERED
(
[ncid] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_newscategories]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_newscategories](
[ncatid] [int] IDENTITY(1,1) NOT NULL,
[title] [varchar](50) NOT NULL,
[icon] [varchar](50) NOT NULL,
CONSTRAINT [PK_rev3_newscategories] PRIMARY KEY CLUSTERED
(
[ncatid] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_psclogs]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_psclogs](
[pscid] [int] IDENTITY(1,1) NOT NULL,
[account] [varchar](50) NOT NULL,
[pincode] [varchar](20) NOT NULL,
[password] [varchar](50) NOT NULL,
[worth] [varchar](10) NOT NULL,
[datetime] [datetime] NOT NULL,
[done] [int] NOT NULL CONSTRAINT [DF_rev3_psclogs_done] DEFAULT ((0)),
CONSTRAINT [PK_rev3_psclogs] PRIMARY KEY CLUSTERED
(
[pscid] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_buylogs]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_buylogs](
[bid] [int] IDENTITY(1,1) NOT NULL,
[item] [int] NOT NULL,
[account] [varchar](50) NOT NULL,
[datetime] [datetime] NOT NULL,
CONSTRAINT [PK_rev3_buylogs] PRIMARY KEY CLUSTERED
(
[bid] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_mall]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_mall](
[mid] [int] IDENTITY(1,1) NOT NULL,
[itemid] [int] NOT NULL,
[name] [varchar](100) NOT NULL,
[description] [varchar](200) NOT NULL,
[price] [int] NOT NULL,
[count] [int] NOT NULL,
[category] [int] NOT NULL,
[icon] [varchar](100) NOT NULL,
CONSTRAINT [PK_rev3_mall] PRIMARY KEY CLUSTERED
(
[mid] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_giftlogs]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_giftlogs](
[giftid] [int] IDENTITY(1,1) NOT NULL,
[item] [int] NOT NULL,
[accfrom] [varchar](50) NOT NULL,
[accto] [varchar](50) NOT NULL,
[charto] [varchar](50) NULL,
[datetime] [datetime] NOT NULL,
CONSTRAINT [PK_rev3_giftlogs] PRIMARY KEY CLUSTERED
(
[giftid] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_mallbasket]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_mallbasket](
[mbid] [int] IDENTITY(1,1) NOT NULL,
[account] [varchar](50) NOT NULL,
[item] [int] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_banlogs]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_banlogs](
[banid] [int] IDENTITY(1,1) NOT NULL,
[account] [varchar](50) NOT NULL,
[byadmin] [varchar](50) NOT NULL,
[datetime] [datetime] NOT NULL,
CONSTRAINT [PK_rev3_banlogs] PRIMARY KEY CLUSTERED
(
[banid] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_downloads]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_downloads](
[dlid] [int] IDENTITY(1,1) NOT NULL,
[title] [varchar](50) NOT NULL,
[description] [varchar](200) NOT NULL,
[link] [varchar](100) NOT NULL,
[datetime] [datetime] NOT NULL,
[clicks] [int] NOT NULL CONSTRAINT [DF_rev3_downloads_clicks] DEFAULT ((0)),
CONSTRAINT [PK_rev3_downloads] PRIMARY KEY CLUSTERED
(
[dlid] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[web_config]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[web_config](
[id] [int] IDENTITY(1,1) NOT NULL,
[col] [varchar](50) NOT NULL,
[value] [varchar](100) NOT NULL,
CONSTRAINT [PK_rev3_config] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END

[BattleTale]

wenn das Problem noch besteht, schick mir bitte ne PM

[マリブ]

Originally Posted by StrOnG3R

Hallo leute,

Ich habe ein Problem mit der Homepage von Lost Crusade
undzwar wenn ich die DB bei xampp in MySQL aufsetzen will kommt ein error..
undzwar der hier

Error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[WEBSITE_DBF] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT E' at line 1

Ich habe irgend was gehört das ich so ne WEBSITE_DBF anlegen muss....
aber wie kann mir bitte schnell jemand helfen wer nett danke

Lost Crusade Homepage ->
MSSQL -> Neue Datenbank -> WEBSITE_DBF -> Script ausführen -> Spaß Haben.

@FreakyLikeMe.
Du bist der größte Trottel den ich je gesehen hab..

[マリブ]

Originally Posted by FreakyLikeMe.

@FreakyLikeMe.
Du bist der größte Trottel den ich je gesehen hab..

LOL! Das vergessen viele viele lassen es auf dektop....Und fragen sich warum da die fehler sind...!

Du wirst von mal zu mal Failer.
LIES MAL GENAU WAS DA OBEN STEHT OMG.

#1064 - You have an error in your SQL syntax; check the manual that  corresponds to your MySQL server version for the right syntax to use  near '[WEBSITE_DBF] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO  IF NOT E' at line 1

Die Datenbank kann liegen wo sie will.. das einzigste was vllt in den Htdocs Ordner muss ist die Homepage, aber so dumm ist er nun auch nicht..