Advertisement
Guest User

Untitled

a guest
Jun 25th, 2019
157
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.08 KB | None | 0 0
  1. <?PHP
  2.  
  3. //error_reporting(E_ALL);
  4. error_reporting(0);
  5. include ("../system/sl_wrapper.php");
  6. include ("../system/db.php");
  7. include ("../system/pass.php");
  8.  
  9. if($headers["Password"] != $SLAPIPass)
  10. {
  11.     header("Location: http://www.disney.com/");
  12.     die();
  13. }
  14. $receiverkey=$headers["ReceiverKey"];
  15. $receivername=$headers["ReceiverName"];
  16. $packname = $headers["Packname"];
  17. $extrabuttons = $headers["Extrabuttons"];
  18.  
  19. //$receiverkey="bad329de-d9c0-4cd9-abfa-79dc460427d1";
  20. //$receivername="Trendy Broek";
  21. //$packname = "test";
  22. //$extrabuttons ="NULL";
  23.  
  24. if ($extrabuttons=="NULL") $extrabuttons="";
  25.  
  26. // Create connection
  27. $conn = new mysqli($servername, $username, $password, $dbname);
  28. // Check connection
  29. if ($conn->connect_error) {
  30.     die("Connection failed: " . $conn->connect_error);
  31. }
  32. //else echo "Conntected";<div></div>
  33.  
  34. //echo $receiverkey;
  35. //echo $receivername;
  36. //echo $packname;
  37. //echo $extrabuttons;
  38.  
  39. $sql = "select * from Ambiance where OwnerID = '".$receiverkey."'";
  40. $result = mysqli_query($conn, $sql);
  41. if (mysqli_num_rows($result) > 0)
  42. {
  43.     $row = mysqli_fetch_assoc($result);
  44.     {        
  45.                 $spacer="";
  46.                 if ((!empty($extrabuttons)) && $extrabuttons!="NULL" && (!empty($row["Extrabuttons"])) ) $spacer=",";
  47.             $sql = "UPDATE Ambiance SET Playbuttons ='".$row["Playbuttons"].",".$packname."', Extrabuttons ='".$row["Extrabuttons"].$spacer.$extrabuttons."'  WHERE OwnerID='".$receiverkey."'";
  48.    
  49.             if (mysqli_query($conn, $sql)) {
  50.             echo "Success - updated sound pack data in database.";
  51.             } else {
  52.                 echo "Error updating record: " . mysqli_error($conn);
  53.             }
  54.     }
  55. } else {
  56.                     $sql = "INSERT INTO Ambiance (OwnerID, OwnerName, Playbuttons, Extrabuttons) VALUES ('".$receiverkey."', '".$receivername."', '".$packname."', '".$extrabuttons."')";
  57.                     if ($conn->query($sql) === TRUE)
  58.                     {
  59.                     echo "Success - Sound-pack inserted into database.";
  60.                         } else {
  61.                         echo "Error1: " . $sql . "<br>" . $conn->error;
  62.                         }
  63. }
  64.  
  65. mysqli_close($conn);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement