Simple guide to increase quest players without having bugs/crashes.
Here i'll increase quest players to 8. you can change values as you want.
1)Source Edits :
Open MMatchGlobal.h (Located in CSCommon)
Find :
Change to :
MMatchDBMgr.h:
Find :
Replace with :
MMatchDBMgr.cpp:
Find :
Replace with :
2) XML Edit :
Decompile "system.mrs" and Open "GameeTypeCfg.xml" in Notepad.
Edit :
To:
3) Database Changes :
Right click on "dbo.QuestGameLog " and click "Modify" (MSSQL05) / "Design" (MSSQL08)
Add these columns :
Now Go "Store Procedures" and Find "dbo.spInsertQuestGameLog" . click modify.
and replace whole thing.
Credits :
Wizkidje : Source edits
Vusion : Spawns
Enjoy!
If i miss something , please feel free to correct it. Thank you!
Here i'll increase quest players to 8. you can change values as you want.
1)Source Edits :
Open MMatchGlobal.h (Located in CSCommon)
Find :
Code:
#define STAGE_QUEST_MAX_PLAYER 4
Change to :
Code:
#define STAGE_QUEST_MAX_PLAYER 8
MMatchDBMgr.h:
Find :
Code:
const int nMasterCID, const int nPlayer1, const int nPlayer2, const int nPlayer3,
Replace with :
Code:
const int nMasterCID, const int nPlayer1, const int nPlayer2, const int nPlayer3,const int nPlayer4, const int nPlayer5, const int nPlayer6, const int nPlayer7,
MMatchDBMgr.cpp:
Find :
Code:
const int nMasterCID, const int nPlayer1, const int nPlayer2, const int nPlayer3,
Replace with :
Code:
const int nMasterCID, const int nPlayer1, const int nPlayer2, const int nPlayer3,const int nPlayer4, const int nPlayer5, const int nPlayer6, const int nPlayer7,
2) XML Edit :
Decompile "system.mrs" and Open "GameeTypeCfg.xml" in Notepad.
Edit :
Code:
<GAMETYPE id="7"> <!-- GAMETYPE_QUEST -->
<ROUNDS round="1" str="---" default="true" />
<LIMITTIME sec="99999" str="STR:GAMETYPECFG_LIMITTIME_INFINITE" />
<MAXPLAYERS player="4" str="4" default="true" />
</GAMETYPE>
To:
Code:
<GAMETYPE id="7"> <!-- GAMETYPE_QUEST -->
<ROUNDS round="1" str="---" default="true" />
<LIMITTIME sec="99999" str="STR:GAMETYPECFG_LIMITTIME_INFINITE" />
[COLOR="#FF0000"]<MAXPLAYERS player="8" str="8" default="true" />[/COLOR]
</GAMETYPE>
3) Database Changes :
Right click on "dbo.QuestGameLog " and click "Modify" (MSSQL05) / "Design" (MSSQL08)
Add these columns :
Code:
Player4 int Checked
Player5 int Checked
Player6 int Checked
Player7 int Checked
Now Go "Store Procedures" and Find "dbo.spInsertQuestGameLog" . click modify.
and replace whole thing.
USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spInsertQuestGameLog] Script Date: 02/13/2013 21:45:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Äù½ºÆ® °ÔÀÓ ·Î±× Á¤º¸ ÀúÀå ÇÁ·Î½ÃÁ®.
ALTER PROC [dbo].[spInsertQuestGameLog]
@GameName varchar(64)
, @Master int
, @Player1 int
, @Player2 int
, @Player3 int
, @Player4 int
, @Player5 int
, @Player6 int
, @Player7 int
, @TotalQItemCount smallint
, @ScenarioID smallint
, @GamePlayTime tinyint
AS
SET NOCOUNT ON
BEGIN TRAN
INSERT INTO QuestGameLog(GameName, Master, Player1, Player2, Player3, TotalQItemCount, ScenarioID, StartTime, EndTime, Player4, Player5, Player6, Player7 )
VALUES (@GameName, @Master, @Player1, @Player2, @Player3, @TotalQItemCount, @ScenarioID, DATEADD(n, -(@GamePlayTime), GETDATE()), GETDATE() , @Player4, @Player5, @Player6, @Player7)
IF 0 <> @@ERROR BEGIN -- ¿©±â Ãß°¡.
ROLLBACK TRAN
RETURN
END
SELECT @@IDENTITY AS 'ORDERQGLID'
COMMIT TRAN
GO
/****** Object: StoredProcedure [dbo].[spInsertQuestGameLog] Script Date: 02/13/2013 21:45:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Äù½ºÆ® °ÔÀÓ ·Î±× Á¤º¸ ÀúÀå ÇÁ·Î½ÃÁ®.
ALTER PROC [dbo].[spInsertQuestGameLog]
@GameName varchar(64)
, @Master int
, @Player1 int
, @Player2 int
, @Player3 int
, @Player4 int
, @Player5 int
, @Player6 int
, @Player7 int
, @TotalQItemCount smallint
, @ScenarioID smallint
, @GamePlayTime tinyint
AS
SET NOCOUNT ON
BEGIN TRAN
INSERT INTO QuestGameLog(GameName, Master, Player1, Player2, Player3, TotalQItemCount, ScenarioID, StartTime, EndTime, Player4, Player5, Player6, Player7 )
VALUES (@GameName, @Master, @Player1, @Player2, @Player3, @TotalQItemCount, @ScenarioID, DATEADD(n, -(@GamePlayTime), GETDATE()), GETDATE() , @Player4, @Player5, @Player6, @Player7)
IF 0 <> @@ERROR BEGIN -- ¿©±â Ãß°¡.
ROLLBACK TRAN
RETURN
END
SELECT @@IDENTITY AS 'ORDERQGLID'
COMMIT TRAN
Credits :
Wizkidje : Source edits
Vusion : Spawns
Enjoy!
If i miss something , please feel free to correct it. Thank you!
Last edited: