Advertisement
Guest User

Untitled

a guest
Jul 7th, 2015
189
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.56 KB | None | 0 0
  1. if(empty($_POST['cap']) === false){
  2. $week = date("W");
  3. $users = $_POST['user'];
  4. if(empty($users) === false){
  5. $cap_check = mysqli_query($con, "SELECT week FROM caps WHERE week = '$week'")or die(mysqli_error($con));
  6. if(mysqli_num_rows($cap_check) == 0){
  7. mysqli_query($con, "INSERT INTO caps (week, start_date, end_date, upgrades) VALUES('$week','','','')")or die(mysqli_error($con));
  8. }
  9. foreach($users as $user){
  10. $user = mysqli_real_escape_string($con, $user);
  11. $qry_check = mysqli_query($con, "SELECT capped_users.user, users.username FROM capped_users
  12. LEFT JOIN users ON capped_users.user = users.user_id
  13. WHERE user ='$user' AND cap_week = '$week'")or die(mysqli_error($con));
  14. $username = mysqli_fetch_assoc($qry_check);
  15. $name = $username['username'];
  16. if(mysqli_num_rows($qry_check) == 0){
  17. mysqli_query($con, "INSERT INTO capped_users(week, user) VALUES('$week','$user')")or die(mysqli_error($con));
  18. $confirm = mysqli_query($con, "SELECT user FROM capped_users WHERE user ='$user' AND week = '$week'")or die(mysqli_error($con));
  19. if(mysqli_num_rows($confirm) == 1){
  20. var_dump($name);
  21. $success_msg[] = '<b>'.$name.'</b>Member has been marked down for the cap this week.';
  22. }else
  23. $errors[]= 'Error! '.$name.' could not be marked down for this weeks cap.';
  24. }else
  25. $errors[]= '<b>'.$name.'</b> is already marked in the Cap list for this week.';
  26. }
  27. }else{
  28. $errors[]= 'No members have been selected';
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement