Wouters vragentopic [Nieuw2]

ik heb een script met $url1 en $url2
$url1 haalt hij alles sites uit een database, en $url2 is een code

no wil ik via curl ervoor zorgen dat hij naar $url gaat met $url2 erachter
dus stel, in
$url1 :
http://www.site1.com
http://www.site2.com
$url2 :
123zea123

dan wil ik dat hij naar
http://www.site1.com/?user=123zea123
en
http://www.site2.com/?user=123zea123
gaat

$url1 kunnen wel iedere dag nieuwe urls bijkomen...

iemand die mij kan helpen?

Alvast bedankt!

Wouter

Vraag 1

[COLOR= #0000BB]<?php

$bannerid[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/intval"]intval[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]id[/COLOR][COLOR= #007700]]);[/COLOR]
[COLOR= #0000BB]$dealer[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_real_escape_string"]mysql_real_escape_string[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$_GET[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]dealer[/COLOR][COLOR= #007700]]);[/COLOR] 

[COLOR= #0000BB]$ip[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$_SERVER[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]REMOTE_ADDR[/COLOR][COLOR= #007700]];[/COLOR]

[COLOR= #0000BB]$query[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT * FROM klikmissies WHERE id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bannerid[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" AND game="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$dealer[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$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]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$object[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700])){[/COLOR]
    [COLOR= #0000BB]$actief[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$object[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]actief[/COLOR][COLOR= #007700]];[/COLOR]
    [COLOR= #0000BB]$url[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$object[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]url[/COLOR][COLOR= #007700]];[/COLOR]
    [COLOR= #0000BB]$nu[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$object[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]nu[/COLOR][COLOR= #007700]];[/COLOR]
    [COLOR= #0000BB]$opbrengst[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$object[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]opbrengst[/COLOR][COLOR= #007700]];[/COLOR]
    [COLOR= #0000BB]$maximaal[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$object[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]maximaal[/COLOR][COLOR= #007700]];
}[/COLOR]
[URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$actief[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #DD0000]"1"[/COLOR][COLOR= #007700]){[/COLOR] [COLOR= #FF8000]//actiefcontrole[/COLOR]
    [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE `klikmissies` SET nu=nu+1 WHERE `id` = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bannerid[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" AND game="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$dealer[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$nu[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]$maximaal[/COLOR][COLOR= #007700]){[/COLOR] [COLOR= #FF8000]//maximaalcontrole[/COLOR]
        [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"UPDATE `klikmissies` SET actief=0 WHERE `id` = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bannerid[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" AND game="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$dealer[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);
    }[/COLOR]
    [COLOR= #0000BB]$date[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/date"]date[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Ymd"[/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 count(1) FROM kmkliks WHERE user = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$guser[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" AND id = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bannerid[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" AND date = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$date[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" AND game="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$game[/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_result"]mysql_result[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result2[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700]){[/COLOR]
        [COLOR= #FF8000]//als alles klopt[/COLOR]
        [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO kmkliks (id, userid, ip, banner, date, game) VALUES (NULL, "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$guser[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$ip[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$bannerid[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$date[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]", "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$game[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]")"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/print"]print[/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]"UPDATE `deal_leden` SET saldo=saldo+"[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$opbrengst[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" WHERE `user` = "[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$guser[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]" AND game="[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$game[/COLOR][COLOR= #007700].[/COLOR][COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"Je punten zijn bijgeschreven, je wordt nu doorgestuurd!"[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"<meta http-equiv="refresh" content="789456123;URL=$url">"[/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 hebt vandaag al geklikt!"[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL][COLOR= #DD0000]"<meta http-equiv="refresh" content="789456123;URL=$url">"[/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]"Deze klikmissie is niet actief!"[/COLOR][COLOR= #007700];
}[/COLOR]
?>

Waar je $game en $guser vandaan haalt is me een raadsel.

Vraag 2

$query3 = mysql_query("SELECT COUNT(1) FROM `users` where date =".date(Y-m-d)."");
$count_day = mysql_result($query2, 0);

Vraag 3
http://www.one2xs.com/threads/9445

Nieuwe vraag

base64

oke die heeft geholpen, nu heb ik nog een laatste vraagje!

echo $url.?user=.$url2;
?

Nielsie:
echo $url.?user=.$url2;
?

haha nee dan zou hij http://www.site1.com/?user=123aez123 alleen maar tonen, hij moet er echt naartoe gaan

[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/header"]header[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"Location: "[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$url[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]"?user="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$url2[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700]);[/COLOR]
?>