Webwereld

Alle gebruikers die online zijn weergeven

Gestart doorMilan10 reacties25 weergaven
Log in om mee te praten

11 berichten · pagina 1 van 1

Milan

Lid · Topicstarter

Berichten
8.602
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Hallo,

Ik kom niet echt uit, ik wil de gebruikers die online zijn weergeven, net zoals op One2xs, scriptje:

[COLOR= #0000BB]<?[/COLOR]
[COLOR= #007700]function[/COLOR] getWichOnlineUsersCount[COLOR= #007700](){[/COLOR]
    [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$conf[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$time[/COLOR][COLOR= #007700]=[/COLOR][URL="http://www.php.net/time"]time[/URL][COLOR= #007700]()-[/COLOR][COLOR= #0000BB]$conf[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]"minutes_per_turn"[/COLOR][COLOR= #007700]]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700];[/COLOR]
    
    [COLOR= #0000BB]$str[/COLOR][COLOR= #007700]=[/COLOR][COLOR= #DD0000]"SELECT COUNT(*) FROM `UserDetails` where lastTurnTime>$time and active=1"[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #FF8000]//echo time()."<br>";
    //echo $str;[/COLOR]
    [COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]= @[/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$str[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700]){[/COLOR]
        [COLOR= #0000BB]$st[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$st[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700]];
    }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR][URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];}[/COLOR]
    [COLOR= #FF8000]//echo "--{$st[0]}---";[/COLOR]
[COLOR= #007700]}[/COLOR]
?>


Weet iemand hoe ik de gebruikers die online zijn laat zien?
0
Rik

Lid

Berichten
18.393
Reputatie
0
Punten
0,04
Lid sinds
Laatst gezien
Als ik het goed heb laat je hiermee alle namen zien:

[COLOR= #0000BB]<?[/COLOR]
[COLOR= #007700]function[/COLOR] getWichOnlineUsers[COLOR= #007700](){[/COLOR]
    [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$conf[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$time[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]()-[/COLOR][COLOR= #0000BB]$conf[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]"minutes_per_turn"[/COLOR][COLOR= #007700]]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700];[/COLOR]
    
    [COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT username, FROM UserDetails where lastTurnTime > "[/COLOR] [COLOR= #007700].[/COLOR][COLOR= #0000BB]$time[/COLOR][COLOR= #007700].[/COLOR] [COLOR= #DD0000]" and active=1"[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700])) {[/COLOR]
        [COLOR= #0000BB]$onlist[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]&nbsp;[/COLOR][COLOR= #007700];
    }[/COLOR]
    
    [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$onlist[/COLOR][COLOR= #007700];
}[/COLOR]

[URL="http://www.php.net/echo"]echo[/URL] getWichOnlineUsers[COLOR= #007700]();[/COLOR]
?>


Of bedoelde je dat niet ?
0
Sjoerd

Lid

Berichten
13.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
[COLOR= #0000BB]<?[/COLOR]
[COLOR= #007700]function[/COLOR] getWichOnlineUsersCount[COLOR= #007700](){[/COLOR]
    [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$conf[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$time[/COLOR][COLOR= #007700]=[/COLOR][URL="http://www.php.net/time"]time[/URL][COLOR= #007700]()-[/COLOR][COLOR= #0000BB]$conf[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]"minutes_per_turn"[/COLOR][COLOR= #007700]]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700];[/COLOR]
    
    [COLOR= #0000BB]$str[/COLOR][COLOR= #007700]=[/COLOR][COLOR= #DD0000]"SELECT COUNT(*) AS aantal FROM `UserDetails` where lastTurnTime>$time and active=1"[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #FF8000]//echo time()."<br>";
    //echo $str;[/COLOR]
    [COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]= @[/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$str[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700]){[/COLOR]
        [COLOR= #0000BB]$st[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$st[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aantal[/COLOR][COLOR= #007700]];
    }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR][URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];}[/COLOR]
    [COLOR= #FF8000]//echo "--{$st[0]}---";[/COLOR]
[COLOR= #007700]}[/COLOR]
?>


of je bedoelt die van Rik
0
Rik

Lid

Berichten
18.393
Reputatie
0
Punten
0,04
Lid sinds
Laatst gezien
Inderdaad, je geeft de count de naam "aantal" mee, dan moet je die wel gebruiken yummie
0
Milan

Lid · Topicstarter

Berichten
8.602
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/milan/domains/manatwar.nl/public_html/test.php on line 8

Als ik die van Rik doe
0
Lennard

Lid

Berichten
35.796
Reputatie
1
Punten
0,00
Lid sinds
Laatst gezien
Sjoerd schreef:
[COLOR= #0000BB]<?[/COLOR]
[COLOR= #007700]function[/COLOR] getWichOnlineUsersCount[COLOR= #007700](){[/COLOR]
    [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$conf[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$time[/COLOR][COLOR= #007700]=[/COLOR][URL="http://www.php.net/time"]time[/URL][COLOR= #007700]()-[/COLOR][COLOR= #0000BB]$conf[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]"minutes_per_turn"[/COLOR][COLOR= #007700]]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700];[/COLOR]
    
    [COLOR= #0000BB]$str[/COLOR][COLOR= #007700]=[/COLOR][COLOR= #DD0000]"SELECT COUNT(*) AS aantal FROM `UserDetails` where lastTurnTime>$time and active=1"[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #FF8000]//echo time()."<br>";
    //echo $str;[/COLOR]
    [COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]= @[/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$str[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700]){[/COLOR]
        [COLOR= #0000BB]$st[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$st[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aantal[/COLOR][COLOR= #007700]];
    }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR][URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];}[/COLOR]
    [COLOR= #FF8000]//echo "--{$st[0]}---";[/COLOR]
[COLOR= #007700]}[/COLOR]
?>
of je bedoelt die van Rik

Geen count(*) he. emo
0
Bartv

Lid

Berichten
4.451
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Hij zegt van:
Wie er online zijn
0
Sjoerd

Lid

Berichten
13.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Sjoerd schreef:
[COLOR= #0000BB]<?[/COLOR]
[COLOR= #007700]function[/COLOR] getWichOnlineUsersCount[COLOR= #007700](){[/COLOR]
    [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$conf[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$time[/COLOR][COLOR= #007700]=[/COLOR][URL="http://www.php.net/time"]time[/URL][COLOR= #007700]()-[/COLOR][COLOR= #0000BB]$conf[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]"minutes_per_turn"[/COLOR][COLOR= #007700]]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700];[/COLOR]
    
    [COLOR= #0000BB]$str[/COLOR][COLOR= #007700]=[/COLOR][COLOR= #DD0000]"SELECT COUNT(1) AS aantal FROM `UserDetails` where lastTurnTime>$time and active=1"[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #FF8000]//echo time()."<br>";
    //echo $str;[/COLOR]
    [COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]= @[/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$str[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700]){[/COLOR]
        [COLOR= #0000BB]$st[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$st[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aantal[/COLOR][COLOR= #007700]];
    }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR][URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];}[/COLOR]
    [COLOR= #FF8000]//echo "--{$st[0]}---";[/COLOR]
[COLOR= #007700]}[/COLOR]
?>
of je bedoelt die van Rik

of

Guildjuhh:
Als ik het goed heb laat je hiermee alle namen zien:

[COLOR= #0000BB]<?[/COLOR]
[COLOR= #007700]function[/COLOR] getWichOnlineUsers[COLOR= #007700](){[/COLOR]
    [URL="http://www.php.net/global"]global[/URL] [COLOR= #0000BB]$conf[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$time[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]()-[/COLOR][COLOR= #0000BB]$conf[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]"minutes_per_turn"[/COLOR][COLOR= #007700]]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700];[/COLOR]
    
    [COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT username FROM UserDetails where lastTurnTime > "[/COLOR] [COLOR= #007700].[/COLOR][COLOR= #0000BB]$time[/COLOR][COLOR= #007700].[/COLOR] [COLOR= #DD0000]" and active=1"[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$fetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$q[/COLOR][COLOR= #007700])) {[/COLOR]
        [COLOR= #0000BB]$onlist[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #0000BB]$fetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]username[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]&nbsp;[/COLOR][COLOR= #007700];
    }[/COLOR]
    
    [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$onlist[/COLOR][COLOR= #007700];
}[/COLOR]

[URL="http://www.php.net/echo"]echo[/URL] getWichOnlineUsers[COLOR= #007700]();[/COLOR]
?>


Of bedoelde je dat niet ?

hij had een , neergezet achter username emo
0
Rik

Lid

Berichten
18.393
Reputatie
0
Punten
0,04
Lid sinds
Laatst gezien
Oh sorry, ik had dat script van jou gekopieerd (@ TS) dus er zat inderdaad nog een komma in yummie
0
Rik

Lid

Berichten
18.393
Reputatie
0
Punten
0,04
Lid sinds
Laatst gezien
Geen dank worshippy
0

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren