Extension talk:WhosOnline/Archive 1

Users/Installers: Don't forget the prefix
In case your wiki uses a prefix (e.g. "mw") for the database tables, change the first line of the SQL instruction into something like: CREATE TABLE `mw_online` (    .....

Other than that: ** Special:WhosOnline|Who is online - Daniel / edutechwiki.unige.ch
 * This extension works fine with Mediwiki version 1.12.0
 * If you want to make a quicklink from the sidebar, edit MediaWiki:Sidebar and add something like:

List visitors?
I would use this extensions since it's stable and hasn't got the UNIQ problem but as a special page it's not very useful. I think most users want to integrate the stats on Main Page or another exisiting page. E.g. Guests: 75, Users (2): Bob, Paul. WHat brings me to the next point. Ignoring the anonymous visitors is what makes me ignore this extension ;)
 * Btw: Works fine in 1.12 for me as well --Subfader 13:12, 12 May 2008 (UTC)

Works also fine in my 1.12 without any fiddling, but Subfader is right: connectable to a "$footerlinks" in "MyModifiedSkin.php" it would be even better. Difficult to implement? --michael 10:00, 16 May 2008 (UTC)
 * Thanks for this nice extension!


 * I also agree with Subfader. My wish list is integrable throughout the wiki and accounting for guests.

Having problem with sql table
I can't seem to add the sql table.

After entering this: CREATE TABLE mw_online (`userid` int(5) NOT NULL default '0',`username` varchar(255) NOT NULL default ,`timestamp` char(14) NOT NULL default , PRIMARY KEY USING HASH (`userid`, `username`),INDEX USING BTREE (`timestamp`)) TYPE=MEMORY;

I get this response -bash: syntax error near unexpected token `('

I think it's to do with the INDEX USING BTREE (`timestamp`) section.

Any ideas how to fix this?

Thanks

--LizK 09:23, 20 August 2008 (UTC)


 * No idea, sorry.


 * Assuming you have the extension files in $IP/extensions/WhosOnline, why don't you cd extensions/WhosOnline, edit whosonline.sql with your favorite text editor (nano, vim etc.), replace $wgDBprefix with mw_ and then run mysql -u [your mysql username here] -p [database name here] < whosonline.sql? That's a lot easier (for me, anyway) than copying and pasting stuff. :) -- Sayuri 13:54, 20 August 2008 (UTC)

Allow inclusion of the page
This patch allows inclusion of the Special page, in a similar way to Special:Newpages (eg. ). If you use   it will only show 10 users and will have the navigation controls.

Edit WhosOnlineSpecialPage.php and change line 79: to

Then go to line 111 and change the rest of the execute function from

to