OSDN Git Service

[feature]統計情報の表示方法を改修
[hengband/web.git] / popularity_ranking.php
1 <?php
2 //ini_set('display_errors', 'On');
3
4 ini_set('log_errors', 'On');
5 ini_set('error_log', 'errors/'.pathinfo(__FILE__, PATHINFO_FILENAME).'.log');
6
7 ini_set('zlib.output_compression', 'On');
8
9 require_once "db_common.inc";
10
11 function print_popularity_table($stat, $id_name, $name)
12 {
13     echo <<<EOM
14 <table class="tablesorter statistics_table" id="${id_name}">
15 <thead>
16 <tr>
17 <th>$name</th>
18 EOM;
19     
20     foreach ([
21         '計', '男性', '女性', '勝利', '平均スコア', '最大スコア',
22     ] as $name) {
23         echo "<th>${name}</th>";
24     }
25     echo "</tr>\n";
26     echo "</thead>\n";
27
28     foreach ($stat as $k => $s) {
29         $name_link = "<a href='score_ranking.php?{$id_name}={$s['id']}'>{$s['name']}</a></td>";
30         $average_score = floor($s['average_score']);
31         echo <<<EOM
32 <tr>
33 <td>$name_link</td>
34 <td>{$s['total_count']}</td>
35 <td>{$s['male_count']}</td>
36 <td>{$s['female_count']}</td>
37 <td>{$s['winner_count']}</td>
38 <td>$average_score</td>
39 <td>{$s['max_score']}</td>
40 </tr>
41 EOM;
42     }
43
44     echo "</table>";
45 }
46
47
48 $db = new ScoreDB();
49
50 $time_start = microtime(true);
51
52 $statistics = $db->get_statistics_tables('total_count');
53
54 $query_time = microtime(true) - $time_start;
55 ?>
56
57 <!DOCTYPE html>
58
59 <html lang="jp">
60         <head>
61                 <meta charset="utf-8"/>
62                 <link rev=made href="mailto:hengband-dev@lists.sourceforge.jp">
63                 <link rel="stylesheet" type="text/css" href="/hengband.css">
64                 <link rel="stylesheet" type="text/css" href="tablesorter-theme/style.css">
65                 <link rel="alternate" title="変愚蛮怒 新着スコア" href="feed/newcome-atom.xml" type="application/atom+xml" />
66                 <script
67                 src="https://code.jquery.com/jquery-3.3.1.min.js"
68                 integrity="sha256-FgpCb/KJQlLNfOu91ta32o/NMZxltwRo8QtmkMRdAu8="
69                 crossorigin="anonymous"></script>
70
71                 <script src="jquery.tablesorter.min.js" type="text/javascript"></script>
72                 <script src="popularity_ranking.js" type="text/javascript"></script>
73                 <title>変愚蛮怒 公式WEB スコアランキング 人気のある種族・職業・性格</title>
74         </head>
75
76         <body>
77
78                 <header>
79
80                         <section id="title">
81                                 <img class="tama1" src="/image/tama.gif" alt="tama">
82                                 <img class="tama2" src="/image/tama.gif" alt="tama">
83                                 <img class="tama3" src="/image/tama.gif" alt="tama">
84                                 <img class="tama4" src="/image/tama.gif" alt="tama">
85                                 <img id="hengTitle" src="/image/hengband_title.png" alt="変愚蛮怒 Hengband">
86                                 <img class="tama4" src="/image/tama.gif" alt="tama">
87                                 <img class="tama3" src="/image/tama.gif" alt="tama">
88                                 <img class="tama2" src="/image/tama.gif" alt="tama">
89                                 <img class="tama1" src="/image/tama.gif" alt="tama">
90                         </section>
91
92                         <section id="mainMenu">
93                                 <a href="/index.html">トップ</a>
94                                 <a href="/download.html">ダウンロード</a>
95                                 <a href="/score.html">スコア</a>
96                                 <a href="/lists.html">コミュニティ</a>
97                                 <a href="/history.html">バージョン履歴</a>
98                                 <a href="/link.html">関連リンク</a>
99                                 <a href="/jlicense.html">著作権表記</a>
100                                 <span>English (Coming Soon)</span>
101                         </section>
102
103                 </header>
104  
105                 <div id="main">
106 <!--main contents-->
107 <h2>人気のある種族・職業・性格</h2>
108 <!--
109 <small>
110 <?php
111 echo sprintf("(%.2f 秒)", $query_time);
112 ?>
113 </small>
114 -->
115 <nobr>[ <a href="javascript:void(0)" class="table_select" id="race_id">種族</a> | <a href="javascript:void(0)" class="table_select" id="class_id">職業</a> | <a href="javascript:void(0)" class="table_select" id="personality_id">性格</a> ]</nobr>
116
117 <?php
118 print_popularity_table($statistics['race'], 'race_id', "種族");
119 ?>
120 <?php
121 print_popularity_table($statistics['class'], 'class_id', "職業");
122 ?>
123 <?php
124 print_popularity_table($statistics['personality'], 'personality_id', "性格");
125 ?>
126
127                 </div>
128
129                 <footer>
130
131                         <section>
132                                 各ページへのリンクは御自由にどうぞ。/ Link Free.<br>
133                                 2018 Hengband Dev Team. <a href="mailto:hengband-dev@lists.sourceforge.jp">hengband-dev@lists.sourceforge.jp</a><br>
134                         </section>
135
136                         <section>
137                                 Powered by <a href="https://ja.osdn.net/" class="footer_banner">
138                                 <img src="https://ja.osdn.net/sflogo.php?group_id=541" border="0" alt="OSDN.jp">
139                                 </a>
140                         </section>
141
142                 </footer>
143
144         </body>
145
146 </html>