How to Add an Admin User to the WordPress Database via MySQL

Posted on November 6, 2014 by zzz_zwp

How to Add an Admin User to the WordPress Database via MySQL.

Fix Miro 3.0 Ogg Conversion Quality

Posted on October 31, 2014 by zzz_zwp

From the poster “Phil” on the Miro support forums… In this directory/Terminal: cd /Applications/Miro Video Converter.app/Contents/Resources/lib/python2.7/mvc Edited this file: open -e basicconverters.py After these lines: class OggTheora(converter.FFmpegConverterInfo): media_type = ‘format’ extension = ‘ogv’ I replaced: parameters = ‘-f ogg … Continue reading →

An Illustrated Guide to Split Windows in Irssi

Posted on October 29, 2014 by zzz_zwp

An Illustrated Guide to Split Windows in Irssi.

WordPress SalesForce Integration With Gravity Forms How To

Posted on October 8, 2014 by zzz_zwp

Integrate Gravity Forms with SalesForce’s Web-To-Lead Service. via WordPress SalesForce Integration With Gravity Forms How To.

Attaching image files to nodes programmatically in Drupal 7 – Stack Overflow

Posted on October 6, 2014 by zzz_zwp

Attaching image files to nodes programmatically in Drupal 7 – Stack Overflow. $filepath = drupal_realpath(‘misc/druplicon.png’);// Create managed File object and associate with Image field. $file =(object) array(‘uid’=>1,’uri’=> $filepath,’filemime’=> file_get_mimetype($filepath),’status’=>1,);// We save the file to the root of the files directory. … Continue reading →

WordPress Capabilities with Custom Roles and Post Types

Posted on July 17, 2014 by zzz_zwp

This is a brief tutorial about how to setup a custom post type, custom roles and capabilities in WordPress. The end result is a site where a user can be assigned to a role with capabilities to publish, edit, and … Continue reading →

Phpbrew – run multiple php versions with ease

Posted on June 25, 2014 by zzz_zwp

phpbrew is a helpful too to run multiple versions of php. Why run multiple versions of php? In this case it was required for upgrading an old legacy site that depended on php 5.2. Phpbrew.

Contact Form 7: Thank You Success Messages

Posted on June 19, 2014 by zzz_zwp

How to simply redirect a visitor to a thank you page after submission with Contact Form 7 – add this snippet to your form’s “Additional Settings” textarea. on_sent_ok: “location.replace(‘http://example.com/thank-you/’);” See more details here: Contact Form 7: Thank You Success Messages.

How to Add an Admin User to the WordPress Database via MySQL

Posted on May 29, 2014 by zzz_zwp

Make sure to use the proper prefix for ‘wp_’ if you have a custom database prefix and to follow the existing user capabilities values when manually adding a user to WordPress. How to Add an Admin User to the WordPress … Continue reading →

SELECT option_name, option_value FROM wp_options WHERE option_name IN ('_site_transient_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4','_site_transient_timeout_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4')

SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1654, 1652, 1650, 1642, 1639, 1631, 1628, 1624, 1622, 1620) ORDER BY t.name ASC

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (448,443,441,447,442,25,452,44,461,439,463,458,67,459,460,120,446,445,449,451,26,1,462,429,440,453,200,444)

SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (468) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC

SELECT wp_comments.comment_ID FROM wp_comments JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID WHERE ( comment_approved = '1' ) AND wp_posts.post_status IN ('publish') ORDER BY wp_comments.comment_date_gmt DESC LIMIT 0,5

SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC

[0] => themes/twentyeleven/inc/theme-options.php [1] => themes/twentyeleven/inc/widgets.php [2] => themes/twentyeleven/index.php [3] => themes/twentyeleven/header.php [4] => themes/twentyeleven/searchform.php [5] => themes/twentyeleven/content.php [6] => themes/twentyeleven/sidebar.php [7] => themes/twentyeleven/footer.php [8] => themes/twentyeleven/sidebar-footer.php

$_SERVER = array ( 'SERVER_SOFTWARE' => 'Apache', 'REQUEST_URI' => '/page/2/', 'LSPHP_ENABLE_USER_INI' => 'on', 'PATH' => '/usr/local/bin:/usr/bin:/bin', 'TEMP' => '/tmp', 'TMP' => '/tmp', 'TMPDIR' => '/tmp', 'PWD' => '/', 'HTTP_ACCEPT' => '*/*', 'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate', 'CONTENT_LENGTH' => '0', 'HTTP_HOST' => 'www.zzzzzzzzz.net', 'HTTP_REFERER' => 'https://zzzzzzzzz.net/page/2', 'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'HTTP_X_HTTPS' => '1', 'REDIRECT_UNIQUE_ID' => 'Z4sMDTyTAq5o6BY5V6QofwAAVz0', 'REDIRECT_QS_ConnectionId' => '173716583744479133537163', 'REDIRECT_SCRIPT_URL' => '/page/2/', 'REDIRECT_SCRIPT_URI' => 'https://www.zzzzzzzzz.net/page/2/', 'REDIRECT_HTTPS' => 'on', 'REDIRECT_SSL_TLS_SNI' => 'www.zzzzzzzzz.net', 'REDIRECT_HTTP2' => 'on', 'REDIRECT_H2PUSH' => 'off', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_STREAM_ID' => '1', 'REDIRECT_H2_STREAM_TAG' => '537163-1785-1', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'Z4sMDTyTAq5o6BY5V6QofwAAVz0', 'QS_ConnectionId' => '173716583744479133537163', 'SCRIPT_URL' => '/page/2/', 'SCRIPT_URI' => 'https://www.zzzzzzzzz.net/page/2/', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'www.zzzzzzzzz.net', 'HTTP2' => 'on', 'H2PUSH' => 'off', 'H2_PUSH' => 'off', 'H2_PUSHED' => '', 'H2_PUSHED_ON' => '', 'H2_STREAM_ID' => '1', 'H2_STREAM_TAG' => '537163-1785-1', 'SERVER_SIGNATURE' => '', 'SERVER_NAME' => 'www.zzzzzzzzz.net', 'SERVER_ADDR' => '192.185.137.117', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '18.191.14.62', 'DOCUMENT_ROOT' => '/home1/zzz/public_html', 'REQUEST_SCHEME' => 'https', 'CONTEXT_PREFIX' => '', 'CONTEXT_DOCUMENT_ROOT' => '/home1/zzz/public_html', 'SERVER_ADMIN' => 'webmaster@zzzzzzzzz.net', 'SCRIPT_FILENAME' => '/home1/zzz/public_html/index.php', 'REMOTE_PORT' => '38568', 'REDIRECT_URL' => '/page/2/', 'SERVER_PROTOCOL' => 'HTTP/2.0', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'SCRIPT_NAME' => '/index.php', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1737165837.4534471035003662109375, 'REQUEST_TIME' => 1737165837, 'argv' => array ( ), 'argc' => 0, );

0.4210	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_nonce_array' LIMIT 1`
0.3300	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_definitions_array' LIMIT 1`
0.2980	`SELECT option_value FROM wp_options WHERE option_name = 'GOTMLS_scan_log/18.191.14.62/1737165837.4753' LIMIT 1`
0.3250	`SELECT option_value FROM wp_options WHERE option_name = 'gzipcompression' LIMIT 1`
0.3622	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_encryption_keys_set' LIMIT 1`
0.3450	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_le_certificate_generated_by_rsssl' LIMIT 1`
0.3080	`SELECT option_value FROM wp_options WHERE option_name = 'rsssl_ssl_activation_active' LIMIT 1`
0.8810	`SELECT option_name, option_value FROM wp_options WHERE option_name IN ('_site_transient_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4','_site_transient_timeout_wp_theme_files_patterns-521ceac6f7ea50d1f2c96a08a1af8fc4')`
0.7141	`SELECT option_value FROM wp_options WHERE option_name = 'preload_cache_counter' LIMIT 1`
10.7150	`SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) ORDER BY wp_posts.post_date DESC LIMIT 10, 10`
0.4399	`SELECT FOUND_ROWS()`
0.7331	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (1654,1652,1650,1642,1639,1631,1628,1624,1622,1620)`
0.8729	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1654,1652,1650,1642,1639,1631,1628,1624,1622,1620) ORDER BY meta_id ASC`
1.7450	`SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1654, 1652, 1650, 1642, 1639, 1631, 1628, 1624, 1622, 1620) ORDER BY t.name ASC`
1.3011	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (448,443,441,447,442,25,452,44,461,439,463,458,67,459,460,120,446,445,449,451,26,1,462,429,440,453,200,444)`
0.6981	`SELECT * FROM wp_posts WHERE ID = 1716 LIMIT 1`
0.4210	`SELECT option_value FROM wp_options WHERE option_name = 'https_migration_required' LIMIT 1`
0.4590	`SELECT option_value FROM wp_options WHERE option_name = 'site_logo' LIMIT 1`
1.0478	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id = 468`
1.9979	`SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (468) ) AND wp_posts.post_type = 'nav_menu_item' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC`
1.4310	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1670,1671,1672,1681,1682) ORDER BY meta_id ASC`
0.8981	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (1542,1534,1579,1544)`
1.0600	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1542,1534,1579,1544) ORDER BY meta_id ASC`
2.0790	`SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (1) ORDER BY umeta_id ASC`
0.8581	`SELECT * FROM wp_users WHERE ID IN (1)`
1.0321	`SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) ORDER BY wp_posts.post_date DESC LIMIT 0, 5`
10.3030	`SELECT wp_posts.* FROM wp_posts WHERE ID IN (1771,1734,1728,1725,1721)`
0.8888	`SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (1771,1734,1728,1725,1721) ORDER BY meta_id ASC`
1.3459	`SELECT DISTINCT t.term_id, tr.object_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') AND tr.object_id IN (1771, 1734, 1728, 1725, 1721) ORDER BY t.name ASC`
1.0500	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (489,490,478,484,492,483,479,480,485,486,481,482,14,37,491,82)`
0.9201	`SELECT wp_comments.comment_ID FROM wp_comments JOIN wp_posts ON wp_posts.ID = wp_comments.comment_post_ID WHERE ( comment_approved = '1' ) AND wp_posts.post_status IN ('publish') ORDER BY wp_comments.comment_date_gmt DESC LIMIT 0,5`
3.6602	SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM wp_posts WHERE post_type = 'post' AND post_status = 'publish' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC
0.7951	`SELECT t.term_id FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND tt.count > 0 ORDER BY t.name ASC`
0.6001	`SELECT t., tt. FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE t.term_id IN (475,474)`

z z z z z z z z z

z z z z z z z z z

How to Add an Admin User to the WordPress Database via MySQL

Fix Miro 3.0 Ogg Conversion Quality

An Illustrated Guide to Split Windows in Irssi

WordPress SalesForce Integration With Gravity Forms How To

Attaching image files to nodes programmatically in Drupal 7 – Stack Overflow

WordPress Capabilities with Custom Roles and Post Types

Phpbrew – run multiple php versions with ease

Contact Form 7: Thank You Success Messages

Use Custom Post Widget With Visual Composer | WordPress Web Design & Hosting in Boulder, CO

How to Add an Admin User to the WordPress Database via MySQL