File Types => PHP => Add .ctp extension
Ctrl + Shift + N => Ctrl + P
// Includes functions for exporting active sheet or all sheets as JSON object (also Python object syntax compatible). | |
// Tweak the makePrettyJSON_ function to customize what kind of JSON to export. | |
var FORMAT_ONELINE = 'One-line'; | |
var FORMAT_MULTILINE = 'Multi-line'; | |
var FORMAT_PRETTY = 'Pretty'; | |
var LANGUAGE_JS = 'JavaScript'; | |
var LANGUAGE_PYTHON = 'Python'; |
UPDATE wp_posts | |
SET post_content = ( Replace (post_content, 'src="http://', 'src="//') ) | |
WHERE Instr(post_content, 'jpeg') > 0 | |
OR Instr(post_content, 'jpg') > 0 | |
OR Instr(post_content, 'gif') > 0 | |
OR Instr(post_content, 'png') > 0; | |
UPDATE wp_posts | |
SET post_content = ( Replace (post_content, "src='http://", "src='//") ) | |
WHERE Instr(post_content, 'jpeg') > 0 |
/* Delete all meta values '_thumnbail_id' for posts not IN category */ | |
DELETE FROM wp_postmeta WHERE post_id IN ( | |
SELECT ID | |
FROM wp_posts p | |
JOIN wp_term_relationships tr ON (p.ID = tr.object_id) | |
JOIN wp_term_taxonomy tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id) | |
JOIN wp_terms t ON (tt.term_id = t.term_id) | |
WHERE p.post_type='post' | |
AND p.post_status = 'publish' | |
AND p.id NOT IN (...) |
-- Remove all attributes from WooCommerce | |
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 all WooCommerce products | |
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 orphaned postmeta | |
DELETE pm |
/* | |
* Copyright (c) 2014, 2015, Formation Tablettes. All rights reserved. | |
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. | |
* | |
* Please contact us or visit www.britweb.fr if you need additional information or have any questions. | |
*/ | |
package com.logic; | |
import com.entity.Proposal; | |
import com.entity.Question; |