David A. Windham
david
/
hp
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
hp
/
readme.md

readme.md 3.1 KB
Permalink History Raw

HP

Just another WordPress project for - https://hospicepiedmont.org/

Built With:

Usage

$ npm install
$ gulp copy / build / run

/* you know the drill */

ca·ve·at git·mptor: do not clone ( build your own, you'll learn more )

Notes:

2021.2.12 - ( v. 1.0.0 )
  • seperate the core functions from the theme functions so that it can be reused on other projects.
2021.1.27 - ( v. 1.0.0 )
  • originally brought on to fix a hacked site
  • request to change the donation process and features
  • needed to clean up site so I'm using this to build out a new minimal boilerplate approach to WordPress projects
  • built this new theme off of some previous projects
  • removed unused plugins
    • mailchimp, php-compatibility-checker, simple-custom-css (move css to theme), simple history, ulimate maintenence mode, widget importer-exporter, wp-bulk-delete, wp-google-fonts, wp-page-navi, wunderground, bfi_thumb, wp_migrate, contact form 7, really simple captcha, rescue portfolio, rescue shortcodes
  • changed wp configuration
    • update plugins/wp
    • disable comments
    • convert all existing content to the Gutenberg editor

  • cleaned database ( 30MB -> 10MB )

    • ALTER TABLE ENGINE = InnoDB;
    • ALTER TABLE CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    • DELETE FROM wp_comments WHERE comment_approved = 'spam';
    • UPDATE wp_posts SET ping_status = 'closed';
    • DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE count = 0 );
    • DELETE FROM wp_term_taxonomy WHERE term_id not IN (SELECT term_id FROM wp_terms);
    • DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);
    • DELETE FROM wp_options WHERE option_name LIKE ('_transient%_feed_%');
    • DELETE a,b,c FROM wp_posts a WHERE a.post_type = 'revision' LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id);
    • DELETE FROM wp_usermeta WHERE NOT EXISTS ( SELECT * FROM wp_users WHERE wp_usermeta.user_id = wp_users.ID )
    • DELETE hp_postmeta FROM hp_postmeta LEFT JOIN hp_posts ON hp_posts.ID = hp_postmeta.post_id WHERE hp_posts.ID IS NULL;
    • DELETE hp_postmeta FROM hp_postmeta LEFT JOIN hp_posts ON hp_posts.ID = hp_postmeta.post_id WHERE wp_posts.ID IS NULL;
    • DELETE FROM hp_posts WHERE post_type='faq';
    • DELETE FROM hp_posts WHERE post_type='portfolio';
    • DELETE FROM hp_posts WHERE post_type='services';
    • DELETE FROM hp_posts WHERE post_type='team';
    • DELETE FROM wp_postmeta WHERE 'meta_key' LIKE ‘%review%’;

  • cleaned media library

    • remove extra sizes / duplicates
    • remove useless files thumbs.db/index.html
    • convert .tif -> .jpg
    • strip thumbnail sizes and regenerate