load_region_table.php

Go to the documentation of this file.

<?php
 
// Passwords for the database are stored outside of the webserver accessible directories to improve security.
// Ensure that passwor file has the correct permission to read, but not be written.
include '/usr/local/share/brigadoon/apache/os_passwords.php';
 
    //#############################################################################################################
    //# OPEN A DATABASE
    //#############################################################################################################
    function rdOpenDatabase($Database, $Host, $Username, $Password)
    {
        // Data Source Name (DSN) string
        $dsn = "mysql:host=$Host;dbname=$Database;charset=utf8mb4";
 
        // Set PDO options for better error handling and security
        $options = [
                PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION, // Throw exceptions on errors
                PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,       // Set default fetch mode to associative array
                PDO::ATTR_EMULATE_PREPARES   => true,                  // Disable emulated prepares for better security
               ];
 
        try
        {
            // Create a new PDO connection instance
            $pdo = new PDO($dsn, $Username, $Password, $options);    
        }
        catch (PDOException $e)
        {
            // Catch the exception and display a user-friendly error message
            // In a production environment, you might log the specific error
            
            die("FAILURE=DATABASE:Connection failed " . $e->getMessage());
        }
        
        return $pdo;
    }

function rdSaveRegion($Parameters, $Pdo)
{
    $sql_query  = "INSERT INTO ls_os_support.ls_os_region (";
 
    $sql_query .= " lor_name, lor_location_x, lor_location_y, lor_size_x, lor_size_y, lor_size_z,";
    $sql_query .= " lor_uuid, lor_map_uuid, lor_edge_upper, lor_edge_lower, lor_edge_left, lor_edge_right";
 
    $sql_query .= ")VALUES(";
 
    $sql_query .= " :lor_name, :lor_location_x, :lor_location_y, :lor_size_x, :lor_size_y, :lor_size_z,";
    $sql_query .= " :lor_uuid, :lor_map_uuid, :lor_edge_upper, :lor_edge_lower, :lor_edge_left, :lor_edge_right";
    
    $sql_query .= ");";
    
    try
    {
        $stmt = $Pdo->prepare($sql_query);
        $stmt->execute($Parameters);
    }
    catch (Exception $e)
    {
        echo("FAILURE=EXTRACT:".$e->getMessage()."\n");
    }
 
}
 
 
/***************************************************************************************************
 *              PROGRAM ENTRY
 ***************************************************************************************************/
 
// Connect to the Support Database
$pdo = rdOpenDatabase($db, $host, $db_username, $db_password);
 
$region_data = [];
 
// Set the Source File for the Conversion and Check it exists. Die if it doesn't exist
$source_file = "/opt/ls_opensim/bin/Regions/Regions.ini";
 
// Read the Source File into an Array
$lines = file($source_file, FILE_IGNORE_NEW_LINES);
$array_size = count($lines);
 
// Step through the Array Line by Line
for ($index = 0; $index < $array_size; $index++)
{
    //Only Process Lines that aren't blank or a comment
    $line = $lines[$index];
    if (!(($line == "") || ($line[0] == ";")))
    {
        //NOTE: The key names in the array match the names used for character substituitions in
        // the SQL insertion command.
         
        // Process a new Region. If a line starts with a '[' character, it is a new region
        if ($line[0] == "[")
        {
            // Clear out the Region Buffer Array
            $region_data = [];
            
            // Extract the Region name
            $region_data['lor_name'] = substr($line, 1, -1);
        }
        
        // If it isn't Region Start, add Infor into the Buffer Array
        else
        {
            // Split the String by the = character
            $key_value_array = explode("=", $line);
            $key = trim($key_value_array[0]); $value = trim($key_value_array[1]);
            
            // Extract the Relevant Items
            switch($key)
            {
                // Extract the UUID of the Array. This UUID can be used to link the Region Name
                // to data in the OpenSim tables 
                case "RegionUUID":
                    $region_data['lor_uuid'] = $value;
                break;
                
                // Get the Bottom Left Corner of the Region.
                case "Location":
                    $location_array = explode(",", $value);
                    $region_data['lor_location_x'] = $location_array[0];
                    $region_data['lor_location_y'] = $location_array[1];
                break;
 
                // Get the X size of the Region in Metres
                case "SizeX":
                    $region_data['lor_size_x'] = $value;
                break;
                
                // get the Y Size of the Region in Metres
                case "SizeY":
                    $region_data['lor_size_y'] = $value;
                break;
                
                // Get the Z Sizeo f the Region
                case "SizeZ":
                    $region_data['lor_size_z'] = $value;
                break;
                
                // Get the UUID of a Static Map Tile
                case "MaptileStaticUUID":
                    $region_data['lor_map_uuid'] = $value;
                break;
                
                // The Default landing Position is not store in the Region Table, but it does indicate that this
                // is the end of the Entry for the Region. Once the end is reached, the boundaries of the Region in
                // global units are calculated. This allows for easy testing to determine which Region in which a
                // global position is located. It also makes conversion between global and local positions easier.
                case "DefaultLanding":
                    $region_data['lor_edge_lower'] = (float)$region_data['lor_location_y'] * 256.0;
                    $region_data['lor_edge_upper'] = (float)$region_data['lor_edge_lower'] + (float)$region_data['lor_size_y'];
                    $region_data['lor_edge_left']  = (float)$region_data['lor_location_x'] * 256.0;
                    $region_data['lor_edge_right'] = (float)$region_data['lor_edge_left']  + (float)$region_data['lor_size_x'];
 
                    // Save the Region to the Table
                    rdSaveRegion($region_data, $pdo);
                break;
            }
        }
    }       
}
 
?>