Guest User

Untitled

a guest
Oct 24th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.82 KB | None | 0 0
  1. /********************************AJAX SAVE METHOD ***********************************/
  2.  
  3. var tmpWorld = JSON.stringify(world);
  4. var tmpCrafted = JSON.stringify(crafted);
  5. var tmpInventory = JSON.stringify(inventory);
  6. $.ajax({
  7. type: "POST",
  8. url: "php/common.php",
  9. cache: false,
  10. data: "action=save&u=neuroflux&w="+tmpWorld+'&c='+tmpCrafted+'&i='
  11. +tmpInventory+'&t='+tools+'&m='+myBuildings+'&pY='+posY+'&pX='+posX,
  12. beforeSend: function() {
  13. $('.savebutton').html('Saving...');
  14. },
  15. success: function(data) {
  16. $('.savebutton').html('Saved').delay(1000).remove();
  17. if (data !== '1') {
  18. console.log("Oh noes! The fail whale has struck: " + data);
  19. }
  20. }
  21. });
  22.  
  23.  
  24. /************************************PHP FILE*************************************/
  25. <?
  26. $dbhost = 'localhost';
  27. $dbuser = 'root';
  28. $dbpass = '';
  29. $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('connecting death');
  30. $dbname = 'universe';
  31. mysql_select_db($dbname) or die ("dbname death");
  32.  
  33. $action = mysql_real_escape_string(trim($_POST['action']));
  34. $username = mysql_real_escape_string(trim($_POST['u']));
  35. $world = mysql_real_escape_string(trim($_POST['w']));
  36. $crafted = mysql_real_escape_string(trim($_POST['c']));
  37. $inventory = mysql_real_escape_string(trim($_POST['i']));
  38. $tools = mysql_real_escape_string(trim($_POST['t']));
  39. $myBuildings = mysql_real_escape_string(trim($_POST['m']));
  40. $posY = mysql_real_escape_string(trim($_POST['pY']));
  41. $posX = mysql_real_escape_string(trim($_POST['pX']));
  42.  
  43. if ($action == "save") {
  44. $result = mysql_query(
  45. "INSERT INTO `worlds`
  46. (`username`,`world`,`crafted`,`inventory`,`tools`,`myBuildings`,`posY`,`posX`)
  47. VALUES
  48. ('$username','$world','$crafted','$inventory','$tools','$myBuildings','$posY','$posX')"
  49. ) or die(mysql_error());
  50. echo "1";
  51. }
  52. ?>
Add Comment
Please, Sign In to add comment