Wie is online?

Vandijkdesign · 2012-03-08T18:10:29.000Z

Dit heb ik nu allemaal: Klik om de spoiler te openen Codeblok: 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 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 " . print_r ( $sFetch , 1 ). "" ; // Als ip overeenkomt if ( $_SERVER [ REMOTE_ADDR ] == $sFetch [ SesIp ]) { // Zetten we de sessie $_SESSION [ uHash ] = $_COOKIE [ uHash ]; $_SESSION [ uId ] = $sFetch [ SesId ]; } } else { // Als beide geset zijn if ( isset ( $_SESSION [ uHash ]) && isset ( $_COOKIE [ uHash ])) { // Als beide een waarde hebben if (! empty ( $_SESSION [ uHash ]) && ! empty ( $_COOKIE [ uHash ])) { // Maar deze waardes niet overeenkomen if ( $_SESSION [ uHash ] != $_COOKIE [ uHash ]) { // Verwijder dan de gegevens @ mysql_query ( "DELETE FROM member_sessions WHERE uHash = " . $_SESSION [ uHash ] . "" ); session_destroy (); setcookie ( "uHash" , , time ()- 60 * 60 * 24 * 7 * 700 ); // En refresh echo ; } else { $sQuery = mysql_query ( "SELECT SesIp, SesId FROM member_sessions WHERE SesHash = " . $_SESSION [ uHash ] . "" ); $sFetch = mysql_fetch_assoc ( $sQuery ); // Als ip of uId niet overeenkomt met de waades in de sessie if (( $sFetch [ SesIp ] != $_SERVER [ REMOTE_ADDR ]) || ( $sFetch [ SesId ] != $_SESSION [ uId ])) { // Deleten en refresh @ mysql_query ( "DELETE FROM member_sessions WHERE uHash = " . $_SESSION [ uHash ] . "" ); session_destroy (); setcookie ( "uHash" , , time ()- 60 * 60 * 24 * 7 * 700 ); echo ; } } } } } if ( isset ( $_SESSION [ uId ])) { mysql_query ( "UPDATE member_accounts SET uLast = NOW() WHERE uId = " . $_SESSION [ uId ]); } ?> En bij het welkomsbericht staat: Klik om de spoiler te openen Codeblok: 1 2 3 Welkom Wat is er fout?!

Gestart doorVandijkdesign8 mrt 201238 reacties105 weergaven

39 berichten · pagina 3 van 3

Vandijkdesign

Lid · Topicstarter

Berichten: 753
Reputatie: 0
Punten: 0,06

Lid sinds: 2010
Laatst gezien: 6 feb 2026

10 mrt 2012, 16:37

#31

Dit heb ik nu allemaal:

Spoiler tonen

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]config.php[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/include"]include[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]functions.php[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #FF8000]// Sessie is verlopen, cookie niet[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_COOKIE[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uHash[/COLOR][COLOR= #007700]]) && ![/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uHash[/COLOR][COLOR= #007700]]))
{[/COLOR]
    [COLOR= #FF8000]// Selecteer sessie op cookie [/COLOR]
[COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT uId,uName,uPass FROM member_accounts WHERE uId = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]].[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$sQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/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/echo"]echo[/URL] [COLOR= #DD0000]"SQL: "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$sFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sQuery[/COLOR][COLOR= #007700]);[/COLOR]

[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Array:FORUMCODE0"[/COLOR][COLOR= #007700];[/COLOR]

    [COLOR= #FF8000]// Als ip overeenkomt[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]SesIp[/COLOR][COLOR= #007700]])
    {[/COLOR]
        [COLOR= #FF8000]// Zetten we de sessie[/COLOR]
        [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uHash[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$_COOKIE[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uHash[/COLOR][COLOR= #007700]];[/COLOR]
        [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]SesId[/COLOR][COLOR= #007700]];    
    }    
}[/COLOR]
[URL="http://www.php.net/else"]else[/URL]
[COLOR= #007700]{[/COLOR]
    [COLOR= #FF8000]// Als beide geset zijn[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uHash[/COLOR][COLOR= #007700]]) &&[/COLOR] [URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_COOKIE[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uHash[/COLOR][COLOR= #007700]]))
    {[/COLOR]
        [COLOR= #FF8000]// Als beide een waarde hebben [/COLOR]
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700](![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uHash[/COLOR][COLOR= #007700]]) && ![/COLOR][URL="http://www.php.net/empty"]empty[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_COOKIE[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uHash[/COLOR][COLOR= #007700]]))
        {[/COLOR]
            [COLOR= #FF8000]// Maar deze waardes niet overeenkomen[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uHash[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #0000BB]$_COOKIE[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uHash[/COLOR][COLOR= #007700]]) {[/COLOR]
                [COLOR= #FF8000]// Verwijder dan de gegevens[/COLOR]
                [COLOR= #007700]@[/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"DELETE FROM member_sessions WHERE uHash = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uHash[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/session_destroy"]session_destroy[/URL][COLOR= #007700]();[/COLOR]
                [URL="http://www.php.net/setcookie"]setcookie[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"uHash"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700],[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]()-[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]24[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]7[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]700[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #FF8000]// En refresh[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<meta http-equiv="refresh" content="0;url=index.php">[/COLOR][COLOR= #007700];   
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL]
            [COLOR= #007700]{[/COLOR] 
                [COLOR= #0000BB]$sQuery[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT SesIp, SesId FROM member_sessions WHERE SesHash = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uHash[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #0000BB]$sFetch[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sQuery[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #FF8000]// Als ip of uId niet overeenkomt met de waades in de sessie[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]SesIp[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/COLOR][COLOR= #007700]]) || ([/COLOR][COLOR= #0000BB]$sFetch[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]SesId[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]))
                {[/COLOR]
                    [COLOR= #FF8000]// Deleten en refresh[/COLOR]
                    [COLOR= #007700]@[/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"DELETE FROM member_sessions WHERE uHash = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uHash[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                    [URL="http://www.php.net/session_destroy"]session_destroy[/URL][COLOR= #007700]();[/COLOR]
                    [URL="http://www.php.net/setcookie"]setcookie[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"uHash"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700],[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]()-[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]24[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]7[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]700[/COLOR][COLOR= #007700]);[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<meta http-equiv="refresh" content="0;url=index.php">[/COLOR][COLOR= #007700];       
                }
            }
        }    
    }
}[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]))
{[/COLOR]
    [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE member_accounts SET uLast = NOW() WHERE uId = "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]);
}[/COLOR]
?>

En bij het welkomsbericht staat:

Spoiler tonen

<li><a href="#" class="user"><span class="bar">Welkom [COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/print_r"]print_r[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700]);[/COLOR]
?></span></a></li>

Wat is er fout?!

Aarclay

Lid

Berichten: 10.421
Reputatie: 4
Punten: 0,00

Lid sinds: 2012
Laatst gezien: 11 jun 2026

10 mrt 2012, 16:38

#32

En wat komt er nou uit:

print_r($_SESSION);
?>

Vandijkdesign

Lid · Topicstarter

Berichten: 753
Reputatie: 0
Punten: 0,06

Lid sinds: 2010
Laatst gezien: 6 feb 2026

10 mrt 2012, 16:41

#33

Aarclay schreef:
En wat komt er nou uit:

print_r($_SESSION);
?>

Welkom Array ( [uHash] => 4626056296c9f96e743784008136481826dfa83bac60c25e4fd11570cc6b9bee [uId] => 4 )

Aarclay

Lid

Berichten: 10.421
Reputatie: 4
Punten: 0,00

Lid sinds: 2012
Laatst gezien: 11 jun 2026

10 mrt 2012, 16:44

#34

En:

print_r($sFetch);

Dit moet een array tonen, lijkt me met o.a je username ($sFetch[uName])

Vandijkdesign

Lid · Topicstarter

Berichten: 753
Reputatie: 0
Punten: 0,06

Lid sinds: 2010
Laatst gezien: 6 feb 2026

10 mrt 2012, 16:50

#35

Aarclay schreef:
En:

print_r($sFetch);

Dit moet een array tonen, lijkt me met o.a je username ($sFetch[uName])

Nu krijg ik: Array ( [SesIp] => 145.53.193.214 [SesId] => 4 )

Aarclay

Lid

Berichten: 10.421
Reputatie: 4
Punten: 0,00

Lid sinds: 2012
Laatst gezien: 11 jun 2026

10 mrt 2012, 16:51

#36

Gebruik eens een andere var. voor die query op lijn 9, 11,13. Eentje waarmee je duidelijk maakt dat je de data uit je member-tabel ophaalt.

Want nu krijg je alle data uit je sessie-tabel.

Marjolein

Lid

Berichten: 15.446
Reputatie: 0
Punten: 0,00

Lid sinds: 2008
Laatst gezien: 21 dec 2020

11 mrt 2012, 09:51

#37

Alstu:

[COLOR= #0000BB]<?php                    
$gegevens_query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"
        SELECT
            uId,
            uName
        FROM
            member_accounts
        WHERE
            uId = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/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]$gegevens_query[/COLOR][COLOR= #007700]))
        {[/COLOR]
            
             [COLOR= #0000BB]$gegevens[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$gegevens_query[/COLOR][COLOR= #007700]);[/COLOR]
             [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$gegevens[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uName[/COLOR][COLOR= #007700]];
        }[/COLOR]
?>

Vandijkdesign

Lid · Topicstarter

Berichten: 753
Reputatie: 0
Punten: 0,06

Lid sinds: 2010
Laatst gezien: 6 feb 2026

11 mrt 2012, 13:19

#38

Marjolein schreef:

Alstu:

[COLOR= #0000BB]<?php                    
$gegevens_query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"
        SELECT
            uId,
            uName
        FROM
            member_accounts
        WHERE
            uId = "[/COLOR] [COLOR= #007700].[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/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]$gegevens_query[/COLOR][COLOR= #007700]))
        {[/COLOR]
            
             [COLOR= #0000BB]$gegevens[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$gegevens_query[/COLOR][COLOR= #007700]);[/COLOR]
             [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$gegevens[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uName[/COLOR][COLOR= #007700]];
        }[/COLOR]
?>

Helemaal top Marjolein, hartstikke bedankt!

Aarclay

Lid

Berichten: 10.421
Reputatie: 4
Punten: 0,00

Lid sinds: 2012
Laatst gezien: 11 jun 2026

11 mrt 2012, 13:37

#39

En dat legde ik dus uit, dat je een andere variabele moest nemen

Jouw reactie

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