<?
userstatus();
// Variabeln definieren
if (!isset($_POST['refback']))	        $_POST['refback']	= "";
if (!isset($_POST['save']))		$_POST['save']	        = "";
if (!isset($_GET['ruid']))		$_GET['ruid']	        = "";
if (!isset($_GET['reset']))		$_GET['reset']	        = "";
$ebene2 = 0;
$ebene3 = 0;
$_GET['ruid'] = (int)$_GET['ruid'];

if ($_GET['reset'] == 'true') {
db_query("UPDATE ".$db_prefix."_werberdaten SET
                 resetzeit = '".time()."',
                 reset = 0
WHERE uid='".$_GET['ruid']."' and werber='".$_SESSION['uid']."' LIMIT 1");
}

if ($_POST['save'] == 'Save' && $_POST['refback'] >= 0 && $_POST['refback'] <= 100 && !ereg("[^0-9]", $_POST['refback'])) {
db_query("UPDATE ".$db_prefix."_werberdaten SET
                 refback = '".$_POST['refback']."'
WHERE uid='".$_GET['ruid']."' and werber='".$_SESSION['uid']."' LIMIT 1");
}


$ref_check = db_query("SELECT w.uid,w.umsatz,w.reset,w.resetzeit,w.gesamt,w.refback,w.aktivzeit,w.zuordnungszeit,k.loginzeit,u.nickname FROM
                              ".$db_prefix."_werberdaten w
                              LEFT JOIN ".$db_prefix."_kontodaten k ON k.uid = w.uid
                              LEFT JOIN ".$db_prefix."_userdaten u ON u.uid = k.uid
WHERE w.uid=".$_GET['ruid']." and w.werber=".$_SESSION['uid']." LIMIT 1");

if (!mysqli_num_rows($ref_check)) {
@include_once('content/error/kein_ref.php');
@include_once('lib/footer.php');
die();
}

$refuser = mysqli_fetch_assoc($ref_check);

if ($refuser['aktivzeit'] >= (time()-(86400*7))) $refstatus = '<img src="./images/gruen.gif" width="15" height="15" border="0" alt="'.date("d.m.y - H:i",$refuser['aktivzeit']).'" align="absmiddle"> &raquo; User ist aktiv';
if ($refuser['aktivzeit'] < (time()-(86400*7))) $refstatus = '<img src="./images/gelb.gif" width="15" height="15" border="0" alt="'.date("d.m.y - H:i",$refuser['aktivzeit']).'" align="absmiddle"> &raquo; User seit 7 tagen inaktiv';
if ($refuser['aktivzeit'] <= (time()-(86400*30))) $refstatus = '<img src="./images/rot.gif" width="15" height="15" border="0" alt="'.date("d.m.y - H:i",$refuser['aktivzeit']).'" align="absmiddle"> &raquo; User seit 30 tagen inaktiv';


$refebene_1 = db_query ("SELECT uid FROM ".$db_prefix."_werberdaten WHERE werber='".$_GET['ruid']."'");
while ($anzeigen_1 = mysqli_fetch_array($refebene_1)) {
$ebene2++;
}

if ($ebene2 > 0){
   $refebene_1 = db_query ("SELECT uid FROM ".$db_prefix."_werberdaten WHERE werber='".$_GET['ruid']."'");
   while ($anzeigen_1 = mysqli_fetch_array($refebene_1)) {
   	$refebene_2 = db_query ("SELECT * FROM ".$db_prefix."_werberdaten WHERE werber='".$anzeigen_1['uid']."' ORDER BY uid ASC");
	while ($anzeigen_2 = mysqli_fetch_array($refebene_2)) {
	$ebene3++;
	}
   }
}
?>

<?head("Refdeteils von ".$refuser['nickname']);?>
<table width="100%" cellpadding="2" cellspacing="2" border="0">
<tr>
<td width="50%"><b>User</b></td><td><?=$refuser['nickname'];?></td>
</tr>
<tr>
<td><b>Aktueller Verdienst</b></td><td><?=number_format($refuser['umsatz']/$pageconfig['re1'],2,",",".");?> <?php echo $pageconfig['waehrung'];?></td>
</tr>

<?if($refuser['resetzeit'] > 0){?>
<tr>
<td><b>Verdienst seit Reset</b></td><td><?=number_format($refuser['reset'],2,",",".");?> <?php echo $pageconfig['waehrung'];?>&nbsp;&nbsp;&raquo;&nbsp;<a href="?content=/konto/refdetails&ruid=<?=$refuser['uid'];?>&reset=true" target="_self">Reset</a>&nbsp;&laquo;</td>
</tr>
<tr>
<td><b>Letzer Reset</b></td><td><?=date("d.m.Y - H:i:s",$refuser['resetzeit']);?></td>
</tr>
<?}?>

<tr>
<td><b>Gesamtverdienst</b></td><td><?=number_format($refuser['gesamt'],2,",",".");?> <?php echo $pageconfig['waehrung'];?></td>
</tr>
<tr>
<td><b>Refback in Prozent</b></td><form action="?content=/konto/refdetails&ruid=<?=$refuser['uid'];?>" method="post"><td><input type="Text" name="refback" value="<?=$refuser['refback'];?>" maxlength="3" style="width:30px">&nbsp;<input type="Submit" name="save" value="Save" style="width:60px"></td></form>
</tr>
<tr>
<td><b>Refs in Ebene 2</b></td><td><?=number_format($ebene2,0,",",".");?></td>
</tr>
<tr>
<tr>
<td><b>Refs in Ebene 3</b></td><td><?=number_format($ebene3,0,",",".");?></td>
</tr>
<tr>
<td><b>Status</b></td><td><?=$refstatus;?></td>
</tr>
<tr>
<td><b>Refzuordnung am</b></td><td><?if ($refuser['zuordnungszeit'] >= 1) {echo date("d.m.Y - H:i:s",$refuser['zuordnungszeit']);} else {echo'<i>Durch Admin zugewiesen!</i>';}?></td>
</tr>

<tr>
<td><b>Letzter Login</b></td><td><?if ($refuser['loginzeit'] >= 1) {echo date("d.m.Y - H:i:s",$refuser['loginzeit']);} else {echo'<i>User war noch nie eingeloggt!</i>';}?></td>
</tr>

<tr>
<td><b>Letzte Aktivität</b></td><td><?if ($refuser['aktivzeit'] >= 1) {echo date("d.m.Y - H:i:s",$refuser['aktivzeit']);} else {echo'<i><font color="#800000">User war noch nie aktiv!</font></i>';}?></td>
</tr>
</table>
<?foot();?>