Webwereld

hulp met bubble

Gestart doorMoerbeke61 reacties90 weergaven
Log in om mee te praten

62 berichten · pagina 1 van 5

Moerbeke

Lid · Topicstarter

Berichten
837
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
kan iemand ons helpen met deze bubble , de bedoeling is dat er bij lidnummer , gewoon de naam van het lid staat en bij saldo hun punten en niet een standaard getal wat hier honderderd is?
mvg

[COLOR= #0000BB]<?[/COLOR]
[URL="http://www.php.net/include"]include[/URL] [COLOR= #DD0000]"config.php"[/COLOR][COLOR= #007700];[/COLOR]

[COLOR= #0000BB]$uur[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]24[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]// na hoeveel uur hij reset.[/COLOR]
[COLOR= #0000BB]$time[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$uur[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]//berekend hoeveel seconden dat is[/COLOR]
[COLOR= #0000BB]$waardes[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]3[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]4[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]5[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]6[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]7[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]8[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]9[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]10[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]20[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]25[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]50[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$aantallen[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/array"]array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]1[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]2[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]3[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]4[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]5[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]6[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]7[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]8[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]9[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]10[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]20[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]25[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]50[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$per_pagina[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]25[/COLOR][COLOR= #007700];[/COLOR]  [COLOR= #FF8000]// Aantal bubbeltjes per pagina[/COLOR]
[COLOR= #0000BB]$limiet[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1000[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #FF8000]//Maximaal aantal bubbeltjes per lid[/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 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]$query[/COLOR][COLOR= #007700])){[/COLOR]
    [COLOR= #0000BB]$select[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$saldo[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$select[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]punten[/COLOR][COLOR= #007700]];[/COLOR]
    [COLOR= #0000BB]$lid_id[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$select[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/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 leden (ip) 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]$saldo[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]100[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$lid_id[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_insert_id"]mysql_insert_id[/URL][COLOR= #007700]();
}[/COLOR]
[COLOR= #0000BB]$settinqs[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM settings"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$data[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$settinqs[/COLOR][COLOR= #007700])){[/COLOR]
    [COLOR= #0000BB]$settings[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]]] =[/COLOR] [COLOR= #0000BB]$data[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]waarde[/COLOR][COLOR= #007700]];
}[/COLOR]
[COLOR= #0000BB]$reset[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$settings[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]reset[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$pot[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$settings[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]pot[/COLOR][COLOR= #007700]];[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/time"]time[/URL][COLOR= #007700]() >[/COLOR] [COLOR= #0000BB]$reset[/COLOR][COLOR= #007700]){[/COLOR]
    [COLOR= #0000BB]$reset[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]() +[/COLOR] [COLOR= #0000BB]$time[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$pot[/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]"TRUNCATE TABLE `nicopara_bubble`"[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE settings SET waarde=0 WHERE naam=pot"[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE settings SET waarde="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$reset[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" WHERE naam=reset"[/COLOR][COLOR= #007700]);
}[/COLOR]
[COLOR= #0000BB]$verschil[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$reset[/COLOR] [COLOR= #007700]-[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]();[/COLOR]
[COLOR= #0000BB]$over_uur[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/floor"]floor[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$verschil[/COLOR]/[COLOR= #0000BB]60[/COLOR]/[COLOR= #0000BB]60[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$over_min[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/floor"]floor[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$verschil[/COLOR] [COLOR= #007700]-[/COLOR] [COLOR= #0000BB]$over_uur[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700])[/COLOR]/[COLOR= #0000BB]60[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$over_sec[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/floor"]floor[/URL][COLOR= #007700](([/COLOR][COLOR= #0000BB]$verschil[/COLOR] [COLOR= #007700]-[/COLOR] [COLOR= #0000BB]$over_uur[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]60[/COLOR] [COLOR= #007700]-[/COLOR] [COLOR= #0000BB]$over_min[/COLOR][COLOR= #007700]*[/COLOR][COLOR= #0000BB]60[/COLOR][COLOR= #007700]));[/COLOR]
?>
<html>
<head>
<title>dutchklik</title>
</head>
<body>
<center>
<h1>DutchKlik Bubble</h1>
<h2>Punten: <?=$saldo?><br/>Jouw Lidnummer: <?=$lid_id?></h2>
<h3>Pot: <?=$pot?></h3>
<h3>Reset over <b><?=$over_uur?></b> uur, <b><?=$over_min?></b> minuten en <b><?=$over_sec?></b> seconden.</h3>
<h4><b>Info: </b></b>MOMENTEEL IS DE BUBBLE GRATIS!!<br><br> </center>Als je een bubbeltje plaatst gaat hiervan 90% in de pot, je word 125% van je bubbeltje uitbetaald als je bovenaan staat.<br/>
<b>Let op</b>, als er gereset word worden de bubbeltjes ook gereset en ben je dus je punten kwijt als je nog een bubbeltje erin had staan.<br/>
Er staat een limiet dat je maximaal <?=$limiet?> bubbeltjes mag plaatsen.</h4><center>
<h3>Bubbeltjes plaatsen:</h3>
[COLOR= #0000BB]<?[/COLOR] [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REQUEST_METHOD[/COLOR][COLOR= #007700]] ==[/COLOR] [COLOR= #DD0000]"POST"[/COLOR][COLOR= #007700]){[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/in_array"]in_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]waarde[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]$waardes[/COLOR][COLOR= #007700]) &&[/COLOR] [URL="http://www.php.net/in_array"]in_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aantal[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #0000BB]$aantallen[/COLOR][COLOR= #007700])){[/COLOR]
        [COLOR= #0000BB]$mijnbubbels[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT count(id) AS mijnbubbels FROM `bubbles` WHERE user_id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$lid_id[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
        [COLOR= #0000BB]$mijnbubbels[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mijnbubbels[/COLOR][COLOR= #007700]);[/COLOR]
        [COLOR= #0000BB]$mijnbubbels[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$mijnbubbels[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]mijnbubbels[/COLOR][COLOR= #007700]];[/COLOR]
        [COLOR= #0000BB]$saldo_2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$saldo[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$loten[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR]
        [COLOR= #0000BB]$bubbel_query[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"INSERT INTO `bubbles` (user_id, waarde)"[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]<[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aantal[/COLOR][COLOR= #007700]];[/COLOR] [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++){[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$mijnbubbels[/COLOR] [COLOR= #007700]<=[/COLOR] [COLOR= #0000BB]$limiet[/COLOR][COLOR= #007700]){[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$saldo_2[/COLOR] [COLOR= #007700]>=[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]waarde[/COLOR][COLOR= #007700]]){[/COLOR]
                    [COLOR= #0000BB]$saldo_2[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$saldo_2[/COLOR] [COLOR= #007700]-[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]waarde[/COLOR][COLOR= #007700]];[/COLOR]
                    [COLOR= #0000BB]$loten[/COLOR][COLOR= #007700]++;[/COLOR]
                    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
                        [COLOR= #0000BB]$bubbel_query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]" VALUES"[/COLOR][COLOR= #007700];
                    }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
                        [COLOR= #0000BB]$bubbel_query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]","[/COLOR][COLOR= #007700];
                    }[/COLOR]
                    [COLOR= #0000BB]$bubbel_query[/COLOR] [COLOR= #007700].=[/COLOR] [COLOR= #DD0000]" ("[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$lid_id[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]waarde[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]")"[/COLOR][COLOR= #007700];[/COLOR]
                    [COLOR= #0000BB]$mijnbubbels[/COLOR][COLOR= #007700]++;
                }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
                    [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aantal[/COLOR][COLOR= #007700]];
                }
            }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
                [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aantal[/COLOR][COLOR= #007700]];
            }
        }[/COLOR]
        [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$loten[/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= #0000BB]$bubbel_query[/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= #0000BB]$reset[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]() +[/COLOR] [COLOR= #0000BB]$time[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$lid_eraf[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$loten[/COLOR] [COLOR= #007700]*[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]waarde[/COLOR][COLOR= #007700]]);[/COLOR]
            [COLOR= #0000BB]$pot_erbij[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$lid_eraf[/COLOR] [COLOR= #007700]*[/COLOR] [COLOR= #0000BB]0.9[/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]$lid_eraf[/COLOR][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]
            [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE settings SET waarde="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$reset[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" WHERE naam=reset"[/COLOR][COLOR= #007700]);[/COLOR]
            [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE settings SET waarde=waarde+"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$pot_erbij[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" WHERE naam=pot"[/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= #0000BB]$erbij[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$erbie[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]waarde[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]){[/COLOR]
                [COLOR= #0000BB]$erbij[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"en"[/COLOR][COLOR= #007700];
            }[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$loten[/COLOR] [COLOR= #007700]!=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]){[/COLOR]
                [COLOR= #0000BB]$erbie[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"s"[/COLOR][COLOR= #007700];
            }[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<b>Je hebt "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$loten[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" bubbeltje"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$erbie[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" geplaatst van "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]waarde[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" punt"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$erbij[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]".</b><br/>"[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$bubbeel_q[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM bubbles ORDER BY id ASC LIMIT 20"[/COLOR][COLOR= #007700]);[/COLOR]
            [COLOR= #0000BB]$pot[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$pot[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]$pot_erbij[/COLOR][COLOR= #007700];[/COLOR]
            [COLOR= #0000BB]$stop[/COLOR] [COLOR= #007700]=[/COLOR] false[COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bubbeel_f[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bubbeel_q[/COLOR][COLOR= #007700])){[/COLOR]
                [URL="http://www.php.net/if"]if[/URL][COLOR= #007700](![/COLOR][COLOR= #0000BB]$stop[/COLOR][COLOR= #007700]){[/COLOR]
                    [COLOR= #0000BB]$waarde_125[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$bubbeel_f[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]waarde[/COLOR][COLOR= #007700]] *[/COLOR] [COLOR= #0000BB]1.25[/COLOR][COLOR= #007700];[/COLOR]
                    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$pot[/COLOR] [COLOR= #007700]>[/COLOR] [COLOR= #0000BB]$waarde_125[/COLOR][COLOR= #007700]){[/COLOR]
                        [COLOR= #0000BB]$pot[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$pot[/COLOR] [COLOR= #007700]-[/COLOR] [COLOR= #0000BB]$waarde_125[/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]$waarde_125[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" WHERE id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bubbeel_f[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]user_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 settings SET waarde=waarde-"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$waarde_125[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" WHERE naam=pot"[/COLOR][COLOR= #007700]);[/COLOR]
                        [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"DELETE FROM bubbles WHERE id="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bubbeel_f[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);
                    }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
                        [COLOR= #0000BB]$stop[/COLOR] [COLOR= #007700]=[/COLOR] true[COLOR= #007700];
                    }
                }
            }
        }[/COLOR] [URL="http://www.php.net/else"]else[/URL] [COLOR= #007700]{[/COLOR]
            [COLOR= #0000BB]$erbij[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
            [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]waarde[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700]){[/COLOR]
                [COLOR= #0000BB]$erbij[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"en"[/COLOR][COLOR= #007700];
            }[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<b>Niet genoeg punten voor bubbeltjes van "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]waarde[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]" punt"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$erbij[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]".</b><br/>"[/COLOR][COLOR= #007700];
        }
    }
}[/COLOR]
?>
<form method="post" action="">
<b>Waarde:</b><select name="waarde">[COLOR= #0000BB]<?[/COLOR] [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]=[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]<[/COLOR] [URL="http://www.php.net/count"]count[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$waardes[/COLOR][COLOR= #007700]);[/COLOR] [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++){[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<option value="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$waardes[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$waardes[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</option>"[/COLOR][COLOR= #007700]; }[/COLOR] ?></select><br />
<b>Aantal : </b><select name="aantal">[COLOR= #0000BB]<?[/COLOR] [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]=[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]<[/COLOR] [URL="http://www.php.net/count"]count[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$aantallen[/COLOR][COLOR= #007700]);[/COLOR] [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++){[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<option value="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$aantallen[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$aantallen[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</option>"[/COLOR][COLOR= #007700]; }[/COLOR] ?></select><br />
<input type="submit" value="Bubbel!">
</form>
<h3>Bubbeltjes Lijst</h3>
<table border=1>
    <tr>
        <td>#</td>
        <td>Lid nummer</td>
        <td>Waarde</td>
        <td>Uitbetaling</td>
    </tr>
[COLOR= #0000BB]<?
$aantaq[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT count(id) AS aantal FROM `bubbles`"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$aantaq[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$aantal[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aantal[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$tot_pag[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ceil"]ceil[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$aantal[/COLOR] / [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$p_n[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/is_numeric"]is_numeric[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]]) &&[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]] < ([/COLOR][COLOR= #0000BB]$tot_pag[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700])){[/COLOR]
    [COLOR= #0000BB]$p_n[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]];
}[/COLOR]
[COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$p_n[/COLOR] [COLOR= #007700]*[/COLOR] [COLOR= #0000BB]$per_pagina[/COLOR] [COLOR= #007700]-[/COLOR] [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$bubblelijst[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM `bubbles` ORDER BY `id` ASC LIMIT "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$start[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]","[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$per_pagina[/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/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bubbeltje[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$bubblelijst[/COLOR][COLOR= #007700])){[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"	<tr>
		<td>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bubbeltje[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</td>
		<td>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bubbeltje[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]user_id[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</td>
		<td>"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bubbeltje[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]waarde[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</td>
		<td>"[/COLOR][COLOR= #007700].([/COLOR][COLOR= #0000BB]$bubbeltje[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]waarde[/COLOR][COLOR= #007700]] *[/COLOR] [COLOR= #0000BB]1.25[/COLOR][COLOR= #007700]).[/COLOR][COLOR= #DD0000]"</td>
	</tr>"[/COLOR][COLOR= #007700];
}[/COLOR]
?>
</table>
[COLOR= #0000BB]<?[/COLOR]
[URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]=[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]<[/COLOR] [COLOR= #0000BB]$tot_pag[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++){[/COLOR]
    [COLOR= #0000BB]$d[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$d[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$p_n[/COLOR][COLOR= #007700]){[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #0000BB]$d[/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]"<a href="?page="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$d[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$d[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</a>"[/COLOR][COLOR= #007700];
    }[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$d[/COLOR] [COLOR= #007700]!=[/COLOR] [COLOR= #0000BB]$tot_pag[/COLOR][COLOR= #007700]){[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]" - "[/COLOR][COLOR= #007700];
    }
}[/COLOR]
?><br/>
0
Moerbeke

Lid · Topicstarter

Berichten
837
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
niemand
0
Jort

Lid

Berichten
524
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Staan de namen van de leden in de zelfde tabel?
0
Moerbeke

Lid · Topicstarter

Berichten
837
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
? Sql ?
0
Jort

Lid

Berichten
524
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Moerbeke schreef:
? Sql ?
Ja,
0
Moerbeke

Lid · Topicstarter

Berichten
837
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
weet ik nie juist nicopara heeft dat gedaan . Kan nu niet werken
0
Jort

Lid

Berichten
524
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Moerbeke schreef:
weet ik nie juist nicopara heeft dat gedaan . Kan nu niet werken
Ik wil je wel even helpen. Maar zit in de tabel van de leden ook de naam van een lid?

(geef anders de leden tabel even)
0
Nicopara

Lid

Berichten
3.052
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Jortttt, zie PM wink
0
Moerbeke

Lid · Topicstarter

Berichten
837
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
iemand anders die ons wil helpen?

mvg
0
Lennard

Lid

Berichten
35.796
Reputatie
1
Punten
0,00
Lid sinds
Laatst gezien
Als je die query op regel 146 verandert in dit:
SELECT bubbles.*, l.username FROM bubbles, users l WHERE l.id = bubbles.userid ORDER BY b.id ASC LIMIT ".$start.",".$per_pagina
dan moet t werken denk..

Je kunt hem dan gebruiken met key username.
0
Moerbeke

Lid · Topicstarter

Berichten
837
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
we gaan eens testen
0
Nicopara

Lid

Berichten
3.052
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Lukt niet sadley
Parse error: syntax error, unexpected T_STRING in /home/nicopara/domains/np-hosting.free.futureweb.be/public_html/dutchklik/bubbletest.php on line 146
0
Lennard

Lid

Berichten
35.796
Reputatie
1
Punten
0,00
Lid sinds
Laatst gezien
Post regel 130 t/m 150 eens.
0
Nicopara

Lid

Berichten
3.052
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
<form method="post" action="">
<b>Waarde:</b><select name="waarde">[COLOR= #0000BB]<?[/COLOR] [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]=[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]<[/COLOR] [URL="http://www.php.net/count"]count[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$waardes[/COLOR][COLOR= #007700]);[/COLOR] [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++){[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<option value="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$waardes[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$waardes[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</option>"[/COLOR][COLOR= #007700]; }[/COLOR] ?></select><br />
<b>Aantal : </b><select name="aantal">[COLOR= #0000BB]<?[/COLOR] [URL="http://www.php.net/for"]for[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]=[/COLOR][COLOR= #0000BB]0[/COLOR][COLOR= #007700];[/COLOR] [COLOR= #0000BB]$i[/COLOR] [COLOR= #007700]<[/COLOR] [URL="http://www.php.net/count"]count[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$aantallen[/COLOR][COLOR= #007700]);[/COLOR] [COLOR= #0000BB]$i[/COLOR][COLOR= #007700]++){[/COLOR] [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"<option value="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$aantallen[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$aantallen[/COLOR][COLOR= #007700][[/COLOR][COLOR= #0000BB]$i[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]"</option>"[/COLOR][COLOR= #007700]; }[/COLOR] ?></select><br />
<input type="submit" value="Bubbel!">
</form>
<h3>Bubbeltjes Lijst</h3>
<table border=1>
    <tr>
        <td>#</td>
        <td>Lid nummer</td>
        <td>Waarde</td>
        <td>Uitbetaling</td>
    </tr>
[COLOR= #0000BB]<?
$aantaq[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT count(id) AS aantal FROM `bubbles`"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$aantaq[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$aantal[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$aantal[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aantal[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$tot_pag[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/ceil"]ceil[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$aantal[/COLOR] / [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$p_n[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700];[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/is_numeric"]is_numeric[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]]) &&[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]] < ([/COLOR][COLOR= #0000BB]$tot_pag[/COLOR] [COLOR= #007700]+[/COLOR] [COLOR= #0000BB]1[/COLOR][COLOR= #007700])){[/COLOR]
    [COLOR= #0000BB]$p_n[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]page[/COLOR][COLOR= #007700]];
}[/COLOR]
[COLOR= #0000BB]$start[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$p_n[/COLOR] [COLOR= #007700]*[/COLOR] [COLOR= #0000BB]$per_pagina[/COLOR] [COLOR= #007700]-[/COLOR] [COLOR= #0000BB]$per_pagina[/COLOR][COLOR= #007700];[/COLOR]
SELECT bubbles[COLOR= #007700].*,[/COLOR] l[COLOR= #007700].[/COLOR]username FROM bubbles[COLOR= #007700],[/COLOR] users l WHERE l[COLOR= #007700].[/COLOR]id [COLOR= #007700]=[/COLOR] bubbles[COLOR= #007700].[/COLOR]userid ORDER BY b[COLOR= #007700].[/COLOR]id ASC LIMIT [COLOR= #DD0000]".$start."[/COLOR][COLOR= #007700],[/COLOR][COLOR= #DD0000]".$per_pagina
while($bubbeltje = mysql_fetch_assoc($bubblelijst)){
    echo "[/COLOR]t[COLOR= #007700]<[/COLOR]tr[COLOR= #007700]>[/COLOR]
tt[COLOR= #007700]<[/COLOR]td[COLOR= #007700]>[/COLOR][COLOR= #DD0000]".$bubbeltje[id]."[/COLOR][COLOR= #007700]<[/COLOR]/td[COLOR= #007700]>[/COLOR]
tt[COLOR= #007700]<[/COLOR]td[COLOR= #007700]>[/COLOR][COLOR= #DD0000]".$bubbeltje[user_id]."[/COLOR][COLOR= #007700]<[/COLOR]/td[COLOR= #007700]>[/COLOR]
tt[COLOR= #007700]<[/COLOR]td[COLOR= #007700]>[/COLOR][COLOR= #DD0000]".$bubbeltje[waarde]."[/COLOR][COLOR= #007700]<[/COLOR]/td[COLOR= #007700]>[/COLOR]
tt[COLOR= #007700]<[/COLOR]td[COLOR= #007700]>[/COLOR][COLOR= #DD0000]".($bubbeltje[waarde] * 1.25)."[/COLOR][COLOR= #007700]<[/COLOR]/td[COLOR= #007700]>[/COLOR]
t[COLOR= #007700]<[/COLOR]/tr[COLOR= #007700]>[/COLOR][COLOR= #DD0000]";
}
?>
</table>
<?
for($i=0; $i < $tot_pag; $i++){
    $d = $i + 1;
    if($d == $p_n){
        echo $d;
    } else {
        echo "[/COLOR][COLOR= #007700]<[/COLOR]a href[COLOR= #007700]=[/COLOR][COLOR= #DD0000]"?page="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$d[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"">"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$d[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]"</a>"[/COLOR][COLOR= #007700];
    }[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$d[/COLOR] [COLOR= #007700]!=[/COLOR] [COLOR= #0000BB]$tot_pag[/COLOR][COLOR= #007700]){[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]" - "[/COLOR][COLOR= #007700];
    }
}[/COLOR]
?><br/>


Is wat teveel, maar ik zie de regelnummers niet op mijn host.
0
Moerbeke

Lid · Topicstarter

Berichten
837
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
is maar tot 47 ;s nico
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