CONTENIDO Forum

Das Diskussionsforum zum Open Source Content Management System
https://forum.contenido.org/

download

https://forum.contenido.org/viewtopic.php?t=3183

Seite 2 von 2

Beschreibung download

Verfasst: Mi 26. Mai 2004, 11:07
von sophie
Ist schon ein bischen was her, aber die Beschreibung kannst Du in
der Dateiverwaltung angeben.
Sophie

Verfasst: So 30. Mai 2004, 15:49
von hyperjojo
hi,

dankeschön!
manchmal ist man halt bisschen dussel... ;)

naja, ich habs noch ein wenig modifiziert:
- es sind 20 Downloads möglich
- Angezeigt wird die Beschreibung
- Die Größe des Downloads wird mit ausgegeben

Ich hab die Anzeige jetzt mal als <ul>-Liste gemacht, kann man natürlich auch wieder als Tabelle machen. Der Filename habe ich jetzt ganz rausgenommen, kann natürlich auch wieder angezeigt werden.
Zu sehen ist das Ganze auf http://clemens-web.de/?idcat=17

Und hier noch der Code:

Code: Alles auswählen

<?php
/*********************************************** 
* CONTENIDO MODUL - INPUT 
*
* Modulname	:	Downloadliste
* over-worked by Johannes Clemens
* Copyright	:	Johannes Clemens
* Modified	:	2004-05-30
* www.clemens-web.de
************************************************/
# original
/***********************************************
* Modulname   :     Download
* Author      :     4fb - Jan Lengowski/ 4.3.1b mods by J. Matern
* Copyright   :     Contenido - four for business
* Created     :     26-08-2002
* Modified    :     05-07-2003
************************************************/ 
$wert = 0;
$werte = array(
"CMS_VAR[1]", "CMS_VALUE[1]", "CMS_VAR[3]", "CMS_VALUE[3]" ,
"CMS_VAR[4]", "CMS_VALUE[4]", "CMS_VAR[6]", "CMS_VALUE[6]" ,
"CMS_VAR[7]", "CMS_VALUE[7]", "CMS_VAR[9]", "CMS_VALUE[9]" ,
"CMS_VAR[10]", "CMS_VALUE[10]", "CMS_VAR[12]", "CMS_VALUE[12]" ,
"CMS_VAR[13]", "CMS_VALUE[13]", "CMS_VAR[15]", "CMS_VALUE[15]" ,
"CMS_VAR[16]", "CMS_VALUE[16]", "CMS_VAR[18]", "CMS_VALUE[18]" ,
"CMS_VAR[19]", "CMS_VALUE[19]", "CMS_VAR[21]", "CMS_VALUE[21]" ,
"CMS_VAR[22]", "CMS_VALUE[22]", "CMS_VAR[24]", "CMS_VALUE[24]" ,
"CMS_VAR[25]", "CMS_VALUE[25]", "CMS_VAR[27]", "CMS_VALUE[27]" ,
"CMS_VAR[28]", "CMS_VALUE[28]", "CMS_VAR[30]", "CMS_VALUE[30]" ,
"CMS_VAR[31]", "CMS_VALUE[31]", "CMS_VAR[33]", "CMS_VALUE[33]" ,
"CMS_VAR[34]", "CMS_VALUE[34]", "CMS_VAR[36]", "CMS_VALUE[36]" ,
"CMS_VAR[37]", "CMS_VALUE[37]", "CMS_VAR[39]", "CMS_VALUE[39]" ,
"CMS_VAR[40]", "CMS_VALUE[40]", "CMS_VAR[42]", "CMS_VALUE[42]" ,
"CMS_VAR[43]", "CMS_VALUE[43]", "CMS_VAR[45]", "CMS_VALUE[45]" ,
"CMS_VAR[46]", "CMS_VALUE[46]", "CMS_VAR[48]", "CMS_VALUE[48]" ,
"CMS_VAR[49]", "CMS_VALUE[49]", "CMS_VAR[51]", "CMS_VALUE[51]" ,
"CMS_VAR[52]", "CMS_VALUE[52]", "CMS_VAR[54]", "CMS_VALUE[54]" ,
"CMS_VAR[55]", "CMS_VALUE[55]", "CMS_VAR[57]", "CMS_VALUE[57]" ,
"CMS_VAR[58]", "CMS_VALUE[58]", "CMS_VAR[60]", "CMS_VALUE[60]" ,
);

$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'";

$db->query($query);

while ($db->next_record()) {
	//$knurpsel replaces old $filename
	$knurpsel[$db->f("idupl")] = $db->f("filename");

} // end while

function d_checked($which) {
  if ($which != "") {
    return "checked";
  }
} // end function

echo "<table width=\"300\" cellspacing=\"1\" cellpadding=\"4\" border=\"0\" bgcolor=\"#000000\">
        <tr bgcolor=\"#cccccc\" align=\"center\">
          <td>Aktiv</td>
          <td>Datei wählen</td>
        </tr>";
for ( $i = 0; $i < 20; $i++ ){
      echo "<tr bgcolor=\"#ffffff\" align=\"center\">
                 <td><input name=\"$werte[$wert]\" value=\"on\"";
      $wert++;
      echo "type=\"checkbox\" ".d_checked("$werte[$wert]")."></td>
                 <td>";
$wert++;
echo "<select name=\"$werte[$wert]\">";
      $wert++;
      if (is_array($knurpsel)) {
          foreach ($knurpsel as $key => $value) {
                   if ("$werte[$wert]" == $key) {
                        echo "<option selected=\"selected\" value=\"". $key ."\">". $value ."</option>";
                   } else {
                        echo "<option value=\"". $key ."\">". $value ."</option>";
                   } // end if
          } // end foreach
      } // end if

      echo "  </select></td></tr>";
      $wert++;
} // for ende
echo "</table>"; 
?>

Code: Alles auswählen

<?php
/*********************************************** 
* CONTENIDO MODUL - OUTPUT 
*
* Modulname	:	Downloadliste
* over-worked by Johannes Clemens
* Copyright	:	Johannes Clemens
* Modified	:	2004-05-30
* www.clemens-web.de
************************************************/
# original
/***********************************************
* Modulname   :     Download
* Author      :     4fb - Jan Lengowski/ 4.3.1b mods by J. Matern
* Copyright   :     Contenido - four for business
* Created     :     26-08-2002
* Modified    :     05-07-2003
************************************************/ 
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\"><ul>";
function showfile() {
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
  $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  return "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
}

if ("CMS_VALUE[1]" == "on") {
  $s = "CMS_VALUE[3]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
	echo showfile();
} // end if

if ("CMS_VALUE[4]" == "on") {
  $s = "CMS_VALUE[6]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[7]" == "on") {
  $s = "CMS_VALUE[9]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[10]" == "on") {
  $s = "CMS_VALUE[12]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[13]" == "on") {
  $s = "CMS_VALUE[15]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[16]" == "on") {
  $s = "CMS_VALUE[18]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[19]" == "on") {
  $s = "CMS_VALUE[21]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[22]" == "on") {
  $s = "CMS_VALUE[24]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[25]" == "on") {
  $s = "CMS_VALUE[27]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[28]" == "on") {
  $s = "CMS_VALUE[30]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[31]" == "on") {
  $s = "CMS_VALUE[33]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[34]" == "on") {
  $s = "CMS_VALUE[36]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[37]" == "on") {
  $s = "CMS_VALUE[39]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[40]" == "on") {
  $s = "CMS_VALUE[42]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[43]" == "on") {
  $s = "CMS_VALUE[45]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[46]" == "on") {
  $s = "CMS_VALUE[48]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[49]" == "on") {
  $s = "CMS_VALUE[51]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[52]" == "on") {
  $s = "CMS_VALUE[54]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[55]" == "on") {
  $s = "CMS_VALUE[57]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

if ("CMS_VALUE[58]" == "on") {
  $s = "CMS_VALUE[60]";
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'pdf'"." AND idupl = '$s'";
  $db->query($query);
  $db->next_record();
  $file = $db->f("filename");
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename");
        $description = $db->f("description");
				$size= $db->f("size");
				$size=$size/1024/1024;
				$size=@round($size,2);
				$size=$size." MB";
  echo "<li><a target=\"_blank\" href=\"$href\">$description</a> ($size)</li>";
} // end if

echo "</ul></table>";
?>

Verfasst: Do 22. Jul 2004, 08:04
von alter schwede
Das Modul von hyperjojo war als Standart-Downloadliste noch nicht ganz optimal. Habe das Modul daher modifiziert.

Änderungen:
- Dateinamenanzeige (notwendig fals keine Dateibeschreibung vorliegt)
- mehrere Dateitypen (je nach Bedarf einschränken) ('pdf' 'doc' 'zip' 'exe' 'gif' 'jpeg' 'jpg' 'png' 'txt' 'ppt' 'xls' 'avi' 'wmv' 'mpg' 'mpeg' 'mp3' 'wav')

Code: Alles auswählen

/*********************************************** 
* CONTENIDO MODUL - INPUT 
* 
* Modulname   :   Downloadliste 
* over-worked by Johannes Clemens 
* Copyright   :   Johannes Clemens 
* Modified   :   2004-05-30 
* www.clemens-web.de
* Modified again : 2004-07-22 by "alter schwede"
************************************************/ 
# original 
/*********************************************** 
* Modulname   :     Download 
* Author      :     4fb - Jan Lengowski/ 4.3.1b mods by J. Matern 
* Copyright   :     Contenido - four for business 
* Created     :     26-08-2002 
* Modified    :     05-07-2003 
************************************************/ 
$wert = 0; 
$werte = array( 
"CMS_VAR[1]", "CMS_VALUE[1]", "CMS_VAR[3]", "CMS_VALUE[3]" , 
"CMS_VAR[4]", "CMS_VALUE[4]", "CMS_VAR[6]", "CMS_VALUE[6]" , 
"CMS_VAR[7]", "CMS_VALUE[7]", "CMS_VAR[9]", "CMS_VALUE[9]" , 
"CMS_VAR[10]", "CMS_VALUE[10]", "CMS_VAR[12]", "CMS_VALUE[12]" , 
"CMS_VAR[13]", "CMS_VALUE[13]", "CMS_VAR[15]", "CMS_VALUE[15]" , 
"CMS_VAR[16]", "CMS_VALUE[16]", "CMS_VAR[18]", "CMS_VALUE[18]" , 
"CMS_VAR[19]", "CMS_VALUE[19]", "CMS_VAR[21]", "CMS_VALUE[21]" , 
"CMS_VAR[22]", "CMS_VALUE[22]", "CMS_VAR[24]", "CMS_VALUE[24]" , 
"CMS_VAR[25]", "CMS_VALUE[25]", "CMS_VAR[27]", "CMS_VALUE[27]" , 
"CMS_VAR[28]", "CMS_VALUE[28]", "CMS_VAR[30]", "CMS_VALUE[30]" , 
"CMS_VAR[31]", "CMS_VALUE[31]", "CMS_VAR[33]", "CMS_VALUE[33]" , 
"CMS_VAR[34]", "CMS_VALUE[34]", "CMS_VAR[36]", "CMS_VALUE[36]" , 
"CMS_VAR[37]", "CMS_VALUE[37]", "CMS_VAR[39]", "CMS_VALUE[39]" , 
"CMS_VAR[40]", "CMS_VALUE[40]", "CMS_VAR[42]", "CMS_VALUE[42]" , 
"CMS_VAR[43]", "CMS_VALUE[43]", "CMS_VAR[45]", "CMS_VALUE[45]" , 
"CMS_VAR[46]", "CMS_VALUE[46]", "CMS_VAR[48]", "CMS_VALUE[48]" , 
"CMS_VAR[49]", "CMS_VALUE[49]", "CMS_VAR[51]", "CMS_VALUE[51]" , 
"CMS_VAR[52]", "CMS_VALUE[52]", "CMS_VAR[54]", "CMS_VALUE[54]" , 
"CMS_VAR[55]", "CMS_VALUE[55]", "CMS_VAR[57]", "CMS_VALUE[57]" , 
"CMS_VAR[58]", "CMS_VALUE[58]", "CMS_VAR[60]", "CMS_VALUE[60]" , 
); 

$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE 
filetype = 'pdf' 
or filetype='doc' 
or filetype='zip' 
or filetype='exe' 
or filetype='gif' 
or filetype='jpeg' 
or filetype='jpg' 
or filetype='png' 
or filetype='txt' 
or filetype='ppt' 
or filetype='xls' 
or filetype='avi' 
or filetype='wmv' 
or filetype='mpg' 
or filetype='mpeg' 
or filetype='mp3' 
or filetype='wav' 
"; 

$db->query($query); 

while ($db->next_record()) { 
   //$knurpsel replaces old $filename 
   $knurpsel[$db->f("idupl")] = $db->f("filename"); 

} // end while 

function d_checked($which) { 
  if ($which != "") { 
    return "checked"; 
  } 
} // end function 

echo "<table width=\"300\" cellspacing=\"1\" cellpadding=\"4\" border=\"0\" bgcolor=\"#000000\"> 
        <tr bgcolor=\"#cccccc\" align=\"center\"> 
          <td>Aktiv</td> 
          <td>Datei wählen</td> 
        </tr>"; 
for ( $i = 0; $i < 20; $i++ ){ 
      echo "<tr bgcolor=\"#ffffff\" align=\"center\"> 
                 <td><input name=\"$werte[$wert]\" value=\"on\""; 
      $wert++; 
      echo "type=\"checkbox\" ".d_checked("$werte[$wert]")."></td> 
                 <td>"; 
$wert++; 
echo "<select name=\"$werte[$wert]\">"; 
      $wert++; 
      if (is_array($knurpsel)) { 
          foreach ($knurpsel as $key => $value) { 
                   if ("$werte[$wert]" == $key) { 
                        echo "<option selected=\"selected\" value=\"". $key ."\">". $value ."</option>"; 
                   } else { 
                        echo "<option value=\"". $key ."\">". $value ."</option>"; 
                   } // end if 
          } // end foreach 
      } // end if 

      echo "  </select></td></tr>"; 
      $wert++; 
} // for ende 
echo "</table>";

Code: Alles auswählen

 
<?php 
/*********************************************** 
* CONTENIDO MODUL - OUTPUT 
* 
* Modulname   :   Downloadliste 
* over-worked by Johannes Clemens 
* Copyright   :   Johannes Clemens 
* Modified   :   2004-05-30 
* www.clemens-web.de 
************************************************/ 
# original 
/*********************************************** 
* Modulname   :     Download 
* Author      :     4fb - Jan Lengowski/ 4.3.1b mods by J. Matern 
* Copyright   :     Contenido - four for business 
* Created     :     26-08-2002 
* Modified    :     05-07-2003 again 22.07.2004 für Dateinamenanzeige, mehrere Dateitypen, ... von Sven Zimmermann
************************************************/ 
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\"><ul>"; 

if ("CMS_VALUE[1]" == "on") { 
  $s = "CMS_VALUE[3]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 


if ("CMS_VALUE[4]" == "on") { 
  $s = "CMS_VALUE[6]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[7]" == "on") { 
  $s = "CMS_VALUE[9]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[10]" == "on") { 
  $s = "CMS_VALUE[12]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[13]" == "on") { 
  $s = "CMS_VALUE[15]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[16]" == "on") { 
  $s = "CMS_VALUE[18]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[19]" == "on") { 
  $s = "CMS_VALUE[21]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>";  
} // end if 

if ("CMS_VALUE[22]" == "on") { 
  $s = "CMS_VALUE[24]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[25]" == "on") { 
  $s = "CMS_VALUE[27]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[28]" == "on") { 
  $s = "CMS_VALUE[30]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[31]" == "on") { 
  $s = "CMS_VALUE[33]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[34]" == "on") { 
  $s = "CMS_VALUE[36]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[37]" == "on") { 
  $s = "CMS_VALUE[39]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[40]" == "on") { 
  $s = "CMS_VALUE[42]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[43]" == "on") { 
  $s = "CMS_VALUE[45]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[46]" == "on") { 
  $s = "CMS_VALUE[48]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[49]" == "on") { 
  $s = "CMS_VALUE[51]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[52]" == "on") { 
  $s = "CMS_VALUE[54]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>";  
} // end if 

if ("CMS_VALUE[55]" == "on") { 
  $s = "CMS_VALUE[57]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

if ("CMS_VALUE[58]" == "on") { 
  $s = "CMS_VALUE[60]"; 
  $query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE idupl = '$s'"; 
  $db->query($query); 
  $db->next_record(); 
  $file = $db->f("filename"); 
    $href =  $cfgClient[$client]["htmlpath"]["frontend"] . $cfgClient[$client]["upload"]. $db->f("dirname") . $db->f("filename"); 
        $description = $db->f("description"); 
            $size= $db->f("size"); 
            $size=$size/1024/1024; 
            $size=@round($size,2); 
            $size=$size." MB"; 
  echo "<li><b><a target=\"_blank\" href=\"$href\">$file</a></b> $description (Größe: $size)</li>"; 
} // end if 

echo "</ul></table>"; 
?>
Hoffe es nutzt jemanden ...

Verfasst: Do 22. Jul 2004, 10:16
von ixepter
Also ich könnte das Modul rechtgut gebrauchen. Jedoch bekomm ich trotz Aktivierten Files(PDF) keine Download Liste zu sehen?! Hat niemand ein ähnliches Problem?

Verfasst: Do 22. Jul 2004, 10:42
von alter schwede
Hab gerade gemerkt, dass das Modul ein Problem mit dem ersten File der Liste hat! Wird es deaktiviert funzt es! Kümmere mich später darum ...

Verfasst: Do 22. Jul 2004, 10:45
von hyperjojo
ja, du hattest das erste File mittels der Funktion gelöst.
Das klappt leider nicht, hatte ich auch schon probiert ;)

@ixepter: Wenn du anstatt des Funktionsaufrufes einfach den Code wie bei den anderen Dateien benutzt, sollte es funktionieren (auf den ersten Blick)

ciao


Johannes

Verfasst: Do 22. Jul 2004, 10:50
von alter schwede
Bug wurde gefixt!

@hyperjojo
So ein Zufall :wink:

Verfasst: Do 22. Jul 2004, 19:17
von ixepter
Danke für den Tipp, jetzt funkt.
Jedoch ist mir etwas aufgefallen ich brauche fast alle 20 Felder. Währe es nicht praktisch wenn man nur das Verzeichnis angeben kann und danach alle Files darin angezeigt werden. Ich habe eine relativ grosse Filestruktur da sucht man sich fast zu.....

Verfasst: Do 22. Jul 2004, 20:51
von alter schwede
Ja das wäre schön! Habe aber keine Ahnung wie man das anstellen könnte.

Ich habe das gleiche Problem. Ich betreue unter anderem ein Fachportal an einer Hochschule. Das sind hunderter von Files für zig Kategorien. Dafür ist das Dateimanagment von Contenido leider ungeeignet. :( Dennoch bleibt Contenido für mich selbst hier das beste CMS! Typo3 verlangt einfach zu viel von den Redakteuren.

Glaube in der v4.5.2 waren die Dateiauswahllisten im Backend vach Verzeichnissen sortiert! Bin mir aber im Moment nicht ganz sicher. Schau die am besten den Snapschuß vom 16.7. an! Wenn ich mich irre, währe so eine Funktion auf jeden Fall sinnvoll!!!

Vielleicht sollte man aber trotzdem über eine optionale artikel- oder kategoriebasierende Datei-Verwaltung nachdenken?
Wäre so etwas den realistischerweise machbar?
Wie handeln das andere CMS-Systeme?

Verfasst: Do 29. Jul 2004, 18:52
von hyperjojo
hi,

jein...

das Problem: Man könnte die wirklich existierenden Files direkt auslesen. Aber Contenido benutzt ja nicht die real-data, sondern das, was beim Upload in der DB gespeichert wird.

Eine Dateiverwaltung, die alle Files eines Verzeichnisses mit Unterverzeichnisse auflistet ist schnell geschrieben. Nur das zu kombinieren mit den Vorteilen der DB (Dateibeschreibung, ...) ist etwas komplizierter.

Wenn ich irgendwann mal viel Zeit zuviel habe und viele Leute daran Interesse bekunden, kann ich mich ja mal dran versuchen. Vielleicht könnte man auch wieder mit mehreren gemeinsam entwickeln. Hat ja bei dem Download-Modul bisher ganz gut funktioniert.... ;)


ciao


JoJo
(gerade aus dem Urlaub zurück)

Verfasst: Fr 30. Jul 2004, 09:29
von ulisteinle
Eine kleine Frage zum SQL Statement:

Was muss ich ändern, wenn ich nur die Dateien eines bestimmten (dem aktuellen) Mandanten angezeigt haben will?

Hab heute morhen irgendwie ´nen Knoten im Hirn...

Gruß
Uli
Alle Zeiten sind UTC+01:00
Seite 2 von 2

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de