Parašė kLx· 2008 Rugp. 16 11:08:01
#1
Sveiki. Gal kas galit vietoj top temų įdėt naujausias temas?
Theme.php :
<?php
if (!defined("IN_FUSION")) { header("Location: ../../index.php"); exit; }
require_once INCLUDES."theme_functions_include.php";
// theme settings
$body_text = "#555555";
$body_bg = "#0c0c0c";
$theme_width = "999";
$theme_width_l = "175";
$theme_width_r = "175";
function render_header($header_content) {
global $theme_width,$db_prefix,$locale,$data,$userdata,$user_data,$aidlink;
echo "<table align='left' cellspacing='0' cellpadding='0' width='$theme_width' >
<tr>
<td class='pageLeft'></td>
<td>
<table cellpadding='0' cellspacing='0' width='100%'>
<td>
<table cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td class='full-header'>
<table cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td style='background-image:url(".THEME."images/header-up.png);' height='112' align='center'>";
echo"<a href='".BASEDIR."index.php' ><img src='".THEME."images/namai.png' border='0' onmouseover=\"this.src='".THEME."images/namai_hover.png'\" onmouseout=\"this.src='".THEME."images/namai.png'\" style='padding-bottom:55px; padding-left:220px'></a> <a href='".FORUM."index.php' ><img src='".THEME."images/forumas.png' onmouseover=\"this.src='".THEME."images/forumas_hover.png'\" onmouseout=\"this.src='".THEME."images/forumas.png'\" border='0' style='padding-bottom:55px'></a> <a href='".BASEDIR."photogallery.php' ><img src='".THEME."images/galerija.png' onmouseover=\"this.src='".THEME."images/galerija_hover.png'\" onmouseout=\"this.src='".THEME."images/galerija.png'\" border='0' style='padding-bottom:55px'></a> <a href='".BASEDIR."weblinks.php' ><img src='".THEME."images/klubai.png' onmouseover=\"this.src='".THEME."images/klubai_hover.png'\" onmouseout=\"this.src='".THEME."images/klubai.png'\" border='0' style='padding-bottom:55px'></a> <a href='".BASEDIR."articles.php' ><img src='".THEME."images/straipsniai.png' onmouseover=\"this.src='".THEME."images/straipsniai_hover.png'\" onmouseout=\"this.src='".THEME."images/straipsniai.png'\" border='0' style='padding-bottom:55px'></a>
</tr>
<tr>
<td style='background-image:url(".THEME."images/header-center.png);' height='187' align='center'>";
echo "<table cellpadding='0' cellspacing='0' width='$theme_width' >\n<tr>
<td align='left' style='padding-left:10px; padding-top:40px;' width='120'>";
include THEME."user_info_panel.php";
echo "</td>
</tr>
</table><br>\n";
echo"</td>
</tr>
<tr><table align='center' width='100%' height='289' background='".THEME."images/header-down.png' border='0' cellspacing='0' cellpadding='0'>";
echo"<tr><td height='50' class='nuorodos' align='center' style='padding-right:300px; padding-top:30px;'><br>";
echo"<table width='100%'><tr>";
echo"<td width='30%'>";
include INFUSIONS."info_panel/locale/Lithuanian.php";
$result=dbquery("SELECT * FROM ".$db_prefix."users ORDER BY user_lastvisit DESC LIMIT 0,16");
if(dbrows($result)!=0){
while($data=dbarray($result)){
$lastseen=time()-$data['user_lastvisit'];
$iW=sprintf("%2d",floor($lastseen/604800));
$iD=sprintf("%2d",floor($lastseen/(60*60*24)));
$iH=sprintf("%02d",floor((($lastseen%604800)%86400)/3600));
$iM=sprintf("%02d",floor(((($lastseen%604800)%86400)%3600)/60));
$iS=sprintf("%02d",floor((((($lastseen%604800)%86400)%3600)%60)));
if($lastseen<60){
$lastseen="<nobr><font color='green'><b>OnLine</b></font></NOBR>";
}elseif($lastseen<360){
$lastseen="<nobr><font color='red'><b>OffLine</b></font></NOBR>";
}elseif($iW>0){
if($iW==1) $Text="".$locale['XXX_007']."";
elseif($iW==2 || $iW==3 || $iW==4) $Text="".$locale['XXX_011']."";
else $Text="".$locale['XXX_008']."";
$lastseen="<nobr>$iW $Text</NOBR>";
}elseif($iD>0){
if($iD==1) $Text="".$locale['XXX_009']."";
else $Text="".$locale['XXX_010']."";
$lastseen="<NOBR>$iD $Text</NOBR>";
}else{
$lastseen="$iH:$iM:$iS";
}
if (!isset($start)) $start="";
echo "<table width='90%' cellpadding='0' cellspacing='0'><tr><td class='small'>
<a href='".BASEDIR."narys,".$data['user_id']."'
onmouseover=\"ddrivetip('$start<center><b>° ".$locale['XXX_017']." °</b></center><hr><b>".$locale['XXX_003']."</b>: ".$data['user_prefix'].$data['user_name']."<br><b>".$locale['XXX_004']."</b>: ".$data['user_location']."<br><b>".$locale['XXX_005']."</b>: ".$data['user_msn']."<br><b>".$locale['XXX_006']."</b>: ".$data['user_posts']."$end')\" style='color:#".$data['user_color']."' onMouseout=\"hideddrivetip()\">";
echo $data['user_prefix'].$data['user_name']."</a> <td align=\"right\" class='small'>".$lastseen."</td></tr></table>";
}
}
echo "</td><td width='40%' style='padding-left:0px;' >";
echo "<table width='70%'>";
$result = dbquery(
"SELECT tf.*, tt.*, tu.user_id,user_name FROM ".$db_prefix."forums tf
INNER JOIN ".$db_prefix."threads tt USING(forum_id)
INNER JOIN ".$db_prefix."users tu ON tt.thread_lastuser=tu.user_id
".$usr_grps." ORDER BY thread_views DESC LIMIT 0,15");
if (dbrows($result) != 0) {
$i=0;
if ($theme_width == "70%") echo "\n";
while ($data = dbarray($result)) {
if ($i % 2 == 0) { $row_color = "tbl1"; } else { $row_color = "tbl1"; }
$new_posts = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."' and post_datestamp>'".(isset($lastvisited) ? $lastvisited : 0)."'");
//$thread_replies = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."'") - 1;
$thread_replies = $data['thread_replies'];
$forum_id = $data['forum_id'];
if ($new_posts > 0) {
$folder123 = "<img src='".THEME."forum/foldernew.gif' height='11'>";
} else if ($new_posts > 19) {
$folder123 = "<img src='".THEME."forum/folderhot.gif' height='11'>";
} else {
if ($data['thread_locked'] == 1) {
$folder123 = "<img src='".THEME."forum/folderlock.gif' height='11'>";
} else if ($data['thread_locked'] == 0) {
$folder123 = "<img src='".THEME."forum/folder.gif' height='11'>";
}
}
//$reply_count = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."'");
$reply_count = $data['thread_replies']+1;
$data2 = dbarray(dbquery("SELECT post_id FROM ".$db_prefix."posts WHERE thread_id='".$data['thread_id']."' ORDER BY post_id DESC LIMIT 1"));
$rstart = ($reply_count > 20 ? "rowstart=".((ceil($reply_count / 20)-1)*20)."&" : "");
echo "<table width=\"70%\" cellpadding=\"0\" cellspacing=\"0\"><tr><td align=\"left\" class='small' width='70%'>";
if ($theme_width == "70%") {
echo "$folder123 <a href='posts/ziureti-".$rstart."".$data['forum_id']."-tema".$data['thread_id']."#".$data2['post_id']."' onMouseover=\"ddrivetip('$start<center><b>° ".$locale['XXX_017']." °</b></center><hr><b>".$locale['XXX_019']."</b>: ".trimlink(str_replace("'", "", $data['thread_subject']), 45)."<hr><b>".$locale['XXX_020']."</b>: ".($reply_count - 1)."/".$data['thread_views']."<br><b>".$locale['XXX_021']."</b>: ".$data['user_name']."<br><b>".$locale['XXX_022']."</b>: ".showdate("forumdate", $data['thread_lastpost'])."$end')\"' onMouseout=\"hideddrivetip()\" >".trimlink($data['thread_subject'], 16)."</a><br></td>\n";
echo "<td align=\"right\" width='25%'>[".$data['thread_views']."]</td>";
} else {
echo "$folder123 <a href='posts/ziureti-".$rstart."".$data['forum_id']."-tema-".$data['thread_id']."#".$data2['post_id']."' onMouseover=\"ddrivetip('$start<center><b>° ".$locale['XXX_017']." °</b></center><hr><b>".$locale['XXX_019']."</b> ".trimlink(str_replace("'", "", $data['thread_subject']), 45)."<hr><b>".$locale['XXX_020']."</b>: ".($reply_count - 1)."/".$data['thread_views']."<br><b>".$locale['XXX_021']."</b>: ".$data['user_name']."<br><b>".$locale['XXX_022']."</b>: ".showdate("forumdate", $data['thread_lastpost'])."$end')\" (".$data['forum_name'].")' onMouseout=\"hideddrivetip()\">".trimlink($data['thread_subject'], 16)."</a><br></td>\n";
echo "<td align=\"right\" width='25%'>[".$data['thread_views']."] </td>";
}
echo "</tr></table>";
$i++;
}
} else {
echo "<center>".$locale['004']."</center>\n";
}
echo"</td>";
echo "</td></tr>
<tr></tr>
<tr><td height=31></td></tr>
</table>
";
echo"</td></tr><tr></tr><tr><td></td></tr></table>";
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n";
echo "<table width='100%' cellspacing='0' cellpadding='0'>\n<tr>\n
<td width='0'></td>
<td width='36' style='background-image:url(".THEME."images/bg5.png); margin-left: 0px;'></td>\n";
}
function openside_header($title) {
echo "<table cellpadding='0' cellspacing='0'>
<tr>
<td class='side-body-header'>\n";
}
function closeside_header() {
echo "</td>
</tr>
</table>\n";
tablebreak();
}
function render_footer($license=false) {
global $theme_width,$settings;
echo "</tr>\n</table>\n";
echo "<table cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td align='center' valign='bottom' class='footer'>Code by <a href='https://webdnd.com/profile.php?lookup=5687'>Enzo</a><r>\n
</td>
</tr>
</table>
</td>
</tr>
</table>\n";
}
function render_news($subject, $news, $info) {
global $locale;
opentable($subject);
echo $locale['040'].newsposter($info)."\n"
."\n\n<hr>\n".$news."\n<hr>\n"
.openform("N",$info['news_id']).newsopts($info," ·").closeform("N",$info['news_id'])."\n";
closetable();
}
function render_article($subject, $article, $info) {
global $locale;
opentable($subject);
echo $locale['040'].articleposter($info)."\n"
."<br>\n<hr>\n<br>\n".$article."<br><br>\n<hr>\n"
.openform("A",$info['article_id']).articleopts($info," ·").closeform("A",$info['article_id'])."\n";
closetable();
}
function render_cheats($subject, $cheats, $info) {
global $locale;
opentable($subject);
echo $locale['040'].articleposter($info)."\n"
."<br>\n<hr>\n<br>\n".$cheats."<br><br>\n<hr>\n"
.openform("A",$info['cheats_id']).articleopts($info," ·").closeform("A",$info['cheats_id'])."\n";
closetable();
}
function opentable($title) {
echo "<table cellpadding='0' cellspacing='0' width='100%'>
<tr>
<td class='capmain'>$title</td>
</tr>
<tr>
<td class='main-body'>\n";
}
function closetable() {
echo "</td>
</tr>
</table>\n";
}
function openside($title) {
echo "<table cellpadding='0' cellspacing='0' width='100%' class='border'>
<tr>
<td class='scapmain'>$title</td>
</tr>
<tr>
<td class='side-body'>\n";
}
function closeside() {
echo "</td>
</tr>
</table>\n";
tablebreak();
}
function opensidex($title,$state="on") {
$boxname = str_replace(" ", "", $title);
echo "<table cellpadding='0' cellspacing='0' width='100%' class='border'>
<tr>
<td class='scapmain'>$title</td>
<td class='scapmain' align='right'>".panelbutton($state,$boxname)."</td>
</tr>
<tr>
<td colspan='2' class='side-body'>
<div id='box_$boxname'".($state=="off"?" style='display:none'":"").">\n";
}
function closesidex() {
echo "</div>
</td>
</tr>
</table>\n";
tablebreak();
}
function tablebreak() {
echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n<td height='5'></td>\n</tr>\n</table>\n";
}
?>
Failas ,kuriame yra reikalingas kodas :
<?php
/*--------------------------------------------------------------------------+
| MOD: eXtreme InfoPanel dla PHP-Fusion v6
|---------------------------------------------
| author: eXtreme-fusion crew - (c) 2005
| web: http://extreme-fusion.pl
|---------------------------------------------
| Wycinanie kodu poza eXtreme-pack zabrionione.
| Jeœli po kopiowaniu coœ nie dzia³a - miej pretensje do siebie.
+--------------------------------------------------------------------------*/
@include "../../config.php";
include "../../maincore.php";
include BASEDIR."subheader.php";
include LOCALE.LOCALESET."forum/main.php";
include BASEDIR."side_left.php";
if (file_exists(INFUSIONS."info_panel/locale/".$settings['locale'].".php")) {
include INFUSIONS."info_panel/locale/".$settings['locale'].".php";
} else {
include INFUSIONS."info_panel/locale/English.php";
}
if (empty($lastvisited)) { $lastvisited = time(); }
opentable($locale['450']);
echo "<table width='100%' cellspacing='0' cellpadding='0'>
<tr>
<td class='smallalt'>
<a href='".FORUM."index.php'>".$settings['sitename']."</a>
</td>\n";
echo "</tr>
</table>\n";
$rows = dbrows(dbquery("SELECT * FROM ".$db_prefix."threads WHERE thread_sticky='0'"));
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if (!isset($forum_id) || !isNum($forum_id)) $forum_id = 0;
echo "<div align='center' style='margin-top:5px;margin-bottom:5px;'>
".makePageNav($rowstart,20,$rows,3,FUSION_SELF."?forum_id=$forum_id&")."
</div>\n";
echo "<table cellspacing='0' cellpadding='0' border='0' width='100%' class='tbl-border'>
<tr>
<td>
<table border='0' cellspacing='1' cellpadding='0' width='100%'>
<tr>
<td width='20' class='tbl2'> </td>
<td class='tbl2'>".$locale['451']."</td>
<td width='100' class='tbl2'>".$locale['452']."</td>
<td align='center' width='50' class='tbl2'>".$locale['453']."</td>
<td align='center' width='50' class='tbl2'>".$locale['454']."</td>
<td width='120' class='tbl2'>".$locale['404']."</td>
</tr>\n";
if ($rowstart == 0) {
$result = dbquery(
"SELECT ".$db_prefix."threads.*, tu1.user_name as user_author, tu2.user_name as user_lastuser FROM ".$db_prefix."threads
LEFT JOIN ".$db_prefix."users tu1 ON ".$db_prefix."threads.thread_author = tu1.user_id
LEFT JOIN ".$db_prefix."users tu2 ON ".$db_prefix."threads.thread_lastuser = tu2.user_id
WHERE thread_sticky='1' ORDER BY thread_lastpost DESC"
);
if (dbrows($result) != 0) {
while ($data = dbarray($result)) {
$new_posts = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."' and post_datestamp>'$lastvisited'");
$thread_replies = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."'") - 1;
$forum_id = $data['forum_id'];
if ($data['thread_locked']) {
echo "<tr>\n<td align='center' width='25' class='tbl1'><img src='".THEME."forum/folderlock.gif'></td>";
} else {
if ($new_posts > 0) {
$folder = "<img src='".THEME."forum/foldernew.gif'>";
} else if ($new_posts > 19) {
$folder = "<img src='".THEME."forum/folderhot.gif'>";
} else {
$folder = "<img src='".THEME."forum/folder.gif'>";
}
echo "<tr>\n<td align='center' width='25' class='tbl2'>$folder</td>";
}
echo "<td class='tbl2'><img src='".THEME."forum/stickythread.gif'>
<a href='".FORUM."viewthread.php?forum_id=$forum_id&thread_id=".$data['thread_id']."'>".$data['thread_subject']."</a></td>
<td class='tbl2' align='right'><a href='".BASEDIR."profile.php?lookup=".$data['thread_author']."'>".$data['user_author']."</a></td>
<td align='center' class='tbl1'>".$data['thread_views']."</td><td class='tbl1' align='center'>".$thread_replies."</td>
<td class='tbl1'><span class='small_date'>".showdate("forumdate", $data['thread_lastpost'])."</span><br>
<span class='small'>".$locale['406']."<a href='".BASEDIR."profile.php?lookup=".$data['thread_lastuser']."'>".$data['user_lastuser']."</a></span></td>
</tr>\n";
}
} else {
$threadcount = 0;
}
}
if ($rows != 0) {
$result = dbquery(
"SELECT ".$db_prefix."threads.*, tu1.user_name as user_author, tu2.user_name as user_lastuser FROM ".$db_prefix."threads
LEFT JOIN ".$db_prefix."users tu1 ON ".$db_prefix."threads.thread_author = tu1.user_id
LEFT JOIN ".$db_prefix."users tu2 ON ".$db_prefix."threads.thread_lastuser = tu2.user_id
WHERE thread_sticky='0' ORDER BY thread_lastpost DESC LIMIT $rowstart,20"
);
$numrows = dbrows($result);
while ($data = dbarray($result)) {
$new_posts = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."' and post_datestamp>'$lastvisited'");
$thread_replies = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."'") - 1;
$forum_id = $data['forum_id'];
if ($data['thread_locked']) {
echo "<tr>\n<td align='center' width='25' class='tbl2'><img src='".THEME."forum/folderlock.gif'></td>";
} else {
if ($new_posts > 0) {
$folder = "<img src='".THEME."forum/foldernew.gif'>";
} else if ($new_posts > 19) {
$folder = "<img src='".THEME."forum/folderhot.gif'>";
} else {
$folder = "<img src='".THEME."forum/folder.gif'>";
}
echo "<tr>
<td align='center' width='25' class='tbl2'>$folder</td>";
}
$reps = dbcount("(thread_id)", "posts", "thread_id='".$data['thread_id']."'");
$reps = ceil($reps / 20);
$threadsubject = "<a href='".FORUM."viewthread.php?forum_id=$forum_id&thread_id=".$data['thread_id']."'>".$data['thread_subject']."</a>";
if ($reps > 1) {
$ctr = 0; $ctr2 = 1; $pages = "";
while ($ctr2 <= $reps) {
$pnum = "<a href='".FORUM."viewthread.php?forum_id=$forum_id&thread_id=".$data['thread_id']."&rowstart=$ctr'>$ctr2</a> ";
$pages = $pages.$pnum; $ctr = $ctr+20; $ctr2++;
}
$threadsubject .= " - (Page: ".trim($pages).")";
}
echo "<td class='tbl1'>$threadsubject</td>
<td class='tbl2' align='right'><a href='".BASEDIR."profile.php?lookup=".$data['thread_author']."'>".$data['user_author']."</a></td>
<td align='center' class='tbl1'>".$data['thread_views']."</td><td class='tbl1' align='center'>".$thread_replies."</td>
<td class='tbl1'><span class='small_date'>".showdate("forumdate", $data['thread_lastpost'])."</span><br>
<span class='small'>".$locale['406']."<a href='".BASEDIR."profile.php?lookup=".$data['thread_lastuser']."'>".$data['user_lastuser']."</a></span></td>
</tr>\n";
}
} else {
if ($threadcount == 0) {
echo "<tr>\n<td colspan='6' class='tbl1'>".$locale['455']."</td>\n</tr>\n";
}
}
echo "</table>
</td>
</tr>
</table>\n";
echo "<div align='center' style='margin-top:5px;margin-bottom:5px;'>
".makePageNav($rowstart,20,$rows,3,FUSION_SELF."?forum_id=$forum_id&")."
</div>\n";
echo "<table width='100%' cellpadding='0' cellspacing='0'>
<tr>
<td class='tbl1'>
<img src='".THEME."forum/foldernew.gif'> - ".$locale['456']."(<img src='".THEME."forum/folderhot.gif'> - ".$locale['457'].")<br>
<img src='".THEME."forum/folder.gif'> - ".$locale['458']."<br>
<img src='".THEME."forum/folderlock.gif'> - ".$locale['459']."</td>
</tr>
</table>\n";
closetable();
include BASEDIR."side_right.php";
include BASEDIR."footer.php";
?>
Ačiū iš anksto , bėja štai kas man nesigauna ,įdėjus iš to failo ,kurį daviau meta klaidą :
You have error in your sql syntax bla bla bla.
Redagavo kLx· 2008 Rugp. 16 11:08:11