Fix useless SQL queries when on Xnet but not in a group.
[platal.git] / classes / platalglobals.php.in
1 <?php
2 /***************************************************************************
3 * Copyright (C) 2003-2010 Polytechnique.org *
4 * http://opensource.polytechnique.org/ *
5 * *
6 * This program is free software; you can redistribute it and/or modify *
7 * it under the terms of the GNU General Public License as published by *
8 * the Free Software Foundation; either version 2 of the License, or *
9 * (at your option) any later version. *
10 * *
11 * This program is distributed in the hope that it will be useful, *
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
14 * GNU General Public License for more details. *
15 * *
16 * You should have received a copy of the GNU General Public License *
17 * along with this program; if not, write to the Free Software *
18 * Foundation, Inc., *
19 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
20 ***************************************************************************/
21
22 class PlatalGlobals extends PlGlobals
23 {
24 /** The x.org version */
25 public $version = '@VERSION@';
26
27 /** db params */
28 public $dbdb = null;
29 public $dbprefix = '';
30 public $dbhost = 'localhost';
31 public $dbuser = null;
32 public $dbpwd = null;
33 public $dbcharset = 'utf8';
34
35 /** default skin */
36 public $skin;
37 public $register_skin;
38
39 public function __construct()
40 {
41 parent::__construct(array('platal.ini', 'platal.conf'));
42 if (isset($GLOBALS['IS_XNET_SITE'])) {
43 $this->core->sitename = 'Polytechnique.net';
44 }
45 }
46
47 public function init()
48 {
49 $this->bootstrap(array('NbIns'), array($this, 'updateNbIns'));
50 $this->bootstrap(array('NbValid'), array($this, 'updateNbValid'));
51 }
52
53 public function asso($key = null)
54 {
55 static $fetched = false;
56 static $aid = null;
57
58 if (isset($GLOBALS['IS_XNET_SITE']) && !$fetched) {
59 $gp = Get::v('n');
60 if ($p = strpos($gp, '/')) {
61 $gp = substr($gp, 0, $p);
62 }
63
64 $aid = Group::get($gp);
65 $fetched = true;
66 }
67 if (empty($key)) {
68 return $aid;
69 } elseif (isset($aid->$key) ) {
70 return $aid->$key;
71 } else {
72 return null;
73 }
74 }
75
76 public function updateNbIns()
77 {
78 $res = XDB::query("SELECT COUNT(*)
79 FROM accounts
80 WHERE state = 'active'");
81 $cnt = $res->fetchOneCell();
82 $this->changeDynamicConfig(array('NbIns' => $cnt));
83 }
84
85 public function updateNbValid()
86 {
87 $res = XDB::query("SELECT COUNT(*)
88 FROM requests");
89 $this->changeDynamicConfig(array('NbValid' => $res->fetchOneCell()));
90 }
91 }
92
93
94 /******************************************************************************
95 * Dynamic configuration update/edition stuff
96 *****************************************************************************/
97
98 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
99 ?>