PageRenderTime 69ms CodeModel.GetById 30ms RepoModel.GetById 1ms app.codeStats 0ms

/content/ajax/_stats_load.php

https://gitlab.com/Etern4l/BitcoinDice
PHP | 238 lines | 207 code | 25 blank | 6 comment | 32 complexity | f5f3ec3db29d4f32267392c77acd0741 MD5 | raw file
    

  1. <?php

    2. 

  2. /*

    3. 

  3.  *  © BitcoinDice 

    4. 

  4. 

    5. 

  5. 

    6. 

  6.  

    7. 

  7. */

    8. 

  8. 

    9. 

  9. 

    10. 

  10. header('X-Frame-Options: DENY'); 

    11. 

  11. 

    12. 

  12. if (empty($_GET['con'])) exit();

    13. 

  13. 

    14. 

  14. $included=true;

    15. 

  15. include '../../inc/db-conf.php';

    16. 

  16. include '../../inc/functions.php';

    17. 

  17. 

    18. 

  18. $settings=mysql_fetch_array(mysql_query("SELECT * FROM `system` LIMIT 1"));

    19. 

  19. 

    20. 

  20. $content='';

    21. 

  21. 

    22. 

  22. switch ($_GET['con']) {

    23. 

  23.   case 'my_bets':

    24. 

  24.     if (empty($_GET['_unique']) || mysql_num_rows(mysql_query("SELECT `id` FROM `players` WHERE `hash`='".prot($_GET['_unique'])."' LIMIT 1"))==0) exit();

    25. 

  25.     $player=mysql_fetch_array(mysql_query("SELECT * FROM `players` WHERE `hash`='".prot($_GET['_unique'])."' LIMIT 1"));

    26. 

  26.     

    27. 

  27.     $my_bets=mysql_query("SELECT * FROM `bets` WHERE `player`=$player[id] ORDER BY `time` DESC LIMIT 30");

    28. 

  28.     if (mysql_num_rows($my_bets)==0) $content.='<br><br><br><i>You haven\'t bet yet.</i>';

    29. 

  29.     else {

    30. 

  30.       $content.='<table id="bets_st_table">';

    31. 

  31.       $content.='<tr>';

    32. 

  32.       $content.='<th>BET ID</th>';

    33. 

  33.       $content.='<th>PLAYER</th>';

    34. 

  34.       $content.='<th>TIME</th>';

    35. 

  35.       $content.='<th>BET</th>';

    36. 

  36.       $content.='<th>MULTIPLIER</th>';

    37. 

  37.       $content.='<th>TARGET</th>';

    38. 

  38.       $content.='<th>ROLL</th>';

    39. 

  39.       $content.='<th>PROFIT</th>';

    40. 

  40.       $content.='</tr>';

    41. 

  41.       $suda=0;

    42. 

  42.       while ($my_bet=mysql_fetch_array($my_bets)) {

    43. 

  43.         $content.=($suda==0)?'<tr>':'<tr class="suda">';

    44. 

  44.         

    45. 

  45.         $username=mysql_fetch_array(mysql_query("SELECT `alias` FROM `players` WHERE `id`=$my_bet[player] LIMIT 1"));

    46. 

  46.         

    47. 

  47.         $chance['under']=floor((1/($my_bet['multiplier']/100)*((100-$settings['house_edge'])/100))*100)/100;

    48. 

  48.         $chance['over']=100-$chance['under'];

    49. 

  49. 

    50. 

  50.         $target=($my_bet['under_over']==0)?'<'.sprintf("%.2f",$chance['under']):'>'.sprintf("%.2f",$chance['over']);

    51. 

  51.         $profit=-$my_bet['bet_amount'];

    52. 

  52.         $profit_class='lose';

    53. 

  53.         $plusko=($my_bet['bet_amount']==0)?'-':'';

    54. 

  54.         if ($my_bet['win_lose']==1) {

    55. 

  55.           $profit+=$my_bet['bet_amount']*$my_bet['multiplier'];

    56. 

  56.           $profit_class='win';

    57. 

  57.           $plusko='+';

    58. 

  58.         }

    59. 

  59. 

    60. 

  60.         $content.='<td class="betId first">'.$my_bet['id'].'</td>';

    61. 

  61.         $content.='<td>'.$username['alias'].'</td>';

    62. 

  62.         $content.='<td>'.date('H:i:s',strtotime($my_bet['time'])).'</td>';

    63. 

  63.         $content.='<td>'.sprintf("%.8f",$my_bet['bet_amount']).'</td>';

    64. 

  64.         $content.='<td>'.sprintf("%.2f",$my_bet['multiplier']).'</td>';

    65. 

  65.         $content.='<td>'.$target.'</td>';

    66. 

  66.         $content.='<td>'.sprintf("%.2f",$my_bet['result']).'</td>';

    67. 

  67.         $content.='<td class="'.$profit_class.' right last">'.$plusko.sprintf("%.8f",floor($profit*100000000)/100000000).'</td>';

    68. 

  68.         $content.='</tr>';

    69. 

  69.         $suda=($suda==0)?1:0;

    70. 

  70.       }

    71. 

  71.       $content.='</table>';

    72. 

  72.     }

    73. 

  73.   break;

    74. 

  74.   case 'all_bets':

    75. 

  75.     $all_bets=mysql_query("SELECT * FROM `bets` WHERE `bet_amount`!=0 ORDER BY `time` DESC LIMIT 30");

    76. 

  76.     if (mysql_num_rows($all_bets)==0) $content.='<br><br><br><i>No one has bet yet.</i>';

    77. 

  77.     else {

    78. 

  78.       $content.='<table id="bets_st_table">';

    79. 

  79.       $content.='<tr>';

    80. 

  80.       $content.='<th>BET ID</th>';

    81. 

  81.       $content.='<th>PLAYER</th>';

    82. 

  82.       $content.='<th>TIME</th>';

    83. 

  83.       $content.='<th>BET</th>';

    84. 

  84.       $content.='<th>MULTIPLIER</th>';

    85. 

  85.       $content.='<th>TARGET</th>';

    86. 

  86.       $content.='<th>ROLL</th>';

    87. 

  87.       $content.='<th>PROFIT</th>';

    88. 

  88.       $content.='</tr>';

    89. 

  89.       $suda=0;

    90. 

  90.       while ($all_bet=mysql_fetch_array($all_bets)) {

    91. 

  91.         $content.=($suda==0)?'<tr>':'<tr class="suda">';

    92. 

  92.         

    93. 

  93.         if (mysql_num_rows(mysql_query("SELECT `id` FROM `players` WHERE `id`=$all_bet[player] LIMIT 1"))!=0)

    94. 

  94.           $username=mysql_fetch_array(mysql_query("SELECT `alias` FROM `players` WHERE `id`=$all_bet[player] LIMIT 1"));

    95. 

  95.         else $username['alias']='[unknown]';

    96. 

  96.         

    97. 

  97.         $chance['under']=floor((1/($all_bet['multiplier']/100)*((100-$settings['house_edge'])/100))*100)/100;

    98. 

  98.         $chance['over']=100-$chance['under'];

    99. 

  99. 

    100. 

  100.         $target=($all_bet['under_over']==0)?'<'.sprintf("%.2f",$chance['under']):'>'.sprintf("%.2f",$chance['over']);

    101. 

  101.         $profit=-$all_bet['bet_amount'];

    102. 

  102.         $profit_class='lose';

    103. 

  103.         $plusko=($all_bet['bet_amount']==0)?'-':'';

    104. 

  104.         if ($all_bet['win_lose']==1) {

    105. 

  105.           $profit+=$all_bet['bet_amount']*$all_bet['multiplier'];

    106. 

  106.           $profit_class='win';

    107. 

  107.           $plusko='+';

    108. 

  108.         }

    109. 

  109. 

    110. 

  110.         $content.='<td class="betId first">'.$all_bet['id'].'</td>';

    111. 

  111.         $content.='<td>'.$username['alias'].'</td>';

    112. 

  112.         $content.='<td>'.date('H:i:s',strtotime($all_bet['time'])).'</td>';

    113. 

  113.         $content.='<td>'.sprintf("%.8f",$all_bet['bet_amount']).'</td>';

    114. 

  114.         $content.='<td>'.sprintf("%.2f",$all_bet['multiplier']).'</td>';

    115. 

  115.         $content.='<td>'.$target.'</td>';

    116. 

  116.         $content.='<td>'.sprintf("%.2f",$all_bet['result']).'</td>';

    117. 

  117.         $content.='<td class="'.$profit_class.' right last">'.$plusko.sprintf("%.8f",floor($profit*100000000)/100000000).'</td>';

    118. 

  118.         $content.='</tr>';

    119. 

  119.         $suda=($suda==0)?1:0;

    120. 

  120.       }

    121. 

  121.       $content.='</table>';

    122. 

  122.     }

    123. 

  123.   break;

    124. 

  124.   case 'news':

    125. 

  125.     $content.='<br><br><br>';

    126. 

  126.     $query=mysql_query("SELECT * FROM `news` ORDER BY `time` DESC");

    127. 

  127.     while ($row=mysql_fetch_array($query)) {

    128. 

  128.       $content.='<div class="news_single">';

    129. 

  129.       $content.=str_replace('[I]','<i>',str_replace('[/I]','</i>',str_replace('[BR]','<br>',str_replace('[/B]','</b>',str_replace('[B]','<b>',$row['content']))))).'<br><span class="news_single_time">'.$row['time'].'</span>';

    130. 

  130.       $content.='</div>';

    131. 

  131.     }

    132. 

  132.     if (mysql_num_rows($query)==0) $content.='<i>No news available.</i>';    

    133. 

  133.   break;

    134. 

  134.   case 'giveaway':

    135. 

  135.     if ($settings['giveaway']!=1) {

    136. 

  136.       $content.='<br><br><br><i>Giveaway is not supported now.</i>';

    137. 

  137.     }

    138. 

  138.     else {

    139. 

  139.       if (empty($_GET['_unique']) || mysql_num_rows(mysql_query("SELECT `id` FROM `players` WHERE `hash`='".prot($_GET['_unique'])."' LIMIT 1"))==0) exit();

    140. 

  140.       $player=mysql_fetch_array(mysql_query("SELECT * FROM `players` WHERE `hash`='".prot($_GET['_unique'])."' LIMIT 1"));

    141. 

  141.       if ($player['balance']!=0) {

    142. 

  142.         $content.='<br><br><br>Sorry, your balance must be <b>0</b> to claim the '.$settings['currency'].' bonus.';

    143. 

  143.       }

    144. 

  144.       else {

    145. 

  145.         $content.='<br><br><br>You can claim the '.$settings['currency'].' bonus now:<br><br>';

    146. 

  146.         $content.='<big><big><b>'.$settings['giveaway_amount'].'</b> '.$settings['currency_sign'].'</big></big><br><br>';

    147. 

  147.         $content.='<table><tr><td valign="top" style="padding: 4px 0;">Enter text from image:</td><td valign="top"><input type="text" id="captchatext" maxlength="4" style="width: 140px; padding: 4px; text-transform: uppercase;"><br><img src="./content/captcha/genImage.php" style="position: relative; top: 4px;"></img></td><td valign="top"><button onclick="javascript:claim($(\'#captchatext\').val());return false;" style="padding: 4px;">Claim</button></td></tr></table>';

    148. 

  148.       }

    149. 

  149.     }

    150. 

  150.   break;

    151. 

  151.   case 'stats':

    152. 

  152.     if (empty($_GET['_unique']) || mysql_num_rows(mysql_query("SELECT `id` FROM `players` WHERE `hash`='".prot($_GET['_unique'])."' LIMIT 1"))==0) exit();

    153. 

  153.     $player=mysql_fetch_array(mysql_query("SELECT * FROM `players` WHERE `hash`='".prot($_GET['_unique'])."' LIMIT 1"));

    154. 

  154. 

    155. 

  155.     $content.='<br><br><br>';

    156. 

  156.     $content.='<div class="stats_">';

    157. 

  157. 

    158. 

  158.     $content.='<table width="100%">';

    159. 

  159.     $content.='<tr><th>Your Stats</th><th class="center"><img src="./content/images/diceStats.png"></th><th>Global Stats</th></tr>';

    160. 

  160.     $content.='<tr><td>'.$player['t_bets'].'</td><td class="center">NUMBER OF BETS</td><td>'.$settings['t_bets'].'</td></tr>';    

    161. 

  161.     $content.='<tr><td>'.$player['t_wagered'].'</td><td class="center">TOTAL WAGERED</td><td>'.$settings['t_wagered'].'</td></tr>';    

    162. 

  162.     $content.='<tr><td>'.$player['t_profit'].'</td><td class="center">TOTAL PROFIT</td><td>'.$settings['t_player_profit'].'</td></tr>';    

    163. 

  163.     $content.='<tr class="wins"><td>'.$player['t_wins'].'</td><td class="center">WINS</td><td>'.$settings['t_wins'].'</td></tr>';    

    164. 

  164.     $content.='<tr class="losses"><td>'.($player['t_bets']-$player['t_wins']).'</td><td class="center">LOSSES</td><td>'.($settings['t_bets']-$settings['t_wins']).'</td></tr>';    

    165. 

  165.     $content.='<tr class="wl"><td>'.sprintf("%.3f",$player['t_wins']/($player['t_bets']-$player['t_wins'])).'</td><td class="center">W/L RATIO</td><td>'.sprintf("%.3f",$settings['t_wins']/($settings['t_bets']-$settings['t_wins'])).'</td></tr>';    

    166. 

  166.     $content.='</table>';

    167. 

  167.     

    168. 

  168.     $content.='</div>';

    169. 

  169.   break;

    170. 

  170.   case 'chat':

    171. 

  171.     if ($settings['chat_enable']!=1) {

    172. 

  172.       $content.='<br><br><br><i>Chat is not supported now.</i>';

    173. 

  173.     }

    174. 

  174.     else {

    175. 

  175.       $content.='<br><br><br><input type="text" id="composeTxt"><button onclick="javascript:compose($(\'#composeTxt\').val());return false;" id="composeBtn">Send</button>';

    176. 

  176.       $content.='<div id="chatWindow"></div>';

    177. 

  177.       $content.='<script type="text/javascript">';

    178. 

  178.       $content.='initializeRefreshingFrameChat();';

    179. 

  179.       $content.='$("#composeTxt").keypress(function(e) { if (e.which==13) compose($("#composeTxt").val()); });';

    180. 

  180.       $content.='$("#composeTxt").qtip({content:{text:\'Press enter to send\'},style:{classes:\'qtip-bootstrap qtip-shadow\'},position:{my:\'bottom left\',at:\'top left\'}});';

    181. 

  181.       $content.='</script>';

    182. 

  182.     }

    183. 

  183.   break;

    184. 

  184.   case 'high_rollers':

    185. 

  185.     $all_bets=mysql_query("SELECT *,(`bet_amount`*`multiplier`) AS `profit_on_win` FROM `bets` WHERE `bet_amount`!=0 AND `win_lose`=1 ORDER BY `profit_on_win` DESC LIMIT 30");

    186. 

  186.     if (mysql_num_rows($all_bets)==0) $content.='<br><br><br><i>No one has bet yet.</i>';

    187. 

  187.     else {

    188. 

  188.       $content.='<table id="bets_st_table">';

    189. 

  189.       $content.='<tr>';

    190. 

  190.       $content.='<th>BET ID</th>';

    191. 

  191.       $content.='<th>PLAYER</th>';

    192. 

  192.       $content.='<th>TIME</th>';

    193. 

  193.       $content.='<th>BET</th>';

    194. 

  194.       $content.='<th>MULTIPLIER</th>';

    195. 

  195.       $content.='<th>TARGET</th>';

    196. 

  196.       $content.='<th>ROLL</th>';

    197. 

  197.       $content.='<th>PROFIT</th>';

    198. 

  198.       $content.='</tr>';

    199. 

  199.       $suda=0;

    200. 

  200.       while ($all_bet=mysql_fetch_array($all_bets)) {

    201. 

  201.         $content.=($suda==0)?'<tr>':'<tr class="suda">';

    202. 

  202.         

    203. 

  203.         if (mysql_num_rows(mysql_query("SELECT `id` FROM `players` WHERE `id`=$all_bet[player] LIMIT 1"))!=0)

    204. 

  204.           $username=mysql_fetch_array(mysql_query("SELECT `alias` FROM `players` WHERE `id`=$all_bet[player] LIMIT 1"));

    205. 

  205.         else $username['alias']='[unknown]';

    206. 

  206. 

    207. 

  207.         $chance['under']=floor((1/($all_bet['multiplier']/100)*((100-$settings['house_edge'])/100))*100)/100;

    208. 

  208.         $chance['over']=100-$chance['under'];

    209. 

  209. 

    210. 

  210.         $target=($all_bet['under_over']==0)?'<'.sprintf("%.2f",$chance['under']):'>'.sprintf("%.2f",$chance['over']);

    211. 

  211.         $profit=-$all_bet['bet_amount'];

    212. 

  212.         $profit_class='lose';

    213. 

  213.         $plusko=($all_bet['bet_amount']==0)?'-':'';

    214. 

  214.         if ($all_bet['win_lose']==1) {

    215. 

  215.           $profit+=$all_bet['bet_amount']*$all_bet['multiplier'];

    216. 

  216.           $profit_class='win';

    217. 

  217.           $plusko='+';

    218. 

  218.         }

    219. 

  219. 

    220. 

  220.         $content.='<td class="betId first">'.$all_bet['id'].'</td>';

    221. 

  221.         $content.='<td>'.$username['alias'].'</td>';

    222. 

  222.         $content.='<td>'.date('H:i:s',strtotime($all_bet['time'])).'</td>';

    223. 

  223.         $content.='<td>'.sprintf("%.8f",$all_bet['bet_amount']).'</td>';

    224. 

  224.         $content.='<td>'.sprintf("%.2f",$all_bet['multiplier']).'</td>';

    225. 

  225.         $content.='<td>'.$target.'</td>';

    226. 

  226.         $content.='<td>'.sprintf("%.2f",$all_bet['result']).'</td>';

    227. 

  227.         $content.='<td class="'.$profit_class.' right last">'.$plusko.sprintf("%.8f",floor($profit*100000000)/100000000).'</td>';

    228. 

  228.         $content.='</tr>';

    229. 

  229.         $suda=($suda==0)?1:0;

    230. 

  230.       }

    231. 

  231.       $content.='</table>';

    232. 

  232.     }

    233. 

  233.   break;

    234. 

  234. }

    235. 

  235. 

    236. 

  236. 

    237. 

  237. echo json_encode(array('content'=>$content));

    238. 

  238. ?>
    239.