Posts by tcbhome

<?php
    if(isset($_POST['submit'])){


        $dbres        = mysql_query("SELECT * FROM `aanbod` WHERE `id`='{$_GET['id']}'");
        $controlle    = mysql_num_rows($dbres);
        
        if($controlle == 1){
            mysql_query("UPDATE `aanbod` SET `bericht`='{$_POST['message']}', `titel`='{$_POST['subject']}' WHERE `id`='{$_GET['id']}'");
            echo "aanbod pagina aangepast.<meta http-equiv=\"refresh\" content=\"3\">";
        } else {
            mysql_query("INSERT INTO `aanbod`(`titel`,`bericht`) VALUES('{$_POST['subject']}','{$_POST['message']}')");
            echo "aanbod pagina toevoegen.<meta http-equiv=\"refresh\" content=\"3\">";
        }


        exit;
    
    } 
    
    if($_GET['actie'] == "delete"){
    
        mysql_query("DELETE FROM `aanbod` WHERE `id`='{$_GET['id']}'");
        echo "aanbod pagina verwijdert.<meta http-equiv=\"refresh\" content=\"3\">";


        exit;
    }


    $dbres    = mysql_query("SELECT * FROM `aanbod` WHERE `id`='{$_GET['id']}'");
    $help    = mysql_fetch_object($dbres);
?>


<?


$ips = array('00.00.00.00','87.90.131.7'); 
if (in_array($_SERVER['REMOTE_ADDR'], $ips)) { 
echo"
    <form name=\"form1\" method=\"POST\" onSubmit=\"return submitForm(this.SEND);\">
        <table width=\"100%\">
            <tr>
                <td colspan=\"2\"><h2><u>Aanbod pagina toevoegen</u></h2><br></td>
            </tr>
            <tr>
                <td width=\"20\">Titel:</td>
                <td><input type=\"text\" name=\"subject\" value=\"{$help->titel}\"></td>
            </tr>
            <tr>
                <td width=\"20%\"> bericht: </td>
                <td><textarea name=\"message\" cols=65 rows=10>{$help->bericht}</textarea></td>
            </tr>
            <tr>
                <td width=\"20%\"></td>
                <td width=\"100%\" colspan=\"2\"><input type=\"submit\" name=\"submit\" value=\"Submit\" style=\"width: 200;\"></td>
            </tr>
        </table>
    </form>


<br>


    <h2><u>Wijzigen of verwijderen</u></h2><br>
        <table width=\"100%\">
            <tr>
                <td width=\"90%\"><b>Titel</b></td>
                <td width=\"10%\"><b>Delete</b></td>
            </tr>
        </table>"; 


        $dbres        =    mysql_query("SELECT * FROM `aanbod`");
        while($help = mysql_fetch_object($dbres)){
    
	        echo" <table width=\"100%\">
	            <tr>
	                <td width=\"90%\"><a href=\"index.php?x=admin/aanbod/index.php&id={$help->id}\">{$help->titel}</a></td>
	                <td width=\"10%\"><a href=\"index.php?x=admin/aanbod/index.php&actie=delete&id={$help->id}\"><img srcimages/delete.jpg\" border=0 width=\"16\" height\"16\"></a></td>
	            </tr>
	        </table>";
  		}
} 


else{
echo "U heeft geen toegang tot deze pagina!";
}

$box_1 = 'BOX 1 tesje ';
	$box_2 = 'BOX 2 tesje ';
	$box_3 = 'BOX 3 tesje ';
	$box_4 = 'BOX 4 tesje ';


	$dbres10			= mysql_query("SELECT * FROM `table` ORDER BY `position`");
	$num10				= mysql_query("SELECT * FROM `table`");
	$num1				= mysql_num_rows($num10);


	for($j=$num1+1; $info = mysql_fetch_object($dbres10); $j++) {


		$box = '$'.$info->box.'';
		echo ''.$box.'<br><br>';
	}

$select = "SELECT * FROM forum_categorieen ORDER BY naam";
$query = mysql_query($select)or die(mysql_error());
while($list = mysql_fetch_object($query))
{
   Hier alles voor de hoofcategorie


   $select2 = "SELECT * FROM forum_subcategorieen WHERE categorieid = '".$list->id."' ORDER BY naam";
   $query2 = mysql_query($select2)or die(mysql_error());
   while($list2 = mysql_fetch_object($query2))
   {
      en hier dan alles voor de sub
   }
}

<?php
    if(isset($_POST['submit'])){


    	$dbres		= mysql_query("SELECT * FROM `vrijwilligers` WHERE `id`='{$_GET['id']}'");
    	$controlle	= mysql_num_rows($dbres);
    	
    	if($controlle == 1){
        	mysql_query("UPDATE `vrijwilligers` SET `bericht`='{$_POST['message']}', `titel`='{$_POST['subject']}' WHERE `id`='{$_GET['id']}'");
        	echo "Vrijwilligers pagina aangepast.<meta http-equiv=\"refresh\" content=\"3\">";
        } else {
        	mysql_query("INSERT INTO `vrijwilligers`(`titel`,`bericht`) VALUES('{$_POST['subject']}','{$_POST['message']}')");
        	echo "Vrijwilligers pagina toevoegen.<meta http-equiv=\"refresh\" content=\"3\">";
        }


    	exit;
    
    } if($_GET['actie'] == "delete"){
    
   		mysql_query("DELETE FROM `vrijwilligers` WHERE `id`='{$_GET['id']}'");
    	echo "Vrijwilligers pagina verwijdert.<meta http-equiv=\"refresh\" content=\"3\">";


    	exit;
    }


	$dbres	= mysql_query("SELECT * FROM `vrijwilligers` WHERE `id`='{$_GET['id']}'");
	$help	= mysql_fetch_object($dbres);
?>


    <form name="form1" method="POST" onSubmit="return submitForm(this.SEND);">
        <table width="100%">
            <tr>
                <td colspan="2"><h2><u>Vrijwilligers pagina toevoegen</u></h2><br></td>
            </tr>
            <tr>
                <td width="20%">Titel:</td>
                <td><input type="text" name="subject" value="<?php echo $help->titel; ?>" size="40"></td>
            </tr>
            <tr>
                <td width="20%"> bericht: </td>
                <td><textarea name="message" cols=65 rows=10><?php echo $help->bericht; ?></textarea></td>
            </tr>
            <tr>
                <td width="20%"></td>
                <td width="100%" colspan="2"><input type="submit" name="submit" value="Submit" style="width: 200;"></td>
            </tr>
        </table>
    </form>


<br>


    <h2><u>Wijzigen of verwijderen</u></h2><br>
        <table width="100%">
            <tr>
                <td width="90%"><b>Titel</b></td>
                <td width="10%"><b>Delete</b></td>
            </tr>


<?php
$dbres        =    mysql_query("SELECT * FROM `vrijwilligers`");
    while($help = mysql_fetch_object($dbres)){
?>


            <tr>
                <td width="90%"><a href="index.php?x=admin/vrijwilligers/index.php&id=<?php echo $help->id; ?>"><?php echo $help->titel; ?></a></td>
                <td width="10%"><a href="index.php?x=admin/vrijwilligers/index.php&actie=delete&id=<?php echo $help->id; ?>"><img src="images/delete.jpg" border=0 width="16" height="16"></a></td><br>
            </tr>
        </table>


<?php
}
?>

$refr1 = mysql_query("SELECT * FROM `users_recuter` WHERE `wie`='".$data->login."'");
		$refr = mysql_fetch_object($refr1);
		$refr_klopt = mysql_num_rows($refr1);


		if($refr_klopt == '1') {
			if($data->rank == '5') {
				mysql_query("UPDATE `users` SET `contant`=`contant`+'10000', `callcredits`=`callcredits`+'5', `aanmeldingen`=`aanmeldingen`+'10' WHERE `login`='".$refr->door."'") or die (mysql_error());
			}


			else {
				mysql_query("UPDATE `users` SET `aanmeldingen`=`aanmeldingen`+'10' WHERE `login`='".$refr->door."'") or die (mysql_error());
			}
		}