user_name,
user_pass,
user_mail,
user_uri,
type,
date,
mod,
user_ip,
refer_id,
trash default 0
)');
//=============================================
// UNINSTALL SQLs
//=============================================
$uninstallQueries = array('DROP TABLE ' . LOG_TABLE, 'DROP TABLE ' . LOG_TAG_TABLE, 'DROP TABLE ' . LOG_TAG_MAP_TABLE, 'DROP TABLE ' . DOWNLOADS_META_TABLE, 'DROP TABLE ' . DOWNLOADS_DATA_TABLE, 'DROP TABLE ' . DOWNLOADS_TAG_TABLE, 'DROP TABLE ' . DOWNLOADS_TAG_MAP_TABLE, 'DROP TABLE ' . SESSION_TABLE, 'DROP TABLE ' . ACCESSLOG_TABLE, 'DROP TABLE ' . TRACKBACK_TABLE, 'DROP TABLE ' . COMMENT_TABLE);
$app->insertSafe();
if ($sessionState == 'on') {
// DELETE ENTRY
if (!empty($_GET['id'])) {
$id = intval($_GET['id']);
// Delete entry
$app->plugin->doAction('pre-delete-entry', $id);
$deleteEntrySql = 'DELETE FROM ' . LOG_TABLE . ' ' . 'WHERE ' . "(draft = '1') AND (id = '" . $id . "')";
$deleteEntryRes = $app->db->query($deleteEntrySql);
// Delete the entry's tag map
$deleteTagMapSql = 'DELETE FROM ' . LOG_TAG_MAP_TABLE . ' ' . 'WHERE ' . "log_id = '" . $id . "'";
$deleteTagMapRes = $app->db->query($deleteTagMapSql);
$app->plugin->doAction('after-entry-deleted', $id);
// Delete the entry's comments
$deleteCommentsSql = 'DELETE FROM ' . COMMENT_TABLE . ' ' . 'WHERE ' . "refer_id = '" . $id . "'";
$deleteCommentsRes = $app->db->query($deleteCommentsSql);
