PHPFusion-Tips.dk - Debatforum: Elementer vises underligt i tema

Kode
<?php

/*---------------------------------------------------+

| PHP-Fusion 7 Content Management System

+----------------------------------------------------+

| Copyright © 2002 - 2010 Nick Jones

| http://www.php-fusion.co.uk/

+----------------------------------------------------+

| Released under the terms & conditions of v3 of the

| GNU General Public License. For details refer to

| the included gpl.txt file or visit http://gnu.org

|----------------------------------------------------+

| Name: DeLuxe Article Portal

| Version: 1.0

| Author: Smokeman

| Web: PHPFusion-Tips.dk

| URL: http://www.phpfusion-tips.dk

+----------------------------------------------------*/

require_once "../../maincore.php";

require_once THEMES."templates/header.php";

include INFUSIONS."deluxe_article_portal/infusion_db.php";



add_to_title(" - DeLuxe Article Portal");



if (file_exists(INFUSIONS."deluxe_article_portal/locale/".$settings['locale'].".php")) {

   include INFUSIONS."deluxe_article_portal/locale/".$settings['locale'].".php";

} else {

   include INFUSIONS."deluxe_article_portal/locale/English.php";

}



echo "<script type='text/javascript' language='JavaScript' src='".INCLUDES."jscript.js'></script>";



opentable($locale['dap_001']);



//---------- 3 ELEMENTS START ----------//



echo "<center><table width='100%'><tr>



<td valign='top' width='33%' class='small'>";

openside($locale['dap_002']);

include INFUSIONS."deluxe_article_portal/new_article.php";

closeside();

echo "</td>";



echo "<td valign='top' width='33%' class='small'>";

openside($locale['dap_003']);

include INFUSIONS."deluxe_article_portal/popular_articles.php";

closeside();

echo "</td>";



echo "<td valign='top' width='33%' class='small' align='center'>";

openside($locale['dap_004']);

include INFUSIONS."deluxe_article_portal/submit_article.php";

closeside();

echo "</td>



</tr></table></center>\n";



echo "<hr /><center>

".$locale['dap_010']." <b>".number_format(dbcount("(article_id)", DB_ARTICLES))."</b> ".$locale['dap_011']." <b>".number_format(dbcount("(article_cat_id)", DB_ARTICLE_CATS))."</b> ".$locale['dap_012'].".

</center><hr />";



//---------- 3 ELEMENTS END ----------//





if (!isset($_GET['sortby']) || !preg_match("/^[0-9A-Z]$/", $_GET['sortby'])) { $_GET['sortby'] = "all"; }

   $orderby = ($_GET['sortby'] == "all" ? "" : " WHERE article_cat_name LIKE '".stripinput($_GET['sortby'])."%'");

   $result = dbquery("SELECT * FROM ".DB_ARTICLE_CATS.$orderby."");

   $rows = dbrows($result);

   if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }





if ($rows != 0) {

   $i = 0;

   $colspan = $rows >= 3 ? "colspan='3' " : ($rows == 2 ? "colspan='2' " : "");

   $width = $rows >= 3 ? "33%" : ($rows == 2 ? "50%" : "100%");

   echo "<table align='center' cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>



<tr>

<td class='tbl1'>";



echo "<table align='center' cellpadding='0' cellspacing='5' width='100%'>

<tr>\n";

   

$result3 = dbquery("SELECT * FROM ".DB_DAP."");

$data3 = dbarray($result3);   

   

   $result = dbquery("SELECT * FROM ".DB_ARTICLE_CATS.$orderby." ORDER BY article_cat_name ASC LIMIT ".$data3['numofarticles_cats']."");



   while ($data = dbarray($result)) {

      if ($i != 0 && $i % 3 == 0) {

         $cell_color = ($i % 2 == 0 ? "tbl1" : "tbl1");

         echo "</tr>

</table>

</td>

</tr>

<tr>\n";



echo "<td class='$cell_color' valign='top'>\n";



echo "<table align='center' cellpadding='0' cellspacing='5' width='100%' valign='top'>\n";

echo "<tr>\n";



   }   



      $num = dbcount("(article_cat)", DB_ARTICLES, "article_cat='".$data['article_cat_id']."'");

      $i ++;

$rowstart="0";



echo "<td width='$width' valign='top'>\n";

openside("".trimlink($data['article_cat_name'], $data3['numofarticles_catschars'])."", "on");



$qresult=dbquery("SELECT * FROM ".DB_ARTICLES." WHERE article_cat='".$data['article_cat_id']."' ORDER BY article_datestamp DESC LIMIT ".$data3['numofarticles_link']."");

echo "<a href='".BASEDIR."articles.php?cat_id=".$data['article_cat_id']."' title=\"header=[".$data['article_cat_name']."] body=[".rawurlencode("".$data['article_cat_description']."")."] delay=[0] fade=[off]\" class='orange'><b>".$locale['dap_015']."</b></a> <span class='small2'>($num)</span><br />";

while($data2=dbarray($qresult)){

echo "".THEME_BULLET." <a target='_self' href='".BASEDIR."articles.php?cat_id=".$data2['article_cat']."&amp;article_id=".$data2['article_id']."' title=\"header=[".$data2['article_subject']."] body=[".rawurlencode("".$data2['article_snippet']."")."] delay=[0] fade=[off]\" class='side'>".trimlink($data2['article_subject'], $data3['numofarticles_linkchars'])."</a>\n<br />";

}



closeside();

echo "</td>\n";

$result3 = dbquery("SELECT * FROM ".DB_DAP."");

$data3 = dbarray($result3);

      if (($rows - $rowstart) > 3 && ($i == $data3['numofarticles_cats'] || $i == ($rows - $rowstart))) {

         while($i % 3 != 0) {

            $cell_color = ($i % 2 == 0 ? "tbl1" : "tbl1");

             echo "<td width='33%'> </td>\n";

            $i ++;

         }

      }

   }



echo "</tr>\n";   

echo "</table>\n";



   echo "</td>\n</tr>\n</table>\n";

} else {



   echo "<center><br />\n".$locale['dap_013']." <b>".$_GET['sortby']."</b><br /><br />\n</center>\n";

}

$search = array(

   "A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R",

   "S","T","U","V","W","X","Y","Z","0","1","2","3","4","5","6","7","8","9"

);

echo "<hr />

<table align='center' cellpadding='0' cellspacing='1' class='tbl-border'>\n<tr>\n

<td rowspan='2' class='tbl2'><a href='".FUSION_SELF."?sortby=all' title=\"header=[".$locale['dap_014']."] body=[".rawurlencode("".$locale['dap_016']."")."] delay=[0] fade=[off]\">".$locale['dap_014']."</a></td>\n";

for ($i = 0; $i < 36 != ""; $i++) {

echo "<td align='center' class='tbl1'>\n<div class='small'><a href='".FUSION_SELF."?sortby=".$search[$i]."' title=\"header=[".$locale['dap_017']."] body=[".rawurlencode("".$locale['dap_018']."<b>".$search[$i]."</b>")."] delay=[0] fade=[off]\">".$search[$i]."</a></div>\n</td>\n";

echo ($i == 17 ? "\n

<td rowspan='2' class='tbl2'><a href='".FUSION_SELF."?sortby=all' title=\"header=[".$locale['dap_014']."] body=[".rawurlencode("".$locale['dap_016']."")."] delay=[0] fade=[off]\">".$locale['dap_014']."</a></td>\n</tr>\n<tr>\n" : "\n");

}

echo "</tr>\n</table>\n";



echo "<table align='center' cellpadding='0' cellspacing='0' width='100%'><tr><td align='right'><a href='http://www.phpfusion-tips.dk/' title=\"header=[".$locale['dap_001']."] body=[".rawurlencode("<center>Powered by:<br />PHPFusion-Tips.dk<br /><a href='http://www.phpfusion-tips.dk/' target='_blank'><img src='".INFUSIONS."/deluxe_article_portal/images/phpftips.gif' alt='PHPFusion-Tips.dk' border='0' /></a></center>")."] delay=[0] fade=[off]\" title='' target='_blank'>&copy;</a></td></tr></table>\n";



closetable();



$result3 = dbquery("SELECT * FROM ".DB_DAP);

$data3 = dbarray($result3);



if ($rows > $data3['numofarticles_cats']) { echo "<div align='center' style='margin-top:5px;'>".makepagenav($_GET['rowstart'], $data3['numofarticles_cats'], $rows, 3, FUSION_SELF."?sortby=".$_GET['sortby']."&amp;")."</div>\n"; }

require_once THEMES."templates/footer.php";

?>