Installing a php script to a BV page

Adrian29630 · #1 08-20-2009, 02:17 AM

I am trying to install a php script into a BV page which only has the template already in place but for some reason no matter which way I try it is ending up on the underlying page and therefore the form is not visible. It is there because if I strip out the template the form is visible but I am trying to place it into a page identical to the rest of the site. I have tried both putting the script onto the page in BV and opening the script in Cp
anel and installing the HTML but either method has the same result. This is the script:-

<FONT size=1><?php
/*************** PHP LOGIN SCRIPT V2.0*********************
(c) Balakrishnan 2009. All Rights Reserved
Usage: This script can be used FREE of charge for any commercial or personal projects. Enjoy!
Limitations:
- This script cannot be sold.
- This script should have copyright notice intact. Dont remove it please...
- This script may not be provided for download except from its original site.
For further usage, please contact me.
************************************************** *********/
include 'dbc.php';
　
if ($_POST['doLogin']=='Login')
{
$user_email = mysql_real_escape_string($_POST['usr_email']);
$md5pass = md5(mysql_real_escape_string($_POST['pwd']));
　
if (strpos($user_email,'@') === false) {
$user_cond = "user_name='$user_email'";
} else {
$user_cond = "user_email='$user_email'";

}
　
$sql = "SELECT `id`,`full_name`,`approved` FROM users WHERE
$user_cond
AND `pwd` = '$md5pass' AND `banned` = '0'
";

$result = mysql_query($sql) or die (mysql_error());
$num = mysql_num_rows($result);
// Match row found with more than 1 results - the user is authenticated.
if ( $num > 0 ) {

list($id,$full_name,$approved) = mysql_fetch_row($result);

if(!$approved) {
$msg = "Account not activated. Please check your email for activation code";
header("Location: login.php?msg=$msg");
exit();
}

// this sets session and logs user in

session_start();
// this sets variables in the session
$_SESSION['user_id']= $id;
$_SESSION['user_name'] = $full_name;

//set a cookie witout expiry until 60 days

if(isset($_POST['remember'])){
setcookie("user_id", $_SESSION['user_id'], time()+60*60*24*60, "/");
setcookie("user_name", $_SESSION['user_name'], time()+60*60*24*60, "/");
}

header("Location: myaccount.php");
}
else
{
$msg = urlencode("Invalid Login. Please try again with correct user email and password. ");
header("Location: login.php?msg=$msg");
}

}

?>
<html>
<head>
<title>Members Login</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
<script language="JavaScript" type="text/javascript" src="js/jquery.validate.js"></script>
<script>
$(document).ready(function(){
$("#logForm").validate();
});
</script>
<link href="styles.css" rel="stylesheet" type="text/css">
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="5" class="main">
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td width="160" valign="top"><p> </p>
<p>  </p>
<p> </p>
<p> </p>
<p> </p></td>
<td width="732" valign="top"><p> </p>
<h3 class="titlehdr">Login Users
</h3>
<p>
<?
/******************** ERROR MESSAGES****************************************** *******
This code is to show error messages
************************************************** ************************/
if (isset($_GET['msg'])) {
$msg = mysql_real_escape_string($_GET['msg']);
echo "<div class=\"msg\">$msg</div>";
}
/******************************* END ********************************/
?></p>
<form action="login.php" method="post" name="logForm" id="logForm" >
<table width="65%" border="0" cellpadding="4" cellspacing="4" class="loginform">
<tr>
<td colspan="2"> </td>
</tr>
<tr>
<td width="28%">Username / Email</td>
<td width="72%"><input name="usr_email" type="text" class="required" id="txtbox" size="25"></td>
</tr>
<tr>
<td>Password</td>
<td><input name="pwd" type="password" class="required password" id="txtbox" size="25"></td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input name="remember" type="checkbox" id="remember" value="1">
Remember me</div></td>
</tr>
<tr>
<td colspan="2"> <div align="center">
<p>
<input name="doLogin" type="submit" id="doLogin3" value="Login">
</p>
<p><a href="register.php">Register Free</a><font color="#FF6600">
|</font> <a href="forgot.php">Forgot Password</a> <font color="#FF6600">
|</font> <a href="activate.php">Activate Account</a></p>
<p><span style="font: normal 9px verdana">Powered by <a href="http://php-login-script.com">PHP
Login Script v2.0</a></span></p>
</div></td>
</tr>
</table>
<div align="center"></div>
<p align="center">  </p>
</form>
<p> </p>

</td>
<td width="196" valign="top"> </td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
</table>
<?php
/*

I have also tried putting it in an HTML box which partially works as the form is visible but so is a part of the coding but not all of it just:-

0 ) { list($id,$full_name,$approved) = mysql_fetch_row($result); if(!$approved) { $msg = "Account not activated. Please check your email for activation code"; header("Location: login.php?msg=$msg"); exit(); } // this sets session and logs user in session_start(); // this sets variables in the session $_SESSION['user_id']= $id; $_SESSION['user_name'] = $full_name; //set a cookie witout expiry until 60 days if(isset($_POST['remember'])){ setcookie("user_id", $_SESSION['user_id'], time()+60*60*24*60, "/"); setcookie("user_name", $_SESSION['user_name'], time()+60*60*24*60, "/"); } header("Location: myaccount.php"); } else { $msg = urlencode("Invalid Login. Please try again with correct user email and password. "); header("Location: login.php?msg=$msg"); } } ?>

Login Users

Karen Mac · #2 08-20-2009, 05:21 AM

Did you right click on the page, page properties and change it to be a php instead of html?

Karen

Adrian29630 · #3 08-20-2009, 06:16 AM

Hi Karen I did that right at the begining but it still shows that piece of script which as you can see is only a small part of the whole. That is what is so strange about it

Karen Mac · #4 08-20-2009, 07:56 AM

link to the page please

Karen

Adrian29630 · #5 08-20-2009, 04:47 PM

Hi Karen
I hadn't published the page because of what appeared in the preview pane so in order to send you the link I had to publish it and when I checked the link I was going to give you lo and behold when published it is perfect!!! So it seems the script only displays itself in "preview" Weird! Anyway all seems now to be ok.

By the way this is a very good login script if you want to check it out, very clear installation instructions, easy to install, simple to amend if needed etc and it is free! The link is http://www.hotscripts.com/listing/ph...-script-80993/ As I know there have been many requests for forms of this nature it may well be worth adding it somewhere easy to find in BV's list of useful add-on's

Thanks for your very quick responses by the way as without them I would still have been struggling with this. Now I can move on with it.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)