function trash_subs($parent = 0) { global $database; // Query pages $query_menu = $database->query("SELECT page_id FROM " . TABLE_PREFIX . "pages WHERE parent = '{$parent}' ORDER BY position ASC"); // Check if there are any pages to show if ($query_menu->numRows() > 0) { // Loop through pages while ($page = $query_menu->fetchRow()) { // Update the page visibility to 'deleted' $database->query("UPDATE " . TABLE_PREFIX . "pages SET visibility = 'deleted' WHERE page_id = '" . $page['page_id'] . "' LIMIT 1"); // Run this function again for all sub-pages trash_subs($page['page_id']); } } }
function trash_subs($parent = 0) { global $database; // Query pages $query_menu = $database->query("SELECT page_id FROM " . TABLE_PREFIX . "pages WHERE parent = '{$parent}' ORDER BY position ASC"); // Check if there are any pages to show if ($query_menu->numRows() > 0) { // Loop through pages while (false !== ($page = $query_menu->fetchRow(MYSQL_ASSOC))) { // Update the page visibility to 'deleted' $database->query("UPDATE " . TABLE_PREFIX . "pages SET visibility = 'deleted' WHERE page_id = '" . $page['page_id'] . "' LIMIT 1"); if ($database->is_error()) { trigger_error(sprintf('[%s - %s] %s', __FILE__, __LINE__, $database->get_error()), E_USER_ERROR); } // Run this function again for all sub-pages trash_subs($page['page_id']); } } }
function trash_subs($parent = 0) { global $database; // Query pages $sql = 'SELECT `page_id` FROM `' . TABLE_PREFIX . 'pages` ' . 'WHERE `parent` = ' . $parent . ' ' . 'ORDER BY `position` ASC'; if ($oRes = $database->query($sql)) { // Check if there are any pages to show if ($oRes->numRows() > 0) { // Loop through pages while ($page = $oRes->fetchRow(MYSQLI_ASSOC)) { // Update the page visibility to 'deleted' $sql = 'UPDATE `' . TABLE_PREFIX . 'pages` SET ' . '`visibility` = \'deleted\' ' . 'WHERE `page_id` = ' . $page['page_id'] . ' ' . ''; $database->query($sql); if ($database->is_error()) { $admin->print_error($database->get_error()); } // Run this function again for all sub-pages trash_subs($page['page_id']); } } } }