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


Author: aabbccPostPosted: Sun Feb 22, 2004 7:59 pm    Post subject: Re: How do I set to receive a newsletter by default?

Another solution I was looking for Razz Thanks



Nuke Cops -> Installation for Newbies

All times are GMT - 8 Hours

Page 1 of 1

Powered by phpBB © 2001,2002 phpBB Group
NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 

Author: gschoperPostPosted: Tue Dec 16, 2003 10:18 pm    Post subject: Re: How do I set to receive a newsletter by default?

Run the following sql statement against your database:
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, 272 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? How do I set to receive a newsletter by default?

Nuke Cops -> Installation for Newbies

Author: blurredvision PostPosted: Tue Dec 16, 2003 7:55 pm    Post subject: How do I set to receive a newsletter by default?

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.
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
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.239 Seconds - 544 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
added by Evaders - DO NOT REMOVE
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::