File: /home/awaldron/www/archive/demo/guidebook/content_edit.php
<?php
session_start();
include("../_functions.php");
echo dbconnect();
force_login();
$admin = is_admin();
$gbadmins = quickSQL("SELECT pgroup_id FROM tbl_guidebooks WHERE gb_id=".$_GET[gb]);
$sql = "SELECT * FROM tbl_pages WHERE page_id=".$_GET["p"];
$result = mysql_query($sql);
$p = mysql_fetch_array($result);
$psql = "SELECT gbtab_name FROM tbl_gbtabs WHERE gbtab_id=".$p["gbtab_id"];
$pres = mysql_query($psql);
$parent = mysql_fetch_array($pres);
$page_title = "Edit Content";
$lnav_mods = array("empdir","leftnav","buzzword");
$rnav_mods = array();
if (!isset($_POST["post"])) {
$bbjava = true;
$disable_cbody = false;
}
include("_gbheader.php");
if (!check_pgroup($_SESSION[auth_user],$gbadmins)) { // CHECK IF USER ATTEMPTING THE EDIT IS AUTHORIZED TO EDIT
echo "<br><br><br>".error("You do not have the proper privileges to edit this notice.")."<br><br><br>";
echo "<center><a href=\"/content.php?p=".$_GET["p"]."\"><< Go Back</a></center><br><br><br>";
} else {
if (isset($_POST["post"])) { // IF POST IS BEING SUBMITTED
$query = "UPDATE tbl_pages SET ";
$query .= "username='".$_POST["username"]."', ";
$query .= "page_title='".$_POST["page_title"]."', ";
$query .= "page_body='".$_POST["message"]."', ";
$query .= "page_updated='".now()."', ";
$query .= "page_active=".$_POST["page_active"].", ";
$query .= "gb_clink=".$_POST["gb_clink"]." ";
$query .= "WHERE page_id=".$_POST["page_id"];
echo "<center><img src=\"/gui/vci_logob.gif\"><br><br><br><br>";
$result = mysql_query($query);
if ($result > 0) {
echo "<b>Your changes have been submitted successfully.</b>\n";
echo "<P><a href=\"".$_POST["update_url"]."\">Back to ".$_POST["page_title"]."</a><br><br><br><br>\n";
} else {
echo "<P>".$query;
echo error("There was an error while confirming your changes.");
echo error(mysql_error());
echo "<br><br><br><br>";
}
}
if (!isset($_POST["post"])) {
$preview = FALSE;
if (isset($_POST["preview"])) { // IF POST IS BEING PREVIEWED
$preview = TRUE;
echo "<br><center><div style=\"width:95%;text-align:left;\"><span style=\"font-size:14px\"><b>Preview of Your Page:</b></span><br>\n";
echo "<div style=\"width:100%;text-align:left;border:solid 1px #999999;padding:10px;\">\n";
echo "<div id=\"stamp\"><span class=\"headline\">".stripslashes($parent["gbtab_name"])."</span></div>\n";
echo "<table border=0 cellspacing=10 class=\"main\">\n";
echo "<tr><td valign=\"top\">\n";
echo "<P><span class=\"subhead\">".stripslashes($_POST["page_title"])."</span><P>\n";
echo format_body($_POST["message"]);
echo "</td></tr></table>\n";
echo "</div></center>\n";
}
echo "<center>\n";
if (!$preview) echo "<br><br><b>Use this form to edit page content.</b>\n";
echo "<form action=\"content_edit.php?gb=".$gb."&tab=".$tab."&p=".$_GET["p"]."\" method=\"post\" name=\"post\" onSubmit=\"MM_validateForm('username','','R');return document.MM_returnValue\">\n";
echo "<input type=\"hidden\" name=\"page_updated\" value=\"".now()."\">\n";
echo "<input type=\"hidden\" name=\"page_id\" value=\"".$_GET["p"]."\">\n";
echo "<input type=\"hidden\" name=\"update_url\" value=\"/guidebook/page.php?gb=".$gb."&tab=".$tab."&p=".$_GET["p"]."\">\n";
if (!$admin) echo "<input type=\"hidden\" name=\"username\" value=\"".$_SESSION["auth_user"]."\">\n";
echo "<P><table border=\"0\" cellpadding=\"3\" cellspacing=\"1\">\n";
echo "<tr><td><b>Delete Page?</b></td><td><SELECT name=\"page_active\" onMouseOver=\"helpline('del')\"><option value=\"1\" SELECTED>No</option><option value=\"0\">Yes</option></SELECT></td>\n";
echo "<td rowspan=4 valign=\"top\">\n";
echo "<table width=200 border=0 cellpadding=3 cellspacing=2 bgcolor=\"#".dbVAR("color_tbar")."\">\n";
echo "<tr class=\"header\"><td><b>Advanced Edit:</b></td></tr>\n";
echo "<tr><td bgcolor=\"#".dbVAR("color_bg")."\"> <img src=\"/gui/bullet.gif\"> <a href=\"#\" onClick=\"openWindow('/content_edit_owners.php?p=".$_GET["p"]."','','resizable=yes,width=500,height=350')\">Add/Remove Owners</a><br><br></td></tr>\n";
echo "</table>\n";
echo "</td>\n";
echo "</tr>\n";
if ($admin) echo "<tr><td><b>Username</b></td><td><input type=\"text\" name=\"username\" size=\"45\" maxlength=\"32\" style=\"width:250px\" value=\"".$p["username"]."\" onMouseOver=\"helpline('un')\"></td></tr>\n";
else echo "<tr><td><b>Username</b></td><td><input type=\"text\" name=\"dummy_username\" size=\"45\" maxlength=\"32\" style=\"width:250px\" value=\"".$_SESSION["auth_user"]."\" onMouseOver=\"helpline('un')\" DISABLED></td></tr>\n";
echo "<tr><td><b>Guidebook Tab:</b></td><td><input type=\"text\" name=\"parentname\" style=\"width:250px\" value=\"".$parent["gbtab_name"]."\" DISABLED></td></tr>\n";
echo "<tr><td><b>Page Title</b></td><td><input type=\"text\" name=\"page_title\" size=\"45\" maxlength=\"255\" style=\"width:250px\" value=\"".(!$preview?stripslashes($p["page_title"]):stripslashes($_POST["page_title"]))."\" onMouseOver=\"helpline('pt')\"></td></tr>\n";
echo "<tr><td colspan=2><b>Grab Page Content from Page ID </b><input type=\"text\" name=\"gb_clink\" onChange=\"disableCBody()\" size=\"6\" maxlength=\"5\" value=\"".(!$preview?($p["gb_clink"]?$p["gb_clink"]:0):$_POST["gb_clink"])."\" />".($p["gb_clink"]>0?" -> <a href=\"/content_edit.php?p=".$p["gb_clink"]."\">Jump to Edit Page id=".$p["gb_clink"]."</a>":"")."</td></tr>\n";
//echo "<tr><td><b>Open in New Window?</b></td><td><SELECT name=\"page_window\" onMouseOver=\"helpline('win')\"><option value=\"0\"".(!$preview?($p["page_window"]==0?" SELECTED":""):($_POST["page_window"]==0?" SELECTED":"")).">No</option><option value=\"1\"".(!$preview?($p["page_window"]==1?" SELECTED":""):($_POST["page_window"]==1?" SELECTED":"")).">Yes</option></SELECT></td></tr>\n";
echo "<tr><td colspan=3> </td></tr>\n";
echo "<tr><td valign=\"top\" colspan=3><b>Page Body</b> : <a href=\"#\" onClick=\"openWindow('/button_buddy.php','','resizable=yes,width=650,height=425')\">Need help? Click Here to Open the Button Buddy</a></td></tr>\n";
echo "<tr><td colspan=3 class=\"row2\" valign=\"top\" bgcolor=\"#EBEFF5\" style=\"border:solid 1px #999999;\">\n";
// ROW: Font Color, Font Size, Upload/Insert
// ROW: BBCode Buttons
// ROW: Tips
echo "<table border=\"0\" cellspacing=\"5\" cellpadding=\"0\">\n";
echo "<tr><td colspan=6>Font color: \n";
echo " <select name=\"addbbcode24\" onChange=\"bbfontstyle('[color=' + this.form.addbbcode24.options[this.form.addbbcode24.selectedIndex].value + ']', '[/color]');this.selectedIndex=0;\" onMouseOver=\"helpline('s')\">\n";
echo " <option style=\"color:black; background-color: #F2F6F9\" value=\"#000000\">Default</option>\n";
echo " <option style=\"color:darkred; background-color: #F2F6F9\" value=\"darkred\">Dark Red</option>\n";
echo " <option style=\"color:red; background-color: #F2F6F9\" value=\"red\">Red</option>\n";
echo " <option style=\"color:#FF8800; background-color: #F2F6F9\" value=\"orange\">Orange</option>\n";
echo " <option style=\"color:brown; background-color: #F2F6F9\" value=\"brown\">Brown</option>\n";
echo " <option style=\"color:green; background-color: #F2F6F9\" value=\"green\">Green</option>\n";
echo " <option style=\"color:olive; background-color: #F2F6F9\" value=\"olive\">Olive</option>\n";
echo " <option style=\"color:blue; background-color: #F2F6F9\" value=\"blue\">Blue</option>\n";
echo " <option style=\"color:darkblue; background-color: #F2F6F9\" value=\"darkblue\">Dark Blue</option>\n";
echo " <option style=\"color:indigo; background-color: #F2F6F9\" value=\"indigo\">Indigo</option>\n";
echo " <option style=\"color:violet; background-color: #F2F6F9\" value=\"violet\">Violet</option>\n";
echo " <option style=\"color:black; background-color: #F2F6F9\" value=\"black\">Black</option>\n";
echo " </select> Font size:<select name=\"addbbcode22\" onChange=\"bbfontstyle('[size=' + this.form.addbbcode22.options[this.form.addbbcode22.selectedIndex].value + ']', '[/size]');this.selectedIndex=1;\" onMouseOver=\"helpline('f')\">\n";
echo " <option value=\"9\">Small</option>\n";
echo " <option value=\"11\" selected>Normal</option>\n";
echo " <option value=\"14\">Large</option>\n";
echo " <option value=\"18\">Extra Large</option>\n";
echo " <option value=\"22\">Headline</option>\n";
echo " </select>\n";
echo " </td>\n";
echo " <td colspan=5 nowrap=\"nowrap\" align=\"right\">Upload/Insert: <a href=\"#\" onClick=\"openWindow('upload/index.php?a=content','','resizable=yes,width=600,height=300')\" onMouseOver=\"helpline('upin')\">Image</a> | <a href=\"#\" onClick=\"openWindow('upload/index.php?a=doc','','resizable=yes,width=600,height=300')\" onMouseOver=\"helpline('upin')\">File</a><!-- a href=\"javascript:bbstyle(-1)\" onMouseOver=\"helpline('a')\">Close Tags</a --></td>\n";
echo "</tr>\n";
echo "<tr align=\"center\" valign=\"middle\"> \n";
echo "<td><input type=\"button\" class=\"button\" name=\"addbbcode0\" value=\"Bold\" style=\"font-weight:bold; width:45px\" onClick=\"bbstyle(0)\" onMouseOver=\"helpline('b')\" /></td>\n";
echo "<td><input type=\"button\" class=\"button\" name=\"addbbcode2\" value=\"Italic\" style=\"font-style:italic; width:55px\" onClick=\"bbstyle(2)\" onMouseOver=\"helpline('i')\" /></td>\n";
echo "<td><input type=\"button\" class=\"button\" name=\"addbbcode4\" value=\"Under\" style=\"text-decoration: underline; width:55px\" onClick=\"bbstyle(4)\" onMouseOver=\"helpline('u')\" /></td>\n";
echo "<td><input type=\"button\" class=\"button\" name=\"addbbcode18\" value=\"Center\" style=\"width: 55px\" onClick=\"bbstyle(18)\" onMouseOver=\"helpline('cntr')\" /></td>\n";
echo "<td><input type=\"button\" class=\"button\" name=\"addbbcode6\" value=\"Quote\" style=\"width: 50px\" onClick=\"bbstyle(6)\" onMouseOver=\"helpline('q')\" /></td>\n";
echo "<td><input type=\"button\" class=\"button\" name=\"addbbcode8\" value=\"Code\" style=\"width: 40px\" onClick=\"bbstyle(8)\" onMouseOver=\"helpline('c')\" /></td>\n";
echo "<td><input type=\"button\" class=\"button\" name=\"addbbcode10\" value=\"BL\" style=\"width: 35px\" onClick=\"bbstyle(10)\" onMouseOver=\"helpline('l')\" /></td>\n";
echo "<td><input type=\"button\" class=\"button\" name=\"addbbcode12\" value=\"NL\" style=\"width: 35px\" onClick=\"bbstyle(12)\" onMouseOver=\"helpline('o')\" /></td>\n";
echo "<td><input type=\"button\" class=\"button\" name=\"addbbcode14\" value=\"Img\" style=\"width: 40px\" onClick=\"bbstyle(14)\" onMouseOver=\"helpline('p')\" /></td>\n";
echo "<td><input type=\"button\" class=\"button\" name=\"addbbcode16\" value=\"URL\" style=\"text-decoration: underline; width: 40px\" onClick=\"bbstyle(16)\" onMouseOver=\"helpline('w')\" /></td>\n";
echo "<td><input type=\"button\" class=\"button\" name=\"addbbcode20\" value=\"File\" style=\"width: 45px\" onClick=\"bbstyle(20)\" onMouseOver=\"helpline('file')\" /></td>\n";
echo "</tr>\n";
echo "<tr><td colspan=\"11\" align=\"left\"> <input type=\"text\" name=\"helpbox\" size=\"45\" maxlength=\"100\" style=\"color:#006600;width:445px;font-size:10px;background:transparent;border:0px;\" class=\"helpline\" value=\"Tip: Styles can be applied quickly to selected text.\" /></td></tr>\n";
echo "</table>\n";
// MAIN BODY TEXTAREA
echo "<script language=\"JavaScript\">\n";
echo "<!-- Hide\n";
echo "var w = (getWidth()-350);\n";
echo "if (w<650) w=650;\n";
echo "var h = (w / 2);\n";
echo "document.write('<textarea name=\"message\" id=\"postbox\" wrap=\"virtual\" style=\"font:12px courier new, courier;width:'+w+'px;height:'+h+'px;\" tabindex=\"3\" onselect=\"storeCaret(this);\" onclick=\"storeCaret(this);\" onkeyup=\"storeCaret(this);backslashReplace();\">');\n";
echo "-->\n";
echo "</script>\n";
echo (!$preview?$p["page_body"]:stripslashes($_POST["message"]));
echo "</textarea>\n";
// Smilies
echo "<table border=0><tr>";
echo "<td><b>Insert Smiley:</b> </td><td>";
echo "<a href=\"javascript:emoticon(':biggrin:')\"><img src=\"/gui/smiles/icon_biggrin.gif\" border=\"0\" alt=\"Very Happy\" title=\"Very Happy\" /></a> ";
echo "<a href=\"javascript:emoticon(':smile:')\"><img src=\"/gui/smiles/icon_smile.gif\" border=\"0\" alt=\"Smile\" title=\"Smile\" /></a> ";
echo "<a href=\"javascript:emoticon(':sad:')\"><img src=\"/gui/smiles/icon_sad.gif\" border=\"0\" alt=\"Sad\" title=\"Sad\" /></a> ";
echo "<a href=\"javascript:emoticon(':surprised:')\"><img src=\"/gui/smiles/icon_surprised.gif\" border=\"0\" alt=\"Surprised\" title=\"Surprised\" /></a> ";
echo "<a href=\"javascript:emoticon(':shock:')\"><img src=\"/gui/smiles/icon_eek.gif\" border=\"0\" alt=\"Shocked\" title=\"Shocked\" /></a> ";
echo "<a href=\"javascript:emoticon(':confused:')\"><img src=\"/gui/smiles/icon_confused.gif\" border=\"0\" alt=\"Confused\" title=\"Confused\" /></a> ";
echo "<a href=\"javascript:emoticon(':shades:')\"><img src=\"/gui/smiles/icon_cool.gif\" border=\"0\" alt=\"Cool\" title=\"Cool\" /></a> ";
echo "<a href=\"javascript:emoticon(':lol:')\"><img src=\"/gui/smiles/icon_lol.gif\" border=\"0\" alt=\"Laughing\" title=\"Laughing\" /></a> ";
echo "<a href=\"javascript:emoticon(':mad:')\"><img src=\"/gui/smiles/icon_mad.gif\" border=\"0\" alt=\"Mad\" title=\"Mad\" /></a> ";
echo "<a href=\"javascript:emoticon(':razz:')\"><img src=\"/gui/smiles/icon_razz.gif\" border=\"0\" alt=\"Razz\" title=\"Razz\" /></a> ";
echo "<a href=\"javascript:emoticon(':oops:')\"><img src=\"/gui/smiles/icon_redface.gif\" border=\"0\" alt=\"Embarassed\" title=\"Embarassed\" /></a> ";
echo "<a href=\"javascript:emoticon(':cry:')\"><img src=\"/gui/smiles/icon_cry.gif\" border=\"0\" alt=\"Crying or Very sad\" title=\"Crying or Very sad\" /></a> ";
echo "<a href=\"javascript:emoticon(':evil:')\"><img src=\"/gui/smiles/icon_evil.gif\" border=\"0\" alt=\"Evil or Very Mad\" title=\"Evil or Very Mad\" /></a> ";
echo "<a href=\"javascript:emoticon(':twisted:')\"><img src=\"/gui/smiles/icon_twisted.gif\" border=\"0\" alt=\"Twisted Evil\" title=\"Twisted Evil\" /></a> ";
echo "<a href=\"javascript:emoticon(':roll:')\"><img src=\"/gui/smiles/icon_rolleyes.gif\" border=\"0\" alt=\"Rolling Eyes\" title=\"Rolling Eyes\" /></a> ";
echo "<a href=\"javascript:emoticon(':wink:')\"><img src=\"/gui/smiles/icon_wink.gif\" border=\"0\" alt=\"Wink\" title=\"Wink\" /></a> ";
echo "<a href=\"javascript:emoticon(':exclaim:')\"><img src=\"/gui/smiles/icon_exclaim.gif\" border=\"0\" alt=\"Exclamation\" title=\"Exclamation\" /></a> ";
echo "<a href=\"javascript:emoticon(':question:')\"><img src=\"/gui/smiles/icon_question.gif\" border=\"0\" alt=\"Question\" title=\"Question\" /></a> ";
echo "<a href=\"javascript:emoticon(':idea:')\"><img src=\"/gui/smiles/icon_idea.gif\" border=\"0\" alt=\"Idea\" title=\"Idea\" /></a> ";
echo "<a href=\"javascript:emoticon(':arrow:')\"><img src=\"/gui/smiles/icon_arrow.gif\" border=\"0\" alt=\"Arrow\" title=\"Arrow\" /></a> ";
echo "</td></tr></table>\n";
// Preview & Submit Buttons
echo "<P><center><input type=\"submit\" name=\"preview\" value=\" Preview \"> <input type=\"submit\" name=\"post\" value=\" Submit \" /></center>\n";
echo "</td></tr></table>\n";
echo "</form>\n";
echo "</center>\n";
}
} // END PERMISSION ELSE
include("_gbfooter.php");
?>