Random 5 is not realy random!

[RipJawWolfFang]

It seems that the pets in the random 5 realy are not random at all!
they are just 5 of the top 10...
Is there anyway to make it random from all the pets?

[BMR777]

How many pets do you have on your site? The random is generated by the server time, so refreshing the page many times in a short timespan will show many of the same pets.

[Seapyramid]

Actually the bottom five are set to order by clicks .. not by random. Simple error with all the coding you did for this release. I fixed the issue on Mystic Grove and moved them to a page of their own. But it is currently set to oder by clicks and not random in the script download.

Sea

[BMR777]

Actually the bottom five are set to order by clicks .. not by random. Simple error with all the coding you did for this release. I fixed the issue on Mystic Grove and moved them to a page of their own. But it is currently set to oder by clicks and not random in the script download.

Sea


Thanks, I'll have to look into that. It's very possible that is the case as I implemented a new random system for that because the old system from the old release is very server intensive. :)

[RipJawWolfFang]

Alright... So can you tell me how to eather fix it or remove it all together without brakeing anything?

[zhiichiro]

yeah. random 5 pets are from top 10..

[mojaruu]

Alright... So can you tell me how to eather fix it or remove it all together without brakeing anything?


i fixed it by using this code:

$query = "SELECT * FROM ".$prefix."owned_adoptables ORDER BY RAND() LIMIT 5 OFFSET ".$offset."";

instead of this one

$query = "SELECT * FROM ".$prefix."owned_adoptables ORDER BY totalclicks DESC LIMIT 20 OFFSET ".$offset."";

on stats.php. and *poof* its seems that its now randomly listed.

:D

[RipJawWolfFang]

it dose not seem to be working however

[mugwumpr]

It worked great for me! I'm seeing pets I never even knew existed. Thanks mojaruu!

:D

[RipJawWolfFang]

YAY! GOT IT WORKING!