vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Administrative and Maintenance Tools - Private Messages & Email Log (https://vborg.vbsupport.ru/showthread.php?t=204562)

Vitaly 02-06-2009 10:00 PM

Private Messages & Email Log
 
1 Attachment(s)
Features:
  1. Log all PM and Emails, sent via forum forms.
  2. Keep logs in separate table with automatic rotation of old records.
  3. Add new menu items in topics and profiles for fast access.
  4. Have nice dynamic menus in search results for cross-searches
  5. Managed access for administrators (except superadmins)
How to install
  1. Upload files to your server
  2. Import product xml
  3. Go to ACP
  4. Select required settings in ?Vbulletin options → Private Message Log?
  5. 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 02-07-2009 06:04 PM

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

Vitaly 02-07-2009 06:30 PM

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 02-07-2009 10:53 PM

Nie mod thnx for share buddy :)

fariborz khan 02-07-2009 11:28 PM

installed ...thanks

ssslippy 02-09-2009 09:27 PM

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

Vitaly 02-09-2009 10:01 PM

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 02-10-2009 03:07 PM

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

DjEddie 02-10-2009 03:44 PM

Hi, im getting database errors on this since installing :

Code:

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 02-10-2009 04:11 PM

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 02-10-2009 04:12 PM

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 02-10-2009 04:25 PM

sorry message posted twice ..

Alexey? 02-10-2009 05:03 PM

This is good
tnaks
marked as installed

Vitaly 02-10-2009 05:13 PM

1 Attachment(s)
DjEddie, thaks for detailed bugreport.

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

DjEddie 02-10-2009 05:37 PM

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

Cheers

DjEddie 02-10-2009 09:25 PM

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

dmknights 02-11-2009 09:31 AM

Nice mod
*Installed*

Rene Kriest 02-11-2009 01:43 PM

Great addon. This is the perfect tool to stop troublemakers. Rarely needed but IF then you will love it
Quote:

Originally Posted by Vitaly (Post 1740003)
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 02-11-2009 02:23 PM

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 02-11-2009 10:12 PM

Quote:

Originally Posted by Vitaly (Post 1740003)
DjEddie, thaks for detailed bugreport.

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

Works correctly.. thanks for this fix :)

haxcommunity 02-12-2009 12:10 AM

-removed-

Vitaly 02-12-2009 08:23 AM

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

haxcommunity 02-12-2009 08:05 PM

Quote:

Originally Posted by Vitaly (Post 1741646)

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

andyh2 02-14-2009 04:45 PM

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

Vitaly 02-14-2009 05:05 PM

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

Vitaly 02-19-2009 02:38 AM

I've changed archive to contain fixed XML file from this post: https://vborg.vbsupport.ru/showpost....3&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 02-19-2009 05:47 PM

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.

Quote:

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 02-19-2009 06:22 PM

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

Wyzrd 02-20-2009 09:47 AM

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

Vitaly 02-20-2009 10:03 AM

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....3&postcount=14 .

Wyzrd 02-20-2009 02:48 PM

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 02-24-2009 06:41 PM

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

ssslippy 02-25-2009 07:44 PM

Quote:

Originally Posted by Vitaly (Post 1739110)
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 02-26-2009 10:55 AM

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 02-26-2009 11:04 AM

Quote:

Originally Posted by Andyrew (Post 1755108)
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 02-26-2009 11:19 AM

Quote:

Originally Posted by Vitaly (Post 1755115)
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 02-28-2009 10:03 PM

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 03-02-2009 02:22 PM

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

Vitaly 03-04-2009 11:52 AM

Quote:

Originally Posted by niteflyer32 (Post 1757213)
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

Quote:

Originally Posted by Darthvader2007 (Post 1758529)
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 03-04-2009 11:59 AM

Quote:

Originally Posted by Andyrew (Post 1755126)
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.

Quote:

Originally Posted by Andyrew (Post 1755126)
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:

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 :)


All times are GMT. The time now is 12:16 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01531 seconds
  • Memory Usage 1,829KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete