1
0

func_addfriend.php 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182
  1. <?php
  2. require_once($_SERVER['DOCUMENT_ROOT'] . "/modules/core/header.php");
  3. $error_message = "";
  4. $friend_id = "";
  5. if(isset($_GET['friend']))
  6. {
  7. $friend_id = $_GET['friend'];
  8. if(!isset($link))
  9. {
  10. $link = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);
  11. if($link === false)
  12. {
  13. die("ERROR: Could not connect. " . mysqli_connect_error());
  14. }
  15. }
  16. if($friend_id == $username) $error_message = "That's sad";
  17. else
  18. {
  19. $friend_id = mysqli_escape_string($link, $friend_id);
  20. $user_check_query = "SELECT ID FROM accounts WHERE Username = BINARY '$friend_id' LIMIT 1";
  21. $res = mysqli_query($link, $user_check_query);
  22. $rowcount = $res->num_rows;
  23. if($rowcount > 0)
  24. {
  25. $result2 = mysqli_fetch_array($res, MYSQLI_ASSOC);
  26. $friendSQL = $result2['ID'];
  27. mysqli_free_result($res);
  28. $user_check_query = "SELECT ID FROM ucp_friends WHERE playerName = '$username' AND friendName = '$friend_id' OR playerName = '$friend_id' AND friendName = '$username' LIMIT 1";
  29. $res = mysqli_query($link, $user_check_query);
  30. $rowcount = $res->num_rows;
  31. if($rowcount > 0)
  32. {
  33. $result2 = mysqli_fetch_array($res, MYSQLI_ASSOC);
  34. $friendPending = $result2['friendPending'];
  35. if($friendPending == 1) $error_message = "There's already a pending request between you two.";
  36. else $error_message = "You're already friends with this user.";
  37. }
  38. else
  39. {
  40. mysqli_free_result($res);
  41. $user_check_query = "INSERT INTO ucp_friends (`friendID`, `playerID`, `friendName`, `playerName`) VALUES ($friendSQL, $playersqlid, '$friend_id', '$username')";
  42. $res = mysqli_query($link, $user_check_query);
  43. $insert = mysqli_insert_id($link);
  44. mysqli_free_result($res);
  45. $user_check_query = "INSERT INTO `notifications` (`master`, `sender`, `friend`) VALUES ('$friendSQL', '$username', '$insert')";
  46. $res = mysqli_query($link, $user_check_query);
  47. mysqli_free_result($res);
  48. $success_message = "Friend request successfully sent.";
  49. }
  50. }
  51. else $error_message = "This user doesn't exist.";
  52. }
  53. }
  54. ?>
  55. <app-popup _nghost-tnh-c158="" class="ng-star-inserted">
  56. <div _ngcontent-tnh-c158="" class="popper">
  57. <div _ngcontent-tnh-c158="" class="popup">
  58. <header _ngcontent-tnh-c158=""><span _ngcontent-tnh-c158="">Friend Request</span><span _ngcontent-tnh-c158="" class="close" onclick="cancelDialog()"><i _ngcontent-tnh-c158="" class="far fa-fw fa-times"></i></span></header>
  59. <div _ngcontent-tnh-c158="" class="popup-content">
  60. <!---->
  61. <div _ngcontent-tnh-c158=""></div>
  62. <!---->
  63. <!---->
  64. <app-popup-friends-new _nghost-tnh-c205="" class="ng-star-inserted">Please enter a player's name to send them a friend request. You need to specify their account name, not a character name. <br _ngcontent-tnh-c205="">
  65. <mat-form-field _ngcontent-tnh-c205="" class="mat-form-field ng-tns-c77-12 mat-primary mat-form-field-type-mat-input mat-form-field-appearance-legacy mat-form-field-can-float mat-form-field-has-label mat-form-field-hide-placeholder ng-pristine ng-valid ng-touched">
  66. <div class="mat-form-field-wrapper ng-tns-c77-12">
  67. <div class="mat-form-field-flex ng-tns-c77-12">
  68. <!---->
  69. <!---->
  70. <div class="mat-form-field-infix ng-tns-c77-12" id="add_friend"><input _ngcontent-tnh-c205="" value="<?php echo $friend_id; ?>" matinput="" class="mat-input-element mat-form-field-autofill-control ng-tns-c77-12 cdk-text-field-autofill-monitored ng-pristine ng-valid ng-touched" id="friend_name" aria-invalid="false" aria-required="false" type="text" maxlength="24" minlength="3"><span class="mat-form-field-label-wrapper ng-tns-c77-12"><label class="mat-form-field-label ng-tns-c77-12 mat-empty mat-form-field-empty ng-star-inserted" id="mat-form-field-label-25" for="mat-input-12" aria-owns="mat-input-12"><span class="ng-tns-c77-12 ng-star-inserted"></span>
  71. <!---->
  72. <!---->
  73. <!---->
  74. <!---->
  75. </label>
  76. <!---->
  77. </span>
  78. </div>
  79. <!---->
  80. </div>
  81. <div class="mat-form-field-underline ng-tns-c77-12 ng-star-inserted"><span class="mat-form-field-ripple ng-tns-c77-12"></span></div>
  82. <!---->
  83. <div class="mat-form-field-subscript-wrapper ng-tns-c77-12">
  84. <!---->
  85. <div class="mat-form-field-hint-wrapper ng-tns-c77-12 ng-trigger ng-trigger-transitionMessages ng-star-inserted" style="opacity: 1; transform: translateY(0%);">
  86. <!---->
  87. <div class="mat-form-field-hint-spacer ng-tns-c77-12"></div>
  88. </div>
  89. <!---->
  90. </div>
  91. </div>
  92. </mat-form-field></br>
  93. <app-button _ngcontent-tnh-c205="" caption="Send Request" class="blue" _nghost-tnh-c216="" id="ChangeButton">
  94. <div _ngcontent-tnh-c216="" id="submit_lol" class="btn-wrapper disabled">
  95. <div _ngcontent-tnh-c216="" class="button">
  96. <!---->
  97. <div _ngcontent-tnh-c216="" class="caption ng-star-inserted">Send Request</div>
  98. <!---->
  99. </div>
  100. <!---->
  101. </div>
  102. </app-button>
  103. <?php if(strlen($success_message) > 0) { ?>
  104. <div _ngcontent-tnh-c205="" class="margin-top-20 ng-star-inserted">
  105. <app-info-bar _ngcontent-tnh-c205="" type="success" class="clearfix width-100" _nghost-tnh-c215="">
  106. <div _ngcontent-tnh-c215="" class="success infobar">
  107. <div _ngcontent-tnh-c215="" class="icon"><i _ngcontent-tnh-c215="" class="fa fa-exclamation-triangle fa-fw"></i></div>
  108. <div _ngcontent-tnh-c215="" class="message"> <?php echo $success_message; ?> </div>
  109. </div>
  110. </app-info-bar>
  111. </div>
  112. <?php } else if(strlen($error_message) > 0) { ?>
  113. <div _ngcontent-tnh-c205="" class="margin-top-20 ng-star-inserted">
  114. <app-info-bar _ngcontent-tnh-c205="" type="error" class="clearfix width-100" _nghost-tnh-c215="">
  115. <div _ngcontent-tnh-c215="" class="error infobar">
  116. <div _ngcontent-tnh-c215="" class="icon"><i _ngcontent-tnh-c215="" class="fa fa-exclamation-triangle fa-fw"></i></div>
  117. <div _ngcontent-tnh-c215="" class="message"> <?php echo $error_message; ?> </div>
  118. </div>
  119. </app-info-bar>
  120. </div>
  121. <?php } ?>
  122. <!---->
  123. </app-popup-friends-new>
  124. <!---->
  125. </div>
  126. </div>
  127. </div>
  128. </app-popup>
  129. <!---->
  130. <script>
  131. (function() {
  132. $('#add_friend').on('keyup', 'input[type="text"]', function()
  133. {
  134. var empty = false;
  135. $('input[type="text"]').each(function()
  136. {
  137. if (($(this).val() == '')) {
  138. empty = true;
  139. }
  140. });
  141. if (empty)
  142. {
  143. $('#submit_lol').addClass('disabled');
  144. document.getElementById("ChangeButton").setAttribute("onClick", "");
  145. }
  146. else
  147. {
  148. $('#submit_lol').removeClass('disabled');
  149. document.getElementById("ChangeButton").setAttribute("onClick", "addFriend()");
  150. }
  151. });
  152. })()
  153. </script>
  154. <?php