Webwereld

Klein stukje inbouwen.

Gestart doorMikeb5 reacties33 weergaven
Log in om mee te praten

6 berichten · pagina 1 van 1

Mikeb

Lid · Topicstarter

Berichten
6.356
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Hallo allemaal,

Ik wil een ifje inbouwen, dat als het adv saldo lager is dan wat er als vergoeding word gegeven, hij op inactief word gezet, zoiets;

$row1 = mysql_query("SELECT saldo FROM users WHERE user = ".$row35[adverteerder]."");
$row2 = mysql_num_rows($row1);
if($row2 < ".$vergoeding."){
$sql = "UPDATE doeadvertenties SET actief=1 WHERE adverteerder=" . $row35[adverteerder] . "";
mysql_query($sql);
}else{
HIER DE REST VAN DE CODE, VOOR HET DOORSTUREN NAAR DE PAGINA VAN DE ADVERTEERDER
}


[COLOR= #0000BB]<?[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]config.php[/COLOR][COLOR= #007700]);[/COLOR]
design_boven[COLOR= #007700]([/COLOR][COLOR= #DD0000]Doe-advertenties[/COLOR][COLOR= #007700]);[/COLOR]
check_login[COLOR= #007700]();[/COLOR]
?>
[COLOR= #0000BB]<?
$user[/COLOR] [COLOR= #007700]=[/COLOR]     [COLOR= #0000BB]$_SESSION[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]user[/COLOR][COLOR= #007700]];[/COLOR]
[COLOR= #0000BB]$id[/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]id[/COLOR][COLOR= #007700]]);[/COLOR]

[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/session_is_registered"]session_is_registered[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]user[/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]$id[/COLOR][COLOR= #007700]))
    {[/COLOR]
        [COLOR= #FF8000]//$sql = mysql_query("SELECT id, adv, link, adverteerder FROM doeadvertenties WHERE id=" . $id . "")or die(mysql_error());
        //$sql = mysql_query("SELECT kliks, email FROM users WHERE user=" . $user . "")or die(mysql_error());[/COLOR]
        [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT a.id, a.adv, a.link, b.kliks, b.email FROM doeadvertenties a, users b WHERE a.id="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$id[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" AND b.user="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$user[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" AND actief=0"[/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]$list[/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][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/COLOR][COLOR= #007700]) ==[/COLOR] [COLOR= #DD0000]"1"[/COLOR] [COLOR= #007700]) 
        {[/COLOR]
[COLOR= #0000BB]$sql35[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT * FROM doeadvertenties WHERE actief=0"[/COLOR][COLOR= #007700];[/COLOR]
                [COLOR= #0000BB]$query35[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql35[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #0000BB]$row35[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query35[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$sql3[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"SELECT * FROM doeadvertenties WHERE adv="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$row35[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]adv[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]" AND actief=0"[/COLOR][COLOR= #007700];[/COLOR]
                [COLOR= #0000BB]$query3[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql3[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #0000BB]$row3[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$query3[/COLOR][COLOR= #007700]);[/COLOR]
                [COLOR= #0000BB]$vergoeding[/COLOR] [COLOR= #007700]= ([/COLOR][COLOR= #0000BB]$row3[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]vergoeding[/COLOR][COLOR= #007700]])*[/COLOR][COLOR= #0000BB]0.1[/COLOR][COLOR= #007700];[/COLOR] 
                [COLOR= #0000BB]$sql[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"UPDATE users SET saldo=saldo-"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$vergoeding[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" WHERE user="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$row35[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]adverteerder[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]""[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$sql[/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 opendoeadvs WHERE user="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$user[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]" AND adv="[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$list[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]adv[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]" AND (keuring=nee OR keuring=ja)"[/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= #DD0000]"0"[/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]"INSERT INTO opendoeadvs(user, adv, ip, datum, keuring, email) VALUES("[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$user[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]","[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$list[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]adv[/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]","[/COLOR][COLOR= #007700].[/COLOR] [URL="http://www.php.net/date"]date[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"d/m/Y"[/COLOR][COLOR= #007700]) .[/COLOR][COLOR= #DD0000]",nee,"[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$list[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]email[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]")"[/COLOR][COLOR= #007700]);[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Je word binnen 5 seconden doorgestuurd naar de adverteerder, doe zorgvuldig de opdrachten!<br>[/COLOR][COLOR= #007700];[/COLOR] 
                [URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][URL="http://www.php.net/strstr"]strstr[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$list[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]link[/COLOR][COLOR= #007700]],[/COLOR] [COLOR= #DD0000]"myaffiliates.nl/"[/COLOR][COLOR= #007700]))
                {[/COLOR]
                    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<meta HTTP-EQUIV="REFRESH" content="5; url=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$list[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]link[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]&epi=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$user[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000]">[/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]<meta HTTP-EQUIV="REFRESH" content="5; url=[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$list[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]link[/COLOR][COLOR= #007700]] .[/COLOR] [COLOR= #DD0000]">[/COLOR][COLOR= #007700];
                }
                
            }[/COLOR]
            [URL="http://www.php.net/else"]else[/URL][COLOR= #FF8000]//Hier onder staat alles wat fout gaat, FOUTGRENS[/COLOR]
            [COLOR= #007700]{[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<meta http-equiv="refresh" content="5;URL=index.php" />[/COLOR][COLOR= #007700];[/COLOR]
                [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je hebt deze advertentie als eens gedaan.<br />Wacht tot deze gekeurd is, of je hebt hem al compleet uitgevoerd."[/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]Doe advertentie bestaat niet[/COLOR][COLOR= #007700]; 
        }
    }[/COLOR]
    [URL="http://www.php.net/else"]else[/URL]
    [COLOR= #007700]{[/COLOR][COLOR= #FF8000]//Geen geldig ?id= opgeven, niet numeriek[/COLOR]
        [URL="http://www.php.net/header"]header[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"index.php"[/COLOR][COLOR= #007700]);[/COLOR]
        [URL="http://www.php.net/exit"]exit[/URL][COLOR= #007700]();
    }
}[/COLOR]
[URL="http://www.php.net/else"]else[/URL][COLOR= #FF8000]//Niet ingelogged[/COLOR]
[COLOR= #007700]{[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<meta http-equiv="refresh" content="5;URL=index.php" />[/COLOR][COLOR= #007700];[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]"Je moet ingelogd zijn om doe advertenties te kunnen doen"[/COLOR][COLOR= #007700];
}[/COLOR]




design_onder[COLOR= #007700]([/COLOR][COLOR= #DD0000]1[/COLOR][COLOR= #007700]);[/COLOR]
?>
0
Alemaalte

Lid

Berichten
5.957
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Leer nou eens eerst php voor je een heel systeem gaat maken.
mysql_num_rows zoek daarvan eens op wat het doet.
0
Josnl

Lid

Berichten
3.461
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Hoezo zou hij dat niet weten Alemaalte...?
0
Alemaalte

Lid

Berichten
5.957
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
$row1 = mysql_query("SELECT saldo FROM users WHERE user = ".$row35[adverteerder]."");
$row2 = mysql_num_rows($row1);
if($row2 < ".$vergoeding."){

Dat slaat nergens op.
0
Mikeb

Lid · Topicstarter

Berichten
6.356
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Ik zeg ook niet dat het klopt. Het is iets in die richting, het is volgens mij trouwens mysql_fetch_assoc.
0
Alemaalte

Lid

Berichten
5.957
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Probeer het eens zelf te vinden...

Indien je dat niet wil doen kan je:
Of naar phphulp.nl gaan of een andere PHP community.
Of het systeem door iemand anders laten maken.
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