 |
boardom b2 message board
|
View previous topic :: View next topic |
Author |
Message |
richardx
Joined: 16 Oct 2004 Posts: 7
|
Posted: Tue Oct 19, 2004 5:32 pm Post subject: SQL Error |
|
|
Heres another problem now with my login: if again you visit my site: http://weblog.richardlennox.net and try to login using anything I think: I now
get this error:
Warning: Cannot modify header information - headers already sent by (output started at /home/richardx/public_html/weblog/rllogin.php:10) in /home/richardx/public_html/weblog/rllogin.php on line 227
and various lines thereafter!!
PHP code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<!-- TemplateBeginEditable name="doctitle" -->
<title>Richard Lennox</title>
<!-- TemplateEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="keywords" content="Richard, Lennox, Richard Lennox, richardlennox, richard, lennox, Richard David Lennox, Carlisle, Heriot-Watt University Edinburgh, Computer Science,"><link href="layout2b.css" rel="stylesheet" type="text/css">
<script type="text/javascript" src="../js/global.js"></script>
<!-- TemplateBeginEditable name="head" -->
<!-- TemplateEndEditable -->
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
<body bgcolor="#CCCCCC" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('file:///C|/Documents%20and%20Settings/Richard%20Lennox/My%20Documents/New%20Site/images/btnWhatWeDo_over.gif','file:///C|/Documents%20and%20Settings/Richard%20Lennox/My%20Documents/New%20Site/images/btnProfiles_over.gif','file:///C|/Documents%20and%20Settings/Richard%20Lennox/My%20Documents/New%20Site/images/btnNews_over.gif','file:///C|/Documents%20and%20Settings/Richard%20Lennox/My%20Documents/New%20Site/images/btnContactUs_over.gif')">
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top"><table width="775" border="0" cellpadding="0" cellspacing="0" class="siteBorder">
<tr>
<td><table width="775" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td height="141" colspan="2"><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="775" height="141">
<param name="movie" value="../images/lennox.swf">
<param name="quality" value="high">
<embed src="../images/lennox.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="775" height="141"></embed>
</object>
</td>
</tr>
<tr>
<td colspan="2"><img src="../images/topBorder.gif" width=775 height=10></td>
</tr>
<tr>
<td width="187" height="264" valign="top" background="../images/navBkg.gif"><table width="187" height="234" cellpadding="0" cellspacing="0" background="../images/navBkg.gif">
<tr>
<td height="84" valign="top"> <img src="../images/navTop.gif" width=187 height=84></td>
</tr>
<tr>
<td height="30"><a href="../Templates/education.htm" onMouseOver="MM_swapImage('imgNav2','','../images/btnEducation_over.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="../images/btnEducation.gif" alt="Education" name="imgNav2" width=187 height=30 border="0" id="imgNav2"></a></td>
</tr>
<tr>
<td height="30"><a href="../Templates/work.htm" onMouseOver="MM_swapImage('imgNav3','','../images/btnWork_over.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="../images/btnWork.gif" alt="Work History" name="imgNav3" width=187 height=30 border="0" id="imgNav3"></a></td>
</tr>
<tr>
<td height="30"><a href="../Templates/personal.htm" onMouseOver="MM_swapImage('imgNav4','','../images/btnPersonal_over.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="../images/btnPersonal.gif" alt="Personal Statement" name="imgNav4" width=187 height=30 border="0" id="imgNav4"></a></td>
</tr>
<tr>
<td height="30"><a href="../Templates/gallery.htm" onMouseOver="MM_swapImage('imgNav6','','../images/btnGallery_over.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="../images/btnGallery.gif" alt="Gallery" name="imgNav6" width=187 height=30 border="0" id="imgNav6"></a></td>
</tr>
<tr>
<td height="30"><a href="../Templates/weblog/index.htm" onMouseOver="MM_swapImage('imgNav5','','../images/btnWeblog_over.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="../images/btnWeblog.gif" alt="Weblog" name="imgNav5" width=187 height=30 border="0" id="imgNav5"></a></td>
</tr>
<tr>
<td height="30"><a href="../Templates/contact.htm" onMouseOver="MM_swapImage('imgNav7','','../images/btnContact_over.gif',1)" onMouseOut="MM_swapImgRestore()"><img src="../images/btnContact.gif" alt="contact Richard Lennox" name="imgNav7" width=187 height=30 border="0" id="imgNav7"></a></td>
</tr>
</table></td>
<td rowspan="3" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="25" align="left"><img src="../images/spacer.gif" width="25" height="8"></td>
<td colspan="2" align="left"><!-- TemplateBeginEditable name="editHeading" -->
<h1>Journal: Login</h1>
<!-- TemplateEndEditable --></td>
</tr>
<tr>
<td><img src="../images/spacer.gif" width="1" height="1"></td>
<td width="533" height="430" align="left" valign="top" class="bodyNorm"><!-- TemplateBeginEditable name="editMain" -->
<?php
require('./b2config.php');
require_once($b2inc.'/b2template.functions.php');
require_once($b2inc.'/b2functions.php');
require_once($b2inc.'/b2vars.php');
if (!function_exists('add_magic_quotes')) {
function add_magic_quotes($array) {
foreach ($array as $k => $v) {
if (is_array($v)) {
$array[$k] = add_magic_quotes($v);
} else {
$array[$k] = addslashes($v);
}
}
return $array;
}
}
if (!get_magic_quotes_gpc()) {
$HTTP_GET_VARS = add_magic_quotes($HTTP_GET_VARS);
$HTTP_POST_VARS = add_magic_quotes($HTTP_POST_VARS);
$HTTP_COOKIE_VARS = add_magic_quotes($HTTP_COOKIE_VARS);
}
$b2varstoreset = array('action','mode','error','text','popupurl','popuptitle');
for ($i = 0; $i < count($b2varstoreset); $i = $i + 1) {
$b2var = $b2varstoreset[$i];
if (!isset($$b2var)) {
if (empty($HTTP_POST_VARS["$b2var"])) {
if (empty($HTTP_GET_VARS["$b2var"])) {
$$b2var = '';
} else {
$$b2var = $HTTP_GET_VARS["$b2var"];
}
} else {
$$b2var = $HTTP_POST_VARS["$b2var"];
}
}
}
/* connecting the db */
$connexion = @mysql_connect($server,$loginsql,$passsql) or die("Can't connect to the database<br>".mysql_error());
mysql_select_db("$base");
switch($action) {
case "logout":
setcookie("cafeloguser");
setcookie("cafelogpass");
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-cache, must-revalidate"); // for HTTP/1.1
header("Pragma: no-cache");
if ($is_IIS) {
header("Refresh: 0;url=index.php");
} else {
header("Location: index.php");
}
exit();
break;
case "login":
if(!empty($HTTP_POST_VARS)) {
$log = $HTTP_POST_VARS["log"];
$pwd = $HTTP_POST_VARS["pwd"];
$redirect_to = $HTTP_POST_VARS["redirect_to"];
}
function login() {
global $server,$loginsql,$passsql,$base,$log,$pwd,$error,$user_ID;
global $tableusers, $pass_is_md5;
$user_login=$log;
$password=$pwd;
if (!$user_login) {
$error="<b>ERROR</b>: the login field is empty";
return false;
}
if (!$password) {
$error="<b>ERROR</b>: the password field is empty";
return false;
}
if (substr($password,0,4)=="md5:") {
$pass_is_md5 = 1;
$password = substr($password,4,strlen($password));
$query = " SELECT ID, user_login, user_pass FROM $tableusers WHERE user_login = '$user_login' AND MD5(user_pass) = '$password' ";
} else {
$pass_is_md5 = 0;
$query = " SELECT ID, user_login, user_pass FROM $tableusers WHERE user_login = '$user_login' AND user_pass = '$password' ";
}
$result = mysql_query($query) or die("Incorrect Login/Password request: ".mysql_error());
$lines = mysql_num_rows($result);
if ($lines<1) {
$error="<b>ERROR</b>: wrong login or password";
$pwd="";
return false;
} else {
$res=mysql_fetch_row($result);
$user_ID=$res[0];
if (($pass_is_md5==0 && $res[1]==$user_login && $res[2]==$password) || ($pass_is_md5==1 && $res[1]==$user_login && md5($res[2])==$password)) {
return true;
} else {
$error="<b>ERROR</b>: wrong login or password";
$pwd="";
return false;
}
}
}
if (!login()) {
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
if ($is_IIS) {
header("Refresh: 0;url=rllogin.php");
} else {
header("Location: rllogin.php");
}
exit();
} else {
$user_login=$log;
$user_pass=$pwd;
setcookie("cafeloguser",$user_login,time()+31536000);
if ($pass_is_md5) {
setcookie("cafelogpass",$user_pass,time()+31536000);
} else {
setcookie("cafelogpass",md5($user_pass),time()+31536000);
}
if (empty($HTTP_COOKIE_VARS["cafelogblogid"])) {
setcookie("cafelogblogid","1",time()+31536000);
}
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
switch($mode) {
case "bookmarklet":
$location="b2bookmarklet.php?text=$text&popupurl=$popupurl&popuptitle=$popuptitle";
break;
case "sidebar":
$location="sidebar.php?text=$text&popupurl=$popupurl&popuptitle=$popuptitle";
break;
case "profile":
$location="profile.php?text=$text&popupurl=$popupurl&popuptitle=$popuptitle";
break;
default:
$location="$redirect_to";
break;
}
if ($is_IIS) {
header("Refresh: 0;url=$location");
} else {
header("Location: $location");
}
}
break;
case "lostpassword":
?><html>
<head>
<title>Lost Password</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="<?php echo $b2inc; ?>/b2.css" type="text/css">
<style type="text/css">
<!--
<?php
if (!preg_match("/Nav/",$HTTP_USER_AGENT)) {
?>
textarea,input,select {
background-color: #f0f0f0;
border-width: 1px;
border-color: #cccccc;
border-style: solid;
padding: 2px;
margin: 1px;
}
<?php
}
?>
-->
</style>
</head>
<body bgcolor="#CCCCCC" text="#000000" link="#cccccc" vlink="#cccccc" alink="#ff0000">
<table width="100%" height="100%">
<td align="center" valign="middle">
<table width="403" height="200" style="border: 1px solid #cccccc;" cellpadding="0" cellspacing="0">
<tr height="50">
<td colspan="2" width="1" align="right" valign="top"> </td>
</tr>
<tr height="150"><td align="right" valign="bottom" height="150" colspan="2">
<p align="center" style="color: #b0b0b0">Type your login here and click OK. You will receive an email with your password.</p>
<?php
if ($error) echo "<div align=\"right\" style=\"padding:4px;\"><font color=\"#FF0000\">$error</font><br /> </div>";
?>
<form name="" action="rllogin.php" method="post">
<input type="hidden" name="action" value="retrievepassword" />
<table width="253" height="70" style="background-color: #ffffff">
<tr><td align="right">login</td>
<td><input type="text" name="user_login" value="" size="8" /> </td></tr>
<tr><td> </td>
<td><input type="submit" name="Submit2" value="OK" class="search"> </td></tr>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<?php
break;
case "retrievepassword":
$user_login = $HTTP_POST_VARS["user_login"];
$user_data = get_userdatabylogin($user_login);
$user_email = $user_data["user_email"];
$user_pass = $user_data["user_pass"];
$message = "Login: $user_login\r\n";
$message .= "Password: $user_pass\r\n";
$m = mail($user_email, "your weblog's login/password", $message);
if ($m == false) {
echo "<p>The email could not be sent.<br />\n";
echo "Possible reason: your host may have disabled the mail() function...</p>";
die();
} else {
echo "<p>The email was sent successfully to $user_login's email address.<br />\n";
echo "<a href=\"rllogin.php\">Click here to login !</a></p>";
die();
}
break;
default:
if((!empty($HTTP_COOKIE_VARS["cafeloguser"])) && (!empty($HTTP_COOKIE_VARS["cafelogpass"]))) {
$user_login = $HTTP_COOKIE_VARS["cafeloguser"];
$user_pass_md5 = $HTTP_COOKIE_VARS["cafelogpass"];
}
function checklogin() {
global $server,$loginsql,$passsql,$base;
global $user_login,$user_pass_md5,$user_ID;
$userdata = get_userdatabylogin($user_login);
if ($user_pass_md5 != md5($userdata["user_pass"])) {
return false;
} else {
return true;
}
}
if ( !(checklogin()) ) {
if (!empty($HTTP_COOKIE_VARS["cafeloguser"])) {
$error="Error: wrong login/password"; //, or your session has expired.";
}
} else {
header("Expires: Wed, 5 Jun 1979 23:41:00 GMT"); /* private joke: this is my birthdate - though officially it's on the 6th, since I'm GMT+1 */
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); /* different all the time */
header("Cache-Control: no-cache, must-revalidate"); /* to cope with HTTP/1.1 */
header("Pragma: no-cache");
header("Location: b2edit.php");
exit();
}
?><html>
<head>
<title>Richard Lennox: Journal Login </title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="<?php echo $b2inc; ?>/b2.css" type="text/css">
<style type="text/css">
<!--
<?php
if (!preg_match("/Nav/",$HTTP_USER_AGENT)) {
?>
textarea,input,select {
background-color: #f0f0f0;
border-width: 1px;
border-color: #cccccc;
border-style: solid;
padding: 2px;
margin: 1px;
}
<?php
}
?>
-->
</style>
</head>
<body bgcolor="#CCCCCC" text="#000000" link="#cccccc" vlink="#cccccc" alink="#ff0000">
<table width="100%" height="100%">
<td align="center" valign="middle">
<table width="200" height="200" style="border: 1px solid #cccccc;" cellpadding="0" cellspacing="0">
<tr height="50">
<td height="50" width="50">
</td>
<td align="right" valign="top">
<a href="rlregister.php" class="b2menutop">register ?</a><br />
<a href="rllogin.php?action=lostpassword" class="b2menutop">lost your password ?</a>
</td>
</tr>
<tr height="150"><td align="right" valign="bottom" height="150" colspan="2">
<?php
if ($error) echo "<div align=\"right\" style=\"padding:4px;\"><font color=\"#FF0000\">$error</font><br /> </div>";
?>
<form name="" action="rllogin.php" method="post">
<?php if ($mode=="bookmarklet") { ?>
<input type="hidden" name="mode" value="<?php echo $mode ?>" />
<input type="hidden" name="text" value="<?php echo $text ?>" />
<input type="hidden" name="popupurl" value="<?php echo $popupurl ?>" />
<input type="hidden" name="popuptitle" value="<?php echo $popuptitle ?>" />
<?php } ?>
<input type="hidden" name="redirect_to" value="b2edit.php" />
<input type="hidden" name="action" value="login" />
<table width="100" style="background-color: #ffffff">
<tr><td align="right">login</td>
<td><input type="text" name="log" value="" size="10" /> </td></tr>
<tr><td align="right">password</td>
<td><input type="password" name="pwd" value="" size="10" /> </td></tr>
<tr><td> </td>
<td><input type="submit" name="Submit2" value="OK" class="search"> </td></tr>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<?php
break;
}
?>
<!-- TemplateEndEditable --></td>
<td width="30" align="right" valign="bottom" class="bodyNorm"><img src="../images/rightBtm.gif" width="30" height="73"></td>
</tr>
<tr align="right">
<td colspan="3"><img src="../images/btmBorder.gif" width="588" height="33"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="187" height="100%" align="left" valign="top" background="../images/navBkg.gif"><img src="../images/spacer.gif" width="1" height="1"></td>
</tr>
<tr>
<td height="184" valign="bottom" background="../images/navBkg.gif"><img src="../images/navBtm.gif" alt="" width=187 height=184 border="0" usemap="#mapContact"></td>
</tr>
<tr>
<td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><a href="http://www.richardlennox.net" target="_blank"><img src="../images/footerLeft.gif" alt="Designed by Richard Lennox" width="301" height="47" border="0"></a></td>
<td><img src="../images/footerRight.gif" width="474" height="47"></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td height="40" align="center" valign="middle" class="menuBtm"><a href="../Templates/index.htm">Home</a> | <a href="../Templates/education.htm">Education
</a> | <a href="../Templates/work.htm">Work History</a> | <a href="../Templates/statement.htm">Personal
Statement</a> | <a href="../Templates/gallery.htm">Gallery</a> | <a href="../Templates/weblog.htm">Weblog</a> | <a href="../Templates/contact.htm">Contact</a></td>
</tr>
</table>
<map name="mapContact">
<area shape="rect" coords="25,23,170,40" href="mailto:[email protected]">
</map>
</body>
</html>
|
|
Back to top |
|
 |
Sigg3
Joined: 03 Jul 2003 Posts: 896 Location: Oslo, Norway
|
|
Back to top |
|
 |
richardx
Joined: 16 Oct 2004 Posts: 7
|
Posted: Tue Oct 19, 2004 8:02 pm Post subject: |
|
|
Yes however, the common solution is to remove all the spaces after ?> in the b2config.php. However this has been checked and double checked but still has the same effect - if anyone wants to try the code visit:
http://weblog.richardlennox.net/rllogin.php
login and passward are blog20 |
|
Back to top |
|
 |
richardx
Joined: 16 Oct 2004 Posts: 7
|
Posted: Tue Oct 19, 2004 9:51 pm Post subject: |
|
|
Ok, am trying a new track!!
Have tried taking my template and adding the b2 code directly into the template where it is required. It works perfectly without the template just putting it all in the editable region seems to mess it all up..
Someone has to know why? |
|
Back to top |
|
 |
Cyberian75
Joined: 26 Sep 2002 Posts: 1283 Location: Oregon
|
Posted: Sun Oct 24, 2004 9:52 pm Post subject: |
|
|
Code: |
require('./b2config.php');
require_once($b2inc.'/b2template.functions.php');
require_once($b2inc.'/b2functions.php');
require_once($b2inc.'/b2vars.php');
|
These lines must be at the very top of the file before ANY HTML tags. _________________ Michael P.
 |
|
Back to top |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB 2 © 2001, 2002 phpBB Group
|