This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
if (function_exists('apc_clear_cache') && $_GET['pass'] == 'SomePassword' && $_SERVER['REMOTE_ADDR']=='127.0.0.1') { | |
if (apc_clear_cache() && apc_clear_cache('user')) | |
print 'All Cleared!'; | |
else | |
print 'Clearing Failed!'; | |
print '<pre>'; | |
print_r(apc_cache_info()); | |
print '</pre>'; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
UPDATE gp_customer_entity SET email='[email protected]'; | |
UPDATE gp_sales_flat_order_address SET email=NULL; | |
UPDATE gp_sales_flat_order SET customer_email=NULL; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT so.increment_id as 'id', | |
so.created_at AS 'date', | |
so.status, | |
ROUND(so.grand_total,2) AS 'total', | |
so.order_currency_code AS 'currency', | |
so.customer_email AS 'email', | |
so.shipping_description AS 'shipping', | |
sop.method AS 'payment', | |
soa.`firstname`, | |
soa.`lastname`, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
drop function if exists fn_remove_accents; | |
delimiter | | |
create function fn_remove_accents( textvalue varchar(20000) ) | |
returns varchar(20000) | |
begin | |
set @textvalue = textvalue; | |
-- ACCENTS | |
set @withaccents = 'ĎŇňŘřČ莞ĽľĚ슚ŽžÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØßÙÚÛÜŮÝŸÞàáâãäåæçèéêëìíîïñòóôõöøùúûüůýÿþƒ'; |