Could someone upload 2011/1.5 Client and Server Files?

[cheaterastic]

Could someone upload 2011/1.5 Client and Server Files?

Do someone has Successful Gunz 1.5/2011 Server working?
Please upload your Client and Server and please share.

Also the Database. Please Generate Scripts your GunZ1.5 database (right-click your database > tasks > Generate Scripts) so that you can share your database sql query.
Save and upload the .sql Generate Scripts.

Well, the links of releases are not working anymore.
Multiupload = not working or other country blocked
Megaupload = DIE

If someone can share GunZ 2011, it's more better.
Make a thread please. For those who want to release.

I have test all GunZ 2011 releases, but there are lot of errors.

There are missing parts of SQL or SQL error, that's why the server not working.
The Emulator Matchserver is not good, my runnable can't access through my Server.

Please. If could someone share GunZ 1.5 or 2011, Please share it. new Client And Server or Runnable and Server Only.. Please.

with runnable. please. Mef not included.

It's better, for database (sql query), Please Generate the Scripts of it by Right-click your database > Tasks > Generate Scripts (scripts all object in the selected database > next next)

[MentaL]

[Phoenix]

I've re-uploaded emisand's database files.
http://forum.ragezone.com/f245/gunz-...ml#post6834882

About the client, I don't mind re-uploading it but I don't have it. I'll see if I can find it and upload it later.

[cheaterastic]

Do someone has Successful Gunz 1.5/2011 Server working?
Please upload your Client and Server and please share.

Also the Database. Please Generate Scripts your GunZ1.5 database (right-click your database > tasks > Generate Scripts) so that you can share your database sql query.
Save and upload the .sql Generate Scripts.

Links updated.
I've uploaded the files to Sendspace since Multiupload is down for some reason.


Download Link for .bak files:
http://www.sendspace.com/file/q64998

Download Link for .sql files:
http://www.sendspace.com/file/6t16tm

Thanks

But I thought it's useful, but for me, it's not because it has lot of errors in my SQL. Gush.
It has big size. the GunzDB.bak has 27 MB while the GunzDB.sql has 104 MB.
Why it has big size, that's not the size of a real Database. Lot of error, there is query INSERT.

Could someone help Please. I really need

Please Help.

[Secured]

Do someone has Successful Gunz 1.5/2011 Server working?
Please upload your Client and Server and please share.

Also the Database. Please Generate Scripts your GunZ1.5 database (right-click your database > tasks > Generate Scripts) so that you can share your database sql query.
Save and upload the .sql Generate Scripts.



Thanks

But I thought it's useful, but for me, it's not because it has lot of errors in my SQL. Gush.
It has big size. the GunzDB.bak has 27 MB while the GunzDB.sql has 104 MB.
Why it has big size, that's not the size of a real Database. Lot of error, there is query INSERT.

Could someone help Please. I really need

Please Help.

maybe because the database is large? why note follow the tutorials and search around and you could at least try and build before asking to be spoon feed.

[Momar]

maybe because the database is large? why note follow the tutorials and search around and you could at least try and build before asking to be spoon feed.

On the SQL they called Complete GunZ Database and .SQL
There are lot of INSERT statement and most on the query is INSERT statement.

My Gunz 1.5 MatchServer is working, We have the same Gunz 1.5 Client and Server with cheaterastic. But cannot connect to the server, it says

Guys, Please don't be braggart / arrogant.
Please Share your GunZ 1.5 Database Scripts, Just Generate Scripts your Database.

Here is my working Gunz 1.5 MatchServer, Agent and Locator.


Cannot Connect to the Server


The SQL Query I've found in GunzDB.SQL[GunZ 1.5 Databases (Scripts)] just to work MatchServer.
For those people that has Gunz1.5 Matchserver Server not working, you may use this, and your MatchServer will Work. But Client cannot connect.
Try to EXECUTE this to your GunzDB.

Spoiler:

CREATE PROC [dbo].[spGetBattleTimeRewardDescription]
-- ALTER PROC dbo.spGetBattleTimeRewardDescription
AS BEGIN

SET NOCOUNT ON;

SELECT BR.BRID, BR.[Name], T1.BRTID, BR.RewardMinutePeriod, BR.RewardCount, BR.RewardKillCount, BR.ResetDesc
FROM dbo.BattleTimeRewardDescription BR(NOLOCK)
JOIN
(
SELECT BRID, MAX(BRTID) AS BRTID
FROM dbo.BattleTimeRewardTerm(NOLOCK)
WHERE ClosedDate IS NULL
GROUP BY BRID
) T1
ON T1.BRID = BR.BRID
WHERE GETDATE() BETWEEN BR.StartDate AND BR.EndDate
AND DATEPART(hh, GETDATE()) BETWEEN BR.StartHour AND BR.EndHour
AND BR.IsOpen = 1
ORDER BY BR.BRID

END
GO








CREATE PROCEDURE [dbo].[spGetSurvivalGroupRanking]
AS BEGIN
SET NOCOUNT ON;

SELECT t.SID, t.CID, c.Name, t.Ranking, t.RP
FROM
(
SELECT s.SID, s.CID, s.RP, r.Ranking
FROM SurvivalCharacterInfo s WITH (NOLOCK), SurvivalRanking r WITH (NOLOCK)
WHERE s.RankRP = r.RP
AND s.SID = r.SID
AND r.Ranking <= 10
AND r.SID IN (1, 2, 3)
) AS t, Character c WITH (NOLOCK)
WHERE t.CID = c.CID
ORDER BY SID, Ranking
END
GO






CREATE TABLE [dbo].[BattleTimeRewardDescription](
[BRID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](128) NULL,
[StartDate] [datetime] NOT NULL,
[EndDate] [datetime] NOT NULL,
[StartHour] [tinyint] NULL,
[EndHour] [tinyint] NULL,
[RewardMinutePeriod] [int] NOT NULL,
[RewardCount] [tinyint] NOT NULL,
[RewardKillCount] [tinyint] NOT NULL,
[ResetCode] [char](7) NOT NULL,
[ResetDesc] [varchar](128) NULL,
[IsOpen] [tinyint] NULL,
CONSTRAINT [PK_BattleTimeRewardDescription] PRIMARY KEY CLUSTERED
(
[BRID] 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








CREATE TABLE [dbo].[BattleTimeRewardTerm](
[BRID] [int] NOT NULL,
[BRTID] [int] IDENTITY(1,1) NOT NULL,
[LastResetDate] [datetime] NOT NULL,
[ClosedDate] [datetime] NULL,
CONSTRAINT [PK_BattleTimeRewardTerm] PRIMARY KEY CLUSTERED
(
[BRID] ASC,
[BRTID] 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














CREATE PROC [dbo].[spGetBattleTimeRewardItemList]
-- ALTER PROC dbo.spGetBattleTimeRewardItemList
AS BEGIN

SET NOCOUNT ON;

WITH T1 AS
(
SELECT BRI.BRID
FROM BattleTimeRewardItemList BRI(NOLOCK)
GROUP BY BRI.BRID HAVING SUM(BRI.RatePerThousand) = 1000
),
T2 AS
(
SELECT BRI.BRID, BRI.BRIID, BRI.ItemIDMale, BRI.ItemIDFemale, BRI.ItemCnt, BRI.RentHourPeriod, BRI.RatePerThousand
FROM dbo.BattleTimeRewardDescription BR(NOLOCK)
JOIN dbo.BattleTimeRewardItemList BRI(NOLOCK)
ON BR.BRID = BRI.BRID
WHERE GETDATE() BETWEEN BR.StartDate AND BR.EndDate
AND DATEPART(hh, GETDATE()) BETWEEN BR.StartHour AND BR.EndHour
AND BR.IsOpen = 1
)
SELECT T2.BRID, T2.BRIID, T2.ItemIDMale, T2.ItemIDFemale, T2.ItemCnt, T2.RentHourPeriod, T2.RatePerThousand
FROM T1 JOIN T2 ON T1.BRID = T2.BRID
ORDER BY T2.BRIID

END
GO







CREATE TABLE [dbo].[BattleTimeRewardItemList](
[BRIID] [int] IDENTITY(1,1) NOT NULL,
[BRID] [int] NOT NULL,
[ItemIDMale] [int] NOT NULL,
[ItemIDFemale] [int] NOT NULL,
[RentHourPeriod] [int] NULL,
[ItemCnt] [int] NULL,
[RatePerThousand] [int] NOT NULL,
CONSTRAINT [PK_BattleTimeRewardItemList] PRIMARY KEY CLUSTERED
(
[BRIID] 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

Please Generate Scripts your GunzDB 1.5, just right-click your database, Tasks, Generate Scripts.

I hope your GunZ 1.5 is working. I hope. Please Share.

[Secured]

On the SQL they called Complete GunZ Database and .SQL
There are lot of INSERT statement and most on the query is INSERT statement.

My Gunz 1.5 MatchServer is working, We have the same Gunz 1.5 Client and Server with cheaterastic. But cannot connect to the server, it says

Guys, Please don't be braggart / arrogant.
Please Share your GunZ 1.5 Database Scripts, Just Generate Scripts your Database.

Here is my working Gunz 1.5 MatchServer, Agent and Locator.


Cannot Connect to the Server


The SQL Query I've found in GunzDB.SQL[GunZ 1.5 Databases (Scripts)] just to work MatchServer.
For those people that has Gunz1.5 Matchserver Server not working, you may use this, and your MatchServer will Work. But Client cannot connect.
Try to EXECUTE this to your GunzDB.

Spoiler:

CREATE PROC [dbo].[spGetBattleTimeRewardDescription]
-- ALTER PROC dbo.spGetBattleTimeRewardDescription
AS BEGIN

SET NOCOUNT ON;

SELECT BR.BRID, BR.[Name], T1.BRTID, BR.RewardMinutePeriod, BR.RewardCount, BR.RewardKillCount, BR.ResetDesc
FROM dbo.BattleTimeRewardDescription BR(NOLOCK)
JOIN
(
SELECT BRID, MAX(BRTID) AS BRTID
FROM dbo.BattleTimeRewardTerm(NOLOCK)
WHERE ClosedDate IS NULL
GROUP BY BRID
) T1
ON T1.BRID = BR.BRID
WHERE GETDATE() BETWEEN BR.StartDate AND BR.EndDate
AND DATEPART(hh, GETDATE()) BETWEEN BR.StartHour AND BR.EndHour
AND BR.IsOpen = 1
ORDER BY BR.BRID

END
GO








CREATE PROCEDURE [dbo].[spGetSurvivalGroupRanking]
AS BEGIN
SET NOCOUNT ON;

SELECT t.SID, t.CID, c.Name, t.Ranking, t.RP
FROM
(
SELECT s.SID, s.CID, s.RP, r.Ranking
FROM SurvivalCharacterInfo s WITH (NOLOCK), SurvivalRanking r WITH (NOLOCK)
WHERE s.RankRP = r.RP
AND s.SID = r.SID
AND r.Ranking <= 10
AND r.SID IN (1, 2, 3)
) AS t, Character c WITH (NOLOCK)
WHERE t.CID = c.CID
ORDER BY SID, Ranking
END
GO






CREATE TABLE [dbo].[BattleTimeRewardDescription](
[BRID] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](128) NULL,
[StartDate] [datetime] NOT NULL,
[EndDate] [datetime] NOT NULL,
[StartHour] [tinyint] NULL,
[EndHour] [tinyint] NULL,
[RewardMinutePeriod] [int] NOT NULL,
[RewardCount] [tinyint] NOT NULL,
[RewardKillCount] [tinyint] NOT NULL,
[ResetCode] [char](7) NOT NULL,
[ResetDesc] [varchar](128) NULL,
[IsOpen] [tinyint] NULL,
CONSTRAINT [PK_BattleTimeRewardDescription] PRIMARY KEY CLUSTERED
(
[BRID] 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








CREATE TABLE [dbo].[BattleTimeRewardTerm](
[BRID] [int] NOT NULL,
[BRTID] [int] IDENTITY(1,1) NOT NULL,
[LastResetDate] [datetime] NOT NULL,
[ClosedDate] [datetime] NULL,
CONSTRAINT [PK_BattleTimeRewardTerm] PRIMARY KEY CLUSTERED
(
[BRID] ASC,
[BRTID] 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














CREATE PROC [dbo].[spGetBattleTimeRewardItemList]
-- ALTER PROC dbo.spGetBattleTimeRewardItemList
AS BEGIN

SET NOCOUNT ON;

WITH T1 AS
(
SELECT BRI.BRID
FROM BattleTimeRewardItemList BRI(NOLOCK)
GROUP BY BRI.BRID HAVING SUM(BRI.RatePerThousand) = 1000
),
T2 AS
(
SELECT BRI.BRID, BRI.BRIID, BRI.ItemIDMale, BRI.ItemIDFemale, BRI.ItemCnt, BRI.RentHourPeriod, BRI.RatePerThousand
FROM dbo.BattleTimeRewardDescription BR(NOLOCK)
JOIN dbo.BattleTimeRewardItemList BRI(NOLOCK)
ON BR.BRID = BRI.BRID
WHERE GETDATE() BETWEEN BR.StartDate AND BR.EndDate
AND DATEPART(hh, GETDATE()) BETWEEN BR.StartHour AND BR.EndHour
AND BR.IsOpen = 1
)
SELECT T2.BRID, T2.BRIID, T2.ItemIDMale, T2.ItemIDFemale, T2.ItemCnt, T2.RentHourPeriod, T2.RatePerThousand
FROM T1 JOIN T2 ON T1.BRID = T2.BRID
ORDER BY T2.BRIID

END
GO







CREATE TABLE [dbo].[BattleTimeRewardItemList](
[BRIID] [int] IDENTITY(1,1) NOT NULL,
[BRID] [int] NOT NULL,
[ItemIDMale] [int] NOT NULL,
[ItemIDFemale] [int] NOT NULL,
[RentHourPeriod] [int] NULL,
[ItemCnt] [int] NULL,
[RatePerThousand] [int] NOT NULL,
CONSTRAINT [PK_BattleTimeRewardItemList] PRIMARY KEY CLUSTERED
(
[BRIID] 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

Please Generate Scripts your GunzDB 1.5, just right-click your database, Tasks, Generate Scripts.

I hope your GunZ 1.5 is working. I hope. Please Share.

All the sql files are in a folder along with the release ^-^ just organize them and boom your done.

[cheaterastic]

All the sql files are in a folder along with the release ^-^ just organize them and boom your done.

If your Server is working,
Could you Generate Scripts your Gunz Database and Objects inside of database?

Please Share.



The .BAK is not working anymore, maybe there is expiration date.
So. please. if your Gunz1.5 Server is working, better Generate Scripts your Database.

Here is the Error Message after restoring Gunz1.5 DB (27,988 KB)

[dsw_pool]

sorry for post fix it my problem ;D

[cheaterastic]

Please, if you have working Gunz1.5 Server,
Please Generate Scripts your Database, and please release it, release the SQL. It's more better, and to be easy for other. Than to keep finding Solution.

Phoenix, if your Gunz 1.5 is really working, then please Generate Scripts your Gunz(1.5) Database, Why don't you do it?

Please guys, who may have mercy, please release it.

[Bug Eye Billy]

My GunZ Server Its working, i will try upload in some hours.

Its Vusion's release + Fix > 500.000 Items

[cheaterastic]

My GunZ Server Its working, i will try upload in some hours.

Its Vusion's release + Fix > 500.000 Items

OK, I will wait for your Releases.

Just Generate the Scripts of your Gunz1.5 Database.

I hope your Gunz 1.5 server is working.

[Vusion]

My GunZ Server Its working, i will try upload in some hours.

Its Vusion's release + Fix > 500.000 Items

I do not allow my files's rerelease. Please, and thank you.
Posted via Mobile Device

And stop talking as if it's hard. Emisand's database is fine. Just get an ounce of common sense and you'll be able to get the source working.
Posted via Mobile Device

[Bug Eye Billy]

I do not allow my files's rerelease. Please, and thank you.
Posted via Mobile Device

And stop talking as if it's hard. Emisand's database is fine. Just get an ounce of common sense and you'll be able to get the source working.
Posted via Mobile Device

Ok. Just saying

So i will send it by MP...

[cheaterastic]

I do not allow my files's rerelease. Please, and thank you.
Posted via Mobile Device

And stop talking as if it's hard. Emisand's database is fine. Just get an ounce of common sense and you'll be able to get the source working.
Posted via Mobile Device

Lol. And if your Gunz 1.5 is working, why don't you share? have you PM me to help. LOL. I know your Server Gunz 1.5 is not working. LOL

Ok. Just saying

So i will send it by MP...

Ok. I will wait for your PM.
And also kliver, don't be scared to release it, no one released yet, and if Emisand released SQL and BAK files with randomly/more inputted sql query/statements, you can released your SQL, if your GunZ 1.5 is working. Please Generate Scripts your Database.

And Phoenix, if your Server GunZ 1.5 is really working, please Generate Scripts your Database.
Be the 1st to release "Full Scripts".

Not Random and more Scripts/SQL query like Emisand did.

I don't want Emisand SQL query, not friendly SQL Query, there are lot of INSERT Statement and almost on the SQL Query are INSERT Statement. And Executing his GunzDB.sql has error. Or MSSQL cannot read it.

And the .BAK Files he gave is not working. Look the Image I showed.

Spoiler:

That's the Error Message.

Please Help please. Selfish, your Gunz 1.5 Server is not working. Arrogant.

[Phoenix]

And Phoenix, if your Server GunZ 1.5 is really working, please Generate Scripts your Database.
Be the 1st to release "Full Scripts".

I use Emisand's database myself. There's nothing wrong with it.

[Gun[Lengend]]

I use Emisand's database myself. There's nothing wrong with it.

Yes, it's not have any problem?

[cheaterastic]

I use Emisand's database myself. There's nothing wrong with it.

Please Phoenix, just generate scripts your Database. And please send it to me. Please. Or just release the full SQL scripts.

Generate Scripts please. Emisand SQL doesn't have full SQL scripts, and his GunzDB.bak is not working.

Please better, generate scripts your gunzdb, there is no problem about it. and be the one to release it.

[Phoenix]

Please Phoenix, just generate scripts your Database. And please send it to me. Please. Or just release the full SQL scripts.

Generate Scripts please. Emisand SQL doesn't have full SQL scripts, and his GunzDB.bak is not working.

Please better, generate scripts your gunzdb, there is no problem about it. and be the one to release it.

If I did that, it would be considered to be a re-release as I'm using the same scripts that he released. If you can get them working, you're doing it wrong.

[cheaterastic]

If I did that, it would be considered to be a re-release as I'm using the same scripts that he released. If you can get them working, you're doing it wrong.

Please just PM me, I can't finish my Gunz1.5 Server without you.
Generate Scripts and PM me,
I promise I will not share it.

Please Phoenix, it just take 2 minutes, just Generate Scripts your Gunz1.5 DB, and please send it to me. GOD.

[Phoenix]

You fail to understand my point. I have not made any edits to the database. I'm closing this thread to prevent more off topic posts.