CONTENIDO Forum

Code: Alles auswählen

?><?php
/***********************************************
* CONTENIDO MODUL - INPUT
*
* Modulname   :     Artikelliste nach Artikel-Spezifikation
* Author      :     Markus Heinzer
* Created     :     25.12.2005
************************************************/

if ("CMS_VALUE[1]" == '')
        {$cms_spec = '1';} else {$cms_spec = "CMS_VALUE[1]";}

if ("CMS_VALUE[2]" == '') 
	{$cms_order = 'title';} else {$cms_order = "CMS_VALUE[2]";}

if ("CMS_VALUE[3]" == '') 
        {$cms_direction = 'asc';} else {$cms_direction = "CMS_VALUE[3]";} 

$db = new DB_Contenido;

$sql = "SELECT SPEC.idartspec, SPEC.artspec, SPEC.client, SPEC.lang 
        FROM {$cfg['tab']['art_spec']} AS SPEC
        WHERE SPEC.client = '$client'
           AND SPEC.lang = '$lang'
        ORDER BY SPEC.idartspec asc";

$db->query($sql);

echo '<table class="text_medium">';

echo '<tr>
          <td>'.mi18n("gewünschte Artikel-Spezifikation").':</td>
          <td><select name="CMS_VAR[1]" size="1">';

               while ($db->next_record())
               {
                    $db_idartspec = $db->f("idartspec");
                    $db_artspec = $db->f("artspec");

                    if ($db_idartspec == $cms_spec) 
                    {echo '<option value="'.$db_idartspec.'" selected="selected">'.$db_artspec.'</option>';}
                    else 
                    {echo '<option value="'.$db_idartspec.'">'.$db_artspec.'</option>';}
               }    
               echo '</select></td></tr>';

echo '<tr>
          <td>'.mi18n("Sortierung nach Artikeltitel").':</td>
          <td><input type="radio" name="CMS_VAR[2]" value="title" ';
                      if ("CMS_VALUE[2]" == 'title') {echo 'checked="checked"';}
                      echo '></td></tr>';
echo '<tr>
          <td>'.mi18n("Sortierung nach Änderungsdatum").':</td>
          <td><input type="radio" name="CMS_VAR[2]" value="lastmodified" ';
                      if ("CMS_VALUE[2]" == 'lastmodified') {echo 'checked="checked"';}
                      echo '></td></tr>';
echo '<tr>
          <td>'.mi18n("Sortierung nach Sortiernummer").':</td>
          <td><input type="radio" name="CMS_VAR[2]" value="artsort" ';
                      if ("CMS_VALUE[2]" == 'artsort') {echo 'checked="checked"';}
                      echo '></td></tr>';
echo '<tr>
          <td>'.mi18n("Sortierung aufsteigend").':</td>
          <td><input type="radio" name="CMS_VAR[3]" value="asc" ';
                      if ("CMS_VALUE[3]" == 'asc') {echo 'checked="checked"';}
                      echo '></td></tr>';
echo '<tr>
          <td>'.mi18n("Sortierung absteigend").':</td>
          <td><input type="radio" name="CMS_VAR[3]" value="desc" ';
                      if ("CMS_VALUE[3]" == 'desc') {echo 'checked="checked"';}
                      echo '></td></tr>';
echo '</table>';
?><?php

Code: Alles auswählen

<?php 

/***********************************************
* CONTENIDO MODUL - OUTPUT
*
* Modulname   :     Artikelliste nach Artikel-Spezifikation
* Author      :     Markus Heinzer
* Created     :     25.12.2005
************************************************/

$cms_spec = "CMS_VALUE[1]";
$cms_order = "CMS_VALUE[2]";
$cms_order = 'ART.'.$cms_order;
$cms_direction = "CMS_VALUE[3]";

$db = new DB_Contenido;

$sql = "SELECT ART.idart, ART.idlang, ART.title, ART.lastmodified, ART.artsort, ART.artspec 
          FROM {$cfg['tab']['art_lang']} AS ART
        WHERE ART.artspec = '$cms_spec' 
          AND ART.idlang = '$lang'
        ORDER BY $cms_order $cms_direction";

$db->query($sql);

while ($db->next_record())
{ 
     $db_idart = $db->f("idart");
     $db_title = $db->f("title");
     echo '<a href="front_content.php?idart='.$db_idart.'">'.$db_title.'</a>';
}
?>