/**
*
* @param $type
* @param $object_id the object who owns the bookmark
*/
public static function remove($type, $object_id, $owner = 0)
{
if (!is_numeric($type) || !is_numeric($object_id) || !is_numeric($owner)) {
throw new \Exception('noo');
}
$session = SessionHandler::getInstance();
$q = 'DELETE FROM ' . self::$tbl_name . ' WHERE owner = ?' . ' AND value = ?' . ' AND type = ?';
return Sql::pDelete($q, 'iii', $owner ? $owner : $session->id, $object_id, $type);
}
public static function removeFromGroup($user_id, $grp_id)
{
$q = 'DELETE FROM ' . self::$tbl_name . ' WHERE groupId = ? AND userId = ?';
Sql::pDelete($q, 'ii', $grp_id, $user_id);
return true;
}
public static function deleteByReference($type, $reference)
{
$q = 'DELETE FROM ' . self::$tbl_name . ' WHERE type = ? AND reference = ?';
return Sql::pDelete($q, 'ii', $type, $reference);
}
/** Garbage Collection */
public function gc($maxlifetime)
{
$q = 'DELETE FROM tblSessionData WHERE expires < NOW()';
Sql::pDelete($q);
return true;
}
public static function deleteById($id, $tblname, $field_name = 'id')
{
if (!is_alphanumeric($tblname) || !is_alphanumeric($field_name)) {
throw new \Exception('very bad');
}
if (!is_numeric($id)) {
throw new \Exception('bad data' . $id);
}
$q = 'DELETE FROM ' . $tblname . ' WHERE ' . $field_name . ' = ?';
Sql::pDelete($q, 'i', $id);
}
public static function delete($type, $owner, $name)
{
$q = 'DELETE FROM ' . self::$tbl_name . ' WHERE owner = ? AND type = ? AND name = ?';
Sql::pDelete($q, 'iis', $owner, $type, $name);
return true;
}
/**
* Removes all chat messages from a chatroom
*/
public static function deleteByRoom($id)
{
$q = 'DELETE FROM ' . self::$tbl_name . ' WHERE room = ?';
Sql::pDelete($q, 'i', $id);
}
