online users

Mordor Networks mordor.networks at gmail.com
Sat Apr 14 15:25:30 CEST 2007


Thor Spruyt wrote:
> Mordor Networks wrote:
>   
>> hi Graham
>> yes sir i know but my question is how to do that im all new to all
>> this.. thank you
>>     
>
> Connect to your mysql database and type "show tables;", then you'll see a 
> list of tables in your database.
> It's probably the "radacct" table you need to query for session information.
> If you don't know how to write SQL queries, have a look at 
> http://www.mysql.org/doc/
>
> Thor.
>
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>   
Thanks for your info , i fixed the issue with this :

$request = "SELECT COUNT(*) FROM radacct WHERE AcctStopTime=0";
$res = mysql_query($request);
while( $row = mysql_fetch_array($res) )
{ $login_users = $row[0]; }
print $row[0];




More information about the Freeradius-Users mailing list