_CFG_ echo ' '; $query = "SELECT parm_name, parm_value FROM " . $tbl . "parameters WHERE parm_name='_PKG_NAME_LONG' LIMIT 1"; $result = mysql_query($query); $row = mysql_fetch_array($result); $title = $row['parm_value']; // this MIGHT be needed later on, depending do you use banner img or not... echo ' ' . $url . ' ' . $row['parm_value'] . ' '; $query = "SELECT parm_name, parm_value FROM " . $tbl . "parameters WHERE parm_name='_DB_PKG_LOCALE' LIMIT 1"; // _CFG_ i'm not sure is locale correct... $result = mysql_query($query); $row = mysql_fetch_array($result); echo $row['parm_value'] .''; $query = "SELECT parm_name, parm_value FROM " . $tbl . "parameters WHERE parm_name='_PKG_FOOTER_LINE_01' LIMIT 1"; // _CFG_ chose footer line 01, as it probably contain's copyright info $result = mysql_query($query); $row = mysql_fetch_array($result); echo ' ' . $row['parm_value'] . ' ' . date("r") . ' ' . $url . ''; // _CFG_ do you want your URL as publisher? $query = "SELECT parm_name, parm_value FROM " . $tbl . "parameters WHERE parm_name='_PKG_EMAIL_MAIL' LIMIT 1"; // _CFG_ chose footer line 01, as it probably contain's copyright info $result = mysql_query($query); $row = mysql_fetch_array($result); echo ' ' . $row['parm_value'] . ' Hosting'; // _CFG_ What you want as subject? /* Let's output those articles */ $link = $url . "/mod.php?mod=articles"; // _CFG_ you want something else here? $query = "SELECT parm_name, parm_value FROM " . $tbl . "parameters WHERE parm_name='IPP_ARTICLES' LIMIT 1"; // _CFG_ chose footer line 01, as it probably contain's copyright info $result = mysql_query($query); $row = mysql_fetch_array($result); $query = "SELECT topic_id, cat_id, subject, time_stamp, entry, auto_nl2br FROM " . $tbl . "articles ORDER BY time_stamp DESC LIMIT " . $row['parm_value']; $result = mysql_query($query); echo ' '; $i = 0; // Following while, i just prefer to do it this way, rather than having $i's stuff inside while :) for those who wonder while ($i <= $row['parm_value']) { echo "\t\t"; // to add 2 tabs there... inside ' chars seeming you can't use them... uh... echo ''; echo "\n"; $i++; } echo ' '; // _CFG_ uncomment and modify following line for small banner img // echo ''; echo ''; // _CFG_ uncomment following lines and modify if you want an banner /* echo ' _URLTOBANNER_ ' . $url . ' '; */ /* _CFG_ Topic & Category IDs */ $topic[1] = "Announcements"; $topic[2] = "Documentation"; $topic[3] = "General"; $topic[4] = "News"; $cat[1] = "General"; $cat[2] = "News"; $cat[3] = "Servers Related"; $cat[4] = "Site Related"; while ($row = mysql_fetch_array($result)) { echo "\t"; echo ' ' . $link . ' '; if ($row['auto_nl2br'] == 1) { $row['entry'] = str_replace("\n", "
", $row['entry']); } echo $row['entry'] . ' ' . $title . ''; //_CFG_ who created it? :) echo "\n\t\t"; echo '' . $topic[$row['topic_id']] . $cat[$row['cat_id']] . ''; $date = date("r", $row['time_stamp']); echo "\n\t\t"; echo '' . $date . ' '; } echo ""; @mysql_free_result($result); mysql_close($db); ?>