Stories
Slash Boxes
Comments

SoylentNews is people

SoylentNews is powered by your submissions, so send in your scoop. Only 18 submissions in the queue.
Meta
posted by martyb on Tuesday December 28 2021, @10:00PM   Printer-friendly
from the teamwork++ dept.

I hope this reaches you after a safe and healthy holiday!

Where We're At:
In our last fundraising update on 2021-21-20 we stood at $1510.49 towards our goal of $3,500.00 for the second half of the year. I am happy to report that we have since collected additional net subscriptions totaling $279.72. Thank You! You Rock!

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 |
+---------+---------+---------------------+------+
| 1908.06 | 1808.21 | 2021-07-01 00:41:45 | 1711 |
+---------+---------+---------------------+------+
1 row in set (0.00 sec)

mysql>

There were a total of 81 (YAY!) subscriptions purchased in the second half of this year (click to see):

mysql> SELECT ts, payment_gross, payment_net, method, submethod, payment_type FROM subscribe_payments WHERE ts >= '2021-07-01' AND payment_gross > 0 ORDER BY ts ;
+---------------------+---------------+-------------+--------+-----------+--------------+
| ts                  | payment_gross | payment_net | method | submethod | payment_type |
+---------------------+---------------+-------------+--------+-----------+--------------+
| 2021-07-01 00:41:45 |         20.00 |       19.12 | paypal | NULL      | user         |
| 2021-07-01 02:15:00 |         20.00 |       18.82 | paypal | NULL      | user         |
| 2021-07-01 02:20:50 |         20.00 |       19.12 | paypal | NULL      | user         |
| 2021-07-01 02:34:13 |         20.00 |       18.82 | paypal | NULL      | gift         |
| 2021-07-01 03:26:34 |         20.00 |       18.82 | paypal | NULL      | user         |
| 2021-07-01 14:19:33 |         20.00 |       19.12 | stripe | CC        | user         |
| 2021-07-01 16:35:50 |         22.34 |       21.39 | stripe | CC        | user         |
| 2021-07-01 18:36:56 |         20.00 |       19.12 | stripe | CC        | user         |
| 2021-07-02 10:49:17 |         20.00 |       19.12 | paypal | NULL      | user         |
| 2021-07-02 14:43:16 |         20.00 |       19.12 | paypal | NULL      | gift         |
| 2021-07-02 21:06:24 |         20.00 |       19.12 | stripe | CC        | user         |
| 2021-07-05 21:59:27 |         40.00 |       37.94 | paypal | NULL      | user         |
| 2021-07-05 22:07:16 |        400.00 |      388.10 | stripe | CC        | user         |
| 2021-07-06 14:07:24 |          5.00 |        4.55 | paypal | NULL      | user         |
| 2021-07-18 14:27:40 |          5.00 |        4.55 | paypal | NULL      | user         |
| 2021-07-19 15:13:31 |         20.00 |       19.12 | stripe | CC        | user         |
| 2021-07-22 12:14:55 |          4.00 |        3.52 | paypal | NULL      | user         |
| 2021-07-25 07:14:27 |         20.00 |       19.12 | stripe | CC        | user         |
| 2021-07-29 11:57:17 |         10.00 |        9.41 | paypal | NULL      | user         |
| 2021-08-06 12:30:41 |          5.00 |        4.34 | paypal | NULL      | user         |
| 2021-08-13 10:28:11 |         20.00 |       18.51 | paypal | NULL      | user         |
| 2021-08-18 11:54:17 |          5.00 |        4.34 | paypal | NULL      | user         |
| 2021-08-22 12:11:44 |          4.00 |        3.31 | paypal | NULL      | user         |
| 2021-08-29 13:03:40 |         10.00 |        9.16 | paypal | NULL      | user         |
| 2021-09-03 12:33:49 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-09-06 10:20:14 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-09-06 13:35:17 |          5.00 |        4.34 | paypal | NULL      | user         |
| 2021-09-10 18:30:22 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-09-11 23:56:46 |         20.00 |       19.12 | stripe | CC        | gift         |
| 2021-09-18 10:37:19 |          5.00 |        4.34 | paypal | NULL      | user         |
| 2021-09-22 10:12:38 |          4.00 |        3.31 | paypal | NULL      | user         |
| 2021-09-29 14:37:56 |         10.00 |        9.16 | paypal | NULL      | user         |
| 2021-10-05 00:31:51 |         20.00 |       19.12 | stripe | CC        | user         |
| 2021-10-06 10:58:25 |          5.00 |        4.34 | paypal | NULL      | user         |
| 2021-10-14 11:33:56 |         30.00 |       28.46 | paypal | NULL      | user         |
| 2021-10-16 09:38:51 |         13.72 |       13.02 | stripe | CC        | user         |
| 2021-10-18 11:21:58 |          5.00 |        4.34 | paypal | NULL      | user         |
| 2021-10-21 13:29:39 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-10-22 12:00:55 |          4.00 |        3.31 | paypal | NULL      | user         |
| 2021-10-24 19:27:39 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-10-26 19:43:45 |         40.00 |       38.11 | paypal | NULL      | user         |
| 2021-10-29 12:01:11 |         10.00 |        9.16 | paypal | NULL      | user         |
| 2021-10-30 18:22:11 |         50.00 |       47.01 | paypal | NULL      | gift         |
| 2021-11-06 12:28:43 |          5.00 |        4.34 | paypal | NULL      | user         |
| 2021-11-08 15:02:34 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-11-09 19:14:31 |         20.00 |       18.51 | paypal | NULL      | user         |
| 2021-11-10 06:40:55 |         50.00 |       47.76 | paypal | NULL      | gift         |
| 2021-11-10 11:47:46 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-11-12 03:08:14 |         30.00 |       28.46 | paypal | NULL      | user         |
| 2021-11-17 01:01:32 |         12.00 |       11.35 | stripe | CC        | user         |
| 2021-11-18 12:22:21 |          5.00 |        4.34 | paypal | NULL      | user         |
| 2021-11-21 14:54:31 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-11-22 12:28:08 |          4.00 |        3.31 | paypal | NULL      | user         |
| 2021-11-27 18:53:45 |         20.00 |       18.51 | paypal | NULL      | user         |
| 2021-11-29 10:45:50 |         10.00 |        9.16 | paypal | NULL      | user         |
| 2021-12-03 15:58:30 |         20.00 |       19.12 | stripe | CC        | gift         |
| 2021-12-04 02:20:36 |         20.00 |       18.51 | paypal | NULL      | user         |
| 2021-12-06 11:29:58 |          5.00 |        4.34 | paypal | NULL      | user         |
| 2021-12-11 04:02:13 |          4.00 |        3.31 | paypal | NULL      | user         |
| 2021-12-11 12:38:48 |         20.00 |       18.51 | paypal | NULL      | user         |
| 2021-12-12 11:08:54 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-12-13 20:52:42 |         12.00 |       11.09 | paypal | NULL      | user         |
| 2021-12-15 09:21:39 |         20.00 |       18.51 | paypal | NULL      | user         |
| 2021-12-15 16:00:03 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-12-16 10:32:40 |         20.00 |       18.51 | paypal | NULL      | user         |
| 2021-12-16 13:42:40 |        100.00 |       96.80 | stripe | CC        | gift         |
| 2021-12-18 10:16:24 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-12-18 10:52:56 |          5.00 |        4.34 | paypal | NULL      | user         |
| 2021-12-20 23:21:01 |         20.00 |       18.81 | paypal | NULL      | user         |
| 2021-12-21 02:21:21 |         40.00 |       38.11 | paypal | NULL      | user         |
| 2021-12-21 05:25:20 |         20.00 |       18.51 | paypal | NULL      | user         |
| 2021-12-21 17:14:58 |         20.00 |       19.12 | stripe | CC        | user         |
| 2021-12-21 21:00:59 |         50.00 |       48.25 | stripe | CC        | user         |
| 2021-12-22 10:26:01 |         20.00 |       18.51 | paypal | NULL      | user         |
| 2021-12-22 10:45:00 |          4.00 |        3.31 | paypal | NULL      | user         |
| 2021-12-23 05:17:16 |         20.00 |       19.12 | stripe | CC        | user         |
| 2021-12-23 18:26:06 |         20.00 |       19.12 | stripe | CC        | gift         |
| 2021-12-23 20:05:03 |         20.00 |       19.12 | stripe | CC        | gift         |
| 2021-12-25 12:02:11 |         40.00 |       38.11 | paypal | NULL      | user         |
| 2021-12-26 01:32:21 |         20.00 |       19.12 | stripe | CC        | user         |
| 2021-12-28 13:01:56 |         20.00 |       18.51 | paypal | NULL      | user         |
+---------------------+---------------+-------------+--------+-----------+--------------+
81 rows in set (0.00 sec)

What's Next?

The sharp-eyed among you have already recognized something: that's not nearly enough:

We need to net an additional $1691.79 to reach our goal.

WE CAN DO THIS! 😃

Just click on Subscribe and follow the instructions! (Click the "*SPOILER* for more details.)

Select whether it's a subscription for yourself or a Gift to someone else. For a Gift sub you can provide your name to tell the recipient who the subscription is from or blank it out if you want to remain anonymous. Then choose a duration (30, 180, or 365 days). Important! You can accept the minimum amount offered (4.00, 12.00, or 20.00) OR type another (larger) amount into the field. Then click the "[Continue]" button.

NB: All transactions are processed remotely — SoylentNews sets up the transaction but does not actually participate directly. Also, if you have an Ad Blocker such as No Script or uBlock Origin installed, you may need to allow an exception for "soylentnews.org", "stripe.com", and "stripe.network" for the transaction to be entered and accepted.

You're on the Home Stretch! Click a button: PayPal (1) "[PayPal Buy Now], (2) "[PayPal Subscribe]", or (3) "[Pay with Card or BitCoin]" (Actually only "Card" is accepted at this time).

You are then taken to a form on their payment processor's site where you provide the payment information and confirm the transaction.

That's it! The payment processor then informs SoylentNews of the transaction amount and their processing fee.

Should you have a question or problem, please feel free to reach out for help on IRC (Internet Relay Chat) and/or leave a message here in the comments.

These funds pay for hosting our servers, incorporation fees, taxes, and a CPA. All income goes to paying for the site. Period. Staff is all-volunteer. Nobody here has ever been paid anything for working on SoylentNews!

--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: 2) by janrinok on Thursday December 30 2021, @09:56AM (2 children)

    by janrinok (52) Subscriber Badge on Thursday December 30 2021, @09:56AM (#1208647) Journal

    The short answer is - No, not easily.

    If we actually delete them from the database then we are left with lots of dangling links to things such as comment IDs, story IDs etc. The database becomes corrupted. Your comment would also be invisible because it is linked to the thing you are asking us to delete!

    We can, and do, change the comment score so that you can easily filter out such stories on your display. However, for some reason, many in our community want to browse at -1 and see everything including things that other members have already identified as being useless and irrelevant (such as Spam).

    All other options require software changes and, as you already know, we no longer have a Perl programmer on the team.

    --
    I am not interested in knowing who people are or where they live. My interest starts and stops at our servers.
    Starting Score:    1  point
    Karma-Bonus Modifier   +1  

    Total Score:   2  
  • (Score: 2) by turgid on Thursday December 30 2021, @10:47AM (1 child)

    by turgid (4318) Subscriber Badge on Thursday December 30 2021, @10:47AM (#1208656) Journal

    I wish I could help but my Perl skills were 6 months about 15 years ago...

    Here's another idea. You could have a special -2 or similar for posts marked spam, and let users filter on that. I like to browse at -1 since sometimes there's grain of truth in what someone else considers troll or flamebait. Also, it's good to know what the loonies are "thinking" sometimes. That they so readily volunteer their opinions is very useful.

    • (Score: 3, Informative) by janrinok on Thursday December 30 2021, @03:04PM

      by janrinok (52) Subscriber Badge on Thursday December 30 2021, @03:04PM (#1208699) Journal

      I like the idea but my first response is that it would require a code change, albeit trivial. That would then necessitate a new build, test schedule, and release which none of the current staff have ever done. Let think on it....

      --
      I am not interested in knowing who people are or where they live. My interest starts and stops at our servers.