Questions & Awnsers
of problems and the awnsers for them on the forum, credits for taking the time to do it goes to BEPETEMISH. Developer of DaVD Gunz.
- Questions awnsered about standard editing:
- 1.1 How to add Quest Mode?
- 1.2 How to change the starting level and bounty?
- 1.3 How to add premium items?
- 1.4 How to change weapon values?
- 1.5 How to change login background?
- 1.6 How to change the loading screen? (corrupt image files fixed)
- 1.7 How to pack and unpack .mrs?
- Questions awnsered about server control:
- 2.1 What are the GM Commands?
- 2.2 How to make a Register Website?
- 2.3 How to Upgrade to match server(14 Jul 2006, english version)?
Q. 1.1 How to add Quest Mode?
A.
- <Part 1: Activate quest; credits to: Buga>
Hi I know that too many people has problems with Quest, Here i have the Solution.
First You need to add a Field at Character TABLE.
The Column you have to ADD is QuestItemInfo and is VARCHAR (MAX)
How to add the table:
Go to the SQL SERVER MANAGEMENT STUDIO.
Connect to the server
Expand your DB
Expand at tables,
Right Click at Fields
And select New Field
So there you have to put the name (QuestItemInfo), then the type of data: varchar (MAX) , and then you check the box that says Allow NULL data.
You are done with the Field
Pictures to as extra support: (tnx to emisand)
Picture 1
Picture 2
Then you need to Install this procedure:
Code:
CREATE PROCEDURE [dbo].[spSelectCharQuestItemInfoByCID]
@nCID INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT QuestItemInfo FROM Character Where CID = @nCID
END
How to install:
Go to Procedures and Right Click there and select New Query, there u paste this code and click at Execute.
- <Part 2.1: Working out the bugs, Editing config.ini; Credits to: emisand>
Go to your match server folder,
Open config.ini,
you will see this line ;MODE="test",
delete the ; so you will get MODE="test",
now save it.
- <Part 2.2: Solve nomsg bug; Credits to: AT.H.K>
download this gunz.exe:
Gunz.rar
Put this gunz.exe in the gunz client folder instead of the origional. (back-up your origional)
On to the database:
Collapse the GunDB , Programmability then Stored Procedures like so:
Now right click dbo.spInsertChar and press modify like this :D :
Ok so thats done a window to the right of it will pop up:
And DELETE all the text like it shows in that picture ^ .
and PASTE this in it
Code:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spInsertChar]
@nAID INT,
@nCharIndex INT,
@szName nvarchar(32),
@nSex INT,
@nHair INT,
@nFace INT,
@nCostume INT
AS
BEGIN
SET NOCOUNT ON;
DECLARE @cnt INT
SELECT @cnt=COUNT(*)
FROM Character
WHERE AID = @nAID
DECLARE @cid INT
SELECT @cid=COUNT(*)
FROM Character
INSERT INTO Character
VALUES(@nAID,@szName,@cnt,50,@nSex,@nCostume,@nFace,@nHair,NULL,0,100000,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,null)
END
- <Part 2.3: Quest doesn't show up as match type?>
Open ChannelRule.xml
Let all channel rules look like this:
Code:
<CHANNELRULE id="0" name="novice">
<MAP name="Mansion"/>
<MAP name="Prison"/>
<MAP name="Prison II"/>
<MAP name="Station"/>
<MAP name="Battle Arena"/>
<MAP name="Town"/>
<MAP name="Snow_Town"/>
<MAP name="Ruin"/>
<MAP name="Dungeon"/>
<MAP name="Castle"/>
<MAP name="Island"/>
<MAP name="Garden"/>
<MAP name="Factory"/>
<MAP name="Port"/>
<MAP name="Lost Shrine"/>
<MAP name="Stairway"/>
<MAP name="Hall"/>
<MAP name="Catacomb"/>
<MAP name="Shower Room"/>
<GAMETYPE id="0" />
<GAMETYPE id="1" />
<GAMETYPE id="2" />
<GAMETYPE id="3" />
<GAMETYPE id="4" />
<GAMETYPE id="5" />
<GAMETYPE id="6" />
<GAMETYPE id="7" />
<GAMETYPE id="8" />
</CHANNELRULE>
What you do here is adding GAMETYPE 7, game type 7 is quest mode. So add quest to the channels you want, you don't need to give all channels quest available.
- <Part 2.4: Character walks out screen; Credits to: emisand>
Add the table:
Go to the SQL SERVER MANAGEMENT STUDIO.
Connect to the server
Expand your DB
Expand at tables,
Right Click at Columns
And select New Column
So there you have to put the name (QuestItemInfo), then the type of data: varchar (MAX) , and then you check the box that says Allow NULL data.
You are done with the Field
Q. 1.2 How to change the starting level and bounty?
A.
<Editing; credits to: Bepetemish>
Open your database,
browse to spInsterChar, (its under Stored Procedures)
right click it and choose "modify"
find the part
Code:
VALUES(@nAID,@szName,@cnt,50,@nSex,@nCostume,@nFac e,@nHair,NULL,0,100000,0,0,0,0,0,0,0,0,0,0,0,0,@cn t,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,NULL)
50 = starting level
100000 = starting bounty
Note that you will start naked so you need to give peaple starting money so they can buy their gear.
Q. 1.3 How to add Premium Items?
A.
- <Part 1: Editing shop.xml; Credits to: hunter1577 and zozole003>
Go to your match server folder, (mine is located in C:\gunzserver\match server\)
Make a back-up of shop.xml
Open shop.xml
Delete everything inside
Now paste this:
[code]
<?xml version="1.0" encoding="euc-kr" ?>
<XML id="shop">
<!--
Questions & Answers
Originally Posted by bepetemish
