The Diary Game 09/16/2022

Hi everyone!

And new day again! It's beautiful! A new beautiful day, new rays of the sun reach our houses, apartments, our skin. We can get excellent vitamin D only by being in the open space under the rays of the sun.

So, today I am focused on finalizing the system for checking the uniqueness of texts. For the other two bots, I've paid enough attention these days, and I'm posting regularly. So today I'm writing The Diary Game post and developing it.

What exactly needs to be done today. You need to re-enable access to the MySql server. Since I work via the mobile Internet (smartphone 3g), the IP address changes all the time, and I change access for MySql remote access.

Developing

I do this with the commands:

mysql
CREATE USER 'xxx'@'xxxxxxxx' IDENTIFIED BY 'xxxx';
grant all privileges on . to 'xxx'@'xxxx' with grant option;

And now I want to make a script that will analyze all tables with posts and select those authors who are 100% unique and add them to the Trusted Link, and then remove from this list those who have less than 80% at least once.

For this I need:

1. Make iteration of dates from a given range
2. Open table p20220x0x and iterate over all entries.
3. Analyze column percent for each record
4. Write to the table.
5. Do the same only with "less than 80%"
6. Deletion from the table.
7. After that, I can start the tag parsing job.

trust_on.js this script makes it possible to parse a p20220x0x format table.

addallposts.js this script allows you to parse all posts in Steemit by tag.

add100.js

//1
const mysql = require("mysql2");
const steem = require('steem');
const fs = require("fs");    
var settings = require('./config.js');

let body3R = '';
let num_day = settings.num_day;
let bd_name = settings.bd_name;
let hive_name = settings.hive_name;
let url_post = settings.url_post;
let url_ok = settings.url_ok;
let password_mysql = settings.password_mysql;
let user_mysql = settings.user_mysql;
let title_name = settings.title_name;
let image_list = settings.image_list;
let moderators_list = settings.moderators_list;
let wifkey = settings.wifkey;
let votey = settings.votey;

config = {
  host: "localhost",
  user: user_mysql,
  database: bd_name,
  password: password_mysql
}

const connection = mysql.createConnection(config);

num_day = num_day + 50;

var d = new Date(); // Today!
d.setDate(d.getDate()-num_day); // Yesterday!
d = d.toJSON().split("T")[0];
d = d.replace(/-/gi, '');
                
let mytable_p = 'p'+d;
// let mytable_p = 'p20211210';

let users; 

const sql = `SELECT * FROM ${mytable_p} ORDER BY length DESC`;

connection.query(sql,  function(err, results) 
    {
        if(err) console.log(err);
        
        console.log(results);
        len = results.length;
         for (yyy = 0; yyy < len; yyy++) 

            if ((users[yyy].length>50)&&(users[yyy].percent===999))
            {
                console.log('users[post_number])&&(users[post_number].length>50)&&(users[post_number].percent===999');   

            }
                else
                {
                    console.log('else');
                }
        });

Life

Yesterday morning I went on the standard way to the train and went to the house on it. There I was engaged in the development and writing of the post. And in the evening I went to meet with the company. We played board games and chatted.

We went to a new cafe called Crooked Pizza. And one of the girls from the company noticed that the picture in the cafe was hanging a little crooked. And she noticed this one, others did not pay attention.

It is also worth noting that the whole cafe was empty, only we were there.

love

Love for the world begins with love for yourself?

I wish you all love
Thank you for your attention
Have a nice day