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

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

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

<?php
$db = getReadDb();
$stmt = $db->prepare("SELECT Member AS memberfield, lname AS resultfield1, fname AS resultfield2, City AS resultfield3, State AS resultfield4, Country AS resultfield5, ExpireD AS resultfield7, ID AS id_field FROM users WHERE OnOff = 'Off' ORDER BY users.lname");
$stmt->execute();
$searchResult = $stmt->fetchAll();
$recordCount = count($searchResult);
$maxRows = 1000;
?>

<center><span class="RedHeadline">Process New Registrations<br></span>
<FONT size="+1"><B><?php echo $recordCount; ?> Unregistered Users</B></FONT><br>
<p></p>
<FONT size="+1"><B>NOTE: I ADDED IN 1-CLICK ACTIVATION. JUST PICK A USER, CLICK EDIT, AND THEN CLICK ACTIVATE. IT WILL TURN THE USER ON, AND SEND THEM THE E-MAIL CONFIRMATION</B></FONT>
<p><FONT size="+0"><B>DON'T PROCESS PEOPLE MORE THEN ONCE! DELETE DUPLICATES</B>
<br><P>
<TABLE width="315" border="0" cellpadding="3" cellspacing="0">
<TR bgcolor="cccccc">
    <TD width="25">&nbsp;&nbsp;&nbsp;</TD>
    <TD width="60"><strong>Member&nbsp;&nbsp;&nbsp;</strong></TD>
    <TD width="50"><strong>Last</strong></TD>
    <TD width="50"><strong>First</strong></TD>
    <TD width="50"><strong>City</strong></TD>
    <TD width="2"><strong>State</strong></TD>
    <TD width="25"><strong>Country</strong></TD>
    <TD width="25"><strong>Expire</strong></TD>
</TR>

<?php
$rowNum = 0;
foreach ($searchResult as $row):
    if ($rowNum >= $maxRows) break;
    $bgColor = ($rowNum % 2 == 0) ? 'ffffff' : 'ffffcf';
    $rowNum++;
?>
<TR bgcolor="<?php echo $bgColor; ?>">
    <TD><A href="user_Recordview2.php?RecordID=<?php echo urlencode($row['id_field']); ?>">[edit]</A></TD>
    <TD><?php echo h($row['memberfield']); ?></TD>
    <TD><?php echo h($row['resultfield1']); ?></TD>
    <TD><?php echo h($row['resultfield2']); ?></TD>
    <TD><?php echo h($row['resultfield3']); ?></TD>
    <TD><?php echo h($row['resultfield4']); ?></TD>
    <TD><?php echo h($row['resultfield5']); ?></TD>
    <TD><?php echo h($row['resultfield7']); ?></TD>
</TR>
<?php endforeach; ?>
</TABLE></center>

</td>
</tr>
</table></center>



<?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'; ?>