download

Gesperrt
sophie
Beiträge: 36
Registriert: Mi 14. Apr 2004, 15:23
Wohnort: Berlin
Kontaktdaten:
Kontaktdaten von sophie

Beschreibung download

Beitrag von sophie » Mi 26. Mai 2004, 11:07

Ist schon ein bischen was her, aber die Beschreibung kannst Du in
der Dateiverwaltung angeben.
Sophie
Nach oben
hyperjojo
Beiträge: 102
Registriert: Fr 1. Nov 2002, 23:57
Kontaktdaten:
Kontaktdaten von hyperjojo

Beitrag von hyperjojo » So 30. Mai 2004, 15:49

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>";
?>
Nach oben
alter schwede
Beiträge: 65
Registriert: So 13. Jun 2004, 01:27
Kontaktdaten:
Kontaktdaten von alter schwede

Beitrag von alter schwede » Do 22. Jul 2004, 08:04

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 ...
Zuletzt geändert von alter schwede am Do 22. Jul 2004, 11:21, insgesamt 2-mal geändert.
Nach oben
ixepter
Beiträge: 65
Registriert: So 11. Jan 2004, 12:08
Kontaktdaten:
Kontaktdaten von ixepter

Beitrag von ixepter » Do 22. Jul 2004, 10:16

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?
Nach oben
alter schwede
Beiträge: 65
Registriert: So 13. Jun 2004, 01:27
Kontaktdaten:
Kontaktdaten von alter schwede

Beitrag von alter schwede » Do 22. Jul 2004, 10:42

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 ...
Zuletzt geändert von alter schwede am Do 22. Jul 2004, 11:25, insgesamt 1-mal geändert.
Nach oben
hyperjojo
Beiträge: 102
Registriert: Fr 1. Nov 2002, 23:57
Kontaktdaten:
Kontaktdaten von hyperjojo

Beitrag von hyperjojo » Do 22. Jul 2004, 10:45

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
Nach oben
alter schwede
Beiträge: 65
Registriert: So 13. Jun 2004, 01:27
Kontaktdaten:
Kontaktdaten von alter schwede

Beitrag von alter schwede » Do 22. Jul 2004, 10:50

Bug wurde gefixt!

@hyperjojo
So ein Zufall :wink:
Nach oben
ixepter
Beiträge: 65
Registriert: So 11. Jan 2004, 12:08
Kontaktdaten:
Kontaktdaten von ixepter

Beitrag von ixepter » Do 22. Jul 2004, 19:17

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.....
Nach oben
alter schwede
Beiträge: 65
Registriert: So 13. Jun 2004, 01:27
Kontaktdaten:
Kontaktdaten von alter schwede

Beitrag von alter schwede » Do 22. Jul 2004, 20:51

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?
Nach oben
hyperjojo
Beiträge: 102
Registriert: Fr 1. Nov 2002, 23:57
Kontaktdaten:
Kontaktdaten von hyperjojo

Beitrag von hyperjojo » Do 29. Jul 2004, 18:52

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)
Nach oben
ulisteinle
Beiträge: 53
Registriert: Sa 13. Mär 2004, 21:59
Wohnort: D -> BW -> HN
Kontaktdaten:
Kontaktdaten von ulisteinle

Beitrag von ulisteinle » Fr 30. Jul 2004, 09:29

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
Nach oben
Gesperrt

Zurück zu „Version 4.4“