';
$userId = api_get_user_id();
// Look if the user can still try playing today
$cardGameSession = Session::read('cardgame');
if (!empty($cardGameSession)) {
// If we've already loaded the cardgame in this session, then there's
// a chance we've already played
if (isset($userId)) {
$sqlCount = "SELECT access_date FROM plugin_card_game WHERE user_id = $userId";
$resultCount = Database::query($sqlCount)->rowCount();
if ($resultCount === 0) {
// If there is no database entry for this user, insert one
// without the 'parts' field (because he has not played yet)
// @todo change date call
$sql = "INSERT INTO plugin_card_game (user_id, access_date, pan)
VALUES ($userId, DATE_ADD(CURDATE(), INTERVAL -1 DAY), 1);";
$resultInsert = Database::query($sql);
Session::write('cardgame', 'havedeck');
} else {
// If there is already one or more records in the database,
// get the number of records for today
// @todo change date call
$sqlDate = "SELECT access_date
FROM plugin_card_game
WHERE access_date = CURDATE()
AND user_id = $userId";
$resultDate = Database::query($sqlDate)->rowCount();
if ($resultDate == 0) {
// If there are records, but none for today, set the
// 'cardgame' session variable and add the
// #havedeckcardgame element to the page (it will get
// picked up by JS later on)
Session::write('cardgame', 'havedeck');
$fh .= '';
} else {
// If the user already played today, set the session
// 'cardgame' variable to 'done' and do not add
// an #havedeckcardgame element
Session::write('cardgame', 'done');
}
}
}
} else {
Session::write('cardgame', 'havedeck');
$fh .= '';
}
$parts = '1';
$pan = '1';
if (isset($userId)) {
try {
$sqlParts = "SELECT parts, pan FROM plugin_card_game WHERE user_id = $userId";
$resultParts = Database::query($sqlParts);
while ($part = Database::fetch_array($resultParts)) {
$parts = $part['parts'];
$pan = $part['pan'];
}
} catch (Exception $e) {
echo 'Exception: ', $e->getMessage(), "\n";
}
}
echo '