$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>