File: /home/awaldron/www/archive/demo/functions/_form.php
<?php
function employee_select($selected="",$emp_only=0) {
$sql = "SELECT username, fname, lname FROM tbl_employees WHERE is_employee=1 AND ".($emp_only==1?"emp_type_id <= 3":"emp_type_id <> 7")." ORDER BY lname ASC";
$res = mysql_query($sql);
echo "<option></option>\n";
for ($j=0; $j < mysql_num_rows($res); $j++) {
$u = mysql_fetch_array($res);
echo "<option value=\"".$u["username"]."\"".($u["username"]==$selected?" SELECTED":"").">".$u[lname].", ".$u[fname]."</option>\n";
}
}
function group_select($parent=0,$base=0,$gid=0) {
$defgrp = DEF_GROUP;
$sql = "SELECT * FROM tbl_groups WHERE group_parent=".$parent." ORDER BY group_name ASC";
$res = mysql_query($sql);
if (mysql_num_rows($res) > 0) {
for ($i=0; $i < mysql_num_rows($res); $i++) {
$row = mysql_fetch_array($res);
if (isset($GLOBALS["delgrp"]) && ($GLOBALS["delgrp"]==$row["group_id"])) ;
else {
if ($base == 0) echo "<option value=".$defgrp."></option>\n";
echo "<option value=\"".$row["group_id"]."\"".(in_array($row["group_id"],$gid)?" SELECTED":"").($row["group_id"]==$gid?" SELECTED":"").">";
if ($base == 2) echo "+ ";
else { for ($j=0; $j < $base; $j++) echo "-"; echo " "; }
echo $row["group_name"];
echo "</option>\n";
if ($base == 0) echo "<option value=".$defgrp.">---------------------------</option>\n";
}
group_select($row["group_id"],($base+2),$gid);
}
}
}
function input_hidden($name,$value) {
return "<input type=\"hidden\" name=\"".$name."\" value=\"".$value."\">\n";
}
function input_submit($name="",$value="") {
return "<input type=\"submit\" name=\"".$name."\" value=\"".$value."\">";
}
function ins_textarea($value="",$preview=0,$upload=1,$filebut=1,$smilies=1,$w=0,$h=0) {
$autosize = FALSE;
if (($w === 0) && ($h === 0)) $autosize = TRUE;
// ROW: Font Color, Font Size, Upload/Insert
// ROW: BBCode Buttons
// ROW: Tips
$out .= "<table border=\"0\" cellspacing=\"5\" cellpadding=\"0\">\n";
$out .= "<tr><td colspan=6>Font color: \n";
$out .= " <select name=\"addbbcode24\" onChange=\"bbfontstyle('[color=' + this.form.addbbcode24.options[this.form.addbbcode24.selectedIndex].value + ']', '[/color]');this.selectedIndex=0;\" onMouseOver=\"helpline('s')\">\n";
$out .= " <option style=\"color:black; background-color: #F2F6F9\" value=\"#000000\">Default</option>\n";
$out .= " <option style=\"color:darkred; background-color: #F2F6F9\" value=\"darkred\">Dark Red</option>\n";
$out .= " <option style=\"color:red; background-color: #F2F6F9\" value=\"red\">Red</option>\n";
$out .= " <option style=\"color:#FF8800; background-color: #F2F6F9\" value=\"orange\">Orange</option>\n";
$out .= " <option style=\"color:brown; background-color: #F2F6F9\" value=\"brown\">Brown</option>\n";
$out .= " <option style=\"color:green; background-color: #F2F6F9\" value=\"green\">Green</option>\n";
$out .= " <option style=\"color:olive; background-color: #F2F6F9\" value=\"olive\">Olive</option>\n";
$out .= " <option style=\"color:blue; background-color: #F2F6F9\" value=\"blue\">Blue</option>\n";
$out .= " <option style=\"color:darkblue; background-color: #F2F6F9\" value=\"darkblue\">Dark Blue</option>\n";
$out .= " <option style=\"color:indigo; background-color: #F2F6F9\" value=\"indigo\">Indigo</option>\n";
$out .= " <option style=\"color:violet; background-color: #F2F6F9\" value=\"violet\">Violet</option>\n";
$out .= " <option style=\"color:black; background-color: #F2F6F9\" value=\"black\">Black</option>\n";
$out .= " </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";
$out .= " <option value=\"9\">Small</option>\n";
$out .= " <option value=\"11\" selected>Normal</option>\n";
$out .= " <option value=\"14\">Large</option>\n";
$out .= " <option value=\"18\">Extra Large</option>\n";
$out .= " <option value=\"22\">Headline</option>\n";
$out .= " </select>\n";
$out .= " </td>\n";
if ($upload) {
$out .= " <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";
} else {
$out .= " <td colspan=5 nowrap=\"nowrap\" align=\"right\"><a href=\"#\" onClick=\"openWindow('/button_buddy.php','','resizable=yes,width=650,height=425')\">Help</a></td>\n";
}
$out .= "</tr>\n";
$out .= "<tr align=\"center\" valign=\"middle\"> \n";
$out .= "<td><input type=\"button\" class=\"button\" name=\"addbbcode0\" value=\"Bold\" style=\"font-weight:bold; width:45px\" onClick=\"bbstyle(0)\" onMouseOver=\"helpline('b')\" /></td>\n";
$out .= "<td><input type=\"button\" class=\"button\" name=\"addbbcode2\" value=\"Italic\" style=\"font-style:italic; width:55px\" onClick=\"bbstyle(2)\" onMouseOver=\"helpline('i')\" /></td>\n";
$out .= "<td><input type=\"button\" class=\"button\" name=\"addbbcode4\" value=\"Under\" style=\"text-decoration: underline; width:55px\" onClick=\"bbstyle(4)\" onMouseOver=\"helpline('u')\" /></td>\n";
$out .= "<td><input type=\"button\" class=\"button\" name=\"addbbcode18\" value=\"Center\" style=\"width: 55px\" onClick=\"bbstyle(18)\" onMouseOver=\"helpline('cntr')\" /></td>\n";
$out .= "<td><input type=\"button\" class=\"button\" name=\"addbbcode6\" value=\"Quote\" style=\"width: 50px\" onClick=\"bbstyle(6)\" onMouseOver=\"helpline('q')\" /></td>\n";
$out .= "<td><input type=\"button\" class=\"button\" name=\"addbbcode8\" value=\"Code\" style=\"width: 40px\" onClick=\"bbstyle(8)\" onMouseOver=\"helpline('c')\" /></td>\n";
$out .= "<td><input type=\"button\" class=\"button\" name=\"addbbcode10\" value=\"BL\" style=\"width: 35px\" onClick=\"bbstyle(10)\" onMouseOver=\"helpline('l')\" /></td>\n";
$out .= "<td><input type=\"button\" class=\"button\" name=\"addbbcode12\" value=\"NL\" style=\"width: 35px\" onClick=\"bbstyle(12)\" onMouseOver=\"helpline('o')\" /></td>\n";
$out .= "<td><input type=\"button\" class=\"button\" name=\"addbbcode14\" value=\"Img\" style=\"width: 40px\" onClick=\"bbstyle(14)\" onMouseOver=\"helpline('p')\" /></td>\n";
$out .= "<td><input type=\"button\" class=\"button\" name=\"addbbcode16\" value=\"URL\" style=\"text-decoration: underline; width: 40px\" onClick=\"bbstyle(16)\" onMouseOver=\"helpline('w')\" /></td>\n";
$out .= "<td><input type=\"button\" class=\"button\" value=\"Help\" style=\"width:45px;background:#FDF3BD;\" onClick=\"openWindow('/button_buddy.php','','resizable=yes,width=650,height=425')\" onMouseOver=\"helpline('help')\" /></td>\n";
$out .= "</tr>\n";
$out .= "<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";
$out .= "</table>\n";
// MAIN BODY TEXTAREA
$out .= "<script language=\"JavaScript\">\n";
$out .= "<!-- Hide\n";
if ($autosize) {
$out .= "var w = (getWidth()-350);\n";
$out .= "if (w<650) w=650;\n";
$out .= "var h = (w / 2);\n";
} else {
$out .= "var w = ".$w.";\n";
$out .= "var h = ".$h.";\n";
}
$out .= "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";
$out .= "-->\n";
$out .= "</script>\n";
$out .= (!$preview?$value:stripslashes($value));
$out .= "</textarea>\n";
if ($smilies == 1) {
// Smilies
$out .= "<table border=0><tr>";
$out .= "<td><b>Insert Smiley:</b> </td><td>";
$out .= "<a href=\"javascript:emoticon(':biggrin:')\"><img src=\"gui/smiles/icon_biggrin.gif\" border=\"0\" alt=\"Very Happy\" title=\"Very Happy\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':smile:')\"><img src=\"gui/smiles/icon_smile.gif\" border=\"0\" alt=\"Smile\" title=\"Smile\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':sad:')\"><img src=\"gui/smiles/icon_sad.gif\" border=\"0\" alt=\"Sad\" title=\"Sad\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':surprised:')\"><img src=\"gui/smiles/icon_surprised.gif\" border=\"0\" alt=\"Surprised\" title=\"Surprised\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':shock:')\"><img src=\"gui/smiles/icon_eek.gif\" border=\"0\" alt=\"Shocked\" title=\"Shocked\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':confused:')\"><img src=\"gui/smiles/icon_confused.gif\" border=\"0\" alt=\"Confused\" title=\"Confused\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':shades:')\"><img src=\"gui/smiles/icon_cool.gif\" border=\"0\" alt=\"Cool\" title=\"Cool\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':lol:')\"><img src=\"gui/smiles/icon_lol.gif\" border=\"0\" alt=\"Laughing\" title=\"Laughing\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':mad:')\"><img src=\"gui/smiles/icon_mad.gif\" border=\"0\" alt=\"Mad\" title=\"Mad\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':razz:')\"><img src=\"gui/smiles/icon_razz.gif\" border=\"0\" alt=\"Razz\" title=\"Razz\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':oops:')\"><img src=\"gui/smiles/icon_redface.gif\" border=\"0\" alt=\"Embarassed\" title=\"Embarassed\" /></a> ";
$out .= "<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> ";
$out .= "<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> ";
$out .= "<a href=\"javascript:emoticon(':twisted:')\"><img src=\"gui/smiles/icon_twisted.gif\" border=\"0\" alt=\"Twisted Evil\" title=\"Twisted Evil\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':roll:')\"><img src=\"gui/smiles/icon_rolleyes.gif\" border=\"0\" alt=\"Rolling Eyes\" title=\"Rolling Eyes\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':wink:')\"><img src=\"gui/smiles/icon_wink.gif\" border=\"0\" alt=\"Wink\" title=\"Wink\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':exclaim:')\"><img src=\"gui/smiles/icon_exclaim.gif\" border=\"0\" alt=\"Exclamation\" title=\"Exclamation\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':question:')\"><img src=\"gui/smiles/icon_question.gif\" border=\"0\" alt=\"Question\" title=\"Question\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':idea:')\"><img src=\"gui/smiles/icon_idea.gif\" border=\"0\" alt=\"Idea\" title=\"Idea\" /></a> ";
$out .= "<a href=\"javascript:emoticon(':arrow:')\"><img src=\"gui/smiles/icon_arrow.gif\" border=\"0\" alt=\"Arrow\" title=\"Arrow\" /></a> ";
$out .= "</td></tr></table>\n";
}
return $out;
}
function page_select($parent=0,$base=0,$pid=0,$pass=1) {
$is_active = quickSQL("SELECT page_active FROM tbl_pages WHERE page_id=".$pid);
if (($is_active == 0) && ($pass == 1)) echo "<option value=\"".$pid."\" SELECTED>x ".quickSQL("SELECT page_title FROM tbl_pages WHERE page_id=".$pid)." (inactive)</option>\n";
$pass++;
$sql = "SELECT * FROM tbl_pages WHERE parent_id=".$parent." AND page_active=1 AND gbtab_id=0 ORDER BY page_rank ASC";
$res = mysql_query($sql);
if (mysql_num_rows($res) > 0) {
for ($i=0; $i < mysql_num_rows($res); $i++) {
$row = mysql_fetch_array($res);
if ($row["page_id"] != 0) {
if (($parent == 1) || ($parent == 0)) echo "<option value=\"0\"></option>\n";
echo "<option value=\"".$row["page_id"]."\"".($pid==$row["page_id"]?" SELECTED":"").">";
if ($base == 2) echo "+ ";
else { for ($j=0; $j < $base; $j++) echo "-"; echo " "; }
if ($row["page_id"] == 1) echo "Intranet Home (".$row["page_title"].")";
else echo $row["page_title"];
echo "</option>\n";
if ($base == 0) echo "<option value=\"0\">---------------------------</option>\n";
page_select($row["page_id"],($base+2),$pid,$pass++);
}
}
} else echo "<P>".$sql."<P>".mysql_error();
}
?>