ok here's the rest:
<h2>Edit Member Information</h2>
<div align="center"><form action="admin.php" method="post">
<input type="hidden" name="action" value="select">
<table border="0" cellspacing="0" cellpadding="2">
<tr><td>ID: </td><td><input type="text" name="id" size="80" class="form"></td></tr>
<tr><td>Name: </td><td><input type="text" name="name" size="80" class="form"></td></tr>
<tr><td>Email: </td><td><input type="text" name="email" size="80" class="form"></td></tr>
<tr><td>URL: </td><td><input type="text" name="url" size="80" class="form"></td></tr>
<tr><td>Country: </td><td><input type="text" name="country" size="80" class="form"></td></tr>
<? if ($enablefave == 'Y'){ ?>
<tr><td><?=$whatfave?>: </td><td><input type="text" name="fave" size="80" class="form"></td></tr>
<? } ?>
<tr><td colspan="2"><input type="Submit" class="button"></td></tr></table>
</form></div>
<? } elseif ($action == "select"){
//the search results from the Edit Member screen
?>
<h2>Edit Member Information</h2> <?
if ($id == "")
{$id = '%';}
if ($name == "")
{$name = '%';}
if ($email == "")
{$email = '%';}
if ($url == "")
{$url = '%';}
if ($country == "")
{$country = '%';}
if ($enablefave == 'Y'){
if ($fave == "")
{$fave = '%';}
// select the right records
$result = mysql_query ("SELECT * FROM $table WHERE id LIKE '$id' AND name LIKE '%$name%' AND email LIKE '%$email%' AND url LIKE '%$url%' AND country LIKE '$country%' AND fave LIKE '%$fave%'");
} else {
$result = mysql_query ("SELECT * FROM $table WHERE id LIKE '$id' AND name LIKE '%$name%' AND email LIKE '%$email%' AND url LIKE '%$url%' AND country LIKE '$country%'");
}
if ($row = mysql_fetch_array($result)) {
do {
// display the search results
?>
<div align="center"><form action="admin.php" method="post">
<input type="hidden" name="action" value="update">
<table border="0" cellspacing="0" cellpadding="2">
<tr><td>ID: <input type="text" name="id" size="20" class="form" value="<?=$row["id"]?>"></td><td>Hide Email: <input type="text" name="hideemail" size="20" class="form" value="<?=$row["hideemail"]?>"><br>
("n" means Show Email, "h" means Hide Email)</td></tr>
<tr><td>Name: </td><td><input type="text" name="name" size="80" class="form" value="<?=$row["name"]?>"></td></tr>
<tr><td>Email: </td><td><input type="text" name="email" size="80" class="form" value="<?=$row["email"]?>"></td></tr>
<tr><td>URL: </td><td><input type="text" name="url" size="80" class="form" value="<?=$row["url"]?>"> (<a href="<?=$row["url"]?>" target="_blank">check site</a>)</td></tr>
<tr><td>Country: </td><td><input type="text" name="country" size="80" class="form" value="<?=$row["country"]?>"></td></tr>
<? if ($enablefave == 'Y'){ ?>
<tr><td><?=$whatfave?>: </td><td><input type="text" name="fave" size="80" class="form" value="<?=$row["fave"]?>"></td></tr>
<? } ?>
<tr><td>Comments: </td><td><textarea rows="3" name="comments" cols="40" class="form"><?=$row["comments"]?></textarea></td></tr>
<tr><td>Action: </td><td><select name="what" class="button">
<option value="up" SELECTED>Update</option>
<option value="del">Delete</option></select></td></tr>
<tr><td colspan="2"><input type="Submit" class="button"></td></tr></table>
</form></div>
<?} while($row = mysql_fetch_array($result));
//if nothing was found, display the following
} else {print "<p>Sorry, no records were found! Please press the back button on your browser to try again. <br>
Tip: you don't have to fill in all the fields in the Edit form. Filling in just one or two will return all members with that information, it works like a search form. :)</p>";}
} elseif ($action == "update"){
if ($what == "up"){
//Update a member through the Edit Member screen
if ($enablefave == 'Y'){
$query = "UPDATE $table SET name='$name', email='$email', url='$url', country='$country', comments='$comments', hideemail='$hideemail', apr='y', fave='$fave' WHERE id='$id'";
mysql_query($query);
} else {
$query = "UPDATE $table SET name='$name', email='$email', url='$url', country='$country', comments='$comments', hideemail='$hideemail', apr='y' WHERE id='$id'";
mysql_query($query);
}
// Delete a member through the Edit Member screen
} elseif ($what == "del"){
$query = "DELETE from $table WHERE id='$id'";
mysql_query($query);
}
//change the last updated date
$query = "UPDATE $table_u SET date='$today' WHERE id='1'";
mysql_query($query);
echo "<p>This member was updated succesfully! Click <a href=\"admin.php\">here</a> to return to the Admin Panel.</p>"; ?>
<? } elseif ($action == "emailall"){
//email all members
?>
<p>Using this function, you can email all the members of your fanlisting through a script. You won't have to start up your email program, it can all be done online.<br>
Please note that once you click the send button, you cannot undo or stop the process. Pressing the Send button twice will result in everyone receiving two emails, so please use this function responsibly!</p>
<p>To see what your email will look like once it's sent, select "Yourself Only" in the "Send It To" drop down box. This will send the below email to yourself, to the address specified in the config.php file. If you select "All Members", the email will be sent to everyone on your member list.</p>
<p>Please feel free to change the below email as needed.</p>
<p><strong>Please note that if your member list is longer than 100 members, the Sent page might take a while to load! This is perfectly normal, please don't refresh or close the window...wait until the page is fully loaded before doing anything else!</strong></p>
<div align="center"><form action="admin.php" method="post">
<input type="hidden" name="action" value="sendall">
<table border="0" cellspacing="0" cellpadding="2">
<tr><td>Subject: </td><td><input type="text" name="subject" size="80" class="form" value="The <?=$sitename?> Fanlisting Has Moved!"></td></tr>
<tr><td>Body: </td><td><textarea rows="6" name="body" cols="70" class="form">Hi,
You're receiving this email because you're a member of <?=$sitename?>. I wanted to let you know that I moved the fanlisting over a new address.
The new url is <?=$siteurl?>.
I would really appreciate it if you could update your links and bookmarks when you have a free moment. :) Thanks so much in advance!
<?=$adminname?>__
<?=$admincollective?></textarea></td></tr>
<tr><td>Send it to: </td><td><select name="what" class="button">
<option value="you" SELECTED>Yourself Only</option>
<option value="all">All Members</option></select></td></tr>
<tr><td colspan="2"><input type="Submit" class="button" value="Send!"></td></tr></table>
</form></div>
<? } elseif ($action == "sendall"){
//send the email just to you
if ($what == "you"){
$recipient = "$adminemail";
$subject = "$_POST[subject]";
$mailheaders = "From: $adminemail\n";
$mailheaders .= "Reply-To: $adminemail\n\n";
mail($recipient, $subject, "$_POST[body]", "$mailheaders");
echo "<p>The email has been sent to yourself. Check your email to make sure this is how you want it to look, and press the back button to return to the previous screen.</p>";
//send it to everyone
} elseif ($what == "all"){
$query="SELECT * FROM $table";
$result=mysql_query($query);
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
$email=mysql_result($result,$i,"email");
$name=mysql_result($result,$i,"name");
$url=mysql_result($result,$i,"url");
$msg = stripslashes($_POST[body]);
$recipient = "$email";
$subject = "$_POST[subject]";
$mailheaders = "From: $adminemail\n";
$mailheaders .= "Reply-To: $adminemail\n\n";
mail($recipient, $subject, $msg, $mailheaders);
echo "<p>This email has been sent to:<br>";
echo "$name :: $email<br>";
++$i; }
} ?>
<? } elseif ($what == "invalid"){ ?>
<p><B>Invalid login name or password!</B><BR>Please press the back button on your browser to try again.</p>
<? }
//the footer navigation ?>
<div align="center"><a href="admin.php">Approve Members</a> :: <a href="admin.php?action=edit">Edit Members</a> :: <a href="admin.php?action=emailall">Email Members</a> :: <a href="admin.php?action=logout">Logout</a></div>
<div align="center" style="border-top: 1px solid #404040; padding-top:5px; margin-top:5px;">
© Copyright <a href="http://nothing-less.net" target="_blank">Sasha</a>, 2003. All Rights Reserved.<br>PHPFanBase v2.0</div>
<? echo "</body></html>";
?>