|
BUILD 1.3.1 - 26th March 2010
=============================================
Changes
and fixes
- Template fix
- Fix HTML when adding announcements
To upgrade from 1.3.0 replace:
- users/ index.php
- admin / sources / 2.php
BUILD 1.3.0 - 2nd March 2010
=============================================
Additions
- Domain name
Ability to use the front end of SitePanel with 3 different domain names (on the same server) under 1 admin area and 1 database under 1 license (admin area must be run under licensed domain).
- GUI Updates.
Ability to choose which GUI a knowledge base article or an announcement belongs to. Option to select a single or multiple GUI whilst adding or editing these.
- GUI Updates.
Ability to assign a GUI to a domain name so if that domain name is viewed the selected gui will automatically load (1 GUI per domain name if selected).
- Articles update.
Ability to enable or disable an article so it is either viewable or not by users.
- Knowledge base and Article update.
The content is now added as html rather than BBcode.
- Knowledge base and Article update.
The excellent Xinha html editor has been added. This offers the ability to easily write and format articles/ announcements and upload images.
- New Sitepanel Theme on front and back ends.
Changes and fixes
- Front end downloads now connect to a function file which will call the file to be downloaded rather than opening the file itself. This means the download folder remains hidden and is more secure.
- Ticket sort order fix - Sometimes replys to tickets were not in the order they were written. This should fix this.
- Admin user password change fix. Changing user passwords did not work previously.
- Ticket 'Suggested solutions' in admin would error if there was a ' in the post title.
- Various database changes needed for the additions.
Template upgrades.
If upgrading copy across the following files from the 'user_default' folder.
- index.tpl
- kb_post.tpl
- kb_main.tpl
BUILD 1.2.1 Castlehill - 18th January 2007
=============================================
- included SitePanel3 API version 1.1 (no ref)
- fixed minor formatting bug when sending plain-text emails (no ref)
- email address format in now checked when creating new account or new ticket [user] (no ref)
- CAPTCHA authentication for account registration and new ticket creation [user] (no ref)
- users must now be logged in before submitting comments to the knowledge base [user] (no ref)
- fixed security bug where arbitrary HTML code could be injected into email subject headers [NA] (no ref)
- added email ban list [NA] (no user)
- various other small bug fixes, grammar and spelling fixes and updates [NA] (no ref)
Template Files
---------------------------------------------
create_ticket.tpl
create_ticket2.tpl
register.tpl
register2.tpl
index.tpl
kb_post.tpl
Database
---------------------------------------------
INSERT INTO {prefix}config VALUES (42, 'enable_captcha', '1');
CREATE TABLE {prefix}bans (
id int(10) NOT NULL auto_increment,
address VARCHAR(255),
banned_by VARCHAR(255),
time int( 20 ),
KEY id (id)
) TYPE = MyISAM;
BUILD 1.2 Castlehill - 25th August 2006
=============================================
- included SitePanel3 API version 0.99 (no ref)
- included compatibility with TicketCheck version 2, via API (no ref)
- added insert date as variable in system, particularly in email templates ( http://forum.sitepanel3.com/index.php?showtopic=413 )
- system autoresponder now toggleable for piped emails (no ref)
- added re-open ticket on pipe reply option (no ref)
- added new alert rule option: only alert assigned admin on ticket reply if possible (no ref)
- added auto-assign ticket to first admin responder option ( http://forum.sitepanel3.com/index.php?showtopic=401 )
- added parsed email attachment support (no ref)
- added option to use parser in "test" mode (no ref)
- added option to view raw email data for any parsed email (no ref)
- added option to block suspicious emails based on subject (no ref)
- added toggleable knowledge base answer guessing when submitting tickets with snazzy AJAX interface (no ref)
- added individual ticket limits for each user ( http://forum.sitepanel3.com/index.php?showtopic=450 )
- added flag/unflag ticket links in individual ticket view (no ref)
- added extra options to maintenance section (no ref)
- added response times by admin user to reports and statistics sections (no ref)
- added response times by department to reports and statistics sections (no ref)
- fixed bug with email pipe when being run on certain server configurations (no ref)
- fixed bug with knowledge base article rating system (no ref)
- fixed knowledge base link problem (no ref)
- fixed SQL bug when dealing with certain department restrictions on admin users ( http://forum.sitepanel3.com/index.php?showtopic=470 )
- fixed bug with auto-close system (no ref)
- fixed bug with auto-close maintenance (no ref)
- fixed bug with email parser when dealing with quote-printable files (no ref)
- fixed bug in purgable closed tickets system (no ref)
- fixed bug in purgable closed attachments system (no ref)
- fixed 2 small bugs in system-wide JS (no ref)
- various improvements to parser behaviour (no ref)
- full paths in knowledge base category drop-down ( http://forum.sitepanel3.com/index.php?showtopic=425 )
- SitePanel3 will now attempt to suggest solutions to existing tickets in the admin panel (no ref)
- improved performance of email piping system (no ref)
- improved performance for some common database access routines (no ref)
- improved add/edit parser interface (no ref)
- improved performance for add/edit department (no ref)
- improved performance of multi-ticket action (no ref)
- improved permissions system, added more options (no ref)
- improved full-text search relevancy significantly (no ref)
- improved performance of maintenance system (no ref)
- various improvements to statistics section ( http://forum.sitepanel3.com/index.php?showtopic=468 )
- various improvements to knowledge base comment management (no ref)
- some small user interface improvements (no ref)
- improved ticket view rendering (no ref)
- improved look of attachments layer in individual ticket view (no ref)
- improved documentation (no ref)
- implemented cross-browser compression routines, improves loading performance significantly (no ref)
- various other small bug fixes, grammar and spelling fixes and updates [NA] (no ref)
Template Files
---------------------------------------------
create_ticket.tpl
create_ticket2.tpl
footer.tpl
header.tpl
index.tpl
kb_post.tpl
Database
---------------------------------------------
ALTER TABLE {prefix}alert_rules ADD rule_trigger_assigned_reply INT( 4 ) NOT NULL AFTER rule_trigger_reply_user;
ALTER TABLE {prefix}parsers ADD parser_enable_autoresponder INT( 4 ) NOT NULL ;
INSERT INTO {prefix}config VALUES (40, 'auto_assign', '0');
INSERT INTO {prefix}config VALUES (41, 'parser_reopen_on_reply', '0');
ALTER TABLE {prefix}user ADD ticket_limit INT( 4 ) NOT NULL ;
ALTER TABLE {prefix}hdposts ADD last_activity_auto_close INT( 20 ) NOT NULL AFTER last_activity ;
ALTER TABLE {prefix}parsers ADD parser_test_mode INT( 4 ) NOT NULL ;
ALTER TABLE {prefix}permissions ADD p_152 INT( 4 ) DEFAULT '0' NOT NULL AFTER p_138 ;
CREATE TABLE {prefix}raw_emails (
raw_email_id int(10) NOT NULL auto_increment,
raw_email_content TEXT,
raw_email_ticket int( 10 ),
raw_email_reply int( 10 ),
raw_email_timestamp int( 20 ),
KEY raw_email_id (raw_email_id)
) TYPE = MyISAM ;
BUILD 1.1.1 Alloway - 15th February 2006
=============================================
- improved parser behaviour when dealing with multiple departments/GUIsets [class email_to_ticket()] (no ref)
+-|- system now uses correct email templates for ticket replies
|- system now uses correct return address for ticket replies
|- system now uses correct email templates for account creation (guest access)
|- system now uses correct return address for account creation (guest access)
|- various other major improvements to parser behaviour
- system now behaves correctly when sending emails from a non-primary GUI set [users] (no ref)
- email template for parser replies can now be changed on a per-department basis [admin] (no ref)
- when creating new email templates information from existing templates can be used [admin] (no ref)
- improved performance in certain high-load areas of the system [admin] (no ref)
Thanks to Matthew Bacon for all of his help during the development of this version.
Template Files
---------------------------------------------
(none)
Database
---------------------------------------------
ALTER TABLE {prefix}departments ADD email_template_pipe_reply VARCHAR( 255 ) NOT NULL ;
BUILD 1.1 Alloway - 1st December 2005
=============================================
- added multi language support [NA] (no ref)
- added French translation, provided by Roch Lambert [NA] (no ref)
- added auto-close feature [NA] (http://forum.sitepanel3.com/index.php?showtopic=385)
- users can now login with user name or registered email address [function - login()] (http://forum.sitepanel3.com/index.php?showtopic=370)
- added ability to modify flood protection behaviour [NA] (no ref)
- added more options for knowledge base customisation [NA] (no ref)
+-|- enable article preview
|- enable RSS feed
|- preview/RSS feed article length
- added previous/next links in single ticket view [admin] (http://forum.sitepanel3.com/index.php?showtopic=357)
- many improvements to core classes [NA] (no ref)
+-|- POP3/IMAP importing system behaviour
|- SMTP mailer class
|- templating class
- general preferences rearranged to improve navigation [admin] (no ref)
- various improvements to spellchecker [NA] (no ref)
- various other small bug fixes, grammar and spelling fixes and updates [NA] (no ref)
Template Files
---------------------------------------------
announcement.tpl
create_ticket.tpl
footer.tpl
index.tpl
kb_category.tpl
kb_main.tpl
kb_post.tpl
header.tpl
register.tpl
Database
---------------------------------------------
INSERT INTO {prefix}config VALUES (33, 'enable_kb_article_preview', '1');
INSERT INTO {prefix}config VALUES (34, 'enable_kb_rss', '1');
INSERT INTO {prefix}config VALUES (35, 'kb_rss_size', '255');
INSERT INTO {prefix}config VALUES (36, 'flood_behaviour', '1');
INSERT INTO {prefix}config VALUES (37, 'user_close_ticket', '0');
INSERT INTO {prefix}config VALUES (38, 'enable_auto_close', '0');
INSERT INTO {prefix}config VALUES (39, 'auto_close_value', '96');
BUILD 1.05 Finale - 20th Oct 2005
=============================================
- add reply box is now visible by default [admin] (http://forum.sitepanel3.com/index.php?showtopic=338)
- tickets which may require a staff reply can be highlighted, toggle-able option [admin] (http://forum.sitepanel3.com/index.php?showtopic=339)
- system now specifies a list of allowed file types for uploads as opposed to disallowed types [NA] (http://forum.sitepanel3.com/index.php?showtopic=340)
- user drop-down list now arranged by username in ascending order when creating a new ticket [admin] (no ref)
- fixed problem with nl2br function in BBcodeDo [function BBcodeDo()] (no ref)
- fixed bug where signature was not being appended to help desk replies [admin] (no ref)
- improvements to ticket display to make attachment status more obvious [both] (no ref)
- improvements to headers used when sending emails [function returnEmailHeaders()] (thanks to rdakin)
- various improvements to admin alerts [function runAlerts()] (no ref)
- various improvements to email handling routines, especially piped emails [NA] (no ref)
- added user and admin user count to dashboard [admin] (no ref)
- added reset views to knowledge base post edit [admin] (no ref)
- added assigned to as a ticket search option [admin] (no ref)
- various other small bug fixes, grammar and spelling fixes and updates [NA] (no ref)
BUILD 1.01 Finale - 29th Sept 2005
=============================================
- made some minor improvements to the spellchecker's handling of punctuation [NA] (no bug ref)
- fixed bug where certain login attempts were not being added to the access log [function login_user()] (no bug ref)
- added select user drop-down menu to user details [admin] (no bug ref)
- added various improvements to the instant messaging system [admin] (no bug ref)
- extensive improvements to handle long user names, long message subjects, etc without breaking layout [NA] (no bug ref)
- emails now checked for validity [NA] (no bug ref) *
- fixed bug where BCC headers in emails were incorrectly formed [function returnEmailHeaders()] (no bug ref)
- fixed error where ticket link in alerts was incorrect [function runAlerts($parent, $action, $db_link)] (REF# 11)
- various other small bug fixes, grammar and spelling fixes and updates [NA] (no bug ref)
BUILD 0.95 Dalrymple (RC2) - 22nd Sept 2005
=============================================
- fixed error with installer script when dealing with certain mySQL configurations [NA] (REF# 5)
- fixed error with SP2 to SP3 upgrade script relating to escape characters in custom data [NA] (no bug ref)
- fixed error where hidden custom fields were being shown in user section [user] (REF# 7)
- added option in admin users preferences to always show custom data when viewing tickets [admin] (no bug ref)
- added option GUI sets to dictate whether or not visitors should be allowed to register for an account [NA] (no bug ref)
- added option email parsers to dictate whether or not guests should be allowed to create new tickets [NA] (no bug ref)
- fixed numerous minor errors where default email sending address was being used where the relevant parser address would be more appropriate [NA] (no bug ref)
- fixed a few small errors in the reports section where occasionally null images were being produced [admin] (no bug ref)
- alerts sent to admin users now contain a link back to the relevant ticket where appropriate [function runAlerts($parent, $action, $db_link)] (no bug ref)
- fixed error where template set was not editable in GUI set administration [admin] (no bug ref)
- purging old closed tickets now correctly deletes attachments using function deleteAttachment() [admin] (no bug ref)
- various improvements to the email all users function [admin] (no bug ref)
- added support for BCC headers [function returnEmailHeaders()] (no bug ref)
- fixed bug where overdue tickets in department with SLA rules where not being highlighted [admin] (no bug ref)
- pipe.php moved to includes directory [NA] (no bug ref)
- double-clicking a main menu item image now takes you to the default page associated with that image [admin] (no bug ref)
- added general preference to force plain-text emails [admin] (no bug ref)
- flood protection and email banning now works correctly [NA] (no bug ref)
- SPAM filter now works based on standard SPAM headers (requires SPAMassasin functionality on server) [NA] (no bug ref)
- various other small bug fixes, grammar and spelling fixes and updates [NA] (no bug ref)
BUILD 0.9 Dalrymple (RC1) - 6th Sept 2005
=============================================
- improved database access count(*) routines [NA] (no bug ref)
- decreased database read overhead in ticket list considerably [admin] (no bug ref)
- admin control panel now only requires a single database connection [admin] (no bug ref)
- further work done to HTML coding and CSS to improve aesthetics when using Microsoft Internet Explorer 6 or less [user] (no bug ref)
- fixed problem with SMTP mail sending [function - mailSMTP($to, $from, $subject, $message, $headers)] (REF# 4)
- fixed problem with SMTP mail sending when sending email to multiple recipients [function - mailSMTP($to, $from, $subject, $message, $headers)] (REF# 4)
- added parent post detail to knowledge base comment edit form [admin] (no bug ref)
- improved pagination to expedite traversal of pages [function - showPagination($page, $total_pages, $link)] (no bug ref)
- added reporting system complete with GD charts [admin] (no bug ref)
- email separator now only used in relevant emails [NA] (no bug ref)
- fixed error where admin users could gain access to tickets which are not in a department they are assigned to [admin] (no bug ref)
- fixed subject formatting in alerts [NA] (no bug ref)
- fixed bug where admin users were being notified of events which occurred in departments they are not assigned to [function - runAlerts($parent, $action, $db_link)] (no bug ref)
- system now writes to ticket log when editing ticket to reflect any important changes [admin] (no bug ref)
- added spell checker user interface [NA] (no bug ref)
- added spell checking to relevant forms [admin] (no bug ref)
- news can now be viewed as RSS feed [NA] (no bug ref)
- added new class to turn email into ticket, used by pipe and IMAP [class email_to_ticket($bodyset, $headersset, $global_prefs, $dbset)] (no bug ref)
- SMTP function now performs check to ensure that authentication procedure is necessary [function - mailSMTP($to, $from, $subject, $message, $headers)] (no bug ref)
- added IMAP email fetching support [NA] (no bug ref)
- added POP3 to email parsing options [NA] (no bug ref)
- various other small bug fixes, grammar and spelling fixes and updates [NA] (no bug ref)
BUILD 0.8 Bargannock - 15th August 2005
=============================================
- remember me function now works [user] (no bug ref)
- forgotten password function now works [user] (no bug ref)
- added new default email template for forgotten password function [NA] (no bug ref)
- added print ticket function [admin] (no bug ref)
- added print ticket function [user] (no bug ref)
- added assign to admin user in multi-ticket actions [admin] (no bug ref)
- fixed leaking tables in Internet Explorer [admin] (no bug ref)
- fixed leaking tables in Internet Explorer [user] (no bug ref)
- added BBcode support [function - BBcodeDo($contents) ] (no bug ref)
- added BBcode quick inserts [function - drawWYSIWYG($form_object) ] (no bug ref)
- fixed problem in templating system which could slow down system if an if tag is not closed [function - template::parse() ]
- when creating new department default email templates are selected [admin] (no bug ref)
- added tickets notes functionality [admin] (no bug ref)
- automatically truncates subject field in email templates list if too long [admin] (no bug ref)
- tickets no longer listed as overdue if SLA is disabled on department [admin] (no bug ref)
- users can now change their password [user] (no bug ref)
- piping system now included [NA] (no bug ref)
- admin panel top menu now has tooltips [admin] (REF# 3)
- select all and select all per section checkbox toggle when dealing with admin user permissions [admin] (REF# 2)
- select all checkbox toggle in ticket list [admin] (no bug ref, related to REF# 2)
- re-assignment now uses editTicket class [admin][editTicket::assign($assign_to, $lock)] (no bug ref)
- added IP address authentication [checkIP()] (no bug ref)
- edited login and authentication functions to improve performance and prevent a possible infinite loop [login($start_cookie, $login_type)] (no bug ref)
- admin top menu is now dynamic using JavaScript [admin] (no bug ref)
- improved layout of admin top menu [admin] (no bug ref)
- added SMTP send mail functionality [class SMTPmailer()] (no bug ref)
- added new database fields to facilitate SMTP functionality [NA] (no bug ref)
- added calendar/today's tasks toggle on main admin page [admin] (no bug ref)
- alert rules can now be applied to admin users other than yourself [admin] (no bug ref)
- added maintenance options [admin] (no bug ref)
- added email parser log [admin] (no bug ref)
- added access log [admin] (no bug ref)
- fixed some Javascript problems in FireFox [admin] (no bug ref)
- added help drop-down for regex matching [admin] (no bug ref)
- added help drop-down for date formats [admin] (no bug ref)
- improved image compatibility with IE [admin] (no bug ref)
- added ability to search for tickets created within a certain time frame in advanced ticket search [admin] (no bug ref)
- fixed pagination when dealing with advanced ticket searches [admin] (no bug ref)
- advanced search string is now persistent [admin] (no bug ref)
- added SitePanel 2 to SitePanel3 upgrade script [NA] (no bug ref)
- fixed bug where auto-assign could assign tickets from a department the current admin user does not have access to [admin] (no bug ref)
- fixed bug where a maximum of 1 ticket was being shown on the welcome page [admin] (no bug ref)
- various other small bug fixes, grammar and spelling fixes and updates [NA] (no bug ref)
BUILD 0.7 Dyrock - 27th July 2005
=============================================
First release
|
