Subversion Repositories ALCASAR

Rev

Rev 1478 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log

Rev 1478 Rev 1805
Line 17... Line 17...
17
 *   along with this program; if not, write to the                         *
17
 *   along with this program; if not, write to the                         *
18
 *   Free Software Foundation, Inc.,                                       *
18
 *   Free Software Foundation, Inc.,                                       *
19
 *   59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.             *
19
 *   59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.             *
20
 ***************************************************************************/
20
 ***************************************************************************/
21
 
21
 
22
// $Id: portail.php 1478 2014-11-04 22:28:12Z richard $
22
// $Id: portail.php 1805 2016-03-10 11:53:23Z clement.siccardi $
23
 
23
 
24
// xml_utilisateur()
24
// xml_utilisateur()
25
 
25
 
26
function request ($texte) {
26
function request ($texte) {
27
		$strResult = 0;
27
		$strResult = 0;
Line 29... Line 29...
29
		$host = "localhost";
29
		$host = "localhost";
30
		$DB_USER = "radius";
30
		$DB_USER = "radius";
31
		$DB_RADIUS = "radius";
31
		$DB_RADIUS = "radius";
32
		$radiuspwd = "J7YI65SW";
32
		$radiuspwd = "J7YI65SW";
33
		// Connexion au serveur
33
		// Connexion au serveur
34
		mysql_connect($host, $DB_USER,$radiuspwd) or die("erreur de connexion au serveur");
34
		$mysqli = new mysqli($host, $DB_USER, $radiuspwd, $DB_RADIUS);
35
		mysql_select_db($DB_RADIUS) or die("erreur de connexion a la base de donnees");
-
 
36
		// Creation et envoi de la requete
-
 
37
		if ($texte == 'user') {$query = "SELECT UserName FROM userinfo";}
35
		if ($texte == 'user') {$query = "SELECT UserName FROM userinfo";}
38
		else { $query = "SELECT GroupName FROM radusergroup GROUP BY GroupName";}
36
		else { $query = "SELECT GroupName FROM radusergroup GROUP BY GroupName";}
39
		$result = mysql_query($query);
37
		$result = $mysqli->query($query);
40
		// Recuperation des resultats
38
		// Recuperation des resultats
41
		$strResult = mysql_num_rows($result);
39
		$strResult = $result->num_rows;
42
		// Deconnexion de la base de donnees
40
		// Deconnexion de la base de donnees
43
		 mysql_close();
41
		$mysqli->close();
44
		return $strResult;
42
		return $strResult;
45
  }
43
 }
-
 
44
 
46
function xml_portail () {
45
function xml_portail () {
47
	global $sysinfo;
46
	global $sysinfo;
48
	
47
 
49
	$_text = "  <Portail>\n"
48
	$_text = "  <Portail>\n"
50
//		. "    <Utilisateur>" . htmlspecialchars( request('user'), ENT_QUOTES ) . "</Utilisateur>\n"
49
//		. "    <Utilisateur>" . htmlspecialchars( request('user'), ENT_QUOTES ) . "</Utilisateur>\n"