The Word Game💎 All NodeJs Scripts Actual.
In this post, all the scripts that generate the rating. Requires nodes and muscle.
On purpose, I post all the scripts here so that everyone can create the entire rating or part of it. If you need help setting up and installing this script, please contact me and I will provide you with all possible assistance.
And also not to lose these scripts, and not to lose them.
For convenient launching, I use a scheduler Task Till Down.
addcom
const fs = require("fs");
const steem = require('steem');
let input, hive, fullbody, x1;
var author,author2;
var permlinkR;
var err;
let stat, stat2;
let num_day = 1;
var d = new Date(); // Today!
d.setDate(d.getDate()-num_day); // Yesterday!
d = d.toJSON().split("T")[0];
d = d.replace(/-/gi, '');
console.log(d);
let mytable_p = 'p'+d;
let mytable_c = 'c'+d;
let mytable = 'a'+d;
//let array = fs.readFileSync('spisok.txt').toString().split("\n");
//let test_a = array[0].split(' ');
const mysql = require("mysql2");
const sql = `SELECT * FROM spisok`;
//const sql = `SELECT * FROM p0111 ORDER BY length DESC`;
// console.log(sql);
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
connection.query(sql, function(err, results) {
if(err) console.log(err);
console.log(results);
let test_a = results;
// console.log(results[2]['author']);
len1 = test_a.length;
for (x1 = 10; x1 < len1; x1++) {
steem.api.getDiscussionsByComments({
"start_author": test_a[x1]['author'],
// "start_author": 'allfabeta',
"limit": 100
}, function (err, result) {
console.log(err, result);
if (err === null) {
stat = 0;
console.log(x1);
// console.log(test_a[x1]['author']);
var i, len = result.length;
for (i = 0; i < len; i++) {
var discussion = result[i];
var d = new Date(); // Today!
d.setDate(d.getDate() - num_day); // Yesterday!
d = d.toJSON().split("T")[0];
permlinkR = discussion.permlink;
author = discussion.author;
author2 = author;
input = discussion.created;
hive = discussion.category;
if ((input.indexOf(d) !== -1) && (hive === 'hive-171319')) {
stat=stat+1;
stat2 = stat;
fullbody = fullbody + ' ' + discussion.body;
}}
const mysql = require("mysql2");
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
connection.on('error', function() {});
let sql22 = `create table if not exists ${mytable_c}(
id int primary key auto_increment,
author varchar(255) not null,
count int not null,
points float not null
)`;
connection.query(sql22, function(err, results) {
if(err) console.log(err);
console.log(results);
});
const sql = `INSERT INTO ${mytable_c}(author, count,points) VALUES('${author}', '${stat}','0')`;
connection.query(sql, function(err, results) {
if(err) console.log(err);
console.log(results);
});
connection.end();
console.log('68 строка');
console.log(stat,author);
} else {
console.log('внимание поломка поломка поломка поломка');
}}
);
}
});
addpost
const fs = require("fs");
const steem = require('steem');
let body3R = '';
//let accounts = fs.readFileSync('spisok.txt').toString().split(" ");
//console.log(accounts);
accounts = 0;
let num_day = 1;
var d = new Date(); // Today!
d.setDate(d.getDate()-num_day); // Yesterday!
d = d.toJSON().split("T")[0];
d = d.replace(/-/gi, '');
console.log(d);
let mytable_p = 'p'+d;
let mytable_c = 'c'+d;
let mytable = 'a'+d;
//accounts.forEach(function (element,i,array){
const mysql = require("mysql2");
const sql = `SELECT * FROM spisok`;
//const sql = `SELECT * FROM p0111 ORDER BY length DESC`;
// console.log(sql);
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
connection.query(sql, function(err, results) {
if(err) console.log(err);
console.log(results[2]['author']);
users = results;
accounts = users;
console.log(accounts);
len = accounts.length;
for (yyy = 0; yyy < len; yyy++)
{
console.log('yyy');
console.log(yyy);
steem.api.getDiscussionsByAuthorBeforeDate(accounts[yyy]['author'],null, new Date().toISOString().split('.')[0],20 , function(err, result) {
// console.log(result);
var i, len = result.length;
for (i = 0; i < len; i++)
{
var raw = result[i];
console.log('Автор');
console.log(raw.author);
console.log('Заголовок');
console.log(raw.author);
console.log('Сообщество');
console.log(raw.category);
console.log('Длина поста');
console.log(raw.body_length);
console.log('Количество ожидаемого вознаграждения');
console.log(raw.pending_payout_value);
console.log('Количество комментариев');
console.log(raw.replies.length);
console.log('Количество upvote');
let upvote = raw.active_votes.length-1;
console.log(raw.active_votes.length-1);
console.log('Дата создания');
console.log(raw.created);
let input = raw.created;
var d = new Date(); // Today!
d.setDate(d.getDate() - num_day); // Yesterday!
d = d.toJSON().split("T")[0];
let title = raw.title;
title = title.replace(/[^a-zа-яё0-9\s]/gi, ' ');
if ((input.indexOf(d) !== -1)&& (raw.category === 'hive-171319'))
{
body3R = `| `+raw.author + `| <a href="`+raw.url+`">` + title + `</a>| `+ upvote + `| ` + `????` + `| ` + raw.children+`| ` + raw.body_length+ ' | \n';
console.log(body3R);
const mysql = require("mysql2");
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
connection.on('error', function() {});
let sql44 = `create table if not exists ${mytable_p}(
id int primary key auto_increment,
author varchar(255) not null,
created varchar(255) not null,
length int not null,
url varchar(255) not null,
comments int not null,
upvotes int not null,
points float not null)`;
connection.query(sql44, function(err, results) {
if(err) console.log(err);
console.log(results);
});
const sql = `INSERT INTO ${mytable_p}(author, created, length, url, comments, upvotes, points) VALUES('${raw.author}', '${raw.created}', '${raw.body_length}', '${raw.url}', '${raw.children}', '${upvote}','0')`;
connection.query(sql, function(err, results) {
if(err) console.log(err);
console.log(results);
});
connection.end();
console.log(raw.created);
fs.appendFileSync("rank.txt",body3R);
}
}
});
}
});
create
//(поменять название таблицы)
//Создать пост в стимите.
let date_know;
const mysql = require("mysql2");
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
let num_day = 1;
var d = new Date(); // Today!
d.setDate(d.getDate()-num_day); // Yesterday!
d = d.toJSON().split("T")[0];
d = d.replace(/-/gi, '');
console.log(d);
let mytable_p = 'p'+d;
let mytable_c = 'c'+d;
let mytable = 'a'+d;
let sql = `create table if not exists ${mytable_p}(
id int primary key auto_increment,
author varchar(255) not null,
created varchar(255) not null,
length int not null,
url varchar(255) UNIQUE KEY,
comments int not null,
upvotes int not null,
points float not null)`;
let sql2 = `create table if not exists ${mytable_c}(
id int primary key auto_increment,
author varchar(255) UNIQUE KEY,
count int not null,
points float not null
)`;
let sql3 = `create table if not exists ${mytable}(
id int primary key auto_increment,
author varchar(255) UNIQUE KEY,
comments float not null,
posts float not null,
points float not null
)`;
console.log(sql);
connection.query(sql, function(err, results) {
if(err) console.log(err);
else console.log("Таблица создана");
});
connection.query(sql2, function(err, results) {
if(err) console.log(err);
else console.log("Таблица создана");
});
connection.query(sql3, function(err, results) {
if(err) console.log(err);
else console.log("Таблица создана");
});
connection.end();
create_day
const mysql = require("mysql2");
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
let num_day = 1;
var d = new Date(); // Today!
d.setDate(d.getDate()-num_day); // Yesterday!
d = d.toJSON().split("T")[0];
d = d.replace(/-/gi, '');
console.log(d);
let mytable_p = 'p'+d;
let mytable_c = 'c'+d;
let mytable = 'a'+d;
const sql = `SELECT * FROM spisok` ;
console.log(sql);
connection.query(sql, function(err, results) {
if(err) console.log(err);
const users = results;
console.log(users);
console.log(users.length);
console.log(users.length);
console.log(users.length);
console.log(users.length);
console.log(users.length);
for(let i=0; i < users.length; i++){
let author = users[i].author;
const sql4 = `INSERT INTO ${mytable}(author, comments, posts, points) VALUES('${author}', '0','0','0')`;
console.log(sql4);
connection.query(sql4,function(err, results) {
if(err) console.log(err); });
}
});
create_spisok
//CREATE DATABASE [IF NOT EXISTS] имя_базы_даных;
const mysql = require("mysql2");
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
let mytable_p = 'posts01';
let mytable_c = 'c1711';
let mytable_day = 'a1711';
let sql = `create table if not exists spisok( id int primary key auto_increment, author varchar(255) UNIQUE KEY)`;
//let sql = `create table if not exists post_number( id int primary key auto_increment, number int)`;
connection.query(sql, function(err, results) {
if(err) console.log(err);
else console.log("Таблица создана");
});
connection.end();
fulllist
const mysql = require("mysql2");
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
let num_day = 1;
let formula;
var d = new Date(); // Today!
d.setDate(d.getDate()-num_day); // Yesterday!
d = d.toJSON().split("T")[0];
d = d.replace(/-/gi, '');
let mytable = 'a'+d;
console.log(mytable);
let full = `
Спасибо Лютику за иллюстрацию. Thanks to Luke for the illustration.
Лидер рейтинга (Rating leader):
Пост для вознаграждения (Reward post):
Thank you for your activity! The leader of the rating receives a reward in the form of upvotes of the entire rating support team. The description of the command is below. I invite you to join the team. Every cent and every upvote counts!
Благодарим за активность! Лидер рейтинга получает вознаграждение в виде апвоутов всей команды поддержки рейтинга. Описание команды ниже по ссылке. Приглашаю присоединиться к команде. Важен каждый цент и каждый апвоут!
<h2>Рейтинг за день </h2>
|N|аккаунт|баллы за комментарии|баллы за посты|общий балл за день|
------------|-------------|------------|-------------|---------|`;
const fs = require("fs");
fs.appendFileSync("report"+d+".txt",full);
const sql = `SELECT * FROM ${mytable} ORDER BY points DESC` ;
console.log(sql);
connection.query(sql, function(err, results) {
if(err) console.log(err);
const users = results;
console.log(users);
for(let i=0; i < users.length; i++){
let notfull;
var d = new Date(); // Today!
d.setDate(d.getDate()-num_day); // Yesterday!
d = d.toJSON().split("T")[0];
d = d.replace(/-/gi, '');
// title = users[i].title.replace(/[^a-zа-яё0-9\s]/gi, ' ');
console.log('|',i+1,'|',users[i].author,'|',users[i].comments,'|',users[i].posts,'|',users[i].points,'|');
let z = Number(i + 1);
notfull = '\n|'+z+'|'+users[i].author+'|'+users[i].comments+'|'+users[i].posts +'|'+users[i].points+'|';
const fs = require("fs");
fs.appendFileSync("report"+d+".txt",notfull);
// console.log(notfull);
}
// console.log('|',i+1,'|',users[i].author,'|','<a href="'+ users[i].url+'">' + title + '</a>','|', users[i].comments,'|', users[i].length,'|');
// + '\n|'+i+1+'|'+users[i].author+'|'+'<a href="'+ users[i].url+'">' + title + '</a>'+'|'+ users[i].comments+'|'+ users[i].length+'|\n'
//console.log(notfull);
full = `
Что такое рейтинг The Word Game. Как это работает. И почему это хорошо:
https://steemit.com/hive-171319/@alexmove/chto-takoe-reiting-the-word-game-kak-eto-rabotaet-i-pochemu-eto-khorosho
What is the rating of The Word Game. How it works. And why is it good:
https://steemit.com/hive-171319/@alexmove/what-is-the-rating-of-the-word-game-how-it-works-and-why-is-it-good
Приглашение присоединиться к команде вознаграждения лидера рейтинга (Welcome to the ranking leader reward team):
https://steemit.com/hive-171319/@alexmove/the-word-game-rewards-for-the-leader-of-the-daily-rating-of-the-word-game-i-invite-you-to-join-support-priglashayu
Спасибо за внимание!
`
const fs = require("fs");
fs.appendFileSync("report"+d+".txt",full);
});
connection.end();
fulllistpost
const mysql = require("mysql2");
const steem = require('steem');
const fs = require("fs");
let num_day = 1;
let wifkey = 'xxxxx';
let votey = "alexmove";
//for (var yyy = 0; yyy < 2; yyy++)
var d = new Date(); // Today!
d.setDate(d.getDate()-num_day); // Yesterday!
d = d.toJSON().split("T")[0];
d = d.replace(/-/gi, '');
let accounts = fs.readFileSync('report'+d+'.txt').toString();
//accounts = accounts.replace(/\n\n/gi, '\n');
console.log(accounts);
let permlink = new Date().toISOString().replace(/[^a-zA-Z0-9]+/g, '').toLowerCase();
console.log(permlink);
let title = "The Word Game💎 "+d+" Daily Rating. With Reward!";
steem.broadcast.comment(
wifkey, // Your posting wif
'', // Parent Author
//'hive-171319', // Parent Permlink
'alexmove', // Parent Permlink
votey,
permlink, // Your post permlink
title, // Title
accounts, // Body
{ tags: ['steem','club5050','steemit','ukraine','js','games'], app: 'ganeshaway' }, // Json Metadata
function(err, result) {
console.log(err, result)});
listall
const mysql = require("mysql2");
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "thewordgame",
password: "xxxxxx"
});
let formula;
let mytable = 'c1810';
let mytable_day = 'a1810';
const sql = `SELECT * FROM authors ORDER BY points DESC` ;
connection.query(sql, function(err, results) {
if(err) console.log(err);
const users = results;
for(let i=0; i < users.length; i++){
if (users[i].count>0) {
formula = (users.length - i)/10;
// console.log(users[i].count);
} else { formula = 0;
// console.log('sdfsdfs');
}
console.log('|',i+1,'|',users[i].name,'|',users[i].points,'|');
}
});
connection.end();```
<h2> listday</h2>
const mysql = require("mysql2");
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
let formula;
var d = new Date(); // Today!
d.setDate(d.getDate()-1); // Yesterday!
d = d.toJSON().split("T")[0];
d = d.replace(/-/gi, '');
console.log(d);
let mytable_p = 'p'+d;
let mytable_c = 'c'+d;
let mytable = 'a'+d;
const sql = SELECT * FROM ${mytable} ORDER BY points DESC ;
connection.query(sql, function(err, results) {
if(err) console.log(err);
const users = results;
for(let i=0; i < users.length; i++){
if (users[i].count>0) {
formula = (users.length - i)/10;
// console.log(users[i].count);
} else { formula = 0;
// console.log('sdfsdfs');
}
console.log('|',i+1,'|',users[i].author,'|',users[i].comments,'|',users[i].posts ,'|',users[i].points,'|');
}
});
connection.end();
<h2> packade</h2>
{
"dependencies": {
"mysql2": "^2.3.3",
"steem": "^0.7.11"
}
}
<h2> save </h2>
const mysql = require("mysql2");
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "thewordgame",
password: "xxxxxx"
});
let mytable_day = 'a1810';
const sql = SELECT * FROM ${mytable_day} ORDER BY points DESC ;
connection.query(sql, function(err, results) {
if(err) console.log(err);
const users = results;
console.log(users);
for(let i=0; i < users.length; i++){
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "thewordgame",
password: "xxxxxx"
});
let author = users[i].author;
sql3 = `UPDATE authors SET points=points+'${users[i].points}' WHERE name='${author}' LIMIT 1000`;
console.log (sql3);
connection.query(sql3,function(err, results) {
if(err) console.log(err);
});
connection.end();
}
});
connection.end();
<h2> sort </h2>
const fs = require("fs");
const steem = require('steem');
let input, hive, fullbody, x1;
var author,author2;
var permlinkR;
var err;
let stat, stat2;
let mytable = 'c1810';
let array = fs.readFileSync('spisok.txt').toString().split("\n");
let test_a = array[0].split(' ');
console.log(test_a[2]);
len1 = test_a.length;
for (x1 = 0; x1 < len1; x1++) {
steem.api.getDiscussionsByComments({
"start_author": test_a[x1],
"limit": 100
}, function (err, result) {
// console.log(err, result);
if (err === null) {
stat = 0;
console.log('asdasdasdas');
var i, len = result.length;
for (i = 0; i < len; i++) {
var discussion = result[i];
var d = new Date(); // Today!
d.setDate(d.getDate() - 1); // Yesterday!
d = d.toJSON().split("T")[0];
permlinkR = discussion.permlink;
author = discussion.author;
author2 = author;
input = discussion.created;
hive = discussion.category;
if ((input.indexOf(d) !== -1) && (hive === 'hive-171319')) {
stat=stat+1;
stat2 = stat;
fullbody = fullbody + ' ' + discussion.body;
}}
const mysql = require("mysql2");
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "thewordgame",
password: "xxxxxx"
});
connection.on('error', function() {});
const sql = `INSERT INTO ${mytable}(author, count,points) VALUES('${author}', '${stat}','0')`;
connection.query(sql, function(err, results) {
if(err) console.log(err);
console.log(results);
});
connection.end();
console.log('68 строка');
console.log(stat,author);
} else {
console.log('внимание поломка поломка поломка поломка');
}}
);
}
<h2> sortcom </h2>
const mysql = require("mysql2");
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
let num_day = 1;
let formula;
var d = new Date(); // Today!
d.setDate(d.getDate()-num_day); // Yesterday!
d = d.toJSON().split("T")[0];
d = d.replace(/-/gi, '');
console.log(d);
let mytable_p = 'p'+d;
let mytable_c = 'c'+d;
let mytable = 'a'+d;
let sql3 = create table if not exists ${mytable}( id int primary key auto_increment, author varchar(255) not null, comments float not null, posts float not null, points float not null );
connection.query(sql3,function(err, results) {
if(err) console.log(err);
});
const sql = SELECT * FROM ${mytable_c} ORDER BY count DESC ;
connection.query(sql, function(err, results) {
if(err) console.log(err);
const users = results;
for(let i=0; i < users.length; i++){
if (users[i].count>0) {
formula = (users.length - i)/10;
// console.log(users[i].count);
} else { formula = 0;
// console.log('sdfsdfs');
}
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
const sql = UPDATE ${mytable_c} SET points='${formula}' WHERE author='${users[i].author}' LIMIT 1000;
console.log(sql);
// const sql = `UPDATE ${mytable} SET points=${formula} WHERE id=${users[i].id}`;
connection.query(sql,function(err, results) {
if(err) console.log(err);
});
const sql12 = `UPDATE ${mytable} SET comments=${formula} WHERE author='${users[i].author}'`;
console.log(sql12);
connection.query(sql12,function(err, results) {
if(err) console.log(err);
//console.log(results);
});
//console.log (users[i].id);
connection.end();
console.log('|',i+1,'|',users[i].author,'|',users[i].count,'|',formula,'|');
}
});
connection.end();
<h2> sortpost </h2>
const mysql = require("mysql2");
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
let num_day = 1;
var d = new Date(); // Today!
d.setDate(d.getDate()-num_day); // Yesterday!
d = d.toJSON().split("T")[0];
d = d.replace(/-/gi, '');
console.log(d);
let mytable_p = 'p'+d;
let mytable_c = 'c'+d;
let mytable = 'a'+d;
const sql = SELECT * FROM ${mytable_p} ORDER BY length DESC ;
connection.query(sql, function(err, results) {
// console.log(results);
if(err) console.log(err);
const users = results;
console.log(users);
for(let i=0; i < users.length; i++){
let formula = (users.length - i)/10;
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
const sql = UPDATE ${mytable_p} SET points=${formula} WHERE url='${users[i].url}';
connection.query(sql,function(err, results) {
if(err) console.log(err);
// console.log(results);
});
const sql12 = `UPDATE ${mytable} SET posts=${formula} WHERE
author='${users[i].author}'`;
connection.query(sql12,function(err, results) {
if(err) console.log(err);
//console.log(results);
});
connection.end();
console.log('|',i+1,'|',users[i].author,'|','<a href="',users[i].url,'">',users[i].length,'</a>','|',formula,'|');
// console.log('|',i+1,'|',users[i].author,'|',users[i].upvotes);
// console.log('|',i+1,'|',users[i].author,'|',users[i].comments);
}
});
connection.end();
<h2> sum </h2>
const mysql = require("mysql2");
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
let num_day = 1;
var d = new Date(); // Today!
d.setDate(d.getDate()-num_day); // Yesterday!
d = d.toJSON().split("T")[0];
d = d.replace(/-/gi, '');
console.log(d);
let mytable_p = 'p'+d;
let mytable_c = 'c'+d;
let mytable = 'a'+d;
const sql = SELECT * FROM ${mytable} ;
connection.query(sql, function(err, results) {
if(err) console.log(err);
const users = results;
console.log(users);
for(let i=0; i < users.length; i++){
let formula = (users.length - i)/10;
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
let count_day = users[i].comments + users[i].posts;
const sql12 = `UPDATE ${mytable} SET points=comments+posts WHERE id=${users[i].id}`;
connection.query(sql12,function(err, results) {
if(err) console.log(err);
//console.log(results);
});
connection.end();
console.log('|',i+1,'|',users[i].author,'|','<a href="',users[i].url,'">',users[i].length,'</a>','|',formula,'|');
// console.log('|',i+1,'|',users[i].author,'|',users[i].upvotes);
// console.log('|',i+1,'|',users[i].author,'|',users[i].comments);
}
});
connection.end();
<h2> spisok_twg </h2>
const fs = require("fs");
const steem = require('steem');
let body3R = '';
//https://steemit.com/hive-171319/@alexmove/the-word-game-post-2
var query = { limit : 100, tag : "hive-171319" };
//accounts.forEach(function (element,i,array){
steem.api.getDiscussionsByTrending(query, function(err, result) {
console.log(result.length);
if (result)
{
var i, len = result.length;
for (i = 0; i < len; i++)
{
var raw = result[i];
console.log('Автор');
console.log(raw.author);
console.log('Заголовок');
console.log(raw.author);
console.log('Сообщество');
console.log(raw.category);
console.log(raw.permlink);
// console.log('Длина поста');
// console.log(raw.body_length);
// console.log('Количество ожидаемого вознаграждения');
console.log(raw.category);
console.log('Сообщество');
// console.log(raw.replies.length);
// console.log('Количество upvote');
let upvote = raw.active_votes.length-1;
// console.log(raw.active_votes.length-1);
console.log('Дата создания');
console.log(raw.created);
let input = raw.created;
var d = new Date(); // Today!
d.setDate(d.getDate()-1); // Yesterday!
d = d.toJSON().split("T")[0];
let title = raw.title;
title = title.replace(/[^a-zа-яё0-9\s]/gi, ' ');
// if ((input.indexOf(d) !== -1)&& (raw.category === 'hive-171319'))
// if (input.indexOf(d) !== -1)
let spisok = raw.author + " ";
const fs = require("fs");
fs.appendFileSync("spisok06.txt",spisok);
const mysql = require("mysql2");
const connection = mysql.createConnection({
host: "localhost",
user: "root",
database: "wordgame",
password: "root"
});
//connection.on('error', function() {});
const sql = `INSERT INTO spisok(author) VALUES('${raw.author}')`;
console.log(sql);
connection.query(sql, function(err, results) {
if(err) console.log(err);
console.log(results);
});
connection.end();
}
}
});
//});
<h2>bat files </h2>
Pay attention to the sequence of launching files!
cmd /c node c:\js\twg\spisok_twg.js
exit
cmd /c node c:\js\twg\create.js
exit
cmd /c node c:\js\twg\addcom.js
exit
cmd /c node c:\js\twg\addpost.js
exit
cmd /c node c:\js\twg\addpost.js
exit
cmd /c node c:\js\twg\create_day.js
exit
cmd /c node c:\js\twg\sortcom.js
exit
cmd /c node c:\js\twg\sortpost.js
exit
cmd /c node c:\js\twg\sortcom.js
exit
cmd /c node c:\js\twg\sortpost.js
exit
cmd /c node c:\js\twg\sum.js
exit
cmd /c node c:\js\twg\fulllist.js
exit
cmd /c node c:\js\twg\fulllistpost.js
exit
Have a nice day.
Lo confieso no entendí nada, le prestaré más atención a ver cómo puedo utilizar este formato, muchas gracias