database_query("SELECT COUNT(*) AS total FROM bateworldcom_zips.bateoffvotes WHERE videoid='".$database->database_real_escape_string($id)."'");
$totalvotes=$database->database_fetch_array($query);
$query=$database->database_query("SELECT * FROM bateworldcom_zips.bateoff_contestants ORDER BY id"); $x=0;
while($row=$database->database_fetch_array($query)){
$contestants[$x]["username"]=$row["name"];
$contestants[$x]["id"]=$row["id"];
$contestants[$x]["picture"]=$row["picture"];
$query1=$database->database_query("SELECT COUNT(*) AS votes FROM bateworldcom_zips.bateoffvotes WHERE videoid='".$database->database_real_escape_string($id)."' AND votefor='".$database->database_real_escape_string($row["id"])."'");
$contestants[$x]["votes"]=$database->database_fetch_array($query1);
$x++;
}
shuffle($contestants);
$x=0;$y=1;
foreach($contestants as $contestant){?>
database_result($database->database_query("SELECT COUNT(*) FROM bateoffcomments WHERE object_id='".$id."'"),0);
if($commentcount==""){$commentcount=0;}
//if($thisbateoff["is_converted"]==0){}else{
?>
_postcomment">
Comments ()
database_query("SELECT * FROM bateoffcomments WHERE object_id='".$id."' ORDER BY id DESC");
while($row=$database->database_fetch_array($query))
{
$owner1=new SEUser(Array($row["authoruser_id"]));
?>
To pay by mail, please choose a non-recurring membership length below. Be sure to include your Bateworld profile name and email address with your payment.
30 Days - $15 90 Days - $25 180 Days - $41 365 Days - $75
Mail your payment and request to:
B.W.E.
P.M.B. #241
8485 E. McDonald Drive
Scottsdale, AZ 85250
Your confidential information will be used only to credit your profile. We do not share or sell our member data.
You will be notified when your payment has been accepted.
';
$smarty->assign('modalcontent', $modal);
include "footer.php";
?>