Parašė sniuff· 2007 Gru. 9 10:12:15
#2
beisas parašė:
Nu tai va,noriu paklausti kaip padaryti tokioj panelei ten yra "TOP5 MUZIKA"
ir "NAUJA MUZIKA"ir ten dar yra vietos ir negraziai atrodo,gal kaip eina padaryti ten toi vietoj dar top forumo nariai,arba istempti ta panele
Paneles kodas:
echo "<table width='100%'>
<tr>
<td width='33%'>";
openside("Naujausios Dainos");
echo "<div class='side-label'><b>Nauja muzika</b></div>\n";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_datestamp DESC LIMIT 5,5");
if (dbrows($result) != 0) {
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
while ($data = dbarray($result)) {
echo "<tr>
<td class='small'>
<img src='".THEME."images/bullet.gif'>
<a href='".BASEDIR."downloads.php?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' title='".$data['download_title']."' class='side'>".trimlink($data['download_title'], 23)."</a>
</td>
<td align='right'>".$data['download_count']."</td>
</tr>";
}
echo "</table>";
} else {
echo "<div style='text-align:center'>".$locale['004']."</div>\n";
}
echo "";
closeside();
echo "</td>
<td width='33%'>";
openside("Top 5 Dainos");
echo "<div class='side-label'><b>Top Dainos</b></div>\n";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_count DESC LIMIT 5,5");
if (dbrows($result) != 0) {
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
while($data = dbarray($result)) {
$itemsubject = trimlink($data['download_title'], 23);
echo "<tr>\n<td class='small'><img src='".THEME."images/bullet.gif'> <a href='".BASEDIR."downloads.php?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' title='".$data['download_title']."' class='side'>$itemsubject</a></td>\n
<td align='right'>".$data['download_count']."</td>\n</tr>\n";
}
echo "</table>";
} else {
echo "<center>".$locale['004']."</center>\n";
}
closeside();
echo "</td>
<td width='33%'>";
echo "</tr>
</table>";
Paveiklsiukas:
http://www.talpink.lt/images/v.p...panele.JPG
Jei eina padekit!
Su Top Forumo Nariais:
echo "<table width='100%'>
<tr>
<td width='33%'>";
openside("Naujausios Dainos");
echo "<div class='side-label'><b>Nauja muzika</b></div>\n";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_datestamp DESC LIMIT 5,5");
if (dbrows($result) != 0) {
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
while ($data = dbarray($result)) {
echo "<tr>
<td class='small'>
<img src='".THEME."images/bullet.gif'>
<a href='".BASEDIR."downloads.php?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' title='".$data['download_title']."' class='side'>".trimlink($data['download_title'], 23)."</a>
</td>
<td align='right'>".$data['download_count']."</td>
</tr>";
}
echo "</table>";
} else {
echo "<div style='text-align:center'>".$locale['004']."</div>\n";
}
echo "";
closeside();
echo "</td>
<td width='33%'>";
openside("Top 5 Dainos");
echo "<div class='side-label'><b>Top Dainos</b></div>\n";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_count DESC LIMIT 5,5");
if (dbrows($result) != 0) {
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
while($data = dbarray($result)) {
$itemsubject = trimlink($data['download_title'], 23);
echo "<tr>\n<td class='small'><img src='".THEME."images/bullet.gif'> <a href='".BASEDIR."downloads.php?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' title='".$data['download_title']."' class='side'>$itemsubject</a></td>\n
<td align='right'>".$data['download_count']."</td>\n</tr>\n";
}
echo "</table>";
} else {
echo "<center>".$locale['004']."</center>\n";
}
closeside();
echo "</td>
<td width='33%'>";
openside("Top Forumo Nariai");
$sql=dbquery("SELECT * FROM ".$db_prefix."users ORDER BY 'user_posts' DESC LIMIT 0, 8");
echo "<table width='auto' cellspacing='0' cellpadding='0'>";
$i=0;
while ($data=dbarray($sql)) {
echo "<tr>
<td align='left'>
<a href='".BASEDIR."profile.php?lookup=".$data ['user_id']."'>";
if(!empty($data['user_avatar']))
{
$avatar="<img src='".IMAGES."avatars/".$data['user_avatar']."' alt='".$data['user_name']."' width='50' height='50'>";}
else
{
$avatar="<img src='".IMAGES."noavatar.gif' alt='".$data['user_name']."' width='50' height='50'>";}
echo"$avatar</a></td>
<td align='left'><a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a><br> - ".$data['user_posts']." Pranesimai</td></tr>";
$i++;
}
echo "</table>";
closeside();
echo "</tr>
</table>";
Jeigu Reikia Kad nebutu Top Forumo Nariu ir nebutu issidraike:
echo "<table width='100%'>
<tr>
<td width='50%'>";
openside("Naujausios Dainos");
echo "<div class='side-label'><b>Nauja muzika</b></div>\n";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_datestamp DESC LIMIT 5,5");
if (dbrows($result) != 0) {
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
while ($data = dbarray($result)) {
echo "<tr>
<td class='small'>
<img src='".THEME."images/bullet.gif'>
<a href='".BASEDIR."downloads.php?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' title='".$data['download_title']."' class='side'>".trimlink($data['download_title'], 23)."</a>
</td>
<td align='right'>".$data['download_count']."</td>
</tr>";
}
echo "</table>";
} else {
echo "<div style='text-align:center'>".$locale['004']."</div>\n";
}
echo "";
closeside();
echo "</td>
<td width='50%'>";
openside("Top 5 Dainos");
echo "<div class='side-label'><b>Top Dainos</b></div>\n";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_count DESC LIMIT 5,5");
if (dbrows($result) != 0) {
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
while($data = dbarray($result)) {
$itemsubject = trimlink($data['download_title'], 23);
echo "<tr>\n<td class='small'><img src='".THEME."images/bullet.gif'> <a href='".BASEDIR."downloads.php?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' title='".$data['download_title']."' class='side'>$itemsubject</a></td>\n
<td align='right'>".$data['download_count']."</td>\n</tr>\n";
}
echo "</table>";
} else {
echo "<center>".$locale['004']."</center>\n";
}
closeside();
echo "</td>";
echo "</tr>
</table>";
Redagavo sniuff· 2007 Gru. 9 10:12:32