<?php
    $servername = "localhost";
    $username = "felhasz";
    $password = "jelszo";
    $dbname = "adatbázis";

    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }

    $addresses = array('Ide egy IP és csak arról fogja fogadni');

    if(!in_array($_SERVER['REMOTE_ADDR'], $addresses))
        die('Anyádpicsája');

    $phone   = $_GET["tel"];
    $prefix  = $_GET["prefix"];
    $message = intval($_GET["message"]);
    $value   = $_GET["value"];
    $smsid   = $_GET["id"];

    $sql = mysqli_query($conn, "SELECT * FROM accounts WHERE accid = '" . $message . "'");
    $row = mysqli_fetch_array($sql);
    $sqlUpload = mysqli_query($conn, "UPDATE accounts SET premium='" . intval($row["premium"]+$value*2.2) . "' WHERE accid='" . $message . "'");
    //$sqlUploadArray = mysqli_fetch_array($sqlUpload);

    echo "SMS: " . $value . "<br>";
    echo "ELŐTTE PP: " . intval($row["premium"]) . "<br>";
    echo "Hozzáadva: " . intval($row["premium"]+$value*2.2) . "<br>";
    //echo "PP: " . intval($message) . "";
    $conn->close();
?>