Klkikken

Ik wil graag dat je 1x per uur per account kan klikken en dat er max. 75 kliks per dag kunnen komen.

Wie zou dit kunnen maken ?

Dit is de code :

[COLOR= #0000BB]<?
$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM `users` WHERE `id`={$_GET[x]}"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$user[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_object"]mysql_fetch_object[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM `clicks` WHERE `ip`=$data->login AND `login`=$user->login AND `active`=1"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$checkclick[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$checkclick[/COLOR] [COLOR= #007700]<[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]){[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700]->[/COLOR]login [COLOR= #007700]!=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]){[/COLOR]
?>
<table width="100%">
    <tr>
        <td align="center">
            <br><br><br><br>
            <table class="div_popup" align="center">
                <tr>
                    <td>
                        [COLOR= #0000BB]<?[/COLOR]
[URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE `users` SET `killers`=`killers`+1,`bank`=`bank`+1000,`contant`=`contant`+500,`power`=`power`+50 WHERE `login`=$user->login"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE `families` SET `power`=`power`+50 WHERE `naam`=$user->familie"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO `clicks`(login,ip,date) values({$user->login},$data->login,NOW())"[/COLOR][COLOR= #007700]);[/COLOR]
 [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$user[/COLOR][COLOR= #007700]->[/COLOR]login[COLOR= #007700];[/COLOR] ?> heeft nu <b>[COLOR= #0000BB]<?[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$user[/COLOR][COLOR= #007700]->[/COLOR]killers[COLOR= #007700]+[/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR] ?></b> killers opgeleid!                    </td>
                </tr>
                <tr>
                    <td>
                        <br><br>
                            <a href="index.php?a=profile&x=<?echo $_GET[x];?>" class="msg_ok">Klik hier indien je niet automatisch verder gaat.</a>
                    </td>
                </tr>
            </table>
        </td>
    </tr>
</table>

<script language="javascript">
    setTimeout("document.location.href=index.php?a=profile&x=<?echo $_GET[x];?>",(3000*2));
</script>
        </div>
    </td>
    </tr>

    </table>
    </td>
[COLOR= #0000BB]<?[/COLOR]
[COLOR= #007700]}
}[/COLOR]
[URL="http://www.php.net/else"]else[/URL][COLOR= #007700]{[/COLOR]
?>
                    <table width="100%">
    <tr>
        <td align="center">
            <br><br><br><br>
            <table class="div_popup_error" align="center">
                <tr>
                    <td style="color:red">
                        <b>FOUT!</b><br><br>Je hebt deze persoon al opgeleid vandaag                    </td>
                </tr>
                <tr>
                    <td>
                        <br><br>
                                                    <a href="#" onclick="history.go(-1); return false" class="error_ok">OK</a>
                                            </td>
                </tr>
            </table>
        </td>
    </tr>
</table>
        </div>
    </td>
    </tr>

    </table>
    </td>
<?}?>

mogen we m?sch?en ook je sql anders hebben we er n?et echt veel aan denk ?k

Welk tabel heb je nodig ?