appdbStats.php

   1 <?php
   2 /****************************************************************/
   3 /* Code to view all kinds of interesting statistics about appdb */
   4 /****************************************************************/
   5
   6 require("path.php");
   7 require(BASE."include/incl.php");
   8 require_once(BASE."include/user.php");
   9
  10 apidb_header("Appdb Statistics");
  11
  12 echo "<div class='default_container'>\n";
  13
  14 echo html_frame_start("","60%","");
  15 echo "<table width='100%' border=1 cellpadding=3 cellspacing=0>\n\n";
  16
  17 /* Display the number of users */
  18 echo "<tr class=color4>\n";
  19 echo "    <td>Users:</td>\n";
  20 echo "    <td>".User::objectGetEntriesCount()."</td>\n";
  21 echo "</tr>\n\n";
  22
  23 /* Display the active users in the last 30 days */
  24 echo "<tr class=color4>\n";
  25 echo "    <td>Users active within the last 30 days:</td>\n";
  26 echo "    <td>".User::active_users_within_days(30)."</td>\n";
  27 echo "</tr>\n\n";
  28
  29 /* Display the active users in the last 60 days */
  30 echo "<tr class=color4>\n";
  31 echo "    <td>Users active within the last 60 days:</td>\n";
  32 echo "    <td>".User::active_users_within_days(60)."</td>\n";
  33 echo "</tr>\n\n";
  34
  35 /* Display the active users in the last 90 days */
  36 echo "<tr class=color4>\n";
  37 echo "    <td>Users active within the last 90 days:</td>\n";
  38 echo "    <td>".User::active_users_within_days(90)."</td>\n";
  39 echo "</tr>\n\n";
  40
  41 /* Display the inactive users */
  42 echo "<tr class=color4>\n";
  43 echo "    <td>Inactive users (not logged in since six months):</td>\n";
  44 echo "    <td>".(User::objectGetEntriesCount()-
  45         User::active_users_within_days(183))."</td>\n";
  46 echo "</tr>\n\n";
  47
  48 /* Display the users who were warned and pending deletion */
  49 echo "<tr class=color4>\n";
  50 echo "    <td>Inactive users pending deletion:</td>\n";
  51 echo "    <td>".User::get_inactive_users_pending_deletion()."</td>\n";
  52 echo "</tr>\n\n";
  53
  54 /* Display the number of comments */
  55 echo "<tr class=color4>\n";
  56 echo "    <td>Comments:</td>\n";
  57 echo "    <td>".getNumberOfComments()."</td>\n";
  58 echo "</tr>\n\n";
  59
  60 /* Display the number of application familes */
  61 echo "<tr class=color4>\n";
  62 echo "    <td>Application families:</td>\n";
  63 echo "    <td>".application::objectGetEntriesCount('accepted')."</td>\n";
  64 echo "</tr>\n\n";
  65
  66 /* Display the number of versions */
  67 echo "<tr class=color4>\n";
  68 echo "    <td>Versions:</td>\n";
  69 echo "    <td>".version::objectGetEntriesCount('accepted')."</td>\n";
  70 echo "</tr>\n\n";
  71
  72 /* Display the number of application maintainers */
  73 echo "<tr class=color4>\n";
  74 echo "    <td>Application maintainers:</td>\n";
  75 echo "    <td>".Maintainer::getNumberOfMaintainers()."</td>\n";
  76 echo "</tr>\n\n";
  77
  78 /* Display the number of test reports */
  79 echo "<tr class=color4>\n";
  80 echo "    <td>Test reports:</td>\n";
  81 echo "    <td>".testData::objectGetEntriescount('accepted')."</td>\n";
  82 echo "</tr>\n\n";
  83
  84 /* Display the number of images */
  85 echo "<tr class=color4>\n";
  86 echo "    <td>Screenshots:</td>\n";
  87 echo "    <td>".screenshot::objectGetEntriesCount('accepted')."</td>\n";
  88 echo "</tr>\n\n";
  89
  90 echo "</table>\n\n";
  91
  92 echo "</div>\n";
  93
  94 echo html_frame_end("&nbsp;");
  95 apidb_footer();
  96 ?>