1. 20 May, 2017 1 commit
    • Carsten  Rose's avatar
      #3766 / SQL_LOG per tt_content record einstellbar machen · 4b0d1413
      Carsten Rose authored
      Add `sqlLog` and `sqlLogMode` to QFQ tt-content records.
      Add mode 'error' and `none` to sqlLogMode.
      Manual.rst: Added explanations for SQL_LOG, SQL_LOG_MODE, and tt-content pendants sqlLog, sqlLogMode. Update config.qfq.ini to latest attributes.
      Database.php: rename $mode to $currentQueryMode to make it more descriptive. Recode dbLog().
      Logger.php: do nothing if there is no file defined.
      Report.php: new function checkUpdateLog().
      Config.php: Set defaults for config.qfq.ini SQL_LOG and SQL_LOG_MODE
      Store.php: Fix problem that an empty SQL_LOG will be prependad with SYSTEM_PATH_EXT.
      4b0d1413
  2. 12 May, 2017 1 commit
  3. 09 May, 2017 2 commits
    • Carsten  Rose's avatar
      #3679: Automatic DB Update · d1b203dd
      Carsten Rose authored
      Fixed: unnecessary exception if there is no Form / FormElement table
      Database.php: New function playSqlFile().
      DatabaseUpdate.php: missing table Form won't throw an exception anymore.
      Manual.rst: note that formEditor.sql will be played automatically.
      d1b203dd
    • Carsten  Rose's avatar
      #3679, Automatic DB update - Schema & FormEditor · 05b32a30
      Carsten Rose authored
      For updates of QFQ prior to 0.17.0, do:   ALTER TABLE  `Form` COMMENT =  'Version=<your old QFQ version>'
      DatabaseUpdate.php, DatabaseUpdateData.php: new class.
      QuickFormQuery.php: Add DB UpdateCheck
      Database.php: moved to new subdirectory `database`. Add 'ALTER' as a new SQL command.
      FormAction.php, TypeAhead.php, Report.php, Sendmail.php, FillStoreForm.php, Store.php, AbstractBuild.php, Delete.php, Evaluate.php: Update path to Database.php.
      05b32a30
  4. 24 Apr, 2017 1 commit
    • Carsten  Rose's avatar
      Implemented new escape class 'mysql' (realEscapeString). · ba817c0e
      Carsten Rose authored
      Implemented defaultEscapeType. configurable via config.qfq.ini (global) and per Form.
      Implemented max GET parameter lenght. Default: 50. BTW: in phpunit test there have been a parameter 'file' which exceeds the limit of 32.
      
      Config.qfq: Skip empty variable names - happens in phpunit tests. Read new `systemEscapeTypeDefault`.
      Constants.php: renamed  TOKEN_LDAP_ESCAPE_* to TOKEN_ESCAPE_LDAP_*. Add TOKEN_ESCAPE_MYSQL, TOKEN_ESCAPE_NONE
      Database.php: Set charset to real_escape_string() functions properly. Proxy for mysqli::real_escape_string()
      Evaluate.php: Respect global escapeTypeDefault. Implement
      formEditor.sql: add column `escapeTypeDefault`. Add FormElement 'escapeTypeDefault'.
      ba817c0e
  5. 02 Apr, 2017 1 commit
    • Carsten  Rose's avatar
      #3385 / templateGroup: insert/update/delete non primary records · 8db50d60
      Carsten Rose authored
      Manual.rst: update doc how to insert/update/delete non primary templateGroup records.
      FormAction.php: removed $templateGroupIndex - solved implicit by defining a LIMIT on 'slaveId' . Implemented '%D' (one below %d). Implemented FE_SQL_HONOR_FORM_ELEMENTS - reduces unecassary SQL queries.
      HelperFormElement.php: moved function 'explodeTemplateGroupElements()' to 'QuickFormQuery.php'
      Database.php: remove call to explodeTemplateGroupElements() - not necessary at that place.
      QuickFormQuery.php: fill STORE_RECORD during Formload - to read templateGroup records very early. Local copy of `getNativeFormElements()`, new `explodeTemplateGroupElements()`
      8db50d60
  6. 26 Mar, 2017 2 commits
    • Carsten  Rose's avatar
      #3433 | templateGroup on primary Record: Values of removed copies are not deleted · 5d817af7
      Carsten Rose authored
      The new implementation creates empty fake instances of all copies of templateGroup FormElements. Those are empty. Before save, the submitted form values will be expanded with the empty fake templateGroup FormElements and such empty values will be saved.
      FormAction.php: Rename constant SQL_FORM_ELEMENT_TEMPLATE_GROUP to SQL_FORM_ELEMENT_TEMPLATE_GROUP_FE_ID - to be more precise.
      HelperFormElement.php, Database.php: new function explodeTemplateGroupElements()
      5d817af7
    • Carsten  Rose's avatar
      #3431 / typeAheadSql: columnname 'key' is a reserverd SQL statement - replace... · f906b671
      Carsten Rose authored
      #3431 / typeAheadSql: columnname 'key' is a reserverd SQL statement - replace by 'id'. Additional the parametername 'typeAheadLdapKeyPrintf' renamed to 'typeAheadLdapIdPrintf'.
      typeAhead.php: fixed typo.
      TypeAhead.php: introduced new mapping from 'id' (SQL) to 'key' (API).
      AbstractBuildForm.php: Constant renamed.
      Database.php: update function makeArrayDict() to reflect name mapping.
      f906b671
  7. 24 Mar, 2017 1 commit
  8. 14 Mar, 2017 1 commit
  9. 02 Mar, 2017 1 commit
  10. 09 Feb, 2017 1 commit
    • Carsten  Rose's avatar
      Create function `Database->getNativeFormElements()` to unify all needed... · 2b29d2ca
      Carsten Rose authored
      Create function `Database->getNativeFormElements()` to unify all needed actions on fresh loaded FormElements like explodeParameterInArrayElements, duplicateRetypEelements, copyAttributesToFormElements. Native FormElements will be loaded on 4 different places in 3 classes.
      
      HelperFormElement.php: Moved copyAttributesToFormElements() from QuickFormQuery to HelperFormElement.
      AbstractBuildForm.php, BuildFormBootstrap.php, QuickFormQuery.php : Use of Database->getNativeFormElements()
      Database.php: HelperFormElement::copyAttributesToFormElements()
      2b29d2ca
  11. 02 Feb, 2017 1 commit
  12. 31 Jan, 2017 1 commit
  13. 29 Nov, 2016 1 commit
  14. 19 Oct, 2016 1 commit
  15. 05 Oct, 2016 1 commit
  16. 23 Sep, 2016 1 commit
  17. 01 Jun, 2016 1 commit
    • Carsten  Rose's avatar
      KeyValueStringParser.php: phpdoc · 58a1f24c
      Carsten Rose authored
      Link.php, AbstractBuildForm.php, BuildFormBootstrap.php, Database.php: introduced constants for glyph. Code rearranged
      testtabbles.sql: extended to test Delete with filenames
      58a1f24c
  18. 31 May, 2016 1 commit
  19. 30 May, 2016 1 commit
  20. 26 May, 2016 1 commit
  21. 11 May, 2016 1 commit
  22. 28 Apr, 2016 1 commit
  23. 18 Apr, 2016 1 commit
  24. 13 Apr, 2016 1 commit
    • Carsten  Rose's avatar
      Preparation to update Form after saving values. · 092e6deb
      Carsten Rose authored
      save.php: return JSON with updated values of all fields.
      AbstractBuildForm.php: updated to deliver values of all form elements
      Constants.php: constants to distinguish all or specific values of FEs. QUERY_TYPE_*
      Database.php: doSQL now returns affectedrows or lastinsertid in case of udpate/inset. Typos fixed.
      QuickFormQuery.php: deliver Values as JSON after save.
      Save.php: return lastinsertid or affectedrows.
      092e6deb
  25. 02 Apr, 2016 1 commit
    • Carsten  Rose's avatar
      UserReportException.php: Added field SYSTEM_REPORT_COLUMN_NAME to output.... · 3f6fedaa
      Carsten Rose authored
      UserReportException.php: Added field SYSTEM_REPORT_COLUMN_NAME to output. Array members renamed to SYSTEM_*.
      Various files adjusted to inlcude renamed file `UserFormException.php`.
      Link.php: Mamut switch() in parseItem() refactored to use $callTable.
      Report.php: refactoring started to use UserReportException() instead of SyntaxReportException. Startet removing all fr_error usages.
      3f6fedaa
  26. 01 Apr, 2016 1 commit
  27. 14 Mar, 2016 1 commit
    • Carsten  Rose's avatar
      AdministratorManual/Index.rst: added note to install mysqlnd Driver. · 4000736f
      Carsten Rose authored
      UsersManual/Index.rst: added Form.showButton
      Support: added findInSet()
      AbstractBuildForm: added createDeleteUrl(), prepareSubrecord(), getFormTable(). Rewrote buildSubrecord(): added 'delete' link, rearranged 'new' link. 'ShowDebugInfo' enhanced.
      BuildFormBootstrap: rewrote BuildButton() to switch New/Delete Button on or off. Show debugInfo as tooltip.
      Constants: New Subrecord contants.
      formEditor.sql: added Form.showButton. Adjusted records
      4000736f
  28. 11 Mar, 2016 1 commit
  29. 02 Mar, 2016 1 commit
  30. 01 Mar, 2016 1 commit
    • Carsten  Rose's avatar
      Db, Link, Report, Utils: renamed FALSE to false · c10434ef
      Carsten Rose authored
      Link: replaced TYPO3_CONF_VARS by STORE_SYSTEM
      Sip, Store: PhpDoc
      AbstractBuildForm, BuildFormBootstrap, Constants: implemented constant SYSTEM_SHOW_DEBUG_INFO
      Database: rewrote errormessage
      c10434ef
  31. 21 Feb, 2016 1 commit
  32. 17 Feb, 2016 1 commit
  33. 11 Feb, 2016 2 commits
  34. 10 Feb, 2016 1 commit
  35. 09 Feb, 2016 1 commit
  36. 02 Feb, 2016 1 commit
  37. 29 Jan, 2016 1 commit