//News
$selectsqlnews="select * from dt_news ";
$resultsqlnews=mysql_query($selectsqlnews);
$rowsqlnews=mysql_fetch_array($resultsqlnews);
//Total Members
$selectsqltotal="select count(*) from dt_profile ";
$resultsqltotal=mysql_query($selectsqltotal);
$rowsqltotal=mysql_fetch_array($resultsqltotal);
//Total Online
$selectsqlonline="select count(*) from dt_usersonline ";
$resultsqlonline=mysql_query($selectsqlonline);
$rowsqlonline=mysql_fetch_array($resultsqlonline);
//Total Online
$selectsqlchat="select distinct sid from dt_im_messages";
$resultsqlchat=mysql_query($selectsqlchat);
$rowsqlchat=mysql_num_rows($resultsqlchat);
//Total Pictures
$selectsqlpic="select * from dt_photos";
$resultsqlpic=mysql_query($selectsqlpic);
$count=0;
while($rowsqlpic=mysql_fetch_array($resultsqlpic))
{
if($rowsqlpic['filename_1']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_2']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_3']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_4']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_5']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_6']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_7']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_8']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_9']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_10']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_11']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_12']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_13']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_15']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_16']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_17']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_18']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_19']!="")
{
$count=$count+1;
}
if($rowsqlpic['filename_20']!="")
{
$count=$count+1;
}
}
//added by sandeep
global $dbhost, $dbuser, $dbpwd, $dbname;
$query_list = "select * from dt_feature ";
$result_list=mysql_db_query($dbname,$query_list);if(mysql_error()!="");
$row_list = mysql_fetch_array($result_list);
$mem_id1=$row_list[3];
$mem_id2=$row_list[4];
$mem_id3=$row_list[5];
$mem_id4=$row_list[6];
$mem_id5=$row_list[7];
$mem_id6=$row_list[8];
$query_list_id1 = "select * from dt_profile where member_id='$mem_id1' ";
$result_list_id1=mysql_db_query($dbname,$query_list_id1);if(mysql_error()!="");
$row_list_id1 = mysql_fetch_array($result_list_id1);
$query_list_id2 = "select * from dt_profile where member_id='$mem_id2' ";
$result_list_id2=mysql_db_query($dbname,$query_list_id2);if(mysql_error()!="");
$row_list_id2 = mysql_fetch_array($result_list_id2);
$query_list_id3 = "select * from dt_profile where member_id='$mem_id3' ";
$result_list_id3=mysql_db_query($dbname,$query_list_id3);if(mysql_error()!="");
$row_list_id3 = mysql_fetch_array($result_list_id3);
$query_list_id4 = "select * from dt_profile where member_id='$mem_id4' ";
$result_list_id4=mysql_db_query($dbname,$query_list_id4);if(mysql_error()!="");
$row_list_id4 = mysql_fetch_array($result_list_id4);
$query_list_id5 = "select * from dt_profile where member_id='$mem_id5' ";
$result_list_id5=mysql_db_query($dbname,$query_list_id5);if(mysql_error()!="");
$row_list_id5 = mysql_fetch_array($result_list_id5);
$query_list_id6 = "select * from dt_profile where member_id='$mem_id6' ";
$result_list_id6=mysql_db_query($dbname,$query_list_id6);if(mysql_error()!="");
$row_list_id6 = mysql_fetch_array($result_list_id6);
$query_list1 = "select * from dt_photos where member_id='$mem_id1'";
$result_list1=mysql_db_query($dbname,$query_list1);if(mysql_error()!="");
$result1=mysql_fetch_array($result_list1);
$query_list2 = "select * from dt_photos where member_id='$mem_id2'";
$result_list2=mysql_db_query($dbname,$query_list2);if(mysql_error()!="");
$result2=mysql_fetch_array($result_list2);
//echo $result2['filename_1'];
$query_list3 = "select * from dt_photos where member_id='$mem_id3'";
$result_list3=mysql_db_query($dbname,$query_list3);if(mysql_error()!="");
$result3=mysql_fetch_array($result_list3);
$query_list4 = "select * from dt_photos where member_id='$mem_id4'";
$result_list4=mysql_db_query($dbname,$query_list4);if(mysql_error()!="");
$result4=mysql_fetch_array($result_list4);
$query_list5 = "select * from dt_photos where member_id='$mem_id5'";
$result_list5=mysql_db_query($dbname,$query_list5);if(mysql_error()!="");
$result5=mysql_fetch_array($result_list5);
$query_list6 = "select * from dt_photos where member_id='$mem_id6'";
$result_list6=mysql_db_query($dbname,$query_list6);if(mysql_error()!="");
$result6=mysql_fetch_array($result_list6);
?>
|
| |
|
| Site
Status |
| Total
Site Member |
:
|
| Member's
Online |
:
|
| Member's
Chatting |
:
|
| Total
Pictures |
:
|
|
| |
|
|