RPGA Module List

prepare("SELECT mod_code, mod_name, mod_min_level, mod_max_level, mod_exp_low, mod_exp_high FROM modules"); $sthAwards = $db->prepare("SELECT award_code, award_name, award_text FROM awards WHERE mod_code = ?"); $sthMods->execute(); while ($row = $sthMods->fetch()) { $sthAwards->execute(array($row['mod_code'])); # Mod info row echo '' . "\n"; echo ' ' . "\n"; echo ' ' . "\n"; echo ' ' . "\n"; echo ''; # Mod details row echo '' . "\n"; echo ' ' . "\n"; } ?>
CodeNameLevels
' . $row['mod_code'] . '' . $row['mod_name'] . 'Level ' . $row['mod_min_level'] . '-' . $row['mod_max_level'] . '
' . "\n"; echo '
'; while ($awardRow = $sthAwards->fetch()) { echo $awardRow['award_code'] . ': ' . $awardRow['award_name'] . '
' . "\n"; } echo '
' . "\n"; echo '
Exp: ' . $row['mod_exp_low'] . ' / ' . $row['mod_exp_high'] . '
Gold: ' . '
' . "\n"; echo '