I commented out the call to the include file and it still comes up with the:
Found
The document has moved here.
Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.
I will include the code from the include file as well below:
<?php
include("include.inc.php");
/*****************************************************/
/* database function declarations */
/*****************************************************/
// open database
function opendb(){
$dblocalhandle=@mysql_connect(DBSERVER,DBUSER,DBPASSWD);
if(!$dblocalhandle){
echo "my handler ! Could not connect to database(1)!";
return (-1);
}
$result=@mysql_select_db(DBNAME, $dblocalhandle);
if(!$result){
#echo "Could not connect to database(2)";
return(-1);
}
return ($dblocalhandle);
}
// query database
function querydb($query){
$result = mysql_query($query);
if(!$result){
$msg = "querydb failed. QUERY =\"". $query ."\".\n";
WriteDebug($msg);
}
return ($result);
}
function fetchRow($result){
$row = @mysql_fetch_assoc($result);
if(!$row){
$row=-1;
return $row;
}else{
return $row;
}
}
function checkRows($result){
$rowcount = @mysql_affected_rows($result);
return $rowcount;
}
function countRows($result){
$rowCount = @mysql_num_rows($result);
return $rowCount;
}
function countFields($row){
$fieldcount = @mysql_num_fields($row);
return $fieldcount;
}
function fieldnames($result, $fieldCount){
$names = array();
for($i=0;$i < $fieldCount;$i++) {
$names[$i] =mysql_field_name($result, $i);
}
return $names;
}
function fetchrownames($row){
$name = mysql_field_name($row,0);
return $names;
}
// create a temporary table for complex queries
/*
function createtemptable($name){
CREATE TEMPORARY TABLE $name;
}
// get rid for the table
function droptemptable($name) {
CREATE TEMPORARY TABLE $name;
}
*/
//close database
function closedb($dblocalhandle){
mysql_close($dblocalhandle);
}
/* cookie functions */
function checkCookie($cookieName){
if (!isset($_COOKIE[$cookieName])) {
return (false);
}else {
return (true);
}
}
function getCookieValue($cookieName){
if (!isset($_COOKIE[$cookieName])) {
return (false);
}else {
$cookie_info = explode("-", $_COOKIE[$cookieName]); //Extract the Data
$style = $cookie_info[0];
setcookie ($cookieName, $style, time() + 31536000000);
$val = $cookie_info[0];
return $val;
}
/*
if ( !isset($_COOKIE[$cookieName]) ) {
$val ="false";
}else {
$cookie_info = explode("-", $_COOKIE[$cookieName]); //Extract the Data
$style = $cookie_info[0];
setcookie ($cookieName, $value, time() + 31536000000);
$val = $cookie_info[0];
}
return $val;
*/
}
//THIS builds an query from $_GET or $_POST values
// called from checkContent.
function buildQuery($getArray, $sqlType, $table){
#echo "sql TYPE = ".$sqlType;
#build the first part of the query.
# Build the second part of the query.
switch($sqlType){
case "UPDATE":
$query = "UPDATE $table SET ";
while (list ($key, $value) = each($getArray)) {
$query .= " $key = '$value',";
}
$query = ereg_replace(",$","",$query);
if(isset($getArray[itemID])){
$query .= " WHERE itemID = '$getArray[itemID]'";
}elseif(isset($getArray[uniqueID])){
$query .= " WHERE uniqueID = '$getArray[uniqueID]'";
}elseif(isset($getArray[uniqueID])){
$query .= " WHERE uniqueID = '$getArray[uniqueID]'";
#echo "query = ".$query;
}
break;
case "INSERT":
$query = "INSERT INTO $table( ";
while (list ($key, $value) = each($getArray)){ #build the query through post variables keys.
$query .= "$key, ";
}
$query = trim($query); # tidy the query and remove the trailing comma
$query = ereg_replace(",$","",$query);
$query .= ") VALUES (" ;
reset($getArray);
while (list ($key, $value) = each($getArray)) {
# again build the query through post variables values after the $_GET was reset.
$query .= "'$value', ";
}
$query = trim($query); # again tidy the query and remove the trailing comma
$query = ereg_replace(",$","",$query);
$query .= ")";
break;
case "DELETE":
$query = "DELETE FROM $table WHERE uniqueID = '$getArray[idNum]'";
$query = trim($query); # tidy the query and remove the trailing comma
$query = ereg_replace(",$","",$query);
reset($getArray);
#echo "query = ".$query;
break;
}
return $query;
} // end buildQuery funtion
function placeCookie($cookieName,$value,$exp){
$cookie_info = explode("-", $_COOKIE[$cookieName]); //Extract the Data
$style = $cookie_info[0];
$margin = time() + 31536000000;
if (!isset($_COOKIE[$cookieName])) {
setcookie ($cookieName, $value, $margin);
}else {
setcookie ($cookieName, $value, time() + 31536000000);
}
return true;
}
//from the php documentation
//page 886 of the pdf
function open_sess($save_path, $session_name) {
global $sess_save_path, $sess_session_name;
$sess_save_path = $save_path;
$sess_session_name = $session_name;
return(true);
}
function close_sess() {
return(true);
}
function read_sess($id){
global $sess_save_path, $sess_session_name;
$sess_file = "$sess_save_path/sess_$id";
if ($fp = @fopen($sess_file, "r")) {
$sess_data = fread($fp, filesize($sess_file));
return($sess_data);
} else {
return("");
}
}
function write_sess($id, $sess_data){
global $sess_save_path, $sess_session_name;
$sess_file = "$sess_save_path/sess_$id";
if ($fp = @fopen($sess_file, "w")) {
return(fwrite($fp, $sess_data));
} else {
return(false);
}
}
function destroy_sess($id) {
global $sess_save_path, $sess_session_name;
$sess_file = "$sess_save_path/sess_$id";
return(@unlink($sess_file));
}
/*********************************************
* WARNING - You will need to implement some *
* sort of garbage collection routine here. *
*********************************************/
function gc_sess($maxlifetime) {
return true;
}
#session_set_save_handler ("open", "close", "read", "write", "destroy", "gc");
#session_start(); // proceed to use sessions normally
function checkUser($username, $password){
$dbhandle = opendb();
$query = "SELECT username, password, status FROM smckay_login WHERE username = '$username' AND password='$password'";
$result = querydb($query);
$max = countRows($result);
if($max != 1){
return FALSE;
}else{
$row = fetchrow($result);
#$surl = "../index.php";
session_start();
$_SESSION['user'] = $username;
$_SESSION['authorised'] = "level$row[status]";
#echo "-----------".$_SESSION['authorised'] ;
return TRUE;
}
}
function insertUser($user, $pass, $email){
$dbhandle = opendb();
$query = "SELECT * FROM smckay_login WHERE username='$user'";
$result = querydb($query, $dbhandle);
$max = countRows($result);
if($max>0){
return FALSE;
}else{
$query = "INSERT INTO smckay_login (username, password, email) VALUES ('$user', '$pass', '$email')";
$result = querydb($query, $dbhandle);
$count = checkRows($result);
return TRUE;
}
}
// login functions from here
function init(){
global $logged_user_id, $row;
$logged_user_id = @$_SESSION["logged_user_id"];
}
//With this function, the script logs the user in or gives an error when one occurs
function log_in(){
global $message, $logged_user_id;
if(!$_POST["username"]){
$message = "You didn't enter your username";
}elseif(!$_POST["password"]){
$message = "You didn't enter your password";
}
if($message){
return;
}
// connection to the users database
$query = "SELECT * FROM users WHERE username='".$_POST['username']."' AND password='".md5($_POST['password'])."'";
$dbhandle = opendb();
$result = querydb($query);
$max = countrows($result);
$row = fetchrow($result);
if(!@$row["userID"]){
$message = "Failed to log in! Your username and/or password is incorrect";
}else{
$logged_user_id = $row["user_id"];
$_SESSION["logged_user_id"] = $row["user_id"];
$message = "Welcome $logged_user_id !";
}
return;
}
// debug info to log
function WriteDebug($msg){
//error_log( $msg, 3 , MAILADR);
@error_log($msg,3,"error.log");
}
//send HTTP-Header
function SendHeader($url){
header("Status: 302 Found");
header("Location: $url");
header("Expires: Mon, 01 Jan 05 00:00:00 GMT");
header("Pragma: no-cache");
header("Cache-Control: no-cache, must-revalidate");
}
function UnauthorisedHeader($url){
header("HTTP/1.0 401 Unauthorized");
header("Location: $url");
header("Expires: Mon, 01 Jan 05 00:00:00 GMT");
header("Pragma: no-cache");
header("Cache-Control: no-cache, must-revalidate");
}
function ConvertDate($datestr){
if(strpos($datestr,"-")>0){
$newsplit = explode("-", $datestr);
$newdate=strftime("%d.%m.%Y",mktime(0,0,0,$newsplit[1],$newsplit[2],$newsplit[0]));
}else{
$newsplit = explode(".", $datestr);
$newdate=strftime("%Y-%m-%d",mktime(0,0,0,$newsplit[1],$newsplit[0],$newsplit[2]));
}
return $newdate;
}
//This function logs out the currently logged in user
/*
global $message, $logged_user_id;
$logged_user_id = "";
unset($_SESSION["logged_user_id"]);
*/
?>
this include file also calls another include file which contains the credentials to access the database and that is all.
I'm not that good at PHP and have only managed to build up on top of previous coding to do what I need, but obviously there must be huge changes in the code from Version 4 to 5 and this is perplexing me.
Any help would be great, or even a link to a simple PHP CMS that operates the same way but works on version 5 would be great.
