Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?PHP
- //error_reporting(E_ALL);
- error_reporting(0);
- include ("../system/sl_wrapper.php");
- include ("../system/db.php");
- include ("../system/pass.php");
- if($headers["Password"] != $SLAPIPass)
- {
- header("Location: http://www.disney.com/");
- die();
- }
- $receiverkey=$headers["ReceiverKey"];
- $receivername=$headers["ReceiverName"];
- $packname = $headers["Packname"];
- $extrabuttons = $headers["Extrabuttons"];
- //$receiverkey="bad329de-d9c0-4cd9-abfa-79dc460427d1";
- //$receivername="Trendy Broek";
- //$packname = "test";
- //$extrabuttons ="NULL";
- if ($extrabuttons=="NULL") $extrabuttons="";
- // Create connection
- $conn = new mysqli($servername, $username, $password, $dbname);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- //else echo "Conntected";<div></div>
- //echo $receiverkey;
- //echo $receivername;
- //echo $packname;
- //echo $extrabuttons;
- $sql = "select * from Ambiance where OwnerID = '".$receiverkey."'";
- $result = mysqli_query($conn, $sql);
- if (mysqli_num_rows($result) > 0)
- {
- $row = mysqli_fetch_assoc($result);
- {
- $spacer="";
- if ((!empty($extrabuttons)) && $extrabuttons!="NULL" && (!empty($row["Extrabuttons"])) ) $spacer=",";
- $sql = "UPDATE Ambiance SET Playbuttons ='".$row["Playbuttons"].",".$packname."', Extrabuttons ='".$row["Extrabuttons"].$spacer.$extrabuttons."' WHERE OwnerID='".$receiverkey."'";
- if (mysqli_query($conn, $sql)) {
- echo "Success - updated sound pack data in database.";
- } else {
- echo "Error updating record: " . mysqli_error($conn);
- }
- }
- } else {
- $sql = "INSERT INTO Ambiance (OwnerID, OwnerName, Playbuttons, Extrabuttons) VALUES ('".$receiverkey."', '".$receivername."', '".$packname."', '".$extrabuttons."')";
- if ($conn->query($sql) === TRUE)
- {
- echo "Success - Sound-pack inserted into database.";
- } else {
- echo "Error1: " . $sql . "<br>" . $conn->error;
- }
- }
- mysqli_close($conn);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement