Default Values in t...
 
Notifications
Clear all

Default Values in tables

6 Posts
4 Users
0 Reactions
1,678 Views
(@jacci)
Posts: 503
Honorable Member
Topic starter
 

I was wondering, is it safe to change the default value in user preferences re emial notifications being sent out to 1 (so they send) instead of 0?
And if i do that, it should mean that all new members will recieve emials?

Most of my members are unaware of that option and since the vast majority of them crave the reviews, but dont knwo they can set that in their preferences, if i could change the default in the table to 1, then they woudl automatically recieve emails (once 3.3 comes out...) and if they then wish they can turn it off.

thanks
jacci


why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/     
php: 5.2.5  msql: 5.0.45-community
efic version: 3.4.3           latest patches: yes
bridges: none              mods: challenges, displayword, beta-search

 
Posted : 05/06/2007 12:17 pm
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

You can do that, and yes it will change. πŸ™‚ New members only.

I was thinking of doing that myself.


Whoever said nothing is impossible never tried slamming a revolving door.

url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word

 
Posted : 05/06/2007 2:29 pm
(@fanfictionworld)
Posts: 149
Estimable Member
 

you would change this in the database right? if so what would you change?


~Spikey~

my site url: http://www.fanfictionworld.org
efic version:3.5.3

 
Posted : 05/06/2007 5:10 pm
(@jacci)
Posts: 503
Honorable Member
Topic starter
 

Thanks Jan_Aq

i thought  you probably could but wasnt sure and figured it would be best to ask. 

fanfictionworld, this is how i have done it and it worked like a charm  πŸ˜€

Log into phpmyadmin and locate your fanfiction tables.
Find the table _authorprefs and select that from the list on the left (assuming phpmyadmin is relatively uniform)
This should bring up a list of things for your authorprefs including;
Field, type, attributse, null, DEFAULT, Extra, Action

in the field list look for
newreviews  :its current default is 0

click the little pencil button for newreveiws  (this will let you edit it)

change the default value to 1 and then press save

On mine i am doing the same to newrespond (when an author responds to reveiew)


why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/     
php: 5.2.5  msql: 5.0.45-community
efic version: 3.4.3           latest patches: yes
bridges: none              mods: challenges, displayword, beta-search

 
Posted : 05/06/2007 11:08 pm
(@tammy)
Posts: 2577
Member Moderator
 

Just be sure your hosting can handle that kind of traffic.  Also, be aware that it's kind of a no-no to send e-mails to people who haven't specifically requested they get emails.  You're spamming them.  I would definitely go into the language files and change the message to tell them exactly how to opt out of these emails.


 
Posted : 06/06/2007 12:26 am
(@jacci)
Posts: 503
Honorable Member
Topic starter
 

That is an excellent idea tammy, i didnt think of that. I have had so many moan to me about not getting them i just assumed everyone would want them.

I might also add smt to my news item to indicate it can be turned off as well as adding clear instruction on the reveiew notification about how to turn them off if they no longer want them


why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/     
php: 5.2.5  msql: 5.0.45-community
efic version: 3.4.3           latest patches: yes
bridges: none              mods: challenges, displayword, beta-search

 
Posted : 06/06/2007 9:01 am
Share: