libdo

Untitled

Oct 15th, 2017
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. *** jQuery.js ***
  2.  
  3. $(document).ready(function() {
  4. $(".wrench").click(function() {
  5. var anchor = $(this).attr("id").split("-");
  6. var span = $("#span-" + anchor[1]);
  7. var textBox = $("#text-" + anchor[2]);
  8. var userID = anchor[3];
  9. var type = anchor[4];
  10. $.getJSON('../admin_click_update_db.php', {
  11. 'text': textBox.val(),
  12. 'UID': userID,
  13. 'type': type
  14. }, function(data) {
  15. if (data.error == false) {
  16. if (span.text() == 1) {
  17. span.text(0);
  18. } else {
  19. span.text(1);
  20. }
  21. } else {
  22. alert(data.errorMessage);
  23. }
  24. });
  25. });
  26. $(".textBox").change(function() {
  27. var id = $(this).attr("id").split("-");
  28. var val = $(this).val();
  29.  
  30. $.getJSON('../admin_field_update_db.php', {
  31.  
  32. }
  33. });
  34. });
  35.  
  36. *** ADMIN_CLICK_UPDATE_DB.PHP ***
  37.  
  38. <?PHP
  39. $data = array(); $data['error'] = false; $data['change'] = false;
  40. if(isset($_GET['param1']) && isset($_GET['param2']) && isset($_GET['param3'])) {
  41. $data['change'] = true;
  42. $UID = mysql_real_escape_string($_GET['UID']);
  43. $type = mysql_real_escape_string($_GET['type']);
  44. $text = mysql_real_escape_string($_GET['text']);
  45. if($type == 0) {
  46. $new = 1;
  47. $query = mysql_query("SELECT activated FROM JQtest WHERE ID = '$UID'" );
  48. if(mysql_result($query,0) == 1){
  49. $new = 0;
  50. }
  51. } elseif($type == 1) {
  52. $new = 1;
  53. $query = mysql_query("SELECT disabled FROM JQtest WHERE ID = '$UID'" );
  54. if(mysql_result($query,0) == 1){
  55. $new = 0;
  56. }
  57. $query = mysql_query("UPDATE `JQtest` SET disabled='$new' WHERE username='$UID' ");
  58. if(!$query){
  59. $data['error'] = true;
  60. $data['errorMessage'] = mysql_error();
  61. } else {
  62. $data['error'] = false;
  63. }
  64. } else {
  65. $data['error'] = true;
  66. }
  67. echo json_encode($data);
  68. }
  69. ?>
Add Comment
Please, Sign In to add comment