Seite 1 von 1

Downloadliste: AVIs und MPGs gleichzeitig?

Verfasst: Mo 12. Jul 2004, 12:36
von ReneWho
Hallo,

mich plagt mal wieder was (so langsam wäre ein PHP crashkurs
richtig wünschenswert für mich *gg*)

Ich habe untenstehendes modul als downloadlist in meinem contenido
system. ursprünglich war es für PDFs gedacht, naja ich hab die
extensions geändert und jetzt ist es eine avi downloadliste. aaaaber:
was mache ich, wenn ich statt nur AVIs auch noch MPGs und WMAs
auf dieser liste anzeigen lasse?
lässt sich folgender code irgendwie erweitern?

Code: Alles auswählen

$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype ='AVI'";
in z.b ?

Code: Alles auswählen

$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'avi'AND 'MPG' AND 'WMA'";

Verfasst: Mo 12. Jul 2004, 12:39
von emergence
ähm, vielleicht so...

Code: Alles auswählen

$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'avi' OR filetype = 'mpg' OR filetype ='wma'";

Verfasst: Mo 12. Jul 2004, 13:13
von ReneWho
Ne geht nicht.
bzw. geht garnix mehr.

Verfasst: Mo 12. Jul 2004, 13:17
von emergence
ähm das query geht bei mir... keine ahnung was du gemacht hast...
schau ins errorlog.txt

Verfasst: Mo 12. Jul 2004, 13:20
von ReneWho
Komando stop...so ein dämliches AR**** von kunden **** d***
user. ich könnte ihm in den **** treten. hat der nicht eben gerade
alle files aus dem verzeichnis gelöscht??? da kann auch nichts
gehen ahhrrrghhhh....lieber gott lass hirn regnen

danke :-)

Verfasst: Mo 12. Jul 2004, 13:21
von Halchteranerin
emergences Abfrage ist aber richtig.
@ReneWho: haben Deine Dateinamen die Erweiterungen in Klein- oder in Grossbuchstaben? Falls gross, dann koennte es daran liegen. Falls Du gross und klein gemischt hast, solltest Du eher so etwas einbauen:

Code: Alles auswählen

$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'avi' OR filetype = 'AVI' OR filetype = 'mpg' OR filetype = 'MPG' OR filetype ='wma' OR filetype = 'WMA'"; 

Verfasst: Mo 12. Jul 2004, 13:22
von Halchteranerin
aehm, na gut, da kann man machen nix ...

Verfasst: Mo 12. Jul 2004, 13:58
von ReneWho
Ein problemchen hat sich da aber noch aufgetan.
der inputbereich funktioniert einwandfrei.
dein outputbereich habe ich folgendermaßen geändert

Code: Alles auswählen

$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma'"." AND idupl = '$s'";
nur wird jetzt im output jedesmal die gleiche datei angezeigt.
wenn ich also 5 verschiedene mpgs nehme, zeigt er mir
5 mal das 1 mpg an. very strange....

Verfasst: Mo 12. Jul 2004, 14:45
von pit
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma'"." AND idupl = '$s'";
könnte sein, dass da ne Klammer fehlt?!

$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma') AND idupl = '$s'";

versuchs mal

Verfasst: Mo 12. Jul 2004, 16:46
von ReneWho
Jups.

Sieht der ausgabe code so aus, kommen avis und mpgs dabei raus :-)

Code: Alles auswählen

$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." AND idupl = '$s'";
Solche klammern bewirken wunder, wenn ich groß bin will ich
auch mal eine werden :lol:

grüßels René

Verfasst: Mo 12. Jul 2004, 18:09
von ReneWho
Falls jemand das modul braucht (ich finde es sehr komfortabel)
hier die funktionierende version in komplett. Ich sollte dem
user der die bilder gelöscht hat den account löschen (notiz schreib...)

Modul Input:

Code: Alles auswählen

################### 
# over-worked by 
# 
# Thomas Broich 
# mywork@cidnet.de 
# 
# Modified : 20.2.2004 
################### 
# 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[30]", "CMS_VALUE[30]", "CMS_VAR[32]", "CMS_VALUE[32]" , 
"CMS_VAR[35]", "CMS_VALUE[35]", "CMS_VAR[37]", "CMS_VALUE[37]" , 
"CMS_VAR[39]", "CMS_VALUE[39]", "CMS_VAR[41]", "CMS_VALUE[41]" , 
"CMS_VAR[43]", "CMS_VALUE[43]", "CMS_VAR[45]", "CMS_VALUE[45]" , 
"CMS_VAR[47]", "CMS_VALUE[47]", "CMS_VAR[49]", "CMS_VALUE[49]" , 
"CMS_VAR[51]", "CMS_VALUE[51]", "CMS_VAR[54]", "CMS_VALUE[54]" , 
"CMS_VAR[57]", "CMS_VALUE[57]", "CMS_VAR[60]", "CMS_VALUE[60]" , 
"CMS_VAR[62]", "CMS_VALUE[62]", "CMS_VAR[65]", "CMS_VALUE[65]" , 
"CMS_VAR[68]", "CMS_VALUE[68]", "CMS_VAR[71]", "CMS_VALUE[71]" , 
"CMS_VAR[74]", "CMS_VALUE[74]", "CMS_VAR[77]", "CMS_VALUE[77]"); 

$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma'"; 

$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=\"350\" cellspacing=\"1\" cellpadding=\"4\" border=\"0\" bgcolor=\"#000000\"> 
<tr bgcolor=\"#cccccc\" align=\"center\"> 
<td class=text>Aktiv</td> 
<td class=text>Datei wählen</td> 
</tr>"; 
for ( $i = 0; $i < 19; $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>"; 
Modul Output

Code: Alles auswählen

<?php 



echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">"; 

if ("CMS_VALUE[1]" == "on") { 

$s = "CMS_VALUE[3]";
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr><td colspan=\"2\" heigth=\"1\" ><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 
echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\" ></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=\"main\" target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 

} // end if 

if ("CMS_VALUE[4]" == "on") { 

$s = "CMS_VALUE[6]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\" ></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=\"main\" target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 

} // end if 

if ("CMS_VALUE[7]" == "on") { 

$s = "CMS_VALUE[9]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\" ></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=\"main\" target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 

} // end if 

if ("CMS_VALUE[10]" == "on") { 

$s = "CMS_VALUE[12]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\" ></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=\"main\" target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 

} // end if 

if ("CMS_VALUE[13]" == "on") { 

$s = "CMS_VALUE[15]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\"></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=\"main\" target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 

} // end if 

if ("CMS_VALUE[16]" == "on") { 

$s = "CMS_VALUE[18]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\" ></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=\"main\" target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 

} // end if 


if ("CMS_VALUE[19]" == "on") { 

$s = "CMS_VALUE[21]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\" ></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=\"main\" target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 

} // end if 

if ("CMS_VALUE[22]" == "on") { 

$s = "CMS_VALUE[24]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\" ></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=\"main\" target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 

} // end if 

if ("CMS_VALUE[25]" == "on") { 

$s = "CMS_VALUE[27]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\"></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=main target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 


} // end if 

if ("CMS_VALUE[30]" == "on") { 

$s = "CMS_VALUE[32]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\"></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=main target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 


} // end if 

if ("CMS_VALUE[35]" == "on") { 

$s = "CMS_VALUE[37]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\"></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=main target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 


} // end if 

if ("CMS_VALUE[39]" == "on") { 

$s = "CMS_VALUE[41]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\"></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=main target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 


} // end if 

if ("CMS_VALUE[43]" == "on") { 

$s = "CMS_VALUE[45]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\"></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=main target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 


} // end if 


if ("CMS_VALUE[47]" == "on") { 

$s = "CMS_VALUE[49]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\"></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=main target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 


} // end if 

if ("CMS_VALUE[51]" == "on") { 

$s = "CMS_VALUE[54]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\"></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=main target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 


} // end if 

if ("CMS_VALUE[57]" == "on") { 

$s = "CMS_VALUE[60]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\"></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=main target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 


} // end if 

if ("CMS_VALUE[62]" == "on") { 

$s = "CMS_VALUE[65]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\"></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=main target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 


} // end if 


if ("CMS_VALUE[68]" == "on") { 

$s = "CMS_VALUE[71]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\"></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=main target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 


} // end if 

if ("CMS_VALUE[74]" == "on") { 

$s = "CMS_VALUE[77]"; 
$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE (filetype = 'avi' OR filetype = 'mpg' OR filetype = 'wma')"." 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"); 

echo "<tr height=\"20\"> 
<td align=\"center\" width=\"20\" ><a target=\"_blank\" href=\"$href\"><img src=\"/images/icon_avi.gif\" border=\"0\"></a></td> 
<td style=\"padding-left:20px\" width=\"460\"  class=\"text11bn\" width=\"\"><a class=main target=\"_blank\" href=\"$href\">$file</a><BR>$description</td> 
</tr>"; 
echo "<tr><td colspan=\"2\" heigth=\"1\"><img src=\"images/spacer.gif\" width=\"1\" height=\"1\"></td></tr>"; 


} // end if 


echo "</table><br><br>"; 

?>
Und hier das dazugehörige Icon:
Bild

Verfasst: Mi 26. Jan 2005, 09:52
von bachi
Hallo, kann mir einer sagen, was zu tun ist, dass ich bei dem Modul die "Pluszeichen", die generiert werden aus den Leerzeichen bei der Dateibeschreibung weg bekomme?
Danke + Grüße
Bachi

Verfasst: Mi 26. Jan 2005, 10:05
von kummer
probiers mit urldecode()

gruss,
andreas

ps: habe ich da nicht irgendwo gelesen ein php-crashkurs täte gut? bitte melden! ich suche noch interessenten. sobald ich ein geeigentes kurslokal aufgetrieben habe, werde ich in deutschland einen kurs durchführen (mit schwerpunkt modulprogrammierung für contenido). interessenten melden sich (unverbindlich): kummer@w3concepts.net