diff options
| author | cflem <carson.fl3ming@gmail.com> | 2016-12-29 15:17:31 -0700 |
|---|---|---|
| committer | cflem <carson.fl3ming@gmail.com> | 2016-12-29 15:17:31 -0700 |
| commit | addf249c06d0f0957e93efd8738b72ef4cd9849c (patch) | |
| tree | b41c796b314b47c16d9750ee3c578d1a2bae1990 /dash/headless.php | |
| parent | 33fcf9fb658f77978514f9dbca463d68ceee3dba (diff) | |
| download | bulletin-addf249c06d0f0957e93efd8738b72ef4cd9849c.tar.gz | |
Made ads per page configurable
Diffstat (limited to 'dash/headless.php')
| -rw-r--r-- | dash/headless.php | 2 |
1 files changed, 1 insertions, 1 deletions
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(); ?> |