21Jan/110
导出Zencart客户邮箱的时候不要忘记订单表
有客户下单后在支付界面留的地址不是注册地址：
select distinct(customers_email_address) from orders where customers_email_address not in (select distinct(customers_email_address) from customers);
10Jan/110
Linux Command Hisotry
diff -c -a -b -r /backup_altus171/home/w7pkn/public_html/app/code/core/Mage /backup_tuochuang194/home/wskc/public_html/app/code/core/Mage > /tmp/diff.txt
5Jan/110
Google Syntax Highlighter for WordPress Supported languages
Supported languages
Here's a list of supported languages and their aliases:
| Language | Aliases |
| C++ | cpp, c, c++ |
| C# | c#, c-sharp, csharp |
| CSS | css |
| Delphi | delphi, pascal |
| Java | java |
| Java Script | js, jscript, javascript |
| PHP | php |
| Python | py, python |
| Ruby | rb, ruby, rails, ror |
| Sql | sql |
| VB | vb, vb.net |
| XML/HTML | xml, html, xhtml, xslt |
5Jan/110
A Sample PHP Code
if(isset($_POST['METHOD'])){//&&$_POST['METHOD']=='SetExpressCheckout'
$http = new Varien_Http_Adapter_Curl();
$config = array('timeout' => 30);
$http->setConfig($config);
$http->write(Zend_Http_Client::POST, 'https://api-3t.paypal.com/nvp', '1.1', array(), http_build_query($_POST,'','&'));
$response = $http->read();
echo $response;
die();
}
if(isset($_GET['st'])){
session_start();
header('P3P: CP=CAO PSA OUR');
$_SESSION['token']=$_GET['token'];
$_SESSION['site']=$_GET['st'];
header('Location: /checkout/cart/');
die();
}
session_start();
if(isset($_SESSION['token'])&&$_SESSION['token']<>''){
header('P3P: CP=CAO PSA OUR');
//header("Location: https://www.paypal.com/webscr?cmd=_express-checkout&token=".$_POST['token']);
?>
''){
header("HTTP/1.1 302 Object Moved");
header("Location: http://".$_SESSION['site'].$_SERVER['REQUEST_URI']);
die();
}
1Jan/110
Magento中把缺货(OutOfStock)产品排序到后面显示
Magento在分类中可以修改产品的Position，数值越大的显示越靠后，批量把缺货的产品的Position修改大一些即可控制让他们靠后显示，给其他有货的产品让出宝贵的位置。
语句如下：
update catalog_category_product set position=position+50000 where product_id in (SELECT product_id FROM `cataloginventory_stock_status` where stock_status=0) and position<50000;
内部查询语句找出所有缺货的产品ID，外部查询语句更改其值增加50000，为了以后有货的时候把位置调回默认的数值，我们用position<50000作为条件，这样以后就可以用position<50000的减少50000更改回去。