<?php
session_start();
$server = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "bitticket";
$connect = new PDO("mysql:host=$server;dbname=$dbname",$dbuser,$dbpass);
function random($car) {
$string = "";
$chaine = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
srand((double)microtime()*1000000);
for($i=0; $i<$car; $i++) {
$string .= $chaine[rand()%strlen($chaine)];
}
return $string;
}

if(isset($_SESSION['guest'])){
    header('location:guest.php');

}elseif(isset($_SESSION['username'])){
    header('location:dashboard.php');


}else{
    $chaine = random(10);
    $date = date("d-m-Y");
    $guest_user = 'G_'.$chaine;
    require "lib/api/bc/newaddy.php";
    $_SESSION['address'] = $address;
    $_SESSION['guest'] = $guest_user;
    $requete = $connect->prepare("INSERT INTO user_info VALUES(:username,:password,:pin,:address,:ticket,:t_withdrawal,:t_used,:t_earning,:t_earning1,:guest,:date)");
    $requete->execute(array(':username' => $guest_user ,':password' => '' ,':pin' => '' ,':address' => $address ,':ticket'=>3,':t_withdrawal'=>0,':t_used' => 0 ,':t_earning' => 0 ,':t_earning1' => 0 ,':guest' => true,':date' => $date));

    $requete = $connect->prepare("INSERT INTO transactions VALUES(:id,:username,:type,:amount,:date)");
    $requete->execute(array(':id'=>"",':username'=>$guest_user,':type'=>"REWARD",':amount'=>3,':date'=>$date));
    header('location:guest.php') ;
}

?>