/* Decoded by unphp.net */
?>query( "DELETE FROM " . PREFIX . "_complaint WHERE id = '{$id}'" );
$db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '22', '')" );
header( "Location: ?mod=complaint" ); die();
}
if ($_POST['action'] == "mass_delete") {
if( !isset($_REQUEST['user_hash']) OR !$_REQUEST['user_hash'] OR $_REQUEST['user_hash'] != $dle_login_hash ) {
die( "Hacking attempt! User not found" );
}
$selected_complaint = $_POST['selected_complaint'];
if( ! $selected_complaint ) {
msg( "error", $lang['mass_error'], $lang['opt_complaint_6'], "?mod=complaint" );
}
foreach ( $selected_complaint as $complaint ) {
$complaint = intval($complaint);
$db->query( "DELETE FROM " . PREFIX . "_complaint WHERE id = '{$complaint}'" );
}
$db->query( "INSERT INTO " . USERPREFIX . "_admin_logs (name, date, ip, action, extras) values ('".$db->safesql($member_id['name'])."', '{$_TIME}', '{$_IP}', '22', '')" );
header( "Location: ?mod=complaint" ); die();
}
$found = false;
if( !$langformatdatefull ) $langformatdatefull = "d.m.Y H:i";
echoheader("{$lang['opt_complaint']}", $lang['header_compl_1']);
echo <<
HTML;
$row = $db->super_query( "SELECT COUNT(*) as count FROM " . PREFIX . "_complaint WHERE p_id > '0'" );
if($row['count']) {
echo <<
{$lang['opt_complaint_1']}
HTML;
}
$row = $db->super_query( "SELECT COUNT(*) as count FROM " . PREFIX . "_complaint WHERE c_id > '0'" );
if($row['count']) {
echo <<
{$lang['opt_complaint_15']}
| {$lang['opt_complaint_3']} |
{$lang['opt_complaint_2']} |
{$lang['user_action']} |
|
HTML;
$db->query("SELECT " . PREFIX . "_complaint.id, `c_id`, " . PREFIX . "_complaint.text, `from`, `to`, " . PREFIX . "_complaint.date, " . PREFIX . "_complaint.email, " . PREFIX . "_comments.autor, is_register, post_id, " . PREFIX . "_comments.text as c_text, " . PREFIX . "_post.title, " . PREFIX . "_post.date as newsdate, " . PREFIX . "_post.alt_name, " . PREFIX . "_post.category FROM " . PREFIX . "_complaint LEFT JOIN " . PREFIX . "_comments ON " . PREFIX . "_complaint.c_id=" . PREFIX . "_comments.id LEFT JOIN " . PREFIX . "_post ON " . PREFIX . "_comments.post_id=" . PREFIX . "_post.id WHERE c_id > '0' ORDER BY id DESC");
$entries = "";
while($row = $db->get_row()) {
$found = true;
$row['text'] = stripslashes($row['text']);
if ( $row['date'] ) $date = date( $langformatdatefull, $row['date'] )."
"; else $date = "";
if ($row['c_text']) {
$row['c_text'] = "" . stripslashes( $row['c_text'] ) . "
";
$edit_link = "
{$lang['opt_complaint_12']}";
$del_c_link = "
{$lang['opt_complaint_13']}";
} else {
$row['c_text'] = "" .$lang['opt_complaint_10']. "
";
$edit_link = "";
$del_c_link = "";
}
if ( filter_var( $row['from'], FILTER_VALIDATE_IP, FILTER_FLAG_IPV4) OR filter_var( $row['from'], FILTER_VALIDATE_IP, FILTER_FLAG_IPV6) ) {
$from = "IP: ".$row['from'];
if( $row['email'] AND filter_var($row['email'], FILTER_VALIDATE_EMAIL) ) {
$email = htmlspecialchars(filter_var($row['email'], FILTER_SANITIZE_EMAIL), ENT_QUOTES, $config['charset']);
$from .= "
{$lang['send_pm']}";
}
} else $from = "{$row['from']}
{$lang['send_pm']}";
if($row['is_register'])
$to = "{$row['autor']}, {$lang['send_pm']}";
else $to = $row['autor'];
$row['category'] = intval( $row['category'] );
if( $config['allow_alt_url'] ) {
if( $config['seo_type'] == 1 OR $config['seo_type'] == 2 ) {
if( $row['category'] and $config['seo_type'] == 2 ) {
$full_link = $config['http_home_url'] . get_url( $row['category'] ) . "/" . $row['post_id'] . "-" . $row['alt_name'] . ".html";
} else {
$full_link = $config['http_home_url'] . $row['post_id'] . "-" . $row['alt_name'] . ".html";
}
} else {
$full_link = $config['http_home_url'] . date( 'Y/m/d/', strtotime ($row['newsdate']) ) . $row['alt_name'] . ".html";
}
} else {
$full_link = $config['http_home_url'] . "index.php?newsid=" . $row['post_id'];
}
$full_link = "" . stripslashes( $row['title'] ) . "";
$entries .= "
| {$date}{$from} |
{$lang['opt_complaint_7']} {$full_link}
{$lang['opt_complaint_8']} {$to}
{$lang['opt_complaint_9']}
{$row['c_text']}{$lang['opt_complaint_2']}
{$row['text']}
|
{$lang['opt_complaint_11']}{$edit_link}{$del_c_link} |
|
";
}
echo <<
HTML;
}
$row = $db->super_query( "SELECT COUNT(*) as count FROM " . PREFIX . "_complaint WHERE n_id > '0'" );
if($row['count']) {
echo <<
{$lang['opt_complaint_16']}
| {$lang['opt_complaint_3']} |
{$lang['opt_complaint_2']} |
{$lang['user_action']} |
|
HTML;
$db->query("SELECT " . PREFIX . "_complaint.id, `n_id`, " . PREFIX . "_complaint.text, `from`, `to`, " . PREFIX . "_complaint.date, " . PREFIX . "_complaint.email, " . PREFIX . "_post.id as post_id, " . PREFIX . "_post.title, " . PREFIX . "_post.date as newsdate, " . PREFIX . "_post.alt_name, " . PREFIX . "_post.category FROM " . PREFIX . "_complaint LEFT JOIN " . PREFIX . "_post ON " . PREFIX . "_complaint.n_id=" . PREFIX . "_post.id WHERE n_id > '0' ORDER BY id DESC");
$entries = "";
while($row = $db->get_row()) {
$found = true;
$row['text'] = stripslashes($row['text']);
if ( $row['date'] ) $date = date( $langformatdatefull, $row['date'] )."
"; else $date = "";
if ($row['post_id']) {
$edit_link = "
{$lang['opt_complaint_18']}";
} else {
$edit_link = "";
}
if ( filter_var( $row['from'], FILTER_VALIDATE_IP, FILTER_FLAG_IPV4) OR filter_var( $row['from'], FILTER_VALIDATE_IP, FILTER_FLAG_IPV6) ) {
$from = "IP: ".$row['from'];
if( $row['email'] AND filter_var($row['email'], FILTER_VALIDATE_EMAIL) ) {
$email = htmlspecialchars(filter_var($row['email'], FILTER_SANITIZE_EMAIL), ENT_QUOTES, $config['charset']);
$from .= "
{$lang['send_pm']}";
}
} else $from = "{$row['from']}
{$lang['send_pm']}";
$row['category'] = intval( $row['category'] );
if( $config['allow_alt_url'] ) {
if( $config['seo_type'] == 1 OR $config['seo_type'] == 2 ) {
if( $row['category'] and $config['seo_type'] == 2 ) {
$full_link = $config['http_home_url'] . get_url( $row['category'] ) . "/" . $row['post_id'] . "-" . $row['alt_name'] . ".html";
} else {
$full_link = $config['http_home_url'] . $row['post_id'] . "-" . $row['alt_name'] . ".html";
}
} else {
$full_link = $config['http_home_url'] . date( 'Y/m/d/', strtotime ($row['newsdate']) ) . $row['alt_name'] . ".html";
}
} else {
$full_link = $config['http_home_url'] . "index.php?newsid=" . $row['post_id'];
}
$full_link = "" . stripslashes( $row['title'] ) . "";
$entries .= "
| {$date}{$from} |
{$lang['opt_complaint_17']} {$full_link}
{$lang['opt_complaint_2']}
{$row['text']}
|
{$lang['opt_complaint_11']}{$edit_link} |
|
";
}
echo <<
HTML;
}
$row = $db->super_query( "SELECT COUNT(*) as count FROM " . PREFIX . "_complaint WHERE p_id = '0' AND c_id = '0' AND n_id = '0'" );
if($row['count']) {
echo <<
{$lang['opt_complaint_21']}
HTML;
}
if (!$found) {
echo <<
{$lang['opt_complaint']}
| {$lang['opt_complaint_19']} |
HTML;
}
echofooter();
?>