[Solved] Add items to storage query

[devdash]

Hello everyone, i am trying to build a query to add items to storage.
This is what i have achieved so far

exec _ADD_ITEM_EXTERN_CHEST 1417, 3683, 15, 1

1417 -- The Account JID
3683 -- The Item ID
15 -- The Item Quantity
1 -- default

this is the results i am getting after execute

(1 row(s) affected)
(null)
Msg 50000, Level 1, State 16
Msg 8114, Level 16, State 3, Procedure _ADD_ITEM_EXTERN_CHEST_FAST, Line 7
Error converting data type int to tinyint.
The '_ADD_ITEM_EXTERN_CHEST' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

I have tried to modify the procedure it self to int instead of tinyint, the results was

(1 row(s) affected)
(null)
Msg 50000, Level 1, State 16

But still, i see no item in the storage.

I have also discovered that items are added with serials not ITEM ID, but how can it have a serial if it wasn't exist in the first place!!

What i am trying to do is, adding an item to specific account storage, so the item wasn't anywhere so i believe the query should first, make the item then have the serial, then add the serial to the first query.

This is all i know so far...

Your answers will be appreciated. Thanks in advance.

[Laag#82]

Hello,

Wrong

1417 -- The Account JID
3683 -- The Item ID
15 -- The Item Quantity
1 -- default

Correct

'123' -- Account Name
'ITEM_ETC_ARENA_COIN' -- Code Name
15 -- The Item Quantity
1 -- Plus

USE SRO_VT_SHARD
exec _ADD_ITEM_EXTERN_CHEST '123', 'ITEM_ETC_ARENA_COIN', 15, 1

You must add one item in storage

IF you need fix this wrong can go to _ADD_ITEM_EXTERN_CHEST_FAST and fix

Good Luck

[devdash]

Originally Posted by khaleed2010

Hello,

Wrong

1417 -- The Account JID
3683 -- The Item ID
15 -- The Item Quantity
1 -- default

Correct

'123' -- Account Name
'ITEM_ETC_ARENA_COIN' -- Code Name
15 -- The Item Quantity
1 -- Plus

USE SRO_VT_SHARD
exec _ADD_ITEM_EXTERN_CHEST '123', 'ITEM_ETC_ARENA_COIN', 15, 1

You must add one item in storage

IF you need fix this wrong can go to _ADD_ITEM_EXTERN_CHEST_FAST and fix

Good Luck

It doesn't work, i will need further help if possible.
I have tried the query u have mentioned, but no success still.

[Laag#82]

Originally Posted by alydandy

It doesn't work, i will need further help if possible.
I have tried the query u have mentioned, but no success still.

Hello,

Test

You must add one item in storage

[devdash]

Originally Posted by khaleed2010

Hello,

Test

You must add one item in storage

The storage have an item already, still same errors

#CASE 1



#CASE 2 (after i edit the tinyint to int in _ADD_ITEM_EXTERN_CHEST procedure)



I believe u have edited something else that u forgot to mention.

NOTE: i tried to use JID, CharName, CharID, and UserName, the same error all the time.

[OKeks]

Account does not exist:

(1 row(s) affected)
(null)
Msg 50000, Level 1, State 16
Msg 8114, Level 16, State 3, Procedure _ADD_ITEM_EXTERN_CHEST_FAST, Line 0
Fehler beim Konvertieren des int-Datentyps in tinyint.

Storage Empty and Account does exist:

(1 row(s) affected)
chest Full! JID is 8              , item: 25834          
Msg 50000, Level 1, State 16
Msg 8114, Level 16, State 3, Procedure _ADD_ITEM_EXTERN_CHEST_FAST, Line 0
Fehler beim Konvertieren des int-Datentyps in tinyint.

Storage not empty and Accound does exist:

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

I guess your account name is wrong. Go to account DB, TB_USER and select an existing StrUserID to use the query (Storage not empty!).
My account name was "log5"...

[devdash]

interesting, worked only when i created an account with username log5 xD
Idk what is wrong with other usernames, this is what i am trying to figure out now.

Thanks anyway you all <3, helped a lot.

#Request_Topic_Close. @

[Devsome]

Originally Posted by alydandy

interesting, worked only when i created an account with username log5 xD
Idk what is wrong with other usernames, this is what i am trying to figure out now.

Thanks anyway you all <3, helped a lot.

#Request_Topic_Close. @

Nice you mention Spidy but she isn't any mod. Please use the report button! To request a close...

[devdash]

Originally Posted by Devsome

Nice you mention Spidy but she isn't any mod. Please use the report button! To request a close...

Old habit, alright next time then.

done.