<?php // categ.php -- Displays items from category definitions

$hostName = "localhost";
$userName = "honeyadmin";
$password = "honeys2002";
$databaseName = "honeys";

$baseDir = '/home/httpd/pinkhoneypot.com/html/members/hungarianhoneys/';

$link = mysql_connect($hostName, $userName, $password);
mysql_select_db($databaseName, $link);

$dom = DOM;
$time = mktime("12", "00", "00", date("m"), date("d"),  date("Y"));

include "header-2.php";
echo "<div style='width: 900px; background-image: url(images/background-left.gif)'>";

$z = 'HoneySchool;Videos';
define(COL_CATEG, "5");
define(HOW_CATEG, "50");
define(EXTRA_LINK, "25");
$keys = explode(';', $z);
$word = " and (word LIKE '%".$keys[0]."%'";
for($x=1; $x < count($keys); $x++) {
	$word .= " OR word LIKE '%".$keys[$x]."%'";
}
$word .= ")";

$girlname = str_replace('_', ' ', $categ);
$girlname = str_replace('-', ' ', $girlname);

$select = "select * from sets where dates<=$time $word and compliant='yes' and (word like '%".$categ."%' OR girlname='".$girlname."' OR girlname LIKE '".$girlname.";%' OR girlname LIKE '%;".$girlname.";%' OR girlname LIKE '%;".$girlname."') ORDER BY dates DESC, name";
$result = mysql_query($select);
$all = mysql_num_rows($result);

if (isset($all)) $all = intval($all);
if (isset($sta)) $sta = intval($sta); else $sta = 0;
if (isset($show)) $show = intval($show); else $show = HOW_CATEG;

if($file = @fopen("template.html", "r")) {
	while(!feof($file)) {
		$TEM.=fgets($file, 1024);
	}
	fclose($file);
}

$select .= " LIMIT $sta,$show";
$result = mysql_query($select);
$up = 0;
$rowup = 0;

echo "<div class='text'>";
echo "	You want access to all of our <strong>" .number_format($all). "</strong> updates and now's your chance to have them all instantly!  With an easy to use <strong>honey index</strong>, <strong>zip downloads</strong> and boner inducing <strong>High Definition Videos</strong> you'll find the honey of your dreams in minutes.";
echo "</div>";

$num_pages = ceil( $all / $show );
echo "<div class='navagation'>\n";
if( $sta > 0 ) {
  echo "<a href='$PHP_SELF?categ=$categ&sta=".($sta - $show)."'><<<&nbsp;<u>PREV</u></a>\n";
}

for( $i = 0; $i < $num_pages; ++$i ) {
  $link_sta = $i * $show;
  if( $link_sta == $sta )
    echo ($i+1);
  else
    echo " <a href='".$PHP_SELF."?categ=".$categ."&sta=".$link_sta."'><u>".($i+1)."</u></a> ";
}

if( ($sta + $show) < $all ) {
  echo "<a href='".$PHP_SELF."?categ=".$categ."&sta=".($sta + $show)."'><u>NEXT</u>&nbsp;>>></a>\n";
}
echo "</div>";

echo "<div style='width:900px; margin: 0 auto;'>";
echo "\r\n<table class='updates' align='center' cellspacing='0' cellpadding='0' border='0'>\r\n<tr>\r\n";
while($row = mysql_fetch_object($result)) {
	if ($rowup == EXTRA_LINK) {
		?>
		</tr></table>
		<div class="join">
			<a href="join.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Updates1','','images/index-o_28.gif',1)"><img src="images/index_28.gif" name="Updates1" width="874" height="44" border="0" id="Updates1" alt="Click Here To Join Honey School Now!" /></a>
		</div>
		<?php
		$up = 0;
		echo "\r\n<table class='updates' align='center' cellspacing='0' cellpadding='0' border='0'>\r\n<tr>\r\n";
		}
	if($up == COL_CATEG) {
		echo "</tr>\r\n<tr>\r\n";
		$up = 0;
		}
	$rowup ++;
	if ($row->type == "movie") {
		echo "<td valign='top'>\r\n	<table align='center' cellspacing='0' cellpadding='0' border='0'><tr><td class='thum-updates'><img src='images/frame-top.gif' width='150' height='8' alt='' border='0'><br /><a href='join.php'><img src='$row->icon' alt='$row->name' border=0></a><br /><img src='images/frame-bottom.gif' width='150' height='23' alt='' border='0'></td></tr></table>\r\n";
		echo "	<p class='date'>$row->day</p>\r\n	<p class='girl'>$row->girlname</p>\r\n	<p class='desc'>$row->name</p>\r\n</td>\r\n";
	} else {
		echo "<td valign='top'>\r\n	<a target='_new' href='join.php'><img src='$row->icon' class='thumb-updates' alt='$row->name'></a><br />\r\n	<p class='date'>$row->day</p>\r\n	<p class='girl'>" . str_replace(';','<br />',$row->girlname) . "</p>\r\n	<p class='desc'>$row->name</p>\r\n</td>\r\n";
	}
	$up ++;
}

echo "</tr>\r\n</table>\r\n\r\n";

$num_pages = ceil( $all / $show );
echo "<div class='navagation'>\n";
if( $sta > 0 ) {
  echo "<a href='$PHP_SELF?categ=$categ&sta=".($sta - $show)."'><<<&nbsp;<u>PREV</u></a>\n";
}

for( $i = 0; $i < $num_pages; ++$i ) {
  $link_sta = $i * $show;
  if( $link_sta == $sta )
    echo ($i+1);
  else
    echo " <a href='".$PHP_SELF."?categ=".$categ."&sta=".$link_sta."'><u>".($i+1)."</u></a> ";
}

if( ($sta + $show) < $all ) {
  echo "<a href='".$PHP_SELF."?categ=".$categ."&sta=".($sta + $show)."'><u>NEXT</u>&nbsp;>>></a>\n";
}
echo "</div>";

echo "</div>\r\n<div style='clear:both; height:0;'></div></div>";

include "footer.php";
?>