Versionsproblem mit enewslist

[Waldlaeufer]

Moin zusammen,

bin gerade dabei Feinheiten meiner Homepage hinzuzufügen und habe mit dem "enewslist" http://www.emediafabrik.de/index.php?de ... _enewslist Mod ein Problem.

Man soll folgendes finden:

Code: Select all

$sql =	"SELECT article_id, article_title, article_cid, UNIX_TIMESTAMP(article_tstamp) AS article_date ".
			"FROM ".DB_PREPEND."phpwcms_article WHERE ".
			"article_public=1 AND article_aktiv=1 AND article_deleted=0 AND ".
			"article_begin < NOW() AND article_end > NOW() ".
			"ORDER BY article_tstamp DESC".$limit.";";

Um es hiermit zu ersetzen:

Code: Select all

$sql =	"SELECT article_id, article_title, article_cid, UNIX_TIMESTAMP(article_tstamp) AS article_date ".
			"FROM ".DB_PREPEND."phpwcms_article WHERE ".
			"article_public=1 AND article_aktiv=1 AND article_deleted=0 AND ".
			"article_begin < NOW() AND article_end > NOW() ".
			$lang.$cat.$list.
			"ORDER BY article_tstamp DESC".$limit.";";

In der von mir installierten Version finde ich aber nur:

Code: Select all

$sql  =	"SELECT article_id, article_title, article_cid, UNIX_TIMESTAMP(article_tstamp) AS article_date ";
		$sorting = 'article_tstamp';
	}
	$sql .=	"FROM ".DB_PREPEND."phpwcms_article WHERE ".$cat;

Kann mir vielleicht jemand dabei helfen wo ich den Code einsetzen muß damit der "MOD" funkioniert?
Hier das was zusätzlich eingefügt werden müßte.

Code: Select all

$lang.$cat.$list.

CU - Dominik

[DeXXus]

Have you tried the "assumed" substitution
This is untested - JUST GUESSING

#-----[ FIND ]---------------------------------------------
#

$sql = "SELECT article_id, article_title, article_cid ".
"FROM ".DB_PREPEND."phpwcms_article WHERE article_id=".$article_id." AND ".
"article_public=1 AND article_aktiv=1 AND article_deleted=0 AND ".
"article_begin < NOW() AND article_end > NOW() LIMIT 1;";
#
#-----[ REPLACE WITH ]---------------------------------
#

$sql = "SELECT article_id, article_title, article_cid, UNIX_TIMESTAMP(article_tstamp) AS article_date ".
"FROM ".DB_PREPEND."phpwcms_article WHERE ".
"article_public=1 AND article_aktiv=1 AND article_deleted=0 AND ".
"article_begin < NOW() AND article_end > NOW() ".
$lang.$cat.$list.
"LIMIT 1;";";


#
#-----[ SAVE and CLOSE ]---------------------------------------------
#


#
# EoM