Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- ?>
- <?php require_once('../Connections/Server.php'); ?>
- <?php
- if (!function_exists("GetSQLValueString")) {
- function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
- {
- if (PHP_VERSION < 6) {
- $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
- }
- $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($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 tbluser SET premierleague=%s WHERE userid=%s",
- GetSQLValueString($_POST['premierleague'], "text"),
- GetSQLValueString($_SESSION['userid'], "int"));
- mysql_select_db($database_Server, $Server);
- $Result1 = mysql_query($updateSQL, $Server) or die(mysql_error());
- }
- if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form2")) {
- $updateSQL = sprintf("UPDATE tbluser SET championship=%s WHERE userid=%s",
- GetSQLValueString($_POST['championship'], "text"),
- GetSQLValueString($_POST['userid'], "int"));
- mysql_select_db($database_Server, $Server);
- $Result1 = mysql_query($updateSQL, $Server) or die(mysql_error());
- }
- if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form3")) {
- $updateSQL = sprintf("UPDATE tbluser SET laliga=%s WHERE userid=%s",
- GetSQLValueString($_POST['laliga'], "text"),
- GetSQLValueString($_POST['userid'], "int"));
- mysql_select_db($database_Server, $Server);
- $Result1 = mysql_query($updateSQL, $Server) or die(mysql_error());
- }
- if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form4")) {
- $updateSQL = sprintf("UPDATE tbluser SET seriea=%s WHERE userid=%s",
- GetSQLValueString($_POST['seriea'], "text"),
- GetSQLValueString($_POST['userid'], "int"));
- mysql_select_db($database_Server, $Server);
- $Result1 = mysql_query($updateSQL, $Server) or die(mysql_error());
- }
- if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form5")) {
- $updateSQL = sprintf("UPDATE tbluser SET championsleague=%s WHERE userid=%s",
- GetSQLValueString($_POST['championsleague'], "text"),
- GetSQLValueString($_POST['userid'], "int"));
- mysql_select_db($database_Server, $Server);
- $Result1 = mysql_query($updateSQL, $Server) or die(mysql_error());
- }
- if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form6")) {
- $updateSQL = sprintf("UPDATE tbluser SET eredivisie=%s WHERE userid=%s",
- GetSQLValueString($_POST['eredivisie'], "text"),
- GetSQLValueString($_POST['userid'], "int"));
- mysql_select_db($database_Server, $Server);
- $Result1 = mysql_query($updateSQL, $Server) or die(mysql_error());
- }
- if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form7")) {
- $updateSQL = sprintf("UPDATE tbluser SET ligueone=%s WHERE userid=%s",
- GetSQLValueString($_POST['ligueone'], "text"),
- GetSQLValueString($_POST['userid'], "int"));
- mysql_select_db($database_Server, $Server);
- $Result1 = mysql_query($updateSQL, $Server) or die(mysql_error());
- }
- if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form8")) {
- $updateSQL = sprintf("UPDATE tbluser SET bundesliga=%s WHERE userid=%s",
- GetSQLValueString($_POST['bundesliga'], "text"),
- GetSQLValueString($_POST['userid'], "int"));
- mysql_select_db($database_Server, $Server);
- $Result1 = mysql_query($updateSQL, $Server) or die(mysql_error());
- }
- mysql_select_db($database_Server, $Server);
- $query_rstpremierleague = "SELECT * FROM tblpremierleague ORDER BY premierleaguename ASC";
- $rstpremierleague = mysql_query($query_rstpremierleague, $Server) or die(mysql_error());
- $row_rstpremierleague = mysql_fetch_assoc($rstpremierleague);
- $totalRows_rstpremierleague = mysql_num_rows($rstpremierleague);
- mysql_select_db($database_Server, $Server);
- $query_rstchampionship = "SELECT * FROM tblchampionship ORDER BY championshipname ASC";
- $rstchampionship = mysql_query($query_rstchampionship, $Server) or die(mysql_error());
- $row_rstchampionship = mysql_fetch_assoc($rstchampionship);
- $totalRows_rstchampionship = mysql_num_rows($rstchampionship);
- mysql_select_db($database_Server, $Server);
- $query_rstbundesliga = "SELECT * FROM tblbundesliga ORDER BY bundesligaName ASC";
- $rstbundesliga = mysql_query($query_rstbundesliga, $Server) or die(mysql_error());
- $row_rstbundesliga = mysql_fetch_assoc($rstbundesliga);
- $totalRows_rstbundesliga = mysql_num_rows($rstbundesliga);
- mysql_select_db($database_Server, $Server);
- $query_rstligueone = "SELECT * FROM tblligueone ORDER BY ligueonename ASC";
- $rstligueone = mysql_query($query_rstligueone, $Server) or die(mysql_error());
- $row_rstligueone = mysql_fetch_assoc($rstligueone);
- $totalRows_rstligueone = mysql_num_rows($rstligueone);
- mysql_select_db($database_Server, $Server);
- $query_rstseriea = "SELECT * FROM tblseriea ORDER BY serieAname ASC";
- $rstseriea = mysql_query($query_rstseriea, $Server) or die(mysql_error());
- $row_rstseriea = mysql_fetch_assoc($rstseriea);
- $totalRows_rstseriea = mysql_num_rows($rstseriea);
- mysql_select_db($database_Server, $Server);
- $query_rsteredivisie = "SELECT * FROM tbleredivise ORDER BY eredivisename ASC";
- $rsteredivisie = mysql_query($query_rsteredivisie, $Server) or die(mysql_error());
- $row_rsteredivisie = mysql_fetch_assoc($rsteredivisie);
- $totalRows_rsteredivisie = mysql_num_rows($rsteredivisie);
- mysql_select_db($database_Server, $Server);
- $query_rstlaliga = "SELECT * FROM tbllaliga ORDER BY laliganame ASC";
- $rstlaliga = mysql_query($query_rstlaliga, $Server) or die(mysql_error());
- $row_rstlaliga = mysql_fetch_assoc($rstlaliga);
- $totalRows_rstlaliga = mysql_num_rows($rstlaliga);
- mysql_select_db($database_Server, $Server);
- $query_rstchampionsleague = "SELECT * FROM tblchampionsleague ORDER BY championsleagueName ASC";
- $rstchampionsleague = mysql_query($query_rstchampionsleague, $Server) or die(mysql_error());
- $row_rstchampionsleague = mysql_fetch_assoc($rstchampionsleague);
- $totalRows_rstchampionsleague = mysql_num_rows($rstchampionsleague);
- mysql_select_db($database_Server, $Server);
- $query_rsttest = "SELECT * FROM tblpremierleague ORDER BY premierleaguename ASC";
- $rsttest = mysql_query($query_rsttest, $Server) or die(mysql_error());
- $row_rsttest = mysql_fetch_assoc($rsttest);
- $totalRows_rsttest = mysql_num_rows($rsttest);
- mysql_select_db($database_Server, $Server);
- $query_rstmybet = "SELECT userid, premierleague, championship, seriea, laliga, ligueone, championsleague, eredivisie, bundesliga FROM tbluser";
- $rstmybet = mysql_query($query_rstmybet, $Server) or die(mysql_error());
- $row_rstmybet = mysql_fetch_assoc($rstmybet);
- $totalRows_rstmybet = mysql_num_rows($rstmybet);
- ?>
- <?php require_once('../Connections/Server.php'); ?>
- <?php require_once('../Connections/Server.php'); ?>
- <!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=utf-8" />
- <title>My Big Fat Bet of the Year</title>
- <link rel="shortcut icon" href="images/football.jpg" />
- <link rel="stylesheet" text="text/css" href="betcss.css"/>
- </head>
- <body>
- <img style="padding-left:95px;" src="../images/logo.png" align="center" width="1041" height="175" alt="My Big Fat Bet of the Year">
- <div id="header" align="center"> <span class="events h1">
- <h2 ><a href="home.php" >Home</a></h2>
- <h2><a href="events.php">Events</a></h2>
- <h2><a href="leaderboard.php">Leaderboard</a></h2>
- <h2><a href="register.php">Register</a></h2>
- <h2><a href="mybet.php">MyBet</a></h2>
- </span></div>
- <div align="right">
- <?php
- if ($_SESSION['MM_UserGroup']==1) {
- echo "<a href=profile.php>Admin</a>";
- echo"I";
- echo "<a href=logout.php>Logout</a>";
- }
- elseif($_SESSION['MM_UserGroup']==2){
- echo "<a href=profile.php>Profile</a>";
- echo "I";
- echo "<a href=logout.php>Logout</a>";
- }
- else {
- echo "<a href=login.php>Login</a>I<a href=register.php>Register</a>";
- }
- ?>
- </div>
- <div id="sidebar" align="left">
- <h2 ><a href="home.php" >Home</a></h2>
- <h2><a href="events.php">Events</a></h2>
- <h2><a href="leaderboard.php">Leaderboard</a></h2>
- <h2><a href="register.php">Register</a></h2>
- <h2><a href="mybet.php">MyBet</a></h2></div>
- <br />
- <span class="events h1">
- <h1><u><strong>MyBet</strong></u></h1>
- </span>
- <div id="main">
- <table width="500" align="center" >
- <tr>
- <th width="125" scope="col"><img src="../images/premierleague.gif" width="125" height="100" alt="Premier League" </th>
- <th width="125" scope="col"><img src="../images/championship.jpg" width="125" height="100" alt="Championship" </th>
- <th width="125" scope="col"><img src="../images/laliga.jpg" width="125" height="100" alt="La Liga" </th>
- <th width="125" scope="col"><img src="../images/seriea.jpg" width="125" height="100" alt="Serie A" </th>
- </tr>
- <tr>
- <td>
- <form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
- <table align="center">
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"></td>
- <td><select name="premierleague">
- <?php
- do {
- ?>
- <option value="<?php echo $row_rstpremierleague['premierleagueid']?>" <?php if (!(strcmp($row_rstpremierleague['premierleagueid'], htmlentities($row_rstmybet['premierleague'], ENT_COMPAT, 'utf-8')))) {echo "SELECTED";} ?>><?php echo $row_rstpremierleague['premierleaguename']?></option>
- <?php
- } while ($row_rstpremierleague = mysql_fetch_assoc($rstpremierleague));
- ?>
- </select></td>
- </tr>
- <tr> </tr>
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"> </td>
- <td align="center"><input type="submit" value="Submit" /></td>
- </tr>
- </table>
- <input type="hidden" name="MM_update" value="form1" />
- <input type="hidden" name="userid" value="<?php echo $row_rstmybet['userid']; ?>" />
- </form>
- <p> </p></td>
- <td>
- <form action="<?php echo $editFormAction; ?>" method="post" name="form2" id="form2">
- <table align="center">
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"></td>
- <td><select name="championship">
- <?php
- do {
- ?>
- <option value="<?php echo $row_rstchampionship['championshipid']?>" <?php if (!(strcmp($row_rstchampionship['championshipid'], htmlentities($row_rstmybet['championship'], ENT_COMPAT, 'utf-8')))) {echo "SELECTED";} ?>><?php echo $row_rstchampionship['championshipname']?></option>
- <?php
- } while ($row_rstchampionship = mysql_fetch_assoc($rstchampionship));
- ?>
- </select></td>
- </tr>
- <tr> </tr>
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"> </td>
- <td align="center"><input type="submit" value="Submit" /></td>
- </tr>
- </table>
- <input type="hidden" name="MM_update" value="form2" />
- <input type="hidden" name="userid" value="<?php echo $row_rstmybet['userid']; ?>" />
- </form>
- <p> </p></td>
- <td>
- <form action="<?php echo $editFormAction; ?>" method="post" name="form3" id="form3">
- <table align="center">
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"></td>
- <td><select name="laliga">
- <?php
- do {
- ?>
- <option value="<?php echo $row_rstlaliga['laligaid']?>" <?php if (!(strcmp($row_rstlaliga['laligaid'], htmlentities($row_rstmybet['laliga'], ENT_COMPAT, 'utf-8')))) {echo "SELECTED";} ?>><?php echo $row_rstlaliga['laliganame']?></option>
- <?php
- } while ($row_rstlaliga = mysql_fetch_assoc($rstlaliga));
- ?>
- </select></td>
- </tr>
- <tr> </tr>
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"> </td>
- <td align="center"><input type="submit" value="Submit" /></td>
- </tr>
- </table>
- <input type="hidden" name="MM_update" value="form3" />
- <input type="hidden" name="userid" value="<?php echo $row_rstmybet['userid']; ?>" />
- </form>
- <p> </p></td>
- <td>
- <form action="<?php echo $editFormAction; ?>" method="post" name="form4" id="form4">
- <table align="center">
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"></td>
- <td><select name="seriea">
- <?php
- do {
- ?>
- <option value="<?php echo $row_rstseriea['serieaid']?>" <?php if (!(strcmp($row_rstseriea['serieaid'], htmlentities($row_rstmybet['seriea'], ENT_COMPAT, 'utf-8')))) {echo "SELECTED";} ?>><?php echo $row_rstseriea['serieAname']?></option>
- <?php
- } while ($row_rstseriea = mysql_fetch_assoc($rstseriea));
- ?>
- </select></td>
- </tr>
- <tr> </tr>
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"> </td>
- <td align="center"><input type="submit" value="Submit" /></td>
- </tr>
- </table>
- <input type="hidden" name="MM_update" value="form4" />
- <input type="hidden" name="userid" value="<?php echo $row_rstmybet['userid']; ?>" />
- </form>
- <p> </p></td>
- </tr>
- </table>
- <p> </p>
- <p> </p>
- <table width="500" align="center">
- <tr>
- <th width="125" scope="col"><img src="../images/CL.jpg" width="125" height="100" alt="Champions League" /></th>
- <th width="125" scope="col"><img src="../images/eredivisie.jpg" width="125" height="100" alt="Eredivisie" /></th>
- <th width="125" scope="col"><img src="../images/ligue1.jpg" width="125" height="100" alt="Ligue One" /></th>
- <th width="125" scope="col"><img src="../images/Bundesliga.jpg" width="125" height="100" alt="Bundesliga" /></th>
- </tr>
- <tr>
- <td>
- <form action="<?php echo $editFormAction; ?>" method="post" name="form5" id="form5">
- <table align="center">
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"></td>
- <td><select name="championsleague">
- <?php
- do {
- ?>
- <option value="<?php echo $row_rstchampionsleague['championsleagueid']?>" <?php if (!(strcmp($row_rstchampionsleague['championsleagueid'], htmlentities($row_rstmybet['championsleague'], ENT_COMPAT, 'utf-8')))) {echo "SELECTED";} ?>><?php echo $row_rstchampionsleague['championsleagueName']?></option>
- <?php
- } while ($row_rstchampionsleague = mysql_fetch_assoc($rstchampionsleague));
- ?>
- </select></td>
- </tr>
- <tr> </tr>
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"> </td>
- <td align="center"><input type="submit" value="Submit" /></td>
- </tr>
- </table>
- <input type="hidden" name="MM_update" value="form5" />
- <input type="hidden" name="userid" value="<?php echo $row_rstmybet['userid']; ?>" />
- </form>
- <p> </p></td>
- <td>
- <form action="<?php echo $editFormAction; ?>" method="post" name="form6" id="form6">
- <table align="center">
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"></td>
- <td><select name="eredivisie">
- <?php
- do {
- ?>
- <option value="<?php echo $row_rsteredivisie['erediviseid']?>" <?php if (!(strcmp($row_rsteredivisie['erediviseid'], htmlentities($row_rstmybet['eredivisie'], ENT_COMPAT, 'utf-8')))) {echo "SELECTED";} ?>><?php echo $row_rsteredivisie['eredivisename']?></option>
- <?php
- } while ($row_rsteredivisie = mysql_fetch_assoc($rsteredivisie));
- ?>
- </select></td>
- </tr>
- <tr> </tr>
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"> </td>
- <td align="center"><input type="submit" value="Submit" /></td>
- </tr>
- </table>
- <input type="hidden" name="MM_update" value="form6" />
- <input type="hidden" name="userid" value="<?php echo $row_rstmybet['userid']; ?>" />
- </form>
- <p> </p></td>
- <td>
- <form action="<?php echo $editFormAction; ?>" method="post" name="form7" id="form7">
- <table align="center">
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"></td>
- <td><select name="ligueone">
- <?php
- do {
- ?>
- <option value="<?php echo $row_rstligueone['ligueoneid']?>" <?php if (!(strcmp($row_rstligueone['ligueoneid'], htmlentities($row_rstmybet['ligueone'], ENT_COMPAT, 'utf-8')))) {echo "SELECTED";} ?>><?php echo $row_rstligueone['ligueonename']?></option>
- <?php
- } while ($row_rstligueone = mysql_fetch_assoc($rstligueone));
- ?>
- </select></td>
- </tr>
- <tr> </tr>
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"> </td>
- <td align="center"><input type="submit" value="Submit" /></td>
- </tr>
- </table>
- <input type="hidden" name="MM_update" value="form7" />
- <input type="hidden" name="userid" value="<?php echo $row_rstmybet['userid']; ?>" />
- </form>
- <p> </p></td>
- <td>
- <form action="<?php echo $editFormAction; ?>" method="post" name="form8" id="form8">
- <table align="center">
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"></td>
- <td><select name="bundesliga">
- <?php
- do {
- ?>
- <option value="<?php echo $row_rstbundesliga['bundesligaID']?>" <?php if (!(strcmp($row_rstbundesliga['bundesligaID'], htmlentities($row_rstmybet['bundesliga'], ENT_COMPAT, 'utf-8')))) {echo "SELECTED";} ?>><?php echo $row_rstbundesliga['bundesligaName']?></option>
- <?php
- } while ($row_rstbundesliga = mysql_fetch_assoc($rstbundesliga));
- ?>
- </select></td>
- </tr>
- <tr> </tr>
- <tr valign="baseline">
- <td nowrap="nowrap" align="right"> </td>
- <td align="center"><input type="submit" value="Submit" /></td>
- </tr>
- </table>
- <input type="hidden" name="MM_update" value="form8" />
- <input type="hidden" name="userid" value="<?php echo $row_rstmybet['userid']; ?>" />
- </form>
- <p> </p></td>
- </tr>
- </table>
- <div id="apDiv1" align="center"><span class="events h1">
- <h2 ><a href="home.php" >Home</a></h2>
- <h2><a href="events.php">Events</a></h2>
- <h2><a href="leaderboard.php">Contact Us</a></h2>
- <h2><a href="register.php">Register</a></h2>
- <h2><a href="mybet.php">Sitemap</a></h2>
- </span></div>
- </body>
- </html>
- <?php
- mysql_free_result($rstpremierleague);
- mysql_free_result($rstchampionship);
- mysql_free_result($rstbundesliga);
- mysql_free_result($rstligueone);
- mysql_free_result($rstseriea);
- mysql_free_result($rsteredivisie);
- mysql_free_result($rstlaliga);
- mysql_free_result($rstchampionsleague);
- mysql_free_result($rsttest);
- mysql_free_result($rstmybet);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement