diff options
| author | Carson Fleming <cflems@cflems.net> | 2017-02-28 16:21:33 -0500 |
|---|---|---|
| committer | Carson Fleming <cflems@cflems.net> | 2017-02-28 16:21:33 -0500 |
| commit | 3bfe03a6f6136947eb8b9c714306d080ce889af7 (patch) | |
| tree | 6a7388d234a37d2dd831f3c81cc34dbb49463825 /dash/dash_functions.php | |
| parent | 117d7a7ce83dbcf749c88201cd46a3e10efc899b (diff) | |
| download | bulletin-3bfe03a6f6136947eb8b9c714306d080ce889af7.tar.gz | |
Omitted uimg uploads from the git repo
Diffstat (limited to 'dash/dash_functions.php')
| -rw-r--r-- | dash/dash_functions.php | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/dash/dash_functions.php b/dash/dash_functions.php index 334d253..2d01973 100644 --- a/dash/dash_functions.php +++ b/dash/dash_functions.php @@ -59,10 +59,12 @@ function draw_ad ($row) { function app_trigger ($responseid) { global $db; - $result = $db->query('SELECT responses.id, responses.uid AS seeker, responses.adid, responses.comment, ads.title, users.name, users.email FROM responses INNER JOIN ads ON responses.adid = ads.id INNER JOIN users ON ads.uid = users.id WHERE responses.id = '.$responseid.' LIMIT 1') or dash_fatal($db->error); + $result = $db->query('SELECT responses.id, responses.uid AS seeker, responses.adid, responses.comment, ads.title, users.name, users.email, users.notify FROM responses INNER JOIN ads ON responses.adid = ads.id INNER JOIN users ON ads.uid = users.id WHERE responses.id = '.$responseid.' LIMIT 1') or dash_fatal($db->error); if ($result->num_rows < 1) dash_fatal('The ad you\'ve tried to apply to no longer exists.'); $appinfo = $result->fetch_assoc(); $result->free(); + if (!$appinfo['notify']) return; + $result = $db->query('SELECT users.name, users.email, SUM(ratings.stars) / COUNT(ratings.stars) AS rating FROM users LEFT JOIN ratings ON ratings.rated = users.id') or dash_fatal($db->error); $uinfo = $result->fetch_assoc(); $result->free(); |
