Dawn of Daria Forum Index Dawn of Daria
Official forums
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

a little bug/glitch with flower top

 
Post new topic   Reply to topic    Dawn of Daria Forum Index -> Bugs in Daria
View previous topic :: View next topic  
Author Message
catslayer
Posts until end: 920


Joined: 01 Mar 2005
Posts: 80
Location: Moscow, Russia

PostPosted: Thu Feb 23, 2006 10:26 am    Post subject: a little bug/glitch with flower top Reply with quote

Noticed it a couple of times: when 2 players have same amount of flowers, he(she), that obtained this amount more recently is placed higher. But after some time, if theese two don't pick any more flowers, they switch. After some more time they switch again. And again... That's strange.
_________________
...so sayeth the wise Slayer.
[posts may be odd, if I'm sleepy]
[it's not "cat-slayer" (which would mean "cat that slays"), it's "catslayer" (which means "slayer of cats") therefore cutting my nick to "cat" is wrong]
Back to top
View user's profile Send private message Visit poster's website ICQ Number
jeb
Posts until end: 500


Joined: 29 Nov 2004
Posts: 730
Location: In your closet

PostPosted: Thu Feb 23, 2006 11:21 am    Post subject: Reply with quote

Shocked
That's strange indeed!
_________________
This post made by me may not be the official opinion of the Dawn of Daria crew or Oxeye Game Studio. I may also say things that are incorrect or based on hopes and expectations. Viewer discretion is adviced. Oxeye
Back to top
View user's profile Send private message Visit poster's website
kiwi
Posts until end: 1000


Joined: 24 Dec 2006
Posts: 7

PostPosted: Sun Dec 24, 2006 4:59 pm    Post subject: Reply with quote

Jeb,

I've got a hunch on this one, if you so happen to use something like this;

Code:

SELECT FlowerCount FROM Users ORDER BY FlowerCount DESC;


Then MySQL will not guarantee the order of rows if FlowerCount is equal. In other words, if user A has 8 flowers, and user B has 8 flowers as well, then it is not guaranteed which user will appear first, A or B.

Therefore, to work out the problem, I would like to propose a double sort, for example including the account ID Smile This way the sort will be consistent, and you will not experience any "jumping" around of records in your sorted dataset.

Code:

SELECT AccountID, FlowerCount FROM Users ORDER BY FlowerCount, AccountID DESC;


Hope this helps ya out!

Best,
Michael van Horen a.k.a. Kiwi
_________________
O, rly?
Back to top
View user's profile Send private message
jeb
Posts until end: 500


Joined: 29 Nov 2004
Posts: 730
Location: In your closet

PostPosted: Sun Dec 24, 2006 10:58 pm    Post subject: Reply with quote

This bug was posted for Alpha 1, as there is no top list for flowers any longer.

Thanks for the tip, though Smile
_________________
This post made by me may not be the official opinion of the Dawn of Daria crew or Oxeye Game Studio. I may also say things that are incorrect or based on hopes and expectations. Viewer discretion is adviced. Oxeye
Back to top
View user's profile Send private message Visit poster's website
kiwi
Posts until end: 1000


Joined: 24 Dec 2006
Posts: 7

PostPosted: Sun Dec 24, 2006 11:06 pm    Post subject: Reply with quote

Silly me Smile
_________________
O, rly?
Back to top
View user's profile Send private message
Dracula
Posts until end: 1000


Joined: 20 Dec 2006
Posts: 4

PostPosted: Mon Dec 25, 2006 11:07 am    Post subject: Reply with quote

It happens sometimes for the fruits, kiwi Wink
Exclamation
Back to top
View user's profile Send private message
jeb
Posts until end: 500


Joined: 29 Nov 2004
Posts: 730
Location: In your closet

PostPosted: Mon Dec 25, 2006 11:09 am    Post subject: Reply with quote

Hehe, maybe I should lock threads that are "obsolete"... What do you think?
_________________
This post made by me may not be the official opinion of the Dawn of Daria crew or Oxeye Game Studio. I may also say things that are incorrect or based on hopes and expectations. Viewer discretion is adviced. Oxeye
Back to top
View user's profile Send private message Visit poster's website
kiwi
Posts until end: 1000


Joined: 24 Dec 2006
Posts: 7

PostPosted: Mon Dec 25, 2006 1:39 pm    Post subject: Reply with quote

Agreed, would help to prevent confusion Smile
_________________
O, rly?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Dawn of Daria Forum Index -> Bugs in Daria All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

Style by Oxeye Game Studio