<?php 
if(substr_count($_SERVER['HTTP_ACCEPT_ENCODING'], 'gzip')) ob_start("ob_gzhandler"); else ob_start();
session_start();
header('Content-Type: text/html; charset=utf-8');
$offset = 60 * 60 * 60 * 60;
$expire = 'expires: ' . gmdate ('D, d M Y H:i:s', time() + $offset) . ' GMT';
header ($expire);
$username = $_COOKIE['user_valid'];
include 'opendb.php';

$cat = $_REQUEST['cat'];
$w = $_REQUEST['w'];
$w = (($w*10)-10);
$st = $w;
$pr = $_REQUEST['pr'];
if((!$st || ($st < 0))) $st = 0;
if(!$pr) $pr = 10;
$slr = round($st/$pr, 0)+2;
$next = $st+$pr;
if($st <= $pr)
{
$back = 0;
}else{
$back = $st-$pr;
}

$val = str_replace("_", " ", $cat);
$val = str_replace("-", " ", $val);

$path = '/messages/'.$_REQUEST[cat].'';

$sqlch = "SELECT * FROM `messages_main_categories` WHERE `cat_url` = '$cat'"; 
$resultch = mysql_query($sqlch) or die('Error, query failed ' . mysql_error());
$count_if_ext = mysql_num_rows($resultch);
if($count_if_ext != '0')
{
$cat_url = $cat;

$rowch = mysql_fetch_array($resultch);
$category_name = $rowch['cat_name'];
$q_cat_url = $rowch['cat_url'];
$head_title = $rowch['cat_name'];
$head_title_text = '';

$title = $rowch['cat_title'];
$keywords = $rowch['cat_keywords'];
$description = $rowch['cat_description'];
$cat_text = $rowch['cat_text'];

$inccat = 1;

if($_REQUEST['w'] > '0')
{
$ww = $w+1;
$meta_title_end = " - page $_REQUEST[w]";
}
}
else
{
$sqlcdb = "SELECT * FROM `messages_categories` WHERE `sub_cat_url` = '$cat' AND `sub` = 'no'"; 
$resultcdb = mysql_query($sqlcdb) or die('Error, query failed ' . mysql_error());
$count_if_exist = mysql_num_rows($resultcdb);
if($count_if_exist != '0')
{
$rowcdb = mysql_fetch_array($resultcdb);
$catnamedb = $rowcdb['cat_name'];
$subcatnamedb = $rowcdb['sub_cat_name'];
$sub_cat_url = $rowcdb['sub_cat_url'];

$head_title = $rowcdb['sub_cat_name'];
$head_title_text = $rowcdb['cat_name'];

$cat_url = $rowcdb['cat_url'];
$q_cat_url = $rowcdb['cat_url'];

$title = $rowcdb['sub_cat_title'];
$keywords = $rowcdb['sub_cat_keywords'];
$description = $rowcdb['sub_cat_description'];
$cat_text = $rowcdb['sub_cat_text'];

$inccat = 1;

if($_REQUEST['w'] > '0')
{
$meta_title_end = " - page $_REQUEST[w]";
}

}
else
{
$sql_q = "SELECT * FROM `messages_sub_categories` WHERE `ss_cat_url` = '$cat'"; 
$result_q = mysql_query($sql_q) or die('Error, query failed ' . mysql_error());
$count_ext = mysql_num_rows($result_q);
if($count_ext != '0')
{
$dlist = mysql_fetch_array($result_q);
$cat_name = $dlist['cat_name'];
$cat_url = $dlist['cat_url'];
$sub_cat_name = $dlist['sub_cat_name'];
$sub_cat_url = $dlist['sub_cat_url'];
$ss_cat_name = $dlist['ss_cat_name'];
$ss_cat_url = $dlist['ss_cat_url'];

$head_title = $dlist['ss_cat_name'];
$head_title_text = $dlist['sub_cat_name'];

$title = $dlist['ss_cat_title'];
$keywords = $dlist['ss_cat_keywords'];
$description = $dlist['ss_cat_description'];
$cat_text = $dlist['ss_cat_text'];

$inccat = 0;

if($_REQUEST['w'] > '0')
{
$meta_title_end = " - page $_REQUEST[w]";
}

}
else
{
$sqlcdb = "SELECT * FROM `messages_sub_categories` WHERE `sub_cat_url` = '$cat'"; 
$resultcdb = mysql_query($sqlcdb) or die('Error, query failed ' . mysql_error());
$count_if_exist = mysql_num_rows($resultcdb);
if($count_if_exist == '0')
{
$error_status = '404';
//header("Location: http://www.greet2k.com/messages/404.html");
}
else
{
$rowcdb = mysql_fetch_array($resultcdb);
$cat_name = $rowcdb['cat_name'];
$cat_url = $rowcdb['cat_url'];
$sub_cat_name = $rowcdb['sub_cat_name'];
$sub_cat_url = $rowcdb['sub_cat_url'];
$ss_cat_name = $rowcdb['ss_cat_name'];
$ss_cat_url = $rowcdb['ss_cat_url'];

$head_title = $rowcdb['sub_cat_name'];
$head_title_text = $rowcdb['cat_name'];

$title = $rowcdb['ss_cat_title'];
$keywords = $rowcdb['ss_cat_keywords'];
$description = $rowcdb['ss_cat_description'];	  

$sqlsub = "SELECT * FROM `messages_categories` WHERE `sub_cat_url` = '$cat'"; 
$resultsub  = mysql_query($sqlsub ) or die('Error, query failed ' . mysql_error());

$rowsub  = mysql_fetch_array($resultsub);
$subch = $rowsub['sub'];
$title = $rowsub['sub_cat_title'];
$keywords = $rowsub['sub_cat_keywords'];
$description = $rowsub['sub_cat_description'];
$cat_text = $rowsub['sub_cat_text'];

$inccat = 1;

if($_REQUEST['w'] > '0')
{
$meta_title_end = " - page $_REQUEST[w]";
}

}
}
}
}
if($error_status != '404'){
//============================================================================
if($inccat == '0'){
$topsql_sg = "SELECT SUM(voteup) AS `vtup`, SUM(votedown) AS `vtdown`, SUM(views) AS `totalview` FROM `messages` WHERE `cat_url` = '$cat_url' AND `sub_cat_url` = '$sub_cat_url' AND `ss_cat_url` = '$ss_cat_url'";
}else{
if($rowcdb['sub_cat_url'] != ''){
$topsql_sg = "SELECT SUM(voteup) AS `vtup`, SUM(votedown) AS `vtdown`, SUM(views) AS `totalview` FROM `messages` WHERE `cat_url` = '$cat_url' AND `sub_cat_url` = '$sub_cat_url'";
}else{
$topsql_sg = "SELECT SUM(voteup) AS `vtup`, SUM(votedown) AS `vtdown`, SUM(views) AS `totalview` FROM `messages` WHERE `cat_url` = '$cat_url'";
}
}
//$topsql_sg = "SELECT SUM(voteup) AS `vtup`, SUM(votedown) AS `vtdown`, SUM(views) AS `totalview` FROM `quotes`"; 
$topresult_sg = mysql_query($topsql_sg) or die('Error, query failed ' . mysql_error());
$toprow_sg = mysql_fetch_array($topresult_sg);

$voteup_sg = $toprow_sg['vtup'];
$votedown_sg = $toprow_sg['vtdown'];
$totalview = $toprow_sg['totalview'];
$total_sg = $voteup_sg + $votedown_sg;
if($voteup_sg > 0) {
$percenteach = ($voteup_sg/$total_sg) * 5;
$rate_sg = round($percenteach, 0);
}else{ $rate_sg = "0"; }
//=============================================================================
?>

<!DOCTYPE html>
<html lang="en">
<head>
<meta name="viewport" content="width=device-width,initial-scale=1">
<meta charset="utf-8">
<?php
$count_word_title = str_word_count($title);
$count_word_description = str_word_count($description);
$count_word_keywords = str_word_count($keywords);
if($count_word_title == 0){
?>
<title><?=$head_title;?> SMS, Text Messages, Wishes, Greetings, Jokes, Quotes<?=$meta_title_end;?></title>
<?php
}else{
?>
<title><?=$title;?><?=$meta_title_end;?></title>
<?php
}
if($count_word_description == 0){
?>
<meta name="description" content="Collection of <?=strtolower($head_title);?> text messages, sms, greetings, jokes wishes, quotes, sayings to read and send<?=$meta_title_end;?>">
<?php
}else{
?>
<meta name="description" content="<?=$description;?><?=$meta_title_end;?>">
<?php
}
if($$count_word_keywords == 0){
?>
<meta name="keywords" content="<?=strtolower($head_title);?>, sms, messages, text message, txt sms, wishes, greetings, funny, sayings, quotes, quotations, poems, mobile, jokes">
<?php
}else{
?>
<meta name="keywords" content="<?=$keywords;?>">
<?php
}
?>
<link href="http://www.greet2k.com/greetings/stylesheet/styles.css" rel="stylesheet">
<link href="/messages/stylesheet/sms-body.css" rel="stylesheet">
<link rel="shortcut icon" href="http://greet2k.com/favicon.ico">
<!--ForWebMenu-->
<link href="http://www.greet2k.com/greetings/stylesheet/dropdown/dropdown.linear.css" media="screen" rel="stylesheet" type="text/css" />
<link href="http://www.greet2k.com/greetings/stylesheet/dropdown/themes/default/default.linear.css" media="screen" rel="stylesheet" type="text/css"/>
<link href="/stylesheet/top-nav.css" rel="stylesheet">
<!--ForWebMenu-->
<!--forResponsivMenu-->
<link href="http://www.greet2k.com/greetings/stylesheet/demo.css" rel="stylesheet">
<script src="http://www.greet2k.com/greetings/java/jquery.js"></script>
<script src="http://www.greet2k.com/greetings/java/flaunt.js"></script>
<!--forResponsivMenu-->

<script>
function share_block(u, t) 
{ 
window.open('http://www.facebook.com/sharer.php?u='+encodeURIComponent(u)+'&t='+encodeURIComponent(t),'sharer', 'toolbar=0, status=0, width=626, height=436'); return false; 
} 
</script>
</head>
<BODY itemscope itemtype="http://schema.org/WebPage">
<meta itemprop="thumbnailUrl" content="http://cdn.greet2k.com/click-icons/<?=$get_cat;?>.jpg" />
<meta itemprop="image" content="http://cdn.greet2k.com/click-icons/<?=$get_cat;?>.jpg" />
<?php if($count_word_description == 0){ ?>
<meta itemprop="description" content = "Collection of <?=strtolower($head_title);?> text messages, sms, greetings, jokes wishes, quotes, sayings to read and send<?=$meta_title_end;?>">
<?php }else{ ?>
<meta itemprop="description" content = "<?=$description;?><?=$meta_title_end;?>">
<?php
}
if($count_word_keywords == 0){
$k_words = explode(", ", "$head_title, messages, text message, wishes, greetings");
for($i = 0; $i < count($k_words); $i++){ echo "<meta itemprop=\"keywords\" content = \"$k_words[$i]\">"; }
}else{
$k_words = explode(", ", $keywords);
for($i = 0; $i < count($k_words); $i++){ echo "<meta itemprop=\"keywords\" content = \"$k_words[$i]\">"; }
}
?>
<div itemprop="aggregateRating" itemscope itemtype="http://schema.org/AggregateRating">
<meta itemprop="worstRating" content = "1">
<meta itemprop="ratingValue" content = "<?=$rate_sg;?>">
<meta itemprop="bestRating" content = "5">
<meta itemprop="ratingCount" content = "<?=$total_sg;?>">
</div>

<?php include '../dynamic/usertop-nav.html';?>
<?php // include 'dynamic/header.html';?>

<?php 
$includeFile = file_get_contents("http://www.greet2k.com/greetings/dynamic/resposivenav.html");
//echo $includeFile;
?>

<section id="wrap">
<div class="wrap topmargin">


<?php 
$includeFile = file_get_contents("http://www.greet2k.com/greetings/dynamic/top-add.html");
echo $includeFile;
?>


<?php
if($inccat == '0')
{
include 'scat.html';
}
else
{
include 'cat.html';
}
?>


<!--LeftPart-->


<?php include 'dynamic/aside.html';?>
<?php 
    $includeFile = file_get_contents("http://www.greet2k.com/greetings/dynamic/top-add.html");
    echo $includeFile;
?>
</div>
</section>
<?php include 'dynamic/footer.html';?>
</body>
</html>
<?php
}else{
$lnk = "http://www.greet2k.com/messages/";
header("HTTP/1.1 301 Moved Permanently"); 
header("Location: $lnk");
}
?>