Userprofile Changed Date in Member Profile & recent changed on forumhome

<font size="4">Userprofile Changed Date - Version 1.03</font>

Hack: Userprofile Changed Date
Version: v1.03
Author: MarcoH64

Last tested on vB3.5.3, but should work on any 3.5.x

Features
- Show the time a User Profile was last updated in the Public Member Profile
- Show a list of the most recent members who have changed their profile on the forumhome page. Hovering over the username will show the time the profile was changed
- Set timelimit between edits before a member show in the recent changed list on forumhome again, to prevent 'Recent Change Spammers'
- As an update are counted changes in: Profile, Avatar, Profile Picture & Signature
- You can turn off updating the timestamps for any of these locations from your vB Options
- The format of the Last Changed date-time can be set in your vB Options.
- Choose to cutoff the list of Recent Changed profiles by either a maximum number of profiles, a timelimit (ie. changed in the last 24 hours) or both.

Changelog
12-2-2006 v1.03
- Added option to cutoff the list of changed profiles on the forumhome page based on a timelimit.
- In previous versions you had to enable/disable plugins, to change if a specific area of the userprofile
(ie Avatar, signature, ..) would be counted as an update. Now added new settings in the vB Options to control this.
- Added a date/time format to the Options. Now you can control how the Last Changed date is shown. Before a change have
effect, someone needs to update their profile since the formatted date/time is already stored in the datastore.

5-12-2005 v1.02
- Fixed bug where only the last change would show on forumhome

25-11-2005 v1.01
- Moved the core logic to functions loaded inside new Plugin
- Removed core logic from the other Plugins, making it easier to maintain code
- Fixed the Profile Pic Plugin
- Added new Plugin for Signature changes
23-11-2005 v1.00
- Initial Release

Notes
Copyright ©2005 MarcoH64
This Modification may not be redistributed in whole or significant part or changed without prior agreement of author.
Please don't forget to click Install.
If you like this work and would like to support the author, donations are always welcome at Paypal: Marcoh64 AT gmail.com

[Bhuwan]

Originally Posted by Sidewindr

Beuller... Beuller...???

Anyone reading this thread ?

Load up the XML code
search for:

, '" . $vbulletin->db->escape_string(serialize($latest_list)) . "'

REPLACE IT WITH:

, '" . $vbulletin->db->escape_string(serialize($latest_list)) . "','1'

[moonclamp]

Installed and working well. Thank You

One question (or request) I'm using the Extra Profile Fields Page Hack by Wired1 ... Is there an easy way to log updates for this too as I have most of the profile information on there?

[rolandogomez]

I've installed this, changed my profile signature to activate it, and as the validation screen passed from one page to another after the update, this briefly was in the header part of the scree, "Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of mh_upcd_set_changed(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /var/www/vhosts/glamour1.com/htdocs/forums/profile.php(1282) : eval()'d code on line "

Though it went back to the my home profile page after I changed it my signature, all seems to work well. I'm just curious if I get this errror message with a change, everyone else will too. Any ideas? Thanks, forum is at www.glamour1.com Thanks, rg.

[mikeclarke]

Originally Posted by Bhuwan

Load up the XML code
search for:

, '" . $vbulletin->db->escape_string(serialize($latest_list)) . "'

REPLACE IT WITH:

, '" . $vbulletin->db->escape_string(serialize($latest_list)) . "','1'

This fix worked for me on 3.6.1. Thanks very much

[criscokid]

I've loaded this mod on a vb3.6.4 board and made the change that Bhuwan suggested and is working ok. It didn't appear to be at first... after waiting about an hour 'changed usernames' are now starting to appear on forumhome.

[criscokid]

I've just upgraded a site to vB3.6.8 and when someone tries to update their profile photo the following error message is generated:

Database error in vBulletin 3.6.8:

Invalid SQL:
REPLACE INTO datastore
VALUES
( 'mh_upcd'
, 'a:50:{i:0;a:4:{s:6:\"userid\";s:1:\"1\";s:8:\"use rname\";s:4:\"Bart\";s:23:\"mh_upcd_lastprofilelis t\";i:1188841274;s:13:\"dateformatted\";s:21:\"M on 03 Sep 2007 18:41\";}i:1;a:4:{s:6:\"userid\";s:5:\"11446\";s:8 :\"username\";s:7:\"Opensky\";s:23:\"mh_upcd_lastp rofilelist\";s:10:\"1188672172\";s:13:\"dateformat ted\";s:21:\"Sat 01 Sep 2007 19:42\";}i:2;a:4:{s:6:\"userid\";s:5:\"11445\";s:8 :\"username\";s:15:\"seasonedclubber\";s:23:\"mh_u pcd_lastprofilelist\";s:10:\"1188659831\";s:13:\"d ateformatted\";s:21:\"Sat 01 Sep 2007 16:17\"; (rest of data snipped) }}'
);

MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Monday, September 3rd 2007 @ 06:41:15 PM
Script : http://xxx.com/forums/profile.php?do=updateprofilepic
Referrer : http://xxx.com/forums/profile.php?do=editprofilepic
Classname : vb_database

Does anyone know a fix for this?

[rayphua]

Nice work Marco, and nice fix Bhuwan. Working on 3.6.7 PL1

Am now worried if the problem Crisco posted will surface as well... Didn't try it yet though.

[criscokid]

Originally Posted by criscokid

I've just upgraded a site to vB3.6.8 and when someone tries to update their profile photo the following error message is generated:

Database error in vBulletin 3.6.8:

I couldn't find anything wrong... the plugin was identical to the one I used on another site that I'm an admin of, I even downloaded a fresh copy. Still no joy. Then I thought 'weel it's working on the other site...' so I logged on to that site, exported the plugin, and imported it on my newly upgraded site... and bingo! It's working.

[Marco van Herwaarden]

Originally Posted by criscokid

I've just upgraded a site to vB3.6.8 and when someone tries to update their profile photo the following error message is generated:

Database error in vBulletin 3.6.8:

Invalid SQL:
REPLACE INTO datastore
VALUES
( 'mh_upcd'
, 'a:50:{i:0;a:4:{s:6:\"userid\";s:1:\"1\";s:8:\"use rname\";s:4:\"Bart\";s:23:\"mh_upcd_lastprofilelis t\";i:1188841274;s:13:\"dateformatted\";s:21:\"M on 03 Sep 2007 18:41\";}i:1;a:4:{s:6:\"userid\";s:5:\"11446\";s:8 :\"username\";s:7:\"Opensky\";s:23:\"mh_upcd_lastp rofilelist\";s:10:\"1188672172\";s:13:\"dateformat ted\";s:21:\"Sat 01 Sep 2007 19:42\";}i:2;a:4:{s:6:\"userid\";s:5:\"11445\";s:8 :\"username\";s:15:\"seasonedclubber\";s:23:\"mh_u pcd_lastprofilelist\";s:10:\"1188659831\";s:13:\"d ateformatted\";s:21:\"Sat 01 Sep 2007 16:17\"; (rest of data snipped) }}'
&nbsp;

MySQL Error : Column count doesn't match value count at row 1
Error Number : 1136
Date : Monday, September 3rd 2007 @ 06:41:15 PM
Script : http://xxx.com/forums/profile.php?do=updateprofilepic
Referrer : http://xxx.com/forums/profile.php?do=editprofilepic
Classname : vb_database

Does anyone know a fix for this?

See https://vborg.vbsupport.ru/showpost....5&postcount=61

[2impulsiv]

Installed and working well with 3.6.8

Cheers.