Jump to: navigation, search

Rollover for the manual

111 bytes added, 03:28, 9 April 2014
no edit summary
Finally, if you want to set all the previous version pages to be protected, so only sysop mediawiki users are able to make changes (so all changes will be forced into the next set of pages...), you can use a series of sql statements in the form:
UPDATE `grampsd_wikigrampswiki2`.`page` SET `page_restrictions` = 0x656469743d7379736f703a6d6f76653d7379736f70 WHERE `page`.`page_title` ='Title_of_the_page_in_the_wiki' collate utf8_unicode_ci LIMIT 1;
(You'll need to replace the spaces in the page title with underscores...)
I do that concatenation in a spreadsheet, creating the (long) SQL statements by combining a first part, the page names and the last part. You'll need to search for any single quotes and put a backslash in front of them in the page names first, too...
That updates a blob field to force protection without having to do the pages individually. You need to do the above sql statement for each page that you want to protect...

Navigation menu