Register for your free account! | Forgot your password?

You last visited: Today at 20:08

  • Please register to post and access all features, it's quick, easy and FREE!

 

Lottery

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jul 2011
Posts: 28
Received Thanks: 0
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.



Luffy11 is offline  
Old   #2

 
elite*gold: 0
Join Date: Jul 2011
Posts: 6,536
Received Thanks: 3,170
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:
MariaDB (drop in for MySQL which performs better):


Spirited is offline  
Old   #3
 
elite*gold: 0
Join Date: Jul 2011
Posts: 28
Received Thanks: 0
Quote:
Originally Posted by Spirited View Post
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.
You must register and activate your account in order to view images.

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.
Luffy11 is offline  
Old   #4

 
elite*gold: 0
Join Date: Jul 2011
Posts: 6,536
Received Thanks: 3,170
Quote:
Originally Posted by Luffy11 View Post
Spirited , Thanks for letting me know.

here's the original photo. You must register and activate your account in order to view images.

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).


Spirited is offline  
Old   #5
 
elite*gold: 0
Join Date: Jul 2011
Posts: 28
Received Thanks: 0
Quote:
Originally Posted by Spirited View Post
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 View Post
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..
Luffy11 is offline  
Old   #6

 
elite*gold: 0
Join Date: Jul 2011
Posts: 6,536
Received Thanks: 3,170
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.
Spirited is offline  
Old   #7
 
elite*gold: 0
Join Date: Feb 2014
Posts: 99
Received Thanks: 56
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
Asphy×ia is offline  
Old   #8
 
elite*gold: 0
Join Date: Jul 2011
Posts: 28
Received Thanks: 0
Quote:
Originally Posted by Spirited View Post
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..
Attached Files
File Type: txt LotteryTable.cs.txt (2.9 KB, 2 views)
File Type: txt LotteryItems.txt (8.5 KB, 3 views)
Luffy11 is offline  
Old   #9
 
elite*gold: 0
Join Date: Jul 2011
Posts: 28
Received Thanks: 0
Quote:
Originally Posted by Asphy×ia View Post
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)..
Luffy11 is offline  
Old   #10

 
elite*gold: 0
Join Date: Jul 2011
Posts: 6,536
Received Thanks: 3,170
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.
Spirited is offline  
Old   #11
 
elite*gold: 0
Join Date: Jul 2011
Posts: 28
Received Thanks: 0
Quote:
Originally Posted by Spirited View Post
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

Attached Files
File Type: rar lottery.rar (3.2 KB, 1 views)
Luffy11 is offline  
Old   #12

 
elite*gold: 0
Join Date: Jul 2011
Posts: 6,536
Received Thanks: 3,170
Quote:
Originally Posted by Luffy11 View Post
Here's the table dump from database. and yes it does saves lottery items into the items list

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?
Spirited is offline  
Old   #13
 
elite*gold: 0
Join Date: Jul 2009
Posts: 458
Received Thanks: 164
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.


pintinho12 is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Lottery
lets hear the tips on the lottery. i hear you should pick the 2nd gold box, and summon your pets. i know some of you know exactly how to get what...
26 Replies - Eudemons Online
Lottery Winning
My winnings are 2 Soc Robe +8 Hat 7 Exp Pots 4 Exp balls 2 met tear bags 2 +1 stone bags 5 +1 stones 7 +2 Stones
229 Replies - CO2 Main - Discussions / Questions
Prize indicator ( lucky lottery)
Wont it be kool if we could see which box has what before you guys start flaming me i searched on this topic and no result well i was wondering if...
11 Replies - CO2 Main - Discussions / Questions
Item Dat. for the lottery?
i was thinking, isit possible to make a item dat thing (like the one that shows supers and elites) for the new lottery?
9 Replies - CO2 Main - Discussions / Questions



All times are GMT +1. The time now is 20:08.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.