0 ORDER BY link_id DESC LIMIT 1000"; do_header(_('votadas')); do_link_item($sql); do_footer(); break; case 'favorites': $sql = "SELECT link_id FROM links, favorites WHERE favorite_user_id=$user_id AND favorite_link_id=link_id ORDER BY link_id DESC LIMIT 1000"; do_header(_('favoritos')); do_link_item($sql); do_footer(); break; case 'commented': $sql = "SELECT distinct(link_id) FROM links, comments WHERE comment_user_id=$user_id and link_id=comment_link_id ORDER BY link_id DESC LIMIT 1000"; do_header(_('comentadas')); do_link_item($sql); do_footer(); break; case 'history': $sql = "SELECT link_id FROM links WHERE link_author=$user_id ORDER BY link_id DESC LIMIT 1000"; do_header(_('envíadas')); do_link_item($sql); do_footer(); break; default: die; } function do_header($title) { echo '' . "\n"; echo '' . "\n"; echo '' . "\n"; echo 'Bookmarks' . "\n"; echo '

Bookmarks

' . "\n"; echo '

' . "\n"; echo '

'.$title.'//'.get_server_name().'

' . "\n"; echo '

' . "\n"; } function do_footer() { echo '

' . "\n"; } function do_link_item($sql) { global $db; $link = new Link; $links = $db->get_col($sql); if ($links) { foreach($links as $link_id) { $link->id=$link_id; $link->read(); if ($_REQUEST['url'] == 'source') { $url = htmlentities($link->url); } else { $url = $link->get_permalink(); } echo '
'.$link->title.'' . "\n"; } } } ?>