trying to get this to work. i can lookup and select a user and it correctly displays the user info. but it puts the first username back in the lookup box so when i click update/create user it gives an error message. my username has admin permission and is the first name in the list, so i don't know if it's putting the first username or my username. errors vary - sometimes says username must be unique, sometimes email must be unique, sometimes passwords don't match. I added the line in blue or the select box didn't do anything. since it looks up the user correctly, i think my problem is in the admin form:
Code:
<%include header.html%>
<center>
<form name='myform' action='db.cgi' method=post>
<%ifnot use_cookie%><input type=hidden name="sid" value=<%session_id%>><%endif%>
<input type=hidden name=db value="<%db%>">
<input type=hidden name=do value="admin_action">
<input type=hidden name="users" value="<%if a_Username%><%a_Username%><%endif%>">
<input type=hidden name="a_Tablename" value="<%db%>">
<%if sdb%>
<!--Subform-->
<input type=hidden name="sdb" value="<%sdb%>">
<input type=hidden name="sdo" value="<%if sdo%><%sdo%><%endif%>">
<input type=hidden name="sfk" value="<%if sfk%><%sfk%><%endif%>">
<%endif%>
<%if q%>
<!--Query objects-->
<input type=hidden name="q" value="<%q%>">
<%endif%>
<table border=1 bgcolor="#FFFFFF" cellpadding=0 cellspacing=0 width="500" valign=top>
<tr><td>
<table border="0" cellspacing="1" cellpadding="2">
<tr>
<td width="163" align="right"><font face="Arial, Helvetica, sans-serif" size="2">User Name: </font></td>
<td width="337">
<%list_users%>
<select name="a_Username">
<%loop loop_users%>
<option value="<%Username%>"><%Username%></option>
<%endloop%>
</select>
<input type="submit" name="admin_action" value="Find User"> <input type="submit" name="sub_delete" value="Delete" onclick="if (document.myform.users.selectedIndex == 0) {return false;} if (!confirm('Do you want to Delete this user?')) return false;">
</td>
</tr>
<tr>
<td width="163" align="right"><font face="Arial, Helvetica, sans-serif" size="2">New
User Name: </font></td>
<td width="337">
<input type="text" name="user" size="25">
</td>
</tr>
<tr>
<td width="163" align="right"><font face="Arial, Helvetica, sans-serif" size="2">Change Password: </font></td>
<td width="337">
<input type="Password" name="a_Password" size="25" value="<%if a_Password%><%a_Password%><%endif%>">
</td>
</tr>
<tr>
<td width="163" align="right"><font face="Arial, Helvetica, sans-serif" size="2">Confirm password: </font></td>
<td width="337">
<input type="Password" name="password_confirm" size="25" value="<%if password_confirm%><%password_confirm%><%else%><%if Password%><%Password%><%endif%><%endif%>">
</td>
</tr>
<tr>
<td width="163" align="right" ><font face="Arial, Helvetica, sans-serif" size="2">Email: </font></td>
<td width="337" >
<input type="text" name="a_Email" size="25" value="<%if a_Email%><%a_Email%><%endif%>">
</td>
</tr>
<tr>
<td width="163" align="right" ><font face="Arial, Helvetica, sans-serif" size="2">Name: </font></td>
<td width="337" >
<input type="text" name="a_Name" size="25" value="<%if a_Name%><% a_Name%><%endif%>">
</td>
</tr>
<tr>
<td width="163" align="right" ><font face="Arial, Helvetica, sans-serif" size="2">Status: </font></td>
<td width="337" > <select name="a_Status">
<option value="Administrator" <%if a_Status eq 'Administrator'%>selected<%endif%>>Administrator
<option value="Not Validated" <%if a_Status eq 'Not Validated'%>selected<%endif%>>Not Validated
<option value="Registered" <%if a_Status eq 'Registered'%>selected<%endif%>>Registered</select>
</td>
</tr>
<tr>
<td width="163" align="right" ><font face="Arial, Helvetica, sans-serif" size="2">Receive Mail: </font></td>
<td width="337" > <select name="a_ReceiveMail">
<option value="No" <%if a_ReceiveMail eq 'No'%>selected<%endif%>>No
<option value="Yes" <%if a_ReceiveMail eq 'Yes'%>selected<%endif%>>Yes</select>
</td>
</tr>
<tr>
<td width="163" align="right" ><font face="Arial, Helvetica, sans-serif" size="2">News letter: </font></td>
<td width="337" > <select name="a_Newsletter">
<option value="No" <%if a_Newsletter eq 'No'%>selected<%endif%>>No
<option value="Yes" <%if a_Newsletter eq 'Yes'%>selected<%endif%>>Yes</select>
</td>
</tr>
I DELETED THE PERMISSION SECTION TO SAVE ROOM HERE
</table>
</td>
</tr>
</table>
<b><font face="Arial, Helvetica, sans-serif" size="2"> </font></b>
</td>
</tr>
</table>
<br>
<table width="500" border="1" cellspacing="0" cellpadding="0">
<tr>
<td height="40">
<div align="center">
<input type="submit" name="sub_edit" value=" Update/Create User ">
</div>
</td>
</tr>
</table>
</form>
</center>
<p><%include footer.html%>