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

[Clive Gould]

I've created a simple Linux bash shell script that generated a Web page containing some basic simulator/server statistics

This was purely to keep an eye on the simulator/server to make sure it was still running ;)

Let me know if you have comand line access to a Linux server and would like a copy of the script


Sent from my iPhone

On 3 Mar 2012, at 14:15, InuYasha Meiji <inuyasha.meiji at gmail.com> wrote:

> Wow, that sound great.  But, I am a bit of a dummy to php and that sort of thing.  Is there a way to take this info and add a small window to a web page on my apache server to show how many people are currently online or maybe even who??
> 
> I am not a php programmer and not sure how to use php to query my database the way you describe.  I am tring to keep my grid using the root and what is available from opensimulator.org and its modules, without going to Diva or simian, but would like a nice web stats display on my web site.  Anything like this would be great help.
> 
> Thanks all of you for your time, I wish I could show more how much I appreciate all you have been doing with this project.
> InuYasha.
> 
> 
> On 3/3/2012 6:08 AM, Clive Gould wrote:
>> 
>> After a number of postings to the OpenSim forums (thanks especially to
>> Diva and Justin) the fix was to get the standalone simulator to create
>> and use a presence table, which could be queried.
>> 
>> This was achieved by adding the following three lines to
>> StandaloneCommon.ini and restarting the simulator:
>> 
>> [PresenceService]
>> StorageProvider = "OpenSim.Data.MySQL.dll"
>> ConnectionString = "Data Source=localhost;Database=opensim;User
>> ID=xxxx;password=yyyy;"
>> 
>> The following SQL query then successfully returned the names of users
>> currently online:
>> 
>> select a.firstname, a.lastname from opensim.UserAccounts a,
>> opensim.Presence b where a.principalid = b.userid
>> _______________________________________________
>> Opensim-users mailing list
>> Opensim-users at lists.berlios.de
>> https://lists.berlios.de/mailman/listinfo/opensim-users
>> 
> 
> 
> -- 
> ________________________________________________________________
> Opensim User: Standalone Grid on Version 0.7.2 with 56 Regions
> on Windows 7, 64-bit. Phenom 9500 2.2 ghz Quad Core, Terabyte Hard 
> Drive, 8gig DDR2 RAM.  Used XAMPP to load PHP Version 5.3.0, Apache
> and MySQL 5.1.41-community edition.  Groups, Profiles, Voice and 
> Offline Mesages all working.
> ________________________________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20120303/77368288/attachment.html>