Skip to content

Instantly share code, notes, and snippets.

View rwkyyy's full-sized avatar
🏠
Working from home

Eduard “RwkY” Doloc rwkyyy

🏠
Working from home
View GitHub Profile
@rwkyyy
rwkyyy / gist:7e164ee109ecf307661ed58fd9e5552e
Created August 24, 2020 14:27
Disable WPBakery Page Builder API update check via function
/* Disable WPBakery Page Builder auto-update check*/
function seventhqueen_vc_disable_update() {
if (function_exists('vc_license') && function_exists('vc_updater') && ! vc_license()->isActivated()) {
remove_filter( 'upgrader_pre_download', array( vc_updater(), 'preUpgradeFilter' ), 10);
remove_filter( 'pre_set_site_transient_update_plugins', array(
vc_updater()->updateManager(),
'check_update'
) );
@rwkyyy
rwkyyy / wc-display-product-attribute-archive-links.php
Last active September 23, 2020 10:19 — forked from woogists/wc-display-product-attribute-archive-links.php
[General Snippets] Display product attribute in single product page with links
@rwkyyy
rwkyyy / gist:309ed21255f35ec63c5d0da67c5ecde9
Last active October 11, 2023 11:37
remove autocomplete in checkout for woocommerce
add_filter( 'woocommerce_checkout_fields' , 'autocomplete_billing_remove', 10, 1 );
function autocomplete_billing_remove( $fields ) {
$fields['billing']['billing_last_name']['autocomplete'] = "off"; // State off
$fields['billing']['billing_phone']['autocomplete'] = null; // Remove statement
return $fields;
}
@rwkyyy
rwkyyy / functions.php
Last active December 2, 2020 16:09
restrict payment gateway based on coupon code
add_filter( 'woocommerce_available_payment_gateways', 'conditional_available_payment_gateways' 20, 1 );
function conditional_available_payment_gateways( $available_gateways ) {
if( is_admin() ) return $available_gateways; // Only for frontend admin
$coupon_code ='cod';
if ( WC()->cart->has_discount( $coupon_code ) ) {
unset( $available_gateways['cod'] );
}
@rwkyyy
rwkyyy / query.sql
Last active March 24, 2022 10:13
SQL cheatbook for big WP tables
--See what is eating up (duplicate no):
SELECT COUNT(meta_key), meta_key FROM wp_postmeta GROUP BY meta_key ORDER BY COUNT(meta_key) DESC;
-- See what is eating up (size kb/gb):
SELECT meta_key, (SUM(LENGTH(meta_id)+LENGTH(post_id)+LENGTH(meta_key)+LENGTH(meta_value)))/1048576 AS `Size`, COUNT(*) AS `Count` FROM wp_postmeta
GROUP BY `meta_key`
ORDER BY `Size` DESC
--Get a key that is duplicate
SELECT * FROM wp_postmeta WHERE `meta_key` LIKE ‘%keyword%’;
@rwkyyy
rwkyyy / functions.php
Last active January 18, 2022 12:42
CLI close orders bulk
// CLI init & close BULK
function orders_close_query() {
$args = array(
'post_type' => 'shop_order',
'posts_per_page' => -1,
'post_status' => 'wc-shipped',
// 'order_by' => 'publish_date',
// 'order' => 'ASC'
);
@rwkyyy
rwkyyy / functions.php
Created January 13, 2022 21:03
afișare număr awb și buton în mail-urile de WC - Sameday România
function rwky_display_awb_mail( $order, $sent_to_admin, $plain_text ) {
// global $wpdb;
$awb = SamedayCourierQueryDb::getAwbForOrderId( sanitize_key( $order->get_id() ) );
$awbNumber = $awb->awb_number;
if ( $awbNumber ) {
echo 'Poți urmări expediția aici:<br><a href="https://sameday.ro/#awb=' . $awbNumber . '" class="button" >AWB: ' . $awbNumber . '</a></br></br>';
} else {
echo '';
@rwkyyy
rwkyyy / functions.php
Created February 16, 2022 15:14
polylang + booster currency switcher - switch automatically on language change
//searched a lot for this, ended up coding it myself -- based on WOOCS and WPML.
add_filter('wp_head', function() {
$lang = get_locale();
switch ($lang)
{
case 'ro_RO':
wcj_session_set( 'wcj-currency', 'RON' );
break;
case 'fr_FR':
wcj_session_set( 'wcj-currency', 'EUR' );
@rwkyyy
rwkyyy / functions.php
Created March 29, 2022 14:05
Enable Catalog Visibility in WooCommerce Product Editor (Gutenberg)
// fix catalog visibility
// original author + credits to https://dev.to/kalimahapps/enable-gutenberg-editor-in-woocommerce-466m
function enable_taxonomy_rest( $args ) {
$args['show_in_rest'] = true;
return $args;
}
add_filter( 'woocommerce_taxonomy_args_product_tag', 'enable_taxonomy_rest' );
@rwkyyy
rwkyyy / functions.php
Created April 26, 2022 10:26
Browser Theme Color (Android) for WordPress
add_action('wp_head', 'head_meta_hookin');
function head_meta_hookin() {
echo '<meta name="theme-color" content="#6eb726">';
echo '<meta name="msapplication-navbutton-color" content="#6eb726">';
echo '<meta name="apple-mobile-web-app-capable" content="yes">';
echo '<meta name="apple-mobile-web-app-status-bar-style" content="black-translucent">';
}