<?php
include_once '../config.php';

$mysqli = new mysqli($host, $user, $password, $db_name);
if ($mysqli->connect_errno) {
    echo "Nepavyko prisijungti prie duomenų bazės: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}



$sql = "SELECT * FROM Vartotojai WHERE atlikta=0";
/* If the query is valid $result will now
 * hold an indexed array of data */
$result = mysqli_query($sql);
/* mysql_fetch_assoc will give you each row as
 * $row['column_name'] */
while ($row = mysqli_fetch_assoc($result)) {
    if ($row['apmoketa'] == 1) {
        //Uzdeti privilegijas
        echo "Uzdeti privilegijas";
    } else {
        if ($row['dienos'] == 0) {
            //Panaikinti privilegijas
            echo "Panaikinti privilegijas";
        } else {
            //Nieko nedaryti
            echo "Nieko nedaryti";
        }
    }
}

while ($row = mysqli_fetch_assoc($result)) {
    if ($row['dienos'] > 0) {
        $dienos = $row['dienos'] - 1;
        $sql = "UPDATE Vartotojai SET dienos=$dienos WHERE vardas='".$row['vardas']."'";
        if ($mysqli->query($sql) === TRUE) {
            echo "Pavyko!";
        } else {
            echo "Erroras: " . $mysqli->error;
        }
    }
}
?>