Online script

Ik heb online script maar de gasten worden wel weergeven maar de leden niet.
Kan iemand me daarmee helpen.

Online.php:

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/require_once"]require_once[/URL] [COLOR= #DD0000]inc/header.php[/COLOR][COLOR= #007700];[/COLOR]
online[COLOR= #007700]([/COLOR][COLOR= #DD0000]1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$id[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]log_id[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$online_query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM `member_online` WHERE DATE_ADD(uLast, INTERVAL 150 SECOND) > NOW() ORDER BY `uLast` DESC"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[COLOR= #0000BB]$online_queryl[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM `gast_online` WHERE DATE_ADD(uLast, INTERVAL 150 SECOND) > NOW() ORDER BY `uLast` DESC"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$online_query[/COLOR][COLOR= #007700]) !=[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]||[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$online_queryl[/COLOR][COLOR= #007700]) !=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
{[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<table><tr><td><strong>Gebruikersnaam:</strong></td><td><strong>Laatst gezien:</strong></td><td><strong>Locatie:</strong></td></tr>[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$online_query[/COLOR][COLOR= #007700]))
        {[/COLOR]
                        [COLOR= #0000BB]$sq[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM leden WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
                        [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$online2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sq[/COLOR][COLOR= #007700]))
                        {[/COLOR]
                                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<tr><td style="width: 150px;"><a href="profiel?id=[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]"><span style="color:[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uCol[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000];font-weight: bold;width: 150px;">[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]</span></a></td><td>[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uLast[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]</td><td><a href="
                                [/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uPage[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]
">[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uPage[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]</a></td></tr>[/COLOR][COLOR= #007700];
                        }
                }[/COLOR]
                [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$online_queryl[/COLOR][COLOR= #007700]))
                {[/COLOR]
                        [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<tr><td style="width: 150px;"><em>Gast</em></td><td>[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uLast[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]</td><td><a href="[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uPage[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]">[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uPage[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]</a></td></tr>[/COLOR][COLOR= #007700];
                }[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]</table>[/COLOR][COLOR= #007700];
        }[/COLOR]
[URL="http://www.php.net/require_once"]require_once[/URL] [COLOR= #DD0000]inc/footer.php[/COLOR][COLOR= #007700];[/COLOR]
?>

Function:

[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #007700]function[/COLOR] online[COLOR= #007700]([/COLOR][COLOR= #0000BB]$s[/COLOR][COLOR= #007700])
{[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$s[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
    {[/COLOR]
    [COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(1) AS onlinecount FROM member_online WHERE DATE_ADD(uLast, INTERVAL 150 SECOND) > NOW()"[/COLOR][COLOR= #007700]))[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$q[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onlinecount[/COLOR][COLOR= #007700]];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Er [/COLOR] [COLOR= #007700]. ([/COLOR][COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]1[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000]is [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000] lid[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]zijn [/COLOR] [COLOR= #007700]. ([/COLOR][COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000]0[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$rows[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000] leden[/COLOR][COLOR= #007700]) .[/COLOR]  [COLOR= #DD0000] online.<br />[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$s[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]){[/COLOR]
    [COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(1) AS onlinecount FROM member_online WHERE DATE_ADD(uLast, INTERVAL 150 SECOND) > NOW()"[/COLOR][COLOR= #007700]))[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[COLOR= #0000BB]$ql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(1) AS onlinecount FROM gast_online WHERE DATE_ADD(uLast, INTERVAL 150 SECOND) > NOW()"[/COLOR][COLOR= #007700]))[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$q[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onlinecount[/COLOR][COLOR= #007700]] +[/COLOR] [COLOR= #0000BB]$ql[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onlinecount[/COLOR][COLOR= #007700]];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Er [/COLOR] [COLOR= #007700]. ([/COLOR][COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]1[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000]is [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000] bezoeker[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]zijn [/COLOR] [COLOR= #007700]. ([/COLOR][COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000]0[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$rows[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000] bezoekers[/COLOR][COLOR= #007700]) .[/COLOR]  [COLOR= #DD0000] online, [/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Waarvan [/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onlinecount[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000] ingelogd.[/COLOR][COLOR= #007700];
}[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]Er ging iets fout in de functie online laden[/COLOR][COLOR= #007700];
    }
}[/COLOR]
?>

Header

$f55 = mysql_query("SELECT * FROM `member_online` WHERE uId = ".isset($_SESSION[uId])."");

    if(mysql_num_rows($f55) == 0)
    {
        mysql_query("INSERT INTO member_online (uLast, uPage, uId) VALUES (NOW(), ".$_SERVER[REQUEST_URI].",". isset($_SESSION[uId]) .")");
    }
    else
    {
        mysql_query("UPDATE member_online SET uLast = NOW(), uPage = ".$_SERVER[REQUEST_URI]." WHERE uId = " . $_SESSION[uId]);
        mysql_query("UPDATE leden SET online = NOW() WHERE id = ".$_SESSION[log_id] ."");
    }
    $sss = mysql_query("SELECT * FROM gast_online WHERE gip = ". $_SERVER[REMOTE_ADDR] ."");

    if(mysql_num_rows($sss) == 0)
    {
        mysql_query("INSERT INTO gast_online (uLast, uPage, gip) VALUES (NOW(), ".$_SERVER[REQUEST_URI].",". $_SERVER[REMOTE_ADDR] .")");
    }
    else
    {
        mysql_query("UPDATE gast_online SET uLast = NOW(), uPage = ".$_SERVER[REQUEST_URI]." WHERE gip = ". $_SERVER[REMOTE_ADDR] ."");
    }

Waarom gebruik je dit script niet?

[COLOR= #0000BB]<?php[/COLOR]

[URL="http://www.php.net/include_once"]include_once[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"config.php"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/include_once"]include_once[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"connect.php"[/COLOR][COLOR= #007700]);[/COLOR]

[COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT name,state FROM `"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$db_tbl[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"` WHERE DATE_SUB(NOW(),INTERVAL 5 MINUTE) <= lastactive ORDER BY name ASC"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$count[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_object"]mysql_fetch_object[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700])) {[/COLOR]
 [COLOR= #0000BB]$name[/COLOR] [COLOR= #007700]=[/COLOR] htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700]->[/COLOR]name[COLOR= #007700]);[/COLOR]
 [COLOR= #0000BB]$state[/COLOR] [COLOR= #007700]=[/COLOR] htmlspecialchars[COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700]->[/COLOR]state[COLOR= #007700]);[/COLOR]
 [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$state[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
  [COLOR= #0000BB]$naam[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"<b>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$name[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</b>"[/COLOR][COLOR= #007700];
 }[/COLOR]
 [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$name[/COLOR][COLOR= #007700];[/COLOR]
 [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]!=[/COLOR] [COLOR= #0000BB]$count[/COLOR][COLOR= #007700]) {[/COLOR]
  [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]", "[/COLOR][COLOR= #007700];
 }[/COLOR]
 [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++;
}[/COLOR]        
?>

ik heb dit script gemaakt maar aangezien shahiem me blokt @ MSN kan ik niet helpen
en kan hij wel het script gratis weggeven

Uhh.. dit script is van PHP My login.

Allard schreef:

Uhh.. dit script is van PHP My login.

Daar heeft hij toch niks aan, als hij zijn eigen systeem gebruikt?

Ja erik heeft gelijk. Daar heb ik niks aan.

@Allard Daar heeft Shahiem toch niks aan, er zit geen sql of wat in.

Marijnnn:
@Allard Daar heeft Shahiem toch niks aan, er zit geen sql of wat in.

Duh je moet script tog aan passen in je eigen database tabel gegevens

De SQL gegevens staan in include_once("config.php");.

Ja, en die hebben wij niet?

Maar ik vraag om hulp en niet om een ander script.

Dus

mysql_query("INSERT INTO member_online (uLast, uPage, uId) VALUES (NOW(), ".$_SERVER[REQUEST_URI].",". isset($_SESSION[uId]) .")");
    }
    else
    {
        mysql_query("UPDATE member_online SET uLast = NOW(), uPage = ".$_SERVER[REQUEST_URI]." WHERE uId = " . $_SESSION[uId]);

moet session login_id toch?