Hello!
I have made a catalogue editor for my PHP-Retro, and I thought I could share it with you!
Installation is easy.
1. Make a file in the housekeeping-folder named catalogue.php.
2. Insert this code into the file:
PHP Code:
<?php
/*================================================================+\
|| # PHPRetro - An extendable virtual hotel site and management
|+==================================================================
|| # Copyright (C) 2009 Yifan Lu. All rights reserved.
|| # http://www.yifanlu.com
|| # Parts Copyright (C) 2009 Meth0d. All rights reserved.
|| # http://www.meth0d.org
|| # Catalogue-script made by RetroDonald
|| # Script Copyright (C) 2009-2010 RetroDonald. All Rights Reserved.
|| # All images, scripts, and layouts
|| # Copyright (C) 2009 Sulake Ltd. All rights reserved.
|+==================================================================
|| # PHPRetro is provided "as is" and comes without
|| # warrenty of any kind. PHPRetro is free software!
|| # License: GNU Public License 3.0
|| # http://opensource.org/licenses/gpl-license.php
\+================================================================*/
$page['dir'] = '\housekeeping';
$page['housekeeping'] = true;
$page['rank'] = 5;
require_once('../includes/core.php');
require_once('./includes/hksession.php');
$lang->addLocale("housekeeping.news");
$page['name'] = $lang->loc['pagename.news'];
$page['category'] = "tools";
require_once('./templates/housekeeping_header.php');
?>
<div class="page_title">
<img src="<?php echo PATH; ?>/housekeeping/images/icons/<?php echo $icon; ?>" class="pticon">
<span class="page_name_shadow">Catalogue</span>
<span class="page_name">Catalogue</span>
</div>
<div class="page_main">
<table border="0" cellpadding="0" cellspacing="0" height="100%">
<tbody>
<tr height="100%" />
<td class="page_main_left">
<div class="left_date"><?php echo date('l F j, Y | g:iA'); ?></div>
<div class="hr"></div>
<div class="text">
<?php echo $description; ?>
</div>
</td>
<td class="page_main_right">
<div class="center">
<?php
if(!$_GET[edit] && !$_GET[fjern] && !$_GET[mobler] && !$_GET[mobeledit] && !$_GET[mobellag] && !$_GET[lag]){
echo("Here, you can edit the catalogue! Choose a catagory to edit. You can edit the furnis inside too....<br><a href='?lag=lag'>Add Catagory</a><br><a href='?mobellag=lag'>Add Furni</a><br>");
$rar = mysql_query("SELECT * FROM catalogue_pages ORDER BY indexid"); ?>
<table height="100%"><tbody>
<tr class="header">
<th width="50">IndexID</th>
<th width="300">IndexNAME</th>
<th width="50">Number of furniture</th>
<th width="50">Minimum rank</th>
<th width="50"></th>
</tr><?php
while($m = mysql_fetch_array($rar)){
$t = mysql_query("SELECT * FROM catalogue_items WHERE catalogue_id_page='$m[indexid]'");
$num = mysql_num_rows($t);
echo("<tr><td width='50'>$m[indexid]</td>
<td width='300'>$m[displayname]</td>
<td width='50'>$num</td>
<td width='50'>$m[minrank]</td>
<td width='50' class='action'><a href='?edit=$m[indexid]'><img src='images/icons/edit.png'></a><a href='?fjern=$b[indexid]'><img src='images/icons/remove.png'></a></td></tr>");
}
echo("</tbody></table>");
}
if($_GET[edit]){
if($_POST[submit]){
mysql_query("UPDATE catalogue_pages SET indexname='$_POST[indexname]', displayname='$_POST[displayname]', style_layout='$_POST[style_layout]', img_header='$_POST[img_header]', img_side='$_POST[img_side]', label_description='$_POST[label_description]', label_misc='$_POST[label_misc]', label_moredetails='$_POST[label_moredetails]' WHERE indexid='$_GET[edit]'");
echo("The catagory was updated!");
}else{
$rar = mysql_query("SELECT * FROM catalogue_pages WHERE indexid='$_GET[edit]'");
$t = mysql_fetch_array($rar);
echo("<form method='post'><table><tr><td width='50%'>Indexname: </td><td width='50%'><input value='$t[indexname]' type='text' name='indexname'></td></tr>
<tr><td width='50%'>Displayname: </td><td width='50%'><input value='$t[displayname]' type='text' name='displayname'></td></tr>
<tr><td width='50%'>Style_Layout: </td><td width='50%'><input value='$t[style_layout]' type='text' name='style_layout'></td></tr>
<tr><td width='50%'>Img_Header: </td><td width='50%'><input value='$t[img_header]' type='text' name='img_header'></td></tr>
<tr><td width='50%'>Img_Side: </td><td width='50%'><input value='$t[img_side]' type='text' name='img_side'></td></tr>
<tr><td width='50%'>Label_Description: </td><td width='50%'><textarea style='width: 200px; height: 100px;' name='label_description'>$t[label_description]</textarea></td></tr>
<tr><td width='50%'>Label_Misc: </td><td width='50%'><textarea style='width: 200px; height: 100px;' name='label_misc'>$t[label_misc]</textarea></td></tr>
<tr><td width='50%'>Label_Moredetails: </td><td width='50%'><textarea style='width: 200px; height: 100px;' name='label_moredetails'>$t[label_moredetails]</textarea></td></tr>
<tr><td width='50%'>Furnitures: </td><td width='50%'><a href='?mobler=$_GET[edit]'>Show Furniture</a></td></tr>
<br><input type='submit' name='submit' value='Update'>
</table></form>
");
}
}
if($_GET[mobler]){
echo("Here is the furnis in the catagory! Click one of them to edit it.<br>");
$rar = mysql_query("SELECT * FROM catalogue_items WHERE catalogue_id_page='$_GET[mobler]'");
while($m = mysql_fetch_array($rar)){
echo("<a href='?mobeledit=$m[tid]'>$m[catalogue_name]</a><br>");
}
}
if($_GET[mobeledit]){
$rar = mysql_query("SELECT * FROM catalogue_items WHERE tid='$_GET[mobeledit]'");
$t = mysql_fetch_array($rar);
if($_POST[submit]){
mysql_query("UPDATE catalogue_items SET catalogue_name='$_POST[catalogue_name]', name_cct='$_POST[name_cct]', recycleable='$_POST[recycleable]', catalogue_description='$_POST[catalogue_description]', catalogue_cost='$_POST[catalogue_cost]', catalogue_id_page='$_POST[catalogue_id_page]', door='$_POST[door]', tradeable='$_POST[tradeable]' WHERE tid='$_GET[mobeledit]'");
echo("The furni was updated!<br><br>");
} echo("
<table height='100%'><tbody><form method='post'>
</tr><td width='50%'>Name</td>
<td width='50%'><input type='text' name='catalogue_name' value='$t[catalogue_name]'></td></tr>
</tr><td width='50%'>Description</td>
<td width='50%'><input type='text' name='catalogue_description' value='$t[catalogue_description]'></td></tr>
</tr><td width='50%'>Price</td>
<td width='50%'><input type='text' name='catalogue_cost' value='$t[catalogue_cost]'></td></tr>
</tr><td width='50%'>Page</td>
<td width='50%'><select name='catalogue_id_page'><option>$t[catalogue_id_page]</option>");
$rar = mysql_query("SELECT * FROM catalogue_pages ORDER BY indexid");
while($l = mysql_fetch_array($rar)){
echo("<option value='$l[indexid]'>$l[displayname]</option>");
}
echo("</select></td></tr>
</tr><td width='50%'>Door</td>
<td width='50%'><select name='door'><option>$t[door]</option><option value='0'>No</option><option value='1'>Yes</option></select></td></tr>
</tr><td width='50%'>Tradeable</td>
<td width='50%'><select name='tradeable'><option>$t[tradeable]</option><option value='1'>Yes</option><option value='0'>No</option></select></td></tr>
</tr><td width='50%'>Recycleable</td>
<td width='50%'><select name='recycleable'><option>$t[recycleable]</option><option value='1'>Yes</option><option value='0'>No</option></select></td></tr>
</tr><td width='50%'>CCT-Name</td>
<td width='50%'><input type='text' name='name_cct' value='$t[name_cct]'></td></tr>
</tbody></table><br><input type='submit' name='submit' value='Update'><>
</form>
");
}
if($_GET[mobellag]){
if($_POST[submit]){
mysql_query("INSERT INTO catalogue_items (catalogue_name, name_cct, recycleable, catalogue_description, catalogue_cost, catalogue_id_page, door, tradeable) VALUES ('$_POST[catalogue_name]', '$_POST[name_cct]', '$_POST[recycleable]', '$_POST[catalogue_description]', '$_POST[catalogue_cost]', '$_POST[catalogue_id_page]', '$_POST[door]', '$_POST[tradeable]')");
echo("The furni was made!<br><br>");
} echo("
<table height='100%'><tbody><form method='post'>
</tr><td width='50%'>Name</td>
<td width='50%'><input type='text' name='catalogue_name'></td></tr>
</tr><td width='50%'>Description</td>
<td width='50%'><input type='text' name='catalogue_description'></td></tr>
</tr><td width='50%'>Price</td>
<td width='50%'><input type='text' name='catalogue_cost'></td></tr>
</tr><td width='50%'>Catagory</td>
<td width='50%'><select name='catalogue_id_page'>");
$rar = mysql_query("SELECT * FROM catalogue_pages ORDER BY indexid");
while($l = mysql_fetch_array($rar)){
echo("<option value='$l[indexid]'>$l[displayname]</option>");
}
echo("</select></td></tr>
</tr><td width='50%'>Door</td>
<td width='50%'><select name='door'><option value='0'>No</option><option value='1'>Yes</option></select></td></tr>
</tr><td width='50%'>Tradeable</td>
<td width='50%'><select name='tradeable'><option value='1'>Yes</option><option value='0'>No</option></select></td></tr>
</tr><td width='50%'>Recycleable</td>
<td width='50%'><select name='recycleable'><option value='1'>Yes</option><option value='0'>No</option></select></td></tr>
</tr><td width='50%'>CCT-Name</td>
<td width='50%'><input type='text' name='name_cct'></td></tr>
</tbody></table><br><input type='submit' name='submit' value='Add Furni'><>
</form>
");
}
if($_GET[lag]){
if($_POST[submit]){
$rar = mysql_query("SELECT * FROM catalogue_pages ORDER BY indexid DESC LIMIT 1");
$r = mysql_fetch_array($rar);
$id = $r[indexid] + 1;
mysql_query("INSERT INTO catalogue_pages (indexid, indexname, displayname, style_layout, img_header, img_side, label_description, label_misc, label_moredetails) VALUES ('$id', '$_POST[indexname]', '$_POST[displayname]', '$_POST[style_layout]', '$_POST[img_header]', '$_POST[img_side]', '$_POST[label_description]', '$_POST[label_misc]', '$_POST[label_moredetails]')");
echo("The catalogue-page was made.");
}else{
echo("<form method='post'><table><tr><td width='50%'>Indexname: </td><td width='50%'><input value='$t[indexname]' type='text' name='indexname'></td></tr>
<tr><td width='50%'>Displayname: </td><td width='50%'><input value='$t[displayname]' type='text' name='displayname'></td></tr>
<tr><td width='50%'>Style_Layout: </td><td width='50%'><input value='$t[style_layout]' type='text' name='style_layout'></td></tr>
<tr><td width='50%'>Img_Header: </td><td width='50%'><input value='$t[img_header]' type='text' name='img_header'></td></tr>
<tr><td width='50%'>Img_Side: </td><td width='50%'><input value='$t[img_side]' type='text' name='img_side'></td></tr>
<tr><td width='50%'>Label_Description: </td><td width='50%'><textarea style='width: 200px; height: 100px;' name='label_description'>$t[label_description]</textarea></td></tr>
<tr><td width='50%'>Label_Misc: </td><td width='50%'><textarea style='width: 200px; height: 100px;' name='label_misc'>$t[label_misc]</textarea></td></tr>
<tr><td width='50%'>Label_Moredetails: </td><td width='50%'><textarea style='width: 200px; height: 100px;' name='label_moredetails'>$t[label_moredetails]</textarea></td></tr>
</table><br><input type='submit' name='submit' value='Add Catagory'></form>
");
}
} ?>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<?php require_once('./templates/housekeeping_footer.php');
?>
3. Open up templates/housekeeping-header.php
4. Replace the code with this:
PHP Code:
<?php
/*================================================================+\
|| # PHPRetro - An extendable virtual hotel site and management
|+==================================================================
|| # Copyright (C) 2009 Yifan Lu. All rights reserved.
|| # http://www.yifanlu.com
|| # Parts Copyright (C) 2009 Meth0d. All rights reserved.
|| # http://www.meth0d.org
|| # All images, scripts, and layouts
|| # Copyright (C) 2009 Sulake Ltd. All rights reserved.
|+==================================================================
|| # PHPRetro is provided "as is" and comes without
|| # warrenty of any kind. PHPRetro is free software!
|| # License: GNU Public License 3.0
|| # http://opensource.org/licenses/gpl-license.php
\+================================================================*/
$version = version();
$lang->addLocale("housekeeping.header");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title>PHPRetro Housekeeping: <?php echo $page['name']; ?></title>
<link rel="shortcut icon" href="<?php echo PATH; ?>/housekeeping/favicon.ico" type="image/vnd.microsoft.icon" />
<link rel="stylesheet" href="<?php echo PATH; ?>/housekeeping/images/styles/style.css" type="text/css">
<link rel="stylesheet" href="<?php echo PATH; ?>/housekeeping/images/styles/boxes.css" type="text/css">
<?php if($page['scrollbar'] == true){ ?>
<script type="text/javascript" src="<?php echo PATH; ?>/housekeeping/images/js/jsScroller.js"></script>
<script type="text/javascript" src="<?php echo PATH; ?>/housekeeping/images/js/jsScrollbar.js"></script>
<script type="text/javascript">
var scroller = null;
var scrollbar = null;
</script>
<?php } ?>
<?php if($page['second_scrollbar'] == true){ ?>
<script type="text/javascript" src="<?php echo PATH; ?>/housekeeping/images/js/jsScroller2.js"></script>
<script type="text/javascript" src="<?php echo PATH; ?>/housekeeping/images/js/jsScrollbar2.js"></script>
<script type="text/javascript">
var scroller2 = null;
var scrollbar2 = null;
</script>
<?php } ?>
<script type="text/javascript">
window.onload = function(){
<?php if($page['scrollbar'] == true){ ?>
scroller = new jsScroller(document.getElementById("listview"), 244, 96);
scrollbar = new jsScrollbar (document.getElementById("Scrollbar-Container"), scroller, false);
<?php } ?>
<?php if($page['second_scrollbar'] == true){ ?>
scroller2 = new jsScroller2(document.getElementById("listview2"), 244, 96);
scrollbar2 = new jsScrollbar2 (document.getElementById("Scrollbar2-Container"), scroller2, false);
<?php } ?>
};
</script>
<meta name="build" content="PHPRetro <?php echo $version['version']." ".$version['stable']; ?>" />
</head>
<body>
<div class="panel">
<div class="header_left"> <br /> <br /> <br /><a href="http://www.phpretro.com/"><img src="<?php echo PATH; ?>/housekeeping/images/header_logo.png" alt="PHPRetro"></a></div>
<div class="header_right"><img src="<?php echo PATH; ?>/housekeeping/images/header_tm1.gif"></div>
<div class="panel_title">
<span class="text">PHPRetro <?php echo $version['major'].".".$version['minor']; ?> <?php echo $lang->loc['housekeeping']; ?></span>
<div class="close_button"><a href="<?php echo PATH; ?>/housekeeping/logout"><img src="<?php echo PATH; ?>/housekeeping/images/button_close.gif" alt="<?php echo $lang->loc['logout']; ?>"></a></div>
</div>
<?php if($page['category'] != "login"){ ?>
<div class="panel_header">
<ul <?php if($page['category'] == "dashboard"){ ?>class="selected" <?php } ?>id="item">
<li class="top"><div style="text-align:center"><a href="#"><?php echo $lang->loc['dashboard']; ?></a></div></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/dashboard"><?php echo $lang->loc['home']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/updates"><?php echo $lang->loc['updates']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/logs"><?php echo $lang->loc['logs']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/about"><?php echo $lang->loc['about']; ?></a></li>
</ul>
<div class="border"></div>
<ul <?php if($page['category'] == "settings"){ ?>class="selected" <?php } ?>id="item">
<li class="top"><div style="text-align:center"><a href="#"><?php echo $lang->loc['settings']; ?></a></div></li>
<?php $sql = $db->query("SELECT id,name FROM ".PREFIX."settings_pages ORDER BY `order` ASC");
while($row = $db->fetch_row($sql)){ echo "<li class=\"item\"><a href=\"".PATH."/housekeeping/settings/".$row[0]."\">".$row[1]."</a></li>\n"; }
?>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/cache"><?php echo $lang->loc['cache']; ?></a></li>
</ul>
<div class="border"></div>
<ul <?php if($page['category'] == "tools"){ ?>class="selected" <?php } ?>id="item">
<li class="top"><div style="text-align:center"><a href="#"><?php echo $lang->loc['tools']; ?></a></div></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/banners"><?php echo $lang->loc['banners']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/campaigns"><?php echo $lang->loc['campaigns']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/catalogue"><?php echo $lang->loc['catalogue']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/collectables"><?php echo $lang->loc['collectables']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/faq"><?php echo $lang->loc['faq']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/news"><?php echo $lang->loc['news']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/newsletter"><?php echo $lang->loc['newsletter']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/recommended"><?php echo $lang->loc['recommended']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/vouchers"><?php echo $lang->loc['vouchers']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/catalogue">Catalogue</a></li>
</ul>
<div class="border"></div>
<ul <?php if($page['category'] == "users"){ ?>class="selected" <?php } ?>id="item">
<li class="top"><div style="text-align:center"><a href="#"><?php echo $lang->loc['users']; ?></a></div></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/users"><?php echo $lang->loc['users']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/bans"><?php echo $lang->loc['bans']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/alerts"><?php echo $lang->loc['alerts']; ?></a></li>
<li class="item"><a href="<?php echo PATH; ?>/housekeeping/help"><?php echo $lang->loc['help']; ?></a></li>
</ul>
<div class="border"></div>
</div>
<div class="clear"></div>
<?php } ?>
<div class="topborder"></div>
Then you are done!
You will find the editor under Tools in the menu!
Hope it's useful!
WHOOPS!
This does NOT support languages, you will have to translate the entire file if you want that!
REALLY REALL REALLY SORRY!
Now it should edit only one page...
The same crap happened to me, so I feel sorry for you
Originally Posted by bokeoke12
