#editorial | Logs for 2022-04-03
« return
[03:23:05] -!- AzumaHazuki [AzumaHazuki!~hazuki@the.end.of.time] has joined #editorial
[08:28:44] -!- AzumaHazuki has quit [Remote host closed the connection]
[09:08:45] -!- norayr [norayr!376bc34bfc@37.252.sq.ypj] has parted #editorial
[09:09:11] -!- norayr [norayr!376bc34bfc@37.252.sq.ypj] has joined #editorial
[09:09:48] -!- halibut has quit [Remote host closed the connection]
[10:10:03] -!- halibut [halibut!~halibut@CanHazVHOST/halibut] has joined #editorial
[12:25:24] -!- norayr [norayr!376bc34bfc@37.252.sq.ypj] has parted #editorial
[15:11:32] <janrinok> =submit https://www.sciencedaily.com
[15:11:36] <systemd> ✓ Sub-ccess! "03New Research Shows What It Takes to Make Society Change for the Better" (11p) -> https://soylentnews.org
[15:12:37] <janrinok> =submit https://www.sciencedaily.com
[15:12:40] <systemd> ✓* Sub-ccess! "08CRISPR and HIV: New Technique in Human Blood Unveils Potential Paths Toward Cure: Key to Possible HI" (19p) -> https://soylentnews.org
[15:16:54] <janrinok> =submit https://www.tomshardware.com
[15:16:56] <systemd> ✓ Sub-ccess! "03The Biggest Deal in Gaming is Under Fire From U.S. Senators" (8p) -> https://soylentnews.org
[15:17:58] <janrinok> =submit https://www.tomshardware.com
[15:18:00] <systemd> ✓ Sub-ccess! "03TSMC Will Reportedly Move Equipment Into Arizona's Fab21 in Q1 2023" (7p) -> https://soylentnews.org
[15:18:42] <janrinok> =submit https://www.tomshardware.com
[15:18:44] <systemd> ✓ Sub-ccess! "03Pimoroni Announces Servo 2040 Servo Motor Controller" (5p) -> https://soylentnews.org
[15:19:48] <janrinok> =submit https://www.sciencedaily.com
[15:19:51] <systemd> ✓* Sub-ccess! "08Monkeys Routinely Consume Fruit Containing Alcohol, Shedding Light on Our Own Taste for Booze: Study" (17p) -> https://soylentnews.org
[15:20:45] <janrinok> =submit https://www.sciencedaily.com
[15:20:48] <systemd> ✓ Sub-ccess! "03New Polymer Membrane Tech Improves Efficiency of CO2 Capture" (14p) -> https://soylentnews.org
[15:30:38] <janrinok> =submit https://www.sciencedaily.com
[15:30:41] <systemd> ✓ Sub-ccess! "03Polynesian Island Yields 'Treasure Trove' of Fungal Biodiversity" (16p) -> https://soylentnews.org
[15:32:54] <janrinok> =submit https://www.technology.org
[15:32:57] <systemd> ✓ Sub-ccess! "03Decoding Movement and Speech From the Brain of a Tetraplegic Person - Technology Org" (29p) -> https://soylentnews.org
[15:36:10] <Fnord666> 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 > '2022-01-01' ;
[15:36:10] <Fnord666> +---------+-------------+---------------------+-----------+---------------------+
[15:36:10] <Fnord666> | Net | GoalPercent | MAX(ts) | MAX(spid) | NOW() |
[15:36:10] <Fnord666> +---------+-------------+---------------------+-----------+---------------------+
[15:36:10] <Fnord666> | 1443.24 | 41.2354286 | 2022-04-02 10:44:55 | 1790 | 2022-04-03 15:35:37 |
[15:36:12] <Fnord666> +---------+-------------+---------------------+-----------+---------------------+
[15:36:14] <Fnord666> 1 row in set (0.01 sec)
[15:36:44] <Fnord666> That is the mysql query to get the current subscription goal status
[15:42:58] <janrinok> Thanks - but you need access to the db, which I haven't got at the moment.
[15:43:14] <Fnord666> yeah, that's an issue.
[15:43:33] <Fnord666> I've updated the funding goal information to the current state.
[15:49:06] <janrinok> Thanks
[15:51:42] <janrinok> Do you know how the information gets into the database so that you can extract it to process it. That is the html template that I need, well one of them. The other is the template/html that puts the data into to display it on the front page.
[15:56:28] <Fnord666> That I do not know. Magic? :)
[15:57:16] <Fnord666> The data that is displayed on the front page, in the Site News section, is manually updated by editing the block.
[15:57:56] <Fnord666> The process is to run the query then manually update the Site News block with the data.
[15:58:19] <Fnord666> I do not know why it's not done through code.
[15:58:38] <Fnord666> Seconding your stories now.
[16:01:19] <janrinok> and I am 2nding yours :D
[16:02:03] <janrinok> got to go and cook a meal - back in an hour or so
[16:02:12] <Fnord666> Enjoy!
[17:23:14] <janrinok> =submit https://arstechnica.com
[17:23:17] <systemd> ✓ Sub-ccess! "03Russia Inches Closer to its Splinternet Dream" (5p) -> https://soylentnews.org
[17:28:56] -!- AzumaHazuki [AzumaHazuki!~hazuki@the.end.of.time] has joined #editorial
[17:45:02] -!- AzumaHazuki has quit [Remote host closed the connection]
[21:13:11] -!- norayr [norayr!376bc34bfc@37.252.sq.ypj] has joined #editorial
[22:32:27] <Bytram> janrinok: Fnord666: primarily, data goes into the DB when a user subscribes.
[22:43:37] <Bytram> janrinok: Fnord666: Also, WayBackWhen I manually created a table that had ~1100 rows, one for each table/row in the DB. I thought I had sent a copy to each of you! Ping me and I will try to find another copy for you.