Welcome, New Sheep!';
echo "
";
$sql_join = "SELECT * FROM bs_accounts WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= `Join`";
$resultjoin = mysql_query($sql_join) or die("Query failed ($sql_join) - " . mysql_error());
$numrows_join = mysql_num_rows($resultjoin);
if ($numrows_join > 0) {
for($a = 0; $a < $numrows_join; $a++)
{
$row_join = mysql_fetch_array($resultjoin);
$name_join = $row_join['CitizenName'];
$id_join = $row_join['CitizenID'];
$irc_join = $row_join['IRCNick'];
$herd_join = $row_join['Team'];
$date_join = $row_join['Join'];
if($herd_join == 'HG') {
$herd_join = 'Honor Guard';
}
elseif($herd_join == '1RH') {
$herd_join = 'Red Herd';
}
elseif($herd_join == '1BH') {
$herd_join = 'Blue Herd';
}
elseif($herd_join == '1GH') {
$herd_join = 'Green Herd';
}
elseif($herd_join == '1YH') {
$herd_join = 'Yellow Herd';
}
elseif($herd_join == '1PH') {
$herd_join = 'Purple Herd';
}
elseif($herd_join == '1WH') {
$herd_join = 'White Herd';
}
elseif($herd_join == '1LH') {
$herd_join = 'Lost Herd';
}
$RowColor="bgcolor='#DDDDDD'";
//inserts the data in rows, creating one row for every record found
echo "
|
" . $name_join . "
|
";
//echo "| " . $name_join . " | ";
echo "
| IRC: | " . $irc_join . " | ";
echo "
| Herd: | " . $herd_join . " | ";
echo "
| Joined: | " . $date_join . " | ";
echo "
| Say hi: |  | ";
}
echo "
";
}
?>
'.$title.'';
echo '
'.$msg.'
';
}
/*
Supply Requests
We're halving second requests (for weapons) while our supplies are a little low. :( We apologize for the inconvenience.
Forums
Some sheep have been asking for forums, and we love to oblige. For any forum-lovers out there, please visit us at
The Black Sheep Forums. You can log in with your citizen ID and roster password.
Vote!
Please vote for The Black Sheep Party
here if you don't have any other party affiliations! The party could use your vote.
Moosic
Check out this band! (
Click Here)
Media Team Article
Please read (and if you like it, vote) this article:
Article Link
*/
?>