Skip to content

Instantly share code, notes, and snippets.

View alexx855's full-sized avatar
🔵
Stay safe and stay optimistic.

Alex Pedersen alexx855

🔵
Stay safe and stay optimistic.
View GitHub Profile
@alexx855
alexx855 / .bashrc
Last active March 24, 2024 11:12
aliases
alias k="kubectl"
alias dc="docker compose"
alias n="npm"
alias p="pnpm"
@alexx855
alexx855 / settings.json
Created March 18, 2023 08:35
VSCode personal settings
{
"solidity.defaultCompiler": "localNodeModule",
"editor.defaultFormatter": "dbaeumer.vscode-eslint",
"editor.formatOnPaste": false, // required
"editor.formatOnType": false, // required
"editor.formatOnSave": true, // optional
"editor.formatOnSaveMode": "modifications", // require
"files.autoSave": "onFocusChange", // optional but recommended
"editor.codeActionsOnSave": {
"source.fixAll": false,
@alexx855
alexx855 / mysql_query.sql
Last active October 19, 2022 14:19
WooCommerce, select users with completed orders by user role
-- ALL SUBSCRIBERS WITH AN ORDER COMPLETED
SELECT
u.ID, um.meta_value AS user_role, COALESCE(COUNT(p.ID), 0) AS completed_orders
FROM wp_users AS u JOIN wp_usermeta AS um ON u.ID = um.user_id
LEFT JOIN wp_postmeta AS pm ON pm.meta_value = um.user_id
LEFT JOIN wp_posts AS p ON p.ID = pm.post_id
WHERE um.meta_key = 'wp_capabilities'
AND um.meta_value LIKE '%subscriber%'
AND um.meta_value NOT LIKE '%administrator%'
AND pm.meta_key = '_customer_user'
@alexx855
alexx855 / images_opt.md
Last active October 19, 2022 14:24
png jpeg images batch optimization with jpegoptim and optipng

install deps

sudo apt-get install jpegoptim
sudo apt-get install optipng

change ./ for your images folder

find ./ -type f -iname *.png -print0 | xargs -0 optipng -nc -nb -o7
find ./ -type f -iname *.jpeg -exec jpegoptim --max=70 --all-progressive -p {} \;
@alexx855
alexx855 / functions.php
Created August 13, 2020 11:14 — forked from butlerblog/functions.php
SMTP using wp-config.php for settings
<?php // Don't use this line.
/**
* This function will connect wp_mail to your authenticated
* SMTP server. This improves reliability of wp_mail, and
* avoids many potential problems.
*
* For instructions on the use of this script, see:
* https://www.butlerblog.com/2013/12/12/easy-smtp-email-wordpress-wp_mail/
*
@alexx855
alexx855 / gist:a30420897de02bb55062290b13ba1cf3
Last active August 24, 2022 12:32
Google Form Script, send email with attachment from drive on submit
function onFormSubmit( e ) {
const values = e.namedValues;
//e.values is an array of form values
const fecha = e.values[ 0 ];
const email = e.values[ 1 ];
//file is the template file, and you get it by ID
const file = DriveApp.getFileById(
'FILE_ID'
@alexx855
alexx855 / columns.php
Created June 15, 2018 17:49
Adding custom columns to custom post types
<?php
// Add the custom columns to the book post type:
add_filter( 'manage_book_posts_columns', 'set_custom_edit_book_columns' );
function set_custom_edit_book_columns($columns) {
unset( $columns['author'] );
$columns['book_author'] = __( 'Author', 'your_text_domain' );
$columns['publisher'] = __( 'Publisher', 'your_text_domain' );
return $columns;
@alexx855
alexx855 / functions.php
Created February 28, 2018 21:48
Wordpress AJAX resquest example
<?php
add_action( 'wp_enqueue_scripts', function() {
// Register the script
wp_register_script('ajax-script', get_template_directory_uri() . '/js/my-ajax-script.js', ['jquery']);
// Localize the script with new data
wp_localize_script('ajax-script', 'my_ajax_object', ['ajax_url' => admin_url( 'admin-ajax.php' )]);
// Enqueued script with localized data.
wp_enqueue_script('ajax-script');
});
<?php
/**
* @see http://stackoverflow.com/questions/40836144/php-how-to-get-images-from-instagram-without-api-access-token
* You can use function file_get_conents instead wp_remote_get
*/
function get_instagram_images( $username, $limit = 100 ){
$profile_url = "https://www.instagram.com/$username/?__a=1";
$iteration_url = $profile_url;
@alexx855
alexx855 / wordpress-instragram-shortcode.php
Created June 1, 2017 01:09
wordpress instragram shortcode
<?php
function get_instagram_data( $url, $javascript_loop = 0, $timeout = 5 ) {
$url = str_replace( "&amp;", "&", urldecode(trim($url)) );
$cookie = tempnam ("/tmp", "CURLCOOKIE");
$ch = curl_init();
curl_setopt( $ch, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows; U; Windows NT 5.1; rv:1.7.3) Gecko/20041001 Firefox/0.10.1" );
curl_setopt( $ch, CURLOPT_URL, $url );
curl_setopt( $ch, CURLOPT_COOKIEJAR, $cookie );