Problem with Plasma/Perfect Coating Kit, Exipred date already expired and in red. :S

[dordort]

I sent myself a few times the Perfect and plasma coating kits and when i get it i cant use it or pick it up from my inventory because its in red and date expired. how to make it unexpired.. thanks.


Pic:







Thanks in advance. =]

[MentaL]

[[hidden]]

check durationidx of your mycashitem table in cabalcash daabase.

[dordort]

But all the same value.. 16

[chumpywumpy]

What is the date on the linux machine? The server expires items based on the date on the server not the client and if that is in the past it will cause odd dates. Not sure why it is on red though as i haven't seen it in red before :/

[dordort]

16 February 2015.

More thing chumpy, i sent something wrong to one of my GMS and he can sell it or pick it up, how can i del it from his inventory?

[Yamachi]

Add this stored procedure (taken from here) to Gamedb and use it to add items directly into your inventory:

/****** Object:  Stored Procedure dbo.cabal_tools_additem    Script Date: 2008.07.10  ******/
/****** Copyright (c) ZeRo                                                                                               *****/

create procedure [dbo].[cabal_tools_additem ] (@charid int, @itemid int, @itemopt int, @slot int)
as
begin
  SET NOCOUNT ON

  declare @data varbinary(4096)
select
  @data = A.data 
FROM
  cabal_inventory_table A
WHERE
  A.characteridx =@charid

set @data = @data +
    dbo.wordtobin(@itemid) + 
    dbo.int2bin(0) + 
    dbo.int2bin(@itemopt) +
    dbo.wordtobin(@slot) +
    dbo.int2bin(0)

UPDATE
  dbo.cabal_inventory_table
SET
  data = @data
WHERE
  characteridx = @charid
  
  SET NOCOUNT OFF  
end
GO

16 February 2015.

More thing chumpy, i sent something wrong to one of my GMS and he can sell it or pick it up, how can i del it from his inventory?

use Gamedb.cabal_tool_GetInventory to retrieve the player's inventory, find the item, then remove it and use Gamedb.cabal_tool_SetInventory

[dordort]

Add this stored procedure (taken from here) to Gamedb and use it to add items directly into your inventory:

/****** Object:  Stored Procedure dbo.cabal_tools_additem    Script Date: 2008.07.10  ******/
/****** Copyright (c) ZeRo                                                                                               *****/

create procedure [dbo].[cabal_tools_additem ] (@charid int, @itemid int, @itemopt int, @slot int)
as
begin
  SET NOCOUNT ON

  declare @data varbinary(4096)
select
  @data = A.data 
FROM
  cabal_inventory_table A
WHERE
  A.characteridx =@charid

set @data = @data +
    dbo.wordtobin(@itemid) + 
    dbo.int2bin(0) + 
    dbo.int2bin(@itemopt) +
    dbo.wordtobin(@slot) +
    dbo.int2bin(0)

UPDATE
  dbo.cabal_inventory_table
SET
  data = @data
WHERE
  characteridx = @charid
  
  SET NOCOUNT OFF  
end
GO

use Gamedb.cabal_tool_GetInventory to retrieve the player's inventory, find the item, then remove it and use Gamedb.cabal_tool_SetInventory

Thanks i will try it, but i dont understand how to del the item. when i do this command "exec dbo.cabal_tool_GetInventory" i get the char items but in one line i dont understand nothing.. for example:

0x0300000000000500000000000000000006000000000005000000010000000000

Edit:

Ok with this trick its with no expired time. ;) thanks. but theres no way to fix the time?

And how to del item i need some explain :X


I got more problem, when someone is trying to receive an item that i send him [its happend in some items but not all] they cant get it. this message appear up:



so they cant take it :S i must use the additem procedure. how can i fix it?

[Yamachi]

Get your friend to put all of his items, except the one you want to delete, in his warehouse. Then, do this:

exec dbo.Gamedb.cabal_tool_SetInventory (CharIdx), 0x

Replace (CharIdx) with the GMs character ID
This will wipe his inventory, effectively getting rid of the broken item.

[dordort]

Get your friend to put all of his items, except the one you want to delete, in his warehouse. Then, do this:

exec dbo.Gamedb.cabal_tool_SetInventory (CharIdx), 0x

Replace (CharIdx) with the GMs character ID
This will wipe his inventory, effectively getting rid of the broken item.

Great. big thanks for you =]
And the problem with this ppls cant receive items its because of SAUR0N server changes, so nevermind i just wait for his answer ;)

Edit:

lol the problem with expired happend because of SAUR0N server edit.. now its good when i type the original files back.

[cypher]

I should have watched my mouth and not said/talked shit to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.