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:
|
<?
require_once "common.php";
isnewday(2);
page_header("Spenderseite");
addnav("G?Zurück zur Grotte","superuser.php");
addnav("W?Zurück zum Weltlichen","village.php");
output("<form action='donators.php?op=add1' method='POST'>",true);
addnav("","donators.php?op=add1");
output("`bDonationpoints vergeben:`b`nCharakter: <input name='name'> `nPunkte: <input name='amt' size='3'>`n<input type='submit' class='button' value='Donation hinzufügen'>",true);
output("</form>",true);
if ($_GET['op']=="add2"){
if ($_GET['id']==$session['user']['acctid']){
$session['user']['donation']+=$_GET['amt'];
}
//ok to execute when this is the current user, they'll overwrite the value at the end of their page
//hit, and this will allow the display table to update in real time.
$sql = "UPDATE accounts SET donation=donation+'{$_GET['amt']}' WHERE acctid='{$_GET['id']}'";
db_query($sql);
$_GET['op']="";
}
if ($_GET['op']==""){
$sql = "SELECT name,donation,donationspent FROM accounts WHERE donation>0 ORDER BY donation DESC";
$result = db_query($sql);
output("<table border='0' cellpadding='5' cellspacing='0'>",true);
output("<tr><td>Name</td><td>Punkte</td><td>Ausgegeben</td></tr>",true);
for ($i=0;$i<db_num_rows($result);$i++){
$row = db_fetch_assoc($result);
output("<tr class='".($i%2?"trlight":"trdark")."'>",true);
output("<td>",true);
output("`^{$row['name']}`0",true);
output("</td><td>`@".number_format($row['donation'])."`0</td>",true);
output("<td>`%".number_format($row['donationspent'])."`0</td>",true);
output("</tr>",true);
}
output("</table>",true);
}else if ($_GET['op']=="add1"){
$search="%";
for ($i=0;$i<strlen($_POST['name']);$i++){
$search.=substr($_POST['name'],$i,1)."%";
}
$sql = "SELECT name,acctid,donation,donationspent FROM accounts WHERE login LIKE '$search'";
$result = db_query($sql);
output("Bestätige {$_POST['amt']} Punkte an:`n`n");
for ($i=0;$i<db_num_rows($result);$i++){
$row = db_fetch_assoc($result);
output("<a href='donators.php?op=add2&id={$row['acctid']}&amt={$_POST['amt']}'>",true);
output($row['name']." ({$row['donation']}/{$row['donationspent']})");
output("</a>`n",true);
addnav("","donators.php?op=add2&id={$row['acctid']}&amt={$_POST['amt']}");
}
}
$session['user']['standort']='Admin-Grotte';
page_footer();
?>
|