#editorial | Logs for 2021-12-31
« return
[00:51:12] -!- inky has quit [Remote host closed the connection]
[00:53:39] -!- inky [inky!~inky@muomkxeyg34.medvideos-tor.org] has joined #editorial
[01:16:50] -!- inky has quit [Remote host closed the connection]
[01:18:32] -!- inky [inky!~inky@5.182.nom.qvx] has joined #editorial
[02:05:07] -!- inky has quit [Remote host closed the connection]
[03:40:59] <Bytram> have a great night everybody!
[05:19:11] -!- Subsentient has quit [Changing host]
[05:19:11] -!- Subsentient [Subsentient!~WhiteRat@the.end.of.time] has joined #editorial
[05:29:46] -!- spiraldancing has quit [Changing host]
[05:29:46] -!- spiraldancing [spiraldancing!~spiraldan@the.end.of.time] has joined #editorial
[05:29:46] -!- mode/#editorial [+v spiraldancing] by irc.sylnt.us
[05:29:46] -!- mode/#editorial [-v spiraldancing] by Hephaestus
[08:44:27] -!- inky [inky!~inky@45.153.xql.p] has joined #editorial
[08:50:09] -!- inky has quit [Remote host closed the connection]
[10:30:57] -!- inky [inky!~inky@5.183.vjn.umn] has joined #editorial
[10:33:07] <janrinok> Deleting https://soylentnews.org it is just advertising.
[10:33:08] <systemd> ^ 03windows reseller hosting: SoylentNews Submission
[11:12:02] <janrinok> =submit https://arstechnica.com
[11:12:07] <systemd> ✓ Sub-ccess! "03Researchers Built a Gecko-bot to Study How Geckos Glide and Crash Land" (14p) -> https://soylentnews.org
[11:12:52] <janrinok> =submit https://arstechnica.com
[11:12:53] <systemd> ✓ Sub-ccess! "03Children’s Hospitals are Filling Nationwide Amid Tidal Wave of Omicron" (9p) -> https://soylentnews.org
[12:34:35] -!- inky has quit [Remote host closed the connection]
[13:25:03] <Bytram> janrinok: agreed on deleting ( https://soylentnews.org )
[13:25:04] <systemd> ^ 03windows reseller hosting: SoylentNews Submission
[13:26:09] <janrinok> Bytram, well here we are again....
[13:26:51] <Bytram> LOL!
[13:27:28] <Bytram> Umm, please remind me... where ARE we going?
[13:27:39] <Bytram> =)
[13:27:52] <janrinok> in circles I think
[13:28:43] <janrinok> I remember several years ago 2 people taking it in turns to post stories for an extended period of time. Deja vu...
[13:28:52] <Bytram> =yt https://youtube.com
[13:28:53] <systemd> https://youtube.com - Billy Preston - Will It Go Round in Circles (04:30; 2,689,356 views; 👍21,604 👎[hidden by butthurt Google employees])
[13:29:32] <Bytram> yep!
[13:29:58] <Bytram> ISTR a stretch doing that with cmn32480
[13:30:11] * Bytram misses him
[13:30:13] <janrinok> yep, you did, and me with LamX
[13:37:36] <janrinok> Just advanced warning - I might not be contributing much on Monday - it is a special day for me and I 'think' I am guest of honour at a surprise party.
[13:38:45] <Bytram> thanks for the heads up... enjo!
[13:48:47] * Bytram 2nds https://soylentnews.org
[13:56:19] * Bytram 2nds https://soylentnews.org
[13:58:51] <Bytram> =cite http://dx.doi.org
[13:58:52] <systemd> <p><b>Journal Reference</b>:<br/><b>Please Wait... | Cloudflare</b>, <cite></cite> (DOI: <a href="https://doi.org/10.3390/bdcc5040056">10.3390/bdcc5040056</a>)</p>
[13:59:05] <Bytram> grr
[14:01:06] <janrinok> yeah - it annoyed me too
[14:08:35] <Bytram> needed to trim it for "fair use" :/ cite should be much better now =)
[14:08:43] <Bytram> teamwork++
[14:08:43] <Bender> karma - teamwork: 310
[14:10:35] * Bytram 2nds https://soylentnews.org
[14:25:45] * Bytram 2nds https://soylentnews.org
[14:29:36] * Bytram 2nds https://soylentnews.org
[14:31:55] <janrinok> I've taken more than 50% of the word count out of the Tesla story?
[14:32:42] * Bytram looks again
[14:33:38] <janrinok> if you want to delete more just leave the link in there and perhaps the first para
[14:35:38] <Bytram> yeah. It's not so simple as strict math. Nothing in the USA is! see: ( https://en.wikipedia.org )
[14:35:39] <systemd> ^ 03Fair use - Wikipedia ( https://en.wikipedia.org )
[14:37:04] <Bytram> warning: it's a long read
[14:41:46] <janrinok> I wont bother then
[14:52:25] <Bytram> about 5-10 minutes, for reading the works. Understanding and applying... that takes longer. I re-read it about yearly or so.
[14:52:40] <Bytram> break time
[14:53:59] <Bytram> janrinok++ thanks a LOT for pushing out those stories!
[14:53:59] <Bender> karma - janrinok: 122
[14:58:26] <janrinok> are you still in that Tesla story?
[15:12:50] <Bytram> sry! all clear -- just looked at the article
[15:16:45] <Bytram> 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' ;
[15:16:45] <Bytram> +---------+---------+---------------------+------+
[15:16:45] <Bytram> | Gross | Net | ts | SPID |
[15:16:45] <Bytram> +---------+---------+---------------------+------+
[15:16:45] <Bytram> | 6916.61 | 6611.75 | 2020-12-31 21:47:25 | 1744 |
[15:16:47] <Bytram> +---------+---------+---------------------+------+
[15:16:49] <Bytram> 1 row in set (0.01 sec)
[15:16:51] <Bytram> mysql>
[15:17:33] <janrinok> are you happy with it now?
[15:18:20] <Bytram> updating beg-o-meter ... please give me a few minutes
[15:22:23] -!- inky [inky!~inky@5.2.wm.wu] has joined #editorial
[15:23:48] <Bytram> mysql> SELECT SUM(payment_net) AS Net, 100.0 * SUM(payment_net) / 7000.00 AS GoalPercent, MAX(ts), MAX(spid), NOW() FROM subscribe_payments WHERE ts > '2020-12-31' ;
[15:23:48] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[15:23:48] <Bytram> | Net | GoalPercent | MAX(ts) | MAX(spid) | NOW() |
[15:23:48] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[15:23:48] <Bytram> | 6611.75 | 94.4535714 | 2021-12-30 17:36:36 | 1744 | 2021-12-31 15:21:49 |
[15:23:49] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[15:23:51] <Bytram> 1 row in set (0.01 sec)
[15:23:53] <Bytram> mysql>
[15:28:45] <Bytram> mysql> select ts, spid, payment_gross, payment_net from subscribe_payments where ts >= '2020-12-30' and ts <= '2021-01-02' order by ts ;
[15:28:45] <Bytram> +---------------------+------+---------------+-------------+
[15:28:45] <Bytram> | ts | spid | payment_gross | payment_net |
[15:28:45] <Bytram> +---------------------+------+---------------+-------------+
[15:28:45] <Bytram> | 2020-12-30 20:49:15 | 1502 | 20.00 | 19.12 |
[15:28:47] <Bytram> | 2020-12-31 17:43:53 | 1503 | 20.00 | 18.82 |
[15:28:49] <Bytram> | 2020-12-31 21:47:25 | 1504 | 20.00 | 18.82 |
[15:28:51] <Bytram> | 2020-12-31 22:01:40 | 1505 | 105.00 | 101.65 |
[15:28:53] <Bytram> | 2020-12-31 22:19:27 | 1506 | 20.00 | 19.12 |
[15:28:55] <Bytram> | 2020-12-31 22:19:59 | 1507 | 30.00 | 28.38 |
[15:28:57] <Bytram> | 2020-12-31 23:00:06 | 1508 | 5.00 | 4.55 |
[15:28:59] <Bytram> | 2021-01-01 06:28:29 | 1509 | 20.00 | 18.82 |
[15:29:01] <Bytram> | 2021-01-01 07:24:47 | 1510 | 25.00 | 23.97 |
[15:29:05] <Bytram> | 2021-01-01 16:54:27 | 1511 | 20.00 | 18.82 |
[15:29:07] <Bytram> | 2021-01-01 22:19:09 | 1512 | 200.00 | 193.90 |
[15:29:09] <Bytram> | 2021-01-01 23:26:55 | 1513 | 20.00 | 19.12 |
[15:29:11] <Bytram> +---------------------+------+---------------+-------------+
[15:29:13] <Bytram> 12 rows in set (0.00 sec)
[15:29:15] <Bytram> mysql>
[15:32:07] <Bytram> ?????
[15:32:18] <Bytram> mysql> SELECT SUM(payment_net) AS Net, ( 100.0 * SUM(payment_net) ) / 7000.00 AS GoalPercent, MAX(ts), MAX(spid), NOW() FROM subscribe_payments WHERE spid >= 1609 ;
[15:32:18] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[15:32:18] <Bytram> | Net | GoalPercent | MAX(ts) | MAX(spid) | NOW() |
[15:32:18] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[15:32:18] <Bytram> | 3859.81 | 55.1401429 | 2021-12-30 17:36:36 | 1744 | 2021-12-31 15:31:16 |
[15:32:20] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[15:32:22] <Bytram> 1 row in set (0.00 sec)
[15:32:24] <Bytram> mysql>
[15:33:24] * Bytram scratches head
[15:37:28] <Bytram> janrinok: Much better! I wonder if we have any Tesla owners in the community, or how much this info will impact a (pending) purchase decision?
[15:37:48] <Bytram> maybe add something like that to the story?
[15:38:40] * Bytram is out of the story
[15:39:28] <Bytram> ahhh!
[15:41:08] <Bytram> Better:
[15:41:14] <Bytram> mysql> SELECT SUM(payment_net) AS Net, ( 100.0 * SUM(payment_net) ) / 7000.00 AS GoalPercent, MAX(ts), MAX(spid), NOW() FROM subscribe_payments WHERE spid >= 1509 ;
[15:41:14] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[15:41:14] <Bytram> | Net | GoalPercent | MAX(ts) | MAX(spid) | NOW() |
[15:41:14] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[15:41:14] <Bytram> | 6401.29 | 91.4470000 | 2021-12-30 17:36:36 | 1744 | 2021-12-31 15:39:45 |
[15:41:16] <Bytram> +---------+-------------+---------------------+-----------+---------------------+
[15:41:18] <Bytram> 1 row in set (0.00 sec)
[15:41:20] <Bytram> mysql>
[15:43:28] <Bytram> ===========
[15:43:32] <Bytram> 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' ;
[15:43:32] <Bytram> +---------+---------+---------------------+------+
[15:43:36] <Bytram> | Gross | Net | ts | SPID |
[15:43:38] <Bytram> +---------+---------+---------------------+------+
[15:43:40] <Bytram> | 6916.61 | 6611.75 | 2020-12-31 21:47:25 | 1744 |
[15:43:42] <Bytram> +---------+---------+---------------------+------+
[15:43:44] <Bytram> 1 row in set (0.00 sec)
[15:43:46] <Bytram> mysql>
[15:46:10] <Bytram> my brain hurts. I know I'm missing something obvious, but just can't see it!
[15:46:17] <Bytram> taking a break
[16:10:02] -!- inky has quit [Remote host closed the connection]
[16:10:57] -!- inky [inky!~inky@95.141.qw.vq] has joined #editorial
[16:12:00] -!- inky has quit [Remote host closed the connection]
[16:14:49] <Bytram> https://soylentnews.org
[16:14:50] <systemd> ^ 03SoylentNews Comments | Happy New Year! We Did It! (I Think) -- Fundraising Update 2021-12-30 ( https://soylentnews.org )
[16:15:21] <Bytram> It's fixed, I think.
[16:15:30] <Bytram> gtg; laters!
[16:21:26] -!- inky [inky!~inky@92.246.py.hvk] has joined #editorial
[17:43:30] -!- inky has quit [Remote host closed the connection]
[22:07:15] <Bytram> janrinok: Congratulations for posting the very first story of 2022 (UTC)