Parašė Žilvis· 2008 Kov. 18 16:03:56
#1
Atsidarau info_panel viskas ok bet per viduri panele rekauja meta tokia nesamone :D
Naujausia žinutė:
Unknown column 'user_color' in 'field list'
Ši panelė neturi turinio
isiaiskinau kad cia reikia redaguoti
info_panel.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.
+--------------------------------------------------------------------------*/
if (file_exists(INFUSIONS."info_panel/locale/".$settings['locale'].".php")) {
include INFUSIONS."info_panel/locale/".$settings['locale'].".php";
} else {
include INFUSIONS."info_panel/locale/Lithuanian.php";
}
include INCLUDES."theme.php";
include LOCALE.LOCALESET."search.php";
opentable($locale['XXX_001']);
echo "<table width='100%' border='0' cellspacing='0' cellpadding='0'>
<tr><td width='32%' valign='top'>";
echo "<FIELDSET><LEGEND><a href='".INFUSIONS."info_panel/members.php'> ".$locale['XXX_002']."</a></LEGEND>\n";
$result=dbquery("SELECT * FROM ".$db_prefix."users ORDER BY user_lastvisit DESC LIMIT 0,8");
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='100%' cellpadding='0' cellspacing='0'><tr><td class='small'>
<a href='".BASEDIR."profile.php?lookup=$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><td align=\"right\" class='small'>".$lastseen."</td></tr></table>";
}
}
echo "</FIELDSET></td><td width='2%' valign='top' align='left'></td><td width='32%' valign='top' align='left'><FIELDSET><LEGEND><a href='".INFUSIONS."info_panel/newest_posts.php'>".$locale['XXX_015']."</a></LEGEND>\n";
if (!isset($usr_grps) || !isNum($usr_grps)) $usr_grps="";
$result = dbquery(
"SELECT tf.*, tt.*, tu.user_id,user_name,user_color,user_prefix 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_lastpost DESC LIMIT 0,8");
if (dbrows($result) != 0) {
$i=0;
if ($theme_width == "100%") 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"));
$threads_message = $data['thread_subject'];
$threads_message = str_replace("'", "", $threads_message);
$rstart = ($reply_count > 20 ? "rowstart=".((ceil($reply_count / 20)-1)*20)."&" : "");
echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\"><tr><td align=\"left\" width='65%' class='small'>";
if ($theme_width == "100%") {
echo "$folder123 <a href='".FORUM."viewthread.php?".$rstart."forum_id=".$data['forum_id']."&thread_id=".$data['thread_id']."#".$data2['post_id']."' onmouseover=\"ddrivetip('$start<center><b>° ".$locale['XXX_017']." °</b></center><hr><b>".$locale['XXX_019']."</b>: ".$threads_message."<hr><b>".$locale['XXX_020']."</b>: ".($reply_count - 1)."/".$data['thread_views']."<br><b>".$locale['XXX_021']."</b>: ".$data['user_prefix'].$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='35%'>[".($reply_count - 1)." / ".$data['thread_views']."]</td>";
} else {
echo "$folder123 <a href='".FORUM."viewthread.php?".$rstart."forum_id=".$data['forum_id']."&thread_id=".$data['thread_id']."#".$data2['post_id']."' onmouseover=\"gpe('text:<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_prefix'].$data['user_name']."<br><b>".$locale['XXX_022']."</b>: ".showdate("forumdate", $data['thread_lastpost']).";')\" (".$data['forum_name'].")'>".trimlink($data['thread_subject'], 16)."</a><br></td>\n";
echo "<td align=\"right\" width='35%'>[".($reply_count - 1)." / ".$data['thread_views']."]</td>";
}
echo "</tr></table>";
$i++;
}
} else {
echo "<center>".$locale['004']."</center>\n";
}
echo "</FIELDSET></td><td width='2%' valign='top' align='left'></td><td width='32%' valign='top' align='right'>
<FIELDSET><LEGEND><a href='".INFUSIONS."info_panel/hottest_threads.php'>".$locale['022']."</a></LEGEND>\n";
$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,8");
if (dbrows($result) != 0) {
$i=0;
if ($theme_width == "100%") 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=\"100%\" cellpadding=\"0\" cellspacing=\"0\"><tr><td align=\"left\" class='small' width='75%'>";
if ($theme_width == "100%") {
echo "$folder123 <a href='".FORUM."viewthread.php?".$rstart."forum_id=".$data['forum_id']."&thread_id=".$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='".FORUM."viewthread.php?".$rstart."forum_id=".$data['forum_id']."&thread_id=".$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 "</FIELDSET></td></tr></table>";
closetable();
?>
Redagavo kiskiss· 2008 Kov. 18 18:03:45