?>
<li<?php
echo $Override === 2 ? ' class="paranoia_override"' : '';
?>
>Warning expires in: <?php
echo time_diff(date('Y-m-d H:i', strtotime($Warned)));
?>
</li>
<?php
}
?>
</ul>
</div>
<?php
// Last.fm statistics and comparability
$LastFMUsername = LastFM::get_lastfm_username($UserID);
if ($LastFMUsername) {
LastFMView::render_sidebar($LastFMUsername, $UserID, $OwnProfile);
}
if (check_paranoia_here('requestsfilled_count') || check_paranoia_here('requestsfilled_bounty')) {
$DB->query("\n\t\tSELECT\n\t\t\tCOUNT(DISTINCT r.ID),\n\t\t\tSUM(rv.Bounty)\n\t\tFROM requests AS r\n\t\t\tLEFT JOIN requests_votes AS rv ON r.ID = rv.RequestID\n\t\tWHERE r.FillerID = {$UserID}");
list($RequestsFilled, $TotalBounty) = $DB->next_record();
} else {
$RequestsFilled = $TotalBounty = 0;
}
if (check_paranoia_here('requestsvoted_count') || check_paranoia_here('requestsvoted_bounty')) {
$DB->query("\n\t\tSELECT COUNT(RequestID), SUM(Bounty)\n\t\tFROM requests_votes\n\t\tWHERE UserID = {$UserID}");
list($RequestsVoted, $TotalSpent) = $DB->next_record();
$DB->query("\n\t\tSELECT COUNT(r.ID), SUM(rv.Bounty)\n\t\tFROM requests AS r\n\t\t\tLEFT JOIN requests_votes AS rv ON rv.RequestID = r.ID AND rv.UserID = r.UserID\n\t\tWHERE r.UserID = {$UserID}");
list($RequestsCreated, $RequestsCreatedSpent) = $DB->next_record();
} else {
