vb.org Archive - Mass Changing Of Options For ALL Users

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

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Mass Changing Of Options For ALL Users (https://vborg.vbsupport.ru/showthread.php?t=7791)

Flare945

02-05-2001 07:10 AM

90% of my users have PM's set to OFF due to a bug I had w/ my PM's... i had forgotten to add something.

Anyways, is there a way that I can get a script or something that will activate it for all users? So they can ALL send/recieve PM's? I am using PM 1.2.5

02-05-2001 02:25 PM

UPDATE user SET receivepm = 1

02-06-2001 05:06 AM

uhh

can u clarify?

i dont understand that at all...

[high]* is stupid :)[/high]

02-06-2001 06:01 AM

You have two options:

install phpMyAdmin and enter that text into the query box and run it

OR

create a new file called something.php and enter the following code into it:

PHP Code:


		
			
<?php

include "global.php";



$result = $DB_site->query("UPDATE user SET receivepm=1");



echo "successfully executed query";

?>

Now copy that file into the same folder as your forums and visit it once with a web browser. If the page returns 'successfully executed query' then you have just altered every user's profile.

Then delete the something.php file.

All times are GMT. The time now is 03:19 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00959 seconds Memory Usage 1,710KB 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_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: