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

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Send Private Message to Public Group Leader on Join Requests (https://vborg.vbsupport.ru/showthread.php?t=74623)

Cyricx 03-08-2005 02:19 AM
It's not working for me at all, and I've followed the instructions to a T... even followed the "non-instructions" by adding the phrase in ;)

The pm title comes across as "Join Request:"

and the message comes up with what I set in as the variable with nothing else, so it's not pulling the $groupname[title] and I'm not sure what the "convert to url" code is supposed to do.

Here is my insertjoinrequest function and you can see from it I've followed your instructions to a T.

Code:
if ($_POST['do'] == 'insertjoinrequest')
{

  require_once('./includes/functions_bbcodeparse.php');
  require_once('./includes/functions_newpost.php');

        globalize($_POST, array('usergroupid' => INT));

        $url = "profile.php?do=editusergroups";

        if ($request = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "usergrouprequest

WHERE userid=$bbuserinfo[userid] AND usergroupid=$usergroupid"))
        {
                // request already exists, just say okay...
                eval(print_standard_redirect('usergroup_requested'));
        }
        else

        {
                // insert the request
                $DB_site->query("
                        INSERT INTO " . TABLE_PREFIX . "usergrouprequest
                                (userid,usergroupid,reason,dateline)
                        VALUES
                                ($bbuserinfo[userid], $usergroupid, '" .

addslashes(htmlspecialchars_uni($_POST['reason'])) . "', " . TIMENOW . ")
                ");

              $leaders = $DB_site->query("
                                SELECT ugl.userid, username
                                FROM " . TABLE_PREFIX . "usergroupleader AS ugl
                                INNER JOIN " . TABLE_PREFIX . "user AS user USING(userid)
                                WHERE ugl.usergroupid = $usergroupid
                        ");
                        $groupname = $DB_site->query_first("
                        SELECT title
                        FROM " . TABLE_PREFIX . "usergroup
                        WHERE usergroupid = $usergroupid
                        ORDER BY usergroupid DESC
                        LIMIT 1
                    ");
                        if ($DB_site->num_rows($leaders))
                        {
                               
                                $_groupleaders = array();
                        $tostring = array();

                                while ($leader = $DB_site->fetch_array($leaders))
                                {
                          // Send a PM to the leaders letting them know a join request has been

made.
                                                  $message =

construct_phrase($vbphrase['group_memberships_message'], $groupname[title]);
                                                  $message = convert_url_to_bbcode($message);
                          $tostring["$leader[userid]"] = $leader['username'];

                          $DB_site->query("INSERT INTO " . TABLE_PREFIX . "pmtext\n\t(fromuserid,

fromusername, title, message, touserarray, iconid, dateline,

showsignature)\nVALUES\n\t($bbuserinfo[userid], '" . addslashes($bbuserinfo['username']) . "',

'Join Request:', '".addslashes(htmlspecialchars($message))."', '" .

addslashes(serialize($tostring)) . "', 0, " . TIMENOW . ", 1)");
                          $pmtextid = $DB_site->insert_id();
                          $DB_site->query("INSERT INTO " . TABLE_PREFIX . "pm (pmtextid, userid,

messageread) VALUES ($pmtextid, $leader[userid], 0)");
                          $DB_site->shutdown_query("UPDATE " . TABLE_PREFIX . "user SET

pmtotal=pmtotal+1, pmunread=pmunread+1 WHERE userid = $leader[userid]");

                        }
              }

                eval(print_standard_redirect('usergroup_requested'));
        }

}
Your absolutely right, I can't believe the devs didn't add this in by default. Would really love to have this hack working though, any help is appreciated :)

amykhar 03-08-2005 02:55 PM
Diid you add the phrase that is listed in the updated instructions? The convert url code simply converts any links you may use in the phrase to make them clickable.

Because you mention the "nonexistant phrase" I am concerned that you didn't see the portion of the instructions where that is added (around line 4 of the instruction file.)

Cyricx 03-08-2005 03:37 PM
Ah bugger, saw the post by Sandman saying that the upgrade instructions needed to include that, didn't see anything about ya updaing them.

So this is a case of "Open mouth insert foot"

I had an older version that I had snagged when this was first brought up.

Thanks Amy! Awesome mod! :)

amykhar 06-14-2005 06:35 PM
Ported: https://vborg.vbsupport.ru/showthread.php?t=83086

|Jordan| 02-04-2006 05:04 PM
This doesnt work in 3.0.12

I've checked and rechecked the file checks and i didnt miss anything.

parash 01-18-2008 06:44 PM
would it be possible to clear more... i tried it 3times but same error came...i dunno what is worng in it..


All times are GMT. The time now is 10:18 PM.
Page 3 of 3 12 3
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.02447 seconds
  • Memory Usage 1,735KB
  • 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
  • (6)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