diff options
| author | Carson Fleming <cflems@cflems.net> | 2017-04-09 18:55:38 -0400 |
|---|---|---|
| committer | Carson Fleming <cflems@cflems.net> | 2017-04-09 18:55:38 -0400 |
| commit | 37ef17fd2904e49d966ed0922871f675ceb384c0 (patch) | |
| tree | ee585ad1ec45ed93c9a2122c18ebf82698ea8eae /dash/headless.php | |
| parent | 59d9ab47a3c2a30f4130efdb38466edcfd1fb3a8 (diff) | |
| download | bulletin-37ef17fd2904e49d966ed0922871f675ceb384c0.tar.gz | |
Rearrange ratings tab
Diffstat (limited to 'dash/headless.php')
| -rw-r--r-- | dash/headless.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/dash/headless.php b/dash/headless.php index 0312f5d..ac20748 100644 --- a/dash/headless.php +++ b/dash/headless.php @@ -33,10 +33,11 @@ if (isset($_GET['clicks'])) { $uid = intval($_GET['rate']); $jid = intval($_GET['jid']); $val = intval($_GET['val']); + $txt = $db->escape_string($_GET['txt']); if ($uid < 1 || $jid < 1 || $val < 1) die('NOK'); $result = $db->query('SELECT ads.id FROM ads INNER JOIN responses ON responses.adid = ads.id AND responses.matched = 1 INNER JOIN users ON users.id = responses.uid LEFT JOIN ratings ON ratings.rated = users.id WHERE ads.id = '.$jid.' AND (ads.uid = '.$b_user['id'].' OR responses.uid = '.$b_user['id'].') AND NOT EXISTS (SELECT ratings.id FROM ratings WHERE ratings.rated = responses.uid AND ratings.job = ads.id AND ratings.rater = '.$b_user['id'].') GROUP BY responses.id LIMIT 1') or die('ERR'); if ($result->num_rows < 1) die('NOK'); - $db->query('INSERT INTO ratings (rated, rater, job, stars) VALUES ('.$uid.', '.$b_user['id'].', '.$jid.', '.$val.')') or die('ERR'); + $db->query('INSERT INTO ratings (rated, rater, job, stars, comment) VALUES ('.$uid.', '.$b_user['id'].', '.$jid.', '.$val.', \''.$txt.'\')') or die('ERR'); if ($db->affected_rows < 1) die('NOK'); die('OK'); } |