Notify by default

[Stoker]

Notify by default

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

[Bullseye]

Thanks

[cisco007]

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 

[Steve]

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

[cisco007]

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!

[Bullseye]

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?

[Steve]

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

[Bullseye]

Which database do I need to modify?

[Steve]

Yours.

[Bullseye]

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'