Teil 1 der function.php
<?php
//CHECK HOTORNOT ADMINISTRATOR LOGIN
function chk_admin_login()
{
global $config;
if($_SESSION['AUID']!=$config['admin_name'] || $_SESSION['APASSWORD']!=$config['admin_pass'])
{
header("Location:$config[baseurl]/siteadmin/login.php");
exit;
}
}
//CHECK HOTORNOT MEMBER LOGIN
function chk_member_login($viewkey="")
{
global $config,$conn;
$sql="select * from signup where UID=$_SESSION[UID]";
$rs=$conn->execute($sql);
if($_SESSION['UID']=="" || $_SESSION['EMAIL']=="" || $rs->recordcount()==0)
{
$q = "";
while(list($k,$v)=each($_GET)){$q.="&$k=$v";}
$q=base64_encode($q);
if($q!="")$add="&add=$q";
$temp=$_SERVER['PHP_SELF'];
$path=explode("/",$temp);
$page=$path[count($path)-1];
$page=str_replace(".php","",$page);
header("Location:$config[baseurl]/signup.php?next=$page$add");
exit;
}
}
function session_to_db()
{
global $conn;
$sql="select * from signup where UID=$_SESSION[UID]";
$rs=$conn->execute($sql);
if($rs->recordcount()>0)
{
$_SESSION[EMAILVERIFIED]=$rs->fields['emailverified'];
}
}
//MAIL FUNCTIION
function mailing($to,$name,$from,$subj,$body,$bcc="") {
$headers="";
global $SERVER_NAME;
$subj=nl2br($subj);
$body=nl2br($body);
$recipient = $to;
if($bcc!="") $headers = "Bcc: " . $bcc."\n";
$headers .= "From: " . $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");
}
//EMAIL VERIFICATION
function isMailVerified()
{
global $config;
if($_SESSION[EMAILVERIFIED]=="no")header("Location:$config[baseurl]/confirm_email.php");
}
function is_commented($vid)
{
global $config,$conn;
$sql="select count(*) as cnt from comments WHERE VID=$vid and UID=$_SESSION[UID]";
$rs=$conn->execute($sql);
if($rs->fields[cnt]>0) return "yes";
}
function is_video_commented($vid)
{
global $config,$conn;
$sql="select be_comment from video WHERE VID=$vid";
$rs=$conn->execute($sql);
return $rs->fields['be_comment'];
}
function is_video_rated($vid)
{
global $config,$conn;
$sql="select be_rated from video WHERE VID=$vid";
$rs=$conn->execute($sql);
return $rs->fields['be_rated'];
}
function is_video_embabed($vid)
{
global $config,$conn;
$sql="select embed from video WHERE VID=$vid";
$rs=$conn->execute($sql);
return $rs->fields['embed'];
}
//SOME YEARS CONSTRUCTION
function years($sel="")
{
$year="";
$init=date("Y");
for($i=1900;$i<=$init;$i++)
{
if($i==$sel)
$year.="<option value='$i' selected>$i</option>";
else
$year.="<option value='$i'>$i</option>";
}
return $year;
}
//SOME MONTHS CONSTRUCTION
function months($sel=""){
$month="";
$months=array("January","February","March","April","May","June","July","August","September","October","November","December");
for($i=1;$i<=12;$i++)
{
if($i==$sel){
$month.="<option value='$i' selected>$i</option>";
}
else{
$month.="<option value='$i'>$i</option>";
}
}
return $month;
}
//SOME DAYS CONSTRUCTION
function days($sel="")
{
$day="";
for($i=1;$i<=31;$i++)
{
if($i==$sel){
$day.="<option value='$i' selected>$i</option>";
}
else{
$day.="<option value='$i'>$i</option>";
}
}
return $day;
}
//Populate country
function country_box($sel=""){
$coun="";
$country=array("United States","Afghanistan","Albania","Algeria","American Samoa","Andorra","Angola","Anguilla","Antartica","Antigua and Barbuda","Argentina","Armenia","Aruba","Ascension Island","Australia","Austria","Azerbaijan","Bahamas","Bahrain","Bangladesh","Barbados","Belarus","Belgium","Belize","Benin","Bermuda","Bhutan","Bolivia","Botswana","Bouvet Island","Brazil","Brunei Darussalam","Bulgaria","Burkina Faso","Burundi","Cambodia","Cameroon","Canada","Cape Verde Islands","Cayman Islands","Chad","Chile","China","Christmas Island","Colombia","Comoros","Cook Islands","Costa Rica","Cote d Ivoire","Croatia/Hrvatska","Cyprus","Czech Republic","Denmark","Djibouti","Dominica","Dominican Republic","East Timor","Ecuador","Egypt","El Salvador","Equatorial Guinea","Eritrea","Estonia","Ethiopia","Falkland Islands","Faroe Islands","Fiji","Finland","France","French Guiana","French Polynesia","Gabon","Gambia","Georgia","Germany","Ghana","Gibraltar","Greece","Greenland","Grenada","Guadeloupe","Guam","Guatemala","Guernsey","Guinea","Guinea-Bissau","Guyana","Haiti","Honduras","Hong Kong","Hungary","Iceland","India","Indonesia","Iran","Ireland","Isle of Man","Israel","Italy", "Jamaica", "Japan", "Jersey", "Jordan", "Kazakhstan", "Kenya", "Kiribati", "Korea", "Kuwait", "Kyrgyzstan", "Laos", "Latvia", "Lebanon", "Lesotho", "Liberia", "Libya", "Liechtenstein", "Lithuania", "Luxembourg", "Macau", "Macedonia", "Madagascar", "Malawi", "Malaysia", "Maldives", "Mali", "Malta", "Marshall Islands", "Martinique", "Mauritania", "Mauritius", "Mayotte Island", "Mexico", "Micronesia", "Moldova", "Monaco", "Mongolia", "Montserrat", "Morocco", "Mozambique", "Myanmar", "Namibia", "Nauru", "Nepal", "Netherlands", "Netherlands Antilles", "New Caledonia", "New Zealand", "Nicaragua", "Niger", "Nigeria", "Niue", "Norfolk Island", "Norway", "Oman", "Pakistan", "Palau", "Panama", "Papua New Guinea", "Paraguay", "Peru", "Philippines", "Pitcairn Island", "Poland", "Portugal", "Puerto Rico", "Qatar", "Reunion Island", "Romania", "Russian Federation", "Rwanda", "Saint Helena", "Saint Lucia", "San Marino", "Saudi Arabia", "Senegal", "Seychelles", "Sierra Leone", "Singapore", "Slovak Republic", "Slovenia", "Solomon Islands", "Somalia", "South Africa", "South Georgia", "Spain", "Sri Lanka", "Suriname", "Svalbard", "Swaziland", "Sweden", "Switzerland", "Syria", "Taiwan", "Tajikistan", "Tanzania", "Thailand", "Togo", "Tokelau", "Tonga Islands", "Tunisia", "Turkey", "Turkmenistan", "Tuvalu", "Uganda", "Ukraine", "United Kingdom", "Uruguay", "Uzbekistan", "Vanuatu", "Vatican City", "Venezuela", "Vietnam", "Western Sahara", "Western Samoa", "Yemen", "Yugoslavia", "Zambia","Zimbabwe");
for($i=0;$i<count($country);$i++)
{
if($sel==$country[$i])
$coun .="<option value='$country[$i]' selected>$country[$i]</option>";
else
$coun .="<option value='$country[$i]'>$country[$i]</option>";
}
return $coun;
}
//DROP STATE
function state_drop($sel="")
{
$coun="";
$state = array("Alabama", "Alaska", "Arizona", "Arkansas", "California", "Colorado", "Connecticut", "Delaware", "District of Columbia", "Florida", "Georgia", "Hawaii", "Idaho", "Illinois", "Indiana", "Iowa", "Kansas", "Kentucky", "Louisiana", "Maine", "Maryland", "Massachusetts", "Michigan", "Minnesota", "Mississippi", "Missouri", "Montana", "Nebraska", "Nevada", "New Jersey", "New Mexico", "New York", "North Carolina", "North Dakota", "Ohio", "Oklahoma", "Oregon", "Pennsylvania", "Rhode Island", "South Carolina", "South Dakota", "Tennessee", "Texas", "Utah", "Vermont", "Virginia", "Washington", "West Virginia", "Wisconsin", "Wyoming", "Others");
for($i=0;$i<count($state);$i++)
{
if($sel==$state[$i])
$coun .="<option value='$state[$i]' selected>$state[$i]</option>";
else
$coun .="<option value='$state[$i]'>$state[$i]</option>";
}
return $coun;
}
//REDIRECT PAGE USING JAVASCRIPT
function redirect($link)
{
echo "<script language=Javascript>
document.location.href='$link';
</script>";
}
function video_to_frame($fpath,$name,$mov,$chnl)
{
global $config;
$frcount=$mov->getFrameCount()-1;
$try = 1;
$fc = 1;
while(1)
{
$p = rand(1,$frcount);
$ff_frame= $mov->getFrame($p);
if($ff_frame==true)
{
$gd_image = $ff_frame->toGDImage();
$ff=$config['TMB_DIR']."/".$name.".jpg";
imagejpeg($gd_image, $ff);
$fd=$config['TMB_DIR']."/".$fc."_".$name.".jpg";
createThumb($ff,$fd,$config['img_max_width'],$config['img_max_height']);
$fc++;
}
$try++;
if($try>10 || $fc==4)
break;
}
}
function createThumb($srcname,$destname,$maxwidth,$maxheigh t)
{
global $config;
$oldimg = $srcname;//$config['basepath']."/photo/".$srcname;
$newimg = $destname;//$config['basepath']."/photo/".$destname;
$imagedata = GetImageSize($oldimg);
$imagewidth = $imagedata[0];
$imageheight = $imagedata[1];
$imagetype = $imagedata[2];
$shrinkage = 1;
if ($imagewidth > $maxwidth)
{
$shrinkage = $maxwidth/$imagewidth;
}
if($shrinkage !=1)
{
$dest_height = $shrinkage * $imageheight;
$dest_width = $maxwidth;
}
else
{
$dest_height=$imageheight;
$dest_width=$imagewidth;
}
if($dest_height > $maxheight)
{
$shrinkage = $maxheight/$dest_height;
$dest_width = $shrinkage * $dest_width;
$dest_height = $maxheight;
}
if($imagetype==2)
{
$src_img = imagecreatefromjpeg($oldimg);
$dst_img = imageCreateTrueColor($dest_width, $dest_height);
ImageCopyResampled($dst_img, $src_img, 0, 0, 0, 0, $dest_width, $dest_height, $imagewidth, $imageheight);
imagejpeg($dst_img, $newimg, 100);
imagedestroy($src_img);
imagedestroy($dst_img);
}
elseif ($imagetype == 3)
{
$src_img = imagecreatefrompng($oldimg);
$dst_img = imageCreateTrueColor($dest_width, $dest_height);
ImageCopyResampled($dst_img, $src_img, 0, 0, 0, 0, $dest_width, $dest_height, $imagewidth, $imageheight);
imagepng($dst_img, $newimg, 100);
imagedestroy($src_img);
imagedestroy($dst_img);
}
else
{
$src_img = imagecreatefromgif($oldimg);
$dst_img = imageCreateTrueColor($dest_width, $dest_height);
ImageCopyResampled($dst_img, $src_img, 0, 0, 0, 0, $dest_width, $dest_height, $imagewidth, $imageheight);
imagejpeg($dst_img, $newimg, 100);
imagedestroy($src_img);
imagedestroy($dst_img);
}
}
//CHECK IF EMAIL ADDRESS IS VALID OR NOT
function check_email($email)
{
$email_regexp = "^([-!#\$%&'*+./0-9=?A-Z^_`a-z{|}~])+@([-!#\$%&'*+/0-9=?A-Z^_`a-z{|}~]+\\.)+[a-zA-Z]{2,4}\$";
return eregi($email_regexp, $email);
}
function check_gurl($name)
{
$email_regexp = "!([a-zA-Z0-9])$";
return eregi($email_regexp, $name);
}
function check_field_exists($fvalue,$field,$table)
{
global $conn;
$sql="select count(*) as cnt from $table where $field='$fvalue'";
$res=$conn->execute($sql);
if($res->fields[cnt]>0) return 1; else return 0;
}
function key_to_info($key)
{
global $config,$conn;
$sql="select VID,UID,keyword,viewnumber from video where vkey='$key'";
$rs=$conn->execute($sql);
if($rs->recordcount()>0){
$list[]=$rs->fields['VID'];
$list[]=$rs->fields['UID'];
$list[]=$rs->fields['keyword'];
$list[]=$rs->fields['viewnumber'];
return $list;
}
else return false;
}
function key_to_info_audio($key)
{
global $config,$conn;
$sql="select VID,UID,keyword,viewnumber from audio where vkey='$key'";
$rs=$conn->execute($sql);
if($rs->recordcount()>0)
{$list[]=$rs->fields['VID'];$list[]=$rs->fields['UID'];$list[]=$rs->fields['keyword'];$list[]=$rs->fields['viewnumber'];
return $list;}
else return false;
}
function delete_vdo($aid,$bid)
{
global $conn;
$sql="DELETE from video WHERE VID=$aid and UID=$bid";$conn->execute($sql);
$sql="DELETE from group_vdo WHERE VID=$aid";$conn->execute($sql);
$sql="DELETE from favourite WHERE VID=$aid";$conn->execute($sql);
$ff1=$config[tmburl]."/1_".$aid.".jpg";
$ff2=$config[tmburl]."/2_".$aid.".jpg";
$ff3=$config[tmburl]."/3_".$aid.".jpg";
if(file_exists($ff1)) @unlink($ff1);
if(file_exists($ff2)) @unlink($ff2);
if(file_exists($ff3)) @unlink($ff3);
$sql="select vdoname from video WHERE VID=$aid";$rs=$conn->execute($sql);
$ff4=$config[vdourl]."/".$rs->fields[vdoname];
if($rs->recordcount()>0 && file_exists($ff4))@unlink($ff4);
return "Deleted successfully!";
}
function group_tags($query)
{
global $conn;
$list="";
$rs=$conn->execute($query);
while(!$rs->EOF)
{
$tarray=explode(" ",$rs->fields['keyword']);
for($i=0;$i<count($tarray);$i++)
{
if(stristr($list,$tarray[$i])===FALSE)
{
$list.=$tarray[$i]." ";
}
}
$rs->movenext();
}
$list=trim($list);
$taglist=explode(" ",$list);
if($list!="")return $taglist;
}
//END
function video_rating($vid,$urate)
{
global $config,$conn;
$sql="select ratedby,rate,voter_id from video where VID='$vid'";
$rs=$conn->execute($sql);
$voter_id=$rs->fields['voter_id'];
$flag=false;
if($config['video_rating']=="Once")
{
$niddle="|";
$niddle.=$_SESSION['UID'];
$niddle.="|";
$flag=strstr($voter_id,$niddle);
}
if(!$flag){
if($voter_id==""){
$voter_id.= "|";
}
$voter_id.=$_SESSION['UID'];
$voter_id.= "|";
$t=$rs->fields['ratedby']*$rs->fields['rate'];
$newrby=($rs->fields['ratedby']+1);
$newrate=($t+$urate)/$newrby;
$sql="update video set
ratedby=$newrby,
rate=$newrate,
voter_id='$voter_id' WHERE VID='$vid'";
$conn->execute($sql);
return true;
}
else{
return false;
}
}
function user_rating($uid,$urate)
{
global $conn;
$sql="select ratedby,rate from signup where UID='$uid'";
$rs=$conn->execute($sql);
$t=$rs->fields['ratedby']*$rs->fields['rate'];
$newrby=($rs->fields['ratedby']+1);
$newrate=($t+$urate)/$newrby;
$sql="update signup set
ratedby=$newrby,
rate=$newrate WHERE UID='$uid'";
$conn->execute($sql);
return ceil($newrate);
}
# Audio ration
function audio_rating($vid,$urate)
{
global $conn;
$sql="select ratedby,rate from audio where VID='$vid'";
$rs=$conn->execute($sql);
$t=$rs->fields['ratedby']*$rs->fields['rate'];
$newrby=($rs->fields['ratedby']+1);
$newrate=($t+$urate)/$newrby;
$sql="update audio set
ratedby=$newrby,
rate=$newrate WHERE VID=$vid";
$conn->execute($sql);
}
function login_data($tbl="")
{
global $conn;
$sql="select count(*) as ttl from $tbl";
$rs=$conn->execute($sql);
if($rs->fields[ttl]>=10)
{$sql="select min(LOGID) as log from $tbl";$rs=$conn->execute($sql);
$sql="delete from $tbl WHERE LOGID=".$rs->fields['log'];$rs=$conn->execute($sql);}
$sql="insert into $tbl set UID=$_SESSION[UID]";$rs=$conn->execute($sql);
}
function insert_id_to_name($id)
{
global $config,$conn;
$sql="select username from signup where UID=$id[un]";
$rs=$conn->execute($sql);
return $rs->fields['username'];
}
function insert_tag_to_name($a)
{
if($a[tag]=="mr") $res="Most Recent";
elseif($a[tag]=="mv") $res="Most Viewed";
elseif($a[tag]=="md") $res="Most Discussed";
elseif($a[tag]=="tf") $res="Top Favourites";
elseif($a[tag]=="tr") $res="Top Rated";
elseif($a[tag]=="rf") $res="Recently Featured";
elseif($a[tag]=="rf") $res="Recently Featured";
elseif($a[tag]=="rd") $res="Random";
return $res;
}
//CACULATION OF TIME
function insert_time_range($info)
{
global $config,$conn;
//print_r($info);
$present=time();
$sql="select $info[field] from $info[tbl] where $info[IDFR]=$info[id]";
//echo $sql;
$rs=$conn->execute($sql);
$addtime=$rs->fields[$info['field']];
$interval=$present-$addtime;
if($interval>0)
{
$day=$interval/(60*60*24);
if($day>=1) {$range=floor($day)." days ";$interval=$interval-(60*60*24*floor($day));}
if($interval>0 && $range=="")
{
$hour=$interval/(60*60);
if($hour>=1) {$range=floor($hour)." hours ";$interval=$interval-(60*60*floor($hour));}
}
if($interval>0 && $range=="")
{
$min=$interval/(60);
if($min>=1) {$range=floor($min)." minutes ";$interval=$interval-(60*floor($min));}
}
if($interval>0 && $range=="")
{
$scn=$interval;
if($scn>=1) {$range=$scn." seconds ";}
}
if($range!="")$range=$range." ago"; else $range="just now";
return $range;
}
}
//END
function insert_time_to_date($a)
{
global $conn;
$date=date("F j, Y, g:i a",$a['tm']);
return $date;
}
//VIDEO KEYWORDS
function insert_video_keyword($a)
{
global $conn;
$sql="select keyword from video where VID='$a[vid]'";
$rs=$conn->execute($sql);
$a=$rs->fields['keyword'];
$list=explode(" ",$a);
return $list;
}
# AUDIO KEY WORD
function insert_audio_keyword($a)
{
global $conn;
$sql="select keyword from audio where VID='$a[vid]'";
$rs=$conn->execute($sql);
$a=$rs->fields['keyword'];
$list=explode(" ",$a);
return $list;
}
function insert_list_channel()
{
global $conn;
$sql="select * from channel";
$rs=$conn->execute($sql);
$i=0;
while(!$rs->EOF)
{
$list[$i]['ch']=$rs->fields['name'];
$list[$i]['id']=$rs->fields['CHID'];
$i++;
$rs->movenext();
}
return $list;
}
function insert_video_channel($a)
{
global $conn;
if($a[tbl]=="")$sqlx="channel from video where VID='$a[vid]'";
else $sqlx="channel from $a[tbl] where GID='$a[gid]'";
$sql="select $sqlx";
$rs=$conn->execute($sql);
$a=$rs->fields['channel'];
if($a!="")
{
$temp=explode("|",$a);
if(count($temp)>=1) for($i=1;$i<count($temp);$i++) $list.=" or CHID=".$temp[$i];
$sql="select CHID,name from channel where CHID=$temp[0] $list";
$rsx=$conn->execute($sql);
$res=$rsx->getrows();
return $res;
}
}
function insert_audio_channel($a)
{
global $conn;
if($a[tbl]==""){
$sqlx="channel from audio where VID='$a[vid]'";
}
else{
$sqlx="channel from $a[tbl] where GID='$a[gid]'";
}
$sql="select $sqlx";
$rs=$conn->execute($sql);
$a=$rs->fields['channel'];
if($a!="")
{
$temp=explode("|",$a);
if(count($temp)>=1) for($i=1;$i<count($temp);$i++) $list.=" or CHID=".$temp[$i];
$sql="select CHID,name from channel where CHID=$temp[0] $list";
$rsx=$conn->execute($sql);
$res=$rsx->getrows();
return $res;
}
}
function insert_show_rate($a)
{
global $conn,$config;
$rate=ceil($a['rte']);
$cnt=floor($rate/2);
for($i=0;$i<$cnt;$i++)$list.="<img src='$config[imgurl]/star.gif' width=15> ";
for($i=0;$i<(5-$cnt);$i++)
{
if($rate-($cnt*2)==1){$list.="<img src='$config[imgurl]/half_star.gif' width=15>";$rate=0;}
else $list.="<img src='$config[imgurl]/blank_star.gif'>";
}
if($rate>0) return $list; else return "Not yet rated";
}
function insert_row_count($a)
{
global $conn;
$sql="select count(*) as cnt from $a[tbl] where GID='$a[gid]'";
$res=$conn->execute($sql);
return $res->fields['cnt'];
}
function insert_channel_count($a)
{
global $conn;
$dt=date("Y-m-d");
$sql="select count(*) as dytotal from video WHERE channel like '%$a[cid]%' and adddate='$dt'";
$rs=$conn->execute($sql);
$list[0]=$rs->fields['dytotal'];
$sql="select count(*) as chtotal from video WHERE channel like '%$a[cid]%'";
$rs=$conn->execute($sql);
$list[1]=$rs->fields['chtotal'];
$sql="select count(*) as grtotal from group_own WHERE channel like '%$a[cid]%'";
$rs=$conn->execute($sql);
$list[2]=$rs->fields['grtotal'];
return $list;
}
function insert_get_photo($a)
{
global $conn;
$sql="select max(VID) as vid from video where UID=$a[uid]";
$rs=$conn->execute($sql);
return $rs->fields['vid'];
}
function insert_video_info($a)
{
global $conn;
$sql="select * from video where VID='$a[vid]'";
$rs=$conn->execute($sql);
$x=$rs->getarray();
return $x;
}
function insert_audio_info($a)
{
global $conn;
$sql="select * from audio where VID='$a[vid]'";
$rs=$conn->execute($sql);
return $rs->getarray();
}
function insert_comment_info($a)
{
global $conn;
$sql="select * from comments where VID='$a[vid]'";
$rs=$conn->execute($sql);
return $rs->getarray();
}
function insert_comment_info_audio($a)
{
global $conn;
$sql="select * from comments_audio where VID='$a[vid]'";
$rs=$conn->execute($sql);
return $rs->getarray();
}
function insert_comment_count($a)
{
global $conn;
$sql="select count(*) as ttl from comments where VID='$a[vid]'";
$rs=$conn->execute($sql);
return $rs->fields['ttl'];
}
function insert_comment_count_audio($a)
{
global $conn;
$sql="select count(*) as ttl from comments_audio where VID='$a[vid]'";
$rs=$conn->execute($sql);
return $rs->fields['ttl'];
}
function insert_video_count($a)
{
global $conn;
if($a[type]=="public")$add="and type='$a[type]'";
if($a[type]=="private")$add="and type='$a[type]'";
$sql="select count(*) as ttl from video where UID=$a[uid] $add";
$rs=$conn->execute($sql);
return $rs->fields['ttl'];
}
function insert_audio_count($a)
{
global $conn;
if($a[type]=="public")$add="and type='$a[type]'";
if($a[type]=="private")$add="and type='$a[type]'";
$sql="select count(*) as ttl from audio where UID=$a[uid] $add";
$rs=$conn->execute($sql);
return $rs->fields['ttl'];
}
function insert_favour_count($a)
{
global $conn;
$sql="select count(*) as ttl from favourite where UID='$a[uid]'";
$rs=$conn->execute($sql);
return $rs->fields['ttl'];
}
function insert_favour_count_audio($a)
{
global $conn;
$sql="select count(*) as ttl from favourite_audio where UID='$a[uid]'";
$rs=$conn->execute($sql);
return $rs->fields['ttl'];
}
function insert_playlist_count($a)
{
global $conn;
$sql="select count(*) as ttl from playlist where UID='$a[uid]'";
$rs=$conn->execute($sql);
return $rs->fields['ttl'];
}
function insert_msg_count()
{
global $conn;
$sql="select count(*) as ttl from pm where receiver='$_SESSION[USERNAME]' and seen=0 and inbox_track=2";
$rs=$conn->execute($sql);
return $rs->fields['ttl']+0;
}
function insert_friends_count($a)
{
global $conn;
$sql="select count(*) as ttl from friends where UID='$a[uid]' and friends_status='Confirmed'";
$rs=$conn->execute($sql);
return $rs->fields['ttl'];
}
function insert_5users_count($a)
{
global $conn;
if($_SESSION[UID]!="") $add="";
$sql="select distinct UID from $a[tbl] $add order by LOGID desc limit 5";
$rs=$conn->execute($sql);
return $rs->getarray();
}
function insert_group_count($a)
{
global $conn;
if($a[chid]!="")
{
$from ="group_own";
$add1="where channel like '%|$a[chid]|%' ";
}
if($a[uid]!="")
{
$add1="where m.GID=o.GID and m.MID=$a[uid]";
$from="group_own as o, group_mem as m";
}
if($a[type]=="public")$add2="and type='$a[type]'";
if($a[type]=="private")$add2="and type='$a[type]'";
$sql="select count(*) as ttl from $from $add1 $add2";
//count(m.GID) as total from group_own as o, group_mem as m WHERE m.GID=o.GID and m.MID=$_REQUEST[UID]
$rs=$conn->execute($sql);
return $rs->fields['ttl'];
}