Sveiki,gal galite padeti ?
yra kodas :
opentable("Kategorijos");
/* Nustatymai
0 isjungta
1 ijungta */
$siuntiniu = 1;
$nuorodu = 1;
$straipsniu = 1;
$naujienu = 1;
if ($siuntiniu == 1) {
$result = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE ".groupaccess('download_cat_access')." ORDER BY download_cat_name");
echo "<table width='400' cellpadding='0' cellspacing='0' align='center'><center><b>Siuntiniu kategorijos</b></center><br>\n<tr>\n<td valign='top'>\n";
$rows = dbrows($result);
if ($rows != 0) {
$counter = 1; $columns = 2;
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) echo "";
$num = dbcount("(download_cat)", "downloads", "download_cat='".$data['download_cat_id']."'");
echo "<table cellpadding='0' cellspacing='0' width='180'>";
echo "<tr>\n<td class='small' align='left'><a href='".BASEDIR."downloads.php?cat_id=".$data['download_cat_id']."'>".$data['download_cat_name']."</a></td>\n";
echo "<td align='right' class='small2'>($num)</td>\n</tr>\n";
echo "</table>\n";
if($counter == 5) { echo "</td><td valign='top'>\n"; }
$counter++;
}
echo "</td>
</tr>
<tr>
<td colspan='2' style='padding-top: 15px;' align='center'>";
$result = dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads");
echo "<span class='small2'><b>Siuntiniu tinklalapyje: ".dbresult($result, 0)." </b></span>";
$result = dbquery("SELECT SUM(download_count) FROM ".$db_prefix."downloads");
echo "<span class='small2'><b>Iš viso atsisiusta: ".dbresult($result, 0)." </b></span>";
echo "</td>
</tr>";
} else {
echo "<center>Šiai panelei nėra turinio</center>\n";
}
echo "</table><hr>";
} else {
echo "";
}
if ($nuorodu == 1) {
$result = dbquery("SELECT * FROM ".$db_prefix."weblink_cats WHERE ".groupaccess('weblink_cat_access')." ORDER BY weblink_cat_name");
echo "<table width='400' cellpadding='0' cellspacing='0' align='center'><center><b>Nuorodu kategorijos</b></center><br>\n<tr>\n<td valign='top'>\n";
$rows = dbrows($result);
if ($rows != 0) {
$counter = 1; $columns = 2;
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) echo "";
$num = dbcount("(weblink_cat)", "weblinks", "weblink_cat='".$data['weblink_cat_id']."'");
echo "<table cellpadding='0' cellspacing='0' width='180'>";
echo "<tr>\n<td class='small' align='left'><a href='".BASEDIR."weblinks.php?cat_id=".$data['weblink_cat_id']."'>".$data['weblink_cat_name']."</a></td>\n";
echo "<td align='right' class='small2'>($num)</td>\n</tr>\n";
echo "</table>\n";
if($counter == 7) { echo "</td><td valign='top'>\n"; }
$counter++;
}
echo "</td>
</tr>
<tr>
<td colspan='2' style='padding-top: 15px;' align='center'>";
$result = dbquery("SELECT count(weblink_id) FROM ".$db_prefix."weblinks");
echo "<span class='small2'><b>Nuorodu tinklalapyje: ".dbresult($result, 0)." </b></span>";
$result = dbquery("SELECT SUM(weblink_count) FROM ".$db_prefix."weblinks");
echo "<span class='small2'><b>Iš viso peržiureta: ".dbresult($result, 0)." </b></span>";
echo "</td>
</tr>";
} else {
echo "<center>Šiai panelei nėra turinio</center>\n";
}
echo "</table><hr>";
} else {
echo "";
}
if ($straipsniu == 1) {
$result = dbquery("SELECT * FROM ".$db_prefix."article_cats WHERE ".groupaccess('article_cat_access')." ORDER BY article_cat_name");
echo "<table width='400' cellpadding='0' cellspacing='0' align='center'><center><b>Straipsniu kategorijos</b></center><br>\n<tr>\n<td valign='top'>\n";
$rows = dbrows($result);
if ($rows != 0) {
$counter = 1; $columns = 2;
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) echo "";
$num = dbcount("(article_cat)", "articles", "article_cat='".$data['article_cat_id']."'");
echo "<table cellpadding='0' cellspacing='0' width='180'>";
echo "<tr>\n<td class='small' align='left'><a href='".BASEDIR."articles.php?cat_id=".$data['article_cat_id']."'>".$data['article_cat_name']."</a></td>\n";
echo "<td align='right' class='small2'>($num)</td>\n</tr>\n";
echo "</table>\n";
if($counter == 13) { echo "</td><td valign='top'>\n"; }
$counter++;
}
echo "</td>
</tr>
<tr>
<td colspan='2' style='padding-top: 15px;' align='center'>";
$result = dbquery("SELECT count(article_id) FROM ".$db_prefix."articles");
echo "<span class='small2'><b>Straipsniu tinklalapyje: ".dbresult($result, 0)." </b></span>";
$result = dbquery("SELECT SUM(article_reads) FROM ".$db_prefix."articles");
echo "<span class='small2'><b>Iš viso skaityta: ".dbresult($result, 0)." </b></span>";
echo "</td>
</tr>";
} else {
echo "<center>Šiai panelei nėra turinio</center>\n";
}
echo "</table><hr>";
} else {
echo "";
}
if ($naujienu == 1) {
$result = dbquery("SELECT * FROM ".$db_prefix."news_cats ORDER BY news_cat_name");
echo "<table width='400' cellpadding='0' cellspacing='0' align='center'><center><b>Naujienu kategorijos</b></center><br>\n<tr>\n<td valign='top'>\n";
$rows = dbrows($result);
if ($rows != 0) {
$counter = 1; $columns = 2;
while ($data = dbarray($result)) {
if ($counter != 0 && ($counter % $columns == 0)) echo "";
$num = dbcount("(news_cat)", "news", "news_cat='".$data['news_cat_id']."'");
echo "<table cellpadding='0' cellspacing='0' width='180'>";
echo "<tr>\n<td class='small' align='left'><a href='".BASEDIR."news_cats.php?cat_id=".$data['news_cat_id']."'>".$data['news_cat_name']."</a></td>\n";
echo "<td align='right' class='small2'>($num)</td>\n</tr>\n";
echo "</table>\n";
if($counter == 2) { echo "</td><td valign='top'>\n"; }
$counter++;
}
echo "</td>
</tr>
<tr>
<td colspan='2' style='padding-top: 15px;' align='center'>";
$result = dbquery("SELECT count(news_id) FROM ".$db_prefix."news");
echo "<span class='small2'><b>Naujienu tinklalapyje: ".dbresult($result, 0)." </b></span>";
$result = dbquery("SELECT SUM(news_reads) FROM ".$db_prefix."news");
echo "<span class='small2'><b>Iš viso skaityta: ".dbresult($result, 0)." </b></span>";
echo "</td>
</tr>";
} else {
echo "<center>Šiai panelei nėra turinio</center>\n";
}
echo "</table>";
} else {
echo "";
}
if (($siuntiniu && $nuorodu && $straipsniu && $naujienu) == 0) {
echo "<center>Jūs išjungėte visą šios panelės turinį!</center>\n";
}
closetable();
ar imanoma padaryti kad rodytu tik
Siuntiniu kategorijos
aciu :) +10
|
yra dar cia gyvu? 
)
