<?php

require('db.php');


$username = $_REQUEST['username'];

$sqlQuery = "SELECT * FROM  users WHERE uname='$username'";
$result = mysqli_query($db, $sqlQuery);
$view = @mysqli_fetch_assoc($result);


$varfname = $view['fname'];
$varuname = $view['uname'];
$varphone = $view['phone'];
$varemail = $view['email'];
$varcurrency = $view['currency'];
$varpassword = $view['password'];
$varpin = $view['pin'];
$varpinup = $view['pinup'];
$varvpin = $view['vpin'];
$varwithfee = $view['withfee'];
$vartax = $view['taxfee'];
$varcountry = $view['country'];
$varsecquestion = $view['secquestion'];
$varsecanswer = $view['secanswer'];
$vartdate = $view['tdate'];
$vartearn = $view['tearn'];
$varadeposit = $view['adeposit'];
$varbal = $view['bal'];
$vartwithdrawal = $view['twithdrawal'];
$varldeposit = $view['ldeposit'];
$vartdeposit = $view['tdeposit'];
$varlwithdrawal = $view['lwithdrawal'];
$varpwithdrawal = $view['pwithdrawal'];
$vartranx1 = $view['tranx1'];
$vartranx2 = $view['tranx2'];
$vartranx3 = $view['tranx3'];
$varownwallet = $view['ownwallet'];
$vardwallet = $view['dwallet'];
$varpstarter = $view['pstarter'];
$varpsilver = $view['psilver'];
$varpgold = $view['pgold'];
$varip = $view['ip'];

?>



<html>

<head lang="en">
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=0.9">
  <link rel="icon" href="<?= htmlspecialchars($siteUrl . str_replace('..', '', $siteIcon)) ?>">
  <title><?= $siteName ?> | Admin</title>
    <style type="text/css">
    
    .style1 {
      color: #F58635
    }

    .style2 {
      font-family: Verdana, Arial, Helvetica, sans-serif;
      font-size: 24px;
    }

    .style5 {
      font-family: Verdana, Arial, Helvetica, sans-serif;
      font-size: 12px;
    }
    </style>
</head>

<body style="background:#f4edf5">
  <div align="center"><br />
    <h2>
      <font color="#f39c12" face="verdana,arial,sans-serif"><?= $siteName ?></font>
    </h2><br />
    <br />
  </div>
  <hr>
  <center>
    <h1 class="style1 style2">Update User Record </h1>
    <strong>
      <font color="red">Please only edit the record field you wish to update</font>
    </strong>
  </center>
  <hr>
  <center>
    <form action="save" method="POST">
      <table>
        <tr>
          <td width="185"><span class="style5">Username: </span></td>
          <td width="144"><b><?php echo $varuname; ?></b></td>
        </tr>
        <input type="hidden" name="username" value="<?php echo $varuname; ?>">
        <tr>
          <td><span class="style5">Full name: </span></td>
          <td><b><input type="text" name="fullname" value="<?php echo $varfname; ?>"></b></td>
        </tr>
        <tr>
          <td><span class="style5">Phone number: </span></td>
          <td><b><input type="text" name="phone" value="<?php echo $varphone; ?>"></b></td>
        </tr>
        <tr>
          <td><span class="style5">Email: </span></td>
          <td><b><input type="email" name="email" value="<?php echo $varemail; ?>"></b></td>
        </tr>
        <tr>
          <td><span class="style5">Currency: </span></td>
          <td><select style="background:#1f1a2c; color:white" class="form-control" name="currency">
              <option value="<?php echo $varcurrency; ?>" selected>Default</option>
              <option>$</option>
              <option>€</option>
              <option>£</option>
            </select></td>
        </tr>
        <tr>
          <td><span class="style5">Password: </span></td>
          <td><b><input type="text" name="password" value="<?php echo $varpassword; ?>"></b></td>
        </tr>
        <tr>
          <td><span class="style5">Pin: </span></td>
          <td><b><input type="text" name="pin" value="<?php echo $varpin; ?>"></b></td>
        </tr>
        <tr>
          <td><span class="style5">Upgrade Pin: </span></td>
          <td><b><input type="text" name="pinup" value="<?php echo $varpinup; ?>"></b></td>
        </tr>






        <tr>
          <td><span class="style5">Commission status: </span></td>
          <td><select style="background:#1f1a2c; color:white" class="form-control" name="vpin">
              <option value="<?php echo $varvpin; ?>" selected>Default</option>
              <option value="6684">Not Paid</option>
              <option value="8904">Paid</option>
            </select></td>
        </tr>





        <tr>
          <td><span class="style5">Withdrawal status: </span></td>
          <td><select style="background:#1f1a2c; color:white" class="form-control" name="vpin2">
              <option value="<?php echo $varwithfee; ?>" selected>Default</option>
              <option value="6684">Not Paid</option>
              <option value="249876">Paid</option>
            </select></td>
        </tr>

        <tr>
          <td><span class="style5">Tax : </span></td>
          <td><select style="background:#1f1a2c; color:white" class="form-control" name="tax">
              <option value="<?php echo $vartax; ?>" selected>Default</option>
              <option value="6684">Not Paid</option>
              <option value="453876">Paid</option>
            </select></td>
        </tr>






        <tr>
          <td><span class="style5">Country: </span></td>
          <td><b><input type="text" name="country" value="<?php echo $varcountry; ?>"></b></td>
        </tr>
        <tr>
          <td><span class="style5">Security Question: </span></td>
          <td><b>
              <input type="text" name="sq" value="<?php echo $varsecquestion; ?>">
            </b></td>
        </tr>
        <tr>
          <td><span class="style5">Security Answer:</span></td>
          <td><input type="text" name="sa" value="<?php echo $varsecanswer; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Date Registered:</span></td>
          <td><input type="text" name="tdate" value="<?php echo $vartdate; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Account Balance:</span></td>
          <td><input type="text" name="bal" value="<?php echo $varbal; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Total Earn:</span></td>
          <td><input type="text" name="tearn" value="<?php echo $vartearn; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Active Deposit:</span></td>
          <td><input type="text" name="adeposit" value="<?php echo $varadeposit; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Last Deposit:</span></td>
          <td><input type="text" name="ldeposit" value="<?php echo $varldeposit; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Total Deposit:</span></td>
          <td><input type="text" name="tdeposit" value="<?php echo $vartdeposit; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Commissions:</span></td>
          <td><input type="text" name="lwithdrawal" value="<?php echo $varlwithdrawal; ?>">&nbsp;</td>
        </tr>
        <!--<tr>-->
        <!--  <td><span class="style5">Pending Withdrawal:</span></td>-->
        <!--  <td><input type="text" name="pwithdrawal" value="<?php echo $varpwithdrawal; ?>">&nbsp;</td>-->
        <!--</tr>-->
        <tr>
          <td><span class="style5">Total Earnings:</span></td>
          <td><input type="text" name="twithdrawal" value="<?php echo $vartwithdrawal; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Firt Transaction Amount:</span></td>
          <td><input type="text" name="tranx1" value="<?php echo $vartranx1; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Second Transaction Amount:</span></td>
          <td><input type="text" name="tranx2" value="<?php echo $vartranx2; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Third Transaction Amount:</span></td>
          <td><input type="text" name="tranx3" value="<?php echo $vartranx3; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Payout Wallet:</span></td>
          <td><input type="text" name="ownwallet" value="<?php echo $varownwallet; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Deposit Wallet:</span></td>
          <td><input type="text" name="dwallet" value="<?php echo $vardwallet; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Balance on Starter plan:</span></td>
          <td><input type="text" name="pstarter" value="<?php echo $varpstarter; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Balance on Silver plan:</span></td>
          <td><input type="text" name="psilver" value="<?php echo $varpsilver; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">Balance on Gold plan:</span></td>
          <td><input type="text" name="pgold" value="<?php echo $varpgold; ?>">&nbsp;</td>
        </tr>
        <tr>
          <td><span class="style5">User IP:</span></td>
          <td><input type="text" name="ip" value="<?php echo $varip; ?>">&nbsp;</td>
        </tr>
      </table>
      <input type="submit" value="Update User Info">
    </form><br />
    <hr>
</body>

</html>