Webwereld

Help me:)

Gestart doorShahiem9 reacties64 weergaven
Log in om mee te praten

10 berichten · pagina 1 van 1

Shahiem

Lid · Topicstarter

Berichten
20.364
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Kan iemand me helpen
Ik krijg dit als foutmelding:
Parse error: syntax error, unexpected T_ELSE in /home/shahiem/domains/shahiem.one2xs.com/public_html/class/head.class.php on line 180

En me code is:

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

[URL="http://www.php.net/require_once"]require_once[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]config.php[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/require_once"]require_once[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"pagina/cookiecheck.php"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/require_once"]require_once[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]instellingen.php[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/require_once"]require_once[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"class/ubb.class.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]admin[/COLOR][COLOR= #007700]])) {[/COLOR]
[URL="http://www.php.net/require_once"]require_once[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"class/admin.class.php"[/COLOR][COLOR= #007700]); }[/COLOR]
[URL="http://www.php.net/require_once"]require_once[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"pagina/ipban.php"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/require_once"]require_once[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"class/poll.class.php"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/require_once"]require_once[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"pagina/inlogcheck.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]id[/COLOR][COLOR= #007700]])) {[/COLOR]
    [URL="http://www.php.net/require_once"]require_once[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]pagina/alert.php[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/require_once"]require_once[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]pagina/nieuwcadeau.php[/COLOR][COLOR= #007700]);
}[/COLOR]

[URL="http://www.php.net/class"]class[/URL] profielen [COLOR= #007700]{
        function[/COLOR] registeren[COLOR= #007700]([/COLOR][COLOR= #0000BB]$gebruikersnaam[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$wachtwoord[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$opvraagwoord[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$email[/COLOR][COLOR= #007700]) {[/COLOR]
        [COLOR= #FF8000]// Eerst halen we alle rare tekens eruit EN hakken we bij de 255 letters/cijfers de rest eraf, Maximale [/COLOR]

lengte is [COLOR= #0000BB]255
$gebruikersnaam[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$gebruikersnaam[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]25[/COLOR][COLOR= #007700]));[/COLOR]
              [COLOR= #0000BB]$gebruikersnaam[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ereg_replace"]ereg_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]<[/COLOR][COLOR= #007700],[/COLOR]  [COLOR= #DD0000]>[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$gebruikersnaam[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #0000BB]$gebruikersnaam[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ereg_replace"]ereg_replace[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]>[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]>[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$gebruikersnaam[/COLOR][COLOR= #007700]);[/COLOR]

        [COLOR= #0000BB]$wachtwoord[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$wachtwoord[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]255[/COLOR][COLOR= #007700]));[/COLOR]
        [COLOR= #0000BB]$opvraagwoord[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$opvraagwoord[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]255[/COLOR][COLOR= #007700]));[/COLOR]
        [COLOR= #0000BB]$email[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$email[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]));[/COLOR]
        
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR]ACCOUNTPERIP [COLOR= #007700]!=[/COLOR] [COLOR= #DD0000]"nee"[/COLOR][COLOR= #007700]) {[/COLOR]
            [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT ip FROM leden WHERE 

ip="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][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]$sql[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je hebt helaas al een account aangemaakt op deze website.<br /><a 

href=javascript:history.go(-1)>Ga terug</a>"[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]();
            }
        }[/COLOR]
        [COLOR= #FF8000]// checken of ip al bestaat
        
        // nu gaan we hem erin stoppen[/COLOR]
        [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO leden 

(gebruikersnaam,wachtwoord,opvraagwoord,email,level,regdatum,ip,punten,muntjes,avatar,rang,handtekening) VALUES 

("[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$gebruikersnaam[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/md5"]md5[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$wachtwoord[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]","[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$opvraagwoord[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$email[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",0,NOW(),"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/COLOR][COLOR= #007700]].[/COLOR]

[COLOR= #DD0000]",0,"[/COLOR][COLOR= #007700].[/COLOR]MUNTJESBIJREGISTRATIE[COLOR= #007700].[/COLOR][COLOR= #DD0000]",,habbo,)"[/COLOR][COLOR= #007700]);[/COLOR]
        [COLOR= #0000BB]$row_member_id[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_insert_id"]mysql_insert_id[/URL][COLOR= #007700]();[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/eregi"]eregi[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Duplicate"[/COLOR][COLOR= #007700],[/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]())) {[/COLOR]
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"De gebruikersnaam of email die je hebt ingevuld is al van een van onze andere 

leden.<br />
            Kies dus een andere.<br />
            <a href=javascript:history.go(-1)>Ga terug</a>."[/COLOR][COLOR= #007700];
        }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]() !=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]) {[/COLOR]
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"De gebruikersnaam of email die je hebt ingevuld is al van een van onze andere 

leden.<br />
            Kies dus een andere.<br />
            <a href=javascript:history.go(-1)>Ga terug</a>."[/COLOR][COLOR= #007700];
        }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO profiel 

(member_id,naam,achternaam,woonplaats,hobby,website,favo_fansite,favo_kamer,grootprofiel)
                            VALUES ("[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row_member_id[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",,,,,,,,)"[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #FF8000]/// de gegevens worden gemaild ///[/COLOR]
            [COLOR= #0000BB]$headers[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]From: [/COLOR][COLOR= #007700].[/COLOR]EMAIL[COLOR= #007700].[/COLOR][COLOR= #DD0000][/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]"
"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]Content-type: text/html[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/mail"]mail[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$email[/COLOR][COLOR= #007700],[/COLOR]SITENAAM[COLOR= #007700],[/COLOR][COLOR= #DD0000]"Beste "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$gebruikersnaam[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]",<br /><br />Je hebt net op 

"[/COLOR][COLOR= #007700].[/COLOR]SITENAAM[COLOR= #007700].[/COLOR][COLOR= #DD0000]" een account gemaakt.<br>
            Hierbij mailen wij je de gegevens.<br />
            Gebruikersnaam : <strong>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$gebruikersnaam[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</strong><br>
            Wachtwoord : <strong>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$wachtwoord[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</strong><br>
            <br>
            Je kan meteen inloggen via <a href="[/COLOR][COLOR= #007700].[/COLOR]SITELINK[COLOR= #007700].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR]SITELINK[COLOR= #007700].[/COLOR][COLOR= #DD0000]"</a>"[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$headers[/COLOR][COLOR= #007700]);[/COLOR]  [COLOR= #FF8000]/// Dit is [/COLOR]

de hele [URL="http://www.php.net/mail"]mail[/URL] code
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"<h3>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$gebruikersnaam[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</h3>
            Je account is succesvol aangemaakt.<br>
            Je hebt een email gekregen met je gegevens.<br>
            Je kan <a href=?p=login>hier</a> meteen al inloggen."[/COLOR][COLOR= #007700];
        }
    }
    
    
    
    
    function[/COLOR] inloggen[COLOR= #007700]([/COLOR][COLOR= #0000BB]$gebruikersnaam[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$wachtwoord[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$remember[/COLOR][COLOR= #007700]) {[/COLOR]
        [COLOR= #FF8000]// rare tekens verwijderen[/COLOR]
        [COLOR= #0000BB]$gebruikersnaam[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$gebruikersnaam[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]25[/COLOR][COLOR= #007700]));[/COLOR]
        [COLOR= #0000BB]$wachtwoord[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$wachtwoord[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]255[/COLOR][COLOR= #007700]));[/COLOR]
        $[COLOR= #0000BB]$remember[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$remember[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]255[/COLOR][COLOR= #007700]));[/COLOR]
        [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT member_id,gebruikersnaam,level,rang FROM leden WHERE 

gebruikersnaam="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$gebruikersnaam[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" AND wachtwoord="[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/md5"]md5[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$wachtwoord[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]""[/COLOR][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]$sql[/COLOR][COLOR= #007700]) <[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"De gegevens die je hebt ingevult is fout.<br>
            Probeer het nog een keer.<br>
            <a href=javascript:history.go(-1)>Ga terug</a>."[/COLOR][COLOR= #007700];
        }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]rang[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #DD0000]"verbannen"[/COLOR][COLOR= #007700]) {[/COLOR]
                [COLOR= #FF8000]// als je level 6 is krijg je een speciale session zodat je admin bent[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]level[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]6[/COLOR][COLOR= #007700]) {[/COLOR]
                    [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]admin[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];
                }[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]level[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700]) {[/COLOR]
                    [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nieuwsreporter[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];
                }[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]level[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]5[/COLOR][COLOR= #007700]) {[/COLOR]
                    [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]moderator[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];
                }[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]level[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]3[/COLOR][COLOR= #007700]) {[/COLOR]
                    [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]forumbeheerder[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];
                }[/COLOR]
                
        [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]member_id[/COLOR][COLOR= #007700]];[/COLOR]
        [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]];[/COLOR]
        [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ip[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/COLOR][COLOR= #007700]];[/COLOR]
        [COLOR= #FF8000]/// RENTE ////[/COLOR]
        [COLOR= #0000BB]$dag[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/date"]date[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Y-m-d"[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO rente (member_id,dag) VALUES ("[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]",NOW())"[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]() !=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]) {[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je hebt vandaag al je rente gehad, je moet wachten tot morgen.<br />"[/COLOR][COLOR= #007700];
        }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$sql_club[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM clublid WHERE 

member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$row_club[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_club[/COLOR][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]$sql_club[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
                [COLOR= #0000BB]$sql_bank[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT bank FROM leden WHERE 

member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #0000BB]$row_bank[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_bank[/COLOR][COLOR= #007700]);[/COLOR]
                
                [COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$row_bank[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bank[/COLOR][COLOR= #007700]];[/COLOR]
                [COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]*[/COLOR] [COLOR= #0000BB]1.05[/COLOR][COLOR= #007700];[/COLOR]
                [COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/round"]round[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$aantal[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE leden SET bank="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$aantal[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" WHERE 

member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je hebt 5% rente gekregen op je bank saldo, Er staan nu 

<strong>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$aantal[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</strong> muntjes op je bank<br />"[/COLOR][COLOR= #007700];
            }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                [COLOR= #0000BB]$sql_bank[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT bank FROM leden WHERE 

member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #0000BB]$row_bank[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_bank[/COLOR][COLOR= #007700]);[/COLOR]
                
                [COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$row_bank[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bank[/COLOR][COLOR= #007700]];[/COLOR]
                [COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]*[/COLOR] [COLOR= #0000BB]1.02[/COLOR][COLOR= #007700];[/COLOR]
                [COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/round"]round[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$aantal[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE leden SET bank="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$aantal[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" WHERE 

member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je hebt 2% rente gekregen op je bank saldo, Er staan nu 

<strong>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$aantal[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</strong> muntjes op je bank<br />"[/COLOR][COLOR= #007700];
            }
        }[/COLOR]
        [COLOR= #FF8000]//// EINDE RENTE /////
        
        //// BEGIN CLUBLID /////[/COLOR]
        [COLOR= #0000BB]$sql_c[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM clublid WHERE member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][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]$sql_c[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
            [COLOR= #0000BB]$row_c[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_c[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$sql_club[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM clublid WHERE datum < CURRENT_DATE - 

INTERVAL 30 DAY AND member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][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]$sql_club[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
                [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"DELETE FROM clublid WHERE 

member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE leden SET rang=Habbo WHERE 

member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<br /><strong>Let op</strong> Je lidmaatschap op de habboclub is 

verlopen<br />"[/COLOR][COLOR= #007700];
            }
        }[/COLOR]
        [COLOR= #FF8000]//// EINDE CLUBLID //////
        
        //// BEGIN MUNTJES PER DAG ////[/COLOR]
        [COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]200[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// aantal muntjes dat erbij komt[/COLOR]
        [COLOR= #0000BB]$aantalclublid[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]300[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// aantal muntjes dat erbij komt als je clublid bent[/COLOR]
        
            [COLOR= #0000BB]$dag[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/date"]date[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Y-m-d"[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO muntjesperdag (member_id,dag) VALUES 

("[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]",NOW())"[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]() !=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]) {[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je hebt vandaag al je muntjes gehad, je moet wachten tot morgen."[/COLOR][COLOR= #007700];
            }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                [COLOR= #0000BB]$sql_club[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM clublid WHERE 

member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #0000BB]$row_club[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_club[/COLOR][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]$sql_club[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
                    [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE leden SET muntjes=muntjes+"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$aantal[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" 

WHERE member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je hebt "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$aantalclublid[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" muntjes erbij gekregen."[/COLOR][COLOR= #007700];
                }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                    [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE leden SET muntjes=muntjes+"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$aantalclublid[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" 

WHERE member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je hebt "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$aantalclublid[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" muntjes erbij gekregen."[/COLOR][COLOR= #007700];
                }
            }[/COLOR]
        [COLOR= #FF8000]//// EINDE MUNTJES PER DAG ////
                // HASH //[/COLOR]
                [COLOR= #0000BB]$sessdata[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]];[/COLOR]
                
                [COLOR= #0000BB]$sessdata_str[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/serialize"]serialize[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sessdata[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #0000BB]$md5hash[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/md5"]md5[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sessdata_str[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hash[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$md5hash[/COLOR][COLOR= #007700];[/COLOR]
                [COLOR= #FF8000]// HASH //[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$remember[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]"ja"[/COLOR][COLOR= #007700]) {[/COLOR]
                    [COLOR= #0000BB]$_COOKIE[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]hash[/COLOR][COLOR= #007700]] =[/COLOR] [COLOR= #0000BB]$md5hash[/COLOR][COLOR= #007700];[/COLOR]  [COLOR= #FF8000]// 1 jaar lang ingelogd![/COLOR]
                [COLOR= #007700]}[/COLOR]
                [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO sessies (member_id,hash,ip,date) VALUES 

("[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]member_id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]","[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$md5hash[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]",NOW())"[/COLOR][COLOR= #007700]);
                }[/COLOR]
                [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"<br /><br /><strong>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$gebruikersnaam[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</strong>, Je bent nu succesvol 

ingelogd.<br>
                Moment gedult, je wordt doorverwezen.
                <meta http-equiv=refresh content=3;URL=index.php?p=beveiligdepagina />"[/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]"Je account is verbannen van deze website.<br />Je kan daarom niet 

inloggen.<br /><a href="javascript:history.go(-1)">Ga terug</a>"[/COLOR][COLOR= #007700];
            }
        }
    }
    function[/COLOR] wachtwoordAanpassen[COLOR= #007700]([/COLOR][COLOR= #0000BB]$wachtwoordoud[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$wachtwoordnieuw[/COLOR][COLOR= #007700])  {[/COLOR]
        [COLOR= #0000BB]$wachtwoordoud[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$wachtwoordoud[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]255[/COLOR][COLOR= #007700]));[/COLOR]
        [COLOR= #0000BB]$wachtwoordnieuw[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$wachtwoordnieuw[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]255[/COLOR][COLOR= #007700]));[/COLOR]
        [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM leden WHERE member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
        [COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]wachtwoord[/COLOR][COLOR= #007700]] ==[/COLOR] [URL="http://www.php.net/md5"]md5[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$wachtwoordoud[/COLOR][COLOR= #007700]) && ([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]]) && 

([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]opvraagwoord[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]opvraagwoord[/COLOR][COLOR= #007700]])) {[/COLOR]
            [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE leden SET wachtwoord="[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/md5"]md5[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$wachtwoordnieuw[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]" WHERE 

member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND email="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND opvraagwoord="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]opvraagwoord[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]() ==[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]) {[/COLOR]
                [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"Je wachtwoord is succesvol geupdate.<br />Je kunt nu verder gaan.<br 

/><a href=javascript:history.go(-1)>Ga terug</a>"[/COLOR][COLOR= #007700];
            }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/return"]return[/URL] [URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]();
            }
        }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"Een of meerdere gegevens zijn fout, probeer het opnieuw.<br /><a 

href=javascript:history.go(-1)>Ga terug.</a>"[/COLOR][COLOR= #007700];
        }
    }
    function[/COLOR] rangAanpassen[COLOR= #007700]([/COLOR][COLOR= #0000BB]$rang_id[/COLOR][COLOR= #007700]) {[/COLOR]
        [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM gekochte_rangen WHERE member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" 

AND rang_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rang_id[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]""[/COLOR][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]$sql[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
            [COLOR= #0000BB]$sql_rangen[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT titel FROM shop_rangen WHERE 

rang_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$rang_id[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$row_rangen[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_rangen[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE leden SET rang="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row_rangen[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]titel[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" WHERE 

member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]() ==[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]) {[/COLOR]
                [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"Je rang is succesvol aangepast.<br /><a 

href=javascript:history.go(-1)>Ga terug</a>"[/COLOR][COLOR= #007700];
            }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/return"]return[/URL] [URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]();
            }
        }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"Dit is niet jou rang."[/COLOR][COLOR= #007700];
        }
    }
    function[/COLOR] stemmen[COLOR= #007700]([/COLOR][COLOR= #0000BB]$member_id[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]$cijfer[/COLOR][COLOR= #007700]) {[/COLOR]
        [COLOR= #0000BB]$cijfer[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cijfer[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]2[/COLOR][COLOR= #007700]));[/COLOR]
        [COLOR= #0000BB]$member_id[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/substr"]substr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$member_id[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700],[/COLOR][COLOR= #0000BB]30[/COLOR][COLOR= #007700]));[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cijfer[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]10[/COLOR][COLOR= #007700]) {[/COLOR]
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"Je kan niet hoger stemmen dan een 10"[/COLOR][COLOR= #007700];
        }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cijfer[/COLOR] [COLOR= #007700]<[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"Je kan niet lager stemmen dan een 1"[/COLOR][COLOR= #007700];
        }[/COLOR][URL="http://www.php.net/elseif"]elseif[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/is_numeric"]is_numeric[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$cijfer[/COLOR][COLOR= #007700])) {[/COLOR]
            [COLOR= #0000BB]$timeoutseconds[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]86400[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$timestamp[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]();[/COLOR]
            [COLOR= #0000BB]$timeout[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$timestamp[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]$timeoutseconds[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"DELETE FROM stemmen_ip WHERE moment<$timeout AND 

ip="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$member_id[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$timeoutseconds1[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]300[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$timestamp1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]();[/COLOR]
            [COLOR= #0000BB]$timeout1[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$timestamp1[/COLOR][COLOR= #007700]-[/COLOR][COLOR= #0000BB]$timeoutseconds1[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"DELETE FROM stemmen_ip WHERE moment<$timeout1 AND 

ip="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" AND member_id != "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$member_id[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
            
            [COLOR= #0000BB]$sql_spam[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM stemmen_ip WHERE 

ip="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][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]$sql_spam[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) {[/COLOR]
                [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE leden SET punten=punten+"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cijfer[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", 

muntjes=muntjes+"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$cijfer[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" WHERE member_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$member_id[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO stemmen_ip (ip,moment,member_id) VALUES 

("[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]","[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$timestamp[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$member_id[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]")"[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]() ==[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]) {[/COLOR]
                    [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"Je hebt succesvol gestemd.<br />
                    Je kan over 24 uur pas weer op dit profiel stemmen.<br /><a 

href=javascript:history.go(-1)>Ga terug</a>"[/COLOR][COLOR= #007700];
                }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/eregi"]eregi[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Duplicate"[/COLOR][COLOR= #007700],[/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]())) {[/COLOR]
                        [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"Je hebt al op dit lid in de afgelopen 24 uur 

gestemd.<br /><a href=javascript:history.go(-1)>Ga terug</a>"[/COLOR][COLOR= #007700];
                    }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                        [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"Je hebt waarschijnlijk al op dit lid gestemd in de 

laatste 24 uur.<br />Zo niet, dat is er iets onbekends mis gegaan.<br /><a href=# onclick=history.go(-1)>Probeer 

gerust opnieuw.</a>"[/COLOR][COLOR= #007700];
                    }
                }
            }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"Je hebt al gestemd deze 5 minuten.<br /><a 

href=javascript:history.go(-1)>Ga terug</a>"[/COLOR][COLOR= #007700];
            }
        }[/COLOR][URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #DD0000]"Het cijfer dat je hebt ingevult is geen echt cijfer."[/COLOR][COLOR= #007700];
        }
    }[/COLOR][COLOR= #FF8000]// begin hier eventueel een nieuwe function[/COLOR]
[COLOR= #007700]}[/COLOR]

[COLOR= #0000BB]$doe[/COLOR] [COLOR= #007700]= new[/COLOR] profielen[COLOR= #007700]();[/COLOR]

[COLOR= #0000BB]$sql_instellingen[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM instellingen WHERE instellingen_id=1"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$instellingen[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql_instellingen[/COLOR][COLOR= #007700]);[/COLOR]


[COLOR= #FF8000]######## FILE_GET_CONTENTS ##############[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/function_exists"]function_exists[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]file_get_contents[/COLOR][COLOR= #007700])) {
function[/COLOR] [URL="http://www.php.net/file_get_contents"]file_get_contents[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$filename[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$use_include_path[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$context[/COLOR][COLOR= #007700]) {[/COLOR]

            [COLOR= #0000BB]$file_array[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/file"]file[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$filename[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$use_include_path[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$context[/COLOR][COLOR= #007700]);[/COLOR]

      [COLOR= #0000BB]$file_string[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/implode"]implode[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000][/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$file_array[/COLOR][COLOR= #007700]);[/COLOR]

  [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$file_string[/COLOR][COLOR= #007700];
}
}[/COLOR]

[COLOR= #FF8000]########## FILE_PUT_CONTENTS ############[/COLOR]

[URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/function_exists"]function_exists[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]file_put_contents[/COLOR][COLOR= #007700])) {[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][URL="http://www.php.net/defined"]defined[/URL][COLOR= #007700]([/COLOR]FILE_APPEND[COLOR= #007700])) {[/COLOR]
    [URL="http://www.php.net/define"]define[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]FILE_APPEND[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]);
    }
    function[/COLOR] file_put_contents[COLOR= #007700]([/COLOR][COLOR= #0000BB]$filename[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$flag[/COLOR] [COLOR= #007700]=[/COLOR] false[COLOR= #007700]) {[/COLOR]
        [COLOR= #0000BB]$mode[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$flag[/COLOR] [COLOR= #007700]==[/COLOR] FILE_APPEND [COLOR= #007700]||[/COLOR] [URL="http://www.php.net/strtoupper"]strtoupper[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$flag[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #DD0000]FILE_APPEND[/COLOR][COLOR= #007700]) ?[/COLOR] [COLOR= #DD0000]a[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]w[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$f[/COLOR] [COLOR= #007700]= @[/COLOR][URL="http://www.php.net/fopen"]fopen[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$n[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$mode[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$f[/COLOR] [COLOR= #007700]===[/COLOR] false[COLOR= #007700]) {[/COLOR]
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];
        }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/is_array"]is_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$d[/COLOR][COLOR= #007700]))[/COLOR] [COLOR= #0000BB]$d[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/implode"]implode[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$d[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$bytes_written[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/fwrite"]fwrite[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$f[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]$d[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/fclose"]fclose[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$f[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/return"]return[/URL] [COLOR= #0000BB]$bytes_written[/COLOR][COLOR= #007700];
        }
    }
}[/COLOR]

[COLOR= #FF8000]#//Onderhouds Pagina\#[/COLOR]
[COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT status FROM instellingen WHERE instellingen_id=1"[/COLOR][COLOR= #007700]);[/COLOR]

[COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]status[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"uit"[/COLOR] [COLOR= #007700]&& ![/COLOR][URL="http://www.php.net/isset"]isset[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]admin[/COLOR][COLOR= #007700]])) {[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" 

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Habbo - Mededeling</title>

<style type="text/css">

body {
    background: url(images/bg.gif);
}

.onderhoud_bg {
    background:url(images/onderhoud_bg.gif) repeat-y;
    font-family:Verdana, Arial, Helvetica, sans-serif;
    font-size:12px;
    padding-left: 90px;
    padding-right: 90px;
    text-align: left;
}

.onderhoud_top {
    background:url(images/onderhoud_top.gif) no-repeat;
    color:#FFFFFF;
    text-align: center;
    height:112px;
    width: 320px;
}

#habbotext {
    font-family:Georgia, Verdana, Arial, Helvetica, sans-serif;
    font-size: 18px;
    font-weight: bold;
    color:#FFFFFF;
    text-align: center;
    width: 700px;
}
</style>
</head>

<body>

<center>
    <table width="700" cellpadding="0" cellspacing="0">
        <tr>
            <td class="onderhoud_top"><div id="habbotext" align="center">[/COLOR][COLOR= #007700].[/COLOR]SITENAAM[COLOR= #007700].[/COLOR][COLOR= #DD0000]</div>
            </td>
        </tr>
        <tr>
            <td class="onderhoud_bg">[/COLOR][COLOR= #007700].[/COLOR]ONDERHOUDTEKST[COLOR= #007700].[/COLOR][COLOR= #DD0000]
                <br />
                <br /><br /><br />
              <strong>Admin login</strong><br /> [/COLOR][COLOR= #007700];[/COLOR]
              [URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"pagina/login.php"[/COLOR][COLOR= #007700]);[/COLOR] 
              [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]<br />
                    <br /></td>
        </tr>
        <tr>
            <td><img src="images/onderhoud_bottom.gif" /></td>
        </tr>
    </table>
</center>
</body>
</html>
[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/die"]die[/URL][COLOR= #007700]();
}[/COLOR]
[COLOR= #FF8000]#\End of onderhouds pagina//#



// Nieuw Bericht? //[/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]id[/COLOR][COLOR= #007700]])) {[/COLOR]
    [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM berichten WHERE gelezen=nee AND aan="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][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]$sql[/COLOR][COLOR= #007700]) >=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]) {[/COLOR]
        [COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]);[/COLOR]
        
        [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE berichten SET gelezen=ja WHERE bericht_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht_id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
        ?>
        <!--- Nieuw Bericht ----->
        <style type="text/css">
        div.error_top
        {
            background-image:url(images/messagebox_top.gif);
            overflow:hidden;
            width:448px;
            height:24px;
            padding:1px;
            font-weight:bold;
            color:#111111;
            text-align:center;
            cursor:move;
        }
        
        div.error_venster {
            color:#000000;
        }
        div.error_mdl
        {
            background-image:url(images/messagebox_middle.png);
            overflow:hidden;
            width:430px;
            color: #000000;
            text-align:left;
            font-family: Verdana, Arial, Helvetica, sans-serif;
            font-size: 12px;
            
        }
        div.error_dwn
        {
            background-image:url(images/messagebox_down.gif);
            overflow:hidden;
            width:450px;
            height:24px;
        }
        p.base_name
        {
            font-size:13px;
            color:#EEEEEE;
            font-family: Verdana, Arial, Helvetica, sans-serif;
        }
        a.berichtbekijken, a.berichtbekijken:visited {
            color: #990000;
        }
        a.berichtbekijken:hover {
            color:#FF9900;
        }
        </style>
        <script language="javascript" type="text/javascript" src="js/actions.js"></script>
        <div id="error_venster" style="display: block; position:fixed; left:300px; top:60px;"><div 

class="error_top" onMouseDown="dragStart(event, error_venster)">
            <table width="320">
                <tr>
                    <td width="10"></td>
                    <td width="310" align="center"><p class="base_name">Je hebt een 

nieuw bericht</p></td>
                    <td valign="top"><a href="#" 

onClick="sluitDiv(error_venster)">Sluiten</a>
                </tr>
            </table>
            </div>
            <div class="error_mdl" id="error_melding" style="padding-left: 20px;">
                [COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht[/COLOR][COLOR= #007700]];[/COLOR] ?><br />
                <a class="berichtbekijken" href="?p=bericht&bid=[COLOR= #0000BB]<?php[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]bericht_id[/COLOR][COLOR= #007700]];[/COLOR] 

?>">Bericht Bekijken</a>
            </div>
            
            <div class="error_dwn"></div>
        </div>
        <!---- Einde nieuw bericht --->
        [COLOR= #0000BB]<?php[/COLOR]
    [COLOR= #007700]}
}[/COLOR]
[COLOR= #FF8000]// Einde nieuw bericht //

// Begin van online bezoekers //[/COLOR]
[COLOR= #0000BB]$s_aantal[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT Count(id) FROM bezonline WHERE ip = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/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/if"]if[/URL] [COLOR= #007700](![/COLOR][URL="http://www.php.net/mysql_result"]mysql_result[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$s_aantal[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]))[/COLOR] 
    [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO bezonline (ip, tijd) VALUES ("[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/time"]time[/URL][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/else"]else[/URL] [COLOR= #007700]{[/COLOR]  
    [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE bezonline SET tijd = "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/time"]time[/URL][COLOR= #007700]().[/COLOR][COLOR= #DD0000]" WHERE ip = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/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/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"DELETE FROM bezonline WHERE tijd < "[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/time"]time[/URL][COLOR= #007700]().[/COLOR][COLOR= #DD0000]" - 60*5"[/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]
[COLOR= #FF8000]// Einde van online bezoekers //[/COLOR]

[COLOR= #0000BB]$sql1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT member_id,gebruikersnaam,level,rang FROM leden WHERE 

gebruikersnaam="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$gebruikersnaam[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" AND wachtwoord="[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/md5"]md5[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$wachtwoord[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$row1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql1[/
0
Admir

Lid

Berichten
1.950
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
heb je regel 180 goed afgesloten? of het komt door ""); een het einde van regel 180
0
Shahiem

Lid · Topicstarter

Berichten
20.364
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
O Al opgelost , maar ik heb nog een fout, bij Nieuws Headlines

Foutmelding:
Warning: mysql_query() [function.mysql-query]: Access denied for user apache@localhost (using password: NO) in /home/shahiem/domains/shahiem.one2xs.com/public_html/statistieken/nieuwsheadlines.php on line 11

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/shahiem/domains/shahiem.one2xs.com/public_html/statistieken/nieuwsheadlines.php on line 11

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/shahiem/domains/shahiem.one2xs.com/public_html/statistieken/nieuwsheadlines.php on line 13
Er zijn geen nieuws berichten gevonden.

[COLOR= #0000BB]<?php

$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"
                        SELECT n.nieuws_id, n.titel, n.datum, l.gebruikersnaam, l.member_id, COUNT(r.reactie_id) AS reacties
                                FROM nieuws_berichten AS n
                                LEFT JOIN leden AS l ON n.member_id = l.member_id
                                LEFT JOIN nieuws_reacties AS r ON n.nieuws_id = r.nieuws_id
                                GROUP BY n.nid
                                ORDER BY n.datum DESC
                                LIMIT 5
                      "[/COLOR][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]$sql[/COLOR][COLOR= #007700]) >[/COLOR] [COLOR= #0000BB]0[/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_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700])) {[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"
<tr><td></td><td>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]datum[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</td><td><a href=?p=nieuws&nid="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nieuws_id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/stripslashes"]stripslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]titel[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</a></td><td>Door: <a href=index.php?p=profiel&mid="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]member_id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR][URL="http://www.php.net/stripslashes"]stripslashes[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row_member[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]gebruikersnaam[/COLOR][COLOR= #007700]]).[/COLOR][COLOR= #DD0000]"</a></td></tr>
"[/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 zijn geen nieuws berichten gevonden.<br />"[/COLOR][COLOR= #007700];
}[/COLOR]

?>
0
Admir

Lid

Berichten
1.950
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
probeer:

if(mysql_num_rows($sql) >= 0) {
0
Luukvdo

Lid

Berichten
18.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Maak verbinding met de database yummie
0
Shahiem

Lid · Topicstarter

Berichten
20.364
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Gedaan nu krij ik alleen nog dit:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/shahiem/domains/shahiem.one2xs.com/public_html/statistieken/nieuwsheadlines.php on line 14
Er zijn geen nieuws berichten gevonden.

Dus nog 1 error moet ik oplossen
0
Luukvdo

Lid

Berichten
18.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Werkt het wel als je:

if(mysql_num_rows($sql))


of

if(mysql_num_rows($sql) >= 0)


doet i.p.v.

if(mysql_num_rows($sql) > 0)


?
0
Shahiem

Lid · Topicstarter

Berichten
20.364
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Nah ze doen eht niet.
0
Luukvdo

Lid

Berichten
18.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Wat gebeurd er als je de query draait in PhpMyAdmin?
0
Erik

Lid

Berichten
7.109
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Zet er eens or die(mysql_error()); achter.
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