Adding items to dbo.character

[eagledude4]

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.

 

[PenguinGuys]

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.

 

[eagledude4]

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.

 

[eagledude4]

This sould be easy stuff for the dbo. pros, cmon ppl.

 

[wtfhacker]

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.

 

[eagledude4]

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?

 

[Solaire]

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

 

[eagledude4]

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.

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

Tried this, came up with

Invalid column name 'Admin'.

 

[Solaire]

Use quotes at names.

 

[eagledude4]

Use quotes at names.

added the quotes, and it worked. I don't save the new query do I?

 

[Phoenix]

added the quotes, and it worked. I don't save the new query do I?

Nope, you don't need to save it. After it's completed, you can just close everything w/o saving.

 

[eagledude4]

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)

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?

 

[eagledude4]

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.