-
27
-
10
-
2015
Kategorisi : Magento
SET FOREIGN_KEY_CHECKS=0;
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
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
Kategorisi : Plesk
mysql -uadmin -p`cat /etc/psa/.psa.shadow`
-
24
-
06
-
2015
Kategorisi : Seo
RewriteCond %{HTTP_HOST} !^www\.(.*)$ [NC]
RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L]
-
16
-
06
-
2015
Kategorisi : Centos
yum install php54* –skip-broken
-
01
-
06
-
2015
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
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);
}
-
17
-
04
-
2015
Kategorisi : Magento
Secure URL, Unsecure URL,
core_config_data içerisindeki valueweb/cookie/cookie_domain “path” aynı olmalı.
-
24
-
03
-
2015
Kategorisi : Mysql,Php
Karşılaştırma için : utf8mb4_unicode_ci ve mysql sorguları için :
mysqli_query($con, “SET NAMES utf8mb4”);
mysqli_set_charset( $con, ‘utf8mb4’ );
-
24
-
03
-
2015
Kategorisi : Linux
sed -i ‘/abcdef/ d’ index.php
