Stories
Slash Boxes
Comments

SoylentNews is people

SoylentNews is powered by your submissions, so send in your scoop. Only 16 submissions in the queue.
Meta
posted by martyb on Thursday December 30 2021, @12:08AM   Printer-friendly
from the We're-getting-there!!! dept.

You guys are GREAT!

Previously:
In our last Fundraising Update we had raised $1,808.21 (net) towards our goal of $3,500.00 for the 2nd half of the year. (And five days earlier we stood at just $1,510.49).

Currently:
And where are we now? Hold onto your seat...

mysql>  SELECT SUM(payment_gross) AS Gross, SUM(payment_net) AS Net, ts, max(spid) AS SPID FROM subscribe_payments WHERE ts >= '2021-07-01' ;
+---------+---------+---------------------+------+
| Gross   | Net     | ts                  | SPID |
+---------+---------+---------------------+------+
| 2435.06 | 2307.23 | 2021-07-01 02:15:00 | 1727 |
+---------+---------+---------------------+------+
1 row in set (0.00 sec)

mysql>

In that time, we had 4x $50.00 subscriptions and a $100.00 subscription (flagged by an "*" below):

mysql> SELECT ts, payment_gross, payment_net, method, submethod, payment_type FROM subscribe_payments WHERE ts > '2021-12-28 13:01:56' AND payment_gross > 0 ORDER BY ts ;
+---------------------+---------------+-------------+--------+-----------+--------------+
| ts                  | payment_gross | payment_net | method | submethod | payment_type |
+---------------------+---------------+-------------+--------+-----------+--------------+
| 2021-12-28 22:28:09 |         *50.00 |       47.76 | paypal | NULL      | user         |
| 2021-12-28 22:48:32 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-12-28 23:33:57 |         *50.00 |       47.76 | paypal | NULL      | user         |
| 2021-12-29 00:54:44 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-12-29 02:47:41 |         *50.00 |       47.01 | paypal | NULL      | user         |
| 2021-12-29 03:08:48 |         20.00 |       18.51 | paypal | NULL      | user         |
| 2021-12-29 04:50:49 |        *100.00 |       96.02 | paypal | NULL      | gift         |
| 2021-12-29 07:01:43 |         20.00 |       18.51 | paypal | NULL      | user         |
| 2021-12-29 10:58:54 |         10.00 |        9.16 | paypal | NULL      | user         |
| 2021-12-29 12:46:04 |         25.00 |       23.26 | paypal | NULL      | user         |
| 2021-12-29 13:32:12 |         20.00 |       19.12 | stripe | CC        | user         |
| 2021-12-29 13:37:36 |         *50.00 |       48.25 | stripe | CC        | user         |
| 2021-12-29 14:16:35 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-12-29 14:24:29 |         40.00 |       37.51 | paypal | NULL      | user         |
| 2021-12-29 21:11:32 |         12.00 |       10.91 | paypal | NULL      | user         |
| 2021-12-29 22:06:03 |         20.00 |       18.81 | paypal | NULL      | user         |
+---------------------+---------------+-------------+--------+-----------+--------------+
16 rows in set (0.00 sec)

mysql>

Yes, the larger subscriptions are attention-getting, but $220.00 of that $527.00 came from subscriptions of $20.00 or less.

Remaining:
Since I started writing this, we received two more $20.00 subscriptions! All told, we need just $1,173.96 to make our goal and only 2 days to go. Can we do it? We Can Do This... Please Subscribe!

Ahem. Got carried away there. But seriously, every bit makes a difference; please help.
--martyb

 
This discussion has been archived. No new comments can be posted.
Display Options Threshold/Breakthrough Mark All as Read Mark All as Unread
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
  • (Score: 3, Interesting) by coolgopher on Thursday December 30 2021, @02:42AM (3 children)

    by coolgopher (1157) on Thursday December 30 2021, @02:42AM (#1208601)

    I'm a bit late to the party here, but for the next round might it be an idea to provide a list of uids without subscription but with overwhelmingly positive karma, so that one can gift subscriptions to those who have contributed positively? Or even anonymously so, "just" another selection on the subscription page for "give subscription to random contributing user" sort of thing?

    Starting Score:    1  point
    Moderation   +1  
       Interesting=1, Total=1
    Extra 'Interesting' Modifier   0  
    Karma-Bonus Modifier   +1  

    Total Score:   3  
  • (Score: 2, Insightful) by Anonymous Coward on Thursday December 30 2021, @03:06AM

    by Anonymous Coward on Thursday December 30 2021, @03:06AM (#1208603)

    Karma maxes out at 50. It's easy enough to trigger some snowflake and get a troll/flamebait/offtopic or two, but you have to be a complete arsehole to have less than 48 after you've been posting for a while.

  • (Score: 3, Informative) by Anonymous Coward on Thursday December 30 2021, @03:13AM (1 child)

    by Anonymous Coward on Thursday December 30 2021, @03:13AM (#1208605)

    Just pick a post you like that has a username with no subscription badge (gold star) showing, and make their day. They will get an email about it.

    • (Score: 2) by nostyle on Thursday December 30 2021, @02:57PM

      by nostyle (11497) on Thursday December 30 2021, @02:57PM (#1208697) Journal

      Better still, find someone you hate and gift them a subscription. Make them utterly conflicted.

      --
      “The supreme art of war is to subdue the enemy without fighting.” – Sun Tzu