/**
* Mostramos la lista de editores junto con
* el formulario para crear nuevos editores
*/
function show_editors()
{
global $tpl, $xoopsUser, $xoopsSecurity, $xoopsModule;
MWFunctions::include_required_files();
xoops_cp_location('<a href="./">' . $xoopsModule->name() . '</a> » ' . __('Editors', 'mywords'));
RMTemplate::get()->assign('xoops_pagetitle', __('Editors Management', 'mywords'));
include_once RMCPATH . '/class/form.class.php';
foreach ($_REQUEST as $k => $v) {
${$k} = $v;
}
$db = XoopsDatabaseFactory::getDatabaseConnection();
list($num) = $db->fetchRow($db->query("SELECT COUNT(*) FROM " . $db->prefix("mw_editors")));
$page = rmc_server_var($_GET, 'page', 1);
$limit = isset($limit) && $limit > 0 ? $limit : 15;
$tpages = ceil($num / $limit);
$page = $page > $tpages ? $tpages : $page;
$start = $num <= 0 ? 0 : ($page - 1) * $limit;
$nav = new RMPageNav($num, $limit, $page, 5);
$nav->target_url('editors.php?page={PAGE_NUM}');
$result = $db->query("SELECT * FROM " . $db->prefix("mw_editors") . " ORDER BY name LIMIT {$start},{$limit}");
$editores = array();
while ($row = $db->fetchArray($result)) {
$ed = new MWEditor();
$ed->assignVars($row);
$tpl->append('editors', $ed);
}
xoops_cp_header();
RMTemplate::get()->add_script(RMCURL . '/include/js/jquery.checkboxes.js');
RMTemplate::get()->add_script('../include/js/scripts.php?file=editors.js');
include RMTemplate::get()->get_template('admin/mywords_editors.php', 'module', 'mywords');
xoops_cp_footer();
}
public static function get_editors($start, $limit, $where = '', $sort = 'name', $order = 'ASC')
{
$db = XoopsDatabaseFactory::getDatabaseConnection();
$sql = "SELECT * FROM " . $db->prefix("mod_mywords_editors");
if ($where != '') {
$sql .= " WHERE {$where}";
}
if ($sort != '') {
$sql .= " ORDER BY {$sort} {$order}";
}
$sql .= " LIMIT {$start}, {$limit}";
$editors = array();
$result = $db->query($sql);
while ($row = $db->fetchArray($result)) {
$editor = new MWEditor();
$editor->assignVars($row);
$editors[] = $editor;
}
return $editors;
}
$drafts[] = $post;
}
$pendings = array();
$result = $db->query("SELECT * FROM " . $db->prefix("mod_mywords_posts") . " WHERE status='waiting' ORDER BY id_post DESC LIMIT 0,8");
while ($row = $db->fetchArray($result)) {
$post = new MWPost();
$post->assignVars($row);
$pendings[] = $post;
}
// Editors
$sql = "SELECT *, (SELECT COUNT(*) FROM " . $db->prefix("mod_mywords_posts") . " WHERE author=id_editor) as counter FROM " . $db->prefix("mod_mywords_editors") . " ORDER BY counter DESC LIMIT 0, 5";
$result = $db->query($sql);
$editors = array();
while ($row = $db->fetchArray($result)) {
$editor = new MWEditor();
$editor->assignVars($row);
$editors[] = array('id' => $editor->id(), 'name' => $editor->getVar('name'), 'link' => $editor->permalink(), 'total' => $row['counter']);
}
unset($editor, $result, $sql);
// URL rewriting
$rule = "RewriteRule ^" . trim($xoopsModuleConfig['basepath'], '/') . "/?(.*)\$ modules/mywords/index.php [L]";
if ($xoopsModuleConfig['permalinks'] > 1) {
$ht = new RMHtaccess('mywords');
$htResult = $ht->write($rule);
if ($htResult !== true) {
showMessage(__('An error ocurred while trying to write .htaccess file!', 'mywords'), RMMSG_ERROR);
}
} else {
$ht = new RMHtaccess('mywords');
$ht->removeRule();
$ht->write();
