<?
require('../admin/db.php');
if(!isset($_SESSION['userid'])) { 
	header("Location: $basehttp/login");
	exit();
}

$favoritesPage = true; 

$result = array(); 

//this has to be done a bit strangely, because we aren't using a numeric key for the performers because this autoincrimenting key would be in the trillions after a while.
$favorites = dbQuery("SELECT * FROM favorites WHERE user = '".(int)$_SESSION['userid']."'",false);
foreach($favorites as $f) { 
	$data = dbRow("SELECT `performers`.*, paysites.slug AS siteSlug, paysites.name as siteName FROM `performers` RIGHT JOIN `paysites` ON `performers`.`site` = `paysites`.`record_num` WHERE `performers`.`deleted` = 0 AND `performers`.`enabled` = 1 AND performers.username = '".mysqli_real_escape_string($dblink,$f['performer_name'])."' AND performers.site = '".(int)$f['performer_site']."'");
	if(is_array($data)) { 
		$result[] = $data;
	}
}

if(is_array($result)) { 
	$total_results = count($result);
	foreach ($result as $row) {
        include($template_path . "/template.performer_item.php");
    }
} else { 
	echo '<div class="notification-col col">';
	echo setMessage(_t("Sorry, no results were found."), 'alert', true);
    echo "</div>";
}