matthewpoer

Execute SQL scripts and generate TSV files

• mysql -h HOSTNAME -u USERNAME -pPASSWORD DATABSE < calls_all_invited_people.sql > calls_all_invited_people.tsv
• mysql -h HOSTNAME -u USERNAME -pPASSWORD DATABSE < calls_all_invited_people_condensed_guids.sql > calls_all_invited_people_condensed_guids.tsv
• mysql -h HOSTNAME -u USERNAME -pPASSWORD DATABSE < meetings_all_invited_people_condensed_guids.sql > meetings_all_invited_people_condensed_guids.tsv
• mysql -h HOSTNAME -u USERNAME -pPASSWORD DATABSE < tasks_all.sql > tasks_all.tsv

Clean TSV files to map \r\n to just \n (removing the \r reference)

• sed -e 's/\r//g' -i calls_all_invited_people.tsv
• sed -e 's/\r//g' -i calls_all_invited_people_condensed_guids.tsv
• sed -e 's/\r//g' -i meetings_all_invited_people_condensed_guids.tsv

matthewpoer

// note that the on-screen JS has a $ but it is not true jQuery
function findButton(){
  button = $('[data-tooltip="Show trimmed content"]');
  if(typeof button != 'undefined' && button.id){
    return button;
  } else {
    return FALSE;
  }
}

matthewpoer

select 
quotes.name,products.name,products.quantity,products.cost_price,
products.discount_price,
quotes.id as quotes_id,
quotes.deleted as quotes_deleted,
product_bundle_quote.id as product_bundle_quote_id,
product_bundle_quote.deleted as product_bundle_quote_deleted,
product_bundles.id as product_bundles_id,
product_bundles.deleted as product_bundles_deleted,
product_bundle_product.id as product_bundle_product_id,

matthewpoer

find ./ -type f -name \*.php -exec php -l {} \; | grep -v 'No syntax errors'

matthewpoer

<?php

echo "<h1>JSON Array to Double Array PHP Bug(?)</h1>";

echo "<p>Attempt to demonstrate a potential PHP Bug wherein a string of data that includes an equals sign (=), when json_encode()'d twice and delivered to a web server, will be interpreted as a split in a data array.</p>\n";

$array = array(
    'one' => 'one is one',
    'two' => 'two = two',
);

matthewpoer

<?php
if (!defined('sugarEntry')) define('sugarEntry', true);

chdir(dirname(__FILE__));
define('ENTRY_POINT_TYPE', 'api');
require_once('include/entryPoint.php');

$sapi_type = php_sapi_name();
if (substr($sapi_type, 0, 3) != 'cli') {
    sugar_die("cron.php is CLI only.");

matthewpoer

Turn HTML fields_meta_data dumps into SQL statements

(1) Manually remove

and open/end tags

(2) remove all strings matching class="tabDetailViewD\w"

(3) replace  

matthewpoer

#/bin/sh
# 
# NumberTwo.sh
# (because it's gonna take a dump)
# 
# Dump and re-load some large database into a new sandbox. Helpful to have
# this in a  script that we can run in the background when the database is 
# large. 
#  
# Use it like this:

matthewpoer

<?php
require_once('clients/base/api/MetadataApi.php');

/**
 * custom/clients/base/api/CustomMetadataApi.php
 */
class CustomMetadataApi extends MetadataApi
{

    /**

matthewpoer

update job_queue set 
date_modified = date_entered,
execute_time = date_entered,
status = 'queued',
resolution = 'queued',
message = NULL,
failure_count = NULL,
client = ''
where name = 'tcx_job_account_set_teams' and resolution = 'failure';