vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Moderators Functions - PM Moderation (https://vborg.vbsupport.ru/showthread.php?t=118983)

pollon 03-07-2007 09:04 AM

HI.
I have installed this hack in 3.6.5. everithing looked fine but when i tried to "approve" the message from the admin cp i got this error message:
PHP Code:

Database error in vBulletin 3.6.5:

Invalid SQL:
SELECT iddatelinepmdetailsfromuseridfromusernametitlemessagerecipientsrecipients_bcc
            FROM moderation_pm
            WHERE id IN 
();

MySQL Error  You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3
Error Number 
1064
Date         
WednesdayMarch 7th 2007 11:41:26 AM
Script       
http://www.my-forum.com/forums/modcp/moderate_pm.php?do=update
Referrer     http://www.my-forum.com/forums/modcp/moderate_pm.php?do=list
IP Address   : -----------------
Username     :------------------------
Classname    vb_database 

and when i tried to "reject" the message i got this:

PHP Code:

Database error in vBulletin 3.6.5:

Invalid SQL:
DELETE FROM moderation_pm
            WHERE id IN 
();

MySQL Error  You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2
Error Number 
1064
Date         
WednesdayMarch 7th 2007 11:42:10 AM
Script       
http://www.my-forum.com/forums/modcp/moderate_pm.php?do=update
Referrer     http://www.my-forum.com/forums/modcp/moderate_pm.php?do=list
IP Address   : ----------------
Username     : ---------------
Classname    vb_database 

anyone can help me please?

Merjawy 03-08-2007 12:55 PM

Quote:

Originally Posted by BoYagoob (Post 1195475)
Yes, you can simply:
1. put the PHP file in the admincp folder
2. change the path of that file in XML file(s)


but I have one question: do you have the same problem that I have:
https://vborg.vbsupport.ru/showpost....4&postcount=85
?

Thanks, I'll try that

as for your question, I have not really tested it from a user's point but thats what I read in here

ORACLE 03-08-2007 09:57 PM

i was having a problem backing up my database because of this mod i kept getting errors.
the product would not install, because it said the table was unknown or that the was nor info in the table (empty). so i had to edit the product so it did not remove the table just the product but no i get a server error in phpmyadmin and vb backup so i can only think this is down to this table. can you tell me how i can force the deletion of this table???
thanks
ORACLE

Chadi 03-14-2007 04:21 PM

It seems like I get duplicates of pm's in the moderation queue. Today, there was about 10 of the same pm, and I'm 100% sure the sender did not accidentally press send 10 times. Anyone know of a fix?

Chadi 03-15-2007 10:34 PM

I hope someone else (coder) can take over this hack and implement these features:

- apply moderation to certain usergroups only
- mass approve / disapprove check box
- ajax preview (tooltip / hover over icon??)

OTTIX 03-23-2007 12:31 PM

Hi, why the welcome pn does not arrive to the member, when i aprove the pn from my admin account.

thanks

Apocalypz 03-23-2007 04:33 PM

I installed the code for version 3.6.5 and it does not show up when I click on moderation or vbulletin options...any help?

OTTIX 03-23-2007 07:46 PM

Hi, why the welcome pn does not arrive to the member, when i aprove the pn from my admin account.

thanks

added;
I see that ther is no Reiceipt in the personal message. (The field "Receipt(s)" is empty)

OTTIX 04-04-2007 08:14 AM

Hi, why the welcome pn does not arrive to the member, when i aprove the pn from my admin account.

thanks

added;
I see that ther is no Reiceipt in the personal message. (The field "Receipt(s)" is empty)

please help :-)

COBRAws 04-07-2007 06:36 PM

Quote:

Originally Posted by chadi (Post 1203406)
It seems like I get duplicates of pm's in the moderation queue. Today, there was about 10 of the same pm, and I'm 100% sure the sender did not accidentally press send 10 times. Anyone know of a fix?

Thats because no "your PM has been sent to XXX" is shown to the user, and he believes that the PM was not sent, so he writes it again and send it.

The truth is that the pm was sent, but this Filter does not tell the user that it was sent.


All times are GMT. The time now is 09:15 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.02168 seconds
  • Memory Usage 1,749KB
  • 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
  • (2)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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