ifthd->core->cache['config']['enable_kb'] ) { $this->ifthd->skin->error('kb_disabled'); } if ( ! $this->ifthd->member['g_kb_access'] || $this->ifthd->member['ban_kb'] ) { $this->ifthd->log( 'security', "Blocked Access Knowledge Base" ); $this->ifthd->skin->error('banned_kb'); } $this->ifthd->load_lang('article'); switch( $this->ifthd->input['code'] ) { case 'view': $this->show_article(); break; case 'print': $this->show_article( 0, 'print' ); break; case 'cat': $this->show_category(); break; case 'search': $this->do_search(); break; case 'comment': $this->submit_comment(); break; case 'rate': $this->do_rate(); break; case 'edit': $this->edit_comment(); break; case 'doedit': $this->do_edit(); break; case 'delete': $this->do_delete(); break; default: $this->show_categories(); break; } } #======================================= # @ Show Article # Simply shows an article. :) #======================================= function show_article($error="", $type="") { #============================= # Security Checks #============================= $this->ifthd->input['id'] = intval( $this->ifthd->input['id'] ); $this->ifthd->core->db->construct( array( 'select' => 'all', 'from' => 'articles', 'where' => array( 'id', '=', $this->ifthd->input['id'] ), 'limit' => array( 0, 1 ), ) ); $this->ifthd->core->db->execute(); if ( ! $this->ifthd->core->db->get_num_rows() ) { $this->ifthd->log( 'error', "Article Not Found ID: ". $this->ifthd->input['id'] ); $this->ifthd->skin->error('no_article'); } #============================= # Fix Up Information #============================= $a = $this->ifthd->core->db->fetch_row(); $a['date'] = $this->ifthd->ift_date( $a['date'] ); if ( $this->ifthd->core->cache['config']['enable_kb_rte'] ) { $a['article'] = $this->ifthd->prepare_output( $this->ifthd->remove_dbl_spaces( $this->ifthd->convert_html( $a['article'] ) ), 0, 0, 1, 1 ); } else { $a['article'] = $this->ifthd->prepare_output( $a['article'], 0, 0, 1 ); } $this->ifthd->core->template->set_var( 'article', $a ); #============================= # Can We Rate? #============================= if ( $this->ifthd->member['id'] ) { $this->ifthd->core->db->construct( array( 'select' => 'all', 'from' => 'article_rate', 'where' => array( array( 'aid', '=', $a['id'] ), array( 'mid', '=', $this->ifthd->member['id'], 'and' ) ), 'limit' => array( 0, 1 ), ) ); $this->ifthd->core->db->execute(); if ( $this->ifthd->core->db->get_num_rows() || ! $this->ifthd->core->cache['config']['allow_kb_rating'] || ! $this->ifthd->member['g_kb_rate'] || $this->ifthd->member['ban_kb_rate'] || $a['dis_rating'] ) { $rate = $this->rate_stars( $a['rating'], 0, $a['id'] ); } else { $rate = $this->rate_stars( $a['rating'], 1, $a['id'] ); } } else { $rate = $this->rate_stars( $a['rating'], 0, $a['id'] ); } $this->ifthd->core->template->set_var( 'rate', $rate ); #============================= # Grab Comments? #============================= if ( $a['comments'] ) { $this->ifthd->core->db->construct( array( 'select' => 'all', 'from' => 'comments', 'where' => array( 'aid', '=', $a['id'] ), ) ); $this->ifthd->core->db->execute(); $comments = array(); // Initialize for Security $row_count = 0; // Initialize for Security while( $c = $this->ifthd->core->db->fetch_row() ) { #============================= # Fix Up Information #============================= $row_count ++; ( $row_count & 1 ) ? $c['class'] = 1 : $c['class'] = 2; $c['time_ago'] = $this->ifthd->ift_date( $c['date'], '', 3 ); $c['date'] = $this->ifthd->ift_date( $c['date'] ); $c['comment'] = $this->ifthd->prepare_output( $c['comment'], 0, 0, 1 ); $comments[] = $c; } $this->ifthd->core->template->set_var( 'comments', $comments ); } #============================= # Do Output #============================= if ( $this->ifthd->core->cache['config']['allow_kb_comment'] && $this->ifthd->member['g_kb_comment'] && ! $this->ifthd->member['ban_kb_comment'] && ! $a['dis_comments'] && $this->ifthd->member['id'] ) { $this->ifthd->core->template->set_var( 'show_comment_form', 1 ); $this->ifthd->core->template->set_var( 'token_add_comment', $this->ifthd->create_token('acomment') ); if ( $error ) { $this->ifthd->core->template->set_var( 'error', $this->ifthd->lang[ 'err_'. $error ] ); } } #============================= # Update Article #============================= $this->ifthd->core->db->construct( array( 'update' => 'articles', 'set' => array( 'views' => $a['views'] + 1 ), 'where' => array( 'id', '=', $a['id'] ), 'limit' => array( 1 ), ) ); $this->ifthd->core->db->next_shutdown(); $this->ifthd->core->db->execute(); #============================= # Do Output #============================= $this->nav = array( "{$this->ifthd->lang['knowledge_base']}", "{$a['cat_name']}", "{$a['name']}", ); if ( $type == 'print' ) { $this->ifthd->core->template->set_var( 'sub_tpl', 'kb_print_article.tpl' ); $this->ifthd->skin->do_print( array( 'title' => $this->ifthd->lang['knowledge_base'] .' :: '. $a['name'] ) ); } else { $this->ifthd->core->template->set_var( 'sub_tpl', 'kb_show_article.tpl' ); $this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => $this->ifthd->lang['knowledge_base'] .' :: '. $a['name'] ) ); } } #======================================= # @ Submit Comment # Adds a new comment to an article. #======================================= function submit_comment() { #============================= # Security Checks #============================= $this->ifthd->create_token('acomment'); $this->ifthd->input['id'] = intval( $this->ifthd->input['id'] ); if ( ! $this->ifthd->core->cache['config']['allow_kb_comment'] ) { $this->ifthd->skin->error('kb_comment_disabled'); } if ( ! $this->ifthd->member['g_kb_comment'] || $this->ifthd->member['ban_kb_comment'] ) { $this->ifthd->log( 'security', "Blocked Article Comment" ); $this->ifthd->skin->error('banned_kb_comment'); } $this->ifthd->core->db->construct( array( 'select' => array( 'id', 'name', 'comments', 'dis_comments' ), 'from' => 'articles', 'where' => array( 'id', '=', $this->ifthd->input['id'] ), 'limit' => array( 0, 1 ), ) ); $this->ifthd->core->db->execute(); if ( ! $this->ifthd->core->db->get_num_rows() ) { $this->ifthd->log( 'error', "Article Not Found ID: ". $this->ifthd->input['id'] ); $this->ifthd->skin->error('no_article'); } $a = $this->ifthd->core->db->fetch_row(); if ( ! $this->ifthd->member['id'] ) { $this->ifthd->log( 'security', "Comment Blocked From Guest '". $a['name'] ."'", 1, $a['id'] ); $this->ifthd->skin->error( 'must_be_user', 1 ); } if ( $a['dis_comments'] ) { $this->ifthd->log( 'security', "Blocked Article Comment" ); $this->ifthd->skin->error('banned_kb_comment'); } if ( ! $this->ifthd->input['comment'] ) { $this->show_article('no_comment'); } #============================= # Add Comment #============================= $db_array = array( 'aid' => $this->ifthd->input['id'], 'mid' => $this->ifthd->member['id'], 'mname' => $this->ifthd->member['name'], 'comment' => $this->ifthd->input['comment'], 'date' => time(), 'ipadd' => $this->ifthd->input['ip_address'], ); $this->ifthd->core->db->construct( array( 'insert' => 'comments', 'set' => $db_array, ) ); $this->ifthd->core->db->execute(); $comment_id = $this->ifthd->core->db->get_insert_id(); $this->ifthd->log( 'member', "Article Comment Added '". $a['name'] ."'", 1, $a['id'] ); #============================= # Update Article #============================= $this->ifthd->core->db->construct( array( 'update' => 'articles', 'set' => array( 'comments' => $a['comments'] + 1 ), 'where' => array( 'id', '=', $a['id'] ), 'limit' => array( 1 ), ) ); $this->ifthd->core->db->next_shutdown(); $this->ifthd->core->db->execute(); #============================= # Redirect #============================= $this->ifthd->skin->redirect( '?act=article&code=view&id='. $a['id'] .'#com'. $comment_id, 'submit_comment_success' ); } #======================================= # @ Show Categories # Show Knowledge Base categories. #======================================= function show_categories() { #============================= # Grab Categories #============================= $this->ifthd->core->db->construct( array( 'select' => 'all', 'from' => 'categories', ) ); $this->ifthd->core->db->execute(); $cats = ""; // Initialize for Security $c_count = $this->ifthd->core->db->get_num_rows(); $row_count_right = 0; // Initialize for Security $row_count_left = 0; // Initialize for Security $cats_left = array(); // Initialize for Security $cats_right = array(); // Initialize for Security while ( $c = $this->ifthd->core->db->fetch_row() ) { $cat_count ++; if ( $cat_count & 1 ) { $row_count_left ++; ( $row_count_left & 1 ) ? $c['class'] = 1 : $c['class'] = 2; $cats_left[] = $c; } else { $row_count_right ++; ( $row_count_right & 1 ) ? $c['class'] = 1 : $c['class'] = 2; $cats_right[] = $c; } } #============================= # Do Output #============================= $this->ifthd->core->template->set_var( 'token_kb_search', $this->ifthd->create_token('search') ); $this->ifthd->core->template->set_var( 'cats_left', $cats_left ); $this->ifthd->core->template->set_var( 'cats_right', $cats_right ); $this->nav = array( "{$this->ifthd->lang['knowledge_base']}", ); $this->ifthd->core->template->set_var( 'sub_tpl', 'knowledge_base.tpl' ); $this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => $this->ifthd->lang['knowledge_base'] ) ); } #======================================= # @ Show Category # Show categories and articles. #======================================= function show_category() { #============================= # Grab Category #============================= $this->ifthd->input['id'] = intval( $this->ifthd->input['id'] ); $this->ifthd->core->db->construct( array( 'select' => 'all', 'from' => 'categories', 'where' => array( 'id', '=', $this->ifthd->input['id'] ), 'limit' => array( 0, 1 ), ) ); $this->ifthd->core->db->execute(); if ( ! $this->ifthd->core->db->get_num_rows() ) { $this->ifthd->log( 'error', "KB Category Not Found ID: ". $this->ifthd->input['id'] ); $this->ifthd->skin->error('no_category'); } $c = $this->ifthd->core->db->fetch_row(); $this->ifthd->core->template->set_var( 'c', $c ); #============================= # Grab Articles #============================= $this->ifthd->core->db->construct( array( 'select' => array( 'id', 'name', 'description', 'date' ), 'from' => 'articles', 'where' => array( 'cat_id', '=', $c['id'] ), 'order' => array( 'date' => 'desc' ), ) ); $this->ifthd->core->db->execute(); $articles = array(); // Initialize for Security $row_count = 0; // Initialize for Security while ( $a = $this->ifthd->core->db->fetch_row() ) { $row_count ++; ( $row_count & 1 ) ? $a['class'] = 1 : $a['class'] = 2; $a['date'] = $this->ifthd->ift_date( $a['date'] ); $articles[] = $a; } $this->ifthd->core->template->set_var( 'articles', $articles ); #============================= # Do Output #============================= $this->ifthd->core->template->set_var( 'token_kb_search', $this->ifthd->create_token('search') ); $this->nav = array( "{$this->ifthd->lang['knowledge_base']}", "{$c['name']}", ); $this->ifthd->core->template->set_var( 'sub_tpl', 'kb_show_category.tpl' ); $this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => $this->ifthd->lang['knowledge_base'] .' :: '. $c['name'] ) ); } #======================================= # @ Do Search # Performs a search and returns results. #======================================= function do_search() { #============================= # Search! #============================= $this->ifthd->check_token('search'); $searchstring = $this->ifthd->input['keywords']; $sql = "SELECT *, ( 1.6 * ( MATCH(keywords) AGAINST ('". mysql_real_escape_string( $searchstring ) ."' IN BOOLEAN MODE) ) + 0.9 * ( MATCH(name) AGAINST ('". mysql_real_escape_string( $searchstring ) ."' IN BOOLEAN MODE) ) + ( 0.6 * ( MATCH(article) AGAINST ('". mysql_real_escape_string( $searchstring ) ."' IN BOOLEAN MODE) ) ) ) AS score FROM ". DB_PRE ."articles WHERE MATCH(name, description, article) AGAINST ('". mysql_real_escape_string( $searchstring ) ."' IN BOOLEAN MODE) ORDER BY score DESC"; $this->ifthd->core->db->query( $sql ); $art = ""; // Initialize for Security while( $m = $this->ifthd->core->db->fetch_row() ) { if ( $m['score'] > $max_score ) { $max_score = $m['score']; } $art[] = $m; } $articles = array(); // Initialize for Security $row_count = 0; // Initialize for Security if ( is_array( $art ) ) { while ( list( , $a ) = each( $art ) ) { #============================= # Fix Up Information #============================= $row_count ++; ( $row_count & 1 ) ? $a['class'] = 1 : $a['class'] = 2; $a['date'] = $this->ifthd->ift_date( $a['date'] ); $a['score'] = @ round( ( $a['score'] / $max_score ) * 100 ) ."%"; $articles[] = $a; } $this->ifthd->core->template->set_var( 'results', $articles ); } #============================= # Do Output #============================= $this->nav = array( "{$this->ifthd->lang['knowledge_base']}", "{$this->ifthd->lang['search_results']}", ); $this->ifthd->core->template->set_var( 'sub_tpl', 'kb_search_results.tpl' ); $this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => $this->ifthd->lang['knowledge_base'] .' :: '. $this->ifthd->lang['search_results'] ) ); } #======================================= # @ Do Rate # Adding rating to article. #======================================= function do_rate() { #============================= # Security Checks #============================= $this->ifthd->input['id'] = intval( $this->ifthd->input['id'] ); $this->ifthd->input['amount'] = intval( $this->ifthd->input['amount'] ); if ( ! $this->ifthd->core->cache['config']['allow_kb_rating'] ) { $this->ifthd->skin->error('kb_rating_disabled'); } if ( ! $this->ifthd->member['g_kb_rate'] || $this->ifthd->member['ban_kb_rate'] ) { $this->ifthd->log( 'security', "Blocked Article Rating" ); $this->ifthd->skin->error('banned_kb_rate'); } $this->ifthd->core->db->construct( array( 'select' => array( 'id', 'name', 'votes', 'rating', 'dis_rating' ), 'from' => 'articles', 'where' => array( 'id', '=', $this->ifthd->input['id'] ), 'limit' => array( 0, 1 ), ) ); $this->ifthd->core->db->execute(); if ( ! $this->ifthd->core->db->get_num_rows() ) { $this->ifthd->log( 'error', "Article Not Found ID: ". $this->ifthd->input['id'] ); $this->ifthd->skin->error('no_article'); } $a = $this->ifthd->core->db->fetch_row(); if ( ! $this->ifthd->member['id'] ) { $this->ifthd->log( 'security', "Article Rating Blocked From Guest '". $a['name'] ."'", 1, $a['id'] ); $this->ifthd->skin->error( 'must_be_user', 1 ); } if ( $a['dis_rating'] ) { $this->ifthd->log( 'security', "Blocked Article Rating" ); $this->ifthd->skin->error('banned_kb_rate'); } $allowed_ratings = array( 1, 2, 3, 4, 5 ); if ( ! in_array( $this->ifthd->input['amount'], $allowed_ratings ) ) { $this->ifthd->log( 'security', "Invalid Article Rating Amount '". $a['name'] ."'", 1, $a['id'] ); $this->ifthd->skin->error('invalid_rate_value'); } $this->ifthd->core->db->construct( array( 'select' => 'all', 'from' => 'article_rate', 'where' => array( array( 'aid', '=', $a['id'] ), array( 'mid', '=', $this->ifthd->member['id'], 'and' ) ), 'limit' => array( 0, 1 ), ) ); $this->ifthd->core->db->execute(); if ( $this->ifthd->core->db->get_num_rows() ) { $this->ifthd->log( 'security', "Already Rated Article By Member '". $a['name'] ."'", 1, $a['id'] ); $this->ifthd->skin->error('already_rated'); } #============================= # Add Rating #============================= $db_array = array( 'aid' => $a['id'], 'mid' => $this->ifthd->member['id'], 'rating' => $this->ifthd->input['amount'], 'date' => time(), 'ipadd' => $this->ifthd->input['ip_address'], ); $this->ifthd->core->db->construct( array( 'insert' => 'article_rate', 'set' => $db_array, ) ); $this->ifthd->core->db->execute(); $this->ifthd->log( 'member', "Article Rating Value ". $this->ifthd->input['amount'] ." Added '". $a['name'] ."'", 1, $a['id'] ); #============================= # Update Article #============================= $new_rating = round( ( $a['rating'] + $this->ifthd->input['amount'] ) / ( $a['votes'] + 1 ), 2 ); $this->ifthd->core->db->construct( array( 'update' => 'articles', 'set' => array( 'votes' => $a['votes'] + 1, 'rating' => $new_rating ), 'where' => array( 'id', '=', $a['id'] ), 'limit' => array( 1 ), ) ); $this->ifthd->core->db->next_shutdown(); $this->ifthd->core->db->execute(); #============================= # Do Output #============================= $this->ifthd->skin->redirect( '?act=article&code=view&id='. $a['id'], 'add_rating_success' ); } #======================================= # @ Edit Comment # Show edit comment form. #======================================= function edit_comment($error="") { #============================= # Security Checks #============================= $this->ifthd->input['id'] = intval( $this->ifthd->input['id'] ); if ( ! $this->ifthd->member['g_com_edit_all'] ) { $this->ifthd->log( 'security', "Blocked Editing of Comment" ); $this->ifthd->skin->error('no_perm_com_edit'); } $this->ifthd->core->db->construct( array( 'select' => 'all', 'from' => 'comments', 'where' => array( 'id', '=', $this->ifthd->input['id'] ), 'limit' => array( 0, 1 ), ) ); $this->ifthd->core->db->execute(); if ( ! $this->ifthd->core->db->get_num_rows() ) { $this->ifthd->log( 'error', "Comment Not Found ID: ". $this->ifthd->input['id'] ); $this->ifthd->skin->error('no_comment'); } $c = $this->ifthd->core->db->fetch_row(); $this->ifthd->core->template->set_var( 'comment', $c ); #============================= # Do Output #============================= if ( $error ) { $this->ifthd->core->template->set_var( 'error', $this->ifthd->lang[ 'err_'. $error ] ); } $this->ifthd->core->template->set_var( 'token_edit_comment', $this->ifthd->create_token('acomment_edit') ); $this->nav = array( "{$this->ifthd->lang['knowledge_base']}", "{$this->ifthd->lang['edit_comment']}", ); $this->ifthd->core->template->set_var( 'sub_tpl', 'kb_edit_comment.tpl' ); $this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => $this->ifthd->lang['knowledge_base'] .' :: '. $this->ifthd->lang['edit_comment'] ) ); } #======================================= # @ Do Edit Comment # Edit comment. :P #======================================= function do_edit() { #============================= # Security Checks #============================= $this->ifthd->check_token('acomment_edit'); $this->ifthd->input['id'] = intval( $this->ifthd->input['id'] ); if ( ! $this->ifthd->member['g_com_edit_all'] ) { $this->ifthd->log( 'security', "Blocked Editing of Comment" ); $this->ifthd->skin->error('no_perm_com_edit'); } if ( ! $this->ifthd->input['comment'] ) { $this->edit_comment('no_comment'); } $this->ifthd->core->db->construct( array( 'select' => 'all', 'from' => 'comments', 'where' => array( 'id', '=', $this->ifthd->input['id'] ), 'limit' => array( 0, 1 ), ) ); $this->ifthd->core->db->execute(); if ( ! $this->ifthd->core->db->get_num_rows() ) { $this->ifthd->log( 'error', "Comment Not Found ID: ". $this->ifthd->input['id'] ); $this->ifthd->skin->error('no_comment'); } $c = $this->ifthd->core->db->fetch_row(); #============================= # Update Comment #============================= $this->ifthd->core->db->construct( array( 'update' => 'comments', 'set' => array( 'comment' => $this->ifthd->input['comment'] ), 'where' => array( 'id', '=', $c['id'] ), 'limit' => array( 1 ), ) ); $this->ifthd->core->db->execute(); $this->ifthd->log( 'member', "Article Comment Edited ID #". $c['id'], 1, $c['id'] ); #============================= # Do Output #============================= $this->ifthd->skin->redirect( '?act=article&code=view&id='. $c['aid'] .'#com'. $c['id'], 'edit_comment_success' ); } #======================================= # @ Do Delete Comment # Delete comment. :( #======================================= function do_delete() { #============================= # Security Checks #============================= $this->ifthd->input['id'] = intval( $this->ifthd->input['id'] ); if ( ! $this->ifthd->member['g_com_delete_all'] ) { $this->ifthd->log( 'security', "Blocked Deletion of Comment" ); $this->ifthd->skin->error('no_perm_com_delete'); } $this->ifthd->core->db->construct( array( 'select' => array( 'c' => 'all', 'a' => array( 'comments' ) ), 'from' => array( 'c' => 'comments' ), 'join' => array( array( 'from' => array( 'a' => 'articles' ), 'where' => array( 'c' => 'aid', '=', 'a' => 'id' ) ) ), 'where' => array( array( 'c' => 'id' ), '=', $this->ifthd->input['id'] ), 'limit' => array( 0, 1 ), ) ); $this->ifthd->core->db->execute(); if ( ! $this->ifthd->core->db->get_num_rows() ) { $this->ifthd->log( 'error', "Comment Not Found ID: ". $this->ifthd->input['id'] ); $this->ifthd->skin->error('no_comment'); } $c = $this->ifthd->core->db->fetch_row(); #============================= # Delete Comment #============================= $this->ifthd->core->db->construct( array( 'delete' => 'comments', 'where' => array( 'id', '=', $c['id'] ), 'limit' => array( 1 ), ) ); $this->ifthd->core->db->execute(); $this->ifthd->log( 'member', "Article Comment Deleted ID #". $c['id'], 2, $c['id'] ); #============================= # Update Article #============================= $this->ifthd->core->db->construct( array( 'update' => 'articles', 'set' => array( 'comments' => $c['comments'] - 1 ), 'where' => array( 'id', '=', $c['aid'] ), 'limit' => array( 1 ), ) ); $this->ifthd->core->db->next_shutdown(); $this->ifthd->core->db->execute(); #============================= # Do Output #============================= $this->ifthd->skin->redirect( '?act=article&code=view&id='. $c['aid'], 'delete_comment_success' ); } #======================================= # @ rate_stars() #======================================= function rate_stars($rating, $rate=0, $fid=0) { $half = 0; // Initialize for Security if ( strstr( $rating, '.' ) ) { $half = 1; } $real_rating = $rating; $rating = round( $rating ); for ( $x = 1; $x < $rating + 1; $x++ ) { if ( $half && $x == $rating ) { if ( $rate ) { $ift_html .= "". $this->ifthd->lang["; } else { $ift_html .= "". $this->ifthd->lang["; } } else { if ( $rate ) { $ift_html .= "". $this->ifthd->lang["; } else { $ift_html .= "". $this->ifthd->lang["; } } } for ( $x = $x; $x <= 5; $x++ ) { if ( $rate ) { $ift_html .= "". $this->ifthd->lang["; } else { $ift_html .= "". $this->ifthd->lang["; } } return $ift_html; } } ?>