11
mboyden
Re: Changing the default notification method
  • 2009/5/31 19:04

  • mboyden

  • Moderator

  • Posts: 484

  • Since: 2005/3/9 1


In the administration of the fields, you can set the notify_method to default to email instead pm. However, existing users will already have pm set in their existing profiles, so you will have to run a sql command to change all the existing users to email instead of pm (or edit their accounts individually).
Pessimists see difficulty in opportunity; Optimists see opportunity in difficulty. --W Churchill

XOOPS: Latest | Debug | Hosting and Web Development

12
tatane
Re: Changing the default notification method
  • 2009/6/1 8:08

  • tatane

  • Just can't stay away

  • Posts: 649

  • Since: 2008/5/6 1


Quote:

mboyden wrote:
so you will have to run a sql command to change all the existing users to email instead of pm.


ok but how?

13
iHackCode
Re: Changing the default notification method

UPDATE xoops_users SET notify_method=2 where notify_method=1;
CBB / LatestNews / Publisher / XM-Spotlight

(ノ◕ヮ◕)ノ*:・゚✧

14
mrrockitt
Re: Changing the default notification method
  • 2009/7/30 15:32

  • mrrockitt

  • Just popping in

  • Posts: 2

  • Since: 2009/6/9 1


Hi Guys,

just to clear this up for any beginners out there like me :)

The best way to do this so that your Users get email notification in XOOPS instead of just private message for any entries they make in a Helpdesk, Forum, etc, is to change a few lines in the XOOPS MySQL.

I simply went into my favourite MySQL GUI program (MySQLyog), found the prefix_users table, (prefix will be whatever number XOOPS used to generate a random name for all of your SQL tables) and looked for the column called 'notify_method'.

You can use the method mentioned above to run a query to update all existing users
(UPDATE prefix_users SET notify_method=2 where notify_method=1;)

To set the default notification method for new Users I then altered the notify_method field of the prefix_users table to show a 2 instead of a 1.
Now all my existing and new Users have email as their default.

Hope that helps if you need it still :)

Russ

Login

Who's Online

167 user(s) are online (102 user(s) are browsing Support Forums)


Members: 0


Guests: 167


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits