hp/readme.md

HP

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

---

Built With:

• Wordpress
• Node
• NPM
• Webpack
• BrowserSync

---

Usage

$ npm install
$ npm run development
$ npm run watch
/* you know the drill */

---

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

---

---

Notes:

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='donation';
  • DELETE FROM hp_posts WHERE post_type='donor';
  • 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 hp_posts WHERE post_type='wpcf7_contact_form';
  • 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