<?php
    //index.php

    define('FORUM_ROOT', '/var/www/nginx-default/punbb/');
    require FORUM_ROOT . 'include/common.php';

    #Full URL to current event
    $forum_page['redirect_url'] = "/nibbleblog/test2/";
    $forum_page['form_action'] = forum_link($forum_url['login']);
    $forum_page['hidden_fields'] = array(
        'form_sent' => '<input type="hidden" name="form_sent" value="1" />',
        'redirect_url'  => '<input type="hidden" name="redirect_url" value="'.forum_htmlencode($forum_page['redirect_url']).'" />',
        'csrf_token'    => '<input type="hidden" name="csrf_token" value="'.generate_form_token($forum_page['form_action']).'" />'
    );

    if(!$forum_user['is_guest']) {
    $link = sprintf('<a href="%s&amp;redirect_url=%s">%s</a><p>',forum_link($forum_url['logout'], array($forum_user['id'], generate_form_token('logout'.$forum_user['id']))),$forum_page['redirect_url'],$lang_common['Logout']);
    print $link;

        //Check SQLite to display subscribed users, and button: Subscribe or Unsubscribe
        try
        {
        $dbh = new PDO('sqlite:events.sqlite');

            //TEMP : TO REMOVE ONCE ISSUE SOLVED!
            $var_url['idpost'] = 7;
            //TEMP : TO REMOVE ONCE ISSUE SOLVED!

            //Check if current user is subscribed or not -> display Subscribe or Unsubscribe
        $sql = sprintf("SELECT COUNT(id) FROM subscription WHERE event=%s AND username='%s'",$var_url['idpost'],$forum_user['username']);
            $subscribed = $dbh->query($sql)->fetchColumn();
            //Choose button value depending on subscribed/unsubscribed
            if($subscribed) {
                $value = "Unsubscribe";
            } else {
                $value = "Subscribe";
            }
            ?>
        <form method="post" action="action.php">
            <input type="hidden" name="event" value="<?php echo $var_url['idpost']; ?>" />
            <input type="submit" name="subscribe" value="<?php echo $value; ?>" />
                </form>
            <?php

            $dbh = null;
        } catch(PDOException $e) {
                echo $e->getMessage();
    }

    } else {
        ?>
        Authentication required<p>

    <form method="post" action="<?php echo $forum_page['form_action'] ?>">
            <?php echo implode("\n\t\t", $forum_page['hidden_fields'])."\n" ?>

            User: <input type="text" id="fld1" name="req_username" value="" /> <br />

            Password: <input type="password" id="fld2" name="req_password" value="" /> <br />

            <input type="submit" name="login" id="login" value="Login" />
         </form>
        <?php
    }
?>