Elite Diviner
- Joined
- Aug 15, 2008
- Messages
- 489
- Reaction score
- 43
SELECT * FROM `banhammer_bans` INNER JOIN `banhammer_players` ON banhammer_bans.creator_id = banhammer_bans.id ORDER BY created_at DESC
SELECT banhammer_bans.player_id, banhammer_bans.creator_id as banhammer_players.name INNER JOIN `banhammer_bans` banhammer_bans.player_id, banhammer_bans.creator_id = banhammer_players.id ORDER BY created_at DESC
SELECT bu.name, ba.name, bb.created_at, bb.expires_at, bb.reason
FROM banhammer_players AS bu
JOIN banhammer_bans AS bb
ON bu.id = bb.player_id
JOIN banhammer_players AS ba
ON bb.creator_id = ba.id
Looks good 'nuff to me.I haven't used SQL for years but here's my answer:
PHP:SELECT bu.name, ba.name, bb.created_at, bb.expires_at, bb.reason FROM banhammer_players AS bu JOIN banhammer_bans AS bb ON bu.id = bb.player_id JOIN banhammer_players AS ba ON bb.creator_id = ba.id
$sql = "SELECT bu.name, ba.name, bb.created_at, bb.expires_at, bb.reason FROM banhammer_players AS bu JOIN banhammer_bans AS bb ON bu.id = bb.player_id JOIN banhammer_players AS ba ON bb.creator_id = ba.id ORDER BY bb.created_at DESC LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
$c = 0;
echo '<table width="100%" cellspacing="0" cellpadding="5">';
echo '<tr class="';
echo $c++&1 ? 'odd' : 'even';
echo '">';
echo '<th style="text-align: left;">Avatar</th>';
echo '<th style="text-align: left;">Username</th>';
echo '<th style="text-align: left;">Banned by</th>';
echo '<th style="text-align: left;">Ban date</th>';
echo '<th style="text-align: left;">Unban date</th>';
echo '<th style="text-align: left;">Reason</th>';
echo '</tr>';
// while there are rows to be fetched...
while ($row = mysql_fetch_assoc($result)) {
echo "<tr class='";
echo $c++&1 ? 'odd' : 'even';
echo "'>";
echo "<td><img src='http://minotar.net/avatar/".$row['bu.name']."/30' /></td>";
echo "<td>".$row['bu.name']."</td>";
echo "<td>".$row['ba.name']."</td>";
echo "<td>".$row['bb.created_at']."</td>";
if(''.$row['bb.expires_at'].'' == 0)
echo "<td>Permanent</td>";
else
echo "<td>".$row['bb.expires_at']."</td>";
echo "<td>".$row['bb.reason']."</td>";
echo "</tr>";
} // end while
while (/*set rows... */) {
var_dump($row);
}
array(4) { ["name"]=> string(6) "Sibens" ["created_at"]=> string(19) "2012-09-05 08:18:27" ["expires_at"]=> NULL ["reason"]=> string(25) "Stealing stuff on a chest" } array(4) { ["name"]=> string(7) "PipeCat" ["created_at"]=> string(19) "2012-08-18 18:35:03" ["expires_at"]=> string(19) "2012-08-19 18:35:03" ["reason"]=> string(76) "Didn't stop arguing with other players after being told to stop by Moderator" } array(4) { ["name"]=> string(7) "PipeCat" ["created_at"]=> string(19) "2012-08-18 18:34:44" ["expires_at"]=> string(19) "2012-08-19 18:34:44" ["reason"]=> string(76) "Didn't stop arguing with other players after being told to stop by Moderator" }
echo('<pre>');
var_dump($variable_to_dump);
die('</pre>');
SELECT bu.name AS banned_player, ba.name AS ban_creator, bb.created_at, bb.expires_at, bb.reason
FROM banhammer_players AS bu
JOIN banhammer_bans AS bb
ON bu.id = bb.player_id
JOIN banhammer_players AS ba
ON bb.creator_id = ba.id