Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
<?
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"> » 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"> » 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"> » 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,",",".");?> <?=$waehrung;?></td>
</tr>
<?if($refuser['resetzeit'] > 0){?>
<tr>
<td><b>Verdienst seit Reset</b></td><td><?=number_format($refuser['reset'],2,",",".");?> <?=$waehrung;?> » <a href="?content=/konto/refdetails&ruid=<?=$refuser['uid'];?>&reset=true" target="_self">Reset</a> «</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,",",".");?> <?=$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"> <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();?>