0) { if (!$offset || $offset < 0) { $offset=0; } $qstring=$qstring." LIMIT $offset,$limit"; } // if ($GLOBALS['IS_DEBUG']) $GLOBALS['G_DEBUGQUERY'] .= $qstring . "
\n";
//
//are we configured to try to use replication?
//
if ($sys_db_use_replication) {
//
//if we haven't yet done an insert/update,
//read from the read-only db
//
if (!$sys_db_is_dirty && mb_eregi("^( )*(select)",$qstring)) {
if ($QUERY_COUNT%3==0) {
// 1/3rd of read queries go to master for now
return @mysql_db_query($sys_dbname,$qstring,$conn_update);
} else {
return @mysql_db_query($sys_dbname,$qstring,$conn);
}
} else {
//must be an update/insert/delete query - go to master server
$sys_db_is_dirty=true;
return @mysql_db_query($sys_dbname,$qstring,$conn_update);
}
} else {
$ret = @mysql_db_query($sys_dbname,$qstring,$conn);
// echo "@mysql_db_query($sys_dbname,$qstring,$conn); ret=$ret
";
if(!$ret){
$e = new mb_exception("db_query($qstring)=$ret db_error=".db_error());
}
return $ret;
}
//echo "SQL__".$qstring;
}
/**
* prepare and query the database
*
* @param $qstring (string) SQL statement
* @param $params (array string params)
* @param $types (array string types)
*/
function db_prep_query($qstring, $params, $types){
$ci = new checkInput($qstring,$params,$types);
$params = $ci->v;
for ($i=0; $i