Version: 2.2, by Vitaly
Developer Last Online: Jul 2014
Category: Administrative and Maintenance Tools -
Version: 3.8.x
Rating:
Released: 02-06-2009
Last Update: 01-21-2010
Installs: 143
DB Changes Uses Plugins Auto-Templates
Re-useable Code Additional Files
No support by the author.
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
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
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.
Private Messages & Email Log Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
02-12-2009, 12:10 AM
