function showArticleSummary($con) { global $core; $content = '<div class="box-dashboard"><div class="top-box-dashboard">' . T_('Latest articles :') . '</div>'; $nb_articles = 0; #connectBD(); /* On recupere les infomations des articles */ $sql = "SELECT\n\t\t\tuser_fullname as fullname,\n\t\t\tpost_pubdate as pubdate,\n\t\t\tpost_title as title,\n\t\t\tpost_permalink as permalink\n\t\tFROM " . $core->prefix . "post, " . $core->prefix . "user\n\t\tWHERE " . $core->prefix . "post.user_id = " . $core->prefix . "user.user_id\n\t\tAND post_status = '1'\n\t\tAND user_status = '1'\n\t\tORDER BY pubdate DESC\n\t\tLIMIT 5"; $rs = $con->select($sql); $list_articles = "<ul>"; $max_title_length = 50; while ($rs->fetch()) { $nb_articles++; # Formatage de la date $date = mysqldatetime_to_date("d/m/Y", $rs->pubdate); # Affichage du lien $titre = html_entity_decode($rs->title, ENT_QUOTES, 'UTF-8'); if (strlen($titre) > $max_title_length) { $show = substr($titre, 0, $max_title_length) . "..."; } else { $show = $titre; } $list_articles .= '<li>' . $date . ' : <a class="tips" href="' . $rs->permalink . '" rel="<b><u>' . T_('User') . ':</u></b> ' . $rs->fullname . ' <br><b><u>' . T_('Title') . ':</u></b> ' . $titre . '" target="_blank">' . $show . '</a></li>'; } $list_articles .= "</ul>"; #closeBD(); $content .= $list_articles; $content .= '</div>'; if ($nb_articles == 0) { return ''; } return $content; }
while ($rs->fetch()) { $post_title = decode_strip($rs->post_title, 100); $post_title = '<a href="' . $rs->post_permalink . '" target="_blank">' . $post_title . '</a>'; if ($rs->post_status) { $status = 'active'; $action = '<img src="meta/icons/true-light.png" title="' . T_('Accept') . '" /> '; $action .= '<a href="javascript:refuse(' . $rs->post_id . ', \'' . $rs->user_fullname . '\', \'' . $rs->post_permalink . '\')">'; $action .= '<img src="meta/icons/warn.png" title="' . T_('Refuse') . '" /></a>'; } else { $status = 'inactive'; $action = '<a href="javascript:accept(' . $rs->post_id . ', \'' . $rs->user_fullname . '\')">'; $action .= '<img src="meta/icons/true.png" title="' . T_('Accept') . '" /></a> '; $action .= '<img src="meta/icons/warn-light.png" title="' . T_('Refuse') . '" />'; } $list .= '<tr id="line' . $rs->post_id . '" class="' . $status . '">'; $list .= '<td>' . mysqldatetime_to_date("d/m/Y", $rs->post_pubdate) . '</td>'; $list .= '<td style="text-align:center;"><b>' . $rs->user_fullname . '</b></td>'; $list .= '<td>' . $post_title . '</td>'; $list .= '<td style="text-align:center;"><span id="action' . $rs->post_id . '">' . $action . '</span></td></tr>'; } $list .= "</table>"; $content = '<h3>' . sprintf(T_('%s last posts :'), $count) . '</h3><br/>'; $content .= $list; echo $content; } else { echo '<p>' . T_('No posts found') . '</p>'; } break; default: print '<div class="flash_warning">' . T_('User bad call') . '</div>'; break;
function getOutput($sql, $num_page = 0, $nb_items = 30) { global $blog_settings, $core; $next_page = $num_page + 1; $prev_page = $num_page - 1; $rs = $core->con->select($sql); $output = showPagination($rs->count(), $num_page, $nb_items, 'updateTribeList'); $output .= ' <br /> <div id="tribelist" class="tribe-list">'; if ($rs->count() > 0) { while ($rs->fetch()) { $sql_post = generate_tribe_SQL($rs->tribe_id, 0, 0); // print $sql_post; $rs_post = $core->con->select($sql_post); $tribe_state = "private"; $tribe_state_img = "lock_locked"; if ($rs->visibility == 1) { $tribe_state = "public"; $tribe_state_img = "lock_unlock"; } $tribe_owner = T_('Admin'); if ($rs->user_id != "root") { $tribe_owner = $rs->user_id; } $tribe_name = html_entity_decode($rs->tribe_name, ENT_QUOTES, 'UTF-8'); $tribe_tags = preg_split('/,/', $rs->tribe_tags, -1, PREG_SPLIT_NO_EMPTY); $tag_list = ""; foreach ($tribe_tags as $tag_item) { $tag_list .= '<span class="tag">' . $tag_item . ' <a href="javascript:rm_tag(' . $num_page . ',' . $nb_items . ',\'' . $rs->tribe_id . '\',\'' . $tag_item . '\')">x</a>'; $tag_list .= '</a></span>'; } $tribe_notags = preg_split('/,/', $rs->tribe_notags, -1, PREG_SPLIT_NO_EMPTY); $notag_list = ""; foreach ($tribe_notags as $tag_item) { $notag_list .= '<span class="tag">' . $tag_item . ' <a href="javascript:rm_notag(' . $num_page . ',' . $nb_items . ',\'' . $rs->tribe_id . '\',\'' . $tag_item . '\')">x</a>'; $notag_list .= '</a></span>'; } $tribe_users = preg_split('/,/', $rs->tribe_users, -1, PREG_SPLIT_NO_EMPTY); $user_list = ""; foreach ($tribe_users as $user_item) { $user_list .= '<span class="user">' . $user_item . ' <a href="javascript:rm_user(' . $num_page . ',' . $nb_items . ',\'' . $rs->tribe_id . '\',\'' . $user_item . '\')">x</a>'; $user_list .= '</a></span>'; } $rm_search_action = '(' . T_('empty') . ')'; if ($rs->tribe_search) { $rm_search_action = '(<a href="javascript:rm_search(' . $num_page . ', ' . $nb_items . ',\'' . $rs->tribe_id . '\')">' . T_('clear') . '</a>)'; } $tribe_icon = ''; $icon_action = '<a href="javascript:add_icon(' . $num_page . ',' . $nb_items . ',\'' . $rs->tribe_id . '\',\'' . addslashes($tribe_name) . '\')"> <img src="meta/icons/add_icon.png" title="' . T_('Add icon to tribe') . '" /></a>'; if ($rs->tribe_icon) { $tribe_icon = '<p class="tribe-icon"><img class="tribe-icon" src="../' . $rs->tribe_icon . '" /></p>'; $icon_action = '<a href="javascript:rm_icon(' . $num_page . ',' . $nb_items . ',\'' . $rs->tribe_id . '\')"> <img src="meta/icons/rm_icon.png" title="' . T_('Remove icon from tribe') . '" /></a>'; } $output .= '<div class="tribesbox tribe-' . $tribe_state . '" id="tribe-' . $rs->tribe_id . '"> <h3><a href="' . BP_PLANET_URL . '/index.php?list=1&tribe_id=' . $rs->tribe_id . '">' . $tribe_name . '</a></h3> ' . $tribe_icon . ' <p class="nickname"> Tribe owner : ' . $tribe_owner . '<br/> Tags : <div class="tag-line">' . $tag_list . '</div><br/> No-tags : <div class="notag-line">' . $notag_list . '</div><br/> Users : <div class="user-line">' . $user_list . '</div><br/> search : ' . $rs->tribe_search . ' ' . $rm_search_action . '<br/> Last post : ' . mysqldatetime_to_date("d/m/Y", $rs_post->last) . '<br/> Post count : ' . $rs_post->count . '<br/> Ordering : ' . $rs->ordering . ' </p> <ul class="actions"> <li><a href="javascript:toggleTribeVisibility(\'' . $rs->tribe_id . '\',' . $num_page . ',' . $nb_items . ')"><img src="meta/icons/' . $tribe_state_img . '.png" title="' . T_('Toggle tribe visibility') . '"/></a></li> <li><a href="javascript:edit(\'' . $rs->tribe_id . '\', ' . $num_page . ', ' . $nb_items . ')"><img src="meta/icons/action-edit.png" title="' . T_('Edit tribe') . '" /></a></li> <li><a href="javascript:removeTribe(\'' . $rs->tribe_id . '\',' . $num_page . ',' . $nb_items . ')"><img src="meta/icons/cross.png" title="' . T_('Remove tribe') . '" /></a></li> <li><a href="javascript:add_tags(' . $num_page . ',' . $nb_items . ',\'' . $rs->tribe_id . '\',\'' . addslashes($tribe_name) . '\')"><img src="meta/icons/add_tag.png" title="' . T_('Add tags to tribe') . '"/></a></li> <li><a href="javascript:add_notags(' . $num_page . ',' . $nb_items . ',\'' . $rs->tribe_id . '\',\'' . addslashes($tribe_name) . '\')"><img src="meta/icons/add_notag.png" title="' . T_('Add unwanted tags to tribe') . '"/></a></li> <li><a href="javascript:add_users(' . $num_page . ',' . $nb_items . ',\'' . $rs->tribe_id . '\',\'' . addslashes($tribe_name) . '\')"><img src="meta/icons/add_user.png" title="' . T_('Add users to tribe') . '" /></a></li> <li><a href="javascript:add_search(' . $num_page . ',' . $nb_items . ',\'' . $rs->tribe_id . '\',\'' . addslashes($tribe_name) . '\')"><img src="meta/icons/add_search.png" title="' . T_('Add search to tribe') . '" /></a></li> <li>' . $icon_action . '</li> </ul> <div class="feedlink"><a href="' . BP_PLANET_URL . '/index.php?list=1&tribe_id=' . $rs->tribe_id . '"> <img alt="RSS" src="' . BP_PLANET_URL . '/themes/' . $blog_settings->get('planet_theme') . '/images/rss_24.png" /></a></div> </div>'; } } else { $output .= '<div class="tribebox"> ' . T_('No tribes found') . ' </div>'; } $output .= '</div>'; $output .= showPagination($rs->count(), $num_page, $nb_items, 'updateFeedList'); return $output; }
function render_page($page) { global $core, $blog_settings, $user_settings; $user_id = $core->auth->userID(); if ($user_settings == null) { $user_settings = new bpSettings($core, $user_id); } $planet_theme = $blog_settings->get('planet_theme'); $tpl = new Hyla_Tpl(dirname(__FILE__) . '/../../themes/' . $planet_theme . '/user'); $tpl->setL10nCallback('T_'); $tpl->importFile($page, $page . '.tpl'); $tpl->setVar('planet', array("url" => BP_PLANET_URL, "theme" => $blog_settings->get('planet_theme'), "title" => $blog_settings->get('planet_title'), "desc" => $blog_settings->get('planet_desc'), "keywords" => $blog_settings->get('planet_keywords'), "desc_meta" => $blog_settings->get('planet_desc_meta'), "msg_info" => $blog_settings->get('planet_msg_info'))); switch ($page) { case 'dashboard': $sql = generate_SQL(0, 10, array($user_id), array(), '', '', false, null, 2); $rs = $core->con->select($sql); while ($rs->fetch()) { $status = ""; if (!$rs->status) { $status = "disabled"; } $post = array('id' => $rs->post_id, 'title' => html_entity_decode($rs->title, ENT_QUOTES, 'UTF-8'), 'title2' => htmlspecialchars($rs->title), 'permalink' => $rs->permalink, 'pubdate' => $rs->pubdate, "date" => mysqldatetime_to_date("d/m/Y", $rs->pubdate), "status" => $status); $rs2 = $core->con->select("SELECT tag_id FROM " . $core->prefix . "post_tag\n\t\t\t\tWHERE post_id = " . $rs->post_id); $tpl->setVar('post', $post); while ($rs2->fetch()) { $tpl->setVar('tag', $rs2->tag_id); $tpl->setVar('post_id', $rs->post_id); $tpl->render('userpost.tags'); } if (!$rs->status) { $tpl->render('userpost.action'); } if ($rs->comment) { $tpl->render('userpost.action.nocomment'); } else { $tpl->render('userpost.action.comment'); } if ($blog_settings->get('allow_post_modification')) { $tpl->render('userpost.action.activate'); } $tpl->render('userpost.item'); } break; case 'profile': $rs = $core->con->select("SELECT * FROM " . $core->prefix . "user\n\t\t\tWHERE user_id = '" . $user_id . "'"); $user = array("user_id" => $user_id, 'user_fullname' => $rs->f('user_fullname'), 'user_email' => $rs->f('user_email')); $tpl->setVar('user', $user); foreach (getAllSupportedLanguages() as $lang) { $tpl->setVar('lang', array("code" => $lang['code'], "name" => $lang['name'], "selected" => $lang['code'] == $rs->f('user_lang') ? 'selected="selected"' : "")); $tpl->render("lang.select"); } $rs_feed = $core->con->select("SELECT * FROM " . $core->prefix . "feed\n\t\t\tWHERE user_id ='" . $user_id . "'"); while ($rs_feed->fetch()) { $status = ""; if (!$rs_feed->feed_status || $rs_feed->feed_status == 2) { $status = "disabled"; } $feed = array("status" => $status, "id" => $rs_feed->feed_id, "url" => $rs_feed->feed_url); $tpl->setVar('feed', $feed); if (!$rs_feed->feed_comment) { $tpl->render('userfeed.action'); } $rs_tags = $core->con->select("SELECT tag_id FROM " . $core->prefix . "feed_tag\n\t\t\t\tWHERE feed_id=" . $rs_feed->feed_id); while ($rs_tags->fetch()) { $tpl->setVar('tag', $rs_tags->tag_id); $tpl->setVar('feed_id', $rs_feed->feed_id); $tpl->render('userfeed.tags'); } if ($blog_settings->get('allow_feed_modification')) { $tpl->render('userfeed.action.activate'); } $tpl->render('userfeed.item'); } $rs_pfeed = $core->con->select("SELECT * FROM " . $core->prefix . "pending_feed\n\t\t\tWHERE user_id ='" . $user_id . "'"); if ($rs_pfeed->count() > 0) { while ($rs_pfeed->fetch()) { $feed = array("site" => $rs_pfeed->site_url, "url" => $rs_pfeed->feed_url); $tpl->setVar('pfeed', $feed); $tpl->render('userpfeed.item'); } $tpl->render('pendingfeed'); } $rs_esite = $core->con->select("SELECT * FROM " . $core->prefix . "site WHERE user_id='" . $user_id . "'"); while ($rs_esite->fetch()) { $tpl->setVar("esite", array("id" => $rs_esite->site_id, "url" => $rs_esite->site_url)); $tpl->render("existing.site"); } break; case 'social': $newsletter_options = array("nomail" => array("selected" => "", "value" => "nomail", "text" => T_('Disable newsletter')), "dayly" => array("selected" => "", "value" => "dayly", "text" => T_('Every day')), "weekly" => array("selected" => "", "value" => "weekly", "text" => T_('Every week')), "monthly" => array("selected" => "", "value" => "monthly", "text" => T_('Every month'))); $option = $user_settings->get('social.newsletter'); if (!isset($option)) { $option = 'nomail'; } $newsletter_options[$option]['selected'] = "selected"; foreach ($newsletter_options as $news) { $tpl->setVar('news', $news); $tpl->render('newsletter.option'); } $checked = array("twitter" => $user_settings->get('social.twitter') ? 'checked' : '', "statusnet" => $user_settings->get('social.statusnet') ? 'checked' : '', "shaarli" => $user_settings->get('social.shaarli') ? 'checked' : '', "shaarli-type.remote" => $user_settings->get('social.shaarli.type') == 'remote' ? 'selected="selected"' : '', "shaarli-type.local" => $user_settings->get('social.shaarli.type') == 'local' ? 'selected="selected"' : '', "google" => $user_settings->get('social.google') ? 'checked' : '', "reddit" => $user_settings->get('social.reddit') ? 'checked' : ''); $tpl->setVar('checked', $checked); $tpl->setVar('statusnet_account', $user_settings->get('social.statusnet.account')); $tpl->setVar('shaarli_instance', $user_settings->get('social.shaarli.instance')); break; case 'tribes': $rs_users = $core->con->select('SELECT user_id, user_fullname FROM ' . $core->prefix . 'user WHERE user_status=1'); while ($rs_users->fetch()) { $tpl->setVar('option', array("user_id" => $rs_users->user_id, "user_name" => $rs_users->user_fullname)); $tpl->render('tribe.option.userlist'); } # On recupere les informtions sur les membres $sql = 'SELECT user_id, tribe_id, tribe_name, tribe_tags, tribe_notags, tribe_users, tribe_nousers, tribe_search, tribe_icon, visibility, ordering FROM ' . $core->prefix . 'tribe WHERE user_id=\'' . $user_id . '\' ORDER by ordering ASC LIMIT 100 OFFSET 0'; $rs = $core->con->select($sql); if ($rs->count() > 0) { while ($rs->fetch()) { $sql_post = generate_tribe_SQL($rs->tribe_id, 0, 0); $rs_post = $core->con->select($sql_post); $tribe_state = "private"; if ($rs->visibility == 1) { $tribe_state = "public"; } $tribe_tags = preg_split('/,/', $rs->tribe_tags, -1, PREG_SPLIT_NO_EMPTY); foreach ($tribe_tags as $tag_item) { $tpl->setVar('tribe_tag', $tag_item); $tpl->setVar('tribe_id', $rs->tribe_id); $tpl->render('tribes.tag'); } $tribe_notags = preg_split('/,/', $rs->tribe_notags, -1, PREG_SPLIT_NO_EMPTY); foreach ($tribe_notags as $tag_item) { $tpl->setVar('tribe_notag', $tag_item); $tpl->setVar('tribe_id', $rs->tribe_id); $tpl->render('tribes.notag'); } $tribe_users = preg_split('/,/', $rs->tribe_users, -1, PREG_SPLIT_NO_EMPTY); foreach ($tribe_users as $user_item) { $tpl->setVar('tribe_user', $user_item); $tpl->setVar('tribe_id', $rs->tribe_id); $tpl->render('tribes.user'); } if ($rs->tribe_search) { $tpl->setVar('tribe_id', $rs->tribe_id); $tpl->render('tribes.search'); } $tribe_icon = getTribeIcon($rs->tribe_id, $rs->tribe_name, $rs->tribe_icon); $tpl->setVar('tribe_id', $rs->tribe_id); $tpl->render('tribes.icon.action'); $tribe_name = html_entity_decode($rs->tribe_name, ENT_QUOTES, 'UTF-8'); $tpl->setVar('tribe', array('id' => $rs->tribe_id, 'name' => $rs->tribe_name, 'stripped_name' => addslashes($rs->tribe_name), 'state' => $tribe_state, 'icon' => $tribe_icon, 'last_post' => mysqldatetime_to_date("d/m/Y", $rs_post->last), 'count' => $rs_post->count, 'ordering' => $rs->ordering, 'search' => $rs->tribe_search)); $tpl->render('tribes.box'); } } break; default: break; } return $tpl->render(); }
# Similar posts $post_tags = getPostTags($post_list->post_id); if ($blog_settings->get("show_similar_posts") && !empty($post_tags)) { $sql_sim = getSimilarPosts_SQL($post_list->post_id, $post_tags); $rsimilar = $core->con->select($sql_sim); if ($rsimilar->count() > 0) { $sim_html = '<div class="similar-block"><h3>' . T_('Similar posts') . '</h3><ul>'; while ($rsimilar->fetch()) { $post_permalink = $rsimilar->permalink; if ($blog_settings->get('internal_links')) { $post_permalink = BP_PLANET_URL . "/index.php?post_id=" . $rsimilar->post_id; } $sim_html .= "<li>"; $sim_html .= $rsimilar->user_fullname . " : "; $sim_html .= '<a href="' . urldecode($post_permalink) . '">' . $rsimilar->post_title; $sim_html .= "</a> (" . mysqldatetime_to_date("d/m/Y", $rsimilar->post_pubdate) . ")"; $sim_html .= "</li>"; } $sim_html .= "</ul></div>"; $item = $item . "\n<p>" . $sim_html . "</p>"; } } if ($_GET['type'] == "rss") { # Display item content echo "\t\t\t<item>\n"; echo "\t\t\t\t<title>" . $nom . " : " . $titre . "</title>\n"; echo "\t\t\t\t<link>" . htmlentities($url) . "</link>\n"; echo "\t\t\t\t<pubDate>" . date("r", strtotime($post_list->pubdate)) . "</pubDate>\n"; echo "\t\t\t\t<dc:creator>" . $nom . "</dc:creator>\n"; echo "\t\t\t\t<description><![CDATA[" . $desc . "]]></description>\n"; echo "\t\t\t\t<guid isPermaLink=\"true\">" . htmlentities($url) . "</guid>\n";
$current_page = "users"; include dirname(__FILE__) . '/tpl.php'; # header('Content-type: text/html; charset=utf-8'); # Valeurs par defaut $params = array('title' => $blog_settings->get('planet_title') . " - " . T_('Users')); $core->tpl->setVar('params', $params); $sql_users = "SELECT\n\t\t" . $core->prefix . "user.user_id,\n\t\t" . $core->prefix . "user.user_fullname,\n\t\t" . $core->prefix . "user.user_email,\n\t\t" . $core->prefix . "site.site_url,\n\t\tMAX(" . $core->prefix . "post.post_pubdate) as pubdate,\n\t\tCOUNT(" . $core->prefix . "post.post_id) as nb_post\n\tFROM " . $core->prefix . "user, " . $core->prefix . "post, " . $core->prefix . "site\n\tWHERE " . $core->prefix . "user.user_status = 1\n\tAND " . $core->prefix . "user.user_id = " . $core->prefix . "post.user_id\n\tAND " . $core->prefix . "user.user_id = " . $core->prefix . "site.user_id\n\tGROUP BY " . $core->prefix . "user.user_id\n\tORDER BY pubdate DESC"; //print $sql_users; //exit; $rs = $core->con->select($sql_users); while ($rs->fetch()) { $puser_settings = new bpSettings($core, $rs->user_id); if ($puser_settings != null && $puser_settings->get('social.shaarli')) { $shaarli = $puser_settings->get('social.shaarli.instance'); $core->tpl->setVar('user_shaarli', $shaarli); $core->tpl->render('user.shaarli'); } $user = array("id" => $rs->user_id, "fullname" => $rs->user_fullname, "email" => $rs->user_email, "website" => $rs->site_url, "last" => mysqldatetime_to_date("d/m/Y", $rs->pubdate), "nb_post" => $rs->nb_post); $core->tpl->setVar('user', $user); //$avatar_email = strtolower($rs->user_email); //$libravatar = "http://cdn.libravatar.org/avatar/".md5($avatar_email)."?default=identicon"; $libravatar = getUserIcon($rs->user_email); $core->tpl->setVar('avatar_url', $libravatar); $core->tpl->render("user.block"); } $core->tpl->render("content.users"); # Show result $analytics_code = getAnalyticsCode(); $core->tpl->setVar('analytics_html', $analytics_code); $core->renderTemplate();
function getOutput($sql, $num_page = 0, $nb_items = 30) { global $core, $blog_settings; $rs = $core->con->select($sql); $output = showPagination($rs->count(), $num_page, $nb_items, 'updateFeedList'); $output .= ' <br /> <table id="userlist" class="table-member"> <thead> <tr> <th class="tc7 tcr" scope="col">' . T_('Avatar') . '</th> <th class="tc9 tcr" scope="col">' . T_('User Informations') . '</th> <th class="tc8 tcr" scope="col">' . T_('Website') . ' & ' . T_('Feed') . '</th> <th class="tc10 tcr" scope="col">' . T_('Action') . '</th> </tr> </thead>'; while ($rs->fetch()) { $avatar_email = strtolower($rs->user_email); $avatar_url = "http://cdn.libravatar.org/avatar/" . md5($avatar_email) . "?d=" . urlencode(BP_PLANET_URL . "/themes/" . $blog_settings->get('planet_theme') . "/images/gravatar.png") . "&s=40"; $output .= '<tr class="line"> <td style="text-align: center;"> <img src="' . $avatar_url . '"> </td>'; $output .= '<td> <ul> <li>' . T_('User id') . ' : ' . $rs->puser_id . '</li> <li>' . T_('Fullname') . ' : ' . html_entity_decode(stripslashes($rs->user_fullname), ENT_QUOTES, 'UTF-8') . '</li> <li>' . T_('Email') . ' : ' . $rs->user_email . '</li> <li>' . T_('Date of submission') . ' : ' . mysqldatetime_to_date("d/m/Y", $rs->created) . '</li> </ul> </td>'; $output .= '<td> <ul> <li>' . T_('Website') . ': <a href="' . $rs->site_url . '" target="_blank" title="' . $rs->site_url . '">' . $rs->site_url . '</a></li> <li>' . T_('Feed') . ': <a href="' . $rs->feed_url . '" target="_blank" title="' . $rs->feed_url . '">' . $rs->feed_url . '</a></li> </ul> </td>'; $output .= '<td style="text-align: center;"> <a href="#" onclick="javascript:refusePendingFeed(\'' . urlencode($rs->puser_id) . '\',\'' . urlencode($rs->site_url) . '\',\'' . urlencode($rs->feed_url) . '\',\'' . urlencode($rs->user_email) . '\',\'' . urlencode($rs->user_fullname) . '\')" > <img src="meta/icons/action-remove.png" title="' . T_("Refuse") . '"/> </a> <a href="#" onclick="javascript:acceptPendingFeed(\'' . urlencode($rs->puser_id) . '\',\'' . urlencode($rs->site_url) . '\',\'' . urlencode($rs->feed_url) . '\',\'' . urlencode($rs->user_email) . '\',\'' . urlencode($rs->user_fullname) . '\')" > <img src="meta/icons/action-add.png" title="' . T_("Accept") . '"/> </a> </td>'; $output .= '</tr>'; } $output .= '</table>'; $output .= showPagination($rs->count(), $num_page, $nb_items, 'updatePendingFeedList'); return $output; }
# header('Content-type: text/html; charset=utf-8'); # Valeurs par defaut $params = array('title' => $blog_settings->get('planet_title') . " - " . T_('Users')); $core->tpl->setVar('params', $params); $user_id = ''; if ($core->auth->sessionExists()) { $user_id = $core->auth->userID(); } $sql_tribes = "SELECT\n\t\tuser_id,\n\t\ttribe_name,\n\t\ttribe_tags,\n\t\ttribe_users,\n\t\ttribe_search,\n\t\ttribe_icon,\n\t\ttribe_id\n\tFROM " . $core->prefix . "tribe\n\tWHERE (user_id = 'root' OR user_id = '" . $user_id . "')\n\t\tAND visibility = 1\n\tORDER BY ordering\n\t\t"; $rs = $core->con->select($sql_tribes); while ($rs->fetch()) { $sql_post = generate_tribe_SQL($rs->tribe_id, 0, 0); $rs_post = $core->con->select($sql_post); $tribe_icon = getTribeIcon($rs->tribe_id, $rs->tribe_name, $rs->tribe_icon); $tribe = array("id" => $rs->tribe_id, "user_id" => $rs->user_id, "name" => $rs->tribe_name, "tags" => implode(', ', getArrayFromList($rs->tribe_tags)), "users" => implode(', ', getArrayFromList($rs->tribe_users)), "search" => $rs->tribe_search, "icon" => $tribe_icon, "last" => mysqldatetime_to_date("d/m/Y", $rs_post->last), "nb_post" => $rs_post->count); $core->tpl->setVar('tribe', $tribe); $core->tpl->render("tribe.block"); } $sql_tags = "SELECT\n\t\t" . $core->prefix . "post_tag.tag_id,\n\t\tCOUNT(" . $core->prefix . "post_tag.tag_id) as weigth\n\tFROM " . $core->prefix . "post_tag\n\tGROUP BY " . $core->prefix . "post_tag.tag_id\n\tORDER BY weigth DESC\n\tLIMIT 100"; $rs = $core->con->select($sql_tags); $max = $rs->f('weight'); while ($rs->fetch()) { if ($rs->weigth > $max) { $max = $rs->weigth; } $weigth = intval($rs->weigth * 10 / $max); $tag = array("id" => $rs->tag_id, "weigth" => $weigth); $core->tpl->setVar('tag', $tag); $core->tpl->render("tag.block"); }
</th> <th class="tc5" scope="col"><?php echo T_('Nb votes'); ?> </th> <th class="tc6 tcr" scope="col"><?php echo T_('Action'); ?> </th> </tr> </thead> <?php /* Traitement de la liste */ while ($rs->fetch()) { $date = mysqldatetime_to_date("d/m/Y", $rs->pubdate); # Couleur de la ligne en fonciton du statut du membre if ($rs->status == "1") { $select = '<select name="statut" class="actif">'; $select .= '<option value="1" selected>' . T_('active') . '</option>'; $select .= '<option value="0">' . T_('inactive') . '</option>'; if ($blog_settings->get('planet_moderation')) { $select .= '<option value="2">' . T_('pending') . '</option>'; } $select .= '</select>'; $statut = T_("active"); $style = 'white'; } elseif ($rs->status == "0" || $rs->status == "2" && !$blog_settings->get('planet_moderation')) { $select = '<select name="statut" class="inactif">'; $select .= '<option value="0" selected>' . T_('inactive') . '</option>'; $select .= '<option value="1">' . T_('active') . '</option>';
function getOutput($sql, $num_page = 0, $nb_items = 30) { global $blog_settings, $core; $next_page = $num_page + 1; $prev_page = $num_page - 1; $rs = $core->con->select($sql); $output = showPagination($rs->count(), $num_page, $nb_items, 'updateFeedList'); $output .= ' <br /> <table id="feedlist" class="table-member"> <thead> <tr> <th class="tc7 tcr" scope="col">' . T_('User') . '</th> <th class="tc9 tcr" scope="col">' . T_('Website(s) user Informations') . '</th> <th class="tc8 tcr" scope="col">' . T_('Feed') . '</th> <th class="tc10 tcr" scope="col">' . T_('Action') . '</th> </tr> </thead>'; # On affiche la liste de membres while ($rs->fetch()) { if ($rs->feed_status == 1) { $status = 'active'; $toggle_status = 'disable'; $toggle_msg = T_('Disable feed'); } elseif ($rs->feed_status == 2) { $status = 'auto-disabled'; $toggle_status = 'enable'; $toggle_msg = T_('Enable feed'); } else { $status = 'inactive'; $toggle_status = 'enable'; $toggle_msg = T_('Enable feed'); } if ($rs->feed_trust) { $toggle_trust = 'untrust'; $trust_msg = T_('Untrust this feed'); } else { $toggle_trust = 'trust'; $trust_msg = T_('Trust this feed'); } if ($rs->feed_comment) { $toggle_comment = 'nocomment'; $comment_msg = T_('Disable comments on this feed'); $comment_status = 0; } else { $toggle_comment = 'comment'; $comment_msg = T_('Allow comments on this feed'); $comment_status = 1; } $user = $core->con->select("SELECT user_email FROM " . $core->prefix . "user WHERE user_id = '" . $rs->user_id . "'"); $avatar_email = strtolower($user->f('user_email')); $avatar_url = "http://cdn.libravatar.org/avatar/" . md5($avatar_email) . "?d=" . urlencode(BP_PLANET_URL . "/themes/" . $blog_settings->get('planet_theme') . "/images/gravatar.png") . "&s=40"; # Get tags from feed $sql2 = "SELECT tag_id\n\t\t\tFROM " . $core->prefix . "feed_tag\n\t\t\tWHERE feed_id = " . $rs->feed_id . ";"; $rs2 = $core->con->select($sql2); $tags = ""; while ($rs2->fetch()) { $tags .= '<span class="tag">' . $rs2->tag_id . ' <a href="javascript:rm_tag(' . $num_page . ',' . $nb_items . ',\'' . $rs->feed_id . '\', \'' . $rs2->tag_id . '\')">x</a></span>'; } $tag_action = '<a href="javascript:add_tags(' . $num_page . ',' . $nb_items . ',' . $rs->feed_id . ', \'' . htmlspecialchars($rs->feed_name) . '\')">'; $tag_action .= '<img src="meta/icons/add_tag.png" title="' . T_('Tag feed') . '" /></a>'; # Affichage de la ligne de tableau $output .= '<tr class="line ' . $status . '"><td><img src="' . $avatar_url . '" /><br />' . $rs->user_id . '</td> <td><ul> <li>' . T_('Feed name : ') . $rs->feed_name . '</li> <li>' . T_('Site URL : ') . '<a href="' . $rs->site_url . '" target="_blank">' . $rs->site_url . '</a></li> </ul></div></td>'; $output .= '<td>'; $output .= '<a href="' . $rs->feed_url . '" target="_blank" title="' . sprintf('Last checked at %s', mysqldatetime_to_date("d/m/Y H:i", $rs->feed_checked)) . '">' . $rs->feed_url . '</a>'; $output .= '<div class="tag-line">' . $tags . ' <span id="tag_action' . $rs->feed_id . '">' . $tag_action . '</span></div></td>'; $output .= '<td style="text-align: center;">'; if ($blog_settings->get('planet_moderation')) { $output .= '<a href="#" onclick="javascript:toggleFeedTrust(\'' . $rs->feed_id . '\', \'' . $num_page . '\', \'' . $nb_items . '\')"> <img src="meta/icons/action-' . $toggle_trust . '.png" title="' . $trust_msg . '" /></a>'; } if ($blog_settings->get('allow_post_comments')) { $output .= '<a href="#" onclick="javascript:toggleFeedComment(\'' . $rs->feed_id . '\', ' . $comment_status . ', \'' . $num_page . '\', \'' . $nb_items . '\')"> <img src="meta/icons/action-' . $toggle_comment . '.png" title="' . $comment_msg . '" /></a>'; } $output .= '<a href="#" onclick="javascript:toggleFeedStatus(\'' . $rs->feed_id . '\', \'' . $num_page . '\', \'' . $nb_items . '\')"> <img src="meta/icons/action-' . $toggle_status . '.png" title="' . $toggle_msg . '" /></a> <a href="#" onclick="javascript:edit(\'' . $rs->feed_id . '\', \'' . $num_page . '\', \'' . $nb_items . '\')"> <img src="meta/icons/action-edit.png" title="' . T_('Update') . '" /></a> <a href="#" onclick="javascript:removeFeed(\'' . $rs->feed_id . '\', \'' . $num_page . '\', \'' . $nb_items . '\')"> <img src="meta/icons/action-remove.png" title="' . T_('Delete') . '" /></a> </td></tr>'; } $output .= '</table>'; $output .= showPagination($rs->count(), $num_page, $nb_items, 'updateFeedList'); return $output; }
function showPostsSummary($rs, $tpl) { while ($rs->fetch()) { $max_title_length = 100; $title = html_entity_decode($rs->title, ENT_QUOTES, 'UTF-8'); if (strlen($title) > $max_title_length) { $show = substr($title, 0, $max_title_length) . "..."; } else { $show = $title; } $line = array("date" => mysqldatetime_to_date("d/m/Y", $rs->pubdate), "title" => $title, "user" => $rs->user_fullname, "short_title" => $show, "id" => $rs->post_id, "url" => "#post" . $rs->post_id); $tpl->setVar('summary', $line); $tpl->render('summary.line'); } return $tpl; }