<?php
include('config.php');
dbConn();
$nav_menu = 6;
include('mod_html_top.php');
?>
<img src="images/section_mystuff.jpg" width="360" height="54" /><br />
<?
include('mod_rcol_mystuff.php');
$content_type = "";
if (isset($_GET['page'])) { $page = addslashes($_GET['page']); } else { $page = "1"; }
/*
if (isset($_GET['ct'])) {
	$content_type = " AND `cms_members_comments`.`content_type` = '".addslashes($_GET['ct'])."' ";
} else {
	$content_type = "";
}
*/

$page_limit = 25;
$limit_start = $page * $page_limit - $page_limit;
	
$get_total = @mysql_query("SELECT `cms_members_comments`.`comment_id` FROM `cms_members_comments`
WHERE `cms_members_comments`.`member_id` = '".$member_id."'".$content_type);


$total_rows = @mysql_num_rows($get_total);
$total_pages = ceil($total_rows / $page_limit);

$grab_sql = @mysql_query("SELECT `cms_members_comments`.`comment_id`,
`cms_members_comments`.`member_id`,
`cms_members_comments`.`content_type`,
`cms_members_comments`.`content_id`,
`cms_members_comments`.`date`,
`cms_members_comments`.`approved`,
`cms_members_comments`.`comment`
FROM `cms_members_comments`
WHERE `cms_members_comments`.`member_id` = '".$member_id."'".$content_type."
ORDER BY `cms_members_comments`.`comment_id` DESC LIMIT ".$limit_start.",".$page_limit);

if ($total_pages > 1) {
	$pagination = pagination($_SERVER['PHP_SELF']."?ct=".$content_type,$page,$total_pages);
} else {
	$pagination = "";
}

if(@mysql_num_rows($grab_sql) == 0) { // IF NO RECORDS
?>
<table border="0" cellspacing="10" cellpadding="0" align="center"><tr><td><div align="center" class="contentname">You have not left any comments!</div></td></tr></table>
<?
} else {

		unset($row);
		echo $pagination;	
		while ($row = mysql_fetch_array($grab_sql)) {
		
				$url_content[1] = "model.php?id=";
				$url_text[1] = "model";
				$url_content[2] = "photoset.php?id=";
				$url_text[2] = "photoset";
				$url_content[3] = "video.php?id=";
				$url_text[3] = "video";
		
	$dt = explode("-", $row['date']);
	$date = date("F jS, Y", mktime(0, 0, 0, $dt[1], $dt[2], $dt[0]));
	$display_name = stripslashes($row['display_name']);
	$comment = stripslashes($row['comment']);
	
	$url = "<a href=\"".$url_content[$row['content_type']].$row['content_id']."\">view ".$url_text[$row['content_type']]."</a>";
	
	if ($row['approved'] == "1") {
		$status = "approved";
	} else {
		$status = "pending approval";
	}
						
?>
<hr size="1" color="#d1d1d1"/>
<table width="600" border="0" cellspacing="10" cellpadding="0">
<tr><td><a href="mystuff_comments_delete.php?id=<?=$row['comment_id']?>">delete</a> &bull; <a href="mystuff_comments_edit.php?id=<?=$row['comment_id']?>">edit</a> &bull; <?=$url?> <strong>status:</strong> <?=$status?><br />
<strong><?=$date?></strong></td></tr>
<tr><td><?=$comment?></td></tr>
</table>
<?

}
echo $pagination;	
}

include('mod_html_middle.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_topphotos.php');
include('mod_rcol_topvideos.php');
include('mod_rcol_random.php');
include('mod_rcol_conversation.php');
include('mod_rcol_feedback.php');

include('mod_html_bottom.php');

?>