Who is coming?

GNH16  DEAL  REGO  WHO IS COMING  STATUS  ACCOMMODATION  DIRECTIONS  PRE-/POST-LUBES  FAQ


[insert_php]
$timestamp = time();
$timestamp_regopen = mktime(18,00,00,8,14,2015);

if ($timestamp_regopen>$timestamp){

echo ‘

Nothing to see here at the moment!

Registration will open very soon, exactly on
August 15th, 2015 at 00:00 (Kuala Lumpur local time)!
(means: August 14th, 2015 – at 18:00 MESZ/CEST)
‘;
}
else {

$host_name = “db586837430.db.1and1.com”;
$database = “db586837430”;
$user_name = “dbo586837430”;
$password = “Yaq1!xsw”;

$db = mysqli_connect($host_name, $user_name, $password, $database);
if (mysqli_connect_errno())
{
echo “Verbindung zum MySQL Server fehlgeschlagen: ” . mysqli_connect_error();
}

$sql_NrOfReg = ‘SELECT COUNT(*) as NrOfReg FROM rego_liste’;
$db_erg_NrOfReg = mysqli_query( $db, $sql_NrOfReg );

while($row = mysqli_fetch_object($db_erg_NrOfReg)) {
$NrOfReg = $row->NrOfReg;
}

echo ‘
‘.$NrOfReg.’ registrations so far. Interested in Statistics?
‘;

$sql_liste = ‘SELECT * FROM rego_liste where paid<>“ZZ” order by id desc’;
$db_erg_liste = mysqli_query( $db, $sql_liste );

echo ‘

‘;

while($row = mysqli_fetch_object($db_erg_liste))
{
$real_id = $row->ID;
$hashname = $row->hashname;
$kennel = $row->kennel;
$paid = $row->paid;
$regotime=$row->regotime;
$todaytime=time();
$days=Floor(($todaytime-$regotime)/60/60/24);
if ($paid==”YES”){$paid=”confirmed”;}
else {$paid=””;}
if ($kennel==”NA”){$kennel=”-“;}

echo ‘

‘;

}
echo ‘

RegoID Hashname Kennel Payment?
‘.$real_id.’ ‘.$hashname.’ ‘.$kennel.’ ‘.$paid.’

‘;

}

[/insert_php]