Form doesn't process correctly -- User info 'vanishes' like magic --

[Chezshire]

Hello everyone

 

I added a very simply 'validation' process to our new player forms so as to block bots, and blocked them it has. The problem though, is that it seems to have blocked everyone else as well I've gone back to my old 'bot-friendly' add-user form for the moment, but I would like to get this one working correctly.

 

The basic problem with it appears to be that the notification that a new player has applied does not forward on to the admin page. I know the admin/home page is working correctly as when i uploaded the prior 'non-validating' version and ran a test everything game through just fine.

 

I'm also trying to write better code now and to that end i'm trying to indent properly, but I'm not sure exactly when too and not to indent. As always any help is appreciated

 

 

 

Here is the full code for the page:

\<?php
include ("functions.php");

approveVars(array("id", "submit", "VERIFICATION", "VERCHECK"));

$verifications = array(1=>"verification",
2=>"assurance",
3=>"trustworthy",
4=>"truthfulness");


// ========= DEFINE VARIABLES

$errorText="";
$player=array();

$fields = array("id","username", "password", "password2", "name", "email", "emailprivate", "web", "city", "state", "state2", "country", "comments", "sampleLDB", "fcRequestLDB", "moderator", "approved","aim","yahoo","icq","moderated");
FOREACH ($fields as $thisField) { $player[$thisField] = ""; 
}

if ($id) { $player=readDatabase("SELECT *, DATE_FORMAT(dateadded, '%b %e, %Y') AS added, TO_DAYS(NOW()) - TO_DAYS(lastlogin) AS llogin FROM login where id=$id"); }

$sendNotice = "";
if (!$player["approved"]) { $sendNotice = "true"; 
	}

	if ($submit) 
{

// ================ IF THEY SUBMITTED THE CHANGES, MAKE THEM!

$patterns = array ("/([^\n\r\f])[\n\r\f]+([^\n\r\f])/");
$replace = array ("\\1\n\\2");

FOREACH ($fields as $thisField) 
{
$THISFIELD = strtoupper($thisField);

if (isset($_POST{$THISFIELD})) { ${$THISFIELD} = $_POST[$THISFIELD]; } else { ${$THISFIELD} = ""; 
}
${$THISFIELD} = preg_replace ($patterns, $replace, ${$THISFIELD});
	} // end FOREACH

if (!$id) 
{

if ($PASSWORD != $PASSWORD2 || !$PASSWORD) { $errorText="You must choose a password and you must enter it twice for accuracy. Please go back and submit the form again."; 
	}

	if (preg_match("/[ \(\)\+\.]/",$AIM) || preg_match("/[ \(\)\+\.]/",$YAHOO)) { $errorText="Please only put the screen name in the AIM and Yahoo fields, no comments or special characters."; 
		}

		$existTest = readDatabase("SELECT * FROM login WHERE username=\"$USERNAME\" || email = \"$EMAIL\"",$db);

		if ($existTest["email"] == $EMAIL) 
	{ $errorText = "That email address is already in use, and there's only one account allowed per person!<br>Please go back and submit the form again after making changes."; 
		}

		if ($existTest["username"] == $USERNAME) { $errorText = "That username is already in use. You'll have to choose a different one, I'm afraid!<br>Please go back and submit the form again after making changes."; 
			}

				} // end if no ID

				if (!$USERNAME) 
			{ //if they didn't a name for their profile...
			$errorText="You must choose a username for this profile.<br>Please go back and submit the form again after making changes.";
				} // end if no USERNAME

				if (!$NAME) 
			{ //if they didn't a name for their profile...
			$errorText="You must enter a name or nickname.<br>Please go back and submit the form again after making changes.";
				} // end if no NAME

				if (!$COMMENTS) 
			{ //if they didn't a name for their profile...
			$errorText="You must complete the Bio portion of your player application to be considered for membership with XPG.<br> Do you like dogs? Do you like cats? What kind of music do you listen too? Do you like comic books? We do! Did you see any of the X-Men movies? We sure did! Are you into the X-Men? We obviousily are! Got a favorite character? Tell us about because lord only knows we've built a site to this very concept and its' pretty spiffy if we say so ourselves. Joking aside, we genuinely want to know a little bit about who you are, what your interested in and why your interested in joining XPG's roleplay community.<br>Please go back and submit the form again after making changes.";
				} // end if no NAME

				if (!$SAMPLELDB) 
			{ //if they didn't a fill in their writing sample...
			$errorText="You must submit a writen sample in order to be considered for membership with XPG. It doesn't need to be X-Men specific, it just needs to demonstate that you can write in a coherent and understandable matter and be a few paragraphs long.<br>Please go back and submit the form again after making changes.";
				} // end if no NAME

				if (!$SAMPLELDB) 
			{ //if they didn't a fill in their writing sample...
			$errorText="You must submit a Canon Character (F.C.) selection to be considered for membership to XPG. You can find current F.C.s available for adoption at www.xpg.us/cerebra.php. If you are unsure of who you would like please contact Whedon. <br>Please go back and submit the form again with an F.C. selection.";
				} // end if no NAME

			if ($login != $id && !$moderator) 
		{ //If they're NOT ALLOWED
		$errorText="You cannot edit another's profile unless you have moderator privileges.";
			} // end if no privileges

				if ($moderator != "super" && $id != $login && $player["moderator"]) 
			{ //If they're NOT ALLOWED
			$errorText="You do not have the privileges to edit this profile; it belongs to a moderator.";
				} // end if no privileges

					if ((strtolower($VERIFICATION) != $verifications[$VERCHECK] || !$VERIFICATION) AND !$moderator) 
				{ //if they didn't get the verification right and they're not a moderator...
			$errorText="You did not enter the "Verification" text correctly.</p>";
				} // end if no NAME

				if ($errorText) { errorPage($errorText); 
					}

					if ($STATE2) { $STATE = $STATE2; 
						}

						$WEB = preg_replace ("/http:\/\//","",$WEB);

						if (!$PASSWORD) { $PASSWORD = $player["password"]; }
						if (!$MODERATED) { $MODERATED = $player["password"]; }

						if (!$id) 
							{
							$sql = "INSERT INTO login (username,
							password,
							moderated,
							name,
							email,
							emailprivate,
							web,
							city,
							state,
							country,
							comments,
							sampleLDB, 
							fcRequestLDB
							lastmodified,
							dateadded,
							moderator,
							aim,
							yahoo,
							icq,
							approved) VALUES(\"$USERNAME\",
							\"$PASSWORD\",
							\"$MODERATED\",
							\"$NAME\",
							\"$EMAIL\",
							\"$EMAILPRIVATE\",
							\"$WEB\",
							\"$CITY\",
							\"$STATE\",
							\"$COUNTRY\",
							\"$COMMENTS\",
							\"$SAMPLELDB\", 
							\"$FCREQUESTLDB\",
							NOW(),
							NOW(),
							\"$MODERATOR\",
							\"$AIM\",
							\"$YAHOO\",
							\"$ICQ\",
							\"$APPROVED\")";
							$action = "Submitted";
							$action2 = '<h2>Your member profile has been submitted! Once it\'s approved by a moderator, you will have access to the the site. <a href="/home.php">Click here to return to the main ' . $siteName . ' page.</a></h2>';
								} else {
							$sql = "UPDATE login SET username=\"$USERNAME\",
							password=\"$PASSWORD\",
							moderated=\"$MODERATED\",
							name=\"$NAME\",
							email=\"$EMAIL\",
							emailprivate=\"$EMAILPRIVATE\",
							web=\"$WEB\",
							city=\"$CITY\",
							state=\"$STATE\",
							country=\"$COUNTRY\",
							comments=\"$COMMENTS\",
							sampleLDB=\"$SAMPLELDB\", 
							fcRequestLDB=\"$FCREQUESTLDB\",
							moderator=\"$MODERATOR\",
							aim=\"$AIM\",
							yahoo=\"$YAHOO\",
							icq=\"$ICQ\",
							approved=\"$APPROVED\"
							WHERE id=$id";
							$action = "Updated";
							$action2 = '<h2>Member profile has been updated and is active immediately!</h2>';
								} // end if $id

							if ($APPROVED == "REMOVE") 
						{
						$sql="DELETE FROM login WHERE id=$id";
						$action = "Deleted";
						$action2 = '<h2>Member profile has been deleted from the database.</h2>';
							} // end if removing

							if ($id && !$moderator && $id != $login) 
						{
						$action = "Not Modified";
						$action2 = "<h2>You really shouldn't be monkeying around with this unless you're a moderator.<br>Go on, scoot!</h2>";
							} elseif ($id && $moderator=="true" && $id != $login && $player["moderator"]) {
						$action = "Not Modified";
						$action2 = "<h2>You really shouldn't be monkeying around with the profile of another moderator.<br>Go on, scoot!</h2>";
							} else {
						$result = mysql_query($sql);
							} // end if password

						echo "<!-- SQL: $sql -->\n";

						$pageTitle="Profile " . $action . " Successfully!";
						include ("header.php");

						if (mysql_error()) { echo "<!-- ".mysql_errno(). " : (line 130) " . mysql_error() . " -->\n\n";
							} else {

						if (!$APPROVED && !$id) {
						mail("Ditko <[email protected]>", "[$siteName] New Player", "A new member has submitted a profile to the $siteName website.\n\nName: $NAME\nUsername: $USERNAME\n\nVisit this URL to approve the member:\nhttp://www.xpg.us/home.php", "Return-Path: Ditko <[email protected]>\nErrors-To: Ditko <[email protected]>\nFrom: Ditko <[email protected]>\nReply-To: Ditko <[email protected]>\nX-Mailer: PHP/" . phpversion());
						} // end if not approved

						if ($APPROVED && $sendNotice && $EMAIL) {
						mail("$EMAIL", "[$siteName] Welcome to $siteName!", "Welcome, $NAME, to $siteName!\n\nThis notice is to inform you that your username has been approved, and you may now log in to $siteName and submit your character bio to Cerebra for approval. When you are finished editing your character bio, click the submit button and we will review it for approval. You can usually expect a notice regarding character approval within 1 week.\n\nVisit this URL and click the \"Authenticate\" button to log in:\nhttp://www.xpg.us\n\nUsername: $USERNAME\nPassword: $PASSWORD", "Return-Path: Ditko <[email protected]>\nErrors-To: Ditko <[email protected]>\nFrom: Ditko <[email protected]>\nReply-To: Ditko <[email protected]>\nX-Mailer: PHP/" . phpversion());
						} // end if first time approved

						} // end if error

						if (!$id) { $id = mysql_insert_id(); 
							}

							?>
							<center>
							<table height="95%" width="75%">
							<tr>
							<td align="center" valign="middle">
							<h1 class="spaceafter">Profile <?php echo $action; ?> Successfully!</h1>
							<p class="spaceafter" align="center">
							<?php echo $action2; 

							if ($id && $APPROVED && $APPROVED != "REMOVE") 
						{
						echo "\n<h2><a href=\"/profile.php?id=$id\">Click here to view the member's profile.<a/></h2>";
							} // end IF APPROVED



							echo "<!-- SQL: $sql -->\n";
							?>
							</td>
							</tr>
							</table>
							<?php
							include ("footer.php");
							die;
								} // -------- END SUBMIT2!! ------------

							if ($id) 
						{
						$player = preg_replace ("/\"/",""", $player);
						$player["comments"] = preg_replace ("/[\r\f\n]+/","\n\n", $player["comments"]);
							} // end if id

							$pageTitle="Add $siteName Player";
							include ("header.php");
							?>		
							<center>

							<!-- must match "form" action  -->	
							<table border="0" cellpadding="6" cellspacing="0" width="95%">
							<form name="form" action="/adduser.php" method="post" enctype="multipart/form-data">
							<tr><td colspan="3">
							<center>
							<h1><font color="#A5B9D5"><?php
							if ($id) 
								{ echo "Edit "; 
								} else { 
								echo "Add "; } // end if ID

								echo $siteName;						
								?> Player</font></h1>
								<?php

								if ($id) 
							{
							echo "<p><a href='/profile.php?id=$id' target='_blank'>View this profile in a new window.</a></p>";					
								} // end if ID

								?>	
								</center></td></tr>
								<tr><td colspan="3" valign="middle" height="20" align="center">
								<hr color="#050F1D" size="5">
								</td></tr>
								<?php

								echo "<!-- Logged in as: $login -->\n";
								echo "<!-- Moderator: $moderator -->\n\n";
								echo "<!-- Profile ID: $id -->\n";
								echo "<!-- Profile Username: " . $player["username"] . " -->\n";

								?>					
								<tr>
								<td width="40%" valign="top" align="right"><p><b>Username:</b></p>
								</td>
								<input type="hidden" name="id" value="<?php echo $player["id"]; ?>"><td width="10" valign="top"></td>
								<td valign="top">
								<p><input type="text" name="USERNAME" size="45" value="<?php echo $player["username"]; ?>"></p>
								<p><span class='fineprint'>Use your first name, middle name or first name and last initial, not a codename; this will only confuse the admins, especially if you play more than one character.</span></p></td>
								</tr>

								<?php
								if ($id) 
							{
							$sql = "SELECT id,codename from cerebra WHERE player=$id ORDER by codename";
							$result = mysql_query($sql);
							if (mysql_num_rows($result)) 
						{
						echo "<tr><td align='right' valign='top'><p><b>Characters:</b></p></td>
						<td width='10'> </td><td valign='top'><p>";

						$myChars = array();
						WHILE ($theseChars = mysql_fetch_assoc($result)) 
					{
					array_push($myChars, "<a href='/cerebra/display.php?id=" . $theseChars["id"] . "'>" . $theseChars["codename"] . "</a>");
						} // end WHILE

						$myCharString = implode(", ", $myChars);
						echo $myCharString;

						echo "</p></td></tr>\n";

						} // end if characters to link

							} // end if id
							?>

							<tr>
							<td width="40%" valign="top" align="right"><p><b>Password:</b><br>
							<span class='fineprint'><font color="red">Leave blank unless changing.</font><br>Repeat twice for accuracy.</p>
							</td>
							<td width="10"></td>
							<td valign="top"><p><input type="password" name="PASSWORD" size="45" value=""><br>
							<input type="password" name="PASSWORD2" size="45" value=""></td>
							</tr>
							<tr>
							<td width="40%" valign="top" align="right"><p><b>Email address:</b></p></td>
							<td width="10"></td>
							<td valign="top">
							<p><input type="text" name="EMAIL" size="45" value="<?php echo $player["email"]; ?>"><br>
							<input type="checkbox" name="EMAILPRIVATE" value="true"
							<?php if ($player["emailprivate"]) { echo " checked"; } ?>> <label for="EMAILPRIVATE"><span class='fineprint'>Do not post on the <?php echo $siteName; ?> website</span></label></td>
							</tr>

							<tr>
							<td width="40%" valign="top" align="right"><p><b>AOL/AIM:</b><br>
							<span class="fineprint"><i>AIM, ICQ or Y!M required for membership on XPG.</p></td>
							</td>
							<td width="10"></td>
							<td valign="top"><p><input type="text" name="AIM" size="45" value="
							<?php echo $player["aim"]; ?>"></p></td>
							</tr>				

							<tr>
							<td width="40%" valign="top" align="right"><p><b>Yahoo:</b><br>
							<span class="fineprint"><i>AIM, ICQ or Y!M required for membership on XPG.</p></td>
							</td>
							<td width="10"></td>
							<td valign="top"><p><input type="text" name="YAHOO" size="45" value="<?php echo $player["yahoo"]; 																?>"></p></td>
							</tr>				

							<tr>
							<td width="40%" valign="top" align="right"><p><b>ICQ:</b><br>
							<span class="fineprint"><i>AIM, ICQ or Y!M required for membership on XPG.</p></td>
							</td>
							<td width="10"></td>
							<td valign="top"><p><input type="text" name="ICQ" size="45" value="<?php echo $player["icq"]; ?>"></p></td>
							</tr>				

							<tr><td colspan="3" valign="middle" height="20" align="center"><hr color="#050F1D" size="5"></td></tr>

							<tr>
							<td width="40%" valign="top" align="right"><p><b>Name:</b></p>
							</td>
							<td width="10" valign="top"></td>
							<td valign="top">
							<p><input type="text" name="NAME" size="45" value="<?php echo $player["name"]; ?>"></td>
							</tr>
							<tr>
							<td width="40%" align="right" valign="top"><p><b>City:</b></p></td>
							<td width="10" valign="top"></td>
							<td valign="top">
							<p><input type="text" name="CITY" size="45" value="<?php echo $player["city"]; ?>"></p></td></tr>
							<tr>
							<td width="40%" align="right" valign="top"><p><b>State/Province:</b></p></td>
							<td width="10" valign="top"></td>
							<td valign="top"><p><select name="STATE" size="1">
							<option value="">Choose US State</option>
								<?php
							$counter = 0;
							while ($counter < count($stateAbbr)) 
						{
						if ($player["state"] == $stateAbbr[$counter]) {$selector = " selected";} else {$selector = ""; }
						echo "<option value=\"$stateAbbr[$counter]\"$selector>$stateName[$counter]\n";
						$counter = $counter +1;
							} ?>
							</select><br><font size="2"> or enter below if non-U.S.<br>
							<input type="text" name="STATE2" size="45" value="<?php if ($player["country"]!="US") 
						{ echo $player["state"]; } ?>">
						</td></tr>
						<tr>
						<td width="40%" align="right" valign="top"><p><b>Country</b></p></td>
						<td width="10" valign="top"></td>
						<td valign="top">
						<p><select name="COUNTRY">
						<?php
						$counter = 0;
						while ($counter < count($countryAbbr)) 
					{
					$selector="";
					if ($countryAbbr[$counter] == $player["country"] || $countryName[$counter] == $player["country"]) {$selector = " selected";} else {$selector = ""; }
					echo "<option value=\"$countryAbbr[$counter]\"$selector>$countryName[$counter]\n";
					$counter = $counter +1;
		 				} 
						?>
		 				</select></p></td></tr>
		 				<tr>
		 				<td width="40%" valign="top" align="right"><p><b>Website(s):</b><br>
		 				<span class="fineprint"><i>Each web address on a separate line. Use this format:<br></i>
		 				<kbd><font color="#dc143c">www.domain.com^Site Name</font></kbd><br>
		 				<i>Note the "^" sign separating the URL from the name.</p></td>
			 			<td width="10" valign="top"></td>
			 			<td valign="top">
						<p class="nospace"><textarea name="WEB" cols="45" rows="4"><?php echo $player["web"]; 					 	  ?>
		 				</textarea></p>
		 				</td>
		 				</tr>
		 				<tr>
		 				<td width="40%" align="right" valign="top"><p><b>Your Bio:</b><br>
		 				<span class="fineprint"> Your <i>Bio</i> is meant to be about you the player, not <i>one of</i> or <i>all of</i> the characters who you wish to play on XPG. We like to know a little bit about <i>who</i> is applying for membership. Who you are, how old are you, what you like, how you heard about 'XPG', etc. So please tell us a little bit about you.<br>
		 				<span class='fineprint'><font color="red">Failure to fill out the player Bio will result in a denial of membership.<br>
		 				</p>
		 				</td>
		 				<td width="10" valign="top"></td>
			 			<td valign="top">
		 				<p><textarea name="COMMENTS" cols="45" rows="10"><?php echo $player["comments"]; ?></textarea>
		 				</p>
		 				</td>
		 				<tr>
		 				<td width="40%" align="right" valign="top"><p><b>Writing Sample:</b><br>
		 				<span class="fineprint"> In order to preserve the quality of our game, we now require a <i>written sample</i> from all perspective members of XPG. Your <i>writing sample</i> should be at least two paragraphs long and a minimum or 400 words. Please use this field to submit your <i>written sample</i> in. If you need any additional help and/or guidance with the writing of a sample, please contact <a href="mailto:[email protected]">Byrne</a><br>
			 			<span class='fineprint'><font color="red">Failure to submit a written sample within three days of application will result in a denial of membership.<br></p>
		 				</td>
						<td width="10" valign="top"></td>
		 				<td valign="top">
		 				<p><textarea name="SAMPLELDB" cols="45" rows="20"><?php echo $player["sampleLDB"]; ?></textarea>
		 				</p>
		 				</td>
		 				</tr>
		 				<tr>
		 				<td width="40%" align="right" valign="top"><p><b>Character Request:</b><br>
		 				<span class="fineprint"> XPG requires that all participants play at least one <i>Canon Character</i>, also known as an F.C. at all times before an <i>Original Character</i> or O.C. will be considered. The reason, for those curious is because in the past we have had many people join XPG, create an O.C., post several times, and then vanish with no ryhme, reason or regard for the other players/characters who had become involved with theirs. As such the Site Staff has had to step in and take over the play of such characters and work to exit them gracefully from gameplay. If you need assistance in finding an F.C. to play, please contact <a href="mailto:[email protected]">WHEDON</a> for assistance<br>
		 				<span class='fineprint'><font color="red">Failure to submit an F.C. request within three days of application<br> will result in a denial of membership.<br></p>
		 				</td>
		 				<td width="10" valign="top"></td>
		 				<td valign="top">
		 				<p>
		 				<textarea name="FCREQUESTLDB" cols="45" rows="10"><?php echo $player["fcrequestLDB"]; ?>
		 				</textarea>
		 				</p>
		 				</td>
		 				</tr>

		 				<tr><td colspan="3" valign="middle" height="20" align="center"><hr color="#050F1D" size="5"></td></tr>

		 				<?php

		 				if (!$id && !$moderator) 
					{
		 			?>
		 			<tr>
		 			<td align="right" valign="middle"><p><b>Verification:</b><br>
					<span class='fineprint'>Type the word you see at the right in the box below it. (Just to make sure you're a real person and not a spambot. We don't allow machines to play.)</span></p></td>
		 			<td width="10" valign="top"></td>
		 			<td valign="middle"><?php

		 			srand((double)microtime()*1000000);
		 			$checker = rand(1,4);

		 			echo "<IMG SRC='verification/$checker.gif'><br>\n";
		 			echo "<INPUT TYPE='hidden' NAME='VERCHECK' value='$checker'>";

		 			?>					
			 		<input type="text" name="VERIFICATION" size="25" value=""></td>
					</tr>
			 		<?php

				 		} // end if

			 			echo "<!-- MODERATOR? $moderator -->\n";
			 			if ($player["id"] && $moderator) 
			 		{
			 		?>
			 		<tr>
			 		<td width="40%" align="right" valign="top"><p><b>Date Created:</b></p>
			 		</td>
			 		<td width="10" valign="top"></td>
			 		<td valign="top">
			 		<p><b><?php echo $player["added"]; ?></b></p></td></tr>

			 		<tr>
			 		<td width="40%" align="right" valign="top"><p><b>Last Login:</b></p>
			 		</td>
			 		<td width="10" valign="top"></td>
			 		<td valign="top">
			 		<p><b><?php
			 		if ($player["llogin"] > 14) { echo "<font color='red'>"; }
			 		echo $player["llogin"];
			 		if ($player["llogin"] > 14) { echo "</font>"; }
			 		?></b> Days Ago</p></td></tr>

			 		<tr>
			 		<td width="40%" align="right" valign="top"><p><b>Approved?</b></p>
			 		</td>
			 		<td width="10" valign="top"></td>
			 		<td valign="top">
			 		<p><select name="APPROVED" size="1">
			 		<option value="true">YES!</option>
			 		<option value="away"<?php if ($player["approved"]=="away") { echo " selected"; } ?>> (away) </option>
			 		<option value=""<?php if (!$player["approved"]) { echo " selected"; } ?>>no</option>
			 		<?php if ($moderator =="super") 
			 	{ echo "<option value=\"REMOVE\">REMOVE</option>\n"; 
				 	} ?>
			 		</select></p></td></tr>
			 		<tr>
			 		<td width="40%" align="right" valign="top"><p><b>Moderate Posts?</b></p>
					</td>
					<td width="10" valign="top"></td>
					<td valign="top">
					<p><select name="MODERATED" size="1">
					<option value="">No</option>
					<option value=""<?php if ($player["moderated"]) { echo " selected"; } ?>>YES!</option>
					</select></p></td></tr>

					<?php

					if ($player["id"] && $moderator=="super") 
				{
				?>
				<tr>
				<td width="40%" align="right" valign="top"><p><b>Moderator?</b></p>
				</td>
				<td width="10" valign="top"></td>
				<td valign="top">
				<p><select name="MODERATOR" size="1">
				<option value="">No</option>
				<option value="true"<?php if ($player["moderator"]=="true") { echo " selected"; } ?>>YES</option><?php
				echo "\n<option value=\"super\"";
				if ($player["moderator"]=="super") { echo " selected"; }
				echo "> = SUPER = </option>";
				?>
				</select></p></td></tr>
				<?php
					} // end if moderator
					?>
					<tr height="20">
					<td colspan="3" valign="middle" height="20" align="center">
					<hr color="#050F1D" size="5">
					</td>
					</tr>
					<?php 
					} else {

					echo "<input type='hidden' name='APPROVED' value='" . $player["approved"] . "'>\n";

						} // end if moderator fields
						?>
						<tr>
						<td align="center" valign="middle" width="40%"></td>
						<td colspan="2"><font color="#d3d3d3"><b><input type="submit" value="Send Form" name="submit"></b></font></td>
						</tr>
						</table>
						</center>

						</form>
						</body>

						</html>