} } // check content amount for each cat // get all categories $sql = "SELECT id FROM " . $config_vars['table_prefix'] . "cats"; if (!($result = $db->sql_query($sql))) { message_die(GENERAL_ERROR, "Coudnt get cats", '', __LINE__, __FILE__, $sql); } while ($row = $db->sql_fetchrow($result)) { $cat = new categorie(); $cat->generate_from_id($row['id']); $catarray[] = $cat; } foreach ($catarray as $cat) { // check how many content is in this cat $should_be = $cat->calc_content_amount(); if ($should_be != $cat->get_content_amount()) { $missmatch['type'] = CONTENT_IN_CAT_AMOUNT; $missmatch['id'] = $cat->id; $missmatch['name'] = $cat->get_name(); $missmatch['value'] = $cat->get_content_amount(); $missmatch['should_be'] = $should_be; $missmatch_array[] = $missmatch; } // check child_content_amount $calc_child_content_amount = $cat->calc_child_content_amount(); if ($calc_child_content_amount != $cat->get_child_content_amount()) { $missmatch['type'] = CHILD_CONTENT_IN_CAT_AMOUNT; $missmatch['id'] = $cat->id; $missmatch['name'] = $cat->get_name(); $missmatch['value'] = $cat->get_child_content_amount();