-- phpMyAdmin SQL Dump -- version 4.6.6deb4 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: 05-Dez-2018 às 14:05 -- Versão do servidor: 10.1.26-MariaDB-0+deb9u1 -- PHP Version: 7.0.27-0+deb9u1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `admin_beta` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `uni1_missions_copy` -- CREATE TABLE `uni1_missions_copy` ( `id` varchar(64) NOT NULL, `class` varchar(64) NOT NULL, `priority` int(11) NOT NULL DEFAULT '1', `reward901` int(11) DEFAULT '0', `reward902` int(11) DEFAULT '0', `reward903` int(11) DEFAULT '0', `reward921` int(11) DEFAULT '0', `code` text, `grind` int(11) NOT NULL DEFAULT '1' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Extraindo dados da tabela `uni1_missions_copy` -- INSERT INTO `uni1_missions_copy` (`id`, `class`, `priority`, `reward901`, `reward902`, `reward903`, `reward921`, `code`, `grind`) VALUES ('tutorial_1', 'tutorial', 1, 1, 1, 1, 1000, '$A = array(\'req\' => $PLANET[\'metal_mine\'], \'value\' => 4);\n$B = array(\'req\' => $PLANET[\'crystal_mine\'], \'value\' => 2);\n$C = array(\'req\' => $PLANET[\'solar_plant\'], \'value\' => 4);\n\n$Requirements = array(\n $A[\'req\'] >= $A[\'value\'] ? 1 : 0,\n $B[\'req\'] >= $B[\'value\'] ? 1 : 0,\n $C[\'req\'] >= $C[\'value\'] ? 1 : 0,\n);\n\nif(count($Requirements) == array_sum($Requirements)){\n $PLANET[$resource[901]] += $MetalProduction * $Mission[\'reward901\'];\n $PLANET[$resource[902]] += $CrystalProduction * $Mission[\'reward902\'];\n $PLANET[$resource[903]] += $DeuteriumProduction * $Mission[\'reward903\'];\n $USER[$resource[921]] += $Mission[\'reward921\'];\n \n $UserMission[$Row[\'class\']] += 1;\n \n Database::get()->update(\"UPDATE %%USERS%% SET mission = :missions WHERE id = :id;\", array(\':missions\' => serialize($UserMission), \':id\' => $USER[\'id\']));\n}\n\n$Requirements = array(\n 1 => array(\'locked\' => $A[\'req\'] >= $A[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_1\'], $A[\'value\'] - $A[\'req\'])),\n 2 => array(\'locked\' => $B[\'req\'] >= $B[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_2\'], $B[\'value\'] - $B[\'req\'])),\n 3 => array(\'locked\' => $C[\'req\'] >= $C[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_3\'], $C[\'value\'] - $C[\'req\'])),\n);', 1), ('tutorial_2', 'tutorial', 1, 1, 1, 1, 1000, '$A = array(\'req\' => $PLANET[\'deuterium_sintetizer\'], \'value\' => 4);\n$B = array(\'req\' => $PLANET[\'robot_factory\'], \'value\' => 2);\n$C = array(\'req\' => $PLANET[\'hangar\'], \'value\' => 4);\n$D = array(\'req\' => $PLANET[\'misil_launcher\'], \'value\' => 10000);\n\n$Requirements = array(\n $A[\'req\'] >= $A[\'value\'] ? 1 : 0,\n $B[\'req\'] >= $B[\'value\'] ? 1 : 0,\n $C[\'req\'] >= $C[\'value\'] ? 1 : 0,\n $D[\'req\'] >= $D[\'value\'] ? 1 : 0,\n);\n\nif(count($Requirements) == array_sum($Requirements)){\n $PLANET[$resource[901]] += $MetalProduction * $Mission[\'reward901\'];\n $PLANET[$resource[902]] += $CrystalProduction * $Mission[\'reward902\'];\n $PLANET[$resource[903]] += $DeuteriumProduction * $Mission[\'reward903\'];\n $USER[$resource[921]] += $Mission[\'reward921\'];\n \n $UserMission[$Row[\'class\']] += 1;\n \n Database::get()->update(\"UPDATE %%USERS%% SET mission = :missions WHERE id = :id;\", array(\':missions\' => serialize($UserMission), \':id\' => $USER[\'id\']));\n}\n\n$Requirements = array(\n 1 => array(\'locked\' => $A[\'req\'] >= $A[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_1\'], $A[\'value\'])),\n 2 => array(\'locked\' => $B[\'req\'] >= $B[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_2\'], $B[\'value\'])),\n 3 => array(\'locked\' => $C[\'req\'] >= $C[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_3\'], $C[\'value\'])),\n 4 => array(\'locked\' => $D[\'req\'] >= $D[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_4\'], pretty_number($D[\'value\'] - $D[\'req\']))),\n);', 1), ('tutorial_3', 'tutorial', 1, 1, 1, 1, 1000, '$A = array(\'req\' => $PLANET[\'metal_mine\'], \'value\' => 10);\n$B = array(\'req\' => $PLANET[\'crystal_mine\'], \'value\' => 7);\n$C = array(\'req\' => $PLANET[\'deuterium_sintetizer\'], \'value\' => 5);\n\n$Requirements = array(\n $A[\'req\'] >= $A[\'value\'] ? 1 : 0,\n $B[\'req\'] >= $B[\'value\'] ? 1 : 0,\n $C[\'req\'] >= $C[\'value\'] ? 1 : 0,\n);\n\nif(count($Requirements) == array_sum($Requirements)){\n $PLANET[$resource[901]] += $MetalProduction * $Mission[\'reward901\'];\n $PLANET[$resource[902]] += $CrystalProduction * $Mission[\'reward902\'];\n $PLANET[$resource[903]] += $DeuteriumProduction * $Mission[\'reward903\'];\n $USER[$resource[921]] += $Mission[\'reward921\'];\n \n $UserMission[$Row[\'class\']] += 1;\n \n Database::get()->update(\"UPDATE %%USERS%% SET mission = :missions WHERE id = :id;\", array(\':missions\' => serialize($UserMission), \':id\' => $USER[\'id\']));\n}\n\n$Requirements = array(\n 1 => array(\'locked\' => $A[\'req\'] >= $A[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_1\'], $A[\'value\'] - $A[\'req\'])),\n 2 => array(\'locked\' => $B[\'req\'] >= $B[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_2\'], $B[\'value\'] - $B[\'req\'])),\n 3 => array(\'locked\' => $C[\'req\'] >= $C[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_3\'], $C[\'value\'] - $C[\'req\'])),\n);', 1), ('tutorial_4', 'tutorial', 1, 1, 1, 1, 1000, '$A = array(\'req\' => $PLANET[\'laboratory\'], \'value\' => 1);\n$B = array(\'req\' => $USER[\'combustion_tech\'], \'value\' => 2);\n$C = array(\'req\' => $PLANET[\'small_ship_cargo\'], \'value\' => 100);\n\n$Requirements = array(\n $A[\'req\'] >= $A[\'value\'] ? 1 : 0,\n $B[\'req\'] >= $B[\'value\'] ? 1 : 0,\n $C[\'req\'] >= $C[\'value\'] ? 1 : 0,\n);\n\nif(count($Requirements) == array_sum($Requirements)){\n $PLANET[$resource[901]] += $MetalProduction * $Mission[\'reward901\'];\n $PLANET[$resource[902]] += $CrystalProduction * $Mission[\'reward902\'];\n $PLANET[$resource[903]] += $DeuteriumProduction * $Mission[\'reward903\'];\n $USER[$resource[921]] += $Mission[\'reward921\'];\n \n $UserMission[$Row[\'class\']] += 1;\n \n Database::get()->update(\"UPDATE %%USERS%% SET mission = :missions WHERE id = :id;\", array(\':missions\' => serialize($UserMission), \':id\' => $USER[\'id\']));\n}\n\n$Requirements = array(\n 1 => array(\'locked\' => $A[\'req\'] >= $A[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_1\'], $A[\'value\'])),\n 2 => array(\'locked\' => $B[\'req\'] >= $B[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_2\'], $B[\'value\'])),\n 3 => array(\'locked\' => $C[\'req\'] >= $C[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_3\'], $C[\'value\'])),\n);', 1), ('tutorial_5', 'tutorial', 1, 1, 1, 1, 1000, '$A = array(\'req\' => $PLANET[\'spy_sonde\'], \'value\' => 1);\n$B = array(\'req\' => Database::get()->selectSingle(\'SELECT COUNT(*) FROM %%LOG_FLEETS%% WHERE fleet_owner = \'.$USER[\'id\'].\' AND fleet_mission = 6\')[\'COUNT(*)\'], \'value\' => 1);\n\n$Requirements = array(\n $A[\'req\'] >= $A[\'value\'] ? 1 : 0,\n $B[\'req\'] >= $A[\'value\'] ? 1 : 0,\n);\n\nif(count($Requirements) == array_sum($Requirements)){\n $PLANET[$resource[901]] += $MetalProduction * $Mission[\'reward901\'];\n $PLANET[$resource[902]] += $CrystalProduction * $Mission[\'reward902\'];\n $PLANET[$resource[903]] += $DeuteriumProduction * $Mission[\'reward903\'];\n $USER[$resource[921]] += $Mission[\'reward921\'];\n \n $UserMission[$Row[\'class\']] += 1;\n \n Database::get()->update(\"UPDATE %%USERS%% SET mission = :missions WHERE id = :id;\", array(\':missions\' => serialize($UserMission), \':id\' => $USER[\'id\']));\n}\n\n$Requirements = array(\n 1 => array(\'locked\' => $A[\'req\'] >= $A[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_1\'], $A[\'value\'])),\n 2 => array(\'locked\' => $B[\'req\'] >= $B[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_1\'], $B[\'value\'])),\n);', 1), ('tutorial_6', 'tutorial', 1, 1, 1, 1, 1000, '$A = array(\'req\' => Database::get()->selectSingle(\'SELECT COUNT(*) FROM %%LOG_FLEETS%% WHERE fleet_owner = \'.$USER[\'id\'].\' AND fleet_mission = 15\')[\'COUNT(*)\'], \'value\' => 1);\n\n$Requirements = array(\n $A[\'req\'] >= $A[\'value\'] ? 1 : 0,\n);\n\nif(count($Requirements) == array_sum($Requirements)){\n $PLANET[$resource[901]] += $MetalProduction * $Mission[\'reward901\'];\n $PLANET[$resource[902]] += $CrystalProduction * $Mission[\'reward902\'];\n $PLANET[$resource[903]] += $DeuteriumProduction * $Mission[\'reward903\'];\n $USER[$resource[921]] += $Mission[\'reward921\'];\n \n $UserMission[$Row[\'class\']] += 1;\n \n Database::get()->update(\"UPDATE %%USERS%% SET mission = :missions WHERE id = :id;\", array(\':missions\' => serialize($UserMission), \':id\' => $USER[\'id\']));\n}\n\n$Requirements = array(\n 1 => array(\'locked\' => $A[\'req\'] >= $A[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_1\'], $A[\'value\'])),\n);', 1), ('tutorial_7', 'tutorial', 1, 1, 1, 1, 1000, '$A = array(\'req\' => $USER[\'expedition_tech\'], \'value\' => 2);\n$B = array(\'req\' => $PLANET[\'colonizer\'], \'value\' => 1);\n$C = array(\'req\' => Database::get()->selectSingle(\'SELECT COUNT(*) FROM %%PLANETS%% WHERE id_owner = \'.$USER[\'id\'].\' AND planet_type = \"1\"\')[\'COUNT(*)\'], \'value\' => 2);\n\n\n$Requirements = array(\n $A[\'req\'] >= $A[\'value\'] ? 1 : 0,\n $B[\'req\'] >= $B[\'value\'] ? 1 : 0,\n $C[\'req\'] >= $C[\'value\'] ? 1 : 0,\n);\n\nif(count($Requirements) == array_sum($Requirements)){\n $PLANET[$resource[901]] += $MetalProduction * $Mission[\'reward901\'];\n $PLANET[$resource[902]] += $CrystalProduction * $Mission[\'reward902\'];\n $PLANET[$resource[903]] += $DeuteriumProduction * $Mission[\'reward903\'];\n $USER[$resource[921]] += $Mission[\'reward921\'];\n \n $UserMission[$Row[\'class\']] += 1;\n \n Database::get()->update(\"UPDATE %%USERS%% SET mission = :missions WHERE id = :id;\", array(\':missions\' => serialize($UserMission), \':id\' => $USER[\'id\']));\n}\n\n$Requirements = array(\n 1 => array(\'locked\' => $A[\'req\'] >= $A[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_1\'], $A[\'value\'])),\n 2 => array(\'locked\' => $B[\'req\'] >= $B[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_2\'], $B[\'value\'])),\n 3 => array(\'locked\' => $C[\'req\'] >= $C[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_3\'], $C[\'value\'])),\n);', 1), ('tutorial_8', 'tutorial', 1, 1, 1, 1, 1000, '$A = array(\'req\' => Database::get()->selectSingle(\'SELECT COUNT(*) FROM %%LOG_FLEETS%% WHERE fleet_owner = \'.$USER[\'id\'].\' AND fleet_mission = 1\')[\'COUNT(*)\'], \'value\' => 1);\n\n$Requirements = array(\n $A[\'req\'] >= $A[\'value\'] ? 1 : 0,\n);\n\nif(count($Requirements) == array_sum($Requirements)){\n $PLANET[$resource[901]] += $MetalProduction * $Mission[\'reward901\'];\n $PLANET[$resource[902]] += $CrystalProduction * $Mission[\'reward902\'];\n $PLANET[$resource[903]] += $DeuteriumProduction * $Mission[\'reward903\'];\n $USER[$resource[921]] += $Mission[\'reward921\'];\n \n $UserMission[$Row[\'class\']] += 1;\n \n Database::get()->update(\"UPDATE %%USERS%% SET mission = :missions WHERE id = :id;\", array(\':missions\' => serialize($UserMission), \':id\' => $USER[\'id\']));\n}\n\n$Requirements = array(\n 1 => array(\'locked\' => $A[\'req\'] >= $A[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_1\'], $A[\'value\'])),\n);', 1), ('tutorial_9', 'tutorial', 1, 1, 1, 1, 1000, '$A = array(\'req\' => $PLANET[\'recycler\'], \'value\' => 1);\n$B = array(\'req\' => Database::get()->selectSingle(\'SELECT COUNT(*) FROM %%LOG_FLEETS%% WHERE fleet_owner = \'.$USER[\'id\'].\' AND fleet_mission = 8;\')[\'COUNT(*)\'], \'value\' => 1);\n\n$Requirements = array(\n $A[\'req\'] >= $A[\'value\'] ? 1 : 0,\n $B[\'req\'] >= $B[\'value\'] ? 1 : 0,\n);\n\nif(count($Requirements) == array_sum($Requirements)){\n $PLANET[$resource[901]] += $MetalProduction * $Mission[\'reward901\'];\n $PLANET[$resource[902]] += $CrystalProduction * $Mission[\'reward902\'];\n $PLANET[$resource[903]] += $DeuteriumProduction * $Mission[\'reward903\'];\n $USER[$resource[921]] += $Mission[\'reward921\'];\n \n $UserMission[$Row[\'class\']] += 1;\n \n Database::get()->update(\"UPDATE %%USERS%% SET mission = :missions WHERE id = :id;\", array(\':missions\' => serialize($UserMission), \':id\' => $USER[\'id\']));\n}\n\n$Requirements = array(\n 1 => array(\'locked\' => $A[\'req\'] >= $A[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_1\'], $A[\'value\'])),\n 2 => array(\'locked\' => $B[\'req\'] >= $B[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_2\'], $B[\'value\'])),\n);', 1), ('tutorial_10', 'tutorial', 1, 1, 1, 1, 1000, '$A = array(\'req\' => Database::get()->selectSingle(\"SELECT COUNT(*) FROM %%PLANETS%% WHERE planet_type = \'3\' AND id_owner = \".$USER[\'id\'].\";\")[\'COUNT(*)\'], \'value\' => 1);\n\n$Requirements = array(\n $A[\'req\'] >= $A[\'value\'] ? 1 : 0,\n);\n\nif(count($Requirements) == array_sum($Requirements)){\n $PLANET[$resource[901]] += $MetalProduction * $Mission[\'reward901\'];\n $PLANET[$resource[902]] += $CrystalProduction * $Mission[\'reward902\'];\n $PLANET[$resource[903]] += $DeuteriumProduction * $Mission[\'reward903\'];\n $USER[$resource[921]] += $Mission[\'reward921\'];\n \n $UserMission[$Row[\'class\']] += 1;\n \n Database::get()->update(\"UPDATE %%USERS%% SET mission = :missions WHERE id = :id;\", array(\':missions\' => serialize($UserMission), \':id\' => $USER[\'id\']));\n}\n\n$Requirements = array(\n 1 => array(\'locked\' => $A[\'req\'] >= $A[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_1\'], $A[\'value\'])),\n);', 1), ('tutorial_11', 'tutorial', 1, 1, 1, 1, 1000, '$A = array(\'req\' => $USER[\'computer_tech\'], \'value\' => 10);\n$B = array(\'req\' => $PLANET[\'robot_factory\'], \'value\' => 10);\n$C = array(\'req\' => $PLANET[\'nano_factory\'], \'value\' => 1);\n\n$Requirements = array(\n $A[\'req\'] >= $A[\'value\'] ? 1 : 0,\n $B[\'req\'] >= $B[\'value\'] ? 1 : 0,\n $C[\'req\'] >= $C[\'value\'] ? 1 : 0,\n);\n\nif(count($Requirements) == array_sum($Requirements)){\n $PLANET[$resource[901]] += $MetalProduction * $Mission[\'reward901\'];\n $PLANET[$resource[902]] += $CrystalProduction * $Mission[\'reward902\'];\n $PLANET[$resource[903]] += $DeuteriumProduction * $Mission[\'reward903\'];\n $USER[$resource[921]] += $Mission[\'reward921\'];\n \n $UserMission[$Row[\'class\']] += 1;\n \n Database::get()->update(\"UPDATE %%USERS%% SET mission = :missions WHERE id = :id;\", array(\':missions\' => serialize($UserMission), \':id\' => $USER[\'id\']));\n}\n\n$Requirements = array(\n 1 => array(\'locked\' => $A[\'req\'] >= $A[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_1\'], $A[\'value\'])),\n 2 => array(\'locked\' => $B[\'req\'] >= $B[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_2\'], $B[\'value\'])),\n 3 => array(\'locked\' => $C[\'req\'] >= $C[\'value\'] ? 1 : 0, \'text\' => sprintf($LNG[\'mission_\'.$MissionTracker.\'_3\'], $C[\'value\'])),\n);', 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `uni1_missions_copy` -- ALTER TABLE `uni1_missions_copy` ADD UNIQUE KEY `id` (`id`); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;