Spring RTS Engine

Code: Select all

name=Commander;unitname=ARMCOM;

Code: Select all

[CANBUILD]{[ARMCOM]{canbuild1=ARMSOLAR;canbuild2=ARMWIN;}}

Code: Select all

Unit Table:
  id - Not used for anyhting, just the key
  unitname - The unitname of the unit. ARMCOM for the commander, ect. Read from the FBI files
  stat - the name of the property. 'description' for 'description=Commander'
  value - the value of the property. 'Commander' for 'description=Commander'

Code: Select all

| id | unitname | stat       | value     |
+------+----------+------------+---------+
| 1  | ARMCOM   | name       | Commander |
| 2  | ARMCOM   | unitname   | ARMCOM    |
| 3  | ARMCOM   | metalcost  | 12345     |
| 4  | ARMCOM   | energycost | 234567    |
| 5  | CORCOM   | name       | Commander |
| 6  | CORCOM   | untiname   | CORCOM    |

Code: Select all

function ParseFile($fileString)
  {
  
  $file = array();
  
    //Loop through each character in the file
  for ($i++ while $i < strlen($fileString))
    {
    $chr = character $i in $fileString;
    switch ($chr)
      {
        //Begining of a [section]
      case "[": 
        $sectionName = string between $i and the next "]";
        $newFileString = string between $i and the closing '}';
        $file[$sectionName] = ParseFile($newFileString);
        $i = position of the closing "}"
        
        //Its a setting.
      default:
        $setting = string betweem $i and the next ";";
        $file[bit before the "="] = bit after the "=";
        $i = position of the ";"l
      }
    }
  }

Code: Select all

$file = Array
  (
  Setting1 = Value;
  Setting2 = Value;
  Section = Array
    (
    Setting3 = Value;
    Setting4 = Value;
    )
  )

Code: Select all

... ARMCOM ...
... ARMCOM ...
... ARMCOM ...
...

Code: Select all

| id | unitname
+------+----------+
| 1  | ARMCOM
| 2  | CORCOM

Code: Select all

| id | idOfUnitToWhichRefers | stat       | value     |
+--+----+------------+---------+
| 1  | 1   | name       | Commander |
| 2  | 1   | unitname   | ARMCOM    |
| 3  | 1   | metalcost  | 12345     |
| 4  | 1   | energycost | 234567    |
| 5  | 1   | name       | Commander |
| 6  | 1   | untiname   | CORCOM    |

Code: Select all

select Table2.* from ComplexJoinSyntax where Table1.Name = 'CORCOM';

Code: Select all

[CANBUILD]{[ARMCOM]{canbuild1=ARMSOLAR; /*comments in the middle!*/ canbuild2=ARMWIN;}}

Code: Select all

SELECT * FROM Table1 WHERE name= 'armcom';

Code: Select all

SELECT name
FROM first_table
INNER JOIN second_table
ON first_table.keyfield = second_table.foreign_keyfield;