Support for the Jump Fleet.

denizuga · Jul 9th 2024, 10:58am

Hello,
Unfortunately, the code I use to teleport fleets from one planet to another isn't working as expected. Everything seems to be running without errors, but instead of teleporting, the ships from the current planet are being deleted and not transferred to the destination planet. Your assistance in resolving this would be greatly appreciated.

Best regards,

2MOON 2.0
PHP : 7.2.34

PHP Source Code

<?php
class ShowJumpFleetPage extends AbstractGamePage {
public static $requireModule = 0;
function __construct() {
parent::__construct();
}
function show() {
global $CONF, $LNG, $PLANET, $USER, $resource, $UNI;
$db = Database::get();
$act = HTTP::_GP('act', '');
$transCoasts = 2000;
if ($act == "take") {
if (!isset($_POST['check_planet']) && !isset($_POST['check_moons']))
$this->redirectTo('game.php?page=harvest');
if($transCoasts > $USER['darkmatter']){$this->printMessage($LNG['error_3'], true, array('game.php?page=JumpFleet', 4));}
else
$USER['darkmatter'] -= $transCoasts;
if(!isset($_POST['check_planet']))
$_POST['check_planet'] = array();
foreach($_POST['check_planet'] as $ID => $Value) {
$sur = $db->uniquequery("SELECT small_ship_cargo, big_ship_cargo, light_hunter, heavy_hunter, crusher, battle_ship, colonizer, recycler, spy_sonde, bomber_ship, destructor, dearth_star, battleship, lune_noir, ev_transporter, star_crasher, giga_recykler, dm_ship FROM %%PLANETS%% where `id` = '".$Value."';");
$db->multi_query("LOCK TABLE %%PLANETS%% WRITE; UPDATE %%PLANETS%% SET `small_ship_cargo` = small_ship_cargo - ".$sur['small_ship_cargo'].", `big_ship_cargo` = big_ship_cargo - ".$sur['big_ship_cargo'].", `light_hunter` = light_hunter - ".$sur['light_hunter'].", `heavy_hunter` = heavy_hunter - ".$sur['heavy_hunter'].", `crusher` = crusher - ".$sur['crusher'].", `battle_ship` = battle_ship - ".$sur['battle_ship'].", `colonizer` = colonizer - ".$sur['colonizer'].", `recycler` = recycler - ".$sur['recycler'].", `spy_sonde` = spy_sonde - ".$sur['spy_sonde'].", `bomber_ship` = bomber_ship - ".$sur['bomber_ship'].", `destructor` = destructor - ".$sur['destructor'].", `dearth_star` = dearth_star - ".$sur['dearth_star'].", `battleship` = battleship - ".$sur['battleship'].", `lune_noir` = lune_noir - ".$sur['lune_noir'].", `ev_transporter` = ev_transporter - ".$sur['ev_transporter'].", `star_crasher` = star_crasher - ".$sur['star_crasher'].", `giga_recykler` = giga_recykler - ".$sur['giga_recykler'].", `dm_ship` = dm_ship - ".$sur['dm_ship']." WHERE `id` = '".$Value."'; UNLOCK TABLES;");
$PLANET['small_ship_cargo'] += $sur['small_ship_cargo'];
$PLANET['big_ship_cargo'] += $sur['big_ship_cargo'];
$PLANET['light_hunter'] += $sur['light_hunter'];
$PLANET['heavy_hunter'] += $sur['heavy_hunter'];
$PLANET['crusher'] += $sur['crusher'];
$PLANET['battle_ship'] += $sur['battle_ship'];
$PLANET['colonizer'] += $sur['colonizer'];
$PLANET['recycler'] += $sur['recycler'];
$PLANET['dearth_star'] += $sur['dearth_star'];
$PLANET['battleship'] += $sur['battleship'];
$PLANET['lune_noir'] += $sur['lune_noir'];
$PLANET['ev_transporter'] += $sur['ev_transporter'];
$PLANET['star_crasher'] += $sur['star_crasher'];
$PLANET['giga_recykler'] += $sur['giga_recykler'];
$PLANET['dm_ship'] += $sur['dm_ship'];
}
if(!isset($_POST['check_moons']))
$_POST['check_moons'] = array();
foreach($_POST['check_moons'] as $ID => $Value) {
$sur = $db->uniquequery("SELECT small_ship_cargo, big_ship_cargo, light_hunter, heavy_hunter, crusher, battle_ship, colonizer, recycler, spy_sonde, bomber_ship, destructor, dearth_star, battleship, lune_noir, ev_transporter, star_crasher, giga_recykler, dm_ship FROM %%PLANETS%% where `id` = '".$Value."';");
$db->multi_query("LOCK TABLE %%PLANETS%% WRITE; UPDATE %%PLANETS%% SET `small_ship_cargo` = small_ship_cargo - ".$sur['small_ship_cargo'].", `big_ship_cargo` = big_ship_cargo - ".$sur['big_ship_cargo'].", `light_hunter` = light_hunter - ".$sur['light_hunter'].", `heavy_hunter` = heavy_hunter - ".$sur['heavy_hunter'].", `crusher` = crusher - ".$sur['crusher'].", `battle_ship` = battle_ship - ".$sur['battle_ship'].", `colonizer` = colonizer - ".$sur['colonizer'].", `recycler` = recycler - ".$sur['recycler'].", `spy_sonde` = spy_sonde - ".$sur['spy_sonde'].", `bomber_ship` = bomber_ship - ".$sur['bomber_ship'].", `destructor` = destructor - ".$sur['destructor'].", `dearth_star` = dearth_star - ".$sur['dearth_star'].", `battleship` = battleship - ".$sur['battleship'].", `lune_noir` = lune_noir - ".$sur['lune_noir'].", `ev_transporter` = ev_transporter - ".$sur['ev_transporter'].", `star_crasher` = star_crasher - ".$sur['star_crasher'].", `giga_recykler` = giga_recykler - ".$sur['giga_recykler'].", `dm_ship` = dm_ship - ".$sur['dm_ship']." WHERE `id` = '".$Value."'; UNLOCK TABLES;");
$PLANET['small_ship_cargo'] += $sur['small_ship_cargo'];
$PLANET['big_ship_cargo'] += $sur['big_ship_cargo'];
$PLANET['light_hunter'] += $sur['light_hunter'];
$PLANET['heavy_hunter'] += $sur['heavy_hunter'];
$PLANET['crusher'] += $sur['crusher'];
$PLANET['battle_ship'] += $sur['battle_ship'];
$PLANET['colonizer'] += $sur['colonizer'];
$PLANET['recycler'] += $sur['recycler'];
$PLANET['dearth_star'] += $sur['dearth_star'];
$PLANET['battleship'] += $sur['battleship'];
$PLANET['lune_noir'] += $sur['lune_noir'];
$PLANET['ev_transporter'] += $sur['ev_transporter'];
$PLANET['star_crasher'] += $sur['star_crasher'];
$PLANET['giga_recykler'] += $sur['giga_recykler'];
$PLANET['dm_ship'] += $sur['dm_ship'];
}
$this->printMessage($LNG['h_ok'], true, array('game.php?page=JumpFleet', 4));
} else {
$Planets = array();
$Moons = array();
if (isset($USER['PLANETS'])) {
$USER['PLANETS'] = getPlanets($USER);
}
foreach($USER['PLANETS'] as $ID => $PlanetQuery) {
if ($ID == $PLANET['id']) continue;
if ($PlanetQuery['planet_type'] == 3) {
$Moons[$PlanetQuery['id']] = $PlanetQuery['name'] . " [" . $PlanetQuery['galaxy'] . ":" . $PlanetQuery['system'] . ":" . $PlanetQuery['planet'] . "]";
} elseif ($PlanetQuery['planet_type'] == 1) {
$Planets[$PlanetQuery['id']] = $PlanetQuery['name'] . " [".$PlanetQuery['galaxy'] . ":" . $PlanetQuery['system'] . ":" . $PlanetQuery['planet'] . "]";
}
}
// $this->tplObj->loadscript("jquery.countdown.js");
$this->tplObj->assign_vars(array(
'PlanetsList' => $Planets,
'MoonsList' => $Moons,
));
$this->display('page.JumpFleet.default.tpl');
}
}
}
?>

Display All

Zuno · Jul 10th 2024, 4:07am

Try to use code from Jump Gate.

PHP Source Code

public function sendFleet()
{
global $PLANET, $USER, $resource, $LNG, $reslist;
$db = Database::get();
$NextJumpTime = self::getNextJumpWaitTime($PLANET['last_jump_time']);
if (TIMESTAMP < $NextJumpTime)
{
$this->sendJSON(array(
'message' => $LNG['in_jump_gate_already_used'].' '.pretty_time($NextJumpTime - TIMESTAMP),
'error' => true
));
}
$TargetPlanet = HTTP::_GP('jmpto', (int) $PLANET['id']);
$sql = "SELECT id, last_jump_time FROM %%PLANETS%% WHERE id = :targetID AND id_owner = :userID AND sprungtor > 0;";
$TargetGate = $db->selectSingle($sql, array(
':targetID' => $TargetPlanet,
':userID' => $USER['id']
));
if (!isset($TargetGate) || $TargetPlanet == $PLANET['id'])
{
$this->sendJSON(array(
'message' => $LNG['in_jump_gate_doesnt_have_one'],
'error' => true
));
}
$NextJumpTime = self::getNextJumpWaitTime($TargetGate['last_jump_time']);
if (TIMESTAMP < $NextJumpTime)
{
$this->sendJSON(array(
'message' => $LNG['in_jump_gate_not_ready_target'].' '.pretty_time($NextJumpTime - TIMESTAMP),
'error' => true
));
}
$ShipArray = array();
$SubQueryOri = "";
$SubQueryDes = "";
$Ships = HTTP::_GP('ship', array());
foreach($reslist['fleet'] as $Ship)
{
if(!isset($Ships[$Ship]) || $Ship == 212)
continue;
$ShipArray[$Ship] = max(0, min($Ships[$Ship], $PLANET[$resource[$Ship]]));
if(empty($ShipArray[$Ship]))
continue;
$SubQueryOri .= $resource[$Ship]." = ".$resource[$Ship]." - ".$ShipArray[$Ship].", ";
$SubQueryDes .= $resource[$Ship]." = ".$resource[$Ship]." + ".$ShipArray[$Ship].", ";
$PLANET[$resource[$Ship]] -= $ShipArray[$Ship];
}
if (empty($SubQueryOri))
{
$this->sendJSON(array(
'message' => $LNG['in_jump_gate_error_data'],
'error' => true
));
}
$array_merge = array(':planetID' => $PLANET['id'],':jumptime' => TIMESTAMP);
$sql = "UPDATE %%PLANETS%% SET ".$SubQueryOri." `last_jump_time` = :jumptime WHERE id = :planetID;";
$db->update($sql,$array_merge);
$sql = "UPDATE %%PLANETS%% SET ".$SubQueryDes." `last_jump_time` = :jumptime WHERE id = :targetID;";
$db->update($sql, array(
':targetID' => $TargetPlanet,
':jumptime' => TIMESTAMP,
));
$PLANET['last_jump_time'] = TIMESTAMP;
$NextJumpTime = self::getNextJumpWaitTime($PLANET['last_jump_time']);
$this->sendJSON(array(
'message' => sprintf($LNG['in_jump_gate_done'], pretty_time($NextJumpTime - TIMESTAMP)),
'error' => false
));
}

Display All

Regards.

denizuga · Jul 10th 2024, 10:27am

How can I integrate ?

denizuga · Jul 10th 2024, 10:49am

*The code works perfectly. now with 2moon 2.0, it is possible to do Fleet teleportation in exchange for Dark matter.

ShowJumpFleetPage.class.php

PHP Source Code

<?php
class ShowJumpFleetPage extends AbstractGamePage {
public static $requireModule = 0;
function __construct() {
parent::__construct();
}
function show() {
global $CONF, $LNG, $PLANET, $USER, $resource, $UNI;
$db = Database::get();
$act = HTTP::_GP('act', '');
$transCoasts = 2000;
if ($act == "take") {
if (!isset($_POST['check_planet']) && !isset($_POST['check_moons'])) {
$this->redirectTo('game.php?page=harvest');
}
if ($transCoasts > $USER['darkmatter']) {
$this->printMessage($LNG['error_3'], true, array('game.php?page=JumpFleet', 4));
} else {
$USER['darkmatter'] -= $transCoasts;
}
if (!isset($_POST['check_planet'])) {
$_POST['check_planet'] = array();
}
foreach ($_POST['check_planet'] as $ID => $Value) {
$sur = $db->selectSingle("SELECT * FROM %%PLANETS%% WHERE `id` = :planetID;", array(':planetID' => $Value));
if (!$sur) {
$this->sendJSON(array(
'message' => $LNG['error_invalid_coordinates'],
'error' => true
));
return;
}
$ShipArray = array();
$SubQueryOri = "";
$SubQueryDes = "";
$reslist = $GLOBALS['reslist'];
foreach ($reslist['fleet'] as $Ship) {
if (!isset($sur[$resource[$Ship]]) || $Ship == 212) {
continue;
}
$ShipArray[$Ship] = max(0, $sur[$resource[$Ship]]);
if (empty($ShipArray[$Ship])) {
continue;
}
$SubQueryOri .= $resource[$Ship] . " = " . $resource[$Ship] . " - " . $ShipArray[$Ship] . ", ";
$SubQueryDes .= $resource[$Ship] . " = " . $resource[$Ship] . " + " . $ShipArray[$Ship] . ", ";
$PLANET[$resource[$Ship]] += $ShipArray[$Ship];
}
if (empty($SubQueryOri)) {
$this->sendJSON(array(
'message' => $LNG['in_jump_gate_error_data'],
'error' => true
));
return;
}
$SubQueryOri = rtrim($SubQueryOri, ', ');
$SubQueryDes = rtrim($SubQueryDes, ', ');
$sql = "UPDATE %%PLANETS%% SET $SubQueryOri WHERE id = :planetID;";
$db->update($sql, array(':planetID' => $Value));
$sql = "UPDATE %%PLANETS%% SET $SubQueryDes WHERE id = :targetID;";
$db->update($sql, array(':targetID' => $PLANET['id']));
}
if (!isset($_POST['check_moons'])) {
$_POST['check_moons'] = array();
}
foreach ($_POST['check_moons'] as $ID => $Value) {
$sur = $db->selectSingle("SELECT * FROM %%PLANETS%% WHERE `id` = :planetID;", array(':planetID' => $Value));
if (!$sur) {
$this->sendJSON(array(
'message' => $LNG['error_invalid_coordinates'],
'error' => true
));
return;
}
$ShipArray = array();
$SubQueryOri = "";
$SubQueryDes = "";
$reslist = $GLOBALS['reslist'];
foreach ($reslist['fleet'] as $Ship) {
if (!isset($sur[$resource[$Ship]]) || $Ship == 212) {
continue;
}
$ShipArray[$Ship] = max(0, $sur[$resource[$Ship]]);
if (empty($ShipArray[$Ship])) {
continue;
}
$SubQueryOri .= $resource[$Ship] . " = " . $resource[$Ship] . " - " . $ShipArray[$Ship] . ", ";
$SubQueryDes .= $resource[$Ship] . " = " . $resource[$Ship] . " + " . $ShipArray[$Ship] . ", ";
$PLANET[$resource[$Ship]] += $ShipArray[$Ship];
}
if (empty($SubQueryOri)) {
$this->sendJSON(array(
'message' => $LNG['in_jump_gate_error_data'],
'error' => true
));
return;
}
$SubQueryOri = rtrim($SubQueryOri, ', ');
$SubQueryDes = rtrim($SubQueryDes, ', ');
$sql = "UPDATE %%PLANETS%% SET $SubQueryOri WHERE id = :planetID;";
$db->update($sql, array(':planetID' => $Value));
$sql = "UPDATE %%PLANETS%% SET $SubQueryDes WHERE id = :targetID;";
$db->update($sql, array(':targetID' => $PLANET['id']));
}
$this->printMessage($LNG['h_ok'], true, array('game.php?page=JumpFleet', 4));
} else {
$Planets = array();
$Moons = array();
if (isset($USER['PLANETS'])) {
$USER['PLANETS'] = getPlanets($USER);
}
foreach ($USER['PLANETS'] as $ID => $PlanetQuery) {
if ($ID == $PLANET['id']) continue;
if ($PlanetQuery['planet_type'] == 3) {
$Moons[$PlanetQuery['id']] = $PlanetQuery['name'] . " [" . $PlanetQuery['galaxy'] . ":" . $PlanetQuery['system'] . ":" . $PlanetQuery['planet'] . "]";
} elseif ($PlanetQuery['planet_type'] == 1) {
$Planets[$PlanetQuery['id']] = $PlanetQuery['name'] . " [" . $PlanetQuery['galaxy'] . ":" . $PlanetQuery['system'] . ":" . $PlanetQuery['planet'] . "]";
}
}
$this->tplObj->assign_vars(array(
'PlanetsList' => $Planets,
'MoonsList' => $Moons,
));
$this->display('page.JumpFleet.default.tpl');
}
}
}
?>

Display All

Zuno · Jul 10th 2024, 11:07am

Congratz! great code, yes, can be with dark matter, but i need test, maybe in 1 day, lets wait maybe others can help.

Regards.

amamoslavida · Jul 13th 2024, 2:39pm

The first code you provided, probably written by a person who tries to avoid resource loss issues in Steemnova. But he had wrong approach and he tried to solve the problem on MySQL level by locking tables. That code won't work for all conditions and will cause issues whenever someone try to implement it in their works.

In order to avoid resource loses, Check Yaro's work ( i guess it was Newstar or XNova not sure ). He kinda solved issue with better approach ( atomic update and version controll ).

If you want to avoide class.PlanetRessUpdate to overwrite Fleet Actions and Fleet Teleport ( in your case ) , you should add "version" column in %%PLANETS%% table. And you should modify your planetRessUpdate like update planets ....... where version = version, also you should change your fleethandler in a way update planets ...... Set x,y,z, ... version = version + 1.

By this way, when a fleet reaches to your planet to trade goods, it will trade and it will update planet version to 1 higher. If ResourceUpdater wants to overwrite it, it cannot because now version is higher. It is not 100% correct solution but with this way probably you will loose production instead of fleets or traded goods.

Your second code will fail someday if you don't have PlanetResourceUpdate fix in Yaro's work. So check that and try to implement it to your work

EDIT : I implemented atomic update for the work on my sign steemnova 1.8x, you can check it from github.

check : install.sql , planets table, i added version column there
check : class.MissionFunctions.php, update planets with version + 1
check : class.PlanetRessUpdate.php update planets where version = version

to do : add version update on your Jump page like in missionfunctions update version = version + 1
to do : if you have darkmatter trading fleet functions apply this steps for user table as well, go to instal.sql add version column into users, and modify in a way that it also updates user version.
to do further : write a cronjob which resets user and planet tables sometimes like once in a year, if you have really active game
to do big : With this way of version controll your users wont lose traded resources however, they will some time lose "production" because their traded resourcess will exceed their planet's storage capacity, so planetressupdate will think, capacity is full and won't add production, it is still smaller issue than losing fleet or losing all goods transported with that fleet. Maybe you can avoid it with PHP transactions, but never try to solve that issue on MySQL level by locking tables, transactions and rollback is probably what Ogame uses nowadays.

Another Edit: Do this for MissionCaseRecycling, or debris will lost sometimes, update planet with version = version + 1,

Support for the Jump Fleet.

Support for the Jump Fleet.

PHP Source Code

PHP Source Code

PHP Source Code

Share

Users Online 4

Tags