Tunalıoğlu – Kişisel Blog – Linux – Php

TRUNCATE sales_flat_quote;
TRUNCATE sales_flat_quote_address;
TRUNCATE sales_flat_quote_shipping_rate;
TRUNCATE dataflow_batch_export;
TRUNCATE dataflow_batch_import;
TRUNCATE log_customer;
TRUNCATE log_quote;
TRUNCATE log_summary;
TRUNCATE log_summary_type;
TRUNCATE log_url;
TRUNCATE log_url_info;
TRUNCATE log_visitor;
TRUNCATE log_visitor_info;
TRUNCATE log_visitor_online;
TRUNCATE report_viewed_product_index;
TRUNCATE report_compared_product_index;
TRUNCATE report_event;
TRUNCATE index_event;

SET FOREIGN_KEY_CHECKS=1;

28: 07; 2015

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

0

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'
" );
}

27: 06; 2015

Mysql admin oturumu açmak – Plesk

0

Kategorisi : Plesk

mysql -uadmin -p`cat /etc/psa/.psa.shadow`

24: 06; 2015

Opencart www olmayan linkleri www linklere yönlendirme

0

Kategorisi : Seo

RewriteCond %{HTTP_HOST} !^www\.(.*)$ [NC]
RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L]

16: 06; 2015

Centos kurulamayan paketleri zorla yüklemek

0

Kategorisi : Centos

yum install php54* –skip-broken

01: 06; 2015

Wp post_title kontrolü

0

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: 05; 2015

Php sosyal medya hashtag

0

Kategorisi : Php

function tags($str){
$regex = “/#+([a-zA-Z0-9

_-]+)/”;
//$str = preg_replace($regex, ‘<a href=”h.php?tag=$1″>$0</a>’, $str);
$str = preg_replace($regex, ‘<a>$0</a>’, $str);
return($str);
}