Top Poster
#1 ramon fincken 403
#2 Site admin 3
#3 Ber|Art 2
#4 braddmark 1
#5 accentmedia 1
#6 Xarzu 1
#7 pEcosespedex 1
#8 khadish 1
#9 moxxx 1
#10 nistelrock 1

The time now is Sun Jan 24, 2021 9:47 am
Ramonfincken.com Forum Index		 View unanswered posts
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!

[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: , , , , ,
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

[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: , , , , , , ,
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

[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: , , , , , , , ,
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

[solution] htaccess rewrite to parent folder
Author ramon fincken :: Posted: Fri Dec 13, 2019 12:23 pm :: Category: PHP coding
Tagged: , , , ,
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]

[chrome] re-add (unhide) www in address bar
Author ramon fincken :: Posted: Thu Oct 31, 2019 1:34 pm :: Category: Ubuntu
Tagged: , , , , , , , , , , , , ,
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.

[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: , , , , ,
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

[date] Find booking date overlap
Author ramon fincken :: Posted: Fri Jul 05, 2019 7:24 am :: Category: PHP coding
Tagged: , ,
Leave a comment

Booking date checker: start & end = guest wish date.
Must NOT overlap with any known availability start-end periods.


Code:

start-end is exactly the same as non-availability start-end
OR
start-end is within the range as non-availability start-end

start is within the range as non-availability start-end

end is within the range as non-availability start-end


https://pastebin.com/cjYSAGf5

All times are GMT
Who is Online
Who is Online Our users have posted a total of 409 articles
We have 26 registered users
The newest registered user is MathewCow
In total there is 1 user online :: 0 Registered, 0 Hidden and 1 Guest   [ Administrator ]   [ Moderator ]
Most users ever online was 41 on Wed Sep 09, 2015 1:34 am
Registered Users: None
This data is based on users active over the past five minutes
Log in
Username:    Password:      Log me on automatically each visit    

New posts New posts    No new posts No new posts    Forum is locked Forum is locked
General forums
The world of freelance
Programming
Other projects
Poll
I love gifts

Yes goodies and presents! [3]
No but I love polls ! [1]
Related google ads