/**
* displayRecentActivity - Displays Recent Activity
*/
function displayRecentActivity($event_id)
{
global $sql;
global $time;
global $pref;
$events = array();
$nbr_events = 0;
if ($event_id != '') {
$eventid_match = " AND (" . TBL_MATCHS . ".Event = '{$event_id}')";
$eventid_award = " AND (" . TBL_EVENTS . ".EventID = '{$event_id}')";
}
// Add recent games
$rowsPerPage = $pref['eb_activity_number_of_items'];
/* Stats/Results */
$q = "SELECT DISTINCT " . TBL_MATCHS . ".*" . " FROM " . TBL_MATCHS . ", " . TBL_SCORES . " WHERE (" . TBL_MATCHS . ".Status = 'active')" . " AND (" . TBL_SCORES . ".MatchID = " . TBL_MATCHS . ".MatchID)" . $eventid_match . " ORDER BY " . TBL_MATCHS . ".TimeReported DESC" . " LIMIT 0, {$rowsPerPage}";
$result = $sql->db_Query($q);
$num_rows = mysql_numrows($result);
if ($num_rows > 0) {
/* Display table contents */
for ($i = 0; $i < $num_rows; $i++) {
$match_id = mysql_result($result, $i, TBL_MATCHS . ".MatchID");
$match = new Match($match_id);
$events[$nbr_events][0] = $match->getField('TimeReported');
$events[$nbr_events][1] = $match->displayMatchInfo(eb_MATCH_NO_EDIT_ICONS);
$nbr_events++;
}
}
// Add Awards events
$q = "SELECT " . TBL_AWARDS . ".*, " . TBL_PLAYERS . ".*, " . TBL_USERS . ".*, " . TBL_EVENTS . ".*, " . TBL_GAMES . ".*" . " FROM " . TBL_AWARDS . ", " . TBL_PLAYERS . ", " . TBL_GAMERS . ", " . TBL_USERS . ", " . TBL_EVENTS . ", " . TBL_GAMES . " WHERE (" . TBL_AWARDS . ".Player = " . TBL_PLAYERS . ".PlayerID)" . " AND (" . TBL_PLAYERS . ".Gamer = " . TBL_GAMERS . ".GamerID)" . " AND (" . TBL_GAMERS . ".User = "******".user_id)" . " AND (" . TBL_PLAYERS . ".Event = " . TBL_EVENTS . ".EventID)" . " AND (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . $eventid_award . " ORDER BY " . TBL_AWARDS . ".timestamp DESC" . " LIMIT 0, {$rowsPerPage}";
$result = $sql->db_Query($q);
$numAwards = mysql_numrows($result);
if ($numAwards > 0) {
/* Display table contents */
for ($i = 0; $i < $numAwards; $i++) {
$aID = mysql_result($result, $i, TBL_AWARDS . ".AwardID");
$aUser = mysql_result($result, $i, TBL_USERS . ".user_id");
$gamer_id = mysql_result($result, $i, TBL_PLAYERS . ".Gamer");
$gamer = new Gamer($gamer_id);
$aUserNickName = $gamer->getField('Name');
$aEventgame = mysql_result($result, $i, TBL_GAMES . ".Name");
$aEventgameicon = mysql_result($result, $i, TBL_GAMES . ".Icon");
$aType = mysql_result($result, $i, TBL_AWARDS . ".Type");
$aTime = mysql_result($result, $i, TBL_AWARDS . ".timestamp");
$aTime_local = $aTime + TIMEOFFSET;
$date = date("d M Y, h:i A", $aTime_local);
$aEventID = mysql_result($result, $i, TBL_EVENTS . ".EventID");
$aEventName = mysql_result($result, $i, TBL_EVENTS . ".Name");
switch ($aType) {
case 'PlayerTookFirstPlace':
$award = EB_AWARD_L2;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/award_star_gold_3.png") . ' alt="' . EB_AWARD_L3 . '" title="' . EB_AWARD_L3 . '"/> ';
break;
case 'PlayerInTopTen':
$award = EB_AWARD_L4;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/award_star_bronze_3.png") . ' alt="' . EB_AWARD_L5 . '" title="' . EB_AWARD_L5 . '"/> ';
break;
case 'PlayerStreak5':
$award = EB_AWARD_L6;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/medal_bronze_3.png") . ' alt="' . EB_AWARD_L7 . '" title="' . EB_AWARD_L7 . '"/> ';
break;
case 'PlayerStreak10':
$award = EB_AWARD_L8;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/medal_silver_3.png") . ' alt="' . EB_AWARD_L9 . '" title="' . EB_AWARD_L9 . '"/> ';
break;
case 'PlayerStreak25':
$award = EB_AWARD_L10;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/medal_gold_3.png") . ' alt="' . EB_AWARD_L11 . '" title="' . EB_AWARD_L11 . '"/> ';
break;
case 'PlayerWonTournament':
$award = EB_AWARD_L12;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/trophy_gold.png") . ' alt="' . EB_AWARD_L13 . '" title="' . EB_AWARD_L13 . '"/> ';
break;
case 'PlayerRankFirst':
$award = EB_AWARD_L14;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/medal_gold_1.png") . ' alt="' . EB_AWARD_L15 . '" title="' . EB_AWARD_L15 . '"/> ';
break;
case 'PlayerRankSecond':
$award = EB_AWARD_L16;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/medal_silver_1.png") . ' alt="' . EB_AWARD_L17 . '" title="' . EB_AWARD_L17 . '"/> ';
break;
case 'PlayerRankThird':
$award = EB_AWARD_L18;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/medal_bronze_1.png") . ' alt="' . EB_AWARD_L19 . '" title="' . EB_AWARD_L19 . '"/> ';
break;
}
$award_string = '<tr><td style="vertical-align:top">' . $icon . '</td>';
$award_string .= '<td><a href="' . e_PLUGIN . 'ebattles/userinfo.php?user='******'">' . $aUserNickName . '</a>';
$award_string .= ' ' . $award;
$award_string .= ' ' . EB_MATCH_L12 . ' <img ' . getActivityGameIconResize($aEventgameicon) . ' title="' . $aEventgame . '"/> <a href="' . e_PLUGIN . 'ebattles/eventinfo.php?eventid=' . $aEventID . '">' . $aEventName . '</a>';
$award_string .= ' <div class="smalltext">';
if ($time - $aTime < INT_MINUTE) {
$award_string .= EB_MATCH_L7;
} else {
if ($time - $aTime < INT_DAY) {
$award_string .= get_formatted_timediff($aTime, $time) . ' ' . EB_MATCH_L8;
} else {
$award_string .= $date;
}
}
$award_string .= '</div></td></tr>';
$events[$nbr_events][0] = $aTime;
$events[$nbr_events][1] = $award_string;
$nbr_events++;
}
}
$q = "SELECT " . TBL_AWARDS . ".*, " . TBL_TEAMS . ".*, " . TBL_EVENTS . ".*, " . TBL_GAMES . ".*" . " FROM " . TBL_AWARDS . ", " . TBL_TEAMS . ", " . TBL_EVENTS . ", " . TBL_GAMES . " WHERE (" . TBL_AWARDS . ".Team = " . TBL_TEAMS . ".TeamID)" . " AND (" . TBL_TEAMS . ".Event = " . TBL_EVENTS . ".EventID)" . " AND (" . TBL_EVENTS . ".Game = " . TBL_GAMES . ".GameID)" . $eventid_award . " ORDER BY " . TBL_AWARDS . ".timestamp DESC" . " LIMIT 0, {$rowsPerPage}";
$result = $sql->db_Query($q);
$numAwards = mysql_numrows($result);
if ($numAwards > 0) {
/* Display table contents */
for ($i = 0; $i < $numAwards; $i++) {
$aID = mysql_result($result, $i, TBL_AWARDS . ".AwardID");
$aEventgame = mysql_result($result, $i, TBL_GAMES . ".Name");
$aEventgameicon = mysql_result($result, $i, TBL_GAMES . ".Icon");
$aType = mysql_result($result, $i, TBL_AWARDS . ".Type");
$aTime = mysql_result($result, $i, TBL_AWARDS . ".timestamp");
$aTime_local = $aTime + TIMEOFFSET;
$date = date("d M Y, h:i A", $aTime_local);
$aEventID = mysql_result($result, $i, TBL_EVENTS . ".EventID");
$aEventName = mysql_result($result, $i, TBL_EVENTS . ".Name");
$aClanTeam = mysql_result($result, $i, TBL_TEAMS . ".TeamID");
list($tclan, $tclantag, $tclanid) = getClanInfo($aClanTeam);
switch ($aType) {
case 'TeamTookFirstPlace':
$award = EB_AWARD_L2;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/award_star_gold_3.png") . ' alt="' . EB_AWARD_L3 . '" title="' . EB_AWARD_L3 . '"/> ';
break;
case 'TeamInTopTen':
$award = EB_AWARD_L4;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/award_star_bronze_3.png") . ' alt="' . EB_AWARD_L5 . '" title="' . EB_AWARD_L5 . '"/> ';
break;
case 'TeamStreak5':
$award = EB_AWARD_L6;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/medal_bronze_3.png") . ' alt="' . EB_AWARD_L7 . '" title="' . EB_AWARD_L7 . '"/> ';
break;
case 'TeamStreak10':
$award = EB_AWARD_L8;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/medal_silver_3.png") . ' alt="' . EB_AWARD_L9 . '" title="' . EB_AWARD_L9 . '"/> ';
break;
case 'TeamStreak25':
$award = EB_AWARD_L10;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/medal_gold_3.png") . ' alt="' . EB_AWARD_L11 . '" title="' . EB_AWARD_L11 . '"/> ';
break;
case 'TeamWonTournament':
$award = EB_AWARD_L12;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/trophy_gold.png") . ' alt="' . EB_AWARD_L13 . '" title="' . EB_AWARD_L13 . '"/> ';
break;
case 'TeamRankFirst':
$award = EB_AWARD_L14;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/medal_gold_1.png") . ' alt="' . EB_AWARD_L15 . '" title="' . EB_AWARD_L15 . '"/> ';
break;
case 'TeamRankSecond':
$award = EB_AWARD_L16;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/medal_silver_1.png") . ' alt="' . EB_AWARD_L17 . '" title="' . EB_AWARD_L17 . '"/> ';
break;
case 'TeamRankThird':
$award = EB_AWARD_L18;
$icon = '<img ' . getActivityIconResize(e_PLUGIN . "ebattles/images/awards/medal_bronze_1.png") . ' alt="' . EB_AWARD_L19 . '" title="' . EB_AWARD_L19 . '"/> ';
break;
}
$award_string = '<tr><td style="vertical-align:top">' . $icon . '</td>';
$award_string .= '<td><a href="' . e_PLUGIN . 'ebattles/claninfo.php?clanid=' . $tclanid . '">' . $tclan . '</a>';
$award_string .= ' ' . $award;
$award_string .= ' ' . EB_MATCH_L12 . ' <img ' . getActivityGameIconResize($aEventgameicon) . ' title="' . $aEventgame . '"/> <a href="' . e_PLUGIN . 'ebattles/eventinfo.php?eventid=' . $aEventID . '">' . $aEventName . '</a>';
$award_string .= ' <div class="smalltext">';
if ($time - $aTime < INT_MINUTE) {
$award_string .= EB_MATCH_L7;
} else {
if ($time - $aTime < INT_DAY) {
$award_string .= get_formatted_timediff($aTime, $time) . ' ' . EB_MATCH_L8;
} else {
$award_string .= $date;
}
}
$award_string .= '</div></td></tr>';
$events[$nbr_events][0] = $aTime;
$events[$nbr_events][1] = $award_string;
$nbr_events++;
}
}
$text .= '<table style="margin-left: 0px; margin-right: auto;">';
multi2dSortAsc($events, 0, SORT_DESC);
for ($index = 0; $index < min($nbr_events, $rowsPerPage); $index++) {
$text .= $events[$index][1];
}
if ($index == 0) {
$text .= '<tr><td>' . EB_ACTIVITY_L1 . '</td></tr>';
}
$text .= '</table>';
return $text;
}
} else {
if ($time - $aTime < INT_DAY) {
$award_string .= get_formatted_timediff($aTime, $time) . ' ' . EB_MATCH_L8;
} else {
$award_string .= $date;
}
}
$award_string .= '</div></td></tr>';
$awards[$nbr_awards][0] = $aTime;
$awards[$nbr_awards][1] = $award_string;
$nbr_awards++;
}
}
if ($nbr_awards > 0) {
$text .= '<table class="table_left">';
multi2dSortAsc($awards, 0, SORT_DESC);
for ($index = 0; $index < min($nbr_awards, $rowsPerPage); $index++) {
$text .= $awards[$index][1];
}
$text .= '</table>';
}
$text .= '</div>';
// tabs-5 "Latest Awards"
$text .= '</div>';
// tabs
$text .= disclaimer();
function check_can_challenge($stat, $list_challenge, $str)
{
//echo "test: $stat<br>";
$regex = "/" . $str . "\\(\\'([a-zA-Z0-9_]*)\\'\\)/";
preg_match_all($regex, $stat, $matches);
