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 option_name, length(option_value) AS option_value_length FROM wp_options WHERE autoload='yes' ORDER BY option_value_length DESC LIMIT 10 |
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
add_action('woocommerce_cart_totals_before_order_total', 'wc_discount_total', 99); | |
add_action('woocommerce_review_order_before_order_total', 'wc_discount_total', 99); | |
function wc_discount_total() | |
{ | |
global $woocommerce; | |
$discount_total = 0; | |
foreach ($woocommerce->cart->get_cart() as $cart_item_key => $values) { |
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
delete | |
FROM `wp_posts` | |
where `post_type`= 'njt_user_add_to_cart'; | |
delete | |
FROM `wp_posts` | |
where `post_type`= 'shop_order_refund'; | |
delete | |
FROM `wp_posts` | |
where `post_type`= 'scheduled-action'; | |
DELETE pm |
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 wp_posts set post_status = 'trash' where post_type = 'shop_order'; |
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
DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%'); | |
DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_%'; | |
DELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy); | |
DELETE FROM wp_term_relationships WHERE object_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation')); | |
DELETE FROM wp_postmeta WHERE post_id IN (SELECT ID FROM wp_posts WHERE post_type IN ('product','product_variation')); | |
DELETE FROM wp_posts WHERE post_type IN ('product','product_variation'); | |
DELETE pm |
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
DELETE FROM wp_comgate_log; |
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
DELETE FROM wp_users WHERE ID NOT in (1,2) | |
DELETE FROM wp_usermeta WHERE user_id NOT in (1,2) |
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
DELETE pm | |
FROM wp_postmeta pm | |
LEFT JOIN wp_posts wp ON wp.ID = pm.post_id | |
WHERE wp.ID IS 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
CREATE TABLE IF NOT EXISTS wp_upvay_rf_payments ( | |
id mediumint(9) NOT NULL AUTO_INCREMENT, | |
time time DEFAULT '0000-00-00 00:00:00' NOT NULL, | |
order_id mediumint(255) NOT NULL, | |
var_symbol mediumint(255) NOT NULL, | |
cislo_ucet mediumint(255) NOT NULL, | |
price mediumint(255) NOT NULL, | |
status text NOT NULL, | |
PRIMARY KEY (id) | |
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; |