} $query .= "PRIMARY KEY (" . $compound_key . "), "; } $query = substr($query, 0, sizeof($query) - 3); $query .= ")"; $result = $db->query($query); if ($result === false) { $error = true; } $completed = $lang['tbl'] . " '" . htmlencode($_POST['tablename']) . "' " . $lang['created'] . ".<br/><span style='font-size:11px;'>" . htmlencode($query) . "</span>"; $backlinkParameters = "&action=column_view&table=" . urlencode($name); break; //- Empty table (=table_empty) //- Empty table (=table_empty) case "table_empty": $query = "DELETE FROM " . $db->quote_id($_POST['tablename']); $result = $db->query($query); if ($result === false) { $error = true; } $query = "VACUUM"; $result = $db->query($query); if ($result === false) { $error = true; } $completed = $lang['tbl'] . " '" . htmlencode($_POST['tablename']) . "' " . $lang['emptied'] . ".<br/><span style='font-size:11px;'>" . htmlencode($query) . "</span>"; $backlinkParameters = "&action=row_view&table=" . urlencode($name); break; //- Create view (=view_create) //- Create view (=view_create) case "view_create":
$compound_key .= ($compound_key == "" ? "" : ", ") . $db->quote($primary_key); } $query .= "PRIMARY KEY (" . $compound_key . "), "; } $query = substr($query, 0, sizeof($query) - 3); $query .= ")"; $result = $db->query($query); if (!$result) { $error = true; } $completed = $lang['tbl'] . " '" . htmlencode($_POST['tablename']) . "' " . $lang['created'] . ".<br/><span style='font-size:11px;'>" . htmlencode($query) . "</span>"; break; /////////////////////////////////////////////// empty table /////////////////////////////////////////////// empty table case "table_empty": $query = "DELETE FROM " . $db->quote_id($_POST['tablename']); $result = $db->query($query); if (!$result) { $error = true; } $query = "VACUUM"; $result = $db->query($query); if (!$result) { $error = true; } $completed = $lang['tbl'] . " '" . htmlencode($_POST['tablename']) . "' " . $lang['emptied'] . ".<br/><span style='font-size:11px;'>" . htmlencode($query) . "</span>"; break; /////////////////////////////////////////////// create view /////////////////////////////////////////////// create view case "view_create": $query = "CREATE VIEW " . $db->quote($_POST['viewname']) . " AS " . $_POST['select'];