habboSSportal/latest-threads.php at master · Harryjeffs/habboSSportal · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
<?php
/**
 * Created by PhpStorm.
 * User: JEFFH14
 * Date: 29/01/2017
 * Time: 2:45 PM
 */
include_once('models/config.php');
$items = 13;
$page = 1;

$title = "Latest Threads";

if(isset($_GET['page']) and is_numeric($_GET['page']) and $page = $_GET['page'])
    $limit = " LIMIT ".(($page-1)*$items).",$items";
else
    $limit = " LIMIT $items";

$sqlStr = "SELECT * FROM `forum_thread` WHERE timestamp >= UNIX_TIMESTAMP(CURDATE()) and deleted = false ORDER BY `thread_id` desc";
$sqlStrAux = $mysqli->query("SELECT * FROM `forum_thread` WHERE timestamp >= UNIX_TIMESTAMP(CURDATE()) and deleted = false ORDER BY `thread_id` desc");

$query = $mysqli->query($sqlStr.$limit);

$p = new pagination;
$p->items($sqlStrAux->num_rows);
$p->limit($items);
$p->urlFriendly();
$p->changeClass();
$p->target("/forum/latest-posts/%/");//#page/1/
$p->currentPage($page);
$p->calculate();
?>

<!doctype html>
<!--suppress HtmlUnknownTarget, HtmlUnknownTarget, HtmlUnknownTarget, HtmlUnknownTarget, HtmlUnknownTarget, HtmlUnknownTarget, HtmlUnknownTarget, HtmlUnknownTarget, HtmlUnknownTarget, HtmlUnknownTarget, HtmlUnknownTarget, HtmlUnknownTarget, HtmlUnknownTarget, HtmlUnknownTarget, HtmlUnknownTarget -->
<html>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="A unique portal made for the Habbo Secret Service to create and View logs made at the Agency on a day to day basis. ">
<meta name="author" content="Harry Jeffs Habbo SS">
<meta name="keywords" content="Habbo SS Portal Logging Log In Greetings, Dashboard">
<link rel="icon" href="/favicon.ico">

<title>Habbo SS Forum - <?php echo $title; ?></title>

<!--  Bootstrap CSS -->
<link href="./assets/css/bootstrap.min.css" rel="stylesheet" type="text/css">

<!-- Icon CSS -->
<link rel="stylesheet" href="./assets/css/ion-icons.min.css">

<!-- Custom CSS -->
<link rel="stylesheet" type="text/css" href="./assets/css/pnotify.custom.min.css">

<!-- Random CSS -->
<link rel="stylesheet" href="/forum/wysibb/theme/default/wbbtheme.css" />
<link href='//fonts.googleapis.com/css?family=Lato:400,700' rel='stylesheet' type='text/css'>
<link rel="stylesheet" href="./assets/css/forum.css?v=67">
<body>
<?php include ("inc/top-banner.php");?>
<link rel="stylesheet" href="./assets/css/forum.css?v=183">
<div class="container" style="margin-top: 100px;">

    <div class="jumbotron">
        <h1>Latest Thread's</h1>
        <p>Today's latest thread activity</p>
    </div>
    <div class="row" style="margin-top: 20px">
        <div class="col-md-10">
            <ol class="breadcrumb">
                <li><a href="/forum">Forum Home</a></li>
                <li class="active">Latest Threads</li>
            </ol>
        </div>
    </div>
    <div class="panel panel-default">
        <div class="panel-heading">
            <a href="#" class="toggle-threads active"><i
                    class="ion-ios-paper"></i> <?php echo $sqlStrAux->num_rows; ?> Discussions</a>
        </div>
        <div class="panel-body">
            <ul class="threads-listing">
                <?php
                if($sqlStrAux->num_rows == 0){
                    echo'      <ul class="threads-listing">
        <p style="text-align: center; margin-top: 15px; margin-bottom: 15px; color: rgba(0, 0, 0, 0.4)">No threads have been posted today! Make sure you check back soon.</p></ul>';}
                ?>
                <?php while ($cat_fetched = $query->fetch_array()) {
                    $reply = $mysqli->query("SELECT reply_id FROM `forum_replys` WHERE thread_id = " . $cat_fetched['thread_id'] . "");
                    echo '<li class="threads-item">
                    <div class="row">
                        <div class="col-xs-10 threadInfo">
                            <div class="threadAvatar pull-left">
                                <div class="userAvatar-md" style="background-image: url(\'http://www.habbo.com/habbo-imaging/avatarimage?user=' . getForumUsername($cat_fetched['user_id']) . '&gesture=sml\');"></div>
                            </div>
                            <h4 class="titleThread">';
                    if ($cat_fetched['pinned'] == 1)
                        echo '<i class="ion-pin threadPinned" data-toggle="tooltip" data-trigger="hover" title="Pinned Thread"></i>';
                    if ($cat_fetched['locked'] == 1)
                        echo '<i class="ion-ios-locked threadPinned" data-toggle="tooltip" data-trigger="hover" title="Locked Thread"></i>';

                    echo '<a href="/forum/thread/'.$cat_fetched['thread_id'].'/" class="linkPrimary">' . $cat_fetched['topic_header'] . '</a></h4>
                            <p class="metaThread">Posted <span data-livestamp="' . $cat_fetched['timestamp'] . '"></span> by <a href="/user/stats/'.getForumUsername($cat_fetched['user_id']).'" class="linkSecondary">' . getForumUsername($cat_fetched['user_id']) . '</i></a></p>
                        </div>
                        <div class="col-xs-2">
                            <div class="pull-right replyCount">
                                <i class="ion-ios-chatboxes-outline replyCountIcon"></i> <span class="replyCountInt">' . $reply->num_rows . '</span>
                            </div>
                        </div>
                    </div>
                </li>';
                } ?>

            </ul>
        </div>
    </div>
</div>
    <center>
        <?php

        $p->show();
        ?>
        <br/>
    </center>
<?php include("models/footer.inc.php"); ?>
<script src="/forum/js/forum.js"></script>
</body>
</html>