You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 161 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - How do I set to receive a newsletter by default? [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
blurredvision
Private
Private


Joined: Aug 05, 2003
Posts: 36


PostPosted: Tue Dec 16, 2003 7:55 pm Reply with quoteBack to top

As of right now, when a new user signs up for my site, the option to receive a newsletter is defaulted to No in their profile. How can I change this to default to Yes, so they will actually have to select No in order to not receive one?

Thanks.
Find all posts by blurredvisionView user's profileSend private message
gschoper
Captain
Captain


Joined: Sep 16, 2003
Posts: 380


PostPosted: Tue Dec 16, 2003 10:18 pm Reply with quoteBack to top

Run the following sql statement against your database:
Code:

ALTER TABLE `nuke_users` CHANGE `newsletter` `newsletter` INT( 1 ) DEFAULT '1' NOT NULL;


This will set the default to Yes for all new accounts.

HTH,

gschoper

_________________
Image
http://nuke.schoper.net/
Find all posts by gschoperView user's profileSend private messageSend e-mailVisit poster's website
aabbcc
Corporal
Corporal


Joined: Feb 20, 2004
Posts: 60


PostPosted: Sun Feb 22, 2004 7:59 pm Reply with quoteBack to top

Another solution I was looking for Razz Thanks

_________________
World of Warcraft Nation
Find all posts by aabbccView user's profileSend private messageVisit poster's website
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.218 Seconds - 222 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::