function digest_getMovements($ownCave, $doNotShow, $showDetails) { global $db; // get movements $ua_movements = Movement::getMovements(); // caveIDs einsammeln $caveIDs = implode(', ', array_map(array($db, 'quote'), array_keys($ownCave))); // Bewegungen besorgen $query = "SELECT *\n FROM " . EVENT_MOVEMENT_TABLE . "\n WHERE source_caveID IN (" . $caveIDs . ")\n OR target_caveID IN (" . $caveIDs . ")\n ORDER BY end ASC, event_movementID ASC"; if (!($sql = $db->query($query))) { return array(); } $rows = $sql->fetchAll(); $sql->closeCursor(); // bewegungen durchgehen $result = array(); foreach ($rows as $row) { // "do not show" movements should not be shown if (in_array($row['movementID'], $doNotShow)) { continue; } // is own movement? $row['isOwnMovement'] = in_array($row['caveID'], array_keys($ownCave)); ///////////////////////////////// // SICHTWEITE BESCHRÄNKEN /* We got some problems, as reverse movements should not ALWAYS be visible. * For example a transport reverse movement should be visible, but a * spy reverse movement should not... * As a work around we will fix it by not showing any adverse reverse movement. * * The original code is following... if (!$row['isOwnMovement']){ if ($ua_movements[$row['movementID']]->returnID == -1){ $sichtweite = getVisionRange($ownCave[$row['source_caveID']]) * $row['speedFactor']; $distance = time() - (time_fromDatetime($row['end']) - getDistanceByID($srcID, $destID) * $row['speedFactor']); } else { $sichtweite = getVisionRange($ownCave[$row['target_caveID']]) * $row['speedFactor']; $distance = ceil((time_fromDatetime($row['end']) - time())/60); } if ($sichtweite < $distance) continue; } */ // compute visibility if (!$row['isOwnMovement']) { // don't show adverse reverse movements if ($ua_movements[$row['movementID']]->returnID == -1) { continue; } $sichtweite = getVisionRange($ownCave[$row['target_caveID']]) * $row['speedFactor']; $distance = ceil((time_fromDatetime($row['end']) - time()) / 60); if ($sichtweite < $distance) { continue; } } ///////////////////////////////// // ***** fremde unsichtbare bewegung ***** if ($row['isOwnMovement'] == 0) { if ($ua_movements[$row['movementID']]->mayBeInvisible) { $anzahl_sichtbarer_einheiten = 0; foreach ($GLOBALS['unitTypeList'] as $unitType) { if ($unitType->visible) { $anzahl_sichtbarer_einheiten += $row[$unitType->dbFieldName]; } } if ($anzahl_sichtbarer_einheiten == 0) { continue; } } } $tmp = array('event_id' => $row['event_movementID'], 'cave_id' => $row['caveID'], 'source_cave_id' => $row['source_caveID'], 'target_cave_id' => $row['target_caveID'], 'movement_id' => $row['movementID'], 'event_start' => time_fromDatetime($row['start']), 'event_start_date' => time_formatDatetime($row['start']), 'event_end' => time_fromDatetime($row['end']), 'event_end_date' => time_formatDatetime($row['end']), 'isOwnMovement' => intval($row['isOwnMovement']), 'seconds_before_end' => time_fromDatetime($row['end']) - time(), 'movement_id_description' => $ua_movements[$row['movementID']]->description); // Quelldaten $source = getCaveNameAndOwnerByCaveID($row['source_caveID']); foreach ($source as $key => $value) { $tmp['source_' . $key] = $value; } // Zieldaten $target = getCaveNameAndOwnerByCaveID($row['target_caveID']); foreach ($target as $key => $value) { $tmp['target_' . $key] = $value; } // ***** Einheiten, Rohstoffe und Artefakte ***** if ($showDetails) { // show artefact if ($row['artefactID']) { $tmp['artefact'] = artefact_getArtefactByID($row['artefactID']); } // show hero if ($row['heroID']) { $tmp['hero'] = "Held läuft mit!"; } // eval(GameConstants::EXPOSE_INVISIBLE) // FIXME (mlunzena): oben holen wir schon bestimmte Höhlendaten, // das sollte man zusammenfassen.. $target = getCaveByID($row['target_caveID']); $expose = eval('return ' . formula_parseToPHP(GameConstants::EXPOSE_INVISIBLE . ";", '$target')); // show units $units = array(); foreach ($GLOBALS['unitTypeList'] as $unit) { // this movement does not contain units of that type if (!$row[$unit->dbFieldName]) { continue; } // expose invisible units // if it is your own move // if unit is visible if (!$row['isOwnMovement'] && !$unit->visible) { // if target cave's EXPOSEINVISIBLE is > than exposeChance if ($expose <= $row['exposeChance']) { // do not expose continue; } else { // do something // for example: // $row[$unit->dbFieldName] *= 2.0 * (double)rand() / (double)getRandMax(); } } $units[] = array('unitID' => $unit->unitID, 'dbFieldName' => $unit->dbFieldName, 'name' => $unit->name, 'value' => $ua_movements[$row['movementID']]->fogUnit && !$row['isOwnMovement'] ? calcFogUnit($row[$unit->dbFieldName]) : $row[$unit->dbFieldName]); } if (sizeof($units)) { $tmp['units'] = $units; } $resources = array(); foreach ($GLOBALS['resourceTypeList'] as $resource) { if (!$row[$resource->dbFieldName]) { continue; } $resources[] = array('name' => $resource->name, 'dbFieldName' => $resource->dbFieldName, 'value' => $ua_movements[$row['movementID']]->fogResource && !$row['isOwnMovement'] ? calcFogResource($row[$resource->dbFieldName]) : $row[$resource->dbFieldName]); } if (sizeof($resources)) { $tmp['resources'] = $resources; } if ($row['isOwnMovement'] && $ua_movements[$row['movementID']]->returnID != -1 && !$row['artefactID'] && !$row['blocked']) { $tmp['cancel'] = array("modus" => UNIT_MOVEMENT, "eventID" => $row['event_movementID']); } } $result[] = $tmp; } return $result; }
function export_movement_irc($movementID) { global $db; require_once 'lib/Movement.php'; require_once 'include/digest.inc.php'; // gather data $ua_movements = Movement::getMovements(); $move = export_getSingleMovement($movementID); if (!sizeof($move)) { return 'Es wurde keine Bewegung gefunden!'; } // get Cave data $sourceCaveData = getCaveNameAndOwnerByCaveID($move['source_caveID']); $targetCaveData = getCaveNameAndOwnerByCaveID($move['target_caveID']); // check if it's a player related movement if ($sourceCaveData['player_name'] !== $_SESSION['player']->name && $targetCaveData['player_name'] !== $_SESSION['player']->name) { return 'Nur eigene Bewegungen erlaubt!'; } // artefact data $artefactData = array(); if ($move['artefactID'] != 0) { $artefactData = artefact_getArtefactByID($move['artefactID']); } // header $header = "Bewegungsart: 4" . $ua_movements[$move['movementID']]->description . "\n"; $header .= "Startzeitpunkt:4 " . time_formatDatetime($move['start']) . "\n"; $header .= "Endzeitpunkt:4 " . time_formatDatetime($move['end']) . "\n"; // movement source $source = "Starthöhle: 4" . $sourceCaveData['cave_name'] . " "; $source .= " (" . $sourceCaveData['xCoord'] . "|" . $sourceCaveData['yCoord'] . ") "; if ($sourceCaveData['player_name']) { $source .= "des Spielers 4" . $sourceCaveData['player_name'] . " "; $source .= "aus dem Stamme 4" . $sourceCaveData['player_tribe'] . " "; } $source .= "\n"; // movement target $target = "Zielhöhle: 4" . $targetCaveData['cave_name']; $target .= " (" . $targetCaveData['xCoord'] . "|" . $targetCaveData['yCoord'] . ") "; if ($targetCaveData['player_name']) { $target .= "des Spielers 4 " . $targetCaveData['player_name'] . " "; $target .= "aus dem Stamme 4" . $targetCaveData['player_tribe'] . " "; } $target .= "\n"; // units $units = "Einheiten: "; foreach ($GLOBALS['unitTypeList'] as $unitsID => $unitDetail) { if ($move[$unitDetail->dbFieldName] > 0) { if ($move['isOwnMovement'] || $unitDetail->visible) { $units .= $unitDetail->name . ": " . ($ua_movements[$move['movementID']]->fogUnit && !$move['isOwnMovement'] ? calcFogUnit($move[$unitDetail->dbFieldName]) : $move[$unitDetail->dbFieldName]) . ", "; } } } $units = substr($units, 0, -2); // resources $resources = ""; foreach ($GLOBALS['resourceTypeList'] as $resourceID => $resourceDetail) { if ($move[$resourceDetail->dbFieldName] > 0) { $resources .= $resourceDetail->name . ": " . ($ua_movements[$move['movementID']]->fogResource && !$move['isOwnMovement'] ? calcFogResource($move[$resourceDetail->dbFieldName]) : $move[$resourceDetail->dbFieldName]) . ", "; } } if ($resources !== "") { $resources = "transportierte Rohstoffe: " . $resources; $resources = substr($resources, 0, -2); } // Artefacts $artefact = ''; if ($move['artefactID'] != 0) { $artefact = "transportierte Artefakte: " . $artefactData['name']; } // Hero $hero = ''; if ($move['heroID'] != 0 && $move['isOwnMovement']) { $hero = "Held läuft mit!"; } $irc = ""; $irc .= $header; $irc .= $source; $irc .= $target . "\n"; $irc .= $units . "\n"; $irc .= $resources . "\n"; $irc .= $artefact . "\n"; $irc .= $hero . "\n"; return $irc; }
function digest_getMovements($ownCave, $doNotShow, $showDetails) { global $db; // get movements $ua_movements = Movement::getMovements(); // caveIDs einsammeln $caveIDs = implode(', ', array_map(array($db, 'quote'), array_keys($ownCave))); $targetExtraFilds = formula_parseToSelectSQL(GameConstants::EXPOSE_INVISIBLE); $sqlExtra = array(); foreach ($targetExtraFilds as $field) { $sqlTargetExtra[] = 'tc.' . $field . ' AS target_' . $field; } $sql = $db->prepare("SELECT em.*, sc.name AS source_cave_name, sp.name AS source_player_name, st.tag AS source_player_tribe, sc.xCoord AS source_xCoord, sc.yCoord AS source_yCoord, tc.name AS target_cave_name, tp.name AS target_player_name, tt.tag AS target_player_tribe, tc.xCoord AS target_xCoord, tc.yCoord AS target_yCoord " . (!empty($sqlTargetExtra) ? ', ' . implode(', ', $sqlTargetExtra) : '') . "\n FROM " . EVENT_MOVEMENT_TABLE . " em\n LEFT JOIN " . CAVE_TABLE . " sc ON sc.caveID = em.source_caveID\n LEFT JOIN " . PLAYER_TABLE . " sp ON sp.playerID = sc.playerID\n LEFT JOIN " . TRIBE_TABLE . " st ON st.tribeID = sp.tribeID\n LEFT JOIN " . CAVE_TABLE . " tc ON tc.caveID = em.target_caveID\n LEFT JOIN " . PLAYER_TABLE . " tp ON tp.playerID = tc.playerID\n LEFT JOIN " . TRIBE_TABLE . " tt ON tt.tribeID = tp.tribeID\n WHERE em.source_caveID IN (" . $caveIDs . ")\n OR em.target_caveID IN (" . $caveIDs . ")\n ORDER BY em.end ASC, em.event_movementID ASC"); if (!$sql->execute()) { return array(); } $rows = $sql->fetchAll(PDO::FETCH_ASSOC); $sql->closeCursor(); // bewegungen durchgehen $result = array(); foreach ($rows as $row) { // "do not show" movements should not be shown if (in_array($row['movementID'], $doNotShow)) { continue; } // is own movement? $row['isOwnMovement'] = in_array($row['caveID'], array_keys($ownCave)); ///////////////////////////////// // SICHTWEITE BESCHRÄNKEN /* We got some problems, as reverse movements should not ALWAYS be visible. * For example a transport reverse movement should be visible, but a * spy reverse movement should not... * As a work around we will fix it by not showing any adverse reverse movement. * * The original code is following... if (!$row['isOwnMovement']){ if ($ua_movements[$row['movementID']]->returnID == -1){ $sichtweite = getVisionRange($ownCave[$row['source_caveID']]) * $row['speedFactor']; $distance = time() - (time_fromDatetime($row['end']) - getDistanceByID($srcID, $destID) * $row['speedFactor']); } else { $sichtweite = getVisionRange($ownCave[$row['target_caveID']]) * $row['speedFactor']; $distance = ceil((time_fromDatetime($row['end']) - time())/60); } if ($sichtweite < $distance) continue; } */ // compute visibility if (!$row['isOwnMovement']) { // don't show adverse reverse movements if ($ua_movements[$row['movementID']]->returnID == -1) { continue; } $sichtweite = getVisionRange($ownCave[$row['target_caveID']]) * $row['speedFactor']; $distance = ceil((time_fromDatetime($row['end']) - time()) / 60); if ($sichtweite < $distance) { continue; } } ///////////////////////////////// // ***** fremde unsichtbare bewegung ***** if ($row['isOwnMovement'] == 0) { if ($ua_movements[$row['movementID']]->mayBeInvisible) { $anzahl_sichtbarer_einheiten = 0; foreach ($GLOBALS['unitTypeList'] as $unitType) { if ($unitType->visible) { $anzahl_sichtbarer_einheiten += $row[$unitType->dbFieldName]; } } if ($anzahl_sichtbarer_einheiten == 0) { continue; } } } $tmp = array('event_id' => $row['event_movementID'], 'cave_id' => $row['caveID'], 'source_cave_id' => $row['source_caveID'], 'target_cave_id' => $row['target_caveID'], 'movement_id' => $row['movementID'], 'event_start' => time_fromDatetime($row['start']), 'event_start_date' => time_formatDatetime($row['start']), 'event_end' => time_fromDatetime($row['end']), 'event_end_date' => time_formatDatetime($row['end']), 'isOwnMovement' => intval($row['isOwnMovement']), 'seconds_before_end' => time_fromDatetime($row['end']) - time(), 'movement_id_description' => $ua_movements[$row['movementID']]->description, 'source_cave_name' => $row['source_cave_name'], 'source_player_name' => $row['source_player_name'], 'source_player_tribe' => $row['source_player_tribe'], 'source_xCoord' => $row['source_xCoord'], 'source_yCoord' => $row['source_yCoord'], 'target_cave_name' => $row['target_cave_name'], 'target_player_name' => $row['target_player_name'], 'target_player_tribe' => $row['target_player_tribe'], 'target_xCoord' => $row['target_xCoord'], 'target_yCoord' => $row['target_yCoord']); // ***** Einheiten, Rohstoffe und Artefakte ***** if ($showDetails) { // show artefact if ($row['artefactID']) { $tmp['artefact'] = artefact_getArtefactByID($row['artefactID']); } // show hero if ($row['heroID']) { $tmp['hero'] = "Held läuft mit!"; } // eval(GameConstants::EXPOSE_INVISIBLE) // FIXME (mlunzena): oben holen wir schon bestimmte Höhlendaten, // das sollte man zusammenfassen.. foreach ($targetExtraFilds as $field) { $target[$field] = $row['target_' . $field]; } $expose = eval('return ' . formula_parseToPHP(GameConstants::EXPOSE_INVISIBLE . ";", '$target')); // show units $units = array(); foreach ($GLOBALS['unitTypeList'] as $unit) { // this movement does not contain units of that type if (!$row[$unit->dbFieldName]) { continue; } // expose invisible units // if it is your own move // if unit is visible if (!$row['isOwnMovement'] && !$unit->visible) { // if target cave's EXPOSEINVISIBLE is > than exposeChance if ($expose <= $row['exposeChance']) { // do not expose continue; } else { // do something // for example: // $row[$unit->dbFieldName] *= 2.0 * (double)rand() / (double)getRandMax(); } } $units[] = array('unitID' => $unit->unitID, 'dbFieldName' => $unit->dbFieldName, 'name' => $unit->name, 'value' => $ua_movements[$row['movementID']]->fogUnit && !$row['isOwnMovement'] ? calcFogUnit($row[$unit->dbFieldName]) : $row[$unit->dbFieldName]); } if (sizeof($units)) { $tmp['units'] = $units; } $resources = array(); foreach ($GLOBALS['resourceTypeList'] as $resource) { if (!$row[$resource->dbFieldName]) { continue; } $resources[] = array('name' => $resource->name, 'dbFieldName' => $resource->dbFieldName, 'value' => $ua_movements[$row['movementID']]->fogResource && !$row['isOwnMovement'] ? calcFogResource($row[$resource->dbFieldName]) : $row[$resource->dbFieldName]); } if (sizeof($resources)) { $tmp['resources'] = $resources; } if ($row['isOwnMovement'] && $ua_movements[$row['movementID']]->returnID != -1 && !$row['artefactID'] && !$row['blocked']) { $tmp['cancel'] = array("modus" => UNIT_MOVEMENT, "eventID" => $row['event_movementID']); } } $result[] = $tmp; } return $result; }