/** * @param ModuleMresource_EntityMresource $oMresource * * @return int|bool */ public function Add($oMresource) { $aParams = array(':date_add' => F::Now(), ':user_id' => $oMresource->GetUserId(), ':link' => $oMresource->IsLink() ? 1 : 0, ':type' => $oMresource->GetType(), ':path_url' => $oMresource->GetPathUrl(), ':path_file' => $oMresource->GetPathFile(), ':hash_url' => $oMresource->GetHashUrl(), ':hash_file' => $oMresource->GetHashFile(), ':storage' => $oMresource->GetStorage(), ':uuid' => $oMresource->GetUuid()); $sql = "\n SELECT mresource_id\n FROM ?_mresource\n WHERE\n storage = ?:storage AND uuid = ?:uuid\n LIMIT 1\n "; $nId = $this->oDb->sqlSelectCell($sql, $aParams); if (!$nId) { $sql = "\n INSERT INTO ?_mresource\n (\n date_add,\n user_id,\n link,\n type,\n path_url,\n path_file,\n hash_url,\n hash_file,\n storage,\n uuid\n )\n VALUES (\n ?:date_add,\n ?d:user_id,\n ?d:link,\n ?d:type,\n ?:path_url,\n ?:path_file,\n ?:hash_url,\n ?:hash_file,\n ?:storage,\n ?:uuid\n )\n "; $nId = $this->oDb->sqlQuery($sql, $aParams); } return $nId ? $nId : false; }