setupAutoloader($fileDir . '/library');
XenForo_Application::initialize($fileDir . '/library', $fileDir);
XenForo_Application::set('page_start_time', $startTime);
require('./library/config.php');
$con = mysqli_connect($config['db']['host'], $config['db']['username'], $config['db']['password'], $config['db']['dbname']);
if(mysqli_connect_errno()) {
echo "Failed to connect to MySQL: ".mysql_connect_error();
die();
}
echo $fileDir."
";
$query = "SELECT notice_id,display_order FROM xf_notice";
$result = mysqli_query($con, $query);
$noticeIds;
$i = 0;
while($row = mysqli_fetch_array($result)) {
if($row['display_order'] == 0) continue;
$noticeIds[$i] = $row['notice_id'];
echo "Row is: ".$row['notice_id']."
";
$i++;
}
shuffle($noticeIds);
for($i=0; $i < count($noticeIds); $i++) {
echo "Notice id is: ".$noticeIds[$i]." and display order is: ".($i+1)."
";
$query = "UPDATE xf_notice SET display_order = ".($i+1)." WHERE notice_id = ".$noticeIds[$i];
mysqli_query($con, $query);
}
$noticeModel = Xenforo_Model::create("XenForo_Model_Notice");
$noticeModel->rebuildNoticeCache();