rendered paste body<html>
<head>
<title>Vote.co.il - אדמיניסטרציה</title>
<link rel="stylesheet" type="text/css" href="media/style.css">
</head>
<body>
<table border="0" cellspacing="0" cellpadding="0" height="48" width="100%">
<tr>
<td class="header_top">Vote.co.il - אדמיניסטרציה</td>
</tr>
<tr><td class="header_line"><img src="media/empty.png" width="1" height="1" border="0" alt="" /></td></tr>
<tr>
<td class="header_menu">
[ <a href="index.php" class="menu">ראשי</a> ]
</td>
</tr>
<tr><td class="header_line"><img src="media/empty.png" width="1" height="1" border="0" alt="" /></td></tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0" dir="rtl">
<tr valign="top">
<td width="200" class="menu">
<b>Packages:</b><br />
<a href="li_Image_Toolbox.html">Image_Toolbox</a><br />
<br /><br />
<b>Files:</b><br />
<div class="package">
<a href="Image_Toolbox/_Image_Toolbox_Image_Toolbox_class_php.html"> Image_Toolbox.class.php
</a><br>
</div><br />
<b>Classes:</b><br />
<div class="package">
<a href="Image_Toolbox/Image_Toolbox.html">Image_Toolbox</a><br />
</div>
</td>
<td>
<table cellpadding="10" cellspacing="0" width="100%" border="0"><tr><td valign="top">
<div align="center"><h1>ראשי:</h1></div>
<br />
<?
include("../config.inc.php");
include("../functions.inc.php");
$query=mysql_query("SELECT id FROM tblMembers")
or die(mysql_error());
$num_rows=mysql_num_rows($query);
if($num_rows==0) {
echo "לא נמצאו חברים באתר";
}else{
?>
<table border="0" cellpadding="4" cellspacing="4" width="100%" align="center">
<tr>
<td style="border: 1px solid #C0C0C0" bgcolor="#FFFFFF">
<table cellpadding="4" cellspacing="0" width="100%">
<tr>
<td height="24" bgcolor="#4ac3da" colspan="7" style="font: normal bold 14px/150% Arial; color: #FFFFFF; padding: 2px 10px">טבלת חברים</td>
</tr>
<tr>
<td height="2" colspan="7"></td>
</tr>
<tr>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #5C9FE1" width="1%"><font color="#5C9FE1" size="2"><b>תמונה</b></font></td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #5C9FE1"><font color="#5C9FE1" size="2"><b>כינוי</b></font></a></td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #5C9FE1" align="center"><font color="#5C9FE1" size="2"><b>תגובות</b></font></td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #5C9FE1" align="center"><font color="#5C9FE1" size="2"><b>הצבעות</b></font></td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #5C9FE1" align="center"><font color="#5C9FE1" size="2"><b>נקודות</b></font></td>
<td style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 1px solid #5C9FE1" align="center"><font color="#5C9FE1" size="2"><b>ציון ממוצע</b></font></td>
</tr>
<?
$limit = '15';
$scrollnumber = '5';
$query1 = mysql_query ("SELECT * FROM tblMembers");
$numrows = mysql_num_rows ($query1);
if (!isset ($_GET['show'])) {
$display = 1;
} else {
$display = $_GET['show'];
}
$start = (($display * $limit) - $limit);
$query2 = mysql_query ("SELECT * FROM tblMembers LIMIT $start,$limit");
$x=0;
while ($array = mysql_fetch_array ($query2)) {
$color = return_color_value_for_gender($array[id]);
$x++;
$sql2 = mysql_query("SELECT COUNT(title) AS `count` FROM tblComments WHERE FromMid = '$array[id]'") or die(mysql_error());
$object=mysql_fetch_object($sql2);
?>
<tr>
<td bgcolor=<?=$color;?> align="center"><img align="top" border="1" height="50" width="50" src="<?=get_username_picture_from_mid($array[id]);?>" hspace="3" vspace="1" alt="liron67" title="liron67"></td>
<td bgcolor="<?=table_colors($x);?>" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 2px solid <?=$color;?>"><a href="viewprofile.php?Mid=<?=$array[id];?>" target="_top"><font color="#5C9FE1" size="2"><b><?=$array[username];?></b></font></a><br><font color="#CBE0F5" size="2"><b>בן <?=$array[age];?>, מאזור ה<?=$array[state];?></b></font></td>
<td bgcolor="<?=table_colors($x);?>" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 2px solid <?=$color;?>" align="center"><font color="#284465" size="2"><b><?=$object->count;?></b></font></td>
<td bgcolor="<?=table_colors($x);?>" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 2px solid <?=$color;?>" align="center"><font color="#284465" size="2"><b><?=$array[votes];?></b></font></td>
<td bgcolor="<?=table_colors($x);?>" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 2px solid <?=$color;?>" align="center"><font color="#284465" size="2"><b><?=$array[points];?></b></font></td>
<td bgcolor="<?=table_colors($x);?>" style="border-left-width: 1px; border-right-width: 1px; border-top-width: 1px; border-bottom: 2px solid <?=$color;?>" align="center"><font color="#284465" size="2"><b><?=$array[average];?></b></font></b></td>
</tr>
<? } ?>
<tr class="alt2">
<td colspan="7" class="smallregular" align="left" dir="rtl">
<div dir="rtl">
<?
$paging = ceil ($numrows / $limit);
if ($display > 1) {
$previous = $display - 1;
?>
[ <a href="<?= $_SERVER['PHP_SELF']; ?>?show=1"><font size="2" color="#97B201"><b>התחלה</b></font></a> |
<a href="<?= $_SERVER['PHP_SELF'] ?>?show=<?= $previous; ?>"><font style="font-size: 9pt" color="#73839E"><b>הקודם</b></font></a> |
<?php
}
if ($numrows != $limit) {
if ($paging > $scrollnumber) {
$first = $display;
$last = ($scrollnumber - 1) + $display;
} else {
$first = 1;
$last = $paging;
}
if ($last > $paging ) {
$first = $paging - ($scrollnumber - 1);
$last = $paging;
}
for ($i = $first;$i <= $last;$i++){
if ($display == $i) {
?>
<font style="font-size: 9pt; font-family: Arial;" color="#73839E"><b><?=$i;?></b></font> <font size="2" color="#73839E"><b>|</b></font>
<?php
} else {
?>
<a href="<?= $_SERVER['PHP_SELF']; ?>?show=<?= $i; ?>"><font style="font-size: 9pt; font-family: Arial" color="#97B201"><b><?=$i;?></b></font></A> <font size="2" color="#73839E"><b>|</b></font> </a>
<?php
} } }
if ($display < $paging) {
$next = $display + 1;
?>
<a href="<?= $_SERVER['PHP_SELF']; ?>?show=<?= $next; ?>"><font style="font-size: 9pt" color="#73839E"><b>הבא</b></font></a> |
<a href="<?= $_SERVER['PHP_SELF']; ?>?show=<?= $paging; ?>"><font style="font-size: 9pt" color="#97B201"><b>סוף</b></font></a> ]
<?php
}
?>
<font style="font-size: 9pt" color="#73839E"><b> מתוך: <?=$numrows;?> </b></font>
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
<?
} }
?>
<div class="credit">
<hr />
</div>
</td></tr></table>
</td>
</tr>
</table>
</body>
</html>