/admin/pages/home.php

https://gitlab.com/Etern4l/BitcoinDice · PHP · 84 lines · 77 code · 1 blank · 6 comment · 1 complexity · f7debccaeb548e611e4fa88e77544cea MD5 · raw file 

    

  1. <?php

    2. 

  2. /*

    3. 

  3.  *  © BitcoinDice 

    4. 

  4. 

    5. 

  5. 

    6. 

  6.  

    7. 

  7. */

    8. 

  8. 

    9. 

  9. if (!isset($included)) exit();

    10. 

  10. ?>

    11. 

  11. <h1>Stats</h1>

    12. 

  12. <table class="vypis_table">

    13. 

  13.   <tr class="vypis_table_obsah">

    14. 

  14.     <td>Number of bets:</td>

    15. 

  15.     <td><b><?php echo $settings['t_bets']; ?></b></td>

    16. 

  16.   </tr>

    17. 

  17.   <tr class="vypis_table_obsah">

    18. 

  18.     <td>Total wagered:</td>

    19. 

  19.     <td><b><?php echo sprintf("%.8f",$settings['t_wagered']); ?></b> <?php echo $settings['currency_sign']; ?></td>

    20. 

  20.   </tr>

    21. 

  21.   <tr class="vypis_table_obsah">

    22. 

  22.     <td>Total profit:</td>

    23. 

  23.     <td><b><?php $settings['t_player_profit']=(0-$settings['t_player_profit']); echo ($settings['t_player_profit']>=0)?'<span style="color: green;">+'.sprintf("%.8f",$settings['t_player_profit']).'</span>':'<span style="color: #d10000;">'.sprintf("%.8f",$settings['t_player_profit']).'</span>'; ?></b> <?php echo $settings['currency_sign']; ?></td>

    24. 

  24.   </tr>

    25. 

  25.   <tr class="vypis_table_obsah">

    26. 

  26.     <td>Real house edge:</td>

    27. 

  27.     <td><b><?php $this_q=mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN (0-((`bet_amount`*`multiplier`)-`bet_amount`)) ELSE `bet_amount` END) AS `total_profit`,SUM(`bet_amount`) AS `total_wager` FROM `bets`"); $h_e_=mysql_fetch_array($this_q); $h_e_['h_e']=($h_e_['total_wager']!=0)?(($h_e_['total_profit']/$h_e_['total_wager'])*100):0; echo ($h_e_['h_e']>=0)?'<span style="color: green;">+'.sprintf("%.5f",$h_e_['h_e']).'%</span>':'<span style="color: #d10000;">'.sprintf("%.5f",$h_e_['h_e']).'%</span>'; ?></b></td>

    28. 

  28.   </tr>

    29. 

  29.   <tr class="vypis_table_obsah">

    30. 

  30.     <td style="color: green;">Wins:</td>

    31. 

  31.     <td style="color: green;"><b><?php echo $settings['t_wins']; ?></b></td>

    32. 

  32.   </tr>

    33. 

  33.   <tr class="vypis_table_obsah">

    34. 

  34.     <td style="color: #d10000;">Losses:</td>

    35. 

  35.     <td style="color: #d10000;"><b><?php echo ($settings['t_bets']-$settings['t_wins']); ?></b></td>

    36. 

  36.   </tr>

    37. 

  37.   <tr class="vypis_table_obsah">

    38. 

  38.     <td style="color: #a06d00;">W/L ratio:</td>

    39. 

  39.     <td style="color: #a06d00;"><b><?php echo sprintf("%.3f",$settings['t_wins']/($settings['t_bets']-$settings['t_wins'])); ?></b></td>

    40. 

  40.   </tr>

    41. 

  41. </table>

    42. 

  42. <br><br>

    43. 

  43. <table class="vypis_table">

    44. 

  44.   <tr class="vypis_table_head">

    45. 

  45.     <th>Period</th>

    46. 

  46.     <th>Real house edge</th>

    47. 

  47.     <th>Profit</th>

    48. 

  48.   </tr>

    49. 

  49.   <tr>

    50. 

  50.     <td>Last hour</td>

    51. 

  51.     <td><?php $this_q=mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN (0-((`bet_amount`*`multiplier`)-`bet_amount`)) ELSE `bet_amount` END) AS `total_profit`,SUM(`bet_amount`) AS `total_wager` FROM `bets` WHERE `time`>NOW()-INTERVAL 1 HOUR"); $h_e_=mysql_fetch_array($this_q); $h_e_['h_e']=($h_e_['total_wager']!=0)?(($h_e_['total_profit']/$h_e_['total_wager'])*100):0; echo ($h_e_['h_e']>=0)?'<span style="color: green;">+'.sprintf("%.5f",$h_e_['h_e']).'%</span>':'<span style="color: #d10000;">'.sprintf("%.5f",$h_e_['h_e']).'%</span>'; ?></td>

    52. 

  52.     <td><?php $profit_=mysql_fetch_array(mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN ((`bet_amount`*`multiplier`)-`bet_amount`) ELSE (0-`bet_amount`) END) AS `profit` FROM `bets` WHERE `time`>NOW()-INTERVAL 1 HOUR")); echo ((0-$profit_['profit'])>=0)?'<span style="color: green;">+'.sprintf("%.8f",0-$profit_['profit']).'</span>':'<span style="color: #d10000;">'.sprintf("%.8f",0-$profit_['profit']).'</span>'; ?></td>

    53. 

  53.   </tr>

    54. 

  54.   <tr>

    55. 

  55.     <td>Last 24h</td>

    56. 

  56.     <td><?php $this_q=mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN (0-((`bet_amount`*`multiplier`)-`bet_amount`)) ELSE `bet_amount` END) AS `total_profit`,SUM(`bet_amount`) AS `total_wager` FROM `bets` WHERE `time`>NOW()-INTERVAL 24 HOUR"); $h_e_=mysql_fetch_array($this_q); $h_e_['h_e']=($h_e_['total_wager']!=0)?(($h_e_['total_profit']/$h_e_['total_wager'])*100):0; echo ($h_e_['h_e']>=0)?'<span style="color: green;">+'.sprintf("%.5f",$h_e_['h_e']).'%</span>':'<span style="color: #d10000;">'.sprintf("%.5f",$h_e_['h_e']).'%</span>'; ?></td>

    57. 

  57.     <td><?php $profit_=mysql_fetch_array(mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN ((`bet_amount`*`multiplier`)-`bet_amount`) ELSE (0-`bet_amount`) END) AS `profit` FROM `bets` WHERE `time`>NOW()-INTERVAL 24 HOUR")); echo ((0-$profit_['profit'])>=0)?'<span style="color: green;">+'.sprintf("%.8f",0-$profit_['profit']).'</span>':'<span style="color: #d10000;">'.sprintf("%.8f",0-$profit_['profit']).'</span>'; ?></td>

    58. 

  58.   </tr>

    59. 

  59.   <tr>

    60. 

  60.     <td>Last 7d</td>

    61. 

  61.     <td><?php $this_q=mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN (0-((`bet_amount`*`multiplier`)-`bet_amount`)) ELSE `bet_amount` END) AS `total_profit`,SUM(`bet_amount`) AS `total_wager` FROM `bets` WHERE `time`>NOW()-INTERVAL 7 DAY"); $h_e_=mysql_fetch_array($this_q); $h_e_['h_e']=($h_e_['total_wager']!=0)?(($h_e_['total_profit']/$h_e_['total_wager'])*100):0; echo ($h_e_['h_e']>=0)?'<span style="color: green;">+'.sprintf("%.5f",$h_e_['h_e']).'%</span>':'<span style="color: #d10000;">'.sprintf("%.5f",$h_e_['h_e']).'%</span>'; ?></td>

    62. 

  62.     <td><?php $profit_=mysql_fetch_array(mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN ((`bet_amount`*`multiplier`)-`bet_amount`) ELSE (0-`bet_amount`) END) AS `profit` FROM `bets` WHERE `time`>NOW()-INTERVAL 7 DAY")); echo ((0-$profit_['profit'])>=0)?'<span style="color: green;">+'.sprintf("%.8f",0-$profit_['profit']).'</span>':'<span style="color: #d10000;">'.sprintf("%.8f",0-$profit_['profit']).'</span>'; ?></td>

    63. 

  63.   </tr>

    64. 

  64.   <tr>

    65. 

  65.     <td>Last 30d</td>

    66. 

  66.     <td><?php $this_q=mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN (0-((`bet_amount`*`multiplier`)-`bet_amount`)) ELSE `bet_amount` END) AS `total_profit`,SUM(`bet_amount`) AS `total_wager` FROM `bets` WHERE `time`>NOW()-INTERVAL 30 DAY"); $h_e_=mysql_fetch_array($this_q); $h_e_['h_e']=($h_e_['total_wager']!=0)?(($h_e_['total_profit']/$h_e_['total_wager'])*100):0; echo ($h_e_['h_e']>=0)?'<span style="color: green;">+'.sprintf("%.5f",$h_e_['h_e']).'%</span>':'<span style="color: #d10000;">'.sprintf("%.5f",$h_e_['h_e']).'%</span>'; ?></td>

    67. 

  67.     <td><?php $profit_=mysql_fetch_array(mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN ((`bet_amount`*`multiplier`)-`bet_amount`) ELSE (0-`bet_amount`) END) AS `profit` FROM `bets` WHERE `time`>NOW()-INTERVAL 30 DAY")); echo ((0-$profit_['profit'])>=0)?'<span style="color: green;">+'.sprintf("%.8f",0-$profit_['profit']).'</span>':'<span style="color: #d10000;">'.sprintf("%.8f",0-$profit_['profit']).'</span>'; ?></td>

    68. 

  68.   </tr>

    69. 

  69.   <tr>

    70. 

  70.     <td>Last 6m</td>

    71. 

  71.     <td><?php $this_q=mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN (0-((`bet_amount`*`multiplier`)-`bet_amount`)) ELSE `bet_amount` END) AS `total_profit`,SUM(`bet_amount`) AS `total_wager` FROM `bets` WHERE `time`>NOW()-INTERVAL 6 MONTH"); $h_e_=mysql_fetch_array($this_q); $h_e_['h_e']=($h_e_['total_wager']!=0)?(($h_e_['total_profit']/$h_e_['total_wager'])*100):0; echo ($h_e_['h_e']>=0)?'<span style="color: green;">+'.sprintf("%.5f",$h_e_['h_e']).'%</span>':'<span style="color: #d10000;">'.sprintf("%.5f",$h_e_['h_e']).'%</span>'; ?></td>

    72. 

  72.     <td><?php $profit_=mysql_fetch_array(mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN ((`bet_amount`*`multiplier`)-`bet_amount`) ELSE (0-`bet_amount`) END) AS `profit` FROM `bets` WHERE `time`>NOW()-INTERVAL 6 MONTH")); echo ((0-$profit_['profit'])>=0)?'<span style="color: green;">+'.sprintf("%.8f",0-$profit_['profit']).'</span>':'<span style="color: #d10000;">'.sprintf("%.8f",0-$profit_['profit']).'</span>'; ?></td>

    73. 

  73.   </tr>

    74. 

  74.   <tr>

    75. 

  75.     <td>Last 12m</td>

    76. 

  76.     <td><?php $this_q=mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN (0-((`bet_amount`*`multiplier`)-`bet_amount`)) ELSE `bet_amount` END) AS `total_profit`,SUM(`bet_amount`) AS `total_wager` FROM `bets` WHERE `time`>NOW()-INTERVAL 12 MONTH"); $h_e_=mysql_fetch_array($this_q); $h_e_['h_e']=($h_e_['total_wager']!=0)?(($h_e_['total_profit']/$h_e_['total_wager'])*100):0; echo ($h_e_['h_e']>=0)?'<span style="color: green;">+'.sprintf("%.5f",$h_e_['h_e']).'%</span>':'<span style="color: #d10000;">'.sprintf("%.5f",$h_e_['h_e']).'%</span>'; ?></td>

    77. 

  77.     <td><?php $profit_=mysql_fetch_array(mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN ((`bet_amount`*`multiplier`)-`bet_amount`) ELSE (0-`bet_amount`) END) AS `profit` FROM `bets` WHERE `time`>NOW()-INTERVAL 12 MONTH")); echo ((0-$profit_['profit'])>=0)?'<span style="color: green;">+'.sprintf("%.8f",0-$profit_['profit']).'</span>':'<span style="color: #d10000;">'.sprintf("%.8f",0-$profit_['profit']).'</span>'; ?></td>

    78. 

  78.   </tr>

    79. 

  79.   <tr>

    80. 

  80.     <td>Since start</td>

    81. 

  81.     <td><?php $this_q=mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN (0-((`bet_amount`*`multiplier`)-`bet_amount`)) ELSE `bet_amount` END) AS `total_profit`,SUM(`bet_amount`) AS `total_wager` FROM `bets`"); $h_e_=mysql_fetch_array($this_q); $h_e_['h_e']=($h_e_['total_wager']!=0)?(($h_e_['total_profit']/$h_e_['total_wager'])*100):0; echo ($h_e_['h_e']>=0)?'<span style="color: green;">+'.sprintf("%.5f",$h_e_['h_e']).'%</span>':'<span style="color: #d10000;">'.sprintf("%.5f",$h_e_['h_e']).'%</span>'; ?></td>

    82. 

  82.     <td><?php $profit_=mysql_fetch_array(mysql_query("SELECT SUM(CASE WHEN `win_lose`=1 THEN ((`bet_amount`*`multiplier`)-`bet_amount`) ELSE (0-`bet_amount`) END) AS `profit` FROM `bets`")); echo ((0-$profit_['profit'])>=0)?'<span style="color: green;">+'.sprintf("%.8f",0-$profit_['profit']).'</span>':'<span style="color: #d10000;">'.sprintf("%.8f",0-$profit_['profit']).'</span>'; ?></td>

    83. 

  83.   </tr>

    84. 

  84. </table>
    85.