[Opensim-users] MySQL query and number of agents online

[Clive Gould]

Sorry didn't work for me - am I being dense?

useraccounts was UserAccounts but...

mysql> select  a.firstname, a.lastname from UserAccounts a, presence b
where a.principalid = b.userid;
ERROR 1146 (42S02): Table 'opensim.presence' doesn't exist


On Fri, Mar 2, 2012 at 2:05 PM, Steven Salter <ssalter at indiana.edu> wrote:
> This seemed to work for me:
>
> select  a.firstname, a.lastname from useraccounts a, presence b where a.principalid = b.userid
>
>
> Steve
>
> On Mar 2, 2012, at 8:40 AM, Clive Gould wrote:
>
>> Hi
>>
>> Any idea what SQL query I need to use to find out how many users are logged in?
>>
>> I've tried the query on the page
>> http://opensimulator.org/wiki/Useful_Queries and the table
>> opensim.agents no longer exists in the database schema
>>
>> i.e. Count the number of users presently logged in (same issues as
>> listing online users, above):
>> SELECT count(UUID) AS 'Users Online' FROM opensim.agents WHERE
>> agentonline = '1';
>>
>> I've looked at the Online=TRUE in the opensim.GridUser table and this
>> returns 21, whereas the console reports 9 agents online
>>
>> Any suggestions most welcome
>>
>> Thanks
>>
>> Clive
>>
>> P.S I've just freed up some memory on our server and upgraded to 0.7.3
>> and so far nothing has gone wrong
>> _______________________________________________
>> Opensim-users mailing list
>> Opensim-users at lists.berlios.de
>> https://lists.berlios.de/mailman/listinfo/opensim-users
>