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

[Fleep Tuque]

Hi InuYasha,

*(Sorry in advance if you've already thought of all this and have made a
choice for your own reasons, but someone was asking me about this the other
day and I was trying to explain why it's often beneficial to use add-ons
with Opensim.  I don't want to sound patronizing though!) *

While I can understand your desire to stick to "core" Opensim, as I
understand it, the developers have made a choice to not include many
different kinds of features and functions in the core distribution in order
to focus on, well, the "core" of what's required to make an Opensim server
work.  They _expect_ users to use add-on modules to extend the
functionality of Opensim, so if you decide to only ever use the core
download, you'll always be pretty limited to the basic functions of the
server.

I think of it like this:  The core Opensim distribution is the frame of a
house and it comes with the basic stuff required to provide some shelter,
but if you want a nice front door and pretty shutters, you'll need to add
those yourself.

(Personally, I think some of the features they've chosen to exclude (or not
include) are unfortunate choices since most people create an Opensim world
for the purpose of sharing it with others and the core distribution doesn't
provide some of the basic features needed to do that - easy account
creation, non-ruth starter avatars, a visually appealing welcome screen,
etc., I mean who wants a house without a door!  But I understand the
philosophy behind the choice and am generally so grateful for all their
hard work that I figure we shouldn't complain.)  ;)

Fortunately, Diva made a really nice front door package for us to use, and
with a little tinkering you can figure out how to customize it for your
grid without being a hardcore php programmer or web developer.  For an
example of a custom welcome screen made with Diva Wifi, see
http://ucsim.uc.edu:8002/wifi/welcome.html - obviously I created some
custom graphics in Photoshop, and I had to edit both the css and html of
the default webpage with the module, but I wouldn't consider myself a super
web dev.

I highly recommend it, and as far as I know you don't have to run the Diva
flavor of Opensim to take advantage of the Diva Wifi module capabilities,
or to further the analogy, I'm pretty sure you can use the Diva Wifi front
door on the stock Opensim house or with her souped up Opensim house.  :)

Hope that helps and you can find more information and download links at:
http://opensimulator.org/wiki/Wifi

Sincerely,

- Chris/Fleep

Chris M. Collins (SL/OS: Fleep Tuque)
Center for Simulations & Virtual Environments Research (UCSIM)
UCIT Instructional & Research Computing
University of Cincinnati
406A Zimmer Hall
315 College Drive
PO BOX 210088
Cincinnati, OH 45221-0088
chris.collins at uc.edu
(513) 556-3018

http://ucsim.uc.edu

On Sat, Mar 3, 2012 at 9:15 AM, 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 listOpensim-users at lists.berlios.dehttps://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.
> ________________________________________________________________
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20120303/3dc5b3c2/attachment.html>