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

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.

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

Did you create the tables with the install.sql file?

__________________
The more we learn... the more we realize how little we actually know.

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!

Is there any way i can get around this?

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!

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.

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

Please, if you do not mind Mikem... That would be greatly appreciated

Thank you!

Wayne