/**
* insert record on Add & Register pages
* @intellisense
*/
function DoInsertRecordSQL($table,&$avalues,&$blobfields, $pageid, &$pageObject, &$cipherer, &$keys)
{
global $error_happened,$conn,$inlineadd,$message,$failed_inline_add,$strTableName;
// make SQL string
$strSQL = "insert into ".AddTableWrappers($table)." ";
$strFields="(";
$strValues="(";
$blobs = PrepareBlobs($avalues,$blobfields);
foreach($avalues as $akey=>$value)
{
$strFields .= $pageObject->pSet->getTableField($akey).", ";
if(in_array($akey, $blobfields))
$strValues.=$value.", ";
else
if(is_null($cipherer))
$strValues .= add_db_quotes($akey,$value).", ";
else
$strValues .= $cipherer->AddDBQuotes($akey,$value).", ";
}
if(substr($strFields,-2)==", ")
$strFields=substr($strFields,0,strlen($strFields)-2);
if(substr($strValues,-2)==", ")
$strValues=substr($strValues,0,strlen($strValues)-2);
$strSQL.=$strFields.") values ".$strValues.")";
if(!ExecuteUpdate($pageObject,$strSQL,$blobs,true))
return false;
if($error_happened)
return false;
$pageObject->ProcessFiles();
if ( $inlineadd==ADD_INLINE )
{
$status="ADDED";
$message=""."Record was added"."";
$IsSaved = true;
}
else
$message="<<< "."Record was added"." >>>";
$auditObj = GetAuditObject($table);
if($inlineadd==ADD_SIMPLE || $inlineadd==ADD_INLINE || $inlineadd==ADD_ONTHEFLY || $inlineadd==ADD_POPUP || $inlineadd==ADD_MASTER || tableEventExists("AfterAdd",$strTableName) || $auditObj)
{
$keys = prepareTableKeysAfterInsert($table, $avalues, $pageObject, $keys);
}
return true;
}
if($retval && $pageObject->isCaptchaOk)
{
//add or set updated lat-lng values for all map fileds with 'UpdateLatLng' ticked
$pageObject->setUpdatedLatLng( $avalues );
$_SESSION[$strTableName."_count_captcha"] = $_SESSION[$strTableName."_count_captcha"]+1;
$customAddResult = true;
$customAddError = false;
if($eventObj->exists("CustomAdd"))
{
$customAddResult = $eventObj->CustomAdd($avalues, $keys, $customAddError, (boolean)$inlineadd, $pageObject);
if($keys && !is_array($keys))
$keys = array("ID" => $keys);
elseif((is_array($keys) && !count($keys)) || !$keys)
$keys = prepareTableKeysAfterInsert($strOriginalTableName, $avalues, $pageObject, $keys);
if(!$customAddResult && !$customAddError)
$mesClass = "";
}
if($customAddResult && !$customAddError)
{
if(DoInsertRecord($strOriginalTableName,$avalues,$blobfields,$id,$pageObject, $pageObject->cipherer, $keys))
{
$IsSaved=true;
// after edit event
if($auditObj || $eventObj->exists("AfterAdd"))
{
foreach($keys as $idx=>$val)
$avalues[$idx]=$val;
