Skip to content

Instantly share code, notes, and snippets.

View Opencontent's full-sized avatar

OpenContent Developer Opencontent

18 followers · 6 following
View GitHub Profile
@Opencontent
Opencontent / mysql_update_from_46_to_2017_12_2_1.sql
Last active April 16, 2018 13:57
-- dbupdate-4.6.0-to-4.7.0.sql
SET storage_engine=InnoDB;
UPDATE ezsite_data SET value='4.7.0' WHERE name='ezpublish-version';
UPDATE ezsite_data SET value='1' WHERE name='ezpublish-release';
ALTER TABLE ezpending_actions ADD COLUMN id int(11) AUTO_INCREMENT PRIMARY KEY;
@Opencontent
Opencontent / php_update_from_46_to_2017_12_2_1
Last active April 16, 2018 15:04
php update/common/scripts/5.0/deduplicatecontentstategrouplanguage.php -sbackend;
php update/common/scripts/5.0/disablesuspicioususers.php -sbackend;
php update/common/scripts/5.0/restorexmlrelations.php -sbackend;
php update/common/scripts/5.1/fiximagesoutsidevardir.php -sbackend;
php update/common/scripts/5.3/recreateimagesreferences.php -sbackend;
php update/common/scripts/5.3/updatenodeassignmentparentremoteids.php -sbackend;
php update/common/scripts/5.4/cleanuntranslatablerelations.php -sbackend;
@Opencontent
Opencontent / list_zone_and_block_in_use.php
Created April 18, 2018 10:48
<?php
/*
Esempio:
cd <ez_doc_root>;
php list_zone_and_block_in_use.php -sbackend --exclude-subtree=541500,595702,515441,165686,212,581893,27411
Restitusce qualcosa simile a:
Zone
10ZonesLayout1
2ZonesLayout1
@Opencontent
Opencontent / xmlimporter.php
Last active May 8, 2018 13:47
<?php
/*
[ImportSettings]
AvailableSourceHandlers[]=xmlimporter
[xmlimporter-HandlerSettings]
Enabled=true
Name=OCExportAs XML Import Handler
ClassName=OCExportasXMLImporter
@Opencontent
Opencontent / change_var_dir.php
Created October 19, 2018 16:36
<?php
require 'autoload.php';
$cli = eZCLI::instance();
$script = eZScript::instance( array( 'description' => ( "OpenContent Change VarDir name" ),
'use-session' => false,
'use-modules' => true,
'use-extensions' => true ) );
$script->startup();
@Opencontent
Opencontent / eztags-postres-update-1.4-2.1.sql
Created January 17, 2019 15:05
ALTER TABLE eztags ADD main_language_id integer not null default 0;
ALTER TABLE eztags ADD language_mask integer not null default 0;
-- ALTER TABLE eztags_attribute_link ADD priority integer not null default 0;
DROP index IF EXISTS eztags_keyword;
CREATE TABLE eztags_keyword (
keyword_id integer not null default 0,
language_id integer not null default 0,
keyword varchar(255) NOT NULL default '',
@Opencontent
Opencontent / check_solr_schema.php
Created January 17, 2019 15:09
<?php
$path = '/Users/luca/git/AWS/solr-consorzioweb/java/solr';
$objects = new RecursiveIteratorIterator(new RecursiveDirectoryIterator($path), RecursiveIteratorIterator::SELF_FIRST);
foreach ($objects as $entry){
if ($entry->getFilename() == "schema.xml" ){
chdir($entry->getPath());
$path = $entry->getPath() . "/schema.xml";
$content = file_get_contents($path);
@Opencontent
Opencontent / do-a-release.md
Last active August 21, 2019 16:20

Automatismo per pubblicare una release

Dato un repo github che contiene solamente il composer delle dipendenze di altri repo, l'obiettivo è esporre un changelog delle modifiche di tutti i repo.

Prerequisiti

Installare composer-lock-diff (fork di Opencontent)

git clone https://github.com/Opencontent/composer-lock-diff.git
cd composer-lock-diff