| Server IP : 195.130.67.5 / Your IP : 216.73.217.154 Web Server : Microsoft-IIS/10.0 System : Windows NT WEBSERVER1 10.0 build 17763 (Windows Server 2016) i586 User : IUSR ( 0) PHP Version : 7.4.19 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /inetpub/wwwroot/icd/administrator/components/com_staffmaster/files/ |
Upload File : |
<?php
/**
* File: update_0_7_0.php
* database schema unchanged through 0.7.5.5
*
* Staff Master 0.7.5.5
*
* Staff Master - Staff Members and Departments Manager
*
* @version 0.7.5.5
* @package StaffMaster_0_7_5_5
* @subpackage files
* @copyright (C) 2007-2008 Travis Hubbard
* @license http://www.gnu.org/licenses/ GNU/GPL v3
* @link http://www.systemsunited.net/
**/
/**
* Updates the database Staff Table from 0.6.5 to version 0.7.5.5
*
* @access private
*/
function updateStaff() {
$db = JFactory::getDBO();
$db->setQuery("ALTER TABLE #__staff ADD COLUMN `alias` varchar(255) NOT NULL");
$db->query();
$db->setQuery("ALTER TABLE #__staff ADD COLUMN `phone1` varchar(25) default NULL");
$db->query();
$db->setQuery("ALTER TABLE #__staff ADD COLUMN `ext1` varchar(10) default NULL");
$db->query();
$db->setQuery("ALTER TABLE #__staff ADD COLUMN `phone2` varchar(25) default NULL");
$db->query();
$db->setQuery("ALTER TABLE #__staff ADD COLUMN `ext2` varchar(10) default NULL");
$db->query();
$db->setQuery("ALTER TABLE #__staff ADD COLUMN `email` varchar(50) default NULL");
$db->query();
$db->setQuery("ALTER TABLE #__staff ADD COLUMN `address1` varchar(100) default NULL");
$db->query();
$db->setQuery("ALTER TABLE #__staff ADD COLUMN `address2` varchar(100) default NULL");
$db->query();
$db->setQuery("ALTER TABLE #__staff ADD COLUMN `address3` varchar(100) default NULL");
$db->query();
$db->setQuery("ALTER TABLE #__staff ADD COLUMN `address4` varchar(100) default NULL");
$db->query();
$db->setQuery("SELECT * FROM #__staff");
$staff_members = $db->loadObjectList();
// Get the old staff members, reparse them for the new DB setup...
// create aliases and update
if( $staff_members ) {
foreach( $staff_members as $row ) {
if( empty( $row->alias ) ) {
$temp_alias = strtolower( $row->name );
$temp_alias = JFilterOutput::stringURLSafe( $temp_alias );
$row->alias = $temp_alias;
}
else {
$row->alias = JFilterOutput::stringURLSafe( strtolower( $row->alias ) );
}
$db->setQuery("UPDATE #__staff SET alias = '$row->alias' WHERE id = $row->id ");
$db->query();
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
}
}
}
}
/**
* Updates the database Departments Table from 0.6.5 to version 0.7.5.5
*
* @access private
*/
function updateDepartments() {
jimport('joomla.filter.filteroutput');
$db = JFactory::getDBO();
$db->setQuery("ALTER TABLE #__staff_departments ADD COLUMN `alias` varchar(255) NOT NULL");
$db->query();
$db->setQuery("ALTER TABLE #__staff_departments ADD COLUMN `footer_text` text default NULL");
$db->query();
$db->setQuery("SELECT * FROM #__staff_departments");
$departments = $db->loadObjectList();
// Get the old departments, reparse them for the new DB setup...
// create aliases and update
if( $departments ) {
foreach( $departments as $row ) {
if( empty( $row->alias ) ) {
$temp_alias = strtolower( $row->name );
$temp_alias = JFilterOutput::stringURLSafe( $temp_alias );
$row->alias = $temp_alias;
}
else {
$row->alias = JFilterOutput::stringURLSafe( strtolower( $row->alias ) );
}
$db->setQuery("UPDATE #__staff_departments SET alias = '$row->alias' WHERE id = $row->id ");
$db->query();
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
}
}
}
else {
// Else there were no departments before, so lets add a default "Administration" department
$db->setQuery("INSERT INTO #__staff_departments ( `id` , `name` , `alias` , `description` , `footer_text` , `ordering` , `published` )
VALUES ( 1 , 'Administration' , 'administration' , '' , '', 1 , 1 );");
$db->query();
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
}
}
}
/**
* Updates the database Settings Table from 0.6.5 to version 0.7.5.5
*
* @access private
*/
function updateSettings() {
$version = '0.7.5.5';
$db = JFactory::getDBO();
$db->setQuery("ALTER TABLE #__staff_settings CHANGE staff_page_title page_title varchar(255) NOT NULL");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings DROP COLUMN `use_custom_css` ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `staff_image_pos` varchar(10) NOT NULL default 'left' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `staff_image_pos_alt` tinyint(1) unsigned NOT NULL default '0' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `view_all` varchar(25) NOT NULL default 'default' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `view_staff` varchar(25) NOT NULL default 'default' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `view_department` varchar(25) NOT NULL default 'default' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `view_list` varchar(25) NOT NULL default 'default' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `header_text` text ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings DROP COLUMN `staff_image_height` ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings DROP COLUMN `staff_image_width` ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings DROP COLUMN `staff_width` ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `auto_alias` tinyint(1) unsigned NOT NULL default '1' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `use_custom_colors` tinyint(1) unsigned NOT NULL default '0' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `custom_colors` text ");
$db->query();
$db->setQuery("SELECT header_color, dept_name_color, dept_desc_color, staff_name_color, staff_title_color, staff_bio_color FROM #__staff_settings");
$colors = $db->loadObjectList();
$custom_colors = null;
if( $colors ) {
$custom_colors = "page_title_color=" . $colors[0]->header_color
. ";dept_name_color=" . $colors[0]->dept_name_color
. ";dept_desc_color=" . $colors[0]->dept_desc_color
. ";staff_name_color=" . $colors[0]->staff_name_color
. ";staff_title_color=" . $colors[0]->staff_title_color
. ";staff_bio_color=" . $colors[0]->staff_bio_color
. ";dept_unique_foot_color=;dept_general_foot_color=;contact_details=;contact_details_link=";
}
else {
$custom_colors = "page_title_color="
. ";dept_name_color="
. ";dept_desc_color="
. ";staff_name_color="
. ";staff_title_color="
. ";staff_bio_color="
. ";dept_unique_foot_color=;dept_general_foot_color=;contact_details=;contact_details_link=";
}
$db->setQuery("UPDATE #__staff_settings SET custom_colors = '{$custom_colors}' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings DROP COLUMN `header_color` ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings DROP COLUMN `dept_name_color` ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings DROP COLUMN `dept_desc_color` ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings DROP COLUMN `staff_name_color` ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings DROP COLUMN `staff_title_color` ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings DROP COLUMN `staff_bio_color` ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `list_use_image` tinyint(1) unsigned NOT NULL default '1' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `version` varchar(15) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `last_checked` varchar(10) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `check_version` tinyint(1) unsigned NOT NULL default '1' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `check_version_frequency` tinyint(4) unsigned NOT NULL default '1' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `view_admin_bio` smallint(5) unsigned NOT NULL default '250' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `cl_phone1` varchar(30) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `cl_phone2` varchar(30) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `cl_phone_ext` varchar(30) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `cl_read_contact` varchar(30) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `cl_email` varchar(30) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `cl_address1` varchar(30) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `cl_address2` varchar(30) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `cl_address3` varchar(30) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `cl_address4` varchar(30) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `linkable_staff_name` tinyint(1) unsigned NOT NULL default '1' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `linkable_contact_details` tinyint(1) unsigned NOT NULL default '1' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `linkable_department` tinyint(1) unsigned NOT NULL default '1' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `th_staff_image` varchar(30) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `th_staff_name` varchar(30) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `th_staff_title` varchar(30) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `th_staff_bio` varchar(30) default NULL ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `use_js_contact` tinyint(1) unsigned NOT NULL default '1' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `use_js_corners` tinyint(1) unsigned NOT NULL default '1' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `use_js_frontend` tinyint(1) unsigned NOT NULL default '1' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `title_in_bio` tinyint(1) unsigned NOT NULL default '0' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `acl` text COMMENT 'NOT IMPLEMENTED' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `use_auto_readmore_bio` tinyint(1) unsigned NOT NULL default '1' COMMENT 'NOT IMPLEMENTED' ");
$db->query();
$db->setQuery("ALTER TABLE #__staff_settings ADD COLUMN `auto_readmore_length` varchar(5) NOT NULL default '200' COMMENT 'NOT IMPLEMENTED' ");
$db->query();
$db->setQuery("UPDATE #__staff_settings SET `staff_image_pos` = 'left' , view_all = 'default' , view_staff = 'default' ,
view_department = 'default' , view_list = 'default' , header_text = '<p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Vivamus at purus. Morbi ante urna, pulvinar vitae, sodales nec, mattis nec, enim.</p>' ,
version = '{$version}' , cl_phone1 = 'Phone1' , cl_phone2 = 'Phone2' , cl_phone_ext = 'Ext.' ,
cl_read_contact = 'View contact details...' , cl_email = 'Email Address' , cl_address1 = 'Address' ,
th_staff_image = 'Staff Picture' , th_staff_name = 'Staff Name' , th_staff_title = 'Staff Title' , th_staff_bio = 'Staff Bio' ,
acl = 'global=\r\nstaff_add=\r\nstaff_edit=\r\nstaff_delete=\r\nstaff_pub=\r\ndept_add=\r\ndept_edit=\r\ndept_delete=\r\ndept_pub=\r\ncfg_edit='
WHERE id = 1 ");
$db->query();
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
}
}
?>