";
$date_font="";
$std_text_font="";
$cdate=mktime();
$newsdated1=mktime_to_mysqltime(time());
$y=substr($newsdated1,0,4);
$m=substr($newsdated1,4,2);
$d=substr($newsdated1,6,2);
$h=23;
$i=59;
$s=59;
//echo $y.$m.$d;
if($d)
{
$stamp1=mktime(0, 0,0, $m, $d, $y );
$stamp2=mktime($h, $i, $s, $m, $d, $y );
}
else
{
$day_number = genSet_Stop($m,$y);
$stamp1=mktime(0, 0,0, $m, 1, $y );
$stamp2=mktime($h, $i, $s, $m, $day_number, $y ); //
}
if($limit!=0)
{
$limitcond=" LIMIT $limit";
}
$query="Select * from ynfx_mis_news WHERE visibility='1' AND status ='a' AND `date_display_from` < '$cdate' AND date_display_to >'$cdate' AND `source` LIKE 'a:1:{i:0;s:2:\"16\";}' OR `source` LIKE 'a:2:{i:0;s:2:\"15\";i:1;s:2:\"16\";}' order by date_news desc $limitcond";
$l = 0;
$result=mysql_db_query($DATABASE,$query);
// echo "Query is $query
";
//$num = mysql_num_rows($result);
//echo "$num";
if(@mysql_num_rows($result))
{
for($i=0;$iSource is $source";
}
*/
/*
$sql_n="SELECT name FROM `ynfx_mis_source` WHERE `id` ='$SOURCE_news[0]' limit 10";
$result_n=mysql_db_query($DATABASE,$sql_n);
if(mysql_error()) error("Unexpected ERROR");
$field = mysql_fetch_array($result_n);
$type=$field['name']; */
//if(($type == 'India Budget') || (($type == 'Google') && ($type == 'India Budget')))
//{
if($l != 10)
{
$headern .="| |
";
//$headern .="| Total News: $num |
";
$headern .="| $std_newsheader_font$header |
";
$headern .="| $date_font Dated - ".date("d M, Y",$date_news )." |
";
$headern .="| $std_text_font $body ... Full Story |
";
$headern .="
";
$l++;
}
else
{
break;
}
$n = $i+1;
}
}//end of for
//}//end of if
if(!$n)$headern .="| $std_text_font No news |
";
$header .="";
return($headern);
}//end of function
function get_countrylist()
{
global $DATABASE;
$sql="select id, name from ynfx_mis_country where enable='1'";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected ERROR");
if(mysql_num_rows($result))
{
$ct=1;
while($row=mysql_fetch_row($result))
{
if(($ct==96)||($ct==191))
{
$header.="";
}
if(($ct==1)||($ct==96)||($ct==191))
{
$header.="";
}
$id=$row[0];
$name=$row[1];
$header.="$name
";
$ct++;
}//end of while
$header." | ";
}//end of if
return($header);
}//end of function
//check if he is a pref member or member who has opted for news
function check_access($login)
{
global $DATABASE;
$ct=0;
$cdate=substr(mktime_to_mysqltime(time()),0,8);
//getting the details from the service access table
$sql="select * from serviceaccess where login='$login' and serviceid in(13,4) and status='Paid' and expdate>'$cdate'";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($result)) $ct++;
//getting the details from the memberservice table
$sql="select * from memberservice where login='$login' and serviceid in(13,4) and paymentstatus='Paid' and expdate>'$cdate' and memberstatus='Approved'";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($result)) $ct++;
return($ct);
}
function get_classification_list($section)
{
global $DATABASE;
$cdate=mktime();
$sql="select distinct a.name, a.id from ynfx_mis_classification a, ynfx_mis_news b where a.id=b.classification and a.enable='1' and b.visibility='1' AND b.status ='a' AND b.date_display_from < '$cdate' AND b.date_display_to >'$cdate' and a.section='IN'";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error");
if(mysql_num_rows($result))
{
//$table.=' | ';
$i==0;
while($row=mysql_fetch_row($result))
{
$name=stripslashes($row[0]);
$id=$row[1];
//bgcolor='#FFFADC'
$table.="";
//if($i!=0) $table.=" | ";
if($id!=$section)
{
$table.="$name | ";
}
else
{
$table.="
$name";
}
$i++;
}//end of while
//$table.=' |
';
}//end of if
return($table);
}//end of function
function get_detail_news($id,$searchSTR)
{
global $DATABASE,$search_arr;
$cdate=time();
$sql="Select id, header, date_news, body from ynfx_mis_news WHERE visibility = '1' AND status = 'a' AND date_display_from < '$cdate' AND date_display_to >'$cdate' and id=$id";
$result = mysql_db_query($DATABASE, $sql);
if(mysql_error()) error("Unexpected Error !!");
if(mysql_num_rows($result))
{
$id = mysql_result($result,0,0);
$header = stripslashes(mysql_result($result,0,1));
$date = date("d M , Y",mysql_result($result,0,2));
$body = stripslashes(mysql_result($result,0,3));
if(trim($searchSTR))
{
$cnt = count($search_arr);
for($s=0;$s<$cnt;$s++)
{
$pat = $search_arr[$s];
$newpat = "\\0";
$body = eregi_replace($pat,"$newpat",$body);
}
}
//$news.="| $header |
| Dated - $date |
$body |
";
$news.="| $header |
| Dated - $date |
$body |
";
}//end of if
return($news);
}
function check_commn_words($str_search)
{
GLOBAL $HTTP_HOST;
$txtfile="http://$HTTP_HOST/mis/includes/wordsfile.txt";
$delimiter = ",";
$words=get_common_words($txtfile,$delimiter);
asort ($words); // sort alphabetically
reset ($words); // reset the list
$search_arr=process_string($str_search);
$result_arr = array_intersect($words, $search_arr);
if(count($result_arr)) return (is_array($result_arr)?@join(",",$result_arr):"");
return false;
}
function process_string_search($str)
{
$str=trim($str);
$str=eregi_replace("[[:space:][:punct:]]{1,}","#",$str);
return split ("#", $str);
}
function process_string($str)
{
$str=trim($str);
$str=eregi_replace("[\^\,\;\.\/\\[:space:][:punct:]]{1,}","#",$str);
$str=eregi_replace("[\#]{2,}","#",$str);
$str=eregi_replace("[\-]{1,}","#",$str);
//if(strpos($str, "#")==0 ) $str=substr("$str",1);
//$str=strrev ($str);
//if(strpos($str, "#")==0 ) $str=substr("$str",1);
//$str=strrev ($str);
return split ("#", $str);
}
function process_str($str)
{
$str=trim($str);
$str=eregi_replace("[\^\,\;\.\/\\[:space:][:punct:]]{1,}"," ",$str);
$str=eregi_replace("[\#]{2,}"," ",$str);
$str=eregi_replace("[\-]{1,}"," ",$str);
//if(strpos($str, "#")==0 ) $str=substr("$str",1);
//$str=strrev ($str);
//if(strpos($str, "#")==0 ) $str=substr("$str",1);
//$str=strrev ($str);
return $str;
}
function get_common_words ($txtfile,$delimiter)
{
if (!($fileref = fopen($txtfile,"r")))
{
return false;
}
$common_words_array=array();
while (!feof($fileref))
{
$current_line = fgets ($fileref,255);
$common_words_array = array_merge(split($delimiter,$current_line),$common_words_array);
}
fclose ($fileref);
return $common_words_array;
}
function get_all_news($datenews,$classification,$country,$idn)
{
global $DATABASE;
$country = unserialize($country);
$cdate = time();
$date = mktime_to_mysqltime($datenews);
$yy = substr($date,0,4);
$mm = substr($date,4,2);
$dd = substr($date,6,2);
$todate = mktime(00,00,00,$mm,$dd+1,$yy);
$fromdate = mysqltime_to_mktime($date);
if(!is_array($country))
{
$country1=$country;
$country=array();
$country[0]=$country1;
}
//getting countrywise news
$sql="Select id, header, country, classification from ynfx_mis_news WHERE visibility='1' AND status = 'a' AND date_display_from < '$cdate' AND date_display_to >'$cdate' and id!='$idn' order by date_news desc";
$result = mysql_db_query($DATABASE, $sql);
if(mysql_error()) error("Unexpected Error !!");
if(mysql_num_rows($result))
{
$ct=0;
$news.=" ";
while($row=mysql_fetch_row($result))
{
if($ct==5) break;
$id=$row[0];
$header=stripslashes($row[1]);
$country_n=unserialize($row[2]);
$section=stripslashes($row[3]);
if(trim($searchSTR))
{
$cnt = count($search_arr);
for($s=0;$s<$cnt;$s++)
{
$pat = $search_arr[$s];
$newpat = "\\0";
$body = eregi_replace($pat,"$newpat",$body);
$header = eregi_replace($pat,"$newpat",$header);
}
}
$show=0;
if($country)
{
if(is_array($country_n))
{
if(count(array_intersect($country,$country_n))) $show=1;
}
}//end of if
if($show)
{
$news.="$header
";
$ct++;
}//end of if
}//end of while
$news.=" | ";
}//end of if
//getting categorywise news
$sql="Select id, header, country, classification from ynfx_mis_news WHERE visibility = '1' AND status = 'a' AND date_display_from < '$cdate' AND date_display_to >'$cdate' and classification = '$classification' and id!='$idn' order by date_news desc limit 5";
$result = mysql_db_query($DATABASE, $sql);
if(mysql_error()) error("Unexpected Error !!");
if(mysql_num_rows($result))
{
$news.=" ";
while($row=mysql_fetch_row($result))
{
$id=$row[0];
$header=stripslashes($row[1]);
$country_n=unserialize($row[2]);
$section=stripslashes($row[3]);
$news.="$header
";
}//end of while
$news.=" | ";
}//end of if
//getting datewise news
$sql="Select id, header, country, classification from ynfx_mis_news WHERE visibility = '1' AND status = 'a' AND date_display_from < '$cdate' AND date_display_to >'$cdate' and date_news between $fromdate and $todate and id!='$idn' order by date_news desc limit 5";
$result = mysql_db_query($DATABASE, $sql);
if(mysql_error()) error("Unexpected Error !!");
if(mysql_num_rows($result))
{
$news.="";
while($row=mysql_fetch_row($result))
{
$id=$row[0];
$header=stripslashes($row[1]);
$country_n=unserialize($row[2]);
$section=stripslashes($row[3]);
$news.="$header
";
//$news.="$header
";
}//end of while
$news.=" | ";
}//end of if
return($news);
}
/*
function get_all_news($datenews,$classification,$country)
{
global $DATABASE;
$country=unserialize($country);
$cdate=time();
$date=mktime_to_mysqltime($datenews);
$yy=substr($date,0,4);
$mm=substr($date,4,2);
$dd=substr($date,6,2);
$todate=mktime(00,00,00,$mm,$dd+1,$yy);
$fromdate=mysqltime_to_mktime($date);
//getting countrywise news
$sql="Select id, header, country from ynfx_mis_news WHERE visibility='1' AND status ='a' AND date_display_from < '$cdate' AND date_display_to >'$cdate' order by date_news desc";
$result = mysql_db_query($DATABASE, $sql);
if(mysql_error()) error("Unexpected Error !!");
if(mysql_num_rows($result))
{
$ct=0;
$news.=" ";
while($row=mysql_fetch_row($result))
{
if($ct==5) break;
$id=$row[0];
$header=stripslashes($row[1]);
$country_n=unserialize($row[2]);
if(trim($searchSTR))
{
$cnt = count($search_arr);
for($s=0;$s<$cnt;$s++)
{
$pat = $search_arr[$s];
$newpat = "\\0";
$body = eregi_replace($pat,"$newpat",$body);
$header = eregi_replace($pat,"$newpat",$header);
}
}
$show=0;
if($country)
{
if(is_array($country_n))
{
if(count(array_intersect($country,$country_n))) $show=1;
}
}//end of if
if($show)
{
$news.="$header
";
$ct++;
}//end of if
}//end of while
$news.=" | ";
}//end of if
//getting categorywise news
$sql="Select id, header, country from ynfx_mis_news WHERE visibility='1' AND status ='a' AND date_display_from < '$cdate' AND date_display_to >'$cdate' and classification='$classification' order by date_news desc limit 5";
$result = mysql_db_query($DATABASE, $sql);
if(mysql_error()) error("Unexpected Error !!");
if(mysql_num_rows($result))
{
$news.=" ";
while($row=mysql_fetch_row($result))
{
$id=$row[0];
$header=stripslashes($row[1]);
$country_n=unserialize($row[2]);
$news.="$header
";
}//end of while
$news.=" | ";
}//end of if
//getting datewise news
$sql="Select id, header, country from ynfx_mis_news WHERE visibility='1' AND status ='a' AND date_display_from < '$cdate' AND date_display_to >'$cdate' and date_news between $fromdate and $todate order by date_news desc limit 5";
$result = mysql_db_query($DATABASE, $sql);
if(mysql_error()) error("Unexpected Error !!");
if(mysql_num_rows($result))
{
$news.="";
while($row=mysql_fetch_row($result))
{
$id=$row[0];
$header=stripslashes($row[1]);
$country_n=unserialize($row[2]);
$news.="$header
";
}//end of while
$news.=" | ";
}//end of if
return($news);
}
*/
function is_service_taken($login,$service)
{
global $DATABASE;
$date=substr(mktime_to_mysqltime(time()),0,8);
$query="Select * from serviceaccess where login='$login' and expdate>$date and status='Paid' and serviceid='$service'";
$result=mysql_db_query($DATABASE,$query);
return (mysql_num_rows($result));
}
function get_events()
{
global $DATABASE;
$sql = "";
if(!$month) $month = date("Ym", time());
if($month!="null")
$sql .= " AND (substring(startdate,1,6)=$month OR substring(enddate,1,6)=$month)";
if($sql) $sql = "WHERE ".substr($sql,4). " ORDER BY startdate";
else $sql = "ORDER BY startdate LIMIT 20";
$sqlfinal = "SELECT * FROM industryevent $sql";
$result=mysql_db_query($DATABASE, $sqlfinal);
if(mysql_error()) error("Unexpected Error");
$count=mysql_num_rows($result);
//bgcolor="#003998"
if($count)
{
$table.='| Current Events |
';
while($row=mysql_fetch_row($result))
{
$title = h_(strtoupper(stripslashes($row[3])));
$table .= ' | '. $title.' | ';
}
$table.=" |
|
|
";
}
return($table);
}
/*
function get_events()
{
global $DATABASE;
$sql = "";
if(!$month) $month = date("Ym", time());
if($month!="null")
$sql .= " AND (substring(startdate,1,6)=$month OR substring(enddate,1,6)=$month)";
if($sql) $sql = "WHERE ".substr($sql,4). " ORDER BY startdate";
else $sql = "ORDER BY startdate LIMIT 20";
$sqlfinal = "SELECT * FROM industryevent $sql";
$result=mysql_db_query($DATABASE, $sqlfinal);
if(mysql_error()) error("Unexpected Error");
$count=mysql_num_rows($result);
//bgcolor="#003998"
if($count)
{
$table.='| Current Events |
';
while($row=mysql_fetch_row($result))
{
$title = h_(strtoupper(stripslashes($row[3])));
$table .= ' | '. $title.' | ';
}
$table.=" |
|
|
";
}
return($table);
}
*/
function get_whois_online()
{
global $DATABASE,$tbl_logindata,$tbl_usermast;
global $std_text_font_date;
global $std_title_font;
global $nav_font_big ;
global $tbl_mis_news;
global $std_text_font;
global $std_text_font,$std_font_date;
$std_newsheader_font = "";
$std_text_font="";
$time=time();
$time=mktime_to_mysqltime($time);
$i=0;
$flag="n";
$time1=time();
$time2=$time1-86400;
$time2=mktime_to_mysqltime($time2);
$array_demo=array();
for($j=0;$j<7;$j++)
{
if($j!=0) $array_demo[$j]="demo$j";
else $array_demo[$j]="demo";
}
$array_demo[$j]="demoynfx";
$sql="select memberlogin from logindata where logindate>$time2 order by logindate desc";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error".mysql_error());
while($row=mysql_fetch_row($result))
{
$login2=stripslashes($row[0]);
if($i==5)
break;
if(!in_array($login2,$array_demo))
{
if($i==0)
{
$arr[$i]=$login2;
$i++;
}
if($i!=0)//means not the first time
{
for($j=0;$j<=$i;$j++)
{
$login1=$arr[$j];
if($login2==$login1)//means it is present in the array
{
$flag="p";
}//end of if($login)
}//end of for
if($flag=="n")//means not present
{
$arr[$i]=$login2;
$i++;
}
$flag="n";
}//end of if
}//end of if(in_array)
}//end of while
for($i=0;$i<=4;$i++)
{
$sqld="select companyname, plan, id from member where login='$arr[$i]'";
$resultd=mysql_db_query($DATABASE,$sqld);
//if($i%2==0) $bgcolor="#FFF7E0";
//else $bgcolor="";
$bgcolor="#FFFFFF";
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($resultd))
{
$companyname=mysql_result($resultd,0,0);
$plan1=mysql_result($resultd,0,1);
$id=mysql_result($resultd,0,2);
}
if($plan!="free")//means he is a preferred member
{
if($plan1=="free")
{
$t.="";
$t.=" | ";
$t.="$std_text_font $companyname | ";
$t.="
";
}
else
{
$t.="";
$t.=" | ";
$t.=" $std_text_font $companyname | ";
$t.="
";
}
}
else//means he is a free member.he can only see pref members links
{
if($plan1!="free")
{
//means the person online is pref show him
$t.="";
$t.=" | ";
$t.="$std_text_font $companyname | ";
$t.="
";
}
else
{
$t.="";
$t.="| $std_text_font $companyname | ";
$t.="
";
}
}
}
$t.="| $std_text_font see all |
";
return($t);
}//end of function
/*
function get_whois_online()
{
global $DATABASE,$tbl_logindata,$tbl_usermast;
global $std_text_font_date;
global $std_title_font;
global $nav_font_big ;
global $tbl_mis_news;
global $std_text_font;
global $std_text_font,$std_font_date;
$std_newsheader_font = "";
$std_text_font="";
$time=time();
$time=mktime_to_mysqltime($time);
$i=0;
$flag="n";
$time1=time();
$time2=$time1-86400;
$time2=mktime_to_mysqltime($time2);
$array_demo=array();
for($j=0;$j<7;$j++)
{
if($j!=0) $array_demo[$j]="demo$j";
else $array_demo[$j]="demo";
}
$array_demo[$j]="demoynfx";
$sql="select memberlogin from logindata where logindate>$time2 order by logindate desc";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error".mysql_error());
while($row=mysql_fetch_row($result))
{
$login2=stripslashes($row[0]);
if($i==5)
break;
if(!in_array($login2,$array_demo))
{
if($i==0)
{
$arr[$i]=$login2;
$i++;
}
if($i!=0)//means not the first time
{
for($j=0;$j<=$i;$j++)
{
$login1=$arr[$j];
if($login2==$login1)//means it is present in the array
{
$flag="p";
}//end of if($login)
}//end of for
if($flag=="n")//means not present
{
$arr[$i]=$login2;
$i++;
}
$flag="n";
}//end of if
}//end of if(in_array)
}//end of while
for($i=0;$i<=4;$i++)
{
$sqld="select companyname, plan, id from member where login='$arr[$i]'";
$resultd=mysql_db_query($DATABASE,$sqld);
if($i%2==0) $bgcolor="#FFF7E0";
else $bgcolor="";
if(mysql_error()) error("Unexpected Error".mysql_error());
if(mysql_num_rows($resultd))
{
$companyname=mysql_result($resultd,0,0);
$plan1=mysql_result($resultd,0,1);
$id=mysql_result($resultd,0,2);
}
/*
if($plan!="free")//means he is a preferred member
{
if($plan1=="free") $t.="| $std_text_font $companyname |
";
else $t.="| $std_text_font $companyname |
";
}
else//means he is a free member.he can only see pref members links
{
*/
/*
if($plan1!="free")
{
//means the person online is pref show him
$t.="| $std_text_font $companyname |
";
}
else $t.="| $std_text_font $companyname |
";
/*
}
*/
/*
}
$t.="| $std_text_font see all |
";
return($t);
}//end of function
*/
function get_news_right($datenews,$country)
{
global $DATABASE;
$country=unserialize($country);
$cdate=time();
$date=mktime_to_mysqltime($datenews);
$yy=substr($date,0,4);
$mm=substr($date,4,2);
$dd=substr($date,6,2);
$todate=mktime(00,00,00,$mm,$dd+1,$yy);
$fromdate=mysqltime_to_mktime($date);
//industry news
$sql="select id from ynfx_mis_classification where section='IN'";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error");
if(mysql_num_rows($result))
{
$i=0;
while($row=mysql_fetch_row($result))
{
$array[$i]=$row[0];
$i++;
}
$string=implode(",",$array);
$sql="Select id, header, country, date_news, classification from ynfx_mis_news WHERE visibility = '1' AND status = 'a' AND date_display_from < '$cdate' AND date_display_to >'$cdate' and classification in($string) order by date_news desc";
$result = mysql_db_query($DATABASE, $sql);
if(mysql_error()) error("Unexpected Error !!");
if(mysql_num_rows($result))
{
$ct=0;
while($row=mysql_fetch_row($result))
{
if($ct==3) break;
$id=$row[0];
$header=stripslashes($row[1]);
$country_n=unserialize($row[2]);
$date_n=$row[3];
$cid=$row[4];
$show=0;
if($country)
{
if(is_array($country_n))
{
if(count(array_intersect($country,$country_n))) $show=1;
}
}//end of if
if($datenews)
{
if(($date_n>$fromdate)&&($date_n<$todate)) $show=1;
}
if($show)
{
$news.="- $header
";
$ct++;
}//end of if
}//end of while
}//end of if
}//end of if mysql_num_rows
//industry report
$sql="select id from ynfx_mis_classification where section='IR'";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error");
if(mysql_num_rows($result))
{
$i=0;
while($row=mysql_fetch_row($result))
{
$array[$i]=$row[0];
$i++;
}
$string=implode(",",$array);
$sql="Select id, header, country, date_news, classification from ynfx_mis_news WHERE visibility = '1' AND status = 'a' AND date_display_from < '$cdate' AND date_display_to >'$cdate' and classification in($string) order by date_news desc";
$result = mysql_db_query($DATABASE, $sql);
if(mysql_error()) error("Unexpected Error !!");
if(mysql_num_rows($result))
{
$ct=0;
$news.=" ";
while($row=mysql_fetch_row($result))
{
if($ct==3) break;
$id=$row[0];
$header=stripslashes($row[1]);
$country_n=unserialize($row[2]);
$date_n=$row[3];
$cid=$row[4];
$show=0;
if($country)
{
if(count(array_intersect($country,$country_n))) $show=1;
}//end of if
if($datenews)
{
if(($date_n>$fromdate)&&($date_n<$todate)) $show=1;
}
if($show)
{
$news.="- $header
";
$ct++;
}//end of if
}//end of while
}//end of if
}//end of if mysql_num_rows
//industry stats
$sql="select id from ynfx_mis_classification where section='IS'";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error("Unexpected Error");
if(mysql_num_rows($result))
{
$i=0;
while($row=mysql_fetch_row($result))
{
$array[$i]=$row[0];$i++;
}
$string=implode(",",$array);
$sql="Select id, header, country, date_news, classification from ynfx_mis_news WHERE visibility = '1' AND status = 'a' AND date_display_from < '$cdate' AND date_display_to >'$cdate' and classification in($string) order by date_news desc";
$result = mysql_db_query($DATABASE, $sql);
if(mysql_error()) error("Unexpected Error !!");
if(mysql_num_rows($result))
{
$ct=0;
$news.=" ";
while($row=mysql_fetch_row($result))
{
if($ct==3) break;
$id=$row[0];
$header=stripslashes($row[1]);
$country_n=unserialize($row[2]);
$date_n=$row[3];
$cid=$row[4];
$show=0;
if($country)
{
if(count(array_intersect($country,$country_n))) $show=1;
}//end of if
if($datenews)
{
if(($date_n>$fromdate)&&($date_n<$todate)) $show=1;
}
if($show)
{
$news.="- - $header
";
$ct++;
}//end of if
}//end of while
}//end of if
}//end of if mysql_num_rows
return($news);
}
function trapuser($login,$page)
{
global $DATABASE;
$date=mktime_to_mysqltime(time());
$sql="insert into user_visit values(null,'$login','$page','$date')";
$result=mysql_db_query($DATABASE,$sql);
if(mysql_error()) error(mysql_error());
}
?> | |