vb.org Archive - Mass Admin PM v1.5

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - Mass Admin PM v1.5 (https://vborg.vbsupport.ru/showthread.php?t=70223)

Quote:

Originally Posted by Avalon111

have your tried it?

I did, here is the error with 3.5:

Fatal error: Call to a member function on a non-object in /home/mysite/public_html/forum/admincp/admin_pmall.php on line 46

Line 46 is:

Code:

// ----------------------------

// Get Usergroups

// ----------------------------



$UserGroups = array();



$usergroups = $DB->query("SELECT * FROM " . TABLE_PREFIX . "usergroup ORDER BY title");



        while($usergroup = $DB_site->fetch_array($usergroups)){

        $UserGroups[] = array(

                                'uid'    => $usergroup['usergroupid'],

                                'u_name' => $usergroup['title'],

                        );

        }

You are using the 3.0.x version. You should use this one, https://vborg.vbsupport.ru/showthrea...threadid=96190.

Installed. But I also need secondary group support.

Quote:

Originally Posted by Saphrym

Installed. But I also need secondary group support.

So do I :(.

Quite possibly one of the most practical add on's ever. Well done mate!!! Thx.

Quote:

Originally Posted by flee2 (Post 624068)

Zero. I will not question your way to make hacks, but checking a few posts back, i see that the users with a lot of records in USER table in database, get stuck when trying to send this. You replied that's is a UPLOAD problem.. or any other problem like this.

I will explain this for you.. checking your hack, it's really good constructed, but you miss a little detail. when you LIMIT the send of PM's, you must LIMIT the QUERY to DB too.

I looked that the query is static in all "retries" to send PM's:

PHP Code:


		
			
$Query_Build = "select * from ".TABLE_PREFIX."user where usergroupid IN({$set_in}) order by userid"

this will return a query result with ALL your members in the usergroup / user table.. if you have 25.000 members in the group "Registered", the query result will have 25.000 records, and before you get the reply from DB, you mysql will go down.

The way to solve this, is LIMIT the query to database, in the one by one step to sending pm's. (LIKE the vB do while sending mass emails)

Example:

Sending to 150 users in usergroup 6, send amount by step is set in 50.

- START SCRIPT
- CHECK THE AMOUNT OF PM'S SENT BY STEP (50)
- QUERY DATABASE TO USERGROUP 6, LIMIT RECORDS FROM 0 TO 50
- SEND PM'S 0 TO 50
- SHOW OK RESULTS AND CONTINUE TO NEXT STEP (SEND THE "STARTAT")
- QUERY DATABASE TO USERGROUP 6, LIMIT RECORDS 51 TO 100 (START - START + AMOUNT)
- SEND PM'S 51 TO 100
AND CONTINUE... TO END

-------------------------

your actual script works like this:

Sending to 150 users in usergroup 6, send amount by step is set in 50.

- START SCRIPT
- CHECK THE AMOUNT OF PM'S SENT BY STEP (50)
- QUERY DATABASE TO USERGROUP 6, NO LIMIT RECORDS (ALL RESULTS)
*** IF THE USERS ARE A LOT, YOU GET A HANGED DB IN A SUPER BIG QUERY **

-----------------

It will be much better if you correct this issue... :D

Yes, it's true. I have more than 120.000 users and mass PMing can not work.

Is there somebody able to fix the problem?

I had the same problem with mass PM'ing about 70,000 members in my "Registered" usergroup. I solved it by temporarily adjusting the memory_limit variable in my php.ini file.

Great hack -- thanks Zero Tolerance!

Quote:

Originally Posted by ice9 (Post 1720534)

I had the same problem with mass PM'ing about 70,000 members in my "Registered" usergroup. I solved it by temporarily adjusting the memory_limit variable in my php.ini file.

What value you set in memory_limit?

First, try the script, and confirm that it's failing. Then, look in your apache error log (probably /var/log/httpd/error_log). If it's failing because of a PHP memory error, you'll probably see a line like this:

Allowed memory size of 50331648 bytes exhausted (tried to allocate 0 bytes)

If you see a line like that, double the memory_limit variable, restart apache, then try again. Watch your server load while the script is running, via the "top" command. Also, you might need to limit it to send only 100 PMs at a time, rather than the default 300. You can also adjust this while the script is executing, by altering the value in the meta-refresh url.

When you're done, don't forget to change memory_limit back in php.ini, and then restart apache again.

X vBulletin 3.8.12 by vBS Debug 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)bbcode_php_printable (4)bbcode_quote_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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01149 seconds Memory Usage 1,742KB 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)bbcode_php_printable (4)bbcode_quote_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
Messages: