30

05

2024

mobile+desktop slider replace

Kategorisi : Wordpress

if ( !wp_is_mobile() ) {
    echo do_shortcode('[rev_slider alias="home"]');
} 
else
{
    // mobile devices
    echo do_shortcode('[rev_slider alias="home_mob"]');
}

---

22

05

2024

wp global text replace

Kategorisi : Wordpress

<pre>function custom_text_replace( $translated_text, $untranslated_text, $domain ) {
    switch ( $untranslated_text ) {
        case 'Read More':
            $translated_text = __( 'Learn More', $domain );
            break;
        case 'Leave a Comment':
            $translated_text = __( 'Share Your Thoughts', $domain );
            break;
        case 'Search':
            $translated_text = __( 'Find', $domain );
            break;
        // Leave the default case out when using languages other than en_US
        default:
            $translated_text = $untranslated_text;
            break;
    }
    return $translated_text;
}
add_filter( 'gettext', 'custom_text_replace', 20, 3 );</pre>

---

16

01

2024

Wp bulk user delete with sql

Kategorisi : Wordpress

DELETE
wp_users,
wp_usermeta
FROM
wp_users
INNER JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id
WHERE
wp_users.ID IN (1,2,3);

---

15

08

2023

Find and Delete Users from WooCommerce

Kategorisi : Wordpress

DELETE FROM b_users
WHERE
b_users.ID NOT IN (SELECT
meta_value
FROM
b_postmeta

WHERE
    meta_key = '_customer_user')
AND b_users.ID NOT IN (SELECT DISTINCT
    (post_author)
FROM
    b_posts) LIMIT 100

;
DELETE FROM b_usermeta
WHERE
b_usermeta.user_id NOT IN (SELECT
ID
FROM
b_users);

---

29

11

2021

wp bulk price update with variables ( sql )

Kategorisi : Wordpress

UPDATE wp_postmeta SET meta_value = meta_value*1.8 WHERE meta_key = '_regular_price' AND meta_value != '';
UPDATE wp_postmeta SET meta_value = meta_value*1.8 WHERE meta_key = '_sale_price' AND meta_value != '';
UPDATE wp_postmeta SET meta_value = meta_value*1.8 WHERE meta_key = '_price' AND meta_value != '';
UPDATE wp_postmeta SET meta_value = meta_value*1.8 WHERE meta_key = '_regular_price_tmp' AND meta_value != '';
UPDATE wp_postmeta SET meta_value = meta_value*1.8 WHERE meta_key = '_sale_price_tmp' AND meta_value != '';
UPDATE wp_postmeta SET meta_value = meta_value*1.8 WHERE meta_key = '_price_tmp' AND meta_value != '';
UPDATE wp_postmeta SET meta_value = meta_value*1.8 WHERE meta_key = '_min_variation_price' AND meta_value != '';
UPDATE wp_postmeta SET meta_value = meta_value*1.8 WHERE meta_key = '_max_variation_price' AND meta_value != '';
UPDATE wp_postmeta SET meta_value = meta_value*1.8 WHERE meta_key = '_min_variation_regular_price' AND meta_value != '';
UPDATE wp_postmeta SET meta_value = meta_value*1.8 WHERE meta_key = '_max_variation_regular_price' AND meta_value != '';
UPDATE wp_postmeta SET meta_value = meta_value*1.8 WHERE meta_key = '_min_variation_sale_price' AND meta_value != '';
UPDATE wp_postmeta SET meta_value = meta_value*1.8 WHERE meta_key = '_max_variation_sale_price' AND meta_value != '';
DELETE FROM wp_options WHERE (option_name LIKE '_transient_wc_var_pricwp_%' OR option_name LIKE '_transient_timeout_wc_var_pricwp_%');

---

20

06

2016

Woocommerce bulk price update

Kategorisi : Wordpress

update w_postmeta set meta_value = meta_value * 1.25 where meta_key=’_price’

---

28

07

2015

Tüm featured images kayıtlarını silmek

Kategorisi : Wordpress

functions.php'ye bu kodları ekliyoruz.

add_action ('init', 'remove_featured_images' );

function remove_featured_images () {

global $wpdb;
// The following query will only unset the featured image, it will not delete it.
$wpdb->query( "
    DELETE FROM $wpdb->postmeta
    WHERE meta_key = '_thumbnail_id'
" );
}

---

01

06

2015

Wp post_title kontrolü

Kategorisi : Wordpress

$post_if = $wpdb->get_var(“SELECT count(post_title) FROM $wpdb->posts WHERE post_title = ‘some text'”);
if($post_if < 1){
echo “var”;
} else {echo “yok”;}

---

04

08

2014

Toplu tarih değişimi – wp

Kategorisi : Wordpress

Toplu tarih değişimi – wordpress

UPDATE wp_posts SET post_date = ‘2014-08-04 17:02:52’ WHERE post_type = ‘post’ AND ID LIKE ‘%63%’

---

07

07

2014

Bir kategorideki tüm yazıları silmek – sql – wp

Kategorisi : Wordpress

Bir kategorideki tüm yazıları silmek için gerekli sql kodumuz :

delete a,b,c,d
FROM w_posts a
LEFT JOIN w_term_relationships b ON ( a.ID = b.object_id )
LEFT JOIN w_postmeta c ON ( a.ID = c.post_id )
LEFT JOIN w_term_taxonomy d ON ( d.term_taxonomy_id = b.term_taxonomy_id )
LEFT JOIN w_terms e ON ( e.term_id = d.term_id )
WHERE e.term_id =1

---