boardom Forum Index boardom
b2 message board
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

SQL Error

 
Post new topic   Reply to topic    boardom Forum Index -> Installation issues
View previous topic :: View next topic  
Author Message
richardx



Joined: 16 Oct 2004
Posts: 7

PostPosted: Tue Oct 19, 2004 5:32 pm    Post subject: SQL Error Reply with quote

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 Smile */
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
View user's profile Send private message
Sigg3



Joined: 03 Jul 2003
Posts: 896
Location: Oslo, Norway

PostPosted: Tue Oct 19, 2004 7:49 pm    Post subject: Reply with quote

This is a typical error. Have you searched the forum for "headers already sent by"?
_________________
Sigg3.net - You know you're worth it! | b2 Cafelog Resource Center | Fight my BattleImp!
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
richardx



Joined: 16 Oct 2004
Posts: 7

PostPosted: Tue Oct 19, 2004 8:02 pm    Post subject: Reply with quote

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
View user's profile Send private message
richardx



Joined: 16 Oct 2004
Posts: 7

PostPosted: Tue Oct 19, 2004 9:51 pm    Post subject: Reply with quote

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
View user's profile Send private message
Cyberian75



Joined: 26 Sep 2002
Posts: 1283
Location: Oregon

PostPosted: Sun Oct 24, 2004 9:52 pm    Post subject: Reply with quote

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
View user's profile Send private message AIM Address
Display posts from previous:   
Post new topic   Reply to topic    boardom Forum Index -> Installation issues All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
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