Log in

View Full Version : Users online on an external page?


k007
01-31-2008, 06:13 AM
is it possible to have a list of users online on an external page? by external meaning not even on the same web server..

Dismounted
01-31-2008, 07:44 AM
The easiest way would be to have a page that generates the string, and the external script would access that page and grab that string with all the info in it.

k007
01-31-2008, 08:06 AM
i dont understand how do i exactly do that? or cant i use mysql and access the forums it self? doesnt the forum mysql db have a table for users online or what?

Dismounted
01-31-2008, 08:23 AM
You could, but you said you'd be accessing off the server, and by default, access to MySQL can only be done with scripts on the same server. To directly query from another server, you would have to allow MySQL connections from the other server, which I advise against.

To use my method (or yours), you would need knowledge of PHP (and probably MySQL).

k007
01-31-2008, 09:04 PM
I have dealt with php and mysql queries before...after checking out the vbulletin database tables layout, i found a table called _sessions, where userids are being added/removed depending on logged/not logged in.. i could get the data from there using php and mysql but the thing that im not sure about is spiders in the session table will they all be displayed with an id of 0? if so i could simply use the query and filter 0 off if not then thats an issue...

Dismounted
02-01-2008, 04:41 AM
Look at the end of index.php.

k007
02-01-2008, 10:03 PM
Thanks man.