Newbie Spellweaver
- Joined
- Jul 26, 2023
- Messages
- 28
- Reaction score
- 1
Sorry, I'm just a newbie in Cabal Development. Can you help me reset or erase that data so I can receive again the item that I'm going to add using Cabal GM Tool?There is a limit for how much data you can receive from the cash inventory, you'll have to limit the data passed through the stored procedure to guarantee that items will still show up ingame.
A limit of 100 should be fine, you can sort them by the date they were sent, too.
I'm not able to look for the name right now but you'll find it rather easily.
DELETE FROM [CabalCash].[dbo].[MyCashItem] WHERE [IsUse]=0
I'm using Navicat. Is the syntax the same?By running this script in SSMS, you will delete all non-received items.SQL:DELETE FROM [CabalCash].[dbo].[MyCashItem] WHERE [IsUse]=0
Found it manually.By running this script in SSMS, you will delete all non-received items.SQL:DELETE FROM [CabalCash].[dbo].[MyCashItem] WHERE [IsUse]=0
Yes. But to be honest, I don't think it's an overflow issue. There is a limit, but it concerns the amount that will be shown to the user. If you have exceeded the limit, you will not see some of the items, but it will definitely not be empty.I'm using Navicat. Is the syntax the same?
Found it manually.
Can I delete data here manually?
View attachment 239468
I deleted it manually and it has been removed in cash inventory.Yes. But to be honest, I don't think it's an overflow issue. There is a limit, but it concerns the amount that will be shown to the user. If you have exceeded the limit, you will not see some of the items, but it will definitely not be empty.
I would suggest checking the DBAgents logs.
I encountered a similar bug only on a server with 9 classes. This is fixed randomly - a few restarts, a few relogs... idk.
SELECT Top 100 Id, ItemKindIdx, ItemOpt, DurationIdx
FROM MyCashItem
WHERE UserNum = @UserNum AND IsUse = 0 Order by RegDate DESC
I already fixed the problem by deleting the data in the database but I also use your code now and IsUse = 0 doesn't show anymore.The procedure is found under
[CabalCash].[dbo].[up_QueryMyCashItem]
SQL:SELECT Top 100 Id, ItemKindIdx, ItemOpt, DurationIdx FROM MyCashItem WHERE UserNum = @UserNum AND IsUse = 0 Order by RegDate DESC
The above will limit it to 100 results ordered by the date at which they were sent, making sure that the newest items are always showing first.
You can have thousands of items in there and you won't encounter any issues in your cash inventory.
It only seems to have a problem once you've got too many in line but that won't bother you anymore.