function group_shared($requestID, $catId, $flag = 0)
{
global $db, $main_smarty, $the_template, $page_size, $cached_links;
if (!is_numeric($requestID)) {
die;
}
$link = new Link();
$group_shared_display = "";
if ($catId) {
$child_cats = '';
// do we also search the subcategories?
if (Independent_Subcategories == true) {
$child_array = '';
// get a list of all children and put them in $child_array.
children_id_to_array($child_array, table_categories, $catId);
if ($child_array != '') {
// build the sql
foreach ($child_array as $child_cat_id) {
$child_cat_sql .= ' OR `link_category` = ' . $child_cat_id . ' ';
if (Multiple_Categories) {
$child_cat_sql .= ' OR ac_cat_id = ' . $child_cat_id . ' ';
}
}
}
}
if (Multiple_Categories) {
$child_cat_sql .= " OR ac_cat_id = {$catId} ";
}
$from_where .= " AND (link_category={$catId} " . $child_cat_sql . ")";
}
$offset = (get_current_page() - 1) * $page_size;
if ($flag == 1) {
$sql = "SELECT SQL_CALC_FOUND_ROWS b.* FROM " . table_group_shared . " a\r\n\t\t\t\t LEFT JOIN " . table_links . " b ON link_id=share_link_id\r\n\t\t\t\t WHERE share_group_id = {$requestID} AND !ISNULL(link_id) {$from_where} \r\n\t\t\t\t GROUP BY link_id\r\n\t\t\t\t ORDER BY link_published_date DESC, link_date DESC ";
} else {
$sql = "SELECT SQL_CALC_FOUND_ROWS b.* FROM " . table_group_shared . " a\r\n\t\t\t\t LEFT JOIN " . table_links . " b ON link_id=share_link_id\r\n\t\t\t\t WHERE share_group_id = {$requestID} AND !ISNULL(link_id) {$from_where} \r\n\t\t\t\t GROUP BY link_id\r\n\t\t\t\t ORDER BY link_published_date DESC, link_date DESC LIMIT {$offset}, {$page_size}";
}
// Search on additional categories
if ($catId && Multiple_Categories) {
$sql = str_replace("WHERE", " LEFT JOIN " . table_additional_categories . " ON ac_link_id=link_id WHERE", $sql);
}
$links = $db->get_results($sql);
$rows = $db->get_var("SELECT FOUND_ROWS()");
if ($flag == 1) {
return $rows;
}
if ($links) {
foreach ($links as $dblink) {
$link->id = $dblink->link_id;
$cached_links[$dblink->link_id] = $dblink;
$link->read();
$group_shared_display .= $link->print_summary('summary', true);
}
}
$main_smarty->assign('group_shared_display', $group_shared_display);
//for auto scrolling
if (Auto_scroll == 2 || Auto_scroll == 3) {
$main_smarty->assign("scrollpageSize", $page_size);
$main_smarty->assign('total_row', $rows);
if ($catId) {
$main_smarty->assign('catID', $catId);
}
$main_smarty->assign('total_row', $rows);
} else {
$main_smarty->assign('group_story_pagination', do_pages($rows, $page_size, 'group_story', true));
}
}
function do_shaken()
{
global $db, $rows, $user, $offset, $page_size, $globals;
if ($globals['bot']) {
return;
}
do_user_subheader(array(_('envíos propios') => get_user_uri($user->username, 'history'), _('votados') => get_user_uri($user->username, 'shaken'), _('favoritos') => get_user_uri($user->username, 'favorites'), _('votados por amigos') => get_user_uri($user->username, 'friends_shaken')), 1, 'rss2.php?voted_by=' . $user->id, _('votadas en rss2'));
$link = new Link();
$rows = -1;
//$db->get_var("SELECT count(*) FROM votes WHERE vote_type='links' and vote_user_id=$user->id");
$links = $db->get_results("SELECT vote_link_id as id, vote_value FROM votes WHERE vote_type='links' and vote_user_id={$user->id} ORDER BY vote_date DESC LIMIT {$offset},{$page_size}");
if ($links) {
foreach ($links as $linkdb) {
$link->id = $linkdb->id;
$link->read();
if ($link->author == $user->id) {
continue;
}
echo '<div style="max-width: 60em">';
$link->print_summary('short', 0, false);
if ($linkdb->vote_value < 0) {
echo '<div class="box" style="z-index:1;margin:0 0 -5x 0;background:#FF3333;position:relative;top:-5px;left:85px;width:8em;padding: 1px 1px 1px 1px;border-color:#f00;opacity:0.9;text-align:center;font-size:0.9em;color:#fff;text-shadow: 0 1px 0 #000">';
echo get_negative_vote($linkdb->vote_value);
echo "</div>\n";
}
echo "</div>\n";
}
echo '<br/><span style="color: #FF6400;"><strong>' . _('Nota') . '</strong>: ' . _('sólo se visualizan los votos de los últimos meses') . '</span><br />';
}
}
$rows = min(100, $db->get_var("SELECT count(*) FROM links"));
}
if ($rows == 0) {
do_error(_('no hay noticias seleccionadas'), 500);
}
$links = $db->get_results("{$sql} LIMIT {$offset},{$page_size}");
if ($memcache_key) {
memcache_madd($memcache_key . 'rows', $rows, 1800);
memcache_madd($memcache_key, $links, 1800);
}
}
if ($links) {
foreach ($links as $dblink) {
$link->id = $dblink->link_id;
$link->read();
$link->print_summary('short');
}
}
do_pages($rows, $page_size);
echo '</div>';
do_footer_menu();
do_footer();
function print_period_tabs()
{
global $globals, $current_user, $range_values, $range_names;
if (!($current_range = check_integer('range')) || $current_range < 1 || $current_range >= count($range_values)) {
$current_range = 0;
}
echo '<ul class="subheader">' . "\n";
for ($i = 0; $i < count($range_values); $i++) {
if ($i == $current_range) {
function do_commented()
{
global $db, $main_smarty, $rows, $user, $offset, $page_size, $cached_links;
$output = '';
$link = new Link();
$rows = $db->get_var("SELECT count(*) FROM " . table_links . ", " . table_comments . " WHERE comment_status='published' AND comment_user_id={$user->id} AND comment_link_id=link_id");
$links = $db->get_results("SELECT DISTINCT * FROM " . table_links . ", " . table_comments . " WHERE comment_status='published' AND comment_user_id={$user->id} AND comment_link_id=link_id AND (link_status='published' OR link_status='queued') ORDER BY link_date DESC LIMIT {$offset},{$page_size}");
if ($links) {
foreach ($links as $dblink) {
$link->id = $dblink->link_id;
$cached_links[$dblink->link_id] = $dblink;
$link->read();
$output .= $link->print_summary('summary', true);
}
}
$main_smarty->assign('user_page', $output);
}
print_shakeit_tabs($tab);
do_mnu_categories_horizontal($_REQUEST['category']);
// fora en posar dropdown echo '</div>'; // Left margin
// end of tabs
if ($cat) {
$from_where .= " AND link_category={$cat} ";
}
$link = new Link();
$rows = $db->get_var("SELECT count(*) {$from_where}");
$links = $db->get_col("SELECT link_id {$from_where} {$order_by} LIMIT {$offset},{$page_size}");
if ($links) {
foreach ($links as $link_id) {
$link->id = $link_id;
$link->read();
if ($offset < 1000) {
$link->print_summary('full', 16);
} else {
$link->print_summary('full');
}
}
}
do_pages($rows, $page_size);
echo '</div>' . "\n";
do_footer();
function print_shakeit_tabs($option = -1)
{
global $globals, $current_user, $db;
$active = array();
if ($option > 0) {
$active[$option] = 'class="tabsub-this"';
}
function do_shaken()
{
global $db, $rows, $user, $offset, $page_size;
$link = new Link();
echo '<h2>' . _('noticias votadas') . '</h2>';
$rows = $db->get_var("SELECT count(*) FROM links, votes WHERE vote_type='links' and vote_user_id={$user->id} AND vote_link_id=link_id and vote_value > 0");
$links = $db->get_col("SELECT link_id FROM links, votes WHERE vote_type='links' and vote_user_id={$user->id} AND vote_link_id=link_id and vote_value > 0 ORDER BY link_date DESC LIMIT {$offset},{$page_size}");
if ($links) {
foreach ($links as $link_id) {
$link->id = $link_id;
$link->read();
$link->print_summary('short');
}
}
}
function report_dupe($url) {
global $globals;
$link = new Link;
if(($found = $link->duplicates($url))) {
$dupe = new Link;
$dupe->id = $found;
$dupe->read();
echo '<p class="error"><strong>'._('noticia repetida').'</strong></p> ';
echo '<p class="error-text">'._('disculpas').'</p>';
$dupe->print_summary();
echo '<br style="clear: both;" /><br/>' . "\n";
echo '<form class="genericform" action="">';
echo '<input class="button" type="button" onclick="window.history.go(-1)" value="« '._('retroceder').'" />';
echo '</form>'. "\n";
echo '</div>'. "\n";
return true;
}
return false;
}
function group_shared($requestID)
{
global $db, $main_smarty, $the_template, $page_size, $cached_links;
if (!is_numeric($requestID)) {
die;
}
$link = new Link();
$group_shared_display = "";
//$group_shared_display .= "SELECT link_id FROM " . table_links . " WHERE link_group_id=$requestID";
//$links = $db->get_col("SELECT link_id FROM " . table_links . " WHERE link_share_id = $requestID");
$rows = $db->get_var("SELECT COUNT(share_link_id) FROM " . table_group_shared . " WHERE share_group_id = {$requestID}");
$links = $db->get_results("SELECT * FROM " . table_group_shared . " WHERE share_group_id = {$requestID}");
if ($links) {
foreach ($links as $dblink) {
$link->id = $dblink->link_id;
$cached_links[$dblink->link_id] = $dblink;
$link->read();
$group_shared_display .= $link->print_summary('summary', true);
}
}
$main_smarty->assign('group_shared_display', $group_shared_display);
$main_smarty->assign('group_story_pagination', do_pages($rows, $page_size, 'group_story', true));
}
}
}
// end link cache setup
}
global $display_grouplinks;
if (!isset($link_summary_output)) {
$link_summary_output = '';
}
if ($new_search) {
foreach ($new_search as $link_id) {
$link->id = $link_id;
$link->read();
if ($display_grouplinks) {
$link->link_group_id = 0;
}
$link_summary_output .= $link->print_summary('summary', true);
}
} else {
if ($links) {
foreach ($links as $link_id) {
$link->id = $link_id;
$link->read();
$link_summary_output .= $link->print_summary('summary', true);
}
}
}
if (isset($fetch_link_summary) && $fetch_link_summary == true) {
$main_smarty->assign('link_summary_output', $link_summary_output);
} else {
echo $link_summary_output;
}
<?php
global $new_search;
$link = new Link();
if ($new_search) {
//$rows = count($new_search);
$rows = $new_search['count'];
$new_search = $new_search['rows'];
if ($new_search) {
foreach ($new_search as $link_id) {
$link->id = $link_id;
$link->read();
$link->print_summary('summary');
}
}
} else {
$rows = $db->get_var($linksum_count);
$links = $db->get_col($linksum_sql);
if ($links) {
foreach ($links as $link_id) {
$link->id = $link_id;
$link->read();
$link->print_summary('summary');
}
}
}
function do_commented () {
global $db, $rows, $user, $offset, $page_size;
$link = new Link;
echo '<h2>'._('noticias comentadas').'</h2>';
$rows = $db->get_var("SELECT count(distinct comment_link_id) FROM comments WHERE comment_user_id=$user->id");
$links = $db->get_col("SELECT DISTINCT link_id FROM links, comments WHERE comment_user_id=$user->id AND comment_link_id=link_id ORDER BY link_date DESC LIMIT $offset,$page_size");
if ($links) {
foreach($links as $link_id) {
$link->id=$link_id;
$link->read();
$link->print_summary('short');
}
}
}
function do_shaken()
{
global $db, $rows, $user, $offset, $page_size, $globals;
if ($globals['bot']) {
return;
}
$link = new Link();
$rows = $db->get_var("SELECT count(*) FROM links, votes WHERE vote_type='links' and vote_user_id={$user->id} AND vote_link_id=link_id and vote_value > 0");
$links = $db->get_col("SELECT link_id FROM links, votes WHERE vote_type='links' and vote_user_id={$user->id} AND vote_link_id=link_id and vote_value > 0 ORDER BY link_date DESC LIMIT {$offset},{$page_size}");
if ($links) {
echo '<div class="bookmarks-export-user-stories">';
echo '<a href="' . $globals['base_url'] . 'link_bookmark.php?user_id=' . $user->id . '&option=shaken" title="' . _('exportar bookmarks en formato Mozilla') . '"><img src="' . $globals['base_url'] . 'img/common/bookmarks-export-01.png" alt="Mozilla bookmark"/></a>';
echo ' <a href="' . $globals['base_url'] . 'rss2.php?voted_by=' . $user->id . '" title="' . _('noticias votadas en rss2') . '"><img src="' . $globals['base_url'] . 'img/common/rss-button01.png" alt="rss2"/></a>';
echo '</div>';
foreach ($links as $link_id) {
$link->id = $link_id;
$link->read();
$link->print_summary('short');
}
echo '<br/><span class="credits-strip-text"><strong>' . _('Nota') . '</strong>: ' . _('sólo se visualizan los votos de los últimos meses') . '</span><br />';
}
}
echo '<div style="font-size:85%;margin-top: 5px">';
echo _('encontrados') . ': ' . $response['rows'] . ', ' . _('tiempo total') . ': ' . sprintf("%1.3f", $response['time']) . ' ' . _('segundos');
echo ' <a href="' . $globals['base_url'] . $rss_program . '?' . htmlspecialchars($_SERVER['QUERY_STRING']) . '" rel="rss"><img src="' . $globals['base_static'] . 'img/common/feed-icon-001.png" width="18" height="18" alt="rss2" style="vertical-align:top"/></a>';
echo '</div>';
}
echo '</fieldset>';
echo '</div>';
if ($response['ids']) {
$rows = min($response['rows'], 1000);
foreach ($response['ids'] as $id) {
$obj->id = $id;
$obj->read();
$obj->basic_summary = true;
switch ($_REQUEST['w']) {
case 'posts':
$obj->print_summary(300);
break;
case 'comments':
if ($obj->type == 'admin' && !$current_user->admin) {
continue;
}
$obj->print_summary(false, 300);
break;
case 'links':
default:
$obj->print_summary();
}
}
}
do_pages($rows, $page_size);
echo '</div>';
function do_commented()
{
global $db, $rows, $user, $offset, $page_size;
$link = new Link();
$rows = $db->get_var("SELECT count(*) FROM " . table_links . ", " . table_comments . " WHERE comment_user_id={$user->id} AND comment_link_id=link_id");
$links = $db->get_col("SELECT DISTINCT link_id FROM " . table_links . ", " . table_comments . " WHERE comment_user_id={$user->id} AND comment_link_id=link_id AND link_status != 'discard' ORDER BY link_date DESC LIMIT {$offset},{$page_size}");
if ($links) {
foreach ($links as $link_id) {
$link->id = $link_id;
$link->read();
$link->print_summary('summary');
}
}
}
if (!empty($link->tags)) {
$globals['tags'] = $link->tags;
}
do_header($link->title, 'post');
// Show the error if the comment couldn't be inserted
if (!empty($new_comment_error)) {
echo '<script type="text/javascript">';
echo '$(function(){alert(\'' . _('comentario no insertado') . ": {$new_comment_error}" . '\')});';
echo '</script>';
}
do_banner_top();
echo '<div id="container">' . "\n";
do_sidebar(false);
echo '<div id="contents">';
do_tabs("main", _('noticia'), true);
$link->print_summary();
switch ($tab_option) {
case 1:
case 2:
echo '<div class="comments">';
// AdSense
do_banner_story();
// Print tabs
print_story_tabs($tab_option);
// If option is "normal comments", show also last trackbakcs and pingbacks
if ($tab_option == 1) {
$trackbacks = $db->get_col("SELECT trackback_id FROM trackbacks WHERE trackback_link_id={$link->id} AND trackback_type='in' and trackback_status = 'ok' ORDER BY trackback_date DESC limit 10");
if ($trackbacks) {
echo '<fieldset><legend><a href="' . $globals['link_permalink'] . '/trackbacks">' . _('últimas relacionadas') . '</a></legend>';
echo '<ul class="tab-trackback">';
require_once mnminclude . 'trackback.php';
}
$page_size = 20;
$offset = (get_current_page() - 1) * $page_size;
$globals['ads'] = true;
$globals['noindex'] = true;
$_REQUEST['q'] = stripslashes($_REQUEST['q']);
$response = sphinx_get_search_link(false, $offset, $page_size);
$search_txt = htmlspecialchars($_REQUEST['q']);
do_header(_('búsqueda de') . ' "' . $search_txt . '"');
do_banner_top();
echo '<div id="container">' . "\n";
do_sidebar();
echo '<div id="contents">';
do_tabs('main', _('búsqueda'), htmlentities($_SERVER['REQUEST_URI']));
echo '<div style="background:#FFE2C5;margin:10px 0 5px 86px;font-size:100%;text-align:right;padding:5px;">' . _('búsqueda') . ': <strong>' . $search_txt . '</strong>';
if (!empty($_REQUEST['q'])) {
echo ' <a href="' . $globals['base_url'] . 'rss2.php?q=' . urlencode($_REQUEST['q']) . '" rel="rss"><img src="' . $globals['base_url'] . 'img/common/feed-icon-12x12.png" alt="rss2" height="12" width="12" style="vertical-align:top"/></a>';
}
echo ' ' . _('encontrados') . ': ' . $response['rows'] . ', ' . _('tiempo total') . ': ' . sprintf("%1.3f", $response['time']) . ' ' . _('segundos') . '</div>';
$link = new Link();
if ($response['ids']) {
$rows = min($response['rows'], 1000);
foreach ($response['ids'] as $link_id) {
$link->id = $link_id;
$link->read();
$link->print_summary('full', $link->status == 'published' ? 100 : 20);
}
}
do_pages($rows, $page_size);
echo '</div>';
do_footer();
// meta tags
$meta_description = preg_replace(array('/\\r/', '/\\n/'), '', $link->truncate_content());
$main_smarty->assign('meta_description', strip_tags($meta_description));
$main_smarty->assign('meta_keywords', $link->tags);
//sidebar
$main_smarty = do_sidebar($main_smarty);
// pagename
define('pagename', 'story');
$main_smarty->assign('pagename', pagename);
if ($current_user->authenticated != TRUE) {
$vars = '';
check_actions('register_showform', $vars);
}
$story_url = getmyurl("storyURL", $link->category_safe_names(), urlencode($link->title_url), $link->id);
$main_smarty->assign('story_url', $story_url);
$main_smarty->assign('the_story', $link->print_summary('full', true));
$parent_comment_id = sanitize($_GET['comment_id'], 3);
if (isset($_GET['reply']) && !empty($parent_comment_id)) {
$main_smarty->assign('the_comments', get_comments(true, 0, $_GET['comment_id']));
$main_smarty->assign('parrent_comment_id', $parent_comment_id);
} elseif (!empty($parent_comment_id)) {
$main_smarty->assign('the_comments', get_comments(true, $parent_comment_id, 0, 1));
$main_smarty->assign('parrent_comment_id', $parent_comment_id);
} else {
$main_smarty->assign('the_comments', get_comments(true));
$main_smarty->assign('parrent_comment_id', 0);
}
$main_smarty->assign('url', $link->url);
$main_smarty->assign('enc_url', urlencode($link->url));
$main_smarty->assign('story_comment_count', $link->comments());
$main_smarty->assign('URL_rss_page', getmyurl('storyrss', isset($requestTitle) ? $requestTitle : urlencode($link->title_url), $link->category_safe_name($link->category)));
function do_new()
{
global $db, $main_smarty, $rows, $user, $offset, $page_size, $cached_links;
$output = '';
$link = new Link();
$rows = $db->get_var("SELECT count(*) FROM " . table_links . " WHERE link_author={$user->id} AND link_status='new'");
$links = $db->get_results("SELECT * FROM " . table_links . " WHERE link_author={$user->id} AND link_status='new' ORDER BY link_date DESC LIMIT {$offset},{$page_size}");
if ($links) {
foreach ($links as $dblink) {
$link->id = $dblink->link_id;
$cached_links[$dblink->link_id] = $dblink;
$link->read();
$output .= $link->print_summary('summary', true);
}
}
$main_smarty->assign('user_page', $output);
}
