Hallo leute.
Ich habe nun Die Files von jemandem Abgekauft.
Name werde ich hier nicht sagen.
Aber ich versuche gerade mit MySQL die Datenbank rauf
zusetzten, aber alles was er mir sagt ist nur.
Info: MySQL installiert.
Und diese hatte ich auch schon:
bei MS SQL Maestro
Und hier das noch:
Sobald bei mir alles geht, werde ich die Files Pub machen.
Um so mehr Leute sie haben um So mehr neue Sachen,
Meine Meinung.
Ich habe nun Die Files von jemandem Abgekauft.
Name werde ich hier nicht sagen.
Aber ich versuche gerade mit MySQL die Datenbank rauf
zusetzten, aber alles was er mir sagt ist nur.
Info: MySQL installiert.
Diese Fehlermeldung bei Navicat For MySQL
[Err] 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 '[WARROCK_DBF]
GO
/****** Object: Table [dbo].[INVENTORY_TBL] Script Date: ' at line 1
[Err] USE [WARROCK_DBF]
GO
/****** Object: Table [dbo].[INVENTORY_TBL] Script Date: 01/04/2010 21:11:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[INVENTORY_TBL](
[userID] [bigint] NOT NULL,
[itemCode] [varchar](11) NOT NULL,
[expireDate] [bigint] NULL,
[class_0] [int] NULL,
[class_1] [int] NULL,
[class_2] [int] NULL,
[class_3] [int] NULL,
[class_4] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ACCOUNT_TBL_DETAIL] Script Date: 01/04/2010 21:11:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ACCOUNT_TBL_DETAIL](
[userID] [bigint] NOT NULL,
[exp] [bigint] NOT NULL,
[level] [int] NOT NULL,
[dinar] [bigint] NOT NULL,
[kills] [bigint] NULL,
[deaths] [bigint] NULL,
[premium] [int] NULL,
[premiumTime] [bigint] NULL,
[premiumDate] [bigint] NULL,
[banDate] [bigint] NULL,
[banTime] [bigint] NULL,
[lastIP] [varchar](32) NULL,
[lastLogin] [varchar](32) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ACCOUNT_TBL] Script Date: 01/04/2010 21:11:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ACCOUNT_TBL](
[userID] [bigint] NOT NULL,
[username] [varchar](32) NOT NULL,
[nickname] [varchar](32) NULL,
[password] [varchar](32) NOT NULL,
[accesslevel] [int] NOT NULL,
[online] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Default [DF_INVENTORY_TBL_] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD CONSTRAINT [DF_INVENTORY_TBL_] DEFAULT ((0)) FOR [expireDate]
GO
/****** Object: Default [DF_INVENTORY_TBL_slotEngineer] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD CONSTRAINT [DF_INVENTORY_TBL_slotEngineer] DEFAULT ((-1)) FOR [class_0]
GO
/****** Object: Default [DF_INVENTORY_TBL_slotMedic] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD CONSTRAINT [DF_INVENTORY_TBL_slotMedic] DEFAULT ((-1)) FOR [class_1]
GO
/****** Object: Default [DF_INVENTORY_TBL_slotSniper] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD CONSTRAINT [DF_INVENTORY_TBL_slotSniper] DEFAULT ((-1)) FOR [class_2]
GO
/****** Object: Default [DF_INVENTORY_TBL_slotAssault] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD CONSTRAINT [DF_INVENTORY_TBL_slotAssault] DEFAULT ((-1)) FOR [class_3]
GO
/****** Object: Default [DF_INVENTORY_TBL_slotHeavyTrooper] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD CONSTRAINT [DF_INVENTORY_TBL_slotHeavyTrooper] DEFAULT ((-1)) FOR [class_4]
GO
/****** Object: Default [DF_ACCOUNT_TBL_DETAIL_exp] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_exp] DEFAULT ((0)) FOR [exp]
GO
/****** Object: Default [DF_ACCOUNT_TBL_DETAIL_level] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_level] DEFAULT ((1)) FOR [level]
GO
/****** Object: Default [DF_ACCOUNT_TBL_DETAIL_dinar] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_dinar] DEFAULT ((0)) FOR [dinar]
GO
/****** Object: Default [DF_ACCOUNT_TBL_DETAIL_kills] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_kills] DEFAULT ((0)) FOR [kills]
GO
/****** Object: Default [DF_ACCOUNT_TBL_DETAIL_deaths] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_deaths] DEFAULT ((0)) FOR [deaths]
GO
/****** Object: Default [DF_ACCOUNT_TBL_DETAIL_premium] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD CONSTRAINT [DF
[Msg] Finished - Unsuccessfully
--------------------------------------------------
GO
/****** Object: Table [dbo].[INVENTORY_TBL] Script Date: ' at line 1
[Err] USE [WARROCK_DBF]
GO
/****** Object: Table [dbo].[INVENTORY_TBL] Script Date: 01/04/2010 21:11:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[INVENTORY_TBL](
[userID] [bigint] NOT NULL,
[itemCode] [varchar](11) NOT NULL,
[expireDate] [bigint] NULL,
[class_0] [int] NULL,
[class_1] [int] NULL,
[class_2] [int] NULL,
[class_3] [int] NULL,
[class_4] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ACCOUNT_TBL_DETAIL] Script Date: 01/04/2010 21:11:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ACCOUNT_TBL_DETAIL](
[userID] [bigint] NOT NULL,
[exp] [bigint] NOT NULL,
[level] [int] NOT NULL,
[dinar] [bigint] NOT NULL,
[kills] [bigint] NULL,
[deaths] [bigint] NULL,
[premium] [int] NULL,
[premiumTime] [bigint] NULL,
[premiumDate] [bigint] NULL,
[banDate] [bigint] NULL,
[banTime] [bigint] NULL,
[lastIP] [varchar](32) NULL,
[lastLogin] [varchar](32) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Table [dbo].[ACCOUNT_TBL] Script Date: 01/04/2010 21:11:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ACCOUNT_TBL](
[userID] [bigint] NOT NULL,
[username] [varchar](32) NOT NULL,
[nickname] [varchar](32) NULL,
[password] [varchar](32) NOT NULL,
[accesslevel] [int] NOT NULL,
[online] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object: Default [DF_INVENTORY_TBL_] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD CONSTRAINT [DF_INVENTORY_TBL_] DEFAULT ((0)) FOR [expireDate]
GO
/****** Object: Default [DF_INVENTORY_TBL_slotEngineer] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD CONSTRAINT [DF_INVENTORY_TBL_slotEngineer] DEFAULT ((-1)) FOR [class_0]
GO
/****** Object: Default [DF_INVENTORY_TBL_slotMedic] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD CONSTRAINT [DF_INVENTORY_TBL_slotMedic] DEFAULT ((-1)) FOR [class_1]
GO
/****** Object: Default [DF_INVENTORY_TBL_slotSniper] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD CONSTRAINT [DF_INVENTORY_TBL_slotSniper] DEFAULT ((-1)) FOR [class_2]
GO
/****** Object: Default [DF_INVENTORY_TBL_slotAssault] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD CONSTRAINT [DF_INVENTORY_TBL_slotAssault] DEFAULT ((-1)) FOR [class_3]
GO
/****** Object: Default [DF_INVENTORY_TBL_slotHeavyTrooper] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD CONSTRAINT [DF_INVENTORY_TBL_slotHeavyTrooper] DEFAULT ((-1)) FOR [class_4]
GO
/****** Object: Default [DF_ACCOUNT_TBL_DETAIL_exp] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_exp] DEFAULT ((0)) FOR [exp]
GO
/****** Object: Default [DF_ACCOUNT_TBL_DETAIL_level] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_level] DEFAULT ((1)) FOR [level]
GO
/****** Object: Default [DF_ACCOUNT_TBL_DETAIL_dinar] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_dinar] DEFAULT ((0)) FOR [dinar]
GO
/****** Object: Default [DF_ACCOUNT_TBL_DETAIL_kills] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_kills] DEFAULT ((0)) FOR [kills]
GO
/****** Object: Default [DF_ACCOUNT_TBL_DETAIL_deaths] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_deaths] DEFAULT ((0)) FOR [deaths]
GO
/****** Object: Default [DF_ACCOUNT_TBL_DETAIL_premium] Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD CONSTRAINT [DF
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Und diese hatte ich auch schon:
bei MS SQL Maestro
[DBNETLID] Connection Open [Connect()).]SQL Service Existiert nicht oder Zugriff verweigert
Und hier das noch:
ou have an error in your SQL syntax; check the manual that Corresponds to your MySQL server version for the right syntax to use near '[WARROCK_DBF]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET AN 'at line 1
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET AN 'at line 1
Sobald bei mir alles geht, werde ich die Files Pub machen.
Um so mehr Leute sie haben um So mehr neue Sachen,
Meine Meinung.