Lottery

So i was tryna check lottery system at the on-going projects i found the same bug as follows.

I'd appreciate if someone can help with this issue.

NB: i've checked the navicat tables and c# files already. i couldn't locate the problem since i've compared them to similar projects.

Thanks in advance.

Could you post your image to epvpimg.com next time? It's a bit of labor for me to start up my virtual machine to look at a picture from an unknown host. I'm not sure if others would jump through hoops to do the same / risk it. In terms of the bug, I'm not sure what you're referring to. All I see is a +6 Money Box. Could you elaborate?

Edit: Also, consider using MySQL Workbench. Navicat is outdated or requires pirating. MySQL Workbench is the official editor for MySQL tables. It works a lot better too! The less people using Navicat and AppServ the better!

MySQL Workbench: [Only registered and activated users can see links. Click Here To Register...]
MariaDB (drop in for MySQL which performs better): [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by Spirited Could you post your image to epvpimg.com next time? It's a bit of labor for me to start up my virtual machine to look at a picture from an unknown host. I'm not sure if others would jump through hoops to do the same / risk it. In terms of the bug, I'm not sure what you're referring to. All I see is a +6 Money Box. Could you elaborate?

Spirited , Thanks for letting me know.

here's the original photo.
[Only registered and activated users can see links. Click Here To Register...]

When i try to lotto i found +6 money bags and 2 soc chi packs which is really weird i didn't know you can add the compose or soc features of that type of items (Treasure)

i've been trying to solve out that issue but i couldn't , i really need help.

Thanks for looking into this again.

Quote:

Originally Posted by Luffy11 Spirited , Thanks for letting me know. here's the original photo. [Only registered and activated users can see links. Click Here To Register...] When i try to lotto i found +6 money bags and 2 soc chi packs which is really weird i didn't know you can add the compose or soc features of that type of items (Treasure) i've been trying to solve out that issue but i couldn't , i really need help. Thanks for looking into this again.

Ohh, I see. So the +6 isn't expected. That's interesting. I'm not sure what would cause that besides a bad packet or bad parameters, so could you provide as much of the following as you can: the item ID of that reward, the table or file that's loading from (could be in MySQL or a flat file being loaded in, so look around), a packet dump of that item being sent to the client (on login or when you obtain the item - or if you can't get that, a list of the parameters being used to create the item).

Quote:

Originally Posted by Spirited Ohh, I see. So the +6 isn't expected. That's interesting. I'm not sure what would cause that besides a bad packet or bad parameters, so could you provide as much of the following as you can: the item ID of that reward, the table or file that's loading from (could be in MySQL or a flat file being loaded in, so look around), a packet dump of that item being sent to the client (on login or when you obtain the item - or if you can't get that, a list of the parameters being used to create the item).

The itemtype.dat is imported into the source i believe..

correction ... the file name is lotteryitems.txt i believe it's being loaded in.

Quote:

Originally Posted by Spirited Ohh, I see. So the +6 isn't expected. That's interesting. I'm not sure what would cause that besides a bad packet or bad parameters, so could you provide as much of the following as you can: the item ID of that reward, the table or file that's loading from (could be in MySQL or a flat file being loaded in, so look around), a packet dump of that item being sent to the client (on login or when you obtain the item - or if you can't get that, a list of the parameters being used to create the item).

here's what it looks like from inside i've compared it to other sources nothing looks different or not accurate

Hopefully i can find out what's wrong..

The item ID is correct. Is there any other information you can show me? Like the method that loads the file and decodes it? Or the method that gives you the item? Search by the file name, and you'll find it. Sorry I'm making you go through this step-by-step, by the way. I'm considering making a general guide on problem solving for conquer online servers, and troubleshooting with a real person helps.

Likely it's just sending the item with unintended parameters. Just make sure itempacket is sending the item ID alone

edit: unless of course the item is supposed to be +, a quality or with sockets

Quote:

Originally Posted by Spirited The item ID is correct. Is there any other information you can show me? Like the method that loads the file and decodes it? Or the method that gives you the item? Search by the file name, and you'll find it. Sorry I'm making you go through this step-by-step, by the way. I'm considering making a general guide on problem solving for conquer online servers, and troubleshooting with a real person helps.

Here's more information to you.


And here's what it looks like from inside navicat

Let me know if this helps..

Quote:

Originally Posted by Asphy×ia Likely it's just sending the item with unintended parameters. Just make sure itempacket is sending the item ID alone edit: unless of course the item is supposed to be +, a quality or with sockets

Correct , + quality or sockets are only for specific items ex: (stones-equipment)..

Oh, I figured by your first post that there wasn't a table in MySQL for this. Can you get me a table dump of lottery? Also, it looks like it saves lottery items in that LotteryItems list. If you right click on "LotteryItems" and select "Find all references", you should be able to find where it's using that to hand out items. It might be an NPC action. Then, we can see what that class does with the data. As Asphyxia has mentioned, it's likely a parameter problem when creating the item.

Quote:

Originally Posted by Spirited Oh, I figured by your first post that there wasn't a table in MySQL for this. Can you get me a table dump of lottery? Also, it looks like it saves lottery items in that LotteryItems list. If you right click on "LotteryItems" and select "Find all references", you should be able to find where it's using that to hand out items. It might be an NPC action. Then, we can see what that class does with the data. As Asphyxia has mentioned, it's likely a parameter problem when creating the item.

Here's the table dump from database. and yes it does saves lottery items into the items list

Quote:

Originally Posted by Luffy11 Here's the table dump from database. and yes it does saves lottery items into the items list  Spoiler [Only registered and activated users can see links. Click Here To Register...]

Table looks correct. The only thing left for you to do is follow the code and find where in the code those items are being created. As I said from the previous post: if you right click on "LotteryItems" and select "Find all references", you should be able to find where it's using that to hand out items. It might be an NPC action. Then, we can see what that class does with the data. As Asphyxia has mentioned, it's likely a parameter problem when creating the item. Is this isn't something you're able to do?

Well, as I know, when creating items we make the check on itemtype for default values. The itemtype has the +6 in the items for stones, maybe yours is fetching something wrong or your itemtype (idk why) might have the plus field with the 6 thing inserted.