<?php require '../header.php'; ?>

<table width="590" cellpadding="5" cellspacing="5"><tr><td>

<?php if (isset($getUser) && $getUser['userlevel'] == '10'): ?>

<?php
$db = getReadDb();

if (isset($_GET['RecordID'])) {
    $stmt = $db->prepare("SELECT users.ID AS viewfield1, users.fname AS viewfield2, users.lname AS viewfield3, users.Member AS viewfield4, users.Password AS viewfield5, users.CurrentDateTime AS viewfield6, users.City AS viewfield9, users.State AS viewfield10, users.Country AS viewfield11, users.List AS viewfield12, users.OnOff AS viewfield13, users.Address1 AS viewfield14, users.Address2 AS viewfield15, users.Zip AS viewfield16, users.Phone AS viewfield17, users.ID AS id_field, users.expired AS viewfield99, totallogins, lastip, lastbrowser, lastlogin, emailsubscribe FROM users WHERE users.ID = ?");
    $stmt->execute([$_GET['RecordID']]);
} else {
    $stmt = $db->prepare("SELECT users.ID AS viewfield1, users.fname AS viewfield2, users.lname AS viewfield3, users.Member AS viewfield4, users.Password AS viewfield5, users.CurrentDateTime AS viewfield6, users.City AS viewfield9, users.State AS viewfield10, users.Country AS viewfield11, users.List AS viewfield12, users.OnOff AS viewfield13, users.Address1 AS viewfield14, users.Address2 AS viewfield15, users.Zip AS viewfield16, users.Phone AS viewfield17, users.ID AS id_field, users.expired AS viewfield99, totallogins, lastip, lastbrowser, lastlogin, emailsubscribe FROM users");
    $stmt->execute();
}
$getRecord = $stmt->fetch();
?>

<?php if ($getRecord): ?>

<FONT color="red" size="+2"><B>View Record</B></FONT>
<font face="arial" size="-1"><br><a href="CurrentSearch_Result.php">Back to Member Administration</a></font>

<FORM action="user_RecordAction.php" method="post">
    <INPUT type="hidden" name="RecordID" value="<?php echo h($getRecord['id_field']); ?>">

    <INPUT type="submit" name="btnView_First" value=" << ">
    <INPUT type="submit" name="btnView_Previous" value="  <  ">
    <INPUT type="submit" name="btnView_Next" value="  >  ">
    <INPUT type="submit" name="btnView_Last" value=" >> ">
    <INPUT type="submit" name="btnView_Edit" value="  Edit  ">
    <INPUT type="submit" name="btnView_Delete" value="Delete">

</FORM>


<TABLE>

    <TR>
    <TD valign="top"> ID: </TD>
    <TD> <?php echo h($getRecord['viewfield1']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> First Name: </TD>
    <TD> <?php echo h($getRecord['viewfield2']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> Last Name: </TD>
    <TD> <?php echo h($getRecord['viewfield3']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> Member Number: </TD>
    <TD> <?php echo h($getRecord['viewfield4']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> Password: </TD>
    <TD> <?php echo h($getRecord['viewfield5']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> Date/Time Entered: </TD>
    <TD> <?php echo h($getRecord['viewfield6']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> City: </TD>
    <TD> <?php echo h($getRecord['viewfield9']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> State: </TD>
    <TD> <?php echo h($getRecord['viewfield10']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> Country: </TD>
    <TD> <?php echo h($getRecord['viewfield11']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> Zip: </TD>
    <TD> <?php echo h($getRecord['viewfield16']); ?> </TD>
    </TR>
    <TR>
    <TD valign="top"> Address: </TD>
    <TD> <?php echo h($getRecord['viewfield14']); ?> </TD>
    </TR>
    <TR>
    <TD valign="top"> Address2: </TD>
    <TD> <?php echo h($getRecord['viewfield15']); ?> </TD>
    </TR>
    <TR>
    <TD valign="top"> Phone: </TD>
    <TD> <?php echo h($getRecord['viewfield17']); ?> </TD>
    </TR>


    <TR>
    <TD valign="top"> List in Directory: </TD>
    <TD> <?php echo h($getRecord['viewfield12']); ?> </TD>
    </TR>


    <TR>
    <TD valign="top"> OnOff: </TD>
    <TD> <?php echo h($getRecord['viewfield13']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> Expire Date: </TD>
    <TD> <?php echo h($getRecord['viewfield99']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> Total Logins: </TD>
    <TD> <?php echo h($getRecord['totallogins']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> Last IP Address: </TD>
    <TD> <?php echo h($getRecord['lastip']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> Last Login: </TD>
    <TD> <?php echo h($getRecord['lastlogin']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> Last Web Browser: </TD>
    <TD> <?php echo h($getRecord['lastbrowser']); ?> </TD>
    </TR>

    <TR>
    <TD valign="top"> Subscribe to Hotline Updates: </TD>
    <TD> <?php echo h($getRecord['emailsubscribe']); ?> </TD>
    </TR>
</TABLE>

<?php endif; ?>

<?php else: ?>
<center><span class="RedHeadline">ACCESS DENIED - YOU MUST BE LOGGED IN WITH ADMINISTRATOR ACCESS<br></span>

<?php endif; ?>

</td></tr></table>
<?php require '../footer.php'; ?>