database_query("SELECT * FROM bateworldcom_zips.bator_training WHERE approved=1 AND id={$id}"); $row=$database->database_fetch_array($query); } elseif($season!=""){ $query=$database->database_query("SELECT * FROM bateworldcom_zips.bator_training WHERE approved=1 AND season={$season} order by id DESC LIMIT 1"); $row=$database->database_fetch_array($query); $id=$row["id"]; } else{ $query=$database->database_query("SELECT * FROM bateworldcom_zips.bator_training WHERE id>39 AND approved=1 ORDER BY id DESC LIMIT 1"); $row=$database->database_fetch_array($query); $id=$row["id"]; } // SET GLOBAL PAGE TITLE/DESCRIPTION $select=""; $query1=$database->database_query("SELECT * FROM bateworldcom_zips.bator_training WHERE season=".$row["season"]." AND approved=1 order by id DESC"); while($row1=$database->database_fetch_array($query1)) { $select.=""; $videoexists=1; } $query2=$database->database_query("SELECT DISTINCT(season) FROM bateworldcom_zips.bator_training WHERE approved=1 order by id DESC"); while($row2=$database->database_fetch_array($query2)) { $seasons.=""; } $msize=ini_get('upload_max_filesize'); $commentcount = $database->database_result($database->database_query("SELECT COUNT(*) FROM batortrainingcomments WHERE object_id='".$id."'"),0); function grabcomments() { global $url, $id, $database; $query = $database->database_query("SELECT * FROM batortrainingcomments WHERE object_id='".$id."' ORDER BY id DESC"); while($row=$database->database_fetch_array($query)) { $owner1=new SEUser(Array($row["authoruser_id"])); ?>
} } function videoplay(){ global $row, $database, $user, $id, $videoexists; $video_info=$row; ?> database_result($database->database_query("SELECT COUNT(*) FROM likedbatortraining WHERE media_id='".$id."'"),0); $smarty->assign('total_likes', $total_likes); $likedmedia=$database->database_query("SELECT * FROM likedbatortraining, se_users WHERE likedbatortraining.user_id='".$user->user_info["user_id"]."' AND likedbatortraining.user_id=se_users.user_id AND media_id={$id}"); if($database->database_num_rows($likedmedia)>0){$smarty->assign('likedmedia', 1);}else{$smarty->assign('likedmedia', 0);} $likedmedia1=$database->database_query("SELECT * FROM likedbatortraining, se_users WHERE likedbatortraining.user_id=se_users.user_id AND media_id={$id} ORDER by likedbatortraining.id DESC"); while($row2=$database->database_fetch_array($likedmedia1)) { $likes[]=$row2; } //=$database->database_fetch_array($likedmedia); $smarty->assign('likes', $likes); $smarty->assign('videoplay', $videoplay); $smarty->assign('thetitle', 'Bator Training'); $smarty->assign('id', $id); $smarty->assign('select', $select); $smarty->assign('commentcount', $commentcount); $smarty->assign('video', $row); $smarty->assign('thedescription',''); $smarty->assign('previousseasons',$seasons); $smarty->assign('thekeywords','bateworld, men\'s masturbation'); $smarty->assign('msize', $msize); include "footer.php"; ?>