create_log_entry()

Complexity

Conditions

324

Size

Total Lines	1182
Code Lines	718

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
function create_log_entry($section, $section_id, $subsection, $subsection_id, $action, $user_id) {
    global $mysqli;

    //  Everything we do for the GAMES SECTION
    if ($section == 'Games') {
        if ($subsection == 'Submission') {
            // get game id
            $query_game_id = "SELECT game_id FROM game_submitinfo WHERE game_submitinfo_id = '$section_id'";
            $result = $mysqli->query($query_game_id) or die("getting game name failed");

Using exit here is not recommended.

            $query_data = $result->fetch_array(MYSQLI_BOTH);
            $section_id = $query_data['game_id'];
            $subsection_id = $query_data['game_id'];
        }

        //  get the game name
        $query_game = "SELECT game_name FROM game WHERE game_id = '$section_id'";
        $result = $mysqli->query($query_game) or die("getting game name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['game_name'];

        if ($subsection == 'Game' or $subsection == 'File' or $subsection == 'Screenshot' or $subsection == 'Mag score'
            or $subsection == 'Box back' or $subsection == 'Box front' or $subsection == 'Review'
            or $subsection == 'Review comment' or $subsection == 'Music' or $subsection == 'Submission'
            or $subsection == 'Fact' or $subsection == 'Sound hardware') {
            $subsection_name = $section_name;
        }

        if ($subsection == 'AKA') {
            //  get the AKA name
            $query_aka = "SELECT aka_name FROM game_aka WHERE game_aka_id = '$subsection_id'";
            $result = $mysqli->query($query_aka) or die("getting aka name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['aka_name'];
            $subsection_id   = $section_id;
        }

        if ($subsection == 'Creator') {
            if ($action == 'Delete') {
                //  get the ind name & id
                $query_ind = "SELECT individuals.ind_id,
                                     individuals.ind_name FROM individuals
                                     LEFT JOIN game_author ON ( individuals.ind_id = game_author.ind_id )
                                     WHERE game_author.game_author_id = '$subsection_id'";
                $result = $mysqli->query($query_ind) or die("getting ind name failed");

Using exit here is not recommended.

                $query_data      = $result->fetch_array(MYSQLI_BOTH);
                $subsection_name = $query_data['ind_name'];
                $subsection_id   = $query_data['ind_id'];
            } else {
                //  get the ind name
                $query_ind = "SELECT ind_name FROM individuals WHERE ind_id = '$subsection_id'";
                $result = $mysqli->query($query_ind) or die("getting ind name failed");

Using exit here is not recommended.

                $query_data      = $result->fetch_array(MYSQLI_BOTH);
                $subsection_name = $query_data['ind_name'];
            }
        }

        if ($subsection == 'Publisher' or $subsection == 'Developer') {
            //  get the pub/dev name
            $query_pubdev = "SELECT pub_dev_name FROM pub_dev WHERE pub_dev_id = '$subsection_id'";
            $result = $mysqli->query($query_pubdev) or die("getting pub/dev name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['pub_dev_name'];
        }

        if ($subsection == 'Year') {
            die("The table game_year has been deprecated and should not be used anymore");

Using exit here is not recommended.

        }

        if ($subsection == 'Similar') {
            if ($action == 'Delete') {
                // get the cross id
                $query_cross = "SELECT game_similar_cross FROM game_similar WHERE game_similar_id = '$subsection_id'";
                $result = $mysqli->query($query_cross) or die("getting cross failed");

Using exit here is not recommended.

                $query_data    = $result->fetch_array(MYSQLI_BOTH);
                $subsection_id = $query_data['game_similar_cross'];
            }
            //  get the game name
            $query_game = "SELECT game_name FROM game WHERE game_id = '$subsection_id'";
            $result = $mysqli->query($query_game) or die("getting game name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['game_name'];
            $subsection_id   = $section_id;
        }

        if ($subsection == 'Comment') {
            //get game_id and game_user_comments_id
            $query_user_comment = "SELECT game_user_comments.game_id,
                                          game_user_comments.game_user_comments_id,
                                          game.game_name
                                          FROM game_user_comments
                                          LEFT JOIN game ON ( game.game_id = game_user_comments.game_id )
                                          WHERE game_user_comments.comment_id = '$subsection_id'";

            $result = $mysqli->query($query_user_comment) or die("getting user comments id failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_id   = $query_data['game_user_comments_id'];
            $section_id      = $query_data['game_id'];
            $section_name    = $query_data['game_name'];
            $subsection_name = $query_data['game_name'];
        }
    }

    //  Everything we do for the GAMES SERIES SECTION
    if ($section == 'Game series') {
        if ($subsection == 'Game') {
            if ($action == 'Delete') {
                //get the game_id and game_series_id
                $query_series = "SELECT game_id, game_series_id FROM game_series_cross
                    WHERE game_series_cross_id = '$subsection_id'";
                $result = $mysqli->query($query_series) or die("getting series info failed");

Using exit here is not recommended.

                $query_data    = $result->fetch_array(MYSQLI_BOTH);
                $subsection_id = $query_data['game_id'];
                $section_id    = $query_data['game_series_id'];
            }

            //  get the game name
            $query_game = "SELECT game_name FROM game WHERE game_id = '$subsection_id'";
            $result = $mysqli->query($query_game) or die("getting game name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['game_name'];
        }

        //  get the name of the series
        $query_series = "SELECT game_series_name FROM game_series WHERE game_series_id = '$section_id'";
        $result = $mysqli->query($query_series) or die("getting series name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['game_series_name'];

        if ($subsection == 'Series') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the Trivia SECTION
    if ($section == 'Trivia') {
        if ($subsection == 'DYK' or $subsection == 'Quote' or $subsection == 'Spotlight') {
            $subsection_name = ("Trivia ID " . $subsection_id);
            $section_name    = ("Trivia ID " . $subsection_id);
        }
    }

    //  Everything we do for the LINKS section
    if ($section == 'Links') {
        // Get the website name
        $query_website = "SELECT website_name FROM website WHERE website_id = '$section_id'";
        $result = $mysqli->query($query_website) or die("getting website name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['website_name'];

        if ($subsection == 'Link') {
            $subsection_name = $section_name;
        }

        if ($subsection == 'Category') {
            // Get the category name
            $query_cat = "SELECT website_category_name FROM website_category
                WHERE website_category_id = '$subsection_id'";
            $result = $mysqli->query($query_cat) or die("getting category name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['website_category_name'];
        }

        if ($subsection == 'Link submit') {
            // Get the submitted link
            $query_link =  "SELECT website_name FROM website_validate WHERE website_id = $subsection_id";
            $result = $mysqli->query($query_link) or die("getting submitted link name failed: ".$mysqli->error);

Using exit here is not recommended.

            $query_data = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['website_name'];
            $subsection_name = $query_data['website_name'];
        }
    }

    //  Everything we do for the LINKS CATEGORY section
    if ($section == 'Links cat') {
        // Get the category name
        $query_cat = "SELECT website_category_name FROM website_category WHERE website_category_id = '$section_id'";
        $result = $mysqli->query($query_cat) or die("getting category name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['website_category_name'];

        if ($subsection == 'Category') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the COMPANY section
    if ($section == 'Company') {
        // Get the company name
        $query_comp = "SELECT pub_dev_name FROM pub_dev WHERE pub_dev_id = '$section_id'";
        $result = $mysqli->query($query_comp) or die("getting comp name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['pub_dev_name'];

        if ($subsection == 'Company' or $subsection == 'Logo') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the Individual section
    if ($section == 'Individuals') {
        if ($subsection == 'Nickname') {
            if ($action == 'Delete') {
                // we need to get the ind id
                $query_ind = "SELECT ind_id FROM individual_nicks WHERE nick_id = '$section_id'";
                $result = $mysqli->query($query_ind) or die("getting individual id failed");

Using exit here is not recommended.

                $query_data    = $result->fetch_array(MYSQLI_BOTH);
                $section_id    = $query_data['ind_id'];
                $subsection_id = $query_data['ind_id'];
            }
        }

        // Get the individual name
        $query_ind = "SELECT ind_name FROM individuals WHERE ind_id = '$section_id'";
        $result = $mysqli->query($query_ind) or die("getting individual name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['ind_name'];

        if ($subsection == 'Individual' or $subsection == 'Image' or $subsection == 'Nickname') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the AUTHor TYPE section
    if ($section == 'Author type') {
        // get the author type name
        $query_author = "SELECT author_type_info FROM author_type WHERE author_type_id = '$section_id'";
        $result = $mysqli->query($query_author) or die("getting author type name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['author_type_info'];

        if ($subsection == 'Author type') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the INTERVIEW section
    if ($section == 'Interviews') {
        if ($subsection == 'Interview') {
            if ($action == 'Update' or $action == 'Delete') {
                //we need to get the individual id
                $query_ind = "SELECT ind_id FROM interview_main WHERE interview_id = '$section_id'";
                $result = $mysqli->query($query_ind) or die("getting ind id failed");

Using exit here is not recommended.

                $query_data = $result->fetch_array(MYSQLI_BOTH);
                $section_id = $query_data['ind_id'];
            }
        }

        if ($subsection == 'Screenshots') {
            if ($action == 'Insert' or $action == 'Delete') {
                //we need to get the individual id
                $query_ind = "SELECT ind_id FROM interview_main WHERE interview_id = '$section_id'";
                $result = $mysqli->query($query_ind) or die("getting ind id failed");

Using exit here is not recommended.

                $query_data = $result->fetch_array(MYSQLI_BOTH);
                $section_id = $query_data['ind_id'];
            }
        }

        // get the name of the person that is interviewed
        $query_ind = "SELECT ind_name FROM individuals WHERE ind_id = '$section_id'";
        $result = $mysqli->query($query_ind) or die("getting ind name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['ind_name'];

        if ($subsection == 'Interview' or $subsection == 'Screenshots') {
            $subsection_name = $section_name;
        }

        if ($subsection == 'Comment') {
            //get game_id and interview_user_comments_id
            $query_user_comment = "SELECT interview_user_comments.interview_id,
                interview_user_comments.interview_user_comments_id,
                individuals.ind_name
                FROM interview_user_comments
                LEFT JOIN interview_main ON ( interview_user_comments.interview_id = interview_main.interview_id )
                LEFT JOIN individuals on (interview_main.ind_id = individuals.ind_id)
                WHERE interview_user_comments.comment_id = '$subsection_id'";

            $result = $mysqli->query($query_user_comment) or die("getting user comments id failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_id   = $query_data['interview_user_comments_id'];
            $section_id      = $query_data['interview_id'];
            $section_name    = $query_data['ind_name'];
            $subsection_name = $query_data['ind_name'];
        }
    }

    //  Everything we do for the Review section
    if ($section == 'Reviews') {
        if ($subsection == 'Comment') {
            //get the game name
            $query_user_comment = "SELECT * FROM review_user_comments
                LEFT JOIN review_main ON (review_user_comments.review_id = review_main.review_id)
                LEFT JOIN review_game ON (review_main.review_id = review_game.review_id)
                LEFT JOIN game ON (game.game_id = review_game.game_id)
                WHERE review_user_comments.comment_id = '$subsection_id'";

            $result = $mysqli->query($query_user_comment) or die("getting user comments id failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_id   = $query_data['review_user_comments_id'];
            $section_id      = $query_data['review_id'];
            $section_name    = $query_data['game_name'];
            $subsection_name = $query_data['game_name'];
        }
    }

    //  Everything we do for the AUTHor TYPE section
    if ($section == 'News') {
        if ($subsection == 'News submit') {
            // get the headline
            $query_news = "SELECT news_headline FROM news_submission WHERE news_submission_id = '$section_id'";
            $result = $mysqli->query($query_news) or die("getting headline failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['news_headline'];

            $subsection_name = $section_name;
        }

        if ($subsection == 'News item') {
            // get the headline
            $query_news = "SELECT news_headline FROM news WHERE news_id = '$section_id'";
            $result = $mysqli->query($query_news) or die("getting headline failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['news_headline'];

            $subsection_name = $section_name;
        }

        if ($subsection == 'Image') {
            // get the image name
            $query_image = "SELECT news_image_name FROM news_image WHERE news_image_id = '$section_id'";
            $result = $mysqli->query($query_image) or die("getting image name failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['news_image_name'];

            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the Menu Set SECTION
    if ($section == 'Menu set') {
        //  get the menu set name
        $query_menu_Set = "SELECT menu_sets_name FROM menu_set WHERE menu_sets_id = '$section_id'";
        $result = $mysqli->query($query_menu_Set) or die("getting menu set name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['menu_sets_name'];

        if ($subsection == 'Menu set' or $subsection == 'Menu disk (multiple)') {
            $subsection_name = $section_name;
        }

        if ($subsection == 'Crew') {
            // get the name of the crew
            $query_crew = "SELECT crew_name FROM crew WHERE crew_id = '$subsection_id'";
            $result = $mysqli->query($query_crew) or die("getting crew name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['crew_name'];
        }

        if ($subsection == 'Individual') {
            // get the name of the crew
            $query_ind = "SELECT ind_name FROM individuals WHERE ind_id = '$subsection_id'";
            $result = $mysqli->query($query_ind) or die("getting individual name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['ind_name'];
        }

        if ($subsection == 'Menu type') {
            // get the name of the menu type
            $query_menu_type = "SELECT menu_types_text FROM menu_types_main
                WHERE menu_types_main_id = '$subsection_id'";
            $result = $mysqli->query($query_menu_type) or die("getting menu type name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['menu_types_text'];
        }

        if ($subsection == 'Menu disk') {
            // get the name of the menu disk
            $sql_menus = "SELECT menu_disk.menu_sets_id,
                                menu_set.menu_sets_name,
                                menu_disk.menu_disk_number,
                                menu_disk.menu_disk_letter,
                                menu_disk.menu_disk_version,
                                menu_disk.menu_disk_part
                                FROM menu_disk
                                LEFT JOIN menu_set ON (menu_disk.menu_sets_id = menu_set.menu_sets_id)
                                WHERE menu_disk.menu_disk_id = '$subsection_id'";

            $result_menus = $mysqli->query($sql_menus) or die("error in query disk name");

Using exit here is not recommended.

            while ($row = $result_menus->fetch_array(MYSQLI_BOTH)) {
                // Create Menu disk name
                $menu_disk_name = "$row[menu_sets_name] ";
                if (isset($row['menu_disk_number'])) {
                    $menu_disk_name .= "$row[menu_disk_number]";
                }
                if (isset($row['menu_disk_letter'])) {
                    $menu_disk_name .= "$row[menu_disk_letter]";
                }
                if (isset($row['menu_disk_part'])) {
                    if (is_numeric($row['menu_disk_part'])) {
                        $menu_disk_name .= " part $row[menu_disk_part]";
                    } else {
                        $menu_disk_name .= "$row[menu_disk_part]";
                    }
                }
            }
            $subsection_name = $menu_disk_name;

The variable $menu_disk_name does not seem to be defined for all execution paths leading up to this point.

        }
    }

    //  Everything we do for the CREW SECTION
    if ($section == 'Crew') {
        // get the name of the crew
        $query_crew = "SELECT crew_name FROM crew WHERE crew_id = '$section_id'";
        $result = $mysqli->query($query_crew) or die("getting crew name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['crew_name'];

        if ($subsection == 'Crew' or $subsection == 'Logo') {
            $subsection_name = $section_name;
        }

        if ($subsection == 'Subcrew') {
            if ($action == 'Delete') {
                // get the id's
                $query_crew = "SELECT * FROM sub_crew WHERE sub_crew_id = '$subsection_id'";
                $result = $mysqli->query($query_crew) or die("getting crew ids failed");

Using exit here is not recommended.

                $query_data    = $result->fetch_array(MYSQLI_BOTH);
                $subsection_id = $query_data['crew_id'];
                $section_id    = $query_data['parent_id'];

                // get the name of the crew
                $query_crew = "SELECT crew_name FROM crew WHERE crew_id = '$section_id'";
                $result = $mysqli->query($query_crew) or die("getting crew name failed");

Using exit here is not recommended.

                $query_data   = $result->fetch_array(MYSQLI_BOTH);
                $section_name = $query_data['crew_name'];
            }

            // get the name of the subcrew
            $query_crew = "SELECT crew_name FROM crew WHERE crew_id = '$subsection_id'";
            $result = $mysqli->query($query_crew) or die("getting crew name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['crew_name'];
        }

        if ($subsection == 'Member') {
            if ($action == 'Delete') {
                // get the id's
                $query_crew = "SELECT * FROM crew_individual WHERE crew_individual_id = '$subsection_id'";
                $result = $mysqli->query($query_crew) or die("getting crew ids failed");

Using exit here is not recommended.

                $query_data    = $result->fetch_array(MYSQLI_BOTH);
                $subsection_id = $query_data['ind_id'];
                $section_id    = $query_data['crew_id'];

                // get the name of the crew
                $query_crew = "SELECT crew_name FROM crew WHERE crew_id = '$section_id'";
                $result = $mysqli->query($query_crew) or die("getting crew name failed");

Using exit here is not recommended.

                $query_data   = $result->fetch_array(MYSQLI_BOTH);
                $section_name = $query_data['crew_name'];
            }

            $query_ind = "SELECT ind_name FROM individuals WHERE ind_id = '$subsection_id'";
            $result = $mysqli->query($query_ind) or die("getting ind name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['ind_name'];
        }

        if ($subsection == 'Nickname') {
            // get the id's
            $query_crew = "SELECT * FROM crew_individual WHERE crew_individual_id = '$subsection_id'";
            $result = $mysqli->query($query_crew) or die("getting crew ids failed");

Using exit here is not recommended.

            $query_data    = $result->fetch_array(MYSQLI_BOTH);
            $subsection_id = $query_data['ind_id'];
            $section_id    = $query_data['crew_id'];

            // get the name of the crew
            $query_crew = "SELECT crew_name FROM crew WHERE crew_id = '$section_id'";
            $result = $mysqli->query($query_crew) or die("getting crew name failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['crew_name'];

            // get the name of the member
            $query_ind = "SELECT ind_name FROM individuals WHERE ind_id = '$subsection_id'";
            $result = $mysqli->query($query_ind) or die("getting ind name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['ind_name'];
        }
    }

    //  Everything we do for the MENU TYPE SECTION
    if ($section == 'Menu type') {
        // get the name of the menu type
        $query_menu_type = "SELECT menu_types_text FROM menu_types_main WHERE menu_types_main_id = '$section_id'";
        $result = $mysqli->query($query_menu_type) or die("getting menu type name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['menu_types_text'];

        if ($subsection == 'Menu type') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the MENU DISK
    if ($section == 'Menu disk') {
        // get the name of the menu disk
        $sql_menus = "SELECT menu_disk.menu_sets_id,
                            menu_set.menu_sets_name,
                            menu_disk.menu_disk_number,
                            menu_disk.menu_disk_letter,
                            menu_disk.menu_disk_version,
                            menu_disk.menu_disk_part
                            FROM menu_disk
                            LEFT JOIN menu_set ON (menu_disk.menu_sets_id = menu_set.menu_sets_id)
                            WHERE menu_disk.menu_disk_id = '$section_id'";

        $result_menus = $mysqli->query($sql_menus) or die("error in query disk name");

Using exit here is not recommended.

        while ($row = $result_menus->fetch_array(MYSQLI_BOTH)) {
            $section_id = $row['menu_sets_id'];

            // Create Menu disk name
            $menu_disk_name = "$row[menu_sets_name] ";
            if (isset($row['menu_disk_number'])) {
                $menu_disk_name .= "$row[menu_disk_number]";
            }
            if (isset($row['menu_disk_letter'])) {
                $menu_disk_name .= "$row[menu_disk_letter]";
            }
            if (isset($row['menu_disk_part'])) {
                if (is_numeric($row['menu_disk_part'])) {
                    $menu_disk_name .= " part $row[menu_disk_part]";
                } else {
                    $menu_disk_name .= "$row[menu_disk_part]";
                }
            }
        }

        $section_name = $menu_disk_name;

        if ($subsection == 'State') {
            // get the name of the menu type
            $query_menu_state = "SELECT menu_state FROM menu_disk_state WHERE state_id = '$subsection_id'";
            $result = $mysqli->query($query_menu_state) or die("getting menu state name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['menu_state'];
        }

        if ($subsection == 'Parent') {
            // get the name of the parent
            $sql_menus = "SELECT menu_disk.menu_sets_id,
                                menu_set.menu_sets_name,
                                menu_disk.menu_disk_number,
                                menu_disk.menu_disk_letter,
                                menu_disk.menu_disk_version,
                                menu_disk.menu_disk_part
                                FROM menu_disk
                                LEFT JOIN menu_set ON (menu_disk.menu_sets_id = menu_set.menu_sets_id)
                                WHERE menu_disk.menu_disk_id = '$subsection_id'";

            $result_menus = $mysqli->query($sql_menus) or die("error in query disk name");

Using exit here is not recommended.

            while ($row = $result_menus->fetch_array(MYSQLI_BOTH)) {
                // Create Menu disk name
                $menu_disk_name = "$row[menu_sets_name] ";
                if (isset($row['menu_disk_number'])) {
                    $menu_disk_name .= "$row[menu_disk_number]";
                }
                if (isset($row['menu_disk_letter'])) {
                    $menu_disk_name .= "$row[menu_disk_letter]";
                }
                if (isset($row['menu_disk_part'])) {
                    if (is_numeric($row['menu_disk_part'])) {
                        $menu_disk_name .= " part $row[menu_disk_part]";
                    } else {
                        $menu_disk_name .= "$row[menu_disk_part]";
                    }
                }
            }
            $subsection_name = $menu_disk_name;
        }

        if ($subsection == 'Year') {
            $subsection_name = $subsection_id;
        }

        if ($subsection == 'Menu disk' or $subsection == 'Screenshots' or $subsection == 'File') {
            $subsection_name = $section_name;
        }

        if ($subsection == 'Credits') {
            if ($action == 'Delete') {
                //get the ind id
                $query_ind = "SELECT ind_id FROM menu_disk_credits WHERE menu_disk_credits_id = '$subsection_id'";
                $result = $mysqli->query($query_ind) or die("getting individual name failed");

Using exit here is not recommended.

                $query_data    = $result->fetch_array(MYSQLI_BOTH);
                $subsection_id = $query_data['ind_id'];
            }

            // get the name of the individual
            $query_ind = "SELECT ind_name FROM individuals WHERE ind_id = '$subsection_id'";
            $result = $mysqli->query($query_ind) or die("getting individual name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['ind_name'];
        }

        if ($subsection == 'Nickname') {
            // get the individual id
            $query_ind = "SELECT ind_id FROM menu_disk_credits WHERE individual_nicks_id = '$subsection_id'";
            $result = $mysqli->query($query_ind) or die("getting individual name failed");

Using exit here is not recommended.

            $query_data = $result->fetch_array(MYSQLI_BOTH);
            $ind_id     = $query_data['ind_id'];

            //now get the individual name
            $query_ind = "SELECT ind_name FROM individuals WHERE ind_id = '$ind_id'";
            $result = $mysqli->query($query_ind) or die("getting individual name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['ind_name'];
        }

        if ($subsection == 'Game' or $subsection == 'Game doc') {
            //  get the game name
            $query_game = "SELECT game_name FROM game WHERE game_id = '$subsection_id'";
            $result = $mysqli->query($query_game) or die("getting game name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['game_name'];
        }

        if ($subsection == 'Demo') {
            //  get the demo name
            $query_demo = "SELECT demo_name FROM demo WHERE demo_id = '$subsection_id'";
            $result = $mysqli->query($query_demo) or die("getting demo name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['demo_name'];
        }

        if ($subsection == 'Tool' or $subsection == 'Tool doc') {
            //  get the tool name
            $query_tool = "SELECT tools_name FROM tools WHERE tools_id = '$subsection_id'";
            $result = $mysqli->query($query_tool) or die("getting tool name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['tools_name'];
        }

        if ($subsection == 'Doc type') {
            // get the name of the doc type
            $query_doc_type = "SELECT doc_type_name FROM doc_type WHERE doc_type_id = '$subsection_id'";
            $result = $mysqli->query($query_doc_type) or die("getting doc type name failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['doc_type_name'];
        }

        if ($subsection == 'Software' or $subsection == 'Chain' or $subsection == 'Doc' or $subsection == 'Authors') {
            //get the type of software
            $query_soft = "SELECT menu_types_main_id FROM menu_disk_title WHERE menu_disk_title_id = '$subsection_id'";
            $result = $mysqli->query($query_soft) or die("getting menu_type failed");

Using exit here is not recommended.

            $query_data = $result->fetch_array(MYSQLI_BOTH);
            $type       = $query_data['menu_types_main_id'];

            //get the name of the software
            if ($type == '1') {
                //get the id of the game
                $query_game = "SELECT game_id FROM menu_disk_title_game WHERE menu_disk_title_id = '$subsection_id'";
                $result = $mysqli->query($query_game) or die("getting game id failed");

Using exit here is not recommended.

                $query_data    = $result->fetch_array(MYSQLI_BOTH);
                $subsection_id = $query_data['game_id'];

                //  get the game name
                $query_game = "SELECT game_name FROM game WHERE game_id = '$subsection_id'";
                $result = $mysqli->query($query_game) or die("getting game name failed");

Using exit here is not recommended.

                $query_data      = $result->fetch_array(MYSQLI_BOTH);
                $subsection_name = $query_data['game_name'];

                if ($subsection != 'Chain' and $subsection != 'Authors') {
                    $subsection = 'Game';
                }
            }

            if ($type == '2') {
                //get the id of the demo
                $query_demo = "SELECT demo_id FROM menu_disk_title_demo WHERE menu_disk_title_id = '$subsection_id'";
                $result = $mysqli->query($query_demo) or die("getting demo id failed");

Using exit here is not recommended.

                $query_data    = $result->fetch_array(MYSQLI_BOTH);
                $subsection_id = $query_data['demo_id'];

                //  get the demo name
                $query_demo = "SELECT demo_name FROM demo WHERE demo_id = '$subsection_id'";
                $result = $mysqli->query($query_demo) or die("getting demo name failed");

Using exit here is not recommended.

                $query_data      = $result->fetch_array(MYSQLI_BOTH);
                $subsection_name = $query_data['demo_name'];
                if ($subsection != 'Chain' and $subsection != 'Authors') {
                    $subsection = 'Demo';
                }
            }

            if ($type == '3') {
                //get the id of the tool
                $query_tool = "SELECT tools_id FROM menu_disk_title_tools WHERE menu_disk_title_id = '$subsection_id'";
                $result = $mysqli->query($query_tool) or die("getting toold id failed");

Using exit here is not recommended.

                $query_data    = $result->fetch_array(MYSQLI_BOTH);
                $subsection_id = $query_data['tools_id'];

                //  get the tool name
                $query_tool = "SELECT tools_name FROM tools WHERE tools_id = '$subsection_id'";
                $result = $mysqli->query($query_tool) or die("getting tool name failed");

Using exit here is not recommended.

                $query_data      = $result->fetch_array(MYSQLI_BOTH);
                $subsection_name = $query_data['tools_name'];
                if ($subsection != 'Chain' and $subsection != 'Authors') {
                    $subsection = 'Tool';
                }
            }

            if ($type == '6') {
                //get the doc cross id
                $query_game_doc = "SELECT doc_games_id FROM menu_disk_title_doc_games
                    WHERE menu_disk_title_id = '$subsection_id'";
                $result = $mysqli->query($query_game_doc) or die("getting doc_game_id failed");

Using exit here is not recommended.

                $query_data    = $result->fetch_array(MYSQLI_BOTH);
                $subsection_id = $query_data['doc_games_id'];

                //  get the game id
                $query_game_id = "SELECT game_id FROM doc_disk_game WHERE doc_disk_game_id = '$subsection_id'";
                $result = $mysqli->query($query_game_id) or die("getting game id failed");

Using exit here is not recommended.

                $query_data    = $result->fetch_array(MYSQLI_BOTH);
                $subsection_id = $query_data['game_id'];

                //  get the game name
                $query_game = "SELECT game_name FROM game WHERE game_id = '$subsection_id'";
                $result = $mysqli->query($query_game) or die("getting game name failed");

Using exit here is not recommended.

                $query_data      = $result->fetch_array(MYSQLI_BOTH);
                $subsection_name = $query_data['game_name'];

                if ($subsection == 'Authors') {
                } else {
                    $subsection      = 'Game doc';
                }

                if ($subsection_name == '') {
                    //get the doc cross id
                    $query_tool_doc = "SELECT doc_tools_id FROM menu_disk_title_doc_tools
                        WHERE menu_disk_title_id = '$subsection_id'";
                    $result = $mysqli->query($query_tool_doc) or die("getting doc_tools_id failed");

Using exit here is not recommended.

                    $query_data    = $result->fetch_array(MYSQLI_BOTH);
                    $subsection_id = $query_data['doc_tools_id'];

                    //get the id of the tool
                    $query_tool = "SELECT tools_id FROM menu_disk_title_tools
                        WHERE menu_disk_title_id = '$subsection_id'";
                    $result = $mysqli->query($query_tool) or die("getting toold id failed");

Using exit here is not recommended.

                    $query_data    = $result->fetch_array(MYSQLI_BOTH);
                    $subsection_id = $query_data['tools_id'];

                    //  get the tool name
                    $query_tool = "SELECT tools_name FROM tools WHERE tools_id = '$subsection_id'";
                    $result = $mysqli->query($query_tool) or die("getting tool name failed");

Using exit here is not recommended.

                    $query_data      = $result->fetch_array(MYSQLI_BOTH);
                    $subsection_name = $query_data['tools_name'];

                    if ($subsection == 'Authors') {
                    } else {
                        $subsection      = 'Tool doc';
                    }
                }
            }
        }
    }

    //  Everything we do for the Articles section
    if ($section == 'Articles') {
        if ($subsection == 'Article') {
            if ($action == 'Update' or $action == 'Delete' or $action == 'Insert') {
                //we need to get the title
                $query_title = "SELECT article_title FROM article_text WHERE article_id = '$section_id'";
                $result = $mysqli->query($query_title) or die("getting title failed");

Using exit here is not recommended.

                $query_data   = $result->fetch_array(MYSQLI_BOTH);
                $section_name = $query_data['article_title'];
            }
        }

        if ($subsection == 'Screenshots') {
            if ($action == 'Insert' or $action == 'Delete') {
                //we need to get the title
                $query_title = "SELECT article_title FROM article_text WHERE article_id = '$section_id'";
                $result = $mysqli->query($query_title) or die("getting title failed");

Using exit here is not recommended.

                $query_data   = $result->fetch_array(MYSQLI_BOTH);
                $section_name = $query_data['article_title'];
            }
        }

        if ($subsection == 'Article' or $subsection == 'Screenshots') {
            $subsection_name = $section_name;

The variable $section_name does not seem to be defined for all execution paths leading up to this point.

        }

        if ($subsection == 'Comment') {
            //we need to get the title
            $query_user_comment = "SELECT article_user_comments.article_id,
                article_user_comments.article_user_comments_id,
                article_text.article_title
                FROM article_user_comments
                LEFT JOIN article_main ON ( article_user_comments.article_id = article_main.article_id )
                LEFT JOIN article_text on ( article_main.article_id = article_text.article_id )
                WHERE article_user_comments.comments_id = '$subsection_id'";

            $result = $mysqli->query($query_user_comment) or die("getting user comments id failed");

Using exit here is not recommended.

            $query_data      = $result->fetch_array(MYSQLI_BOTH);
            $section_id      = $query_data['article_id'];
            $section_name    = $query_data['article_title'];
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the ARTICLE TYPE SECTION
    if ($section == 'Article type') {
        // get the name of the article type
        $query_article_type = "SELECT article_type FROM article_type WHERE article_type_id = '$section_id'";
        $result = $mysqli->query($query_article_type) or die("getting article type name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['article_type'];

        if ($subsection == 'Article type') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the DOC TYPE SECTION
    if ($section == 'Doc type') {
        // get the name of the doc type
        $query_doc_type = "SELECT doc_type_name FROM doc_type WHERE doc_type_id = '$section_id'";
        $result = $mysqli->query($query_doc_type) or die("getting doc type name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['doc_type_name'];

        if ($subsection == 'Doc type') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the DOC CATEGORY SECTION
    if ($section == 'Doc category') {
        // get the name of the doc type
        $query_category_type = "SELECT doc_category_name FROM doc_category WHERE doc_category_id = '$section_id'";
        $result = $mysqli->query($query_category_type) or die("getting doc category name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['doc_category_name'];

        if ($subsection == 'Doc category') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the DOWNLOAD FORMAT SECTION
    if ($section == 'Format') {
        // get the name of the format
        $query_format = "SELECT format FROM format WHERE format_id = '$section_id'";
        $result = $mysqli->query($query_format) or die("getting format name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['format'];

        if ($subsection == 'Format') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the DOWNLOAD LINGO SECTION
    if ($section == 'Lingo') {
        // get the name of the lingo
        $query_lingo = "SELECT lingo_name FROM lingo WHERE lingo_id = '$section_id'";
        $result = $mysqli->query($query_lingo) or die("getting lingo name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['lingo_name'];

        if ($subsection == 'Lingo') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the DOWNLOAD OPTION SECTION
    if ($section == 'Option') {
        // get the name of the lingo
        $query_option = "SELECT download_option FROM download_options WHERE download_options_id = '$section_id'";
        $result = $mysqli->query($query_option) or die("getting option name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['download_option'];

        if ($subsection == 'Option') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the TOS VERSION SECTION
    if ($section == 'TOS') {
        // get the name of the lingo
        $query_tos = "SELECT tos_version FROM tos_version WHERE tos_version_id = '$section_id'";
        $result = $mysqli->query($query_tos) or die("getting tos name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['tos_version'];

        if ($subsection == 'TOS') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the TRAINER SECTION
    if ($section == 'Trainer') {
        // get the name of the trainer option
        $query_trainer = "SELECT trainer_options FROM trainer_options WHERE trainer_options_id = '$section_id'";
        $result = $mysqli->query($query_trainer) or die("getting trainer optione failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['trainer_options'];

        if ($subsection == 'Trainer') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the DOWNLOADS EDIT SECTION
    if ($section == 'Downloads') {
        // get the name of the game
        $query_game = "SELECT * FROM game WHERE game_id = '$section_id'";
        $result = $mysqli->query($query_game) or die("getting game_name failed yooohoo");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['game_name'];

        if ($subsection == 'Options') {
            // get the name of the option
            $query_option = "SELECT * FROM download_options WHERE download_options_id = '$subsection_id'";
            $result = $mysqli->query($query_option) or die("getting option failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['download_option'];
            $subsection_id = $query_data['download_options_id'];
        }

        if ($subsection == 'TOS') {
            // get the name of the option
            $query_tos = "SELECT * FROM tos_version
                             WHERE tos_version_id = '$subsection_id'";
            $result = $mysqli->query($query_tos) or die("getting tos failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['tos_version'];
            $subsection_id = $query_data['tos_version_id'];
        }

        if ($subsection == 'Details') {
            $subsection_name = $section_name;
        }

        if ($subsection == 'Menudisk') {
            $subsection_name = $section_name;
        }

        if ($subsection == 'Chain') {
            $subsection_name = $section_name;
        }

        if ($subsection == 'Trainer') {
            // get the name of the trainer option
            $query_trainer = "SELECT * FROM trainer_options
                             WHERE trainer_options_id = '$subsection_id'";
            $result = $mysqli->query($query_trainer) or die("getting trainer failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['trainer_options'];
            $subsection_id = $query_data['trainer_options_id'];
        }

        if ($subsection == 'Crew') {
            // get the name of the trainer option
            $query_crew = "SELECT * FROM crew WHERE
                            crew_id = '$subsection_id'";
            $result = $mysqli->query($query_crew) or die("getting crew failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['crew_name'];
        }

        if ($subsection == 'Authors') {
            // get the name of the author option
            $query_ind = "SELECT ind_name FROM individuals WHERE
                            ind_id = '$subsection_id'";
            $result = $mysqli->query($query_ind) or die("getting ind failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['ind_name'];
        }
    }

    //  Everything we do for the BUG REPORT TYPE SECTION
    if ($section == 'Bug type') {
        // get the name of the type
        $query_type = "SELECT bug_report_type FROM bug_report_type WHERE bug_report_type_id = '$section_id'";
        $result = $mysqli->query($query_type) or die("getting type name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['bug_report_type'];

        if ($subsection == 'Bug type') {
            $subsection_name = $section_name;
        }
    }

    //  Everything we do for the BUG REPORT SECTION
    if ($section == 'Bug') {
        $subsection_name = ("Bug report ID " . $subsection_id);
        $section_name    = ("Bug report ID " . $subsection_id);
    }

    //  Everything we do for the GAMES CONFIG section
    if ($section == 'Games Config') {
        if ($subsection == 'Games Engine') {
            // Get the engine name
            $query = "SELECT name FROM engine WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting engine name failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Programming Language') {
            // Get the programming language name
            $query = "SELECT name FROM programming_language WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting language name failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Genre') {
            // Get the genre name
            $query = "SELECT name FROM game_genre WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting genre name failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Port') {
            // Get the port name
            $query = "SELECT name FROM port WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting port name failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Individual Role') {
            // Get the role name
            $query = "SELECT name FROM individual_role WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting role name failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Developer Role') {
            // Get the role name
            $query = "SELECT role FROM developer_role WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting role name failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Language') {
            // Get the language name
            $query = "SELECT name FROM language WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting language name failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Control') {
            // Get the language name
            $query = "SELECT name FROM control WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting control type failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Resolution') {
            // Get the resolution name
            $query = "SELECT name FROM resolution WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting resolution failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'System') {
            // Get the system name
            $query = "SELECT name FROM system WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting system failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Emulator') {
            // Get the emulator name
            $query = "SELECT name FROM emulator WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting emulator failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Trainer') {
            // Get the trainer option name
            $query = "SELECT name FROM trainer_option WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting trainer option failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Memory') {
            // Get the memory amount
            $query = "SELECT name FROM memory WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting memory amount failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['memory'];
        } elseif ($subsection == 'Tos') {
            // Get the tos amount
            $query = "SELECT name FROM tos WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting tos version failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Protection') {
            // Get the protection type
            $query = "SELECT name FROM copy_protection WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting copy protection failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Disk Protection') {
            // Get the protection type
            $query = "SELECT name FROM disk_protection WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting disk protection failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Enhancement') {
            // Get the Enhancement
            $query = "SELECT name FROM enhancement WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting enhancement failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Media Type') {
            // Get the Enhancement
            $query = "SELECT name FROM media_type WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting media type failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Media Scan Type') {
            // Get the Enhancement
            $query = "SELECT name FROM media_scan_type WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting media type failed");

Using exit here is not recommended.

The assignment to $result is dead and can be removed.

        } elseif ($subsection == 'Sound hardware') {
            // Get the the hardware
            $query = "SELECT name FROM sound_hardware WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting sound hardware failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        } elseif ($subsection == 'Progress System') {
            // Get the the system
            $query = "SELECT name FROM game_progress_system WHERE id = '$section_id'";
            $result = $mysqli->query($query) or die("getting progress system failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $section_name = $query_data['name'];
        }
        $subsection_name = $section_name;
    }

    //Everything we do for GAME RELEASES
    if ($section == 'Game Release') {
        //  get the release name
        $query_game = "SELECT game_name FROM game WHERE game_id = '$section_id'";
        $result = $mysqli->query($query_game) or die("getting name failed");

Using exit here is not recommended.

        $query_data   = $result->fetch_array(MYSQLI_BOTH);
        $section_name = $query_data['game_name'];

        if ($subsection == 'Game Release' or $subsection == 'Release Info' or $subsection == 'Release AKA'
            or $subsection == 'Compatibility' or $subsection == 'Distributor'
            or $subsection == 'Scene' or $subsection == 'Memory Enhancement' or $subsection == 'Minimum Memory'
            or $subsection == 'Incompatible Memory' or $subsection == 'Incompatible TOS'
            or $subsection == 'Protection' or $subsection == 'Language' or $subsection == 'System Enhancement'
            or $subsection == 'Copy Protection' or $subsection == 'Disk Protection' or $subsection == 'Media'
            or $subsection == 'Dump' or $subsection == 'Media Scan' or $subsection == "Scan") {
            $subsection_name = $section_name;
        }

        if ($subsection == 'Distributor') {
            // get the distributor name
            $query_distributor = "SELECT * FROM pub_dev
                                  LEFT JOIN game_release_distributor
                                  ON (pub_dev.pub_dev_id = game_release_distributor.pub_dev_id)
                                  WHERE pub_dev.pub_dev_id = '$subsection_id'";
            $result = $mysqli->query($query_distributor) or die("getting name failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['pub_dev_name'];
            $subsection_id = $query_data['game_release_id'];
        }

        if ($subsection == 'Crew') {
            // get the distributor name
            $query_crew = "SELECT * FROM crew
                                  LEFT JOIN game_release_crew
                                  ON (crew.crew_id = game_release_crew.crew_id)
                                  WHERE crew.crew_id = '$subsection_id'";
            $result = $mysqli->query($query_crew) or die("getting name failed");

Using exit here is not recommended.

            $query_data   = $result->fetch_array(MYSQLI_BOTH);
            $subsection_name = $query_data['crew_name'];
            $subsection_id = $query_data['game_release_id'];
        }
    }

    $section_name    = $mysqli->real_escape_string($section_name);
    $subsection_name = $mysqli->real_escape_string($subsection_name);

The variable $subsection_name does not seem to be defined for all execution paths leading up to this point.

    $log_time = time();
    $sql_log = $mysqli->query("INSERT INTO change_log

The assignment to $sql_log is dead and can be removed.

        (section, section_id, section_name, sub_section, sub_section_id, sub_section_name, user_id, action, timestamp)
        VALUES ('$section', '$section_id', '$section_name', '$subsection', '$subsection_id', '$subsection_name',
        '$user_id', '$action', '$log_time')") or die("Couldn't insert change log into database");

Using exit here is not recommended.

}