if ($GLOBALS['TYPO3_DB']->sql_num_rows($qry2) == 0) {
$products[$row['products_id']] = $row;
}
}
$content .= '<div class="main-heading"><h2>' . $this->pi_getLL('admin_label_check_2') . '</h2></div>';
foreach ($products as $row) {
$products_id = $row['products_id'];
$query = $GLOBALS['TYPO3_DB']->DELETEquery('tx_multishop_products_to_categories', 'products_id=' . $products_id);
$res = $GLOBALS['TYPO3_DB']->sql_query($query);
}
$content .= '<strong>' . count($products) . '</strong> ' . $this->pi_getLL('admin_label_x_orphanned_products_to_categories_relations_has_been_deleted') . '.<br />';
$str = "SELECT categories_id from tx_multishop_categories";
$qry = $GLOBALS['TYPO3_DB']->sql_query($str);
$cats = array();
while (($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry)) != false) {
if (!mslib_fe::hasProducts($row['categories_id']) and !mslib_fe::hasCats($row['categories_id'])) {
$cats[$row['categories_id']] = $row;
}
}
foreach ($cats as $row) {
if ($row['categories_id']) {
mslib_befe::deleteCategory($row['categories_id']);
}
}
$content .= '<strong>' . count($cats) . '</strong> ' . $this->pi_getLL('admin_label_x_orphanned_categories_has_been_deleted') . '.<br />';
// chk 3 the unused options
$content .= '<div class="main-heading"><h2>' . $this->pi_getLL('admin_label_check_3') . '</h2></div>';
$str = "SELECT products_options_values_id from tx_multishop_products_options_values";
$qry = $GLOBALS['TYPO3_DB']->sql_query($str);
$option_values = array();
while (($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($qry)) != false) {
$link = $cat['categories_external_url'];
}
$categories_name = htmlspecialchars($cat['categories_name']);
$meta_description = htmlspecialchars($cat['meta_description']);
$actifsub = 0;
$act = 0;
$hasChild = 0;
if ($user_crumbar[$nested_level]['id'] == $cat['categories_id']) {
if ($this->get['categories_id'] == $cat['categories_id'] or $this->maxDEPTH == $nested_level + 1) {
$act = 1;
}
if ($user_crumbar[$nested_level + 1]) {
$actifsub = 1;
}
}
if ($actifsub or mslib_fe::hasCats($cat['categories_id'], 0)) {
$hasChild = 1;
}
$this->class = array();
if ($hasChild) {
$this->class[] = 'hasChild';
}
if ($act) {
$this->class[] = 'active';
}
if ($actifsub) {
$this->class[] = 'actifsub active';
}
$cat_level_3 .= '<li class="' . implode(' ', $this->class) . '"><a href="' . $link . '" title="' . htmlspecialchars($meta_description) . '"' . $target . '><span>' . $categories_name . '</span></a></li>';
}
// hide in menu
