function sort($option, $pkg, $form, $page)
{
$rows = _ff_select("select * from `#__facileforms_forms` where id = $form");
$width = $height = 600;
if (count($rows)) {
$f = $rows[0];
if ($f->widthmode ==0) $width = $f->width; else $width = $f->prevwidth;
if ($f->heightmode==0) $height = $f->height;
if ($width < 1) $width = 600;
if ($height < 1) $height = 600;
} // if
$rows = _ff_select(
"select id ".
"from `#__facileforms_elements` ".
"where form=$form and page=$page ".
"order by ".
"if(`type`='Hidden Input',1,0), ".
"if(`type`='Hidden Input',0,if(posy<0,$height+if(posymode=0,posy,(posy*$height)/100),if(posymode=0,posy,(posy*$height)/100))), ".
"if(`type`='Hidden Input',0,if(posx<0,$width+if(posxmode=0,posx,(posx*$width)/100),if(posxmode=0,posx,(posx*$width)/100))), ".
"name, title, id"
);
$o = 1;
if (count($rows)) foreach ($rows as $row) {
_ff_query("update `#__facileforms_elements` set ordering=$o where id=$row->id");
$o++;
} // foreach
JFactory::getApplication()->redirect(
"index.php?option=$option&act=editpage&form=$form&page=$page&pkg=$pkg",
BFText::_('COM_BREEZINGFORMS_ELEMENTS_SORTED'));
} // save
function dropPackage($id)
{
if ($this->hasErrors()) return;
$this->oldscripts = _ff_select(
"select id, name from #__facileforms_scripts where package = '$id'"
);
$this->oldpieces = _ff_select(
"select id, name from #__facileforms_pieces where package = '$id'"
);
dropPackage($id); // the one in admin.facileforms.php
} // dropPackage
function instPackage($option, $caller, $pkg)
{
$rows = _ff_select(
"select * from #__facileforms_packages where id != '' order by id"
);
HTML_facileFormsConf::instPackage($option, $caller, $pkg, $rows);
} // instPackage
static function sort($option, $pkg, $form, $page)
{
$rows = _ff_select("select * from `#__facileforms_forms` where id = " . JFactory::getDBO()->Quote($form));
$width = $height = 600;
if (count($rows)) {
$f = $rows[0];
if ($f->widthmode == 0) {
$width = $f->width;
} else {
$width = $f->prevwidth;
}
if ($f->heightmode == 0) {
$height = $f->height;
}
if ($width < 1) {
$width = 600;
}
if ($height < 1) {
$height = 600;
}
}
// if
$rows = _ff_select("select id " . "from `#__facileforms_elements` " . "where form=" . JFactory::getDBO()->Quote($form) . " and page=" . JFactory::getDBO()->Quote($page) . " " . "order by " . "if(`type`='Hidden Input',1,0), " . "if(`type`='Hidden Input',0,if(posy<0," . intval($height) . "+if(posymode=0,posy,(posy*" . intval($height) . ")/100),if(posymode=0,posy,(posy*" . intval($height) . ")/100))), " . "if(`type`='Hidden Input',0,if(posx<0," . intval($width) . "+if(posxmode=0,posx,(posx*" . intval($width) . ")/100),if(posxmode=0,posx,(posx*" . intval($width) . ")/100))), " . "name, title, id");
$o = 1;
if (count($rows)) {
foreach ($rows as $row) {
_ff_query("update `#__facileforms_elements` set ordering={$o} where id={$row->id}");
$o++;
}
}
// foreach
JFactory::getApplication()->redirect("index.php?option={$option}&act=editpage&form={$form}&page={$page}&pkg={$pkg}", BFText::_('COM_BREEZINGFORMS_ELEMENTS_SORTED'));
}
function step3($option)
{
global $ff_admpath,$mainframe, $ff_config, $errors, $errmode;
$instmode = intval(JRequest::getVar( 'ff_installmode', 1));
$instsamp = intval(JRequest::getVar( 'ff_instsamples', 0));
$instqmsamp = intval(JRequest::getVar( 'ff_instqmsamples', 0));
$instold = intval(JRequest::getVar( 'ff_instoldlib', 0));
// list of sample forms before 1.4
$sampleforms =
"'SampleContactForm',".
"'SampleCountrySelect',".
"'SamplePaneNavigation',".
"'SamplePizzaShop',".
"'SampleEmbeddedCode',".
"'SamplePieceApp',".
"'RnrContestRegist',".
"'RnrContestList'";
// list of sample menus before 1.4
$samplemenus =
"'Facile Forms Sample Menu'";
// list of sample scripts before 1.4
$stdscripts =
"'ff_anychecked',".
"'ff_checked',".
"'ff_countQuerySelections',".
"'ff_getfocus',".
"'ff_getQuerySelections',".
"'ff_getQuerySelectedRows',".
"'ff_integer_or_empty',".
"'ff_nextpage',".
"'ff_page1',".
"'ff_page2',".
"'ff_page3',".
"'ff_previouspage',".
"'ff_showaction',".
"'ff_showelementinit',".
"'ff_showforminit',".
"'ff_showsubmitted',".
"'ff_showvalidation',".
"'ff_submittedhome',".
"'ff_unchecked',".
"'ff_validate_form',".
"'ff_validate_nextpage',".
"'ff_validate_page',".
"'ff_validate_submit',".
"'ff_validemail',".
"'ff_valuenotempty'";
// list of sample pieces before 1.4
$stdpieces =
"'ff_InitUtilities',".
"'ff_SubmitUtilities',".
"'ff_redirectParent',".
"'ff_getPageByName',".
"'ff_setSelected',".
"'ff_setChecked',".
"'ff_setValue'";
// database update
$sql_path = $ff_admpath.'/sql';
$errors = array();
$errmode = 'log';
switch ($instmode) {
case 0: // New install: create tables
facileFormsInstaller::exec_sql($sql_path.'/create.sql');
$ff_config = new facileFormsConfig();
break;
case 1: // Reinstall: no db change
break;
case 2: // Upgrade from 1.0.x
facileFormsInstaller::exec_sql($sql_path.'/upgrade_1.1.sql');
case 3: // Upgrade from 1.1.x
facileFormsInstaller::exec_sql($sql_path.'/upgrade_1.2.sql');
case 4: // Upgrade from 1.2.x
facileFormsInstaller::exec_sql($sql_path.'/upgrade_1.3.sql');
case 5: // Upgrade from 1.3.x
facileFormsInstaller::exec_sql($sql_path.'/upgrade_1.4.sql');
default:
break;
} // switch
// get xref to old samples
$oldscripts = NULL;
$oldpieces = NULL;
if ($instmode>=2 && $instmode<=5) { // upgrades until 1.4
// get old xref tables
$oldscripts = _ff_select("select id, name from #__facileforms_scripts where name in ($stdscripts)");
$oldpieces = _ff_select("select id, name from #__facileforms_pieces where name in ($stdpieces)");
// drop old std scripts & pieces
_ff_query("delete from #__facileforms_scripts where name in ($stdscripts)");
_ff_query("delete from #__facileforms_pieces where name in ($stdpieces)");
} // if
// call installer to load new std libraries
$xmlfile = $ff_admpath.'/packages/stdlib.english.xml';
$inst = new ff_importPackage();
$inst->import($xmlfile);
if (intval($instold) == 1) {
// call installer to load backward compatibility library
$xmlfile = $ff_admpath.'/packages/oldlib.english.xml';
$inst->import($xmlfile);
} // if
if (intval($instsamp) == 1) {
if ($instmode>=2 && $instmode<=5) { // upgrades until 1.4
// drop old sample forms
$rows = _ff_select("select id from #__facileforms_forms where name in ($sampleforms)");
if (count($rows)) foreach ($rows as $row) {
_ff_query("delete from #__facileforms_elements where form = $row->id");
_ff_query("delete from #__facileforms_forms where id = $row->id");
} // if
// drop old sample menus
$rows = _ff_select("select id from #__facileforms_compmenus where title in ($samplemenus)");
if (count($rows)) foreach ($rows as $row)
_ff_query("delete from #__facileforms_compmenus where id=$row->id or parent=$row->id");
} // if
// call installer to load new samples
$xmlfile = $ff_admpath.'/packages/samples.english.xml';
$inst->import($xmlfile);
} // if
if (intval($instqmsamp) == 1) {
$xmlfile = $ff_admpath.'/packages/quickmode.samples.xml';
if(file_exists($xmlfile)){
$inst->import($xmlfile);
}
}
// relink items refering to old scripts and pieces
relinkScripts($oldscripts);
relinkPieces($oldpieces);
// adjust component menu
jimport('joomla.version');
$version = new JVersion();
if(version_compare($version->getShortVersion(), '1.6', '>=')){
updateComponentMenus();
_ff_query(
"update #__menu set `alias` = 'BreezingForms' ".
"where `link`='index.php?option=com_breezingforms'"
);
_ff_query(
"update #__menu set `alias` = 'Manage Records', img='components/com_breezingforms/images/js/ThemeOffice/checkin.png' ".
"where `link`='index.php?option=com_breezingforms&act=managerecs'"
);
_ff_query(
"update #__menu set `alias` = 'Manage Backend Menus', img='components/com_breezingforms/images/js/ThemeOffice/mainmenu.png' ".
"where `link`='index.php?option=com_breezingforms&act=managemenus'"
);
_ff_query(
"update #__menu set `alias` = 'Manage Forms', img='components/com_breezingforms/images/js/ThemeOffice/content.png' ".
"where `link`='index.php?option=com_breezingforms&act=manageforms'"
);
_ff_query(
"update #__menu set `alias` = 'Manage Scripts', img='components/com_breezingforms/images/js/ThemeOffice/controlpanel.png' ".
"where `link`='index.php?option=com_breezingforms&act=managescripts'"
);
_ff_query(
"update #__menu set `alias` = 'Manage Pieces', img='components/com_breezingforms/images/js/ThemeOffice/controlpanel.png' ".
"where `link`='index.php?option=com_breezingforms&act=managepieces'"
);
_ff_query(
"update #__menu set `alias` = 'Integrator', img='components/com_breezingforms/images/js/ThemeOffice/controlpanel.png' ".
"where `link`='index.php?option=com_breezingforms&act=integrate'"
);
_ff_query(
"update #__menu set `alias` = 'Configuration', img='components/com_breezingforms/images/js/ThemeOffice/config.png' ".
"where `link`='index.php?option=com_breezingforms&act=configuration'"
);
} else {
_ff_query("update #__components set admin_menu_link='' where `option`='com_breezingforms' and parent=0");
updateComponentMenus();
// assign nice icons to facileforms
_ff_query(
"update #__components set admin_menu_img='components/com_breezingforms/images/js/ThemeOffice/checkin.png' ".
"where admin_menu_link='option=com_breezingforms&act=managerecs'"
);
_ff_query(
"update #__components set admin_menu_img='components/com_breezingforms/images/js/ThemeOffice/mainmenu.png' ".
"where admin_menu_link='option=com_breezingforms&act=managemenus'"
);
_ff_query(
"update #__components set admin_menu_img='components/com_breezingforms/images/js/ThemeOffice/content.png' ".
"where admin_menu_link='option=com_breezingforms&act=manageforms'"
);
_ff_query(
"update #__components set admin_menu_img='components/com_breezingforms/images/js/ThemeOffice/controlpanel.png' ".
"where admin_menu_link='option=com_breezingforms&act=managescripts'"
);
_ff_query(
"update #__components set admin_menu_img='components/com_breezingforms/images/js/ThemeOffice/controlpanel.png' ".
"where admin_menu_link='option=com_breezingforms&act=managepieces'"
);
_ff_query(
"update #__components set admin_menu_img='components/com_breezingforms/images/js/ThemeOffice/config.png' ".
"where admin_menu_link='option=com_breezingforms&act=integrate'"
);
_ff_query(
"update #__components set admin_menu_img='components/com_breezingforms/images/js/ThemeOffice/config.png' ".
"where admin_menu_link='option=com_breezingforms&act=configuration'"
);
// fix broken menuitems
$id = _ff_selectValue(
"select min(id) from #__components ".
"where `parent`=0 and `option`='com_breezingforms'"
);
if ($id)
_ff_query(
"update #__menu ".
"set componentid=$id, link='index.php?option=com_breezingforms' ".
"where type='components' and params like 'ff_com_name=%'"
);
}
if ($ff_config->images == '{mossite}/administrator/components/com_breezingforms/images')
$ff_config->images = '{mossite}/components/com_breezingforms/images';
if ($ff_config->uploads == '{mospath}/administrator/components/com_breezingforms/uploads')
$ff_config->uploads = '{mospath}/components/com_breezingforms/uploads';
$ff_config->store();
HTML_facileFormsInstaller::step3($option, $errors);
} // step3
function dropPackage($id)
{
// drop package settings
_ff_query("delete from #__facileforms_packages where id = " . JFactory::getDBO()->Quote($id) . "");
// drop backend menus
$rows = _ff_select("select id from #__facileforms_compmenus where package = " . JFactory::getDBO()->Quote($id) . "");
if (count($rows)) {
foreach ($rows as $row) {
_ff_query("delete from #__facileforms_compmenus where id={$row->id} or parent={$row->id}");
}
}
updateComponentMenus();
// drop forms
$rows = _ff_select("select id from #__facileforms_forms where package = " . JFactory::getDBO()->Quote($id) . "");
if (count($rows)) {
foreach ($rows as $row) {
_ff_query("delete from #__facileforms_elements where form = {$row->id}");
_ff_query("delete from #__facileforms_forms where id = {$row->id}");
}
}
// if
// drop scripts
_ff_query("delete from #__facileforms_scripts where package = " . JFactory::getDBO()->Quote($id) . "");
// drop pieces
_ff_query("delete from #__facileforms_pieces where package = " . JFactory::getDBO()->Quote($id) . "");
}
function dropPackage($id)
{
if ($this->hasErrors()) {
return;
}
$this->oldscripts = _ff_select("select id, name from #__facileforms_scripts where package = " . JFactory::getDBO()->Quote($id) . "");
$this->oldpieces = _ff_select("select id, name from #__facileforms_pieces where package = " . JFactory::getDBO()->Quote($id) . "");
dropPackage($id);
// the one in admin.facileforms.php
}
function dropPackage($id)
{
// drop package settings
_ff_query("delete from #__facileforms_packages where id = '$id'");
// drop backend menus
$rows = _ff_select("select id from #__facileforms_compmenus where package = '$id'");
if (count($rows)) foreach ($rows as $row)
_ff_query("delete from #__facileforms_compmenus where id=$row->id or parent=$row->id");
updateComponentMenus();
// drop forms
$rows = _ff_select("select id from #__facileforms_forms where package = '$id'");
if (count($rows)) foreach ($rows as $row) {
_ff_query("delete from #__facileforms_elements where form = $row->id");
_ff_query("delete from #__facileforms_forms where id = $row->id");
} // if
// drop scripts
_ff_query("delete from #__facileforms_scripts where package = '$id'");
// drop pieces
_ff_query("delete from #__facileforms_pieces where package = '$id'");
} // dropPackage
