LOOR Lab loorlab

💻

💥👩‍🚀👨‍🚀💥

Omnipresent Creative Experiences

loorlab / list_terms_taxonomy_WP_CLI.bash

Created May 16, 2025 23:16

List terms from the persons_categories taxonomy - WP CLI

	wp term list persons_categories --format=table

	wp term list persons_categories --format=csv > persons_categories.csv

	wp term list persons_categories --format=json

loorlab / display_all_taxonomies_CPT_post_WP_CLI.bash

Created May 16, 2025 23:12

Displays all taxonomies associated with the post's CPT and what terms are assigned to them. - WP CLI

	wp eval '
	$post_id = 53972; // ID
	$post_type = get_post_type($post_id);
	$taxonomies = get_object_taxonomies($post_type);
	foreach ($taxonomies as $tax) {
	$terms = get_the_terms($post_id, $tax);
	echo "Taxonomía: $tax\n";
	if (!empty($terms)) {
	foreach ($terms as $term) {
	echo "- {$term->name} (ID: {$term->term_id})\n";

loorlab / taxonomies-CPT-WP_CLI.bash

Created May 16, 2025 23:07

View the taxonomies associated with a CPT (e.g., person) - WP CLI

wp eval 'print_r( get_object_taxonomies("person") );'

loorlab / count_total_number_records_by_comma_WIN.bash

Created May 16, 2025 21:47

Count the total number of records in a comma-separated file (no-index.txt) in WIN, Bash console

expr $(tr -cd ',' < no-index.txt | wc -c) + 1

loorlab / translate_checkout_WOO.php

Created February 25, 2025 03:39

Translate : WooCommerce Checkout Fields

	<?php
	// Force translate WooCommerce
	add_filter('gettext', function($translated, $text, $domain) {
	if ($domain === 'woocommerce') {
	$translations = [
	'Billing details' => 'Detalles de facturación',
	'First name' => 'Nombre',
	'Last name' => 'Apellido',
	'Company name' => 'Nombre de la empresa',
	'Country / Region' => 'País / Región',

loorlab / query_mysql_total_posts_exclude_pages_cpt_WP.sql

Created February 11, 2025 00:14

Query - MySQL - WordPress | Display all Posts exclude pages and other content type

	SELECT
	p.ID,
	p.post_title,
	p.post_status,
	CONCAT(u.option_value, '/', p.post_name, '/') AS permalink
	FROM
	wp_posts p
	JOIN
	wp_options u
	ON u.option_name = 'siteurl'

loorlab / EventEmitter.js

Created January 26, 2025 01:36 — forked from brunosimon/EventEmitter.js

	export default class EventEmitter
	{
	constructor()
	{
	this.callbacks = {}
	this.callbacks.base = {}
	}

	on(_names, callback)
	{

loorlab / query_mysql_total_posts_by_no_category_permalinks_WP.sql

Created January 20, 2025 08:35

Query - MySQL - WordPress | Total Posts by No Category and Permalinks

	SELECT
	p.ID,
	p.post_title,
	CONCAT(o.option_value, '/', p.post_name, '/') AS permalink
	FROM
	wp_posts p
	JOIN
	wp_options o ON o.option_name = 'siteurl'
	JOIN
	wp_term_relationships tr ON p.ID = tr.object_id

loorlab / datasets

Created December 27, 2024 21:46

Datasets

	https://www.datos.gov.co/en/
	https://datosabiertos.esri.co/
	https://datosabiertos.bogota.gov.co/dataset
	https://datos.icde.gov.co/

loorlab / query_mysql_total_posts_by_no_category_WP.sql

Created December 22, 2024 05:39

Query - MySQL - WordPress | Total Posts by No Category

	SELECT p.ID, p.post_title, p.post_date
	FROM wp_posts p
	LEFT JOIN wp_term_relationships tr ON p.ID = tr.object_id
	LEFT JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy = 'category'
	WHERE p.post_type = 'post'
	AND p.post_status = 'publish'
	AND tt.term_taxonomy_id IS NULL;