First half of my funtions code
b_img);
$tmp_count=count($tmp);
$ext=strtolower($tmp[$tmp_count-1]);
if($ext=="swf") {
$img_s="
";
} else $img_s="".$img_s." ";
$dis_id[]=$row->b_id;
}
$tak=rand(0,$num);
$sql_query="select * from banners where b_id='$dis_id[$tak]'";
$num=sql_execute($sql_query,'num');
if($num!=0) {
$bann=sql_execute($sql_query,'get');
$d_f=date("d",$bann->b_f_day);
$m_f=date("m",$bann->b_f_day);
$y_f=date("Y",$bann->b_f_day);
$d_t=date("d",$bann->b_t_day);
$m_t=date("m",$bann->b_t_day);
$y_t=date("Y",$bann->b_t_day);
// $f_day=mktime(0,0,0,$m_f,$d_f,$y_f);
// $t_day=mktime(0,0,0,$m_t,$d_t,$y_t);
$f_day=mktime(0,0,0,$m_f,$d_f,$y_f);
$t_day=mktime(0,0,0,$m_t,$d_t,$y_t);
$today=mktime(0,0,0,date("m"),date("d"),date("Y"));
if(($bann->b_dur=="D") and ($today>$t_day)) {
delete_banner($dis_id[$tak]);
}
elseif($bann->b_dur=="C" and ($bann->b_ncl<=$bann->b_clks)) {
delete_banner($dis_id[$tak]);
}
elseif($bann->b_dur=="I" and ($bann->b_noi<=$bann->b_see)) {
delete_banner($dis_id[$tak]);
}
echo $dis[$tak];
for($i=0; $i<=$ip_co; $i++) {
mysql_query("update banners set b_see=b_see+1 where b_id='$dis_id[$tak]'");
}
}
}
}
function f_banners() {
global $cookie_url,$main_url;
$sql="select * from banners where b_blk='N' and b_typ='F' and b_exp='N'";
$res=mysql_query($sql);
$dis=array();
$dis_id=array();
$num=mysql_num_rows($res);
if(mysql_num_rows($res)) {
while($row=mysql_fetch_object($res)) {
$tmp=explode(".",$row->b_img);
$tmp_count=count($tmp);
$ext=strtolower($tmp[$tmp_count-1]);
if($ext=="swf") {
$img_s="
";
} else $img_s="".$img_s." ";
$dis_id[]=$row->b_id;
}
$tak=rand(0,$num);
$sql_query="select * from banners where b_id='$dis_id[$tak]'";
$num=sql_execute($sql_query,'num');
if($num!=0) {
$bann=sql_execute($sql_query,'get');
$d_f=date("d",$bann->b_f_day);
$m_f=date("m",$bann->b_f_day);
$y_f=date("Y",$bann->b_f_day);
$d_t=date("d",$bann->b_t_day);
$m_t=date("m",$bann->b_t_day);
$y_t=date("Y",$bann->b_t_day);
// $f_day=mktime(0,0,0,$m_f,$d_f,$y_f);
// $t_day=mktime(0,0,0,$m_t,$d_t,$y_t);
// $today=mktime(0,0,0,date("m"),date("d"),date("Y"));
$f_day=mktime(0,0,0,$m_f,$d_f,$y_f);
$t_day=mktime(0,0,0,$m_t,$d_t,$y_t);
$today=mktime(0,0,0,date("m"),date("d"),date("Y"));
if(($bann->b_dur=="D") and ($today>$t_day)) {
delete_banner($dis_id[$tak]);
}
elseif($bann->b_dur=="C" and ($bann->b_ncl<=$bann->b_clks)) {
delete_banner($dis_id[$tak]);
}
elseif($bann->b_dur=="I" and ($bann->b_noi<=$bann->b_see)) {
delete_banner($dis_id[$tak]);
}
echo $dis[$tak];
for($i=0; $i<=$ip_co; $i++) {
mysql_query("update banners set b_see=b_see+1 where b_id='$dis_id[$tak]'");
}
}
}
}
function mailing($to,$name,$from,$subj,$body) {
global $SERVER_NAME,$admin_mail;
$subj=nl2br($subj);
$body=nl2br($body);
$recipient = $to;
$headers = "From: $name <$from>\n";
$headers .= "MIME-Version: 1.0\n";
$headers .= "Return-Path: <$admin_mail>\n";
$headers .= "Content-Type: text/html;\n";
$headers .= "X-Mailer: PHP/" . phpversion();
ini_set("sendmail_from", $from);
mail("$recipient","$subj","$body","$headers","-r $from");
}
function form_get($value){
global $HTTP_POST_VARS,$HTTP_GET_VARS,$_SERVER;
$REQUEST_METHOD=$_SERVER["REQUEST_METHOD"];
if($REQUEST_METHOD=='POST')
$get_value=$HTTP_POST_VARS["$value"];
elseif($REQUEST_METHOD=='GET')
$get_value=$HTTP_GET_VARS["$value"];
return addslashes_deep($get_value);
}
function addslashes_deep($value) {
$value = is_array($value) ?
array_map('addslashes_deep', $value) :
addslashes($value);
return $value;
}
function cookie_get($name){
global $HTTP_COOKIE_VARS;
return $HTTP_COOKIE_VARS[$name];
}
//require file, depending on mode
function check($mode){
global $cookie_url,$main_url;
$modules=array("article","blog_url","blogs","calendar","chkuser","events","forums","help","im","iml","imv","join","listing","login","main","messages", "paypal","paystat","people_card","photo_album","privacy","profile","rank","recent_view","search","terms","tour","tribe","update_paypal","user","forgot ","tacs","widgets");
if(isset($mode))
if(in_array($mode,$modules))
$document=$mode.".php";
else
$document="main.php";
else
$document="main.php";
require("$document");
}
//require admin file, depending on mode
function ad_check($mode){
if(isset($mode)){
$document=$mode.".php";
}
else{
$document="main.php";
}
require("admin/$document");
}
//require calendar file, depending on mode
function cal_check($mode){
if(isset($mode)){
$document=$mode.".php";
}
else{
$document="calendar.php";
}
require("calendar/$document");
}
//printing java code for listing categories
function listing_cats_java($mod){
$sql_query="select * from categories";
$res=sql_execute($sql_query,'res');
while($cat=mysql_fetch_object($res)){
if($mod==1){
echo ";
listCategory.setDefaultOption('$cat->cat_id','$cat->cat_id');
listCategory.addOptions('$cat->cat_id','Select Subcategory','$cat->cat_id'";
}
elseif($mod==2){
$nex=$cat->cat_id+1;
echo "
listmessage_categoryId.setDefaultOption('$cat->cat_id','$nex');
listmessage_categoryId.addOptions('$cat->cat_id'";
}
$sql_query="select * from sub_categories where cat_id='$cat->cat_id'";
$res2=sql_execute($sql_query,'res');
while($sub=mysql_fetch_object($res2)){
echo ",'$sub->name','$sub->sub_cat_id'";
}//while
echo ");";
}//while
}//function
// Returnds the curent page number on a multipage display
function getpage(){
if(!isset($_GET['page'])) $page=1;
else $page=$_GET['page'];
return $page;
}
function getpages(){
if(!isset($_GET['page'])) $page=1;
else $page=$_GET['page'];
return $page;
}
//Displays the page numbers
function show_page_nos($sql,$url,$lines,$page){
$tmp =explode("LIMIT",$sql);
if(count($tmp)<1) $tmp =explode("limit",$sql);
$pgsql =$tmp[0];
include 'show_pagenos.php';
}
//Formats The Date
function format_date($date,$time=0){
$tmp =explode(" ",$date);
$date2 =explode("-",$tmp[0]);
$date =$date2[1]."-".$date2[2]."-".$date2[0];
if($time) return $date." ".$tmp[1];
else return $date;
}
//just printing listing cats list
function listing_cats($sel){
$sql_query="select * from categories";
$res=sql_execute($sql_query,'res');
while($cat=mysql_fetch_object($res)){
if($cat->cat_id=="$sel"){
echo "$cat->name";
}
else{
echo " $cat->name";
}
}//while
}//function
//just printing events cats list
function events_cats($sel){
$sql_query="select * from event_cat";
$res=sql_execute($sql_query,'res');
while($cat=mysql_fetch_object($res)){
if($cat->cat_id=="$sel"){
echo " ".stripslashes($cat->event_nam)." ";
}
else{
echo "".stripslashes($cat->event_nam)." ";
}
}//while
}//function
//admin header
function show_ad_header($adsess){
$mode=form_get("mode");
$act=form_get("act");
?>
Site Administration
<?=$site_name?>
error;
$detailes_line=$err->detailes;
show_header();
require('error.php');
show_footer();
exit();
}
//complete pages
function complete_screen($comid){
$sql_query="select * from complete where cmp_id='$comid'";
$cmp=sql_execute($sql_query,'get');
$header_line=$cmp->complete;
$detailes_line=$cmp->detailes;
show_header();
require('complete.php');
show_footer();
exit();
}
//checkin user login info
function login_test($mem_id,$mem_pass){
global $conf;
$sql_query="select password,ban,mem_acc,amount,deducted from members where mem_id='$mem_id' and mem_id>0";
$num=sql_execute($sql_query,'num');
$mem=sql_execute($sql_query,'get');
//if password incorrect
$adsess=form_get("adsess");
if($adsess!="")
admin_test($adsess);
else {
$mode=form_get("mode");
$act=form_get("act");
$pack = sql_execute("SELECT package_amt,onetime,period,vphoto FROM member_package WHERE package_id='".$mem->mem_acc."'","get");
if(($num==0)||($mem_pass!=$mem->password)){
error_screen(0);
}
//if user banned
elseif($mem->ban=='y'){
error_screen(12);
}
if(!$pack->onetime && $pack->package_amt>0){
if((time()-$mem->deducted)>($pack->period*86400))
if($mem->amount>$pack->package_amt)
deduct($mem_id);
elseif(($mode!="user" && $act!="profile")&&($mode!="login" && $act!="home"))
error_screen(37);
}
$mem=sql_execute($sql_query,'get');
if(($mode!="user" && $act!="profile")&&($mode!="login" && $act!="home")&&($pack->package_amt>0))
if($mem->amount<$conf['min_balance'])
error_screen(39);
if($mode=="photo_album" && $pack->vphoto=='0')
error_screen(40);
//updating db (setting user in online mode)
$now=time();
$was=$now-60*20;
$sql_query="update members set current='$now' where mem_id='$mem_id'";
sql_execute($sql_query,'');
$sql_query="update members set online='off' where current < $was";
sql_execute($sql_query,'');
}
}
//checkin admin session key
function admin_test($session){
$time=time();
$interval=$time-3600*24;
$sql_query="delete from admin where started < $interval";
@sql_execute($sql_query,'');
$sql_query="select * from admin where sess_id='$session'";
$num=@sql_execute($sql_query,'num');
if($num==0)
error_screen(24);
}
//sending messages, depending on message id
function messages($to,$mid,$data){
global $system_mail,$site_name;
if($mid==7){
$subject=$data[0];
$body=$data[1];
$name=$data[2];
$from_mail=$data[3];
}//if
else{
$sql_query="select * from messages where mes_id='$mid'";
$mes=sql_execute($sql_query,'get');
$subject=$mes->subject;
$body=$mes->body;
//replacing templates
$body=ereg_replace("\|email\|","$data[0]",$body);
$body=ereg_replace("\|password\|","$data[1]",$body);
$body=ereg_replace("\|link\|","$data",$body);
$body=ereg_replace("\|subject\|","$data[0]",$body);
$body=ereg_replace("\|message\|","$data[1]",$body);
$body=ereg_replace("\|user\|","$data[0]",$body);
$subject=ereg_replace("\|email\|","$data[0]",$subject);
$subject=ereg_replace("\|password\|","$data[1]",$subject);
$subject=ereg_replace("\|link\|","$data",$subject);
$subject=ereg_replace("\|subject\|","$data[0]",$subject);
$subject=ereg_replace("\|message\|","$data[1]",$subject);
$subject=ereg_replace("\|user\|","$data[0]",$subject);
$name=$site_name;
$from_mail=$system_mail;
}//else
$subject=stripslashes($subject);
$body=stripslashes($body);
$sql_query="select notifications from members where email='$to'";
$num=sql_execute($sql_query,'num');
if($num>0){
$mem=sql_execute($sql_query,'get');
if($mem->notifications=='1'){
$stat=1;
}
else {
$stat=0;
}
}
else {
$stat=1;
}
if(($stat==1)||($mid<4)){
mailing($to,$name,$from_mail,$subject,$body);
}
}
//deleting empty values of array
function if_empty($data){
$flag=0;
if($data==''){
return '';
}//if
else{
$result=array();
$i=0;
foreach($data as $val){
if((isset($val))&($i!=0)&($val!="")){
//if(!$val){
$flag=1;
array_push($result,$val);
}//if
$i++;
}//foreach
if($flag==0){
return '';
}//elseif
else {
return $result;
}//else
}//else
}//function
function if_empty1($data){
$flag=0;
if($data==''){
return '';
}//if
else{
$result=array();
$i=0;
foreach($data as $val){
if($val){
//if(!$val){
$flag=1;
array_push($result,$val);
}//if
$i++;
}//foreach
if($flag==0){
return '';
}//elseif
else {
return $result;
}//else
}//else
}//function
//showing country drop-down list
function country_drop(){
?>
Any
United States
Afghanistan
Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Antartica
Antigua and Barbuda
Argentina
Armenia
Aruba
Ascension Island
Australia
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bermuda
Bhutan
Bolivia
Botswana
Bouvet Island
Brazil
Brunei Darussalam
Bulgaria
Burkina Faso
Burundi
Cambodia
Cameroon
Canada
Cape Verde Islands
Cayman Islands
Chad
Chile
China
Christmas Island
Colombia
Comoros
Congo, Republic of
Cook Islands
Costa Rica
Cote d'Ivoire
Croatia/Hrvatska
Cyprus
Czech Republic
Denmark
Djibouti
Dominica
Dominican Republic
East Timor
Ecuador
Egypt
El Salvador
Equatorial Guinea
Eritrea
Estonia
Ethiopia
Falkland Islands
Faroe Islands
Fiji
Finland
France
French Guiana
French Polynesia
Gabon
Gambia
Georgia
Germany
Ghana
Gibraltar
Greece
Greenland
Grenada
Guadeloupe
Guam
Guatemala
Guernsey
Guinea
Guinea-Bissau
Guyana
Haiti
Honduras
Hong Kong
Hungary
Iceland
India
Indonesia
Iran
Ireland
Isle of Man
Israel
Italy
Jamaica
Japan
Jersey
Jordan
Kazakhstan
Kenya
Kiribati
Korea, Republic of
Kuwait
Kyrgyzstan
Laos
Latvia
Lebanon
Lesotho
Liberia
Libya
Liechtenstein
Lithuania
Luxembourg
Macau
Macedonia
Madagascar
Malawi
Malaysia
Maldives
Mali
Malta
Marshall Islands
Martinique
Mauritania
Mauritius
Mayotte Island
Mexico
Micronesia
Moldova
Monaco
Mongolia
Montserrat
Morocco
Mozambique
Myanmar
Namibia
Nauru
Nepal
Netherlands
Netherlands Antilles
New Caledonia
New Zealand
Nicaragua
Niger
Nigeria
Niue
Norfolk Island
Norway
Oman
Pakistan
Palau
Panama
Papua New Guinea
Paraguay
Peru
Philippines
Pitcairn Island
Poland
Portugal
Puerto Rico
Qatar
Reunion Island
Romania
Russian Federation
Rwanda
Saint Helena
Saint Lucia
San Marino
Saudi Arabia
Senegal
Seychelles
Sierra Leone
Singapore
Slovak Republic
Slovenia
Solomon Islands
Somalia
South Africa
South Georgia
Spain
Sri Lanka
Suriname
Svalbard
Swaziland
Sweden
Switzerland
Syria
Taiwan
Tajikistan
Tanzania
Thailand
Togo
Tokelau
Tonga Islands
Tunisia
Turkey
Turkmenistan
Tuvalu
Uganda
Ukraine
United Kingdom
Uruguay
Uzbekistan
Vanuatu
Vatican City
Venezuela
Vietnam
Western Sahara
Western Samoa
Yemen
Yugoslavia
Zambia
Zimbabwe
$i\n";
}
else {
echo "$i\n";
}
}
}
//months drop-down list
function month_drop($sel){
$month=array(1=>"Jan",2=>"Feb",3=>"Mar",4=>"Apr",5=>"May",6=>"Jun",
7=>"Jul",8=>"Aug",9=>"Sep",10=>"Oct",11=>"Nov",12=>"Dec");
for($i=1;$i<=12;$i++){
if($i==$sel){
echo " $month[$i]\n";
}
else {
echo " $month[$i]\n";
}
}
}
//years drop-down list
function year_drop($sel){
if($sel=='now'){
$year=2010;
$start=date("Y");
for($i=$start;$i<=$year;$i++){
echo " $i\n";
}//for
}//if
else{
$year=date("Y");
for($i=1900;$i<=$year;$i++){
if($i==$sel){
echo " $i\n";
}
else {
echo " $i\n";
}
}
}//else
}
//showing if user is online,offline or anonymous
function show_online($m_id){
$sql_query="select fname,lname,online from members where mem_id='$m_id'";
$mem=sql_execute($sql_query,'get');
if($mem->online=='on'){
echo "$mem->fname $mem->fname $mem->fname ".stripslashes($tip->tip_header)." ".stripslashes($tip->tip);
}
//creating array of lister friends
function lister_degree($mem_id,$deg){
$result=array();
for($i=$deg;$i>=1;$i--){
$network=count_network($mem_id,"$i","ar");
$result=array_merge($result,$network);
}
//$result=if_empty($result);
if($result==''){
$result[]='';
}
return $result;
}//function
//showing listings, depending on mode
function show_listings($mode,$m_id,$page){
$now=time();
$sql_query="delete from listings where added+live<$now";
sql_execute($sql_query,'');
if($mode!='tribe'){
//setting ignore list
$sql_query="select ignore_list from members where mem_id='$m_id'";
$mem1=sql_execute($sql_query,'get');
$ignore=split("\|",$mem1->ignore_list);
$ignore=if_empty($ignore);
//setting filter
$sql_query="select filter,zip from members where mem_id='$m_id'";
$mem=sql_execute($sql_query,'get');
$items=split("\|",$mem->filter);
$distance=$items[0];
$zip=$items[1];
if($zip==''){
$zip=$mem->zip;
}
$degree=$items[2];
//applying distance filter
$zone=array();
if($distance=='any'){
$zonear='no result';
}else{
$zonear=inradius($zip,$distance);
}
if(($zonear=='not found')||($zonear=='no result')){
$sql_query="select lst_id from listings";
$res=sql_execute($sql_query,'res');
while($z=mysql_fetch_object($res)){
array_push($zone,$z->lst_id);
}
}
else {
$sql_query="select lst_id from listings where ";
foreach($zonear as $zp){
$sql_query.="zip='$zp' or ";
}
$sql_query=rtrim($sql_query,' or ');
$res=sql_execute($sql_query,'res');
while($z=mysql_fetch_object($res)){
array_push($zone,$z->lst_id);
}
}
//applying degree filter
$friends=array();
$filter=array();
if($degree=='any'){
$sql_query="select mem_id from members";
$res=sql_execute($sql_query,'res');
while($fr=mysql_fetch_object($res)){
array_push($friends,$fr->mem_id);
}
}
else {
for($i=$degree;$i>=1;$i--){
$friends=array_merge($friends,count_network($m_id,$i,"ar"));
}//for
}//else
$filter=$friends;
}//if
$zone=if_empty($zone);
$filter=if_empty($filter);
//recent listings
if($mode=='recent'){
if(($filter!='')&&($zone!=''))
{
$sql_query="select * from listings where (";
if($filter!=''){
foreach($filter as $id){
$sql_query.="mem_id='$id' or ";
}//foreach
$sql_query=rtrim($sql_query,' or ');
}//if
if($zone!=''){
$sql_query.=") and (";
foreach($zone as $zon){
$sql_query.="lst_id='$zon' or ";
}//foreach
$sql_query=rtrim($sql_query,' or ');
$sql_query.=")";
}//if
if($ignore!=''){
//deleting from sql-query ignored users
foreach($ignore as $ign){
$sql_query.=" and mem_id!='$ign'";
}//foreach
}//if
if($degree!='any'){
$sql_query.=" and anonim!='y'";
}//if
$sql_query.=" and stat='a' order by added desc";
$res=sql_execute($sql_query,'res');
if(mysql_num_rows($res)){
$i=0;
while($lst=mysql_fetch_object($res)){
if($lst->show_deg!='trb'){
if(($lst->show_deg!='any')&&($lst->mem_id!=$m_id)){
$lister_friends=lister_degree($lst->mem_id,$lst->show_deg);
}
else{
$lister_friends[]=$m_id;
}
//checkin if user is a friend of lister
if((in_array($m_id,$lister_friends))||($lst->anonim=='y')){
$date=date("m/d/Y",$lst->added);
$sql_query="select name from categories where cat_id='$lst->cat_id'";
$cat=sql_execute($sql_query,'get');
$sql_query="select name from sub_categories where sub_cat_id='$lst->sub_cat_id'";
$sub=sql_execute($sql_query,'get');
echo "";
echo "
";
if(($lst->privacy=='y')||($lst->anonim=='y')){
echo "
";
if($lst->anonim!='y'){
show_online($lst->mem_id);
}
else{
echo "anonymous
";
echo "
$date - $cat->name - $sub->name
".stripslashes($lst->descr_part)." more
";
if($lst->anonim!='y'){
connections($m_id,$lst->mem_id);
}
echo "
";
echo "
";
if($i==5){
break;
}
$i++;
}//if
}//while
}//if
}//else
}//if
}//if
//profile section listings from user and friends
elseif($mode=='inprofile'){
$friends=array();
$friends=count_network($m_id,"1","ar");
$sql_query="select * from listings where (mem_id='$m_id'";
if($friends!=''){
foreach($friends as $fr){
$sql_query.=" or mem_id='$fr'";
}//foreach
}//if
$sql_query.=") and stat='a' order by added";
$num=sql_execute($sql_query,'num');
if($num==0){
echo "No listings available
";
}//if
else {
$res=sql_execute($sql_query,'res');
while($lst=mysql_fetch_object($res)){
$date=date("m/d",$lst->added);
echo "$date ".stripslashes($lst->title)." ";
$c_name=get_cat_name($lst->cat_id);
echo " ($c_name ) - ";
show_online($lst->mem_id);
echo "";
}//while
}//else
}//elseif
//showing user's listings
elseif($mode=='my'){
$sql_query="select * from listings where mem_id='$m_id' and stat='a'";
$sql_query.=" order by added";
$num=sql_execute($sql_query,'num');
if($num==0){
echo "No listings available";
}//if
else {
$res=sql_execute($sql_query,'res');
while($lst=mysql_fetch_object($res)){
$date=date("m/d",$lst->added);
echo "$date ".stripslashes($lst->title)." ";
$c_name=get_cat_name($lst->cat_id);
echo " (
$c_name ) - ";show_online($lst->mem_id);
echo "";
}//while
}//else
}//elseif
//showing one category listings
elseif($mode=='cat'){
$cid=form_get('cat_id');
$start=($page-1)*20;
$sql_query="select * from listings where cat_id='$cid' and stat='a'";
$sql_query.=" order by added limit $start,20";
$num=sql_execute($sql_query,'num');
if($num==0){
echo "No listings available";
}//if
else {
$res=sql_execute($sql_query,'res');
while($lst=mysql_fetch_object($res)){
if($lst->show_deg!='trb'){
if(($lst->show_deg!='any')&&($lst->mem_id!=$m_id)){
$lister_friends=lister_degree($lst->mem_id,$lst->show_deg);
}
else{
$lister_friends[]=$m_id;
}
if((in_array($m_id,$lister_friends))||($lst->anonim=='y')){
$date=date("m/d",$lst->added);
echo "$date ".stripslashes($lst->title)." ";
if($lst->anonim!='y'){
show_online($lst->mem_id);echo " - ";
}
else{
echo "anonymous";
}
echo find_relations($m_id,$lst->mem_id);
echo "";
}//if
}//if
}//while
}//else
}//elseif
//showing one sub-category listings
elseif($mode=='sub_cat'){
$sid=form_get('sub_cat_id');
$start=($page-1)*20;
$sql_query="select * from listings where sub_cat_id='$sid' and stat='a'";
$sql_query.=" order by added limit $start,20";
$num=sql_execute($sql_query,'num');
if($num==0){
echo "No listings available";
}//if
else {
$res=sql_execute($sql_query,'res');
while($lst=mysql_fetch_object($res)){
if($lst->show_deg!='trb'){
if(($lst->show_deg!='any')&&($lst->mem_id!=$m_id)){
$lister_friends=lister_degree($lst->mem_id,$lst->show_deg);
}
else{
$lister_friends[]=$m_id;
}
if((in_array($m_id,$lister_friends))||($lst->anonim=='y')){
$date=date("m/d",$lst->added);
echo "$date ".stripslashes($lst->title)." ";
if($lst->anonim!='y'){
show_online($lst->mem_id);
}
else{
echo "anonymous";
}
echo " - ";echo find_relations($m_id,$lst->mem_id);
echo "";
}//if
}//if
}//while
}//else
}//elseif
//showing tribe listings
elseif($mode=='tribe'){
$sql_query="select * from listings where trb_id='$m_id' and stat='a'";
$sql_query.=" order by added";
$num=sql_execute($sql_query,'num');
if($num==0){
echo "No listings available";
}//if
else {
$res=sql_execute($sql_query,'res');
while($lst=mysql_fetch_object($res)){
$date=date("m/d",$lst->added);
echo "$date ".stripslashes($lst->title)." ";
$c_name=trim(get_cat_name($lst->cat_id));
echo " ($c_name ) - ";
show_online($lst->mem_id);
echo "";
}//while
}//else
}//elseif
}//function
//searching degree between 2 users
function find_relations($mem_id,$frd_id){
if($frd_id=='0'){
return '';
}
if($mem_id==$frd_id){
return 'You';
}//if
else {
$fr1=count_network($mem_id,"1","ar");
if(is_array($fr1)&&in_array($frd_id,$fr1)){
return "1°";
}//if
else {
$fr2=count_network($mem_id,"2","ar");
if(is_array($fr2)&&in_array($frd_id,$fr2)){
return "2°";
}//if
else {
$fr3=count_network($mem_id,"3","ar");
if(is_array($fr3)&&in_array($frd_id,$fr3)){
return "3°";
}//if
else {
$fr4=count_network($mem_id,"4","ar");
if(is_array($fr4)&&in_array($frd_id,$fr4)){
return "4°";
}//if
else{
return "(unrelated)";
}//else
}//else
}//else
}//else
}//else
}//function
//building a connection chain between 2 user's
function connections($mem_id,$frd_id){
//anonymous
if($frd_id=='0'){
echo '';
}
//1 user and 2 are the same
elseif($mem_id==$frd_id){
echo "You";
}//if
else {
$friend=array();
$friend=count_network($mem_id,"1","ar");
//1 degree
if (is_array($friend)&&in_array($frd_id,$friend)){
echo show_online($frd_id)."";
show_online($result[0]);echo "";
show_online($result[0]);echo "";
show_online($result[0]);echo "";
}//if
echo "";
echo "";
show_photo($frd);
echo "
";
show_online($frd);
echo "
No friends.
";
}//else
}//function
//showing pages line (if the output is too big, for ex. search results are split into several pages)
function pages_line($id,$type,$page,$limit){
//spliting friends list
if($type=='friends'){
$friends=count_network($id,"1","num");
if($friends!='0'){
if($friends%$limit==0){
$pages=$friends/$limit;
}//if
else {
$pages=(int)($friends/$limit)+1;
}//else
$first="";
$last=" ";
echo $first."1".$mid."<<".$last." ";
if($page!='1'){
echo $first.($page-1).$mid."<".$last;
}//if
echo " ";
for($i=1;$i<=$pages;$i++){
if($i==$page){
echo "";
}
echo $first.$i.$mid."$i".$last." ";
if($i==$page){
echo " ";
}
}//for
echo " ";
if($pages!=$page){
echo $first.($page+1).$mid.">".$last." ";
}//if
echo $first.$pages.$mid.">>".$last." ";
}//if
}//if
if($type=='friends2'){
$friends=count_network($id,"2","num");
if($friends!='0'){
if($friends%$limit==0){
$pages=$friends/$limit;
}//if
else {
$pages=(int)($friends/$limit)+1;
}//else
$first="";
$last=" ";
echo $first."1".$mid."<<".$last." ";
if($page!='1'){
echo $first.($page-1).$mid."<".$last;
}//if
echo " ";
for($i=1;$i<=$pages;$i++){
if($i==$page){
echo "";
}
echo $first.$i.$mid."$i".$last." ";
if($i==$page){
echo " ";
}
}//for
echo " ";
if($pages!=$page){
echo $first.($page+1).$mid.">".$last." ";
}//if
echo $first.$pages.$mid.">>".$last." ";
}//if
}//if
if($type=='friends3'){
$friends=count_network($id,"3","num");
if($friends!='0'){
if($friends%$limit==0){
$pages=$friends/$limit;
}//if
else {
$pages=(int)($friends/$limit)+1;
}//else
$first="";
$last=" ";
echo $first."1".$mid."<<".$last." ";
if($page!='1'){
echo $first.($page-1).$mid."<".$last;
}//if
echo " ";
for($i=1;$i<=$pages;$i++){
if($i==$page){
echo "";
}
echo $first.$i.$mid."$i".$last." ";
if($i==$page){
echo " ";
}
}//for
echo " ";
if($pages!=$page){
echo $first.($page+1).$mid.">".$last." ";
}//if
echo $first.$pages.$mid.">>".$last." ";
}//if
}//if
if($type=='friends4'){
$friends=count_network($id,"4","num");
if($friends!='0'){
if($friends%$limit==0){
$pages=$friends/$limit;
}//if
else {
$pages=(int)($friends/$limit)+1;
}//else
$first="";
$last=" ";
echo $first."1".$mid."<<".$last." ";
if($page!='1'){
echo $first.($page-1).$mid."<".$last;
}//if
echo " ";
for($i=1;$i<=$pages;$i++){
if($i==$page){
echo "";
}
echo $first.$i.$mid."$i".$last." ";
if($i==$page){
echo " ";
}
}//for
echo " ";
if($pages!=$page){
echo $first.($page+1).$mid.">".$last." ";
}//if
echo $first.$pages.$mid.">>".$last." ";
}//if
}//if
if($type=='friendsall'){
$friends=count_network($id,"all","num");
if($friends!='0'){
if($friends%$limit==0){
$pages=$friends/$limit;
}//if
else {
$pages=(int)($friends/$limit)+1;
}//else
$first="";
$last=" ";
echo $first."1".$mid."<<".$last." ";
if($page!='1'){
echo $first.($page-1).$mid."<".$last;
}//if
echo " ";
for($i=1;$i<=$pages;$i++){
if($i==$page){
echo "";
}
echo $first.$i.$mid."$i".$last." ";
if($i==$page){
echo " ";
}
}//for
echo " ";
if($pages!=$page){
echo $first.($page+1).$mid.">".$last." ";
}//if
echo $first.$pages.$mid.">>".$last." ";
}//if
}//if
//spliting members list
elseif($type=='members'){
$membs=tribe_members($id);
$members=count($membs);
if($members!='0'){
if($members%$limit==0)
$pages=$members/$limit;
else
$pages=(int)($members/$limit)+1;
$first="";
$last=" ";
echo $first."1".$mid."<<".$last." ";
if($page!='1'){
echo $first.($page-1).$mid."<".$last;
}//if
echo " ";
for($i=1;$i<=$pages;$i++){
if
Posted by rumrunner439 , 07-27-2008, 06:41 PM second half of my funtions now i have to figure out how to get the video_albums.php to work right now all im getting is a login screen with my video_albums.php
}//function
//showing number of new discussion board posts since last user's visit
function tribe_new_posts($mem_id,$trb_id){
$visit=cookie_get("$trb_id");
if($visit==''){
$visit=0;
}
$sql_query="select top_id from board where trb_id='$trb_id' and added>$visit";
$num=sql_execute($sql_query,'num');
if($num==0){
return "no new posts";
}//if
else {
return "$num new posts read ";
}//if
echo "";
echo "";
show_photo($frd);
echo "
";
show_online($frd);
echo "
No members.
";
}//else
}//function
//showing topics of tribe discussion board
function show_board($trb_id){
$sql_query="select * from board where trb_id='$trb_id'";
$res=sql_execute($sql_query,'res');
echo " Topic Author Replies Last Post ";
while($brd=mysql_fetch_object($res)){
$sql_query="select rep_id,added from replies where top_id='$brd->top_id' order by added desc";
$num=sql_execute($sql_query,'num');
$res2=sql_execute($sql_query,'res');
$one=mysql_fetch_object($res2);
if($one->added==''){
$one->added=$brd->added;
}
$last_post=date("m/d/Y",$one->added);
echo "".stripslashes($brd->topic)." ";
echo name_header($brd->mem_id,'');
echo " $num $last_post ";
}//while
}//function
//showing tribe events list
function show_events($trb_id){
$sql_query="select * from events where trb_id='$trb_id'";
$res=sql_execute($sql_query,'res');
while($evn=mysql_fetch_object($res)){
$date=date("m/d/Y",$evn->start_date);
echo "".stripslashes($evn->title)." $date";
$start_time=date("h:i A",$evn->start_time);
if($evn->start_time!='0'){
echo " @ $start_time ";
}
echo "";
}//while
}//function
function show_files($trb_id) {
$get=sql_execute("SELECT files FROM tribes WHERE trb_id='$trb_id'","get");
$files=split("\|",$get->files);
if($files!='') {
foreach($files as $f) {
echo "".$f." $name->name\n";
}
else {
echo " $name->name\n";
}
}//foreach
}//if
}//function
//returns tribe type
function tribe_type($trb_id,$mode){
$sql_query="select type from tribes where trb_id='$trb_id'";
$trb=sql_execute($sql_query,'get');
if($trb->type=='pub'){
$text="Public";
}
elseif($trb->type=='mod'){
$text="Moderated Membership";
}
elseif($trb->type=='priv'){
$text="Private";
}
if($mode=='output'){
return $text;
}
elseif($mode=='get'){
return $trb->type;
}
}//function
//showing join tribe link, if user is not a member
function join_tribe_link($mem_id,$trb_id){
$nn = sql_execute("SELECT mes_id FROM messages_system WHERE frm_id='$mem_id' AND type='trb_req' AND special = '$trb_id'","num");
if($nn)
return;
$sql_query="select members,deny from tribes where trb_id='$trb_id'";
$trb=sql_execute($sql_query,'get');
$deny=split("\|",$trb->deny);
if($deny=='')
$deny=array();
$flag2=0;
foreach($deny as $den){
if($den==$mem_id){
$flag2=1;
break;
}//if
}//foreach
$members=split("\|",$trb->members);
if($members=='')
$members=array();
$link="join $cat->name ";
}//function
//showing profile photo album link
function photo_album_link($mem_id){
$sql_query="select photo,updated from photo where mem_id='$mem_id'";
$ph=sql_execute($sql_query,'get');
$items=split("\|",$ph->photo);
$items=if_empty($items);
$items=array_unset($items,"no");
if($items==''){
$num=0;
}
else {
$num=count($items);
}
if($num!=0){
echo "$num photos in album ";
}
else {
echo "0 photos in album";
}
}
function number_photos($mem_id){
$sql_query="select photo,updated from photo where mem_id='$mem_id'";
$ph=sql_execute($sql_query,'get');
$items=split("\|",$ph->photo);
$items=if_empty($items);
$items=array_unset($items,"no");
$num=count($items);
echo $num - 1;
}
//showing member since value
function member_since($p_id){
$sql_query="select joined from members where mem_id='$p_id'";
$mem=sql_execute($sql_query,'get');
$since=date("m/d/Y",$mem->joined);
return $since;
}
//showing first name of user to another users if they are not realted
//and first with second name if they are friends
function name_header($p_id,$mem_id){
$sql_query="select fname,lname from members where mem_id='$p_id'";
$p=sql_execute($sql_query,'get');
$sql_query="select frd_id from network where mem_id='$p_id' and frd_id='$mem_id'";
$num=sql_execute($sql_query,'num');
if(($num==0)&&($mem_id!='ad')){
return "$p->fname";
}
else {
return "$p->fname $p->lname";
}
}
//showing different pages of profile
function show_profile($mem_id,$type){
$sql_query="select * from profiles where mem_id='$mem_id'";
$pro=sql_execute($sql_query,'get');
$sql_query="select * from members where mem_id='$mem_id'";
$mem=sql_execute($sql_query,'get');
$sql_query="select trb_id from tribes where mem_id='$mem_id'";
$num=sql_execute($sql_query,'num');
$tribes=array();
if($num==0){
$tribes="";
}
else {
$res=sql_execute($sql_query,'res');
while($trb=mysql_fetch_object($res)){
array_push($tribes,$trb->trb_id);
}
}
//basic profile
if($type=="basic"){
$here_for=$pro->here_for;
if($here_for!=''){
$here_for="".$here_for." ";
}
if($mem->showgender=="0"){
$gender="";
}
elseif($mem->gender=="m"){
$gender="Male";
}
elseif($mem->gender=="f"){
$gender="Female";
}
else{
$gender="";
}
if($mem->showloc=="0"){
$location="";
}
else {
if($mem->country!='United States'){
$location=$mem->country;
}
else {
$sql_query="select city,state from zipdata where zipcode='$mem->zip'";
$num=sql_execute($sql_query,'num');
if($num==0){
$location=$mem->country;
}
else {
$loc=sql_execute($sql_query,'get');
$city=strtolower($loc->city);
$city=ucfirst($city);
$location=$city.", ".$loc->state;
}
}
}
$interests=$pro->interests;
if($interests!=''){
$split=split(",",$interests);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$interests=rtrim($interest,',');
}
$hometown=$pro->hometown;
if($hometown!=''){
$hometown="".$hometown." ";
}
$schools=$pro->schools;
if($schools!=''){
$split=split(",",$schools);
$school='';
foreach($split as $word){
$school.="".$word." ,";
}
$schools=rtrim($school,',');
}
if($mem->showage=="0"){
$age='';
}
else {
$now=time();
$was=$mem->birthday;
$dif=$now-$was;
$age=date("Y",$dif)-1970;
}
$description=array("Here For"=>$here_for,"Gender"=>$gender,"Age"=>$age,"Location"=>$location,"Interests"=>$interests,"Hometown"=>$hometown,"Schools"=>$schools);
while(list($key,$val)=each($description)){
if($val!=''){
echo "$key $val ";
}//if
}//while
if($groups!=''){
echo "Network Groups ";
$i=0;
foreach($groups as $group){
$sql_query="select name from groups where trb_id='$group'";
$trb=sql_execute($sql_query,'get');
echo "$trb->name ";
$i++;
if($i!=count($groups)){
echo ", ";
}
}
}
}//basic
//personal
elseif($type=="personal"){
$languages=$pro->$pro->languages;
if($languages!=''){
$split=split(",",$ineterests);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$languages=rtrim($ineterest,',');
}
$website=$pro->website;
if($website!=''){
$website="".$website." ";
}
$books=$pro->books;
if($books!=''){
$split=split(",",$books);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$books=rtrim($ineterest,',');
}
$music=$pro->music;
if($music!=''){
$split=split(",",$music);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$music=rtrim($interest,',');
}
$movies=$pro->movies;
if($movies!=''){
$split=split(",",$movies);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$movies=rtrim($interest,',');
}
$travel=$pro->travel;
if($travel!=''){
$split=split(",",$travel);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$travel=rtrim($interest,',');
}
$clubs=$pro->clubs;
if($clubs!=''){
$split=split(",",$clubs);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$clubs=rtrim($interest,',');
}
$about=$pro->about;
$meet_people=$pro->meet_people;
if($meet_people!=''){
$split=split(",",$meet_people);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$meet_people=rtrim($interest,',');
}
$description=array(
"Languages"=>$languages,
"Personal Website"=>$website,
"Favorite books"=>$books,
"Favorite music"=>$music,
"Favorite movies/tv"=>$movies,
"I've traveled to"=>$travel,
"Clubs"=>$clubs,
"About me"=>$about,
"I want to meet people for"=>$meet_people
);
while(list($key,$val)=each($description)){
if($val!=''){
echo " $key $val ";
}//if
}//while
answers("per",$mem_id);
}//personal
//professional
elseif($type=="professional"){
$position=$pro->position;
if($position!=''){
$position="".$position." ";
}
$company=$pro->company;
if($company!=''){
$company="".$company." ";
}
$occupation=$pro->occupation;
if($occupation!=''){
$occupation="".$occupation." ";
}
if($pro->industry!=''){
$sql_query="select name from industries where ind_id='$pro->industry'";
$ind=sql_execute($sql_query,'get');
$industry=$ind->name;
}
else
$industry='';
$specialities=$pro->specialities;
if($specialities!=''){
$split=split(",",$specialities);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$specialities=rtrim($interest,',');
}
$overview=$pro->overview;
$skills=$pro->skills;
if($skills!=''){
$split=split(",",$skills);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$skills=rtrim($interest,',');
}
$p_positions=$pro->p_positions;
if($p_positions!=''){
$split=split(",",$p_positions);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$p_positions=rtrim($interest,',');
}
$p_companies=$pro->p_companies;
if($p_companies!=''){
$split=split(",",$p_companies);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$p_companies=rtrim($interest,',');
}
$assotiations=$pro->assotiations;
if($associations!=''){
$split=split(",",$assotiations);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$assotiations=rtrim($interest,',');
}
$description=array (
"Position/Title"=>$position,
"Company"=>$company,
"Occupation"=>$occupation,
"Industry"=>$industry,
"Specialties"=>$specialities,
"Overview"=>$overview,
"Skills"=>$skills,
"Past Positions"=>$p_positions,
"Past Companies"=>$p_companies,
"Associations"=>$assotiations);
while(list($key,$val)=each($description)){
if($val!=''){
echo "$key $val ";
}//if
}//while
answers("pro",$mem_id);
}//professional
}//function
//shows testimonials on user
function show_testimonials($p_id,$m_id){
$sql_query="select * from testimonials where mem_id='$p_id' and stat='a'";
$num=sql_execute($sql_query,'num');
if($num==0){
echo "";echo name_header($p_id,$m_id);echo " has no testimonials.
";
}
else {
$res=sql_execute($sql_query,'res');
while($tst=mysql_fetch_object($res)){
echo "";show_photo($tst->from_id);echo "";
show_online($tst->from_id);echo " ";
$date=date("F d, Y",$tst->added);
echo "$date".stripslashes($tst->testimonial)."
";
}//while
}//else
}
//when showing form with radio or checkbox elements, functions chacks if it must be checked
function checked($val,$ch){
if($val==$ch){
echo " checked ";
}
}
function photo_album1($mem_id,$page,$mod){
$p_id=0;
$m_id=0;
$page=$page-1;
$sql_query="select photo_b_thumb,capture,approve from photo where mem_id='$mem_id'";
$pho=sql_execute($sql_query,'get');
$sql_query="select photo_b_thumb from members where mem_id='$mem_id'";
$main=sql_execute($sql_query,'get');
$photos=split("\|",$pho->photo_b_thumb);
$photos=if_empty($photos);
$captures=split("\|",$pho->capture);
$captures=if_empty($captures);
$approve=split("\|",$pho->approve);
$approve=if_empty($approve);
$start=$page*5;
$end=count($photos);
if($end>count($photos)){
$end=count($photos);
}//if
if($photos!=''){
echo "";
$p=0;
for($i=$start;$i<$end;$i++){
if ($p==0){
echo "";
}
$p++;
echo "Delete ";
}
echo " ";
$p=0;
}
}//for
echo "
$main_set
$captures[$i] ";
if($mod=='edi'){
echo "Delete
";
$p=0;
for($i=$start;$i<$end;$i++){
if ($p==0){
echo "";
}
$p++;
echo "Delete ";
$p=0;
}
}//for
echo "
";
$p=0;
for($i=$start;$i<$end;$i++){
$ii++;
if($photos[$i]){
if ($p==0){
echo "";
}
$p++;
//$ii=$i-1;
echo "Delete ";
$p=0;
}
}
}
//for
echo "
$captures[$i]
-- Select a friend --";
if($fr!=''){
foreach($fr as $frd){
$sql_query="select fname from members where mem_id='$frd'";
$f=sql_execute($sql_query,'get');
echo " $f->fname ";
}//foreach
}//if
}//function
function drop_friends1($mem_id,$ti){
$fr=count_network($mem_id,"1","ar");
echo "-- Select a friend --";
if($fr!=''){
foreach($fr as $frd){
$sql_query1="select members from tribes where trb_id='$ti'";
$t=sql_execute($sql_query1,'get');
//echo $t->members.$frd;
$all="$t->members";
//echo strrpos($t->members,$frd);
if (!strpos($all,$frd)){
$sql_query="select fname from members where mem_id='$frd'";
$f=sql_execute($sql_query,'get');
echo " $f->fname";
}
}//foreach
}//if
}//function
//drop-down list of tribe categories
function drop_t_cats($sel){
$sql_query="select name,t_cat_id from t_categories";
$res=sql_execute($sql_query,'res');
while($cat=mysql_fetch_object($res)){
if($cat->t_cat_id=="$sel"){
echo " $cat->name";
}//if
else {
echo " $cat->name";
}//else
}//while
}//function
//drop-down list of industries
function industry_drop($sel){
$sql_query="select * from industries";
$res=sql_execute($sql_query,'res');
while($ind=mysql_fetch_object($res)){
echo "ind_id=="$sel"){
echo " selected";
}
echo " value='$ind->ind_id'>";
if(!ereg("_",$ind->name)){ echo " "; }
echo "$ind->name ";
}//while
}//function
function show_friends_deg($m_id,$limit,$inline,$page,$deg){
$friends=count_network($m_id,"$deg","ar");
$friends=if_empty1($friends);
if($friends!=''){
$start=($page-1)*$limit;
$end=$start+$limit;
if($end>count($friends)){
$end=count($friends);
}
for($i=$start;$i<$end;$i++){
$frd=$friends[$i];
if(($i==0)||($i%$inline==0))
{
echo "";
}//if
echo "";
echo "";
show_photo($frd);
echo "
";
show_online($frd);
echo "
No friends.
";
}//else
}//function
function delete_banner($id) {
$sql_query="update banners set b_exp='Y' where b_id='$id'";
sql_execute($sql_query,'');
}//function
function maketime ($hour,$minute,$second,$month,$date,$year){
if ($hour === false) $hour = Date ("G");
if ($minute === false) $minute = Date ("i");
if ($second === false) $second = Date ("s");
if ($month === false) $month = Date ("n");
if ($date === false) $date = Date ("j");
if ($year === false) $year = Date ("Y");
if ($year >= 1970) return mktime ($hour, $minute, $second, $month, $date, $year);
// date before 1-1-1970 (Win32 Fix)
$m_days = Array (31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);
if ($year % 4 == 0 && ($year % 100 > 0 || $year % 400 == 0))
{
$m_days[1] = 29; // non leap-years can be: 1700, 1800, 1900, 2100, etc.
}
// go backward (-), based on $year
$d_year = 1970 - $year;
$days = 0 - $d_year * 365;
$days -= floor ($d_year / 4); // compensate for leap-years
$days += floor (($d_year - 70) / 100); // compensate for non-leap-years
$days -= floor (($d_year - 370) / 400); // compensate again for giant leap-years
// go forward (+), based on $month and $date
for ($i = 1; $i < $month; $i++)
{
$days += $m_days [$i - 1];
}
$days += $date - 1;
// go forward (+) based on $hour, $minute and $second
$stamp = $days * 86400;
$stamp += $hour * 3600;
$stamp += $minute * 60;
$stamp += $second;
return $stamp;
}
function connections1($mem_id,$frd_id){
//anonymous
if($frd_id=='0'){
$result=$result.'';
}
//1 user and 2 are the same
elseif($mem_id==$frd_id){
$result=$result."You";
}//if
else {
$friend=array();
$friend=count_network($mem_id,"1","ar");
//1 degree
if (is_array($friend)&&in_array($frd_id,$friend)){
$result=$result.show_online($frd_id)."";
show_online($result[0]);$result=$result."";
show_online($result[0]);$result=$result."";
show_online($result[0]);$result=$result."".$here_for." ";
if($mem->showgender=="0")
$gender="";
elseif($mem->gender=="m")
$gender="Male";
elseif($mem->gender=="f")
$gender="Female";
else
$gender="";
if($mem->showloc=="0")
$location="";
else {
if($mem->country!='United States'){
$location=$mem->country;
}
else {
$sql_query="select city,state from zipdata where zipcode='$mem->zip'";
$num=sql_execute($sql_query,'num');
if($num==0){
$location=$mem->country;
}
else {
$loc=sql_execute($sql_query,'get');
$city=strtolower($loc->city);
$city=ucfirst($city);
$location=$city.", ".$loc->state;
}
}
}
$interests=$pro->interests;
if($interests!=''){
$split=split(",",$interests);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$interests=rtrim($interest,',');
}
$hometown=$pro->hometown;
if($hometown!=''){
$hometown="".$hometown." ";
}
$schools=$pro->schools;
if($schools!=''){
$split=split(",",$schools);
$school='';
foreach($split as $word){
$school.="".$word." ,";
}
$schools=rtrim($school,',');
}
if($mem->showage=="0"){
$age='';
}
else {
$birth=$mem->birthday;
$age=(int)((time()-$birth)/31536000);
}
$description=array("Here For"=>$here_for,"Gender"=>$gender,"Age"=>$age,"Location"=>$location,"Interests"=>$interests,"Hometown"=>$hometown,"Schools"=>$schools,"Education"=>$pr o->education,"High School(s)"=>$pro->high_schools,"Film School(s)"=>$pro->film_schools,"College/University"=>$pro->college_university,"Major"=>$pro->major,"Degree(s)"=>$pro->degrees,"Year of degree"=>$pro->yearofdegree,"Special Training"=>$pro->special_training,"Special Groups"=>$pro->special_groups,"About Me"=>emoticon(htmlcode($pro->about_me)));
while(list($key,$val)=each($description)){
if($val!=''){
echo "$key ".stripslashes($val)." Groups ";
$i=0;
foreach($tribes as $tribe){
$sql_query="select name from tribes where trb_id='$tribe'";
$trb=sql_execute($sql_query,'get');
echo "".stripslashes($trb->name)." ".$word." ,";
}
$languages=rtrim($ineterest,',');
}
$website=$pro->website;
if($website!=''){
if(strpos($website,"ttp:")){
$website="".$website." ";}else{
$website="".$website." ";
}
}
$books=$pro->books;
if($books!=''){
$split=split(",",$books);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$books=rtrim($ineterest,',');
}
$music=$pro->music;
if($music!=''){
$split=split(",",$music);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$music=rtrim($interest,',');
}
$movies=$pro->movies;
if($movies!=''){
$split=split(",",$movies);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$movies=rtrim($interest,',');
}
$travel=$pro->travel;
if($travel!=''){
$split=split(",",$travel);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$travel=rtrim($interest,',');
}
$clubs=$pro->clubs;
if($clubs!=''){
$split=split(",",$clubs);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$clubs=rtrim($interest,',');
}
$about=$pro->about;
$meet_people=$pro->meet_people;
if($meet_people!=''){
$split=split(",",$meet_people);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$meet_people=rtrim($interest,',');
}
$hobby=$pro->hobby;
if($hobby!=''){
$split=split(",",$hobby);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$hobby=rtrim($interest,',');
}
$status=$pro->status;
if($status!=''){
$split=split(",",$status);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$status=rtrim($interest,',');
}
$description=array("Languages"=>$languages,
$GLOBALS['word'][125]=>$website,
"Favorite books"=>$books,
"Favorite music"=>$music,
"Favorite movies/tv"=>$movies,
"I've traveled to"=>$travel,
"Clubs"=>$clubs,
"Hobby"=>$hobby,
"Status"=>$status,
"About me"=>$about,
"I want to meet people for"=>$meet_people);
while(list($key,$val)=each($description)){
if($val!=''){
echo "$key ".stripslashes($val)." ".$position." ";
}
$company=$pro->company;
if($company!=''){
$company="".$company." ";
}
$occupation=$pro->occupation;
if($occupation!=''){
$occupation="".$occupation." ";
}
if($pro->industry!=''){
$sql_query="select name from industries where ind_id='$pro->industry'";
$ind=sql_execute($sql_query,'get');
$industry=$ind->name;
}
else {
$industry='';
}
$specialities=$pro->specialities;
if($specialities!=''){
$split=split(",",$specialities);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$specialities=rtrim($interest,',');
}
$overview=$pro->overview;
$skills=$pro->skills;
if($skills!=''){
$split=split(",",$skills);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$skills=rtrim($interest,',');
}
$p_positions=$pro->p_positions;
if($p_positions!=''){
$split=split(",",$p_positions);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$p_positions=rtrim($interest,',');
}
$p_companies=$pro->p_companies;
if($p_companies!=''){
$split=split(",",$p_companies);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$p_companies=rtrim($interest,',');
}
$assotiations=$pro->assotiations;
if($associations!=''){
$split=split(",",$assotiations);
$interest='';
foreach($split as $word){
$interest.="".$word." ,";
}
$associations=rtrim($interest,',');
}
$description=array (
"Position/Title"=>$position,
"Company"=>$company,
"Occupation"=>$occupation,
"Industry"=>$industry,
"Specialties"=>$specialities,
"Overview"=>$overview,
"Skills"=>$skills,
"Past Positions"=>$p_positions,
"Past Companies"=>$p_companies,
"Associations"=>$association
);
while(list($key,$val)=each($description)){
if($val!=''){
echo "$key ".stripslashes($val)." ".get_media($mem_id)." ".$que->q_que." ";
if($ftype=="tb" || $ftype=="ta")
echo $val;
else {
if($ftype=="rb" || $ftype=="dd") {
$ans = sql_execute("SELECT * FROM answers WHERE a_id='$val' ORDER BY a_id","get");
echo $ans->a_ans;
} elseif($ftype=="cb") {
$ans = sql_execute("SELECT * FROM answers WHERE a_qid = '".$que->q_id."' ORDER BY a_id ASC","res");
$val = explode("|",$val);
while($row=mysql_fetch_object($ans)){
if(in_array($row->a_id,$val))
echo $row->a_ans." No friends.
"; }//else
}//function
function show_online1($m_id){
$sql_query="select fname,lname,online,mem_id from members where mem_id='$m_id'";
//echo $sql_query;
$mem=sql_execute($sql_query,'get');
if($mem->online=='on'){
echo "$mem->fname ";
$sql_query="select * from members where mem_id='$m_id'";
$mem1=sql_execute($sql_query,'get');
$now=time();
$was=$mem1->birthday;
$y=@date("Y",$now);
$m=@date("m",$was);
$d=@date("d",$was);
$birth_in_this=mktime(0,0,0,$m,$d,$y);
$dif=$birth_in_this-$now;
$dif=round($dif/(60*60*24));
}
else {
echo "$mem->fname ";
$sql_query="select * from members where mem_id='$m_id'";
$mem1=sql_execute($sql_query,'get');
$now=time();
$was=$mem1->birthday;
$y=@date("Y",$now);
$m=@date("m",$was);
$d=@date("d",$was);
$birth_in_this=mktime(0,0,0,$m,$d,$y);
$dif=$birth_in_this-$now;
$dif=round($dif/(60*60*24));
}
}
//showing user main photo
function get_education_drop()
{
return 'Elementary
High School
Film School
Tech School
Some College
Associates Degree
Bachelors
Masters
Ph.D
Postdoctoral
';
}
function htmlcode($string) {
$string=eregi_replace("\\[img\\]([^\\[]*)\\[/img\\]","\\1 ",$string);
$string=eregi_replace("\\[i\\]([^\\[]*)\\[/i\\]","\\1 ",$string);
$string=eregi_replace("\\[u\\]([^\\[]*)\\[/u\\]","\\1 ",$string);
$string=eregi_replace("\\[strike\\]([^\\[]*)\\[/strike\\]","\\1 ",$string);
$string=eregi_replace("\\[email\\]([^\\[]*)\\[/email\\]","\\1 ",$string);
$string=eregi_replace("\\[url\\]www.([^\\[]*)\\[/url\\]","\\1 ",$string);
$string=eregi_replace("\\[url\\]([^\\[]*)\\[/url\\]","\\1 ",$string);
$string=eregi_replace("\\[url=http://([^\\[]+)\\]([^\\[]*)\\[/url\\]","\\2 ",$string);
$string=eregi_replace("\[br\]", '
Shared Hosting
Shared Hosting
"; $dis[]="".$img_s.""; $dis_id[]=$row->b_id; } $tak=rand(0,$num); $sql_query="select * from banners where b_id='$dis_id[$tak]'"; $num=sql_execute($sql_query,'num'); if($num!=0) { $bann=sql_execute($sql_query,'get'); $d_f=date("d",$bann->b_f_day); $m_f=date("m",$bann->b_f_day); $y_f=date("Y",$bann->b_f_day); $d_t=date("d",$bann->b_t_day); $m_t=date("m",$bann->b_t_day); $y_t=date("Y",$bann->b_t_day); // $f_day=mktime(0,0,0,$m_f,$d_f,$y_f); // $t_day=mktime(0,0,0,$m_t,$d_t,$y_t); $f_day=mktime(0,0,0,$m_f,$d_f,$y_f); $t_day=mktime(0,0,0,$m_t,$d_t,$y_t); $today=mktime(0,0,0,date("m"),date("d"),date("Y")); if(($bann->b_dur=="D") and ($today>$t_day)) { delete_banner($dis_id[$tak]); } elseif($bann->b_dur=="C" and ($bann->b_ncl<=$bann->b_clks)) { delete_banner($dis_id[$tak]); } elseif($bann->b_dur=="I" and ($bann->b_noi<=$bann->b_see)) { delete_banner($dis_id[$tak]); } echo $dis[$tak]; for($i=0; $i<=$ip_co; $i++) { mysql_query("update banners set b_see=b_see+1 where b_id='$dis_id[$tak]'"); } } } } function f_banners() { global $cookie_url,$main_url; $sql="select * from banners where b_blk='N' and b_typ='F' and b_exp='N'"; $res=mysql_query($sql); $dis=array(); $dis_id=array(); $num=mysql_num_rows($res); if(mysql_num_rows($res)) { while($row=mysql_fetch_object($res)) { $tmp=explode(".",$row->b_img); $tmp_count=count($tmp); $ext=strtolower($tmp[$tmp_count-1]); if($ext=="swf") { $img_s=""; } else $img_s="