Whos Online Script

vk2him · 2 January 2009 06:47

MCHALLIS post:260:

Try this mysql command on the table and let me know if it helps:


ALTER TABLE `whos_online` 
CHANGE `hostname` `hostname` VARCHAR( 255 ) default NULL ,
CHANGE `http_referer` `http_referer` VARCHAR( 255 ) default NULL;

Wow, you’re a magician, its working now!!! Thanks, I’m going to play around with it now

MCHALLIS · 2 January 2009 06:51

Great

I will modify the whos-online.sql.txt in the download so the next person on IIS does not have that problem.

You are using version 1.50?

There is a newer version I uploaded yesterday.

Version: 1.51 22-Dec-2008

fixed bug where IP addresses sometimes were not showing when logged in
to upgrade from 1.50, replace include-whos-online-page.php

Version: 1.52 31-Dec-2008

fixed refresh not working when login enabled and logged in
added a new state-addon plugin to show “city, state” next to country flags, see ‘state-addon’ folder readme.txt
Thanks to (Jim McMurry - jcweather.us) for the idea and some of the code.
to upgrade from 1.51, replace whos-online.php, include-whos-online-page.php, and include-whos-online-header.php

vk2him · 2 January 2009 07:04

Thanks, I’ll include those updates now … at the moment I’m having formatting issues trying to incorporate your code into my background template … I get this error:

Warning: Cannot modify header information - headers already sent by (output started at C:\Inetpub\wwwroot\wx\whos-online.php:61) in C:\Inetpub\wwwroot\wx\include-whos-online-settings.php on line 328

The page displays properly, just with this error at the top … The error may be in a different spot if the updated code changes … I’ll try that now

pinto · 2 January 2009 10:19

test a basic worldmap (plugin)

you can see it at my site: Tools & info who’s online

test-worldmap.zip (42.7 KB)

i_fiorentino · 2 January 2009 10:28

Hi guys,
what kind of mysql database are you used?
yours or one of your service provider?
Thanks,

Alessandro

vk2him · 2 January 2009 11:33

I am using a mysql database on my own IIS server …

jwwd · 2 January 2009 12:16

Hi Pinto

I have it up and running and its working fine - very easy to implement.

Best regards,

Henrik

vk2him · 2 January 2009 12:39

I have it working too Pinto, very nice!! I may make the Pin picture a bit larger

http://wx.theshackbythebeach.com/wx/whos-online.php
Cheers

jmcmurry · 2 January 2009 15:20

Jozef,

Outstanding addition! Now I wonder about country and possibly regional map options. Hmmm.

Jim

user3162 · 2 January 2009 15:51

My pins are in the ocean!
http://www.nhpaweather.com/whos-online.php

Oops! Looks OK in I.E. but in Firefox they are off- but just for my site. When I view other pages in this post with Firefox, they look OK.

Fixed! I changed the doc type, now it looks OK.

MCHALLIS · 2 January 2009 17:02

I will test the basic worldmap (plugin) today.
This requires you have the country addon and the state addon installed. You have to have all 3 plugins installed.

If you just want to put the worldmap on your whos online page it will be populated with every visitor.

If you want to put the worldmap on any other page on your site, then there is a weakness in this system:
as it is now, the location_info table only gets populated when the whos online page is being viewed.
Worse yet, if you have it password protected, the location_info table only gets populated when the whos online page is being viewed by the logged in admin.

This is getting a bit busy with 3 layers of plugins.
Using the maxmind data makes the country-to-ip data redundant.
When I get time, I might make it one plugin that requires the maxmind data with options to turn on and off features.
The worldmap could be included on any page on your site.
It would be whos-online 2.0 and require uninstall and re-install. How many are up for this idea?

pinto · 2 January 2009 17:23

I would say: go on Mike, if you have time.(installing, reinstall, it’s fun, I like to play with things like this)
And as it is now you only have the last 30 day visitors, …and so on.
The script was only hacked together to show what was possible.

@ Jim I sure would have a map for US, Europe, even one for my own country, or … but that is a little to much for me.

I only picked some lines from different scripts, put them in a shaker, shake a couple of minutes and there it was.

jwwd · 2 January 2009 17:26

Hi Mike

I agree with pinto

Its good fun to play with all the great scripts.

Best regards,

Henrik

Billw69 · 2 January 2009 17:37

Sounds like a GREAT idea to me.

jmcmurry · 2 January 2009 17:41

Mike,

I too am up for version 2.0!

Jim

MCHALLIS · 2 January 2009 17:41

OK great, I am working on it today. 8)

It will have only one plugin called “location-plugin”.
The plugin will combine all the location features.
The whos-online map can be used on any page.

When I have it ready I will start a new post.

mth · 2 January 2009 18:37

Just so I am ready for the next version…I will have to totally delete what I currently have. Is there an easy way to delete the whois tables from my SQL server using PHPMYADMIN?

burgus · 2 January 2009 18:41

Drop the tables, I think that will clear the data base.

Mark

MCHALLIS · 2 January 2009 21:17

I have the 2.0 version working on my site. :lol:
I need more time to document the changes in the readme files and changelog

G.O.B.B · 2 January 2009 22:08

If you do not want to re-create the tables, you can use truncate, that clears out the data but leaves the schema intact.