Пример #1
0
    // Show suscribed
}
$char_selected = $chars = false;
// User for index by first letter
do_header(_("subs menéame"), 'm/');
print_tabs($option);
/*** SIDEBAR ****/
echo '<div id="sidebar">';
do_banner_right();
do_banner_promotions();
echo '</div>';
/*** END SIDEBAR ***/
echo '<div id="newswrap">';
switch ($option) {
    case 0:
        $subs = SitesMgr::get_subscriptions($current_user->user_id);
        $template = 'subs_simple.html';
        $all = false;
        break;
    case 1:
        $all = false;
        $template = 'subs.html';
        $sql = "select subs.*, user_id, user_login, user_avatar, count(*) as c from subs LEFT JOIN users ON (user_id = owner), sub_statuses where date > date_sub(now(), interval 5 day) and subs.id = sub_statuses.id and sub_statuses.id = sub_statuses.origen and sub_statuses.status = 'published' and subs.sub = 1 group by subs.id order by c desc limit 50";
        $subs = $db->get_results($sql);
        break;
    default:
        $all = true;
        $chars = $db->get_col("select distinct(left(ucase(name), 1)) from subs");
        // Check if we must show just those beginning with a letter
        if (!empty($_GET['c']) && ($char_selected = substr(clean_input_string($_GET['c']), 0, 1))) {
            $extra = "subs.name like '{$char_selected}%' and";
Пример #2
0
function print_subs_form($selected = false)
{
    global $db, $globals, $current_user;
    function id($s)
    {
        return $s->id;
    }
    if (!empty($globals['submnm'])) {
        $subs = false;
    } else {
        $subs = SitesMgr::get_sub_subs();
        $ids = array_map('id', $subs);
        // A link in a sub is edited from another sub, or from the main site
        // Add its selected sub.
        if ($selected != false && !in_array($selected, $ids)) {
            $e = SitesMgr::get_info($selected);
            if ($e) {
                array_unshift($subs, $e);
                // Add to the form
                array_unshift($ids, $selected);
                // Avoid to show it again if subscribed to
            }
        }
        $extras = SitesMgr::get_subscriptions($current_user->user_id);
        // Don't repeat the same subs
        $subscriptions = array();
        foreach ($extras as $s) {
            if (!in_array($s->id, $ids)) {
                $subscriptions[] = $s;
            }
        }
    }
    if ($selected == false) {
        $selected = SitesMgr::my_id();
    }
    $vars = compact('selected', 'subs', 'subscriptions');
    return Haanga::Load('form_subs.html', $vars);
}