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 <[email protected]> wrote: > 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 <[email protected]>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 <[email protected]> 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 <[email protected]> >>> >>> > 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 <[email protected]> >>> 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 >>> > > [email protected] >>> > > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l >>> > > >>> > _______________________________________________ >>> > MediaWiki-l mailing list >>> > [email protected] >>> > https://lists.wikimedia.org/mailman/listinfo/mediawiki-l >>> > >>> _______________________________________________ >>> MediaWiki-l mailing list >>> [email protected] >>> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l >>> >> >> > _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
