/** * delete a record by its id * @param int $id * @return boolean */ public static function delete($id) { static::validateParamTypes(array('id' => $id)); DB\dbQuery('DELETE from `' . static::getTableName() . '` ' . 'WHERE id = $1 AND `type` = $2', array($id, static::$type)) or die(DB\dbQueryError()); $rez = DB\dbAffectedRows() > 0; return $rez; }
/** * delete a record by its id * @param int $id * @return boolean */ public static function delete($id) { static::validateParamTypes(array('id' => $id)); DB\dbQuery('DELETE from `' . static::$tableName . '` ' . 'WHERE id = $1', $id) or die(DB\dbQueryError()); $rez = DB\dbAffectedRows() > 0; return $rez; }
public static function deleteByNodeId($nodeId, $userId = false) { if ($userId == false) { $userId = \CB\User::getId(); } DB\dbQuery('DELETE FROM ' . static::getTableName() . ' WHERE user_id = $1 AND node_id = $2', array($userId, $nodeId)) or die(DB\dbQueryError()); $rez = DB\dbAffectedRows() > 0; return $rez; }
/** * copy a record * @param int $id * @return boolean */ public static function copy($sourceId, $targetId) { DB\dbQuery('INSERT INTO `objects` (`id` ,`data` ,`sys_data`) SELECT $2 ,`data` ,`sys_data` FROM `objects` WHERE id = $1', array($sourceId, $targetId)) or die(DB\dbQueryError()); return DB\dbAffectedRows() > 0; }
/** * delete a record by its id * @param []int $ids * @return boolean */ public static function delete($ids) { $sql = 'DELETE from ' . static::getTableName() . ' WHERE `type` = $1 and id'; if (is_scalar($ids)) { static::validateParamTypes(array('id' => $ids)); DB\dbQuery($sql . ' = $2', array(static::$type, $ids)); } else { $ids = Util\toNumericArray($ids); if (!empty($ids)) { DB\dbQuery($sql . ' IN (' . implode(',', $ids) . ')', static::$type); } } $rez = DB\dbAffectedRows() > 0; return $rez; }
/** * copy a record * @param int $id * @return boolean */ public static function copy($sourceId, $targetId) { $r = Tree::read($targetId); $pid = empty($r) ? null : $r['pid']; DB\dbQuery('INSERT INTO ' . static::getTableName() . ' (id, pid, `is_folder`, `type`, `name`, `l1`, `l2`, `l3`, `l4`, `order`, `visible`, `iconCls`, `default_field`, `cfg`, `title_template`, `info_template`) SELECT $2, $3, `is_folder`, `type`, `name`, `l1`, `l2`, `l3`, `l4`, `order`, `visible`, `iconCls`, `default_field`, `cfg`, `title_template`, `info_template` FROM ' . static::getTableName() . ' WHERE id = $1', array($sourceId, $targetId, $pid)); return DB\dbAffectedRows() > 0; }
public static function deleteByUserId($userId) { DB\dbQuery('DELETE FROM sessions WHERE user_id = $1', $userId) or die(DB\dbQueryError()); return DB\dbAffectedRows() > 0; }
/** * move active (non deleted) children to other parent * @param array $sourceId * @param array $targetId * @return bool */ public static function moveActiveChildren($sourceId, $targetId) { DB\dbQuery('UPDATE tree SET updated = 1 ,pid = $2 WHERE pid = $1 AND dstatus = 0', array($sourceId, $targetId)); return DB\dbAffectedRows() > 0; }
/** * write session data * @param varchar $session_id * @param varchar $session_data * @return bool */ public function write($session_id, $session_data) { $lifetime = ini_get('session.cookie_lifetime'); $lifetime = empty($this->lifetime) ? null : $this->lifetime; /* when updating/creating a new session then parent session and all other child sessions shoould be marked as expiring in corresponding timeout */ if (!empty($this->previous_session_id)) { DB\dbQuery('UPDATE sessions SET expires = TIMESTAMPADD(SECOND, $3, CURRENT_TIMESTAMP) WHERE ( (id = $2) OR (pid = $2) ) and id <> $1', array($session_id, $this->previous_session_id, $this->lifetime_pid_sessions)) or die(DB\dbQueryError()); } $res = DB\dbQuery('INSERT INTO sessions (id, pid, expires, user_id, data) VALUES($1, $2, TIMESTAMPADD(SECOND, $3, CURRENT_TIMESTAMP), $4, $5) ON DUPLICATE KEY UPDATE expires = TIMESTAMPADD(SECOND, $3, CURRENT_TIMESTAMP) ,last_action = CURRENT_TIMESTAMP ,user_id = $4 ,data = $5', array($session_id, $this->previous_session_id, $lifetime, '0' . @$_SESSION['user']['id'], $session_data)) or die(DB\dbQueryError()); return DB\dbAffectedRows() > 0; }