$iAttackScoreLimit = max(1, (int) $GAMEPREFS['military_scorelimit']);
// 2
$iMinActionTicks = max(1, (int) $GAMEPREFS['military_min_period']);
$iMaxActionTicks = max($iMinActionTicks, (int) $GAMEPREFS['military_max_period']);
// MOVE SHIPS //
if (isset($_POST['m'])) {
$arrAllowedShips = db_fetch_fields('
SELECT
s.id,
s.id
FROM
d_all_units u,
d_ships s
WHERE
u.id = s.id AND
u.r_d_required_id IN (
SELECT
r_d_id
FROM
planet_r_d
WHERE
planet_id = ' . PLANET_ID . ' AND
eta = 0
);
');
foreach ((array) $_POST['m'] as $arrMove) {
if (!isset($arrMove['ship_id'], $arrMove['amount'], $arrMove['from_fleet'], $arrMove['to_fleet']) || $arrMove['from_fleet'] === $arrMove['to_fleet']) {
continue;
}
$szFleetAction1 = (string) db_select_one('fleets', 'action', 'owner_planet_id = ' . PLANET_ID . ' AND fleetname = \'' . $arrMove['to_fleet'] . '\'');
$szFleetAction2 = (string) db_select_one('fleets', 'action', 'owner_planet_id = ' . PLANET_ID . ' AND fleetname = \'' . $arrMove['from_fleet'] . '\'');
<td><input type="submit" value="Search" style="width:100%;" /></td>
</tr>
</form>
<form method="get" action="" autocomplete="off" onsubmit="return postForm(this,H);">
<tr>
<td width="40%" class="c"><select name="intel_scan_id"><option value="">--</option>
<?php
$arrScans = db_fetch_fields('
SELECT
u.id,
CONCAT(u.id,\'. \',u.unit_plural)
FROM
d_all_units u,
planet_r_d p
WHERE
u.r_d_required_id = p.r_d_id AND
p.planet_id = ' . PLANET_ID . ' AND
p.eta = 0 AND
u.T = \'scan\' AND
u.is_mobile = \'1\' AND
0 < IFNULL((SELECT SUM(amount) FROM waves_on_planets WHERE planet_id = ' . PLANET_ID . ' AND wave_id = u.id),0)
ORDER BY
u.o ASC;
');
foreach ($arrScans as $iScan => $szScan) {
echo '<option' . (isset($_GET['intel_scan_id']) && $_GET['intel_scan_id'] == $iScan ? ' selected="1"' : '') . ' value="' . $iScan . '">' . $szScan . '</option>';
}
?>
</select></td>
<td width="40%" class="c">
<input type="text" name="x" value="<?php
/**
* L a n g u a g e s - S E T
*/
public static function setLanguages($f_iLanguageId = null)
{
$q = db_query('SELECT `key` FROM language_keys;');
if ($q) {
while ($r = mysql_fetch_assoc($q)) {
$a[$r['key']] = '';
}
}
$arrLanguages = !$f_iLanguageId ? db_select('languages') : db_select('languages', 'id = ' . (int) $f_iLanguageId);
foreach ($arrLanguages as $arrLanguage) {
$szFile = PROJECT_RESOURCES . '/languages/' . $arrLanguage['id'] . '.txt';
$r = $a;
if (null !== $arrLanguage['parent_language_id']) {
$szQuery = '
SELECT
UPPER(language_keys.key) AS k,
language_translations.value AS v
FROM
language_translations,
language_keys,
languages
WHERE
languages.id = ' . (int) $arrLanguage['parent_language_id'] . ' AND
language_translations.language_id = languages.id AND
language_keys.id = language_translations.language_key_id;';
$r = array_merge($r, db_fetch_fields($szQuery));
}
$szQuery = '
SELECT
UPPER(language_keys.key) AS k,
language_translations.value AS v
FROM
language_translations,
language_keys,
languages
WHERE
languages.id = ' . (int) $arrLanguage['id'] . ' AND
language_translations.language_id = languages.id AND
language_keys.id = language_translations.language_key_id;';
$r = array_merge($r, db_fetch_fields($szQuery));
fwrite($h = fopen($szFile, 'w'), serialize($r));
fclose($h);
}
}
function getUserBets()
{
$arrBets = db_fetch_fields('SELECT pl.user_id, IFNULL(SUM(b.bet), 0) AS bet FROM ' . TABLE_POOLS . ' po, ' . TABLE_PLAYERS . ' pl LEFT JOIN ' . TABLE_BETS . ' b ON b.user_id = pl.user_id WHERE pl.sit_out = \'0\' AND pl.in_or_out = \'in\' AND po.table_id = ' . TABLE_ID . ' GROUP BY pl.user_id');
return $arrBets;
}
<?php
if (isset($_GET['mode']) && $_GET['mode'] == "toggle") {
$t = '1' == $g_arrUser['show_all_r_d'] ? '0' : '1';
db_update('planets', "show_all_r_d = '" . $t . "'", 'id = ' . PLANET_ID);
Go();
}
$arrSkills = db_fetch_fields('SELECT s.id, IFNULL((SELECT value FROM planet_skills WHERE skill_id = s.id AND planet_id = ' . PLANET_ID . '),0) AS value FROM d_skills s ORDER BY s.id ASC;');
if (isset($_GET['r_d_id'])) {
// Make sure that R&D exists and none other is busy
if (!count($rd = db_select('d_r_d_available', 'id = ' . (int) $_GET['r_d_id'] . ' AND T = \'' . $szType . '\' LIMIT 1')) || db_count('d_r_d_available a, planet_r_d p', 'a.id = p.r_d_id AND p.planet_id = ' . PLANET_ID . ' AND p.eta <> 0 AND a.T = \'' . $rd[0]['T'] . '\'')) {
exit(json::encode(array(array('msg', 'Invalid ID!'))));
}
$rd = $rd[0];
// check requirements
if (!db_count('d_r_d_available a', 'a.id = ' . (int) $rd['id'] . ' AND T = \'' . $szType . '\' AND
(
a.id NOT IN
(
SELECT
r_d_id
FROM
d_r_d_requires
) OR
a.id IN
(
SELECT
r.r_d_id
FROM
d_r_d_requires r
JOIN
function db_select_fields($tbl, $fields, $where = '')
{
$query = 'SELECT ' . $fields . ' FROM ' . $tbl . ($where ? ' WHERE ' . $where : '');
return db_fetch_fields($query);
}
