PhpBB3 BBCodes

Notify by default

Moved here: viewtopic.php?f=45&t=1259

Thanks

and the sql query to update this to already registered user, go to either you phpmyadmin page or use the STK!

Thanks for that cisc007 was wondering why this didnt work on my site.

i do this everytime I upgrade a site just to be sure, i know i probably don't have to but i do it anyways!

cisco007 » 26 Apr 2010, 18:35 wrote:and the sql query to update this to already registered user, go to either you phpmyadmin page or use the STK!

Code: Select all

UPDATE `phpbb_users` SET `user_notify` = 1 WHERE `user_type` <> 2 

Sorry to be a pain, but I'm not really sure how to do this, do I need to modify a file, if so which one?

I've done the other one for new users, is there a way to do it for current users by altering a file?

viewtopic.php?f=10&t=53 < read down and look at the part "Doing SQL changes"

Which database do I need to modify?

Yours.

the forum one?

Installed put it in that one and got this message:

#1146 - Table 'bullseye_forum.phpbb_users' doesn't exist

How ever underneath that message, it says 'edit' and 'create PHP code'