Random button not random

List overview All Threads
Download

newer

older

Block New Users

Re: [Mediawiki-l] Problems with...

Ekompute .info

27 Jun 2009 27 Jun '09

9:02 p.m.

Hi, it seems like my random button is not working very well. It keeps on repeating certain pages instead of moving on. How can I can better randomness? PM Poon

Show replies by date

Platonides

28 Jun 28 Jun

1:04 a.m.

New subject: [Mediawiki-l] Random button not random

Ekompute .info wrote:

...

Hi, it seems like my random button is not working very well. It keeps on repeating certain pages instead of moving on. How can I can better randomness? PM Poon

Your random ids are not evenly distributed. Execute the query: UPDATE page SET page_random = RAND();

Ekompute .info

7:56 a.m.

New subject: [Mediawiki-l] Random button not random

Hi Platonides, thank you for your response. I am a real monkey. I will find out how to execute that query through Google Search. If you have a read tutorial somewhere, do let me know too. Thank you. PM Poon On Sun, Jun 28, 2009 at 7:04 AM, Platonides <Platonides(a)gmail.com> wrote:

...

Ekompute .info wrote:

Hi, it seems like my random button is not working very well. It keeps on repeating certain pages instead of moving on. How can I can better randomness? PM Poon

Your random ids are not evenly distributed. Execute the query: UPDATE page SET page_random = RAND(); _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Alex Barley

12:58 p.m.

New subject: [Mediawiki-l] Random button not random

It's a MySQL query. If you have a commercial host (not your computer) running cPanel, it will probably have PHPMyAdmin - you can run the query from there. If you have installed Apache, PHP and MySQL on your computer, you'd be best off using the MySQL administrator program. 2009/6/28 Ekompute .info <ekompute(a)gmail.com>

...

Ekompute .info wrote: > Hi, it seems like my random button is not working very well. It keeps

repeating certain pages instead of moving on. How can I can better randomness? PM Poon

_______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Ekompute .info

7:19 p.m.

New subject: [Mediawiki-l] Random button not random

Thank you Alex. Yes, I am on shared hosting and it has PHPMyAdmin. PM Poon On Sun, Jun 28, 2009 at 6:58 PM, Alex Barley <alejrb(a)gmail.com> wrote:

...

Hi Platonides, thank you for your response. I am a real monkey. I will

find

out how to execute that query through Google Search. If you have a read tutorial somewhere, do let me know too. Thank you. PM Poon On Sun, Jun 28, 2009 at 7:04 AM, Platonides <Platonides(a)gmail.com>

wrote:

Ekompute .info wrote: > Hi, it seems like my random button is not working very well. It keeps

repeating certain pages instead of moving on. How can I can better randomness? PM Poon

_______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Ekompute .info

8 Jul 8 Jul

2:58 a.m.

New subject: [Mediawiki-l] Random button not random

Hi Platonides, I have tried the method at JBDirectory.com<http://jbdirectory.com>but apparently, it is still not random. I wonder what could have happened. I click the SQL button at the top (2nd tab) of pHpAdmin and execute the query, after I found that the query box in Query (4th tab) did not work. PM Poon On Mon, Jun 29, 2009 at 1:19 AM, Ekompute .info <ekompute(a)gmail.com> wrote:

...

Thank you Alex. Yes, I am on shared hosting and it has PHPMyAdmin. PM Poon On Sun, Jun 28, 2009 at 6:58 PM, Alex Barley <alejrb(a)gmail.com> wrote:

Hi Platonides, thank you for your response. I am a real monkey. I will

find

out how to execute that query through Google Search. If you have a read tutorial somewhere, do let me know too. Thank you. PM Poon On Sun, Jun 28, 2009 at 7:04 AM, Platonides <Platonides(a)gmail.com>

wrote:

> Ekompute .info wrote: > > Hi, it seems like my random button is not working very well. It

keeps

> repeating certain pages instead of moving on. How can I can better > randomness? > > PM Poon Your random ids are not evenly distributed. Execute the query: UPDATE page SET page_random = RAND(); _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

_______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Ekompute .info

9 Jul 9 Jul

5:15 p.m.

New subject: [Mediawiki-l] Random button not random

Hi, I think I know why my random button did not work with: UPDATE page SET page_random = RAND(); I had set the random link in LocalSettings.php to read only protected pages as follows: $wgExtraRandompageSQL = '(select count(*) from page_restrictions where pr_page=page_id and pr_type="edit")'; . How do I modify the above command to do that? PM Poon On Wed, Jul 8, 2009 at 8:58 AM, Ekompute .info <ekompute(a)gmail.com> wrote:

...

Thank you Alex. Yes, I am on shared hosting and it has PHPMyAdmin. PM Poon On Sun, Jun 28, 2009 at 6:58 PM, Alex Barley <alejrb(a)gmail.com> wrote:

Hi Platonides, thank you for your response. I am a real monkey. I will

find

out how to execute that query through Google Search. If you have a read tutorial somewhere, do let me know too. Thank you. PM Poon On Sun, Jun 28, 2009 at 7:04 AM, Platonides <Platonides(a)gmail.com>

wrote:

> Ekompute .info wrote: > > Hi, it seems like my random button is not working very well. It

keeps

on > > repeating certain pages instead of moving on. How can I can better > > randomness? > > > > PM Poon > > Your random ids are not evenly distributed. > Execute the query: UPDATE page SET page_random = RAND(); > > > _______________________________________________ > MediaWiki-l mailing list > MediaWiki-l(a)lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l > _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

_______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Platonides

6:15 p.m.

New subject: [Mediawiki-l] Random button not random

Ekompute .info wrote:

...

How do I modify the above command to do that?

UPDATE page SET page_random = RAND() WHERE (select count(*) from page_restrictions where pr_page=page_id and pr_type="edit");

Ekompute .info

6:44 p.m.

New subject: [Mediawiki-l] Random button not random

Hi Platonides, thank you for your reply. I have done it and it works for Dummipedia.org but not for JBDirectory.com. I wonder why. Could it be because of pr_type="edit"? I am wondering whether that clause is necessarily and what it actually does. PM Poon On Fri, Jul 10, 2009 at 12:15 AM, Platonides <Platonides(a)gmail.com> wrote:

...

Ekompute .info wrote:

How do I modify the above command to do that?

UPDATE page SET page_random = RAND() WHERE (select count(*) from page_restrictions where pr_page=page_id and pr_type="edit"); _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Platonides

8:46 p.m.

New subject: [Mediawiki-l] Random button not random

Ekompute .info wrote:

...

$wgExtraRandompageSQL is just a WHERE clause. Here I am just adding it to the rerandoming SQL to help giving an even randomness to all articles. The query

...

select count(*) from page_restrictions where pr_page=page_id and

pr_type="edit" is used to select only pages protected for edit (new system protection only).

Ekompute .info

10 Jul 10 Jul

1:30 a.m.

New subject: [Mediawiki-l] Random button not random

Hi Platonides, thank you very much for your clear explanation. PM Poon On Fri, Jul 10, 2009 at 2:46 AM, Platonides <Platonides(a)gmail.com> wrote:

...

Ekompute .info wrote:

necessarily

and what it actually does. PM Poon

$wgExtraRandompageSQL is just a WHERE clause. Here I am just adding it to the rerandoming SQL to help giving an even randomness to all articles. The query

select count(*) from page_restrictions where pr_page=page_id and

pr_type="edit" is used to select only pages protected for edit (new system protection only). _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

5404

days inactive

5416

days old

mediawiki-l@lists.wikimedia.org

Manage subscription

10 comments

3 participants

tags (0)

participants (3)

Alex Barley
Ekompute .info
Platonides