Differential D23639 Diff 66742 fundraisers/yearend2016/index.php

Changeset View

Standalone View

View Options

fundraisers/yearend2016/index.php

Show All 10 Lines1<?php
11 $pageConfig = array_merge($pageConfig, [ 11​ $pageConfig = array_merge($pageConfig, [
12 'title' => i18n_noop("Make the World a Better Place! - KDE End of Year 2016 Fundraising"), 12​ 'title' => i18n_noop("Make the World a Better Place! - KDE End of Year 2016 Fundraising"),
13 'cssFile' => '/css/announce.css' 13​ 'cssFile' => '/css/announce.css'
14 ]); 14​ ]);
15 15​
16 require('../../aether/header.php'); 16​ require('../../aether/header.php');
17 $site_root = "../../"; 17​ $site_root = "../../";
18 18​
19 require("donations_auth.inc"); 19​ require("config.php");
20​
21​ $countStmt = $dbConnection->prepare("SELECT COUNT(*) FROM yearend2016donations ORDER BY CREATED_AT DESC;");
22​ $countStmt->execute();
23​ $n = $countStmt->fetchColumn();
24​
25​ $res = $dbConnection->prepare("SELECT *, UNIX_TIMESTAMP(CREATED_AT) AS date_t FROM yearend2016donations ORDER BY CREATED_AT DESC;");
20 26​
21 $query = "select count(*) from yearend2016donations;"; ​
22 $q = mysql_query($query,$sq); ​
23 echo mysql_error(); ​
24 $row = mysql_fetch_array($q); ​
25 $index = $row[0]; ​
26 ​
27 $query = "select *,unix_timestamp(date) as date_t from yearend2016donations order by date desc;"; ​
28 $q = mysql_query($query,$sq); ​
29 echo mysql_error(); ​
30 $total = 0; 27​ $total = 0;
ognarbAuthorUnsubmitted
Done

query not used

ognarb: query not used
31 $table = "<table border='1' width='100%'>"; 28​ $table = "<table border='1' width='100%'>";
32 $table.="<tr><th width='20'></th><th width='180'>".i18n_var("Date")."</th><th width='80'>".i18n_var("Amount")."</th><th style='text-align:left'>".i18n_var("Donor Name")."</th></tr>"; 29​ $table.="<tr><th width='20'></th><th width='180'>".i18n_var("Date")."</th><th width='80'>".i18n_var("Amount")."</th><th style='text-align:left'>".i18n_var("Donor Name")."</th></tr>";
33 while ($row = mysql_fetch_array($q)) { 30​ while ($row = $res->fetch()) {
34 $msg = htmlspecialchars($row["message"]); 31​ $msg = htmlspecialchars($row["message"]);
35 if ($msg == "") { 32​ if ($msg == "") {
36 $msg = "<i>".i18n_var("Anonymous donation")."</i>"; 33​ $msg = "<i>".i18n_var("Anonymous donation")."</i>";
37 } 34​ }
38 $amount = $row["amount"]; 35​ $amount = $row["amount"];
39 $table.="<tr>"; 36​ $table.="<tr>";
40 $table.="<td align='center'>".$index."</td>"; 37​ $table.="<td align='center'>".$index."</td>";
41 $table.="<td align='center'>".date("jS F Y", $row["date_t"])."</td>"; 38​ $table.="<td align='center'>".date("jS F Y", $row["date_t"])."</td>";
42 $table.="<td align='right'>&euro;&nbsp;".number_format($amount,2)."</td>"; 39​ $table.="<td align='right'>&euro;&nbsp;".number_format($amount,2)."</td>";
43 $total += $amount; 40​ $total += $amount;
44 $table.="<td>".$msg."</td>"; 41​ $table.="<td>".$msg."</td>";
45 $table.="</tr>"; 42​ $table.="</tr>";
46 $index--; 43​ $index--;
47 } 44​ }
48 $table.="</table><br/>"; 45​ $table.="</table><br/>";
49 $total = number_format($total, 0, ".", "&#8201;"); 46​ $total = number_format($total, 0, ".", "&#8201;");
50 47​
51 // This is select from select seems mysql specific? 48​ // This is select from select seems mysql specific?
52 $query = "select MIN(sum_amount) from ( select sum(amount) as sum_amount from yearend2016donations group by email order by sum_amount DESC LIMIT 9 ) as tops;"; 49​ $query = "select MIN(sum_amount) from ( select sum(amount) as sum_amount from yearend2016donations group by email order by sum_amount DESC LIMIT 9 ) as tops;";
53 $q = mysql_query($query,$sq); 50​ $limitStmt = $dbConnection->prepare($query);
54 echo mysql_error(); 51​ $limitStmt->execute();
55 $limit_amount = mysql_fetch_array($q)[0]; 52​ $limit_amount = $limitStmt->fetchColumn();
56 53​
57 $query = "select * from ( select email, sum(amount) as sum_amount from yearend2016donations group by email order by sum_amount ) as tops where sum_amount >= ".$limit_amount." order by sum_amount DESC;"; 54​ $query = "select * from ( select email, sum(amount) as sum_amount from yearend2016donations group by email order by sum_amount ) as tops where sum_amount >= :limit_amount order by sum_amount DESC;";
58 $q = mysql_query($query,$sq); 55​ $q = $dbConnection->prepare($query);
59 echo mysql_error(); 56​ $q->execute(['limit_amount' => $limit_amount]);
60 57​
61 $top9table = "<table border='1' width='100%'>"; 58​ $top9table = "<table border='1' width='100%'>";
62 $top9table.="<tr><th width='20'></th><th width='180'>".i18n_var("Total Amount")."</th><th style='text-align:left'>".i18n_var("Donor Name")."</th></tr>"; 59​ $top9table.="<tr><th width='20'></th><th width='180'>".i18n_var("Total Amount")."</th><th style='text-align:left'>".i18n_var("Donor Name")."</th></tr>";
63 $count = 0; 60​ $count = 0;
64 $last_amount = -1; 61​ $last_amount = -1;
65 $last_was_same_amount = false; 62​ $last_was_same_amount = false;
66 while ($row = mysql_fetch_array($q)) { 63​ $q2 = $dbConnection->prepare('select distinct message as name from yearend2016donations where email=:email');
64​ while ($row = $q->fetch()) {
ognarbAuthorUnsubmitted
Done

I forgot execute()

ognarb: I forgot execute()
67 $amount = $row["sum_amount"]; 65​ $amount = $row["sum_amount"];
68 $email = $row['email']; 66​ $email = $row['email'];
69 $query2 = "select distinct message as name from yearend2016donations where email='".$email."';"; 67​ $q2->execute(['email' => $email]);
70 $q2 = mysql_query($query2,$sq); ​
71 echo mysql_error(); ​
72 $donation_count = 0; 68​ $donation_count = 0;
73 while ($row2 = mysql_fetch_array($q2)) { 69​ while ($row2 = $q2-fetch()) {
74 $msg = $row2["name"]; 70​ $msg = $row2["name"];
75 $donation_count++; 71​ $donation_count++;
76 } 72​ }
77 73​
78 if ($donation_count !== 1) { 74​ if ($donation_count !== 1) {
79 $msg = "<i>".i18n_var("Anonymous donation")."</i>"; 75​ $msg = "<i>".i18n_var("Anonymous donation")."</i>";
80 } 76​ }
81 if ($msg == "") { 77​ if ($msg == "") {
▲ Show 20 Lines • Show All 245 Lines • Show Last 20 Lines