public static function list_owner_or_admin(\Snabb\Database\Connection $db, $user_id, $list_id)
{
if ($db->query('SELECT list_id FROM lists WHERE user_id = ' . (int) $user_id . ' AND list_id = ' . (int) $list_id)->fetch() !== false) {
return true;
}
if ($db->query('SELECT list_id FROM list_users WHERE user_id =' . (int) $user_id . ' AND list_id = ' . (int) $list_id . ' AND list_admin_from IS NOT NULL')->fetch() !== false) {
return true;
}
return false;
}
public static function getData(\Snabb\Database\Connection $db, $key)
{
$data = $db->query('SELECT event_value FROM events WHERE event_key = ' . $db->quote($key))->fetch();
return ($data !== false and $data['event_value'] !== null) ? $data['event_value'] : false;
}