Add items to storage query

04/05/2021 16:09 devdash#1

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.

04/06/2021 01:59 Laag#82#2

Hello,

Wrong

Code:

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

Correct

Code:

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

Code:

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

[Only registered and activated users can see links. Click Here To Register...] 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

04/06/2021 21:41 devdash#3

Quote:
Originally Posted by khaleed2010
Hello,

Wrong
Code:
1417 -- The Account JID
3683 -- The Item ID
15 -- The Item Quantity
1 -- default
Correct
Code:
'123' -- Account Name
'ITEM_ETC_ARENA_COIN' -- Code Name
15 -- The Item Quantity
1 -- Plus
Code:
USE SRO_VT_SHARD
exec _ADD_ITEM_EXTERN_CHEST '123', 'ITEM_ETC_ARENA_COIN', 15, 1
[Only registered and activated users can see links. Click Here To Register...] 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.

04/06/2021 22:04 Laag#82#4

Quote:

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,

Code:

Test

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...] You must add one item in storage

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

04/07/2021 16:40 devdash#5

Quote:
Originally Posted by khaleed2010
Hello,
Code:
Test
[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...] You must add one item in storage

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

The storage have an item already, still same errors

#CASE 1
[Only registered and activated users can see links. Click Here To Register...]

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

[Only registered and activated users can see links. Click Here To Register...]

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.

04/12/2021 21:16 OKeks#6

Account does not exist:

Code:

(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:

Code:

(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:

Code:

(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"...

04/14/2021 13:40 devdash#7

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. @[Only registered and activated users can see links. Click Here To Register...]

04/14/2021 21:30 Devsome#8

Quote:

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. @[Only registered and activated users can see links. Click Here To Register...]

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

04/14/2021 22:46 devdash#9

Quote:

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.