static function query($sql, $fetch = true)
{
$connection = self::connect();
if (error($connection)) {
return $connection;
}
// save the query
self::$last_query = $sql;
// execute the query
$result = @mysql_query($sql, $connection);
self::$affected = @mysql_affected_rows();
self::$trace[] = $sql;
if (!$result) {
return self::error(l::get('db.errors.query_failed', 'The database query failed'));
}
if (!$fetch) {
return $result;
}
$array = array();
while ($r = self::fetch($result)) {
array_push($array, $r);
}
return $array;
} /**
* Send key to db
*/
public function send_key_to_db()
{
if (!self::$flag_key_sent_to_db) {
$db = new db($this->db_link);
// todo: disable logging in db
$db->query("SELECT set_config('sm.numbers.crypt.key', '" . $db->escape($this->key) . "', false)");
$db->query("SELECT set_config('sm.numbers.crypt.options', '" . $db->escape($this->cipher) . "', false)");
// todo: enable logging in db
self::$flag_key_sent_to_db = true;
}
return true;
}
