Index: trunk/www/sites/www/fundraisers/yearend2017/.git/COMMIT_EDITMSG =================================================================== --- trunk/www/sites/www/fundraisers/yearend2017/.git/COMMIT_EDITMSG (revision 1505360) +++ trunk/www/sites/www/fundraisers/yearend2017/.git/COMMIT_EDITMSG (revision 1505361) @@ -1,11 +1,11 @@ -Clean css +Revert "Comment database related code" -Signed-off-by: Lays Rodrigues +This reverts commit 3876ffd2b5b423bce9c06334ee2d85eab6234ada. # Please enter the commit message for your changes. Lines starting # with '#' will be ignored, and an empty message aborts the commit. # # On branch master # Changes to be committed: -# modified: static/css/styles.css +# modified: index.php # Index: trunk/www/sites/www/fundraisers/yearend2017/.git/index =================================================================== Cannot display: file marked as a binary type. svn:mime-type = application/octet-stream Index: trunk/www/sites/www/fundraisers/yearend2017/.git/logs/HEAD =================================================================== --- trunk/www/sites/www/fundraisers/yearend2017/.git/logs/HEAD (revision 1505360) +++ trunk/www/sites/www/fundraisers/yearend2017/.git/logs/HEAD (revision 1505361) @@ -1,42 +1,43 @@ 0000000000000000000000000000000000000000 3116420cdf5f9c5efa443049f7073e2945b7c717 Lays Rodrigues 1511665409 -0200 commit (initial): First Commit 3116420cdf5f9c5efa443049f7073e2945b7c717 cea548e2c017cd370770416103df3980e299c00b Lays Rodrigues 1511665681 -0200 commit: Add gitignore cea548e2c017cd370770416103df3980e299c00b 2621f09874ddb529a683edd250826c2e43c5a5ed Lays Rodrigues 1511665746 -0200 commit: Add tox, setup.py and readme 2621f09874ddb529a683edd250826c2e43c5a5ed af60dbb203aa62d14cec5f9ff4c0f17f3120cc84 Lays Rodrigues 1511666234 -0200 commit: Add heroku procfile af60dbb203aa62d14cec5f9ff4c0f17f3120cc84 0e8685a6014a7c916eaad9abe627609f36c7dcf0 Lays Rodrigues 1511666314 -0200 commit: Add gunicorn as dependence 0e8685a6014a7c916eaad9abe627609f36c7dcf0 f17ea2a8a477b8c6e5f020dc640e7d7337d52633 Lays Rodrigues 1511666422 -0200 commit: a f17ea2a8a477b8c6e5f020dc640e7d7337d52633 b688de8aa3d897062f2f78b46aa2de2c509d2cf6 Lays Rodrigues 1511666639 -0200 commit: a b688de8aa3d897062f2f78b46aa2de2c509d2cf6 324aca5672f395ca7d7d50d74a094a25e2f14699 Lays Rodrigues 1511666964 -0200 commit: a 324aca5672f395ca7d7d50d74a094a25e2f14699 a2c5aed063633f88803576a71de693c6dcb3b546 Lays Rodrigues 1511667657 -0200 commit: a a2c5aed063633f88803576a71de693c6dcb3b546 cdbf3d09e2a24f0faf4ae02dc02c537e829b23f1 Lays Rodrigues 1511717650 -0200 commit: a cdbf3d09e2a24f0faf4ae02dc02c537e829b23f1 2c46cbd8a911a7c6d93a82124e52842a29774fcf Lays Rodrigues 1511717756 -0200 commit: a 2c46cbd8a911a7c6d93a82124e52842a29774fcf af60dbb203aa62d14cec5f9ff4c0f17f3120cc84 Lays Rodrigues 1511717994 -0200 rebase -i (start): checkout HEAD~8 af60dbb203aa62d14cec5f9ff4c0f17f3120cc84 32b51a355ed659082a40b2bbddffc9835bea8b40 Lays Rodrigues 1511717994 -0200 rebase -i (squash): # This is a combination of 2 commits. 32b51a355ed659082a40b2bbddffc9835bea8b40 bd6d057d11372eb6c56a7cd573efc49b963ac199 Lays Rodrigues 1511717994 -0200 rebase -i (squash): # This is a combination of 3 commits. bd6d057d11372eb6c56a7cd573efc49b963ac199 59547973b83dd55d1eec7a8eab2b989752dbef26 Lays Rodrigues 1511717994 -0200 rebase -i (squash): # This is a combination of 4 commits. 59547973b83dd55d1eec7a8eab2b989752dbef26 256d73b67e6fb9d1a271dd7e68b4d4e13caab415 Lays Rodrigues 1511717994 -0200 rebase -i (squash): # This is a combination of 5 commits. 256d73b67e6fb9d1a271dd7e68b4d4e13caab415 f2b9d9b1b653c0ce9b48b35f1a3f7fbb8734fcf7 Lays Rodrigues 1511717994 -0200 rebase -i (squash): # This is a combination of 6 commits. f2b9d9b1b653c0ce9b48b35f1a3f7fbb8734fcf7 c04972fb47ab39af97e9fe0ebba1f75561847e29 Lays Rodrigues 1511717994 -0200 rebase -i (squash): # This is a combination of 7 commits. c04972fb47ab39af97e9fe0ebba1f75561847e29 7ee7052092421cd6a686654650e333e16878ed29 Lays Rodrigues 1511717994 -0200 rebase -i (squash): Add heroku procfile 7ee7052092421cd6a686654650e333e16878ed29 7ee7052092421cd6a686654650e333e16878ed29 Lays Rodrigues 1511718007 -0200 rebase -i (finish): returning to refs/heads/master 7ee7052092421cd6a686654650e333e16878ed29 e3ddb54883daa0d1c5595360e3e7fce03af63ca8 Lays Rodrigues 1511724562 -0200 commit: Add __init__.py e3ddb54883daa0d1c5595360e3e7fce03af63ca8 e3ddb54883daa0d1c5595360e3e7fce03af63ca8 Lays Rodrigues 1511727368 -0200 checkout: moving from master to turn_into_php e3ddb54883daa0d1c5595360e3e7fce03af63ca8 ed84c943d1468e582b3aa06a9481ab912bc384f3 Lays Rodrigues 1511727676 -0200 commit: Remove Python files ed84c943d1468e582b3aa06a9481ab912bc384f3 40891068576c8a0c172a73e7f680ed6bdbe82665 Lays Rodrigues 1511727732 -0200 commit: Move index to root of project 40891068576c8a0c172a73e7f680ed6bdbe82665 2046027461571d7166d27a8a13d333c4f3d4e3a8 Lays Rodrigues 1511727747 -0200 commit: Turn html -> php 2046027461571d7166d27a8a13d333c4f3d4e3a8 4bcfbb92cd8c90dc0004dc8823783b1d22c30615 Lays Rodrigues 1511728004 -0200 commit: Add PHP/Paypal Files 4bcfbb92cd8c90dc0004dc8823783b1d22c30615 f01a568292bfc89e58f27b831ec5fb853634e9da Lays Rodrigues 1511728417 -0200 commit: Revert use of python/flask urls for static files f01a568292bfc89e58f27b831ec5fb853634e9da 85589eaa700991f30d6700e48398ae4205957f79 Lays Rodrigues 1511728823 -0200 commit: Add get on db to load the donations 85589eaa700991f30d6700e48398ae4205957f79 6c3a9fdd7a887e1e3fedb45f1ed2b926b93295d3 Lays Rodrigues 1511734055 -0200 commit: Add end-date and update of amount of backers 6c3a9fdd7a887e1e3fedb45f1ed2b926b93295d3 fdf4a44d1b86849310f7aeac681f6ddc93e0ca0c Lays Rodrigues 1511734567 -0200 commit: Remove not used images fdf4a44d1b86849310f7aeac681f6ddc93e0ca0c 6c3a9fdd7a887e1e3fedb45f1ed2b926b93295d3 Lays Rodrigues 1511734578 -0200 reset: moving to HEAD~ 6c3a9fdd7a887e1e3fedb45f1ed2b926b93295d3 c55c9691d6c3c8733515673da5de4211062f617f Lays Rodrigues 1511734585 -0200 commit: Remove not used images c55c9691d6c3c8733515673da5de4211062f617f 3e1b79141c32b7bb972bfb91696eebb368bc8009 Lays Rodrigues 1511734605 -0200 commit: Change order of sections 3e1b79141c32b7bb972bfb91696eebb368bc8009 09bc36947a2f9fb0c3d6eaf2595f6616b25978be Lays Rodrigues 1511735607 -0200 commit: Remove not used images 09bc36947a2f9fb0c3d6eaf2595f6616b25978be b0733b4b62737f9bcd208c8f03088e0b6b0999b2 Lays Rodrigues 1511735644 -0200 commit: Add some kde images b0733b4b62737f9bcd208c8f03088e0b6b0999b2 4d493d68262d27b3634d4aa6eb2f22c948d3484a Lays Rodrigues 1511735649 -0200 commit: Add new images to template and add modal to open video 4d493d68262d27b3634d4aa6eb2f22c948d3484a e3ddb54883daa0d1c5595360e3e7fce03af63ca8 Lays Rodrigues 1511735812 -0200 checkout: moving from turn_into_php to master e3ddb54883daa0d1c5595360e3e7fce03af63ca8 4d493d68262d27b3634d4aa6eb2f22c948d3484a Lays Rodrigues 1511735816 -0200 rebase: checkout turn_into_php 4d493d68262d27b3634d4aa6eb2f22c948d3484a 4d493d68262d27b3634d4aa6eb2f22c948d3484a Lays Rodrigues 1511735816 -0200 rebase finished: returning to refs/heads/master 4d493d68262d27b3634d4aa6eb2f22c948d3484a 0fd4c8cf7a9f04b609a47e5049c9235d07af20c4 Lays Rodrigues 1511735898 -0200 commit: Change structure of project 0fd4c8cf7a9f04b609a47e5049c9235d07af20c4 3876ffd2b5b423bce9c06334ee2d85eab6234ada Lays Rodrigues 1511736724 -0200 commit: Comment database related code 3876ffd2b5b423bce9c06334ee2d85eab6234ada f8e1b504e967d56e6ffdffa622c4c271aabb6c2a Lays Rodrigues 1511736831 -0200 commit: Clean css +f8e1b504e967d56e6ffdffa622c4c271aabb6c2a efac3f09570800e1ef52a5f5d0de45e64b6f0e53 Lays Rodrigues 1511832152 -0200 revert: Revert "Comment database related code" Index: trunk/www/sites/www/fundraisers/yearend2017/.git/logs/refs/heads/master =================================================================== --- trunk/www/sites/www/fundraisers/yearend2017/.git/logs/refs/heads/master (revision 1505360) +++ trunk/www/sites/www/fundraisers/yearend2017/.git/logs/refs/heads/master (revision 1505361) @@ -1,17 +1,18 @@ 0000000000000000000000000000000000000000 3116420cdf5f9c5efa443049f7073e2945b7c717 Lays Rodrigues 1511665409 -0200 commit (initial): First Commit 3116420cdf5f9c5efa443049f7073e2945b7c717 cea548e2c017cd370770416103df3980e299c00b Lays Rodrigues 1511665681 -0200 commit: Add gitignore cea548e2c017cd370770416103df3980e299c00b 2621f09874ddb529a683edd250826c2e43c5a5ed Lays Rodrigues 1511665746 -0200 commit: Add tox, setup.py and readme 2621f09874ddb529a683edd250826c2e43c5a5ed af60dbb203aa62d14cec5f9ff4c0f17f3120cc84 Lays Rodrigues 1511666234 -0200 commit: Add heroku procfile af60dbb203aa62d14cec5f9ff4c0f17f3120cc84 0e8685a6014a7c916eaad9abe627609f36c7dcf0 Lays Rodrigues 1511666314 -0200 commit: Add gunicorn as dependence 0e8685a6014a7c916eaad9abe627609f36c7dcf0 f17ea2a8a477b8c6e5f020dc640e7d7337d52633 Lays Rodrigues 1511666422 -0200 commit: a f17ea2a8a477b8c6e5f020dc640e7d7337d52633 b688de8aa3d897062f2f78b46aa2de2c509d2cf6 Lays Rodrigues 1511666639 -0200 commit: a b688de8aa3d897062f2f78b46aa2de2c509d2cf6 324aca5672f395ca7d7d50d74a094a25e2f14699 Lays Rodrigues 1511666964 -0200 commit: a 324aca5672f395ca7d7d50d74a094a25e2f14699 a2c5aed063633f88803576a71de693c6dcb3b546 Lays Rodrigues 1511667657 -0200 commit: a a2c5aed063633f88803576a71de693c6dcb3b546 cdbf3d09e2a24f0faf4ae02dc02c537e829b23f1 Lays Rodrigues 1511717650 -0200 commit: a cdbf3d09e2a24f0faf4ae02dc02c537e829b23f1 2c46cbd8a911a7c6d93a82124e52842a29774fcf Lays Rodrigues 1511717756 -0200 commit: a 2c46cbd8a911a7c6d93a82124e52842a29774fcf 7ee7052092421cd6a686654650e333e16878ed29 Lays Rodrigues 1511718007 -0200 rebase -i (finish): refs/heads/master onto 2621f09874ddb529a683edd250826c2e43c5a5ed 7ee7052092421cd6a686654650e333e16878ed29 e3ddb54883daa0d1c5595360e3e7fce03af63ca8 Lays Rodrigues 1511724562 -0200 commit: Add __init__.py e3ddb54883daa0d1c5595360e3e7fce03af63ca8 4d493d68262d27b3634d4aa6eb2f22c948d3484a Lays Rodrigues 1511735816 -0200 rebase finished: refs/heads/master onto 4d493d68262d27b3634d4aa6eb2f22c948d3484a 4d493d68262d27b3634d4aa6eb2f22c948d3484a 0fd4c8cf7a9f04b609a47e5049c9235d07af20c4 Lays Rodrigues 1511735898 -0200 commit: Change structure of project 0fd4c8cf7a9f04b609a47e5049c9235d07af20c4 3876ffd2b5b423bce9c06334ee2d85eab6234ada Lays Rodrigues 1511736724 -0200 commit: Comment database related code 3876ffd2b5b423bce9c06334ee2d85eab6234ada f8e1b504e967d56e6ffdffa622c4c271aabb6c2a Lays Rodrigues 1511736831 -0200 commit: Clean css +f8e1b504e967d56e6ffdffa622c4c271aabb6c2a efac3f09570800e1ef52a5f5d0de45e64b6f0e53 Lays Rodrigues 1511832152 -0200 revert: Revert "Comment database related code" Index: trunk/www/sites/www/fundraisers/yearend2017/.git/refs/heads/master =================================================================== --- trunk/www/sites/www/fundraisers/yearend2017/.git/refs/heads/master (revision 1505360) +++ trunk/www/sites/www/fundraisers/yearend2017/.git/refs/heads/master (revision 1505361) @@ -1 +1 @@ -f8e1b504e967d56e6ffdffa622c4c271aabb6c2a +efac3f09570800e1ef52a5f5d0de45e64b6f0e53 Index: trunk/www/sites/www/fundraisers/yearend2017/index.php =================================================================== --- trunk/www/sites/www/fundraisers/yearend2017/index.php (revision 1505360) +++ trunk/www/sites/www/fundraisers/yearend2017/index.php (revision 1505361) @@ -1,397 +1,396 @@ KDE - End of Year 2017

End of Year Fundraising

Help us build a world in which everyone has control over their digital life and enjoys freedom and privacy!

Donate!

Status

prepare("SELECT *, UNIX_TIMESTAMP(CREATED_AT) AS date_t FROM endofyear2017donations ORDER BY CREATED_AT DESC;") or die ($dbConnection->error); - // $stmt->execute(); - // $result = $stmt->get_result(); - // $stmt->close(); - // $count = $result->num_rows; - $count = 0; + $stmt = $dbConnection->prepare("SELECT *, UNIX_TIMESTAMP(CREATED_AT) AS date_t FROM endofyear2017donations ORDER BY CREATED_AT DESC;") or die ($dbConnection->error); + $stmt->execute(); + $result = $stmt->get_result(); + $stmt->close(); + $count = $result->num_rows; ?>
90%
Days
Hours
Minutes
Seconds
".$count."" ?>
Backers

Support Us

Donate 10€

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt

Donate 20€

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt

Donate 50€

Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt

2017 Retrospective

List of Donations

Anonymous donation"; - // $total += $row["amount"]; - // - // $table.=""; - // $table.="".$n.""; - // $table.="".date("jS F Y", $row["date_t"]).""; - // $table.="€".number_format($row["amount"],2).""; - // $table.="".$name.""; - // $table.=""; - // $n--; - // } - // $table.=""; - // mysqli_close($dbConnection); + $total = 0; + $n = $count; + $table = ""; + while ($row = mysqli_fetch_array($result)) { + $name = htmlspecialchars($row["donor_name"]); + if ($name == "") + $name = "Anonymous donation"; + $total += $row["amount"]; + + $table.=""; + $table.="".$n.""; + $table.="".date("jS F Y", $row["date_t"]).""; + $table.="€".number_format($row["amount"],2).""; + $table.="".$name.""; + $table.=""; + $n--; + } + $table.=""; + mysqli_close($dbConnection); ?>
# Date Amount Donor Name