Skip to content
Snippets Groups Projects
  1. Oct 14, 2013
  2. Oct 10, 2013
  3. Oct 09, 2013
    • Jared Hancock's avatar
      Fixup the installer · e055cc21
      Jared Hancock authored
      Fixup several minor bugs concerning initial experience
      e055cc21
    • Jared Hancock's avatar
      Completion of dynamic forms concept · 43b74f4a
      Jared Hancock authored
      Moved to an initial form which specifies the ticket's priority and issue and
      changed the rendering to render things properly. Now the user can decide
      where priority shows on the client side, and the priority privacy setting is
      placed in the dynamic form wizard.
      
      The standard form is added to every ticket without option. Extra forms can
      be defined and associated with help topics which can additionally be added
      to tickets upon creation. This allows for standardization of the dynamic
      data location for searches and filtering.
      
      Implemented advanced search for dynamic data. Along with reinstating the
      basic ticket search on keywords
      
      Implemented ticket filtering on dynamic data for both keyword searches as
      well as searches for special fields (drop-down lists, etc.)
      
      Phone number for users is now completely optional
      43b74f4a
    • Jared Hancock's avatar
      Move client information to separate formset · 53666db6
      Jared Hancock authored
      This moves client information like name and email address out of the general
      dynamic forms data for a ticket. It really paves the way for the first-class
      user of the future.
      53666db6
    • Jared Hancock's avatar
      Rebase form sections to forms and remove form sets · 59c219f4
      Jared Hancock authored
      Previously, form sections were grouped into form sets for reusability. This
      patch drops the form sets and makes form sections the new "forms".
      Eventually a section-header field will be added that technically does not
      add any dynamic data to the form, but allows for the same feature as having
      a form set with multiple sections.
      59c219f4
    • Jared Hancock's avatar
      Dynamic data for osTicket · 9e75169e
      Jared Hancock authored
      *This is a major redesign / rework of the osTicket base*
      
      This patch drops the concept of static ticket metadata and allows for an
      admin-configurable arbitrary data that is attachable to tickets
      
      The system is architected such that the base osTicket install now comes with
      a "default" form that has fields for subject, name, email, and phone number.
      This form is editable to allow for the addition of arbitrary other fields;
      however, the basic fields must remain in order to be associated with a
      help-topic and attached to a ticket.
      
      This concept can be expanded to allow for arbitrary data associated with
      registered clients or ticket thread items.
      
      Forms are comprised of sections. Sections have a title and instructions
      properties and a list of fields. Fields have various implementations to
      represent different data such as text, long answer, phone number, datetime,
      yes/no, and selections, and are configurable to define the look and feel and
      interpretation of the respective form field.
      
      Dropdown lists are represented as "Dynamic Lists", which are
      admin-configurable lists of items. Dropdowns can be optionally represented
      as Bootstrap typeahead fields.
      
      This also adds the start of a simple ORM which will hopefully be expanded in
      the future to support multiple database platforms. Currently, only MySQL is
      implemented.
      9e75169e
    • Jared Hancock's avatar
      Enable attachments by default · 484d2ef1
      Jared Hancock authored
      484d2ef1
    • Jared Hancock's avatar
      HTML ticket thread, inline images and draft support · 864d3539
      Jared Hancock authored
      Process inline attachments in thread entry and support inline images in
      piped emails
      
      Support inline images across the system, with draft support
      
      Migrate to a single attachment table
          That way we don't need a new table for everything we need to attach an
          inline image to (like a signature, for instance)
      
      Add richtext support for internal notes
      
      Implement images on site pages
      
      * Image paste in Redactor
      * Make non-local images optional
      * Placeholder for non-local images
      * Fix local image download hover
      * Don't re-attach inline images
      864d3539
  4. Aug 12, 2013
    • Jared Hancock's avatar
      Make default data translatable · 20f3e62a
      Jared Hancock authored
      This is one of the last major hurdles to make osTicket fully translatable.
      With the advent of 1.7.0, database migration is based on the MD5 hash of the
      install SQL file. Therefore, the install SQL script cannot be modified (ie.
      translated) or else the system cannot be migrated, since the MD5 hash will
      no longer match up.
      
      This patch pulls initial data out of the install file so that it can be
      translatable. Eventually the install worksheet can allow a drop-down box of
      the default system language. The default data from that language will be
      loaded into the system.
      20f3e62a
  5. Aug 09, 2013
  6. Jul 11, 2013
  7. Jul 09, 2013
    • Jared Hancock's avatar
      Installer uses the streams config · dfa90b8a
      Jared Hancock authored
      Allow the installation to use the same streams config and schema signatures
      as the migrater
      
      Allow the install to install mulitple database streams
      dfa90b8a
  8. Jul 03, 2013
  9. May 28, 2013
    • Jared Hancock's avatar
      Various bug-fixes for the upgrader · 0e0f6dcb
      Jared Hancock authored
      - timezone_offset was dropped from the config table at 1.7-dpr1
      - upgrader: only apply five patches in one request
      - upgrader: fix readPatchInfo to work correctly
      - session: support migrating from 1.6 (again)
      - config: support migrating from 1.6 (fallback)
      - config: no default for 'isonline' setting
      - config: fix SQL whitespace issue for schema signature fallbacks
      - config: hash 1.6 versions in the schema signature lookup
      - upgrader: fix logging bug in attachment migration
      0e0f6dcb
    • Jared Hancock's avatar
      Federate configuration settings · db81f071
      Jared Hancock authored
      Change the config table from a column-based table to a key-value table
      with namespacing. This allows several parts of osTicket to store their
      respective configurations in the same table without requiring database
      structure updates
      
      'namespace' is reserved in PHP
      db81f071
  10. May 23, 2013
    • Jared Hancock's avatar
      Use ticket default department=0 · 3e206b68
      Jared Hancock authored
      Since the first department id cannot be assumed
      3e206b68
    • Jared Hancock's avatar
      Use database default storage engine · 55e1c8ec
      Jared Hancock authored
      Drop required usage of MyISAM tables, and drop fulltext indexes as they
      are not used in the code currently anyway. Also, use a blob to store
      session data so as not to waste space with UTF-8 encoding. Lastly, fix
      session_id storage to use VARCHAR(255) which is required for versions
      of MySQL < 5.0.3, and use ascii for the storage model for the
      session_id as it will contain simple characters only.
      55e1c8ec
  11. May 22, 2013
    • Jared Hancock's avatar
      Allow osTicket to install on a database cluster · c83248ce
      Jared Hancock authored
      The problem stems from assumed MySQL insert ids. In MySQL clusters, the id
      numbers will not necessarily be consecutive. This patch causes the install
      and upgrade patches to lookup the assumed values for the linked id numbers.
      c83248ce
  12. Feb 14, 2013
  13. Jan 21, 2013
  14. Jan 18, 2013
  15. Dec 17, 2012
  16. Nov 16, 2012
  17. Oct 19, 2012
  18. Oct 02, 2012
  19. Sep 27, 2012
  20. Sep 18, 2012
  21. Sep 14, 2012
    • Jared Hancock's avatar
      Add chunked file data support · e51bb66f
      Jared Hancock authored
      This will remove the upper limit of BLOB sizes imposed by MySQL with the
      max_allowed_packet setting completely.
      
      This adds a new table %file_chunk which will contain the filedata in smaller
      chunks (256kB). It also includes a new class, AttachmentChunkedData, which
      will handle reading and writing the data, abstracting away the chunks.
      
      This is done by migrating data from the %file table to the %file_chunk
      table. One must beware that this must safely (the migration that is) plug
      into the both the live osTicket developers as well as the users doing a full
      upgrade from osTicket-1.6*. For this, the AttachmentFile::save method was
      patched to use the new AttachmentChunkedData class to write the attachment
      data to the database in chunks. That is, the migrater will use the new code
      on the major upgrade and bypass the filedata column of the %file table
      altogether. Therefore, the patch associated with this commit will not
      migrate any data for the major upgrade.
      
      For developers doing incremental upgrades, the patch included in this
      commit will transfer the data from the %file data to the new %file_chunk
      table by chunking it. As written, only the first 16MB of the attachment is
      migrated. This could easily be adjusted, but it seems like a reasonable
      limit for now.
      e51bb66f
  22. Sep 10, 2012
  23. Sep 03, 2012
  24. Aug 31, 2012
  25. Aug 30, 2012
  26. Aug 13, 2012
  27. Jul 22, 2012
  28. Jul 21, 2012
  29. Jul 16, 2012
  30. Jul 09, 2012
Loading