Changeset View
Changeset View
Standalone View
Standalone View
fundraisers/kdesprints2015/index.php
Show All 14 Lines | 13 | $pageConfig = array_merge($pageConfig, [ | |||
---|---|---|---|---|---|
15 | 'cssFile' => '/css/announce.css' | 15 | 'cssFile' => '/css/announce.css' | ||
16 | ]); | 16 | ]); | ||
17 | 17 | | |||
18 | require('../../aether/header.php'); | 18 | require('../../aether/header.php'); | ||
19 | $site_root = "../../"; | 19 | $site_root = "../../"; | ||
20 | 20 | | |||
21 | require("donations_auth.inc"); | 21 | require("donations_auth.inc"); | ||
22 | 22 | | |||
23 | $query = "select *,unix_timestamp(date) as date_t from randameetings2015donations order by date desc;"; | 23 | $res = $db->prepare("SELECT *, UNIX_TIMESTAMP(date) AS date_t FROM randameetings2015donations ORDER BY date DESC;"); | ||
24 | $q = mysql_query($query,$sq); | 24 | $res->execute(); | ||
25 | echo mysql_error(); | | |||
26 | $total = 0; | 25 | $total = 0; | ||
27 | $count = 0; | 26 | $count = 0; | ||
28 | $table = "<table border='1' width='100%'>"; | 27 | $table = "<table border='1' width='100%'>"; | ||
29 | $table.="<tr><th width='20'>No.</th><th width='180'>Date</th><th width='80'>Amount</th><th style='text-align:left'>Donor Name</th></tr>"; | 28 | $table.="<tr><th width='20'>No.</th><th width='180'>Date</th><th width='80'>Amount</th><th style='text-align:left'>Donor Name</th></tr>"; | ||
30 | while ($row = mysql_fetch_array($q)) { | 29 | while ($row = $res->fetch()) { | ||
31 | $msg = htmlspecialchars($row["message"]); | 30 | $msg = htmlspecialchars($row["message"]); | ||
32 | if ($msg == "") { | 31 | if ($msg == "") { | ||
33 | $msg = "<i>Anonymous donation</i>"; | 32 | $msg = "<i>Anonymous donation</i>"; | ||
34 | } | 33 | } | ||
35 | $total += $row["amount"]; | 34 | $total += $row["amount"]; | ||
36 | $count++; | 35 | $count++; | ||
37 | 36 | | |||
38 | $table.="<tr>"; | 37 | $table.="<tr>"; | ||
Show All 11 Lines | 48 | $graph_style = "width: 100%; height: 30px; border: 1px solid #888; background: rgb(204,204,204); | |||
50 | position: relative;"; | 49 | position: relative;"; | ||
51 | $bar_style = "height: 30px; background: rgb(68,132,242); width: ".$percent."%"; | 50 | $bar_style = "height: 30px; background: rgb(68,132,242); width: ".$percent."%"; | ||
52 | ?> | 51 | ?> | ||
53 | 52 | | |||
54 | <main class="container"> | 53 | <main class="container"> | ||
55 | 54 | | |||
56 | <h1>KDE Sprints 2015 fundraising</h1> | 55 | <h1>KDE Sprints 2015 fundraising</h1> | ||
57 | 56 | | |||
58 | <!-- <div class="formholder" style='float:right; width:40%;'> | 57 | <?php /* <div class="formholder" style='float:right; width:40%;'> | ||
59 | <form action="https://www.paypal.com/cgi-bin/webscr" method="post"> | 58 | <form action="https://www.paypal.com/cgi-bin/webscr" method="post"> | ||
60 | <input type="hidden" name="business" value="kde-ev-paypal@kde.org"> --> | 59 | <input type="hidden" name="business" value="kde-ev-paypal@kde.org"> --> */ ?> | ||
61 | 60 | | |||
62 | <?php | 61 | <?php | ||
63 | echo "<p align='center'>€$total raised of a €$goal goal</p>"; | 62 | echo "<p align='center'>€$total raised of a €$goal goal</p>"; | ||
64 | echo "<div style='$graph_style'><div style='$bar_style'></div></div>"; | 63 | echo "<div style='$graph_style'><div style='$bar_style'></div></div>"; | ||
65 | echo "<br/>" | 64 | echo "<br/>" | ||
66 | ?> | 65 | | ||
67 | <!-- <input type="hidden" name="cmd" value="_donations" /> | 66 | /*<!-- <input type="hidden" name="cmd" value="_donations" /> | ||
68 | <input type="hidden" name="lc" value="GB" /> | 67 | <input type="hidden" name="lc" value="GB" /> | ||
69 | <input type="hidden" name="item_name" value="KDE e.V." /> | 68 | <input type="hidden" name="item_name" value="KDE e.V." /> | ||
70 | <input type="hidden" name="item_number" value="Donation to Randa Meetings 2015 KDE e.V." /> | 69 | <input type="hidden" name="item_number" value="Donation to Randa Meetings 2015 KDE e.V." /> | ||
71 | <input type="hidden" name="currency_code" value="EUR" /> | 70 | <input type="hidden" name="currency_code" value="EUR" /> | ||
72 | <input type="hidden" name="cbt" value="Return to www.kde.org" /> | 71 | <input type="hidden" name="cbt" value="Return to www.kde.org" /> | ||
73 | <input type="hidden" name="on0" value="Show Name on donor List" /> | 72 | <input type="hidden" name="on0" value="Show Name on donor List" /> | ||
74 | <input type="hidden" name="no_note " value="1" /> | 73 | <input type="hidden" name="no_note " value="1" /> | ||
75 | <input type="hidden" name="return" value="https://www.kde.org/fundraisers/kdesprints2015/thanks_paypal.php"> | 74 | <input type="hidden" name="return" value="https://www.kde.org/fundraisers/kdesprints2015/thanks_paypal.php"> | ||
76 | <input type="hidden" name="notify_url" value="https://www.kde.org/fundraisers/kdesprints2015/notify.php"> | 75 | <input type="hidden" name="notify_url" value="https://www.kde.org/fundraisers/kdesprints2015/notify.php"> | ||
77 | <div align="center"> | 76 | <div align="center"> | ||
78 | <input type='text' name="amount" value='40' style="vertical-align:middle;text-align:right;" size="4" /> € | 77 | <input type='text' name="amount" value='40' style="vertical-align:middle;text-align:right;" size="4" /> € | ||
79 | <input type="image" name="submit" src="https://www.paypal.com/en_US/i/btn/btn_donate_LG.gif" alt="PayPal" style="vertical-align:middle;" /> | 78 | <input type="image" name="submit" src="https://www.paypal.com/en_US/i/btn/btn_donate_LG.gif" alt="PayPal" style="vertical-align:middle;" /> | ||
80 | <br/> | 79 | <br/> | ||
81 | <br/> | 80 | <br/> | ||
82 | Show my name on the <a href="#donorlist">donor list</a> <select name="os0"> | 81 | Show my name on the <a href="#donorlist">donor list</a> <select name="os0"> | ||
83 | <option value="Yes">Yes</option> | 82 | <option value="Yes">Yes</option> | ||
84 | <option value="No">No</option> | 83 | <option value="No">No</option> | ||
85 | </select> | 84 | </select> | ||
86 | </div> | 85 | </div> | ||
87 | </form> | 86 | </form> | ||
88 | </div> --> | 87 | </div> -->*/ | ||
88 | ?> | ||||
89 | 89 | | |||
90 | <b>The Randa Meetings 2015 Fundraiser has finished. Thank you everybody who supported us in this fundraiser. We didn't reach the set goal but we collected quite some money and that means there will be more KDE Sprints thanks to your support! See <a href="http://planet.kde.org">http://planet.kde.org</a> for more information to come and go to the <a href="https://www.kde.org/community/donations/index.php">KDE donation page</a> if you want to support us further.</b> | 90 | <b>The Randa Meetings 2015 Fundraiser has finished. Thank you everybody who supported us in this fundraiser. We didn't reach the set goal but we collected quite some money and that means there will be more KDE Sprints thanks to your support! See <a href="http://planet.kde.org">http://planet.kde.org</a> for more information to come and go to the <a href="https://www.kde.org/community/donations/index.php">KDE donation page</a> if you want to support us further.</b> | ||
91 | 91 | | |||
92 | <p><strong>[update]</strong> The fundraising campaign has been extended. We had intended to have ongoing updates from the Randa Meetings. However, developers were working rather than writing articles and blogposts. By extending the campaign, more information can be provided about what was actually accomplished.</p> | 92 | <p><strong>[update]</strong> The fundraising campaign has been extended. We had intended to have ongoing updates from the Randa Meetings. However, developers were working rather than writing articles and blogposts. By extending the campaign, more information can be provided about what was actually accomplished.</p> | ||
93 | 93 | | |||
94 | <p>For the sixth year, the KDE sprints in Randa, Switzerland will include key projects and top developers, working concurrently under one roof, free from noise and distractions.</p> | 94 | <p>For the sixth year, the KDE sprints in Randa, Switzerland will include key projects and top developers, working concurrently under one roof, free from noise and distractions.</p> | ||
95 | 95 | | |||
96 | 96 | | |||
▲ Show 20 Lines • Show All 134 Lines • Show Last 20 Lines |