Skip to content

Instantly share code, notes, and snippets.

/applications/MAMP/library/bin/mysql -u [USERNAME] -p [DATABASE_NAME] < [PATH_TO_SQL_FILE]
Example:
/applications/MAMP/library/bin/mysql -u root -p wordpress_db < /Applications/MAMP/htdocs/mydatabase.sql
@accrane
accrane / functions-author.php
Created December 28, 2020 14:20
WordPress Prevent Author Lookup
function redirect_to_home_if_author_parameter() {
$is_author_set = get_query_var( 'author', '' );
if ( $is_author_set != '' && !is_admin()) {
wp_redirect( home_url(), 301 );
exit;
}
}
add_action( 'template_redirect', 'redirect_to_home_if_author_parameter' );
@accrane
accrane / cus.js
Created June 9, 2020 19:27
strings
let myTitles = Array.prototype.slice.apply(document.querySelectorAll("h2.woocommerce-loop-product__title"));
const searchTerm = '(';
// console.log( myTitles );
const regExp = /\(([^)]+)\)/;
myTitles.forEach((myTitles) => {
//console.log("apply worked");
if( myTitles.innerHTML.indexOf(searchTerm) > -1 ) {
// console.log('yep');
DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision'
@accrane
accrane / menus.scss
Created February 1, 2018 15:25
Animated underline on Navigation
a {
display: block;
text-decoration: none;
color: #000;
position: relative;
padding: 0 10px;
&:before {
content: "";
RewriteEngine On
RewriteCond %{SERVER_PORT} 80
RewriteRule ^(.*)$ https://www.example.com/$1 [R,L]
<script type="text/javascript">
jQuery(document).ready(function ($) {
// disable the button until successfull google captcha
document.getElementById("button1").disabled = true;
document.getElementById("button2").disabled = true;
})(jQuery);
</script>
@accrane
accrane / google-captcha-enable-submit.html
Created April 14, 2017 19:18
enables submit button
<script type="text/javascript" language="JavaScript">
// Callback to get the button working.
function enableBtn1(){
document.getElementById("button1").disabled = false;
}
function enableBtn2(){
document.getElementById("button2").disabled = false;
}
</script>
@accrane
accrane / google-captcha-render.html
Created April 14, 2017 19:12
rendering the Google Captcha
<script type="text/javascript" language="JavaScript">
// Call to rendor the captcha
var recaptcha1;
var recaptcha2;
var myCallBack = function() {
//Render the recaptcha1 on the element with ID "recaptcha1"
recaptcha1 = grecaptcha.render('recaptcha1', {
//'sitekey' : '6LeIxAcTAAAAAJcZVRqyHh71UMIEGNQ_MXjiZKhI', //test key
'sitekey' : 'YOUR_SITE_KEY', // production
@accrane
accrane / google-captcha-form.html
Created April 14, 2017 19:08
the form setup for Google Captcha V2
<div class="form-wrap">
<!-- Form 1 -->
<form id="form-1">
<!--
Other form elements...
-->
<!-- insert the google captcha div with the ID of "recaptcha1" -->
<div id="recaptcha1" class="googlecapt"></div>
<!-- Give your submit button an ID of "button1" -->