<? function db_connect() { global $db;<!------22 ТРОКА if ($db) return; $db = mysql_connect("localhost", MYSQLUSER, MYSQLPASS); mysql_select_db(MYSQLDB, $db); if (!$db) { echo "Couldn't open database!\n"; exit; } } function db_disconnect() { global $db; if ($db) { mysql_close($db); $db = NULL; } } function db_query($q) { global $db; $result = mysql_query($q, $db); return $result; } function db_fetch_array($result) { global $db; $r = mysql_fetch_array($result); return $r; } function db_query_row($q) { $result = db_query($q); if (!$result) return NULL; $row = mysql_fetch_array($result); return $row; } function db_query_value($q) { $row = db_query_row($q); return $row[0]; } function db_array_update($table, $a, $where) { $q = "update $table set "; $b = NULL; foreach($a as $key => $value) { if (is_int($key)) continue; // if (isset($value) && $value != "") $b[] = "$key='$value'"; } $q .= implode(",", $b); $q .= " where ".$where; db_query($q); } function db_array_insert($table, $a) { $q = "insert into $table set "; $b = NULL; foreach($a as $key => $value) { if (is_int($key)) continue; if ($value && $value != "") $b[] = "$key='$value'"; } $q .= implode(",", $b); db_query($q); } function db_insert_id() { return mysql_insert_id(); } function gen_id($table, $column, $size, $characters_allow) { for(;;) { $id = random_string($size, TRUE, $characters_allow); $q = "select count(*) from $table where $column='$id'"; $count = db_query_value($q); if ($count == 0) break; } return $id; } function db_num_rows($result) { return mysql_num_rows($result); } ?>