|
<?php
/*----------------------------------------------------+
| LATEST SITE INFO PANEL PHP-FUSION
|-----------------------------------------------------+
| Copyright 2006 Latest Info Panel
| Created By Jason Bechler - Weather Talk
| Web: http://wxtalk.zitenet.com/
| Email: -
| Please respect my work as its my first MOD
|----------------------------------------------------+
| Released under the terms and conditions of
| the GNU General Public License
+----------------------------------------------------*/
if (!defined("IN_FUSION")) { header("Location: ../../index.php"); exit; }
if(file_exists(INFUSIONS."latest_site_info_panel/locale/".$settings['locale'].".php")) {
include INFUSIONS."latest_site_info_panel/locale/".$settings['locale'].".php";
} else {
include INFUSIONS."latest_site_info_panel/locale/Polish.php";
}
echo "<script type='text/javascript' src='".INFUSIONS."latest_site_info_panel/js/boxover.js'></script>";
openside("<center><img src='".THEME."images/bullet.gif'>".$locale['LSIP001']."<img src='".THEME."images/bullet.gif'></center>");
echo "<fieldset><div class='side-label'><div title='header=[<center>".$locale['LSIP002']."</center>] body=[<center>".$locale['LSIP003']."</center>]'><a href='".BASEDIR."downloads.php'>".$locale['LSIP002']."</a></div></div>\n";
$result = dbquery(
"SELECT td.*,tdc.* FROM ".$db_prefix."downloads td
INNER JOIN ".$db_prefix."download_cats tdc ON td.download_cat=tdc.download_cat_id
WHERE ".groupaccess('download_cat_access')." ORDER BY download_datestamp DESC LIMIT 0,5"
);
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['download_title'], 23);
echo "<a href='".BASEDIR."downloads.php?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' title='".$data['download_title']."' class='side'>$itemsubject</a><br>\n";
}
} else {
echo "<center>".$locale['004']."</center>\n";
}
echo "<div class='side-label'><div title='header=[<center>".$locale['LSIP004']."</center>] body=[<center>".$locale['LSIP005']."</center>]'><a href='".BASEDIR."weblinks.php'>".$locale['LSIP004']."</a></div></div>\n";
$result = dbquery(
"SELECT tw.*,twc.* FROM ".$db_prefix."weblinks tw
INNER JOIN ".$db_prefix."weblink_cats twc ON tw.weblink_cat=twc.weblink_cat_id
WHERE ".groupaccess('weblink_cat_access')." ORDER BY weblink_datestamp DESC LIMIT 0,5"
);
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['weblink_name'], 23);
echo "<a href='".BASEDIR."weblinks.php?cat_id=".$data['weblink_cat']."&weblink_id=".$data['weblink_id']."' title='".$data['weblink_name']."' target='_blank' class='side'>$itemsubject</a><br>\n";
}
} else {
echo "<center>".$locale['004']."</center>\n";
}
closeside();
openside("<center><img src='".THEME."images/bullet.gif'>".$locale['LSIP006']."<img src='".THEME."images/bullet.gif'></center>");
echo "<fieldset><div class='side-label'><div title='header=[<center>".$locale['LSIP007']."</center>] body=[<center>".$locale['LSIP008']."</center>]'><a href='".INFUSIONS."forum_threads_list_panel/newposts.php'>".$locale['LSIP007']."</a></div></div>\n";
$result = dbquery("
SELECT * FROM ".$db_prefix."threads
INNER JOIN ".$db_prefix."forums ON ".$db_prefix."threads.forum_id=".$db_prefix."forums.forum_id
WHERE ".groupaccess('forum_access')." ORDER BY thread_lastpost DESC LIMIT 5
");
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['thread_subject'], 23);
echo "<a href='".FORUM."viewthread.php?forum_id=".$data['forum_id']."&thread_id=".$data['thread_id']."' title='".$data['thread_subject']."' class='side'>$itemsubject</a><br>\n";
}
} else {
echo "<center>".$locale['004']."</center>\n";
}
echo "<div class='side-label'><b>".$locale['LSIP009']."</b></div>\n";
$result = dbquery("
SELECT tf.forum_id, tt.thread_id, tt.thread_subject, COUNT(tp.post_id) as count_posts
FROM ".$db_prefix."forums tf
INNER JOIN ".$db_prefix."threads tt USING(forum_id)
INNER JOIN ".$db_prefix."posts tp USING(thread_id)
WHERE ".groupaccess('forum_access')." GROUP BY thread_id ORDER BY count_posts DESC, thread_lastpost DESC LIMIT 5");
if (dbrows($result) != 0) {
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n";
while($data = dbarray($result)) {
$itemsubject = trimlink($data['thread_subject'], 20);
echo "<tr>\n<td class='side-small'><a href='".FORUM."viewthread.php?forum_id=".$data['forum_id']."&thread_id=".$data['thread_id']."' title='".$data['thread_subject']."' class='side'>$itemsubject</a></td>
<td align='right' class='side-small'>[<font color='red'>".($data['count_posts']-1)."</font>]</td>\n</tr>\n";
}
echo "</table>\n";
} else {
echo "<center>".$locale['004']."</center>\n";
}
closeside();
openside("<center><img src='".THEME."images/bullet.gif'>".$locale['LSIP010']."<img src='".THEME."images/bullet.gif'></center>");
echo "<fieldset><div class='side-label'><div title='header=[<center>".$locale['LSIP011']."</center>] body=[<center>".$locale['LSIP012']."</center>]'><a href='".BASEDIR."news_cats.php'>".$locale['LSIP011']."</a></div></div>\n";
$result = dbquery(
"SELECT tn.*, tc.*, user_id, user_name FROM ".$db_prefix."news tn
LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id
LEFT JOIN ".$db_prefix."news_cats tc ON tn.news_cat=tc.news_cat_id
WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")
ORDER BY news_datestamp DESC LIMIT 0,5"
);
if (dbrows($result) != 0) {
while($data = dbarray($result)) {
$itemsubject = trimlink($data['news_subject'], 23);
echo "<a href='".BASEDIR."news.php?readmore=".$data['news_id']."' title='".$data['news_subject']."' class='side'>$itemsubject</a><br>\n";
}
} else {
echo "<center>".$locale['004']."</center>\n";
}
echo "<div class='side-label'><div title='header=[<center>".$locale['LSIP013']."</center>] body=[<center>".$locale['LSIP014']."</center>]'><a href='".BASEDIR."articles.php'>".$locale['LSIP013']."</a></div></div>\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 "<a href='".BASEDIR."readarticle.php?article_id=".$data['article_id']."' title='".$data['article_subject']."' class='side'>$itemsubject</a><br>\n";
}
} else {
echo "<center>".$locale['004']."</center>\n";
}
closeside();
?>
Spróbuj tego.
  Nie pomagam na komunikatorach oraz PW! |
v7.02.06
