SoylentNews is people
SoylentNews
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.)
(Score: 0, Troll) by aristarchus on Sunday January 02 2022, @01:17AM (11 children)
Except, there is one tiny flaw in your plan to exile aristarchus: one of those posts was not me. I understand how it can be troubling to read posts that your ideology tells you are incorrect, but that is just part of being on the internets. Perhaps, instead of spam modding me, you ought to cease being such a snowflake?
(Score: 0) by Anonymous Coward on Sunday January 02 2022, @01:38AM (10 children)
Go report me to the admins. Give them the URLs of the comments and ask them to overturn the spam mods.
You and I both know that you posted both comments, and that you also posted as Frigatebird elsewhere in this thread. Drop the charade and stop insulting everyone's intelligence.
If you don't like the spam mod, take it up with the admins. Go convince them that I used the spam mod inappropriately. They can revert the spam mods and mod ban me if they deem it appropriate. Put up or shut up.
(Score: 0, Troll) by aristarchus on Sunday January 02 2022, @03:19AM (9 children)
Never thought I'd see janrinok resorting to posting AC!
The only way you could know this is if you were me, which I assume you are not, oh delightful AC, since if you were, I would know that. Who is insulting whose intelligence now? Or is that what this is, another covert aristarchus ploy for sympathy, spam modding himself much like Pisistratus of Athens did, to gain a majority vote?
http://classics.mit.edu/Herodotus/history.1.i.html [mit.edu]
(Score: 1) by khallow on Sunday January 02 2022, @04:38PM (5 children)
(Score: 1, Troll) by aristarchus on Sunday January 02 2022, @09:49PM (4 children)
If this type of behavior stands, you are next, khallow!
(Score: 0, Insightful) by Anonymous Coward on Monday January 03 2022, @05:31AM (1 child)
Just wanna say, I am not Ari, either! Don't spam mod me, Bro!!!
(Score: 0) by Anonymous Coward on Monday January 03 2022, @03:00PM
samefag
(Score: 1) by khallow on Monday January 03 2022, @06:36PM (1 child)
(Score: 2) by aristarchus on Monday January 03 2022, @08:57PM
Nobody on SN talks to themselves more than you, khallow! Once this vigilante AC figures out you are your own sockpuppet, you will be spam modded as well!
(Score: 2) by janrinok on Monday January 03 2022, @12:04PM (1 child)
I am not interested in knowing who people are or where they live. My interest starts and stops at our servers.
(Score: 2) by aristarchus on Monday January 03 2022, @09:04PM
Sure he did't! Wink, wink, nudge, nudge, say no more! Say no more!
(Score: 2) by Runaway1956 on Tuesday January 04 2022, @06:20PM
AC called it.
Khallow called it.
janrinok calls it.
I call it.
All of your posts, under whichever name(s) you choose to use are insults to intelligence.
If you insist on dying on this hill, then please, hurry up and die. You are the sock master of SN, and anyone with an IQ larger than his shoe size can see it. Which pretty much means every member of SN - this isn't the place that attracts idiots. Except you, of course.
A MAN Just Won a Gold Medal for Punching a Woman in the Face