- Jul 03, 2019
-
-
JediKev authored
This addresses an issue where `IndexOldStuff()` doesn't reindex everything it's supposed to. The reindex leaves out all of the Thread Entries with empty titles or bodies. This is due to the SQL statement that retrieves thread entries. In the SQL statement, we check if the sum of the Thread Entry Title length and the Thread Entry Body length is greater than 0. If so we reindex the entry, otherwise we exclude it. The problem is both ```LENGTH(A1.`title`)``` and ```LENGTH(A1.`body`)``` can return `NULL` and you cannot add `NULL` (a string) to an integer. This updates the SQL to add `IFNULL()` statements around the possible `NULL` values so that if `NULL` we typecast to integer of 0 which can be added to integers successfully.
-
- May 10, 2019
-
-
Peter Rotich authored
-
Peter Rotich authored
cli: Package Better Wording
-
- May 09, 2019
-
-
Peter Rotich authored
FAQ Issues
-
Peter Rotich authored
cli: Package No File Permissions
-
Peter Rotich authored
oops: .eml/.msg Missing Not Operator
-
Peter Rotich authored
Lint Fixes
-
JediKev authored
This updates the variable name that determines if the current PHP version is 5.6+ from `$php56` to `$php56plus`. This will help other understand better what the variable is/does.
-
- Apr 30, 2019
-
-
Peter Rotich authored
-
- Apr 29, 2019
-
-
JediKev authored
This addresses a typo where we are missing a not operator in class MailFetcher when checking for no `$body` in the fetched attachments. This adds the not operator so that the `if()` statement is properly executed and we correctly set a fake body when there is none.
-
- Apr 25, 2019
-
-
JediKev authored
This addresses an issue where the `package` cli module is leaving out the permissions on files. This causes the final ZIP archive to contain files without permissions meaning the files are un-usable until you restore permissions. This can make life difficult on people trying to install osTicket with minimal knowledge as they wouldn’t know what is wrong. This is due to the `setExternalAttributesName` method not shifting 16 bits on the file "mode" which will not translate to binary. The file "mode" is the inode protection mode for a file returned by the `stat()` method. It is essentially a decimal representation of a file's permissions. Since "mode" is in decimal format we need to shift by 16 bits to translate it to binary so the archiver understands. Once the mode is translated to binary the permissions are preserved.
-
aydreeihn authored
This commit gets rid of PHP warnings. Additionally, it updates the lint tests to be more accurate.
-
- Apr 24, 2019
-
-
Peter Rotich authored
-
JediKev authored
This updates jQuery to the latest stable release of v3.4.0.
-
Peter Rotich authored
-
Peter Rotich authored
xss: XSS To LFI Vulnerability
-
JediKev authored
This addresses a vulnerability found by [AkkuS CW](https://pentest.com.tr) where a simple XSS attempt can lead to an LFI (Local File Inclusion) attack. The issue stems from the system returning the unformatted file contents in an error message when uploading a CSV to the User Importer. This formats the contents before uploading so that if the contents are returned in an error message they will not be executed by the browser which therefore prevents XSS attempts and the possibility of an LFI attack. This also formats all the user-created data sent to ImportError to prevent the same issue.
-
- Apr 23, 2019
-
-
Peter Rotich authored
issue: .eml/.msg Attachments
-
- Apr 17, 2019
-
-
JediKev authored
This addresses an issue where `.eml` and `.msg` files on incoming mails are being dropped. This is due the the mail fetcher that tries to process `.eml`/`.msg` files and adds them as thread entries rather than adding them as attachments. This adds a new section that utilizes a new method to fetch the body of `.eml`/`.msg` files, fetches the subjects of the `.eml`/`.msg` files as the attachment names, and creates attachments. This preserves the `.eml` and `.msg` files and adds them to the pertinent thread entries as attachments.
-
- Apr 16, 2019
-
-
Peter Rotich authored
-
Peter Rotich authored
Update README.md
-
- Apr 15, 2019
-
-
ntozier authored
-
Peter Rotich authored
issue: sendAccessLink On NULL
-
Peter Rotich authored
issue: iFrame Single Quotes
-
- Apr 11, 2019
-
-
JediKev authored
It's all about the single quotes baby! Apparently I can't read; the single quotes are only meant for word options such as `'self'` and `'none'`. When adding single quotes to the `<host-source>` options it takes them literally…too literally. For example, if your options are `'localhost:80 localhost:8080 localhost:8000'` then `'localhost:80` and `localhost:8000'` will be seen as "invalid" due to the single quotes. This removes the single quotes from every line that sets the CSP so all options are valid. This also adds single quotes around the `self` option so it stays valid as well.
-
- Apr 10, 2019
-
-
ntozier authored
-
- Apr 05, 2019
-
-
aydreeihn authored
This commit fixes several issues with how we manage FAQs and related objects. 1. When trying to add a Help Topic to an FAQ, we should add the record to the faq_topic table after saving the faq so that we can accurately retrieve the faq_id 2. When deleting a Help Topic, we need to make sure we're using the topic->delete function rather than deleting based on a QuerySet so that the related FAQ Topics will also be deleted. 3. When deleting a FAQ Category, we need to ensure that we delete all related FAQs and FAQ Topics. To do this, we should use the delete function from the FAQ class first to delete all related FAQs and FAQ Topics and then we should use the Category delete function to delete the remaining Category (remove faqs->expunge from the category->delete function since it we now pass through faq->delete as well)
-
- Apr 04, 2019
-
-
JediKev authored
This addresses an issue where entering a collaborator's email to send ticket email access link throws a fatal error. This is due to the method that checks for tickets with the User's email equal to the email provided. This only checks for User's emails not Collaborator emails. This adds a check for Collaborator emails as well so this will not crash out.
-
- Apr 01, 2019
-
-
Peter Rotich authored
issue: iFrame On Install
-
- Mar 29, 2019
-
-
JediKev authored
This addresses the "Call to getAllowIframes() on NULL" error on installation pages. This is due to 4781 that introduced the concept of allowing multiple iFrames, where we are not checking for `$cfg` before calling the method. This adds a check for `$cfg` so the errors do not occur.
-
Peter Rotich authored
oops: Emojis Strip Korean
-
JediKev authored
This addresses an issue where Korean text is stripped from the body. This is due to the strip_emoticons function, as Korean text is in the same unicode range as some of the emojis.
-
- Mar 27, 2019
-
-
Peter Rotich authored
iframe: Allow Multiple iFrame Domains
-
Peter Rotich authored
issue: Maxfilesize Comma Crash
-
- Mar 26, 2019
-
-
Peter Rotich authored
issue: Strip Emoticons
-
Peter Rotich authored
Fix bug: send new ticket alert to account manager
-
JediKev authored
This addresses an issue where emoticons/emojis cut off the remainder of the email when being added to a ticket thread.
-
- Mar 21, 2019
-
-
Peter Rotich authored
issue: Organizations Users Sort
-
- Mar 18, 2019
-
-
JediKev authored
This addresses issue 4803 where sorting by Users on Organizations does not sort properly. It sorts by name instead of the User count. This corrects the value in the `$sortOptions` array from `users` to `user_count`.
-
Hans Chen authored
not sending new ticket alert to account manager.
-