|
» Online Users: 52 |
| 0 members and 52 guests |
| No Members online |
| Most users ever online was 611, 03-21-2008 at 11: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
|
|
|
|
|
|
|
|
|
|
|
Portatiles - Ofertas en Ordenadores y Portatiles. Increibles Ofertas DELL.
|
|
|
|
|
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; Originally Posted by Mighty_Y
find in modules/Newsletter/index.php
Code:
$query = "SELECT email, uid FROM ${prefix}... |
|
 |
|
 |
|
|
07-11-2004, 10:09 PM
|
|
Junior Member
|
|
Join Date: Jun 2004
Location: Portsmouth, UK
Posts: 15
|
|
|
Originally Posted by Mighty_Y
|
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 
|
Hi Mighty Y! I have tried this but still get the error with line 48
error
|
Quote:
|
|
Warning: Supplied argument is not a valid MySQL result resource in /home/stokerpoons/public_html/modules/Newsletter/index.php on line 48
|
line 48
|
Quote:
|
|
list($usermail) = mysql_fetch_row($result);
|
Thanks anyway!  [/quote] |
07-12-2004, 11:02 AM
|
|
Moderator
|
|
Join Date: Nov 2002
Location: Belgium
Posts: 957
|
|
replace
|
Code:
|
global $prefix, $user, $modul_name; |
with
|
Code:
|
global $prefix, $user, $modul_name, $db; |
and replace
|
Code:
|
$query = "SELECT email, uid FROM ${prefix}_users WHERE uid = '$cookie[0]'";
$result = mysql_query($query);
list($usermail) = mysql_fetch_row($result); |
with
|
Code:
|
$query = "SELECT user_email, user_id FROM ".$prefix."_users WHERE uid = '$cookie[0]'";
$result = $db->sql_query($query);
list($usermail) = $db->sql_fetchrow($result); |
Normally it should work now, or atleast another error should pop in |
07-12-2004, 11:23 AM
|
|
Junior Member
|
|
Join Date: Jun 2004
Location: Portsmouth, UK
Posts: 15
|
|
|
I dont get any errors anymore but there are still no emails added to the list even though it confirms that the email has been added :?
It even sends the email saying that the user has been added but no joy!
|
07-12-2004, 11:38 AM
|
|
Moderator
|
|
Join Date: Nov 2002
Location: Belgium
Posts: 957
|
|
I'm gonna modify this thing
A little bit patience please |
07-12-2004, 11:49 AM
|
|
Junior Member
|
|
Join Date: Jun 2004
Location: Portsmouth, UK
Posts: 15
|
|
No worries Mighty_Y!
Your a Star |
07-12-2004, 12:18 PM
|
|
Moderator
|
|
Join Date: Nov 2002
Location: Belgium
Posts: 957
|
|
here is the fully working (atleast on my system ) version of the newsletter module:
http://users.skynet.be/fa091229/newsletter1.70.zip
It won't stay on my server forever, so you are warned (it stays there, till I forget what it is or why it is there, and then I delete it ) |
07-12-2004, 12:20 PM
|
|
Junior Member
|
|
Join Date: Jun 2004
Location: Portsmouth, UK
Posts: 15
|
|
Cheers Mighty_Y. I will give it a shot later on tonight! |
07-12-2004, 01:42 PM
|
|
Moderator
|
|
Join Date: Nov 2002
Location: Belgium
Posts: 957
|
|
Mikem, I compared yours with my modified version and it seems I went a little bit further in adjusting (I use $db almost everywhere) so i have put my index.php in your package (with the block and more structurised):
http://users.skynet.be/fa091229/Newsletter.zip |
07-12-2004, 01:49 PM
|
|
Senior Member
|
|
Join Date: Sep 2002
Posts: 2,905
|
|
|
Originally Posted by Mighty_Y
|
Mikem, I compared yours with my modified version and it seems I went a little bit further in adjusting (I use $db almost everywhere) so i have put my index.php in your package (with the block and more structurised):
http://users.skynet.be/fa091229/Newsletter.zip
|
roger..yes, I had not made the new db changes for the new sql layering..blah blah.... :roll: ..thanks Mighty..hopefully that will work for him :wink: |
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
All times are GMT -5. The time now is 12:12 PM.
