Skip to content

Instantly share code, notes, and snippets.

View loopool's full-sized avatar

loopool loopool

View GitHub Profile
@loopool
loopool / magento-clear-log.sql
Last active November 2, 2022 18:27
Clearing magento log data
set foreign_key_checks = 0;
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;
@loopool
loopool / nginx.conf
Created March 19, 2013 02:40
Nginx配置文件nginx.conf中文详解
#定义Nginx运行的用户和用户组
user www www;
#nginx进程数,建议设置为等于CPU总核心数。
worker_processes 8;
#全局错误日志定义类型,[ debug | info | notice | warn | error | crit ]
error_log /var/log/nginx/error.log info;
#进程文件
@loopool
loopool / mage-ssh.sh
Last active December 15, 2015 03:19
Install magento via SSH. magento 1.7,sample data 1.6
cd /home/www
wget http://www.magentocommerce.com/downloads/assets/1.7.0.2/magento-1.7.0.2.tar.gz
wget http://www.magentocommerce.com/downloads/assets/1.6.1.0/magento-sample-data-1.6.1.0.tar.gz
tar -zxvf magento-1.7.0.2.tar.gz
tar -zxvf magento-sample-data-1.6.1.0.tar.gz
mv magento-sample-data-1.6.1.0/media/* magento/media/
mv magento-sample-data-1.6.1.0/magento_sample_data_for_1.6.1.0.sql magento/data.sql
mv magento/* magento/.htaccess public_html
cd public_html
chmod o+w var var/.htaccess app/etc
@loopool
loopool / get-magento-urls.php
Last active December 15, 2015 04:29
Get magento store urls
//Get Magento Store Info
Get store data
Mage::app()->getStore();
Store Id
Mage::app()->getStore()->getStoreId();
Store code
Mage::app()->getStore()->getCode();
Website Id
Mage::app()->getStore()->getWebsiteId();
Store Name
@loopool
loopool / gen-pass.php
Created June 5, 2014 09:26
PHP generate random string
<?php
//Normal way
function generateRandomString($length = 10) {
$characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
$randomString = '';
for ($i = 0; $i < $length; $i++) {
$randomString .= $characters[rand(0, strlen($characters) - 1)];
}
return $randomString;
}
@loopool
loopool / magento-delete-test-data.sql
Last active December 7, 2015 10:42
Remove all products,categories,customers,orders,logs from magento database
SET FOREIGN_KEY_CHECKS=0;
-- Delete all products
TRUNCATE TABLE `catalog_product_bundle_option`;
TRUNCATE TABLE `catalog_product_bundle_option_value`;
TRUNCATE TABLE `catalog_product_bundle_selection`;
TRUNCATE TABLE `catalog_product_entity_datetime`;
TRUNCATE TABLE `catalog_product_entity_decimal`;
TRUNCATE TABLE `catalog_product_entity_gallery`;
TRUNCATE TABLE `catalog_product_entity_int`;
@loopool
loopool / _Magento2_DeleteTestData.md
Created September 29, 2022 05:56 — forked from leek/_Magento2_DeleteTestData.md
Magento 2 - Delete All Test Data

These set of scripts are for Magento 2. For Magento 1, see this Gist.