Файл: sngine-v2.8/Updates/Update 2.5.8 to 2.5.9/Update_2.5.9/includes/ajax/admin/delete.php
Строк: 157
<?php
/**
* ajax -> admin -> delete
*
* @package Sngine
* @author Zamblek
*/
// fetch bootstrap
require('../../../bootstrap.php');
// check AJAX Request
is_ajax();
// check admin logged in
if(!$user->_logged_in || !$user->_is_admin) {
modal(MESSAGE, __("System Message"), __("You don't have the right permission to access this"));
}
// valid inputs
if(!isset($_POST['id']) || !is_numeric($_POST['id'])) {
_error(400);
}
// delete
try {
switch ($_POST['handle']) {
case 'invitation_code':
$db->query(sprintf("DELETE FROM invitation_codes WHERE code_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'theme':
$db->query(sprintf("DELETE FROM system_themes WHERE theme_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'language':
$db->query(sprintf("DELETE FROM system_languages WHERE language_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'user':
$user->delete_user($_POST['id']);
if(isset($_POST['node']) && is_numeric($_POST['node'])) {
/* delete report */
$db->query(sprintf("DELETE FROM reports WHERE report_id = %s", secure($_POST['node'], 'int') )) or _error(SQL_ERROR_THROWEN);
}
break;
case 'user_posts':
$user->delete_posts($_POST['id']);
break;
case 'session':
$db->query(sprintf("DELETE FROM users_sessions WHERE session_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'user_package':
$db->query(sprintf("UPDATE users SET user_subscribed = '0', user_package = null, user_subscription_date = null, user_boosted_posts = '0', user_boosted_pages = '0' WHERE user_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'page':
$user->delete_page($_POST['id']);
if(isset($_POST['node']) && is_numeric($_POST['node'])) {
/* delete report */
$db->query(sprintf("DELETE FROM reports WHERE report_id = %s", secure($_POST['node'], 'int') )) or _error(SQL_ERROR_THROWEN);
}
break;
case 'page_posts':
$user->delete_posts($_POST['id'], 'page');
break;
case 'page_category':
$db->query(sprintf("DELETE FROM pages_categories WHERE category_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'group':
$user->delete_group($_POST['id']);
if(isset($_POST['node']) && is_numeric($_POST['node'])) {
/* delete report */
$db->query(sprintf("DELETE FROM reports WHERE report_id = %s", secure($_POST['node'], 'int') )) or _error(SQL_ERROR_THROWEN);
}
break;
case 'group_posts':
$user->delete_posts($_POST['id'], 'group');
break;
case 'group_category':
$db->query(sprintf("DELETE FROM groups_categories WHERE category_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'event':
$user->delete_event($_POST['id']);
if(isset($_POST['node']) && is_numeric($_POST['node'])) {
/* delete report */
$db->query(sprintf("DELETE FROM reports WHERE report_id = %s", secure($_POST['node'], 'int') )) or _error(SQL_ERROR_THROWEN);
}
break;
case 'event_posts':
$user->delete_posts($_POST['id'], 'event');
break;
case 'event_category':
$db->query(sprintf("DELETE FROM events_categories WHERE category_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'blogs_category':
$db->query(sprintf("DELETE FROM blogs_categories WHERE category_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'market_category':
$db->query(sprintf("DELETE FROM market_categories WHERE category_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'forum':
$user->delete_forum($_POST['id']);
if(isset($_POST['node']) && is_numeric($_POST['node'])) {
/* delete report */
$db->query(sprintf("DELETE FROM reports WHERE report_id = %s", secure($_POST['node'], 'int') )) or _error(SQL_ERROR_THROWEN);
}
break;
case 'forum_thread':
$user->delete_forum_thread($_POST['id']);
if(isset($_POST['node']) && is_numeric($_POST['node'])) {
/* delete report */
$db->query(sprintf("DELETE FROM reports WHERE report_id = %s", secure($_POST['node'], 'int') )) or _error(SQL_ERROR_THROWEN);
}
break;
case 'forum_reply':
$user->delete_forum_reply($_POST['id']);
if(isset($_POST['node']) && is_numeric($_POST['node'])) {
/* delete report */
$db->query(sprintf("DELETE FROM reports WHERE report_id = %s", secure($_POST['node'], 'int') )) or _error(SQL_ERROR_THROWEN);
}
break;
case 'movie':
$db->query(sprintf("DELETE FROM movies WHERE movie_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'movie_genre':
$db->query(sprintf("DELETE FROM movies_genres WHERE genre_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'game':
$db->query(sprintf("DELETE FROM games WHERE game_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'ads_system':
$db->query(sprintf("DELETE FROM ads_system WHERE ads_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'package':
$db->query(sprintf("DELETE FROM packages WHERE package_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'report':
$db->query(sprintf("DELETE FROM reports WHERE report_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'post':
$user->delete_post($_POST['id']);
if(isset($_POST['node']) && is_numeric($_POST['node'])) {
/* delete report */
$db->query(sprintf("DELETE FROM reports WHERE report_id = %s", secure($_POST['node'], 'int') )) or _error(SQL_ERROR_THROWEN);
}
break;
case 'comment':
$user->delete_comment($_POST['id']);
if(isset($_POST['node']) && is_numeric($_POST['node'])) {
/* delete report */
$db->query(sprintf("DELETE FROM reports WHERE report_id = %s", secure($_POST['node'], 'int') )) or _error(SQL_ERROR_THROWEN);
}
break;
case 'ip':
$db->query(sprintf("DELETE FROM banned_ips WHERE ip_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'custom_field':
$db->query(sprintf("DELETE FROM custom_fields WHERE field_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
$db->query(sprintf("DELETE FROM custom_fields_values WHERE field_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'static_page':
$db->query(sprintf("DELETE FROM static_pages WHERE page_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'widget':
$db->query(sprintf("DELETE FROM widgets WHERE widget_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'emoji':
$db->query(sprintf("DELETE FROM emojis WHERE emoji_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'sticker':
$db->query(sprintf("DELETE FROM stickers WHERE sticker_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
case 'announcement':
$db->query(sprintf("DELETE FROM announcements WHERE announcement_id = %s", secure($_POST['id'], 'int') )) or _error(SQL_ERROR_THROWEN);
break;
default:
_error(400);
break;
}
// return
return_json();
} catch (Exception $e) {
modal(ERROR, __("Error"), $e->getMessage());
}
?>