Advertisement
Guest User

Untitled

a guest
Dec 19th, 2014
173
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.71 KB | None | 0 0
  1. function submitCheck(){
  2. ob_start();
  3.  
  4. //Function explanation
  5. //------------------------------------------------------------
  6. // This calls it only when the buttom is pressed.
  7. // Rather than it been ran everytime the page loads.
  8. //------------------------------------------------------------
  9.  
  10. global $current_user;
  11. global $wp_query;
  12. $post_obj = $wp_query->get_queried_object();
  13. $Page_ID = $post_obj->ID;
  14. global $current_user;
  15.  
  16. $con3=mysqli_connect("localhost","elliot_vanityx","Vxb[M*]tw8AX","elliot_cl53-vanity");
  17. // Check connection
  18. if (mysqli_connect_errno()){
  19. echo "Failed to connect to con3 tournamentmanager.php MySQL: " . mysqli_connect_error();
  20. }
  21.  
  22. if (checkForTeam($current_user->user_login)){
  23.  
  24. $sql3="SELECT * FROM vt_tournaments WHERE tadminid = ". $Page_ID ."";
  25. $result3 = mysqli_query($con3,$sql3);
  26. $row3 = mysqli_fetch_array($result3);
  27. $tgame = $row3['tgame'];
  28.  
  29. $theclosedate = $row3['tclosedate'];
  30. $theclosetime = $row3['tclosetime'];
  31. $tournamentstatus = $row3['tournamentstatus'];
  32.  
  33. if (time() > strtotime($theclosedate . " " . $theclosetime)) {
  34.  
  35. die('<script type="text/javascript">alert("Sorry, sign ups are now closed.");</script><meta http-equiv="refresh" content="0;URL="javascript:history.back();" >');
  36.  
  37. } else {
  38.  
  39. // 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]) {
  40.  
  41. // 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();" >');
  42.  
  43. // } else {
  44.  
  45. $sqlp1xp="SELECT * FROM vt_rankings_" . $row3['tgame'] ." WHERE playerusername = '$_POST[poneuser]'";
  46. $resultp1xp = mysqli_query($con3,$sqlp1xp);
  47. $rowp1xp = mysqli_fetch_array($resultp1xp);
  48. $p1xp = $rowp1xp['playerxp'];
  49.  
  50. $sqlp2xp="SELECT * FROM vt_rankings_" . $row3['tgame'] ." WHERE playerusername = '$_POST[ptwouser]'";
  51. $resultp2xp = mysqli_query($con3,$sqlp2xp);
  52. $rowp2xp = mysqli_fetch_array($resultp2xp);
  53. $p2xp = $rowp2xp['playerxp'];
  54.  
  55. $sqlp3xp="SELECT * FROM vt_rankings_" . $row3['tgame'] ." WHERE playerusername = '$_POST[pthreeuser]'";
  56. $resultp3xp = mysqli_query($con3,$sqlp3xp);
  57. $rowp3xp = mysqli_fetch_array($resultp3xp);
  58. $p3xp = $rowp3xp['playerxp'];
  59.  
  60. $sqlp4xp="SELECT * FROM vt_rankings_" . $row3['tgame'] ." WHERE playerusername = '$_POST[pfouruser]'";
  61. $resultp4xp = mysqli_query($con3,$sqlp4xp);
  62. $rowp4xp = mysqli_fetch_array($resultp4xp);
  63. $p4xp = $rowp4xp['playerxp'];
  64.  
  65. $sqlp5xp="SELECT * FROM vt_rankings_" . $row3['tgame'] ." WHERE playerusername = '$_POST[pfiveuser]'";
  66. $resultp5xp = mysqli_query($con3,$sqlp5xp);
  67. $rowp5xp = mysqli_fetch_array($resultp5xp);
  68. $p5xp = $rowp5xp['playerxp'];
  69.  
  70. $teamxp = $p1xp + $p2xp + $p3xp + $p4xp + $p5xp;
  71.  
  72. if ($_POST[pone] == "" || $_POST[pone] == " ") {
  73.  
  74. 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();" >');
  75.  
  76. } else {
  77.  
  78. $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')";
  79. }
  80.  
  81. // }
  82.  
  83. exit('<script type="text/javascript">alert("Your team: ' . $_POST[teamname] . ' has been entered.");</script><meta http-equiv="refresh" content="0;URL="javascript:history.back();" >');
  84.  
  85. }
  86.  
  87.  
  88. }
  89.  
  90. mysqli_close($con3);
  91. $myvariable = ob_get_clean();
  92. return $myvariable;
  93. } // Closes function submitCheck
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement