U2 360° Tour 2011 tweet archive for hashtag


This is an archive of all tweets related to U2's 360° Tour 2011 concert in with the hashtag . We capture as many tweets as possible but can't guarantee to get them all.

"; addthis(); echo "
"; /* Setup vars for query. */ $limit = 50; //how many items to show per page $page = $_GET['page']; if($page) $start = ($page - 1) * $limit; //first item to display on this page else $start = 0; //if no page var is given, set start to 0 /* Get data. */ $sql = "SELECT text, from_user, id, profile_image_url, created_at, time FROM $tbl_name ORDER BY time DESC LIMIT $start, $limit "; # $sql = "SELECT text, from_user, id, profile_image_url, created_at, time FROM $tbl_name "; $result = mysql_query($sql); /* Setup page vars for display. */ if ($page == 0) $page = 1; //if no page var is given, default to 1. $prev = $page - 1; //previous page is page - 1 $next = $page + 1; //next page is page + 1 $lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up. $lpm1 = $lastpage - 1; //last page minus 1 /* Now we apply our rules and draw the pagination object. We're actually saving the code to a variable in case we want to draw it more than once. */ $pagination = ""; if($lastpage > 1) { $pagination .= "
"; //previous button if ($page > 1) $pagination.= "« previous"; else $pagination.= "« previous"; //pages if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } } elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some { //close to beginning; only hide later pages if($page < 1 + ($adjacents * 2)) { for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } $pagination.= "..."; $pagination.= "$lpm1"; $pagination.= "$lastpage"; } //in middle; hide some front and some back elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) { $pagination.= "1"; $pagination.= "2"; $pagination.= "..."; for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } $pagination.= "..."; $pagination.= "$lpm1"; $pagination.= "$lastpage"; } //close to end; only hide early pages else { $pagination.= "1"; $pagination.= "2"; $pagination.= "..."; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "$counter"; else $pagination.= "$counter"; } } } //next button if ($page < $counter - 1) $pagination.= "next »"; else $pagination.= "next »"; $pagination.= "
\n"; } ?> ", "

", "

", "

"); $text = str_replace($remove, ' ', $text); $text = unshorturl($text); $text = twitter_photo_replace(highlight_tweet($text)); // Add this tweet to the list $tweet_list .= $current_tweet; echo "
\n"; echo "
\n"; echo " \n"; echo "
\n"; echo "
\n"; echo "
\n"; echo " ".$row['from_user']."\n"; echo "
\n"; echo "
$text \n"; echo " \n"; echo "
\n"; echo "
\n"; echo "

\n"; // Your while loop here } ?>