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
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();
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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
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@gmail.com
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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
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@gmail.com wrote:
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@gmail.com
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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Hi Platonides, I have tried the method at JBDirectory.comhttp://jbdirectory.combut 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@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@gmail.com wrote:
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@gmail.com
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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
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@gmail.com wrote:
Hi Platonides, I have tried the method at JBDirectory.comhttp://jbdirectory.combut 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@gmail.comwrote:
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@gmail.com wrote:
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@gmail.com
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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
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@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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
Ekompute .info wrote:
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
$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).
Hi Platonides, thank you very much for your clear explanation.
PM Poon
On Fri, Jul 10, 2009 at 2:46 AM, Platonides Platonides@gmail.com wrote:
Ekompute .info wrote:
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
$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@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org