[Request/Help] Launcher and .sql of Gunz2 DB.

Hashed · Dec 16, 2012

I'm hitting quite a few roadblocks while trying to hook up the database to the server files, therefore, I need your help.

I need the following;
GunZ 2 Launcher
gunz2db.sql

I've got the backup of the Gunz2 DB, yet, I can't make any changes as I had to overwrite the option to do so, if I didn't, I wouldn't of been able to restore it.

If ANYONE has these, I will be gratefully thankful.
Any help is appreciated.

wesman2232 · Dec 16, 2012

The GunZ2 Database should have been in the files I gave you.
Look in the sql folder.

If not, I'll upload them for you:

You must be registered to see links

Launcher, I'm not sure of.

If you're talking about an actual script for the DB, I'll try to create that for you as well.
Here you go:
Gunz2DB.sql

Code:

USE [master]
GO
/****** Object:  Database [Gunz2DB]    Script Date: 12/16/2012 04:03:43 ******/
CREATE DATABASE [Gunz2DB] ON  PRIMARY 
( NAME = N'gunz2db', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\Gunz2DB.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'gunz2db_log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\Gunz2DB_1.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [Gunz2DB] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Gunz2DB].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Gunz2DB] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Gunz2DB] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Gunz2DB] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Gunz2DB] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Gunz2DB] SET ARITHABORT OFF
GO
ALTER DATABASE [Gunz2DB] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [Gunz2DB] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [Gunz2DB] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [Gunz2DB] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [Gunz2DB] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Gunz2DB] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [Gunz2DB] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Gunz2DB] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Gunz2DB] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Gunz2DB] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Gunz2DB] SET  DISABLE_BROKER
GO
ALTER DATABASE [Gunz2DB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [Gunz2DB] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [Gunz2DB] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Gunz2DB] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [Gunz2DB] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Gunz2DB] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [Gunz2DB] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [Gunz2DB] SET  READ_WRITE
GO
ALTER DATABASE [Gunz2DB] SET RECOVERY FULL
GO
ALTER DATABASE [Gunz2DB] SET  MULTI_USER
GO
ALTER DATABASE [Gunz2DB] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Gunz2DB] SET DB_CHAINING OFF
GO
USE [Gunz2DB]
GO
/****** Object:  Table [dbo].[Account]    Script Date: 12/16/2012 04:03:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Account](
    [AID] [int] NOT NULL,
    [UserID] [varchar](20) NOT NULL,
    [UGradeID] [tinyint] NULL,
    [Age] [tinyint] NULL,
    [Sex] [bit] NULL,
    [Email] [varchar](64) NULL,
    [RegDate] [datetime] NULL,
 CONSTRAINT [PK_Account_AID] PRIMARY KEY CLUSTERED 
(
    [AID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [IX_Account_RegDate] ON [dbo].[Account] 
(
    [RegDate] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ACCOUNT_UserID] ON [dbo].[Account] 
(
    [UserID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Character]    Script Date: 12/16/2012 04:03:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Character](
    [CID] [int] IDENTITY(1,1) NOT NULL,
    [AID] [int] NOT NULL,
    [Name] [varchar](64) NOT NULL,
    [Race] [tinyint] NOT NULL,
    [Hair] [int] NULL,
    [Face] [int] NULL,
    [Level] [tinyint] NULL,
    [XP] [int] NULL,
    [BP] [int] NULL,
    [HP] [smallint] NULL,
    [AP] [smallint] NULL,
    [CharNum] [tinyint] NULL,
    [head_slot] [int] NULL,
    [chest_slot] [int] NULL,
    [hands_slot] [int] NULL,
    [legs_slot] [int] NULL,
    [feet_slot] [int] NULL,
    [fingerl_slot] [int] NULL,
    [fingerr_slot] [int] NULL,
    [melee_slot] [int] NULL,
    [primary_slot] [int] NULL,
    [secondary_slot] [int] NULL,
    [custom1_slot] [int] NULL,
    [custom2_slot] [int] NULL,
    [head_itemid] [int] NULL,
    [chest_itemid] [int] NULL,
    [hands_itemid] [int] NULL,
    [legs_itemid] [int] NULL,
    [feet_itemid] [int] NULL,
    [fingerl_itemid] [int] NULL,
    [fingerr_itemid] [int] NULL,
    [melee_itemid] [int] NULL,
    [primary_itemid] [int] NULL,
    [secondary_itemid] [int] NULL,
    [custom1_itemid] [int] NULL,
    [custom2_itemid] [int] NULL,
    [DeleteFlag] [bit] NULL,
    [RegDate] [datetime] NULL,
 CONSTRAINT [PK_Character_CID] PRIMARY KEY CLUSTERED 
(
    [CID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [IX_Character_AID] ON [dbo].[Character] 
(
    [AID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Character_Name] ON [dbo].[Character] 
(
    [Name] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Character_RegDate] ON [dbo].[Character] 
(
    [RegDate] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AccountLocal]    Script Date: 12/16/2012 04:03:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AccountLocal](
    [AID] [int] NOT NULL,
    [Name] [varchar](60) NULL,
    [CountryCode3] [char](3) NULL,
    [ZipCode] [varchar](32) NULL,
    [Address] [varchar](256) NULL,
    [Email] [varchar](64) NULL,
 CONSTRAINT [PK_AccountLocal_AID] PRIMARY KEY CLUSTERED 
(
    [AID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [IX_AccountLocal_CountryCode3] ON [dbo].[AccountLocal] 
(
    [CountryCode3] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_AccountLocal_Name] ON [dbo].[AccountLocal] 
(
    [Name] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Login]    Script Date: 12/16/2012 04:03:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Login](
    [AID] [int] NOT NULL,
    [UserID] [varchar](20) NOT NULL,
    [Password] [varchar](20) NOT NULL,
    [IsFailedBlock] [bit] NULL,
    [LastLoginTime] [datetime] NULL,
 CONSTRAINT [PK_Login_AID] PRIMARY KEY CLUSTERED 
(
    [AID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [IX_Login_LastLoginTime] ON [dbo].[Login] 
(
    [LastLoginTime] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Login_UserID] ON [dbo].[Login] 
(
    [UserID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  StoredProcedure [dbo].[spGetCharacterLook]    Script Date: 12/16/2012 04:03:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[spGetCharacterLook]
 @AID int
, @CharNum tinyint
as
begin
 set nocount on

 select top (1) c.Race, c.hair, c.face, cs.head_itemid
  , cs.chest_itemid, cs.hands_itemid, cs.legs_itemid, cs.feet_itemid
  , cs.fingerl_itemid, cs.fingerr_itemid, cs.melee_itemid,cs.primary_itemid
  , cs.secondary_itemid, cs.custom1_itemid, cs.custom2_itemid
 from dbo.Character c(nolock), dbo.CharacterSlot cs(nolock)
 where c.AID = @AID and c.CharNum = @CharNum and c.DeleteFlag <> 1 
  and cs.CID = c.CID
 order by cs.CharSlotID
end
GO
/****** Object:  Default [DF__Account__RegDate__023D5A04]    Script Date: 12/16/2012 04:03:49 ******/
ALTER TABLE [dbo].[Account] ADD  DEFAULT (getdate()) FOR [RegDate]
GO
/****** Object:  Default [DF__Character__Level__08EA5793]    Script Date: 12/16/2012 04:03:49 ******/
ALTER TABLE [dbo].[Character] ADD  DEFAULT ((0)) FOR [Level]
GO
/****** Object:  Default [DF__Character__Delet__09DE7BCC]    Script Date: 12/16/2012 04:03:49 ******/
ALTER TABLE [dbo].[Character] ADD  DEFAULT ((0)) FOR [DeleteFlag]
GO
/****** Object:  Default [DF__Character__RegDa__0AD2A005]    Script Date: 12/16/2012 04:03:49 ******/
ALTER TABLE [dbo].[Character] ADD  DEFAULT (getdate()) FOR [RegDate]
GO
/****** Object:  Default [DF__Login__IsFailedB__0519C6AF]    Script Date: 12/16/2012 04:03:49 ******/
ALTER TABLE [dbo].[Login] ADD  DEFAULT ((0)) FOR [IsFailedBlock]
GO
/****** Object:  ForeignKey [FK_Character_AID]    Script Date: 12/16/2012 04:03:49 ******/
ALTER TABLE [dbo].[Character]  WITH CHECK ADD  CONSTRAINT [FK_Character_AID] FOREIGN KEY([AID])
REFERENCES [dbo].[Account] ([AID])
GO
ALTER TABLE [dbo].[Character] CHECK CONSTRAINT [FK_Character_AID]
GO
/****** Object:  ForeignKey [FK_AccountLocal_AID]    Script Date: 12/16/2012 04:03:49 ******/
ALTER TABLE [dbo].[AccountLocal]  WITH CHECK ADD  CONSTRAINT [FK_AccountLocal_AID] FOREIGN KEY([AID])
REFERENCES [dbo].[Account] ([AID])
GO
ALTER TABLE [dbo].[AccountLocal] CHECK CONSTRAINT [FK_AccountLocal_AID]
GO
/****** Object:  ForeignKey [FK_Login_AID]    Script Date: 12/16/2012 04:03:49 ******/
ALTER TABLE [dbo].[Login]  WITH CHECK ADD  CONSTRAINT [FK_Login_AID] FOREIGN KEY([AID])
REFERENCES [dbo].[Account] ([AID])
GO
ALTER TABLE [dbo].[Login] CHECK CONSTRAINT [FK_Login_AID]
GO

Gunz2DB_log.sql

Code:

USE [master]
GO
/****** Object:  Database [Gunz2DB_log]    Script Date: 12/16/2012 04:07:14 ******/
CREATE DATABASE [Gunz2DB_log] ON  PRIMARY 
( NAME = N'gunz2logdb', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\Gunz2DB_log.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'gunz2logdb_log', FILENAME = N'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\Gunz2DB_log_1.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [Gunz2DB_log] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Gunz2DB_log].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Gunz2DB_log] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Gunz2DB_log] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Gunz2DB_log] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Gunz2DB_log] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Gunz2DB_log] SET ARITHABORT OFF
GO
ALTER DATABASE [Gunz2DB_log] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [Gunz2DB_log] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [Gunz2DB_log] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [Gunz2DB_log] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [Gunz2DB_log] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Gunz2DB_log] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [Gunz2DB_log] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Gunz2DB_log] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Gunz2DB_log] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Gunz2DB_log] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Gunz2DB_log] SET  DISABLE_BROKER
GO
ALTER DATABASE [Gunz2DB_log] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [Gunz2DB_log] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [Gunz2DB_log] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Gunz2DB_log] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [Gunz2DB_log] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Gunz2DB_log] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [Gunz2DB_log] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [Gunz2DB_log] SET  READ_WRITE
GO
ALTER DATABASE [Gunz2DB_log] SET RECOVERY FULL
GO
ALTER DATABASE [Gunz2DB_log] SET  MULTI_USER
GO
ALTER DATABASE [Gunz2DB_log] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Gunz2DB_log] SET DB_CHAINING OFF
GO
USE [Gunz2DB_log]
GO
/****** Object:  Table [dbo].[LoginLog]    Script Date: 12/16/2012 04:07:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LoginLog](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [AID] [int] NOT NULL,
    [ServerID] [smallint] NULL,
    [CID] [int] NOT NULL,
    [IPPart1] [tinyint] NULL,
    [IPPart2] [tinyint] NULL,
    [IPPart3] [tinyint] NULL,
    [IPPart4] [tinyint] NULL,
    [RegDate] [datetime] NULL,
    [RegDay] [tinyint] NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_LoginLog_RegDay] ON [dbo].[LoginLog] 
(
    [RegDay] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[CharacterDeleteLog]    Script Date: 12/16/2012 04:07:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CharacterDeleteLog](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [CID] [int] NOT NULL,
    [UsedName] [varchar](60) NOT NULL,
    [RegDate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
    [id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
CREATE NONCLUSTERED INDEX [IX_CharacterDeleteLog_CID] ON [dbo].[CharacterDeleteLog] 
(
    [CID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CharacterDeleteLog_UsedName] ON [dbo].[CharacterDeleteLog] 
(
    [UsedName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO
/****** Object:  Default [DF__LoginLog__RegDat__00551192]    Script Date: 12/16/2012 04:07:19 ******/
ALTER TABLE [dbo].[LoginLog] ADD  DEFAULT (getdate()) FOR [RegDate]
GO
/****** Object:  Default [DF__LoginLog__RegDay__014935CB]    Script Date: 12/16/2012 04:07:19 ******/
ALTER TABLE [dbo].[LoginLog] ADD  DEFAULT (datepart(day,getdate())) FOR [RegDay]
GO
/****** Object:  Default [DF__Character__RegDa__060DEAE8]    Script Date: 12/16/2012 04:07:19 ******/
ALTER TABLE [dbo].[CharacterDeleteLog] ADD  DEFAULT (getdate()) FOR [RegDate]
GO

Hashed · Dec 16, 2012

I will look at this after work. Thanks for the script, hopefully it will execute properly.

wesman2232 · Dec 16, 2012

If not, tell me and we'll work it out

Hashed · Dec 16, 2012

wesman2232 said:
If not, tell me and we'll work it out

Works like a charm, I've already started creating Stored Procedures and tables, yet, I'm not to well familiar with this kind of stuff, just going off a limb on this one.

wesman2232 · Dec 16, 2012

If I have something to work off of, I'd help you out.
Like errors in PHP, they tell you exactly what table or column you are missing.

Anyway, going off of the QueryData files in each of the server file folders, i made a list of what needs to be created. They are either tables or stored procedures, but I'm pretty sure they are stored procedures:

Code:

spLogin
spTestNULLQuery
spTempInsertLogin
spInsertConnLog
spSelectCharacterList
spInsertCharacter
spDeleteCharacter
spSelectFriendList
spSelectObserverList
spInsertFriend
spDeleteFriend
spSelectItemInstanceList
spDeleteItemInstance
spChangeEquItemInstance
spSaveCharacterData
spSelectChoiceProductList
spInsertChoiceProduct
spDeleteChoiceProduct
spSelectCharacterBattleRecord
spSelectChallengeQuestionNumber
spChangeWeaponSlot
spSelectPlayerDataStageSetup
spSavePlayerDataStageSetupUpdate
spSavePlayerDataStageSetupInsert
spGameLogInsertBattleInfo
spGameLogUpdateEndBattle
spGameLogInsertKillDeath
spGameLogInsertWeaponShot
spGameLogInsertWeaponTime
spDevAddItemInstance
spTestSelectUnicode
spInsertServerStartLog
spInsertServerStopLog
spInsertServerPatchLog
spSelectServerPatchSchedule

OldSchoolGZ · Dec 18, 2012

sp usually means stored procedure

Hashed · Dec 18, 2012

OldSchoolGZ said:
sp usually means stored procedure

You don't say.

[Request/Help] Launcher and .sql of Gunz2 DB.

Hashed

Lotus

wesman2232

DRGunZ 2 Creator

Hashed

Lotus

wesman2232

DRGunZ 2 Creator

Hashed

Lotus

wesman2232

DRGunZ 2 Creator

OldSchoolGZ

Experienced Elementalist

Hashed

Lotus

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor