}
print '</div>';
print '<div class="columnright">';
// Display screen names of users mentioned most by this user
$mentions_query = "SELECT COUNT(*) AS cnt, users.screen_name, users.user_id\r\n\tFROM tweet_mentions, users\r\n\tWHERE tweet_mentions.target_user_id = users.user_id\r\n\tAND tweet_mentions.source_user_id = {$user_id}\r\n\tGROUP BY tweet_mentions.target_user_id\r\n\tORDER BY cnt DESC, users.screen_name ASC \r\n\tLIMIT 6";
$mentions_results = $db->select($mentions_query);
if (mysqli_num_rows($mentions_results)) {
print "<strong>Mentioned by @{$screen_name}:</strong><br/>";
while ($mentions_row = mysqli_fetch_assoc($mentions_results)) {
print '(' . $mentions_row['cnt'] . ') ' . '<a href="user_profile.php?user_id=' . $mentions_row['user_id'] . '">@' . $mentions_row['screen_name'] . '</a><br/>';
}
}
// Display screen names of users who mention this user the most
$mentions_query = "SELECT COUNT(*) AS cnt, users.screen_name, users.user_id\r\n\tFROM tweet_mentions, users\r\n\tWHERE tweet_mentions.source_user_id = users.user_id\r\n\tAND tweet_mentions.target_user_id = {$user_id}\r\n\tGROUP BY tweet_mentions.source_user_id\r\n\tORDER BY cnt DESC, users.screen_name ASC \r\n\tLIMIT 6";
$mentions_results = $db->select($mentions_query);
if (mysqli_num_rows($mentions_results)) {
print "<br/><strong>Mentioners of @{$screen_name}:</strong><br/>";
while ($mentions_row = mysqli_fetch_assoc($mentions_results)) {
print '(' . $mentions_row['cnt'] . ') ' . '<a href="user_profile.php?user_id=' . $mentions_row['user_id'] . '">@' . $mentions_row['screen_name'] . '</a><br/>';
}
}
print '</div>';
// Display recent tweets by this user
if ($total_tweets != 0) {
print '<div class="clear"><h3>Recent Tweets</h3>';
require '../get_all_tweets.php';
$where = " AND tweets.user_id = {$user_id} ";
$tweets = get_all_tweets($where, 0, 100);
require 'display_tweets.php';
}
require 'page_bottom.html';
if ($page < 0) {
$page = 0;
}
} elseif ($_GET['next']) {
$page = intval($_GET['page']) + 1;
} else {
$page = 0;
}
} else {
$start_date = '0000-00-00';
$end_date = '0000-00-00';
$query = '';
$page = 0;
}
require 'page_top.html';
print '<h2>Search Tweets</h2>';
print "<form action='search_tweets.php' method='get'>";
print "Start Date: <input type='text' name='start_date' value='{$start_date}'>";
print "End Date: <input type='text' name='end_date' value='{$end_date}'><br/>";
print "Search Terms: <input type='text' name='query' value='{$query}' size='50'>";
print "<input type='hidden' name='page' value={$page}>";
print '<button type="submit" name="submit" value=1>Search</button>';
print '<button type="submit" name="prev" value=1>< Prev</button>';
print '<button type="submit" name="next" value=1>Next ></button>';
print '</form>';
if (!empty($where)) {
require '../get_all_tweets.php';
$tweets = get_all_tweets($where, $page * $results_per_page, $results_per_page);
require 'display_tweets.php';
}
require 'page_bottom.html';
