Join.php
[code]
<?php require_once('../Connections/Frozen.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue ="", $theNotDefinedValue ="") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue !="") ?"'". $theValue ."'": "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue !="") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue !="") ?"'". doubleval($theValue) ."'": "NULL";
      break;
    case "date":
      $theValue = ($theValue !="") ?"'". $theValue ."'": "NULL";
      break;
    case "defined":
      $theValue = ($theValue !="") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .="?". htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) {
  $insertSQL = sprintf("INSERT INTO joining (Realname, Charname, Mainchar, `Class`, Race, `Level`, Roleplay) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['Realname'], "text"),
                       GetSQLValueString($_POST['Charname'], "text"),
                       GetSQLValueString($_POST['Mainchar'], "text"),
                       GetSQLValueString($_POST['Class'], "text"),
                       GetSQLValueString($_POST['Race'], "text"),
                       GetSQLValueString($_POST['Level'], "text"),
                       GetSQLValueString($_POST['Roleplay'], "text"));

  mysql_select_db($database_Frozen, $Frozen);
  $Result1 = mysql_query($insertSQL, $Frozen) or die(mysql_error());

  $insertGoTo ="home.html";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ?"&":"?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
?><!DOCTYPE html PUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type"content="text/html; charset=iso-8859-1"/>
<title>Untitled Document</title>
<link href="frozen.css" rel="stylesheet" type="text/css" />
</head>

<body topmargin="1"leftmargin="3"bottommargin="1"rightmargin="3"bgcolor="#000000">

<form method="post"name="form2"action="<?php echo $editFormAction; ?>">
  <table align="center" class="text">
    <tr valign="baseline">
      <td nowrap align="right">Real Name:</td>
      <td><input type="text"name="Realname"value=""size="32"></td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Char Name:</td>
      <td><input type="text"name="Charname"value=""size="32"></td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Main char:</td>
      <td><select name="Mainchar">
        <option value="yes"<?php if (!(strcmp("yes",""))) {echo "SELECTED";} ?>>Yes</option>
        <option value="No"<?php if (!(strcmp("No",""))) {echo "SELECTED";} ?>>No</option>
      </select>
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Class:</td>
      <td><select name="Class">
        <option value="Mage">Mage</option>
        <option value="Paladin">Paladin</option>
        <option value="Priest">Priest</option>
        <option value="Warrior">Warrior</option>
        <option value="Rogue">Rogue</option>
        <option value="Warlock">Warlock</option>
        <option value="Druid">Druid</option>
        <option value="Shaman">Shaman</option>
      </select>
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Race:</td>
      <td><select name="Race">
        <option value="Draenei">Draenei</option>
        <option value="Humans">Humans</option>
        <option value="Gnomes">Gnomes</option>
        <option value="Dwarfs">Dwarfs</option>
        <option value="Night Elfs">Night Elfs</option>
      </select>
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Level:</td>
      <td><select name="Level">
<option value="lvl1">1</option>
<option value="lvl2">2</option>
<option value="lvl3">3</option>
<option value="lvl4">4</option>
<option value="lvl5">5</option>
<option value="lvl6">6</option>
<option value="lvl7">7</option>
<option value="lvl8">8</option>
<option value="lvl9">9</option>
<option value="lvl10">10</option>
<option value="lvl11">11</option>
<option value="lvl12">12</option>
<option value="lvl13">13</option>
<option value="lvl14">14</option>
<option value="lvl15">15</option>
<option value="lvl16">16</option>
<option value="lvl17">17</option>
<option value="lvl18">18</option>
<option value="lvl19">19</option>
<option value="lvl20">20</option>
<option value="lvl21">21</option>
<option value="lvl22">22</option>
<option value="lvl23">23</option>
<option value="lvl24">24</option>
<option value="lvl25">25</option>
<option value="lvl26">26</option>
<option value="lvl27">27</option>
<option value="lvl28">28</option>
<option value="lvl29">29</option>
<option value="lvl30">30</option>
<option value="lvl31">31</option>
<option value="lvl32">32</option>
<option value="lvl33">33</option>
<option value="lvl34">34</option>
<option value="lvl35">35</option>
<option value="lvl36">36</option>
<option value="lvl37">37</option>
<option value="lvl38">38</option>
<option value="lvl39">39</option>
<option value="lvl40">40</option>
<option value="lvl41">41</option>
<option value="lvl42">42</option>
<option value="lvl43">43</option>
<option value="lvl44">44</option>
<option value="lvl45">45</option>
<option value="lvl46">46</option>
<option value="lvl47">47</option>
<option value="lvl48">48</option>
<option value="lvl49">49</option>
<option value="lvl50">50</option>
<option value="lvl51">51</option>
<option value="lvl52">52</option>
<option value="lvl53">53</option>
<option value="lvl54">54</option>
<option value="lvl55">55</option>
<option value="lvl56">56</option>
<option value="lvl57">57</option>
<option value="lvl58">58</option>
<option value="lvl59">59</option>
<option value="lvl60">60</option>
<option value="lvl61">61</option>
<option value="lvl62">62</option>
<option value="lvl63">63</option>
<option value="lvl64">64</option>
<option value="lvl65">65</option>
<option value="lvl66">66</option>
<option value="lvl67">67</option>
<option value="lvl68">68</option>
<option value="lvl69">69</option>
<option value="lvl70">70</option>



      </select>
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">Roleplaying:</td>
      <td><select name="Roleplay">
        <option value="Yes">Yes</option>
        <option value="Sometimes">Sometimes</option>
		<option value="None">None</option>
      </select>
      </td>
    </tr>
    <tr valign="baseline">
      <td nowrap align="right">&nbsp;</td>
      <td><input type="submit"value="Join Our Cause"></td>
    </tr>
  </table>
  <input type="hidden"name="MM_insert"value="form2">
</form>
<p>&nbsp;</p>
</body>
</html>
[/code]

pmembers.php
[code]
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_Frozen = "localhost";
$database_Frozen = "frozencrusaders_frozen";
$username_Frozen = "frozencrusaders_root";
$password_Frozen = "hoef je niet te zien";
$Frozen = mysql_pconnect($hostname_Frozen, $username_Frozen, $password_Frozen) or trigger_error(mysql_error(),E_USER_ERROR); 

mysql_select_db($database_Frozen, $Frozen);
$query_Recordset1 = "SELECT * FROM joining where member=0";
$Recordset1 = mysql_query($query_Recordset1, $Frozen) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<link href="/frozen.css" rel="stylesheet" type="text/css" />
</head>

<body topmargin="50"leftmargin="3"bottommargin="1"rightmargin="3" bgcolor="#000000">
<table width="800" border="0" class="text" align="center">
  <tr>
    <td class="text"><a href="/login.php" class="text">Recruiting officer login </a></td>
  </tr>
  <tr>
    <td height="23" class="text">&nbsp;</td>
    <td class="text">&nbsp;</td>
    <td class="text">&nbsp;</td>
    <td class="text">&nbsp;</td>
  </tr>
  <tr>
    <td width="237" height="23" class="text">Char name </td>
    <td width="174" class="text">Race</td>
    <td width="236" class="text">Class</td>
    <td width="60" class="text">Level</td>
  </tr>
  <tr>
    <td class="textwhite">&nbsp;</td>
    <td class="textwhite">&nbsp;</td>
    <td class="textwhite">&nbsp;</td>
    <td class="textwhite">&nbsp;</td>
  </tr>

    <?php do { ?>  
	  <tr>
      <td class="textwhite"><?php echo $row_Recordset1['Charname']; ?></td>
      <td class="textwhite"><?php echo $row_Recordset1['Race']; ?></td>
      <td class="textwhite"><?php echo $row_Recordset1['Class']; ?></td>
      <td class="textwhite"><?php echo $row_Recordset1['Level']; ?></td>
	  </tr>
      <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>

</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
[/code]

Admin_recruit.php
[code]
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_Frozen = "localhost";
$database_Frozen = "frozencrusaders_frozen";
$username_Frozen = "frozencrusaders_root";
$password_Frozen = "Gaat je niks aan";
$Frozen = mysql_pconnect($hostname_Frozen, $username_Frozen, $password_Frozen) or trigger_error(mysql_error(),E_USER_ERROR);
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE joining SET member=%s WHERE Charname=%s",
                       GetSQLValueString($_POST['member'], "int"),
                       GetSQLValueString($_POST['Charname'], "text"));

  mysql_select_db($database_Frozen, $Frozen);
  $Result1 = mysql_query($updateSQL, $Frozen) or die(mysql_error());

  $updateGoTo = "/admin_recruit.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
}

$Frozen = mysql_pconnect($hostname_Frozen, $username_Frozen, $password_Frozen) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database_Frozen, $Frozen);
$query_Recordset1 = "SELECT * FROM joining where member=0";
$Recordset1 = mysql_query($query_Recordset1, $Frozen) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<link href="/frozen.css" rel="stylesheet" type="text/css" />
</head>

<body topmargin="50"leftmargin="3"bottommargin="1"rightmargin="3" bgcolor="#000000">
<form id="form1" name="form1" method="POST" action="<?php echo $editFormAction; ?>">
  <table width="800" border="0" class="text" align="center">
    <tr>
      <td width="166" height="23" class="text">Char name </td>
      <td width="132" class="text">Race</td>
      <td width="134" class="text">Class</td>
      <td width="25" class="text">Level</td>
      <td width="211" class="text">Actions</td>
    </tr>
    <tr>
      <td class="textwhite">&nbsp;</td>
      <td class="textwhite">&nbsp;</td>
      <td class="textwhite">&nbsp;</td>
      <td class="textwhite">&nbsp;</td>
      <td class="textwhite">&nbsp;</td>
    </tr>
    <?php do { ?>
    <tr>
      <?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?>
      <td height="34" class="textwhite"><?php echo $row_Recordset1['Charname']; ?></td>
      <td class="textwhite"><?php echo $row_Recordset1['Race']; ?></td>
      <td class="textwhite"><?php echo $row_Recordset1['Class']; ?></td>
      <td class="textwhite"><?php echo $row_Recordset1['Level']; ?></td>
      <td class="textwhite" align="center"> <input name="Charname" type="hidden" id="Charname" value="<?php echo $row_Recordset1['Charname']; ?>" />
        <input name="member" type="hidden" id="member" value="1" />
        <input type="submit" name="Submit" value="Make Member" />
        / <a href="recordDelete.php?Charname=<?php echo $row_Recordset1['Charname'] ?>" class="textwhite">delete</a> </td>
      <?php } // Show if recordset not empty ?>
    </tr>
    <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
  </table>
  <input type="hidden" name="MM_update" value="form1">
</form>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
[/code]

rmembers.pho
[code]
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_Frozen = "localhost";
$database_Frozen = "frozencrusaders_frozen";
$username_Frozen = "frozencrusaders_root";
$password_Frozen = "Gaat je niks aan";
$Frozen = mysql_pconnect($hostname_Frozen, $username_Frozen, $password_Frozen) or trigger_error(mysql_error(),E_USER_ERROR); 

mysql_select_db($database_Frozen, $Frozen);
$query_Recordset1 = "SELECT * FROM joining where member=1";
$Recordset1 = mysql_query($query_Recordset1, $Frozen) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<link href="/frozen.css" rel="stylesheet" type="text/css" />
</head>

<body topmargin="50"leftmargin="3"bottommargin="1"rightmargin="3" bgcolor="#000000">
<table width="800" border="0" class="text" align="center">
  <tr>
    <td height="23" class="text"><a href="/loginof.php" class="text"> officers login </a></td>
    <td class="text">&nbsp;</td>
    <td class="text">&nbsp;</td>
  </tr>
  <tr>
    <td height="23" class="text">&nbsp;</td>
    <td class="text">&nbsp;</td>
    <td class="text">&nbsp;</td>
  </tr>
  <tr>
    <td width="225" height="23" class="text">Char name </td>
    <td width="175" class="text">Race</td>
    <td width="175" class="text">Class</td>
  </tr>
  <tr>
    <td class="textwhite">&nbsp;</td>
    <td class="textwhite">&nbsp;</td>
    <td class="textwhite">&nbsp;</td>
  </tr>

    <?php do { ?>  
	  <tr>
      <td class="textwhite"><?php echo $row_Recordset1['Charname']; ?></td>
      <td class="textwhite"><?php echo $row_Recordset1['Race']; ?></td>
      <td class="textwhite"><?php echo $row_Recordset1['Class']; ?></td>
	  </tr>
      <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>
</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
[/code]

admin_members.php
[code]
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_Frozen = "localhost";
$database_Frozen = "frozencrusaders_frozen";
$username_Frozen = "frozencrusaders_root";
$password_Frozen = "Gaat je niks aan";
$Frozen = mysql_pconnect($hostname_Frozen, $username_Frozen, $password_Frozen) or trigger_error(mysql_error(),E_USER_ERROR);

$Frozen = mysql_pconnect($hostname_Frozen, $username_Frozen, $password_Frozen) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database_Frozen, $Frozen);
$query_Recordset1 = "SELECT * FROM joining where member=1";
$Recordset1 = mysql_query($query_Recordset1, $Frozen) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<link href="/frozen.css" rel="stylesheet" type="text/css" />
</head>

<body topmargin="50"leftmargin="3"bottommargin="1"rightmargin="3" bgcolor="#000000">
  <table width="800" border="0" class="text" align="center">
    <tr>
      <td width="166" height="23" class="text">Char name </td>
      <td width="132" class="text">Race</td>
      <td width="134" class="text">Class</td>
      <td width="25" class="text">Level</td>
      <td width="211" class="text">Actions</td>
    </tr>
    <tr>
      <td class="textwhite">&nbsp;</td>
      <td class="textwhite">&nbsp;</td>
      <td class="textwhite">&nbsp;</td>
      <td class="textwhite">&nbsp;</td>
      <td class="textwhite">&nbsp;</td>
    </tr>
    <?php do { ?>
   
      <?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?><tr>
      <td height="34" class="textwhite"><?php echo $row_Recordset1['Charname']; ?></td>
      <td class="textwhite"><?php echo $row_Recordset1['Race']; ?></td>
      <td class="textwhite"><?php echo $row_Recordset1['Class']; ?></td>
      <td class="textwhite"><?php echo $row_Recordset1['Level']; ?></td>
      <td class="textwhite" align="center"><a href="recordDelete1.php?Charname=<?php echo $row_Recordset1['Charname'] ?>" class="textwhite">delete</a> </td>
	   </tr>
      <?php } // Show if recordset not empty ?>
   
    <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
  </table>
  

</body>
</html>
<?php
mysql_free_result($Recordset1);
?>
[/code]

login.php
[code]
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_Frozen = "localhost";
$database_Frozen = "frozencrusaders_frozen";
$username_Frozen = "frozencrusaders_root";
$password_Frozen = "Gaat je niks aan";
$Frozen = mysql_pconnect($hostname_Frozen, $username_Frozen, $password_Frozen) or trigger_error(mysql_error(),E_USER_ERROR);
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
  $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}

if (isset($_POST['textfield'])) {
  $loginUsername=$_POST['textfield'];
  $password=$_POST['textfield2'];
  $MM_fldUserAuthorization = "";
  $MM_redirectLoginSuccess = "/admin_recruit.php";
  $MM_redirectLoginFailed = "/pmembers.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_Frozen, $Frozen);
  
  $LoginRS__query=sprintf("SELECT name, password FROM login WHERE name='%s' AND password='%s'",
    get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password)); 
   
  $LoginRS = mysql_query($LoginRS__query, $Frozen) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
     $loginStrGroup = "";
    
    //declare two session variables and assign them
    $_SESSION['MM_Username'] = $loginUsername;
    $_SESSION['MM_UserGroup'] = $loginStrGroup;	      

    if (isset($_SESSION['PrevUrl']) && false) {
      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
    }
    header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<link href="/frozen.css" rel="stylesheet" type="text/css" />
</head>

<body topmargin="50"leftmargin="3"bottommargin="1"rightmargin="3" bgcolor="#000000">
<form id="form1" name="form1" method="POST" action="<?php echo $loginFormAction; ?>">
  <table width="387" border="0" align="center">
    <tr>
      <td width="146" class="textwhite">Name</td>
      <td width="231"><input type="text" name="textfield" /></td>
    </tr>
    <tr>
      <td class="textwhite">Password</td>
      <td><input type="text" name="textfield2" /></td>
    </tr>
    <tr>
      <td colspan="2" align="center"><input type="submit" name="Submit" value="Login" /></td>
    </tr>
  </table>
</form>
</body>
</html>
[/code]

loginof.php
[code]
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_Frozen = "localhost";
$database_Frozen = "frozencrusaders_frozen";
$username_Frozen = "frozencrusaders_root";
$password_Frozen = "Gaat je niks aan";
$Frozen = mysql_pconnect($hostname_Frozen, $username_Frozen, $password_Frozen) or trigger_error(mysql_error(),E_USER_ERROR);
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
  $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}

if (isset($_POST['textfield'])) {
  $loginUsername=$_POST['textfield'];
  $password=$_POST['textfield2'];
  $MM_fldUserAuthorization = "";
  $MM_redirectLoginSuccess = "/admin_members.php";
  $MM_redirectLoginFailed = "/rmembers.php";
  $MM_redirecttoReferrer = false;
  mysql_select_db($database_Frozen, $Frozen);
  
  $LoginRS__query=sprintf("SELECT name, password FROM login WHERE name='%s' AND password='%s'",
    get_magic_quotes_gpc() ? $loginUsername : addslashes($loginUsername), get_magic_quotes_gpc() ? $password : addslashes($password)); 
   
  $LoginRS = mysql_query($LoginRS__query, $Frozen) or die(mysql_error());
  $loginFoundUser = mysql_num_rows($LoginRS);
  if ($loginFoundUser) {
     $loginStrGroup = "";
    
    //declare two session variables and assign them
    $_SESSION['MM_Username'] = $loginUsername;
    $_SESSION['MM_UserGroup'] = $loginStrGroup;	      

    if (isset($_SESSION['PrevUrl']) && false) {
      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
    }
    header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<link href="/frozen.css" rel="stylesheet" type="text/css" />
</head>

<body topmargin="50"leftmargin="3"bottommargin="1"rightmargin="3" bgcolor="#000000">
<form id="form1" name="form1" method="POST" action="<?php echo $loginFormAction; ?>">
  <table width="387" border="0" align="center">
    <tr>
      <td width="146" class="textwhite">Name</td>
      <td width="231"><input type="text" name="textfield" /></td>
    </tr>
    <tr>
      <td class="textwhite">Password</td>
      <td><input type="text" name="textfield2" /></td>
    </tr>
    <tr>
      <td colspan="2" align="center"><input type="submit" name="Submit" value="Login" /></td>
    </tr>
  </table>
</form>
</body>
</html>
[/code]

recordDelete.php
[code]
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_Frozen = "localhost";
$database_Frozen = "frozencrusaders_frozen";
$username_Frozen = "frozencrusaders_root";
$password_Frozen = "Gaat je niks aan";
$Frozen = mysql_pconnect($hostname_Frozen, $username_Frozen, $password_Frozen) or trigger_error(mysql_error(),E_USER_ERROR);
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

if ((isset($_GET['Charname'])) && ($_GET['Charname'] != "")) {
  $deleteSQL = sprintf("DELETE FROM joining WHERE Charname=%s",
                       GetSQLValueString($_GET['Charname'], "text"));

  mysql_select_db($database_Frozen, $Frozen);
  $Result1 = mysql_query($deleteSQL, $Frozen) or die(mysql_error());

  $deleteGoTo = "/admin_recruit.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
    $deleteGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $deleteGoTo));
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
</body>
</html>
[/code]

recordDelete1.php
[code]
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_Frozen = "localhost";
$database_Frozen = "frozencrusaders_frozen";
$username_Frozen = "frozencrusaders_root";
$password_Frozen = "Gaat je niks aan";
$Frozen = mysql_pconnect($hostname_Frozen, $username_Frozen, $password_Frozen) or trigger_error(mysql_error(),E_USER_ERROR);
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

if ((isset($_GET['Charname'])) && ($_GET['Charname'] != "")) {
  $deleteSQL = sprintf("DELETE FROM joining WHERE Charname=%s",
                       GetSQLValueString($_GET['Charname'], "text"));

  mysql_select_db($database_Frozen, $Frozen);
  $Result1 = mysql_query($deleteSQL, $Frozen) or die(mysql_error());

  $deleteGoTo = "/admin_members.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
    $deleteGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $deleteGoTo));
}
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
</body>
</html>
[/code]
