/**
* 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
WHERE group_id=$1 ORDER BY month DESC, day DESC";
if ($span == 30) {
- $res = db_query_params($sql, array($group_id), 30, 0, 'DB_STATS');
+ $res = db_query_params($sql, array($group_id), 30, 0, 'SYS_DB_STATS');
} else {
- $res = db_query_params($sql, array($group_id), 7, 0, 'DB_STATS');
+ $res = db_query_params($sql, array($group_id), 7, 0, 'SYS_DB_STATS');
}
- echo db_error('DB_STATS');
+ echo db_error('SYS_DB_STATS');
// if there are any days, we have valid data.
if ( ($valid_days = db_numrows( $res )) > 0 ) {
} else {
echo _('Project did not exist on this date.');
- echo db_error('DB_STATS') .'</p>';
+ echo db_error('SYS_DB_STATS') .'</p>';
}
}
SELECT * FROM stats_project_months
WHERE group_id=$1
ORDER BY group_id DESC, month DESC
- ",array($group_id), -1, 0, 'DB_STATS');
+ ",array($group_id), -1, 0, 'SYS_DB_STATS');
// if there are any weeks, we have valid data.
if ( ($valid_months = db_numrows( $res )) > 1 ) {
} else {
echo _('Project did not exist on this date.')."<p>";
- echo db_error('DB_STATS');
+ echo db_error('SYS_DB_STATS');
}
}
SELECT *
FROM stats_project_all_vw
WHERE group_id=$1
- ", array($group_id), -1, 0, 'DB_STATS');
+ ", array($group_id), -1, 0, 'SYS_DB_STATS');
$row = db_fetch_array($res);
?>