|
You last visited: Today at 08:17
Advertisement
WEBSITE_DBF ???
Discussion on WEBSITE_DBF ??? within the Flyff Private Server forum part of the Flyff category.
05/19/2012, 22:11
|
#1
|
elite*gold: 0
Join Date: Aug 2011
Posts: 400
Received Thanks: 26
|
WEBSITE_DBF ???
hallo zusammen
ich habe gerade meine website_dbf gelöscht und wollte fragen ob sie nochmal jemand hat für mich wäre nett wenn mir jemand weiterhelfen kann denn ich finde die hier nirgends mehr danke im vorraus
|
|
|
05/19/2012, 22:34
|
#2
|
elite*gold: 0
Join Date: Dec 2010
Posts: 164
Received Thanks: 54
|
meinst du die von lc hp?
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
|
|
|
05/19/2012, 22:43
|
#3
|
elite*gold: 0
Join Date: Aug 2011
Posts: 400
Received Thanks: 26
|
danke das hat mir weitergeholfen =)
|
|
|
05/20/2012, 00:13
|
#4
|
elite*gold: 18
Join Date: Sep 2009
Posts: 20,174
Received Thanks: 14,475
|
#Closed
|
|
|
Similar Threads
|
[HELP] WEBSITE_DBF erstellen
04/07/2012 - Flyff Private Server - 10 Replies
Hallo,
ich bräuchte Hilfe mit dem erstellen der WEBSITE_DBF Datenbank in MSSQL.
Ich habe es einmal so versucht:
http://www.pic-upload.de/view-13668421/Erstes-all es-in-einem.jpg.html
Pic-Upload.de - Erstes-alles-in-einem.jpg
Dann habe ich noch gelesen, dass man es so machen könnte:
http://www.pic-upload.de/view-13668509/Zweites-al les-in-einem.jpg.html
Pic-Upload.de - Zweites-alles-in-einem.jpg
Doch keine der beiden Möglichkeiten hat funktioniert. :-/
|
WEBSITE_DBF.bak
02/16/2012 - Flyff Private Server - 13 Replies
Any got the .bak file for WEBSITE_DBF because I need it in my server. I already got it and when I deleted it, I forgot that I don't have the backup for it.
If anyone would help me by giving/sharing the .bak files for it, that would be great.
Thanks,
inteL
|
All times are GMT +1. The time now is 08:17.
|
|