vb.org Archive
Page 3 of 6 12 3 45 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Add-On Releases - DownloadsII PM moderation notification Add-On (https://vborg.vbsupport.ru/showthread.php?t=130536)

CyberRanger 03-12-2007 04:25 PM
Quote:
Originally Posted by joeldaviddc (Post 1201629)
anybody can help me ???
Sorry for the slow replies. Lots of RL work keeping me tied up. I'll get an update out tomorrow to fix your problem and see if I can add more options for who gets the PM's.

In the meantime, if you'd like to fix the error yourself:

In the plugins "Alert Mods to Edited File in Moderation" and "Alert Mods to New File in Moderation",

FIND:
PHP Code:
$result = $db->query_read("SELECT title, usergroup.usergroupid, username, userid
               FROM " . TABLE_PREFIX . "usergroup, " . TABLE_PREFIX . "user
                           WHERE ecdownloadpermissions & 1024 AND  usergroup.usergroupid = user.usergroupid
            "); 
CHANGE TO:
PHP Code:
$result = $db->query_read("SELECT title, " . TABLE_PREFIX . "usergroup.usergroupid, username, userid
               FROM " . TABLE_PREFIX . "usergroup, " . TABLE_PREFIX . "user
                           WHERE ecdownloadpermissions & 1024 AND  " . TABLE_PREFIX . "usergroup.usergroupid = " . TABLE_PREFIX . "user.usergroupid
            "); 

joeldaviddc 03-12-2007 05:02 PM
thanks for your reply cyberranger.

I have made the changes you tell me, but i still receive a database error, finally i have changed a little bit your code to this

PHP Code:
$result = $db->query_read("SELECT title, vb_usergroup.usergroupid, username, userid
   FROM " . TABLE_PREFIX . "usergroup, " . TABLE_PREFIX . "user
                           WHERE ecdownloadpermissions & 1024 AND  " . TABLE_PREFIX . "usergroup.usergroupid = " . TABLE_PREFIX . "user.usergroupid
"); 
(my table prefix is vb_ , and i have added before the select for usergroup.usergroupid )

and now is working fine,

thanks a lot...

CyberRanger 03-12-2007 05:10 PM
Quote:
Originally Posted by joeldaviddc (Post 1201734)
(my table prefix is vb_ , and i have added before the select for usergroup.usergroupid )

and now is working fine,

thanks a lot...
Ah, right, thanks! Sorry I missed that spot.

Black Tiger 08-13-2007 09:36 PM
Can my request from message #14 also be temporarily made by hacking a template or file? If yes, which code should i use?

CyberRanger 08-27-2007 03:00 AM
Quote:
Originally Posted by Black Tiger (Post 1117234)
Nice hack. Coul'd there be a feature made so admin can decide who get's a pm? For example if you just want die admin to get a pm and not other people which can manage the moderation queu?
There are two plugins that control sending the PM's: "Alert Mods to Edited File in Moderation" and "Alert Mods to New File in Moderation" In both, the sql that selects the users to send the PM to is:
PHP Code:
$result = $db->query_read("SELECT title, usergroup.usergroupid, username, userid
               FROM " . TABLE_PREFIX . "usergroup, " . TABLE_PREFIX . "user
                           WHERE ecdownloadpermissions & 1024 AND  usergroup.usergroupid = user.usergroupid
            "); 
You could easily change the WHERE clause to get a different set of users. For example, to have the PM sent to the admin group, change the query to:
PHP Code:
$result = $db->query_read("SELECT title, usergroup.usergroupid, username, userid
               FROM " . TABLE_PREFIX . "usergroup, " . TABLE_PREFIX . "user
                           WHERE usergroup.usergroupid = 6
            "); 

AScherff 08-27-2007 07:23 AM
Quote:
Originally Posted by CyberRanger (Post 1201692)
In the meantime, if you'd like to fix the error yourself:

In the plugins "Alert Mods to Edited File in Moderation" and "Alert Mods to New File in Moderation",
I have had the same problems and thought that was an error in DLII and contacted Jelle...

He gave me the hint to have a look here :-)

Black Tiger 08-27-2007 11:44 AM
@Cyberranger: Thanks very much! I will change it to admin only.

Black Tiger 09-08-2007 11:16 PM
Found another question.:)
Quote:
WHERE usergroup.usergroupid = 6
Could there also be made a change to have just 1 user receive the pm's?
Maybe change this to WHERE userid = xx?
And if yes, do I need to change that somewhere else too?
Let's say I only want userid 2 to receive pm's, is that possible too?

RS_Jelle 11-02-2007 09:10 AM
Then you need to replace:
PHP Code:
$result = $db->query_read("SELECT title, usergroup.usergroupid, username, userid
               FROM " . TABLE_PREFIX . "usergroup, " . TABLE_PREFIX . "user
                           WHERE ecdownloadpermissions & 1024 AND  usergroup.usergroupid = user.usergroupid
            "); 
With:
PHP Code:
$result = $db->query_read("SELECT username, userid
               FROM " . TABLE_PREFIX . "user
                           WHERE userid = 2
            "); 
Note: you need to replace this two times. I removed the usergroup parts from the query as they aren't necessary for this, so it's a bit lighter.

It should work, but I didn't test it ...

Black Tiger 11-02-2007 01:16 PM
Great, thank you very much!!!


All times are GMT. The time now is 03:20 PM.
Page 3 of 6 12 3 45 Last »
Show 40 post(s) from this thread on one page

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.01169 seconds
  • Memory Usage 1,766KB
  • 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
  • (7)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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