function Insert($parentid, $name, $tripcode, $email, $subject, $message, $filename, $file_original, $filetype, $file_md5, $image_w, $image_h, $filesize, $thumb_w, $thumb_h, $password, $timestamp, $bumped, $ip, $posterauthority, $tag, $stickied, $locked, $boardid)
{
global $tc_db;
$query = "INSERT INTO `" . KU_DBPREFIX . "posts` ( `parentid` , `boardid`, `name` , `tripcode` , `email` , `subject` , `message` , `file` , `file_original`, `file_type` , `file_md5` , `image_w` , `image_h` , `file_size` , `file_size_formatted` , `thumb_w` , `thumb_h` , `password` , `timestamp` , `bumped` , `ip` , `ipmd5` , `posterauthority` , `tag` , `stickied` , `locked` ) VALUES ( " . $tc_db->qstr($parentid) . ", " . $tc_db->qstr($boardid) . ", " . $tc_db->qstr($name) . ", " . $tc_db->qstr($tripcode) . ", " . $tc_db->qstr($email) . ", " . $tc_db->qstr($subject) . ", " . $tc_db->qstr($message) . ", " . $tc_db->qstr($filename) . ", " . $tc_db->qstr($file_original) . ", " . $tc_db->qstr($filetype) . ", " . $tc_db->qstr($file_md5) . ", " . $tc_db->qstr(intval($image_w)) . ", " . $tc_db->qstr(intval($image_h)) . ", " . $tc_db->qstr($filesize) . ", " . $tc_db->qstr(ConvertBytes($filesize)) . ", " . $tc_db->qstr($thumb_w) . ", " . $tc_db->qstr($thumb_h) . ", " . $tc_db->qstr($password) . ", " . $tc_db->qstr($timestamp) . ", " . $tc_db->qstr($bumped) . ", " . $tc_db->qstr(md5_encrypt($ip, KU_RANDOMSEED)) . ", '" . md5($ip) . "', " . $tc_db->qstr($posterauthority) . ", " . $tc_db->qstr($tag) . ", " . $tc_db->qstr($stickied) . ", " . $tc_db->qstr($locked) . " )";
$tc_db->Execute($query);
$id = $tc_db->Insert_Id();
if (!$id || KU_DBTYPE == 'sqlite') {
// Non-mysql installs don't return the insert ID after insertion, we need to manually get it.
$id = $tc_db->GetOne("SELECT `id` FROM `" . KU_DBPREFIX . "posts` WHERE `boardid` = " . $tc_db->qstr($boardid) . " AND timestamp = " . $tc_db->qstr($timestamp) . " AND `ipmd5` = '" . md5($ip) . "' LIMIT 1");
}
if ($id == 1 && $this->board['start'] > 1) {
$tc_db->Execute("UPDATE `" . KU_DBPREFIX . "posts` SET `id` = '" . $this->board['start'] . "' WHERE `boardid` = " . $boardid);
return $this->board['start'];
}
return $id;
}
function spaceused()
{
global $tc_db, $tpl_page;
$this->AdministratorsOnly();
$tpl_page .= '<h2>' . _gettext('Disk space used') . '</h2><br />';
$spaceused_res = 0;
$spaceused_src = 0;
$spaceused_thumb = 0;
$spaceused_total = 0;
$files_res = 0;
$files_src = 0;
$files_thumb = 0;
$files_total = 0;
$tpl_page .= '<table border="1" width="100%"><tr><th>' . _gettext('Board') . '</th><th>' . _gettext('Area') . '</th><th>' . _gettext('Files') . '</th><th>' . _gettext('Space Used') . '</th></tr>';
$results = $tc_db->GetAll("SELECT HIGH_PRIORITY `name` FROM `" . KU_DBPREFIX . "boards` ORDER BY `name` ASC");
foreach ($results as $line) {
list($spaceused_board_res, $files_board_res) = recursive_directory_size(KU_BOARDSDIR . $line['name'] . '/res');
list($spaceused_board_src, $files_board_src) = recursive_directory_size(KU_BOARDSDIR . $line['name'] . '/src');
list($spaceused_board_thumb, $files_board_thumb) = recursive_directory_size(KU_BOARDSDIR . $line['name'] . '/thumb');
$spaceused_board_total = $spaceused_board_res + $spaceused_board_src + $spaceused_board_thumb;
$files_board_total = $files_board_res + $files_board_src + $files_board_thumb;
$spaceused_res += $spaceused_board_res;
$files_res += $files_board_res;
$spaceused_src += $spaceused_board_src;
$files_src += $files_board_src;
$spaceused_thumb += $spaceused_board_thumb;
$files_thumb += $files_board_thumb;
$spaceused_total += $spaceused_board_total;
$files_total += $files_board_total;
$tpl_page .= '<tr><td rowspan="4">/' . $line['name'] . '/</td><td>res/</td><td>' . number_format($files_board_res) . '</td><td>' . ConvertBytes($spaceused_board_res) . '</td></tr>';
$tpl_page .= '<tr><td>src/</td><td>' . number_format($files_board_src) . '</td><td>' . ConvertBytes($spaceused_board_src) . '</td></tr>';
$tpl_page .= '<tr><td>thumb/</td><td>' . number_format($files_board_thumb) . '</td><td>' . ConvertBytes($spaceused_board_thumb) . '</td></tr>';
$tpl_page .= '<tr><td><strong>' . _gettext('Total') . '</strong></td><td>' . number_format($files_board_total) . '</td><td>' . ConvertBytes($spaceused_board_total) . '</td></tr>';
}
$tpl_page .= '<tr><td rowspan="4"><strong>' . _gettext('All boards') . '</strong></td><td>res/</td><td>' . number_format($files_res) . '</td><td>' . ConvertBytes($spaceused_res) . '</td></tr>';
$tpl_page .= '<tr><td>src/</td><td>' . number_format($files_src) . '</td><td>' . ConvertBytes($spaceused_src) . '</td></tr>';
$tpl_page .= '<tr><td>thumb/</td><td>' . number_format($files_thumb) . '</td><td>' . ConvertBytes($spaceused_thumb) . '</td></tr>';
$tpl_page .= '<tr><td><strong>' . _gettext('Total') . '</strong></td><td>' . number_format($files_total) . '</td><td>' . ConvertBytes($spaceused_total) . '</td></tr>';
$tpl_page .= '</table>';
management_addlogentry(_gettext('Viewed disk space used'), 0);
}
