$success = 95; } $roll = random_int(1, 100); if ($roll < $success) { echo "<strong>" . $row['character_name'] . " " . $langvars['l_planet_ison'] . "</strong><br>"; } $res->MoveNext(); } } $update = $db->Execute("UPDATE {$db->prefix}ships SET turns = turns - 1, turns_used = turns_used + 1 WHERE ship_id = ?;", array($playerinfo['ship_id'])); Tki\Db::LogDbErrors($pdo_db, $update, __LINE__, __FILE__); } elseif ($command == "capture" && $planetinfo['owner'] == 0) { echo $langvars['l_planet_captured'] . "<br>"; $update = $db->Execute("UPDATE {$db->prefix}planets SET team = 0, owner = ?, base = 'N', defeated = 'N' WHERE planet_id = ?;", array($playerinfo['ship_id'], $planet_id)); Tki\Db::LogDbErrors($pdo_db, $update, __LINE__, __FILE__); $ownership = Tki\Ownership::calc($pdo_db, $playerinfo['sector'], $tkireg, $langvars); if ($ownership !== null) { echo "{$ownership}<p>"; } if ($planetinfo['owner'] != 0) { Tki\Score::updateScore($pdo_db, $planetinfo['owner'], $tkireg, $playerinfo); } if ($planetinfo['owner'] != 0) { $sql = "SELECT character_name FROM ::prefix::ships WHERE ship_id=:ship_id LIMIT 1"; $stmt = $pdo_db->prepare($sql); $stmt->bindParam(':ship_id', $planetinfo['owner']); $stmt->execute(); $planetowner = $stmt->fetch(PDO::FETCH_ASSOC); } else { $planetowner = $langvars['l_planet_noone']; }
Tki\Db::LogDbErrors($pdo_db, $resy, __LINE__, __FILE__); $resz = $db->Execute("UPDATE {$db->prefix}teams SET number_of_members = number_of_members - 1, creator = ? WHERE id = ?;", array($newcreator, $whichteam)); Tki\Db::LogDbErrors($pdo_db, $resz, __LINE__, __FILE__); $res = $db->Execute("SELECT DISTINCT sector_id FROM {$db->prefix}planets WHERE owner = ? AND base = 'Y' AND team <> 0;", array($playerinfo['ship_id'])); Tki\Db::LogDbErrors($pdo_db, $res, __LINE__, __FILE__); $i = 0; while (!$res->EOF) { $sectors[$i] = $res->fields['sector_id']; $i++; $res->MoveNext(); } $resx = $db->Execute("UPDATE {$db->prefix}planets SET team = 0 WHERE owner = ?;", array($playerinfo['ship_id'])); Tki\Db::LogDbErrors($pdo_db, $resx, __LINE__, __FILE__); if ($sectors !== null) { foreach ($sectors as $sector) { Tki\Ownership::calc($pdo_db, $sector, $tkireg->min_bases_to_own, $langvars); } } Tki\PlayerLog::WriteLog($pdo_db, $playerinfo['ship_id'], LOG_TEAM_NEWLEAD, $team['team_name'] . "|" . $newcreatorname['character_name']); Tki\PlayerLog::WriteLog($pdo_db, $newcreator, LOG_TEAM_LEAD, $team['team_name']); } echo "<br><br><a href=\"teams.php\">" . $langvars['l_clickme'] . "</a> " . $langvars['l_team_menu'] . ".<br><br>"; break; case 3: // Join a team if ($playerinfo['team'] != 0) { echo $langvars['l_team_leavefirst'] . "<br>"; } else { if ($playerinfo['team_invite'] == $whichteam) { $resx = $db->Execute("UPDATE {$db->prefix}ships SET team = ?, team_invite = 0 WHERE ship_id = ?;", array($whichteam, $playerinfo['ship_id'])); Tki\Db::LogDbErrors($pdo_db, $resx, __LINE__, __FILE__);
$planetinfo = $result2->fields; } if ($planetinfo['owner'] == $playerinfo['ship_id'] || $planetinfo['team'] == $playerinfo['team'] && $playerinfo['team'] > 0) { echo "<h1>" . $title . "</h1>\n"; if ($action == "planetteam") { echo $langvars['l_teamm_toteam'] . "<br>"; $result = $db->Execute("UPDATE {$db->prefix}planets SET team=?, owner=? WHERE planet_id = ?;", array($playerinfo['team'], $playerinfo['ship_id'], $planet_id)); Tki\Db::LogDbErrors($pdo_db, $result, __LINE__, __FILE__); $ownership = Tki\Ownership::calc($pdo_db, $playerinfo['sector'], $tkireg->min_bases_to_own, $langvars); if ($ownership !== null) { echo "<p>{$ownership}<p>"; } } if ($action == "planetpersonal") { echo $langvars['l_teamm_topersonal'] . "<br>"; $result = $db->Execute("UPDATE {$db->prefix}planets SET team='0', owner = ? WHERE planet_id = ?;", array($playerinfo['ship_id'], $planet_id)); Tki\Db::LogDbErrors($pdo_db, $result, __LINE__, __FILE__); $ownership = Tki\Ownership::calc($pdo_db, $playerinfo['sector'], $tkireg->min_bases_to_own, $langvars); // Kick other players off the planet $result = $db->Execute("UPDATE {$db->prefix}ships SET on_planet='N' WHERE on_planet='Y' AND planet_id = ? AND ship_id <> ?;", array($planet_id, $playerinfo['ship_id'])); Tki\Db::LogDbErrors($pdo_db, $result, __LINE__, __FILE__); if ($ownership !== null) { echo "<p>" . $ownership . "<p>"; } } Tki\Text::gotomain($pdo_db, $lang); } else { echo "<br>" . $langvars['l_team_exploit'] . "<br>"; Tki\Text::gotomain($pdo_db, $lang); } Tki\Footer::display($pdo_db, $lang, $tkireg, $template);