[Opensim-users] Caching hypergrid users info

[Gudule Lapointe]

More background info:

Currently, login time is only saved in griduser table fro local users. That makes the calculation of total monthly users impossible. Though this number is really interesting to mesure grid activity in an hypergrid context.

First idea was to patch OpenSim and fill the Login field for HG visitors as well. But this would have affected a couple of other things, including the current "local active users" which is a de facto standard.
Another idea would be to add a separate checkin field to griduser. This could be done if it is considered as interesting for most. 


Le 13 juin 2012 à 11:11, Gudule Lapointe a écrit :

> Hello
> 
> We wanted a way to get connection info for hypergrid users. It looks like this information is not saved in the database, so not usable for external modules like web interfaces.
> 
> So we created it:
> 	- a "cacheusers" table to add in robust database 
> 	- a script to feed this table from robust log (with a cron batch)
> 	- a php file to fetch grid info, including monthly stats for all visitors (local users and HG visitors)
> 
> I think the table could also be used inside OpenSim to keep trace of HG visitors, so it could eventually be adjusted following global needs and added in OpenSim core.
> For example, better use would be to update it upon HG visitor login, instead of running a script for that.
> But for now, it is an independent project.
> 
> We published the current code (along with other useful tools) at 
> 	http://www.speculoos.net/fr/opensim-toolbox
> 	https://github.com/GuduleLapointe/opensim-toolbox
> 
> --
> http://www.speculoos.net/
> secondlife://speculoos.net:8002/
> Speculoos, the belgian cookie-flavored metaverse
> 
> _______________________________________________
> 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/20120613/76f4554f/attachment.html>