Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /********************************AJAX SAVE METHOD ***********************************/
- var tmpWorld = JSON.stringify(world);
- var tmpCrafted = JSON.stringify(crafted);
- var tmpInventory = JSON.stringify(inventory);
- $.ajax({
- type: "POST",
- url: "php/common.php",
- cache: false,
- data: "action=save&u=neuroflux&w="+tmpWorld+'&c='+tmpCrafted+'&i='
- +tmpInventory+'&t='+tools+'&m='+myBuildings+'&pY='+posY+'&pX='+posX,
- beforeSend: function() {
- $('.savebutton').html('Saving...');
- },
- success: function(data) {
- $('.savebutton').html('Saved').delay(1000).remove();
- if (data !== '1') {
- console.log("Oh noes! The fail whale has struck: " + data);
- }
- }
- });
- /************************************PHP FILE*************************************/
- <?
- $dbhost = 'localhost';
- $dbuser = 'root';
- $dbpass = '';
- $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('connecting death');
- $dbname = 'universe';
- mysql_select_db($dbname) or die ("dbname death");
- $action = mysql_real_escape_string(trim($_POST['action']));
- $username = mysql_real_escape_string(trim($_POST['u']));
- $world = mysql_real_escape_string(trim($_POST['w']));
- $crafted = mysql_real_escape_string(trim($_POST['c']));
- $inventory = mysql_real_escape_string(trim($_POST['i']));
- $tools = mysql_real_escape_string(trim($_POST['t']));
- $myBuildings = mysql_real_escape_string(trim($_POST['m']));
- $posY = mysql_real_escape_string(trim($_POST['pY']));
- $posX = mysql_real_escape_string(trim($_POST['pX']));
- if ($action == "save") {
- $result = mysql_query(
- "INSERT INTO `worlds`
- (`username`,`world`,`crafted`,`inventory`,`tools`,`myBuildings`,`posY`,`posX`)
- VALUES
- ('$username','$world','$crafted','$inventory','$tools','$myBuildings','$posY','$posX')"
- ) or die(mysql_error());
- echo "1";
- }
- ?>
Add Comment
Please, Sign In to add comment