/*****************************************
     flashusers_validate_account.php
*****************************************/
function validate_account(){
//echo "flashusers - validate account<br>";
// if it is a request to confirm the e-mail address...
if ( (isset($_GET['f'])) && ($_GET['f'] == 0) ){
    // see if we have a hash...
    if ( (isset($_GET['h'])) && ($_GET['h'] != "")) {

        // if we do see if it is someone...
        $table_name = $wpdb->prefix . "users";

        $myhash = $_GET['h'];
        $presql  = "SELECT id, user_email, user_verify_email FROM $table_name WHERE user_email_hash = '$myhash'";

        $postsql = $wpdb->prepare($presql);
        $result = $wpdb->get_row($postsql);

        // it is someone after all...
        if ($result != NULL) {
            // so let's see... What do we do if he is already active?
            if ($result->user_verify_email == 1){

                $verified_status_title = _e("Account già verificato.");
                $verified_status_subtitle  = _e("L'indirizzo e-mail &egrave; gi&agrave; stato verificato.");
                $verified_status_text = _e ("Qualora non possiate pi&ugrave; accedere alla vostra casella di posta, vi preghiamo di contattarci.");


            } else {
                $mailChimp = true;
                if ($mailChimp){
                    $mailchimp_msg = "";
                    /*****************************
                              MAILCHIMP
                    ******************************/
                    require 'incs/MCAPI.class.php';
                    require 'incs/config.inc.php'; //contains apikey

                    //API Key - see http://admin.mailchimp.com/account/api
                    $apikey = "545454545";

                    // A List Id to run examples against. use lists() to view all
                    // Also, login to MC account, go to List, then List Tools, and look for the List ID entry
                    $listId = "545454";


                    $api = new MCAPI($apikey);
                    //$merge_vars = array('FNAME'=>$tmpName, 'LNAME'=>$tmpLame);
                    $retval = $api->listSubscribe($listId, 'my@mail.com' );

                    if ($api->errorCode){
                        $mailchimp_msg .= "Unable to load listSubscribe()!\n";
                        $mailchimp_msg .= "\tCode=".$api->errorCode."\n";
                        $mailchimp_msg .= "\tMsg=".$api->errorMessage."\n";
                    }
                }
            //$wpdb->query($update);
            $verified_status_title = _e("Indirizzo e-mail confermato.");
            $verified_status_subtitle  = _e("L'indirizzo e-mail &egrave; stato verificato.");
            $verified_status_text = _e ("Da adesso potrai accedere al sito, compilare il tuo profilo ed iscriverti agli eventi.");
            //LOG IN AUTO

        }


        // nope, false alarm...
        } else {

            $verified_status_title = _e("Account sconosciuto.");
            $verified_status_subtitle  = _e("L'account non pu&ograve; essere riconosciuto").
            $verified_status_text = _e ("Il link utilizzato per verificare l'account potrebbe essere vecchio o inesistente.");


        }

    } else {

        $verified_status_title = _e("Errore nella verifica dell'email");
        $verified_status_subtitle  = _e("Si &egrave; verificato un problema");
        $verified_status_text = _e ("Se pensate di aver fatto tutto correttamente vi preghiamo di contattarci mediante l'appostita pagina.");
    }

    $returnHTML  = $mailchimp_msg.'<br>';

    $returnHTML .= '<div class="mbm phm headerTextContainer" id="flashdating-form-holder">';
    $returnHTML .= '    <div class="title">'.$verified_status_title.'</div>';
    $returnHTML .= '    <div class="sub-title">'.$verified_status_subtitle.'</div>';
    $returnHTML .= '    <div class="text">'.$verified_status_text.'</div>';
    $returnHTML .= '</div>';

    } else $returnHTML = 'This applet is only accessible by the application.';

    return $returnHTML;
}

/*****************************************
     flashusers_chimptest.php
*****************************************/
function chimptest(){
    $returnHTML = "Chimptest running...<br>";

    ini_set('error_reporting', E_ALL);
    include('incs/common.php');
    require 'incs/MCAPI.class.php';

    //API Key - see http://admin.mailchimp.com/account/api
    $apikey = "545454545545";

    // A List Id to run examples against. use lists() to view all
    // Also, login to MC account, go to List, then List Tools, and look for the List ID entry
    $listId = "c54545454";


    $api = new MCAPI($apikey);
    //$merge_vars = array('FNAME'=>$tmpName, 'LNAME'=>$tmpLame);
    $retval = $api->listSubscribe($listId, 'my@mail.com' );

    if ($api->errorCode){
        $returnHTML .= "Unable to load listSubscribe()!\n";
        $returnHTML .= "\tCode=".$api->errorCode."\n";
        $returnHTML .= "\tMsg=".$api->errorMessage."\n";
    } else {
        $returnHTML .= "Subscribed - look for the confirmation email!\n";
    }
    return $returnHTML;
}

/*****************************************
     flashusers.php
*****************************************/

function flashusers_validate_account() {
    include('frontend/flashusers_validate_account.php');
    return validate_account();
}

function flashusers_chimptest(){
    include "frontend/flashusers_chimptest.php";
    return chimptest();

}
add_shortcode ('flashusers_chimptest', 'flashusers_chimptest');
add_shortcode ('flashusers_validate_account','flashusers_validate_account');