Removing items from inventory

[buzz2289]

Hello all i have a questing,

We have an issue with pets being bugged after setting it as a starting item when players create a character, so i would like to know how i can delete a pet from all players inventory, the pet is a Peng, when you hover mouse near it, it pops up telling the player "invalid pet" so i need to forcibly remove them.

How might this be done? thanks in advance

[MentaL]

[buzz2289]

A little assistance would be great! i dont ask for a hand feed, but just a bump forward.

[PunkS7yle]

You could use the ChangeItem file to change all those pets to an UCH or a disc or something similar.

[lifestream]

Hmm i havent done anything item related yet so not sure - but generally i would approach it by running a DB query to search and update specific value.

USE db_name
DECLARE @x number=0
DECLARE @colname varchar(max) = 'invslot'
DECLARE @sql varchar(max)
While x <= 21
BEGIN
SET @colname = 'invslot'
SET @x=@x+1
SET @colname = @colname + @x

SELECT @sql ='UPDATE  tablename SET'+@colname+' = NULL WHERE '+@colname+'="pet"

exec (@sql)

END

the NULL to 0 or what ever the default should be. x <= 21 - the number of inv slots. @colname is the column name for inv (without the leading number? like invslot1 invslot2 invslot3).

This is simple script - however no idea if it works - i dont know the db structure for cabal yet.
A dynamic sql that loops through tge table, synamically changing column name and only updates when x value is found.

[PunkS7yle]

Hmm i havent done anything item related yet so not sure - but generally i would approach it by running a DB query to search and update specific value.

USE db_name
DECLARE @x number=0
DECLARE @colname varchar(max) = 'invslot'
DECLARE @sql varchar(max)
While x <= 21
BEGIN
SET @colname = 'invslot'
SET @x=@x+1
SET @colname = @colname + @x

SELECT @sql ='UPDATE  tablename SET'+@colname+' = NULL WHERE '+@colname+'="pet"

exec (@sql)

END

the NULL to 0 or what ever the default should be. x <= 21 - the number of inv slots. @colname is the column name for inv (without the leading number? like invslot1 invslot2 invslot3).

This is simple script - however no idea if it works - i dont know the db structure for cabal yet.
A dynamic sql that loops through tge table, synamically changing column name and only updates when x value is found.

Inventory data is binary bulk, that won't work.

[lifestream]

So it doesnt have separate column for each slot, ratehr all is stored as one string in database?

nvm that... it cant have... items are diff size and ranomly placed in the inventory.

Cant they just sell it?

[PunkS7yle]

My suggestion would work fine.

[buzz2289]

You could use the ChangeItem file to change all those pets to an UCH or a disc or something similar.

Thank you so much now i hate looking like an idiot, but where/what is the "changeItem" file?

[lifestream]

\etc\cabal\Data

[buzz2289]

I think that ruined every character that had that pet, cause now they all DC when trying to log in

here is the error:

[Tue Oct 1 2013 00:03:47.844610 3075214192]: 1.open user 84 [A8AFCAA8] (xxx.xxx.xxx.xxx)
[Tue Oct 1 2013 00:03:53.904493 2753530768]: [RANK LIMIT] characterIdx (299) set to Novice, type BattleStyleLev
[Tue Oct 1 2013 00:03:53.904705 2753530768]: [##ERROR##] ApplyForInit(): CanEquipItemInSlot false. CharIdx(299), SlotIdx(11), ItemType(34)
[Tue Oct 1 2013 00:03:53.904720 2753530768]: close(): closing(xxx.xxx.xxx.xxx)
[Tue Oct 1 2013 00:03:53.904787 2753530768]: 1.close user -1 [A8AFCAA8] (xxx.xxx.xxx.xxx)
[Tue Oct 1 2013 00:03:53.904814 2753530768]: [##ERROR##] 'OnITCResultInits' fail (Proc/Initialize.cpp:1591)

[lifestream]

No idea, never used it - but could it have beel a wrong value you used, so the item in inv causes them to crit sicne it doesnt exist or is bugged?

[PunkS7yle]

Under [ChangeWeapon] field put this in

0	PETID 0 PETID 1 0

let me know and always test on a local/test server first.. or make backups.

[buzz2289]

ok i will
and i did have a backup thank god haha

[ChangeWeapon] ItemIndex ItemDuration TriggerKind ChangeKind ChangeDuration

these are my rows, your line didn't take in right what is a TriggerKind?

Under [ChangeWeapon] field put this in

0	PETID 0 PETID 1 0

let me know and always test on a local/test server first.. or make backups.

Problem solve much thanks!!

[PunkS7yle]

You iz welcome.