openside("Naujausia siuntiniai");
if (iMEMBER) {
echo "Nauji siuntiniai
\n";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_datestamp DESC LIMIT 0,5");
if (dbrows($result) != 0) {
echo "";
} else {
echo "".$locale['004']."
\n";
}
echo "";
}
if (iGUEST) {
echo "Nauji siuntiniai
\n";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_datestamp DESC LIMIT 0,5");
if (dbrows($result) != 0) {
echo "";
while ($data = dbarray($result)) {
echo "
![](".THEME."images/bullet.gif)
".trimlink($data['download_title'], 23)."
|
".$data['download_count']." |
";
}
echo "
";
} else {
echo "".$locale['004']."
\n";
}
echo "";
}
+
closeside();
echo "
";
openside("Top 5 Siuntiniai");
if (iMEMBER) {
echo " Top 5 siuntiniai \n";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_count DESC LIMIT 0,5");
if (dbrows($result) != 0) {
echo "";
while($data = dbarray($result)) {
$itemsubject = trimlink($data['download_title'], 23);
echo "\n| $itemsubject | \n
".$data['download_count']." | \n \n";
}
echo " ";
} else {
echo "".$locale['004']."\n";
}
}
if (iGUEST) {
echo "Top 5 siuntiniai \n";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_count DESC LIMIT 0,5");
if (dbrows($result) != 0) {
echo "";
while($data = dbarray($result)) {
$itemsubject = trimlink($data['download_title'], 23);
echo "\n| $itemsubject | \n
".$data['download_count']." | \n \n";
}
echo " ";
} else {
echo "".$locale['004']."\n";
}
}
closeside();
echo " |
";
openside("Paskutiniai straipsniai ");
echo " Paskutiniai straipsniai \n";
$result = dbquery(
"SELECT ta.*,tac.* FROM ".$db_prefix."articles ta
INNER JOIN ".$db_prefix."article_cats tac ON ta.article_cat=tac.article_cat_id
WHERE ".groupaccess('article_cat_access')." ORDER BY article_datestamp DESC LIMIT 0,5"
);
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['article_subject'], 23);
echo " $itemsubject
\n";
}
} else {
echo "".$locale['004']."\n";
}
closeside(); |