21/07/2008 Gunz Matchserver

[emisand]

Hello,

I have seen some people saying that they have this server files.
As I don't want them to have any advantage and prevent them from selling this, I'm releasing them.

I didn't made any fix in this release, I just edited the server.ini to remove br gunz passwords and ip addresses and edited the matchserver to remove maiet information.

Server Files:
Mirror 1: http://www.megaupload.com/?d=527K5JVB
Mirror 2: http://rapidshare.com/files/32542611...atchServer.rar

Full Client from BR Gunz for this matchserver (25/07/2008):
http://www.megaupload.com/?d=C0ZINFEH

Client Update from BR Gunz for this matchserver (25/07/2008):
http://www.megaupload.com/?d=XG01AA01

Tables and Procedures for Gamble Items
Credits to Theoretical

USE [GunzDB]
GO
/****** Object:  Table [dbo].[GambleItem]    Script Date: 12/24/2009 21:33:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[GambleItem](
	[GIID] [int] NOT NULL CONSTRAINT [DF_GambleItem_GIID]  DEFAULT ((1)),
	[Name] [varchar](64) NOT NULL,
	[Description] [varchar](64) NULL,
	[Price] [int] NOT NULL,
	[StartDiffMin] [int] NOT NULL,
	[LifeTimeMin] [int] NOT NULL,
	[Opened] [int] NOT NULL,
	[IsCash] [int] NOT NULL,
 CONSTRAINT [PK_GambleItem] PRIMARY KEY CLUSTERED 
(
	[GIID] 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


USE [GunzDB]
GO


USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spGetGambleItemList]    Script Date: 12/24/2009 21:34:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROC [dbo].[spGetGambleItemList] AS
BEGIN
	SELECT GIID,Name,Description,Price,StartDiffMin,LifeTimeMin,Opened,IsCash FROM
GambleItem ORDER BY GIID ASC
END


/****** Object:  Table [dbo].[GambleRewardItem]    Script Date: 12/24/2009 21:33:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GambleRewardItem](
	[GIID] [int] NOT NULL CONSTRAINT [DF_GambleRewardItem_GIID]  DEFAULT ((1)),
	[ItemIDMale] [int] NOT NULL,
	[ItemIDFemale] [int] NOT NULL,
	[RentHourPeriod] [int] NOT NULL,
	[RatePerThousand] [int] NOT NULL,
 CONSTRAINT [PK_GambleRewardItem] PRIMARY KEY CLUSTERED 
(
	[GIID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]




SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROC [dbo].[spGetGambleRewardItem] AS
BEGIN
	SELECT GIID,ItemIDFemale,ItemIDMale,RentHourPeriod,RatePerThousand FROM
GambleRewardItem ORDER BY GIID ASC
END

Use it at your own risk.

[MentaL]

[ThroneX]

Thanks Emisand.Merry Christmas.

[Military]

nice thank you.

[alfredao]

Very Nice, Thanks ;D

[Nobody666]

Thanks alot.

[Military]

I think I should release the 2008 BR Client, but I can do that tomorrow

[emisand]

Here you have the client for this matchserver:

ftp://fpatch.levelupgames.com.br/gun...e_20080725.exe

[Military]

Here you have the client for this matchserver:

ftp://fpatch.levelupgames.com.br/gun...e_20080725.exe

nvm lol, I got it from there.

[alfredao]

Can you post the DB? With new Stored procedures.

spGetGambleItemList, spGetGambleRewardItem, spChangeGambleItemToRewardItem, spGetTeamID4, spTeam4WinTheGame, etc

[emisand]

Can you post the DB? With new Stored procedures.

spGetGambleItemList, spGetGambleRewardItem, spChangeGambleItemToRewardItem, spGetTeamID4, spTeam4WinTheGame, etc

I will not release that now.

[alfredao]

I will not release that now.

ok, thanks :(

[RodiSR]

Nice release emisand so im seeing you and lambda returning back at ragezone, cool this is a good christmas.
Btw the link from the 2008 br client dosn't work, It isn't in the update folder from the ftp.

[emisand]

Im not returning back to this fucking community, Im just releasing this to prevent other fags to sell this shit or to believe they are better.

[jessika_]

thanks emisand DX

[Military]

Im not returning buck to this fucking community, Im just releasing this to prevent other fags to sell this shit or to believe they are better.

well said