» Log in
User Name:

Password:

Not a member yet?
Register Now!
» Online Users: 68
0 members and 68 guests
No Members online
Most users ever online was 611, 03-21-2008 at 10:10 PM.
» .::.
Web Hosting - web hosting, dedicated servers and web design services
Online Degree - search for 1000+ online degrees, online colleges & online universities.
tattoo - we are a group of tattoo enthusiasts
Gexa Energy - your absolute best choice in electric service
Texas electricity - save on electric rates
buy Rimonabant - Help dieters achieve significant weight loss without having to slog in the gym

Register Now! Contact Us

About this Page
This is a discussion on Your Newsletter Module within the Nuke 7.x - Modules forums, part of the PHP-Nuke 7.x category; Hi, I was wondering where you got your newsletter module from as i would like to introduce something similar into ...



Go Back   Nukemods Forum » PHP-Nuke 7.x » Nuke 7.x - Modules

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-09-2004, 07:30 PM
Junior Member
 
Join Date: Jun 2004
Location: Portsmouth, UK
Posts: 15
Send a message via MSN to stokerpoons
Your Newsletter Module
Hi, I was wondering where you got your newsletter module from as i would like to introduce something similar into my site at www.engineering247.com.

I was also wondering where you got your User Info block that displays the STAFF and ADMIN next to the appropriate person when they are logged in.

Thankyou very much for yout time and nice site
Regards

Wayne
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 07-09-2004, 07:42 PM
coldblooded's Avatar
Super Moderator
 
Join Date: Jan 2002
Location: USA
Posts: 618
Newsletter module is available here.

The User Info block is a modified version of telli's, the original version is available at his site.
__________________
The more we learn... the more we realize how little we actually know.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 07-09-2004, 09:05 PM
Junior Member
 
Join Date: Jun 2004
Location: Portsmouth, UK
Posts: 15
Send a message via MSN to stokerpoons
After installing the newsletter module i get the following error at the top of the page when i access the module from the main menu

Quote:
Warning: Supplied argument is not a valid MySQL result resource in /home/stokerpoons/public_html/modules/Newsletter/index.php on line 48
I have been over my instalation and have not found any problems with it. I have done everything it has asked!

These are lines 46 - 48...

Quote:
$query = "SELECT email, uid FROM ${prefix}_users WHERE uid = '$cookie[0]'";
$result = mysql_query($query);
list($usermail) = mysql_fetch_row($result);
I have tried to add my email addresse to the list but none are added when i try as if they are not being added to the database.

Do any of you guys know what the problem may be?

Regards

Wayne
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 07-09-2004, 10:25 PM
coldblooded's Avatar
Super Moderator
 
Join Date: Jan 2002
Location: USA
Posts: 618
Did you create the tables with the install.sql file?
__________________
The more we learn... the more we realize how little we actually know.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 07-10-2004, 05:43 AM
Moderator
 
Join Date: Nov 2002
Location: Belgium
Posts: 957
uid, email, mysql_query, mysql_fetch_row etc can only be used in nuke 6.0 so i think this module needs to be modified a little :?
__________________
Yannick R. aka Mighty_Y
http://support.code-area51.com
http://www.code-area51.com

Search before asking makes my life easier!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 07-10-2004, 05:57 AM
Junior Member
 
Join Date: Jun 2004
Location: Portsmouth, UK
Posts: 15
Send a message via MSN to stokerpoons
Is there any way i can get around this?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 07-10-2004, 01:56 PM
Moderator
 
Join Date: Nov 2002
Location: Belgium
Posts: 957
find in modules/Newsletter/index.php
Code:
    $query = "SELECT email, uid FROM ${prefix}_users WHERE uid = '$cookie[0]'";
and replace with
Code:
    $query = "SELECT user_email, user_id FROM $prefix_users WHERE user_id = '$cookie[0]'";
try that and report back
__________________
Yannick R. aka Mighty_Y
http://support.code-area51.com
http://www.code-area51.com

Search before asking makes my life easier!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 07-10-2004, 02:18 PM
coldblooded's Avatar
Super Moderator
 
Join Date: Jan 2002
Location: USA
Posts: 618
mikem installed that module, I didn't know he had to mod it. Sorry about that.
__________________
The more we learn... the more we realize how little we actually know.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 07-11-2004, 06:41 PM
Senior Member
 
Join Date: Sep 2002
Posts: 2,905
Originally Posted by coldblooded
mikem installed that module, I didn't know he had to mod it. Sorry about that.
Yeah, I have a modded version on file. IF you still need it, let me know.

mikem
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old 07-11-2004, 07:43 PM
Junior Member
 
Join Date: Jun 2004
Location: Portsmouth, UK
Posts: 15
Send a message via MSN to stokerpoons
Please, if you do not mind Mikem... That would be greatly appreciated

Thank you!

Wayne
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
newsletter problem boaw Nuke 7.x - General 3 08-27-2006 11:04 AM
Newsletter questions silence_gr Nuke 7.x - Modules 1 11-03-2004 12:59 PM
Newsletter Module XtraX Nuke 6.5 to 6.9 - Modules 3 08-10-2003 11:39 AM
Looking for enhanced newsletter module crypto Nuke 6.5 to 6.9 - Modules 0 06-27-2003 03:26 PM
Newsletter Module nopeace4u nukemods.com 1 03-18-2003 08:08 AM


All times are GMT -5. The time now is 07:57 PM.


Design by Vjacheslav Trushkin, color scheme by ColorizeIt!.

LinkBacks Enabled by vBSEO 3.1.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31