Private Messages & Email Log

[Vitaly]

Features:
Log all PM and Emails, sent via forum forms.
Keep logs in separate table with automatic rotation of old records.
Add new menu items in topics and profiles for fast access.
Have nice dynamic menus in search results for cross-searches
Managed access for administrators (except superadmins)How to install
Upload files to your server
Import product xml
Go to ACP
Select required settings in ?Vbulletin options → Private Message Log?
Set access ?Can view PM logs? to necessary members in ?Usergroups → Administator Permissions?. Super administrators can be skipped.Notes:

This mod uses full scan for text searches, that can affect SQL-server load at really big boards. Fulltext indexes are not used intentionally, because whose can't produce sharp results and not compatible with innodb. I suppose, that if you really need this mod, you know exactly, what are you doing and what are you going to search. In my practice, ONLY exact matches were useful.

One of tradeoff to reduce SQL-server load ? make log size shorter (1-2 months instead of 6). When vB 4.0 provides refactored search framework, search method can be rewritten.

If you install this mod on your server, i recommend to clarify forum rules, and add text, that your project doesn't provide the ways of confidential communication ? only public and non public.

PS. This mod is independent. Since could't find one, that satisfy my requirements to functionality and usability, the new one was done from scratch. Code is reuseable. If you can do things better - i'll be glad to install your branch and spend my efforts to another things :)

PPS. Should work with 3.7.x (checked at 3.7.4)

This mod is developped here http://github.com/rcdesign/vb-pm_log . Patches are welcome.

history

2.2
- Redesigned database to improve search/paging in some cases
- Should fix conflicts with other mods, that where reported in this threads
- Sources repo is now @ github

... (not public)

1.9
- Ups... another broken link (from message list to user profiles)
- Fixed access for non superadmins, who had "Read PM Log" privilegies.

1.8
- fixed broken link in ACP popup menu
- workaround to show smiles and bbcodes

1.7
- fixed some sql-error

1.6
- first public release

[Libby]

Can you make quoted text also availaible, please?
The path to the smilies is not correct (admincp/images/smilies)

[Vitaly]

Thanks for note about smiles. I'll check, what can be done with relative paths.

About quote - don't know yet. Those were not deleted intentionally, but parcer for APC-executed scripts eliminates bbcode. I've checked, the same parcer call on general pages produces correct results. And other similar products also delete quotes. Need time to investigate.

[letsjoy]

Nie mod thnx for share buddy :)

[fariborz khan]

installed ...thanks

[ssslippy]

Anyway to make this save already sent pm's that are in people's boxes?

[Vitaly]

Separate convertor should be implemented and that conflicts to my principles. If you didn't annonced, that admin can read user's pm, it's impolite to collect previous messages :)

You can try this mod https://vborg.vbsupport.ru/showthread.php?t=123166

[haxcommunity]

I really needed this due to a situation on my site. Thanks so much!

[DjEddie]

Hi, im getting database errors on this since installing :


Database error in vBulletin 3.8.0:

Invalid SQL:

REPLACE INTO
`rcd_log_pm`
SET
`pmid` = 41716,
`pmtextid` = 2909,
`fromuserip` = '*******',
`fromuserid` = 12447,
`fromusername` = '******',
`fromuseremail` = '******',
`touserid` = 12447,
`tousername` = 'RudeX',
`touseremail` = '******',
`title` = '******',
`message` = '******',
`iconid` = ,
`dateline` = 1234284034,
`showsignature` = ,
`allowsmilie` = 1;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
`dateline` = 1234284034,
`showsignature` = ,
`allow' at line 15
Error Number : 1064
Request Date : Tuesday, February 10th 2009 @ 04:40:34 PM
Error Date : Tuesday, February 10th 2009 @ 04:40:34 PM
Script : ******/register.php?a=act&u=12447&i=123fffc9f5ae95e349821df6cc49d3efabb2b68c
Referrer : ******
IP Address : ******
Username : ******
Classname : vB_Database
MySQL Version :


This Error comes when a new member has just signed up and received a welcome PM

Any Ideas? ... i've disabled the mod for now.

Thank you :)

[Vitaly]

Thanks for report.

1. Is it a sigle error, or constantly repeats with any try to sent pm (even after registration)?

2. Is pm sent via some addon or via standard vb feature?

[DjEddie]

Hi,

Its only on the Welcome PM that comes standard with vb, I don't get any other db error emails about your mod ... just the one after registration :)

Thanks Vitaly :)

[DjEddie]

sorry message posted twice ..

[Alexey?]

This is good
tnaks
marked as installed

[Vitaly]

DjEddie, thaks for detailed bugreport.

Try update to attached XML. Uploaded files were not changed.

[DjEddie]

No Worries and Thanks Vitaly, imported now, will let you know either way if any problems over next soo long :)

Cheers

[DjEddie]

Working Perfect now... no problems ... thanx Vitaly :)

[dmknights]

Nice mod
*Installed*

[Rene Kriest]

Great addon. This is the perfect tool to stop troublemakers. Rarely needed but IF then you will love it
DjEddie, thaks for detailed bugreport.

Try update to attached XML. Uploaded files were not changed.
Did you include this file already in PM 1.6?

[Vitaly]

Not yet. If you don't use "registration autopm", that doesn't make a sense. Mod works 2 months at my production site sinse migrated to vB, with no problems.

Update will be in 1-4 weeks. That depends, if new changes will be added or not. Have some ideas to improve usability even more.

[Namaless]

DjEddie, thaks for detailed bugreport.

Try update to attached XML. Uploaded files were not changed.
Works correctly.. thanks for this fix :)

[haxcommunity]

-removed-

[Vitaly]

<a href="https://vborg.vbsupport.ru/showpost.php?p=1740003&postcount=14" target="_blank">https://vborg.vbsupport.ru/showp...3&postcount=14</a>

[haxcommunity]

https://vborg.vbsupport.ru/showpost.php?p=1740003&postcount=14

I apologize, I hadn't seen that post until after I had posted, thank you.

[andyh2]

Is there a way to get this to grab old PMs before I installed this mod?

[Vitaly]

<a href="https://vborg.vbsupport.ru/showpost.php?p=1739110&postcount=7" target="_blank">https://vborg.vbsupport.ru/showp...10&postcount=7</a>

[Vitaly]

I've changed archive to contain fixed XML file from this post: https://vborg.vbsupport.ru/showpost.php?p=1740003&postcount=14

Next version is a bit delayed. Planned to add time filter for search, because it's a typical use case: to check messages only for last 7-60 days.

[Wyzrd]

I'm having a error myself.

I tried installing Cyb - Paypal Donate System. Everytime you try to donate money. It takes you to a page where you select how much to donate. Then when you click donate. This error happens.

Database error in vBulletin 3.8.1:

Invalid SQL:

REPLACE INTO
`rcd_log_pm`
SET
`pmid` = 94,
`pmtextid` = 70,
`fromuserip` = '',
`fromuserid` = 1,
`fromusername` = 'Wyzrd',
`fromuseremail` = '',
`touserid` = 1,
`tousername` = 'Wyzrd',
`touseremail` = '',
`title` = 'Your donation will be checked',
`message` = 'Dear Wyzrd,\r\n \r\n We have noticed that you haved used our PayPal Donation System on 19-02-09, 14:43.\r\n Your donation will be checked and you\'ll receive another PM if/when it\'s confirmed.\r\n \r\n Best Regards,\r\n \r\n The Forum Team',
`iconid` = ,
`dateline` = 1235072626,
`showsignature` = ,
`allowsmilie` =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
`dateline` = 1235072626,
`showsignature` = ,
`allow' at line 15
Error Number : 1064
Request Date : Thursday, February 19th 2009 @ 01:43:46 PM
Error Date : Thursday, February 19th 2009 @ 01:43:46 PM
Script : http://rap-underground.com/forums/misc.php?do=dodonate
Referrer : http://rap-underground.com/forums/misc.php?do=donate
IP Address : 69.142.46.55
Username : Wyzrd
Classname : vB_Database
MySQL Version : 5.0.67-community

I removed my email and ip from the above mentioned database error.

I disabled the Pm Logs and now the Paypal Donate works.

[Vitaly]

Have you read previous posts? Do you have fixed PM Logs or not?

[Wyzrd]

I did download the fixed pm logs and uploaded it over the old one. I still have the error.

[Vitaly]

Have you reimported product? Only XML file was updated. Your error looks exactly as with not fixed product.

Try to reimport XML from this post https://vborg.vbsupport.ru/showpost.php?p=1740003&postcount=14 .

[Wyzrd]

I downloaded it again, and re-imported again, this time though it seemed to fix the problem. Thanks Vitaly. Great mod by the way.

[Satjunkies4life]

Any way to get this only available to the super-Admin and not regular administrators?

[ssslippy]

Separate convertor should be implemented and that conflicts to my principles. If you didn't annonced, that admin can read user's pm, it's impolite to collect previous messages :)

You can try this mod https://vborg.vbsupport.ru/showthread.php?t=123166

You could always read previous sent PM's as long as they are in the database still. They are stored in plain text. An importer for previous PM's still in the database would be appreciated if you have free time.

[Andyrew]

Is the log erased after the Logs keeping time (days) number or should we have a way of deleting the log at any time.

[Vitaly]

Is the log erased after the Logs keeping time (days) number or should we have a way of deleting the log at any time.

I don't understand your question. All log records, older than defined count of days, are deleted automatically.

If you wish to delete all - you can uninstall mod, and log table will be destroyed.

[Andyrew]

All log records, older than defined count of days, are deleted automatically.


That's what i was wanting to know, :up: but would be good if we had a way to manually delete the log at any time like a prune feature.
Also when viewing the log we have the option to click on a username to view profile, the link is wrong for my forums as i use www.myforum.com/forums/ and /forums is missing from your link so i get page not found error. :confused:

[niteflyer32]

Thank you for the mod. 3.8.1 here

1 question please. I'm a superadmin and don't see the setting in Admin usergroup to allow viewing PMs for admins.

Thanks

[Darthvader2007]

Can i also delete PM message with this mod ?
Of not, will there be some option in the future ?

[Vitaly]

1 question please. I'm a superadmin and don't see the setting in Admin usergroup to allow viewing PMs for admins.Thanks

You have to set admin permissions first, as described in setup instructions.

Usergroups → Administator Permissions → Can view PM logs

Can i also delete PM message with this mod ?
Of not, will there be some option in the future ?

Sorry, no. This mod is not for PM management.

[Vitaly]

That's what i was wanting to know, :up: but would be good if we had a way to manually delete the log at any time like a prune feature.

Personaly, I don't see reason to add such feature. That's qute specific use-case. As wokraround, you can set prune time to 0 and run clearing task manually. Though, I don't understand situation, why you can need to prune log table but keep mod installed.

Also when viewing the log we have the option to click on a username to view profile, the link is wrong for my forums as i use www.myforum.com/forums/ (http://www.myforum.com/forums/) and /forums is missing from your link so i get page not found error. :confused:

Try new version.

What's new:
Fixed some links
Workaround to show smiles, quotes and so on.PS. Everybody welcome to fix my horrible english in that mod :)

[Andyrew]

Like the new layout when viewing messages, :up: link to view profile page when clicking a user name is still wrong.

myforum.com/forums/admincp/member.php?u=100

Should be

myforum.com/forums/member.php?u=100

[odln018]

I'm having something odd, I cannot seem to find where to set permissions to allow the administrators access to this.

Thanks for any help!

[Vitaly]

Like the new layout when viewing messages, :up: link to view profile page when clicking a user name is still wrong.

Ups... fixed too much :)

Try this one

[dklassen]

deleted

[dklassen]

Will this work in 3.7.3? It installed fine, I set the permissions but it's not showing up under "users" in admin CP.

The link does show up in the user profile but it get's this error.

Not Found
The requested document was not found on this server.

[Vitaly]

Looks like you've imported XML but didn't uploaded files. No ideas about 3.7.3.

[Vitaly]

New version uploaded, that fixes 2 bugs:

- Аnother broken link (from message list to user profiles). Sorry :( , added in previous version.
- Fixed access for non superadmins, who had "Read PM Log" privilegies. Those could not see mod links in menu & profiles, and could not read message texts.

[Andyrew]

All my users are seeing this since updated.

Fatal error: Call to undefined function can_administer_log() in /xxxxx/xxxxxx/xxxxx/forums/includes/class_postbit.php(294) : eval()'d code on line 227

have had to disable mod.

[Vitaly]

Hmm... some additional mod conflicts? Don see any errors in my logs.

Try to edit global_start hook in this mod.

Change
if ($vbulletin->options['rcd_pm_log_show_link']
AND ( THIS_SCRIPT == 'misc'
OR THIS_SCRIPT == 'member'
OR THIS_SCRIPT == 'showthread'
OR THIS_SCRIPT == 'rcd_pm_log'))for

if ($vbulletin->options['rcd_pm_log_show_link'] )

Or just for

if (true)

if doesn't helps.

[Andyrew]

Not sure if i ticked Allow Overwrite when updating, could this have caused it. ?

I don't see any errors, only my users see errors. i will try a fresh install first before edits.

[Vitaly]

Make sure, that you've uploaded file & imported XML with "allow override" settings. Other upgrate methods can produce inpredictable results.

If problem exists - tell me exactly, at wich page and wich actions and try changes above.

May be there are some mistakes, but i don't see FATAL problems at my server, right now 500 users online.

[Andyrew]

Only works if i do last code change.if (true)

Otherwise whenever a user clicks on a thread it gives the error as before.

[Vitaly]

Thanks for info. Very-very strange. No ideas for now.

Are links in menus & ACP now ok?

[SnowBot]

OK when updating all my users get 500 internal server error.....

I overwritten xml and files.

[Andyrew]

Thanks for info. Very-very strange. No ideas for now.

Are links in menus & ACP now ok?

Yes links work ok. :up:

[odln018]

When I try to uninstall this, I get this stuck in the admincp sidebar.

"*[rcd_pm_log]*", how can I uninstall, and have all traces removed?

[Andyrew]

When I try to uninstall this, I get this stuck in the admincp sidebar.

"*[rcd_pm_log]*", how can I uninstall, and have all traces removed?

Remove the files you uploaded with this mod.

[SnowBot]

still not working, any fix yet ?

[Vitaly]

<a href="https://vborg.vbsupport.ru/showpost.php?p=1765152&postcount=49" target="_blank">https://vborg.vbsupport.ru/showp...2&postcount=49</a>

[SnowBot]

I changed that and it still didnt work.

version 1.7 & 1.8 worked apart from the links BUT 1.9 gives users errors when trying to read a post BUT the admin works fine.

[rmxs]

suggestion :)
Latest xxx PMS..

a button that you set a number a display xxx latest pms.

Works very good

[Vitaly]

I have plans to make filter "search for last XX days", because most actual searches are for last 30-60 days. That will speed up requests.

But have now more urgent products in tail. So, next major release will be only after 1-2 months. At least, current version works and is much better than nothing :)

[rmxs]

Hello i thinks you have to make a template for read pms..
Now i got white page with the pm :(

[Almotmaiz.Net]

thanks for this sharing..

this is arabic lang. pack, for 1.9 version

enjoy !

[MindStar]

To add a "tool tip" showing the contents of a PM in the PM Log List screen, change line 280 in admincp/rcd_pm_log.php to

$row[] = "<a target=\"_blank\" href=\"" . $vbulletin->options['bburl'] . "/misc.php?" . $vbulletin->session->vars['sessionurl'] . "do=showpm&logid=" . $pm['logid'] . "\" title=\"" . strip_tags($pm['message']) . "\">" . $pm['title'] . "</a>";
The extra code is . "\" title=\"" . strip_tags($pm['message'])The $pm['message'] information has already been obtained from the SQL query used to get the list of logged PMs, so the only overhead is the additional HTML code to add the contents of the PM to each log entry displayed in the AdminCP.

This saves having to open the PM in a new window if you are just having a quick check to see what the logged PM says. BBCode and Images are not rendered, you have to click on the link to read the logged PM with all the BBCode formatting, etc.

[Vitaly]

May be...

Thanks

If anyone has time to implement full-featured ajax popup instead of simple tooltips, I could include it in next release.

[down.low]

I had to uninstall this mod because I got this error whenever I tried to open any threads at all:

Fatal error: Call to undefined function can_administer_pm_log() in /*****/*****/*****/*****/forums/includes/class_postbit.php(294) : eval()'d code on line 284Any idea what's wrong and how to fix this problem? I have 3.8 vbulletin.

[Moshe1010]

I had to uninstall this mod because I got this error whenever I tried to open any threads at all:

Fatal error: Call to undefined function can_administer_pm_log() in /*****/*****/*****/*****/forums/includes/class_postbit.php(294) : eval()'d code on line 284Any idea what's wrong and how to fix this problem? I have 3.8 vbulletin.

I got this too

Fatal error: Call to undefined function can_administer_pm_log() in *****/public_html/includes/class_postbit.php(294) : eval()'d code on line 77

[down.low]

No support for this product I take it?

[Vitaly]

<a href="https://vborg.vbsupport.ru/showpost.php?p=1765152&postcount=49" target="_blank">https://vborg.vbsupport.ru/showp...2&postcount=49</a>

Please, read previous posts prior to ask questions.

[down.low]

https://vborg.vbsupport.ru/showpost.php?p=1765152&postcount=49

Please, read previous posts prior to ask questions.


Being that it was an error on a different line in your code,-then the other persons post- I would think to just ask you instead of jumping to conclusions and messing it up even more then it already is. If someone's error code doesn't match mine exactly- I'm not just gonna go fiddling around- especially when the first result of your mod when no one at all being able to open a thread- me jumping to conclusions (just because) could've killed the whole site- all from one assumption. So being that the errors are different from one another, should I still do what was previously suggested for someone different?

[down.low]

I read every post before asking for help- even if there's 50, have done it before so trust reading the 5 little pages in this thread wasn't a problem.

[Sonic625]

Is it possible to log only PM that use triggered keywords?

Example. If I want to log all PMs that talk about planes, so if a PM has the word plane or aircraft (etc) in it it would log it and exclude the rest.

[Vitaly]

No.

[ijob]

I have an uncached template warning

[Vitaly]

Where? Details required.

[wolfstream]

I got this too
Me 3, it's an epidemic
https://vborg.vbsupport.ru/showpost.php?p=1765152&postcount=49

Please, read previous posts prior to ask questions.


Please, actually fix your problems instead of getting pissy with people who shouldn't have to code for you. It's amazing how many "developers" will try to pull this "read previous posts" instead of fixing their own errors

* wolfstream uninstalls product because it doesn't work properly

[megroup]

Hello,

I'm running 3.8.2 version and just installed your mod.
All users except SuperAdmin are getting HTTP ERROR 500 when they are trying to view any thread.

[megroup]

I'm also getting DB error message:

Database error in vBulletin 3.8.2:

Invalid SQL:

SELECT
COUNT( * ) AS `Count`
FROM
`forum_rcd_log_pm` AS PM;

MySQL Error : Table 'forum_my.forum_rcd_log_pm' doesn't exist
Error Number : 1146

[geni57]

Works GREAT

[P?ŋĭsЋ?я]

Thanks İnstalled:up:

[geni57]

Uninstalled admins can use but when regular users try to view a post, it gives them a data base error.

NEEDS work

[wolfstream]

Exactly, this needs a lot of work here

[thetgc]

great mod :)

how could i add a page in between clicking on PM Log and viewing the logs itself... say a page that says 'Are you sure you want to view the log? [yes][no]'???

Would be great if this could be coded :)

Also, would it be possible for you to add a delete pms feature? i know it maybe inpolite but some people mass pm users with sh*t...

[Leo Brazil]

Someone tested on 4.0 ?

[Pandemikk]

"Sorry, you don't have permission to access the administrative controls on this page.

If you need to access this page, ask your lead administrator to enable your permissions for this page using the Administrator Permissions section of the control panel."

The link there is 404. Also, I'm the super admin member number 1 on my forum.. Why am I getting this error message?

[Vitaly]

I've updated mod. Latest version should fix conflicts, reported by some members. Hm.... at least it works at my production site :)

[alloutvb]

hummm not working for me this is what i get when i click on the pm log link in the admin cp under users http://www.***.com/admincp/index.php?loc=plugin.php%3Fdo%3Dproduct

[Vitaly]

Sorry, I don't understand your bug description. Did you uploaded files prior to import XML?

[alloutvb]

i uploaded them before i imported the xml

[Vitaly]

Please, provide more details of what you are doing (with links), and what errors you get. I have very weak telepathy skills. Also, tell if you upgraded or it was new install.

[KEKforce]

Great Mod!

Will there be a VB4 version?

[Vitaly]

It will, in 2-3 months.

[Dr.LoVe]

There is no log all Emails

where can i find it ?

[FractalizeR]

Any news about 4.0 version?

[R0L3X]

Great Mod!

How can I use my style on pm vieuw page/misc.php... ?

[Pandemikk]

Clientscript and cpstyles are being looked for at public_html/directory instead of public_html/root_forum/directory

A bit annoying when checking my error logs.

[dearinfinity]

hi, any update on version 4.0?

[Vitaly]

~1 month. It's better to track changes here http://github.com/rcdesign

[alfanexus]

Looking forward to 4.0 version :)

[Mike-D]

This mod is developped here http://github.com/rcdesign/vb-pm_logJust a side note: You know that everyone can Download all Files at the above Link which have been published here at vBOrg?

[Vitaly]

Hmm... do you know another secret reason to give link and prohibit downloads :) ?

That's a public repository for developpers.

[penuch]

Still no version for 4?

[Hostboard]

Still no version for 4?

See post #99 :rolleyes:

[FractalizeR]

There is nothing in GIT repository about v4 version. Vitaly, are you still developing it?

[Vitaly]

http://github.com/rcdesign

Look for global log & my profile @ this forum. I can't convert all at once, but progress goes. This mod will be available in several weeks. Can't give you exact date.

PS. And of cause, anyone can help with converting :)

[burakdulgar]

Nice mod, thnx :)

[SKY9999]

THANKS :)