diff options
| -rw-r--r-- | dash/dash_employee.php | 2 | ||||
| -rw-r--r-- | dash/headless.php | 2 | ||||
| -rw-r--r-- | inc/config.php | 1 |
3 files changed, 3 insertions, 2 deletions
diff --git a/dash/dash_employee.php b/dash/dash_employee.php index b7cf12e..0c7e47c 100644 --- a/dash/dash_employee.php +++ b/dash/dash_employee.php @@ -4,7 +4,7 @@ $title = 'Dashboard / Bulletin'; require('header.php'); $page = 1; if (!empty($_GET['p'])) $page = max(1, intval($_GET['p'])); -$result = $db->query('SELECT ads.*, categories.cat_name, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM ads LEFT JOIN categories ON ads.cat = categories.id LEFT JOIN ratings ON ads.uid = ratings.rated GROUP BY ads.id LIMIT ' . 10*($page-1) . ', 10') or fatal($db->error); +$result = $db->query('SELECT ads.*, categories.cat_name, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM ads LEFT JOIN categories ON ads.cat = categories.id LEFT JOIN ratings ON ads.uid = ratings.rated GROUP BY ads.id LIMIT ' . $b_config['ads_per_page']*($page-1) . ', '.$b_config['ads_per_page']) or fatal($db->error); while ($row = $result->fetch_assoc()) { ?> <div class="job"> diff --git a/dash/headless.php b/dash/headless.php index f3ba5df..bc321f2 100644 --- a/dash/headless.php +++ b/dash/headless.php @@ -3,7 +3,7 @@ $clicks = 0; if (!empty($_GET['clicks'])) $clicks = max(0, intval($_GET['clicks'])); require('dash_common.php'); $db = new bdb(); -$result = $db->query('SELECT ads.*, categories.cat_name, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM ads LEFT JOIN categories ON ads.cat = categories.id LEFT JOIN ratings ON ads.uid = ratings.rated GROUP BY ads.id LIMIT '.($clicks+10).', 1') or die(); +$result = $db->query('SELECT ads.*, categories.cat_name, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM ads LEFT JOIN categories ON ads.cat = categories.id LEFT JOIN ratings ON ads.uid = ratings.rated GROUP BY ads.id LIMIT '.($clicks+$b_config['ads_per_page']).', 1') or die(); if ($result->num_rows) { $row = $result->fetch_assoc(); ?> diff --git a/inc/config.php b/inc/config.php index 93050e7..76783c3 100644 --- a/inc/config.php +++ b/inc/config.php @@ -14,5 +14,6 @@ $b_config = array( 'mail_from' => 'Bulletin <noreply@bulletinalpha.tk>', 'mobile_base' => 'https://m.bulletinalpha.tk/', 'moblie_host' => 'm.bulletinalpha.tk', + 'ads_per_page' => 10, ); ?> |