Instantly share code, notes, and snippets.

Coding on something

Daniele Scasciafratte Mte90

View GitHub Profile
mysql --user='[users]' --password='[psw]' --database='[db]' --execute="UPDATE `user` SET `verification_token` = NULL WHERE `user`.`verification_token` IS NOT NULL;"
#!/usr/bin/env bash
cd /opt/mozita/
pkill -f
cd ./mozitaantispam_bot/
git pull
nohup python3 ./ &
cd ../
function replace() {
sed -i.bak s#https://"$1" /tmp/"$1"-"$2".po
sed -i.bak s/ /tmp/"$1"-"$2".po
sed -i.bak s/WordPress/ClassicPress/g /tmp/"$1"-"$2".po
View freemius-to-slack.php
// Get Freemius data
$json = file_get_contents('php://input');
$data = json_decode($json, true);
if( isset( $data['objects'] ) ) {
function slack($data) {

This set of script is used to manipulate the stuff to upload on common voice.

Usually the procedure is to check the sentences, later with is added the pipe for newlines, add the pipes and made a counter of the actual status of this strings.

With instead we extract only the sentences for italian to manipulate later after a manual check of every line as example for links.

View scripts.js
// This automatically click on yes on all of the three buttons to speed the procedure
jQuery('.form-item-field-moderation-personalized:nth-child(2) label, .form-item-field-moderation-issue-addressed:nth-child(2) label, .form-item-field-moderation-positive-tone:nth-child(2) label ').trigger('click')
# If the branch is not master, execute phpmetrics and upoload everything on the VPS
current_branch=$(git symbolic-ref HEAD | sed -e 's,.*/\(.*\),\1,')
if [ $current_branch != "master" ]; then
phpmetrics --report-html="/tmp/your-report" /var/www/VVV/www/your-project/htdocs/wp-content/plugins/your-plugin/ --config=phpmetrics.ini > /dev/null
sshpass -p your-password rsync --exclude={.sass-cache*,*.map,node_modules,.php_cs,.git*,*.lock,*.yml,*lock.json} --progress -avz /tmp/your-report -e ssh user@domain.tld:/var/www/your-metrics/$current_branch/ > /dev/null
View freemius.php
echo "Parsing Freemius Webhook";
// Get Freemius data
$json = file_get_contents('php://input');
$data = json_decode($json, true);
if( isset($data['objects']['user']) ) {
// Let's call our opensupports instance
$name = $data['objects']['user']['first'] . ' ' . $data['objects']['user']['last'];
View snippet.php
* Plugin Name: Better errors
* Description: Better errors in log
* Author: Daniele Scasciafratte
* Version: 1.0
* Author URI:
function handleError($code, $description, $file = null, $line = null, $context = null) {
cd ./vim-qt/src
make clean
./configure --with-features=huge \
--enable-multibyte \
--enable-rubyinterp=yes \
--enable-python3interp=yes \
--enable-largefile \
--disable-netbeans \