ifthd->member['acp']['manage_article'] )
{
$this->ifthd->skin->error('no_perm');
}
$this->ifthd->skin->set_section( 'Knowledge Base / Custom Pages Control' );
$this->ifthd->skin->set_description( 'Manage your knowledge base, categories, articles and custom pages.' );
if ( $this->ifthd->input['act'] == 'kb' )
{
switch( $this->ifthd->input['code'] )
{
case 'list':
$this->list_articles();
break;
case 'add':
$this->add_article();
break;
case 'edit':
$this->edit_article();
break;
case 'doadd':
$this->do_add();
break;
case 'doedit':
$this->do_edit();
break;
case 'dodel':
$this->do_delete();
break;
default:
$this->show_cats();
break;
}
}
elseif ( $this->ifthd->input['act'] == 'kbcat' )
{
switch( $this->ifthd->input['code'] )
{
case 'list':
$this->show_cats();
break;
case 'edit':
$this->edit_cat();
break;
case 'delete':
$this->delete_cat();
break;
case 'doadd':
$this->do_add_cat();
break;
case 'doedit':
$this->do_edit_cat();
break;
case 'dodel':
$this->do_delete_cat();
break;
default:
$this->show_cats();
break;
}
}
}
#=======================================
# @ Show Categories
# Show the categories / default page.
#=======================================
function show_cats($error='', $alert='')
{
#=============================
# Grab Departments
#=============================
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'categories',
) );
$this->ifthd->core->db->execute();
$cat_rows = ""; // Initialize for Security
$row_count = 0; // Initialize for Security
if ( $this->ifthd->core->db->get_num_rows() )
{
while( $c = $this->ifthd->core->db->fetch_row() )
{
$row_count ++;
( $row_count & 1 ) ? $row_class = 'option1-med' : $row_class = 'option2-med';
#=============================
# Fix Up Information
#=============================
$c['description'] = $this->ifthd->shorten_str( $c['description'], 80, 1 );
$cat_rows .= "
| {$c['id']} |
{$c['name']} |
{$c['description']} |
{$c['articles']} |
 |
 |
";
}
}
else
{
$cat_rows .= "
| There are no categories to display. |
";
}
#=============================
# Do Output
#=============================
if ( $error )
{
$error = "{$error}
";
}
elseif ( $alert )
{
$error = "{$alert}
";
}
$this->output = "{$error}
| ID |
Name |
Description |
Articles |
Edit |
Delete |
". $cat_rows ."
";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Management",
"Knowledge Base",
"List Categories",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Manage Categories' ) );
}
#=======================================
# @ Edit Category
# Show edit category form.
#=======================================
function edit_cat($error="")
{
#=============================
# Security Checks
#=============================
$this->ifthd->input['id'] = intval( $this->ifthd->input['id'] );
if ( ! $this->ifthd->member['acp']['manage_cat_edit'] )
{
$this->ifthd->skin->error('no_perm');
}
$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->skin->error('no_category');
}
$c = $this->ifthd->core->db->fetch_row();
#=============================
# Do Output
#=============================
if ( $error )
{
$error = "{$error}}
";
$name = $this->ifthd->input['name'];
$description = $this->ifthd->input['description'];
}
else
{
$name = $c['name'];
$description = $c['description'];
}
$this->output = "
";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Management",
"Knowledge Base",
"Edit Category",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Manage Categories' ) );
}
#=======================================
# @ Delete Category
# Show delete category form.
#=======================================
function delete_cat()
{
#=============================
# Security Checks
#=============================
$this->ifthd->input['id'] = intval( $this->ifthd->input['id'] );
if ( ! $this->ifthd->member['acp']['manage_cat_delete'] )
{
$this->ifthd->skin->error('no_perm');
}
$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->skin->error('no_category');
}
$c = $this->ifthd->core->db->fetch_row();
#=============================
# Do Output
#=============================
$cat_drop = $this->ifthd->build_cat_drop( 0, $c['id'] );
$this->output = "";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Management",
"Knowledge Base",
"Delete Category",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Manage Categories' ) );
}
#=======================================
# @ Do Create Category
# Create a new KB category.
#=======================================
function do_add_cat()
{
#=============================
# Security Checks
#=============================
if ( ! $this->ifthd->member['acp']['manage_cat_add'] )
{
$this->ifthd->skin->error('no_perm');
}
if ( ! $this->ifthd->input['name'] )
{
$this->show_cats('Please enter a name.');
}
if ( ! $this->ifthd->input['description'] )
{
$this->show_cats('Please enter a description.');
}
#=============================
# Add Category
#=============================
$db_array = array(
'name' => $this->ifthd->input['name'],
'description' => $this->ifthd->input['description'],
);
$this->ifthd->core->db->construct( array(
'insert' => 'categories',
'set' => $db_array,
) );
$this->ifthd->core->db->execute();
$cat_id = $this->ifthd->core->db->get_insert_id();
$this->ifthd->log( 'admin', "KB Category Added '". $this->ifthd->input['name'] ."'", 1, $cat_id );
#=============================
# Rebuild Cache
#=============================
$this->ifthd->rebuild_cat_cache();
#=============================
# Redirect
#=============================
#$this->ifthd->skin->redirect( '?section=manage&act=kbcat&code=list', 'add_cat_success' );
$this->show_cats( '', 'The category has been successfully added.' );
}
#=======================================
# @ Do Edit Category
# Edit a KB category.
#=======================================
function do_edit_cat()
{
#=============================
# Security Checks
#=============================
$this->ifthd->input['id'] = intval( $this->ifthd->input['id'] );
if ( ! $this->ifthd->member['acp']['manage_cat_edit'] )
{
$this->ifthd->skin->error('no_perm');
}
$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->skin->error('no_category');
}
if ( ! $this->ifthd->input['name'] )
{
$this->edit_cat('Please enter a name.');
}
if ( ! $this->ifthd->input['description'] )
{
$this->edit_cat('Please enter a description.');
}
#=============================
# Edit Category
#=============================
$db_array = array(
'name' => $this->ifthd->input['name'],
'description' => $this->ifthd->input['description'],
);
$this->ifthd->core->db->construct( array(
'update' => 'categories',
'set' => $db_array,
'where' => array( 'id', '=', $this->ifthd->input['id'] ),
) );
$this->ifthd->core->db->execute();
$this->ifthd->log( 'admin', "KB Category Updated '". $this->ifthd->input['name'] ."'", 1, $this->ifthd->input['id'] );
#=============================
# Rebuild Cache
#=============================
$this->ifthd->rebuild_cat_cache();
#=============================
# Redirect
#=============================
#$this->ifthd->skin->redirect( '?section=manage&act=kbcat&code=list', 'edit_cat_success' );
$this->show_cats( '', 'The category has been successfully updated.' );
}
#=======================================
# @ Do Delete Category
# Delete a KB category.
#=======================================
function do_delete_cat()
{
#=============================
# Security Checks
#=============================
$this->ifthd->input['id'] = intval( $this->ifthd->input['id'] );
if ( ! $this->ifthd->member['acp']['manage_cat_delete'] )
{
$this->ifthd->skin->error('no_perm');
}
$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->skin->error('no_category');
}
$c = $this->ifthd->core->db->fetch_row();
#=============================
# Perform Our Action
#=============================
if ( $this->ifthd->input['action'] == 1 )
{
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'categories',
'where' => array( 'id', '=', $this->ifthd->input['moveto'] ),
'limit' => array( 0,1 ),
) );
$this->ifthd->core->db->execute();
if ( ! $this->ifthd->core->db->get_num_rows() )
{
$this->ifthd->skin->error('no_category');
}
$cb = $this->ifthd->core->db->fetch_row();
#=============================
# Update New Category
#=============================
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'articles',
'where' => array( 'cat_id', '=', $c['id'] ),
) );
$this->ifthd->core->db->execute();
$num_articles = $this->ifthd->core->db->get_num_rows();
$this->ifthd->core->db->next_no_quotes('set');
$this->ifthd->core->db->construct( array(
'update' => 'categories',
'set' => array( 'articles' => 'articles+'. $num_articles ),
'where' => array( 'id', '=', $this->ifthd->input['moveto'] ),
'limit' => array( 1 ),
) );
$this->ifthd->core->db->execute();
#=============================
# Update Articles
#=============================
$this->ifthd->core->db->construct( array(
'update' => 'articles',
'set' => array( 'cat_id' => $cb['id'], 'cat_name' => $cb['name'] ),
'where' => array( 'cat_id', '=', $c['id'] ),
) );
$this->ifthd->core->db->execute();
}
elseif ( $this->ifthd->input['action'] == 2 )
{
$this->ifthd->core->db->construct( array(
'delete' => 'articles',
'where' => array( 'cat_id', '=', $c['id'] ),
) );
$this->ifthd->core->db->execute();
}
#=============================
# Delete Category
#=============================
$this->ifthd->core->db->construct( array(
'delete' => 'categories',
'where' => array( 'id', '=', $c['id'] ),
'limit' => array( 1 ),
) );
$this->ifthd->core->db->execute();
$this->ifthd->log( 'admin', "KB Category Deleted '". $c['name'] ."'", 2, $c['id'] );
#=============================
# Rebuild Cache
#=============================
$this->ifthd->rebuild_cat_cache();
#=============================
# Redirect
#=============================
#$this->ifthd->skin->redirect( '?section=manage&act=kbcat&code=list', 'delete_cat_success' );
$this->show_cats( 'The category has been successfully deleted.' );
}
#=======================================
# @ List Articles
# Show a list of articles.
#=======================================
function list_articles($error='', $alert='')
{
#=============================
# Sorting Options
#=============================
$this->ifthd->input['cat'] = intval( $this->ifthd->input['cat'] );
$link_extra = ""; // Initialize for Security
if ( $this->ifthd->input['cat'] )
{
$link_extra = '&cat='. $this->ifthd->input['cat'];
}
if ( $this->ifthd->input['sort'] )
{
$sort = $this->ifthd->input['sort'];
}
else
{
$sort = 'id';
}
$order_var = "order_". $sort;
$img_var = "img_". $sort;
if ( $this->ifthd->input['order'] )
{
$order = strtoupper( $this->ifthd->input['order'] );
}
if ( $order == 'DESC' )
{
$$order_var = "&order=asc";
$$img_var = " 
";
}
else
{
$$order_var = "&order=desc";
$$img_var = " 
";
}
$link_id = "ID". $img_id ."";
$link_name = "Name". $img_name ."";
$link_description = "Description". $img_description ."";
if ( $this->ifthd->input['sort'] )
{
$link_extra .= "&sort=". $this->ifthd->input['sort'];
}
if ( $this->ifthd->input['order'] )
{
$link_extra .= "&order=". $this->ifthd->input['order'];
}
#=============================
# Grab Articles
#=============================
if ( $this->ifthd->input['st'] )
{
$start = $this->ifthd->input['st'];
}
else
{
$start = 0;
}
// Filter?
if ( $this->ifthd->input['cat'] )
{
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'articles',
'where' => array( 'cat_id', '=', $this->ifthd->input['cat'] ),
'order' => array( $sort => $order ),
) );
}
else
{
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'articles',
'order' => array( $sort => $order ),
) );
}
$this->ifthd->core->db->execute();
$article_rows = ""; // Initialize for Security
$row_count = 0; // Initialize for Security
if ( ! $kb_count = $this->ifthd->core->db->get_num_rows() )
{
$this->ifthd->skin->error('no_articles_found');
}
// Filter?
if ( $this->ifthd->input['cat'] )
{
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'articles',
'where' => array( 'cat_id', '=', $this->ifthd->input['cat'] ),
'order' => array( $sort => $order ),
'limit' => array( $start, 20 ),
) );
}
else
{
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'articles',
'order' => array( $sort => $order ),
'limit' => array( $start, 20 ),
) );
}
$this->ifthd->core->db->execute();
while( $a = $this->ifthd->core->db->fetch_row() )
{
$row_count ++;
( $row_count & 1 ) ? $row_class = 'option1-med' : $row_class = 'option2-med';
#=============================
# Fix Up Information
#=============================
$a['description'] = $this->ifthd->shorten_str( $a['description'], 80, 1 );
$article_rows .= "
| {$a['id']} |
{$a['name']} |
{$a['description']} |
|
|
";
}
$page_links = $this->ifthd->page_links( '?section=manage&act=kb&code=list'. $link_extra, $kb_count, 20, $start, 1 );
if ( $page_links )
{
$page_links = "
". $page_links;
}
#=============================
# Do Output
#=============================
if ( $error )
{
$error = "{$error}
";
}
elseif ( $alert )
{
$error = "{$alert}
";
}
$this->output = "
{$error}
| {$link_id} |
{$link_name} |
{$link_description} |
Edit |
Delete |
". $article_rows ."
{$page_links}";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Management",
"Knowledge Base",
"List Articles",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Manage Articles' ) );
}
#=======================================
# @ Add Article
# Show add article form.
#=======================================
function add_article($error="")
{
#=============================
# Do Output
#=============================
if ( ! $this->ifthd->member['acp']['manage_article_add'] )
{
$this->ifthd->skin->error('no_perm');
}
$cat_drop = $this->ifthd->build_cat_drop();
if ( $error )
{
$error = "{$error}
";
}
$this->output = "";
if ( $this->ifthd->member['use_rte'] && $this->ifthd->core->cache['config']['enable_kb_rte'] )
{
$this->output .= "
";
}
$this->output .= "{$error}
";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Management",
"Knowledge Base",
"Add Article",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Manage Articles' ) );
}
#=======================================
# @ Edit Article
# Show edit article form.
#=======================================
function edit_article($error="")
{
#=============================
# Security Checks
#=============================
$this->ifthd->input['id'] = intval( $this->ifthd->input['id'] );
if ( ! $this->ifthd->member['acp']['manage_article_edit'] )
{
$this->ifthd->skin->error('no_perm');
}
$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->skin->error('no_article');
}
$a = $this->ifthd->core->db->fetch_row();
#=============================
# Do Output
#=============================
if ( $error )
{
$error = "{$error}
";
$name = $this->ifthd->input['name'];
$description = $this->ifthd->input['description'];
$keywords = $this->ifthd->input['keywords'];
$article = $this->ifthd->input['article'];
$dis_comments = $this->ifthd->input['dis_comments'];
$dis_rating = $this->ifthd->input['dis_rating'];
$cat_drop = $this->ifthd->build_cat_drop( $this->ifthd->input['category'] );
}
else
{
$name = $a['name'];
$description = $a['description'];
$keywords = $a['keywords'];
$article = $a['article'];
$dis_comments = $a['dis_comments'];
$dis_rating = $a['dis_rating'];
$cat_drop = $this->ifthd->build_cat_drop( $a['cat_id'] );
}
$this->output = "";
if ( $this->ifthd->member['use_rte'] && $this->ifthd->core->cache['config']['enable_kb_rte'] )
{
$this->output .= "
";
}
$this->output .= "{$error}
";
$this->ifthd->skin->add_output( $this->output );
$this->nav = array(
"Management",
"Knowledge Base",
"Edit Article",
);
$this->ifthd->skin->do_output( array( 'nav' => $this->nav, 'title' => 'Manage Articles' ) );
}
#=======================================
# @ Do Add Article
# Create a new article.
#=======================================
function do_add()
{
#=============================
# Security Checks
#=============================
if ( ! $this->ifthd->member['acp']['manage_article_add'] )
{
$this->ifthd->skin->error('no_perm');
}
if ( ! $this->ifthd->input['name'] )
{
$this->add_article('Please enter a name.');
}
if ( ! $this->ifthd->input['description'] )
{
$this->add_article('Please enter a description.');
}
$this->ifthd->input['article'] = $this->ifthd->remove_extra_lbs( $this->ifthd->input['article'] );
if ( ! $this->ifthd->input['article'] )
{
$this->add_article('Please enter article content.');
}
#=============================
# Grab Category
#=============================
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'categories',
'where' => array( 'id', '=', $this->ifthd->input['category'] ),
'limit' => array( 0,1 ),
) );
$this->ifthd->core->db->execute();
if ( ! $this->ifthd->core->db->get_num_rows() )
{
$this->ifthd->skin->error('no_category');
}
$c = $this->ifthd->core->db->fetch_row();
#=============================
# Keywords
#=============================
$keywords = ""; // Initialize for Security
if ( $this->ifthd->input['keywords'] )
{
$raw_keys = preg_split( "(,|\|)", $this->ifthd->input['keywords'] );
while ( list( , $good_key ) = each( $raw_keys ) )
{
$better_key = trim( $good_key );
if ( $better_key )
{
$keywords .= $better_key ."|";
}
$better_key = "";
}
$keywords = substr( $keywords, 0, -1 ); // Remove trailing bar
}
#=============================
# Add Article
#=============================
$db_array = array(
'cat_id' => $c['id'],
'cat_name' => $c['name'],
'name' => $this->ifthd->input['name'],
'description' => $this->ifthd->input['description'],
'article' => $this->ifthd->input['article'],
'date' => time(),
'author_id' => $this->ifthd->member['id'],
'author_name' => $this->ifthd->member['name'],
'keywords' => $keywords,
'dis_comments'=> $this->ifthd->input['dis_comments'],
'dis_rating' => $this->ifthd->input['dis_rating'],
);
$this->ifthd->core->db->construct( array(
'insert' => 'articles',
'set' => $db_array,
) );
$this->ifthd->core->db->execute();
$article_id = $this->ifthd->core->db->get_insert_id();
$this->ifthd->log( 'admin', "KB Article Added '". $this->ifthd->input['name'] ."'", 1, $article_id );
#=============================
# Update Category
#=============================
$this->ifthd->core->db->next_no_quotes('set');
$this->ifthd->core->db->construct( array(
'update' => 'categories',
'set' => array( 'articles' => 'articles+1' ),
'where' => array( 'id', '=', $c['id'] ),
) );
$this->ifthd->core->db->execute();
#=============================
# Rebuild Cache
#=============================
$this->ifthd->rebuild_cat_cache();
#=============================
# Redirect
#=============================
#$this->ifthd->skin->redirect( '?section=manage&act=kb&code=list&cat='. $c['id'], 'add_article_success' );
$this->list_articles( '', 'The article has been successfully added.' );
}
#=======================================
# @ Do Edit Article
# Edit an article.
#=======================================
function do_edit()
{
#=============================
# Security Checks
#=============================
$this->ifthd->input['id'] = intval( $this->ifthd->input['id'] );
if ( ! $this->ifthd->member['acp']['manage_article_edit'] )
{
$this->ifthd->skin->error('no_perm');
}
$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->skin->error('no_article');
}
$a = $this->ifthd->core->db->fetch_row();
if ( ! $this->ifthd->input['name'] )
{
$this->edit_article('Please enter a name.');
}
if ( ! $this->ifthd->input['description'] )
{
$this->edit_article('Please enter a description.');
}
$this->ifthd->input['article'] = $this->ifthd->remove_extra_lbs( $this->ifthd->input['article'] );
if ( ! $this->ifthd->input['article'] )
{
$this->edit_article('Please enter article content');
}
#=============================
# Move Categories? *NoOoOo...*
#=============================
if ( $a['cat_id'] != $this->ifthd->input['category'] )
{
$this->ifthd->core->db->construct( array(
'select' => 'all',
'from' => 'categories',
'where' => array( 'id', '=', $this->ifthd->input['category'] ),
'limit' => array( 0,1 ),
) );
$this->ifthd->core->db->execute();
if ( ! $this->ifthd->core->db->get_num_rows() )
{
$this->ifthd->skin->error('no_category');
}
$c = $this->ifthd->core->db->fetch_row();
#=============================
# Update Old Category
#=============================
$this->ifthd->core->db->next_no_quotes('set');
$this->ifthd->core->db->construct( array(
'update' => 'categories',
'set' => array( 'articles' => 'articles-1' ),
'where' => array( 'id', '=', $a['cat_id'] ),
'limit' => array( 1 ),
) );
$this->ifthd->core->db->execute();
#=============================
# Update New Category
#=============================
$this->ifthd->core->db->next_no_quotes('set');
$this->ifthd->core->db->construct( array(
'update' => 'categories',
'set' => array( 'articles' => 'articles+1' ),
'where' => array( 'id', '=', $c['id'] ),
'limit' => array( 1 ),
) );
$this->ifthd->core->db->execute();
#=============================
# Rebuild Cache
#=============================
$this->ifthd->rebuild_cat_cache();
}
else
{
$c = array(); // Initialize for Security
$c['id'] = $a['cat_id'];
$c['name'] = $a['cat_name'];
}
#=============================
# Keywords
#=============================
$keywords = ""; // Initialize for Security
if ( $this->ifthd->input['keywords'] )
{
$raw_keys = preg_split( "(,|\|)", $this->ifthd->input['keywords'] );
while ( list( , $good_key ) = each( $raw_keys ) )
{
$better_key = trim( $good_key );
if ( $better_key )
{
$keywords .= $better_key ."|";
}
$better_key = "";
}
$keywords = substr( $keywords, 0, -1 ); // Remove trailing bar
}
#=============================
# Edit Article
#=============================
$db_array = array(
'cat_id' => $c['id'],
'cat_name' => $c['name'],
'name' => $this->ifthd->input['name'],
'description' => $this->ifthd->input['description'],
'article' => $this->ifthd->input['article'],
'updated' => time(),
'keywords' => $keywords,
'dis_comments'=> $this->ifthd->input['dis_comments'],
'dis_rating' => $this->ifthd->input['dis_rating'],
);
$this->ifthd->core->db->construct( array(
'update' => 'articles',
'set' => $db_array,
'where' => array( 'id', '=', $a['id'] ),
) );
$this->ifthd->core->db->execute();
$this->ifthd->log( 'admin', "KB Article Updated '". $this->ifthd->input['name'] ."'", 1, $a['id'] );
#=============================
# Rebuild Cache
#=============================
$this->ifthd->rebuild_cat_cache();
#=============================
# Redirect
#=============================
#$this->ifthd->skin->redirect( '?section=manage&act=kb&code=list&cat='. $c['id'], 'edit_article_success' );
$this->list_articles( '', 'The article has been successfully updated.' );
}
#=======================================
# @ Do Delete Article
# Delete an article.
#=======================================
function do_delete()
{
#=============================
# Security Checks
#=============================
$this->ifthd->input['id'] = intval( $this->ifthd->input['id'] );
if ( ! $this->ifthd->member['acp']['manage_article_delete'] )
{
$this->ifthd->skin->error('no_perm');
}
$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->skin->error('no_article');
}
$a = $this->ifthd->core->db->fetch_row();
#=============================
# DELETE *MwhaAaAaAaAa*
#=============================
$this->ifthd->core->db->construct( array(
'delete' => 'articles',
'where' => array( 'id', '=', $a['id'] ),
'limit' => array( 1 ),
) );
$this->ifthd->core->db->execute();
$this->ifthd->log( 'admin', "KB Article Deleted '". $a['name'] ."'", 2, $a['id'] );
#=============================
# Update Old Category
#=============================
$this->ifthd->core->db->next_no_quotes('set');
$this->ifthd->core->db->construct( array(
'update' => 'categories',
'set' => array( 'articles' => 'articles-1' ),
'where' => array( 'id', '=', $a['cat_id'] ),
'limit' => array( 1 ),
) );
$this->ifthd->core->db->execute();
#=============================
# Rebuild Cache
#=============================
$this->ifthd->rebuild_cat_cache();
#=============================
# Redirect
#=============================
#$this->ifthd->skin->redirect( '?section=manage&act=kb&code=list&cat='. $a['cat_id'], 'delete_article_success' );
$this->list_articles( 'The article has been successfully deleted.' );
}
}
?> 