/**
* @desc Visualiza la lista de amigos del usuario
**/
function showFriends()
{
global $xoopsOption, $tpl, $db, $xoopsUser, $xoopsModuleConfig, $pag, $xoopsConfig;
$xoopsOption['template_main'] = 'gs_panel_friends.html';
include 'header.php';
$mc =& $xoopsModuleConfig;
GSFunctions::makeHeader();
//Barra de Navegación
$sql = "SELECT COUNT(*) FROM " . $db->prefix('gs_friends') . " WHERE gsuser='******'";
$page = isset($pag) ? $pag : '';
$limit = 30;
list($num) = $db->fetchRow($db->query($sql));
if ($page > 0) {
$page -= 1;
}
$start = $page * $limit;
$tpages = (int) ($num / $limit);
if ($num % $limit > 0) {
$tpages++;
}
$pactual = $page + 1;
if ($pactual > $tpages) {
$rest = $pactual - $tpages;
$pactual = $pactual - $rest + 1;
$start = ($pactual - 1) * $limit;
}
if ($tpages > 1) {
if ($mc['urlmode']) {
$urlnav = 'cpanel/friends';
} else {
$urlnav = 'cpanel.php?by=cpanel/friends';
}
$nav = new GsPageNav($num, $limit, $start, 'pag', $urlnav, 0);
$tpl->assign('friendsNavPage', $nav->renderNav(4, 1));
}
$showmax = $start + $limit;
$showmax = $showmax > $num ? $num : $showmax;
$tpl->assign('lang_showing', sprintf(__('Sowing friends %u to %u from %u.', 'galleries'), $start + 1, $showmax, $num));
$tpl->assign('limit', $limit);
$tpl->assign('pag', $pactual);
//Fin de barra de navegación
$sql = "SELECT * FROM " . $db->prefix('gs_friends') . " WHERE gsuser='******'";
$sql .= " LIMIT {$start},{$limit}";
$result = $db->query($sql);
while ($row = $db->fetchArray($result)) {
$xu = new XoopsUser($row['uid']);
$tpl->append('users', array('uid' => $xu->uid(), 'uname' => $xu->uname(), 'link' => XOOPS_URL . "/modules/galleries/" . ($mc['urlmode'] ? "usr/" . $xu->uname() . "/" : "user.php?id=usr/" . $xu->uname()), 'avatar' => RMEvents::get()->run_event('rmcommon.get.avatar', $xu->email(), 0, $xu->user_avatar() != '' ? XOOPS_URL . '/uploads/avatars/' . $xu->user_avatar() : GS_URL . '/images/avatar.png')));
}
$tpl->assign('lang_uname', __('User name', 'galleries'));
$tpl->assign('lang_newfriend', __('New Friend', 'galleries'));
$tpl->assign('lang_del', __('Delete', 'galleries'));
$tpl->assign('lang_confirm', __('Do you really wish to delete specified friend?', 'galleries'));
$tpl->assign('lang_confirms', __('Do you really wish to delete selected friends?', 'galleries'));
$tpl->assign('form_action_add', GSFunctions::get_url() . ($mc['urlmode'] ? 'cp/add/' : '?cp=add'));
$tpl->assign('form_action_del', GSFunctions::get_url() . ($mc['urlmode'] ? 'cp/delete/' : '?cp=delete'));
$tpl->assign('delete_link', GSFunctions::get_url() . ($mc['urlmode'] ? 'cp/deletefriend/pag/' . $pactual . '/id/' : '?cp=deletefriend&page=' . $pactual . '&id='));
RMTemplate::get()->add_style('panel.css', 'galleries');
createLinks();
include 'footer.php';
}
/**
* Shows all messages sent by users and stored in database
*/
function cm_show_messages()
{
global $xoopsDB, $xoopsModuleConfig, $xoopsSecurity;
// Styles
RMTemplate::get()->add_style('admin.css', 'contact');
// Pagination
$page = rmc_server_var($_GET, 'page', 1);
$page = $page <= 0 ? 1 : $page;
$result = $xoopsDB->query("SELECT COUNT(*) FROM " . $xoopsDB->prefix("contactme"));
list($num) = $xoopsDB->fetchRow($result);
$limit = $xoopsModuleConfig['limit'];
$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('index.php?page={PAGE_NUM}');
// Get messages
$messages = array();
$result = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix("contactme") . " ORDER BY id_msg DESC LIMIT {$start},{$limit}");
$time = new RMTimeFormatter(0, __('%M% %d%, %Y%', 'contact'));
while ($row = $xoopsDB->fetchArray($result)) {
$msg = new CTMessage();
$msg->assignVars($row);
if ($msg->getVar('xuid')) {
$user = new XoopsUser($msg->getVar('xuid'));
}
$messages[] = array('id' => $msg->id(), 'subject' => $msg->getVar('subject'), 'ip' => $msg->getVar('ip'), 'email' => $msg->getVar('email'), 'name' => $msg->getVar('name'), 'company' => $msg->getVar('org'), 'body' => $msg->getVar('body'), 'phone' => $msg->getVar('phone'), 'register' => $msg->getVar('register'), 'xuid' => $msg->getVar('xuid'), 'uname' => $msg->getVar('xuid') > 0 ? $user->uname() : '', 'date' => $time->format($msg->getVar('date')));
}
RMTemplate::get()->add_local_script('admin.js', 'contact');
RMTemplate::get()->add_local_script('jquery.checkboxes.js', 'rmcommon');
xoops_cp_header();
include RMTemplate::get()->get_template('admin/ct_dashboard.php', 'module', 'contact');
xoops_cp_footer();
}
function get_submitter_info($uid)
{
if ($uid <= 0) {
return _GUESTS;
}
$poster = new XoopsUser($uid);
// check if invalid uid
if ($poster->uname() == '') {
return '';
}
if ($this->nameoruname == 'uname') {
$name = $poster->uname();
} else {
$name = trim($poster->name());
if ($name == "") {
$name = $poster->uname();
}
}
return "<a href='" . XOOPS_URL . "/userinfo.php?uid={$uid}'>{$name}</a>";
}
function showReports()
{
global $xoopsModule, $xoopsConfig, $xoopsSecurity;
//Indica la lista a mostrar
$show = isset($_REQUEST['show']) ? intval($_REQUEST['show']) : '0';
//$show = 0 Muestra todos los reportes
//$show = 1 Muestra los reportes revisados
//$show = 2 Muestra los reportes no revisados
define('RMCSUBLOCATION', $show == 0 ? 'allreps' : ($show == 1 ? 'reviews' : 'noreviewd'));
$db = XoopsDatabaseFactory::getDatabaseConnection();
//Lista de Todos los reportes
$sql = "SELECT * FROM " . $db->prefix('mod_bxpress_report') . ($show ? $show == 1 ? " WHERE zapped=1" : " WHERE zapped=0 " : '') . " ORDER BY report_time DESC";
$result = $db->queryF($sql);
$reports = array();
$tf = new RMTimeFormatter(0, '%T% %d%, %Y% %h%:%i%:%s%');
while ($rows = $db->fetchArray($result)) {
$report = new bXReport();
$report->assignVars($rows);
$user = new XoopsUser($report->user());
$post = new bXPost($report->post());
$topic = new bXTopic($post->topic());
$forum = new bXForum($post->forum());
if ($report->zappedBy() > 0) {
$zuser = new XoopsUser($report->zappedBy());
}
$reports[] = array('id' => $report->id(), 'post' => array('link' => $post->permalink(), 'id' => $report->post()), 'user' => $user->uname(), 'uid' => $user->uid(), 'date' => $tf->format($report->time()), 'report' => $report->report(), 'forum' => array('link' => $forum->permalink(), 'name' => $forum->name()), 'topic' => array('link' => $topic->permalink(), 'title' => $topic->title()), 'zapped' => $report->zapped(), 'zappedby' => $report->zappedby() > 0 ? array('uid' => $zuser->uid(), 'name' => $zuser->uname()) : '', 'zappedtime' => $report->zappedtime() > 0 ? $tf->format($report->zappedtime()) : '');
}
RMTemplate::get()->add_local_script('jquery.checkboxes.js', 'rmcommon', 'include');
RMTemplate::get()->add_local_script('admin.js', 'bxpress');
RMTemplate::get()->set_help('http://www.redmexico.com.mx/docs/bxpress-forums/introduccion/standalone/1/');
RMTemplate::get()->assign('xoops_pagetitle', __('Reports Management', 'bxpress'));
$bc = RMBreadCrumb::get();
$bc->add_crumb(__('Reports management', 'bxpress'));
xoops_cp_header();
include RMTemplate::get()->get_template('admin/forums-reports.php', 'module', 'bxpress');
xoops_cp_footer();
}
/**
* @desc Almacena la información del usuario en la base de datos
**/
function saveUsers($edit = 0)
{
global $xoopsSecurity, $mc;
foreach ($_POST as $k => $v) {
${$k} = $v;
}
$ruta = "&pag={$page}&search={$search}";
if (!$xoopsSecurity->check()) {
redirectMsg('users.php?' . ($edit ? "op=edit&id={$id}&" : '') . $ruta, __('Session token expired!', 'galleries'), 1);
die;
}
$db = XoopsDatabaseFactory::getDatabaseConnection();
if ($edit) {
//Verificamos que el usuario sea válido
if ($id <= 0) {
redirectMsg('./users.php?' . $ruta, __('User id is not valid!', 'galleries'), 1);
die;
}
//Verificamos que el usuario exista
$user = new GSUser($id);
if ($user->isNew()) {
redirectMsg('./users.php?' . $ruta, __('Specified user does not exists!', 'galleries'), 1);
die;
}
//Verificamos que el usuario no se encuentre registrado
$sql = "SELECT COUNT(*) FROM " . $db->prefix('gs_users') . " WHERE uid={$uid} AND id_user<>{$id}";
list($num) = $db->fetchRow($db->query($sql));
if ($num > 0) {
redirectMsg('./users.php?' . $ruta, __('This is user has been registered already!', 'galleries'), 1);
die;
}
} else {
//Verificamos que el usuario no se encuentre registrado
$sql = "SELECT COUNT(*) FROM " . $db->prefix('gs_users') . " WHERE uid={$uid}";
list($num) = $db->fetchRow($db->query($sql));
if ($num > 0) {
redirectMsg('./users.php?' . $ruta, __('This is user has been registered already!', 'galleries'), 1);
die;
}
$user = new GSUser();
}
$user->setUid($uid);
$xu = new XoopsUser($uid);
$user->setUname($xu->uname());
$user->setQuota($quota * 1024 * 1024);
$user->isNew() ? $user->setDate(time()) : '';
$user->setBlocked($block);
if (!$user->save()) {
redirectMsg('./users.php?' . $ruta, __('Errors ocurred while trying to save this user.', 'galleries') . '<br />' . $user->errors(), 1);
die;
} else {
if ($edit) {
@mkdir($mc['storedir'] . "/" . $user->uname(), 511);
@mkdir($mc['storedir'] . "/" . $user->uname() . "/ths", 511);
@mkdir($mc['storedir'] . "/" . $user->uname() . "/formats", 511);
} else {
mkdir($mc['storedir'] . "/" . $user->uname(), 511);
mkdir($mc['storedir'] . "/" . $user->uname() . "/ths", 511);
mkdir($mc['storedir'] . "/" . $user->uname() . "/formats", 511);
}
redirectMsg('./users.php?' . $ruta, __('User saved successfully!', 'galleries'), 0);
die;
}
}
$post->setAuthor($row['uid']);
$post->setDate($row['created']);
$post->setModDate($row['published']);
$post->setText($row['hometext'] . '<br />' . $row['bodytext']);
$post->setStatus(1);
$post->setAllowComs(1);
$post->setAdvance(0);
$post->addToCatego($cats[$row['topicid']]);
$post->save();
$stories[$row['storyid']] = $post->getID();
}
// Guardamos los comentarios
$result = $db->query("SELECT * FROM " . $db->prefix("xoopscomments") . " WHERE com_modid='" . $module->mid() . "'");
while ($row = $db->fetchArray($result)) {
$xu = new XoopsUser($row['com_uid']);
$sql = "INSERT INTO " . $db->prefix("mw_comments") . " (`post`,`nombre`,`email`,`texto`,`xu`,`fecha`,`aprovado`)\n\t\t\t\t\tVALUES ('" . $stories[$row['com_itemid']] . "','" . $xu->uname() . "','" . $xu->email() . "','{$row['com_text']}',\n\t\t\t\t\t'{$row['com_uid']}','{$row['com_created']}','" . ($row['com_status'] == 2 ? 1 : 0) . "')";
$db->queryF($sql);
$post = new NPPost($stories[$row['com_itemid']]);
$post->setComments($post->getComments() + 1);
$post->update();
}
redirect_header('posts.php', 2, _AS_NP_DBOK);
die;
break;
default:
xoops_cp_header();
makeAdminNav();
$hiddens['op'] = 'do';
$buttons['sbt']['value'] = _SUBMIT;
$buttons['sbt']['type'] = 'submit';
$util->msgBox($hiddens, 'import_news.php', sprintf(_AS_NP_CONFIRMIMPORT, 'News'), '../images/question.png', $buttons, true, 400);
/**
* @desc Almacena información de las secciones
**/
function rd_save_sections($edit = 0)
{
global $xoopsUser, $xoopsSecurity;
foreach ($_POST as $k => $v) {
${$k} = $v;
}
if (!$xoopsSecurity->check()) {
redirectMsg('./sections.php?op=new&id=' . $id, __('Session token expired!', 'docs'), 1);
die;
}
if ($id <= 0) {
redirectMsg('resources.php', __('A Document was not specified!', 'docs'), 1);
die;
}
$res = new RDResource($id);
if ($res->isNew()) {
redirectMsg('resources.php', __('Specified Document does not exists!', 'docs'), 1);
die;
}
$db = XoopsDatabaseFactory::getDatabaseConnection();
if ($edit) {
//Verifica si la sección es válida
if ($id_sec <= 0) {
redirectMsg('./sections.php?id=' . $id, __('No section has been specified', 'docs'), 1);
die;
}
//Comprueba si la sección es existente
$sec = new RDSection($id_sec);
if ($sec->isNew()) {
redirectMsg('./sections.php?id=' . $id, __('Section does not exists!', 'docs'), 1);
die;
}
//Comprueba que el título de la sección no exista
$sql = "SELECT COUNT(*) FROM " . $db->prefix('rd_sections') . " WHERE title='{$title}' AND id_res='{$id}' AND id_sec<>{$id_sec}";
list($num) = $db->fetchRow($db->queryF($sql));
if ($num > 0) {
redirectMsg('./sections.php?op=new&id=' . $id, __('Already exists another section with same title!', 'docs'), 1);
die;
}
} else {
//Comprueba que el título de la sección no exista
$sql = "SELECT COUNT(*) FROM " . $db->prefix('rd_sections') . " WHERE title='{$title}' AND id_res='{$id}'";
list($num) = $db->fetchRow($db->queryF($sql));
if ($num > 0) {
redirectMsg('./sections.php?op=new&id=' . $id, __('Already exists another section with same title!', 'docs'), 1);
die;
}
$sec = new RDSection();
}
//Genera $nameid Nombre identificador
$nameid = !isset($nameid) || $nameid == '' ? TextCleaner::getInstance()->sweetstring($title) : $nameid;
$sec->setVar('title', $title);
$sec->setVar('content', $content);
$sec->setVar('order', $order);
$sec->setVar('id_res', $id);
$sec->setVar('nameid', $nameid);
$sec->setVar('parent', $parent);
if (!isset($uid)) {
$sec->setVar('uid', $xoopsUser->uid());
$sec->setVar('uname', $xoopsUser->uname());
} else {
$xu = new XoopsUser($uid);
if ($xu->isNew()) {
$sec->setVar('uid', $xoopsUser->uid());
$sec->setVar('uname', $xoopsUser->uname());
} else {
$sec->setVar('uid', $uid);
$sec->setVar('uname', $xu->uname());
}
}
if ($sec->isNew()) {
$sec->setVar('created', time());
$sec->setVar('modified', time());
} else {
$sec->setVar('modified', time());
}
// Metas
if ($edit) {
$sec->clear_metas();
}
// Clear all metas
// Initialize metas array if not exists
if (!isset($metas)) {
$metas = array();
}
// Get meta key if "select" is visible
if (isset($meta_name_sel) && $meta_name_sel != '') {
$meta_name = $meta_name_sel;
}
// Add meta to metas array
if (isset($meta_name) && $meta_name != '') {
array_push($metas, array('key' => $meta_name, 'value' => $meta_value));
}
// Assign metas
foreach ($metas as $value) {
$sec->add_meta($value['key'], $value['value']);
}
RMEvents::get()->run_event('docs.saving.section', $sec);
if (!$sec->save()) {
if ($sec->isNew()) {
redirectMsg('./sections.php?action=new&id=' . $id, __('Database could not be updated!', 'docs') . "<br />" . $sec->errors(), 1);
die;
} else {
redirectMsg('./sections.php?action=edit&id=' . $id . '&sec=' . $id_sec, __('Sections has been saved but some errors ocurred', 'docs') . "<br />" . $sec->errors(), 1);
die;
}
} else {
$res->setVar('modified', time());
$res->save();
RMEvents::get()->run_event('docs.section.saved', $sec);
if ($return) {
redirectMsg('./sections.php?action=edit&sec=' . $sec->id() . '&id=' . $id, __('Database updated successfully!', 'docs'), 0);
} else {
redirectMsg('./sections.php?id=' . $id, __('Database updated successfully!', 'docs'), 0);
}
}
}
function get_pic_data($album, &$count, &$album_name, $limit1 = -1, $limit2 = -1, $set_caption = true)
{
global $USER, $xoopsModuleConfig, $ALBUM_SET, $CURRENT_CAT_NAME, $HTML_SUBST, $THEME_DIR;
global $GLOBALS;
global $xoopsDB, $xoopsModule, $xoopsConfig;
$myts =& MyTextSanitizer::getInstance();
// MyTextSanitizer object
$sort_array = array('na' => 'filename ASC', 'nd' => 'filename DESC', 'da' => 'pid ASC', 'dd' => 'pid DESC');
$sort_code = isset($USER['sort']) ? $USER['sort'] : $xoopsModuleConfig['default_sort_order'];
$sort_order = isset($sort_array[$sort_code]) ? $sort_array[$sort_code] : $sort_array[$xoopsModuleConfig['default_sort_order']];
$limit = $limit1 != -1 ? ' LIMIT ' . $limit1 : '';
$limit .= $limit2 != -1 ? ' ,' . $limit2 : '';
if ($limit2 == 1) {
$select_columns = '*';
} else {
$select_columns = 'pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime';
}
// Regular albums
if (is_numeric($album)) {
$album_name = get_album_name($album);
$approved = GALLERY_ADMIN_MODE ? '' : 'AND approved=\'YES\'';
$result = $xoopsDB->query("SELECT count(*) from " . $xoopsDB->prefix("xcgal_pictures") . " WHERE aid='{$album}' {$approved} {$ALBUM_SET}");
$nbEnr = $xoopsDB->fetchArray($result);
$count = $nbEnr['count(*)'];
$xoopsDB->freeRecordSet($result);
if ($select_columns != '*') {
$select_columns .= ', title, caption, owner_id';
}
$result = $xoopsDB->query("SELECT {$select_columns} from " . $xoopsDB->prefix("xcgal_pictures") . " WHERE aid='{$album}' {$approved} {$ALBUM_SET} ORDER BY {$sort_order} {$limit}");
$rowset = db_fetch_rowset($result);
$xoopsDB->freeRecordSet($result);
// Set picture caption
if ($set_caption) {
foreach ($rowset as $key => $row) {
$caption = $rowset[$key]['title'] ? "<span class=\"thumb_title\">" . $rowset[$key]['title'] . "</span>" : '';
if ($xoopsModuleConfig['caption_in_thumbview']) {
$caption .= $rowset[$key]['caption'] ? "<span class=\"thumb_caption\">" . $myts->makeTareaData4Show($rowset[$key]['caption'], 0) . "</span>" : '';
}
if ($xoopsModuleConfig['display_comment_count']) {
$comments_nr = xoops_comment_count($xoopsModule->mid(), $row['pid']);
if ($comments_nr > 0) {
$caption .= "<span class=\"thumb_num_comments\">" . sprintf(_MD_FUNC_COM, $comments_nr) . "</span>";
}
}
$rowset[$key]['caption_text'] = $caption;
}
}
return $rowset;
}
// Meta albums
switch ($album) {
case 'lastcom':
// Last comments
if ($ALBUM_SET && $CURRENT_CAT_NAME) {
$album_name = $album_name = _MD_LASTCOM . ' - ' . $CURRENT_CAT_NAME;
} else {
$album_name = _MD_LASTCOM;
}
$result = $xoopsDB->query("SELECT count(*) from " . $xoopsDB->prefix("xoopscomments") . ", " . $xoopsDB->prefix("xcgal_pictures") . " WHERE com_modid = " . $xoopsModule->mid() . " AND approved='YES' AND com_itemid = pid {$ALBUM_SET}");
$nbEnr = $xoopsDB->fetchArray($result);
$count = $nbEnr['count(*)'];
$xoopsDB->freeRecordSet($result);
if ($select_columns != '*') {
$select_columns = $select_columns . ', com_id, com_uid,com_itemid,com_rootid, com_exparams, com_created, com_title';
}
include_once XOOPS_ROOT_PATH . "/include/comment_constants.php";
$result = $xoopsDB->query("SELECT {$select_columns} FROM " . $xoopsDB->prefix("xoopscomments") . ", " . $xoopsDB->prefix("xcgal_pictures") . " WHERE com_modid = " . $xoopsModule->mid() . " AND approved = 'YES' AND pid = com_itemid AND com_status=" . XOOPS_COMMENT_ACTIVE . " {$ALBUM_SET} ORDER by com_id DESC {$limit}");
$rowset = db_fetch_rowset($result);
$xoopsDB->freeRecordSet($result);
$member_handler =& xoops_gethandler('member');
$comment_config = $xoopsModule->getInfo('comments');
if ($set_caption) {
foreach ($rowset as $key => $row) {
if ($row['com_uid'] > 0) {
$poster =& $member_handler->getUser($row['com_uid']);
if (is_object($poster)) {
$posters = '<a href="' . XOOPS_URL . '/userinfo.php?uid=' . $row['com_uid'] . '">' . $poster->getVar('uname') . '</a>';
} else {
$posters = $GLOBALS['xoopsConfig']['anonymous'];
}
} else {
$posters = $GLOBALS['xoopsConfig']['anonymous'];
}
$comtitle = '<a href="' . XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/' . $comment_config['pageName'] . '?' . $comment_config['itemName'] . '=' . $row['com_itemid'] . '&com_id=' . $row['com_id'] . '&com_rootid=' . $row['com_rootid'] . '&com_mode=flat&' . $row['com_exparams'] . '#comment' . $row['com_id'] . '">' . $row['com_title'] . '</a>';
$caption = "<span class=\"thumb_title\">" . $posters . '</span>' . "<span class=\"thumb_caption\">" . formatTimestamp($row['com_created'], 'm') . '</span>' . "<span class=\"thumb_caption\">" . $comtitle . '</span>';
$rowset[$key]['caption_text'] = $caption;
}
}
return $rowset;
break;
case 'lastup':
// Last uploads
if ($ALBUM_SET && $CURRENT_CAT_NAME) {
$album_name = _MD_LASTUP . ' - ' . $CURRENT_CAT_NAME;
} else {
$album_name = _MD_LASTUP;
}
$result = $xoopsDB->query("SELECT count(*) from " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES' {$ALBUM_SET}");
$nbEnr = $xoopsDB->fetchArray($result);
$count = $nbEnr['count(*)'];
$xoopsDB->freeRecordSet($result);
if ($select_columns != '*') {
$select_columns .= ', owner_id';
}
$result = $xoopsDB->query("SELECT {$select_columns} FROM " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES' {$ALBUM_SET} ORDER BY pid DESC {$limit}");
$rowset = db_fetch_rowset($result);
$xoopsDB->freeRecordSet($result);
if ($set_caption) {
foreach ($rowset as $key => $row) {
$user_handler =& xoops_gethandler('member');
$pic_owner =& $user_handler->getUser($row['owner_id']);
if (is_object($pic_owner)) {
$user_link = '<br /><a href ="' . XOOPS_URL . '/userinfo.php?uid=' . $pic_owner->uid() . '">' . $pic_owner->uname() . '</a>';
} else {
$user_link = '';
}
$caption = "<span class=\"thumb_caption\">" . formatTimestamp($row['ctime'], 'm') . $user_link . '</span>';
$rowset[$key]['caption_text'] = $caption;
}
}
return $rowset;
break;
case 'topn':
// Most viewed pictures
if ($ALBUM_SET && $CURRENT_CAT_NAME) {
$album_name = _MD_TOPN . ' - ' . $CURRENT_CAT_NAME;
} else {
$album_name = _MD_TOPN;
}
$result = $xoopsDB->query("SELECT count(*) from " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES' AND hits > 0 {$ALBUM_SET}");
$nbEnr = $xoopsDB->fetchArray($result);
$count = $nbEnr['count(*)'];
$xoopsDB->freeRecordSet($result);
if ($select_columns != '*') {
$select_columns .= ', hits';
}
$result = $xoopsDB->query("SELECT {$select_columns} FROM " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES' AND hits > 0 {$ALBUM_SET} ORDER BY hits DESC, ctime, mtime {$limit}");
$rowset = db_fetch_rowset($result);
$xoopsDB->freeRecordSet($result);
if ($set_caption) {
foreach ($rowset as $key => $row) {
$caption = "<span class=\"thumb_caption\">" . sprintf(_MD_FUNC_VIEW, $row['hits']) . '</span>';
$rowset[$key]['caption_text'] = $caption;
}
}
return $rowset;
break;
case 'toprated':
// Top rated pictures
if ($ALBUM_SET && $CURRENT_CAT_NAME) {
$album_name = _MD_TOPRATED . ' - ' . $CURRENT_CAT_NAME;
} else {
$album_name = _MD_TOPRATED;
}
$result = $xoopsDB->query("SELECT count(*) from " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES' AND votes >= '{$xoopsModuleConfig['min_votes_for_rating']}' {$ALBUM_SET}");
$nbEnr = $xoopsDB->fetchArray($result);
$count = $nbEnr['count(*)'];
$xoopsDB->freeRecordSet($result);
if ($select_columns != '*') {
$select_columns .= ', pic_rating, votes';
}
$result = $xoopsDB->query("SELECT {$select_columns} FROM " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES' AND votes >= '{$xoopsModuleConfig['min_votes_for_rating']}' {$ALBUM_SET} ORDER BY ROUND((pic_rating+1)/2000) DESC, votes DESC {$limit}");
$rowset = db_fetch_rowset($result);
$xoopsDB->freeRecordSet($result);
if ($set_caption) {
foreach ($rowset as $key => $row) {
if (defined('THEME_HAS_RATING_GRAPHICS')) {
$prefix = $THEME_DIR;
} else {
$prefix = '';
}
$caption = "<span class=\"thumb_caption\">" . '<img src="' . $prefix . 'images/rating' . round($row['pic_rating'] / 2000) . '.gif" align="middle" alt=""/>' . '<br />' . sprintf(_MD_FUNC_VOTE, $row['votes']) . '</span>';
$rowset[$key]['caption_text'] = $caption;
}
}
return $rowset;
break;
case 'lasthits':
// Last viewed pictures
if ($ALBUM_SET && $CURRENT_CAT_NAME) {
$album_name = _MD_LASTHITS . ' - ' . $CURRENT_CAT_NAME;
} else {
$album_name = _MD_LASTHITS;
}
$result = $xoopsDB->query("SELECT count(*) from " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES' {$ALBUM_SET}");
$nbEnr = $xoopsDB->fetchArray($result);
$count = $nbEnr['count(*)'];
$xoopsDB->freeRecordSet($result);
if ($select_columns != '*') {
$select_columns .= ', mtime';
}
$result = $xoopsDB->query("SELECT {$select_columns} FROM " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES' {$ALBUM_SET} ORDER BY mtime DESC {$limit}");
$rowset = db_fetch_rowset($result);
$xoopsDB->freeRecordSet($result);
if ($set_caption) {
foreach ($rowset as $key => $row) {
$caption = "<span class=\"thumb_caption\">" . formatTimestamp($row['mtime'], 'm') . '</span>';
$rowset[$key]['caption_text'] = $caption;
}
}
return $rowset;
break;
case 'random':
// Random pictures
if ($ALBUM_SET && $CURRENT_CAT_NAME) {
$album_name = _MD_RANDOM . ' - ' . $CURRENT_CAT_NAME;
} else {
$album_name = _MD_RANDOM;
}
$result = $xoopsDB->query("SELECT count(*) from " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES' {$ALBUM_SET}");
$nbEnr = $xoopsDB->fetchArray($result);
$pic_count = $nbEnr['count(*)'];
$xoopsDB->freeRecordSet($result);
// if we have more than 1000 pictures, we limit the number of picture returned
// by the SELECT statement as ORDER BY RAND() is time consuming
if ($pic_count > 1000) {
$result = $xoopsDB->query("SELECT count(*) from " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES'");
$nbEnr = $xoopsDB->fetchArray($result);
$total_count = $nbEnr['count(*)'];
$xoopsDB->freeRecordSet($result);
$granularity = floor($total_count / RANDPOS_MAX_PIC);
$cor_gran = ceil($total_count / $pic_count);
srand(time());
for ($i = 1; $i <= $cor_gran; $i++) {
$random_num_set = rand(0, $granularity) . ', ';
}
$random_num_set = substr($random_num_set, 0, -2);
$result = $xoopsDB->query("SELECT {$select_columns} FROM " . $xoopsDB->prefix("xcgal_pictures") . " WHERE randpos IN ({$random_num_set}) AND approved = 'YES' {$ALBUM_SET} ORDER BY RAND() LIMIT {$limit2}");
} else {
$result = $xoopsDB->query("SELECT {$select_columns} FROM " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES' {$ALBUM_SET} ORDER BY RAND() LIMIT {$limit2}");
}
$rowset = array();
while ($row = $xoopsDB->fetchArray($result)) {
$row['caption_text'] = '';
$rowset[-$row['pid']] = $row;
}
$xoopsDB->freeRecordSet($result);
return $rowset;
break;
case 'search':
// Search results
if (isset($USER['search'])) {
$search_string = $USER['search'];
} else {
$search_string = '';
}
if (substr($search_string, 0, 3) == '###') {
$query_all = 1;
$search_string = substr($search_string, 3);
} else {
$query_all = 0;
}
if ($ALBUM_SET && $CURRENT_CAT_NAME) {
$album_name = _MD_SEARCH . ' - ' . $CURRENT_CAT_NAME;
} else {
$album_name = _MD_SEARCH . ' - "' . $search_string . '"';
}
//var_dump(htmlspecialchars($search_string));
//$search_string = utf8Encode($search_string);
include 'include/search.inc.php';
return $rowset;
break;
case 'usearch':
// User pics search results
if (isset($USER['suid']) && $USER['suid'] > 0) {
$owner = new XoopsUser($USER['suid']);
$album_name = _MD_USEARCH . $owner->uname();
} else {
$album_name = 'Pics submitted by ' . $xoopsConfig['anonymous'];
}
$result = $xoopsDB->query("SELECT count(*) from " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES' AND owner_id = '{$USER['suid']}' {$ALBUM_SET}");
$nbEnr = $xoopsDB->fetchArray($result);
$count = $nbEnr['count(*)'];
$xoopsDB->freeRecordSet($result);
if ($select_columns != '*') {
$select_columns .= ', pic_rating, votes';
}
$result = $xoopsDB->query("SELECT {$select_columns} FROM " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES' AND owner_id = '{$USER['suid']}' {$ALBUM_SET} ORDER BY ctime DESC {$limit}");
$rowset = db_fetch_rowset($result);
$xoopsDB->freeRecordSet($result);
if ($set_caption) {
foreach ($rowset as $key => $row) {
$caption = "<span class=\"thumb_caption\">" . formatTimestamp($row['ctime'], 'm') . "</span>";
$rowset[$key]['caption_text'] = $caption;
}
}
return $rowset;
break;
case 'mostsend':
// Top rated pictures
if ($ALBUM_SET && $CURRENT_CAT_NAME) {
$album_name = _MD_MOST_SENT . ' - ' . $CURRENT_CAT_NAME;
} else {
$album_name = _MD_MOST_SENT;
}
$result = $xoopsDB->query("SELECT count(*) from " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES' AND sent_card > 0 {$ALBUM_SET}");
$nbEnr = $xoopsDB->fetchArray($result);
$count = $nbEnr['count(*)'];
$xoopsDB->freeRecordSet($result);
if ($select_columns != '*') {
$select_columns .= ', sent_card';
}
$result = $xoopsDB->query("SELECT {$select_columns} FROM " . $xoopsDB->prefix("xcgal_pictures") . " WHERE approved = 'YES' AND sent_card >0 {$ALBUM_SET} ORDER BY sent_card DESC {$limit}");
$rowset = db_fetch_rowset($result);
$xoopsDB->freeRecordSet($result);
if ($set_caption) {
foreach ($rowset as $key => $row) {
$caption = "<span class=\"thumb_caption\">" . sprintf(_MD_FUNC_SEND, $row['sent_card']) . '</span>';
$rowset[$key]['caption_text'] = $caption;
}
}
return $rowset;
break;
default:
// Invalid meta album
redirect_header('index.php', 2, _MD_NON_EXIST_AP);
}
}
/**
* desc Elimina de la base de datos los elementos
**/
function dt_delete_items()
{
global $xoopsModuleConfig, $xoopsConfig, $xoopsModule, $xoopsSecurity, $rmc_config, $xoopsUser;
$ids = rmc_server_var($_POST, 'ids', array());
$page = rmc_server_var($_POST, 'page', 1);
$search = rmc_server_var($_POST, 'search', '');
$sort = rmc_server_var($_POST, 'sort', 'id_soft');
$mode = rmc_server_var($_POST, 'mode', 1);
$cat = rmc_server_var($_POST, 'cat', 0);
$type = rmc_server_var($_POST, 'type', '');
$params = '?pag=' . $page . '&search=' . $search . '&sort=' . $sort . '&mode=' . $mode . '&cat=' . $cat . '&type=' . $type;
//Verificamos que el software sea válido
if (!is_array($ids) && $ids <= 0) {
redirectMsg('items.php' . $params, __('You must select at least one download item to delete!', 'dtransport'), RMMSG_WARN);
}
if (!is_array($ids)) {
$ids = array($ids);
}
if (!$xoopsSecurity->check()) {
redirectMsg('items.php' . $params, __('Session token expired!', 'dtransport'), RMMSG_ERROR);
}
$errors = '';
$mailer = new RMMailer('text/html');
$etpl = DT_PATH . '/lang/deletion_' . $rmc_config['lang'] . '.php';
if (!file_exists($etpl)) {
$etpl = DT_PATH . '/lang/deletion_en.php';
}
$mailer->template($etpl);
$mailer->assign('siteurl', XOOPS_URL);
$mailer->assign('dturl', $xoopsModuleConfig['permalinks'] ? XOOPS_URL . '/' . trim($xoopsModuleConfig['htbase'], '/') : DT_URL);
$mailer->assign('downcp', $xoopsModuleConfig['permalinks'] ? XOOPS_URL . '/' . trim($xoopsModuleConfig['htbase'], '/') . '/cp/' : DT_URL . '/?p=cpanel');
$mailer->assign('dtname', $xoopsModule->name());
$mailer->assign('sitename', $xoopsConfig['sitename']);
foreach ($ids as $id) {
$sw = new DTSoftware($id);
if ($sw->isNew()) {
continue;
}
if (!$sw->delete()) {
$errors .= $sw->errors();
continue;
}
$xu = new XoopsUser($sw->getVar('uid'));
$mailer->add_users(array($xu));
$mailer->assign('uname', $xu->name() != '' ? $xu->name() : $xu->uname());
$mailer->assign('download', $sw->getVar('name'));
$mailer->assign('email', $xu->getVar('email'));
$mailer->assign('method', $xu->getVar('notify_method'));
$mailer->set_subject(sprintf(__('Your download %s has been deleted!', 'dtransport'), $sw->getVar('name')));
if ($xu->getVar('notify_method') == 1) {
$mailer->set_from_xuser($xoopsUser);
$mailer->send_pm();
} else {
$mailer->send();
}
}
if ($errors != '') {
redirectMsg('items.php' . $params, __('Errors ocurred while trying to delete selected downloads!', 'dtransport') . '<br />' . $errors, RMMSG_ERROR);
}
redirectMsg('items.php' . $params, __('Downloads deleted successfully!', 'dtransport'), RMMSG_SUCCESS);
}
$answer = str_replace("\r\n", "<br>", $answer);
$answer = str_replace("\n", "<br>", $answer);
$faqsa['answer'] = $answer;
$faqsa['datesub'] = formatTimestamp($datesub, "D, d-M-Y, H:i");
$faqsa['counter'] = $counter;
$faqsa['question'] = $question;
//$faqsa['printer'] = "index.php?op=print&t=".$t;
//$faqsa['cjump'] = generatecjump();
$faqsa['catlink'] = "<a href='javascript:history.go(-1)'>" . _MD_BACK2CAT . "</a><b> | </b><a href='./index.php'>" . _MD_RETURN2INDEX . "</a>";
if ($uid == 0) {
$faqsa['poster'] = "Guest";
} else {
$thisUser = new XoopsUser($uid);
$thisUser->getVar("uname");
$thisUser->getVar("uid");
$faqsa['poster'] = "<a href='" . XOOPS_URL . "/userinfo.php?uid=" . $thisUser->uid() . "'>" . $thisUser->uname() . "</a>";
//$thisUser->getVar("uname");
}
$xoopsTpl->assign('faqpage', $faqsa);
$xoopsTpl->assign(array('lang_faq' => _MD_FAQ, 'lang_publish' => _MD_PUBLISH, 'lang_posted' => _MD_POSTED, 'lang_read' => _MD_READ, 'lang_times' => _MD_TIMES, 'lang_articleheading' => '<h4>' . $question . '</h4>'));
break;
case "default":
default:
global $xoopsUser, $xoopsConfig, $xoopsDB;
$index = array();
$xoopsOption['template_main'] = 'wffaq_index.html';
$result = $xoopsDB->query("SELECT * FROM " . $xoopsDB->prefix("faqcategories") . " ORDER BY name");
$total = $xoopsDB->getRowsNum($result);
if ($total == 0) {
redirect_header("javascript:history.go(-1)", 1, _MD_MAINNOCATADDED);
exit;
xoops_cp_header();
echo "<table width='100%' border='0' cellspacing='1' class='outer'><tr><td class=\"even\">";
//echo $HTTP_POST_VARS['ishtml'];
echo _AM_NOMAINTEXT . "<br />";
echo "</td></tr></table>";
break;
}
if ($article->approved && $article->type() != "admin") {
$article->setPublished(time());
$isnew = '1';
}
$article->store();
if (!empty($isnew) && $article->notifypub() && $article->uid() != 0) {
$poster = new XoopsUser($article->uid());
$subject = _AM_ARTPUBLISHED;
$message = sprintf(_AM_HELLO, $poster->uname());
$message .= "\n\n" . _AM_YOURARTPUB . "\n\n";
$message .= _AM_TITLEC . $article->title() . "\n" . _AM_URLC . XOOPS_URL . "/modules/" . $xoopsModule->dirname() . "/article.php?articleryid=" . $article->storyid() . "\n" . _AM_PUBLISHEDC . formatTimestamp($article->published(), "{$timestanp}", 0) . "\n\n";
$message .= $xoopsConfig['sitename'] . "\n" . XOOPS_URL . "";
$xoopsMailer =& getMailer();
$xoopsMailer->useMail();
$xoopsMailer->setToEmails($poster->getVar("email"));
$xoopsMailer->setFromEmail($xoopsConfig['adminmail']);
$xoopsMailer->setFromName($xoopsConfig['sitename']);
$xoopsMailer->setSubject($subject);
$xoopsMailer->setBody($message);
$xoopsMailer->send();
}
redirect_header('allarticles.php', 1, _AM_DBUPDATED);
exit;
break;
function SaveTutorial()
{
global $db, $xoopsConfig, $xoopsUser, $HTTP_POST_VARS, $myts, $eh;
if ($HTTP_POST_VARS['tid']) {
$tid = $HTTP_POST_VARS['tid'];
} else {
$tid = 0;
}
$cid = $HTTP_POST_VARS["cid"];
$smiley = intval($HTTP_POST_VARS["xsmiley"]);
$html = intval($HTTP_POST_VARS["xhtml"]);
$status = $HTTP_POST_VARS["status"];
$dir = $HTTP_POST_VARS["dir"];
$time = $HTTP_POST_VARS["time"];
$hits = $HTTP_POST_VARS["hits"];
$rating = $HTTP_POST_VARS["rating"];
$votes = $HTTP_POST_VARS["votes"];
$framebrowse = $HTTP_POST_VARS["framebrowse"];
if ($html == 0 && $smiley == 0) {
$codes = 0;
} elseif ($html == 1 && $smiley == 0) {
$codes = 1;
} elseif ($html == 0 && $smiley == 1) {
$codes = 2;
} else {
$codes = 3;
}
if ($framebrowse == 1) {
$codes += 10;
}
if ($HTTP_POST_VARS["gid"]) {
$gid = $HTTP_POST_VARS["gid"];
} else {
$gid = 0;
}
$tname = $myts->makeTboxData4Save($HTTP_POST_VARS["tname"]);
$tauthor = $myts->makeTboxData4Save($HTTP_POST_VARS["tauthor"]);
$timg = $myts->makeTboxData4Save($HTTP_POST_VARS["timg"]);
if (ereg("http://", $timg) || $timg == "") {
$timgwidth = 0;
$timgheight = 0;
} else {
$timgwidth = $HTTP_POST_VARS["timgwidth"];
$timgheight = $HTTP_POST_VARS["timgheight"];
}
$tdesc = $myts->makeTboxData4Save($HTTP_POST_VARS["tdesc"]);
$tcont = $myts->makeTareaData4Save($HTTP_POST_VARS["tcont"], $html, $smiley, 1);
$submitter = $HTTP_POST_VARS["submitter"];
$message = "";
if (!empty($HTTP_POST_VARS["tlink"])) {
$tlink = $myts->makeTboxData4Save($HTTP_POST_VARS["tlink"]);
}
// Check if Title exist
if ($tname == "") {
$message .= "<h4><font color=\"#ff0000\">";
$message .= _MD_ERRORNAME . "</font></h4><br>";
$error = 1;
}
// Check if Description exist
if ($tdesc == "") {
$message .= "<h4><font color=\"#ff0000\">";
$message .= _MD_ERRORDESC . "</font></h4><br>";
$error = 1;
}
// Check if Content exist
if ($tcont == "" && $tlink == "") {
$message .= "<h4><font color=\"#ff0000\">";
$message .= _MD_ERRORCONT . "</font></h4><br>";
$error = 1;
}
if ($error == 1) {
xoops_cp_header();
OpenTable();
echo $message;
echo "<center><input type=\"button\" value=\"" . _MD_GOBACK . "\" onclick=\"javascript:history.go(-1)\"></center>";
CloseTable();
xoops_cp_footer();
exit;
}
if ($tid == 0) {
$newid = $db->genId("tutorials_tid_seq");
$db->query("INSERT INTO " . $db->prefix("tutorials") . " (tid, cid, gid, tname, tdesc, timg, tcont, tlink, tauthor, status, codes, hits, rating, votes, date, submitter, dir, timgwidth, timgheight) VALUES ({$newid}, {$cid}, {$gid}, '{$tname}', '{$tdesc}', '{$timg}', '{$tcont}', '{$tlink}', '{$tauthor}', {$status}, {$codes}, 0, 0, 0, {$time}, {$submitter}, {$dir}, {$timgwidth}, {$timgheight})") or $eh->show("0013");
} elseif ($status == 0) {
$db->query("UPDATE " . $db->prefix("tutorials") . " set tid={$tid}, cid={$cid}, gid={$gid}, tname='{$tname}', tdesc='{$tdesc}', timg='{$timg}', tcont='{$tcont}', tlink='{$tlink}', tauthor='{$tauthor}', status={$status}, codes={$codes}, hits=0, rating=0, votes=0, date={$time}, timgwidth={$timgwidth}, timgheight={$timgheight} where tid={$tid}") or $eh->show("0013");
} elseif ($tid > 0 && $status == 3) {
$result = $db->query("SELECT status, date FROM " . $db->prefix("tutorials") . " WHERE tid={$tid}");
list($statusdb, $date) = $db->fetch_row($result);
if ($statusdb != 2) {
$time = time();
}
$date = $time;
$db->query("UPDATE " . $db->prefix("tutorials") . " set tid={$tid}, cid={$cid}, gid={$gid}, tname='{$tname}', tdesc='{$tdesc}', timg='{$timg}', tcont='{$tcont}', tlink='{$tlink}', tauthor='{$tauthor}', status={$status}, codes={$codes}, date={$date}, timgwidth={$timgwidth}, timgheight={$timgheight} where tid={$tid}") or $eh->show("0013");
} else {
$date = time();
$db->query("UPDATE " . $db->prefix("tutorials") . " set tid={$tid}, cid={$cid}, gid={$gid}, tname='{$tname}', tdesc='{$tdesc}', timg='{$timg}', tcont='{$tcont}', tlink='{$tlink}', tauthor='{$tauthor}', status={$status}, codes={$codes}, date={$date}, timgwidth={$timgwidth}, timgheight={$timgheight} where tid={$tid}") or $eh->show("0013");
}
if ($status == 1 || $status == 3) {
$result = $db->query("SELECT submitter FROM " . $db->prefix("tutorials") . " WHERE tid={$tid}");
list($submitter) = $db->fetch_row($result);
if ($xoopsUser->uid() != $submitter) {
$submitter = new XoopsUser($submitter);
$subject = sprintf(_MD_YOURFILEAT, $xoopsConfig['sitename']);
$message = sprintf(_MD_HELLO, $submitter->uname());
if ($status == 1) {
$message .= "\n\n" . _MD_WEAPPROVED . "\n\n";
}
if ($status == 3) {
$message .= "\n\n" . _MD_WEAPPROVEDMOD . "\n\n";
}
$siteurl = XOOPS_URL . "/modules/tutorials/";
$message .= sprintf(_MD_VISITAT, $siteurl);
$message .= "\n\n" . _MD_THANKSSUBMIT . "\n\n" . $xoopsConfig['sitename'] . "\n" . XOOPS_URL . "\n" . $xoopsConfig['adminmail'] . "";
$xoopsMailer =& getMailer();
$xoopsMailer->useMail();
$xoopsMailer->setToEmails($submitter->getVar("email"));
$xoopsMailer->setFromEmail($xoopsConfig['adminmail']);
$xoopsMailer->setFromName($xoopsConfig['sitename']);
$xoopsMailer->setSubject($subject);
$xoopsMailer->setBody($message);
$xoopsMailer->send();
}
}
redirect_header("index.php", 1, _MD_DBUPDATED);
exit;
}
/**
* @desc Almacena la información del grupo de imágenes
**/
function saveBulkImages()
{
global $util, $mc, $xoopsUser;
XoopsLogger::getInstance()->activated = false;
XoopsLogger::getInstance()->renderingEnabled = false;
set_time_limit(0);
foreach ($_POST as $k => $v) {
${$k} = $v;
}
$ruta = "page={$page}&search={$search}&owner={$uid}&sort={$sort}&mode={$mode}";
if ($xoopsUser->uid() == $uid) {
$xu = $xoopsUser;
} else {
$xu = new XoopsUser($uid);
}
//Verificamos si el usuario se encuentra registrado
$user = new GSUser($xu->uname());
if ($user->isNew()) {
//Insertamos información del usuario
$user->setUid($uid);
$user->setUname($xu->uname());
$user->setQuota($mc['quota'] * 1024 * 1024);
$user->setDate(time());
if (!$user->save()) {
send_error(__('User owner could not be created!', 'galleries') . "<br />" . $user->errors());
die;
} else {
mkdir($mc['storedir'] . "/" . $user->uname());
mkdir($mc['storedir'] . "/" . $user->uname() . "/ths");
mkdir($mc['storedir'] . "/" . $user->uname() . "/formats");
}
} else {
@mkdir($mc['storedir'] . "/" . $user->uname());
@mkdir($mc['storedir'] . "/" . $user->uname() . "/ths");
@mkdir($mc['storedir'] . "/" . $user->uname() . "/formats");
}
// Insertamos las etiquetas
$tgs = explode(",", $tags);
/**
* @desc Almacena los ids de las etiquetas que se asignarán a la imágen
*/
$ret = array();
foreach ($tgs as $k) {
$k = trim($k);
if ($k == '') {
continue;
}
// Comprobamos que la palabra tenga la longitud permitida
if (strlen($k) < $mc['min_tag'] || strlen($k) > $mc['max_tag']) {
continue;
}
// Creamos la etiqueta
$tag = new GSTag($k);
if (!$tag->isNew()) {
// Si ya existe nos saltamos
$ret[] = $tag->id();
continue;
}
$tag->setTag($k);
if ($tag->save()) {
$ret[] = $tag->id();
}
}
$errors = '';
$k = 1;
include_once RMCPATH . '/class/uploader.php';
$updir = $mc['storedir'] . "/" . $xu->uname();
$upths = $mc['storedir'] . "/" . $xu->uname() . "/ths";
// Cargamos la imágen
if (!file_exists($updir)) {
mkdir($updir, 511);
}
if (!file_exists($upths)) {
mkdir($upths, 511);
}
$uploader = new RMFileUploader($updir, $mc['size_image'] * 1024, array('gif', 'jpg', 'jpeg', 'png'));
$err = array();
if (!$uploader->fetchMedia('Filedata')) {
send_error($uploader->getErrors());
}
if (!$uploader->upload()) {
send_error($uploader->getErrors());
}
// Insertamos el archivo en la base de datos
$img = new GSImage();
$img->setTitle($uploader->savedFileName);
$img->setOwner($uid);
$img->setPublic(2);
$img->setCreated(time());
$img->setImage($uploader->getSavedFileName());
if (!$image->save()) {
unlink($uploader->savedDestination);
send_error(__('File could not be inserted to database!', 'galleries'));
}
$ret['message'] = '1';
$ret['id'] = $image->id();
echo json_encode($ret);
die;
}
function sendChat() {
global $xoopsDB, $xoopsUser;
$from = $_SESSION['xoopsUserId'];
$to = $_POST['to'];
$message = $_POST['message'];
$user = new XoopsUser($from);
$uname = $user->uname();
$avatar =$user->user_avatar();
if ($avatar!='blank.gif') {
$avatarURL = XOOPS_URL."/uploads/".$avatar;
} else {
$avatarURL = XOOPS_URL."/modules/xim/images/default_avatar.png";
}
$_SESSION['openChatBoxes'][$_POST['to']] = date('Y-m-d H:i:s', time());
$config = im_Getconfig($user);
$soundUrl = XOOPS_URL.'/modules/xim/media/0.mp3';
$status = $config['status'];
$messagesan = sanitize($message);
header('Content-type: application/json');
echo '{"message":"'.$messagesan.'"}';
if (!isset($_SESSION['chatHistory'][$_POST['to']])) {
$_SESSION['chatHistory'][$_POST['to']] = '';
}
$_SESSION['chatHistory'][$_POST['to']] .= <<<EOD
{"s":"1","n":"{$uname}","a":"$avatarURL","f":"{$to}","m":"{$messagesan}","q":"$soundUrl","p":"$status"},
EOD;
unset($_SESSION['tsChatBoxes'][$_POST['to']]);
$sql = "insert into ".$xoopsDB->prefix(xim_chat)." (".$xoopsDB->prefix(xim_chat).".from,".$xoopsDB->prefix(xim_chat).".to,message,sent) values ('".mysql_real_escape_string($from)."', '".mysql_real_escape_string($to)."','".mysql_real_escape_string($message)."',NOW())";
$query = $xoopsDB->query($sql);
//echo "1";
exit(0);
}
$n = 0;
echo "<form method='post'>\n";
if ($count > $max) {
echo "<div>" . $nav->renderNav() . "</div>";
}
echo "<table class='outer'>\n";
echo "<tr><th>" . _AM_RESERVATION . "</th><th>" . _AM_EVENT_DAY . "</th><th>" . _AM_TITLE . "</th>";
echo "<th>" . _AM_POSTER . "</th><th>" . _AM_DISP_STATUS . "</th>";
echo "<th>" . _AM_OPERATION . "</th></tr>\n";
while ($data = $xoopsDB->fetchArray($result)) {
$bg = $tags[$n++ % 2];
$eid = $data['eid'];
$date = eventdate($data['edate']);
$title = "<a href='../event.php?eid={$eid}'>" . $data['title'] . "</a>";
$poster = new XoopsUser($data['uid']);
$u = "<a href='" . XOOPS_URL . "/userinfo.php?uid=" . $poster->uid() . "'>" . $poster->uname() . "</a>";
$s = $data['status'];
$sn = $ev_stats[$data['status']];
if ($s == STAT_DELETED) {
$sn = "<a href='../admin.php?op=delete&eid={$eid}' class='deleted'>{$sn}</a>";
} elseif ($s == STAT_POST) {
$sn = "<strong>{$sn}</strong>";
}
$ors = $xoopsDB->query("SELECT reservation FROM " . OPTBL . " WHERE eid={$eid}");
if ($xoopsDB->getRowsNum($ors)) {
list($resv) = $xoopsDB->fetchRow($ors);
$mk = "<input type='hidden' name='rv[{$eid}]' value='on' />";
$mk .= "<input type='checkbox' name='ck[{$eid}]' " . ($resv ? " checked" : "") . " />";
} else {
$mk = " ";
}
if ($d_sortby != $sortby) {
$pagenav_args .= '&sortby=' . $sortby;
}
$num_users = $xoopsDB->getRowsNum($result);
//number of users per sorted and limit query
if ($totalcount > 0) {
while ($userinfo = $xoopsDB->fetchArray($result)) {
$userinfo = new XoopsUser($userinfo['uid']);
$user = array();
$avatar = $userinfo->user_avatar();
if ($avatar == 'blank.gif' && $xoopsModuleConfig['defaultavatar']) {
$user['avatar'] = "<img src='" . XOOPS_URL . "/modules/membership/images/davatar.gif' alt='' width='64' height='64' />";
} else {
$user['avatar'] = "<img src='" . XOOPS_URL . "/uploads/" . $userinfo->user_avatar() . "' alt='' width='64' height='64' />";
}
$user['nickname'] = "<a href='" . XOOPS_URL . "/userinfo.php?uid=" . $userinfo->uid() . "'>" . $userinfo->uname("E") . "</a>";
$user['regdate'] = formatTimeStamp($userinfo->user_regdate(), "m");
$showmail = 0;
if ($userinfo->user_viewemail()) {
$showmail = 1;
} else {
if ($is_admin) {
$showmail = 1;
}
}
if ($showmail) {
$user['email'] = "<a href='mailto:" . $userinfo->email("E") . "'>";
$user['email'] .= "<img src='" . XOOPS_URL . "/images/icons/email.gif' border='0' alt='" . sprintf(_SENDEMAILTO, $userinfo->uname("E")) . "' /></a>";
} else {
$user['email'] = "";
}
function saveEdit()
{
global $db, $util, $xoopsUser;
foreach ($_POST as $k => $v) {
${$k} = $v;
}
if (!$util->validateToken()) {
redirectMsg('edits.php?op=edit&id=' . $id, _AS_AH_SESSINVALID, 1);
die;
}
if ($id <= 0) {
redirectMsg('./edits.php', _AS_AH_NOID, 1);
die;
}
$edit = new AHEdit($id);
if ($edit->isNew()) {
redirectMsg('./edits.php', _AS_AH_NOTEXISTS, 1);
die;
}
$sec = new AHSection($edit->section());
if ($sec->isNew()) {
redirectMsg('./edits.php', _AS_AH_NOTEXISTSSEC, 1);
die;
}
//Comprueba que el título de la sección no exista
$sql = "SELECT COUNT(*) FROM " . $db->prefix('pa_sections') . " WHERE title='{$title}' AND id_res='" . $sec->resource() . "' AND id_sec<>'" . $sec->id() . "'";
list($num) = $db->fetchRow($db->queryF($sql));
if ($num > 0) {
redirectMsg('./edits.php?op=edit&id=' . $edit->id(), _AS_AH_ERRTITLE, 1);
die;
}
//Genera $nameid Nombre identificador
$found = false;
$i = 0;
do {
$nameid = $util->sweetstring($title) . ($found ? $i : '');
$sql = "SELECT COUNT(*) FROM " . $db->prefix('pa_sections') . " WHERE nameid = '{$nameid}'";
list($num) = $db->fetchRow($db->queryF($sql));
if ($num > 0) {
$found = true;
$i++;
} else {
$found = false;
}
} while ($found == true);
$sec->setTitle($title);
$sec->setContent($content);
$sec->setOrder($order);
$sec->setNameId($nameid);
$sec->setParent($parent);
$sec->setVar('dohtml', isset($dohtml) ? 1 : 0);
$sec->setVar('doxcode', isset($doxcode) ? 1 : 0);
$sec->setVar('dobr', isset($dobr) ? 1 : 0);
$sec->setVar('dosmiley', isset($dosmiley) ? 1 : 0);
$sec->setVar('doimage', isset($dosmiley) ? 1 : 0);
if (!isset($uid)) {
$sec->setUid($xoopsUser->uid());
$sec->setUname($xoopsUser->uname());
} else {
$xu = new XoopsUser($uid);
if ($xu->isNew()) {
$sec->setUid($xoopsUser->uid());
$sec->setUname($xoopsUser->uname());
} else {
$sec->setUid($uid);
$sec->setUname($xu->uname());
}
}
$sec->setModified(time());
if (!$sec->save()) {
redirectMsg('edits.php', _AS_AH_DBERROR . '<br />' . $sec->errors(), 1);
die;
}
$edit->delete();
redirectMsg('edits.php', _AS_AH_DBOK, 0);
}
/**
* This function deletes all image formats, except thumbnails, for specified albums.
* This is useful when you need to regenerate images
*/
function delete_formats()
{
global $xoopsModuleConfig;
$id = rmc_server_var($_GET, 'id', 0);
$page = rmc_server_var($_GET, 'page', 1);
if ($id <= 0) {
redirectMsg("sets.php?page={$page}", __('Sorry, this is not a valid album!', 'galleries'), 1);
die;
}
$set = new GSSet($id);
if ($set->isNew()) {
redirectMsg("sets.php?page={$page}", __('Specified Album does not exists!', 'galleries'), 1);
die;
}
$db = Database::getInstance();
$t1 = $db->prefix("gs_images");
$t2 = $db->prefix("gs_setsimages");
$sql = "SELECT a.image FROM {$t1} a, {$t2} b WHERE b.id_set={$id} AND a.id_image=b.id_image";
$result = $db->query($sql);
$dir = rtrim($xoopsModuleConfig['storedir'], '/');
if ($set->uname() == '') {
$user = new XoopsUser($set->owner());
$uname = $user->uname();
} else {
$uname = $set->uname();
}
if ($uname == '') {
redirectMsg('sets.php?page=' . $page, __('Sorry, we were unable to find the album owner!', 'galleries'), 1);
break;
}
$dir .= '/' . $uname . '/formats';
if (!is_dir($dir)) {
redirectMsg('sets.php?page=' . $page, __('There are not image formats for this album.', 'galleries'), 0);
die;
}
while (list($image) = $db->fetchRow($result)) {
@unlink($dir . '/bigset_' . $image);
@unlink($dir . '/set_' . $image);
@unlink($dir . '/user_' . $image);
@unlink($dir . '/srh_' . $image);
}
$pics = $set->getPics();
$sql = "UPDATE {$t1} SET user_format=0, set_format=0, bigset_format=0, search_format=0 WHERE id_image IN (" . implode(",", $pics) . ")";
$db->queryF($sql);
redirectMsg('sets.php?page=' . $page, __('Image formats deleted!', 'galleries'), 0);
}
$data['features'][] = array('id' => $feature->id(), 'title' => $feature->title(), 'updated' => $updated, 'nameid' => $feature->nameid(), 'content' => $feature->content(), 'link' => $feature->permalink(), 'metas' => $dtfunc->get_metas('feat', $feature->id()));
}
unset($chars, $feature);
// Logs
$logs = $item->logs(true);
$data['logs'] = array();
foreach ($logs as $log) {
$data['logs'][] = array('id' => $log->id(), 'title' => $log->title(), 'content' => $log->log(), 'date' => formatTimestamp($log->date(), 's'));
}
unset($logs, $log);
$data['metas'] = $dtfunc->get_metas('down', $item->id());
$data['approved'] = $item->getVar('approved');
$xoopsTpl->assign('item', $data);
// Usuario
$dtUser = new XoopsUser($item->getVar('uid'));
$xoopsTpl->assign('dtUser', array('id' => $dtUser->uid(), 'uname' => $dtUser->uname(), 'avatar' => $dtUser->getVar('user_avatar')));
if ($mc['daydownload']) {
$xoopsTpl->assign('daily_items', $dtfunc->get_items(0, 'daily', $mc['limit_daydownload']));
$xoopsTpl->assign('daily_width', floor(100 / $mc['limit_daydownload']));
$xoopsTpl->assign('lang_daydown', __('<strong>Day</strong> Downloads', 'dtransport'));
}
// Desargas relacionadas
if ($mc['active_relatsoft']) {
$xoopsTpl->assign('lang_related', __('<strong>Related</strong> Downloads', 'dtransport'));
$xoopsTpl->assign('related_items', $dtfunc->items_by($relatedTags, 'tags', $item->id(), 'RAND()', 0, $mc['limit_relatsoft']));
}
if (!$item->getVar('approved')) {
$xoopsTpl->assign('lang_noapproved', __('This item has not been approved yet! You can view this information but other users can not.', 'dtransport'));
}
// Lenguaje
$xoopsTpl->assign('lang_new', __('New', 'dtransport'));
