File size: 2.75Kb
<?php
$hostname = "host";
$user = "username";
$password = "password";
$db = "database";
$main_name= "SpiderWap";
$main_link= "http://spiderwap.co.za";
mysql_connect($hostname, $user, $password);
mysql_select_db ($db);
///////////////////////
function print_data($sex_data, $komu_data, $page)
{
if(empty($page)) $page=0;
$query=mysql_query("SELECT `id` FROM `users` where sex='$sex_data';");
$num_of_rows=mysql_num_rows($query);
$total_mat_number=$num_of_rows;
$mat_per_page=1;
$total_pages=ceil($total_mat_number/$mat_per_page);
$let=@mysql_query("select count(*) from `otziv` where komu='$komu_data' and message>0;");
$lett=@mysql_fetch_array($let);
$lett_count = @mysql_query("SELECT count(*) FROM `otziv` WHERE message>0;");
$ldc = @mysql_fetch_array($lett_count);
$lcount = $ldc['count(*)'];
$lett_regs = @mysql_query("select count(*) from `otziv`;");
$lregs = @mysql_fetch_array($lett_regs);
$print = mysql_query("select * from `users` where sex='$sex_data' and counter>0 order by counter desc limit ".$page.",".($page+$mat_per_page).";");
while($data=mysql_fetch_array($print))
{
if($data['foto']==""){print "<small><img src=\"no.gif\" alt=\"No Pic\"/></small><br/>";} else {
print "<img src=\"http://".$data['foto']."\" alt=\"".$data['nick']."\"/><br/>
<small><b>Vote Count</b> ".$data['counter']."</small><br/>
<small><a href=\"votefoto.php?id=".$data['id']."\">Vote Pic</a></small><br/>";}
print "<small><b>ID:</b> ".$data['id']."</small><br/>";
print "<small><b>Nick</b>: ".$data['nick']."</small><br/>";
print "<small><b>Name:</b> ".$data['name']."</small><br/>";
print "<small><b>City:</b> ".$data['gorod']."</small><br/>";
print "<small><b>Date Of Birth</b>: ".$data['bday']."-".$data['bmonth']."-".$data['byear']."</small><br/>";
print "<small><b>Height:</b> ".$data['rost']."</small><br/>";
print "<small><b>Weight:</b> ".$data['ves']."</small><br/>";
print "<small><b>More Info</b>: ".$data['infa']."</small><br/>";
print "<small><b>Seexing: ".$data['ssex']." For ".$data['swhy']."</b></small><br/>";
print "<small><b>Mobile:</b> <a href=\"wtai://wp/mc;".$data['mob']."\">".$data['mob']."</a><br/>";
print "<small><b>e-mail:</b> <a href=\"mailto:".$data['mail']."\">".$data['mail']."</a><br/></small><br/>";
//print "<small><a href=\"add.php?dir=".$data['nick']."&pp=1\">Add Comments</a></small><br/>";
//print "<small><a href=\"letter.php?komu=".$data['nick']."\">Read Comments[".$lett['count(*)']."]</a></small><br/>";
print "<small>*****</small><br/>";
}
for ($i=0; $i<$total_pages; $i++){
$page_number=$i*$mat_per_page;
if ($page_number!=$page) {
print "<small><a href=\"znak.php?sex=$sex_data&page=$page_number\">[".($i+1)."]</a></small>";
} else {
print "<small><b>[".($i+1)."]</b></small>"; }
}
}
?>