BASE_URL: $base_url";
//exit;
include "$DOCUMENT_ROOT/php/date_functions.php";
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Verify that folder exits.
// If it exits return TRUE
// if not then create it and return TRUE
// On error return FALSE
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
function uCheckPath( $filename ) {
$path = dirname( $filename );
/*
echo "
FILENAME: ".$filename;
echo "
DIRECTORY: ".$path;
echo "
DIRECTORY STATUS: ".!is_dir($path);
echo "
";
*/
if( !is_dir($path)) {
// Strip the / from the end of the path name if it exists
if( $path[strlen($path)-1]=="/" ) { $path[strlen($path)-1] = ""; }
// Make the new directory
mkdir($path,0700) or FileError( "Could not create directory: $path" );
}
return TRUE;
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// Displays error message
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
function FileError($msg) {
echo $msg;
//exit;
}
// ###################################################################################
/* Opens the "msg.html" template, inserts a custom message, and diplays in browser */
// ###################################################################################
function uPageOut($msg,$filepath,$head = "System Message",$user,$menu) {
global $HTTP_HOST;
global $HTTP_COOKIE_VARS;
// if($user) { $user=$user." is logged in"; }
$fd = fopen ($filepath."msg.html", "r")
or die( "Referrer:".$HTTP_REFERRER."
Cannot open ".$filepath."msg.html" );
while (!feof ($fd)) {
$buffer = fgets($fd, 4096);
$buffer = str_replace ("**HEADLINE**", $head, $buffer);
$buffer = str_replace ("**PAGE_BODY**", $msg, $buffer);
$buffer = str_replace ("**MENU_OPT**", "$menu", $buffer);
$buffer = str_replace ("**LOGIN_STATUS**", "$user", $buffer);
$buffer = str_replace ("**HOST_URL**", "http://$HTTP_HOST", $buffer);
$buffer = str_replace ("**USER_NAME**", $HTTP_COOKIE_VARS[name], $buffer);
echo $buffer;
}
fclose ($fd);
// return;
exit;
}
// ###################################################################################
// Sends visitor back to a form and displays error message
// ###################################################################################
function uFormOut($msg,$filename,$filepath) {
$fd = fopen ($filepath.$filename, "r");
while (!feof ($fd)) {
$buffer = fgets($fd, 4096);
$buffer = str_replace ("", $msg, $buffer);
echo $buffer;
}
fclose ($fd);
return;
}
// #########################################################
// Save Article to a temp file
// #########################################################
function uSaveFile( $filename,$buffer ) {
$fp = fopen ($filename, "w") or FileError( "Could not open '$filename'" );
if( fputs($fp,$buffer,strlen($buffer)) ) { fclose ($fp); return TRUE; }
else { fclose ($fp); return FALSE; }
}
// #########################################################
/* Returns the entire contents of a text file */
// #########################################################
function uGetFile($file,$filepath) {
$fd = fopen ($filepath.$file, "r");
if(!$fd){ return FALSE; }
while (!feof ($fd)) {
$buffer = $buffer . fgets($fd, 4096);
}
fclose ($fd);
return $buffer;
}
// #########################################################
/* Returns only one section of a text file */
// #########################################################
function uGetSection($file,$section,$filepath) {
$fd = fopen ($filepath.$file, "r");
while (!feof ($fd)) {
$buffer = fgets($fd, 4096);
if (eregi($section,$buffer)) {
while (!eregi("",$buffer)) {
$out = $out . $buffer;
$buffer = fgets($fd, 4096);
}
}
}
fclose ($fd);
return $out;
}
// #########################################################
/* Redirects to another page */
// #########################################################
function redir($to) {
echo "";
}
// #########################################################
/* Check to see if visitor is logged in */
// #########################################################
function uValidateUser( $id,$db,$table="members" ) {
$date = date('Y-m-d');
$sql = "SELECT LoggedIn, LastLogin FROM $table WHERE id=$id";
$result = mysql_query( $sql,$db );
//if( $myrow['LoggedIn']=="Yes" ) {
if( mysql_affected_rows( $db )>0 ) {
$myrow = mysql_fetch_array( $result );
if( !eregi( $date, $myrow['LastLogin'] ) ) { return false; }
return true;
}
//}
return false;
}
// #########################################################
//Check To See If User Exists
// #########################################################
function UserExist( $username,$fieldname,$table,$db ) {
$sql = "SELECT $fieldname FROM $table WHERE $fieldname='$username'";
$result = mysql_query( $sql,$db ) or die( "Error: ".mysql_error() );
if( mysql_affected_rows( $db )==1 ) {
return TRUE;
}
else {
return FALSE;
}
}
// #########################################################
//SAVES A FIELDS FROM A FIELDSLIST ARRAY TO A TABLE DEFINED IN THE FORMFIELDS TABLE FOR A GIVEN FORM
// #########################################################
function SaveRecords($form_name,$fieldlist,$db) {
// Get a Table or Tables that these form fields will be saved in
$sql = "SELECT DISTINCT dbTable FROM FormFields WHERE FormName='$form_name'";
$result = mysql_query( $sql, $db ) or die( "Error: ".mysql_error() );
//echo $sql;
// Check if results were returned
if( mysql_affected_rows( $db )==0 ) { return FALSE; }
// Get Table Names
while( $myrow = mysql_fetch_array( $result ) ) {
if( isset($db_tables) ) {
$db_tables = array_merge( $db_tables, array( $myrow['dbTable'] ) );
}
else { $db_tables = array( $myrow["dbTable"] ); }
}
// Saves field data for each table in $db_tables
while( list( $key,$val ) = each( $db_tables ) ) {
$sql = "SELECT * FROM FormFields WHERE FormName='$form_name' AND dbTable='$val'";
$result = mysql_query( $sql, $db ) or die( "Error: ".mysql_error() );
$sql = "INSERT INTO $val ";
$db_cols = "(";
$db_vals = "VALUES (";
while( $myrow = mysql_fetch_array( $result ) ) {
$db_cols = $db_cols . $myrow["FieldName"] . ",";
$db_vals = $db_vals . "'" . $fieldlist[$myrow["FieldName"]] . "',";
}
// Build SQL statement
$sql = $sql . $db_cols . "Created, Updated) " . $db_vals . "'" . date('Y-m-d') . "', '" . date('Y-m-d') . "')";
//echo $sql;
//exit;
// Save $result to DB
$result = mysql_query( trim($sql), $db ) or die( "Error: " . mysql_error() );
}
return TRUE;
}
// ###################################################################################
// THIS FUNCTION DELETES A RECORD FROM A TABLE (based on known record id)
// ###################################################################################
function DeleteRecord( $table,$id,$db ) {
$sql = "DELETE FROM $table WHERE id=$id";
$result = mysql_query( $sql,$db ) or die("$sql
DB Error: ".mysql_error() ); if( mysql_affected_rows( $db )>0 ) { return TRUE; } else { return FALSE; } } // ######################################################### // Returns the value of one field from a specified table // ######################################################### function uGetField ( $id,$field,$table,$db,$field_str='*',$where ) { if(!$where) { $where = "WHERE id=$id"; } $sql = "SELECT $field_str FROM $table $where"; $result = mysql_query( $sql,$db ); // or die( "$sql
DB Error: ".mysql_error() );
//echo $sql."
";
if( mysql_affected_rows( $db )<1 ) {
//$out = "
$sql";
}
else {
$myrow = mysql_fetch_array( $result );
$out = $myrow[$field];
}
mysql_free_result( $result );
return $out;
}
// #########################################################
// Returns the value of one field from a specified table
// #########################################################
function uGetFieldVals( $post_vars ) {
while (list($field, $value) = each( $post_vars )) {
if( isset($field_data)) {
$field_data = array_merge( $field_data, array( $field=>$value ));
}
else {
$field_data = array( $field=>$value );
}
//echo "$field = $value
";
}
//exit;
return $field_data;
}
// #########################################################
// Returns sql UPDATE statement
// #########################################################
function UpdateRecord( $form_name,$field_data,$db ) {
}
// #########################################################
// Saves record to DB based on passed SQL string
// #########################################################
function dbSave( $sql,$db ) {
if( $result = mysql_query( $sql,$db )) { return TRUE; }
else { echo "
ERROR: ".mysql_error()."
$sql
|
(Area
Code) |
Number |