<?php session_start();?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="description" CONTENT="نام سايت">
<title>نام سايت</title>
<?
// Get Shamsi_Date now ---------
$y_miladi=date("Y");
$m_miladi=date("n");
$d_miladi=date("j");
$date="$y_miladi-$m_miladi-$d_miladi";
require_once('miladi_to_shamsi.inc');
$c=new miladi_to_shamsi();
$p=$date;
$c -> to($p);
$day =$c -> day();
$month =$c -> month();
$year =$c -> year();
$day1 = $day+1; $month1 = $month-1;
if (strlen($day)==1) $day = "0$day";
if (strlen($month)==1) $month = "0$month";
$HTTP_SESSION_VARS['day'] = $day;
$HTTP_SESSION_VARS['month'] = $month;
$HTTP_SESSION_VARS['year'] = $year;
$date2 = "$year-$month-$day";
// connect DB
require('connect_to_mysql.php');
// Get News Overtime
$query = "select time from over_time";
$result = mysql_query($query);
if (!$result)
require_once('create_tables.php');
$row = mysql_fetch_row($result);
$time = $row[0];
if ($time==1)
$t = 7;
elseif($time==2)
$t = 14;
else
$t = 21;
if ($month<7)
$num = 31;
else
$num = 30 ;
$sum = ($month * $num ) + $day ;
$sum = $sum-$t;
$m = (integer)($sum/$num) ;
$d = $sum % $num ;
if (strlen($d)==1) $d = "0$d";
if (strlen($m)==1) $m = "0$m";
$date1 = "$year-$m-$d";
// Get News Types Id
$array = array('mashhad','national','analys');
for ($i=0;$i<=2;$i++)
{
$query = "select id from news_type
where type = '$array[$i]' ";
$result = mysql_query($query);
$row = mysql_fetch_row($result);
$type[$i] = $row[0];
}
$query_news="select body from news";
$result_news = mysql_query($query_news);
$num_news=mysql_num_rows($result_news);
while($row = mysql_fetch_row($result_news) )
{
$d = $row[2];
$m = $row[3];
if (strlen($d)==1) $d = "0$d";
if (strlen($m)==1) $m = "0$m";
$dte = "$row[4]-$m-$d";
if ( ($dte>=$date1) && (($row[7]==1 && isset ($HTTP_SESSION_VARS['user'])) || ($row[7]==0)) )
{
$img = $row[5];
$khabar = $row[1];
$id = $row[0];
$time = $row[6];
$title=strtok($khabar,'//');
$ln=strlen($title);
$khabar=substr($khabar,$ln+2);
$khabar_show=strtok($khabar,'///');
print '<meta name="Keywords" CONTENT="'.$khabar.'">';
}
}
?>
<link rel="stylesheet" type="text/css" href="styles.css" />