Junior Spellweaver
- Joined
- Mar 22, 2016
- Messages
- 192
- Reaction score
- 32
Hello,
I'm getting an error when using consumable cash shop items from the reward inventory. The error code in the client is 1795. The files I am working with are the 2015 files in the vmbox VM. Here's how I discovered the issue.
I've been trying to figure out how to get items into the player inventory using the database manager because I don't have a working OP tool for my files. The only OP tool I saw for my files was a stripped down version made by xkl and it was missing the functionality I needed. So I searched Ragezone for "nItemKey" because the first issue I had was I had no idea how the ItemKeys were generated. That led me to a post where someone posted an SQL query for creating a welcome back reward system. So I chopped that query up to suit my needs.
The query is here:
I don't know what a few of those columns mean. Some of them are easy because common sense, and some are more cryptic. In another post I was able to find a very basic rundown of what some of the columns mean, which can be found below:
I've been experimenting with the different options and after trial and error, the above query worked. The item is successfully added to the reward inventory. However, when I withdraw the item, it has a "0" in the lower right corner as if it were stackable, and the items i'm using aren't stackable (exp cards) Which tells me i'm doing SOMETHING wrong.
Using said items produces the error code 1795 in the client. I was wondering if it broke all kinds of items, and I created an item (itemID 1250 short bow) and claimed it from the reward inventory and I was able to successfully equip it. However, I noticed that outside of the frame of the weapon description was the following text:
As if it has a phantom license applied to it. I saw another post dealing with this issue using an automated SQL query but I wanted to solve the 1795 error first because if I can solve that, it might also solve whatever caused that creator text. So my questions are:
1.) Is my SQL query sound? It may work, but even broken SQL queries can work. I need a sanity check.
2.) What is error code 1795, and where, if anywhere, can I find a listing of other error codes.
3.) The original query I used as the source for mine had more values for the columns, but I cut out what I thought I could leave NULL. Could this possibly be what the cause is?
4.) Are my notes for the column meanings close? Do they make any sense or am I off base on some or all of them?
5.) How are itemkeys calculated?
6.) Something I noticed about items created with my query, their itemkeys are much much MUCH smaller than the item keys of other items, could this be the cause? If so, where can I start looking to try and fix it?
It's been a while since I have made a post here. I picked up all of this stuff (server development) to have something fun to do, and did it off and on as a hobby. I stopped a while ago, just forgot about it. Now I'm getting back into it. I guess i'm looking for a little bit of constructive feedback and criticism and also a little bit of help. I'm using little to no documentation to figure this all out and i've managed to get this far stumbling in the dark but now i'm at a point where I need a little bit of light.
Thank you in advance for any assistance you can provide.
I'm getting an error when using consumable cash shop items from the reward inventory. The error code in the client is 1795. The files I am working with are the 2015 files in the vmbox VM. Here's how I discovered the issue.
I've been trying to figure out how to get items into the player inventory using the database manager because I don't have a working OP tool for my files. The only OP tool I saw for my files was a stripped down version made by xkl and it was missing the functionality I needed. So I searched Ragezone for "nItemKey" because the first issue I had was I had no idea how the ItemKeys were generated. That led me to a post where someone posted an SQL query for creating a welcome back reward system. So I chopped that query up to suit my needs.
The query is here:
Code:
INSERT INTO dbo.tItem (nItemKey, nStorageType, nOwner, nStorage, nItemID)
VALUES (ABS(CHECKSUM(NewID())) % 99999999999, 2, Character Number, 0, ID of Item to add);
I don't know what a few of those columns mean. Some of them are easy because common sense, and some are more cryptic. In another post I was able to find a very basic rundown of what some of the columns mean, which can be found below:
Code:
1. nItemKey - Identify ID for the Item
2. nStorageType - Inventory/Reward Inventory/Storage
3. nOwner - nCharNo from tCharacter
4. nStorage - Slot of Inventory/Storage (Item slots in ascending order?) (VERY FINICKY)
5. nItemID - ID from ItemInfo
6. nFlags - Idk (Should be something like used or unused or whatever)
7. dDate - Date
I've been experimenting with the different options and after trial and error, the above query worked. The item is successfully added to the reward inventory. However, when I withdraw the item, it has a "0" in the lower right corner as if it were stackable, and the items i'm using aren't stackable (exp cards) Which tells me i'm doing SOMETHING wrong.
Using said items produces the error code 1795 in the client. I was wondering if it broke all kinds of items, and I created an item (itemID 1250 short bow) and claimed it from the reward inventory and I was able to successfully equip it. However, I noticed that outside of the frame of the weapon description was the following text:
Code:
"Creator <>"
As if it has a phantom license applied to it. I saw another post dealing with this issue using an automated SQL query but I wanted to solve the 1795 error first because if I can solve that, it might also solve whatever caused that creator text. So my questions are:
1.) Is my SQL query sound? It may work, but even broken SQL queries can work. I need a sanity check.
2.) What is error code 1795, and where, if anywhere, can I find a listing of other error codes.
3.) The original query I used as the source for mine had more values for the columns, but I cut out what I thought I could leave NULL. Could this possibly be what the cause is?
4.) Are my notes for the column meanings close? Do they make any sense or am I off base on some or all of them?
5.) How are itemkeys calculated?
6.) Something I noticed about items created with my query, their itemkeys are much much MUCH smaller than the item keys of other items, could this be the cause? If so, where can I start looking to try and fix it?
It's been a while since I have made a post here. I picked up all of this stuff (server development) to have something fun to do, and did it off and on as a hobby. I stopped a while ago, just forgot about it. Now I'm getting back into it. I guess i'm looking for a little bit of constructive feedback and criticism and also a little bit of help. I'm using little to no documentation to figure this all out and i've managed to get this far stumbling in the dark but now i'm at a point where I need a little bit of light.
Thank you in advance for any assistance you can provide.
Last edited: