Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Adding items to dbo.character

Junior Spellweaver
Joined
Jun 7, 2009
Messages
195
Reaction score
24
I tried to look up a way to put items into the dbo.character but no luck.

Can someone please tell me how I can give GM weapons via dbo.character? I know how to edit primaryitemid/secondaryitemid with the item id, but, but I dont know what to fill in for primary_slot or secondary_slot.
 
Last edited:
Experienced Elementalist
Joined
Sep 4, 2009
Messages
248
Reaction score
69
Re: modding dbo.character

Why? dbo.CharacterItem works just fine.
If you want to do it that way, though, you will need to edit a few places in MatchServer and probably the Client.
 
Upvote 0
Junior Spellweaver
Joined
Jun 7, 2009
Messages
195
Reaction score
24
Re: modding dbo.character

Why? dbo.CharacterItem works just fine.
If you want to do it that way, though, you will need to edit a few places in MatchServer and probably the Client.

I don't think you understand what I meant. I know it works fine, I'm just trying to edit a character's current primary weapon with another, and that requires filling in boxes for primary_slot, and primaryitemid.

I do not know what to fill in for primary_slot. I'm pretty sure I can do this all in dbo.character.
 
Last edited:
Upvote 0
Skilled Illusionist
Joined
Dec 18, 2009
Messages
300
Reaction score
82
Log into SQL, Click New Query, copy this:
UPDATE Character SET primary_itemid='ITEMID' WHERE Name=NAME

Just edit the name that marked, and itemid.
Then right click on master, choose GunzDB then hit Excute and done.
 
Upvote 0
Junior Spellweaver
Joined
Jun 7, 2009
Messages
195
Reaction score
24
Log into SQL, Click New Query, copy this:
UPDATE Character SET primary_itemid='ITEMID' WHERE Name=NAME

Just edit the name that marked, and itemid.
Then right click on master, choose GunzDB then hit Excute and done.

Isnt that just replacing the primary_item id of the character?
 
Last edited:
Upvote 0
Praise the Sun!
Loyal Member
Joined
Dec 4, 2007
Messages
2,502
Reaction score
986
Try something like

DECLARE @CID int
DECLARE @CIID int
SELECT @CID = CID FROM Character WHERE Name = 'Wizkid';
SELECT @CIID = CIID FROM CharacterItem WHERE CID = @CID AND ItemID = '15';
UPDATE Character SET primary_itemid = @CIID WHERE CID = @CID
 
Upvote 0
Junior Spellweaver
Joined
Jun 7, 2009
Messages
195
Reaction score
24
Log into SQL, Click New Query, copy this:
UPDATE Character SET primary_itemid='ITEMID' WHERE Name=NAME

Just edit the name that marked, and itemid.
Then right click on master, choose GunzDB then hit Excute and done.

Code:
UPDATE Character SET primary_itemid='4001' WHERE Name=Admin
Tried this, came up with
Code:
Invalid column name 'Admin'.
 
Upvote 0
Junior Spellweaver
Joined
Jun 7, 2009
Messages
195
Reaction score
24
Nope, you don't need to save it. After it's completed, you can just close everything w/o saving.


I logged in after executing: (no errors after adding the quotes around admin)

Code:
UPDATE Character SET primary_itemid='4001' WHERE Name='Admin'

and my primary weapon is still the same as before I executed the query.

I don't need to restart the server do I?
 
Last edited:
Upvote 0
Junior Spellweaver
Joined
Jun 7, 2009
Messages
195
Reaction score
24
When I login it previews my character with the weapon I assigned, but when I go into equip, the new weapon does not show up.
 
Upvote 0
Back
Top