public function display()
{
$array_type = "";
if (is_array($this->_optionsArray[0])) {
$array_type = "multi";
}
if ($this->_dropdown_type == "multi") {
$dd_text = '<select multiple name= "' . $this->_dd_name . '">';
// added benton
} else {
$dd_text = "<select name=\"" . $this->_dd_name . "\">";
}
// Add a first empty line if desired
if ($this->_introselect != "") {
$dd_text .= "<option value=\"\">{$this->_introselect}</option>";
}
$sorter = "";
$current_type = "";
if (!empty($this->_optionsArray)) {
foreach ($this->_optionsArray as $key => $value) {
// deal with multi vs. primitive arrays
if ($array_type == "multi") {
$our_selected = $value[0];
$label = $value[1];
} elseif ($this->_show_keys == TRUE) {
// we want to show both key and value
$our_selected = $key;
$label = $value;
} else {
// show the value in both places
$our_selected = $value;
$label = $value;
}
//print "<p>Our selected = $our_selected || sorter = $sorter || label = $label</p>";
if ($this->_truncation != "") {
$label = Truncate($label, $this->_truncation, '');
}
if ($current_type != $sorter) {
$dd_text .= "<option value=\"\" class=\"dropdown_list\"> -- " . strtoupper($sorter) . " -- </option>";
}
// check if our values are coming in a multidimensional array
if (is_array($this->_selected)) {
if (in_array($our_selected, $this->_selected)) {
$dd_text .= "<option value=\"{$our_selected}\" selected=\"selected\">{$label}</option>";
} else {
$dd_text .= "<option value=\"{$our_selected}\">{$label}</option>";
}
} else {
if ($our_selected === $this->_selected) {
$dd_text .= "<option value=\"{$our_selected}\" selected=\"selected\">{$label}</option>";
} else {
$dd_text .= "<option value=\"{$our_selected}\">{$label}</option>";
}
}
$current_type = $sorter;
}
}
$dd_text .= "</select>";
return $dd_text;
}
public function output($action = "", $view = "public")
{
global $PublicPath;
global $CpanelPath;
// public vs. admin
parent::establishView($view);
// Get librarians associated with this guide
$querier = new Querier();
$qs = "SELECT f.faq_id, question, answer from faq f, faq_subject fs WHERE f.faq_id = fs.faq_id and fs.subject_id = " . $this->_subject_id . " ORDER BY question";
//print $qs;
$faqArray = $querier->query($qs);
if ($faqArray) {
$this->_body = "<ul>";
foreach ($faqArray as $value) {
$short_q = Truncate($value["question"], 150, '');
$this->_body .= "<li><a target=\"_blank\" href=\"{$PublicPath}" . "faq.php?faq_id={$value['0']}\">{$short_q}</a></li>\n";
}
$this->_body .= "</ul>";
} else {
$this->_body = "<p class=\"faq-alert\">" . _("There are no FAQs linked for this guide") . "</p>";
if ($view == "admin") {
$this->_body = "<p class=\"faq-alert\">" . _("There are no FAQs linked for this guide") . "</p>\n <p><i class=\"fa fa-plus-square\"></i> <a href=\"../faq/faq.php?faq_id=&wintype=pop\" class=\"showmedium-reloader\">" . _("Add New FAQ") . "</a></p>";
}
}
parent::assemblePluslet();
return $this->_pluslet;
}
function genTalkBacks($tbArray, $show_response = 1)
{
global $IconPath;
$row_count1 = 0;
$row_count2 = 0;
$colour1 = "evenrow";
$colour2 = "oddrow";
$tb_answer = "";
foreach ($tbArray as $value) {
$row_colour = $row_count2 % 2 ? $colour1 : $colour2;
if ($value[2]) {
$q_from = $value[2];
} else {
$q_from = _("Anonymous");
}
if (isset($show_response) && $show_response == 0) {
$first_div_width = "90%";
$last_mod_tb = "";
} else {
$first_div_width = "45%";
$short_answer = stripslashes(htmlspecialchars_decode(TruncByWord($value["answer"], 15)));
$last_mod_tb = lastModded("talkback", $value["talkback_id"], 0, 1);
}
$short_question = Truncate($value["question"], 200);
if ($last_mod_tb) {
$mod_line = _("--") . $last_mod_tb;
} else {
$mod_line = "";
}
$tb_answer .= "\n <div style=\"clear: both; float: left; padding: 3px 5px; width: 98%;\" class=\"striper {$row_colour}\">\n <div style=\"float: left; width: 32px; max-width: 5%;\"><a class=\"showcustom\" style=\"color: #333;\" href=\"talkback.php?talkback_id={$value['0']}&wintype=pop\"><i class=\"fa fa-pencil fa-lg\" alt=\"" . _("Edit") . "\"></i></a></div>\n <div style=\"float: left; width: {$first_div_width};\">\n <strong>Q:</strong> {$short_question} <span style=\"color: #666; font-size: 10px;\">({$q_from}, {$value['date_formatted']})</span>\n </div>";
if (isset($show_response) && $show_response == 1) {
$tb_answer .= "<div style=\"float: left; width: 45%; margin-left: 4%;\">\n <strong>A:</strong> {$short_answer} <span style=\"color: #666; font-size: 10px;\">{$mod_line}</span>\n </div>\n ";
}
$tb_answer .= "</div>";
$row_count2++;
}
return $tb_answer;
}
public function output($action = "", $view = "public")
{
global $PublicPath;
// public vs. admin
parent::establishView($view);
// Get librarians associated with this guide
$querier = new Querier();
$qs = "SELECT f.faq_id, question, answer from faq f, faq_subject fs WHERE f.faq_id = fs.faq_id and fs.subject_id = " . $this->_subject_id . " ORDER BY question";
//print $qs;
$faqArray = $querier->query($qs);
if ($faqArray) {
$this->_body = "<ul>";
foreach ($faqArray as $value) {
$short_q = Truncate($value[question], 150, '');
$this->_body .= "<li><a target=\"_blank\" href=\"{$PublicPath}" . "faq.php?faq_id={$value['0']}\">{$short_q}</a></li>\n";
}
$this->_body .= "</ul>";
} else {
$this->_body = _("There are no FAQs linked for this guide");
}
parent::assemblePluslet();
return $this->_pluslet;
}
}
} else {
$limit = "";
}
$querierVid = new Querier();
$qVid = "SELECT video_id, title, description, source, foreign_id, duration, date, display, vtags\n\tFROM video\n\tORDER BY video_id DESC\n\t{$limit}";
$vidArray = $querierVid->query($qVid);
$row_count1 = 0;
$row_count2 = 0;
$colour1 = "evenrow";
$colour2 = "oddrow";
$vid_list = "";
if ($vidArray) {
foreach ($vidArray as $value) {
$row_colour1 = $row_count1 % 2 ? $colour1 : $colour2;
$short_title = Truncate($value["title"], 200);
$short_desc = stripslashes(htmlspecialchars_decode(TruncByWord($value["description"], 15)));
$last_revised_line = lastModded("video", $value[0]);
if ($value[7] != "1") {
$activity = " <span style=\"color: #666;\">* " . _("unpublished") . "</span>";
} else {
$activity = "";
}
$vid_list .= "\n <div style=\"clear: both; float: left; padding: 3px 5px; width: 98%;\" class=\"striper {$row_colour1}\">\n <div style=\"pluslet_body\">\n <a class=\"showmedium\" href=\"video.php?video_id={$value['0']}&wintype=pop\"><i class=\"fa fa-pencil fa-lg\" alt=\"" . _("Edit") . "\"></i></a>\n <a href=\"" . $VideoPath . "?video_id={$value['0']}\" target=\"_blank\"><i class=\"fa fa-eye fa-lg\" alt=\"" . _("View") . "\"></i></a>\n </div>\n <div style=\"float: left; width: 90%;\">\n {$short_title} <span style=\"color: #666; font-size: 10px;\">({$last_revised_line})</span> {$activity}\n </div>\n </div>";
$row_count1++;
}
} else {
$vid_list = "<p>" . _("No Videos yet. Grab your camera.") . "</p>";
}
$ingest_body_text = "<a href=\"ingest.php\">" . _("FIND VIDEOS") . "</a>";
$add_metadata_text = "<a href=\"video.php\">" . _("ENTER VIDEO") . "</a>";
function SubstituteValueWorker($a_matches, $s_repl, $b_html = true)
{
/**
* @global FieldManager $SubstituteFields
*/
global $aSubstituteErrors, $SubstituteFields, $SPECIAL_VALUES;
$b_insert_br = true;
// option to put "<br />" tags before newlines in HTML templates
$n_max_chars = 0;
$n_max_lines = 0;
$s_list_sep = $SPECIAL_VALUES['template_list_sep'];
$b_text_subs = false;
$s_name = $a_matches[0];
assert(strlen($s_name) > 1 && $s_name[0] == '$');
$s_name = substr($s_name, 1);
if (($i_len = strlen($s_name)) > 0 && $s_name[0] == '{') {
assert($s_name[$i_len - 1] == '}');
$s_name = substr($s_name, 1, -1);
//
// grab any processing options
//
$a_args = explode(":", $s_name);
$s_name = $a_args[0];
if (($n_args = count($a_args)) > 1) {
for ($ii = 1; $ii < $n_args; $ii++) {
//
// some options are followed by =X
// where X is a value
//
$s_param = "";
if (($i_pos = strpos($a_args[$ii], '=')) !== false) {
$s_param = substr($a_args[$ii], $i_pos + 1);
$s_opt = substr($a_args[$ii], 0, $i_pos);
} else {
$s_opt = $a_args[$ii];
}
switch ($s_opt) {
case "nobr":
$b_insert_br = false;
break;
case "chars":
if ($s_param !== "") {
$n_max_chars = (int) $s_param;
}
break;
case "lines":
if ($s_param !== "") {
$n_max_lines = (int) $s_param;
}
break;
case "sep":
if ($s_param !== "") {
$s_list_sep = $s_param;
}
break;
case "subs":
$b_text_subs = true;
break;
}
}
}
}
$s_value = "";
$s_mesg = "";
if ($SubstituteFields->IsFieldSet($s_name) && !$SubstituteFields->TestFieldEmpty($s_name, $s_mesg)) {
if ($b_html) {
$s_value = $SubstituteFields->GetSafeFieldValue($s_name, $b_text_subs, $s_list_sep);
} else {
$s_value = $SubstituteFields->GetFieldValue($s_name, $s_list_sep);
}
$s_value = Truncate($s_value, $n_max_chars, $n_max_lines);
if ($b_html && $b_insert_br) {
$s_value = nl2br($s_value);
}
} elseif (isset($SPECIAL_VALUES[$s_name])) {
$s_value = $b_html ? htmlspecialchars((string) $SPECIAL_VALUES[$s_name]) : (string) $SPECIAL_VALUES[$s_name];
$s_value = Truncate($s_value, $n_max_chars, $n_max_lines);
} elseif (isset($s_repl)) {
$s_value = $s_repl;
} else {
$s_value = "";
}
return $s_value;
}
}
} else {
$limit = "LIMIT 0,10";
}
$querierFAQ = new Querier();
$qFAQ = "SELECT faq_id, question, answer, keywords\n\tFROM faq\n\tORDER BY faq_id DESC\n\t{$limit}";
$faqArray = $querierFAQ->query($qFAQ);
$row_count1 = 0;
$row_count2 = 0;
$colour1 = "evenrow";
$colour2 = "oddrow";
$faq_list = "";
if ($faqArray) {
foreach ($faqArray as $value) {
$row_colour1 = $row_count1 % 2 ? $colour1 : $colour2;
$short_question = Truncate($value["question"], 200);
$short_answer = stripslashes(htmlspecialchars_decode(TruncByWord($value["answer"], 15)));
$last_revised_line = lastModded("faq", $value[0]);
// Answered FAQs
$faq_list .= "\n <div class=\"striper faq_wrapper {$row_colour1}\">\n <div class=\"faq_tools\">\n <a href=\"faq.php?faq_id={$value['0']}&wintype=pop\" class=\"showmedium-reloader\"><img src=\"{$IconPath}/pencil.png\" alt=\"edit\" width=\"16\" height=\"16\" /></a>\n <a href=\"" . $FAQPath . "?faq_id={$value['0']}\" target=\"_blank\"><img src=\"{$IconPath}/eye.png\" alt=\"edit\" width=\"16\" height=\"16\" /></a>\n </div>\n <div class=\"faq_question\">\n {$short_question} <span class=\"faq-short-question\">({$last_revised_line})</span>\n </div>\n </div>";
$row_count1++;
}
} else {
$faq_list = "<p>" . _("No FAQs yet. Why not dream one up?") . "</p>";
}
$faq_body = "<p><strong>{$row_count1} " . _("FAQs visible");
if (!isset($limit) || $limit != "all") {
$faq_body .= " (<a href=\"index.php?limit=all\">" . _("See All") . "</a>)";
}
$faq_body .= "</strong></p>" . $faq_list;
?>
function SubstituteValueWorker($a_matches, $s_repl, $b_html = true)
{
global $aSubstituteErrors, $SubstituteFields, $SPECIAL_VALUES;
$b_insert_br = true;
// option to put "<br />" tags before newlines in HTML templates
$n_max_chars = 0;
$n_max_lines = 0;
$s_list_sep = $SPECIAL_VALUES['template_list_sep'];
$b_text_subs = false;
$s_name = $a_matches[0];
assert(strlen($s_name) > 1 && $s_name[0] == '$');
$s_name = substr($s_name, 1);
if (($i_len = strlen($s_name)) > 0 && $s_name[0] == '{') {
assert($s_name[$i_len - 1] == '}');
$s_name = substr($s_name, 1, -1);
//
// grab any processing options
//
$a_args = explode(":", $s_name);
$s_name = $a_args[0];
if (($n_args = count($a_args)) > 1) {
for ($ii = 1; $ii < $n_args; $ii++) {
//
// some options are followed by =X
// where X is a value
//
$s_param = "";
if (($i_pos = strpos($a_args[$ii], '=')) !== false) {
$s_param = substr($a_args[$ii], $i_pos + 1);
$s_opt = substr($a_args[$ii], 0, $i_pos);
} else {
$s_opt = $a_args[$ii];
}
switch ($s_opt) {
case "nobr":
$b_insert_br = false;
break;
case "chars":
if ($s_param !== "") {
$n_max_chars = (int) $s_param;
}
break;
case "lines":
if ($s_param !== "") {
$n_max_lines = (int) $s_param;
}
break;
case "sep":
if ($s_param !== "") {
$s_list_sep = $s_param;
}
break;
case "subs":
$b_text_subs = true;
break;
}
}
}
}
$s_value = "";
if ($SubstituteFields->IsFieldSet($s_name) && !$SubstituteFields->TestFieldEmpty($s_name, $s_mesg)) {
if ($b_html) {
//
// Up to and including version 8.24, the code used
// htmlspecialchars. Version 8.28 caused UTF-8 template
// processing to break, because it started using htmlentities
// without specifying the charset.
//
$s_value = $SubstituteFields->GetSafeFieldValue($s_name, $b_text_subs, $s_list_sep);
} else {
$s_value = $SubstituteFields->GetFieldValue($s_name, $s_list_sep);
}
$s_value = Truncate($s_value, $n_max_chars, $n_max_lines);
if ($b_html && $b_insert_br) {
//
// Insert HTML line breaks before newlines.
//
$s_value = nl2br($s_value);
}
} elseif (isset($SPECIAL_VALUES[$s_name])) {
$s_value = $b_html ? htmlspecialchars((string) $SPECIAL_VALUES[$s_name]) : (string) $SPECIAL_VALUES[$s_name];
$s_value = Truncate($s_value, $n_max_chars, $n_max_lines);
} elseif (isset($s_repl)) {
//
// If a replacement value has been specified use it, and
// don't call htmlspecialchars. This allows the use
// of HTML tags in a replacement string.
//
$s_value = $s_repl;
} else {
$s_value = "";
}
return $s_value;
}
public function outputSubject($value)
{
global $IconPath;
$subject_name = Truncate($value[6], 25, '');
$source_name = Truncate($value[7], 15, '');
// check if the note override icon should be active or in
if ($value[5] != "") {
$note_fa = "";
} else {
$note_fa = "fa-inactive";
}
// check if the source override icon should be active or in
if ($value[3] != $this->_def_source[0][0]) {
//on
$source_fa = "";
} else {
//off
$source_fa = "fa-inactive";
}
$oursubjects = "\n \t<div class=\"pure-g selected_item_wrapper\">\n \t<div class=\"pure-u-1-2\">\n \t<input name=\"subject[]\" value=\"{$value['1']}\" type=\"hidden\" />\n \t<input name=\"rank[]\" value=\"{$value['0']}\" type=\"hidden\" />\n \t<input name=\"source[]\" value=\"{$value['3']}\" id=\"hidden_source-{$value['1']}-{$value['3']}\" type=\"hidden\" />\n \t{$subject_name} <span class=\"small_extra\">{$source_name}</span><br />\n \t<textarea style=\"display: none; clear: both;\" class=\"desc_override\" name=\"description_override[]\" rows=\"4\" cols=\"35\">{$value['5']}</textarea>\n \t</div>\n \t<div class=\"pure-u-1-2\">\n \t<i class=\"fa fa-lg fa-trash delete_sub clickable\" alt=\"" . _("remove subject") . "\" title=\"" . _("remove subject") . "\"></i>\n \t<i class=\"fa fa-lg fa-book {$source_fa} source_override clickable\" id=\"source_override-{$value['1']}-{$value['3']}\" alt=\"" . _("change source type") . "\" title=\"" . _("change source type") . "\" border=\"0\" /></i>\n \t<i class=\"fa fa-lg fa-file-text-o {$note_fa} note_override clickable\" id=\"note_override-{$value['1']}-{$value['3']}\" alt=\"" . _("add description override") . "\" title=\"" . _("add description override") . "\" border=\"0\" /></i>\n \t</div>\n \t</div>";
return $oursubjects;
}
*/
$subcat = "guides";
$page_title = "Find Stuff";
$no_header = "yes";
include "../../includes/header.php";
$all_subs = "";
$our_subject_id = "";
if (isset($_GET["subject_id"])) {
$our_subject_id = scrubData($_GET["subject_id"], "int");
}
// get list of all subjects with pluslets, to use later
$q3 = "SELECT s.shortform, s.subject FROM subject s\nINNER JOIN tab t\nON s.subject_id = t.subject_id\nINNER JOIN section sec\nON t.tab_id = sec.tab_id\nINNER JOIN pluslet_section ps\nON sec.section_id = ps.section_id\nGROUP BY s.subject";
//print $q2;
$r3 = $db->query($q3);
foreach ($r3 as $myrow) {
$sub_title = Truncate($myrow[1], 50, '');
$all_subs .= "<option value=\"{$myrow['0']}\">{$sub_title}</option>";
}
print "\n<div id=\"maincontent\">\n<form action=\"discover.php\" method=\"post\" id=\"target\">\n\n<div style=\"float: left; width: 60%;\">\n <div class=\"box\">\n <h2>Browse</h2>\n\n\t<select name=\"all_subs\" id=\"all_subs\">\n\t<option value=\"\" style=\"font-size: 9pt;\">" . _("- Browse Boxes -") . "</option>\n\n\t{$all_subs}\n</select>\n</div>\n\n</div>\n<div style=\"float: left; width: 35%; margin-left: 3%;\">\n\t<div class=\"box\">\n <h2>Search</h2>\n\n\t <input type=\"text\" id=\"search_terms\" name=\"search\" />\n\t <input type=\"submit\" value=\"" . _("Go!") . "\" name=\"searcher\" id=\"searcho\" />\n\t </div>\n</div>\n</form>\n<div class=\"box no_overflow\" class=\"clear-both\">\n<div id=\"results\"></div>\n</div>\n";
?>
<script type="text/javascript" language="javascript">
$(document).ready(function(){
var thisguide = '<?php
print $our_subject_id;
?>
';
$("#all_subs").change(function() {
var desired_guide = $("select option:selected").val();
$("#results").fadeIn(3000).load("find_results.php", {shortform: desired_guide, guide_id: thisguide});
function getTopic($where, $page, $num)
{
global $DB, $table_topic;
$TopicArr = array();
$Tsql = "SELECT COUNT(`tid`) FROM `" . $table_topic . "` " . $where;
$TotalTopic = $DB->fetch_one($Tsql);
if ($TotalTopic > 0) {
$RSql = "SELECT * FROM `" . $table_topic . "` " . $where . " ORDER BY `tid` DESC LIMIT " . ($page - 1) * $num . "," . $num;
$Result = $DB->query($RSql);
while ($Re = $DB->fetch_array($Result)) {
$TopicArr[] = array("tid" => $Re['tid'], "fid" => $Re['fid'], "author" => stripslashes($Re['author']), "authorid" => $Re['authorid'], "authorico" => $Re['authorico'], "title" => filterHTML($Re['subject']), "subject" => Truncate(filterHTML($Re['subject']), 84), "dateline" => $Re['dateline'], "lasttime" => getCountDown($Re['lasttime']), "lastauthor" => stripslashes($Re['lastauthor']), "lastauthorid" => $Re['lastauthorid'], "lastauthorico" => $Re['lastauthorico'], "views" => $Re['views'], "replies" => $Re['replies'], "stick" => $Re['stick'], "digest" => $Re['digest'], "lockout" => $Re['lockout']);
}
}
$return['Total'] = $TotalTopic;
$return['Topic'] = $TopicArr;
$return['Page'] = $this->Pagination($TotalTopic, $num, $page);
return $return;
}
function getDBbySubBoxes($selected_sub)
{
$db = new Querier();
$subs_option_boxes = "";
$alphabet = "";
$subs_query = "SELECT distinct subject_id, subject, type FROM `subject` WHERE type = 'Subject' AND active = '1' ORDER BY subject";
$subs_result = $db->query($subs_query);
$num_subs = count($subs_result);
if ($num_subs > 0) {
foreach ($subs_result as $myrow) {
$subs_id = $myrow[0];
$subs_name = $myrow[1];
$subs_name = Truncate($subs_name, 50, '');
$subs_option_boxes .= "<option value=\"databases.php?letter=bysub&subject_id={$subs_id}\"";
if ($selected_sub == $subs_id) {
$subs_option_boxes .= " selected=\"selected\"";
}
$subs_option_boxes .= ">" . _($subs_name) . "</option>";
}
}
$alphabet .= " <select name=\"browser\" onChange=\"window.location=this.options[selectedIndex].value\">\n <option value=\"\" style=\"color: #ccc;\">- by subject -</option>\n {$subs_option_boxes}\n </select>";
return $alphabet;
}
function getDBbySubBoxes($selected_sub, $additionaltype = "Placeholder")
{
$db = new Querier();
$subs_option_boxes = "";
$alphabet = "";
$morequery = "";
if ($additionaltype != "") {
$morequery = "OR type = '" . $additionaltype . "'";
}
$subs_query = "SELECT distinct subject_id, subject, type FROM `subject` WHERE (type = 'Subject' " . $morequery . ") AND active = '1' ORDER BY subject";
$subs_query = "\n SELECT DISTINCT s.subject_id, s.subject, s.type \nFROM SUBJECT s\nINNER JOIN rank r\nON s.subject_id = r.subject_id\nINNER JOIN title t\nON r.title_id = t.title_id\nINNER JOIN location_title lt\nON t.title_id = lt.title_id\nINNER JOIN location l\nON lt.location_id = l.location_id\nWHERE s.type = 'Subject' \nAND s.active = '1' \nAND l.eres_display = 'Y'\nORDER BY s.subject";
$subs_result = $db->query($subs_query);
$num_subs = count($subs_result);
if ($num_subs > 0) {
foreach ($subs_result as $myrow) {
$subs_id = $myrow[0];
$subs_name = $myrow[1];
$subs_name = Truncate($subs_name, 50, '');
$subs_option_boxes .= "<option value=\"databases.php?letter=bysub&subject_id={$subs_id}\"";
if ($selected_sub == $subs_id) {
$subs_option_boxes .= " selected=\"selected\"";
}
$subs_option_boxes .= ">" . _($subs_name) . "</option>";
}
}
$alphabet .= " <select name=\"browser\" onChange=\"window.location=this.options[selectedIndex].value\">\n <option value=\"\" style=\"color: #ccc;\">- by subject -</option>\n {$subs_option_boxes}\n </select>";
return $alphabet;
}
function genTalkBacks($tbArray, $show_response = 1)
{
global $IconPath;
$row_count1 = 0;
$row_count2 = 0;
$colour1 = "evenrow";
$colour2 = "oddrow";
$tb_answer = "";
if (!is_array($tbArray)) {
return "<strong>" . _("Alas, there are no items with this tag.") . "</strong>";
}
foreach ($tbArray as $key => $value) {
$tb_tagger = "";
$row_colour = $row_count2 % 2 ? $colour1 : $colour2;
if ($value[2]) {
$q_from = $value[2];
} else {
$q_from = _("Anonymous");
}
if ($value["answer"] == '') {
$row_colour = "tb_highlight";
}
//show tag even if answer is not empty
$tb_tagger = "<span class=\"ctag-on\">" . $value["tbtags"] . "</span>";
if (isset($show_response) && $show_response == 0) {
$first_div_width = "90%";
$last_mod_tb = "";
} else {
$first_div_width = "45%";
$short_answer = stripslashes(htmlspecialchars_decode(TruncByWord($value["answer"], 15)));
$last_mod_tb = lastModded("talkback", $value["talkback_id"], 0, 1);
}
$short_question = Truncate($value["question"], 200);
if ($last_mod_tb) {
$mod_line = _("--") . $last_mod_tb;
} else {
$mod_line = "";
}
$tb_answer .= "\n <div style=\"clear: both; float: left; padding: 3px 5px; width: 98%;\" class=\"striper {$row_colour}\">\n <div style=\"float: left; width: 32px; max-width: 5%;\"><a class=\"showmedium-reloader\" style=\"color: #333;\" href=\"talkback.php?talkback_id={$value['0']}&wintype=pop\"><img src=\"{$IconPath}/pencil.png\" alt=\"edit\" width=\"16\" height=\"16\" /></a></div>\n <div style=\"float: left; width: {$first_div_width};\">\n {$tb_tagger}<strong>Q:</strong> {$short_question} <span style=\"color: #666; font-size: 10px;\">({$q_from}, {$value['date_formatted']})</span>\n </div>";
if (isset($show_response) && $show_response == 1) {
$tb_answer .= "<div style=\"float: left; width: 45%; margin-left: 4%;\">\n <strong>A:</strong> {$short_answer} <span style=\"color: #666; font-size: 10px;\">{$mod_line}</span>\n </div>\n ";
}
$tb_answer .= "</div>";
$row_count2++;
}
return $tb_answer;
}
public function outputCollection($value)
{
global $IconPath;
$collection_name = Truncate($value["name"], 25, '');
$ourcolls = "\n <div class=\"selected_item_wrapper\">\n <div class=\"selected_item\">\n <input name=\"collection[]\" value=\"{$value['faqpage_id']}\" type=\"hidden\" />\n {$collection_name}\n </div>\n <div class=\"selected_item_options\">\n <img src=\"{$IconPath}/delete.png\" class=\"delete_sub\" alt=\"" . "delete" . "\" title=\"" . "remove subject" . "\" border=\"0\">\n </div>\n </div>";
return $ourcolls;
}
use SubjectsPlus\Control\Dropdown;
use SubjectsPlus\Control\Record;
use SubjectsPlus\Control\LinkChecker;
use SubjectsPlus\Control\Mailer;
use SubjectsPlus\Control\MailMessage;
include "../includes/header.php";
// Connect to database
//print_r($_POST);
switch ($_POST["type"]) {
case "location":
$record = new Record();
$record->buildLocation();
break;
case "add_subject":
$subject_name = Truncate($_POST["our_sub_text"], 25, '');
$source_name = Truncate($_POST["our_source_text"], 15, '');
echo "<div class=\"selected_item_wrapper\"><div class=\"selected_item\" id=\"root-" . $_POST["our_source_id"] . "\"><input type=\"hidden\" name=\"rank[]\" value=\"0\" /><input type=\"hidden\" name=\"subject[]\" value=\"" . $_POST["our_sub_id"] . "\" /><input type=\"hidden\" id=\"hidden_source-" . $_POST["our_sub_id"] . "-" . $_POST["our_source_id"] . "\" name=\"source[]\" value=\"" . $_POST["our_source_id"] . "\" />" . $subject_name . "<span class=\"small_extra\"> " . $source_name . " </span><br />\n <textarea class=\"desc_override desc-area\" name=\"description_override[]\" rows=\"4\" cols=\"35\"></textarea></div>\n <div class=\"selected_item_options\"><i class=\"fa fa-lg fa-trash delete_sub clickable\" alt=\"" . _("remove subject") . "\" title=\"" . _("remove subject") . "\"></i>\n <i class=\"fa fa-book fa-lg\"></i>\n <i class=\"fa fa-lg fa-file-text-o source_override clickable\" id=\"source_override-" . $_POST["our_sub_id"] . "-" . $_POST["our_source_id"] . "\"></i> </div></div>";
break;
case "source_override":
// load list of sources
$querierSource = new Querier();
$qSource = "select source_id, source from source order by source";
$defsourceArray = $querierSource->query($qSource);
$sourceMe = new Dropdown("source_override[]", $defsourceArray, $_POST["our_source_id"]);
$source_string = $sourceMe->display();
echo "<span class=\"record-source-override\">" . _("Source Override") . "<br />{$source_string} <img src=\"{$IconPath}/list-add.png\" class=\"add_source\" id=\"add_source_id-" . $_POST["our_subject_id"] . "-" . $_POST["our_source_id"] . "\" alt=\"" . _("add source override") . "\" title=\"" . _("add source override") . "\" border=\"0\">\n <i class=\"fa fa-times clickable cancel_add_source\" id=\"cancel_add_source_id-" . $_POST["our_subject_id"] . "-" . $_POST["our_source_id"] . "\" alt=\"" . _("never mind") . "\" title=\"" . _("never mind") . "\" border=\"0\"></i></span>";
break;
case "new_record_label":
switch ($_POST["format_type_id"]) {
case 1:
$label_text = _("Location (Enter URL)");
public function outputSubject($value)
{
global $IconPath;
$subject_name = Truncate($value[6], 25, '');
$source_name = Truncate($value[7], 15, '');
// check if the note override icon should be active or in
if ($value[5] != "") {
$note_icon = "document-26.png";
} else {
$note_icon = "file-26.png";
}
// check if the source override icon should be active or in
if ($value[3] != $this->_def_source[0][0]) {
$source_icon = "usb_on-26.png";
} else {
$source_icon = "usb_off-26.png";
}
$oursubjects = "\n \t<div class=\"pure-g selected_item_wrapper\">\n \t<div class=\"pure-u-1-2\">\n \t<input name=\"subject[]\" value=\"{$value['1']}\" type=\"hidden\" />\n \t<input name=\"rank[]\" value=\"{$value['0']}\" type=\"hidden\" />\n \t<input name=\"source[]\" value=\"{$value['3']}\" id=\"hidden_source-{$value['1']}-{$value['3']}\" type=\"hidden\" />\n \t{$subject_name} <span class=\"small_extra\">{$source_name}</span><br />\n \t<textarea style=\"display: none; clear: both;\" class=\"desc_override\" name=\"description_override[]\" rows=\"4\" cols=\"35\">{$value['5']}</textarea>\n \t</div>\n \t<div class=\"pure-u-1-2\">\n \t<img src=\"{$IconPath}/delete.png\" class=\"delete_sub icon_smaller\" alt=\"" . _("remove subject") . "\" title=\"" . _("remove subject") . "\" border=\"0\" />\n \t<img src=\"{$IconPath}/{$source_icon}\" class=\"source_override icon_smaller\" id=\"source_override-{$value['1']}-{$value['3']}\" alt=\"" . _("change source type") . "\" title=\"" . _("change source type") . "\" border=\"0\" />\n \t<img src=\"{$IconPath}/{$note_icon}\" class=\"note_override icon_smaller\" id=\"note_override-{$value['1']}-{$value['3']}\" alt=\"" . _("add description override") . "\" title=\"" . _("add description override") . "\" border=\"0\" />\n \t</div>\n \t</div>";
return $oursubjects;
}
* @brief Inserting elements via .load into faq.php
*
* @author adarby
* @date
* @todo scrub post vars
*/
$subcat = "faq";
$page_title = "FAQ Bits include";
$header = "noshow";
include "../includes/header.php";
// Connect to database
//print_r($_POST);
switch ($_POST["type"]) {
case "add_collection":
$subject_name = Truncate($_POST["our_sub_text"], 25, '');
echo "<div class=\"selected_item_wrapper\"><div class=\"selected_item\">\n <input type=\"hidden\" name=\"collection[]\" value=\"" . $_POST["our_sub_id"] . "\" />\n " . $subject_name . "</div>\n <div class=\"selected_item_options\"><i class=\"fa fa-times\" class=\"delete_sub\" alt=\"delete\" border=\"0\"></i>\n </div></div>";
break;
case "add_subject":
$subject_name = Truncate($_POST["our_sub_text"], 25, '');
echo "<div class=\"selected_item_wrapper\"><div class=\"selected_item\" \">\n <input type=\"hidden\" name=\"subject[]\" value=\"" . $_POST["our_sub_id"] . "\" />\n " . $subject_name . "</div>\n <div class=\"selected_item_options\"><i class=\"fa fa-times\" class=\"delete_sub\" alt=\"delete\" border=\"0\"></i>\n </div></div>";
break;
case "recommend_delete":
$del_record = $CpanelPath . "faq/faq.php?faq_id=" . $_POST["our_id"];
$message_body = "<p>" . _("The following record is recommended for delete") . ":</p>\n <p><a href=\"{$del_record}\">{$del_record}</a></p>";
$messageParams = array('from' => $_SESSION['email'], 'to' => $administrator_email, 'subjectLine' => _("SubjectsPlus: FAQ Delete Recommendation"), 'content' => $message_body);
$message = new MailMessage($messageParams);
$mailer = new Mailer();
$mailer->send($message);
echo "<div class=\"rec_delete_confirm\">" . _("Delete request sent to ") . "{$administrator_email}</div>";
break;
}
function getForumTopic($fid, $page, $num, $digest = false)
{
global $DB, $table_topic;
$TopicArr = array();
$Tsql = "SELECT COUNT(`tid`) FROM `" . $table_topic . "` WHERE `fid`=" . $fid;
if ($digest) {
$Tsql .= " AND `digest`=1";
}
$Total = $DB->fetch_one($Tsql);
if ($Total > 0) {
$QSql = "SELECT * FROM `" . $table_topic . "` WHERE `fid` = " . $fid . " ORDER BY `stick` DESC,`lasttime` DESC";
if ($digest) {
$QSql = "SELECT * FROM `" . $table_topic . "` WHERE `fid` = " . $fid . " AND `digest`=1 ORDER BY `tid` DESC";
}
$Result = $DB->query($QSql . " LIMIT " . ($page - 1) * $num . "," . $num);
while ($Re = $DB->fetch_array($Result)) {
$TopicArr[] = array("tid" => $Re['tid'], "fid" => $Re['fid'], "author" => stripslashes($Re['author']), "authorid" => $Re['authorid'], "authorico" => $Re['authorico'], "title" => filterHTML($Re['subject']), "subject" => Truncate(filterHTML($Re['subject']), 80), "dateline" => $Re['dateline'], "lasttime" => getCountDown($Re['lasttime']), "lastauthor" => stripslashes($Re['lastauthor']), "lastauthorid" => $Re['lastauthorid'], "lastauthorico" => $Re['lastauthorico'], "views" => $Re['views'], "replies" => $Re['replies'], "stick" => $Re['stick'], "digest" => $Re['digest'], "isdigest" => $digest, "lockout" => $Re['lockout']);
}
}
$return['Total'] = $Total;
$return['Topic'] = $TopicArr;
$return['Page'] = $this->Pagination($Total, $num, $page);
return $return;
}
