$conn = getConnection();
$conn->autocommit(FALSE);
try {
$conn->osc_dbExec('DROP TABLE %st_news', DB_TABLE_PREFIX);
} catch (Exception $e) {
$conn->rollback();
echo $e->getMessage();
}
$conn->autocommit(TRUE);
}
/**
* Includes stylesheets and javascript files to templates
*/
function gz_news_add_header()
{
osc_render_file(GZ_NEWS_PLUGIN_FOLDER . 'views/news_header.php');
}
/**
* Generate admin menu page to list news
*/
osc_add_admin_menu_page(__('News', 'gz_news'), GzNewsUtils::getAdminIndexUrl(), 'gz_news');
/**
* Register a submenu into admin page, to add news
*/
osc_add_admin_submenu_page('gz_news', __('Add News', 'gz_news'), GzNewsUtils::getAdminAddUrl(), 'gz_news_add');
osc_add_hook('admin_header', 'gz_news_add_header');
osc_add_hook('header', 'gz_news_add_header');
/** Remove the uninstall hook to do not lose data
osc_add_hook(osc_plugin_path(__FILE__) . '_uninstall', 'gz_news_call_after_uninstall');
*/
osc_register_plugin(osc_plugin_path(__FILE__), 'gz_news_call_after_install');
<?php
if (osc_is_admin_user_logged_in() == FALSE) {
die;
}
$add_url = GzNewsUtils::getAdminAddUrl();
$index_url = GzNewsUtils::getAdminIndexUrl();
$dao = GzNewsDao::newInstance();
$current_page = (int) Params::getParam('new_p');
$selected = 0;
if ($current_page > 0) {
$selected = $current_page - 1;
}
$total_items = $dao->count();
$total_per_page = 10;
$total_pages = ceil($total_items / $total_per_page);
$params = array('total' => (int) $total_pages, 'selected' => $selected, 'url' => $index_url . '&new_p={PAGE}', 'sides' => 5);
// set pagination
$pagination = new Pagination($params);
$paginator_html = $pagination->doPagination();
$options = array('page' => $current_page, 'total_per_page' => $total_per_page);
$list = $dao->listItems($options);
?>
<h2 class="render-title">
<?php
_e('Listing News', 'gz_news');
?>
<a class="btn btn-mini" href="<?php
echo $add_url;
?>
