$order = 'likes';
} else {
if ($_GET["sort"] == 'downloaded') {
$order = 'downloads';
} else {
$order = 'cl_file.id';
}
}
}
//No query case
if ($where == 'WHERE ') {
$where = '';
}
//Remove first AND from where string
$where = preg_replace('/AND/', '', $where, 1);
$stmt = $db->prepare("\n\t\tSELECT SQL_CALC_FOUND_ROWS *\n\t\tFROM cl_file JOIN cl_user ON cl_file.author=cl_user.id\n\t\t" . $where . "\n\t\tORDER BY " . $order . " DESC\n\t\t" . page_sql_calc(16));
$stmt->execute($args);
$result = $stmt->fetchAll();
$num_rows = $db->query('SELECT FOUND_ROWS()')->fetchColumn();
} catch (PDOException $ex) {
errorbox('Something happened.');
}
?>
<br>
<div class="container">
<div class="row card hoverable">
<span class="col s12 card-title <?php
echo $theme;
?>
white-text center" style="font-size: 200%;">Filters</span>
successbox($_GET["user"] . " is now an administrator.");
}
}
}
}
}
//Get Member data
$append = 'id';
$append2 = '';
if (!empty($_GET["sort"]) && $_GET["sort"] == 'uploaded') {
$append = 'uploads';
}
if (!empty($_GET["username"])) {
$append2 = 'WHERE username = ?';
}
$stmt = $db->prepare("\n\t\tSELECT SQL_CALC_FOUND_ROWS *\n\t\tFROM cl_user\n\t\t" . $append2 . "\n\t\tORDER BY " . $append . " DESC\n\t\t" . page_sql_calc(25));
if (!empty($_GET["username"])) {
$stmt->execute(array($_GET["username"]));
} else {
$stmt->execute();
}
$result = $stmt->fetchAll();
$num_rows = $db->query('SELECT FOUND_ROWS()')->fetchColumn();
} catch (PDOException $ex) {
errorbox('Something happened.');
}
?>
<br>
<div class="container">
<div class="row card hoverable">
$stmt = $db->prepare("\r\n\t\t\t\tDELETE FROM cl_comment\r\n\t\t\t\tWHERE id = ?");
$stmt->execute(array($_GET["deletecomment"]));
} catch (PDOException $ex) {
errorbox('Something happened.');
include 'footer.php';
exit(0);
}
successbox('Comment deleted. Please wait.');
header("Location:comments.php");
include 'footer.php';
exit(0);
}
$comments = null;
$num_rows = 0;
try {
$stmt = $db->prepare("\r\n\t\tSELECT SQL_CALC_FOUND_ROWS *\r\n\t\tFROM cl_comment JOIN cl_user ON cl_comment.author=cl_user.id\r\n\t\tORDER BY cl_comment.id DESC\r\n\t\t" . page_sql_calc(10));
$stmt->execute();
$comments = $stmt->fetchAll();
$num_rows = $db->query('SELECT FOUND_ROWS()')->fetchColumn();
} catch (PDOException $ex) {
errorbox('Something happened.');
}
?>
<br>
<div class="container">
<div class="row card hoverable">
<span class="col s12 card-title <?php
echo $theme;
?>
white-text center" style="font-size: 200%;">All Comments</span>
