File: /home/awaldron/public_html/archive/demo/admin/pages_layout.php
<?php
session_start();
if (!isset($_SESSION["p"])) $_SESSION["p"] = $_GET["p"];
if (isset($_GET["p"]) && ($_GET["p"] != $_SESSION["p"])) {
$username = $_SESSION["auth_user"];
session_unset();
$_SESSION["auth_user"] = $username;
$_SESSION["p"] = $_GET["p"];
}
function get_used_modules($col) {
$used = array(1,2,5,12,13); $ctr = 5;
for ($j=0; $j < count($_SESSION["col".$col]); $j++) {
$used[$ctr] = $_SESSION["col".$col][$j]["mod_id"];
$ctr++;
}
return $used;
}
function get_used_boards() {
$used = array(); $ctr = 0;
for ($j=0; $j < count($_SESSION["col2"]); $j++) {
$used[$ctr] = $_SESSION["col2"][$j]["ntid"];
$ctr++;
}
return $used;
}
function module_select($col) {
$used_modules = get_used_modules($col);
$sql = "SELECT * FROM tbl_modules";
$res = mysql_query($sql);
echo "<option>--Select a Module--</option>\n";
while ($row = mysql_fetch_array($res)) {
if (!in_array($row["mod_id"],$used_modules)) echo "<option value=\"".$row["mod_id"]."\">".$row["mod_title"]."</option>\n";
}
}
function notice_select() {
$used_boards = get_used_boards();
$sql = "SELECT * FROM tbl_notice_types ORDER BY notice_type_name ASC";
$res = mysql_query($sql);
echo "<option>--Select a Noticeboard / Forum--</option>\n";
while ($row = mysql_fetch_array($res)) {
if (!in_array($row["notice_type_id"],$used_boards)) echo "<option value=\"".$row["notice_type_id"]."\">".$row["notice_type_name"]."</option>\n";
}
}
include("../_functions.php");
dbconnect();
if (!is_logged()) auto_login();
echo "<html>\n";
echo "<head>\n";
echo "<title>".COMPANY_NAME." : Web Page Layout</title>\n";
echo "<script language=\"JavaScript\" type=\"text/javascript\">\n";
echo "<!--\n";
echo "function openWindow(theURL,winName,features) { //v2.0\n";
echo " window.open(theURL,winName,features);\n";
echo "}\n";
echo "-->\n";
echo "</script>\n";
echo "</head>\n";
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../default.css\">\n";
echo "<body style=\"margin:15px;\">\n";
if (!admin_panel($_SESSION["auth_user"])) {
echo "<br><br><br><br>".error("You must be logged in to access the administration panel!");
} else {
if (isset($_GET["commit"])) {
if (quickUPDATE("DELETE FROM tbl_layout WHERE page_id=".$_SESSION["p"]) === FALSE) echo "<br>DELETE FAILED";
if (quickUPDATE("UPDATE tbl_pages SET page_body_display=".$_SESSION["page_body_display"].", page_cols=".$_SESSION["page_cols"]." WHERE page_id=".$_SESSION["p"]) === FALSE) echo "<br>PAGE RECORD UPDATE FAILED";
for ($i=1; $i <= 3; $i++) {
$n = "col".(string)$i;
for ($j=0; $j < count($_SESSION[$n]); $j++) {
$ins = "INSERT INTO tbl_layout (page_id,mod_id,lo_side,lo_rank,ntid,ntid_display) VALUES (".$_SESSION["p"].",".$_SESSION[$n][$j]["mod_id"].",".$_SESSION[$n][$j]["lo_side"].",".$_SESSION[$n][$j]["lo_rank"].",".$_SESSION[$n][$j]["ntid"].",".$_SESSION[$n][$j]["ntid_display"].")";
quickUPDATE($ins);
}
}
}
if (isset($_GET["reset2def"])) {
quickUPDATE("DELETE FROM tbl_layout WHERE page_id=".$_SESSION["p"]);
$pbd = quickSQL("SELECT page_body_display FROM tbl_pages WHERE page_id=0");
$pcols = quickSQL("SELECT page_cols FROM tbl_pages WHERE page_id=0");
quickUPDATE("UPDATE tbl_pages SET page_body_display=".$pbd.", page_cols=".$pcols." WHERE page_id=".$_SESSION["p"]);
$username = $_SESSION["auth_user"];
$pid = $_SESSION["p"];
session_unset();
$_SESSION["auth_user"] = $username;
$_SESSION["p"] = $pid;
}
if ($_GET["act"] == "wpprops") {
$_SESSION["page_body_display"] = $_GET["page_body_display"];
$_SESSION["page_cols"] = $_GET["page_cols"];
}
if ($_GET["act"] == "move") {
$temp = $_SESSION["col".$_GET["column"]][$_GET["mod1"]];
$_SESSION["col".$_GET["column"]][$_GET["mod1"]] = $_SESSION["col".$_GET["column"]][$_GET["mod2"]];
$_SESSION["col".$_GET["column"]][$_GET["mod2"]] = $temp;
$_SESSION["col".$_GET["column"]][$_GET["mod1"]]["lo_rank"] = ($_GET["mod1"] + 1);
$_SESSION["col".$_GET["column"]][$_GET["mod2"]]["lo_rank"] = ($_GET["mod2"] + 1);
}
if ($_GET["act"] == "addtocol") {
$i = count($_SESSION["col".$_GET["column"]]);
$_SESSION["col".$_GET["column"]][$i]["loid"] = 0;
$_SESSION["col".$_GET["column"]][$i]["page_id"] = $_SESSION["p"];
$_SESSION["col".$_GET["column"]][$i]["mod_id"] = $_GET["mod_id"];
$_SESSION["col".$_GET["column"]][$i]["lo_side"] = $_GET["column"];
$_SESSION["col".$_GET["column"]][$i]["lo_rank"] = $i+1;
$_SESSION["col".$_GET["column"]][$i]["ntid"] = 0;
$_SESSION["col".$_GET["column"]][$i]["ntid_display"] = 0;
}
if ($_GET["act"] == "addboard") {
$i = count($_SESSION["col2"]);
$_SESSION["col2"][$i]["loid"] = 0;
$_SESSION["col2"][$i]["page_id"] = $_SESSION["p"];
$_SESSION["col2"][$i]["mod_id"] = 13;
$_SESSION["col2"][$i]["lo_side"] = 2;
$_SESSION["col2"][$i]["lo_rank"] = $i+1;
$_SESSION["col2"][$i]["ntid"] = $_GET["ntid"];
$_SESSION["col2"][$i]["ntid_display"] = 10;
}
if ($_GET["act"] == "notice_display") {
$_SESSION["col2"][$_GET["row"]]["ntid_display"] = $_GET["notice_disp"];
}
if ($_GET["act"] == "del") {
for ($i=0; $i < (count($_SESSION["col".$_GET["column"]])-1); $i++) {
$copy = $i+1;
if ($i >= $_GET["mod"]) {
$_SESSION["col".$_GET["column"]][$i] = $_SESSION["col".$_GET["column"]][$copy];
$_SESSION["col".$_GET["column"]][$i]["lo_rank"]--;
}
}
$unset = count($_SESSION["col".$_GET["column"]]) - 1;
unset($_SESSION["col".$_GET["column"]][$unset]);
}
echo "<P><img src=\"/gui/icons/cog.gif\" align=\"left\">\n";
echo "<div class=\"headline\">Web Page Layout</div>\n";
echo "<P>From this control panel, you have the ability to edit the layout of this webpage.\n";
if (!isset($_SESSION["page_title"]) && !isset($_SESSION["page_body_display"]) && !isset($_SESSION["page_cols"])) {
$sql = "SELECT * FROM tbl_pages WHERE page_id=".$_SESSION["p"];
$res = mysql_query($sql);
if (mysql_num_rows($res) == 1) {
extract(mysql_fetch_array($res));
$_SESSION["page_title"] = $page_title;
$_SESSION["page_body_display"] = $page_body_display;
$_SESSION["page_cols"] = $page_cols;
}
}
echo "<center><br><br><br><span class=\"headline\">".$_SESSION["page_title"]."</span>\n";
echo "<form action=\"pages_layout.php\" method=\"get\" name=\"layoutform\">\n";
echo "<input type=\"hidden\" name=\"act\" value=\"wpprops\">\n";
echo "<P><table class=\"textdn\" border=0><tr><td width=250>\n";
echo "<table class=\"textdn\" border=0 cellspacing=2 cellpadding=2 width=100% style=\"background:#FFFFFF;border:solid 2px #000000;\">\n";
echo "<tr><td colspan=4 align=\"center\"><b style=\"color:#".COLOR_TBAR."\">WEB PAGE PROPERTIES</b></td></tr>\n";
echo "<tr><td colspan=4><img src=\"/gui/black.gif\" width=100% height=1></td></tr>\n";
echo "<tr><td colspan=4><b>Display Page Body?</b> <SELECT name=\"page_body_display\" onChange=\"document.layoutform.submit()\"><option value=\"1\"".($_SESSION["page_body_display"]==1?" SELECTED":"").">Yes</option><option value=\"0\"".($_SESSION["page_body_display"]==0?" SELECTED":"").">No</option></SELECT></td></tr>";
echo "<tr><td><b>Page Layout:</b></td><td><input type=\"radio\" name=\"page_cols\" value=\"3\"".($_SESSION["page_cols"]==3?" CHECKED":"")." onClick=\"document.layoutform.submit()\"></td><td><img src=\"layout3.gif\"></td><td>3 columns</td></tr>\n";
echo "<tr><td> </td><td><input type=\"radio\" name=\"page_cols\" value=\"2\"".($_SESSION["page_cols"]==2?" CHECKED":"")." onClick=\"document.layoutform.submit()\"></td><td><img src=\"layout2.gif\"></td><td>2 columns</td></tr>\n";
echo "<tr><td> </td><td><input type=\"radio\" name=\"page_cols\" value=\"1\"".($_SESSION["page_cols"]==1?" CHECKED":"")." onClick=\"document.layoutform.submit()\"></td><td><img src=\"layout1.gif\"></td><td>1 column</td></tr>\n";
echo "</form>\n";
echo "</table>\n";
echo "</td><td><img src=\"/clear.gif\" width=20 height=1></td><td width=250>\n";
echo "<table class=\"textdn\" border=0 cellspacing=2 cellpadding=2 width=100% style=\"background:#FFFFFF;border:solid 2px #000000;\">\n";
echo "<form action=\"pages_layout.php\" method=\"get\">\n";
echo "<tr><td align=\"center\"><b style=\"color:#".COLOR_TBAR."\">FINAL PRODUCT</b></td></tr>\n";
echo "<tr><td align=\"center\"><img src=\"/gui/black.gif\" width=100% height=1></td></tr>\n";
echo "<tr><td align=\"center\">When you're satisfied <img src=\"/gui/clear.gif\" width=1 height=20>with this layout:</td></tr>\n";
echo "<tr><td align=\"center\"><img src=\"/gui/clear.gif\" width=1 height=20><input type=\"submit\" value=\"Commit Layout to Web Page\" name=\"commit\"></td></tr>\n";
echo "<tr><td align=\"center\"><img src=\"/gui/clear.gif\" width=1 height=20>".(isset($_GET["commit"])?"<img src=\"/gui/smiles/icon_biggrin.gif\"> <span style=\"color:#009900;font-size:12px;\"><b>OK!</b></span>":"")."</td></tr>\n";
echo "<tr><td align=\"center\"> </td></tr>\n";
echo "</form>\n";
echo "</table>\n";
echo "</td><td><img src=\"/clear.gif\" width=20 height=1></td><td width=250>\n";
echo "<table class=\"textdn\" border=0 cellspacing=2 cellpadding=2 width=100% style=\"background:#FFFFFF;border:solid 2px #000000;\">\n";
echo "<form action=\"pages_layout.php\" method=\"get\">\n";
echo "<tr><td align=\"center\"><b style=\"color:#".COLOR_TBAR."\">RESTORE DEFAULTS</b></td></tr>\n";
echo "<tr><td align=\"center\"><img src=\"/gui/black.gif\" width=100% height=1></td></tr>\n";
echo "<tr><td align=\"center\">To delete <img src=\"/gui/clear.gif\" width=1 height=20>this layout</td></tr>\n";
echo "<tr><td align=\"center\" valign=\"top\">and restore <img src=\"/gui/clear.gif\" width=1 height=20>default settings</td></tr>\n";
echo "<tr><td align=\"center\"><img src=\"/gui/clear.gif\" width=1 height=20><input type=\"submit\" value=\"Remove Custom Layout\" name=\"reset2def\"".($_SESSION["p"]==0?" DISABLED":"")."></td></tr>\n";
echo "<tr><td align=\"center\"> </td></tr>\n";
echo "</form>\n";
echo "</table>\n";
echo "</td></tr></table>\n";
if (!isset($_SESSION["col1"]) && !isset($_SESSION["col2"]) && !isset($_SESSION["col3"])) {
$sql = "SELECT * FROM tbl_layout WHERE page_id=".$_SESSION["p"]." ORDER BY lo_side ASC, lo_rank ASC";
$res = mysql_query($sql);
if (mysql_num_rows($res) == 0) {
$sql = "SELECT * FROM tbl_layout WHERE page_id=".DEF_LAYOUT." ORDER BY lo_side ASC, lo_rank ASC";
$res = mysql_query($sql);
}
$col1 = $col2 = $col3 = array();
$ctr1 = $ctr2 = $ctr3 = 0;
for ($i=0; $i < mysql_num_rows($res); $i++) {
$row = mysql_fetch_array($res);
if ($row["lo_side"] == 1) { while (list($key, $value) = each($row)) $col1[$ctr1][$key] = $value; $ctr1++; }
else if ($row["lo_side"] == 2) { while (list($key, $value) = each($row)) $col2[$ctr2][$key] = $value; $ctr2++; }
else if ($row["lo_side"] == 3) { while (list($key, $value) = each($row)) $col3[$ctr3][$key] = $value; $ctr3++; }
}
$_SESSION["col1"] = $col1;
$_SESSION["col2"] = $col2;
$_SESSION["col3"] = $col3;
}
echo "<br><br><br><table class=\"textdn\" border=0 cellspacing=10 cellpadding=0>\n";
echo "<tr>\n";
// COLUMN ONE - LEFT NAVIGATION //
if ($_SESSION["page_cols"] != 1) {
echo "<td width=150 valign=\"top\">";
for ($i=0; $i < count($_SESSION["col1"]); $i++) {
echo "<div style=\"width:100%;height:85px;text-align:center;vertical-align:middle;background:#DCDCDC;border:solid 2px;\">\n";
echo "<br><b>".quickSQL("SELECT mod_title FROM tbl_modules WHERE mod_id=".$_SESSION["col1"][$i]["mod_id"])."</b><br>";
if ($i != 0) echo "<a href=\"pages_layout.php?act=move&column=1&mod1=".$i."&mod2=".($i-1)."\" class=\"small\">Move Up</a>";
if (($i != 0) && ($i != (count($_SESSION["col1"])-1))) echo " | ";
if ($i != (count($_SESSION["col1"])-1)) echo "<a href=\"pages_layout.php?act=move&column=1&mod1=".$i."&mod2=".($i+1)."\" class=\"small\">Move Down</a>";
echo "<br><a href=\"pages_layout.php?act=del&column=1&mod=".$i."\" class=\"small\">Remove Module</a>";
echo "</div>\n<P>\n";
}
echo "<form action=\"pages_layout.php\" method=\"get\" name=\"addcol1\">\n";
echo "<input type=\"hidden\" name=\"act\" value=\"addtocol\">\n";
echo "<input type=\"hidden\" name=\"column\" value=\"1\">\n";
echo "<center><b>Add a module:</b><br><SELECT name=\"mod_id\" onChange=\"document.addcol1.submit()\">\n";
echo module_select(1);
echo "</SELECT></center>\n";
echo "</form>\n";
echo "</td>";
}
// COLUMN TWO - MAIN BODY //
if ($_SESSION["page_cols"] == 1) echo "<td width=\"770\" valign=\"top\">";
else if ($_SESSION["page_cols"] == 2) echo "<td width=\"610\" valign=\"top\">";
else if ($_SESSION["page_cols"] == 3) echo "<td width=\"450\" valign=\"top\">";
if ($_SESSION["page_body_display"]==1) {
echo "<div style=\"width:100%;height:200px;text-align:center;vertical-align:middle;background:#DCDCDC;border:solid 2px;\">\n";
echo "<br><b><span style=\"color:#".COLOR_TBAR."\">- Page Body -</span><br>".$_SESSION["page_title"]."</b>";
echo "</div>\n<P>\n";
}
for ($i=0; $i < count($_SESSION["col2"]); $i++) {
echo "<div style=\"width:100%;height:200px;text-align:center;vertical-align:middle;background:#DCDCDC;border:solid 2px;\">\n";
if ($_SESSION["col2"][$i]["mod_id"] == 13) echo "<br><b>".quickSQL("SELECT notice_type_name FROM tbl_notice_types WHERE notice_type_id=".$_SESSION["col2"][$i]["ntid"])."</b><br>";
else echo "<br><b>".quickSQL("SELECT mod_title FROM tbl_modules WHERE mod_id=".$_SESSION["col2"][$i]["mod_id"])."</b><br>";
if ($_SESSION["col2"][$i]["mod_id"] == 13) {
echo "<table class=\"textdn\" border=0><tr><form action=\"pages_layout.php\" method=\"get\" name=\"notice_display\">\n";
echo "<input type=\"hidden\" name=\"act\" value=\"notice_display\">\n";
echo "<input type=\"hidden\" name=\"row\" value=\"".$i."\">\n";
echo "<td>Number of Notices to display:</td><td><input type=\"text\" size=2 maxlength=2 name=\"notice_disp\" value=\"".$_SESSION["col2"][$i]["ntid_display"]."\"> <input type=\"submit\" value=\"go\"></td></form></tr></table>\n";
}
if ($i != 0) echo "<a href=\"pages_layout.php?act=move&column=2&mod1=".$i."&mod2=".($i-1)."\" class=\"small\">Move Up</a>";
if (($i != 0) && ($i != (count($_SESSION["col2"])-1))) echo " | ";
if ($i != (count($_SESSION["col2"])-1)) echo "<a href=\"pages_layout.php?act=move&column=2&mod1=".$i."&mod2=".($i+1)."\" class=\"small\">Move Down</a>";
echo "<br><a href=\"pages_layout.php?act=del&column=2&mod=".$i."\" class=\"small\">Remove Module</a>";
echo "</div>\n<P>\n";
}
echo "<form action=\"pages_layout.php\" method=\"get\" name=\"addboard\">\n";
echo "<input type=\"hidden\" name=\"act\" value=\"addboard\">\n";
echo "<center><b>Add a Noticeboard / Discussion Forum:</b><br><SELECT name=\"ntid\" onChange=\"document.addboard.submit()\">\n";
echo notice_select();
echo "</SELECT></form></center>\n";
echo "<P><form action=\"pages_layout.php\" method=\"get\" name=\"addcol2\">\n";
echo "<input type=\"hidden\" name=\"act\" value=\"addtocol\">\n";
echo "<input type=\"hidden\" name=\"column\" value=\"2\">\n";
echo "<center><b>Add a module:</b><br><SELECT name=\"mod_id\" onChange=\"document.addcol2.submit()\">\n";
echo module_select(2);
echo "</SELECT></center>\n";
echo "</form>\n";
echo "</td>";
// COLUMN THREE - RIGHT NAV //
if ($_SESSION["page_cols"] == 3) {
echo "<td width=150 valign=\"top\">";
for ($i=0; $i < count($_SESSION["col3"]); $i++) {
echo "<div style=\"width:100%;height:85px;text-align:center;vertical-align:middle;background:#DCDCDC;border:solid 2px;\">\n";
echo "<br><b>".quickSQL("SELECT mod_title FROM tbl_modules WHERE mod_id=".$_SESSION["col3"][$i]["mod_id"])."</b><br>";
if ($i != 0) echo "<a href=\"pages_layout.php?act=move&column=3&mod1=".$i."&mod2=".($i-1)."\" class=\"small\">Move Up</a>";
if (($i != 0) && ($i != (count($_SESSION["col3"])-1))) echo " | ";
if ($i != (count($_SESSION["col3"])-1)) echo "<a href=\"pages_layout.php?act=move&column=3&mod1=".$i."&mod2=".($i+1)."\" class=\"small\">Move Down</a>";
echo "<br><a href=\"pages_layout.php?act=del&column=3&mod=".$i."\" class=\"small\">Remove Module</a>";
echo "</div>\n<P>\n";
}
echo "<form action=\"pages_layout.php\" method=\"get\" name=\"addcol3\">\n";
echo "<input type=\"hidden\" name=\"act\" value=\"addtocol\">\n";
echo "<input type=\"hidden\" name=\"column\" value=\"3\">\n";
echo "<center><b>Add a module:</b> <SELECT name=\"mod_id\" onChange=\"document.addcol3.submit()\">\n";
echo module_select(3);
echo "</SELECT></center>\n";
echo "</form>\n";
echo "</td>";
}
echo "</tr></table></center>\n";
echo "<br><br><br><br>\n";
echo "<center>Powered by <a href=\"http://www.intrabreeze.com\">IntraBreeze</a> © 2005 IntraBreeze, LLC</center>\n";
//echo "<pre>";
//print_r($col2);
//echo "</pre>";
}
echo "</body>\n</html>\n";
?>