Last Visit / Dead User Admin Module Version 3.0

Posted: Mon May 10, 2004 7:56 pm

Last Visit Version 3.0
Last Visit is an administrative module for PHP-Nuke which enables advanced user management capabilities for website administrators. Last Visit allows ease of identification and termination of inactive (dead) members and provides valuable statistical information in an easy to use layout.

If you're familiar with the costs of bandwidth and webspace you may already see the true value of this module.
Every member of your site requires bandwidth and space. Every dead member is money out of your pocket in more than one way. The ability to identify and remove the dead memberships from your database makes this module one of your website's most powerful and valuable tools. How many other modules pay for themselves over and over again?

With that said, here is a list of some of the features that Last Visit Version 3.0 has ...

Updates/upgrades/fixes/support
Database table installer
User friendly design
Detailed legend
Hide description and legend
Hide settings
Measure activity status in hour, day, week, or month increments
Sort member list according to activity status
Set limit on number of members to list
Jump to member
Fetch member
Canned warning messages
Choose default warning message
Create, save, edit, or delete canned warning messages
IP logging
IP query
Edit member info
Registration date
Last visit date
Last visit time
# of page hits for member
Pages visited by member
Clear member tracking list
Warn individual members
Terminate individual members
Reset individual member stats
Suspend membership
Allow member access
Color coded activity status
Color coded warning status
Display only no-shows (new members that never log in)
Terminate no-shows
Warn all no-shows
Mass warn groups
Mass terminate groups
Reset all member hits
Clear all member tracking lists
Backup database
Various page statistics
and more to come...

Get it here!

- Prophet

Posted: Thu May 13, 2004 8:23 am

Thx m8
I was searching this for a while

Posted: Sat May 15, 2004 1:36 pm

New version released 4-15-04 fixes broken image. If you downloaded this module prior to that date, please update.

- Prophet

Nuke Soldier Joined: Jun 08, 2003 Posts: 30

I installed as per instructions on a nuke6.5 site and get a "page not found" error when I clcik on the Last Visit admin icon and it tries to take me to "/admin.php?op=LastVisitAdmin".

I downloaded the zip from your site today so it should be the latest.

Any ideas?

Posted: Mon May 17, 2004 9:26 am

Be sure the admin/case files were uploaded.
Try entering the module address into the browser address bar to be sure the module was installed correctly and is functioning (bypass the link).
Also, go to your Admin Preferences and be sure there is no /forward slash/ on the end of your Site URL.
I had someone test the module for me in Nuke 6.5 and it worked.

Let me know.

- Prophet

Nuke Soldier Joined: Jun 08, 2003 Posts: 30

Case, link and module files were all uploaded from the archive.

There is no forward slash in my preferences/Site URL.

When I click the icon or type in the URL (mysite.com/admin.php?op=LastVisitAdmin) it thinks for a couple of seconds then gives the "page cannot be displayed" message. This is a first install on a site with approx. 4 thousand members.

All 6.5 patches/sec-fixes are applied to this site.

Posted: Mon May 17, 2004 3:23 pm

I'm not sure what the problem is at this point. It is difficult for me to determine where the error is created when I cannot duplicate it. I'm somewhat new to PHP and Nuke and have never worked with version 6.5. However, I have been able to resolve some compatibility issues with 6.5 just through experimentation. I will continue to work towards making this module compatible with more Nuke versions. I am also currently working on a way to limit the list number for sites like yours that have thousands of members ... this in itself may resolve some potential problems. I will keep trying to find an answer to your problem with the module.

If anyone else experiences the same problem (or another), let me know so I can fix it.

If anyone else has the answer, post it.

- Prophet

Posted: Mon May 17, 2004 8:33 pm

New Version available for download.

- Prophet

Nuke Cadet Joined: Sep 02, 2003 Posts: 9

Was about to post that this didn't work with version 7 as it wasn't logging any of the user data even after being installed for 2 days. Installed the new version of it and it is now logging data for users, limit record option is a nice touch as it was taking ages to load 3000 members.

Another option that would be nice is the ability to alter the trigger levels so you don't have ot wait for 90days from dead users to be flagged. This would be really handy for when you first install it if you know you are carrying loads of dead accounts. Guess I could just alter them myself but I'm lazy.

Nice work!!

Nuke Soldier Joined: Jun 08, 2003 Posts: 30

Thanks prophet! Your last update works fine on my Nuke6.5 site. Must have been the # of users?

Posted: Tue May 18, 2004 4:15 pm

Ronin,
Excellent! I am happy to hear that it's working for you now! I made a number of changes to the code that may help solve potential issues. The list limit was a much needed addition to the module.
Thanks for your helpful comments! Very Happy

- Prophet

Posted: Tue May 18, 2004 5:20 pm

Macwedd wrote:

Another option that would be nice is the ability to alter the trigger levels so you don't have ot wait for 90days from dead users to be flagged. This would be really handy for when you first install it if you know you are carrying loads of dead accounts. Guess I could just alter them myself but I'm lazy.

Nice work!!

Macwedd, thanks for the comments!
Actually, you will begin to see results 30 days after installation. You can consider a member to be "dead" at 30 days if you want. I just figured it's reasonable to assume that after 90 days of inactivity chances are slim that a member will return.

Best regards!

- Prophet

Posted: Tue May 18, 2004 7:02 pm

Good module Prophet, lets see how it runs on 6.0, I have some of those versions running as well, so Ill keep ya posted.

Posted: Tue May 18, 2004 7:22 pm

Thanks Allevon, I appreciate your feedback!
I imagine there are many people (like me) that will be happy to reclaim some of that wasted database and disk space taken up by dead members. I believe this to be a valuable admin tool. I would like to make it usable for as many as possible.

Keep me posted on the Nuke version tests.

Best regards,

- Prophet

Nuke Soldier Joined: Dec 20, 2003 Posts: 16

I guess you can't install this on v7.0 phpnuke?

I can't get pass the SQL query

Quote:

Error

SQL-query :

INSERT INTO `nuke_warn_mail`
VALUES ( 1, 'Hello [recipient name]: \r\nThis email is to inform you that your account at [sitename] may soon be terminated due to inactivity. To avoid account cancellation simply login to your account at [site url]\r\n\r\nWe value our members and hope that you will continue to be one.\r\n\r\nBest regards,\r\n [sitename] Staff\r\n', '[sitename] Account Cancellation Notice', '0' )

MySQL said:

#1136 - Column count doesn't match value count at row 1

I manually sql query'd the below that worked
---------
DROP TABLE IF EXISTS `nuke_warn_mail`;
CREATE TABLE `nuke_warn_mail` (
`wid` int(11) NOT NULL auto_increment,
`body` text NOT NULL,
`subject` varchar(255) NOT NULL default '',
`exp` char(1) NOT NULL default '0',
`sorta` char(10) NOT NULL default '0',
`sortb` char(10) NOT NULL default '100',
PRIMARY KEY (`wid`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
---------

When i enter this line manually is where the errors come from, but i dont know what / how / if it can be fixed.

--------
INSERT INTO `nuke_warn_mail` VALUES (1, 'Hello [recipient name]: \r\nThis email is to inform you that your account at [sitename] may soon be terminated due to inactivity. To avoid account cancellation simply login to your account at [site url]\r\n\r\nWe value our members and hope that you will continue to be one.\r\n\r\nBest regards,\r\n [sitename] Staff\r\n', '[sitename] Account Cancellation Notice', '0');
--------

So i skipped that step and finished the rest and in the admin area for last visit i get this

Quote:

User ID User IP Username Last Visit Page Hits Action

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/evergame/public_html/includes/sql_layer.php on line 286

Page Stats

Total number of users over 30 days since last visit: 0
Total number of users over 60 days since last visit: 0
Total number of dead users (over 90 days since last visit): 0
Total number of active users less than 30 days: 0
Total number of active warning flags: 0

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/evergame/public_html/includes/sql_layer.php on line 286
Total number of user hits:
Total number of users: 13351

If you can help get this working for my phpnuke 7.0 please post ^^ thx