Ramonfincken.com ~ Index

Author ramon fincken :: Posted: Thu Mar 18, 2021 9:28 am :: Category: Mysql databases

Split column item in multiple columns, and fill with empty if field Quantity is less then the split

Split on ; character.
The coupons column is " coupon1;coupon2 " etc .. and it needs to be split for the export we need.

Code:

SELECT id, `Quantity`, `email`, coupons

,SUBSTRING_INDEX(coupons,';',1) 'coupon1'
,IF(Quantity>1, SUBSTRING_INDEX(SUBSTRING_INDEX(coupons,';',2),';',-1) , '') 'coupon2'
,IF(Quantity>2, SUBSTRING_INDEX(SUBSTRING_INDEX(coupons,';',3),';',-1) , '') 'coupon3'
,IF(Quantity>3, SUBSTRING_INDEX(SUBSTRING_INDEX(coupons,';',4),';',-1) , '') 'coupon4'
,IF(Quantity>4, SUBSTRING_INDEX(SUBSTRING_INDEX(coupons,';',5),';',-1) , '') 'coupon5'
,IF(Quantity>5, SUBSTRING_INDEX(SUBSTRING_INDEX(coupons,';',6),';',-1) , '') 'coupon6'
,IF(Quantity>6, SUBSTRING_INDEX(SUBSTRING_INDEX(coupons,';',7),';',-1) , '') 'coupon7'
,IF(Quantity>7, SUBSTRING_INDEX(SUBSTRING_INDEX(coupons,';',8),';',-1) , '') 'coupon8'
,IF(Quantity>8, SUBSTRING_INDEX(SUBSTRING_INDEX(coupons,';',9),';',-1) , '') 'coupon9'
,IF(Quantity>9, SUBSTRING_INDEX(SUBSTRING_INDEX(coupons,';',10),';',-1) , '') 'coupon10'

FROM `coupons`

(0) Replies

wp-cli delete all with custom keep-me table

Author ramon fincken :: Posted: Mon Jan 18, 2021 7:06 pm :: Category: CMS-ses (Joomla, WordPress, etc..)

Tagged:

Leave a comment

Code:

wp-cli post delete $(wp-cli db query --socket=/usr/local/mysql/data/mysql.sock --skip-column-names --batch "SELECT post_id FROM wp_postmeta WHERE post_id < 1010313 AND post_id IN ( SELECT ID FROM wp_posts WHERE post_type = 'attachment' AND ID NOT IN ( SELECT meta_value FROM wp_found ) ) AND meta_key = '_wp_attached_file' LIMIT 200") --force

you need a limit if you expect many thousands of IDS, this is due to a bash limit, not your WP site or the DB

use at your own risk, this is more complex than you might think!

(0) Replies

[solution] Letsencrypt Please choose an account

Author ramon fincken :: Posted: Fri Jan 15, 2021 9:58 am :: Category: Bash, perl, python and CLI linux

Tagged: account, certificate, DV, error, letsencrypt, solution

Leave a comment

Duplicates in your accounts, fix them by pointing to the newest account. MAKE SURE your know which account is the most new.

Code:

/etc/letsencrypt/accounts# find -type d
.
./acme-v01.api.letsencrypt.org
./acme-v01.api.letsencrypt.org/directory
./acme-v01.api.letsencrypt.org/directory/some-old-hash
./acme-v02.api.letsencrypt.org
./acme-v02.api.letsencrypt.org/directory
./acme-v02.api.letsencrypt.org/directory/the-new-hash

/etc/letsencrypt/accounts# rm -rf ./acme-v01.api.letsencrypt.org

Code:

cd /etc/letsencrypt/renewal
sed -i 's/some-old-hash/the-new-hash/g' *.conf

(0) Replies

[WordPress] creating PHP patches for WordPress Make Core and setting it up

Author ramon fincken :: Posted: Fri Oct 30, 2020 8:40 am :: Category: CMS-ses (Joomla, WordPress, etc..)

Tagged: core, develop, make, patch, phpunit, svn, trac, wordpress

Leave a comment

Do you want to contribute your PHP skills to WordPress Core?

Use this manual to get started !

# For to make PHP patches Razz

To make children happy
# https://make.wordpress.org/core/handboo...dards/php/

# Download
svn co https://develop.svn.wordpress.org/trunk wordpress_make
cd wordpress_make

# JS and CSS
npm install
npm run build
npm run dev

copy wp-config-sample.php to wp-config.php and edit accordingly (do not forget to create a new DB !)

# Install and do your coding

# PHP unit test
# https://make.wordpress.org/core/handboo...g/phpunit/

#WARNING: You might need to install an older version
sudo apt install phpunit
copy wp-tests-config-sample.php to wp-tests-config.php and edit accordingly (do not forget to create a *new* DB !)

phpunit
or

# Patch and submit to trac
# https://make.wordpress.org/core/handboo...g-a-patch/
svn diff filename.php > filename.diff

(0) Replies

[fix] How to add the clock seconds to ubuntu 20.04

Author ramon fincken :: Posted: Tue Aug 04, 2020 6:27 am :: Category: Ubuntu

Tagged: 20, add, clock, dconf, gnome, gui, second, seconds, ubuntu

Leave a comment

Code:

sudo apt install dconf-editor

Then open dconf GUI

Search for "seconds" or go to /org/gnome/desktop/interface/clock-show-seconds

Enable!

Related read: https://ubuntu-mate.community/t/20-04-m...l/21795/21

(0) Replies

[solution] htaccess rewrite to parent folder

Author ramon fincken :: Posted: Fri Dec 13, 2019 12:23 pm :: Category: PHP coding

Tagged: folder, htaccess, map, parent, rewrite

Leave a comment

when some idiot decides to put a whole site in a (dated) subfolder like

www/2018/

and you want to migrate to another host and set things strait ( meaning www/ ) you will end up with A LOT OF 404 urls

You need to create a 2018 folder and put this in your htaccess to redirect 301 all requests to the parent root folder

Code:

RewriteRule ^(.*)$ https://www.fulldomain.ext/$1 [R=301,L]

(0) Replies

[chrome] re-add (unhide) www in address bar

Author ramon fincken :: Posted: Thu Oct 31, 2019 1:34 pm :: Category: Ubuntu

Tagged: address-bar, chrome, chromium, flags, hide, omnibox, settings, solution, subdomain, subdomains, trivial, ui, un-hide, www

Leave a comment

visit

Code:

chrome://flags/#omnibox-ui-hide-steady-state-url-scheme-and-subdomains

set
Omnibox UI Hide Steady-State URL Trivial Subdomains

to Disabled and restart to see the www. again.

(0) Replies

[solution] composer "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?

Author ramon fincken :: Posted: Mon Sep 02, 2019 3:08 pm :: Category: Bash, perl, python and CLI linux

Tagged: break, composer, continue, did you mean, lint, php

Leave a comment

Code:

composer install

Code:

"continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?

if it is NOT your PHP (when as zip); don't forget to update your composer!!

Code:

find . -type f -name '*.php' -exec php -l {} \; |grep -v "No syntax errors detected"

Ubuntu:

Code:

/usr/local/bin/composer self-update

(0) Replies

Forum		Topics	Posts	Last Post
General forums
	About this blog Moderator ramon fincken	4	4	Mon Jan 05, 2009 5:47 pm ramon fincken
	Lounge Chit - chat Moderator ramon fincken	61	76	Wed Oct 22, 2014 8:49 am ramon fincken
	Reviews Movie reviews - Goodie reviews and much more ! Moderator ramon fincken	5	5	Sun Oct 11, 2009 8:00 pm ramon fincken
	Rants Rants about things in daily life ...	5	11	Sun Mar 21, 2010 10:12 pm ramon fincken
	Ubuntu A forum about my favourite Operating System!	26	30	Tue Aug 04, 2020 6:27 am ramon fincken
The world of freelance
	Freelancing Moderator ramon fincken	2	2	Wed Jan 21, 2009 9:52 am ramon fincken
	Coping with clients Moderator ramon fincken	1	1	Thu Jan 08, 2009 12:00 pm ramon fincken
	Services I offer many webdevelopment services such as custom coding, photoshop webdesign and W3 valid slicing and basing ! Feel free to ask for a quote ! Moderator ramon fincken	1	2	Sun Mar 21, 2010 2:00 pm ramon fincken
Programming
	PHP coding Moderator ramon fincken	79	94	Fri Dec 13, 2019 12:23 pm ramon fincken
	Mysql databases Moderator ramon fincken	12	14	Thu Mar 18, 2021 9:28 am ramon fincken
	HTML and other markup&programming languages Moderator ramon fincken	30	31	Sat Jul 28, 2018 5:59 pm ramon fincken
	Control panels (plesk, cpanel, direct admin) Moderator ramon fincken	5	8	Tue Jun 09, 2015 5:44 am ramon fincken
	CMS-ses (Joomla, WordPress, etc..) Moderator ramon fincken	46	62	Mon Jan 18, 2021 7:06 pm ramon fincken
	Bash, perl, python and CLI linux	32	33	Fri Jan 15, 2021 9:58 am ramon fincken
Other projects
	Antispam Moderator ramon fincken	6	6	Sat Oct 30, 2010 4:37 pm ramon fincken
	Other projects Moderator ramon fincken	17	26	Sat Dec 27, 2014 1:01 pm ramon fincken

Board:	Search Usergroups RSS
Register, Log(in/out):	Register Log in
About:	My LinkedIn profile I'm for hire / Huur me in My Wishlist

Ramonfincken.com

Featured links

Active topics

Related topics