Menu
▾
▴
#1 Table Prefixes
You forgot to add the table prefix into a few files.
Below are the corrected versions:
(This list isn't full, I will submit more as I find them)
install.php:
<?php
require_once './config.php';
require_once './mysql.php';
global $db, $dbh;
$sql[0]="CREATE TABLE {$db['prefix']}content
(`id` int(255) not null AUTO_INCREMENT,
`main` varchar(255) not null,
`pagetitle` varchar(255) not null,
`menu` varchar(255) not null,
PRIMARY KEY (`id`))";
$sql[1]="CREATE TABLE {$db['prefix']}settings
(`title` varchar(255) not null,
`copyright` text not null,
`menu` text not null)";
$sql[2]="CREATE TABLE {$db['prefix']}template
(`bgcolour` varchar(255) not null,
`bordercolour` varchar(255) not null,
`font` varchar(255) not null)";
$sql[3] = "INSERT INTO {$db['prefix']}content (id,
main, pagetitle, menu) VALUES('1', 'Welcome to Bolt
Content Manager', 'Bolt Content Manager', 'yes')";
$sql[4] = "INSERT INTO {$db['prefix']}settings (title,
copyright) VALUES('Bolt Content Manager', 'Copyright
Bruce Bolt')";
$sql[5] = "INSERT INTO {$db['prefix']}template
(bgcolour, bordercolour, font) VALUES('FFCC67',
'D70000', 'Abadi MT Condensed')";
$sql[6]= "CREATE TABLE {$db['prefix']}members
(`USERNAME` varchar(255) not null,
`PASSWORD` varchar(255) not null)";
$sql[7] = "INSERT INTO `members` (`USERNAME` ,
`PASSWORD`) VALUES ('admin', 'password')";
foreach ($sql as $query)
{
echo 'Sending query: '.$query.' ... ';
if (mysql_query($query, $dbh) === FALSE)
{
echo '<b>Error - Not done!</b><br />Unable to
query mySQL database: '.mysql_error().'<br />';
continue;
}
echo '<b>Done</b><br />';
}
die('<b>Installation successful!</b>');
?>
uninstall.php:
<?php
require_once './config.php';
require_once './mysql.php';
$sql[0] = "DROP TABLE `{$db['prefix']}content`";
$sql[1] = "DROP TABLE `{$db['prefix']}settings`";
$sql[2] = "DROP TABLE `{$db['prefix']}template`";
$sql[3] = "DROP TABLE `{$db['prefix']}members`";
foreach ($sql as $query)
{
echo 'Sending query: '.$query.' ... ';
if (mysql_query($query, $dbh) === FALSE)
{
echo '<b>×</b><br />Unable to query mySQL
database: '.mysql_error().'<br />';
continue;
}
echo '<b>√</b><br />';
}
die('<b>Uninstallation successful!</b>');
?>
optimise.php:
<?php
if ($_SESSION['logged_on'] == TRUE) {
require_once './config.php';
require_once './mysql.php';
$sql[0] = "OPTIMIZE TABLE {$db['prefix']}content";
$sql[1] = "OPTIMIZE TABLE {$db['prefix']}settings";
$sql[2] = "OPTIMIZE TABLE {$db['prefix']}template";
foreach ($sql as $query)
{
echo 'Sending query: '.$query.' ... ';
if (mysql_query($query, $dbh) === FALSE)
{
echo '<b>×</b><br />Unable to query mySQL
database: '.mysql_error().'<br />';
continue;
}
echo '<b>Done</b><br />';
}
echo '<b>If you see no errors above optimisation is
complete!</b>';
} else {
echo('YOU ARE NOT LOGGED IN');
}
?>
addcontent.php:
<?php
if ($_SESSION['logged_on'] == TRUE) {
include("mysql.php");
$newtitle = $_GET['pagetitle'];
$newmain = $_GET['main'];
$menu = $_GET['menu'];
$result = mysql_query("INSERT INTO
{$db['prefix']}content (main, pagetitle, menu)
VALUES('$newmain', '$newtitle', '$menu')") or
die(mysql_error());
echo('The following information has been added to the
database:');
echo('<br />Page Title: ');
echo $newtitle;
echo('<br />Content: ');
echo $newmain;
} else {
echo('YOU ARE NOT LOGGED IN');
}
?>
admin.php:
<?php
require_once("mysql.php");
session_start();
if (isset($_GET['logout'])) {
$_SESSION = array();
session_destroy();
echo('You are logged out<br><a href="admin.php">Admin
Home</a>');
} else {
if ($_SESSION['logged_on'] == TRUE) {
?>
<html>
<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Admin Panel</title>
</head>
<body text="#008080" link="#008080" vlink="#008080"
alink="#008080">
<p align="center"><font size="5" face="Tahoma"
color="#008080">Bolt Content
Manager<br>
Administration Panel</font></p>
<table border="0" width="100%">
<tr>
<td width="20%">
<p align="center"><font size="2" face="Tahoma"
color="#008080"><a
href="processrequest.php?act=06"><img border="0"
src="images/add.png"><br>
Add Page</a></font></td>
<td width="20%">
<p align="center"><font size="2" face="Tahoma"
color="#008080"><a
href="processrequest.php?act=07"><img border="0"
src="images/page.png"><br>
Edit Pages</a></font></td>
<td width="20%">
<p align="center"><font size="2" face="Tahoma"
color="#008080"><a
href="processrequest.php?act=07"><img border="0"
src="images/pagedelete.png"></a></font><a
href="processrequest.php?act=07"><font face="Tahoma"
size="2"><br>
Delete Pages</font></a></td>
<td width="20%">
<p align="center"><font size="2" face="Tahoma"
color="#008080"><a href="processrequest.php?act=12">General
Settings</a></font></td>
<td width="20%">
<p align="center"><font size="2" face="Tahoma"
color="#008080"><a
href="processrequest.php?act=04"><img border="0"
src="images/optimise.png"><br>
Optimise Database</a></font></td>
</tr>
<tr>
<td width="20%" align="center"><font face="Tahoma"
color="#008080"><font size="2">[COMING
SOON]</font><br>
<font size="2">Administrators</font></font></td>
<td width="20%" align="center"><font face="Tahoma"
color="#008080" size="2"><a
href="processrequest.php?act=16">Check
Version</a></font></td>
<td width="20%" align="center">
<p align="center"><font size="2" face="Tahoma"
color="#008080"><a
href="processrequest.php?act=08"><img border="0"
src="images/styles.png"><br>
Page Style</a></font></td>
<td width="20%" align="center"></td>
<td width="20%" align="center"><font face="Tahoma"
color="#008080" size="2"><a
href="admin.php?logout">LOGOUT</a></font></td>
</tr>
</table>
<p align="center"><font size="2" face="Tahoma">Software
copyright Bruce Bolt<br>
Protected under the GNU General Public License<br>
Images copyright Michael Hodgson</font></p>
</body>
</html>
<?php
} else {
function printform() {
echo('
<form action="admin.php" method="POST" name="login">
Username: <input type="text" name="uname" /><br>
Password: <input type="password" name="password" /><br>
<input type="submit" value="Login" name="submit" />
</form>');
}
// if the form hgas been submitted
if(isset($_POST['submit'])) {
// get the input from the form
$funame = $_POST['uname'];
$fpassword = $_POST['password'];
// check to see if the name exists
$sql= mysql_query("SELECT * FROM
`{$db['prefix']}members` WHERE USERNAME = '$funame'");
$myrow = mysql_fetch_array($sql);
if ($myrow['USERNAME']) {
if ($myrow['PASSWORD'] == $fpassword) {
$uname = $funame;
$logged_on = TRUE;
$_SESSION['logged_on'] = 'TRUE';
echo "You are now logged in as $uname.<br> <a
href='admin.php'>Please click here to proceed to the
admin panel!</a>";
} else {
echo "<font color='#FF0000'>Sorry the password is
incorrect.</font><br><br>";
printform();
}
} else {
echo "<font color='#FF0000'>Sorry that username does
not exist.</font><br><br>";
printform();
}
// otherwise print the form out onto the page
} else {
printform();
}
}
}
?>
delete.php:
<?php
if ($_SESSION['logged_on'] == TRUE) {
//Connect to database
include("mysql.php");
//Get information
$id = $_GET['id'];
//Insert into database
$result1 = mysql_query("DELETE from
{$db['prefix']}content WHERE id='$id' LIMIT 1") or
die(mysql_error());
//Display information to user
echo('The page has been deleted:<br />ID: ');
echo $id;
echo('<br /><a href="adminmain.php">Admin Home</a>');
} else {
echo('YOU ARE NOT LOGGED IN');
}
?>
Logged In: YES
user_id=1172331
Thank you!
Will do later when I have time.
Version 1.1.2 will be released in a few days.