Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 | <?php if (!defined( 'main' )) { die ( "no direct access" );} $dif = date ( 'Y-m-d H:i:s' , time() - 60); $abf = "SELECT uid FROM `prefix_online` WHERE uptime > '" . $dif . "'" ; $resultID = db_query( $abf ); $brk = '' ; $uid = array (); $guests = 0; $guestn = $lang [ 'guests' ]; $content = '' ; while ( $row = db_fetch_object( $resultID )) { if ( $row ->uid != 0 AND $brk != $row ->uid) { $name =@db_result(db_query( 'SELECT name FROM prefix_user WHERE id=' . $row ->uid),0); $content .= '<tr><td><img src="include/images/icons/online.gif" border="0" alt="online"></td>' ; $content .= '<td><a href="index.php?user-details-' . $row ->uid. '">' . $name . '</a></td></tr>' . "\n" ; $uid [] = $row ->uid; } if ( $row ->uid == 0) { $guests ++; } $brk = $row ->uid; } if ( $guests == 1) { $guestn = $lang [ 'guest' ]; } if ( empty ( $content )) { $content .= '<tr><td><img src="include/images/icons/offline.gif" border="0" alt="offline"></td><td><font color="#003366">0 User </font></td></tr>' . "\n" ; } $content .= '<tr><td colspan="2"><hr style="height: 0px; border: dashed #9AB1C8 0px; border-top-width: 1px;"></td></tr>' . "\n" ; $where = ( count ( $uid )>0) ? 'WHERE id NOT IN (' .implode( ', ' , $uid ). ')' : '' ; $abf2 = 'SELECT * FROM prefix_user ' . $where . ' ORDER BY llogin DESC LIMIT 0,5' ; $erg2 = db_query( $abf2 ); while ( $row2 = db_fetch_object( $erg2 )) { $datum = date ( 'H:i d.m.y' , $row2 ->llogin); $user = $row2 ->name; $content .= '<tr><td><img src="include/images/icons/offline.gif" border="0" alt="offline"></td><td><a href="index.php?user-details-' . $row2 ->id. '" title="' . $lang [ 'lasttimeonline' ]. $datum . '">' . $user . '</a></td></tr>' . "\n" ; } if ( $guests == 0) { $content .= '<tr><td colspan="2"><hr style="height: 0px; border: dashed #9AB1C8 0px; border-top-width: 1px";></td></tr>' . "\n" .' <tr><td><img src= "include/images/icons/offline.gif" border= "0" alt= "offline" ></td><td><font size= "-1" color= "#003366" >0 '.$lang[' guests '].' </td></tr>'. "\n" ; } else { $content .= '<tr><td colspan="2"><hr style="height: 0px; border: dashed #9AB1C8 0px; border-top-width: 1px;"></td></tr>' . "\n" .' <tr><td><img src= "include/images/icons/online.gif" border= "0" alt= "online" ></td><td><font size=-1> '.$guests.' '.$guestn.' </font></td></tr>'. "\n" ; } ?> <table align= "center" border= "0" cellpadding= "0" cellspacing= "0" > <?php echo $content ; ?> </table> |
49 50 51 52 53 54 55 56 | function user_update_database () { $dif = date ( 'Y-m-d H:i:s' , time() - 7200); db_query( "UPDATE prefix_online SET uptime = now() WHERE sid = '" .session_id(). "'" ); db_query( "DELETE FROM prefix_online WHERE uptime < '" . $dif . "'" ); if ( loggedin() ) { db_query( "UPDATE prefix_user SET llogin = '" .time(). "' WHERE id = '" . $_SESSION ['authid ']."' "); } } |
1 | date_default_timezone_set('Europe/Berlin') |
10 11 12 13 14 15 16 17 18 19 20 21 22 23 | function db_connect () { if (defined( 'CONN' )) { return ; } define ( 'CONN' , @mysql_pconnect(DBHOST, DBUSER, DBPASS)); $db = @mysql_select_db(DBDATE, CONN); if (!CONN) { die ( 'Verbindung nicht möglich, bitte prüfen Sie ihre mySQL Daten wie Passwort, Username und Host<br />' ); } if ( ! $db ) { die ( 'Kann Datenbank "' .DBDATE. '" nicht benutzen : ' . mysql_error(CONN)); } } |
1 | mysql_query("SET `time_zone` = '".date('P')."'"); |