[ABD] Visitors Today (1.0.4)

Any abandoned MODs will be moved to this forum.

WARNING: MODs in this forum are not currently being supported or maintained by the original MOD author. Proceed at your own risk.
Forum rules
IMPORTANT: MOD Development Forum rules

WARNING: MODs in this forum are not currently being supported nor updated by the original MOD author. Proceed at your own risk.
Locked
Anti.Social
Registered User
Posts: 51
Joined: Wed Dec 13, 2006 6:12 pm
Location: 6' Under with no marker
Contact:

[ABD] Visitors Today (1.0.4)

Post by Anti.Social » Wed Jun 20, 2007 7:38 pm

MOD Title: Visitors Today.
MOD Description: Adds a list of users who visited today on the forum index. Complete with user count, total, and break down of all users.
Features:
» Enable/Disable display/counting of bots via ACP
» Enable/Disable display/counting of guests via ACP
» Enable/Disable display of hidden users to admins/moderators via ACP
» Enable/Disable display of last visit time on hover via ACP
» Enable/Disable the use of user/group colors in the visitors list via ACP
» Enable/Disable use of board timezone via ACP
» Configure what is displayed via the ACP, tons of new options to play with.
» ACP configurable tracking threshold, allowing for easy customization of how long ago to display visitors from
» Ability to control format used to display date/times via ACP (The date format is the same as the PHP date function.)
» Simple database setup & template cache clearing install script included (you will still need to use either the pre-modded files, or manually modify your board.)

» It manages all of this with just sql 4 queries. (6 when setting a new record for # of visitors in a set period)
» Update from previous versions included in 1.0.4 RC2
» Correctly handles permissions for displaying hidden users


» Tested on phpBB3.0 RC2/RC3, current version RC2/RC3 compatible, not tested w/ RC1 or earlier!

» Beta tested by the users/members of http://www.uteoclans.com and my forum whore ZOLE to whom goes a special thanks.


MOD Version: 1.0.4 RC2
MOD Download: Main Download Site (This allows me to track the # of downloads so I know how popular this mod is)
Mirror #1: WikiUpload Mirror
Mirror #2: FileSend.net Mirror
Updated: 7/10/2007
Last Stable version: 1.0.4 RC2

Language Files (comming soon?)
en (included in package)
German (Thanks to IPB Refugee aka Wolfgang)
Dutch (Thanks to rohithathie)

Demo Board: http://www.uteoclans.com/mod_dev/phpBB3/ (currently running v1.0.4RC2 & phpBB3.0RC3)
Demo Username: Not Required
Demo Password: Not Required


(Updated Screenshots comming w/ version 1.0.4 RC2)
forum index as normal user w/ hidden users
http://www.uteoclans.com/mod_dev/images ... normal.jpg

forum index as admin w/ hidden users
http://www.uteoclans.com/mod_dev/images ... _admin.jpg

last visit hover
http://www.uteoclans.com/mod_dev/images ... _hover.jpg

ACP Board Settings
http://www.uteoclans.com/mod_dev/images/acp_board.jpg

ACP Main/Index
http://www.uteoclans.com/mod_dev/images/acp_main.jpg
Last edited by DavidIQ on Tue Jan 27, 2009 5:21 pm, edited 21 times in total.
Reason: Changed status to abandoned

User avatar
Stitch625
Registered User
Posts: 683
Joined: Wed Jun 20, 2007 3:38 pm
Location: Michigan
Contact:

Re: [RC1] Visitors Today

Post by Stitch625 » Thu Jun 21, 2007 2:23 am

I posted this originally in the wrong thread :oops:

Hello Anti,

I would like to try your mod out. However can you make it so it resets the count and list at midnight? The mod says 24 hours is the default. Default from what time? The time from when you install the mod?

Kind of confused how it works?

[EDIT] Ok so I am A little impatiant. I went ahead and installed it and it seems to be working so far. The only thing that is not working is the time does not show even though I have it checked to yes in the ACP and the Bots show even though I have them set to NO.

Anti.Social
Registered User
Posts: 51
Joined: Wed Dec 13, 2006 6:12 pm
Location: 6' Under with no marker
Contact:

Re: [RC1] Visitors Today

Post by Anti.Social » Thu Jun 21, 2007 5:04 pm

I have updated the mod, posted a new screenshot explaining the "Last Visit Hover" and updated the above post.

For users who have v1.0.0RC1 installed simply extract the 'root/includes/functions_visitors.php' file from v1.0.1RC1 over your existing 'root/includes/functions_visitors.php' to updated as that is the only file to be changed between versions.

Let me know if you encounter any other errors.

BTW: Default delete threshold of 86400 will cause the mod to use 12:00AM (midnight, SERVER TIME!!!) as the oldest allowed visitors time, anything prior to this will be purged from the database upon ANYBODY visiting the forums. Example: you have a vistors list that looks like : "In total there were 18 users online :: 48 registered users, 15 hidden users, 10 bots and 85 guests." ..... etc... @ 11:59:59PM tonight, the next person to visit your forums, refresh a page, etc. will cause this mod to purge the previous days visitors data.

Setting a delete threshold of anything other then 86400 will result in the mod purging the database every required intervul, Example: If you set delete threshold to 3600 then the mod will purge of ANYTHING older then 1 HOUR FROM WHEN THE PAGE WAS LAST LOADED.

User avatar
Stitch625
Registered User
Posts: 683
Joined: Wed Jun 20, 2007 3:38 pm
Location: Michigan
Contact:

Re: [RC1] Visitors Today

Post by Stitch625 » Fri Jun 22, 2007 1:04 am

DUDE! This mod ROCKS! Totally awsome job! This mod does exactly what I want it to do. I have tried 3 other similar mods like this but they either have bugs, run way too many queries or don't have all the options I was used to with the Last Visit mod for phpbb2.

I must say, you worked the bugs out of this one in a hurry. I just love the last visit hover option. Very professional!. So far since I have dowloaded your latest version today it is working perfectly!

Thank you very much! KUDOS!

User avatar
Stitch625
Registered User
Posts: 683
Joined: Wed Jun 20, 2007 3:38 pm
Location: Michigan
Contact:

Re: [RC1] Visitors Today

Post by Stitch625 » Fri Jun 22, 2007 1:05 am

oops double post

sorry. No delete button.

notaloafer
Registered User
Posts: 56
Joined: Fri Jun 08, 2007 5:02 am

Re: [RC1] Visitors Today

Post by notaloafer » Fri Jun 22, 2007 3:45 am

SQL ERROR [ mysql4 ]

Unknown column 'u.user_id' in 'on clause' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


I followed the directions....

-Eric.

cillinz
Registered User
Posts: 68
Joined: Sun Jan 16, 2005 11:29 am

Re: [RC1] Visitors Today

Post by cillinz » Fri Jun 22, 2007 5:44 am

The same error for me :/
stotis.net <- Lithuanian the best.

User avatar
LuckyPip
Registered User
Posts: 69
Joined: Fri Dec 03, 2004 4:40 am

Re: [RC1] Visitors Today

Post by LuckyPip » Fri Jun 22, 2007 7:33 am

And same here - something to do with line 82 in functions_visitors.php, I believe

Code: Select all

$result = $db->sql_query($sql);$i=-1; $today->visitlist = array();
Hope this will get fixed quickly as I believe I'm gonna like this nifty little MOD :P

spollin
Registered User
Posts: 34
Joined: Wed Sep 25, 2002 3:04 pm
Contact:

Re: [RC1] Visitors Today

Post by spollin » Fri Jun 22, 2007 2:26 pm

same issue for me too :( looking forward to it getting fixed as it seems like a nice little mod indeed :)

User avatar
Stitch625
Registered User
Posts: 683
Joined: Wed Jun 20, 2007 3:38 pm
Location: Michigan
Contact:

Re: [RC1] Visitors Today

Post by Stitch625 » Fri Jun 22, 2007 3:52 pm

I am no coder or anything but It almost seems like your guys problem has something to do with the DB queries. Did you install all of the queries that came with the mod.

I installed mine and first time around it is working perfectly.

freestyler
Registered User
Posts: 31
Joined: Thu Dec 08, 2005 11:13 pm
Location: Kentucky
Contact:

Re: [RC1] Visitors Today

Post by freestyler » Fri Jun 22, 2007 5:50 pm

Where do I add the database queries? I'm getting this error,

http://meanmug.org/forum/

This wasn't the easiest mod to install for a first-timer. :?

I don't know where this code goes. Do I go into myphpadmin to add it?

Code: Select all

DROP TABLE IF EXISTS `phpbb_visitors_table`;
CREATE TABLE `phpbb_visitors_today` (
  `index` int(11) NOT NULL auto_increment,
  `user_id` int(1) NOT NULL default '0',
  `user_ip` varchar(15) NOT NULL default '',
  `allow_viewonline` tinyint(1) NOT NULL default '0',
  `last_visit` int(11) NOT NULL default '0',
  PRIMARY KEY  (`index`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;


INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_display_bots', '1', 1);
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_display_time', '1', 1);
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_display_color', '1', 1);
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_display_hidden', '1', 1);
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_delete_threshold', 86400, 1);
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_record_count', '0', 1);
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_record_date', '0', 1);

Last edited by freestyler on Fri Jun 22, 2007 6:36 pm, edited 1 time in total.

elcochino6
Registered User
Posts: 22
Joined: Mon May 14, 2007 5:58 pm
Contact:

Re: [RC1] Visitors Today

Post by elcochino6 » Fri Jun 22, 2007 6:00 pm

I have installed the mod as instructed in the xml file, and it appears to have worked in the sense that there are no errors showing. I do not however show any users there and am having trouble finding the settings in the acp. please check out my board http://www.ifishct.com/phpBB3 and let me know what could be going on... Thanks
http://www.ifishct.com Fishing reports and information for Connecticut and the Northeast...

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 25431
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: [RC1] Visitors Today

Post by Paul » Fri Jun 22, 2007 6:23 pm

To fix the mysql that happens with mysql5 (For error see above) replace in includes/functions_visitors.php

Code: Select all

        FROM 
                ' . USERS_TABLE . ' u,
                ' . VISITORS_TABLE . ' v 
with

Code: Select all

        FROM (
                ' . USERS_TABLE . ' u,
                ' . VISITORS_TABLE . ' v )
around line 76.
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

elcochino6
Registered User
Posts: 22
Joined: Mon May 14, 2007 5:58 pm
Contact:

Re: [RC1] Visitors Today

Post by elcochino6 » Fri Jun 22, 2007 6:40 pm

i rechecked everything and tried again, but this time I got the error on line 82, I have uninstalled and backed up my database to a previous version, all seems to be back to normal, but I was unable to successfully get the mod working.
http://www.ifishct.com Fishing reports and information for Connecticut and the Northeast...

User avatar
Stitch625
Registered User
Posts: 683
Joined: Wed Jun 20, 2007 3:38 pm
Location: Michigan
Contact:

Re: [RC1] Visitors Today

Post by Stitch625 » Fri Jun 22, 2007 6:47 pm

freestyler,

You need to open up phpmyadmin. Hopefully you have it. Select your DB and click the button at the top that says SQL and a text area should appear. Just copy that query code into the box and click go. it will come back and let you know if everything went ok.

Good Luck

PS. You may have to change your db prefix in the query code to match your if it's different.

For example: My db tables prefix is phpbb3

so in other words

Code: Select all

INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_display_bots', '1', 1);
Becomes

Code: Select all

INSERT INTO `phpbb_3config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_display_bots', '1', 1);

Locked

Return to “[3.0.x] Abandoned MODs”