Classes

[Hymn]

I've been sitting on an idea for quite some time now, and I need to confirm a few things. Each of these will progressively be harder, you need to tell me what I can and can't do.

1. I need to create "classes", via the original classes that gunz has. However, I could not find the place where you can edit the list of these and the items they are given in game. I need exactly 9 Classes (18 if you count male/female), each giving people a set of items. Items will not be for sale on this server, so the items you get in the beginning are the only ones you can have.

2. Is it possible through the mssql database to setup class specific items?

3. Altering the drop table for monsters... possible?

[MentaL]

[HisShadow]

I may be mistaken, but I am fairly certain that the items and character presets (travia doctor, ect) Are hard-coded into the gunz binary. or rather, the item codes of the items they use are. I've seen nothing in the database or xml files that suggest that they can be altered in any way other than modifying the names of the classes (via string replacement) and the items that each type starts with (through changing item ids to match the default items each type is given).

the items dropped in quest can be changed through a combination of droptable, questitems, and the npc definition files. however, the droptable xml file is someone messy and not overly easy to interpret

[Hymn]

I may be mistaken, but I am fairly certain that the items and character presets (travia doctor, ect) Are hard-coded into the gunz binary. or rather, the item codes of the items they use are. I've seen nothing in the database or xml files that suggest that they can be altered in any way other than modifying the names of the classes (via string replacement) and the items that each type starts with (through changing item ids to match the default items each type is given).

the items dropped in quest can be changed through a combination of droptable, questitems, and the npc definition files. however, the droptable xml file is someone messy and not overly easy to interpret

Bleh, if thats true ;_;


Maybe its possible to setup a slash command which sends a request to the database to give you a set of items, and your only allowed to do it once?

Or maybe setup so that you can buy 1 item (lets call it Class Packs) and you only have enough for one item. Upon purchase of that item, it sends the player a set of items to use.

[Komotost]

Im a little late on this, I havent been around for a while...

This is NOT true... You CAN change the items, bounty, level, etc, Of the character being created...

The list of items that is on the character creating menu is in system\strings.xml and the strings for the item is actually stored in your database...

I havent messed with a server in a very long time, so I will just tell you which string it is in, You can figure out what values are for what (Shouldnt be hard if you look at the character table, just a hint)

Ok I just downloaded on of the sql db and here is where it is at...

/****** Object:  StoredProcedure [dbo].[spInsertChar]    Script Date: 03/10/2007 01:32:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE 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,1,@nSex,@nCostume,@nFace,@nHair,NULL,0,99999999,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,getdate(),getdate(),0)
END
GO

@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace,@nHair,NULL,0,99999999,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,getdate(),getdate(),0

Is what you are looking for...

Ok, I no longer have the database I edited on my computer so, I will tell you a rough idea of how to do it...

Ok, The Costume is what you select such as Gun Priest, etc...

You need to return the value for that and run a what/if/what ever it is for sql (I dont recall, it was my only time really working with it) anyways, Run it through the what/if/what ever command until the integer is equal to the one set in the sql...

So, Now lets break this down (I know I said I was going to, But since I dont have the sql for you anymore I can at least do this)

@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace,@nHair,NULL,0,99999999,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,getdate(),getdate(),0

Account ID, Account Name, Character Number, Character Sex, Costume Selected, Face Selected, Hair Selected, Null, EXP, Bounty, Etc, Etc, Etc...


Just look in your dbo.Character

The sql might not be in exact order, But very close... Just need to change a 0 to the item number you want them to start with, YOu can find the 0 to change...

Good luck

Gondie/Komotost

[sexy fire slash]

Komotost. Do not Bump Old Threads.

They Probobally Quit On GunZ P Servers. Or They Don't Go On The Forums No More.

[7-Eleven]

default.mrs for new option

[sexy fire slash]

7-Eleven........ What Are You Talking About Thats For Pics Etc.

[7-Eleven]

Wanna bet, once again? Explore CharCreate.xml first before throwing random flames at someone.

[sexy fire slash]

Hehehehe lol soz.

7-Eleven BTW can you tell me how to use ollydbg to make my TheDuel.exe Or Gunz.exe have no map check?

[7-Eleven]

^ i know nothing about asm html php mssql ,anything

[sexy fire slash]

Wow Wtf. Then How Do You Code?

[Komotost]

You yell at me for 'bumping an old topic' but you wont even keep it on topic...

I simply posted it there because Im sure that there are other people out there that have not figured out how to do it...

And yes, I do know for a FACT that that string contains the integers needed to create a character with specified items.

Please do your research before you attempt to 'enforce the rules' and insult me.

As for the map check, Google is your friend...

Find some old igunz tuts on it...

[7-Eleven]

Wow Wtf. Then How Do You Code?

wow wtf, since when i've coded something?

[sexy fire slash]

My Bad.

And You Have Helped Alot Of People Wit Stuff So I Thought U Where A Coder.

@Komost. Im Not An Idiot. i have been searching for weeks. im a developer and im not stupid enough to break the rules.
I Have Been Searching. So Don't Say Things If You Don't Know What Your Talking About.

[CryptX]

Are you Hymn from Twilight on NAGunz?

[Hymn]

Yes sir I am.

[7-Eleven]

Okay.

I did some testing and you can add new class but I do not know how to make it read stuffs.

Might needs Gunz.exe edits so, you can only edit whats now currently and cant add new ones :(

[NIRVANAdylan]

Hmm,
Maybe the theduel.exe or a Gunz.exe has another check in it to make sure the new added "class" is legit.

I think you should do it the way Sir 7-Eleven ( :) ) did it, then either disable this check, or somehow REFERENCE the class somewhere in the whole Gunz code.