PHP
<?
$familie1 = mysql_query("SELECT * FROM `families` WHERE `naam`='$data->familie'");
$familie = mysql_fetch_object($familie1);
$leden1 = mysql_query("SELECT * FROM `users` WHERE `familie`='$familie->naam'");
$leden = mysql_num_rows($leden1);
if(isset($_POST['submitrang'])){
if($_POST['rang'] == 4){
$user1 = mysql_query("SELECT * FROM `users` WHERE `login`='{$_POST['login']}'");
$user = mysql_fetch_object($user1);
mysql_query("UPDATE `families` SET `power`=`power`-'$user->power' WHERE `naam`='$user->familie'");
mysql_query("UPDATE `users` SET `famlevel`='0',`familie`='' WHERE `login`='{$_POST['login']}'");
}
else{
mysql_query("UPDATE `users` SET `famlevel`='{$_POST['rang']}' WHERE `login`='{$_POST['login']}'");
}}
if($_POST['item'] > 0){
if($_POST['number'] == "" || $_POST['number'] == 0){
$error = 1;
}}
if($_POST['item'] == 1){
if($familie->contant >= 10000*$_POST['number']){
$ledenerbij = 5*$_POST['number'];
$gelderaf = 10000*$_POST['number'];
mysql_query("UPDATE `families` SET `maxleden`=`maxleden`+'$ledenerbij',`contant`=`contant`-'$gelderaf' WHERE `naam`='$familie->naam'");
}
else{
$error = 2;
}
}
if($_POST['item'] == 3){
if($familie->contant >= 60000*$_POST['number']){
$powererbij = 720*$_POST['number'];
$gelderaf = 60000*$_POST['number'];
if($leden > 1){
mysql_query("UPDATE `families` SET `dcb`=`dcb`+'{$_POST['number']}', `power`=`power`+'$powererbij',`contant`=`contant`-'$gelderaf' WHERE `naam`='$familie->naam'");
}
else{
$error = 3;
}
}
else{
$error = 2;
}
}
if($_POST['item'] == 2){
if($familie->contant >= 100000*$_POST['number']){
$powererbij = 10*$_POST['number'];
$leden1 = mysql_query("SELECT * FROM `users` WHERE `familie`='$familie->naam'");
$leden = mysql_num_rows($leden1);
$fampowererbij = $powererbij*$leden;
$gelderaf = 100000*$_POST['number'];
mysql_query("UPDATE `families` SET `fampower`=`fampower`+'{$_POST['number']}', `contant`=`contant`-'$gelderaf',`power`=`power`+'$fampowererbij' WHERE `naam`='$familie->naam'");
mysql_query("UPDATE `users` SET `power`=`power`+'$powererbij' WHERE `familie`='$familie->naam'");
}
else{
$error = 2;
}
}
if($_POST['item'] == 4){
if($familie->contant >= 150000*$_POST['number']){
$powererbij = 1800*$_POST['number'];
$gelderaf = 150000*$_POST['number'];
if($leden > 2){
mysql_query("UPDATE `families` SET `rocketlauncher`=`rocketlauncher`+'{$_POST['number']}', `power`=`power`+'$powererbij',`contant`=`contant`-'$gelderaf' WHERE `naam`='$familie->naam'");
}
else{
$error = 3;
}
}
else{
$error = 2;
}
}
if($_POST['item'] == 5){
if($familie->contant >= 180000*$_POST['number']){
$powererbij = 2160*$_POST['number'];
$gelderaf = 180000*$_POST['number'];
if($leden > 4){
mysql_query("UPDATE `families` SET `tank`=`tank`+'{$_POST['number']}', `power`=`power`+'$powererbij',`contant`=`contant`-'$gelderaf' WHERE `naam`='$familie->naam'");
}
else{
$error = 3;
}
}
else{
$error = 2;
}
}
if($_POST['item'] == 6){
if($familie->contant >= 320000*$_POST['number']){
$powererbij = 4160*$_POST['number'];
$gelderaf = 320000*$_POST['number'];
if($leden > 5){
mysql_query("UPDATE `families` SET `helicopter`=`helicopter`+'{$_POST['number']}', `power`=`power`+'$powererbij',`contant`=`contant`-'$gelderaf' WHERE `naam`='$familie->naam'");
}
else{
$error = 3;
}
}
else{
$error = 2;
}
}
if($_POST['item'] == 7){
if($familie->contant >= 550000*$_POST['number']){
$powererbij = 8250*$_POST['number'];
$gelderaf = 550000*$_POST['number'];
if($leden > 7){
mysql_query("UPDATE `families` SET `gevechtsvliegtuig`=`gevechtsvliegtuig`+'{$_POST['number']}', `power`=`power`+'$powererbij',`contant`=`contant`-'$gelderaf' WHERE `naam`='$familie->naam'");
}
else{
$error = 3;
}
}
else{
$error = 2;
}
}
if($_POST['item'] == 8){
if($familie->contant >= 1000000*$_POST['number']){
$powererbij = 18000*$_POST['number'];
$gelderaf = 1000000*$_POST['number'];
if($leden > 29){
mysql_query("UPDATE `families` SET `battleship`=`battleship`+'{$_POST['number']}', `power`=`power`+'$powererbij',`contant`=`contant`-'$gelderaf' WHERE `naam`='$familie->naam'");
}
else{
$error = 3;
}
}
else{
$error = 2;
}
}
if($_POST['item'] == 9){
if($familie->contant >= 5000000*$_POST['number']){
$powererbij = 100000*$_POST['number'];
$gelderaf = 5000000*$_POST['number'];
if($leden > 49){
mysql_query("UPDATE `families` SET `vliegdekschip`=`vliegdekschip`+'{$_POST['number']}', `power`=`power`+'$powererbij',`contant`=`contant`-'$gelderaf' WHERE `naam`='$familie->naam'");
}
else{
$error = 3;
}
}
else{
$error = 2;
}
}
if(isset($_POST['personal'])){
mysql_query("UPDATE `families` SET `info`='{$_POST['personal']}' WHERE `naam`='$familie->naam'");
}
?>
<div class="title_bg">
<div class="title"><?if($_GET['x'] != ""){echo$_GET['x'];}else{echo"Familiebeheer";}?></div>
</div>
<div style="background-color:#dbd2b7; padding:10px; padding-top:4px;">
<table cellpadding="0" cellspacing="0" width="100%"><tr><td>
<table width="100%" class="mod_list" cellspacing="2" cellpadding="2">
<div style="background-color:#dbd2b7; ">
<br>
<table cellpadding="4" cellspacing="0" width="100%" align="center"><tr><td>
<?
if($_GET['x'] == ""){
if($data->famlevel > 0){
?>
Opties:<BR><BR><BR>
>> <a href="index.php?a=familiebeheer&x=Bank">Bank</a><BR>
>> <a href="index.php?a=familiebeheer&x=Doneer">Doneren</a><BR>
>> <a href="index.php?a=familiebeheer&x=Aannemen">Leden aannemen</a><BR>
>> <a href="index.php?a=familiebeheer&x=Verwijderen">Leden verwijderen/rang veranderen</a><BR>
>> <a href="index.php?a=familiebeheer&x=Shop">Shop</a><BR>
>> <a href="index.php?a=familiebeheer&x=Profiel">Profiel aanpassen</a>
<?}}
if($_GET['x'] == Profiel){
if($data->famlevel > 0){
if(isset($_POST['personal'])){
echo "<FONT color=green><b><BR>Profiel aangepast!</b></FONT><BR>";
}
?>
<form method="POST">
<table width="90%">
<tr>
<td>
LET OP: Codes gaan in UBB! Hierbij kun je denken aan [img] of [url] tags!<BR><BR>
<textarea name="personal" id="profile" rows="15" style="width:100%"><?if(!isset($_POST['personal'])){echo $familie->info;}else{echo $_POST['personal'];}?></textarea>
</td>
</tr>
<tr>
<td>
<input type="submit" class="mod_submit" value="Opslaan">
</td>
</tr>
</table>
</form>
<?}}
if($_GET['x'] == Shop){
if($data->famlevel > 0){
if($error == 1){
echo "<b><FONT color=red>Je moet een geldig aantal invoeren! </FONT></b><BR>";
}
if($error == 2){
echo "<b><FONT color=red>Je hebt niet genoeg geld! </FONT></b><BR>";
}
if($error == 3){
echo "<b><FONT color=red>Je hebt niet genoeg leden! </FONT></b><BR>";
}
if($_POST['item'] > 0){
if($error == ""){
echo "<b><FONT color=green>Aankoop geslaagd. </FONT></b><BR>";
}
}
?>
<table width=100% cellspacing="2px" cellpadding="2px" class="mod_list">
<form method="POST">
<input type="hidden" name="item" value="1">
<tr>
<td colspan=3 style="font-size:14px; font-weight:bold; color:#402810; padding-left:8px;">Clubhuis</td>
</tr>
<tr>
<td rowspan=6 width="110px" height="110px" valign="middle" align="center">
<img src="images/shop/family/familie_villa.gif">
</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/money.gif"></td>
<td>Prijs: <b>€10.000</b></td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/lightning.gif"></td>
<td>Power: <b>0</b></td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/wand.gif"></td>
<td valign="middle"><form method="post" style="display: inline;">Aantal: <input type="text" name="number" class="input" size="5"> <input type="submit" value="Kopen!" class="mod_submit"></form></td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/information.gif"></td>
<td>Koop ruimte voor 5 extra leden in je familie.</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/asterisk_orange.gif"></td>
<td valign="middle" >
De familie heeft er <b><?
$clubhuis = $familie->maxleden/5-1;
echo$clubhuis;?></b> in zijn bezit. </td>
</tr>
</form>
</table>
<br>
<table width=100% cellspacing="2px" cellpadding="2px" class="mod_list">
<form method="POST">
<input type="hidden" name="item" value="3">
<tr>
<td colspan=3 style="font-size:14px; font-weight:bold; color:#402810; padding-left:8px;">Daisy cutter bom</td>
</tr>
<tr>
<td rowspan=6 width="110px" height="110px" valign="middle" align="center">
<img src="images/shop/family/familie_daisycutter.gif">
</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/money.gif"></td>
<td>Prijs: <b>€60.000</b></td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/lightning.gif"></td>
<td>Power: <b>720</b></td>
</tr>
<?if($leden >= 2){?>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/wand.gif"></td>
<td valign="middle"><form method="post" style="display: inline;">Aantal: <input type="text" name="number" class="input" size="5"> <input type="submit" value="Kopen!" class="mod_submit"></form></td>
</tr><?}?>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/information.gif"></td>
<td>Opmerkingen: om dit wapen te kopen heb je minimaal 2 leden in je familie nodig!</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/asterisk_orange.gif"></td>
<td valign="middle" >
De familie heeft er <b><?echo$familie->dcb;?></b> in zijn bezit. </td>
</tr>
</form>
</table>
<br>
<table width=100% cellspacing="2px" cellpadding="2px" class="mod_list">
<form method="POST">
<input type="hidden" name="item" value="2">
<tr>
<td colspan=3 style="font-size:14px; font-weight:bold; color:#402810; padding-left:8px;">Familie power</td>
</tr>
<tr>
<td rowspan=6 width="110px" height="110px" valign="middle" align="center">
<img src="images/shop/family/familie_power.gif">
</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/money.gif"></td>
<td>Prijs: <b>€100.000</b></td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/lightning.gif"></td>
<td>Power: <b>0</b></td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/wand.gif"></td>
<td valign="middle"><form method="post" style="display: inline;">Aantal: <input type="text" name="number" class="input" size="5"> <input type="submit" value="Kopen!" class="mod_submit"></form></td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/information.gif"></td>
<td>Koop voor elk familielid 10 extra power!</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/asterisk_orange.gif"></td>
<td valign="middle" >
De familie heeft er <b><?echo$familie->fampower;?></b> in zijn bezit. </td>
</tr>
</form>
</table>
<br>
<table width=100% cellspacing="2px" cellpadding="2px" class="mod_list">
<form method="POST">
<input type="hidden" name="item" value="4">
<tr>
<td colspan=3 style="font-size:14px; font-weight:bold; color:#402810; padding-left:8px;">Rocket launcher</td>
</tr>
<tr>
<td rowspan=6 width="110px" height="110px" valign="middle" align="center">
<img src="images/shop/family/familie_rocketlauncher.gif">
</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/money.gif"></td>
<td>Prijs: <b>€150.000</b></td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/lightning.gif"></td>
<td>Power: <b>1.800</b></td>
</tr>
<?if($leden >= 3){?>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/wand.gif"></td>
<td valign="middle"><form method="post" style="display: inline;">Aantal: <input type="text" name="number" class="input" size="5"> <input type="submit" value="Kopen!" class="mod_submit"></form></td>
</tr><?}?>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/information.gif"></td>
<td>Opmerkingen: om dit wapen te kopen heb je minimaal 3 leden in je familie nodig!</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/asterisk_orange.gif"></td>
<td valign="middle" >
De familie heeft er <b><?echo$familie->rocketlauncher;?></b> in zijn bezit. </td>
</tr>
</form>
</table>
<br>
<table width=100% cellspacing="2px" cellpadding="2px" class="mod_list">
<form method="POST">
<input type="hidden" name="item" value="5">
<tr>
<td colspan=3 style="font-size:14px; font-weight:bold; color:#402810; padding-left:8px;">Tank</td>
</tr>
<tr>
<td rowspan=6 width="110px" height="110px" valign="middle" align="center">
<img src="images/shop/family/familie_tank.gif">
</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/money.gif"></td>
<td>Prijs: <b>€180.000</b></td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/lightning.gif"></td>
<td>Power: <b>2.160</b></td>
</tr>
<?if($leden >= 5){?>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/wand.gif"></td>
<td valign="middle"><form method="post" style="display: inline;">Aantal: <input type="text" name="number" class="input" size="5"> <input type="submit" value="Kopen!" class="mod_submit"></form></td>
</tr><?}?>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/information.gif"></td>
<td>Opmerkingen: om dit wapen te kopen heb je minimaal 5 leden in je familie nodig!</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/asterisk_orange.gif"></td>
<td valign="middle" >
De familie heeft er <b><?echo$familie->tank;?></b> in zijn bezit. </td>
</tr>
</form>
</table>
<br>
<table width=100% cellspacing="2px" cellpadding="2px" class="mod_list">
<form method="POST">
<input type="hidden" name="item" value="6">
<tr>
<td colspan=3 style="font-size:14px; font-weight:bold; color:#402810; padding-left:8px;">Helicopter</td>
</tr>
<tr>
<td rowspan=6 width="110px" height="110px" valign="middle" align="center">
<img src="images/shop/family/familie_helicopter.gif">
</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/money.gif"></td>
<td>Prijs: <b>€320.000</b></td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/lightning.gif"></td>
<td>Power: <b>4.160</b></td>
</tr>
<?if($leden >= 6){?>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/wand.gif"></td>
<td valign="middle"><form method="post" style="display: inline;">Aantal: <input type="text" name="number" class="input" size="5"> <input type="submit" value="Kopen!" class="mod_submit"></form></td>
</tr><?}?>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/information.gif"></td>
<td>Opmerkingen: om dit wapen te kopen heb je minimaal 6 leden in je familie nodig!</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/asterisk_orange.gif"></td>
<td valign="middle" >
De familie heeft er <b><?echo$familie->helicopter;?></b> in zijn bezit. </td>
</tr>
</form>
</table>
<br>
<table width=100% cellspacing="2px" cellpadding="2px" class="mod_list">
<form method="POST">
<input type="hidden" name="item" value="7">
<tr>
<td colspan=3 style="font-size:14px; font-weight:bold; color:#402810; padding-left:8px;">Gevechtsvliegtuig</td>
</tr>
<tr>
<td rowspan=6 width="110px" height="110px" valign="middle" align="center">
<img src="images/shop/family/familie_vliegtuig.gif">
</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/money.gif"></td>
<td>Prijs: <b>€550.000</b></td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/lightning.gif"></td>
<td>Power: <b>8.250</b></td>
</tr>
<?if($leden >= 8){?>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/wand.gif"></td>
<td valign="middle"><form method="post" style="display: inline;">Aantal: <input type="text" name="number" class="input" size="5"> <input type="submit" value="Kopen!" class="mod_submit"></form></td>
</tr><?}?>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/information.gif"></td>
<td>Opmerkingen: om dit wapen te kopen heb je minimaal 8 leden in je familie nodig!</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/asterisk_orange.gif"></td>
<td valign="middle" >
De familie heeft er <b><?echo$familie->gevechtsvliegtuig;?></b> in zijn bezit. </td>
</tr>
</form>
</table>
<br>
<table width=100% cellspacing="2px" cellpadding="2px" class="mod_list">
<form method="POST">
<input type="hidden" name="item" value="8">
<tr>
<td colspan=3 style="font-size:14px; font-weight:bold; color:#402810; padding-left:8px;">Battleship</td>
</tr>
<tr>
<td rowspan=6 width="110px" height="110px" valign="middle" align="center">
<img src="images/shop/family/familie_battleship.gif">
</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/money.gif"></td>
<td>Prijs: <b>€1.000.000</b></td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/lightning.gif"></td>
<td>Power: <b>18.000</b></td>
</tr>
<?if($leden >= 30){?>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/wand.gif"></td>
<td valign="middle"><form method="post" style="display: inline;">Aantal: <input type="text" name="number" class="input" size="5"> <input type="submit" value="Kopen!" class="mod_submit"></form></td>
</tr><?}?>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/information.gif"></td>
<td>Opmerkingen: om dit wapen te kopen heb je minimaal 30 leden in je familie nodig!</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/asterisk_orange.gif"></td>
<td valign="middle" >
De familie heeft er <b><?echo$familie->battleship;?></b> in zijn bezit. </td>
</tr>
</form>
</table>
<br>
<table width=100% cellspacing="2px" cellpadding="2px" class="mod_list">
<form method="POST">
<input type="hidden" name="item" value="9">
<tr>
<td colspan=3 style="font-size:14px; font-weight:bold; color:#402810; padding-left:8px;">Vliegdekschip</td>
</tr>
<tr>
<td rowspan=6 width="110px" height="110px" valign="middle" align="center">
<img src="images/shop/family/familie_vliegdekschip.gif">
</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/money.gif"></td>
<td>Prijs: <b>€5.000.000</b></td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/lightning.gif"></td>
<td>Power: <b>100.000</b></td>
</tr>
<?if($leden >= 50){?>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/wand.gif"></td>
<td valign="middle"><form method="post" style="display: inline;">Aantal: <input type="text" name="number" class="input" size="5"> <input type="submit" value="Kopen!" class="mod_submit"></form></td>
</tr><?}?>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/information.gif"></td>
<td>Opmerkingen: om dit wapen te kopen heb je minimaal 50 leden in je familie nodig!</td>
</tr>
<tr>
<td width="18px" align="center" valign="middle"><img src="images/icons_gif/asterisk_orange.gif"></td>
<td valign="middle" >
De familie heeft er <b><?echo$familie->vliegdekschip;?></b> in zijn bezit. </td>
</tr>
</form>
</table><br>
<?
}}
if($_GET['x'] == Verwijderen){
if($data->famlevel > 0){
?>
<BR>
<?
$dbres = mysql_query("SELECT * FROM `users` WHERE `familie`='$familie->naam' AND `famlevel`>'-1'");
for($j=0+1; $info = mysql_fetch_object($dbres); $j++){
if($info->login != $familie->owner){
?>
<form method="POST">
<a href="index.php?a=profile&x=<?echo$info->id?>"><?echo$info->login?></a> -
<input type="radio" name="login" value="<?echo$info->login;?>">
<select name="rang">
<option value="0"<?if($info->famlevel == 0){?> selected<?}?>>Familie lid</option>
<option value="1"<?if($info->famlevel == 1){?> selected<?}?>>Sottocapo</option>
<option value="2"<?if($info->famlevel == 2){?> selected<?}?>>Consligliere</option>
<option value="3"<?if($info->famlevel == 3){?> selected<?}?>>Don</option>
<option value="4" >Verwijderen</option>
</select>
<BR><BR>
<?}}}?>
<input type="submit" class="mod_submit" value="Uitvoeren" name="submitrang">
</form>
<?}
if($familie->maxleden-$leden > 0){
if($_GET['x'] == Aannemen){
if($data->famlevel > 0){
if(isset($_GET['refuse'])){
$user1 = mysql_query("SELECT * FROM `users` WHERE `id`='{$_GET['refuse']}'");
$user = mysql_fetch_object($user1);
if($user->familie == $familie->naam && $user->famlevel < 0){
echo "Je hebt $user->login afgewezen!<BR>";
}
else{
echo "$user->login wil geen lid worden van $familie->naam!<BR>";
}}
if(isset($_GET['accept'])){
$user1 = mysql_query("SELECT * FROM `users` WHERE `id`='{$_GET['accept']}'");
$user = mysql_fetch_object($user1);
if($user->familie == $familie->naam && $user->famlevel < 0){
echo "Je hebt $user->login aangenomen!<BR>";
}
else{
echo "$user->login wil geen lid worden van $familie->naam!<BR>";
}}
if(isset($_GET['refuse'])){
$user1 = mysql_query("SELECT * FROM `users` WHERE `id`='{$_GET['refuse']}'");
$user = mysql_fetch_object($user1);
if($user->familie == $familie->naam && $user->famlevel < 0){
mysql_query("UPDATE `users` SET `famlevel`='0',`familie`='' WHERE `id`='$user->id'");
}}
if(isset($_GET['accept'])){
$user1 = mysql_query("SELECT * FROM `users` WHERE `id`='{$_GET['accept']}'");
$user = mysql_fetch_object($user1);
if($user->familie == $familie->naam && $user->famlevel < 0){
mysql_query("UPDATE `users` SET `famlevel`='0' WHERE `id`='$user->id'");
mysql_query("UPDATE `families` SET `power`=`power`+'$user->power' WHERE `naam`='$familie->naam'");
}}
$dbres = mysql_query("SELECT * FROM `users` WHERE `familie`='$familie->naam' AND `famlevel`='-1' ORDER BY `login`");
$count = mysql_num_rows($dbres);
if($count == 0){
echo "<i>Er zijn geen leden die lid willen worden van $familie->naam.</i>";
}
for($j=0+1; $info = mysql_fetch_object($dbres); $j++){
?>
<a href="index.php?a=profile&x=<?echo$info->id?>"><?echo$info->login?></a> - <a href="index.php?a=familiebeheer&x=Aannemen&accept=<?echo$info->id?>">Aannemen</a>/<a href="index.php?a=familiebeheer&x=Aannemen&refuse=<?echo$info->id?>">Weigeren</a><BR><BR>
<?}}}}
else{
echo "<i>Maximaal aantal leden berijkt!</i>";
}
if($_GET['x'] == Doneer){
$bank = number_format($familie->bank, 0, '.', '.');
$contant = number_format($familie->contant, 0, '.', '.');
if(isset($_POST['doneren']) && preg_match('/^[0-9]+$/',$_POST['doneer'])){
$doneer = $_POST['doneer'];
if($data->contant >= $doneer){
mysql_query("UPDATE `families` SET `bank`=`bank`+'$doneer' WHERE `naam`='$data->familie'");
mysql_query("UPDATE `users` SET `contant`=`contant`-'$doneer' WHERE `id`='$data->id'");
echo "je hebt {$doneer} bedrag overgemaakt naar de familie";
} else { echo "Zoveel geld heb je niet contant!";}
}
?>
<form method="POST">
<tr>
<td>
€ <input type="text" name="doneer" size="25" value="">
</td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" class="mod_submit" value="Doneer!" name="doneren">
</form>
<?}
if($_GET['x'] == Bank){
if($data->famlevel > 0){
if(isset($_POST['submit']) && preg_match('/^[0-9]+$/',$_POST['money1'])) {
if($_POST['submit'] == Halen){
if($_POST['money1'] <= $familie->bank) {
$familie->contant += $_POST['money1'];
$familie->bank -= $_POST['money1'];
mysql_query("UPDATE `families` SET `bank`=`bank`-'{$_POST['money1']}',`contant`=`contant`+'{$_POST['money1']}' WHERE `naam`='$data->familie'");
print "Er is <b>€{$_POST['money1']}</b> afgeschreven van je bankrekening!";
}
else {
print "Zoveel geld staat er niet op de bank";
}
}
}
if(isset($_POST['submit']) && preg_match('/^[0-9]+$/',$_POST['money1'])) {
if($_POST['submit'] == Storten){
if($_POST['money1'] <= $familie->contant) {
if($familie->storten > 0) {
$familie->contant -= $_POST['money1'];
$familie->bank += $_POST['money1'];
mysql_query("UPDATE `families` SET `bank`=`bank`+'{$_POST['money1']}',`contant`=`contant`-'{$_POST['money1']}',`storten`=`storten`'-1' WHERE `naam`='$data->familie'");
print "Er is <b>€{$_POST['money1']}</b> bijgeschreven bij je bankrekening!";
} else { print "Je kan niet meer storten vandaag"; }
} else { print "Zoveel geld heb je niet";}
}
}
$familiecontant = number_format($familie->contant, 0, '.' , '.');
$familiebank = number_format($familie->bank, 0, '.' , '.');?>
<table cellspacing="2" cellpadding="2" class="mod_list">
<tr>
<td width="6%" style="text-align:center;"><img src="images/icons_gif/coins.gif" alt="Geld (contant)" border="0"></td>
<td width="20%">Geld (contant)</td>
<td><b title="Klik hier om dit bedrag in te vullen" style="cursor:pointer" onclick="document.getElementById('money1').value = '<?echo$familiecontant;?>'">€ <?echo$familiecontant;?></td>
</tr>
<tr>
<td width="6%" style="text-align:center;"><img src="images/icons_gif/money.gif" alt="Geld (bank)" border="0"></td>
<td width="20%">Geld (bank)</td>
<td><b title="Klik hier om dit bedrag in te vullen" style="cursor:pointer" onclick="document.getElementById('money1').value = '<?echo$familiebank;?>'">€ <?echo$familiebank;?></td>
</tr>
<tr>
<td width="6%" style="text-align:center;"><img src="images/icons_gif/information.gif" alt="Aantal keer opnemen" border="0"></td>
<td colspan="2">Je kunt vandaag nog <b><?echo$familie->storten;?></b> keer geld storten.</td>
</tr>
<tr>
<td width="6%" style="text-align:center;"><img src="images/icons_gif/money_euro.gif" alt="Geld opnemen of storten" border="0"></td>
<td colspan="2">
<form method="POST">
<input type="text" id="money1" name="money1" maxlength="25" style="width: 200px" class="input">
<input type="submit" name="submit" value="Storten" class="mod_submit">
<input type="submit" name="submit" value="Halen" class="mod_submit">
</td>
</form>
</tr>
</table>
<?}}?>
</table>
</div>
</td></tr></table>
</div>
<table width='100%' cellspacing='2' cellpadding='2'>
<tr>
<td class='content_bottom'></td>
</tr>
</table>
<br> </div>
</td>
</tr>
</table>
</td>Beste CP'ers
ik familie beheer proberen helemaal bugloos te maken voor jullie en voor mezelf maar bij familie shop lukt het me niet om die bug met -9999999 te maken kan iemand aub maken en hem hier posten hier boven is de script voor mensen die hem nu alfast willen gebruiken als jullie meer bugs zien meld het aub
mvg
