database.php File Reference

Go to the source code of this file.

Functions
	db_connect ()
	db_query ($qstring, $print=0)
	db_numrows ($qhandle)
	db_free_result ($qhandle)
	db_result ($qhandle, $row, $field)
	db_numfields ($lhandle)
	db_fieldname ($lhandle, $fnumber)
	db_affected_rows ($qhandle)
	db_fetch_array ($qhandle=0)
	db_insertid ($qhandle)
	db_error ()
	db_createinsertinto ($result, $table, $row, $autoincrement_fieldname, $replace_fieldname='zxry', $replace_value='axa')

---

Function Documentation

db_affected_rows (  $  qhandle  )

Definition at line 77 of file database.php. Referenced by cookbook_handle_update(), form_clean(), form_header(), people_add_to_job_inventory(), trackers_conf_copy(), trackers_data_create_value(), trackers_data_handle_update(), trackers_data_update_usage(), trackers_data_update_value(), trackers_transition_update_other_field(), and trackers_votes_update(). { return @mysql_affected_rows(); }

db_connect (   )

Definition at line 25 of file database.php. { global $sys_dbhost,$sys_dbuser,$sys_dbpasswd,$conn; $conn = @mysql_connect($sys_dbhost,$sys_dbuser,$sys_dbpasswd); if (!$conn) { fb("Failed to connect to database. Please contact as soon as possible server administrators. Until this problem get fixed, you will not be able to use this site.", 1); } }

db_createinsertinto (  $  result, $  table, $  row, $  autoincrement_fieldname, $  replace_fieldname = 'zxry', $  replace_value = 'axa' )

Definition at line 110 of file database.php. References db_fieldname(), db_numfields(), and db_result. Referenced by trackers_conf_copy(). { unset($fields,$values); for ($i = 0; $i < db_numfields($result); $i++) { $fieldname = db_fieldname($result, $i); # Create the sql by ignoring the autoincremental id if ($fieldname != $autoincrement_fieldname) { # If the value is empty if (db_result($result, $row, $fieldname) != NULL) { if ($fields) { $fields .= ","; $values .= ","; } $fields .= $fieldname; # Replace another field if ($fieldname == $replace_fieldname) { $values .= "'".$replace_value."'"; } else { $values .= "'".db_result($result, $row, $fieldname)."'"; } } } } # No fields? Ignore if (!$fields) { return 0; } return "INSERT INTO ".$table." ($fields) VALUES ($values)"; }

db_error (   )

Definition at line 102 of file database.php. Referenced by bookmark_add(), get_next_thread_id(), people_add_to_job_inventory(), people_show_category_table(), post_message(), register_valid(), show_newest_projects(), and trackers_data_post_notification_settings(). { return @mysql_error(); }

db_fetch_array (  $  qhandle = 0  )

Definition at line 82 of file database.php. Referenced by account_nextuid(), conf_form(), gnuevalconfirm_email(), project_admin_registration_info(), search_box(), send_new_project_email(), send_pending_user_email(), session_login_valid(), show_all_users_add_list(), show_all_users_remove_list(), show_features_boxes(), show_newest_projects(), show_pending_users_list(), show_sitestats(), show_users_list(), stats_get_generic(), trackers_conf_copy(), trackers_data_get_all_fields(), trackers_data_get_all_report_fields(), trackers_data_get_cached_field_value(), trackers_data_get_technicians(), trackers_data_update_value(), trackers_transition_get_update(), trackers_transition_update_item(), trackers_votes_user_remains_count(), and verify_login_valid(). { if ($qhandle) { return @mysql_fetch_array($qhandle); } else { if ($GLOBALS['db_qhandle']) { return @mysql_fetch_array($GLOBALS['db_qhandle']); } else { return (array()); } } }

db_fieldname (  $  lhandle, $  fnumber )

Definition at line 72 of file database.php. Referenced by db_createinsertinto(). { return @mysql_field_name($lhandle,$fnumber); }

db_free_result (  $  qhandle  )

Definition at line 57 of file database.php. { return @mysql_free_result($qhandle); }

db_insertid (  $  qhandle  )

Definition at line 96 of file database.php. Referenced by forum_create_forum(), get_next_thread_id(), post_message(), register_valid(), and trackers_conf_copy(). { return @mysql_insert_id(); }

db_numfields (  $  lhandle  )

Definition at line 67 of file database.php. Referenced by db_createinsertinto(). { return @mysql_numfields($lhandle); }

db_numrows (  $  qhandle  )

Definition at line 47 of file database.php. Referenced by account_emailvalid(), check_user_name(), cookbook_handle_update(), form_check(), format_item_attached_files(), format_item_cc_list(), format_item_details(), forum_header(), forum_show_nested_messages(), get_forum_name(), get_forum_saved_date(), get_news_name(), gnuevalconfirm_email(), graphs_build(), member_check(), member_check_pending(), member_check_private(), menu_thispage(), my_incoming_assigned_item_list(), my_incoming_unassigned_item_list(), my_item_list(), news_show_latest(), people_add_to_job_inventory(), people_get_category_name(), people_show_category_list(), people_show_category_table(), post_message(), register_valid(), send_new_project_email(), send_pending_user_email(), session_login_valid(), show_features_boxes(), show_filters(), show_grouphistory(), show_item_history(), show_item_list_sober(), show_newest_projects(), show_submessages(), show_thread(), show_votes(), stats_get_generic(), trackers_data_get_field_predefined_values(), trackers_data_get_item_notification_info(), trackers_data_get_max_value_id(), trackers_data_get_notification_settings(), trackers_data_handle_update(), trackers_data_is_default_value(), trackers_data_update_usage(), trackers_data_use_field_predefined_values(), trackers_transition_get_other_field_update(), trackers_transition_get_update(), trackers_votes_user_giventoitem_count(), trackers_votes_user_remains_count(), user_can_be_super_user(), and verify_login_valid(). { # return only if qhandle exists, otherwise 0 if ($qhandle) { return @mysql_numrows($qhandle); } else { return 0; } }

db_query (  $  qstring, $  print = 0 )

Definition at line 35 of file database.php. References $GLOBALS, and print. Referenced by account_emailvalid(), account_nextuid(), bookmark_add(), bookmark_delete(), bookmark_edit(), check_user_name(), conf_form(), cookbook_build_form(), cookbook_handle_update(), form_check(), form_clean(), form_header(), forum_create_forum(), forum_header(), forum_show_a_nested_message(), forum_show_nested_messages(), get_forum_name(), get_forum_saved_date(), get_news_name(), get_next_thread_id(), gnuevalconfirm_email(), member_add(), member_approve(), member_check(), member_check_pending(), member_check_private(), member_getpermissions(), member_remove(), menu_thispage(), my_incoming_assigned_item_list(), my_incoming_unassigned_item_list(), my_item_list(), news_show_latest(), news_total_number(), people_add_to_job_inventory(), people_get_category_name(), people_job_category_box(), people_job_status_box(), people_show_category_jobs(), people_show_category_list(), people_show_category_table(), post_message(), project_admin_registration_info(), register_valid(), search_box(), send_new_project_email(), send_pending_user_email(), session_login_valid(), show_features_boxes(), show_filters(), show_item_list_sober(), show_newest_projects(), show_sitestats(), show_submessages(), show_thread(), show_votes(), stats_get_generic(), trackers_conf_copy(), trackers_data_create_value(), trackers_data_get_all_fields(), trackers_data_get_all_report_fields(), trackers_data_get_default_value(), trackers_data_get_dependent_items(), trackers_data_get_field_predefined_values(), trackers_data_get_field_value(), trackers_data_get_item_group(), trackers_data_get_item_notification_info(), trackers_data_get_items(), trackers_data_get_max_value_id(), trackers_data_get_notification_settings(), trackers_data_get_submitters(), trackers_data_get_technicians(), trackers_data_handle_update(), trackers_data_is_default_value(), trackers_data_post_notification_settings(), trackers_data_reset_usage(), trackers_data_update_usage(), trackers_data_update_value(), trackers_data_use_field_predefined_values(), trackers_transition_get_other_field_update(), trackers_transition_get_update(), trackers_transition_update_item(), trackers_transition_update_other_field(), trackers_votes_update(), trackers_votes_user_giventoitem_count(), trackers_votes_user_remains_count(), user_can_be_super_user(), user_get_result_set_from_unix(), and verify_login_valid(). { # global $QUERY_COUNT; # $QUERY_COUNT++; if ($print) print "<br />Query is: $qstring<br />"; # if ($GLOBALS[IS_DEBUG]) $GLOBALS[G_DEBUGQUERY] .= $qstring . "<BR>\n"; global $sys_dbname; $GLOBALS['db_qhandle'] = @mysql($sys_dbname,$qstring); return $GLOBALS['db_qhandle']; }

db_result (  $  qhandle, $  row, $  field )

Definition at line 62 of file database.php. { return @mysql_result($qhandle,$row,$field); }

---