jeremyhalin

// 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';

jeremyhalin

PhpStorm Settings

General

.ctp files like .php files

File Types => PHP => Add .ctp extension

Shortcuts

Open new file / Go to file

Ctrl + Shift + N => Ctrl + P

jeremyhalin

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 

jeremyhalin

/* 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 (...)

jeremyhalin

-- 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

jeremyhalin

/*
 * 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;