MFS Team Owner
- Joined
- Jan 10, 2007
- Messages
- 767
- Reaction score
- 227
Refferal list isn`t working correctly. For example, I voted for my character AngeL 3 times, he should be ranked 1st in list, but for each vote he get in top again.
See image View attachment 127593
open referal.php and chage code with this, test and say is it working
Code:
<? if (eregi("modules/", $_SERVER['SCRIPT_NAME'])) { header("Location: ../?op=news"); } ?>
<script type="text/javascript" src="includes/javascript/rules.js"></script>
<script type="text/javascript" src="includes/javascript/pfewlpflpwelpf.js"></script>
<table align='center' width='350' cellspacing='0' cellpaddding='0' class='sort-table'>
<tr>
<td align='center' colspan='5' class=asd><? echo $servername; ?> :: Referals</td>
</tr>
<tr>
<td align='right'>Referals:</td>
<td align='center'><a onclick="rules('')"><input OnClick="rankings('rank')" type='submit' class='button' value='show'></a></td>
</tr>
<tr><td align='center' colspan='2'>
<div id='showrules' style='display: none;'>
<table width='400' align='center'>
<tr><td> </td></tr>
<tr><td align='center'>
<table width='400' align='center' class='maintable'>
<tr>
<td align='center' class='asd'>Total Referals</td></tr></table>
<table width='400' align='center' class='maintable'>
<tr>
<td align='center' class='asd'>#
<td align='center' class='asd'>Name
<td align='center' class='asd'>Votes
</td></tr>
<?php
include "config.php";
$query = mssql_query("SELECT TOP 100 userid, broi from items order by broi desc");
for($i=0; $i < mssql_num_rows($query); ++$i)
{
$rank = $i+1;
while ($a = $fetch = mssql_fetch_array($query)) {
$id = $a['userid'];
$getname = mssql_query("SELECT * from MEMB_INFO where memb___id='$id'");
$fatch = mssql_fetch_array($getname);
$username = $fatch['memb___id'];
$broi = mssql_num_rows(mssql_query("SELECT broi from items where userid='$id'"));
$up = mssql_query("UPDATE items SET broi='$broi' WHERE userid='$id'");
$username = $fatch['memb___id'];
echo"
<tr>
<td align='center' class='maintable'>$rank.</td>
<td align='center' class='maintable'>$username</td>
<td align='center' class='maintable'>$broi</td>
</tr>
";
}}
?>
</table>
</td></tr>
</table>
<tr><td> </td></tr>
<tr class='even'></td></tr>
</table>