index_flag_ids.php

   1 <?php
   2 /** board script
   3 * Displayes the submitted flag_ids of the
   4 * last X time with meta information
   5 * If the submission to gameserver was successfull (submitsuccess)
   6 * and we got points for it (scoresuccess) it should be green bg
   7 *
   8 * 2014-15 by Jan "Someone" Vales <someone@somenet.org>
   9 * do not publish!
  10 */
  11
  12 $GLOBALS['db'] = new PDO('pgsql:host=localhost;port=5432;dbname=flagbot;user=flagbot;password=flagbotpw');
  13 $GLOBALS['db']->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  14 $query = "SELECT * FROM flag_ids WHERE (received + INTERVAL '30 minute') > now() ORDER BY received DESC";
  15
  16 ?>
  17 <!DOCTYPE html>
  18   <html>
  19   <head>
  20     <link rel="stylesheet" type="text/css" href="styles.css"></link>
  21   </head>
  22   <body>
  23     <h1>Submission Board - flag_ids</h1>
  24     <p><a href="./index.php">go to flags</a></p>
  25     <p>Shows all submissions of the last 30 min<br>
  26     NUM ROWS: <?php echo sizeof($GLOBALS['db']->query($query)->fetchAll()); ?></p>
  27     <table style="width: 100%">
  28       <thead>
  29         <tr>
  30             <th>service</th>
  31             <th>team</th>
  32             <th>flag_id</th>
  33             <th>received</th>
  34             <th>status</th>
  35           </tr>
  36         </thead>
  37         <tbody>
  38           <?php
  39           $stmt = $GLOBALS['db']->query($query);
  40           while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
  41           ?>
  42             <tr class="score-<?php echo $row['status']; ?>">
  43               <td><?php echo $row['service']; ?>&nbsp;</td>
  44               <td><?php echo $row['team']; ?>&nbsp;</td>
  45               <td><?php echo $row['flag_id']; ?>&nbsp;</td>
  46               <td><?php echo $row['host']; ?>&nbsp;</td>
  47               <td><?php echo $row['received']; ?></td>
  48               <td><?php echo $row['status']; ?></td>
  49             </tr>
  50             <?php
  51           }
  52           ?>
  53         </tbody>
  54       </table>
  55     <p>Status: 0=new; 1=depleted</p>
  56     </body>
  57     </html>