Mass Changing Of Options For ALL Users

[Flare945]

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

UPDATE user SET receivepm = 1

uhh

can u clarify?

i dont understand that at all...


[high]* is stupid [/high]

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.