Ik heb een php bestand genaamd stats2.php
Dit is de code:
[COLOR= #0000BB]<?[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]_include.php[/COLOR][COLOR= #007700]);[/COLOR]
?>
<h2>Stats</h2>
<p>
[COLOR= #0000BB]<?
$leden1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM users"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$leden[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$leden1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$result1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT sum(uitbetaald) FROM users"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$row1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$result2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT sum(uitbetaald2) FROM users"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$row2[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result2[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$result3[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT sum(kliks) FROM users"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$row3[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result3[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$credits[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$row1[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]"sum(uitbetaald)"[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$geld[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$row2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]"sum(uitbetaald2)"[/COLOR][COLOR= #007700]]*[/COLOR][COLOR= #0000BB]40[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$punten[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$row3[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]"sum(kliks)"[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$totaal[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$geld[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]$credits[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]$punten[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$top1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM `users` WHERE level = 1 and vip = yes"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$top[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$top1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$kliks1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM kliks"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$kliks[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$kliks1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$popup1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM popup_kliks"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$popup[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$popup1[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$links1[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM klikbottom"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$links[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$links1[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Aantal actieve leden: <b>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$leden[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</b><br>"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Totaal aantal VIP leden: <b>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$top[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</b><br>"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Totaal aantal punten verdiend door leden: <b>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$totaal[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</b><br>"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Totaal aantal verschillende links in het linkspel: <b>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$links[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</b><br>"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Totaal aantal kliks in het linkspel: <b>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$kliks[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</b><br>"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Totaal aantal unieke popup vieuws: <b>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$popup[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</b><br><br>"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$uitbetaald[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$row1[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]"sum(uitbetaald)"[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$uitbetaald2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$row2[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]"sum(uitbetaald2)"[/COLOR][COLOR= #007700]][/COLOR]/[COLOR= #0000BB]100[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$totaal2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$geld[/COLOR][COLOR= #007700]+[/COLOR][COLOR= #0000BB]$credits[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Totaal aantal punten uitbetaald: <b>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$totaal2[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</b><br>"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Totaal aantal credits uitbetaald: <b>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$uitbetaald[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</b><br>"[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Totaal aantal euros uitbetaald: <b>€"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$uitbetaald2[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</b>"[/COLOR][COLOR= #007700];[/COLOR]
?>
</p>
Nu wil ik dat die eerst geruned wordt dus dat er dit staat:
Stats
Aantal actieve leden: 374
Totaal aantal VIP leden: 4
Totaal aantal punten verdiend door leden: 1993616.2
Totaal aantal verschillende links in het linkspel: 7
Totaal aantal kliks in het linkspel: 1141689
Totaal aantal unieke popup vieuws: 70678
Totaal aantal punten uitbetaald: 1599511
Totaal aantal credits uitbetaald: 76431
Totaal aantal euros uitbetaald: €380.77
En dat moet dan in de stats.txt worden gezet