include("../includes/common.htm");
if ($job==2) { $sid="dbid"; } else { $sid="id"; }
$qry="select Firstname,Lastname,PageName,Email,lastlogin from $table[$job] where $sid='$fid'";
$rec=SelectQry($qry);
$oldpagename=$rec[0]['PageName'];
$memberdir=$jobdir[$job] . $oldpagename;
if ($debug) { print "current dir: $memberdir
"; }
if (($fid) && ($status=='save')) {
$pagename=$first_name.$last_name;
$pagename=ereg_replace(" ","",$pagename);
$pagename=strtolower($pagename);
/* check if new pagename already exist */
if ($pagename!=$oldpagename) {
$pagecount=0;
for($t=0;$t<5;$t++) {
$dupcheck="select PageName from $table[$t] where PageName='$pagename'";
if ($debug) print "$dupcheck
";
$duprec=SelectQry($dupcheck);
while (count($duprec)>0) {
if ($debug) print "already exit in $table[$t]: $pagename
";
$pagecount++;
$pagename.=$pagecount;
$dupcheck="select PageName from $table[$t] where PageName='$pagename'";
$duprec=SelectQry($dupcheck);
}
}
}
//print "test: $pagename
";
$first_name=ucfirst($first_name);
$last_name=ucfirst($last_name);
$fullname=$first_name . " " . $last_name;
if ($password!='') {
$updatepw="update $table[$job] set Password='$password' where $sid='$fid'";
if ($admin) print "$updatepw
";
$updatepwrec = mysql_query("$updatepw") or $msg="Unable to change password, contact admin.
";
}
$update="update $table[$job] set Firstname='$first_name',Lastname='$last_name',Name='$fullname',PageName='$pagename' where $sid='$fid'";
if ($debug) print "$update
";
$newdir=eregi_replace($oldpagename,$pagename,$memberdir);
if (is_dir($memberdir)) {
rename ($memberdir, $newdir);
if ($debug) print "
current pagename:$oldpagename
old dir:$memberdir
new dir:$newdir
";
} else if ($debug) { print "
unknown dir: $memberdir"; }
$updaterec = mysql_query("$update") or $msg="Unable to update record, contact admin.
";
if ($debug) print mysql_error(). "
";
if ($updaterec!='') {
$msg="Record successfully updated. Refresh page to view changes.";
setcookie("NAME", "", time()+19999,$spath,$sdomain);
setcookie("DIR", "", time()+19999,$spath,$sdomain);
setcookie("NAME", $fullname, time()+19999,$spath,$sdomain);
setcookie("DIR", $newdir, time()+19999,$spath,$sdomain);
$qry="select Firstname,Lastname,PageName,Email,lastlogin from $table[$job] where $sid='$fid'";
$rec=SelectQry($qry);
} else { $msg="Unable to update record, contact admin."; }
}
?>