<html><body bgcolor="#FFFFFF"><div>I've created a simple Linux bash shell script that generated a Web page containing some basic simulator/server statistics</div><div><br></div><div>This was purely to keep an eye on the simulator/server to make sure it was still running ;)</div><div><br></div><div>Let me know if you have comand line access to a Linux server and would like a copy of the script</div><div><br><br>Sent from my iPhone</div><div><br>On 3 Mar 2012, at 14:15, InuYasha Meiji <<a href="mailto:inuyasha.meiji@gmail.com">inuyasha.meiji@gmail.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div>
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??<br>
<br>
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 <a href="http://opensimulator.org">opensimulator.org</a> 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.<br>
<br>
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.<br>
InuYasha.<br>
<br>
<br>
On 3/3/2012 6:08 AM, Clive Gould wrote:
<blockquote cite="mid:CAFGJoA5F7iQnbc3DzKg9VJ47r==1VSJOyDY1GpQfC4Y0SYM=2Q@mail.gmail.com" type="cite">
<pre wrap="">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
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de"><a href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a></a>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users"><a href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a></a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
________________________________________________________________
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.
________________________________________________________________
</pre>
</div></blockquote></body></html>