/**
* db_connect_if_needed() - Set up the DB connection if it's unset
*/
-function db_connect_if_needed () {
- global $gfconn ;
+function db_connect_if_needed() {
+ global $gfconn;
if (!isset ($gfconn)) {
- db_connect () ;
+ db_connect();
}
}
* @return int result set handle.
*/
function db_query_from_file($file,$limit='-1',$offset=0,$dbserver=NULL) {
- db_connect_if_needed () ;
+ db_connect_if_needed();
$dbconn = db_switcher($dbserver) ;
global $QUERY_COUNT;
* @param int ability to spread load to multiple db servers.
* @return int result set handle.
*/
-function db_query_params($qstring,$params,$limit='-1',$offset=0,$dbserver=NULL) {
+function db_query_params($qstring, $params, $limit = '-1', $offset = 0, $dbserver = NULL) {
global $sysdebug_dbquery;
- db_connect_if_needed () ;
+ db_connect_if_needed();
$dbconn = db_switcher($dbserver) ;
global $QUERY_COUNT;
/**
* db_begin() - Begin a transaction.
*
- * @param constant Database server ('DB_PRIMARY', 'DB_STATS', 'DB_TROVE', 'DB_SEARCH')
- * @return true.
+ * @param constant Database server ('SYS_DB_PRIMARY', 'SYS_DB_STATS', 'SYS_DB_TROVE', 'SYS_DB_SEARCH')
+ * @return true.
*/
-function db_begin($dbserver=NULL) {
+function db_begin($dbserver = NULL) {
global $_sys_db_transaction_level;
// start database transaction only for the top-level
/**
* db_commit() - Commit a transaction.
*
- * @param constant Database server ('DB_PRIMARY', 'DB_STATS', 'DB_TROVE', 'DB_SEARCH')
- * @return true on success/false on failure.
+ * @param constant Database server ('SYS_DB_PRIMARY', 'SYS_DB_STATS', 'SYS_DB_TROVE', 'SYS_DB_SEARCH')
+ * @return true on success/false on failure.
*/
-function db_commit($dbserver=NULL) {
+function db_commit($dbserver = NULL) {
global $_sys_db_transaction_level;
// check for transaction stack underflow
/**
* db_rollback() - Rollback a transaction.
*
- * @param constant Database server ('DB_PRIMARY', 'DB_STATS', 'DB_TROVE', 'DB_SEARCH')
+ * @param constant Database server ('SYS_DB_PRIMARY', 'SYS_DB_STATS', 'SYS_DB_TROVE', 'SYS_DB_SEARCH')
* @return true on success/false on failure.
*/
-function db_rollback($dbserver=NULL) {
+function db_rollback($dbserver = NULL) {
global $_sys_db_transaction_level;
// check for transaction stack underflow