<?php

//-----------------------------------------------------

//Si on a spécifié un id a modifier, on affiche les champs sql associées

//-----------------------------------------------------

if(isset($_GET['playerid'])){

    $data = $db->fetchRow('SELECT * 

                    FROM `'.$config['db_prefix'].'user` 

                    WHERE `id` = \''.$_GET['playerid'].'\' 

                    LIMIT 1');

    echo '<form action="?page=playeredit" method="post">';

    echo '<input type="hidden" name="modifyid" value="'.$data['id'].'"/>';

        foreach ($data as $key => $value) {

            echo $key.': <input type="text" name="'.$key.'" value="'.$value.'"/><br />';

        }

    echo '<input type="submit" value="Submit" /></form>';

}

//-----------------------------------------------------

//si on a validé le formulaire de modification, on applique

//-----------------------------------------------------

elseif(isset($_POST['modifyid'])){

    $modifid=$_POST['modifyid'];

    unset($_POST['modifyid']);

    $array=array();

        foreach ($_POST as $key => $value) {

            $array[$key] = $value;

        }

    $db->update($array, $config['db_prefix'].'user', '`id` = \''.$modifid.'\'');

    echo 'done';

    echo '<a href="index.php">Retour</a>';

//-----------------------------------------------------

//Sinon on affiche la liste des entrées dans la table

//-----------------------------------------------------

} else

{

    if(!isset($_GET['pagenumber'])){

        $_GET['pagenumber']=1;

    }

    $debut=($_GET['pagenumber']-1)*100;

    $data = $db->fetch('SELECT id, pseudo 

                FROM `'.$config['db_prefix'].'user` 

                LIMIT '.$debut.', 99  ; ');

    $i=0;

    echo '<table>';

    echo '<tr><td>Id</td><td>Pseudo</td></tr>';

        while(isset($data[$i])){

            echo '<tr><td>'.$data[$i]['id'].'</td><td><a href="?page=playeredit&playerid='.$data[$i]['id'].' ">'.$data[$i]['pseudo'].'</a></td></tr>';

            $i++;

        }

    echo '</table>';

}