28 public function __construct(
$usr_id)
63 $res = $this->db->queryF(
65 SELECT usr_id, buddy_usr_id, ts, '" . self::TYPE_APPROVED .
"' rel_type FROM buddylist WHERE usr_id = %s 67 SELECT usr_id, buddy_usr_id, ts, IF(ignored = 1, '" . self::TYPE_IGNORED .
"', '" . self::TYPE_REQUESTED .
"') rel_type FROM buddylist_requests WHERE usr_id = %s OR buddy_usr_id = %s 69 array(
'integer',
'integer',
'integer'),
70 array($this->usr_id, $this->usr_id, $this->usr_id)
73 while(
$row = $this->db->fetchAssoc(
$res))
76 $relation->setUserId(
$row[
'usr_id']);
77 $relation->setBuddyUserId(
$row[
'buddy_usr_id']);
78 $relation->setTimestamp(
$row[
'ts']);
79 $relation->setIsOwnedByRequest($relation->getUserId() ==
$this->usr_id);
80 $key = $this->usr_id == $relation->getUserId() ? $relation->getBuddyUserId() : $relation->getUserId();
81 $relations[$key] = $relation;
93 if(self::TYPE_APPROVED ==
$row[
'rel_type'])
100 if(self::TYPE_IGNORED ==
$row[
'rel_type'])
119 "DELETE FROM buddylist WHERE usr_id = %s OR buddy_usr_id = %s",
120 array(
'integer',
'integer'),
121 array($this->usr_id, $this->usr_id)
125 "DELETE FROM buddylist_requests WHERE usr_id = %s OR buddy_usr_id = %s",
126 array(
'integer',
'integer'),
127 array($this->usr_id, $this->usr_id)
139 'usr_id' => array(
'integer', $relation->
getUserId()),
151 'buddy_usr_id' => array(
'integer', $relation->
getUserId())
164 $this->db->manipulateF(
165 "DELETE FROM buddylist WHERE usr_id = %s AND buddy_usr_id = %s",
166 array(
'integer',
'integer'),
170 $this->db->manipulateF(
171 "DELETE FROM buddylist WHERE buddy_usr_id = %s AND usr_id = %s",
172 array(
'integer',
'integer'),
184 'buddylist_requests',
186 'usr_id' => array(
'integer', $relation->
getUserId()),
191 'ignored' => array(
'integer', (
int)$ignored)
201 $this->db->manipulateF(
202 "DELETE FROM buddylist_requests WHERE usr_id = %s AND buddy_usr_id = %s",
203 array(
'integer',
'integer'),
207 $this->db->manipulateF(
208 "DELETE FROM buddylist_requests WHERE buddy_usr_id = %s AND usr_id = %s",
209 array(
'integer',
'integer'),
219 $this->db->beginTransaction();
Class ilBuddySystemIgnoredRequestRelationState.
getAll()
Reads all items from database.
getRelationByDatabaseRecord($row)
setDatabaseAdapter(ilDB $db)
removeFromRequestedBuddies(ilBuddySystemRelation $relation)
Class ilBuddySystemRelationRepository.
Class ilBuddySystemLinkedState.
save(ilBuddySystemRelation $relation)
Class ilBuddySystemRequestedRelationState.
removeFromApprovedBuddies(ilBuddySystemRelation $relation)
addToApprovedBuddies(ilBuddySystemRelation $relation)
Class ilBuddySystemRelation.
addToRequestedBuddies(ilBuddySystemRelation $relation, $ignored)