function Alert($POD, $PARAMETERS = null)
{
parent::Msg($POD, 'alert', array('table_name' => 'alerts', 'table_shortname' => 'x', 'fields' => array('id', 'date', 'userId', 'targetUserId', 'targetContentId', 'targetContentType', 'message', 'status'), 'ignore_fields' => array('minutes'), 'joins' => array('u' => 'inner join users u on u.id=x.userId', 'g' => 'left join groups g on g.id=x.targetContentId and targetContentType=\'group\'', 'c' => 'left join comments c on c.id=x.targetContentId and targetContentType=\'comment\'', 'd' => 'left join content d on d.id=x.targetContentId and targetContentType=\'content\'', 'tu' => 'inner join users u on u.id=x.targetUserId')));
if (!$this->success()) {
return $this;
}
// load item by id or accept params
if (isset($PARAMETERS['gid']) && sizeof($PARAMETERS) == 1) {
$this->load('gid', $PARAMETERS['gid']);
} else {
if (isset($PARAMETERS['id']) && sizeof($PARAMETERS) == 1) {
$this->load('id', $PARAMETERS['id']);
} else {
if ($PARAMETERS) {
foreach ($PARAMETERS as $key => $val) {
$this->set($key, $val);
}
}
}
}
return $this;
}
function Message($POD, $PARAMETERS = null)
{
parent::Msg($POD, 'message', array('table_name' => 'messages', 'table_shortname' => 'm', 'fields' => array('id', 'userId', 'targetUserId', 'fromId', 'message', 'date', 'status'), 'ignore_fields' => array('permalink', 'minutes'), 'joins' => array('from' => 'inner join users from on m.fromId=from.id', 'to' => 'inner join users to on m.targetUserId=to.id and m.fromId!=m.targetUserId')));
if (isset($PARAMETERS['id']) && sizeof($PARAMETERS) == 2) {
// load by ID
$this->load('id', $PARAMETERS['id']);
} else {
if ($PARAMETERS) {
foreach ($PARAMETERS as $key => $value) {
if ($key != 'POD') {
$this->set($key, $value);
}
}
}
}
return $this;
}
