Stories
Slash Boxes
Comments

SoylentNews is people

SoylentNews is powered by your submissions, so send in your scoop. Only 14 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: 2) by janrinok on Sunday January 02 2022, @09:58AM (3 children)

    by janrinok (52) Subscriber Badge on Sunday January 02 2022, @09:58AM (#1209313) Journal

    I am a fucking AC, janrinok! I cannot send emails to the admin, since I have no account, no existence, no return address! Are you saying that this means my complaint about unfair spam modding counts for nothing?

    Don't lose your temper, it will not help persuade me to help you when I am able to do so. If you do not have an account at all - what gives you the right to dictate to those who are members how this site should be run?

    Please log in and send the email, or seek an outlet for your 'contribution' elsewhere. We cannot tell if your SPAM moderation is unfair if you do not tell us via email which moderations you are referring to, can we? If you are posting as AC how can we identify your particular comments? Anyone could claim that any AC posts are theirs. Indeed, I could be replying to your first ever post, couldn't I? Just create an email account and please do as we ask.

    AC's built SoylentNews, and we can bring it down, if you do not temper your Brit attitude!

    No actually they didn't build it, and no ACs without accounts have ever helped manage the site either. Account holders who post by name or as Anonymous Coward did, and still do, contribute considerably though. Some other ACs also contribute - but by no means all.

    And you think that threatening to 'bring the site down' is going to endear you further to the majority who contribute in giving their labour, financially or in intelligent discussion? In what way would bringing the site down serve you or the greater community? What makes you think that this site is yours if you haven't got an account and that you have the right to make such decisions? We started with nothing - I don't want to start again but If we had to, I think that we could. But there would probably to be rule changes if that were to happen.

    --
    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: -1, Troll) by Anonymous Coward on Monday January 03 2022, @05:54AM (2 children)

    by Anonymous Coward on Monday January 03 2022, @05:54AM (#1209486)

    I have seen how users with logged in accounts are treated.

    Don't lose your temper, it will not help persuade me to help you when I am able to do so. If you do not have an account at all - what gives you the right to dictate to those who are members how this site should be run?

    No right. No wrong, either, just pointing out that something is rotten in Denmark. I am trying to contribute, but it is obvious to everyone that SN desires no help, as it spirals down into a closed bubble of paranoia. No account != no dictating. You are at the mercy of the interwebs, janrinok!

    • (Score: 3, Informative) by janrinok on Monday January 03 2022, @02:09PM

      by janrinok (52) Subscriber Badge on Monday January 03 2022, @02:09PM (#1209515) Journal

      We serve the community first - that is how it should be.

      I didn't deny the AC assistance, but (s)he admitted having no account so will have to wait their turn. If the AC would like to report the moderation that concerns them via email as usual then we can look into it. This is not a new concept : "If you see moderation abuse [soylentnews.org] (mod bombing or spam mod), please mail the admin any comments (the cid link) showing the abuse."

      It seems that a very small number of our community think that coming up in the middle of a discussion to complain about moderation (which is ALWAYS off-topic) is the best way to intimidate the admin staff into reacting immediately. It isn't - being so sparsely manned means that we have to manage our contributions to the site to fit staff availability.

      Just follow the rules [soylentnews.org] please.

      --
      I am not interested in knowing who people are or where they live. My interest starts and stops at our servers.
    • (Score: 1) by khallow on Monday January 03 2022, @06:44PM

      by khallow (3766) Subscriber Badge on Monday January 03 2022, @06:44PM (#1209595) Journal

      I have seen how users with logged in accounts are treated.

      Sigh, so have I. This is a non-story.