Uncategorized'.PHP_EOL;
else
echo '
'.htmlentities($row['cat_name']).'
'.PHP_EOL;
?>
Employer Not Rated'.PHP_EOL;
else
echo '
'.$row['rating'].' Star Employer
'.PHP_EOL;
?>
Pays $
[...]
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();
$options = array(
'rid' => $appinfo['id'],
'adname' => $appinfo['title'],
'seekername' => $appinfo['name'],
'seekerrating' => is_null($uinfo['rating']) ? 'has yet to be rated' : 'is rated '.number_format($uinfo['rating'], 1).' stars',
'seekereml' => $uinfo['email'],
'seekerid' => $appinfo['seeker'],
);
bulletin_mail($appinfo['email'], '"'.$appinfo['title'].'" Has Received a Response', tpl($options, 'app_eml.tpl'));
}
?>