Stories
Slash Boxes
Comments

SoylentNews is people

SoylentNews is powered by your submissions, so send in your scoop. Only 13 submissions in the queue.
Meta
posted by martyb on Friday December 31 2021, @12:02AM   Printer-friendly
from the Woo-Hoo! dept.

Happy New Year!
As the final hours of 2021 here's wishing everyone a Happy New Year!

In light of the holiday, I am inviting the editorial staff to post stories on a weekend/holiday schedule. Thank you for all your hard work in 2021. Here's wishing for a better year to come! Enjoy!

We did it! [*]
([*] I think).

Current Status:
Thanks to a VERY generous subscription of nearly $1,000, we reached our fundraising goal for the second half of the year THANK YOU!: $4,132.81 on a goal of $3,500.00 (all amounts are estimates):

mysql>  SELECT  SUM(payment_net) AS Net,  100.0 * SUM(payment_net) / 3500.00  AS GoalPercent, MAX(ts), MAX(spid), NOW() FROM subscribe_payments WHERE ts > '2021-06-30' ;
+---------+-------------+---------------------+-----------+---------------------+
| Net     | GoalPercent | MAX(ts)             | MAX(spid) | NOW()               |
+---------+-------------+---------------------+-----------+---------------------+
| 4132.81 | 118.0802857 | 2021-12-30 17:36:36 |      1744 | 2021-12-30 23:45:49 |
+---------+-------------+---------------------+-----------+---------------------+
1 row in set (0.00 sec)

mysql>

And for those of you interested in the details:

mysql> SELECT spid, ts, payment_gross, payment_net, payment_type FROM subscribe_payments WHERE ts > '2021-12-29 22:06:03' AND payment_gross > 0 ORDER BY ts ;
+------+---------------------+---------------+-------------+--------------+
| spid | ts                  | payment_gross | payment_net | payment_type |
+------+---------------------+---------------+-------------+--------------+
| 1728 | 2021-12-29 23:16:21 |         20.00 |       18.81 | user         |
| 1729 | 2021-12-30 00:15:05 |        100.00 |       96.80 | user         |
| 1730 | 2021-12-30 01:08:02 |         20.00 |       19.12 | user         |
| 1731 | 2021-12-30 01:13:58 |         30.00 |       28.01 | user         |
| 1732 | 2021-12-30 01:45:50 |         50.00 |       48.25 | user         |
| 1733 | 2021-12-30 02:35:54 |         40.00 |       38.54 | user         |
| 1734 | 2021-12-30 03:12:48 |         20.00 |       18.81 | user         |
| 1735 | 2021-12-30 04:24:07 |        924.43 |      897.32 | user         |
| 1736 | 2021-12-30 07:05:37 |         20.00 |       18.51 | user         |
| 1737 | 2021-12-30 07:50:05 |         20.00 |       18.51 | gift         |
| 1738 | 2021-12-30 09:23:14 |         20.00 |       19.12 | gift         |
| 1739 | 2021-12-30 12:22:42 |         20.00 |       18.51 | user         |
| 1740 | 2021-12-30 12:24:24 |         20.00 |       18.81 | user         |
| 1741 | 2021-12-30 13:59:52 |         40.00 |       38.11 | user         |
| 1742 | 2021-12-30 17:33:36 |         20.00 |       19.12 | gift         |
| 1743 | 2021-12-30 17:35:13 |         20.00 |       19.12 | gift         |
| 1744 | 2021-12-30 17:36:36 |         20.00 |       19.12 | gift         |
+------+---------------------+---------------+-------------+--------------+
17 rows in set (0.00 sec)

mysql>

That's great news! So why the equivocation?

Looking Closer:
Actually, it's more of a stepping back to look at things over the course of the entire year:

mysql> SELECT SUM(payment_gross) AS Gross, SUM(payment_net) AS Net, ts, max(spid) AS SPID FROM subscribe_payments WHERE ts > '2020-12-31' ;
+---------+---------+---------------------+------+
| Gross   | Net     | ts                  | SPID |
+---------+---------+---------------------+------+
| 6916.61 | 6611.75 | 2020-12-31 21:47:25 | 1744 |
+---------+---------+---------------------+------+
1 row in set (0.00 sec)

mysql>

The fundraising goal for the first half of the year was also $3,500.00. So... (2 x $3,500.00) is $7,000.00 but we have a total of... $6,916.61?

The Crash:
And then I remembered. Early this year we had a server (fluorine) crash. We had backups (yay!), but they were borken (Boo! Hiss!). We lost over a day's worth of activity, including a number of subscriptions. I *was* able to manually reconstruct people's subscriptions (time) based on information displayed on a window I just happened to have open at the time. But that was in a table separate from what is used to generate these numbers. After 3 days' effort, I'd patched things up as well as I could. Thankfully the official numbers (on which income and taxes are calculated) are kept on a completely separate server. Whew! One that I DO NOT have access. I'd concluded that we'll just have to sort things out at the end of the year. And that time has draw nigh.

tl;dr:
We're probably all set for the year, but there is also the matter that (unknown to me) we had previously been running at a deficit for a couple years. So anything additional you can contribute will go to replenish our funding base. (NCommander and Matt_ each put up $5,000.00 of their own money that to get us started.)

 
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: 0, Troll) by aristarchus on Tuesday January 04 2022, @07:20AM (8 children)

    by aristarchus (2645) on Tuesday January 04 2022, @07:20AM (#1209726) Journal

    You poor, poor AC! Refugee from the world of real, are we? You expect people on line to be who they say they are? You think that the White supremacists behind janrinok and Runaway are on the level? Do you know what it is you are carrying? Your protests are as farts in the wind, mere hemo objections, a conservative screen with no substance, a paper tiger, if you will. You do not understand me, if you think I am the hypocrite. But then, I have come to expect such stupidity from my opponents on SN. You would rather I just go away, instead of persistently pointing out the bankruptcy of your worldview. I pity you. Spam away, AC!

      (Oh wait, ACs cannot mod, so you are an actual user, too cowardly to Spam mod the Mighty Aristarchus to his face? Thought as much. Coward.)

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

    Total Score:   0  
  • (Score: 3, Informative) by Azuma Hazuki on Tuesday January 04 2022, @07:41AM (7 children)

    by Azuma Hazuki (5086) on Tuesday January 04 2022, @07:41AM (#1209728) Journal

    This is fucking dumb. You make some big threats, so let's see you follow through with them. I personally have no problem with you taking SN down if you're actually capable of that, but I doubt you are. And I'm getting really, really tired of your stupidity. Put up or shut up.

    --
    I am "that girl" your mother warned you about...
    • (Score: 0, Flamebait) by aristarchus on Tuesday January 04 2022, @07:44AM (6 children)

      by aristarchus (2645) on Tuesday January 04 2022, @07:44AM (#1209729) Journal

      Shirley, 'Zumi, you of all soylentils realize it has already happened, Just check the comment count. Dead, really dead. And an attempt to discuss actual issues ends up with Runaway comments. Dead.

      • (Score: 2) by Azuma Hazuki on Tuesday January 04 2022, @07:49AM (5 children)

        by Azuma Hazuki (5086) on Tuesday January 04 2022, @07:49AM (#1209730) Journal

        Nope. You said you can take SN down. Go ahead and do it.

        --
        I am "that girl" your mother warned you about...
        • (Score: 1, Troll) by aristarchus on Tuesday January 04 2022, @07:53AM (4 children)

          by aristarchus (2645) on Tuesday January 04 2022, @07:53AM (#1209731) Journal

          Missing my point, my dear Hazuki; it already is down, just doesn't know it yet.

          • (Score: 2) by Azuma Hazuki on Tuesday January 04 2022, @07:54AM (2 children)

            by Azuma Hazuki (5086) on Tuesday January 04 2022, @07:54AM (#1209732) Journal

            Do it, or forever quit threatening to do it. I am so sick of your bullshit. Go on, drop the dox and bring down the hammer of the law. I dare you. I dare you to follow through on your threats.

            --
            I am "that girl" your mother warned you about...
            • (Score: 1, Troll) by aristarchus on Tuesday January 04 2022, @08:53AM (1 child)

              by aristarchus (2645) on Tuesday January 04 2022, @08:53AM (#1209739) Journal

              Perhaps you missed the real drama that attended to the departure of the Buzzard? One who could threatened to pull the plug. Wasn't me. I am just a pawn, or lowly philosopher, in the game of SN.

              • (Score: 3, Informative) by Azuma Hazuki on Tuesday January 04 2022, @05:17PM

                by Azuma Hazuki (5086) on Tuesday January 04 2022, @05:17PM (#1209843) Journal

                Then stop making threats. Don't write checks your ass (which people are saying is prehensile now...?) can't cash.

                --
                I am "that girl" your mother warned you about...
          • (Score: 0) by Anonymous Coward on Tuesday January 04 2022, @06:34PM

            by Anonymous Coward on Tuesday January 04 2022, @06:34PM (#1209863)

            Missing my point ....

            If you had a point, you could have made it years ago. Give it up, fool, your existence is pointless.