Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function submitCheck(){
- ob_start();
- //Function explanation
- //------------------------------------------------------------
- // This calls it only when the buttom is pressed.
- // Rather than it been ran everytime the page loads.
- //------------------------------------------------------------
- global $current_user;
- global $wp_query;
- $post_obj = $wp_query->get_queried_object();
- $Page_ID = $post_obj->ID;
- global $current_user;
- $con3=mysqli_connect("localhost","elliot_vanityx","Vxb[M*]tw8AX","elliot_cl53-vanity");
- // Check connection
- if (mysqli_connect_errno()){
- echo "Failed to connect to con3 tournamentmanager.php MySQL: " . mysqli_connect_error();
- }
- if (checkForTeam($current_user->user_login)){
- $sql3="SELECT * FROM vt_tournaments WHERE tadminid = ". $Page_ID ."";
- $result3 = mysqli_query($con3,$sql3);
- $row3 = mysqli_fetch_array($result3);
- $tgame = $row3['tgame'];
- $theclosedate = $row3['tclosedate'];
- $theclosetime = $row3['tclosetime'];
- $tournamentstatus = $row3['tournamentstatus'];
- if (time() > strtotime($theclosedate . " " . $theclosetime)) {
- die('<script type="text/javascript">alert("Sorry, sign ups are now closed.");</script><meta http-equiv="refresh" content="0;URL="javascript:history.back();" >');
- } else {
- // if ($_POST[poneuser] == $_POST[ptwouser] OR $_POST[poneuser] == $_POST[pthreeuser] OR $_POST[poneuser] == $_POST[pfouruser] OR $_POST[poneuser] == $_POST[pfiveuser] OR $_POST[ptwouser] == $_POST[pthreeuser] OR $_POST[ptwouser] == $_POST[pfouruser] OR $_POST[ptwouser] == $_POST[pfiveuser] OR $_POST[pthreeuser] == $_POST[pfouruser] OR $_POST[pthreeuser] == $_POST[pfiveuser] OR $_POST[pfouruser] == $_POST[pfiveuser]) {
- // die('<script type="text/javascript">alert("ERROR: You may not have the same username for 2 players.");</script><meta http-equiv="refresh" content="0;URL="javascript:history.back();" >');
- // } else {
- $sqlp1xp="SELECT * FROM vt_rankings_" . $row3['tgame'] ." WHERE playerusername = '$_POST[poneuser]'";
- $resultp1xp = mysqli_query($con3,$sqlp1xp);
- $rowp1xp = mysqli_fetch_array($resultp1xp);
- $p1xp = $rowp1xp['playerxp'];
- $sqlp2xp="SELECT * FROM vt_rankings_" . $row3['tgame'] ." WHERE playerusername = '$_POST[ptwouser]'";
- $resultp2xp = mysqli_query($con3,$sqlp2xp);
- $rowp2xp = mysqli_fetch_array($resultp2xp);
- $p2xp = $rowp2xp['playerxp'];
- $sqlp3xp="SELECT * FROM vt_rankings_" . $row3['tgame'] ." WHERE playerusername = '$_POST[pthreeuser]'";
- $resultp3xp = mysqli_query($con3,$sqlp3xp);
- $rowp3xp = mysqli_fetch_array($resultp3xp);
- $p3xp = $rowp3xp['playerxp'];
- $sqlp4xp="SELECT * FROM vt_rankings_" . $row3['tgame'] ." WHERE playerusername = '$_POST[pfouruser]'";
- $resultp4xp = mysqli_query($con3,$sqlp4xp);
- $rowp4xp = mysqli_fetch_array($resultp4xp);
- $p4xp = $rowp4xp['playerxp'];
- $sqlp5xp="SELECT * FROM vt_rankings_" . $row3['tgame'] ." WHERE playerusername = '$_POST[pfiveuser]'";
- $resultp5xp = mysqli_query($con3,$sqlp5xp);
- $rowp5xp = mysqli_fetch_array($resultp5xp);
- $p5xp = $rowp5xp['playerxp'];
- $teamxp = $p1xp + $p2xp + $p3xp + $p4xp + $p5xp;
- if ($_POST[pone] == "" || $_POST[pone] == " ") {
- die('<script type="text/javascript">alert("[Invalid player name] Failed to enter team, please try again.");</script><meta http-equiv="refresh" content="0;URL="javascript:history.back();" >');
- } else {
- $sql2="INSERT INTO vt_teams (teamname, player1, player2, player3, player4, player5, contact, username, tournamentid, player1username, player2username, player3username, player4username, player5username, teamdetails, teamlogo, teamwebsite, teamxp) VALUES('$_POST[teamname]', '$_POST[pone]', '$_POST[ptwo]', '$_POST[pthree]', '$_POST[pfour]', '$_POST[pfive]', '$_POST[contact]', '$current_user->user_login', '$_POST[tid]', '$_POST[poneuser]', '$_POST[ptwouser]', '$_POST[pthreeuser]', '$_POST[pfouruser]', '$_POST[pfiveuser]', '$_POST[teamdetails]', '$_POST[teamlogo]', '$_POST[teamwebsite]', '$teamxp')";
- }
- // }
- exit('<script type="text/javascript">alert("Your team: ' . $_POST[teamname] . ' has been entered.");</script><meta http-equiv="refresh" content="0;URL="javascript:history.back();" >');
- }
- }
- mysqli_close($con3);
- $myvariable = ob_get_clean();
- return $myvariable;
- } // Closes function submitCheck
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement