Your Newsletter Module

stokerpoons · **Your Newsletter Module -** 07-09-2004, 07:30 PM

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

coldblooded · 07-09-2004, 07:42 PM

Newsletter module is available here.

The User Info block is a modified version of telli's, the original version is available at his site.

stokerpoons · 07-09-2004, 09:05 PM

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

coldblooded · 07-09-2004, 10:25 PM

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

Mighty_Y · 07-10-2004, 05:43 AM

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 :?

stokerpoons · 07-10-2004, 05:57 AM

Is there any way i can get around this?

Mighty_Y · 07-10-2004, 01:56 PM

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

coldblooded · 07-10-2004, 02:18 PM

mikem installed that module, I didn't know he had to mod it. Sorry about that.

mikem · 07-11-2004, 06:41 PM

Quote:

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

stokerpoons · 07-11-2004, 07:43 PM

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

Thank you!

Wayne