Skip to content

Instantly share code, notes, and snippets.

View mjtiempo's full-sized avatar

Mark John Tiempo mjtiempo

View GitHub Profile
#!/bin/bash
#read db credentials from wp-config.php
source <(php -r 'require("wp-config.php"); echo("DB_NAME=".DB_NAME."; DB_USER=".DB_USER."; DB_PASSWORD=".DB_PASSWORD."; TABLE_PREFIX=".$table_prefix); ')
#dump wp db on wpdb_backup_$DB_NAME.sql
mysqldump --user $DB_USER --password="$DB_PASSWORD" $DB_NAME > wpdb_backup_$DB_NAME.sql
#find and replace $table_prefix
sed -i 's/$TABLE_PREFIX/wp_/g' wpdb_backup_$DB_NAME.sql
@mjtiempo
mjtiempo / adduser-wp.sql
Last active September 18, 2019 01:48
Manually add admin to Wordpress Database
INSERT INTO `twizwebzyio_1568661505`.`wp_users` (`ID`, `user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_activation_key`, `user_status`, `display_name`) VALUES ('4', 'markt', MD5('markt'), 'Mark Tiempo', 'mark@monstervoip.com', 'http://www.test.com/', '2019-09-017 00:00:00', '', '0', 'Mark Tiempo');
INSERT INTO `twizwebzyio_1568661505`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '4', 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
INSERT INTO `twizwebzyio_1568661505`.`wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, '4', 'wp_user_level', '10');
const {app, BrowserWindow} = require('electron') // http://electron.atom.io/docs/api
let window = null
// Wait until the app is ready
app.once('ready', () => {
// Create a new window
window = new BrowserWindow({
// Set the initial width to 800px
width: 800,
sfdx force:package:create -p mvcti -d force-app --wait 10 -v markmonster -x
sfdx force:package:version:create -p mvcti -d force-app --wait 10 -v markmonster -x
sfdx force:package:version:promote --package mvcti@1.0.1-1 -v markmonster
sfdx force:package:install --wait 10 --publishwait 10 --package mvcti@1.0.1-1 -r -u markmonster
users = jsonf_to_list('en_users.json')
uid_map = map(lambda user: user['id'], users)
user_list = list(uid_map)
user_ids = list(filter(None, user_list))
def search_dict_list(dict_list, dict_id):
return next((item for item in dict_list if item["id"] == dict_id), None)
def jsonf_to_list(filename):
with open(filename, 'r') as f:
thelist = json.load(f)
@mjtiempo
mjtiempo / jitsimeet-quickinst.sh
Last active July 21, 2023 14:19
Jitsi Meet Quick Install
sudo su &&
cd &&
wget https://prosody.im/files/prosody-debian-packages.key -O- | sudo apt-key add - &&
echo deb http://packages.prosody.im/debian $(lsb_release -sc) main | sudo tee -a /etc/apt/sources.list &&
apt-get update -y &&
apt-get upgrade -y &&
apt-get install prosody -y &&
chown root:prosody /etc/prosody/certs/localhost.key &&
chmod 644 /etc/prosody/certs/localhost.key &&
cp /etc/prosody/certs/localhost.key /etc/ssl &&
@mjtiempo
mjtiempo / jitsimeet-ubuntu-20.04.sh
Created August 4, 2020 20:11
Install Jitsi meet Ubuntu 20.04
sudo su
cd &&
apt-get update -y &&
apt-get install gcc -y &&
apt-get install unzip -y &&
apt-get install lua5.2 -y &&
apt-get install liblua5.2 -y &&
apt-get install luarocks -y &&
luarocks install basexx &&
@mjtiempo
mjtiempo / asyncHttpRequests.py
Created June 16, 2021 13:39
run asyc http request using asyncio and pypeln in python
from aiohttp import ClientSession, TCPConnector
import asyncio
import sys
import pypeln as pl
import csv
limit = 1000
def csv2list(file):
results = []
with open(file, newline='') as inputfile:
@mjtiempo
mjtiempo / python-logging
Last active October 2, 2022 02:01
Logging to stdout and file in python
'''
src: https://stackoverflow.com/a/46098711/2433866
'''
import sys
import logging
import logging.handlers
logging.basicConfig(
level=logging.INFO,
format="[%(asctime)s] %(levelname)s in %(module)s: %(message)s",
@mjtiempo
mjtiempo / testrail.sh
Last active October 17, 2022 01:57
Install Testrail on Ubuntu >= 20.04
#!/usr/bin/env bash
PHP_VERSION=7.4
IONCUBE_VERSION=12.0.2
TESTRAIL_DB_NAME=testrail
TESTRAIL_DB_USER=testrail
TESTRAIL_DB_PASSWORD=testrail
DEBIAN_FRONTEND=noninteractive
echo "Updating Software"