RunQuery($sSQL, FALSE);
// False means do not stop on error
$sSQL = "UPDATE IGNORE config_cfg SET cfg_value='Include/fpdf17' WHERE cfg_name='sFPDF_PATH'";
RunQuery($sSQL, FALSE);
// False means do not stop on error
// Update the format of the scanned check stored in the family record.
// The original implementation stored the whole string, including the check number.
// The new version strips out the check number to facilitate matching. The original
// version worked most of the time, but not in the rare cases when the check number
// was in the middle.
require "Include/MICRFunctions.php";
$micrObj = new MICRReader();
$sSQL = "SELECT fam_ID, fam_scanCheck from family_fam";
$rsFamilies = RunQuery($sSQL);
while ($aRow = mysql_fetch_array($rsFamilies)) {
$scanFormat = $micrObj->IdentifyFormat($aRow['fam_scanCheck']);
if ($aRow['fam_scanCheck'] != '' && $scanFormat != $micrObj->NOT_RECOGNIZED) {
$newScanCheck = $micrObj->FindRouteAndAccount($aRow['fam_scanCheck']);
$sSQL = "UPDATE family_fam SET fam_scanCheck='{$newScanCheck}' WHERE fam_ID=" . $aRow['fam_ID'];
if (!RunQuery($sSQL, FALSE)) {
break 2;
}
// break while and for
}
}
// add time zone config parameter, now mandatory for time functions in php
$sSQL = "INSERT IGNORE INTO `config_cfg` VALUES (65, 'sTimeZone', 'America/New_York', 'text', 'America/New_York', 'Time zone- see http://php.net/manual/en/timezones.php for valid choices.', 'General', NULL)";
$rsIns = RunQuery($sSQL, FALSE);
// False means do not stop on error
// Add config 'sGMapIcons' for icons list for family map
//
