|
| ||
| I NEED HELP PLEASE:Warning: mysql_num_rows(): I NEED HELP PLEASE PLEASE PLEASE THE PROBLEM IS Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php on line 28 [PHP]<? $conn_id; $sql_res; $sql_res2; $sql_query; $HTTP_REFERER=$_SERVER["HTTP_REFERER"]; $REQUEST_METHOD=$_SERVER["REQUEST_METHOD"]; function sql_connect(){ global $conn_id,$sql_host,$sql_user,$sql_pass,$sql_db; $conn_id=mysql_connect($sql_host,$sql_user,$sql_pass); mysql_select_db($sql_db); } function sql_execute($sql_query,$wtr){ global $conn_id; $sql_res=mysql_query($sql_query,$conn_id); if($wtr=='get'){ if(mysql_num_rows($sql_res)){ return mysql_fetch_object($sql_res); } else { return ''; } } elseif($wtr=='num'){ return mysql_num_rows($sql_res); } elseif($wtr=='res'){ return $sql_res; } } function sql_rows($id,$table){ global $conn_id; $query="select $id from $table"; $result=mysql_query($query,$conn_id); $number=mysql_num_rows($result); return $number; } function sql_close(){ global $conn_id; mysql_close($conn_id); } function h_banners() { global $cookie_url,$main_url; $sql="select * from banners where b_blk='N' and b_typ='H' 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="<object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000' codebase='http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0' width='420' height='60'> <param name='movie' value='".$main_url."/".$row->b_img."'> <param name='quality' value='high'> <embed src='".$main_url."/".$row->b_img."' quality='high' pluginspage='http://www.macromedia.com/go/getflashplayer' type='application/x-shockwave-flash' width='420' height='60'></embed></object>"; } else $img_s="<img src='".$main_url."/".$row->b_img."' border='0' width='420' height='60' alt='".stripslashes($row->b_desc)."' ismap>"; $dis[]="<A href='".$main_url."/banners/index.php?url=".$row->b_url."&seid=".$row->b_id."&sess=set' target='_blank'>".$img_s."</a>"; $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="<object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000' codebase='http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0' width='720' height='60'> <param name='movie' value='".$main_url."/".$row->b_img."'> <param name='quality' value='high'> <param name='wmode' value='opaque'> <param name='loop' value='false'> <embed src='".$main_url."/".$row->b_img."' loop='false' wmode='opaque' quality='high' swLiveConnect='false' pluginspage='http://www.macromedia.com/go/getflashplayer' type='application/x-shockwave-flash' width='720' height='60'></embed></object>"; } else $img_s="<img src='".$main_url."/".$row->b_img."' border='0' width='720' height='60' alt='".stripslashes($row->b_desc)."' ismap>"; $dis[]="<A href='".$main_url."/banners/index.php?url=".$row->b_url."&seid=".$row->b_id."&sess=set' target='_blank'>".$img_s."</a>"; $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; $subj=nl2br($subj); $body=nl2br($body); $recipient = $to; $headers = "From: " . "$name" . "<" . "$from" . ">\n"; $headers .= "X-Sender: <" . "$to" . ">\n"; $headers .= "Return-Path: <" . "$to" . ">\n"; $headers .= "Error-To: <" . "$to" . ">\n"; $headers .= "Content-Type: text/html\n"; mail("$recipient","$subj","$body","$headers"); } 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 $get_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; if(isset($mode)){ $document=$mode.".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 "<option selected value='$cat->cat_id'>$cat->name"; } else{ echo "<option value='$cat->cat_id'>$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 "<option selected value='$cat->event_id'>".stripslashes($cat->event_nam)."</option>"; } else{ echo "<option value='$cat->event_id'>".stripslashes($cat->event_nam)."</option>"; } }//while }//function //admin header function show_ad_header($adsess){ $mode=form_get("mode"); $act=form_get("act"); ?> <html> <head> <title>Site Administration</title> <link href="styles/style.css" type="text/css" rel="stylesheet"> <? if(($mode='listings_manager')&&($act=='edit')) {?> <script language="Javascript" src="DynamicOptionList.js"></script> <SCRIPT LANGUAGE="JavaScript"> var listCategory = new DynamicOptionList("Category","RootCategory"); <? listing_cats_java(1); ?> listCategory.addOptions('','Select Subcategory',''); listCategory.setDefaultOption('',''); function init() { var theform = document.forms["searchListing"]; listCategory.init(theform); } </SCRIPT> <body marginwidth="5" bgcolor="#ffffff" leftmargin ="5" topmargin="5" marginheight="5" onLoad="listCategory.init(document.forms['searchListing']);"> <? } ?> </head> <body topmargin=2 leftmargin=2> <table width="740"> <tr><td width=100%> <? require('templates/ad_header.php'); ?> </td> <tr><td width=100%> <? }//function //showing header function show_header(){ ?> <html> <head> <title>Demo Site</title> <link href="styles/style.css" type="text/css" rel="stylesheet"> <? $mode=form_get("mode"); $act=form_get("act"); if($mode=="user"){ ?> <script language="JavaScript"> <!-- function formsubmit(type){ document.profile.redir.value=type; document.profile.submit(); } --> </script> <? } elseif(($mode=='listing')&&($act=='create')){ ?> <script language="Javascript" src="DynamicOptionList.js"></script> <SCRIPT LANGUAGE="JavaScript"> var listmessage_categoryId = new DynamicOptionList("message_categoryId","message_rootCategoryId"); <? listing_cats_java(2); ?> listmessage_categoryId.addOptions('8000','computer','8001','creative','8002','erotic','8003','event','8004','household','8005','garden / labor / haul','8006','lessons','8007','looking for','8008','skilled trade','8009','sm biz ads','8010','therapeutic','8011'); function init() { var theform = document.forms["manageListing"]; listmessage_categoryId.init(theform); } </SCRIPT> <body marginwidth="5" bgcolor="#ffffff" leftmargin ="5" topmargin="5" marginheight="5" onLoad="listmessage_categoryId.init(document.forms['manageListing']);"> <? } elseif((($mode=='listing')&&($act!='create')&&($act!='show')&&($act!='feedback'))||(($mode=='search')&&($act=='listing'))){ ?> <script language="Javascript" src="DynamicOptionList.js"></script> <SCRIPT LANGUAGE="JavaScript"> var listCategory = new DynamicOptionList("Category","RootCategory"); <? listing_cats_java(1); ?> listCategory.addOptions('','Select Subcategory',''); listCategory.setDefaultOption('',''); function init() { var theform = document.forms["searchListing"]; listCategory.init(theform); } </SCRIPT> <body marginwidth="5" bgcolor="#ffffff" leftmargin ="5" topmargin="5" marginheight="5" onLoad="listCategory.init(document.forms['searchListing']);"> <? }//elseif ?> </head> <body topmargin=2 leftmargin=2> <table width="740"> <tr><td width=100%> <? require('templates/header.php'); ?> </td> <tr><td width=100%> <? } //showing footer function show_footer(){ ?> </td> <tr><td width=100%> <? require("templates/footer.php"); ?> </td></body></html> <? //sql_close(); } //redirect function show_screen($loc){ Header("Location: $loc"); exit; } //error reports function error_screen($errid){ $sql_query="select * from errors where err_id='$errid'"; $err=sql_execute($sql_query,'get'); $error_line=$err->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){ $sql_query="select password,ban from members where mem_id='$mem_id'"; $num=sql_execute($sql_query,'num'); $mem=sql_execute($sql_query,'get'); //if password incorrect if(($num==0)||($mem_pass!=$mem->password)){ error_screen(0); } //if user banned elseif($mem->ban=='y'){ error_screen(12); } //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) & ($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(){ ?> <OPTION VALUE="any">Any</OPTION> <OPTION VALUE="United States">United States</OPTION> <OPTION VALUE="Afghanistan">Afghanistan</OPTION> <OPTION VALUE="Albania">Albania</OPTION> <OPTION VALUE="Algeria">Algeria</OPTION> <OPTION VALUE="American Samoa">American Samoa</OPTION> <OPTION VALUE="Andorra">Andorra</OPTION> <OPTION VALUE="Angola">Angola</OPTION> <OPTION VALUE="Anguilla">Anguilla</OPTION> <OPTION VALUE="Antartica">Antartica</OPTION> <OPTION VALUE="Antigua and Barbuda">Antigua and Barbuda</OPTION> <OPTION VALUE="Argentina">Argentina</OPTION> <OPTION VALUE="Armenia">Armenia</OPTION> <OPTION VALUE="Aruba">Aruba</OPTION> <OPTION VALUE="Ascension Island">Ascension Island</OPTION> <OPTION VALUE="Australia">Australia</OPTION> <OPTION VALUE="Austria">Austria</OPTION> <OPTION VALUE="Azerbaijan">Azerbaijan</OPTION> <OPTION VALUE="Bahamas">Bahamas</OPTION> <OPTION VALUE="Bahrain">Bahrain</OPTION> <OPTION VALUE="Bangladesh">Bangladesh</OPTION> <OPTION VALUE="Barbados">Barbados</OPTION> <OPTION VALUE="Belarus">Belarus</OPTION> <OPTION VALUE="Belgium">Belgium</OPTION> <OPTION VALUE="Belize">Belize</OPTION> <OPTION VALUE="Benin">Benin</OPTION> <OPTION VALUE="Bermuda">Bermuda</OPTION> <OPTION VALUE="Bhutan">Bhutan</OPTION> <OPTION VALUE="Bolivia">Bolivia</OPTION> <OPTION VALUE="Botswana">Botswana</OPTION> <OPTION VALUE="Bouvet Island">Bouvet Island</OPTION> <OPTION VALUE="Brazil">Brazil</OPTION> <OPTION VALUE="Brunei Darussalam">Brunei Darussalam</OPTION> <OPTION VALUE="Bulgaria">Bulgaria</OPTION> <OPTION VALUE="Burkina Faso">Burkina Faso</OPTION> <OPTION VALUE="Burundi">Burundi</OPTION> <OPTION VALUE="Cambodia">Cambodia</OPTION> <OPTION VALUE="Cameroon">Cameroon</OPTION> <OPTION VALUE="Canada">Canada</OPTION> <OPTION VALUE="Cape Verde Islands">Cape Verde Islands</OPTION> <OPTION VALUE="Cayman Islands">Cayman Islands</OPTION> <OPTION VALUE="Chad">Chad</OPTION> <OPTION VALUE="Chile">Chile</OPTION> <OPTION VALUE="China">China</OPTION> <OPTION VALUE="Christmas Island">Christmas Island</OPTION> <OPTION VALUE="Colombia">Colombia</OPTION> <OPTION VALUE="Comoros">Comoros</OPTION> <OPTION VALUE="Congo, Republic of">Congo, Republic of</OPTION> <OPTION VALUE="Cook Islands">Cook Islands</OPTION> <OPTION VALUE="Costa Rica">Costa Rica</OPTION> <OPTION VALUE="Cote d Ivoire">Cote d'Ivoire</OPTION> <OPTION VALUE="Croatia/Hrvatska">Croatia/Hrvatska</OPTION> <OPTION VALUE="Cyprus">Cyprus</OPTION> <OPTION VALUE="Czech Republic">Czech Republic</OPTION> <OPTION VALUE="Denmark">Denmark</OPTION> <OPTION VALUE="Djibouti">Djibouti</OPTION> <OPTION VALUE="Dominica">Dominica</OPTION> <OPTION VALUE="Dominican Republic">Dominican Republic</OPTION> <OPTION VALUE="East Timor">East Timor</OPTION> <OPTION VALUE="Ecuador">Ecuador</OPTION> <OPTION VALUE="Egypt">Egypt</OPTION> <OPTION VALUE="El Salvador">El Salvador</OPTION> <OPTION VALUE="Equatorial Guinea">Equatorial Guinea</OPTION> <OPTION VALUE="Eritrea">Eritrea</OPTION> <OPTION VALUE="Estonia">Estonia</OPTION> <OPTION VALUE="Ethiopia">Ethiopia</OPTION> <OPTION VALUE="Falkland Islands">Falkland Islands</OPTION> <OPTION VALUE="Faroe Islands">Faroe Islands</OPTION> <OPTION VALUE="Fiji">Fiji</OPTION> <OPTION VALUE="Finland">Finland</OPTION> <OPTION VALUE="France">France</OPTION> <OPTION VALUE="French Guiana">French Guiana</OPTION> <OPTION VALUE="French Polynesia">French Polynesia</OPTION> <OPTION VALUE="Gabon">Gabon</OPTION> <OPTION VALUE="Gambia">Gambia</OPTION> <OPTION VALUE="Georgia">Georgia</OPTION> <OPTION VALUE="Germany">Germany</OPTION> <OPTION VALUE="Ghana">Ghana</OPTION> <OPTION VALUE="Gibraltar">Gibraltar</OPTION> <OPTION VALUE="Greece">Greece</OPTION> <OPTION VALUE="Greenland">Greenland</OPTION> <OPTION VALUE="Grenada">Grenada</OPTION> <OPTION VALUE="Guadeloupe">Guadeloupe</OPTION> <OPTION VALUE="Guam">Guam</OPTION> <OPTION VALUE="Guatemala">Guatemala</OPTION> <OPTION VALUE="Guernsey">Guernsey</OPTION> <OPTION VALUE="Guinea">Guinea</OPTION> <OPTION VALUE="Guinea-Bissau">Guinea-Bissau</OPTION> <OPTION VALUE="Guyana">Guyana</OPTION> <OPTION VALUE="Haiti">Haiti</OPTION> <OPTION VALUE="Honduras">Honduras</OPTION> <OPTION VALUE="Hong Kong">Hong Kong</OPTION> <OPTION VALUE="Hungary">Hungary</OPTION> <OPTION VALUE="Iceland">Iceland</OPTION> <OPTION VALUE="India">India</OPTION> <OPTION VALUE="Indonesia">Indonesia</OPTION> <OPTION VALUE="Iran">Iran</OPTION> <OPTION VALUE="Ireland">Ireland</OPTION> <OPTION VALUE="Isle of Man">Isle of Man</OPTION> <OPTION VALUE="Israel">Israel</OPTION> <OPTION VALUE="Italy">Italy</OPTION> <OPTION VALUE="Jamaica">Jamaica</OPTION> <OPTION VALUE="Japan">Japan</OPTION> <OPTION VALUE="Jersey">Jersey</OPTION> <OPTION VALUE="Jordan">Jordan</OPTION> <OPTION VALUE="Kazakhstan">Kazakhstan</OPTION> <OPTION VALUE="Kenya">Kenya</OPTION> <OPTION VALUE="Kiribati">Kiribati</OPTION> <OPTION VALUE="Korea, Republic of">Korea, Republic of</OPTION> <OPTION VALUE="Kuwait">Kuwait</OPTION> <OPTION VALUE="Kyrgyzstan">Kyrgyzstan</OPTION> <OPTION VALUE="Laos">Laos</OPTION> <OPTION VALUE="Latvia">Latvia</OPTION> <OPTION VALUE="Lebanon">Lebanon</OPTION> <OPTION VALUE="Lesotho">Lesotho</OPTION> <OPTION VALUE="Liberia">Liberia</OPTION> <OPTION VALUE="Libya">Libya</OPTION> <OPTION VALUE="Liechtenstein">Liechtenstein</OPTION> <OPTION VALUE="Lithuania">Lithuania</OPTION> <OPTION VALUE="Luxembourg">Luxembourg</OPTION> <OPTION VALUE="Macau">Macau</OPTION> <OPTION VALUE="Macedonia">Macedonia</OPTION> <OPTION VALUE="Madagascar">Madagascar</OPTION> <OPTION VALUE="Malawi">Malawi</OPTION> <OPTION VALUE="Malaysia">Malaysia</OPTION> <OPTION VALUE="Maldives">Maldives</OPTION> <OPTION VALUE="Mali">Mali</OPTION> <OPTION VALUE="Malta">Malta</OPTION> <OPTION VALUE="Marshall Islands">Marshall Islands</OPTION> <OPTION VALUE="Martinique">Martinique</OPTION> <OPTION VALUE="Mauritania">Mauritania</OPTION> <OPTION VALUE="Mauritius">Mauritius</OPTION> <OPTION VALUE="Mayotte Island">Mayotte Island</OPTION> <OPTION VALUE="Mexico">Mexico</OPTION> <OPTION VALUE="Micronesia">Micronesia</OPTION> <OPTION VALUE="Moldova">Moldova</OPTION> <OPTION VALUE="Monaco">Monaco</OPTION> <OPTION VALUE="Mongolia">Mongolia</OPTION> <OPTION VALUE="Montserrat">Montserrat</OPTION> <OPTION VALUE="Morocco">Morocco</OPTION> <OPTION VALUE="Mozambique">Mozambique</OPTION> <OPTION VALUE="Myanmar">Myanmar</OPTION> <OPTION VALUE="Namibia">Namibia</OPTION> <OPTION VALUE="Nauru">Nauru</OPTION> <OPTION VALUE="Nepal">Nepal</OPTION> <OPTION VALUE="Netherlands">Netherlands</OPTION> <OPTION VALUE="Netherlands Antilles">Netherlands Antilles</OPTION> <OPTION VALUE="New Caledonia">New Caledonia</OPTION> <OPTION VALUE="New Zealand">New Zealand</OPTION> <OPTION VALUE="Nicaragua">Nicaragua</OPTION> <OPTION VALUE="Niger">Niger</OPTION> <OPTION VALUE="Nigeria">Nigeria</OPTION> <OPTION VALUE="Niue">Niue</OPTION> <OPTION VALUE="Norfolk Island">Norfolk Island</OPTION> <OPTION VALUE="Norway">Norway</OPTION> <OPTION VALUE="Oman">Oman</OPTION> <OPTION VALUE="Pakistan">Pakistan</OPTION> <OPTION VALUE="Palau">Palau</OPTION> <OPTION VALUE="Panama">Panama</OPTION> <OPTION VALUE="Papua New Guinea">Papua New Guinea</OPTION> <OPTION VALUE="Paraguay">Paraguay</OPTION> <OPTION VALUE="Peru">Peru</OPTION> <OPTION VALUE="Philippines">Philippines</OPTION> <OPTION VALUE="Pitcairn Island">Pitcairn Island</OPTION> <OPTION VALUE="Poland">Poland</OPTION> <OPTION VALUE="Portugal">Portugal</OPTION> <OPTION VALUE="Puerto Rico">Puerto Rico</OPTION> <OPTION VALUE="Qatar">Qatar</OPTION> <OPTION VALUE="Reunion Island">Reunion Island</OPTION> <OPTION VALUE="Romania">Romania</OPTION> <OPTION VALUE="Russian Federation">Russian Federation</OPTION> <OPTION VALUE="Rwanda">Rwanda</OPTION> <OPTION VALUE="Saint Helena">Saint Helena</OPTION> <OPTION VALUE="Saint Lucia">Saint Lucia</OPTION> <OPTION VALUE="San Marino">San Marino</OPTION> <OPTION VALUE="Saudi Arabia">Saudi Arabia</OPTION> <OPTION VALUE="Senegal">Senegal</OPTION> <OPTION VALUE="Seychelles">Seychelles</OPTION> <OPTION VALUE="Sierra Leone">Sierra Leone</OPTION> <OPTION VALUE="Singapore">Singapore</OPTION> <OPTION VALUE="Slovak Republic">Slovak Republic</OPTION> <OPTION VALUE="Slovenia">Slovenia</OPTION> <OPTION VALUE="Solomon Islands">Solomon Islands</OPTION> <OPTION VALUE="Somalia">Somalia</OPTION> <OPTION VALUE="South Africa">South Africa</OPTION> <OPTION VALUE="South Georgia">South Georgia</OPTION> <OPTION VALUE="Spain">Spain</OPTION> <OPTION VALUE="Sri Lanka">Sri Lanka</OPTION> <OPTION VALUE="Suriname">Suriname</OPTION> <OPTION VALUE="Svalbard">Svalbard</OPTION> <OPTION VALUE="Swaziland">Swaziland</OPTION> <OPTION VALUE="Sweden">Sweden</OPTION> <OPTION VALUE="Switzerland">Switzerland</OPTION> <OPTION VALUE="Syria">Syria</OPTION> <OPTION VALUE="Taiwan">Taiwan</OPTION> <OPTION VALUE="Tajikistan">Tajikistan</OPTION> <OPTION VALUE="Tanzania">Tanzania</OPTION> <OPTION VALUE="Thailand">Thailand</OPTION> <OPTION VALUE="Togo">Togo</OPTION> <OPTION VALUE="Tokelau">Tokelau</OPTION> <OPTION VALUE="Tonga Islands">Tonga Islands</OPTION> <OPTION VALUE="Tunisia">Tunisia</OPTION> <OPTION VALUE="Turkey">Turkey</OPTION> <OPTION VALUE="Turkmenistan">Turkmenistan</OPTION> <OPTION VALUE="Tuvalu">Tuvalu</OPTION> <OPTION VALUE="Uganda">Uganda</OPTION> <OPTION VALUE="Ukraine">Ukraine</OPTION> <OPTION VALUE="United Kingdom">United Kingdom</OPTION> <OPTION VALUE="Uruguay">Uruguay</OPTION> <OPTION VALUE="Uzbekistan">Uzbekistan</OPTION> <OPTION VALUE="Vanuatu">Vanuatu</OPTION> <OPTION VALUE="Vatican City">Vatican City</OPTION> <OPTION VALUE="Venezuela">Venezuela</OPTION> <OPTION VALUE="Vietnam">Vietnam</OPTION> <OPTION VALUE="Western Sahara">Western Sahara</OPTION> <OPTION VALUE="Western Samoa">Western Samoa</OPTION> <OPTION VALUE="Yemen">Yemen</OPTION> <OPTION VALUE="Yugoslavia">Yugoslavia</OPTION> <OPTION VALUE="Zambia">Zambia</OPTION> <OPTION VALUE="Zimbabwe">Zimbabwe</OPTION> <? } //days drop-down list function day_drop($sel){ for($i=1;$i<=31;$i++){ if($i==$sel){ echo "<option selected value='$i'>$i\n"; } else { echo "<option value='$i'>$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 "<option selected value='$i'>$month[$i]\n"; } else { echo "<option value='$i'>$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 "<option value='$i'>$i\n"; }//for }//if else{ $year=date("Y"); for($i=$year-50;$i<=$year;$i++){ if($i==$sel){ echo "<option selected value='$i'>$i\n"; } else { echo "<option value='$i'>$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 "<img src='images/icon_online.gif' alt='this user is online now'>"; echo "  <span class='namelink-online'><a href='index.php?mode=people_card&p_id=$m_id'>$mem->fname</a></span>"; } else{ echo "<img src='images/icon_offline.gif' alt='this user is offline now'>"; echo "  <span class='namelink-offline'><a href='index.php?mode=people_card&p_id=$m_id'>$mem->fname</a></span>"; } } //showing user's name function show_memnam($m_id){ $sql_query="select fname,lname from members where mem_id='$m_id'"; $mem=sql_execute($sql_query,'get'); echo "<span class='namelink-online'><a href='index.php?mode=people_card&p_id=$m_id'>$mem->fname</a></span>"; } //showing user main photo function show_photo($m_id){ if($m_id=='anonim'){ echo "<img src='images/unknownUser_th.jpg' border=0>"; }//if else { $sql_query="select photo_thumb from members where mem_id='$m_id'"; $mem=sql_execute($sql_query,'get'); if($mem->photo_thumb=='no'){ $mem->photo_thumb="images/unknownUser_th.jpg"; } echo "<a href='index.php?mode=people_card&p_id=$m_id'><img src='$mem->photo_thumb' border=0></a>"; } } //calculating number of new messages in inbox function mes_num($m_id){ $sql_query="select mes_id from messages_system where mem_id='$m_id' and folder='inbox' and type='message' and new='new'"; $num=sql_execute($sql_query,'num'); return $num; } function count_network1($m_id,$deg,$mod){ //degree 1 $sql_query="select mem_id from members where mem_id!=$m_id"; $num=sql_execute($sql_query,'num'); if($num==0){ $friend=''; }//if else { $res=sql_execute($sql_query,'res'); $friend=array(); while($fr=mysql_fetch_object($res)){ array_push($friend,$fr->mem_id); }//while $friend=del_dup($friend); }//else if ($mod=='num'){ return $num; } elseif ($mod=='ar'){ return $friend; } } //calculating number or creating array of user's friends, depending on degree function count_network($m_id,$deg,$mod){ //degree 1 if($deg==1){ $sql_query="select frd_id from network where mem_id='$m_id'"; $num=sql_execute($sql_query,'num'); if($num==0){ $friend=''; }//if else { $res=sql_execute($sql_query,'res'); $friend=array(); while($fr=mysql_fetch_object($res)){ array_push($friend,$fr->frd_id); }//while $friend=del_dup($friend); }//else }//deg1 //degree 2 elseif($deg==2){ $fr=array(); $fr=count_network($m_id,"1","ar"); if($fr==''){ $friend=''; $num=0; }//if else { $friend=array(); foreach($fr as $fid){ $sql_query="select frd_id from network where mem_id='$fid' and frd_id!='$m_id'"; $res=sql_execute($sql_query,'res'); while($fri=mysql_fetch_object($res)){ array_push($friend,$fri->frd_id); }//while }//foreach $friend=del_dup($friend); $friend=array_diff($friend,$fr); $num=count($friend); }//else }//deg2 //degree 3 elseif($deg==3){ $fr=array(); $fr1=count_network($m_id,"1","ar"); $fr=count_network($m_id,"2","ar"); if($fr==''){ $friend=''; $num=0; }//if else { $friend=array(); foreach($fr as $fid){ $sql_query="select frd_id from network where mem_id='$fid' and frd_id!='$m_id'"; $res=sql_execute($sql_query,'res'); while($fri=mysql_fetch_object($res)){ array_push($friend,$fri->frd_id); }//while }//foreach $friend=del_dup($friend); $friend=array_diff($friend,$fr); $friend=array_diff($friend,$fr1); $num=count($friend); }//else }//deg3 //degree 4 elseif($deg==4){ $fr=array(); $fr1=count_network($m_id,"1","ar"); $fr2=count_network($m_id,"2","ar"); $fr=count_network($m_id,"3","ar"); if($fr==''){ $friend=''; $num=0; }//if else { $friend=array(); foreach($fr as $fid){ $sql_query="select frd_id from network where mem_id='$fid' and frd_id!='$m_id'"; $res=sql_execute($sql_query,'res'); while($fri=mysql_fetch_object($res)){ array_push($friend,$fri->frd_id); }//while }//foreach $friend=del_dup($friend); $friend=array_diff($friend,$fr); $friend=array_diff($friend,$fr1); $friend=array_diff($friend,$fr2); $num=count($friend); }//else }//deg4 //degree all elseif($deg=='all'){ $num=count_network($m_id,"1","num")+count_network($m_id,"2","num")+ count_network($m_id,"3","num")+count_network($m_id,"4","num"); $friend=array_merge(count_network($m_id,"1","ar"),count_network($m_id,"2","ar"), count_network($m_id,"3","ar"),count_network($m_id,"4","ar")); }//degall //////////////////////////////////// //format output if ($mod=='num'){ return $num; } elseif ($mod=='ar'){ return $friend; } //////////////////////////////////// } //deleting duplicates from array function del_dup($data){ $result=array(); $result=array_unique($data); return $result; } //showing random tip function show_tip(){ $num=sql_rows("tip_id","tips"); $tid=rand(0,$num); $sql_query="select * from tips where tip_id='$tid'"; $tip=sql_execute($sql_query,'get'); echo "<span class='bold'>$tip->tip_header</span></br> $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 "<table>"; echo "<tr><td> <table class='table-photo'> <tr><td align=center width=70 height=75>"; if(($lst->privacy=='y')||($lst->anonim=='y')){ echo "<img src='images/unknownUser_th.jpg' border=0>"; }//if else { show_photo($lst->mem_id); }//else echo "</td> <tr><td align=center>"; if($lst->anonim!='y'){ show_online($lst->mem_id); } else{ echo "<small><small>anonymous</small></small>"; } echo "</td> </table> </td>"; echo "<td> <table width=100% class='body'> <tr><td class='form-comment'><a href='index.php?mode=listing&act=show&lst_id=$lst->lst_id'> <img src='images/icon_listing.gif' border=0> $lst->title</a></td> <tr><td>$date - $cat->name - $sub->name</td> <tr><td>$lst->descr_part <span class='action'><a href='index.php?mode=listing&act=show&lst_id=$lst->lst_id'>more</a></span></td> <tr><td>"; if($lst->anonim!='y'){ connections($m_id,$lst->mem_id); } echo "</td> </table> </td>"; echo "</table>"; 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 "<p align=center>No listings available</p> "; }//if else { $res=sql_execute($sql_query,'res'); while($lst=mysql_fetch_object($res)){ $date=date("m/d",$lst->added); echo "$date <img src='images/icon_listing.gif'> <a href='index.php?mode=listing&act=show&lst_id=$lst->lst_id'>$lst->title</a>"; $c_name=get_cat_name($lst->cat_id); echo " (<a href='index.php?mode=listing&act=show_cat&cat_id=$lst->cat_id'>$c_name</a>) - "; show_online($lst->mem_id); echo "</br>"; }//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 <img src='images/icon_listing.gif'> <a href='index.php?mode=listing&act=show&lst_id=$lst->lst_id'>$lst->title</a>"; $c_name=get_cat_name($lst->cat_id); echo " (<a href='index.php?mode=listing&act=show_cat&cat_id=$lst->cat_id'> $c_name</a>) - ";show_online($lst->mem_id); echo "</br>"; }//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 <img src='images/icon_listing.gif'> <a href='index.php?mode=listing&act=show&lst_id=$lst->lst_id'>$lst->title</a> "; if($lst->anonim!='y'){ show_online($lst->mem_id);echo " - "; } else{ echo "anonymous"; } echo find_relations($m_id,$lst->mem_id); echo "</br>"; }//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 <img src='images/icon_listing.gif'> <a href='index.php?mode=listing&act=show&lst_id=$lst->lst_id'>$lst->title</a> "; if($lst->anonim!='y'){ show_online($lst->mem_id); } else{ echo "anonymous"; } echo " - ";echo find_relations($m_id,$lst->mem_id); echo "</br>"; }//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 <img src='images/icon_listing.gif'> <a href='index.php?mode=listing&act=show&lst_id=$lst->lst_id'>$lst->title</a>"; $c_name=trim(get_cat_name($lst->cat_id)); echo " (<a href='index.php?mode=listing&act=show_cat&cat_id=$lst->cat_id'>$c_name</a>) - "; show_online($lst->mem_id); echo "</br>"; }//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)."<img src='images/icon_arrow_blue.gif' border=0>You"; }//if //2 degree else { $friend=count_network($mem_id,"2","ar"); if(is_array($friend)&&in_array($frd_id,$friend)){ $deg2=count_network($frd_id,"1","ar"); $my=count_network($mem_id,"1","ar"); if(count($my)<count($deg2)){ $result=array_intersect($my,$deg2); } else{ $result=array_intersect($deg2,$my); } show_online($frd_id);echo "<img src='images/icon_arrow_blue.gif' border=0>"; show_online($result[0]);echo "<img src='images/icon_arrow_blue.gif' border=0>You"; }//if //3 degree else{ $friend=count_network($mem_id,"3","ar"); if(is_array($friend)&&in_array($frd_id,$friend)){ $deg1=count_network($frd_id,"1","ar"); $my2=count_network($mem_id,"2","ar"); if(count($my2)<count($deg1)){ $result=array_intersect($my2,$deg1); } else{ $result=array_intersect($deg1,$my2); } $deg2=count_network($frd_id,"2","ar"); $my=count_network($mem_id,"1","ar"); if(count($my)<count($deg2)){ $result2=array_intersect($my,$deg2); } else{ $result2=array_intersect($deg2,$my); } foreach($result2 as $one){ if($one!=''){ $last=$one; break; }//if }//foreach show_online($frd_id);echo "<img src='images/icon_arrow_blue.gif' border=0>"; show_online($result[0]);echo "<img src='images/icon_arrow_blue.gif' border=0>"; show_online($last);echo "<img src='images/icon_arrow_blue.gif' border=0>You"; }//if //4 degree else{ $friend=count_network($mem_id,"4","ar"); if(is_array($friend)&&in_array($frd_id,$friend)){ $deg1=count_network($frd_id,"1","ar"); $my3=count_network($mem_id,"3","ar"); if(count($my3)<count($deg1)){ $result=array_intersect($my3,$deg1); } else{ $result=array_intersect($deg1,$my3); } $deg2=count_network($frd_id,"2","ar"); $my2=count_network($mem_id,"2","ar"); if(count($my2)<count($deg2)){ $result1=array_intersect($my2,$deg2); } else{ $result1=array_intersect($deg2,$my2); } $deg3=count_network($frd_id,"3","ar"); $my1=count_network($mem_id,"1","ar"); if(count($my1)<count($deg3)){ $result2=array_intersect($my1,$deg3); } else{ $result2=array_intersect($deg3,$my1); } foreach($result2 as $one){ if($one!=''){ $last=$one; break; }//if }//foreach show_online($frd_id);echo "<img src='images/icon_arrow_blue.gif' border=0>"; show_online($result[0]);echo "<img src='images/icon_arrow_blue.gif' border=0>"; show_online($result1[0]);echo "<img src='images/icon_arrow_blue.gif' border=0>"; show_online($last);echo "<img src='images/icon_arrow_blue.gif' border=0>You"; }//if //no connection else{ echo "No connections between You and ";show_online($frd_id); }//else }//else }//else }//else }//else }//function //searching zip codes within specified radius function inradius($zip,$radius) { $sql_query="SELECT * FROM zipData WHERE zipcode='$zip'"; $num=sql_execute($sql_query,'num'); if($num==0){ return "not found"; }//if else { $zp=sql_execute($sql_query,'get'); $lat=$zp->lat; $lon=$zp->lon; $sql_query="SELECT zipcode FROM zipData WHERE (POW((69.1*(lon-\"$lon\")*cos($lat/57.3)),\"2\")+POW((69.1*(lat-\"$lat\")),\"2\"))<($radius*$radius) "; $num2=sql_execute($sql_query,'num'); if($num2>0){ $res=sql_execute($sql_query,'res'); $i=0; while($found=mysql_fetch_object($res)) { $zipArray[$i]=$found->zipcode; $i++; }//while }//if else { return "no result"; }//else }//else return $zipArray; } // end func //showing one user friends function show_friends($m_id,$limit,$inline,$page){ $friends=count_network($m_id,"1","ar"); 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 "<tr>"; }//if echo "<td width=65 height=75><table class='table-photo'>"; echo "<tr><td align=center width=65>"; show_photo($frd); echo "</td> <tr><td align=center>"; show_online($frd); echo "</td></table></td>"; }//foreach }//if else { echo "<p align=center>No friends.</p>"; }//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="<a href='index.php?mode=people_card&act=friends&p_id=$id&page="; $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//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="<a href='index.php?mode=user&act=friends_view&pro=2&page="; $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//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="<a href='index.php?mode=user&act=friends_view&pro=3&page="; $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//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="<a href='index.php?mode=user&act=friends_view&pro=4&page="; $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//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="<a href='index.php?mode=user&act=friends_view&pro=all&page="; $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//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; }//if else { $pages=(int)($members/$limit)+1; }//else $first="<a href='index.php?mode=tribe&act=view_mems&trb_id=$id&page="; $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//for echo "   "; if($pages!=$page){ echo $first.($page+1).$mid.">".$last." "; }//if echo $first.$pages.$mid.">>".$last." "; }//if }//if //spliting category listings list elseif($type=='cat'){ $sql_query="select * from listings where cat_id='$id' and stat='a'"; $listings=sql_execute($sql_query,'num'); if($listings!='0'){ if($listings%$limit==0){ $pages=$listings/$limit; }//if else { $pages=(int)($listings/$limit)+1; }//else $first="<a href='index.php?mode=listing&act=show_cat&cat_id=$id&page="; $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//for echo "   "; if($pages!=$page){ echo $first.($page+1).$mid.">".$last." "; }//if echo $first.$pages.$mid.">>".$last." "; }//if }//if //spliting sub-category listings list elseif($type=='sub_cat'){ $sql_query="select * from listings where sub_cat_id='$id' and stat='a'"; $listings=sql_execute($sql_query,'num'); if($listings!='0'){ if($listings%$limit==0){ $pages=$listings/$limit; }//if else { $pages=(int)($listings/$limit)+1; }//else $first="<a href='index.php?mode=listing&act=show_sub_cat&sub_cat_id=$id&page="; $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//for echo "   "; if($pages!=$page){ echo $first.($page+1).$mid.">".$last." "; }//if echo $first.$pages.$mid.">>".$last." "; }//if }//if //spliting user's photos list elseif($type=='photo_album'){ $sql_query="select photo from photo where mem_id='$id'"; $pho=sql_execute($sql_query,'get'); $phot=split("\|",$pho->photo); $phot=if_empty($phot); $photos=count($phot); if($photos!='0'){ if($photos%$limit==0){ $pages=$photos/$limit; }//if else { $pages=(int)($photos/$limit)+1; }//else $first="<a href='index.php?mode=photo_album&p_id=$id&page="; $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//for echo "   "; if($pages!=$page){ echo $first.($page+1).$mid.">".$last." "; }//if echo $first.$pages.$mid.">>".$last." "; }//if }//if //spliting tribe photo list elseif($type=='tribe_photo_album'){ $sql_query="select photo from tribe_photo where trb_id='$id'"; $pho=sql_execute($sql_query,'get'); $phot=split("\|",$pho->photo); $phot=if_empty($phot); $photos=count($phot); if($photos!='0'){ if($photos%$limit==0){ $pages=$photos/$limit; }//if else { $pages=(int)($photos/$limit)+1; }//else $first="<a href='index.php?mode=photo_album&act=tribe&trb_id=$id&page="; $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//for echo "   "; if($pages!=$page){ echo $first.($page+1).$mid.">".$last." "; }//if echo $first.$pages.$mid.">>".$last." "; }//if }//if //spliting basic search results elseif($type=='basic'){ $first="<a href='index.php?mode=search&act=user&type=basic"; $form_data=array('degrees','distance','zip','fname','lname','email'); while (list($key,$val)=each($form_data)){ ${$val}=form_get("$val"); $first.="&".$val."=".urlencode(${$val}); }//while $first.="&page="; $search=$id; if($search%$limit==0){ $pages=$search/$limit; }//if else { $pages=(int)($search/$limit)+1; }//else $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//for echo "   "; if($pages!=$page){ echo $first.($page+1).$mid.">".$last." "; }//if echo $first.$pages.$mid.">>".$last." "; }//if elseif($type=='tribe_photo_album_edit'){ $sql_query="select photo from tribe_photo where trb_id='$id'"; $pho=sql_execute($sql_query,'get'); $phot=split("\|",$pho->photo); $phot=if_empty($phot); $photos=count($phot); if($photos!='0'){ if($photos%$limit==0){ $pages=$photos/$limit; }//if else { $pages=(int)($photos/$limit)+1; }//else $first="<a href='index.php?mode=tribe&act=manage&trb_id=$id&pro=photos&page="; $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//for echo "   "; if($pages!=$page){ echo $first.($page+1).$mid.">".$last." "; }//if echo $first.$pages.$mid.">>".$last." "; }//if }//if //spliting basic search results //spliting advanced search results elseif($type=='advanced'){ $first="<a href='index.php?mode=search&act=user&type=advanced"; $form_data=array('degrees','gender','distance','zip','fname','lname','email', 'interests','here_for','schools','occupation','company','position', 'only_wp','sort','show','age_from','age_to'); while (list($key,$val)=each($form_data)){ ${$val}=form_get("$val"); $first.="&".$val."=".urlencode(${$val}); }//while $first.="&page="; $search=$id; if($search%$limit==0){ $pages=$search/$limit; }//if else { $pages=(int)($search/$limit)+1; }//else $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//for echo "   "; if($pages!=$page){ echo $first.($page+1).$mid.">".$last." "; }//if echo $first.$pages.$mid.">>".$last." "; }//if //spliting simple search results elseif($type=='simple'){ $ar=array( "interests" , "hometown" , "schools" , "languages" , "books" , "music" , "movies" , "travel" , "clubs" , "position" , "company" , "occupation" , "specialities" ); $first="<a href='index.php?mode=search&act=simple"; foreach($ar as $val){ ${$val}=form_get("$val"); ${$val}=urlencode(${$val}); $first.="&".$val."=".${$val}; } $first.="&page="; $search=$id; if($search%$limit==0){ $pages=$search/$limit; }//if else { $pages=(int)($search/$limit)+1; }//else $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//for echo "   "; if($pages!=$page){ echo $first.($page+1).$mid.">".$last." "; }//if echo $first.$pages.$mid.">>".$last." "; }//if //spliting listings search result elseif($type=='search_lst'){ $first="<a href='index.php?mode=search&act=listing"; $form_data=array('keywords','RootCategory','Category','degree','distance','zip'); while (list($key,$val)=each($form_data)){ ${$val}=form_get("$val"); $first.="&".$val."=".urlencode(${$val}); }//while $first.="&page="; $search=$id; if($search%$limit==0){ $pages=$search/$limit; }//if else { $pages=(int)($search/$limit)+1; }//else $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//for echo "   "; if($pages!=$page){ echo $first.($page+1).$mid.">".$last." "; }//if echo $first.$pages.$mid.">>".$last." "; }//if //spliting tribes search result elseif($type=='search_trb'){ $first="<a href='index.php?mode=search&act=tribe"; $keywords=form_get("keywords"); $first.="&keywords=".urlencode($keywords); $first.="&page="; $search=$id; if($search%$limit==0){ $pages=$search/$limit; }//if else { $pages=(int)($search/$limit)+1; }//else $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//for echo "   "; if($pages!=$page){ echo $first.($page+1).$mid.">".$last." "; }//if echo $first.$pages.$mid.">>".$last." "; }//if //spliting users admin view list if($type=='ad_users'){ $sql_query="select mem_id from members"; $num=sql_execute($sql_query,'num'); $users=$num; if($users!='0'){ if($users%$limit==0){ $pages=$users/$limit; }//if else { $pages=(int)($users/$limit)+1; }//else $first="<a href='admin.php?mode=users_manager&adsess=$id&page="; $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//for echo "   "; if($pages!=$page){ echo $first.($page+1).$mid.">".$last." "; }//if echo $first.$pages.$mid.">>".$last." "; }//if }//if //spliting users admin view list if($type=='banner_list'){ $sql_query="select b_id from banners"; $num=sql_execute($sql_query,'num'); $users=$num; if($users!='0'){ if($users%$limit==0){ $pages=$users/$limit; }//if else { $pages=(int)($users/$limit)+1; }//else $first="<a href='admin.php?mode=banner_manager&adsess=$id&page="; $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//for echo "   "; if($pages!=$page){ echo $first.($page+1).$mid.">".$last." "; }//if echo $first.$pages.$mid.">>".$last." "; }//if }//if //spliting listings admin view list if($type=='ad_listings'){ $sql_query="select lst_id from listings"; $num=sql_execute($sql_query,'num'); $listings=$num; if($listings!='0'){ if($listings%$limit==0){ $pages=$listings/$limit; }//if else { $pages=(int)($listings/$limit)+1; }//else $first="<a href='admin.php?mode=listings_manager&adsess=$id&page="; $mid="'>"; $last="</a>"; 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 "<b>"; } echo $first.$i.$mid."$i".$last." "; if($i==$page){ echo "</b>"; } }//for echo "   "; if($pages!=$page){ echo $first.($page+1).$mid.">".$last." "; }//if echo $first.$pages.$mid.">>".$last." "; }//if }//if }//function //delete item from array function array_unset($ar,$el){ for($i=0;$i<count($ar);$i++){ if($ar[$i]==$el){ unset($ar[$i]); } } return $ar; } //returns category name by category id function get_cat_name($cat_id){ $sql_query="select name from categories where cat_id='$cat_id'"; $cat=sql_execute($sql_query,'get'); return $cat->name; } //showing when user's profile was last updated function show_profile_updated($p_id){ $sql_query="select updated from profiles where mem_id='$p_id'"; $prof=sql_execute($sql_query,'get'); $updated=date("m/d/Y",$prof->updated); return $updated; } //showing profile photo function show_profile_photo($mem_id){ $sql_query="select photo_b_thumb from members where mem_id='$mem_id'"; $mem=sql_execute($sql_query,'get'); if($mem->photo_b_thumb=='no'){ $mem->photo_b_thumb="images/unknownUser.jpg"; } echo "<a href='index.php?mode=photo_album&p_id=$mem_id'><img src='$mem->photo_b_thumb' border=0></a>"; } //showing tribe main photo function show_tribe_photo($trb_id){ $sql_query="select photo_b_thumb from tribes where trb_id='$trb_id'"; $trb=sql_execute($sql_query,'get'); if($trb->photo_b_thumb=='no'){ $trb->photo_b_thumb="images/unknownUser.jpg"; } echo "<a href='index.php?mode=photo_album&act=tribe&trb_id=$trb_id'><img src='$trb->photo_b_thumb' border=0></a>"; } //showing tribe main photo (small) function show_tribe_s_photo($trb_id){ $sql_query="select photo_thumb from tribes where trb_id='$trb_id'"; $trb=sql_execute($sql_query,'get'); if($trb->photo_thumb=='no'){ $trb->photo_thumb="images/unknownUser_th.jpg"; } echo "<a href='index.php?mode=tribe&act=show&trb_id=$trb_id'><img src='$trb->photo_thumb' border=0></a>"; } //showing the link to tribe photo album function tribe_photo_link($trb_id){ $sql_query="select photo_b_thumb,updated from tribe_photo where trb_id='$trb_id'"; $ph=sql_execute($sql_query,'get'); $items=split("\|",$ph->photo_b_thumb); $items=if_empty($items); $items=array_unset($items,'no'); if($items==''){ $num=0; } else { $num=count($items); } if($num!=0){ echo "<a href='index.php?mode=photo_album&act=tribe&trb_id=$trb_id'>$num photos in album</a>"; } else { echo "0 photos in album"; } } //showing link to viewing tribe's members function tribe_members_link($trb_id){ $sql_query="select members from tribes where trb_id='$trb_id'"; $trb=sql_execute($sql_query,'get'); $members=split("\|",$trb->members); $members=if_empty($members); $num=count($members); if($num!=0){echo "<a href='index.php?mode=tribe&act=view_mems&trb_id=$trb_id'>$num Members</a>";} }//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 <span class='action'><a href='index.php?mode=tribe&act=show&trb_id=$trb_id'>read</a></span>"; }//else }//function //returns tribe's members array function tribe_members($trb_id){ $sql_query="select members from tribes where trb_id='$trb_id'"; $trb=sql_execute($sql_query,'get'); //$trb->members=$trb->members."|"; $members=split("\|",$trb->members); //echo $members[0]; $members=if_empty1($members); return $members; }//function //shows tribe members function show_members($trb_id,$limit,$inline,$page){ $members=tribe_members($trb_id); if($members!=''){ $start=($page-1)*$limit; $end=$start+$limit; if($end>count($members)){ $end=count($members); } for($i=$start;$i<$end;$i++){ $frd=$members[$i]; if(($i==0)||($i%$inline==0)) { echo "<tr>"; }//if echo "<td width=65 height=75><table class='table-photo'>"; echo "<tr><td align=center width=65>"; show_photo($frd); echo "</td> <tr><td align=center>"; show_online($frd); echo "</td></table></td>"; }//foreach }//if else { echo "<p align=center>No members.</p>"; }//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 "<tr><td>Topic</td><td>Author</td><td>Replies</td><td>Last Post</td>"; 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 "<tr><td><a href='index.php?mode=tribe&act=board&pro=view&top_id=$brd->top_id&trb_id=$trb_id'>$brd->topic</a></td> <td><a href='index.php?mode=people_card&p_id=$brd->mem_id'>"; echo name_header($brd->mem_id,''); echo "</a></td><td>$num</td><td>$last_post</td>"; }//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 "<a href='index.php?mode=tribe&act=event&pro=view&evn_id=$evn->evn_id&trb_id=$trb_id'>$evn->title</a> $date"; $start_time=date("h:i A",$evn->start_time); if($evn->start_time!='0'){ echo " @ $start_time "; } echo "</br>"; }//while }//function //user friends drop-down list function drop_mem_tribes($mem_id,$sel){ $sql_query="select tribes from members where mem_id='$mem_id'"; $mem=sql_execute($sql_query,'get'); $tribes=split("\|",$mem->tribes); $tribes=if_empty($tribes); if($tribes!=''){ foreach($tribes as $trb){ $sql_query="select name from tribes where trb_id='$trb'"; $name=sql_execute($sql_query,'get'); if($trb==$sel){ echo "<option selected value='$trb'>$name->name\n"; } else { echo "<option value='$trb'>$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){ $sql_query="select members from tribes where trb_id='$trb_id'"; $trb=sql_execute($sql_query,'get'); $members=split("\|",$trb->members); $members=if_empty($members); $link="<span class='action'><a href='index.php?mode=tribe&act=join&trb_id=$trb_id'>join</a></span>"; if($members==''){ echo $link; }//if else { $flag=0; foreach($members as $mem){ if($mem==$mem_id){ $flag=1; break; }//if }//foreach if($flag==0){ echo $link; }//if }//else }//function //checking if user has an access to the tribe (member) function tribe_access_test($mem_id,$trb_id){ $sql_query="select stat from tribes where trb_id='$trb_id'"; $trb=sql_execute($sql_query,'get'); if($trb->stat=='s'){ error_screen(29); }//if $members=tribe_members($trb_id); //print_r($members); //echo $trb_id; $type=tribe_type($trb_id,'get'); $act=form_get("act"); if($type=='priv'){ if(!in_array($mem_id,$members)){ error_screen(11); }//if } if($act!='show'){ if(!in_array($mem_id,$members)){ error_screen(11); }//if }//if }//function //returns tribe category link function tribe_category($trb_id){ $sql_query="select t_cat_id from tribes where trb_id='$trb_id'"; $trb=sql_execute($sql_query,'get'); $sql_query="select name from t_categories where t_cat_id='$trb->t_cat_id'"; $cat=sql_execute($sql_query,'get'); return "<a href='index.php?mode=tribe&act=cat&t_cat_id=$trb->t_cat_id'>$cat->name</a>"; }//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 "<a href='index.php?mode=photo_album&p_id=$mem_id'>$num photos in album</a>"; } else { echo "0 photos in album"; } } //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="<a href='index.php?mode=search&act=simple&interests=".$here_for."'>".$here_for."</a>"; } 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.="<a href='index.php?mode=search&act=simple&interests=".$word."'>".$word."</a>,"; } $interests=rtrim($interest,','); } $hometown=$pro->hometown; if($hometown!=''){ $hometown="<a href='index.php?mode=search&act=simple&hometown=".$hometown."'>".$hometown."</a>"; } $schools=$pro->schools; if($schools!=''){ $split=split(",",$schools); $school=''; foreach($split as $word){ $school.="<a href='index.php?mode=search&act=simple&schools=".$word."'>".$word."</a>,"; } $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 "<tr><td>$key</td><td>$val</td>"; }//if }//while if($groups!=''){ echo "<tr><td>Network Groups</td><td>"; $i=0; foreach($groups as $group){ $sql_query="select name from groups where trb_id='$group'"; $trb=sql_execute($sql_query,'get'); echo "<a href='index.php?mode=group&act=show&trb_id=$group'>$trb->name</a>"; $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.="<a href='index.php?mode=search&act=simple&languages=".$word."'>".$word."</a>,"; } $languages=rtrim($ineterest,','); } $website=$pro->website; if($website!=''){ $website="<a href='".$website."'>".$website."</a>"; } $books=$pro->books; if($books!=''){ $split=split(",",$books); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&books=".$word."'>".$word."</a>,"; } $books=rtrim($ineterest,','); } $music=$pro->music; if($music!=''){ $split=split(",",$music); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&music=".$word."'>".$word."</a>,"; } $music=rtrim($interest,','); } $movies=$pro->movies; if($movies!=''){ $split=split(",",$movies); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&movies=".$word."'>".$word."</a>,"; } $movies=rtrim($interest,','); } $travel=$pro->travel; if($travel!=''){ $split=split(",",$travel); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&travel=".$word."'>".$word."</a>,"; } $travel=rtrim($interest,','); } $clubs=$pro->clubs; if($clubs!=''){ $split=split(",",$clubs); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&clubs=".$word."'>".$word."</a>,"; } $clubs=rtrim($interest,','); } $about=$pro->about; $meet_people=$pro->meet_people; if($meet_people!=''){ $split=split(",",$meet_people); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&interests=".$word."'>".$word."</a>,"; } $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 "<tr><td>$key</td><td>$val</td>"; }//if }//while }//personal //professional elseif($type=="professional"){ $position=$pro->position; if($position!=''){ $position="<a href='index.php?mode=search&act=simple&position=".$position."'>".$position."</a>"; } $company=$pro->company; if($company!=''){ $company="<a href='index.php?mode=search&act=simple&company=".$company."'>".$company."</a>"; } $occupation=$pro->occupation; if($occupation!=''){ $occupation="<a href='index.php?mode=search&act=simple&occupation=".$occupation."'>".$occupation."</a>"; } 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.="<a href='index.php?mode=search&act=simple&specialities=".$word."'>".$word."</a>,"; } $specialities=rtrim($interest,','); } $overview=$pro->overview; $skills=$pro->skills; if($skills!=''){ $split=split(",",$skills); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&skills=".$word."'>".$word."</a>,"; } $skills=rtrim($interest,','); } $p_positions=$pro->p_positions; if($p_positions!=''){ $split=split(",",$p_positions); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&interests=".$word."'>".$word."</a>,"; } $p_positions=rtrim($interest,','); } $p_companies=$pro->p_companies; if($p_companies!=''){ $split=split(",",$p_companies); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&interests=".$word."'>".$word."</a>,"; } $p_companies=rtrim($interest,','); } $assotiations=$pro->assotiations; if($associations!=''){ $split=split(",",$assotiations); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&interests=".$word."'>".$word."</a>,"; } $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 "<tr><td>$key</td><td>$val</td>"; }//if }//while }//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 "<p align=center>";echo name_header($p_id,$m_id);echo " has no testimonials.</p>"; } else { $res=sql_execute($sql_query,'res'); while($tst=mysql_fetch_object($res)){ echo "<table class='body' vasilek><tr><td class=lined>";show_photo($tst->from_id);echo "</br>"; show_online($tst->from_id);echo "</td>"; $date=date("F d, Y",$tst->added); echo "<td valign=top>$date</br>$tst->testimonial</td></table>"; }//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 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); $start=$page*5; $end=count($photos); if($end>count($photos)){ $end=count($photos); }//if if($photos!=''){ echo "<td><table class=lined>"; $p=0; for($i=$start;$i<$end;$i++){ if ($p==0){ echo "<tr>"; } $p++; echo "<td><a href='index.php?mode=photo_album&act=view&pho_id=$i&p_id=$mem_id'><img src='$photos[$i]' border=0></a><br>$captures[$i]"; if($mod=='edi'){ echo "<br><a href='index.php?mode=user&act=del&type=photos&pro=edit&pho_id=$i'>Delete</a>"; } echo "</td>"; if ($p==5){ echo "</tr>"; $p=0; } }//for echo "</table></td>"; }//if else { echo "No photos available"; } }//function function photo_album3($mem_id,$page,$mod){ $p_id=0; $m_id=0; $page=$page-1; $sql_query="select photo_b_thumb,capture 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); $start=$page*5; $end=$start+5; if($end>count($photos)){ $end=count($photos); }//if if($photos!=''){ echo "<td><table class=lined>"; $p=0; for($i=$start;$i<$end;$i++){ if ($p==0){ echo "<tr>"; } $p++; echo "<td><a href='index.php?mode=photo_album&act=view&pho_id=$i&p_id=$mem_id'><img src='$photos[$i]' border=0></a><br>$captures[$i]"; if($mod=='edi'){ echo "<br><a href='index.php?mode=user&act=del&type=photos&pro=edit&pho_id=$i'>Delete</a>"; } echo "</td>"; if ($p==5){ echo "</tr>"; $p=0; } }//for echo "</table></td>"; }//if else { echo "No photos available"; } }//function function photo_album2($mem_id,$page,$mod){ $p_id=0; $m_id=0; $page=$page-1; $sql_query="select photo_b_thumb,capture 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); $start=$page*5; $end=count($photos); if($end>count($photos)){ $end=count($photos); }//if if($photos!=''){ echo "<td><table class=lined>"; $p=0; for($i=$start;$i<$end;$i++){ if ($p==0){ echo "<tr>"; } $p++; echo "<td><a href='index.php?mode=photo_album&act=view&pho_id=$i&p_id=$mem_id'><img src='$photos[$i]' border=0></a><br>$captures[$i]"; if($mod=='edi'){ echo "<br><a href='index.php?mode=user&act=profile&pho_id=$i&pro=edit&type=photos'>Delete</a>"; } echo "</td>"; if ($p==5){ echo "</tr>"; $p=0; } }//for echo "</table></td>"; }//if else { echo "No photos available"; } }//function //showing user photo album function photo_album($mem_id,$page,$mod){ $page=$page-1; $sql_query="select photo_b_thumb,capture 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); $start=$page*6; $end=$start+100000; if($end>count($photos)){ $end=count($photos); }//if if($photos!=''){ for($i=$start;$i<$end;$i++){ if($main->photo_b_thumb==$photos[$i]) $main_set="Main Photo"; echo "<td><table class=lined> <tr><td align='center' class='body'>$main_set<br><a href='index.php?mode=photo_album&act=view&pho_id=$i&p_id=$mem_id'><img src='$photos[$i]' border=0></a></td> <tr><td align='center' class='body'>$captures[$i]</td>"; if($mod=='edi'){ echo "<tr><td align='center' class='body'><a href='index.php?mode=user&act=del&type=photos&pro=edit&pho_id=$i'>Delete</a></td>"; } echo "</table></td>"; $main_set=""; }//for }//if else { echo "No photos available"; } }//function //showing user photo album function photo_album_count($mem_id,$page,$mod){ $page=$page-1; $cou=0; $sql_query="select photo_b_thumb,capture 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); $start=$page*6; $end=$start+1000000; if($end>count($photos)){ $end=count($photos); }//if if($photos!=''){ for($i=$start;$i<$end;$i++){ $cou++; }//for }//if return $cou; }//function //Deleteing user photo album function del_album($mem_id,$page,$mod,$cid){ global $base_path,$main_url; $sql_query="select photo,photo_b_thumb,photo_thumb,capture 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'); $photo_b_thumb=split("\|",$pho->photo_b_thumb); $photo=split("\|",$pho->photo); $photo_thumb=split("\|",$pho->photo_thumb); $pho_cou=count($photo); $photo_b_thumb=if_empty($photo_b_thumb); $photo=if_empty($photo); $photo_thumb=if_empty($photo_thumb); $capture=split("\|",$pho->capture); $capture=if_empty($capture); if($pho_cou!=0){ sql_execute($sql_query,''); for($i=0;$i<$pho_cou;$i++){ if($i!=$cid) { $photo_up.="|".$photo[$i]; $photo_b_thumb_up.="|".$photo_b_thumb[$i]; $photo_thumb_up.="|".$photo_thumb[$i]; $capture_up.="|".$capture[$i]; } else { if(file_exists("$base_path/$photos[$i]")){ @unlink("$base_path/$photos[$i]"); } } if($i!=$cid) { if($main->photo_b_thumb==$photos[$i]) { $sql_query="update members set photo='',photo_thumb='',photo_b_thumb='' where mem_id='$m_id'"; sql_execute($sql_query,''); } } }//for $sql_query="update photo set photo='".$photo_up."',photo_b_thumb='".$photo_b_thumb_up."', photo_thumb='".$photo_thumb_up."',capture='".$capture_up."' where mem_id='$mem_id'"; // echo $sql_query; sql_execute($sql_query,''); }//if }//function function del_album1($mem_id,$page,$mod,$cid){ global $base_path,$main_url; $sql_query="select photo,photo_b_thumb,photo_thumb,capture from tribe_photo where trb_id='$mem_id'"; // echo $sql_query; $pho=sql_execute($sql_query,'get'); $sql_query="select photo_b_thumb from tribes where trb_id='$mem_id'"; $main=sql_execute($sql_query,'get'); $photo_b_thumb=split("\|",$pho->photo_b_thumb); $photo=split("\|",$pho->photo); $photo_thumb=split("\|",$pho->photo_thumb); $pho_cou=count($photo); // $photo_b_thumb=if_empty($photo_b_thumb); // $photo=if_empty($photo); // $photo_thumb=if_empty($photo_thumb); $capture=split("\|",$pho->capture); // $capture=if_empty($capture); if($pho_cou!=0){ sql_execute($sql_query,''); for($i=0;$i<$pho_cou;$i++){ if($i!=$cid) { $photo_up.="|".$photo[$i]; $photo_b_thumb_up.="|".$photo_b_thumb[$i]; $photo_thumb_up.="|".$photo_thumb[$i]; $capture_up.="|".$capture[$i]; } else { if(file_exists("$base_path/$photos[$i]")){ @unlink("$base_path/$photos[$i]"); } } if($i!=$cid) { if($main->photo_b_thumb==$photos[$i]) { $sql_query="update tribes set photo='',photo_thumb='',photo_b_thumb='' where trb_id='$m_id'"; sql_execute($sql_query,''); } } }//for $sql_query="update tribe_photo set photo='".$photo_up."',photo_b_thumb='".$photo_b_thumb_up."', photo_thumb='".$photo_thumb_up."',capture='".$capture_up."' where trb_id='$mem_id'"; // echo $sql_query; sql_execute($sql_query,''); }//if }//function //showing tribe photo album function tribe_photo_album1($trb_id,$page){ $page=$page-1; $sql_query="select photo_b_thumb,capture from tribe_photo where trb_id='$trb_id'"; $pho=sql_execute($sql_query,'get'); $sql_query="select photo_b_thumb from tribes where trb_id='$trb_id'"; $main=sql_execute($sql_query,'get'); $photos=split("\|",$pho->photo_b_thumb); $photos=if_empty($photos); $photos=array_unset($photos,"no"); $captures=split("\|",$pho->capture); $captures=if_empty($captures); $start=$page*5; $end=count($photos); if($end>count($photos)){ $end=count($photos); }//if if($photos!=''){ echo "<td><table class=lined>"; $p=0; for($i=$start;$i<$end;$i++){ if ($p==0){ echo "<tr>"; } $p++; echo "<td><a href='index.php?mode=photo_album&act=view&pho_id=$i&p_id=$mem_id'><img src='$photos[$i]' border=0></a><br>$captures[$i]<br> <a href='?mode=tribe&act=manage&trb_id=$trb_id&pro=photos&del=$photos[$i]'>Delete</a></td>"; echo "</td>"; if ($p==5){ echo "</tr>"; $p=0; } }//for echo "</table></td>"; }//if else { echo "No photos available"; } }//function function tribe_photo_album2($trb_id,$page){ $page=$page-1; $sql_query="select photo_b_thumb,capture from tribe_photo where trb_id='$trb_id'"; $pho=sql_execute($sql_query,'get'); $sql_query="select photo_b_thumb from tribes where trb_id='$trb_id'"; $main=sql_execute($sql_query,'get'); $photos=split("\|",$pho->photo_b_thumb); $photos=if_empty($photos); //print_r($photos); $photos=array_unset($photos,"no"); $captures=split("\|",$pho->capture); $captures=if_empty($captures); //print_r($captures); $start=$page*5; $end=count($photos); if($end>count($photos)){ $end=count($photos); }//if $ii=0; if($photos!=''){ echo "<td><table class=lined>"; $p=0; for($i=$start;$i<$end;$i++){ $ii++; if($photos[$i]){ if ($p==0){ echo "<tr>"; } $p++; //$ii=$i-1; echo "<td><a href='index.php?mode=photo_album&act=trb_view&pho_id=$i&trb_id=$trb_id'><img src='$photos[$i]' border=0></a><br>$captures[$i]<br> <a href='?mode=tribe&act=manage&trb_id=$trb_id&pro=photos&del=$photos[$i]'>Delete</a></td>"; echo "</td>"; if ($p==5){ echo "</tr>"; $p=0; } } } //for echo "</table></td>"; }//if else { echo "No photos available"; } }//function function tribe_photo_album($trb_id,$page){ $page=$page-1; $sql_query="select photo_b_thumb,capture from tribe_photo where trb_id='$trb_id'"; $pho=sql_execute($sql_query,'get'); $sql_query="select photo_b_thumb from tribes where trb_id='$trb_id'"; $main=sql_execute($sql_query,'get'); $photos=split("\|",$pho->photo_b_thumb); $photos=if_empty($photos); $photos=array_unset($photos,"no"); $captures=split("\|",$pho->capture); $captures=if_empty($captures); $start=$page*5; $end=$start+5; if($end>count($photos)){ $end=count($photos); }//if if($photos!=''){ for($i=$start;$i<$end;$i++){ echo "<td><table class=lined> <tr><td><a href='index.php?mode=photo_album&act=trb_view&pho_id=$i&trb_id=$trb_id'><img src='$photos[$i]' border=0></a></td> <tr><td align=center>$captures[$i]</td> </table></td>"; }//for }//if else { echo "No photos available."; } }//function //drop-down list of user friends function drop_friends($mem_id){ $fr=count_network($mem_id,"1","ar"); echo "<option value=''>-- 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 "<option value='$frd'>$f->fname"; }//foreach }//if }//function function drop_friends1($mem_id,$ti){ $fr=count_network($mem_id,"1","ar"); echo "<option value=''>-- 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 "<option value='$frd'>$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 "<option selected value='$cat->t_cat_id'>$cat->name"; }//if else { echo "<option value='$cat->t_cat_id'>$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 "<option"; if($ind->ind_id=="$sel"){ echo " selected"; } echo " value='$ind->ind_id'>"; if(!ereg("_",$ind->name)){ echo " "; } echo "$ind->name</option>"; }//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 "<tr>"; }//if echo "<td width=65 height=75><table class='table-photo'>"; echo "<tr><td align=center width=65>"; show_photo($frd); echo "</td> <tr><td align=center>"; show_online($frd); echo "</td></table></td>"; }//foreach }//if else { echo "<p align=center>No friends.</p>"; }//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){ // This function can undo the Win32 error to calculate datas before 1-1-1970 (by TOTH = igtoth@netsite.com.br) // For centuries, the Egyptians used a (12 * 30 + 5)-day calendar // The Greek began using leap-years in around 400 BC // Ceasar adjusted the Roman calendar to start with Januari rather than March // All knowledge was passed on by the Arabians, who showed an error in leaping // In 1232 Sacrobosco (Eng.) calculated the error at 1 day per 288 years // In 1582, Pope Gregory XIII removed 10 days (Oct 15-24) to partially undo the // error, and he instituted the 400-year-exception in the 100-year-exception, // (notice 400 rather than 288 years) to undo the rest of the error // From about 2044, spring will again coincide with the tropic of Cancer // Around 4100, the calendar will need some adjusting again 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)."<img src='images/icon_arrow_blue.gif' border=0>You"; }//if //2 degree else { $friend=count_network($mem_id,"2","ar"); if(is_array($friend)&&in_array($frd_id,$friend)){ $deg2=count_network($frd_id,"1","ar"); $my=count_network($mem_id,"1","ar"); if(count($my)<count($deg2)){ $result=array_intersect($my,$deg2); } else{ $result=array_intersect($deg2,$my); } show_online($frd_id);$result=$result."<img src='images/icon_arrow_blue.gif' border=0>"; show_online($result[0]);$result=$result."<img src='images/icon_arrow_blue.gif' border=0>You"; }//if //3 degree else{ $friend=count_network($mem_id,"3","ar"); if(is_array($friend)&&in_array($frd_id,$friend)){ $deg1=count_network($frd_id,"1","ar"); $my2=count_network($mem_id,"2","ar"); if(count($my2)<count($deg1)){ $result=array_intersect($my2,$deg1); } else{ $result=array_intersect($deg1,$my2); } $deg2=count_network($frd_id,"2","ar"); $my=count_network($mem_id,"1","ar"); if(count($my)<count($deg2)){ $result2=array_intersect($my,$deg2); } else{ $result2=array_intersect($deg2,$my); } foreach($result2 as $one){ if($one!=''){ $last=$one; break; }//if }//foreach show_online($frd_id);$result=$result."<img src='images/icon_arrow_blue.gif' border=0>"; show_online($result[0]);$result=$result."<img src='images/icon_arrow_blue.gif' border=0>"; show_online($last);$result=$result."<img src='images/icon_arrow_blue.gif' border=0>You"; }//if //4 degree else{ $friend=count_network($mem_id,"4","ar"); if(is_array($friend)&&in_array($frd_id,$friend)){ $deg1=count_network($frd_id,"1","ar"); $my3=count_network($mem_id,"3","ar"); if(count($my3)<count($deg1)){ $result=array_intersect($my3,$deg1); } else{ $result=array_intersect($deg1,$my3); } $deg2=count_network($frd_id,"2","ar"); $my2=count_network($mem_id,"2","ar"); if(count($my2)<count($deg2)){ $result1=array_intersect($my2,$deg2); } else{ $result1=array_intersect($deg2,$my2); } $deg3=count_network($frd_id,"3","ar"); $my1=count_network($mem_id,"1","ar"); if(count($my1)<count($deg3)){ $result2=array_intersect($my1,$deg3); } else{ $result2=array_intersect($deg3,$my1); } foreach($result2 as $one){ if($one!=''){ $last=$one; break; }//if }//foreach show_online($frd_id);$result=$result."<img src='images/icon_arrow_blue.gif' border=0>"; show_online($result[0]);$result=$result."<img src='images/icon_arrow_blue.gif' border=0>"; show_online($result1[0]);$result=$result."<img src='images/icon_arrow_blue.gif' border=0>"; show_online($last);$result=$result."<img src='images/icon_arrow_blue.gif' border=0>You"; }//if //no connection else{ $result=$result."No connections between You and ";show_online($frd_id); }//else }//else }//else }//else }//else return $result; }//function function show_profile_pc($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="<a href='index.php?mode=search&act=simple&interests=".$here_for."'>".$here_for."</a>"; } 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.="<a href='index.php?mode=search&act=simple&interests=".$word."'>".$word."</a>,"; } $interests=rtrim($interest,','); } $hometown=$pro->hometown; if($hometown!=''){ $hometown="<a href='index.php?mode=search&act=simple&interests=".$hometown."'>".$hometown."</a>"; } $schools=$pro->schools; if($schools!=''){ $split=split(",",$schools); $school=''; foreach($split as $word){ $school.="<a href='index.php?mode=search&act=simple&interests=".$word."'>".$word."</a>,"; } $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 "<tr><td bgcolor='#ffffff'>$key</td><td bgcolor='#ffffff'><font color='#000000'><span class='namelink-offline'>$val</span></font></td></tr>"; }//if }//while if($tribes!=''){ echo "<tr><td bgcolor='#ffffff'>Groups</td><td bgcolor='#ffffff'><span class='namelink-offline'>"; $i=0; foreach($tribes as $tribe){ $sql_query="select name from tribes where trb_id='$tribe'"; $trb=sql_execute($sql_query,'get'); echo "<span class='namelink-offline'><a href='index.php?mode=tribe&act=show&trb_id=$tribe'>$trb->name</a></span>"; $i++; if($i!=count($tribes)){ echo ", "; } } } }//basic //personal elseif($type=="personal"){ $languages=$pro->$pro->languages; if($languages!=''){ $split=split(",",$ineterests); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&languages=".$word."'>".$word."</a>,"; } $languages=rtrim($ineterest,','); } $website=$pro->website; if($website!=''){ if(strpos($website,"ttp:")){ $website="<a href='".$website."'>".$website."</a>";}else{ $website="<a href='http://".$website."'>".$website."</a>"; } } $books=$pro->books; if($books!=''){ $split=split(",",$books); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&books=".$word."'>".$word."</a>,"; } $books=rtrim($ineterest,','); } $music=$pro->music; if($music!=''){ $split=split(",",$music); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&music=".$word."'>".$word."</a>,"; } $music=rtrim($interest,','); } $movies=$pro->movies; if($movies!=''){ $split=split(",",$movies); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&movies=".$word."'>".$word."</a>,"; } $movies=rtrim($interest,','); } $travel=$pro->travel; if($travel!=''){ $split=split(",",$travel); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&travel=".$word."'>".$word."</a>,"; } $travel=rtrim($interest,','); } $clubs=$pro->clubs; if($clubs!=''){ $split=split(",",$clubs); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&clubs=".$word."'>".$word."</a>,"; } $clubs=rtrim($interest,','); } $about=$pro->about; $meet_people=$pro->meet_people; if($meet_people!=''){ $split=split(",",$meet_people); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&meet_people=".$word."'>".$word."</a>,"; } $meet_people=rtrim($interest,','); } $hobby=$pro->hobby; if($hobby!=''){ $split=split(",",$hobby); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&hobby=".$word."'>".$word."</a>,"; } $hobby=rtrim($interest,','); } $status=$pro->status; if($status!=''){ $split=split(",",$status); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&status=".$word."'>".$word."</a>,"; } $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 "<tr><td bgcolor='#ffffff'>$key</td><td bgcolor='#ffffff'><span class='namelink-offline'>$val</span></td></tr>"; }//if }//while }//personal //professional elseif($type=="professional"){ $position=$pro->position; if($position!=''){ $position="<a href='index.php?mode=search&act=simple&interests=".$position."'>".$position."</a>"; } $company=$pro->company; if($company!=''){ $company="<a href='index.php?mode=search&act=simple&interests=".$company."'>".$company."</a>"; } $occupation=$pro->occupation; if($occupation!=''){ $occupation="<a href='index.php?mode=search&act=simple&interests=".$occupation."'>".$occupation."</a>"; } 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.="<a href='index.php?mode=search&act=simple&specialities=".$word."'>".$word."</a>,"; } $specialities=rtrim($interest,','); } $overview=$pro->overview; $skills=$pro->skills; if($skills!=''){ $split=split(",",$skills); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&skills=".$word."'>".$word."</a>,"; } $skills=rtrim($interest,','); } $p_positions=$pro->p_positions; if($p_positions!=''){ $split=split(",",$p_positions); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&p_positions=".$word."'>".$word."</a>,"; } $p_positions=rtrim($interest,','); } $p_companies=$pro->p_companies; if($p_companies!=''){ $split=split(",",$p_companies); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&p_companies=".$word."'>".$word."</a>,"; } $p_companies=rtrim($interest,','); } $assotiations=$pro->assotiations; if($associations!=''){ $split=split(",",$assotiations); $interest=''; foreach($split as $word){ $interest.="<a href='index.php?mode=search&act=simple&associations=".$word."'>".$word."</a>,"; } $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 "<tr><td bgcolor='#ffffff'>$key</td><td bgcolor='#ffffff'><span class='namelink-offline'>$val</span></td></tr>"; }//if }//while }//professional }//function function show_friends1($m_id,$limit,$inline,$page){ /*$sql_query="select limitsim from members where mem_id=$m_id"; $lim=sql_execute($sql_query,'get'); $limit=$lim->limits; switch ($limit) { case 0: $limit=4; break; case 1: $limit=3; break; case 2: $limit=2; break; case 3: $limit=1; break; } echo $limit."!!!!!!!!!!!"; */ $friends=count_network($m_id,"all","ar"); if($friends!=''){ $start=($page-1)*$limit; $end=$start+$limit; if($end>count($friends)){ $end=count($friends); } for($i1=$start;$i1<$end;$i1++){ $frd=$friends[$i1]; if(($i1==0)||($i1%$inline==0)){}//if echo "<!--"; $n=connections1($m_id,$frd); echo "-->"; $f=1; $i=0; do { $pos=strpos($n,"icon_arrow_blue.gif"); if ($pos){ $n = substr ($n,$pos+1); $i++; }else {$f=0;} }while($f==1); //echo $i; $sql_query="select limitsim from members where mem_id=$frd"; $lim=sql_execute($sql_query,'get'); $limit=$lim->limitsim; switch ($limit) { case 0: $limit=4; break; case 1: $limit=3; break; case 2: $limit=2; break; case 3: $limit=1; break; } if ($i==0){$i=4;} if ( $i <=$limit){ show_online1($frd);} }//foreach }//if else { echo "<p align=center>No friends.</p>"; }//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 "<option value='$mem->mem_id'>$mem->fname</option>"; $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)); if (($dif<8) and ($dif>0)){ } } else{ echo "<option value='$mem->mem_id'>$mem->fname</option>"; $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)); if (($dif<8) and ($dif>0)){ } } } //showing user main photo ?>[/PHP] line 28 IS [PHP]return mysql_num_rows($sql_res); [/PHP] |
| ||
| Re: I NEED HELP PLEASE:Warning: mysql_num_rows(): Isnt this a continuation of a previous thread? Check to see if mysql_num_rows is a valid resource and base youre returned value on that |
| All times are GMT -4. The time now is 2:50 am. |
Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC