+global\authCheck::checkPermissions()

Complexity

Conditions	30
Paths	116

Size

Total Lines	91
Code Lines	56

Duplication

Lines	13
Ratio	14.29 %

Importance

Changes

0

<?php
    private function checkPermissions()
    {
        //Get guild object
        $guild = $this->discord->guilds->get('id', $this->guildID);

        //Establish connection to mysql
        $conn = new mysqli($this->db, $this->dbUser, $this->dbPass, $this->dbName);

        $sql = "SELECT characterID, discordID, eveName, role FROM authUsers WHERE active='yes'";

        $result = $conn->query($sql);

        //Set empty arrays
        $corpArray = array();
        $allianceArray = array();

        // If config is outdated
        if (null === $this->authGroups) {

This code seems to be duplicated across your project.

            $msg = '**Auth Failure:** Please update the bots config to the latest version.';
            queueMessage($msg, $this->alertChannel, $this->guild);
            $nextCheck = time() + 10800;
            setPermCache('permsLastChecked', $nextCheck);
            return null;
        }

        //Set corp/ally id arrays
        foreach ($this->authGroups as $authGroup) {
            if ($authGroup['corpID'] !== 0) {
                $corpArray[] = (int)$authGroup['corpID'];
            }
            if ($authGroup['allianceID'] !== 0) {
                $allianceArray[] = (int)$authGroup['allianceID'];
            }
        }

        if ($result->num_rows >= 1) {
            while ($rows = $result->fetch_assoc()) {
                $charID = $rows['characterID'];
                $discordID = $rows['discordID'];
                $role = $rows['role'];
                $member = $guild->members->get('id', $discordID);
                $eveName = $rows['eveName'];
                //Check if member has roles
                if (null === @$member->roles) {
                    continue;
                }

                //Auth things
                $character = characterDetails($charID);
                //if issue with esi, skip
                if (null === $character) {
                    continue;
                }
                $corporationID = $character['corporation_id'];
                $corporationDetails = corpDetails($corporationID);
                if (null === $corporationDetails) {
                    continue;
                }
                $allianceID = @$corporationDetails['alliance_id'];

                //check if user authed based on standings
                $standings = null;
                if ($role === 'blue' || 'neut' || 'red') {
                    $allianceContacts = getContacts($allianceID);

Are you sure the assignment to $allianceContacts is correct as getContacts($allianceID) (which targets getContacts()) seems to always return null.

                    $corpContacts = getContacts($corporationID);

Are you sure the assignment to $corpContacts is correct as getContacts($corporationID) (which targets getContacts()) seems to always return null.

                    if ($role === 'blue' && ($allianceContacts['standings'] || $corpContacts['standings'] === 5 || 10)) {

This code seems to be duplicated across your project.

                        $standings = 1;
                    }
                    if ($role === 'red' && ($allianceContacts['standings'] || $corpContacts['standings'] === -5 || -10)) {

This code seems to be duplicated across your project.

                        $standings = 1;
                    }
                    if ($role === 'neut' && ($allianceContacts['standings'] || $corpContacts['standings'] === 0 || (@(int)$allianceContacts['standings'] && @(int)$corpContacts['standings'] === null || ''))) {
                        $standings = 1;
                    }
                }
                if (!in_array((int)$allianceID, $allianceArray) && !in_array((int)$corporationID, $corpArray) && null === $standings) {
                    // Deactivate user in database
                    $sql = "UPDATE authUsers SET active='no' WHERE discordID='$discordID'";
                    $this->logger->addInfo("AuthCheck: {$eveName} account has been deactivated as they are no longer in a correct corp/alliance.");
                    $conn->query($sql);
                    continue;
                }
            }
            $nextCheck = time() + 10800;
            setPermCache('permsLastChecked', $nextCheck);
            return null;
        }
        $nextCheck = time() + 10800;
        setPermCache('permsLastChecked', $nextCheck);
        return null;
    }