Search options (Page 3 of 4)

<?php 
    // query to set up appropriate player challenges
    $imatch_id = intval($_GET['imatch_id']); 
    $result = $db->query("SELECT * FROM ".$db->prefix."ladders WHERE imatch_id=$imatch_id") or error('Query failed', __FILE__, __LINE__, $db->error());

?>
<br />
<?php echo $line['username'].'\'s pending challenges:' ?></dt><br />
<?php 
    //while loop here could be totally wrong,  using to examine all matches listed....
    while ($row = $db->fetch_assoc($result))
    {
        //if there is a match listed where the playerb's name is equal to the name of the player whose profile page it is ($line['username']) then it will show this match 
        if ($row['playerb'] == $line['username'])
        {
       //when it finds above, it lists the playera and the playerb for that match
            echo $row['playera'].'has a challenge against'.$row['playerb'].'(awaiting winner)'; 
        }
        else
        {
       //if these possibilities do not occur then echo no current challenges
            echo 'No current challenges';
        }
    }
?>

<form method="get" action="new_ichallenge.php" >
    <center>
        <input type="hidden" value="" id="imatch_id" name="imatch_id">
        <input type="hidden" value="<?php $pun_user['username']?>" id="playera" name="playera">
        <input type="hidden" value="<?php $line['username']?>" id="playerb" name="playerb">
        <input type="submit" value="Challenge Player" name="submit">
    </center>
</form>

<?php
// PERFORM QUERY & POPULATE TABLE
 $p=isset($_GET['p'])?(int)($_GET['p']-1)*15:0;
 $query = 'SELECT id, username, iwins, ilosses, ipoints FROM punbb2_users' . ' ORDER by ipoints DESC, username ASC LIMIT '.$p.', 15' ;
 $result = mysql_query($query) or die('Query failed: ' . mysql_error());
    
    $id = '<a href="profile.php?id='.$line['id'].'">'.pun_htmlspecialchars($line['username']).'</a>' ;

if ($db->num_rows($result))
{
    while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
     echo "\t<tr>\n";


            
        
?>

    <td class="tcl" scope="col"><?php echo '<a href="iprofile.php?id='.$line['id'].'">'.pun_htmlspecialchars($line['username']).'</a>' ?></td>
    <td class="tc2" scope="col"><?php echo $line['iwins']; ?></td>
    <td class="tc3" scope="col"><?php echo $line['ilosses']; ?></td>
    <td class="tc4" scope="col"><center><?php echo $line['ipoints']; ?></center></td>        

<?php
          }
    echo "\t</tr>\n";
}
echo "</table>\n";

//BEGIN PAGINATE
$result = $db->query('SELECT COUNT(id)-1 FROM '.$db->prefix.'users') or error('Unable to fetch total user count', __FILE__, __LINE__, $db->error());
 $query_rows = $db->result($result);

$num_pages = ceil($query_rows / 15);

if (intval($_GET['p']) && $_GET['p'] <= $num_pages) 
$cur_page = $_GET['p'];

$link_to = 'iladder.php?';

echo '<center>Page:'.paginate($num_pages, $cur_page, $link_to).'</center>';
//END PAGINATE


?>

 $p = (int)$_GET['p']*15;
 $query = 'SELECT id, username, iwins, ilosses, ipoints FROM punbb2_users' . ' ORDER by ipoints DESC, username ASC LIMIT '.$p.', 15' ;

$num_pages = ceil($query_rows / 15);

if (intval($_GET['p']) && $_GET['p'] <= $num_pages) 
$cur_page = $_GET['p'];