ARCHIVE_UPDATE_SCRIPT.php

   1 <?php
   2
   3
   4
   5 // require 'inc/config.php';
   6 // require 'inc/config_instance.php';
   7 require 'inc/functions.php';
   8
   9
  10 global $config;
  11
  12 // Check so only ADMIN can run script
  13 check_login(true);
  14 if (!$mod || $mod['type'] != ADMIN)
  15     die("You need to be logged in as admin");
  16
  17
  18
  19
  20 $page['title'] = 'Updating Database - Archiving of Threads';
  21
  22
  23 $step = isset($_GET['step']) ? round($_GET['step']) : 0;
  24
  25 switch($step)
  26 {
  27     default:
  28     case 0:
  29         $page['body'] = '<p style="text-align:center">You are about to update the database to allow archiving of threads.</p>';
  30         $page['body'] .= '<p style="text-align:center"><a href="?step=2">Click here to update database entries.</a></p>';
  31     break;
  32         case 2:
  33                 $page['body'] = '<p style="text-align:center">Database have been updated.</p>';
  34
  35                 $sql_errors = "";
  36
  37                 // Update posts_* table to archive function
  38                 // Get list of boards
  39                 $boards = listBoards();
  40                 foreach ($boards as &$_board) {
  41                         $query = Element('archive.sql', array('board' => $_board['uri']));
  42                         if (mysql_version() < 50503)
  43                                 $query = preg_replace('/(CHARSET=|CHARACTER SET )utf8mb4/', '$1utf8', $query);
  44                         query($query) or error(db_error());;
  45
  46                         // Create Archive Folders
  47                         if (!file_exists( $_board['uri'] . "/" . $config['dir']['archive']))
  48                                 @mkdir( $_board['uri'] . "/" . $config['dir']['archive'], 0777)
  49                                         or error("Couldn't create " .  $_board['uri'] . "/" . $config['dir']['archive'] . ". Check permissions.", true);
  50                         if (!file_exists($_board['uri'] . "/" . $config['dir']['archive'] . $config['dir']['img']))
  51                                 @mkdir($_board['uri'] . "/" . $config['dir']['archive'] . $config['dir']['img'], 0777)
  52                                         or error("Couldn't create " . $_board['uri'] . "/" . $config['dir']['archive'] . $config['dir']['img'] . ". Check permissions.", true);
  53                         if (!file_exists($_board['uri'] . "/" . $config['dir']['archive'] . $config['dir']['thumb']))
  54                                 @mkdir($_board['uri'] . "/" . $config['dir']['archive'] . $config['dir']['thumb'], 0777)
  55                                         or error("Couldn't create " . $_board['uri'] . "/" . $config['dir']['archive'] . $config['dir']['img'] . ". Check permissions.", true);
  56                         if (!file_exists($_board['uri'] . "/" . $config['dir']['archive'] . $config['dir']['res']))
  57                                 @mkdir($_board['uri'] . "/" . $config['dir']['archive'] . $config['dir']['res'], 0777)
  58                                         or error("Couldn't create " . $_board['uri'] . "/" . $config['dir']['archive'] . $config['dir']['img'] . ". Check permissions.", true);
  59                         // Create Featured threads Folders
  60                         if (!file_exists($_board['uri'] . "/" . $config['dir']['featured']))
  61                                 @mkdir($_board['uri'] . "/" . $config['dir']['featured'], 0777)
  62                                         or error("Couldn't create " . $_board['uri'] . "/" . $config['dir']['featured'] . ". Check permissions.", true);
  63                         if (!file_exists($_board['uri'] . "/" . $config['dir']['featured'] . $config['dir']['img']))
  64                                 @mkdir($_board['uri'] . "/" . $config['dir']['featured'] . $config['dir']['img'], 0777)
  65                                         or error("Couldn't create " . $_board['uri'] . "/" . $config['dir']['featured'] . $config['dir']['img'] . ". Check permissions.", true);
  66                         if (!file_exists($_board['uri'] . "/" . $config['dir']['featured'] . $config['dir']['thumb']))
  67                                 @mkdir($_board['uri'] . "/" . $config['dir']['featured'] . $config['dir']['thumb'], 0777)
  68                                         or error("Couldn't create " . $_board['uri'] . "/" . $config['dir']['featured'] . $config['dir']['img'] . ". Check permissions.", true);
  69                         if (!file_exists($_board['uri'] . "/" . $config['dir']['featured'] . $config['dir']['res']))
  70                                 @mkdir($_board['uri'] . "/" . $config['dir']['featured'] . $config['dir']['res'], 0777)
  71                                         or error("Couldn't create " . $_board['uri'] . "/" . $config['dir']['featured'] . $config['dir']['img'] . ". Check permissions.", true);
  72                 }
  73
  74                 if (!empty($sql_errors))
  75                     $page['body'] .= '<div class="ban"><h2>SQL errors</h2><p>SQL errors were encountered when trying to update the database and hashing ip addresses.</p><p>The errors encountered were:</p><ul>' . $sql_errors . '</ul></div>';
  76
  77                 break;
  78 }
  79
  80
  81 echo Element('page.html', $page);
  82
  83 ?>
  84 <!-- There is probably a much better way to do this, but eh. -->
  85 <link rel="stylesheet" type="text/css" href="stylesheets/style.css" />
  86