index.php

<?php
    
    // Exchanges in DB:
    // Binance.COM  1
    // Binance.US   8
    // Bitfinex     2
    // Bitvavo      3
    // bitpanda     4
    // Upbit        5
    // Indodax      6
    // KuCoin       7
    // Bitrue       9

    // PAY ATTENTION ON THE ORDER ABOVE!!!

    // Status in DB:
    // 0            down
    // 1            up

    // !-- MySQL Database table needs to be cleared every 24 hours trough a cron job or similar --!

    require_once('config.php');

    // Implement functions
    require("functions/getAddressBalance.php");

    $voteMessage = "";

    $userIP = $_SERVER['REMOTE_ADDR'];
    $IPConcat = "$userIP$IPSalt";
    $userIPHashed = hash("sha256", $IPConcat);

    // create connection
    $conn = mysqli_connect($host, $username, $password, $database);

    // check connection
    if($conn->connect_error) {
        die("Connection to database failed.");
    }

    // Check POST methods to track votes
    if(isset($_POST['binancedown'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 1";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '1', '0')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Binance.COM withdrawals being suspended!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif (isset($_POST['binanceup'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 1";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '1', '1')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Binance withdrawals.COM being possible!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['bitfinexup'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 2";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '2', '1')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Bitfinex withdrawals being possible!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['bitfinexdown'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 2";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '2', '0')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Bitfinex withdrawals being suspended!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['bitvavoup'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 3";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '3', '1')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Bitvavo withdrawals being possible!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['bitvavodown'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 3";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '3', '0')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Bitvavo withdrawals being suspended!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['bitpandaup'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 4";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '4', '1')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for bitpanda withdrawals being possible!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['bitpandadown'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 4";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '4', '0')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for bitpanda withdrawals being suspended!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['upbitup'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 5";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '5', '1')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Upbit withdrawals being possible!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['upbitdown'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 5";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '5', '0')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Upbit withdrawals being suspended!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['indodaxup'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 6";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '6', '1')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Indodax withdrawals being possible!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['indodaxdown'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 6";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '6', '0')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Indodax withdrawals being suspended!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['kucoinup'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 7";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '7', '1')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for KuCoin withdrawals being possible!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['kucoindown'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 7";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '7', '0')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for KuCoin withdrawals being suspended!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['binanceusup'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 8";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '8', '1')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Binance.US withdrawals being possible!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['binanceusdown'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 8";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '8', '0')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Binance.US withdrawals being suspended!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['bitrueup'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 9";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '9', '1')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Bitrue withdrawals being possible!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['bitruedown'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 9";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '9', '0')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Bitrue withdrawals being suspended!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['coinmerceup'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 10";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '10', '1')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Coinmerce.io withdrawals being possible!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    } elseif(isset($_POST['coinmercedown'])) {
        $sql = "SELECT * FROM votes WHERE IP = '$userIPHashed' AND Exchange = 10";
        $result = mysqli_query($conn, $sql);
        $count = mysqli_num_rows($result);
        if($count == 0) {
            $sql = "INSERT INTO `votes` (`ID`, `IP`, `Exchange`, `Status`) VALUES (NULL, '$userIPHashed', '10', '0')";
            if($conn->query($sql) === TRUE) {
                $voteMessage = "You voted for Coinmerce.io withdrawals being suspended!";
            } else {
                $voteMessage = "There was an issue with the database.";
            }
        } else {
            $voteMessage = "You already voted in the last 24 hours!";
        }
    }

    function get_percentage($total, $number) {
        if ( $total > 0 ) {
            return round(($number * 100) / $total, 2);
        } else {
            return 0;
        }
    }
?>

<html>
    <head>
        <title>IOTA exchange status</title>
        <link rel="stylesheet" type="text/css" href="css/main.css">
        <link rel="preconnect" href="https://fonts.googleapis.com">
        <link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
        <link href="https://fonts.googleapis.com/css2?family=Open+Sans:wght@300;400;500;700&display=swap" rel="stylesheet"> 
    </head>
    <body>
        <div class="header">
            <h1><a href="https://iotaexchangestatus.canreal.net">IOTA Exchange Status</a></h1>
            <p>This simple website tracks if exhanges allow withdrawals of IOTA based on user votes. - Most exchanges don't allow me to check if withdrawals are enabled via their API, so this is the only solution I figured out.</p>
            <p>
                <?php echo "The current server time is " . date("h:i:sa") ."<br>Votes will always be reset at 12am server time!"; ?>
            </p>

            <p>
                <br><br><span class="voteMessage" style="color: #FFBF00">
                INFO: 
                    <?php
                        echo $voteMessage;
                    ?>
                </span>
            </p>

        </div>
            <div class=content>
            <section id="binance-com">
                <h2><a href="https://www.binance.com">Binance.com</a></h2>
                <p>
                    <?php 
                        $sql = "SELECT * FROM votes WHERE Exchange = 1 AND Status = 0";
                        $result = mysqli_query($conn, $sql);
                        $downCount = mysqli_num_rows($result);
                        echo $downCount;
                    ?> votes for suspended withdrawals in the last 24 hours.<br>
                    <?php
                        $sql = "SELECT * FROM votes WHERE Exchange = 1 AND Status = 1";
                        $result = mysqli_query($conn, $sql);
                        $upCount = mysqli_num_rows($result);
                        echo $upCount;
                    ?> votes for possible withdrawals in the last 24 hours.<br>
                    <?php
                    // Check how many percent of users voted for suspended withdrawals
                        $total = $downCount + $upCount;
                        $percentage = get_percentage($total, $downCount);
                        echo "<br>Therefore, $percentage% voted for suspended withdrawals in the last 24 hours.<br>";
                        if($percentage >= 20) {
                            echo '<br><span style="color: #FFBF00; font-weight:500;">It is likely that withdrawals are suspended at the moment, because more than 20% voted for suspended withdrawals!</span>';
                        }
                    ?>
                </p>
                <p>Have you withdrawn recently? If so, please vote:</p>
                <form method="post">
                    <input type="submit" name="binanceup" value="Withdrawal possible" style="background-color: #52B788">
                    <input type="submit" name="binancedown" value="Withdrawal suspended" style="background-color: #E63946">
                </form>
                <p>
                    Hot wallet balance: <?php echo getAddressBalance("iota1qrp7wn7ag964yh7r6csphg8l47q9ehlpxz8tukhad09x7avjj09s5qunq87"); ?><br>
                    Cold wallet balance: <?php echo getAddressBalance("iota1qptaxjt2un3qgnu40j7kgdjyucwph45pwstfwl7r3dlswyels50qcetuyk4"); ?>
                </p>
            </section>

            <section id="binance-us">
                <h2><a href="https://www.binance.us">Binance.us</a></h2>
                <p>
                    <?php 
                        $sql = "SELECT * FROM votes WHERE Exchange = 8 AND Status = 0";
                        $result = mysqli_query($conn, $sql);
                        $downCount = mysqli_num_rows($result);
                        echo $downCount;
                    ?> votes for suspended withdrawals in the last 24 hours.<br>
                    <?php
                        $sql = "SELECT * FROM votes WHERE Exchange = 8 AND Status = 1";
                        $result = mysqli_query($conn, $sql);
                        $upCount = mysqli_num_rows($result);
                        echo $upCount;
                    ?> votes for possible withdrawals in the last 24 hours.<br>
                    <?php
                    // Check how many percent of users voted for suspended withdrawals
                        $total = $downCount + $upCount;
                        $percentage = get_percentage($total, $downCount);
                        echo "<br>Therefore, $percentage% voted for suspended withdrawals in the last 24 hours.<br>";
                        if($percentage >= 20) {
                            echo '<br><span style="color: #FFBF00; font-weight:500;">It is likely that withdrawals are suspended at the moment, because more than 20% voted for suspended withdrawals!</span>';
                        }
                    ?>
                </p>
                <p>Have you withdrawn recently? If so, please vote:</p>
                <form method="post">
                    <input type="submit" name="binanceusup" value="Withdrawal possible" style="background-color: #52B788">
                    <input type="submit" name="binanceusdown" value="Withdrawal suspended" style="background-color: #E63946">
                </form>
            </section>
            
            <section id="bitfinex">
                <h2><a href="https://www.bitfinex.com/">Bitfinex</a></h2>
                <p>
                    <?php 
                        $sql = "SELECT * FROM votes WHERE Exchange = 2 AND Status = 0";
                        $result = mysqli_query($conn, $sql);
                        $downCount = mysqli_num_rows($result);
                        echo $downCount;
                    ?> votes for suspended withdrawals in the last 24 hours.<br>
                    <?php
                        $sql = "SELECT * FROM votes WHERE Exchange = 2 AND Status = 1";
                        $result = mysqli_query($conn, $sql);
                        $upCount = mysqli_num_rows($result);
                        echo $upCount;
                    ?> votes for possible withdrawals in the last 24 hours.<br>
                    <?php
                    // Check how many percent of users voted for suspended withdrawals
                        $total = $downCount + $upCount;
                        $percentage = get_percentage($total, $downCount);
                        echo "<br>Therefore, $percentage% voted for suspended withdrawals in the last 24 hours.<br>";
                        if($percentage >= 20) {
                            echo '<br><span style="color: #FFBF00; font-weight:500;">It is likely that withdrawals are suspended at the moment, because more than 20% voted for suspended withdrawals!</span>';
                        }
                    ?>
                </p>
                <p>Have you withdrawn recently? If so, please vote:</p>
                <form method="post">
                    <input type="submit" name="bitfinexup" value="Withdrawal possible" style="background-color: #52B788">
                    <input type="submit" name="bitfinexdown" value="Withdrawal suspended" style="background-color: #E63946">
                </form>
            </section>

            <section id="bitvavo">
                <h2><a href="https://bitvavo.com">Bitvavo</a></h2>
                <p>
                    <?php 
                        $sql = "SELECT * FROM votes WHERE Exchange = 3 AND Status = 0";
                        $result = mysqli_query($conn, $sql);
                        $downCount = mysqli_num_rows($result);
                        echo $downCount;
                    ?> votes for suspended withdrawals in the last 24 hours.<br>
                    <?php
                        $sql = "SELECT * FROM votes WHERE Exchange = 3 AND Status = 1";
                        $result = mysqli_query($conn, $sql);
                        $upCount = mysqli_num_rows($result);
                        echo $upCount;
                    ?> votes for possible withdrawals in the last 24 hours.<br>
                    <?php
                    // Check how many percent of users voted for suspended withdrawals
                        $total = $downCount + $upCount;
                        $percentage = get_percentage($total, $downCount);
                        echo "<br>Therefore, $percentage% voted for suspended withdrawals in the last 24 hours.<br>";
                        if($percentage >= 20) {
                            echo '<br><span style="color: #FFBF00; font-weight:500;">It is likely that withdrawals are suspended at the moment, because more than 20% voted for suspended withdrawals!</span>';
                        }
                    ?>
                </p>
                <p>Have you withdrawn recently? If so, please vote:</p>
                <form method="post">
                    <input type="submit" name="bitvavoup" value="Withdrawal possible" style="background-color: #52B788">
                    <input type="submit" name="bitvavodown" value="Withdrawal suspended" style="background-color: #E63946">
                </form>
            </section>

            <section id="bitpanda">
                <h2><a href="https://www.bitpanda.com">bitpanda</a></h2>
                <p>
                    <?php 
                        $sql = "SELECT * FROM votes WHERE Exchange = 4 AND Status = 0";
                        $result = mysqli_query($conn, $sql);
                        $downCount = mysqli_num_rows($result);
                        echo $downCount;
                    ?> votes for suspended withdrawals in the last 24 hours.<br>
                    <?php
                        $sql = "SELECT * FROM votes WHERE Exchange = 4 AND Status = 1";
                        $result = mysqli_query($conn, $sql);
                        $upCount = mysqli_num_rows($result);
                        echo $upCount;
                    ?> votes for possible withdrawals in the last 24 hours.<br>
                    <?php
                    // Check how many percent of users voted for suspended withdrawals
                        $total = $downCount + $upCount;
                        $percentage = get_percentage($total, $downCount);
                        echo "<br>Therefore, $percentage% voted for suspended withdrawals in the last 24 hours.<br>";
                        if($percentage >= 20) {
                            echo '<br><span style="color: #FFBF00; font-weight:500;">It is likely that withdrawals are suspended at the moment, because more than 20% voted for suspended withdrawals!</span>';
                        }
                    ?>
                </p>
                <p>Have you withdrawn recently? If so, please vote:</p>
                <form method="post">
                    <input type="submit" name="bitpandaup" value="Withdrawal possible" style="background-color: #52B788">
                    <input type="submit" name="bitpandadown" value="Withdrawal suspended" style="background-color: #E63946">
                </form>
            </section>

            <section id="upbit">
                <h2><a href="https://upbit.com">Upbit</a></h2>
                <p>
                    <?php 
                        $sql = "SELECT * FROM votes WHERE Exchange = 5 AND Status = 0";
                        $result = mysqli_query($conn, $sql);
                        $downCount = mysqli_num_rows($result);
                        echo $downCount;
                    ?> votes for suspended withdrawals in the last 24 hours.<br>
                    <?php
                        $sql = "SELECT * FROM votes WHERE Exchange = 5 AND Status = 1";
                        $result = mysqli_query($conn, $sql);
                        $upCount = mysqli_num_rows($result);
                        echo $upCount;
                    ?> votes for possible withdrawals in the last 24 hours.<br>
                    <?php
                    // Check how many percent of users voted for suspended withdrawals
                        $total = $downCount + $upCount;
                        $percentage = get_percentage($total, $downCount);
                        echo "<br>Therefore, $percentage% voted for suspended withdrawals in the last 24 hours.<br>";
                        if($percentage >= 20) {
                            echo '<br><span style="color: #FFBF00; font-weight:500;">It is likely that withdrawals are suspended at the moment, because more than 20% voted for suspended withdrawals!</span>';
                        }
                    ?>
                </p>
                <p>Have you withdrawn recently? If so, please vote:</p>
                <form method="post">
                    <input type="submit" name="upbitup" value="Withdrawal possible" style="background-color: #52B788">
                    <input type="submit" name="upbitdown" value="Withdrawal suspended" style="background-color: #E63946">
                </form>
            </section>

            <section id="indodax">
                <h2><a href="https://indodax.com/">Indodax</a></h2>
                <p>
                    <?php 
                        $sql = "SELECT * FROM votes WHERE Exchange = 6 AND Status = 0";
                        $result = mysqli_query($conn, $sql);
                        $downCount = mysqli_num_rows($result);
                        echo $downCount;
                    ?> votes for suspended withdrawals in the last 24 hours.<br>
                    <?php
                        $sql = "SELECT * FROM votes WHERE Exchange = 6 AND Status = 1";
                        $result = mysqli_query($conn, $sql);
                        $upCount = mysqli_num_rows($result);
                        echo $upCount;
                    ?> votes for possible withdrawals in the last 24 hours.<br>
                    <?php
                    // Check how many percent of users voted for suspended withdrawals
                        $total = $downCount + $upCount;
                        $percentage = get_percentage($total, $downCount);
                        echo "<br>Therefore, $percentage% voted for suspended withdrawals in the last 24 hours.<br>";
                        if($percentage >= 20) {
                            echo '<br><span style="color: #FFBF00; font-weight:500;">It is likely that withdrawals are suspended at the moment, because more than 20% voted for suspended withdrawals!</span>';
                        }
                    ?>
                </p>
                <p>Have you withdrawn recently? If so, please vote:</p>
                <form method="post">
                    <input type="submit" name="indodaxup" value="Withdrawal possible" style="background-color: #52B788">
                    <input type="submit" name="indodaxdown" value="Withdrawal suspended" style="background-color: #E63946">
                </form>
            </section>

            <section id="kucoin">
                <h2><a href="https://www.kucoin.com/">KuCoin</a></h2>
                <p>
                    <?php 
                        $sql = "SELECT * FROM votes WHERE Exchange = 7 AND Status = 0";
                        $result = mysqli_query($conn, $sql);
                        $downCount = mysqli_num_rows($result);
                        echo $downCount;
                    ?> votes for suspended withdrawals in the last 24 hours.<br>
                    <?php
                        $sql = "SELECT * FROM votes WHERE Exchange = 7 AND Status = 1";
                        $result = mysqli_query($conn, $sql);
                        $upCount = mysqli_num_rows($result);
                        echo $upCount;
                    ?> votes for possible withdrawals in the last 24 hours.<br>
                    <?php
                    // Check how many percent of users voted for suspended withdrawals
                        $total = $downCount + $upCount;
                        $percentage = get_percentage($total, $downCount);
                        echo "<br>Therefore, $percentage% voted for suspended withdrawals in the last 24 hours.<br>";
                        if($percentage >= 20) {
                            echo '<br><span style="color: #FFBF00; font-weight:500;">It is likely that withdrawals are suspended at the moment, because more than 20% voted for suspended withdrawals!</span>';
                        }
                    ?>
                </p>
                <p>Have you withdrawn recently? If so, please vote:</p>
                <form method="post">
                    <input type="submit" name="kucoinup" value="Withdrawal possible" style="background-color: #52B788">
                    <input type="submit" name="kucoindown" value="Withdrawal suspended" style="background-color: #E63946">
                </form>
            </section>

            <section id="bitrue">
                <h2><a href="https://www.bitrue.com/">Bitrue</a></h2>
                <p>
                    <?php 
                        $sql = "SELECT * FROM votes WHERE Exchange = 9 AND Status = 0";
                        $result = mysqli_query($conn, $sql);
                        $downCount = mysqli_num_rows($result);
                        echo $downCount;
                    ?> votes for suspended withdrawals in the last 24 hours.<br>
                    <?php
                        $sql = "SELECT * FROM votes WHERE Exchange = 9 AND Status = 1";
                        $result = mysqli_query($conn, $sql);
                        $upCount = mysqli_num_rows($result);
                        echo $upCount;
                    ?> votes for possible withdrawals in the last 24 hours.<br>
                    <?php
                    // Check how many percent of users voted for suspended withdrawals
                        $total = $downCount + $upCount;
                        $percentage = get_percentage($total, $downCount);
                        echo "<br>Therefore, $percentage% voted for suspended withdrawals in the last 24 hours.<br>";
                        if($percentage >= 20) {
                            echo '<br><span style="color: #FFBF00; font-weight:500;">It is likely that withdrawals are suspended at the moment, because more than 20% voted for suspended withdrawals!</span>';
                        }
                    ?>
                </p>
                <p>Have you withdrawn recently? If so, please vote:</p>
                <form method="post">
                    <input type="submit" name="bitrueup" value="Withdrawal possible" style="background-color: #52B788">
                    <input type="submit" name="bitruedown" value="Withdrawal suspended" style="background-color: #E63946">
                </form>
            </section>

            <section id="coinmerceio">
                <h2><a href="https://coinmerce.io/">Coinmerce.io</a></h2>
                <p>
                    <?php 
                        $sql = "SELECT * FROM votes WHERE Exchange = 10 AND Status = 0";
                        $result = mysqli_query($conn, $sql);
                        $downCount = mysqli_num_rows($result);
                        echo $downCount;
                    ?> votes for suspended withdrawals in the last 24 hours.<br>
                    <?php
                        $sql = "SELECT * FROM votes WHERE Exchange = 10 AND Status = 1";
                        $result = mysqli_query($conn, $sql);
                        $upCount = mysqli_num_rows($result);
                        echo $upCount;
                    ?> votes for possible withdrawals in the last 24 hours.<br>
                    <?php
                    // Check how many percent of users voted for suspended withdrawals
                        $total = $downCount + $upCount;
                        $percentage = get_percentage($total, $downCount);
                        echo "<br>Therefore, $percentage% voted for suspended withdrawals in the last 24 hours.<br>";
                        if($percentage >= 20) {
                            echo '<br><span style="color: #FFBF00; font-weight:500;">It is likely that withdrawals are suspended at the moment, because more than 20% voted for suspended withdrawals!</span>';
                        }
                    ?>
                </p>
                <p>Have you withdrawn recently? If so, please vote:</p>
                <form method="post">
                    <input type="submit" name="coinmerceup" value="Withdrawal possible" style="background-color: #52B788">
                    <input type="submit" name="coinmercedown" value="Withdrawal suspended" style="background-color: #E63946">
                </form>
            </section>

        </div>
        <div class="footer">
            <a href="https://www.buymeacoffee.com/thisdudeisvegan" target="_blank"><img src="https://cdn.buymeacoffee.com/buttons/v2/default-yellow.png" alt="Buy Me A Coffee" style="height: 60px !important;width: 217px !important;" ></a>
            <p>
                <span style="color: #FFBF00; font-weight: 500;">IOTA Donation address:</span><br>
                iota1qqm9k3003sszpq4d5n0yc89pk6dvpm3wvc7lexlzr2nwwrpaxaxdg7f85k6<br><br>
                Developed with ❤️ by <a href="https://github.com/braydofficial">braydofficial / thisdudeisvegan</a><br>
                Open Source and on <a href="https://github.com/braydofficial/iotaexchangestatus">GitHub</a><br>
            </p>
        </div>
    </body>
    <script type="text/javascript">

        (function() {
            var start = new Date.toLocaleString("en-US", {timeZone: "Europe/Berlin"});
            start.setHours(0, 0, 0); // 12am

            function pad(num) {
                return ("0" + parseInt(num)).substr(-2);
            }

            function tick() {
                var now = new Date;
                if (now > start) { // too late, go to tomorrow
                start.setDate(start.getDate() + 1);
                }
                var remain = ((start - now) / 1000);
                var hh = pad((remain / 60 / 60) % 60);
                var mm = pad((remain / 60) % 60);
                var ss = pad(remain % 60);
                document.getElementById('countdown').innerHTML =
                hh + ":" + mm + ":" + ss;
                setTimeout(tick, 1000);
            }

            document.addEventListener('DOMContentLoaded', tick);
        })();

    </script>
</html>