/**
* @param string $status
* @return Zend_Db_Expr
* @throws \Exception
*/
public static function getFriendListQuery($status = "> 0")
{
return new Zend_Db_Expr(Cunity::get("db")->select()->from(Mysqli::getDbprefix() . "relations", new Zend_Db_Expr("(CASE WHEN sender = " . $_SESSION['user']->userid . " THEN receiver WHEN receiver = " . $_SESSION['user']->userid . " THEN sender END)"))->where("status" . $status)->where("sender=? OR receiver=?", $_SESSION['user']->userid));
}
/**
* @param string $status
* @return Zend_Db_Expr
* @throws \Exception
*/
public static function getEventsListQuery($status = "> 0")
{
return new Zend_Db_Expr(Cunity::get("db")->select()->from(Mysqli::getDbprefix() . "events_guests", "eventid")->where("status" . $status)->where("userid=?", $_SESSION['user']->userid));
}
