Top Download php

Gehe zu Seite:

Geschlossen

Fr. 24.07.2009 18:28 Uhr #1

Smoky Mitglied

Hallo zusammen,
Wie ihr auf nrw1.nr.funpic.de/, sehen könnt sieht die Download Box nicht sehr schön aus.( Links unten).
Ich hätte gerne Datum, und Anzahl der Downloads. Ganz rechts Angezeigt wird. Nicht so versetzt, sieht einfach s...... aus. Woran liegt das, muß ich and der php was ändern?

Mein

<?php
//Copyright by Stefan Jungbauer
//www.zocker-eppingen.de
//V 1.1
 
defined ('main') or die ( 'no direct access' );
 
echo '<b>Newest Download</b>';
 
$erg = db_query("SELECT prefix_downloads.cat,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%Y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by prefix_downloads.id DESC LIMIT 0,5");
 
$i = 0;
  while ($row = db_fetch_object($erg)) { 
$i++;   
$user = $row->name;
echo'
<table width="100%" cellspacing="0" cellpadding="0" height="13">
<tr><td>&nbsp;'.$i.'.&nbsp;<a href="?downloads-show-'.$row->id.'">&nbsp;'.$user.'</a></td><td> '.$row->datum.'</td></tr>
</table>';
 
  }
 
echo '<b>Top Download</b>';
$a = 0;
$erg = db_query("SELECT prefix_downloads.cat,hits,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%Y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by hits DESC LIMIT 0,5");
  while ($row = db_fetch_object($erg)) { 
$a++;
     
$name = $row->name;
echo'
<table width="100%" cellspacing="0" cellpadding="0" height="13">
<tr><td>'.$a.'.&nbsp;<a href="?downloads-show-'.$row->id.'">&nbsp;'.$name.'</a></td><td>'.$row->hits.'</td></tr>
</table>';
 
  }
 
 
 
 
?>

betroffene Homepage: nrw1.nr.funpic.de/

Zuletzt modifiziert von Smoky am 24.07.2009 - 19:01:08

0 Mitglieder finden den Beitrag gut.

zitieren

Fr. 24.07.2009 18:48 Uhr #2

Lord|Schirmer Administrator

boxes/download.php

<?
defined ('main') or die ( 'no direct access' );
 
echo '<b>Newest Download</b>';
$erg = db_query("SELECT prefix_downloads.cat,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by prefix_downloads.id DESC LIMIT 0,5");
$i = 0;
  while ($row = db_fetch_object($erg)) { 
$i++;   
$user = $row->name;
echo'
<table width="100%" cellspacing="0" cellpadding="0" height="13">
<tr><td aligm="left">&nbsp;'.$i.'.&nbsp;<a href="?downloads-show-'.$row->id.'">'.$row->time.'&nbsp;'.$user.'</a></td><td aligm="right"> '.$row->datum.'</td></tr>
</table>';
}
 
echo '<b>Top Download</b>';
$a = 0;
$erg = db_query("SELECT prefix_downloads.cat,hits,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by hits DESC LIMIT 0,5");
  while ($row = db_fetch_object($erg)) { 
$a++;
     
$name = $row->name;
echo'
<table width="100%" cellspacing="0" cellpadding="0" height="13">
<tr><td aligm="left">'.$a.'.&nbsp;<a href="?downloads-show-'.$row->id.'">'.$row->time.'&nbsp;'.$name.'</a></td><td aligm="right">'.$row->hits.'</td></tr>
</table>';
}
?>

rules :: doku :: faq :: linkus

0 Mitglieder finden den Beitrag gut.

zitieren

Fr. 24.07.2009 18:55 Uhr #3

Smoky Mitglied

Zitat geschrieben von Lord|Schirmer

boxes/download.php

<?
defined ('main') or die ( 'no direct access' );
 
echo '<b>Newest Download</b>';
$erg = db_query("SELECT prefix_downloads.cat,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by prefix_downloads.id DESC LIMIT 0,5");
$i = 0;
  while ($row = db_fetch_object($erg)) { 
$i++;   
$user = $row->name;
echo'
<table width="100%" cellspacing="0" cellpadding="0" height="13">
<tr><td aligm="left">&nbsp;'.$i.'.&nbsp;<a href="?downloads-show-'.$row->id.'">'.$row->time.'&nbsp;'.$user.'</a></td><td aligm="right"> '.$row->datum.'</td></tr>
</table>';
}
 
echo '<b>Top Download</b>';
$a = 0;
$erg = db_query("SELECT prefix_downloads.cat,hits,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by hits DESC LIMIT 0,5");
  while ($row = db_fetch_object($erg)) { 
$a++;
     
$name = $row->name;
echo'
<table width="100%" cellspacing="0" cellpadding="0" height="13">
<tr><td aligm="left">'.$a.'.&nbsp;<a href="?downloads-show-'.$row->id.'">'.$row->time.'&nbsp;'.$name.'</a></td><td aligm="right">'.$row->hits.'</td></tr>
</table>';
}
?>

klappt leider nicht. Fehler:

Parse error: syntax error, unexpected '<' in /usr/export/www/vhosts/funnetwork/hosting/nrw1/include/boxes/download.php on line 6

0 Mitglieder finden den Beitrag gut.

zitieren

Fr. 24.07.2009 19:15 Uhr #4

Lord|Schirmer Administrator

probiere nochmal dieses

<?php
defined ('main') or die ( 'no direct access' ); 
 
echo '<b>Newest Download</b>';
$i = 0; 
$erg = db_query("SELECT prefix_downloads.cat,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by prefix_downloads.id DESC LIMIT 0,5"); 
while ($row = db_fetch_object($erg)) {  
$i++;     
$user = $row->name; 
echo' 
<table width="100%" cellspacing="0" cellpadding="0" height="13"> 
<tr><td aligm="left">&nbsp;'.$i.'.&nbsp;<a href="index.php?downloads-show-'.$row->id.'">'.$row->time.'&nbsp;'.$user.'</a></td><td aligm="right"> '.$row->datum.'</td></tr> 
</table>'; 
}
echo '<b>Top Download</b>'; 
$a = 0; 
$erg = db_query("SELECT prefix_downloads.cat,hits,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by hits DESC LIMIT 0,5"); 
while ($row = db_fetch_object($erg)) {  
$a++;
$name = $row->name; 
echo' 
<table width="100%" cellspacing="0" cellpadding="0" height="13"> 
<tr><td aligm="left">'.$a.'.&nbsp;<a href="index.php?downloads-show-'.$row->id.'">'.$row->time.'&nbsp;'.$name.'</a></td><td aligm="right">'.$row->hits.'</td></tr> 
</table>'; 
} 
?>

rules :: doku :: faq :: linkus

0 Mitglieder finden den Beitrag gut.

zitieren

Fr. 24.07.2009 19:24 Uhr #5

Smoky Mitglied

Zitat geschrieben von Lord|Schirmer

probiere nochmal dieses

<?php
defined ('main') or die ( 'no direct access' ); 
 
echo '<b>Newest Download</b>';
$i = 0; 
$erg = db_query("SELECT prefix_downloads.cat,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by prefix_downloads.id DESC LIMIT 0,5"); 
while ($row = db_fetch_object($erg)) {  
$i++;     
$user = $row->name; 
echo' 
<table width="100%" cellspacing="0" cellpadding="0" height="13"> 
<tr><td aligm="left">&nbsp;'.$i.'.&nbsp;<a href="index.php?downloads-show-'.$row->id.'">'.$row->time.'&nbsp;'.$user.'</a></td><td aligm="right"> '.$row->datum.'</td></tr> 
</table>'; 
}
echo '<b>Top Download</b>'; 
$a = 0; 
$erg = db_query("SELECT prefix_downloads.cat,hits,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by hits DESC LIMIT 0,5"); 
while ($row = db_fetch_object($erg)) {  
$a++;
$name = $row->name; 
echo' 
<table width="100%" cellspacing="0" cellpadding="0" height="13"> 
<tr><td aligm="left">'.$a.'.&nbsp;<a href="index.php?downloads-show-'.$row->id.'">'.$row->time.'&nbsp;'.$name.'</a></td><td aligm="right">'.$row->hits.'</td></tr> 
</table>'; 
} 
?>

Ich habe es so übernommen, leider keine Veränderung, siehe HP. Ist echt Merkwürdig

0 Mitglieder finden den Beitrag gut.

zitieren

Fr. 24.07.2009 19:54 Uhr #6

Lord|Schirmer Administrator

Ja ist klar, habe natürlich nur kurz drüber geschaut, es wird jedesmal eine neue Tabelle generiert! So ist es sinnvoller:

<?php
defined ('main') or die ( 'no direct access' ); 
 
echo '<center><table width="95%" cellspacing="0" cellpadding="0" border="0">';
 
echo '<tr><td colspan="2"><b>Newest Download</b></td></tr>';
$i = 0;
$erg = db_query("SELECT prefix_downloads.cat,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by prefix_downloads.id DESC LIMIT 0,5"); 
while ($row = db_fetch_object($erg)) {  
$i++;     
$user = $row->name; 
echo'<tr><td align="left">'.$i.'.&nbsp;<a href="index.php?downloads-show-'.$row->id.'">'.$row->time.'&nbsp;'.$user.'</a></td><td align="right">'.$row->datum.'</td></tr>'; 
}
 
echo '<tr><td colspan="2">&nbsp;</td></tr>';
 
echo '<tr><td colspan="2"><b>Top Download</b></td></tr>'; 
$a = 0; 
$erg = db_query("SELECT prefix_downloads.cat,hits,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by hits DESC LIMIT 0,5"); 
while ($row = db_fetch_object($erg)) {  
$a++;
$name = $row->name; 
echo'<tr><td align="left">'.$a.'.&nbsp;<a href="index.php?downloads-show-'.$row->id.'">'.$row->time.'&nbsp;'.$name.'</a></td><td align="right">'.$row->hits.'</td></tr>'; 
}
echo '</table></center>';
?>

Zuletzt modifiziert von Lord|Schirmer am 24.07.2009 - 19:54:44

rules :: doku :: faq :: linkus

0 Mitglieder finden den Beitrag gut.

zitieren

Fr. 24.07.2009 20:00 Uhr #7

Smoky Mitglied

Zitat geschrieben von Lord|Schirmer

Ja ist klar, habe natürlich nur kurz drüber geschaut, es wird jedesmal eine neue Tabelle generiert! So ist es sinnvoller:

<?php
defined ('main') or die ( 'no direct access' ); 
 
echo '<center><table width="95%" cellspacing="0" cellpadding="0" border="0">';
 
echo '<tr><td colspan="2"><b>Newest Download</b></td></tr>';
$i = 0;
$erg = db_query("SELECT prefix_downloads.cat,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by prefix_downloads.id DESC LIMIT 0,5"); 
while ($row = db_fetch_object($erg)) {  
$i++;     
$user = $row->name; 
echo'<tr><td align="left">'.$i.'.&nbsp;<a href="index.php?downloads-show-'.$row->id.'">'.$row->time.'&nbsp;'.$user.'</a></td><td align="right">'.$row->datum.'</td></tr>'; 
}
 
echo '<tr><td colspan="2">&nbsp;</td></tr>';
 
echo '<tr><td colspan="2"><b>Top Download</b></td></tr>'; 
$a = 0; 
$erg = db_query("SELECT prefix_downloads.cat,hits,prefix_downloads.name,prefix_downloads.id,DATE_FORMAT(time,'%d.%m.%y') as datum FROM prefix_downloads LEFT JOIN prefix_downcats ON prefix_downcats.id = prefix_downloads.cat WHERE ".$_SESSION['authright']." <= prefix_downcats.recht order by hits DESC LIMIT 0,5"); 
while ($row = db_fetch_object($erg)) {  
$a++;
$name = $row->name; 
echo'<tr><td align="left">'.$a.'.&nbsp;<a href="index.php?downloads-show-'.$row->id.'">'.$row->time.'&nbsp;'.$name.'</a></td><td align="right">'.$row->hits.'</td></tr>'; 
}
echo '</table></center>';
?>

Zuletzt modifiziert von Lord|Schirmer am 24.07.2009 - 19:54:44

Sehr schön, es klappt. Vielen, vielen Dank.

0 Mitglieder finden den Beitrag gut.

zitieren

Fr. 24.07.2009 20:01 Uhr #8

Lord|Schirmer Administrator

Registriert seit
21.03.2007

Beiträge
7.680

Beitragswertungen

...gern geschehen!

rules :: doku :: faq :: linkus
0 Mitglieder finden den Beitrag gut.
- zitieren

Beitrag zur Merkliste hinzufügen

ilch Forum » Ilch Clan 1.1 » Fehlersuche und Probleme » Top Download php