<?php
if (!isset($_GET['id'])) { // IF NO MODEL_ID... REDIRECT
printf("<meta http-equiv=\"Refresh\" content=\"0;url=./models.php\">"); 
die();
}
$content_id = $_GET['id'];
$content_type = "1"; // MODEL
include('config.php');
dbConn();


include('mod_html_top.php');
include('mod_rcol_vipdelight.php');
include('mod_rcol_coming.php');
include('mod_rcol_browse.php');
include('mod_rcol_vipnetwork.php');
include('mod_rcol_search.php');

include('mod_rcol_topmodels.php');
include('mod_rcol_random.php');
include('mod_rcol_conversation.php');
include('mod_rcol_feedback.php');
include('mod_html_middle.php');

$page_limit = "9";
$limit_start = "0";
$page = "1";
$sort_by  = "`cms_models`.`name`";
$sort_order = "ASC";
$sort_url = "?id=".$content_id;

if (isset($_GET['page'])) {
	$page = $_GET['page'];
}

$limit_start = $page * $page_limit - $page_limit;

$model_info = @mysql_query("SELECT `cms_tags_s`.`ctag_id` , `cms_tags_s`.`description`, `cms_tags_s`.`stag_id`
FROM `cms_tags`
INNER JOIN `cms_tags_s` ON `cms_tags_s`.`stag_id` = `cms_tags`.`stag_id`
WHERE `cms_tags`.`content_id` = '".$content_id."' AND `cms_tags`.`content_type` = '1' AND `cms_tags_s`.`ctag_id` IN (8,16,17,18)");

//$sort = "";
while ($row = mysql_fetch_array($model_info)) {
	//if($sort != "") { $sort .= ","; }
	//$sort .= $row['stag_id'];
		$model_stats[$row['ctag_id']] = $row['stag_id'];
}

//$sort = "AND `cms_tags`.`stag_id` IN (".$sort.")";

$models = "";
$get_hair = @mysql_query("SELECT `cms_models`.`model_id`
FROM `cms_models`
INNER JOIN `cms_tags` ON `cms_tags`.`content_id` = `cms_models`.`model_id`
WHERE `cms_models`.`releasedate` <= '".$today."' AND `cms_tags`.`stag_id` = '".$model_stats[8]."'
GROUP BY `cms_models`.`model_id`");
unset($row);
while ($row = mysql_fetch_array($get_hair)) {
		$models .= $row['model_id'].",";
}
$models = rtrim($models, ',');


$get_bodytype = @mysql_query("SELECT `cms_models`.`model_id`
FROM `cms_models`
INNER JOIN `cms_tags` ON `cms_tags`.`content_id` = `cms_models`.`model_id`
WHERE `cms_models`.`releasedate` <= '".$today."' AND `cms_tags`.`stag_id` = '".$model_stats[16]."' AND `cms_models`.`model_id` IN (".$models.")
GROUP BY `cms_models`.`model_id`");
unset($row);
$models = "";
while ($row = mysql_fetch_array($get_bodytype)) {
		$models .= $row['model_id'].",";

}
$models = rtrim($models, ',');

$get_breasttype = @mysql_query("SELECT `cms_models`.`model_id`
FROM `cms_models`
INNER JOIN `cms_tags` ON `cms_tags`.`content_id` = `cms_models`.`model_id`
WHERE `cms_models`.`releasedate` <= '".$today."' AND `cms_tags`.`stag_id` = '".$model_stats[17]."' AND `cms_models`.`model_id` IN (".$models.")
GROUP BY `cms_models`.`model_id`");
unset($row);
$models = "";
while ($row = mysql_fetch_array($get_breasttype)) {
		$models .= $row['model_id'].",";
}

$models = rtrim($models, ',');

$get_breasttype = @mysql_query("SELECT `cms_models`.`model_id`
FROM `cms_models`
INNER JOIN `cms_tags` ON `cms_tags`.`content_id` = `cms_models`.`model_id`
WHERE `cms_models`.`releasedate` <= '".$today."' AND `cms_tags`.`stag_id` = '".$model_stats[18]."' AND `cms_models`.`model_id` IN (".$models.")
GROUP BY `cms_models`.`model_id`");
unset($row);
$models = "";
while ($row = mysql_fetch_array($get_breasttype)) {
		$models .= $row['model_id'].",";
}

//$sort = str_replace($content_id.",","",$models);
$sort = $models;
$sort = rtrim($sort, ',');
$sort = "AND `cms_models`.`model_id` IN (".$sort.")";

$get_total = @mysql_query("SELECT `cms_models`.`model_id`
FROM `cms_models`
INNER JOIN `cms_tags` ON `cms_tags`.`content_id` = `cms_models`.`model_id`
WHERE `cms_models`.`releasedate` <= '".$today."' ".$sort."
GROUP BY `cms_models`.`model_id`");
$total_rows = @mysql_num_rows($get_total);


$total_pages = ceil($total_rows / $page_limit);

if ($total_pages > 1) {
$pagination = pagination("models_likeme.php".$sort_url,$page,$total_pages);
} else {
$pagination = "";
}

$query = "SELECT `cms_models`.`model_id`,
`cms_models`.`releasedate`,
`cms_models`.`model_id`,
`cms_models`.`name`,
LEFT(`cms_models`.`name`,1) as model_letter,
`cms_models`.`total_videos`,
`cms_models`.`total_photos`,
(`cms_models`.`rate_total`/`cms_models`.`rate_count`) as rate
FROM `cms_models`
INNER JOIN `cms_tags` ON `cms_tags`.`content_id` = `cms_models`.`model_id`
WHERE `cms_models`.`releasedate` <= '".$today."' ".$sort."
GROUP BY `cms_models`.`model_id` 
ORDER BY ".$sort_by." ".$sort_order."
LIMIT ".$limit_start.",".$page_limit."";

$num_columns = "3";
$section = "models";
include('mod_model_output.php');


include('mod_html_bottom.php');
?>