debug = true;
$GLOBALS["adodb_lastresult"] = "";
function Sql_Connect($host,$user,$password,$database) {
if ($host && $user) {
$GLOBALS["adodb_connection"]->Connect($host, $user, $password, $database);
return 1;
}
return 0;
}
function Sql_has_error ($dbconnection) {
return 0;
}
function Sql_Error ($errno = 0) {
$msg = $GLOBALS["adodb_connection"]->ErrorMsg();
return 'Database error '. $errno.' '.$msg.'
';
if (function_exists("logevent")) {
logevent("Database error: $msg");
}
}
function Sql_Query($query,$ignore = 0) {
$result = $GLOBALS["adodb_connection"]->Execute($query);
$GLOBALS["adodb_lastresult"] = $result;
if ($result) {
return $result;
} else {
Sql_Error($GLOBALS["adodb_connection"]->ErrNo());
return 0;
}
}
function Sql_Verbose_Query($query) {
if (preg_match("/dev$/",VERSION))
print "$query
\n";
flush();
return Sql_Query($query);
}
function Sql_Fetch_Array(&$dbresult) {
$array = $dbresult->fetchRow();
return $array;
}
function Sql_Fetch_Row(&$dbresult) {
$row = $dbresult->FetchRow();
return $row;
}
function Sql_Fetch_Row_Query($query) {
# print "Sql Fetch_Row $query
";
$req = Sql_Query($query);
return Sql_Fetch_Row($req);
}
function Sql_Fetch_Array_Query($query) {
$req = Sql_Query($query);
return Sql_Fetch_Array($req);
}
function Sql_Affected_Rows() {
if (is_object($GLOBALS["adodb_lastresult"])) {
# print "is object".$GLOBALS["adodb_lastresult"]->RecordCount();
# print '
';
# print_r($GLOBALS["adodb_lastresult"]);
# print '
';
if ($GLOBALS["adodb_lastresult"]->RecordCount())
return $GLOBALS["adodb_lastresult"]->RecordCount();
}
return $GLOBALS["adodb_connection"]->affected_rows();
}
function Sql_Num_Rows($result="") {
if (is_object($GLOBALS["adodb_lastresult"])) {
# print "is object".$GLOBALS["adodb_lastresult"]->RecordCount();
# print '
';
# print_r($GLOBALS["adodb_lastresult"]);
# print '
';
if ($GLOBALS["adodb_lastresult"]->RecordCount())
return $GLOBALS["adodb_lastresult"]->RecordCount();
}
return $GLOBALS["adodb_connection"]->affected_rows();
}
function Sql_Insert_id() {
return $GLOBALS["adodb_connection"]->insert_id();
}
function Sql_Table_exists($table) {
if (isset($GLOBALS["dbtables"]) && is_array($GLOBALS["dbtables"])) {
if (isset($GLOBALS["dbtables"][$table]))
return 1;
}
if (!isset($GLOBALS["dbtables"]) || !is_array($GLOBALS["dbtables"])) {
$GLOBALS["dbtables"] = array();
$req = Sql_Query("show tables");
while ($row = Sql_Fetch_Row($req)) {
# print $row[0]."
";
$GLOBALS["dbtables"][$row[0]] = $row[0];
# if ($row[0] == $table)
# return 1;
}
}
return isset($GLOBALS["dbtables"][$table]);
}
function Sql_Table_Column_Exists($table,$column) {
if (Sql_Table_exists($table)) {
$req = Sql_Query("show columns from $table");
while ($row = Sql_Fetch_Row($req)) {
if ($row[0] == $column)
return 1;
}
}
}
function Sql_Check_For_Table($table) {
return Sql_Table_exists($table);
}
function Sql_create_Table ($table,$structure) {
$query = "CREATE TABLE $table (\n";
while (list($column, $val) = each($structure)) {
$query .= "$column " . $structure[$column][0] . ",";
}
# get rid of the last ,
$query = substr($query,0,-1);
$query .= "\n)";
# submit it to the database
$res = Sql_Verbose_Query($query);
}
?>
?>