if (empty($race_id) || $race_id == 1) {
create_error('Please choose a race!');
}
if (!is_numeric($var['game_id'])) {
create_error('Game ID is not numeric');
}
$gameID = $var['game_id'];
$db->query('SELECT 1 FROM player WHERE game_id = ' . $db->escapeNumber($gameID) . ' AND player_name = ' . $db->escape_string($player_name, true) . ' LIMIT 1');
if ($db->nextRecord() > 0) {
create_error('The player name already exists.');
}
if (!Globals::isValidGame($gameID)) {
create_error('Game not found!');
}
// does it cost something to join that game?
$credits = Globals::getGameCreditsRequired($gameID);
if ($credits > 0) {
if ($account->getTotalSmrCredits() < $credits) {
create_error('You do not have enough credits to join this game!');
}
$account->decreaseTotalSmrCredits($credits);
}
// check if hof entry is there
$db->query('SELECT 1 FROM account_has_stats WHERE account_id = ' . $db->escapeNumber(SmrSession::$account_id) . ' LIMIT 1');
if (!$db->nextRecord()) {
$db->query('INSERT INTO account_has_stats (account_id, HoF_name) VALUES (' . $db->escapeNumber($account->getAccountID()) . ', ' . $db->escape_string($account->getLogin(), true) . ')');
}
// put him in a sector with a hq
$hq_id = $race_id + 101;
$db->query('SELECT * FROM location JOIN sector USING(game_id, sector_id) ' . 'WHERE game_id = ' . $db->escapeNumber($gameID) . ' AND ' . 'location_type_id = ' . $db->escapeNumber($hq_id));
if ($db->nextRecord()) {
?> </td> </tr> <tr> <td align="right">Game Speed</td> <td> </td> <td align="left"><?php echo Globals::getGameSpeed($StatsGameID); ?> </td> </tr> <tr> <td align="right">Credits Needed</td> <td> </td> <td align="left"><?php echo number_format(Globals::getGameCreditsRequired($StatsGameID)); ?> </td> </tr> <tr> <td align="right">Stats Ignored</td> <td> </td> <td align="left"><?php echo Globals::getGameIgnoreStats($StatsGameID) ? 'Yes' : 'No'; ?> </td> </tr> <tr> <td align="right">Starting Credits</td> <td> </td> <td align="left"><?php