View repair.php
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2017-11-01 on Sugar 7.9.2.0 | |
| function usage($error = '') { | |
| if (!empty($error)) print(PHP_EOL . 'Error: ' . $error . PHP_EOL); | |
| print(' php ' . __FILE__ . ' --instance /full/path' . PHP_EOL); |
esimonetti
/ secretHandling.php
Last active May 13, 2019
Sample of programmatic AES256GCM and blowfish encryption and decryption of secret value in Sugar
View secretHandling.php
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2019-05-13 | |
| // Sample of programmatic AES256GCM and blowfish encryption and decryption of secret value in Sugar | |
| // secret value to encrypt for storage purposes, and to decrypt real-time |
esimonetti
/ SugarACLLock.php
Last active Apr 22, 2019
SugarCRM v7 - Conditional record locking through ACL's customisation
View SugarACLLock.php
| <?php | |
| // | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2016-05-08 on Sugar 7.7.0.0 | |
| // file: custom/data/acl/SugarACLLock.php | |
| // | |
| // ACL to lock record in certain conditions. Always allow admin users and specific user ids |
esimonetti
/ TidewaysProf.php
Last active Feb 20, 2019
POC of Tideways profiling extension for Sugar 7.9.1.0 on PHP 7.1
View TidewaysProf.php
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // Original work: https://gist.github.com/lblockken/78a59273f2460b36eb127a7c2ee510a1 | |
| // | |
| // 2017-07-31 on Sugar 7.9.1.0 with PHP 7.1 | |
| // filename: custom/include/SugarXHprof/TidewaysProf.php |
esimonetti
/ ProcessQueueCommand.php
Last active Jan 21, 2019
Sugar CLI command to run index processing without waiting for the scheduler - SUPERSEDED, LOOK INTO ./bin/sugarcrm search:silent_reindex and ./bin/sugarcrm search:silent_reindex_mp
View ProcessQueueCommand.php
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2017-12-15 on Sugar 7.9.2.0 | |
| // Sugar CLI command to run index processing without waiting for the scheduler | |
| // | |
| // Trigger reindex with: ./bin/sugarcrm search:reindex | |
| // Process records by running either as a background process or with a cron: ./bin/sugarcrm elastic:process_records |
View list.php
| <?php | |
| // | |
| // Enrico Simonetti | |
| // 2019-01-10 | |
| // | |
| // file: custom/Extension/modules/Reports/Ext/clients/base/views/list/list.php | |
| // | |
| // Add tags to reports on listviews | |
| // |
esimonetti
/ mysql_tables_optimize.php
Last active Jan 4, 2019
CLI script to optimize Sugar mysql tables, by dropping all non-primary indices, optimizing and finally re-creating indices. Script similar to https://gist.github.com/esimonetti/7c4d57d57464ce6a71973de6fe0da089 but implementing the recommendations described here https://www.percona.com/blog/2010/12/09/mysql-optimize-tables-innodb-stop/
View mysql_tables_optimize.php
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2019-01-04 on Sugar 8.0.2 | |
| // | |
| // CLI script to optimize Sugar mysql tables, by dropping all non-primary indices, optimizing and finally re-creating indices | |
| function usage($error = '') { |
esimonetti
/ mysql_tables_optimize.php
Last active Jan 4, 2019
CLI script to optimize Sugar mysql tables. Have a look at https://gist.github.com/esimonetti/94cd0c7d966684d7650e471c153d7e9d for a more optimised version according to https://www.percona.com/blog/2010/12/09/mysql-optimize-tables-innodb-stop/
View mysql_tables_optimize.php
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2018-09-20 on Sugar 8.0.0 | |
| // | |
| // CLI script to optimize Sugar mysql tables | |
| ini_set('memory_limit', '64M'); |
esimonetti
/ commentlog.php
Created Dec 28, 2018
Show last 10 commentlog entries on Cases, with the newest one at the top
View commentlog.php
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2018-12-28 Sugar 8.3.0 | |
| // Show last 10 commentlog entries on Cases, with the newest one at the top | |
| // | |
| // file: custom/Extension/modules/Cases/Ext/Vardefs/commentlog.php | |
| // |
esimonetti
/ CustomSugarCacheRedis.php
Last active Dec 13, 2018
Custom implementation of Sugar redis cache, using authentication and persistent connection
View CustomSugarCacheRedis.php
| <?php | |
| // Enrico Simonetti | |
| // enricosimonetti.com | |
| // | |
| // 2017-11-23 tested on Sugar 7.9.2.0 on PHP 7.1 with the addition of: https://gist.github.com/esimonetti/a99ea05b68cd2586949944c1b24b2921 | |
| // Custom implementation of Sugar redis cache, using authentication if configured and using persistent connections if configured | |
| // | |
| // file: custom/include/SugarCache/CustomSugarCacheRedis.php |
NewerOlder