/** * @static */ function FindAll($classname, $conditions = array(), $order = '') { eval('$tmp = new ' . $classname . '();'); $tmp->_db_Init(); if (count($conditions)) { $wh = ''; foreach ($conditions as $k => $v) { if (!array_key_exists($k, $tmp->_db_fields)) { StrikeError('DBEntity::FindAll : unknown field \'' . $k . '\''); } $wh .= ($wh == '' ? '' : ' AND ') . '@_k_' . $k . '=@' . $k; } $cmd = new DBCommand("SELECT * FROM @_db_table WHERE " . $wh . ($order == '' ? '' : ' ORDER BY ' . $order)); $cmd->Add('@_db_table', DB_TableName, $tmp->_db_table); foreach ($conditions as $k => $v) { $cmd->Add('@_k_' . $k, DB_TableName, $k); $cmd->Add('@' . $k, $tmp->_db_fields[$k]['t'], $v, $tmp->_db_fields[$k]['s']); } } else { $cmd = new DBCommand("SELECT * FROM @_db_table" . ($order == '' ? '' : ' ORDER BY ' . $order)); $cmd->Add('@_db_table', DB_TableName, $tmp->_db_table); } return DBEntity::FindAllByCmd($classname, $cmd); }
public static function clearForAccount($accID) { return DBEntity::query('DELETE FROM account_session WHERE accountId=' . $accID); }
function Image() { parent::DBEntity(true); $this->uploaded = Now(); $this->lastshow = Now(); }