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?


All times are GMT. The time now is 09:58 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.01143 seconds
  • Memory Usage 1,741KB
  • 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
  • (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
  • (10)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