include "botcheck.php";
include "session.php";
include_once "useronline/addonline.php";
include "dailyhits.php";
include "authenticate.php";
GrabVar('q');
?>
PhrozenFlame.com - Connecting You to the World of Flash
:: Results from Internal
Title
Author
Date Added
if ($q) {
$query = "(SELECT `Id`,`Title`,`Author`,`Time`,`Type`,`NoThumb`,`Views` FROM flashmovies WHERE `Title` LIKE '%$q%' OR `Author` LIKE '%$q%' OR `Description` LIKE '%$q%') UNION (SELECT `Id`,`Title`,`Author`,`Time`,`Type`,`NoThumb`,`Views` FROM flashgames WHERE `Title` LIKE '%$q%' OR `Author` LIKE '%$q%' OR `Description` LIKE '%$q%') ORDER BY `Views` DESC";
$result = MySQL_query($query);
if (mysql_num_rows($result) > 0) {
While( $rows = MySQL_fetch_array($result) ) {
$id = $rows['Id'];
$type = $rows['Type'];
$title = $rows['Title'];
$author = $rows['Author'];
$submitted = date("d/m/y H:i:s", $rows['Time']);
if ($rows['NoThumb']=="True") {
$screenlink = "images/nothumb.jpg";
} else {
$screenlink = "thumbs/$type/$id.jpg";
}
if ($type=="flash") { $type = "flashclip"; }
?>