Downloadliste: AVIs und MPGs gleichzeitig?

Gesperrt
ReneWho
Beiträge: 101
Registriert: Do 5. Feb 2004, 13:10
Kontaktdaten:

Downloadliste: AVIs und MPGs gleichzeitig?

Beitrag von ReneWho » Mo 12. Jul 2004, 12:36

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'";
Zuletzt geändert von ReneWho am Mo 12. Jul 2004, 18:10, insgesamt 1-mal geändert.

emergence
Beiträge: 10644
Registriert: Mo 28. Jul 2003, 12:49
Wohnort: Austria
Kontaktdaten:

Beitrag von emergence » Mo 12. Jul 2004, 12:39

ähm, vielleicht so...

Code: Alles auswählen

$query = "SELECT * FROM ".$cfg["tab"]["upl"]." WHERE filetype = 'avi' OR filetype = 'mpg' OR filetype ='wma'";
*** make your own tools (wishlist :: thx)

ReneWho
Beiträge: 101
Registriert: Do 5. Feb 2004, 13:10
Kontaktdaten:

Beitrag von ReneWho » Mo 12. Jul 2004, 13:13

Ne geht nicht.
bzw. geht garnix mehr.

emergence
Beiträge: 10644
Registriert: Mo 28. Jul 2003, 12:49
Wohnort: Austria
Kontaktdaten:

Beitrag von emergence » Mo 12. Jul 2004, 13:17

ähm das query geht bei mir... keine ahnung was du gemacht hast...
schau ins errorlog.txt
*** make your own tools (wishlist :: thx)

ReneWho
Beiträge: 101
Registriert: Do 5. Feb 2004, 13:10
Kontaktdaten:

Beitrag von ReneWho » Mo 12. Jul 2004, 13:20

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 :-)

Halchteranerin
Beiträge: 5478
Registriert: Di 2. Mär 2004, 21:11
Wohnort: Halchter, wo sonst? ;-)
Kontaktdaten:

Beitrag von Halchteranerin » Mo 12. Jul 2004, 13:21

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'"; 

Halchteranerin
Beiträge: 5478
Registriert: Di 2. Mär 2004, 21:11
Wohnort: Halchter, wo sonst? ;-)
Kontaktdaten:

Beitrag von Halchteranerin » Mo 12. Jul 2004, 13:22

aehm, na gut, da kann man machen nix ...

ReneWho
Beiträge: 101
Registriert: Do 5. Feb 2004, 13:10
Kontaktdaten:

Beitrag von ReneWho » Mo 12. Jul 2004, 13:58

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....

pit
Beiträge: 96
Registriert: Mo 14. Apr 2003, 10:28
Wohnort: Rotenhain
Kontaktdaten:

Beitrag von pit » Mo 12. Jul 2004, 14:45

$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

ReneWho
Beiträge: 101
Registriert: Do 5. Feb 2004, 13:10
Kontaktdaten:

Beitrag von ReneWho » Mo 12. Jul 2004, 16:46

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é

ReneWho
Beiträge: 101
Registriert: Do 5. Feb 2004, 13:10
Kontaktdaten:

Beitrag von ReneWho » Mo 12. Jul 2004, 18:09

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

bachi
Beiträge: 161
Registriert: Di 20. Apr 2004, 12:22
Wohnort: Würzburg
Kontaktdaten:

Beitrag von bachi » Mi 26. Jan 2005, 09:52

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
C 4.5.2 - 4.6
www.myworkstyle.de
www.hsgweb.de
--
::: It´s not a bug - it´s a feature!!! :::

kummer
Beiträge: 2423
Registriert: Do 6. Mai 2004, 09:17
Wohnort: Bern, Schweiz
Kontaktdaten:

Beitrag von kummer » Mi 26. Jan 2005, 10:05

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
aitsu.org :: schnell - flexibel - komfortabel :: Version 2.2.0 (since June 22, 2011) (jetzt mit dual license GPL/kommerziell)

Gesperrt