I thought i should check if it's still possible to play this game. Played it in the Westwood days and tried my luck a while after here. I tried downloading the various downloads but for each of them i get a warning to make sure i trust the exe. for each.

I don't now how to do that. Could anyone help this simpleton perhaps ?

If this game is still running and i manage to get back in and just enjoy it like i did before without a rush to max i would certainly donate to maintaining it. Provided that can be done without a CC, Paypall perhaps ?

https://www.raphkoster.com/games/presentations/scifi-mmps-lessons-learned/

Runtime for the audio file is a little over one hour.

If you're wondering why we don't just post the link directly, it is because then it would be easy for bots and other malicious entities to find it and join, increasing the workload of the people managing those communities.

7 years ago a forum topic was started that was asking questions about the state of things within the emulator, albeit not in a very tactful manner. The post did get derailed and has since been buried due to time and space dust, but did have response from project leadership.

With that said though it has now been 7 years since I added my questions to the forum thread, and unfortunately things haven't really changed since the question was answered. The following is what was asked:

Now I am not the type of person to complain about efforts put in by others when I am unable to contribute to it myself, but I do feel that after this many years and (correct me if I am wrong) these patch notes and content never actually materialized. 

I fully understand that being a volunteer based project that unexpected life changes can drastically alter ones priorities in life, specially when the nature of this is as previously mentioned, volunteer based, and with time being the most valuable and important commodity we have in life it should not be used up dealing with something that you really don't have time spare for.

So that brings me to the end of this post with basically the same question, where does the project really stand regarding additional story advancement, sectors, mobs, server back end etc? If this is Earth & Beyond Emulator in its final state, then so be it. Hundreds of us have thoroughly enjoyed what has been brought back to life and are eternally grateful for everyone involved in getting it off the ground and in the state we all love and play today. But if there is really content that the team has, please lets have a bit of transparency about how realistic it is that it will ever go live.

Thanks for reading

-FFT

Post Server Status (only) here from now on - tnx :)

Apologies is this has been asked and answered but will the storyline ever advance? I would love to see how it plays out.

Thanks for any help/answers!

[attachment=3137:Advice.jpg]

[attachment=3138:Beams.jpg]

[attachment=3139:Boot.jpg]

[attachment=3140:Chugalug.jpg]

[attachment=3141:EverCrack.jpg]

[attachment=3142:Honesty.jpg]

[attachment=3143:Kill Chavez.jpg]

[attachment=3144:Listen.jpg]

[attachment=3145:Meditating.jpg]

[attachment=3146:MT.jpg]

[attachment=3147:Pie.jpg]

[attachment=3148:PL Monkey.jpg]

[attachment=3149:Scuttled Bug.jpg]

[attachment=3150:Spicy.jpg]

[attachment=3151:Terminals.jpg]

[attachment=3152:Trick or Treat.jpg]

[attachment=3153:Tumble.jpg]

[attachment=3154:Welcome.jpg]

[attachment=3155:What.jpg]

[attachment=3156:Woosh.jpg]

---

Also, because I think it was a neat coincidence:

[attachment=3157:Sunblock.jpg]

I can login to the forum, the client is installed but what did I miss to actually log into the game?

v/r,

Farlito 

   I want to place a special shout out to the pilots that stepped up and were willing to invest your time, credits, and patience to a newbie. It truly reflects what is to be love about this game. The People. The investment you all have made, makes the return experience just like coming home.  Thank you all!

- Caduceus (Cadu)

"What's the license"

1. You may not use this software for commercial gain. No ads, no donations, no other revenue streams. If you break even with hosting and publicly (no request, publicly, on a normal page anyone can view) display that your operating it as non-profit, that's fine.
2. It must remain open source in its entirety. Every image, every line of code, every byte of data in the database must all be accessible without authorization or signup.
3. The code cannot be placed on github or any other site which intends to ingest the code into AI tools or otherwise monetize the code hosted there.
   1. Running your own git instance and hosting from there is fine.
4. Any future license must require and honor these terms. Meaning, you cannot repackage this and change the license to MIT or something else. These terms of license must be in all downstream forks.

For running a production site

For an actual production site, you'll probably want to use mysql instead of sqlite, but sqlite is great for development and the code changeover from one to the other isn't bad. Mostly it's replacing ? with %s in a bunch of places. Well...the binding process is completely different, but meh. I didn't write it using mysql, again, if zen4's Promontory 21 hadn't been the shitshow it was, I'd have written it to use mysql.

Also, you'll probably want to remove the Command Bar entirely from a production site. This tool wasn't really built to work like a wiki. It was meant for 1-2 people who are highly trusted to update the DB, then for it to mostly be a read-only experience.

The idea behind adding mobs:

1. Fly around with two chars. A JD and a PW are optimal. JD has 3 beams, 1 Energy, 1 EMP, 1 Plasma. PW has 3 guns, one loaded Explosive, 1 loaded Impact, 1 loaded Chemical.
2. Telescopium on the JD
3. DO NOT USE ANY RESIST DEBUFFS OF ANY KIND! Not even gravity link.
4. Click on the 'Add Mob' button, shoot with energy laser, say it does 145 (-50) damage. You'd type in 145 for the Damage Component and -50 for the Resist Component. There's a blub on the page that explains all this.
   1. Fire 1 round from all the other weapon types and enter the damage/resist components.
   2. For positive numbers just enter the number without a + sign, so +500 is just 500.
   3. The page is smart enough to know that 145 (-50) meant you did 195 dmg, and 1000 (+500) meant you did 500.
5. The page will do the math on its own to determine the mob resists and store them in the DB.
6. A checkbox needs to be added for whether or not the mob is default hostile.

"All this is in the wiki!"

Yeah, but seeing it on a map is easier, and for things like mobs and ore, it helps to visually see where things are. Sure, there's Titanium in KV, but *where* in KV. Oh, only 2-3 of the 17 fields there. Cool. Now I know where to warp.

"This javascript is written by a moron"

Yeah. this is my first major javascript attempt. I was making this a web 2.0 page (so, one page load, then only DOM changes after) purely for practice/learning. You'll note I don't import jquery or any libraries. This is all hand-written baisc javascript. Maybe I'm a masochist. Maybe I just like learning. *shrug*

"How did you get the navs?"

1. Log into the game (ON ONE CHARACTER, DO NOT MULTIBOX FOR THIS unless using separate installs), enter a sector,
2. Create a private channel (mostly to avoid spamming others)
3. Target a 'normal' nav, press ctrl+t (I remapped it to b for easier pressing)
   1. Press n to go to the next visible nav
   2. Press ctrl+t
   3. Repeat until all visible navs are reported in chat. Don't worry about duplicates, the code below is smart enough to remove them.
4. type 'hidden' in your private channel
5. press 'x' to target the nearest hidden nav (move away if asteroids are in view)
   1. Press ctrl+t
   2. Press n to go to the next hidden nav
   3. Repeat until all hidden navs are dumped
6. Close game
7. Run script below on your chat.log file
8. Copy-paste output into the "Add Navs" button, after you check the 'JSON Import' checkbox

I imagine a script similar to this will be useful for import mobs/roids from chat as well. I did not do the work to make this a thing though. Also, I did not learn sectors could be asymmetric (like Grissom, where it's box is -450|575|-525|650) until I was almost done adding sectors, so roughly 40 of the 69 sectors in the game should be double-checked for asymmetry. sector_ids 1-53 are suspect, basically. Xipe Totec was the first asymmetric zone I remember finding. After Xipe, I made sure to check all 4 dimensions instead of assuming symmetry.

--Parse_navs.py--

#!/usr/bin/python3

import argparse
import json
import re

"""THis list is also defined in functions.php and map_script.js, update all 3!

$NAV_TYPE_MAP_BASE = [
    "Normal Nav" => 0,
    "Hidden Nav" => 1,
    "Normal Gate" => 2,
    "Faction Gate" => 3,
    "Normal Station" => 4,
    "Faction Station" => 5,
    "Planet" => 6,
    "Landable Planet" => 7,
    "Weft" => 8,
    "Extended Weft" => 9,
    "Ore Field" => 10
];
"""

def parse_log(file_path, channel_name, player_name):
    results = {}

    sector_pattern = re.compile(r"We have entered (.+?) Sector \((.+?)\)")
    target_pattern = re.compile(r"\[(\d+)\] " + re.escape(player_name) + r": Target '(.+?)' at \(([-\d.]+), ([-\d.]+), ([-\d.]+)\)")
    hidden_nav_pattern = re.compile(r"\[(\d+)\] " + re.escape(player_name) + r": hidden")

    current_sector = ""
    hidden_nav_mode = False
    with open(file_path, 'r', encoding='latin-1') as file:
        for line in file:
            sector_match = sector_pattern.search(line)
            if sector_match:
                sector_name = sector_match.group(1)
                system_name = sector_match.group(2)
                current_sector = sector_name
                #print(f"We have entered {sector_name} ({system_name})")
                hidden_nav_mode = False
                
            if hidden_nav_pattern.search(line):
                hidden_nav_mode = True

            target_match = target_pattern.search(line)
            if target_match:
                target_channel = target_match.group(1)
                target_name = target_match.group(2)
                nav_type = 0;
                
                if target_name.startswith("Sector Gate ") or target_name.startswith("Accelerator") or target_name.startswith("System Gate"):
                    nav_type = 2;
                if hidden_nav_mode:
                    nav_type = 1
                
                if target_channel == channel_name:
                    x_coord = int(round(float(target_match.group(3)),0))
                    y_coord = int(round(float(target_match.group(4)),0))
                    z_coord = int(round(float(target_match.group(5)),0))
                    
                    if current_sector not in results:
                        results[current_sector] = {}
                    #Assume normal navs until we have some way to mark other things automatically.
                    
                    coord_pack = [x_coord, y_coord, z_coord, nav_type]
                    if target_name not in results[current_sector]:
                        results[current_sector][target_name] = [coord_pack]
                    elif coord_pack not in results[current_sector][target_name]:
                        results[current_sector][target_name].append(coord_pack)
                    
                    #print(f"Target '{target_name}' at ({x_coord}, {y_coord}, {z_coord}, {nav_type})")
    #print(json.dumps(results, indent=4))
    #print(results)
    print(format_output(results))

def format_output(data):
    formatted_output = "{"
    for key in data:
        formatted_output += f'"{key}": {{\n'
        for nav in data[key]:
            formatted_output += f'\t"{nav}": {data[key][nav]},\n'
        formatted_output = formatted_output[:-2] + "},\n"
    # Remove the trailing comma and newline character for the last line
    formatted_output = formatted_output[:-2] + "}\n"
    return formatted_output

if __name__ == "__main__":
    parser = argparse.ArgumentParser(description="Parse log file")
    parser.add_argument("file", help="Path to the log file")
    parser.add_argument("--channel", default="100", help="Channel name (default: [100])")
    parser.add_argument("--player", default="Doctorje", help="Player name (default: Doctorje)")
    args = parser.parse_args()

    parse_log(args.file, args.channel, args.player)

--parse_ores.py--

#!/usr/bin/python3

import argparse
import json
import re
import sqlite3
import sys

RESOURCE_SOURCE_MAP = {
    "Copper Ore": ["Rock", 1],
    "Crude Graphite": ["Hydrocarbon", 1],
    "Crude Nickel": ["Rock", 1],
    "Diridium Crystal": ["Crystal", 1],
    "Hydrogen": ["Gas", 1],
    "Iron Ore": ["Rock", 1],
    "Lead Ore": ["Rock", 1],
    "Lithium Ore": ["Glowing", 1],
    "Magnetite Ore": ["Rock", 1],
    "Mordanite": ["Rock", 1],
    "Nitrogen": ["Gas", 1],
    "Oxygen": ["Gas", 1],
    "Potash": ["Glowing", 1],
    "Raw Agate": ["Crystal", 1],
    "Raw Beryl": ["Crystal", 1],
    "Raw Black Tazeron": ["Hydrocarbon", 1],
    "Raw Bloodstone": ["Crystal", 1],
    "Raw Blue Tazeron": ["Hydrocarbon", 1],
    "Raw Crude Coal": ["Hydrocarbon", 1],
    "Raw Green Tazeron": ["Hydrocarbon", 1],
    "Raw Jasper": ["Crystal", 1],
    "Raw Onyx": ["Crystal", 1],
    "Raw Red Tazeron": ["Hydrocarbon", 1],
    "Raw Topaz": ["Crystal", 1],
    "Raw White Tazeron": ["Hydrocarbon", 1],
    "Raw Yellow Tazeron": ["Hydrocarbon", 1],
    "Sand": ["Hydrocarbon", 1],
    "Sponge Chloride": ["Crystal", 1],
    "Sulfates": ["Glowing", 1],
    "Tar": ["Hydrocarbon", 1],
    "Uranium Ore": ["Glowing", 1],
    "Zinc Ore": ["Rock", 1],
    "Aluminium Ore": ["Rock", 2],
    "Brominite": ["Glowing", 2],
    "Cadmium Ore": ["Glowing", 2],
    "Carbon Dioxide": ["Gas", 2],
    "Crude Oil": ["Hydrocarbon", 2],
    "Germanium Ore": ["Rock", 2],
    "Helium": ["Gas", 2],
    "Hermesite": ["Rock", 2],
    "Magnesium Ore": ["Rock", 2],
    "Methane": ["Gas", 2],
    "Molybdenum Ore": ["Rock", 2],
    "Phosphates": ["Glowing", 2],
    "Plutonium Ore": ["Glowing", 2],
    "Quartz Crystals": ["Hydrocarbon", 2],
    "Raw Amethyst": ["Crystal", 2],
    "Raw Coal": ["Hydrocarbon", 2],
    "Raw Garnet": ["Crystal", 2],
    "Raw Moonstone": ["Crystal", 2],
    "Raw Sunstone": ["Crystal", 2],
    "Raw Tourmaline": ["Crystal", 2],
    "Raw Turquoise": ["Crystal", 2],
    "Tin Ore": ["Rock", 2],
    "Zircon": ["Rock", 2],
    "Alanite": ["Glowing", 3],
    "Barite": ["Glowing", 3],
    "Boronite": ["Glowing", 3],
    "Caesium Ore": ["Rock", 3],
    "Calcite": ["Glowing", 3],
    "Cobalite": ["Rock", 3],
    "Fluorine": ["Gas", 3],
    "Gallium Ore": ["Rock", 3],
    "Indium Ore": ["Rock", 3],
    "Light Crude Oil": ["Hydrocarbon", 3],
    "Obsidian": ["Hydrocarbon", 3],
    "Polonium Ore": ["Glowing", 3],
    "Raw Alexandrite": ["Crystal", 3],
    "Raw Anthracite": ["Hydrocarbon", 3],
    "Raw Citrine": ["Crystal", 3],
    "Raw Lapis Lazuli": ["Crystal", 3],
    "Raw Malachite": ["Crystal", 3],
    "Star Iron Ore": ["Rock", 3],
    "Tungsten Ore": ["Rock", 3],
    "Anubium Ore": ["Rock", 4],
    "Argon": ["Gas", 4],
    "Californium Ore": ["Glowing", 4],
    "Ceresite": ["Glowing", 4],
    "Galactic Ore": ["Rock", 4],
    "Herculinium Ore": ["Rock", 4],
    "Manganese Ore": ["Rock", 4],
    "Meteoric Sand": ["Hydrocarbon", 4],
    "Neon": ["Gas", 4],
    "Raw Black Opal": ["Crystal", 4],
    "Raw Centauricite": ["Rock", 4],
    "Raw Fire Opal": ["Crystal", 4],
    "Raw Flawless Garnet": ["Crystal", 4],
    "Raw Ruby": ["Crystal", 4],
    "Saganite": ["Glowing", 4],
    "Silver Ore": ["Rock", 4],
    "Solar Sweet Oil": ["Hydrocarbon", 4],
    "Vanadium Ore": ["Rock", 4],
    "Andromesite": ["Hydrocarbon", 5],
    "Bastinium Ore": ["Glowing", 5],
    "Brood Oil": ["Hydrocarbon", 5],
    "Chromium Ore": ["Rock", 5],
    "Gold Ore": ["Rock", 5],
    "Hades Blood": ["Hydrocarbon", 5],
    "Halon": ["Gas", 5],
    "Hawkinsite": ["Glowing", 5],
    "Minervite": ["Glowing", 5],
    "Radium Ore": ["Glowing", 5],
    "Radon": ["Gas", 5],
    "Raw Black Pearl": ["Crystal", 5],
    "Raw Capellicite": ["Crystal", 5],
    "Raw Heartstone": ["Crystal", 5],
    "Raw Sapphire": ["Crystal", 5],
    "Raw Skystone": ["Crystal", 5],
    "Rhodite": ["Rock", 5],
    "Titanium Ore": ["Rock", 5],
    "Zalmoxium Ore": ["Rock", 5],
    "Adamantine Ore": ["Rock", 6],
    "Charon's Dust": ["Hydrocarbon", 6],
    "Curium Ore": ["Glowing", 6],
    "Discordite": ["Glowing", 6],
    "Hafnium Ore": ["Rock", 6],
    "Homerite": ["Rock", 6],
    "Krypton": ["Gas", 6],
    "Mirandium Ore": ["Rock", 6],
    "Osirium Ore": ["Rock", 6],
    "Oxium Ore": ["Rock", 6],
    "Platinum Ore": ["Rock", 6],
    "Raw Anthenicite": ["Hydrocarbon", 6],
    "Raw Charon Crystal": ["Glowing", 6],
    "Raw Emerald": ["Crystal", 6],
    "Raw Flawless Ruby": ["Crystal", 6],
    "Raw Icy Pearl": ["Crystal", 6],
    "Stygian Blackwater": ["Hydrocarbon", 6],
    "Xenon": ["Gas", 6],
    "Apollonite": ["Glowing", 7],
    "Brucite Ore": ["Glowing", 7],
    "Celestial Ore": ["Rock", 7],
    "Chalcophanite": ["Glowing", 7],
    "Conorite": ["Rock", 7],
    "Cupidite": ["Glowing", 7],
    "Demeter's Tears": ["Hydrocarbon", 7],
    "Horusium Ore": ["Glowing", 7],
    "Inderite": ["Rock", 7],
    "Iridium Ore": ["Rock", 7],
    "Leonite": ["Hydrocarbon", 7],
    "Neutronium Ore": ["Glowing", 7],
    "Niobite": ["Rock", 7],
    "Raw Barite": ["Glowing", 7],
    "Raw Diamond": ["Crystal", 7],
    "Raw Eye Stone": ["Crystal", 7],
    "Raw Firerock": ["Crystal", 7],
    "Raw Galactic Rimstone": ["Crystal", 7],
    "Raw Hadecite": ["Hydrocarbon", 7],
    "Stojsavline": ["Gas", 7],
    "Stygian Blacksand": ["Hydrocarbon", 7],
    "Tantalum Ore": ["Rock", 7],
    "Vaneon": ["Gas", 7],
    "Wexeon": ["Gas", 7],
    "Abyssian Dust": ["Hydrocarbon", 8],
    "Ambrosia Crude": ["Hydrocarbon", 8],
    "Boragon": ["Gas", 8],
    "Duplium Ore": ["Rock", 8],
    "Emperion": ["Gas", 8],
    "Helvatha": ["Hydrocarbon", 8],
    "Idunium Ore": ["Rock", 8],
    "Khnumium Ore": ["Glowing", 8],
    "Minosium Ore": ["Glowing", 8],
    "Morganium Ore": ["Rock", 8],
    "Persephonite": ["Glowing", 8],
    "Pyrrhotite Gneiss": ["Hydrocarbon", 8],
    "Raw Acheronite": ["Hydrocarbon", 8],
    "Raw Alunite": ["Rock", 8],
    "Raw Charybdis Voidstone": ["Crystal", 8],
    "Raw Meteoric Diamond": ["Crystal", 8],
    "Raw Mica": ["Hydrocarbon", 8],
    "Raw Scyllan Diamond": ["Crystal", 8],
    "Raw Tincal": ["Rock", 8],
    "Raw Voidgem": ["Crystal", 8],
    "Vanirum Ore": ["Rock", 8],
    "Yunieon Gas": ["Gas", 8],
    "Abaddon Ashes": ["Hydrocarbon", 9],
    "Aesirium Ore": ["Rock", 9],
    "Asmodeusium Ore": ["Rock", 9],
    "Astralite": ["Hydrocarbon", 9],
    "Balderium Ore": ["Rock", 9],
    "Crude Rutha": ["Hydrocarbon", 9],
    "Etherion": ["Gas", 9],
    "Grail Water": ["Hydrocarbon", 9],
    "Kronosite": ["Glowing", 9],
    "Modredium Ore": ["Rock", 9],
    "Nova Dust": ["Crystal", 9],
    "Noxion": ["Gas", 9],
    "Pagion": ["Gas", 9],
    "Raw Erebusite": ["Hydrocarbon", 9],
    "Raw Promethium": ["Rock", 9],
    "Raw Star Ore": ["Rock", 9],
    "Raw Tiberium Crystals": ["Crystal", 9],
    "Raw Wormstone": ["Crystal", 9],
    "Star Ash": ["Crystal", 9],
    "Thothium Ore": ["Hydrocarbon", 9],
    "Troseki": ["Rock", 9],
    "Ziosite": ["Hydrocarbon", 9]
}

"""
Error List:
    Raw Erebusite comes from Hydrocarbon, not Crystal
    Raw Charon Crystal comes from Glowing, not Crystal?
"""

"""THis list is also defined in functions.php and map_script.js, update all 3!

$NAV_TYPE_MAP_BASE = [
    "Normal Nav" => 0,
    "Hidden Nav" => 1,
    "Normal Gate" => 2,
    "Faction Gate" => 3,
    "Normal Station" => 4,
    "Faction Station" => 5,
    "Planet" => 6,
    "Landable Planet" => 7,
    "Weft" => 8,
    "Extended Weft" => 9,
    "Ore Field" => 10
];
"""

def createDB(db_cur):
    sql = """CREATE TABLE raw_roids(
        roid_id INTEGER PRIMARY KEY,
        sector_name TEXT NOT NULL,
        x INTEGER NOT NULL,
        y INTEGER NOT NULL,
        z INTEGER NOT NULL,
        source_type TEXT CHECK(source_type IN ('Rock','Glowing','Hydrocarbon','Crystal','Gas','Hulk')) NOT NULL,
        level INTEGER NOT NULL CHECK(level IN (1,2,3,4,5,6,7,8,9)))"""
    
    db_cur.execute(sql);
    
    sql = """CREATE TABLE raw_roid_contents(
        raw_roid_id INTEGER NOT NULL, 
        roid_held TEXT NOT NULL,
        quantity INTEGER NOT NULL,
        FOREIGN KEY (raw_roid_id) REFERENCES raw_roids(roid_id) ON DELETE CASCADE)"""
        
    db_cur.execute(sql);

def getNextID(db_cur, table_name, id_col_name):
    db_cur.execute(f"""SELECT IFNULL(MIN(t1.{id_col_name} + 1),1) AS next_available_id 
        FROM {table_name} t1 LEFT JOIN {table_name} t2 ON t1.{id_col_name} + 1 = t2.{id_col_name} 
        WHERE t2.{id_col_name} IS NULL;""")
    return db_cur.fetchone()[0]

def addDataToDB(db_cur, roid_details, mining_details):
    #Check if the roid is already in the DB
    db_cur.execute("SELECT roid_id FROM raw_roids WHERE sector_name = ? AND x = ? AND y = ? AND z = ? AND source_type = ? AND level = ?", roid_details)
    row = db_cur.fetchone()
    roid_id = 0
    if row:
        roid_id = row[0]
    else:
        roid_id = getNextID(db_cur, "raw_roids", "roid_id")
        final_roid_details = (roid_id,) + roid_details
        db_cur.execute('INSERT INTO raw_roids (roid_id, sector_name, x, y, z, source_type, level) VALUES (?,?, ?,?,?, ?,?)', final_roid_details)
    
    if mining_details:
        final_mining_details = (roid_id,) + mining_details
        db_cur.execute("INSERT INTO raw_roid_contents(raw_roid_id, roid_held, quantity) VALUES (?,?,?)", final_mining_details)
#end addDataToDB

def parse_log(file_path, channel_name, player_name):
    results = {}

    db_conn = sqlite3.connect(":memory:")
    #db_conn = sqlite3.connect("testing.db")
    db_conn.row_factory = sqlite3.Row
    db_cur = db_conn.cursor()
    
    createDB(db_cur)

    sector_pattern = re.compile(r"We have entered (.+?) Sector \((.+?)\)")
    target_pattern = re.compile(r"\[" + re.escape(channel_name) + "] " + re.escape(player_name) + r": Target '(.+?)' at \(([-\d.]+), ([-\d.]+), ([-\d.]+)\)")
    target_with_level_pattern = re.compile(r"\[" + re.escape(channel_name) + "] " + re.escape(player_name) + r": ([-\d.]+) Target '(.+?)' at \(([-\d.]+), ([-\d.]+), ([-\d.]+)\)")
    prospect_pattern = re.compile(r"COMPUTER: Prospected \(([-\d.]+)\) (.+?)$")
    roid_level_pattern = re.compile(r"\[(\d+)\] " + re.escape(player_name) + r": ([-\d.]+) Target '")

    current_sector = ""
    current_roid_level = 0
    current_roid = None
    current_roid_ingame_type = None
    roid_contents = []
    with open(file_path, 'r', encoding='latin-1') as file:
        for line in file:
            sector_match = sector_pattern.search(line)
            if sector_match:
                sector_name = sector_match.group(1)
                system_name = sector_match.group(2)
                current_sector = sector_name
                current_roid_level = 0
                current_roid = None
                current_roid_ingame_type = None
                #print(f"We have entered {sector_name} ({system_name})")

            roid_level_match = roid_level_pattern.search(line)
            if roid_level_match:
                current_roid_level = roid_level_match.group(2)

            hulk_match = target_with_level_pattern.search(line)
            target_match = target_pattern.search(line)
            
            if (hulk_match or target_match) and current_roid is not None:
                if current_roid_ingame_type != 'Hulk':
                    #Run through once to find max level ore in roid, but not for hulks.
                    for contents in roid_contents:
                        if current_roid[5] < RESOURCE_SOURCE_MAP[contents[0]][1]:
                            current_roid[5] = RESOURCE_SOURCE_MAP[contents[0]][1]
                #and again to actually update db
                for contents in roid_contents:
                    addDataToDB(db_cur, tuple(current_roid), contents)
                roid_contents = []
            
            if hulk_match:
                target_level = hulk_match.group(1)
                target_name = hulk_match.group(2)
                x_coord = int(round(float(hulk_match.group(3)),0))
                y_coord = int(round(float(hulk_match.group(4)),0))
                z_coord = int(round(float(hulk_match.group(5)),0))

                current_roid = [sector_name, x_coord,y_coord,z_coord, target_name, target_level]
                current_roid_ingame_type = target_name
                
            if target_match:
                target_name = target_match.group(1)

                x_coord = int(round(float(target_match.group(2)),0))
                y_coord = int(round(float(target_match.group(3)),0))
                z_coord = int(round(float(target_match.group(4)),0))
                
                current_roid = [sector_name, x_coord,y_coord,z_coord, None, 0]
                current_roid_ingame_type = target_name
               
            prospect_match = prospect_pattern.search(line)
            if prospect_match and current_roid is not None:
                quantity = prospect_match.group(1)
                ore_name = prospect_match.group(2)
                if ore_name in RESOURCE_SOURCE_MAP:
                    roid_type = RESOURCE_SOURCE_MAP[ore_name][0]
                    roid_type_ingame = ""
                    
                    if roid_type == "Rock" or roid_type == "Glowing":
                        roid_type_ingame = "Asteroid"
                    elif roid_type == "Crystal":
                        roid_type_ingame = "Crystalline Asteroid"
                    elif roid_type == "Gas":
                        roid_type_ingame = "Gas Cloud"
                    elif roid_type == "Hydrocarbon":
                        roid_type_ingame = "Hydrocarbon Deposit"
                    else:
                        roid_type_ingame = roid_type
                    
                    if current_roid_ingame_type != roid_type_ingame:
                        print(f"INVALID SOURCE ERROR: {current_roid} has contents {ore_name} which should come from {roid_type} type roids.")
                        sys.exit(1)
                        
                    current_roid[4] = roid_type
                
                roid_contents.append((ore_name, quantity))
                

    db_conn.commit()
    
    db_cur.execute("Select * from raw_roids LEFT JOIN raw_roid_contents on roid_id = raw_roid_id")
    rows = db_cur.fetchall()
    
    the_json = dict()
    
    prev_roid_id = None
    for row in rows:
        # sys.stdout.write("DEBUG: ")
        # for data in row:
            # sys.stdout.write(f",{data} ")
        # sys.stdout.write("\n")
    
        if row['sector_name'] not in the_json:
            the_json[row['sector_name']] = dict()
        
        if row['source_type'] not in the_json[row['sector_name']]:
            the_json[row['sector_name']][row['source_type']] = []
        
        roid_details = { "level": row['level'], "coords": [row['x'],row['y'],row['z']] }
        
        if row['roid_held'] is not None:
            if 'contents' not in roid_details:
                roid_details['contents'] = dict()
            roid_details['contents'][row['roid_held']] = row['quantity']
        
        if row['roid_id'] != prev_roid_id:
            the_json[row['sector_name']][row['source_type']].append(roid_details)
        else:
            if row['roid_held'] in the_json[row['sector_name']][row['source_type']][-1]['contents']:
                the_json[row['sector_name']][row['source_type']][-1]['contents'][row['roid_held']] += row['quantity']
            else:
                the_json[row['sector_name']][row['source_type']][-1]['contents'][row['roid_held']] = row['quantity']
        prev_roid_id = row['roid_id']
            
    #print(json.dumps(the_json, indent=4))
    print(json.dumps(the_json))
    #print(the_json)
    #print(format_output(the_json))

def format_output(data):
    formatted_output = "{"
    for sector in data:
        formatted_output += f'"{sector}": {{\n'
        for roid_type in data[sector]:
            formatted_output += f'\t"{roid_type}": [\n'
            for inner_data in data[sector][roid_type]:
                formatted_output += f'\t\t{{\n'
                for key in inner_data:
                    formatted_output += f'\t\t\t"{key}": {inner_data[key]},\n'
                formatted_output = formatted_output[:-2] + "\n\t\t},\n"
            formatted_output = formatted_output[:-2] + "\n\t],\n"
        formatted_output = formatted_output[:-2] + "\n},\n"
    # Remove the trailing comma and newline character for the last line
    formatted_output = formatted_output[:-2] + "}\n"
    formatted_output = formatted_output.replace("'",'"')
    return formatted_output

if __name__ == "__main__":
    parser = argparse.ArgumentParser(description="Parse log file")
    parser.add_argument("file", help="Path to the log file")
    parser.add_argument("--channel", default="100", help="Channel name (default: [100])")
    parser.add_argument("--player", default="Doctorje", help="Player name (default: Doctorje)")
    args = parser.parse_args()

    parse_log(args.file, args.channel, args.player)

"How do I initialize this project?"

1. I assume you are on linux and can get a basic PHP running on your own.
2. sqlite3 better_map.db
3. .read initialization_data/base_schema.sqlite_3
4. .read initialization_data/3_10_data_import.sql
5. cat initialization_data/mining_data_1
   1. Press "Add Ores", paste in the JSON, submit.
6. cat initialization_data/mining_data_2
   1. Press "Add Ores", paste in the JSON, submit.
7. Edit get_missing_item.php and put in your net-7 username/password. Yes I know that 'isn't secure'. This is a one-person app that I'm likely to be the only user of. It's fine for that. If you do it 'for real', then make it better.
   1. Only needed if you want it to auto-fetch missing items (from Hulks) that are not currently in your DB.
8. You should be good to go.
   1. The sector_data files are there as backups, in case the 3_10 import fails for some reason, or if you want to debug/test the JSON nav import feature.

NOTE FOR 9_13_2025_backup.7z: This uses the same database as the 4_28 backup previously posted. if your database contains newer data, be sure to NOT overwrite it with better_map.db contained within!

9_13_2025_backup.7z

Could you (GMs) please clarify why my OL 84 character was removed from the Paramis sector? I understand the reasoning behind preventing high-level players from camping triggers, but in this case it was an alt I’m still leveling and not a toon that could realistically take on GoBB or the Controller.

I’d really appreciate if the GM team could elaborate a bit more on the decision so I can better understand the rules and avoid issues in the future.

Thanks in advance.

To use it, simply download the teamspeak client here

and enter the server address.

We are using Teamspeak 3

Server Address: TS.Net-7.org:9987

if that address doesn't work, try play.net-7.org:8760

--Kyp--
You should only need to direct client at 'ts.net-7.org' to connect now, TS has been repaired and is now fully functional behind the firewall.

I don't care if it's something that costs me money, either. Trade runs bring in reliable income but I can make money, I'm looking for experience.

Thanks for any info