 |
 |
 |
 |
 |
Ostatnio widziani |
 |
 |
 |
 |
|
| Zarejestrowanych: 39,500 |
| Gości on-line: 14 |
|
|
 |
 |
 |
|
 |
 |
 |
 |
Zobacz Temat |
 |
 |
 |
 |
 |
 |
| Super administrator niewidoczny na stronie || Dodane dnia 07-09-2010 10:48 |
|
|
Czy istnieje możliwość całkowitego ukrycia obecności super administratora na stronie /w ostatnio widziani, użytkowników on line/. Pozdrawiam.
|
|
|
| RE: Super administrator niewidoczny na stronie || Dodane dnia 07-09-2010 10:54 |
|
|
W zapytaniu które wyciąga z bazy poprostu zrób warunek WHERE online_user != '1' czy jakoś tak jeśli user_id super admina jest inne to zmień cyfrę..
Nie pamiętam jak wygląda struktura ostatnio widzianych ..
|
|
|
| RE: Super administrator niewidoczny na stronie || Dodane dnia 08-09-2010 13:42 |
|
|
Dzięki w panelu użytkowników on line działa, żeby w panelu ostatnio widziani również był niewidoczny trzeba podmienić w pliku last_seen_users_panel.php w linijce:
$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_lastvisit>'0' AND user_status='0' ORDER BY user_lastvisit DESC LIMIT 1,10");
w DESC LIMIT 0,10 - 0 na 1.
|
|
|
| RE: Super administrator niewidoczny na stronie || Dodane dnia 08-09-2010 15:55 |
| Blivd Użytkownik
Ostrzeżeń:
| | |
grom44 nie bardzo :)
|
|
|
| RE: Super administrator niewidoczny na stronie || Dodane dnia 08-09-2010 16:10 |
|
|
Blivd - masz racje trochę testowałem to rozwiązanie i wychodzą bzdury.
Medyq twoje rozwiązanie też nie jest najlepsze sory ale to nie to.
może ktoś wie jak to zrobić siedzę już dwa dni i kicha. Pozdrawiam.
|
|
|
| RE: Super administrator niewidoczny na stronie || Dodane dnia 08-09-2010 17:47 |
|
|
@grom Twój pomysł utnie tylko najnowszego online czyli jak SA siedziałby 24 na dobę :P
Online user Panel:
$cond = ($userdata['user_level'] != 0 ? "'".$userdata['user_id']."'" : "'0' AND online_ip='".USER_IP."' ");
$result = dbquery("SELECT * FROM ".$db_prefix."online WHERE online_user=".$cond." AND online_user !='1'");
if (dbrows($result) != 0) {
$result = dbquery("UPDATE ".$db_prefix."online SET online_lastactive='".time()."' WHERE online_user=".$cond."");
} else {
$name = ($userdata['user_level'] != 0 ? $userdata['user_id'] : "0");
$result = dbquery("INSERT INTO ".$db_prefix."online (online_user, online_ip, online_lastactive) VALUES ('$name', '".USER_IP."', '".time()."')");
}
$result = dbquery("DELETE FROM ".$db_prefix."online WHERE online_lastactive<".(time()-60)."");
openside($locale['010']);
$result = dbquery("SELECT * FROM ".$db_prefix."online WHERE online_user='0'");
echo "<img src='".THEME."images/bullet.gif' alt=''> ".$locale['011'].dbrows($result)."<br>\n";
$result = dbquery(
"SELECT ton.*, user_id,user_name,user_color,user_prefix FROM ".$db_prefix."online ton
LEFT JOIN ".$db_prefix."users tu ON ton.online_user=tu.user_id
WHERE online_user!='0' AND online_user!='1'"
);
Podaj strukture info panelu to tez Ci ktoś pomoże ja niestety nie mam takiego pliku a nawet jeśli to zmieniony za bardzo..
|
|
|
| RE: Super administrator niewidoczny na stronie || Dodane dnia 08-09-2010 19:24 |
|
|
Dzięki za zainteresowanie tematem, kombinuje ale jakoś nie idzie
podaje swój plik - online_users_panel.php
<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2005 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
if (!defined("IN_FUSION")) { header("Location:../../index.php"); exit; }
if ($settings['maintenance'] != "1") {
$cond = ($userdata['user_level'] != 0 ? "'".$userdata['user_id']."'" : "'0' AND online_ip='".USER_IP."'");
$result = dbquery("SELECT * FROM ".$db_prefix."online WHERE online_user=".$cond."");
if (dbrows($result) != 0) {
$result = dbquery("UPDATE ".$db_prefix."online SET online_lastactive='".time()."' WHERE online_user=".$cond."");
} else {
$name = ($userdata['user_level'] != 0 ? $userdata['user_id'] : "0");
$result = dbquery("INSERT INTO ".$db_prefix."online (online_user, online_ip, online_lastactive) VALUES ('$name', '".USER_IP."', '".time()."')");
}
$result = dbquery("DELETE FROM ".$db_prefix."online WHERE online_lastactive<".(time()-60)."");
openside($locale['010']);
$result = dbquery("SELECT * FROM ".$db_prefix."online WHERE online_user='0'");
echo "<img src='".THEME."images/bullet.gif' alt=''> ".$locale['011'].dbrows($result)."<br>\n";
$result = dbquery(
"SELECT ton.*, user_id,user_name,user_color,user_prefix FROM ".$db_prefix."online ton
LEFT JOIN ".$db_prefix."users tu ON ton.online_user=tu.user_id
WHERE online_user!='0'"
);
$members = dbrows($result);
if ($members != 0) {
$i = 1;
echo "<img src='".THEME."images/bullet.gif' alt=''> ".$locale['012'];
while($data = dbarray($result)) {
echo "<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side' style='color:#".$data['user_color']."'><b>".$data['user_prefix'].$data['user_name']."</b></a>";
if ($i != $members) echo ", ";
$i++;
}
echo "<br>\n";
} else {
echo $locale['013']."<br>\n";
}
echo "<br><img src='".THEME."images/bullet.gif' alt=''> ".$locale['014'].number_format(dbcount("(user_id)", "users", "user_status<='1'"))."<br>\n";
if ($settings['admin_activation'] == "1") echo "<img src='".THEME."images/bullet.gif' alt=''> ".$locale['015'].dbcount("(user_id)", "users", "user_status='2'")."<br>\n";
$data = dbarray(dbquery("SELECT user_id,user_name,user_color,user_prefix FROM ".$db_prefix."users WHERE user_status='0' ORDER BY user_joined DESC LIMIT 0,1"));
echo "<img src='".THEME."images/bullet.gif' alt=''> ".$locale['016']."<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side' style='color:#".$data['user_color']."'>".$data['user_prefix'].$data['user_name']."</a>\n";
closeside();
}
?>
|
|
|
| RE: Super administrator niewidoczny na stronie || Dodane dnia 08-09-2010 19:26 |
|
|
Chodziło o plik info_panel.php, a nie online_user_panel.php. Ten dostałeś wyżej...
|
|
|
| RE: Super administrator niewidoczny na stronie || Dodane dnia 08-09-2010 19:31 |
|
|
Sory ale już mam młyna, nie zaskoczyłem.
plik - info_panel.php
<?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/English.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();
?>
|
|
|
| RE: Super administrator niewidoczny na stronie || Dodane dnia 08-09-2010 20:29 |
|
|
podmień to $result=dbquery("SELECT * FROM ".$db_prefix."users ORDER BY user_lastvisit WHERE user_id !='1' DESC LIMIT 0,8");
w miejsce 1 wstaw id osoby która ma się nie wyświetlać.. jak chcesz kilka to wg zasady
WHERE user_id !='1' AND user_id !='11' AND user_id !='19'
|
|
|
| RE: Super administrator niewidoczny na stronie || Dodane dnia 09-09-2010 09:11 |
|
|
Chyba coś nie tak wyskakuje mi błąd:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE user_id !='1' DESC LIMIT 0,8' at line 1
|
|
|
| RE: Super administrator niewidoczny na stronie || Dodane dnia 09-09-2010 10:50 |
|
|
Sorka mój błąd.. chyba powinno byc odwrotnie :P
WHERE user_id !='1' ORDER BY user_lastvisit DESC
|
|
|
| RE: Super administrator niewidoczny na stronie || Dodane dnia 09-09-2010 21:09 |
|
|
Medyq -odwrotnie to znaczy jak, bo nie bardzo rozumiem.
|
|
|
| RE: Super administrator niewidoczny na stronie || Dodane dnia 10-09-2010 07:46 |
|
|
To znaczy odwrotnie czyli zamienic miejscami lub do kodu podanego dwa posty wyżej podstawić do z kodu post wyżej czyli efekt koncowy do wklejenia do info panelu to:
$result=dbquery("SELECT * FROM ".$db_prefix."users WHERE user_id !='1' ORDER BY user_lastvisit DESC LIMIT 0,8");
Jaśniej się już chyba nie daje..
|
|
|
| RE: Super administrator niewidoczny na stronie || Dodane dnia 10-09-2010 12:05 |
|
|
Dzięki medyq wszystko śmiga, sory za to pytanie ale nie pomyślałem.
Muszę teraz tylko sprawdzić sprawę wyświetlania innych użytkowników na tym samym nr IP co super administrator. Myślę że nie będzie to kolidowało.
|
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
Szybka Odpowiedź |
 |
 |
 |
 |
 |
 |
Temat został zablokowany bądź nie zaakceptowałeś jeszcze regulaminu dostępnego TUTAJ
|
 |
 |
 |
 |
|