The Diary Game 09/16/2022

in CCS2 years ago

THE DIARY GAME 0916.png

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.

photo_2022-09-15_19-50-59.jpg

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.

photo_2022-09-15_21-57-36.jpg

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');
                }
        });

photo_2022-09-15_23-36-47.jpg

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.

photo_2022-09-16_12-05-42.jpg

love

Love for the world begins with love for yourself?

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

Sort:  

Upvoted! Thank you for supporting witness @jswit.

Congratulations, your post has been upvoted by @campingclub Community Curation Trail. Many Thanks for Witness Vote! Best Regards Camping Club Steemit Community on Steem With that in mind, happy blogging
CCS
Manually curated by @visionaer3003
https://steemlogin.com/sign/account-witness-vote?witness=visionaer3003&approve=1
https://steemitwallet.com/~witnesses

Omg I just don't understand anything about numbers or programming parafernalia I must be honest on that. Actually the markdown process has been a headache for me since the beginning 🤭. I really appreciate the beautiful outdoors pictures my God, lovely.

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.

OK I didn't understand this, 'till I read this:

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.

Thankyou for the tag! 😅. This that's the only way I can understand. And congrats man You have been doing such a meticulous work.

Uhm...

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.

Perfeccionist maybe?

I asume you're the tea team for the first picture. I was expecting a review about the coffe itself, but I I love coffe. Thank you for wishing us all love, I wish you love too

 2 years ago 

You're busy today yet you still have time for yourself. Enjoy your weekend.

 2 years ago 

Looks like the programming stuff is progressing.
Meanwhile, the name of the cafe sounds quite odd
Hehe

Hi Alex, I lovely cup of tea? Coffee? I don't understand very well 🤒 You know I was born in the country. I my childhood memories are fantastic. I got that feeling again every time I saw your pictures of your house. I personally drink a lot of tea, but my real love is coffee. I don't understand the thing about the bot I'm from another generation 😅. Is always lovely to read you.