The phpwcms support forum will help to find answers to your questions. The small but strong community is here since more than 10 years.
https://forum.phpwcms.org/
Code: Select all
$my_date = (isset($result['0']['max_article_tstamp'])) ? $result['0']['max_article_tstamp']: '--';
Code: Select all
$my_date = (isset($result['0']['max_article_tstamp'])) ? $result['0']['max_article_tstamp']: time();
Code: Select all
$sql = "SELECT article_id, UNIX_TIMESTAMP(max(article_tstamp)) AS max_article_tstamp, ";
$sql .= "article_begin AS article_livedate, ";
$sql .= "article_end AS article_killdate ";
$sql .= "FROM ".DB_PREPEND."phpwcms_article ar LEFT JOIN ".DB_PREPEND."phpwcms_articlecat ac ON ";
$sql .= "ar.article_cid = ac.acat_id WHERE ";
// Categorie settings -------------
$sql .= "ac.acat_aktiv=1 AND ac.acat_public=1 AND ac.acat_trash=0 AND ";
// category: "hide" or "visible when active"
$sql .= "ac.acat_hidden=0 AND "; // "hide" or "visible when active"
$sql .= "ac.acat_regonly=0 AND "; // "visible for users logged on only"
// Article settings ---------------
$sql .= "ar.article_public=1 AND ar.article_aktiv=1 AND ";
// Article settings
$sql .= "ar.article_deleted=0 AND ar.article_begin<NOW() ";
$sql .= "AND IF(ac.acat_archive=1 AND ar.article_archive_status=1, 1, ar.article_end>NOW()) LIMIT 1";
$result = _dbQuery($sql);
Code: Select all
$sql = "SELECT UNIX_TIMESTAMP(max(article_tstamp)) AS max_article_tstamp ";
// Nur fuer MySQL Engines geeignet die auch im SELECT Unterabfragen unterstuetzen
// Only suitable for MySQL Engines that also support subqueries in SELECT statement
/*
$sql .= ",article_id, ";
$sql .= "article_begin AS article_livedate, ";
$sql .= "article_end AS article_killdate ";
*/
$sql .= "FROM ".DB_PREPEND."phpwcms_article ar LEFT JOIN ".DB_PREPEND."phpwcms_articlecat ac ON ";
....