online users

[tnt at kalik.co.yu]

SELECT COUNT(*) FROM radacct WHERE AcctStopTime=0

That will give you the number of currently logged in users (according to
the database).

Ivan Kalik
Kalik Informatika ISP

Dana 13/4/2007, "Mordor Networks" <mordor.networks at gmail.com> piše:

>i want to know how many user logged in mysql database/radius but it only
>show the number of user in my databse for example is says 61 logged out
>and 0 login
>so here is the problem
>//login users from//
>$login_users = ; < what i have to write here ? which table i have to query?
>
>how i can fix that ?
>if i change the number from 0 to 1 it show me one user online so their
>must be a way to fix it?
>heres the code :
>
><?php
>
>include ("include/Artichow/class/jpgraph.php");
>include ("include/Artichow/class/jpgraph_pie.php");
>include ("include/Artichow/class/jpgraph_pie3d.php");
>include_once ("class/Oreon.class.php");
>include_once ("phpradmin.conf.php");
>
>$oreon_db = new OreonDatabase($conf_pra["host"], $conf_pra["user"],
>$conf_pra["password"], $conf_pra["db"]);
>$table = "userinfo";
>
>//este si es valido
>$total_users_in_db = $oreon_db ->getTotalRowsInTable($table);
>//$total_users_in_db = 500;
>
>//login users from DB (SELECT COUNT(*) FROM radacct??;)
>$login_users = ;
>//logoff users total_users_in_db - login_users
>$logoff_users = ($total_users_in_db - $login_users);
>//percent
>$percent_login = ($login_users * 100 / $total_users_in_db);
>$percent_logoff = ( 100 - $percent_login );
>$data = array($percent_login,$percent_logoff);
>//$data = array(12,88);
>
>$graph = new PieGraph(350,170,"auto");
>$graph->SetShadow();
>//$graph->title->Set( $lang['pra_total_users_in_db']":" $total_users_in_db);
>$graph->title->Set("Total users in Data Base: $total_users_in_db");
>
>$graph->title->SetFont(FF_FONT1,FS_BOLD);
>$p1 = new PiePlot3D($data);
>$p1->ExplodeSlice( 1);
>$p1->SetLabelType( "PIE_VALUE_ABS");
>$p1->SetSize(0.40);
>$p1->SetCenter(0.33);
>$p1->SetSliceColors(array('green','blue'));
>$p1->setLegends(array(
>"LogIN Users: $login_users",
>"LogOUT Users: $logoff_users",
>));
>
>$graph->Add($p1);
>$graph->Stroke();
>
>?>
>-
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>
>