XoopsModules25x / efqdirectory

admin/fieldtypes.php

Switch Indentation +12 added lines, -12 removed lines

@@ -281,18 +281,18 @@
     $op = $_POST['op'];
 }
 switch ($op) {
-    case 'view':
-        viewFieldtype();
-        break;
-    case 'editFieldtype':
-        editFieldtype();
-        break;
-    case 'addFieldtype':
-        addFieldtype();
-        break;
-    default:
-        fieldtypesConfig();
-        break;
+    	case 'view':
+        	viewFieldtype();
+        	break;
+    	case 'editFieldtype':
+        	editFieldtype();
+        	break;
+    	case 'addFieldtype':
+        	addFieldtype();
+        	break;
+    	default:
+        	fieldtypesConfig();
+        	break;
 }
 
 function getCatOverview()

admin/main.php

Switch Indentation +269 added lines, -269 removed lines

@@ -301,275 +301,275 @@
     $op = $_POST['op'];
 }
 switch ($op) {
-    case 'approve':
-        approve();
-        break;
-    case 'deleteListingConfirm':
-        delListingConfirm();
-        break;
-    case 'deleteListing':
-        delListing();
-        break;
-    case 'delVote':
-        delVote();
-        break;
-    case 'listNewListings':
-        listNewListings();
-        break;
-    case 'updateItemType':
-        updateItemType();
-        break;
-    case 'duplicateDataTypes':
-        listDuplicateDataTypes();
-        break;
-    case 'mergeDuplicates':
-        mergeDuplicates();
-        break;
-    case 'edit':
-        global $xoopsDB, $xoopsConfig, $myts, $eh, $efqtree, $moddir, $xoopsUser, $datafieldmanager, $subscription, $subscriptionhandler;
-        $sql         = 'SELECT i.itemid, i.logourl, i.uid, i.status, i.created, i.title, i.typeid, t.description FROM '
-                       . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_items')
-                       . ' i LEFT JOIN '
-                       . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_text')
-                       . ' t ON (i.itemid=t.itemid) WHERE i.itemid='
-                       . $get_itemid
-                       . '';
-        $item_result = $xoopsDB->query($sql);
-        $numrows     = $xoopsDB->getRowsNum($item_result);
-        xoops_cp_header();
-        //adminmenu(-1, _MD_A_MODADMIN_HOME);
-        echo "<hr size='1'><br>";
-        while (list($itemid, $logourl, $submitter, $status, $created, $itemtitle, $typeid, $description) = $xoopsDB->fetchRow($item_result)) {
-            if ($status == '1') {
-                echo '<input type="button" value="' . _MD_APPROVE . "\" onclick=\"location='main.php?op=approve&amp;item=$get_itemid'\">&nbsp;";
-            }
-            echo '&nbsp;<input type="button" value="'
-                 . _MD_DELETE
-                 . "\" onClick=\"location='main.php?op=deleteListingConfirm&amp;item=$get_itemid'\">&nbsp;<input type=\"button\" value=\""
-                 . _MD_VIEWITEM
-                 . "\" onclick=\"location='"
-                 . XOOPS_URL
-                 . '/modules/'
-                 . $moddir
-                 . "/listing.php?item=$get_itemid'\"><br><br>";
-
-            $sql         = 'SELECT DISTINCT t.dtypeid, t.title, t.section, f.typeid, f.fieldtype, f.ext, t.options, d.itemid, d.value, d.customtitle, t.custom ';
-            $sql         .= 'FROM '
-                            . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_x_cat')
-                            . ' ic, '
-                            . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_dtypes_x_cat')
-                            . ' xc, '
-                            . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_fieldtypes')
-                            . ' f, '
-                            . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_dtypes')
-                            . ' t ';
-            $sql         .= 'LEFT JOIN ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_data') . ' d ON (t.dtypeid=d.dtypeid AND d.itemid=' . $get_itemid . ') ';
-            $sql         .= "WHERE ic.cid=xc.cid AND ic.active='1' AND xc.dtypeid=t.dtypeid AND t.fieldtypeid=f.typeid AND t.activeyn='1' AND ic.itemid=" . $get_itemid . '';
-            $data_result = $xoopsDB->query($sql) or $eh->show('0013');
-            $numrows     = $xoopsDB->getRowsNum($data_result);
-
-            $form = new XoopsThemeForm(_MD_EDITITEM_FORM, 'editform', 'main.php');
-            $form->addElement(new XoopsFormText(_MD_TITLE, 'itemtitle', 50, 250, $itemtitle), true);
-            //$categories = getCategoriesPaths($get_itemid);
-            $get_dirid  = getDirIdFromItem($itemid);
-            $categories = getCatSelectArea($itemid, $get_dirid);
-            $form_cats  = new XoopsFormLabel(_MD_ITEMCATEGORIES, "$categories");
-            $form->addElement($form_cats);
-            $form->addElement(new XoopsFormDhtmlTextArea(_MD_DESCRIPTION, 'description', $description, 5, 50));
-            while (list($dtypeid, $title, $section, $ftypeid, $fieldtype, $ext, $options, $itemid, $value, $customtitle, $custom) = $xoopsDB->fetchRow($data_result)) {
-                $field = $datafieldmanager->createField($title, $dtypeid, $fieldtype, $ext, $options, $value, $custom, $customtitle);
-            }
-            $form->addElement(new XoopsFormButton('', 'submit', _MD_SAVE, 'submit'));
-            $form->addElement(new XoopsFormHidden('op', 'save'));
-            $form->addElement(new XoopsFormHidden('itemid', $get_itemid));
-            $form->addElement(new XoopsFormHidden('dirid', $get_dirid));
-            $form->addElement(new XoopsFormHidden('ini_itemtitle', $itemtitle));
-            $form->addElement(new XoopsFormHidden('uid', $xoopsUser->getVar('uid')));
-            if ($description === false) {
-                $form->addElement(new XoopsFormHidden('description_set', '0'));
-            } else {
-                $form->addElement(new XoopsFormHidden('description_set', '1'));
-            }
-            $form->display();
-            echo '<br>';
-            $itemtypes        = $subscriptionhandler->itemTypesArray();
-            $form             = new XoopsThemeForm(_MD_EDITITEMTYPE_FORM, 'edititemtypeform', 'main.php');
-            $itemtypes_select = new XoopsFormSelect(_MD_SELECT_ITEMTYPE, 'typeid', $typeid);
-            $itemtypes_select->addOptionArray($itemtypes);
-            $form->addElement($itemtypes_select);
-            $form->addElement(new XoopsFormButton('', 'submit', _MD_SAVE, 'submit'));
-            $form->addElement(new XoopsFormHidden('op', 'updateItemType'));
-            $form->addElement(new XoopsFormHidden('itemid', $get_itemid));
-            $form->addElement(new XoopsFormHidden('dirid', $get_dirid));
-            $form->addElement(new XoopsFormHidden('uid', $xoopsUser->getVar('uid')));
-            $form->display();
-        }
-        xoops_cp_footer();
-        break;
-    case 'save':
-        if (!empty($_POST['submit'])) {
-            $submitter = !empty($xoopsUser) ? $xoopsUser->getVar('uid') : 0;
-
-            if (!empty($_POST['itemid'])) {
-                $post_itemid = (int)$_POST['itemid'];
-            } else {
-                redirect_header('index.php', 2, _MD_NOVALIDITEM);
-                exit();
-            }
-            if (isset($_POST['itemtitle'])) {
-                $p_title     = $myts->makeTboxData4Save($_POST['itemtitle']);
-                $p_ini_title = $_POST['ini_itemtitle'];
-                if ($p_title != $p_ini_title) {
-                    //If the posted title is different from the initial title the record should be updated.
-                    $sql = 'UPDATE ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_items') . " SET title = '$p_title' WHERE itemid = $post_itemid";
-                    $xoopsDB->query($sql) or $eh->show('0013');
-                }
-            } else {
-                redirect_header('index.php', 2, _MD_NOVALIDITEM);
-                exit();
-            }
-            if (!empty($_POST['dirid'])) {
-                $post_dirid = (int)$_POST['dirid'];
-            } else {
-                $post_dirid = 0;
-            }
-            if (isset($_POST['ini_description'])) {
-                $p_ini_description = $myts->makeTareaData4Save($_POST['ini_description']);
-            } else {
-                $p_ini_description = null;
-            }
-            if (isset($_POST['description'])) {
-                $p_description = $myts->makeTareaData4Save($_POST['description']);
-            } else {
-                $p_description = null;
-            }
-            if (isset($_POST['description_set'])) {
-                if ($_POST['description_set'] == '1') {
-                    if ($p_ini_description != $p_description) {
-                        $sql = 'UPDATE ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_text') . " SET description = '$p_description' WHERE itemid = $post_itemid";
-                        $xoopsDB->query($sql) or $eh->show('0013');
-                    }
-                } elseif (isset($_POST['description']) && $_POST['description'] != '') {
-                    if ($p_description != null) {
-                        $sql = sprintf("INSERT INTO %s (itemid, description) VALUES (%u, '%s')", $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_text'), $post_itemid, $p_description);
-                        $xoopsDB->query($sql) or $eh->show('0013');
-                    }
-                }
-            }
-            $sql         = 'SELECT DISTINCT t.dtypeid, t.title, t.section, f.typeid, f.fieldtype, f.ext, t.options, d.itemid, d.value ';
-            $sql         .= 'FROM '
-                            . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_x_cat')
-                            . ' ic, '
-                            . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_dtypes_x_cat')
-                            . ' xc, '
-                            . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_fieldtypes')
-                            . ' f, '
-                            . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_dtypes')
-                            . ' t ';
-            $sql         .= 'LEFT JOIN ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_data') . ' d ON (t.dtypeid=d.dtypeid AND d.itemid=' . $post_itemid . ') ';
-            $sql         .= "WHERE ic.cid=xc.cid AND ic.active='1' AND xc.dtypeid=t.dtypeid AND t.fieldtypeid=f.typeid AND ic.itemid=" . $post_itemid . '';
-            $data_result = $xoopsDB->query($sql) or $eh->show('0013');
-            $numrows     = $xoopsDB->getRowsNum($data_result);
-            while (list($dtypeid, $title, $section, $ftypeid, $fieldtype, $ext, $options, $itemid, $value) = $xoopsDB->fetchRow($data_result)) {
-                if (isset($_POST["$dtypeid"])) {
-                    if ($fieldtype == 'textarea' || 'dhtml') {
-                        $post_value = $myts->makeTareaData4Save($_POST["$dtypeid"]);
-                    } else {
-                        $post_value = $myts->makeTboxData4Save($_POST["$dtypeid"]);
-                    }
-                } else {
-                    $post_value = '';
-                }
-
-                if (isset($_POST['custom' . $dtypeid . ''])) {
-                    $post_customtitle = $myts->makeTboxData4Save($_POST['custom' . $dtypeid . '']);
-                } else {
-                    $post_customtitle = '';
-                }
-                if ($fieldtype == 'address') {
-                    $addressfields = array('address', 'address2', 'zip', 'postcode', 'phone', 'lat', 'lon', 'phone', 'fax', 'mobile', 'city', 'country', 'uselocyn', 'main', 'active');
-                    foreach ($addressfields as $field) {
-                        if (isset($_POST["$dtypeid$field"])) {
-                            ${'post_' . $field} = $myts->makeTboxData4Save($_POST["$dtypeid$field"]);
-                        } else {
-                            ${'post_' . $field} = '';
-                        }
-                    }
-                    //INSERT OF UPDATE address
-                    //If INSERT, then get $newid and save it as the value in efqdiralpha1_data table
-                    if (isset($_POST['submitaddress'])) {
-                        if ($itemid == null || $post_value == '') {
-                            //That means there was not any value, so a new record should be added to the data table.
-                            $newaddrid = $xoopsDB->genId($xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_addresses') . '_addrid_seq');
-                            $sql       = sprintf("INSERT INTO %s (addrid, itemid, dtypeid, address, address2, zip, postcode, phone, lat, lon, main, active, fax, mobile, city, country) VALUES (%u, %u, %u, '%s', '%s', '%s', '%s', '%s', '%s', '%s', %u, %u, '%s', '%s', '%s', '%s')",
-                                                 $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_addresses'), $newaddrid, $post_itemid, $dtypeid, $post_address, $post_address2, $post_zip, $post_postcode, $post_phone, $post_lat, $post_lon, $post_main, $post_active, $post_fax, $post_mobile,
-                                                 $post_city, $post_country);
-                            //echo $sql."<br><br>";
-                            $xoopsDB->query($sql) or $eh->show('0013');
-                            $post_value = $xoopsDB->getInsertId();
-                        } else {
-                            $sql = 'UPDATE '
-                                   . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_addresses')
-                                   . " SET address = '$post_address', address2 = '$post_address2', zip = '$post_zip', postcode = '$post_postcode', lat = '$post_lat', lon = '$post_lon', main = '$post_main', active = '$post_active', fax = '$post_fax', mobile = '$post_mobile', city = '$post_city', country = '$post_country' WHERE addrid = '$post_value' AND itemid = '$post_itemid'";
-                            //echo $sql."<br><br>";
-                            $xoopsDB->query($sql) or $eh->show('0013');
-                        }
-                    }
-                }
-                if ($itemid == null) {
-                    //That means there was not any value, so a new record should be added to the data table.
-                    $newid = $xoopsDB->genId($xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_data') . '_dataid_seq');
-                    $sql   = sprintf("INSERT INTO %s (dataid, itemid, dtypeid, VALUE, created) VALUES (%u, %u, %u, '%s', '%s')", $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_data'), $newid, $post_itemid, $dtypeid, $post_value, time());
-                    $xoopsDB->query($sql) or $eh->show('0013');
-                } else {
-                    if ($value != $post_value) {
-                        $sql = 'UPDATE ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_data') . " SET value = '$post_value' WHERE dtypeid = $dtypeid AND itemid = $itemid";
-                        $xoopsDB->query($sql) or $eh->show('0013');
-                    }
-                }
-            }
-
-            $efqlisting        = new efqListing();
-            $efqlistinghandler = new efqListingHandler();
-            $linkedcats        = $efqlistinghandler->getLinkedCatsArray($post_itemid, $post_dirid);
-            $sql               = 'SELECT cid FROM ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_cat') . " WHERE dirid='" . $post_dirid . '\' AND active=\'1\'';
-            $allcatsresult     = $xoopsDB->query($sql);
-
-            $numrows = $xoopsDB->getRowsNum($allcatsresult);
-            $count   = 0;
-            if ($numrows > 0) {
-                while (list($cid) = $xoopsDB->fetchRow($allcatsresult)) {
-                    if (isset($_POST['selected' . $cid . ''])) {
-                        if (!in_array($cid, $linkedcats)) {
-                            $newid = $xoopsDB->genId($xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_x_cat') . '_xid_seq');
-                            $sql   = sprintf("INSERT INTO %s (xid, cid, itemid, active, created) VALUES (%u, %u, %u, '%s', '%s')", $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_x_cat'), $newid, $cid, $post_itemid, 1, time());
-                            $xoopsDB->query($sql) or $eh->show('0013');
-                        }
-
-                        ++$count;
-                    } else {
-                        if (in_array($cid, $linkedcats)) {
-                            $sql = sprintf('DELETE FROM %s WHERE cid=%u AND itemid=%u', $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_x_cat'), $cid, $post_itemid);
-                            $xoopsDB->query($sql) or $eh->show('0013');
-                        }
-                    }
-                }
-                if ($count == 0) {
-                    redirect_header(XOOPS_URL . "/modules/$moddir/admin/main.php?op=edit&item=" . $post_itemid . '', 2, _MD_NOCATEGORYMATCH);
-                    exit();
-                }
-            } else {
-                redirect_header(XOOPS_URL . "/modules/$moddir/admin/main.php?op=edit&item=" . $post_itemid . '', 2, _MD_NOCATEGORIESAVAILABLE);
-                exit();
-            }
-
-            redirect_header("main.php?op=edit&amp;item=$post_itemid", 2, _MD_ITEM_UPDATED);
-            exit();
-        }
-        break;
-    default:
-        listings();
-        break;
+    	case 'approve':
+        	approve();
+        	break;
+    	case 'deleteListingConfirm':
+        	delListingConfirm();
+        	break;
+    	case 'deleteListing':
+        	delListing();
+        	break;
+    	case 'delVote':
+        	delVote();
+        	break;
+    	case 'listNewListings':
+        	listNewListings();
+        	break;
+    	case 'updateItemType':
+        	updateItemType();
+        	break;
+    	case 'duplicateDataTypes':
+        	listDuplicateDataTypes();
+        	break;
+    	case 'mergeDuplicates':
+        	mergeDuplicates();
+        	break;
+    	case 'edit':
+        	global $xoopsDB, $xoopsConfig, $myts, $eh, $efqtree, $moddir, $xoopsUser, $datafieldmanager, $subscription, $subscriptionhandler;
+        	$sql         = 'SELECT i.itemid, i.logourl, i.uid, i.status, i.created, i.title, i.typeid, t.description FROM '
+                       	. $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_items')
+                       	. ' i LEFT JOIN '
+                       	. $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_text')
+                       	. ' t ON (i.itemid=t.itemid) WHERE i.itemid='
+                       	. $get_itemid
+                       	. '';
+        	$item_result = $xoopsDB->query($sql);
+        	$numrows     = $xoopsDB->getRowsNum($item_result);
+        	xoops_cp_header();
+        	//adminmenu(-1, _MD_A_MODADMIN_HOME);
+        	echo "<hr size='1'><br>";
+        	while (list($itemid, $logourl, $submitter, $status, $created, $itemtitle, $typeid, $description) = $xoopsDB->fetchRow($item_result)) {
+            	if ($status == '1') {
+                	echo '<input type="button" value="' . _MD_APPROVE . "\" onclick=\"location='main.php?op=approve&amp;item=$get_itemid'\">&nbsp;";
+            	}
+            	echo '&nbsp;<input type="button" value="'
+                 	. _MD_DELETE
+                 	. "\" onClick=\"location='main.php?op=deleteListingConfirm&amp;item=$get_itemid'\">&nbsp;<input type=\"button\" value=\""
+                 	. _MD_VIEWITEM
+                 	. "\" onclick=\"location='"
+                 	. XOOPS_URL
+                 	. '/modules/'
+                 	. $moddir
+                 	. "/listing.php?item=$get_itemid'\"><br><br>";
+
+            	$sql         = 'SELECT DISTINCT t.dtypeid, t.title, t.section, f.typeid, f.fieldtype, f.ext, t.options, d.itemid, d.value, d.customtitle, t.custom ';
+            	$sql         .= 'FROM '
+                            	. $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_x_cat')
+                            	. ' ic, '
+                            	. $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_dtypes_x_cat')
+                            	. ' xc, '
+                            	. $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_fieldtypes')
+                            	. ' f, '
+                            	. $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_dtypes')
+                            	. ' t ';
+            	$sql         .= 'LEFT JOIN ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_data') . ' d ON (t.dtypeid=d.dtypeid AND d.itemid=' . $get_itemid . ') ';
+            	$sql         .= "WHERE ic.cid=xc.cid AND ic.active='1' AND xc.dtypeid=t.dtypeid AND t.fieldtypeid=f.typeid AND t.activeyn='1' AND ic.itemid=" . $get_itemid . '';
+            	$data_result = $xoopsDB->query($sql) or $eh->show('0013');
+            	$numrows     = $xoopsDB->getRowsNum($data_result);
+
+            	$form = new XoopsThemeForm(_MD_EDITITEM_FORM, 'editform', 'main.php');
+            	$form->addElement(new XoopsFormText(_MD_TITLE, 'itemtitle', 50, 250, $itemtitle), true);
+            	//$categories = getCategoriesPaths($get_itemid);
+            	$get_dirid  = getDirIdFromItem($itemid);
+            	$categories = getCatSelectArea($itemid, $get_dirid);
+            	$form_cats  = new XoopsFormLabel(_MD_ITEMCATEGORIES, "$categories");
+            	$form->addElement($form_cats);
+            	$form->addElement(new XoopsFormDhtmlTextArea(_MD_DESCRIPTION, 'description', $description, 5, 50));
+            	while (list($dtypeid, $title, $section, $ftypeid, $fieldtype, $ext, $options, $itemid, $value, $customtitle, $custom) = $xoopsDB->fetchRow($data_result)) {
+                	$field = $datafieldmanager->createField($title, $dtypeid, $fieldtype, $ext, $options, $value, $custom, $customtitle);
+            	}
+            	$form->addElement(new XoopsFormButton('', 'submit', _MD_SAVE, 'submit'));
+            	$form->addElement(new XoopsFormHidden('op', 'save'));
+            	$form->addElement(new XoopsFormHidden('itemid', $get_itemid));
+            	$form->addElement(new XoopsFormHidden('dirid', $get_dirid));
+            	$form->addElement(new XoopsFormHidden('ini_itemtitle', $itemtitle));
+            	$form->addElement(new XoopsFormHidden('uid', $xoopsUser->getVar('uid')));
+            	if ($description === false) {
+                	$form->addElement(new XoopsFormHidden('description_set', '0'));
+            	} else {
+                	$form->addElement(new XoopsFormHidden('description_set', '1'));
+            	}
+            	$form->display();
+            	echo '<br>';
+            	$itemtypes        = $subscriptionhandler->itemTypesArray();
+            	$form             = new XoopsThemeForm(_MD_EDITITEMTYPE_FORM, 'edititemtypeform', 'main.php');
+            	$itemtypes_select = new XoopsFormSelect(_MD_SELECT_ITEMTYPE, 'typeid', $typeid);
+            	$itemtypes_select->addOptionArray($itemtypes);
+            	$form->addElement($itemtypes_select);
+            	$form->addElement(new XoopsFormButton('', 'submit', _MD_SAVE, 'submit'));
+            	$form->addElement(new XoopsFormHidden('op', 'updateItemType'));
+            	$form->addElement(new XoopsFormHidden('itemid', $get_itemid));
+            	$form->addElement(new XoopsFormHidden('dirid', $get_dirid));
+            	$form->addElement(new XoopsFormHidden('uid', $xoopsUser->getVar('uid')));
+            	$form->display();
+        	}
+        	xoops_cp_footer();
+        	break;
+    	case 'save':
+        	if (!empty($_POST['submit'])) {
+            	$submitter = !empty($xoopsUser) ? $xoopsUser->getVar('uid') : 0;
+
+            	if (!empty($_POST['itemid'])) {
+                	$post_itemid = (int)$_POST['itemid'];
+            	} else {
+                	redirect_header('index.php', 2, _MD_NOVALIDITEM);
+                	exit();
+            	}
+            	if (isset($_POST['itemtitle'])) {
+                	$p_title     = $myts->makeTboxData4Save($_POST['itemtitle']);
+                	$p_ini_title = $_POST['ini_itemtitle'];
+                	if ($p_title != $p_ini_title) {
+                    	//If the posted title is different from the initial title the record should be updated.
+                    	$sql = 'UPDATE ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_items') . " SET title = '$p_title' WHERE itemid = $post_itemid";
+                    	$xoopsDB->query($sql) or $eh->show('0013');
+                	}
+            	} else {
+                	redirect_header('index.php', 2, _MD_NOVALIDITEM);
+                	exit();
+            	}
+            	if (!empty($_POST['dirid'])) {
+                	$post_dirid = (int)$_POST['dirid'];
+            	} else {
+                	$post_dirid = 0;
+            	}
+            	if (isset($_POST['ini_description'])) {
+                	$p_ini_description = $myts->makeTareaData4Save($_POST['ini_description']);
+            	} else {
+                	$p_ini_description = null;
+            	}
+            	if (isset($_POST['description'])) {
+                	$p_description = $myts->makeTareaData4Save($_POST['description']);
+            	} else {
+                	$p_description = null;
+            	}
+            	if (isset($_POST['description_set'])) {
+                	if ($_POST['description_set'] == '1') {
+                    	if ($p_ini_description != $p_description) {
+                        	$sql = 'UPDATE ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_text') . " SET description = '$p_description' WHERE itemid = $post_itemid";
+                        	$xoopsDB->query($sql) or $eh->show('0013');
+                    	}
+                	} elseif (isset($_POST['description']) && $_POST['description'] != '') {
+                    	if ($p_description != null) {
+                        	$sql = sprintf("INSERT INTO %s (itemid, description) VALUES (%u, '%s')", $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_text'), $post_itemid, $p_description);
+                        	$xoopsDB->query($sql) or $eh->show('0013');
+                    	}
+                	}
+            	}
+            	$sql         = 'SELECT DISTINCT t.dtypeid, t.title, t.section, f.typeid, f.fieldtype, f.ext, t.options, d.itemid, d.value ';
+            	$sql         .= 'FROM '
+                            	. $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_x_cat')
+                            	. ' ic, '
+                            	. $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_dtypes_x_cat')
+                            	. ' xc, '
+                            	. $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_fieldtypes')
+                            	. ' f, '
+                            	. $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_dtypes')
+                            	. ' t ';
+            	$sql         .= 'LEFT JOIN ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_data') . ' d ON (t.dtypeid=d.dtypeid AND d.itemid=' . $post_itemid . ') ';
+            	$sql         .= "WHERE ic.cid=xc.cid AND ic.active='1' AND xc.dtypeid=t.dtypeid AND t.fieldtypeid=f.typeid AND ic.itemid=" . $post_itemid . '';
+            	$data_result = $xoopsDB->query($sql) or $eh->show('0013');
+            	$numrows     = $xoopsDB->getRowsNum($data_result);
+            	while (list($dtypeid, $title, $section, $ftypeid, $fieldtype, $ext, $options, $itemid, $value) = $xoopsDB->fetchRow($data_result)) {
+                	if (isset($_POST["$dtypeid"])) {
+                    	if ($fieldtype == 'textarea' || 'dhtml') {
+                        	$post_value = $myts->makeTareaData4Save($_POST["$dtypeid"]);
+                    	} else {
+                        	$post_value = $myts->makeTboxData4Save($_POST["$dtypeid"]);
+                    	}
+                	} else {
+                    	$post_value = '';
+                	}
+
+                	if (isset($_POST['custom' . $dtypeid . ''])) {
+                    	$post_customtitle = $myts->makeTboxData4Save($_POST['custom' . $dtypeid . '']);
+                	} else {
+                    	$post_customtitle = '';
+                	}
+                	if ($fieldtype == 'address') {
+                    	$addressfields = array('address', 'address2', 'zip', 'postcode', 'phone', 'lat', 'lon', 'phone', 'fax', 'mobile', 'city', 'country', 'uselocyn', 'main', 'active');
+                    	foreach ($addressfields as $field) {
+                        	if (isset($_POST["$dtypeid$field"])) {
+                            	${'post_' . $field} = $myts->makeTboxData4Save($_POST["$dtypeid$field"]);
+                        	} else {
+                            	${'post_' . $field} = '';
+                        	}
+                    	}
+                    	//INSERT OF UPDATE address
+                    	//If INSERT, then get $newid and save it as the value in efqdiralpha1_data table
+                    	if (isset($_POST['submitaddress'])) {
+                        	if ($itemid == null || $post_value == '') {
+                            	//That means there was not any value, so a new record should be added to the data table.
+                            	$newaddrid = $xoopsDB->genId($xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_addresses') . '_addrid_seq');
+                            	$sql       = sprintf("INSERT INTO %s (addrid, itemid, dtypeid, address, address2, zip, postcode, phone, lat, lon, main, active, fax, mobile, city, country) VALUES (%u, %u, %u, '%s', '%s', '%s', '%s', '%s', '%s', '%s', %u, %u, '%s', '%s', '%s', '%s')",
+                                                 	$xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_addresses'), $newaddrid, $post_itemid, $dtypeid, $post_address, $post_address2, $post_zip, $post_postcode, $post_phone, $post_lat, $post_lon, $post_main, $post_active, $post_fax, $post_mobile,
+                                                 	$post_city, $post_country);
+                            	//echo $sql."<br><br>";
+                            	$xoopsDB->query($sql) or $eh->show('0013');
+                            	$post_value = $xoopsDB->getInsertId();
+                        	} else {
+                            	$sql = 'UPDATE '
+                                   	. $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_addresses')
+                                   	. " SET address = '$post_address', address2 = '$post_address2', zip = '$post_zip', postcode = '$post_postcode', lat = '$post_lat', lon = '$post_lon', main = '$post_main', active = '$post_active', fax = '$post_fax', mobile = '$post_mobile', city = '$post_city', country = '$post_country' WHERE addrid = '$post_value' AND itemid = '$post_itemid'";
+                            	//echo $sql."<br><br>";
+                            	$xoopsDB->query($sql) or $eh->show('0013');
+                        	}
+                    	}
+                	}
+                	if ($itemid == null) {
+                    	//That means there was not any value, so a new record should be added to the data table.
+                    	$newid = $xoopsDB->genId($xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_data') . '_dataid_seq');
+                    	$sql   = sprintf("INSERT INTO %s (dataid, itemid, dtypeid, VALUE, created) VALUES (%u, %u, %u, '%s', '%s')", $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_data'), $newid, $post_itemid, $dtypeid, $post_value, time());
+                    	$xoopsDB->query($sql) or $eh->show('0013');
+                	} else {
+                    	if ($value != $post_value) {
+                        	$sql = 'UPDATE ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_data') . " SET value = '$post_value' WHERE dtypeid = $dtypeid AND itemid = $itemid";
+                        	$xoopsDB->query($sql) or $eh->show('0013');
+                    	}
+                	}
+            	}
+
+            	$efqlisting        = new efqListing();
+            	$efqlistinghandler = new efqListingHandler();
+            	$linkedcats        = $efqlistinghandler->getLinkedCatsArray($post_itemid, $post_dirid);
+            	$sql               = 'SELECT cid FROM ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_cat') . " WHERE dirid='" . $post_dirid . '\' AND active=\'1\'';
+            	$allcatsresult     = $xoopsDB->query($sql);
+
+            	$numrows = $xoopsDB->getRowsNum($allcatsresult);
+            	$count   = 0;
+            	if ($numrows > 0) {
+                	while (list($cid) = $xoopsDB->fetchRow($allcatsresult)) {
+                    	if (isset($_POST['selected' . $cid . ''])) {
+                        	if (!in_array($cid, $linkedcats)) {
+                            	$newid = $xoopsDB->genId($xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_x_cat') . '_xid_seq');
+                            	$sql   = sprintf("INSERT INTO %s (xid, cid, itemid, active, created) VALUES (%u, %u, %u, '%s', '%s')", $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_x_cat'), $newid, $cid, $post_itemid, 1, time());
+                            	$xoopsDB->query($sql) or $eh->show('0013');
+                        	}
+
+                        	++$count;
+                    	} else {
+                        	if (in_array($cid, $linkedcats)) {
+                            	$sql = sprintf('DELETE FROM %s WHERE cid=%u AND itemid=%u', $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_item_x_cat'), $cid, $post_itemid);
+                            	$xoopsDB->query($sql) or $eh->show('0013');
+                        	}
+                    	}
+                	}
+                	if ($count == 0) {
+                    	redirect_header(XOOPS_URL . "/modules/$moddir/admin/main.php?op=edit&item=" . $post_itemid . '', 2, _MD_NOCATEGORYMATCH);
+                    	exit();
+                	}
+            	} else {
+                	redirect_header(XOOPS_URL . "/modules/$moddir/admin/main.php?op=edit&item=" . $post_itemid . '', 2, _MD_NOCATEGORIESAVAILABLE);
+                	exit();
+            	}
+
+            	redirect_header("main.php?op=edit&amp;item=$post_itemid", 2, _MD_ITEM_UPDATED);
+            	exit();
+        	}
+        	break;
+    	default:
+        	listings();
+        	break;
 }
 
 function unique_events($array)

admin/xdir_migrate.php

Switch Indentation +6 added lines, -6 removed lines

@@ -112,10 +112,10 @@
 }
 switch ($op) {
 
-    case 'newdir':
-        newDir();
-        break;
-    default:
-        xdirConfig();
-        break;
+    	case 'newdir':
+        	newDir();
+        	break;
+    	default:
+        	xdirConfig();
+        	break;
 }

admin/directories.php

Switch Indentation +26 added lines, -26 removed lines

@@ -251,30 +251,30 @@
     $op = $_POST['op'];
 }
 switch ($op) {
-    case 'edit':
-        editDir();
-        break;
-    case 'update':
-        updateDir();
-        break;
-    case 'changestatus':
-        if (isset($_POST['fct'])) {
-            $fct = $_POST['fct'];
-            if ($fct == 'activate') {
-                $newstatus = 1;
-            } elseif ($fct == 'inactivate') {
-                $newstatus = 0;
-            }
-        }
-        changeStatus($newstatus);
-        break;
-    case 'newdir':
-        newDir();
-        break;
-    case 'moddir':
-        modDir($get_dir);
-        break;
-    default:
-        dirConfig();
-        break;
+    	case 'edit':
+        	editDir();
+        	break;
+    	case 'update':
+        	updateDir();
+        	break;
+    	case 'changestatus':
+        	if (isset($_POST['fct'])) {
+            	$fct = $_POST['fct'];
+            	if ($fct == 'activate') {
+                	$newstatus = 1;
+            	} elseif ($fct == 'inactivate') {
+                	$newstatus = 0;
+            	}
+        	}
+        	changeStatus($newstatus);
+        	break;
+    	case 'newdir':
+        	newDir();
+        	break;
+    	case 'moddir':
+        	modDir($get_dir);
+        	break;
+    	default:
+        	dirConfig();
+        	break;
 }

admin/categories.php

Switch Indentation +33 added lines, -33 removed lines

@@ -935,39 +935,39 @@
     $op = $_POST['op'];
 }
 switch ($op) {
-    case 'newdatatype':
-        addDatatype();
-        break;
-    case 'editdtypes':
-        editDatatypes();
-        break;
-    case 'editdtype':
-        editDatatype($get_dtypeid);
-        break;
-    case 'savedtype':
-        saveDatatype();
-        break;
-    case 'importdtypes':
-        importDatatypes();
-        break;
-    case 'edit':
-        editCat($get_catid);
-        break;
-    case 'update':
-        updateCat();
-        break;
-    case 'newcat':
-        newCat();
-        break;
-    case 'deleteCat':
-        deleteCat();
-        break;
-    case 'deleteCatConfirm':
-        deleteCatConfirm();
-        break;
-    default:
-        catConfig($get_dirid);
-        break;
+    	case 'newdatatype':
+        	addDatatype();
+        	break;
+    	case 'editdtypes':
+        	editDatatypes();
+        	break;
+    	case 'editdtype':
+        	editDatatype($get_dtypeid);
+        	break;
+    	case 'savedtype':
+        	saveDatatype();
+        	break;
+    	case 'importdtypes':
+        	importDatatypes();
+        	break;
+    	case 'edit':
+        	editCat($get_catid);
+        	break;
+    	case 'update':
+        	updateCat();
+        	break;
+    	case 'newcat':
+        	newCat();
+        	break;
+    	case 'deleteCat':
+        	deleteCat();
+        	break;
+    	case 'deleteCatConfirm':
+        	deleteCatConfirm();
+        	break;
+    	default:
+        	catConfig($get_dirid);
+        	break;
 }
 
 function getCatOverview()

admin/extensionmanager.php

Switch Indentation +3 added lines, -3 removed lines

@@ -355,7 +355,7 @@
     case "delLocs2":
     delLocationsToLink();
     break;*/
-    default:
-        showExtFields($type, $ext);
-        break;
+    	default:
+        	showExtFields($type, $ext);
+        	break;
 }

subscriptions.php

Switch Indentation +32 added lines, -32 removed lines

@@ -319,38 +319,38 @@
 }
 
 switch ($op) {
-    case 'upgrade':
-        upgrade();
-        break;
-    case 'orderselect':
-        orderselect();
-        break;
-    case 'orderpayment':
-        $GLOBALS['xoopsOption']['template_main'] = 'efqdiralpha1_subscriptions.tpl';
-        include XOOPS_ROOT_PATH . '/header.php';
-        orderpayment();
-        $xoopsTpl->assign('xoops_module_header', $xoops_module_header);
-        break;
-    case 'terminate':
-        $GLOBALS['xoopsOption']['template_main'] = 'efqdiralpha1_subscriptions.tpl';
-        include XOOPS_ROOT_PATH . '/header.php';
-        terminate();
-        $xoopsTpl->assign('xoops_module_header', $xoops_module_header);
-        break;
-    case 'terminate_confirm':
-        include XOOPS_ROOT_PATH . '/header.php';
-        terminate_confirm();
-        break;
-    case 'renew':
-        include XOOPS_ROOT_PATH . '/header.php';
-        renew();
-        break;
-    default:
-        $GLOBALS['xoopsOption']['template_main'] = 'efqdiralpha1_subscriptions.tpl';
-        include XOOPS_ROOT_PATH . '/header.php';
-        showsubscription();
-        $xoopsTpl->assign('xoops_module_header', $xoops_module_header);
-        break;
+    	case 'upgrade':
+        	upgrade();
+        	break;
+    	case 'orderselect':
+        	orderselect();
+        	break;
+    	case 'orderpayment':
+        	$GLOBALS['xoopsOption']['template_main'] = 'efqdiralpha1_subscriptions.tpl';
+        	include XOOPS_ROOT_PATH . '/header.php';
+        	orderpayment();
+        	$xoopsTpl->assign('xoops_module_header', $xoops_module_header);
+        	break;
+    	case 'terminate':
+        	$GLOBALS['xoopsOption']['template_main'] = 'efqdiralpha1_subscriptions.tpl';
+        	include XOOPS_ROOT_PATH . '/header.php';
+        	terminate();
+        	$xoopsTpl->assign('xoops_module_header', $xoops_module_header);
+        	break;
+    	case 'terminate_confirm':
+        	include XOOPS_ROOT_PATH . '/header.php';
+        	terminate_confirm();
+        	break;
+    	case 'renew':
+        	include XOOPS_ROOT_PATH . '/header.php';
+        	renew();
+        	break;
+    	default:
+        	$GLOBALS['xoopsOption']['template_main'] = 'efqdiralpha1_subscriptions.tpl';
+        	include XOOPS_ROOT_PATH . '/header.php';
+        	showsubscription();
+        	$xoopsTpl->assign('xoops_module_header', $xoops_module_header);
+        	break;
 }
 
 include XOOPS_ROOT_PATH . '/footer.php';