Execute $query ever x seconds

[antonyfal]

Hi.

I have a query that determines if user is online/offline. Works perfectly when page loads. I want to change to auto run query every X seconds.

NOTES:

- The query is on a .php page with multiple other queries.

-IF it is possible to still run the query with-in this page? or make a separate file and include in an iframe? i would like to avoid the iframe and just $output the result of query every X seconds.

 

Here is my $query code:

^{$query = "SELECT `manager_id` FROM #__profiles_xref WHERE profileid = '$profid'";}

^{$onofflineid=doSelectSql($query,1);}

^{foreach ($onofflineid as $isonoffline){}

^{$profmanagerid=$isonoffline->manager_id;}

^}

 

^{$query = "SELECT `session_id` FROM table_session WHERE userid = '$propmanagerid'";}

^{$onofflinestatus=doSelectSql($query,1);}

^{if (count($onofflinestatus)>0)}

^{

^{$output['PROPSTATUS']='Online';}

^{} else {}

^{$output['PROPSTATUS']='Offline';}

^}

[trq]

You would need to schedule a job to execute your script. Look into cron.

[kickstart]

Hi

 

As above, or if you want the details output to update a users page then maybe put it in a small script to be used for an AJAX call.

 

All the best

 

Keith