} echo container('Hooks', '<table class="page rowHover" border="1"> <thead> <tr class="hrow ui-widget-header"> <td>Hook</td> <td>Current Value</td> <td>Actions</td> </tr> </thead> <tbody> ' . $rows . ' </tbody> </table>'); break; case 'edit': $hookID = intval($_GET['hookId']); $hook = dbRows("SELECT * FROM {$sqlPrefix}hooks WHERE id = {$hookID}"); echo container("Edit Hook '{$hook['name']}'", "<form action=\"./moderate.php?do=hooks&do2=edit2&hookId={$hook['id']}\" method=\"post\">\n <label for=\"text\">New Value:</label><br />\n <textarea name=\"text\" id=\"textClike\" style=\"width: 100%; height: 300px;\">{$hook['code']}</textarea><br /><br />\n\n <button type=\"submit\">Update</button>\n</form>"); break; case 'edit2': $hookId = $_GET['hookId']; $text = $_POST['text']; $database->update(array('code' => $text), "{$sqlPrefix}phrases", array('hookId' => (int) $hookId)); $database->modLog('hookEdit', $hookID); echo container('Updated', 'The hook has been updated.<br /><br /><form action="moderate.php?do=hooks" method="POST"><button type="submit">Return</button></form>'); break; } } else { echo 'You do not have permission to modify hooks.'; } }
unlink('.tempStop'); echo container('', 'FIM has been re-enabled.'); } else { echo container('Error', 'FIM is already running.'); } break; case 'updatePostFormatCache': echo container('Error', 'Not yet coded.'); break; case 'updatePostCountCache': $limit = 20; $offset = intval($_GET['page']) * $limit; $nextpage = intval($_GET['page']) + 1; $records = dbRows("SELECT * FROM {$sqlPrefix}ping LIMIT {$limit} OFFSET {$offset}", 'id'); foreach ($records as $id => $record) { $totalPosts = dbRows("SELECT COUNT(m.id) AS count FROM {$sqlPrefix}messages AS m WHERE room = {$record['roomId']} AND user = {$record['userId']} AND m.deleted = false GROUP BY m.user"); $totalPosts = intval($totalPosts['count']); dbQuery("UPDATE {$sqlPrefix}ping SET messages = {$totalPosts} WHERE id = {$record['id']}"); } if ($records) { echo "<script type=\"text/javascript\">window.location = './moderate.php?do=maintenance&do2=postcountcache&page={$nextpage}';</script>"; } break; } } else { trigger_error('No permission.', E_USER_ERROR); } /* Update Data for Errors */ $xmlData['maintenance']['errStr'] = $errStr; $xmlData['maintenance']['errDesc'] = $errDesc; /* Output Data */