Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Naujienų statistika

Parašė Gedi Minas· 2008 Vas. 24 15:02:19
#9

opentable("Naujienu statistika");
echo "<table cellpadding='0' cellspacing='0' width='100%'><tr>\n";
echo "<td width='25%'>\n";
echo "<b>Top flash:</b><br><br>\n";
$result = dbquery("SELECT * FROM ".DB_PREFIX."news WHERE news_cat='įrašyk kategorijos ID' AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_reads DESC LIMIT 0,5");
while ($data = dbarray($result)) {
$title = $data['news_subject'];
$sh_title = $title;
$n_id = $data['news_id'];
$v_id = $data['news_reads'];
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=$n_id");
$date = $data['news_datestamp'];
$n_date = showdate("%d-%m-%Y", $date);
echo "<a href='".THEME."news.php?readmore=$n_id'>".trimlink($sh_title,15)."<br>";
}
echo "<br>\n";
echo "</td>\n";
echo "<td width='25%'>\n";
echo "<b>Top video:</b><br><br>\n";
$result = dbquery("SELECT * FROM ".DB_PREFIX."news WHERE news_cat='įrašyk kategorijos ID' AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_reads DESC LIMIT 0,5");
while ($data = dbarray($result)) {
$title = $data['news_subject'];
$sh_title = $title;
$n_id = $data['news_id'];
$v_id = $data['news_reads'];
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=$n_id");
$date = $data['news_datestamp'];
$n_date = showdate("%d-%m-%Y", $date);
echo "<a href='".THEME."news.php?readmore=$n_id'>".trimlink($sh_title,15)."<br>";
}
echo "<br>\n";
echo "</td>\n";
echo "<td width='25%'>\n";
echo "<b>Top foto:</b><br><br>\n";
$result = dbquery("SELECT * FROM ".DB_PREFIX."news WHERE news_cat='įrašyk kategorijos ID' AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_reads DESC LIMIT 0,5");
while ($data = dbarray($result)) {
$title = $data['news_subject'];
$sh_title = $title;
$n_id = $data['news_id'];
$v_id = $data['news_reads'];
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=$n_id");
$date = $data['news_datestamp'];
$n_date = showdate("%d-%m-%Y", $date);
echo "<a href='".THEME."news.php?readmore=$n_id'>".trimlink($sh_title,15)."<br>";
}
echo "<br>\n";
echo "</td>\n";
echo "<td width='25%'>\n";
echo "<b>Top jokes:</b><br><br>\n";
$result = dbquery("SELECT * FROM ".DB_PREFIX."news WHERE news_cat='įrašyk kategorijos ID' AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_reads DESC LIMIT 0,5");
while ($data = dbarray($result)) {
$title = $data['news_subject'];
$sh_title = $title;
$n_id = $data['news_id'];
$v_id = $data['news_reads'];
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=$n_id");
$date = $data['news_datestamp'];
$n_date = showdate("%d-%m-%Y", $date);
echo "<a href='".THEME."news.php?readmore=$n_id'>".trimlink($sh_title,15)."<br>";
}
echo "<br>\n";
echo "</td>\n";
echo "</tr><tr>\n";
echo "<td width='25%'>\n";
echo "<b>Naujausi flash:</b><br><br>\n";
$result = dbquery("SELECT * FROM ".DB_PREFIX."news WHERE news_cat='įrašyk kategorijos ID' AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_datestamp DESC LIMIT 0,5");
while ($data = dbarray($result)) {
$title = $data['news_subject'];
$sh_title = $title;
$n_id = $data['news_id'];
$v_id = $data['news_reads'];
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=$n_id");
$date = $data['news_datestamp'];
$n_date = showdate("%d-%m-%Y", $date);
echo "<a href='".THEME."news.php?readmore=$n_id'>".trimlink($sh_title,15)."<br>";
}
echo "</td>\n";
echo "<td width='25%'>\n";
echo "<b>Naujausi video:</b><br><br>\n";
$result = dbquery("SELECT * FROM ".DB_PREFIX."news WHERE news_cat='įrašyk kategorijos ID' AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_datestamp DESC LIMIT 0,5");
while ($data = dbarray($result)) {
$title = $data['news_subject'];
$sh_title = $title;
$n_id = $data['news_id'];
$v_id = $data['news_reads'];
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=$n_id");
$date = $data['news_datestamp'];
$n_date = showdate("%d-%m-%Y", $date);
echo "<a href='".THEME."news.php?readmore=$n_id'>".trimlink($sh_title,15)."<br>";
}
echo "</td>\n";
echo "<td width='25%'>\n";
echo "<b>Naujausios foto:</b><br><br>\n";
$result = dbquery("SELECT * FROM ".DB_PREFIX."news WHERE news_cat='įrašyk kategorijos ID' AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_datestamp DESC LIMIT 0,5");
while ($data = dbarray($result)) {
$title = $data['news_subject'];
$sh_title = $title;
$n_id = $data['news_id'];
$v_id = $data['news_reads'];
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=$n_id");
$date = $data['news_datestamp'];
$n_date = showdate("%d-%m-%Y", $date);
echo "<a href='".THEME."news.php?readmore=$n_id'>".trimlink($sh_title,15)."<br>";
}
echo "</td>\n";
echo "<td width='25%'>\n";
echo "<b>Naujausi jokes:</b><br><br>\n";
$result = dbquery("SELECT * FROM ".DB_PREFIX."news WHERE news_cat='įrašyk kategorijos ID' AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_datestamp DESC LIMIT 0,5");
while ($data = dbarray($result)) {
$title = $data['news_subject'];
$sh_title = $title;
$n_id = $data['news_id'];
$v_id = $data['news_reads'];
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=$n_id");
$date = $data['news_datestamp'];
$n_date = showdate("%d-%m-%Y", $date);
echo "<a href='".THEME."news.php?readmore=$n_id'>".trimlink($sh_title,15)."<br>";
}
echo "</td>\n";

echo "</tr></table>\n";
closetable();



Redagavo Gedi Minas· 2008 Vas. 24 15:02:36