$i = 1; foreach ($lookup_results as $result) { $stmt_acct = $db->prepare('SELECT * FROM characters WHERE charid = ? LIMIT 1'); $stmt_acct->execute(array($result['charid'])); $character = $stmt_acct->fetch(PDO::FETCH_ASSOC); $stmt_username = $db->prepare('SELECT * FROM user_accounts WHERE uid = ? LIMIT 1'); $stmt_username->execute(array($character['uid'])); $account = $stmt_username->fetch(PDO::FETCH_ASSOC); ?> <tr style="text-align: center"> <td style="width: 10%"><?php echo $i; ?> </td> <td><?php echo Character::fetchCharacterName($result['charid']); ?> </td> <td><?php echo $account['username']; ?> </td> <td><?php echo $result['level']; ?> </td> </tr> <?php $i++; } }
public static function getDoctrineCompliance($characterID) { //Globalizing the DB variable global $db; // Getting the group ID $groupID = Character::fetchGroupID($characterID); $characterName = Character::fetchCharacterName($characterID); // Getting the list of doctrines $stmt = $db->prepare('SELECT * FROM doctrines WHERE gid = ? ORDER BY doctrineid ASC'); $stmt->execute(array($groupID)); $doctrines = $stmt->fetchAll(PDO::FETCH_ASSOC); // Creating some statements for future use with getting fitting and module information for each doctrine and fitting respectively $stmtFittings = $db->prepare('SELECT * FROM doctrines_fits WHERE doctrineid = ? ORDER BY fittingid ASC'); $stmtModules = $db->prepare('SELECT * FROM doctrines_fittingmods WHERE fittingid = ? ORDER BY type_id ASC'); //Looping through each doctrine to get fitting information foreach ($doctrines as $doctrine) { $stmtFittings->execute(array($doctrine['doctrineid'])); $fittings = $stmtFittings->fetchAll(PDO::FETCH_ASSOC); // Looping through each fitting to get module information foreach ($fittings as $fitting) { // Setting the default failure, warning, and success levels for the fitting $fittingFailure = 0; $fittingSuccess = 0; $fittingWarning = 0; $fittingTotal = 0; $stmtModules->execute(array($fitting['fittingid'])); $modules = $stmtModules->fetchAll(PDO::FETCH_ASSOC); // Getting skill information about the ship hull itself $hullCheck = Fitting::checkItemPrerequisites($fitting['fitting_ship'], $characterID); if ($hullCheck === TRUE) { $fittingSuccess += 1; } elseif ($hullCheck == "Warning") { $fittingWarning += 1; } else { $fittingFailure += 1; } $fittingTotal += 1; // Looping through each module to get skill information, and compare it to the character in question foreach ($modules as $module) { $moduleCheck = Fitting::checkItemPrerequisites($module['type_id'], $characterID); if ($moduleCheck === TRUE) { $fittingSuccess += 1; } elseif ($hullCheck == "Warning") { $fittingWarning += 1; } else { $fittingFailure += 1; } $fittingTotal += 1; } if ($fittingFailure >= 1) { $colorStatus = 'failure'; } elseif ($fittingWarning >= 1) { $colorStatus = 'warning'; } else { $colorStatus = 'success'; } // Inputting the fitting into the tracking database $stmt = $db->prepare('INSERT INTO doctrines_tracking (charid,character_name,gid,doctrineid,fittingid,usable_items,total_items,color_status) VALUES (?,?,?,?,?,?,?,?)' . ' ON DUPLICATE KEY UPDATE character_name=VALUES(character_name),gid=VALUES(gid),usable_items=VALUES(usable_items),total_items=VALUES(total_items),color_status=VALUES(color_status)'); $stmt->execute(array($characterID, $characterName, $groupID, $doctrine['doctrineid'], $fitting['fittingid'], $fittingSuccess, $fittingTotal, $colorStatus)); } } }