function spreadVoid($caves, $minX, $minY, $maxX, $maxY)
{
for ($x = $minX; $x <= $maxX; $x++) {
for ($y = $minY; $y <= $maxY; $y++) {
if (isset($caves[$x][$y]) && $caves[$x][$y] == 1) {
$caves_new[$x][$y] = 1;
} else {
$count = countVoid($caves, $x, $y);
// linearly increasing probability
$prob = MAX_PROB / 8.0 * $count;
if (rand() / (double) getRandMax() < $prob) {
$caves_new[$x][$y] = 1;
}
}
}
}
return $caves_new;
}
function wonder_processOrder($playerID, $wonderID, $caveID, $coordX, $coordY, $caveData, $db)
{
global $defenseSystemTypeList, $unitTypeList, $buildingTypeList, $scienceTypeList, $resourceTypeList, $wonderTypeList;
// ADDED by chris--- for farmschutz: protection_end in sql
// check the target cave
$query = "SELECT playerID, caveID, protection_end FROM Cave " . "WHERE xCoord = '{$coordX}' " . "AND yCoord = '{$coordY}'";
if (!($result = $db->query($query)) || !($targetData = $result->nextRow())) {
return -3;
}
// ADDED by chris--- for farmschutz
if (date("YmdHis", time()) < $targetData[protection_end]) {
return -4;
}
// ----------------------------------
$targetID = $targetData[caveID];
// check, if cave allowed
if ($wonderTypeList[$wonderID]->target == "same") {
$allowed = $caveID == $targetID;
} else {
if ($wonderTypeList[$wonderID]->target == "own") {
$allowed = $playerID == $targetData[playerID];
} else {
if ($wonderTypeList[$wonderID]->target == "other") {
$allowed = $playerID != $targetData[playerID];
} else {
// $wonderTypeList[$wonderID]->target == "all"
$allowed = 1;
}
}
}
if (!$allowed) {
return -2;
}
$set = array();
$setBack = array();
$where = array("WHERE caveID = '{$caveID}' ");
// get all the resource costs
foreach ($wonderTypeList[$wonderID]->resourceProductionCost as $key => $value) {
if ($value != "" && $value != "0") {
$formula = formula_parseToSQL($value);
$dbField = $resourceTypeList[$key]->dbFieldName;
array_push($set, "{$dbField} = {$dbField} - ({$formula})");
array_push($setBack, "{$dbField} = {$dbField} + ({$formula})");
array_push($where, "{$dbField} >= ({$formula})");
}
}
// get all the unit costs
foreach ($wonderTypeList[$wonderID]->unitProductionCost as $key => $value) {
if ($value != "" && $value != "0") {
$formula = formula_parseToSQL($value);
$dbField = $unitTypeList[$key]->dbFieldName;
array_push($set, "{$dbField} = {$dbField} - {$formula}");
array_push($setBack, "{$dbField} = {$dbField} + {$formula}");
array_push($where, "{$dbField} >= {$formula}");
}
}
// generate SQL
if (sizeof($set)) {
$set = implode(", ", $set);
$set = "UPDATE Cave SET {$set} ";
$setBack = implode(", ", $setBack);
$setBack = "UPDATE Cave SET {$setBack} WHERE caveID = '{$caveID}'";
}
// generate dependecies
foreach ($wonderTypeList[$wonderID]->buildingDepList as $key => $value) {
if ($value != "" && $value != "0") {
array_push($where, "{$buildingTypeList[$key]->dbFieldName} >= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->maxBuildingDepList as $key => $value) {
if ($value != -1) {
array_push($where, "{$wonderTypeList[$key]->dbFieldName} <= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->defenseSystemDepList as $key => $value) {
if ($value != "" && $value != "0") {
array_push($where, "{$defenseSystemTypeList[$key]->dbFieldName} >= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->maxDefenseSystemDepList as $key => $value) {
if ($value != -1) {
array_push($where, "{$defenseSystemTypeList[$key]->dbFieldName} <= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->resourceDepList as $key => $value) {
if ($value != "" && $value != "0") {
array_push($where, "{$resourceTypeList[$key]->dbFieldName} >= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->maxResourceDepList as $key => $value) {
if ($value != -1) {
array_push($where, "{$resourceTypeList[$key]->dbFieldName} <= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->scienceDepList as $key => $value) {
if ($value != "" && $value != "0") {
array_push($where, "{$scienceTypeList[$key]->dbFieldName} >= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->maxScienceDepList as $key => $value) {
if ($value != -1) {
array_push($where, "{$scienceTypeList[$key]->dbFieldName} <= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->unitDepList as $key => $value) {
if ($value != "" && $value != "0") {
array_push($where, "{$unitTypeList[$key]->dbFieldName} >= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->maxUnitDepList as $key => $value) {
if ($value != -1) {
array_push($where, "{$unitTypeList[$key]->dbFieldName} <= {$value}");
}
}
$where = implode(" AND ", $where);
if (!$db->query($set . $where) || $db->affected_rows() != 1) {
return 0;
}
// calculate the chance and evaluate into $chance
if ($chance_formula = $wonderTypeList[$wonderID]->chance) {
$chance_eval_formula = formula_parseToPHP($chance_formula, '$caveData');
$chance_eval_formula = "\$chance={$chance_eval_formula};";
eval($chance_eval_formula);
}
// does the wonder fail?
// if ((double)rand() / (double)getRandMax() > $chance) {
srand((double) microtime() * 1000000);
$wond1 = (double) rand();
$wond2 = (double) getRandMax();
//echo $wond1." / ".$wond2." = ".$wond1/$wond2." -- ". $chance."<br>";
if ($wond1 / $wond2 > $chance) {
return 2;
// wonder did fail
}
// schedule the wonder's impacts
// create a random factor between -0.3 and +0.3
$delayRandFactor = rand(0, getrandmax()) / getrandmax() * 0.6 - 0.3;
// now calculate the delayDelta depending on the first imact's delay
$delayDelta = $wonderTypeList[$wonderID]->impactList[0][delay] * $delayRandFactor;
foreach ($wonderTypeList[$wonderID]->impactList as $impactID => $impact) {
$delay = (int) (($delayDelta + $impact[delay]) * WONDER_TIME_BASE_FACTOR);
$query = "INSERT INTO Event_wonder " . "(casterID, sourceID, targetID, wonderID, impactID, event_start, " . "event_end) " . "VALUES ('{$playerID}', '{$caveID}', '{$targetID}', '{$wonderID}', " . "'{$impactID}', NOW()+0, (NOW() + INTERVAL {$delay} SECOND)+0)";
if (!$db->query($query)) {
$db->query($setBack);
return -1;
}
}
// create messages
$sourceMessage = "Sie haben auf die Siedlung in {$coordX}/{$coordY} einen Zauber " . $wonderTypeList[$wonderID]->name . " erwirkt.";
$targetMessage = "Der Besitzer der Siedlung in {$caveData['xCoord']}/{$caveData['yCoord']} " . "hat auf Ihre Siedlung in {$coordX}/{$coordY} einen Zauber gewirkt.";
messages_sendSystemMessage($playerID, 9, "Zauber erwirkt auf {$coordX}/{$coordY}", $sourceMessage, $db);
messages_sendSystemMessage($targetData[playerID], 9, "Zauber!", $targetMessage, $db);
return 1;
}
function wonder_processTribeWonder($caveID, $wonderID, $casterTribe, $targetTribe)
{
global $db;
// check if wonder exists and is TribeWonder
if (isset($GLOBALS['wonderTypeList'][$wonderID]) || !$wonder->isTribeWonder) {
$wonder = $GLOBALS['wonderTypeList'][$wonderID];
} else {
return -33;
}
// check if tribes exist
$targetTribeData = tribe_getTribeByTag($targetTribe);
$casterTribeData = tribe_getTribeByTag($casterTribe);
if (!$targetTribeData || !$casterTribeData) {
return -15;
}
// check if tribe is valid
if (!$targetTribeData['valid']) {
return -34;
}
// check if caster tribe ist valid
if (!$casterTribeData['valid']) {
return -35;
}
$targetTribeRelations = relation_getRelationsForTribe($targetTribe);
$casterTribeRelations = relation_getRelationsForTribe($casterTribe);
$wonderPossible = false;
foreach ($wonder->targetsPossible as $targetsPossible) {
// check target
if ($targetsPossible['target'] == 'own' && strtoupper($casterTribe) != strtoupper($targetTribe)) {
continue;
}
if ($targetsPossible['target'] == 'other' && strtoupper($casterTribe) == strtoupper($targetTribe)) {
continue;
}
// check relation
$check = wonder_checkRelations($targetsPossible['relation'], $targetTribe, $casterTribe, $casterTribeRelations, $targetTribeRelations);
if ($check == true) {
$wonderPossible = true;
break;
}
}
if ($wonderPossible == false) {
return -37;
}
// take wonder Costs from TribeStorage
$memberNumber = tribe_getNumberOfMembers($casterTribe);
if (!processProductionCost($wonder, 0, NULL, $memberNumber, true)) {
return -33;
}
// does the wonder fail?
if ((double) rand() / (double) getRandMax() > $wonder->chance) {
return 11;
// wonder did fail
}
// schedule the wonder's impacts
// create a random factor between -0.3 and +0.3
$delayRandFactor = rand(0, getrandmax()) / getrandmax() * 0.6 - 0.3;
// now calculate the delayDelta depending on the first impact's delay
$delayDelta = $wonder->impactList[0]['delay'] * $delayRandFactor;
// get targets
$targets = tribe_getTribeWonderTargets($targetTribe);
if (!$targets || sizeof($targets) == 0) {
return -33;
}
$now = time();
// loop over targets
foreach ($targets as $target) {
// loop over impacts
foreach ($wonder->impactList as $impactID => $impact) {
$delay = (int) (($delayDelta + $impact['delay']) * WONDER_TIME_BASE_FACTOR);
$sql = $db->prepare("INSERT INTO " . EVENT_WONDER_TABLE . " (casterID, sourceID, targetID, \n wonderID, impactID, start, end) \n VALUES (:playerID, :caveID, :targetID, :wonderID, :impactID, :start, :end)");
$sql->bindValue('playerID', 0, PDO::PARAM_INT);
// playerID 0, for not receiving lots of wonder-end-messages
$sql->bindValue('caveID', $caveID, PDO::PARAM_INT);
$sql->bindValue('targetID', $target['caveID'], PDO::PARAM_INT);
$sql->bindValue('wonderID', $wonderID, PDO::PARAM_INT);
$sql->bindValue('impactID', $impactID, PDO::PARAM_INT);
$sql->bindValue('start', time_toDatetime($now), PDO::PARAM_STR);
$sql->bindValue('end', time_toDatetime($now + $delay), PDO::PARAM_STR);
$sql->execute();
}
// end foreach impactList
}
// end foreach target
// send caster messages
$messageClass = new Messages();
$sourceMessage = 'Sie haben auf den Stamm "' . $targetTribe . '" ein Stammeswunder ' . $wonder->name . ' erwirkt.';
$messageClass->sendSystemMessage($_SESSION['player']->playerID, 9, 'Stammeswunder erwirkt auf "' . $targetTribe . '"', $sourceMessage);
// send target messages
$targetPlayersArray = array();
foreach ($targets as $target) {
if (!isset($targetPlayersArray[$target['playerID']])) {
$targetPlayersArray[$target['playerID']] = $target;
}
}
foreach ($targetPlayersArray as $target) {
$targetMessage = 'Der Stamm "' . $casterTribe . '" hat ein Stammeswunder auf deine Höhlen gewirkt';
$messageClass->sendSystemMessage($target['playerID'], 9, 'Stammeswunder!', $targetMessage);
}
return 12;
}
public static function processWonder($wonderID, $casterTribeData, $targetTribeName)
{
global $db;
if ($wonderID < 0 || empty($casterTribeData) || empty($targetTribeName)) {
return -30;
}
// check if wonder exists and is TribeWonder
if (isset($GLOBALS['wonderTypeList'][$wonderID]) || !$wonder->isTribeWonder) {
$wonder = $GLOBALS['wonderTypeList'][$wonderID];
} else {
return -33;
}
// check if tribes exist
$targetTribeData = Tribe::getID($targetTribeName, true);
if (empty($targetTribeData)) {
return -15;
}
$casterTribeID = $casterTribeData['tribeID'];
$targetTribeID = $targetTribeData['tribeID'];
// check if tribe is valid
if (!$targetTribeData['valid']) {
return -34;
}
// check if caster tribe ist valid
if (!$casterTribeData['valid']) {
return -35;
}
$casterTribeRelations = TribeRelation::getRelations($casterTribeID);
$targetTribeRelations = TribeRelation::getRelations($targetTribeID);
$wonderPossible = false;
foreach ($wonder->targetsPossible as $targetsPossible) {
// check target
if ($targetsPossible['target'] == 'own' && $casterTribeID !== $targetTribeID) {
continue;
}
if ($targetsPossible['target'] == 'other' && $casterTribeID === $targetTribeID) {
continue;
}
// check relation
$check = self::checkRelations($targetsPossible['relation'], $targetTribeID, $casterTribeID, $casterTribeRelations, $targetTribeRelations);
if ($check == true) {
$wonderPossible = true;
break;
}
}
if ($wonderPossible == false) {
return -37;
}
// take wonder Costs from TribeStorage
$memberNumber = Tribe::getMemberCount($casterTribeID);
if (!processProductionCost($wonder, 0, NULL, $memberNumber, true)) {
return -33;
}
// does the wonder fail?
if ((double) rand() / (double) getRandMax() > $wonder->chance) {
return 11;
// wonder did fail
}
// schedule the wonder's impacts
// create a random factor between -0.3 and +0.3
$delayRandFactor = rand(0, getrandmax()) / getrandmax() * 0.6 - 0.3;
// now calculate the delayDelta depending on the first impact's delay
$delayDelta = $wonder->impactList[0]['delay'] * $delayRandFactor;
// get targets
$targets = Tribe::getPlayerList($targetTribeID, false, true);
if (sizeof($targets) == 0) {
return -33;
}
$now = time();
// loop over targets
foreach ($targets as $playerID => $playerData) {
foreach ($playerData['caves'] as $caveID => $caveData) {
// loop over impacts
foreach ($wonder->impactList as $impactID => $impact) {
$delay = (int) (($delayDelta + $impact['delay']) * WONDER_TIME_BASE_FACTOR);
$sql = $db->prepare("INSERT INTO " . EVENT_WONDER_TABLE . "\n (casterID, sourceID, targetID, wonderID, impactID, start, end)\n VALUES\n (:playerID, :caveID, :targetID, :wonderID, :impactID, :start, :end)");
$sql->bindValue('playerID', 0, PDO::PARAM_INT);
// playerID 0, for not receiving lots of wonder-end-messages
$sql->bindValue('caveID', $casterTribeID, PDO::PARAM_INT);
$sql->bindValue('targetID', $caveID, PDO::PARAM_INT);
$sql->bindValue('wonderID', $wonderID, PDO::PARAM_INT);
$sql->bindValue('impactID', $impactID, PDO::PARAM_INT);
$sql->bindValue('start', time_toDatetime($now), PDO::PARAM_STR);
$sql->bindValue('end', time_toDatetime($now + $delay), PDO::PARAM_STR);
$sql->execute();
}
// end foreach impactList
}
}
// end foreach target
// send caster messages
$messageClass = new Messages();
$messageClass->sendSystemMessage($_SESSION['player']->playerID, 9, sprintf(_("Stammeswunder erwirkt auf %s"), $targetTribeData['tag']), sprintf(_("Sie haben auf den Stamm %s ein Stammeswunder %s erwirkt."), $targetTribeData['tag'], $wonder->name));
// send target messages
$targetPlayersArray = array();
foreach ($targets as $target) {
if (!isset($targetPlayersArray[$target['playerID']])) {
$targetPlayersArray[$target['playerID']] = $target;
}
}
foreach ($targetPlayersArray as $target) {
$messageClass->sendSystemMessage($target['playerID'], 9, 'Stammeswunder!', sprintf(_("Der Stamm %s hat ein Stammeswunder auf deine Höhlen gewirkt."), $casterTribeData['tag']));
}
return 12;
}
function wonder_processOrder($playerID, $wonderID, $caveID, $coordX, $coordY, $caveData, $db)
{
global $defenseSystemTypeList, $unitTypeList, $buildingTypeList, $scienceTypeList, $resourceTypeList, $wonderTypeList, $WONDERRESISTANCE;
if ($wonderTypeList[$wonderID]->target == "same") {
$targetID = $caveID;
$query = "SELECT * FROM Cave " . "WHERE caveID = '{$targetID}' ";
if (!($result = $db->query($query)) || !($targetData = $result->nextRow())) {
return -3;
}
$coordX = $targetData['xCoord'];
$coordY = $targetData['yCoord'];
} else {
// check the target cave
$query = "SELECT * FROM Cave " . "WHERE xCoord = '{$coordX}' " . "AND yCoord = '{$coordY}'";
if (!($result = $db->query($query)) || !($targetData = $result->nextRow())) {
return -3;
}
$targetID = $targetData['caveID'];
}
// check, if cave allowed
if ($wonderTypeList[$wonderID]->target == "own") {
$allowed = $playerID == $targetData['playerID'];
} else {
if ($wonderTypeList[$wonderID]->target == "other") {
$allowed = $playerID != $targetData['playerID'];
} else {
// $wonderTypeList[$wonderID]->target == "all" or == "same"
$allowed = 1;
}
}
if (!$allowed) {
return -2;
}
$set = array();
$setBack = array();
$where = array("WHERE caveID = '{$caveID}' ");
// get all the resource costs
foreach ($wonderTypeList[$wonderID]->resourceProductionCost as $key => $value) {
if ($value != "" && $value != "0") {
$formula = formula_parseToSQL($value);
$dbField = $resourceTypeList[$key]->dbFieldName;
array_push($set, "{$dbField} = {$dbField} - ({$formula})");
array_push($setBack, "{$dbField} = {$dbField} + ({$formula})");
array_push($where, "{$dbField} >= ({$formula})");
}
}
// get all the unit costs
foreach ($wonderTypeList[$wonderID]->unitProductionCost as $key => $value) {
if ($value != "" && $value != "0") {
$formula = formula_parseToSQL($value);
$dbField = $unitTypeList[$key]->dbFieldName;
array_push($set, "{$dbField} = {$dbField} - {$formula}");
array_push($setBack, "{$dbField} = {$dbField} + {$formula}");
array_push($where, "{$dbField} >= {$formula}");
}
}
foreach ($wonderTypeList[$wonderID]->buildingProductionCost as $key => $value) {
if ($value != "" && $value != "0") {
$formula = formula_parseToSQL($value);
$dbField = $buildingTypeList[$key]->dbFieldName;
array_push($set, "{$dbField} = {$dbField} - {$formula}");
array_push($setBack, "{$dbField} = {$dbField} + {$formula}");
array_push($where, "{$dbField} >= {$formula}");
}
}
// generate SQL
if (sizeof($set)) {
$set = implode(", ", $set);
$set = "UPDATE Cave SET {$set} ";
$setBack = implode(", ", $setBack);
$setBack = "UPDATE Cave SET {$setBack} WHERE caveID = '{$caveID}'";
}
// generate dependecies
foreach ($wonderTypeList[$wonderID]->buildingDepList as $key => $value) {
if ($value != "" && $value != "0") {
array_push($where, "{$buildingTypeList[$key]->dbFieldName} >= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->maxBuildingDepList as $key => $value) {
if ($value != -1) {
array_push($where, "{$wonderTypeList[$key]->dbFieldName} <= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->defenseSystemDepList as $key => $value) {
if ($value != "" && $value != "0") {
array_push($where, "{$defenseSystemTypeList[$key]->dbFieldName} >= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->maxDefenseSystemDepList as $key => $value) {
if ($value != -1) {
array_push($where, "{$defenseSystemTypeList[$key]->dbFieldName} <= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->resourceDepList as $key => $value) {
if ($value != "" && $value != "0") {
array_push($where, "{$resourceTypeList[$key]->dbFieldName} >= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->maxResourceDepList as $key => $value) {
if ($value != -1) {
array_push($where, "{$resourceTypeList[$key]->dbFieldName} <= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->scienceDepList as $key => $value) {
if ($value != "" && $value != "0") {
array_push($where, "{$scienceTypeList[$key]->dbFieldName} >= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->maxScienceDepList as $key => $value) {
if ($value != -1) {
array_push($where, "{$scienceTypeList[$key]->dbFieldName} <= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->unitDepList as $key => $value) {
if ($value != "" && $value != "0") {
array_push($where, "{$unitTypeList[$key]->dbFieldName} >= {$value}");
}
}
foreach ($wonderTypeList[$wonderID]->maxUnitDepList as $key => $value) {
if ($value != -1) {
array_push($where, "{$unitTypeList[$key]->dbFieldName} <= {$value}");
}
}
$where = implode(" AND ", $where);
if (!$db->query($set . $where) || $db->affected_rows() != 1) {
return 0;
}
// calculate the chance and evaluate into $chance
if ($chance_formula = $wonderTypeList[$wonderID]->chance) {
$chance_eval_formula = formula_parseToPHP($chance_formula, '$caveData');
$chance_eval_formula = "\$chance={$chance_eval_formula};";
eval($chance_eval_formula);
}
// if this wonder is offensive
// calculate the wonder resistance and evaluate into $resistance
// TODO: Wertebereich der Resistenz ist derzeit 0 - 1, also je höher desto resistenter
if ($wonderTypeList[$wonderID]->offensiveness == "offensive") {
$resistance_eval_formula = formula_parseToPHP($WONDERRESISTANCE, '$targetData');
$resistance_eval_formula = "\$resistance={$resistance_eval_formula};";
eval($resistance_eval_formula);
} else {
$resistance = 0.0;
}
// does the wonder fail?
if ((double) rand() / (double) getRandMax() > $chance - $resistance) {
return 2;
// wonder did fail
}
// schedule the wonder's impacts
// create a random factor between -0.3 and +0.3
$delayRandFactor = rand(0, getrandmax()) / getrandmax() * 0.6 - 0.3;
// now calculate the delayDelta depending on the first impact's delay
$delayDelta = $wonderTypeList[$wonderID]->impactList[0]['delay'] * $delayRandFactor;
foreach ($wonderTypeList[$wonderID]->impactList as $impactID => $impact) {
$delay = (int) (($delayDelta + $impact['delay']) * WONDER_TIME_BASE_FACTOR);
$now = time();
$query = sprintf("INSERT INTO Event_wonder (casterID, sourceID, targetID, " . "wonderID, impactID, `start`, `end`) " . "VALUES (%d, %d, %d, %d, %d, '%s', '%s')", $playerID, $caveID, $targetID, $wonderID, $impactID, time_toDatetime($now), time_toDatetime($now + $delay));
if (!$db->query($query)) {
$db->query($setBack);
return -1;
}
}
// create messages
$sourceMessage = "Sie haben auf die Höhle in {$coordX}/{$coordY} ein Wunder " . $wonderTypeList[$wonderID]->name . " erwirkt.";
$targetMessage = "Der Besitzer der Höhle in {$caveData['xCoord']}/{$caveData['yCoord']} " . "hat auf Ihre Höhle in {$coordX}/{$coordY} ein Wunder gewirkt.";
messages_sendSystemMessage($playerID, 9, "Wunder erwirkt auf {$coordX}/{$coordY}", $sourceMessage, $db);
messages_sendSystemMessage($targetData['playerID'], 9, "Wunder!", $targetMessage, $db);
return 1;
}
function wonder_processOrder($playerID, $wonderID, $caveID, $coordX, $coordY, $caveData)
{
global $db;
if ($GLOBALS['wonderTypeList'][$wonderID]->target == "same") {
$targetID = $caveID;
$sql = $db->prepare("SELECT * FROM " . CAVE_TABLE . " \n WHERE caveID = :targetID");
$sql->bindValue('targetID', $targetID);
if (!$sql->execute() || !($targetData = $sql->fetch(PDO::FETCH_ASSOC))) {
return -3;
}
$sql->closeCursor();
$coordX = $targetData['xCoord'];
$coordY = $targetData['yCoord'];
} else {
// check the target cave
$sql = $db->prepare("SELECT * FROM " . CAVE_TABLE . " \n WHERE xCoord = :coordX\n AND yCoord = :coordY");
$sql->bindValue('coordX', $coordX, PDO::PARAM_INT);
$sql->bindValue('coordY', $coordY, PDO::PARAM_INT);
if (!$sql->execute() || !($targetData = $sql->fetch(PDO::FETCH_ASSOC))) {
return -3;
}
$sql->closeCursor();
$targetID = $targetData['caveID'];
}
// check, if cave allowed
if ($GLOBALS['wonderTypeList'][$wonderID]->target == "own") {
$allowed = $playerID == $targetData['playerID'];
} else {
if ($GLOBALS['wonderTypeList'][$wonderID]->target == "other") {
$allowed = $playerID != $targetData['playerID'];
} else {
// $wonderTypeList[$wonderID]->target == "all" or == "same"
$allowed = 1;
}
}
if (!$allowed) {
return -2;
}
// take production costs from cave
if (!processProductionCost($GLOBALS['wonderTypeList'][$wonderID], $caveID, $caveData)) {
return 0;
}
// calculate the chance and evaluate into $chance
if ($chance_formula = $GLOBALS['wonderTypeList'][$wonderID]->chance) {
$chance_eval_formula = formula_parseToPHP($chance_formula, '$caveData');
$chance_eval_formula = "\$chance={$chance_eval_formula};";
eval($chance_eval_formula);
}
// if this wonder is offensive
// calculate the wonder resistance and evaluate into $resistance
// TODO: Wertebereich der Resistenz ist derzeit 0 - 1, also je höher desto resistenter
if ($GLOBALS['wonderTypeList'][$wonderID]->offensiveness == "offensive") {
$resistance_eval_formula = formula_parseToPHP(GameConstants::WONDER_RESISTANCE, '$targetData');
$resistance_eval_formula = "\$resistance={$resistance_eval_formula};";
eval($resistance_eval_formula);
} else {
$resistance = 0.0;
}
// does the wonder fail?
if ((double) rand() / (double) getRandMax() > $chance - $resistance) {
return 2;
// wonder did fail
}
// schedule the wonder's impacts
// create a random factor between -0.3 and +0.3
$delayRandFactor = rand(0, getrandmax()) / getrandmax() * 0.6 - 0.3;
// now calculate the delayDelta depending on the first impact's delay
$delayDelta = $GLOBALS['wonderTypeList'][$wonderID]->impactList[0]['delay'] * $delayRandFactor;
foreach ($GLOBALS['wonderTypeList'][$wonderID]->impactList as $impactID => $impact) {
$delay = (int) (($delayDelta + $impact['delay']) * WONDER_TIME_BASE_FACTOR);
$now = time();
$sql = $db->prepare("INSERT INTO " . EVENT_WONDER_TABLE . " (casterID, sourceID, targetID, \n wonderID, impactID, start, end) \n VALUES (:playerID, :caveID, :targetID, :wonderID, :impactID, :start, :end)");
$sql->bindValue('playerID', $playerID, PDO::PARAM_INT);
$sql->bindValue('caveID', $caveID, PDO::PARAM_INT);
$sql->bindValue('targetID', $targetID, PDO::PARAM_INT);
$sql->bindValue('wonderID', $wonderID, PDO::PARAM_INT);
$sql->bindValue('impactID', $impactID, PDO::PARAM_INT);
$sql->bindValue('start', time_toDatetime($now), PDO::PARAM_STR);
$sql->bindValue('end', time_toDatetime($now + $delay), PDO::PARAM_STR);
if (!$sql->execute()) {
//give production costs back
processProductionCostSetBack($GLOBALS['wonderTypeList'][$wonderID], $caveID, $caveData);
return -1;
}
}
// create messages
$messageClass = new Messages();
$sourceMessage = 'Sie haben auf die Höhle in ' . $coordX . '/' . $coordY . ' ein Wunder ' . $GLOBALS['wonderTypeList'][$wonderID]->name . ' erwirkt.';
$targetMessage = 'Der Besitzer der Höhle in ' . $caveData['xCoord'] . '/' . $caveData['yCoord'] . ' hat auf Ihre Höhle in ' . $coordX . '/' . $coordY . ' ein Wunder gewirkt.';
// create xml message
$casterxml = new SimpleXMLElement('<?xml version=\'1.0\' encoding=\'utf-8\'?><wonderMessageCaster></wonderMessageCaster>');
$casterxml->addChild('timestamp', time());
$casterxml->addChild('wonderType', 'caster');
$casterxml->addChild('source');
$casterxml->source->addChild('xCoord', $caveData['xCoord']);
$casterxml->source->addChild('yCoord', $caveData['yCoord']);
$casterxml->source->addChild('caveName', $caveData['name']);
$casterxml->addChild('target');
$casterxml->target->addChild('xCoord', $targetData['xCoord']);
$casterxml->target->addChild('yCoord', $targetData['yCoord']);
$casterxml->target->addChild('caveName', $targetData['name']);
$casterxml->addChild('wonderName', $GLOBALS['wonderTypeList'][$wonderID]->name);
$targetxml = new SimpleXMLElement('<?xml version=\'1.0\' encoding=\'utf-8\'?><wonderMessageTarget></wonderMessageTarget>');
$targetxml->addChild('timestamp', time());
$targetxml->addChild('wonderType', 'target');
$targetxml->addChild('source');
$targetxml->source->addChild('xCoord', $caveData['xCoord']);
$targetxml->source->addChild('yCoord', $caveData['yCoord']);
$targetxml->source->addChild('caveName', $caveData['name']);
$targetxml->addChild('target');
$targetxml->target->addChild('xCoord', $targetData['xCoord']);
$targetxml->target->addChild('yCoord', $targetData['yCoord']);
$targetxml->target->addChild('caveName', $targetData['name']);
$messageClass->sendSystemMessage($playerID, 9, 'Wunder erwirkt auf ' . $coordX . '/' . $coordY, $sourceMessage, $casterxml->asXML());
$messageClass->sendSystemMessage($targetData['playerID'], 9, 'Wunder!', $targetMessage, $targetxml->asXML());
return 1;
}
function setMovementEvent($caveID, $caveData, $targetX, $targetY, $unit, $resource, $movementID, $reqFood, $absDuration, $artefactID, $heroID, $caveSpeedFactor)
{
global $db;
// ziel-hoehlenID holen
$sql = $db->prepare("SELECT caveID FROM " . CAVE_TABLE . " \n WHERE xCoord = :targetX AND yCoord = :targetY");
$sql->bindValue('targetX', $targetX, PDO::PARAM_INT);
$sql->bindVAlue('targetY', $targetY, PDO::PARAM_INT);
if ($sql->rowCountSelect() != 1) {
return 1;
}
if (!$sql->execute()) {
return 1;
}
$row = $sql->fetch();
$sql->closeCursor();
$targetCaveID = $row['caveID'];
// updates fuer cave basteln
$update = "UPDATE " . CAVE_TABLE . " ";
$updateRollback = "UPDATE " . CAVE_TABLE . " ";
$where = "WHERE caveID = {$caveID} ";
$whereRollback = "WHERE caveID = {$caveID} ";
$set = $setRollback = array();
foreach ($unit as $unitID => $value) {
if (!empty($value)) {
$set[] = $GLOBALS['unitTypeList'][$unitID]->dbFieldName . " = " . $GLOBALS['unitTypeList'][$unitID]->dbFieldName . " - {$value} ";
$setRollback[] = $GLOBALS['unitTypeList'][$unitID]->dbFieldName . " = " . $GLOBALS['unitTypeList'][$unitID]->dbFieldName . " + {$value} ";
$where .= "AND " . $GLOBALS['unitTypeList'][$unitID]->dbFieldName . " >= {$value} ";
$where .= "AND {$value} >= 0 ";
// check for values bigger 0!
}
}
foreach ($resource as $resourceID => $value) {
$value_to_check = $value;
if ($resourceID == GameConstants::FUEL_RESOURCE_ID) {
$value += $reqFood;
}
if (!empty($value) || !empty($value_to_check)) {
$set[] = $GLOBALS['resourceTypeList'][$resourceID]->dbFieldName . " = " . $GLOBALS['resourceTypeList'][$resourceID]->dbFieldName . " - {$value} ";
$setRollback[] = $GLOBALS['resourceTypeList'][$resourceID]->dbFieldName . " = " . $GLOBALS['resourceTypeList'][$resourceID]->dbFieldName . " + {$value} ";
$where .= "AND " . $GLOBALS['resourceTypeList'][$resourceID]->dbFieldName . " >= {$value} ";
if (!empty($value_to_check)) {
$where .= "AND {$value_to_check} >= 0 ";
}
}
}
$update = $update . "SET " . implode(", ", $set) . $where;
$updateRollback = $updateRollback . "SET " . implode(", ", $setRollback) . $whereRollback;
if (!$db->exec($update)) {
return 2;
}
// remove the artefact if any
if ($artefactID > 0) {
// TODO: what should happen, if the first succedes but one of the other fails afterwards
if (!artefact_removeEffectsFromCave($artefactID)) {
$db->query($updateRollback);
return 3;
}
if (!artefact_uninitiateArtefact($artefactID)) {
$db->query($updateRollback);
return 3;
}
if (!artefact_removeArtefactFromCave($artefactID)) {
$db->query($updateRollback);
return 3;
}
}
// remove hero if any
if ($heroID > 0) {
if (!hero_removeHeroFromCave($heroID)) {
return 3;
}
}
// insert fuer movement_event basteln
$now = time();
$insert = "INSERT INTO " . EVENT_MOVEMENT_TABLE . " (caveID, source_caveID, target_caveID, movementID, `start`, `end`, artefactID, heroID, speedFactor, exposeChance, ";
$i = 0;
foreach ($unit as $uID => $val) {
if (!empty($val)) {
if ($i++ != 0) {
$insert .= " , ";
}
$insert .= $GLOBALS['unitTypeList'][$uID]->dbFieldName;
}
}
foreach ($resource as $rID => $val) {
if (!empty($val)) {
$insert .= " , " . $GLOBALS['resourceTypeList'][$rID]->dbFieldName;
}
}
$speedFactor = getMaxSpeedFactor($unit) * $caveSpeedFactor;
// determine expose chance
$exposeChance = (double) rand() / (double) getRandMax();
$insert .= sprintf(" ) VALUES (%d, %d, %d, %d, " . "'%s', '%s', %d, %d, %f, %f, ", $caveID, $caveID, $targetCaveID, $movementID, time_toDatetime($now), time_toDatetime($now + $absDuration * 60), $artefactID, $heroID, $speedFactor, $exposeChance);
$i = 0;
foreach ($unit as $val) {
if (!empty($val)) {
if ($i++ != 0) {
$insert .= " , ";
}
$insert .= $val;
}
}
foreach ($resource as $val) {
if (!empty($val)) {
$insert .= " , " . $val;
}
}
$insert .= " )";
if (!$db->exec($insert)) {
// update rueckgaengig machen
$db->query($updateRollback);
return 3;
}
return 0;
}
exit;
}
$maxX = $row[maxX];
$maxY = $row[maxY];
$minX = $row[minX];
$minY = $row[minY];
echo "Map size: {$minX} -> {$maxX} x {$minY} -> {$maxY}\n";
for ($i = 0; $i < $number; $i++) {
do {
// look randomly for an existing cave
srand((double) microtime() * 1000000);
// chris---: php compability, 28.7.2004
$x = (int) (rand() / (double) getRandMax() * ($maxX - $minX)) + $minX;
srand((double) microtime() * 1000000);
// chris---: php compability, 28.7.2004
$y = (int) (rand() / (double) getRandMax() * ($maxY - $minY)) + $minY;
$query = "SELECT caveID " . "FROM Cave " . "WHERE xCoord = {$x} AND yCoord = {$y} AND playerID = 0 AND quest_cave = 0 AND starting_position = 0";
// ADDED by chris for quests, 2.8.2004
} while (!($result = $db->query($query)) || !($row = $result->nextRow()));
$caveID = $row[caveID];
$query = "INSERT INTO Artefact (artefactClassID, caveID) " . "values ({$artefactClassID}, {$caveID})";
if (!$db->query($query)) {
echo "Couldn't create Artefact!\n";
exit(1);
}
$query = "UPDATE Cave SET artefacts=artefacts+1 " . "WHERE caveID = {$caveID}";
if (!$db->query($query)) {
echo "Couldn't place Artefact into cave {$caveID}!\n";
echo $query . "\n";
exit(1);
}
<?php
require_once 'vendor/autoload.php';
$chartData = [];
$offset = 100 * (rand() / getRandMax()) ** 4;
$scale = 100 * (rand() / getRandMax()) ** 2;
$volatility = 0.5 * (rand() / getRandMax()) ** 3;
for ($n = 0, $current = $offset + 0.5 * $scale; $n < 24; $n++) {
$current -= $offset;
$current *= 1 + $volatility * (rand() / getRandMax() - 0.5);
$current += $offset;
$chartData[$n] = $current;
}
$chart = new NeatCharts\LineChart($chartData, ['width' => 500, 'height' => 400, 'lineColor' => '#00F', 'labelColor' => '#222', 'smoothed' => false, 'fontSize' => 14]);
header('Content-type: image/svg+xml; charset=utf-8');
echo '<?xml version="1.0" standalone="no"?>' . PHP_EOL;
echo $chart->render();
