$t_wager = mysql_fetch_array(mysql_query("SELECT SUM(`t_wagered`) AS `t` FROM `players`"));
$wins['global'] = mysql_num_rows(mysql_query("SELECT `id` FROM `games` WHERE `ended`=1 AND `winner`='player'"));
$wins['player'] = mysql_num_rows(mysql_query("SELECT `id` FROM `games` WHERE `ended`=1 AND `winner`='player' AND `player`={$player['id']}"));
$ties['global'] = mysql_num_rows(mysql_query("SELECT `id` FROM `games` WHERE `ended`=1 AND `winner`='tie'"));
$ties['player'] = mysql_num_rows(mysql_query("SELECT `id` FROM `games` WHERE `ended`=1 AND `winner`='tie' AND `player`={$player['id']}"));
$losses['global'] = mysql_num_rows(mysql_query("SELECT `id` FROM `games` WHERE `ended`=1 AND `winner`='dealer'"));
$losses['player'] = mysql_num_rows(mysql_query("SELECT `id` FROM `games` WHERE `ended`=1 AND `winner`='dealer' AND `player`={$player['id']}"));
$return .= '<tr>';
$return .= '<td class="stats-val">' . mysql_num_rows(mysql_query("SELECT `id` FROM `games` WHERE `ended`=1 AND `player`={$player['id']}")) . '</td>';
$return .= '<td>NUMBER OF BETS</td>';
$return .= '<td class="stats-val">' . mysql_num_rows(mysql_query("SELECT `id` FROM `games` WHERE `ended`=1")) . '</td>';
$return .= '</tr>';
$return .= '<tr>';
$return .= '<td class="stats-val">' . n_num($player['t_wagered']) . '</td>';
$return .= '<td>TOTAL WAGERED</td>';
$return .= '<td class="stats-val">' . n_num($t_wager['t']) . '</td>';
$return .= '</tr>';
$return .= '<tr>';
$return .= '<td class="stats-val" style="color: #78D16B;">' . $wins['player'] . '</td>';
$return .= '<td style="color: #78D16B;">WINS</td>';
$return .= '<td class="stats-val" style="color: #78D16B;">' . $wins['global'] . '</td>';
$return .= '</tr>';
$return .= '<tr>';
$return .= '<td class="stats-val">' . $ties['player'] . '</td>';
$return .= '<td>TIES</td>';
$return .= '<td class="stats-val">' . $ties['global'] . '</td>';
$return .= '</tr>';
$return .= '<tr>';
$return .= '<td class="stats-val" style="color: #EE7171;">' . $losses['player'] . '</td>';
$return .= '<td style="color: #EE7171;">LOSSES</td>';
$return .= '<td class="stats-val" style="color: #EE7171;">' . $losses['global'] . '</td>';
<table class="vypis_table">
<tr class="vypis_table_head">
<th>Time</th>
<th>Player</th>
<th>Amount</th>
<th>Transaction ID</th>
</tr>
<?php
while ($tx = mysql_fetch_array($query_)) {
if (mysql_num_rows(mysql_query("SELECT `alias` FROM `players` WHERE `id`={$tx['player_id']} LIMIT 1")) != 0) {
$player = mysql_fetch_array(mysql_query("SELECT `alias` FROM `players` WHERE `id`={$tx['player_id']} LIMIT 1"));
} else {
$player['alias'] = '[unknown]';
}
$amount = n_num($tx['amount'], true);
if ($amount > 0) {
$am_class = 'win';
$amount = '+' . $amount;
} else {
$am_class = 'lose';
}
echo '<tr class="vypis_table_obsah">';
echo '<td><small><small>' . str_replace(' ', '<br>', $tx['time']) . '</small></small></td>';
echo '<td><small>' . $player['alias'] . '</small></td>';
echo '<td class="' . $am_class . '"><small>' . $amount . '</small></td>';
echo '<td><small><small>' . $tx['txid'] . '</small></small></td>';
echo '</tr>';
}
?>
</table>
$gameID = mysql_insert_id();
$dealerSums = getSums($dealer_deck);
$playerSums = getSums($player_deck);
$data['winner'] = '-';
if (in_array(21, $dealerSums)) {
mysql_query("UPDATE `games` SET `ended`=1,`winner`='dealer' WHERE `id`={$gameID} LIMIT 1");
$accessable = 0;
$winner = 'dealer';
$data['winner'] = 'dealer';
playerWon($player['id'], $gameID, $wager, 'lose', true, serialize($final_shuffle));
} else {
if (in_array(21, $playerSums)) {
mysql_query("UPDATE `games` SET `ended`=1,`winner`='player' WHERE `id`={$gameID} LIMIT 1");
$accessable = 0;
$winner = 'player';
$data['winner'] = 'player';
playerWon($player['id'], $gameID, $wager, 'regular', true, serialize($final_shuffle));
} else {
$cards['dealer-2'][0] = '-';
$cards['dealer-2'][1] = '-';
$winner = '-';
$dealerSums = '-';
}
}
if ($dealerSums != '-') {
$dealerSums = implode(',', $dealerSums);
}
$playerSums = implode(',', $playerSums);
echo json_encode(array('error' => 'no', 'content' => $cards, 'sums' => array('dealer' => $dealerSums, 'player' => $playerSums), 'wager' => n_num($wager, true), 'accessable' => $accessable, 'winner' => $winner, 'data' => $data));
mysql_query("UPDATE `system` SET `t_bets`=`t_bets`+1,`t_wagered`=ROUND((`t_wagered`+{$wager}),8),`t_player_profit`=ROUND((`t_player_profit`-" . $wager . "),8) WHERE `id`=1 LIMIT 1");
mysql_query("UPDATE `players` SET `t_bets`=`t_bets`+1,`t_wagered`=ROUND((`t_wagered`+{$wager}),8) WHERE `id`={$player['id']} LIMIT 1");
</div>
</div>
</div>
<div class="modal fade" id="modals-giveaway" aria-labelledby="mlabels-giveaway" aria-hidden="true">
<div class="modal-dialog modal-giveaway">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h4 class="modal-title" id="mlabels-giveaway">Giveaway</h4>
</div>
<div class="modal-body">
<div class="m_alert_giveaway"></div>
<div class="form-group">
<label>Giveaway Amount</label><br>
<?php
echo '<b>' . n_num($settings['giveaway_amount']) . '</b> ' . $settings['currency_sign'];
?>
</div>
<div class="form-group">
<label>Enter text from image</label><br>
<input type="text" class="form-control captchaInput" maxlength="7" id="input-captcha">
</div>
<a href="#" onclick="javascript:claim_bonus();return false;" class="btn btn-main btn-lg claimButton">CLAIM</a>
<a class="captchadiv" href="#" onclick="javascript:$(this).children().remove().clone().appendTo($(this));return false;" data-toggle="tooltip" data-placement="bottom" title="Click to refresh"><img src="./content/captcha/genImage.php"></a>
</div>
</div>
</div>
</div>
<div class="modal fade" id="modals-account" aria-labelledby="mlabels-account" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<?php
/*
* © CryptoBlackJack
*
*
*
*/
header('X-Frame-Options: DENY');
$init = true;
include '../../inc/db-conf.php';
include '../../inc/functions.php';
if (empty($_GET['_unique']) || mysql_num_rows(mysql_query("SELECT `id` FROM `players` WHERE `hash`='" . prot($_GET['_unique']) . "' LIMIT 1")) == 0) {
exit;
}
$player = mysql_fetch_array(mysql_query("SELECT `id` FROM `players` WHERE `hash`='" . prot($_GET['_unique']) . "' LIMIT 1"));
validateAccess($player['id']);
$settings = mysql_fetch_array(mysql_query("SELECT * FROM `system` WHERE `id`=1 LIMIT 1"));
$pendings = '<table class="table table-striped" style="text-align: left;">';
$pendings .= '<tr><th>Amount (' . $settings['currency_sign'] . ')</th><th>Confirmations Left</th></tr>';
$searcher = mysql_query("SELECT * FROM `deposits` WHERE `player_id`={$player['id']} AND `received`!=0");
if (mysql_num_rows($searcher) == 0) {
$pendings .= '<tr><td colspan="2"><i>No pending deposits</i></td></tr>';
}
while ($dp = mysql_fetch_array($searcher)) {
$mins_left = $settings['min_confirmations'] - $dp['confirmations'];
$amount = $dp['amount'];
$pendings .= '<tr><td><b>' . n_num($amount, true) . '</b></td><td>' . $mins_left . '</td></tr>';
}
$pendings .= '</table>';
echo json_encode(array('content' => $pendings));
<?php
/*
* © CryptoBlackJack
*
*
*
*/
header('X-Frame-Options: DENY');
$init = true;
include '../../inc/db-conf.php';
include '../../inc/functions.php';
if (empty($_GET['_unique']) || mysql_num_rows(mysql_query("SELECT `id` FROM `players` WHERE `hash`='" . prot($_GET['_unique']) . "' LIMIT 1")) == 0) {
exit;
}
$player = mysql_fetch_array(mysql_query("SELECT `balance`,`id` FROM `players` WHERE `hash`='" . prot($_GET['_unique']) . "' LIMIT 1"));
validateAccess($player['id']);
echo json_encode(array('balance' => n_num($player['balance'], true)));
