Space RPG .Net

Using SQLite for the Galaxy Map

This tutorial will instruct you on modifying the pe.dat file to be able to view all of galaxy map jump gate lines. For general instructions on using SQLite to modify the pe.dat file, please visit the Player File Hacks page.

The first thing to do after you have opened the pe.dat file using SQLite is view the current_player table. This table tells you what the player_id of the ship that you have played with most recently. There should only be one row and one column in the table. The screenshot below shows you what this will look like. In the case below, the player_id is 4:

The following code can be executed in sqlite to update the galaxy map for a player with player_id = 4. If the player_id is something other than 4, the first of the two fields in the "VALUES" clause must be updated to that number. For more information on SQL, you can visit our SQL tutorial.

INSERT INTO player_systems (player_id,system_id) VALUES (4,3);
INSERT INTO player_systems (player_id,system_id) VALUES (4,4);
INSERT INTO player_systems (player_id,system_id) VALUES (4,5);
INSERT INTO player_systems (player_id,system_id) VALUES (4,6);
INSERT INTO player_systems (player_id,system_id) VALUES (4,7);
INSERT INTO player_systems (player_id,system_id) VALUES (4,8);
INSERT INTO player_systems (player_id,system_id) VALUES (4,9);
INSERT INTO player_systems (player_id,system_id) VALUES (4,10);
INSERT INTO player_systems (player_id,system_id) VALUES (4,11);
INSERT INTO player_systems (player_id,system_id) VALUES (4,12);
INSERT INTO player_systems (player_id,system_id) VALUES (4,13);
INSERT INTO player_systems (player_id,system_id) VALUES (4,14);
INSERT INTO player_systems (player_id,system_id) VALUES (4,15);
INSERT INTO player_systems (player_id,system_id) VALUES (4,16);
INSERT INTO player_systems (player_id,system_id) VALUES (4,17);
INSERT INTO player_systems (player_id,system_id) VALUES (4,18);
INSERT INTO player_systems (player_id,system_id) VALUES (4,19);
INSERT INTO player_systems (player_id,system_id) VALUES (4,20);
INSERT INTO player_systems (player_id,system_id) VALUES (4,21);
INSERT INTO player_systems (player_id,system_id) VALUES (4,22);
INSERT INTO player_systems (player_id,system_id) VALUES (4,23);
INSERT INTO player_systems (player_id,system_id) VALUES (4,24);
INSERT INTO player_systems (player_id,system_id) VALUES (4,25);
INSERT INTO player_systems (player_id,system_id) VALUES (4,26);
INSERT INTO player_systems (player_id,system_id) VALUES (4,27);
INSERT INTO player_systems (player_id,system_id) VALUES (4,28);
INSERT INTO player_systems (player_id,system_id) VALUES (4,29);
INSERT INTO player_systems (player_id,system_id) VALUES (4,30);
INSERT INTO player_systems (player_id,system_id) VALUES (4,31);
INSERT INTO player_systems (player_id,system_id) VALUES (4,32);
INSERT INTO player_systems (player_id,system_id) VALUES (4,33);
INSERT INTO player_systems (player_id,system_id) VALUES (4,34);
INSERT INTO player_systems (player_id,system_id) VALUES (4,35);
INSERT INTO player_systems (player_id,system_id) VALUES (4,36);
INSERT INTO player_systems (player_id,system_id) VALUES (4,37);
INSERT INTO player_systems (player_id,system_id) VALUES (4,38);
INSERT INTO player_systems (player_id,system_id) VALUES (4,39);
INSERT INTO player_systems (player_id,system_id) VALUES (4,40);
INSERT INTO player_systems (player_id,system_id) VALUES (4,41);
INSERT INTO player_systems (player_id,system_id) VALUES (4,42);
INSERT INTO player_systems (player_id,system_id) VALUES (4,43);
INSERT INTO player_systems (player_id,system_id) VALUES (4,44);
INSERT INTO player_systems (player_id,system_id) VALUES (4,45);
INSERT INTO player_systems (player_id,system_id) VALUES (4,46);
INSERT INTO player_systems (player_id,system_id) VALUES (4,47);
INSERT INTO player_systems (player_id,system_id) VALUES (4,48);
INSERT INTO player_systems (player_id,system_id) VALUES (4,49);
INSERT INTO player_systems (player_id,system_id) VALUES (4,50);
INSERT INTO player_systems (player_id,system_id) VALUES (4,51);
INSERT INTO player_systems (player_id,system_id) VALUES (4,52);
INSERT INTO player_systems (player_id,system_id) VALUES (4,53);
INSERT INTO player_systems (player_id,system_id) VALUES (4,54);
INSERT INTO player_systems (player_id,system_id) VALUES (4,55);
INSERT INTO player_systems (player_id,system_id) VALUES (4,56);
INSERT INTO player_systems (player_id,system_id) VALUES (4,57);
INSERT INTO player_systems (player_id,system_id) VALUES (4,58);
INSERT INTO player_systems (player_id,system_id) VALUES (4,59);
INSERT INTO player_systems (player_id,system_id) VALUES (4,60);
INSERT INTO player_systems (player_id,system_id) VALUES (4,61);
INSERT INTO player_systems (player_id,system_id) VALUES (4,62);
INSERT INTO player_systems (player_id,system_id) VALUES (4,63);
INSERT INTO player_systems (player_id,system_id) VALUES (4,64);
INSERT INTO player_systems (player_id,system_id) VALUES (4,65);
INSERT INTO player_systems (player_id,system_id) VALUES (4,66);
INSERT INTO player_systems (player_id,system_id) VALUES (4,67);
INSERT INTO player_systems (player_id,system_id) VALUES (4,68);
INSERT INTO player_systems (player_id,system_id) VALUES (4,69);
INSERT INTO player_systems (player_id,system_id) VALUES (4,70);
INSERT INTO player_systems (player_id,system_id) VALUES (4,71);
INSERT INTO player_systems (player_id,system_id) VALUES (4,72);
INSERT INTO player_systems (player_id,system_id) VALUES (4,73);
INSERT INTO player_systems (player_id,system_id) VALUES (4,74);
INSERT INTO player_systems (player_id,system_id) VALUES (4,75);
INSERT INTO player_systems (player_id,system_id) VALUES (4,76);
INSERT INTO player_systems (player_id,system_id) VALUES (4,77);
INSERT INTO player_systems (player_id,system_id) VALUES (4,78);
INSERT INTO player_systems (player_id,system_id) VALUES (4,79);
INSERT INTO player_systems (player_id,system_id) VALUES (4,80);
INSERT INTO player_systems (player_id,system_id) VALUES (4,81);
INSERT INTO player_systems (player_id,system_id) VALUES (4,82);
INSERT INTO player_systems (player_id,system_id) VALUES (4,83);
INSERT INTO player_systems (player_id,system_id) VALUES (4,84);
INSERT INTO player_systems (player_id,system_id) VALUES (4,85);
INSERT INTO player_systems (player_id,system_id) VALUES (4,86);
INSERT INTO player_systems (player_id,system_id) VALUES (4,87);
INSERT INTO player_systems (player_id,system_id) VALUES (4,88);
INSERT INTO player_systems (player_id,system_id) VALUES (4,89);
INSERT INTO player_systems (player_id,system_id) VALUES (4,90);
INSERT INTO player_systems (player_id,system_id) VALUES (4,91);
INSERT INTO player_systems (player_id,system_id) VALUES (4,92);
INSERT INTO player_systems (player_id,system_id) VALUES (4,93);
INSERT INTO player_systems (player_id,system_id) VALUES (4,94);
INSERT INTO player_systems (player_id,system_id) VALUES (4,95);
INSERT INTO player_systems (player_id,system_id) VALUES (4,96);
INSERT INTO player_systems (player_id,system_id) VALUES (4,97);
INSERT INTO player_systems (player_id,system_id) VALUES (4,98);
INSERT INTO player_systems (player_id,system_id) VALUES (4,99);

Copy and paste this code (modifying the first number in 'VALUES' if your current player is not 4) into the Sqlite Browser window as shown below.

After you have done that, press the 'Execute' button located near the center of your SqliteCC window. This will execute all 100 lines of the code making all of the jump gate lines visible the next time you play Epoch Star.

Š2005 Battleline Games
Contact Us: Support@EpochStar.com