Databaseinfo

Structure of database

Database of blocks is transformed from game datafiles. Two file (Main and Sub) are generated to reduce case by blocks. Template:Db/Version/0.xxx.xxx/file

'"DbParser"' rename unwanted type, handle image options and send to '"Db"' '"Db"' choose the page (Main and Sub) who have the requested data and ask to Version wich version (folder ) go to. '"Version"' give '"LastVersion"'or the version ask. '"LastVersion"' store the default version. '"Main"' and '"Sub"' are stored in 0.xxx.xxx and share data of each blocks to light process.

Update Database

You have to create a page Db/Version/0.xxx.xxx of the number of version.
You have to get '"Main"' and '"Sub"' page in the new 0.xxx.xxx/ folder done.
You must add version added in '"Version"' page.
If it is the last stable version, you have to put it as default version ( replace in '"LastVersion"' )

get '"Main"' and '"Sub"' page

Regex and xslt are used to transform original files of games. 2 files are needed : BlockConfig.xml and BlockTypes.properties they are in :

linux : $$linuxinstalldir$$/Starmade/data/config
Windows : Program files\Starmade\data\config
Steam : steam\steam\steamapps\common\StarMade\data\config

Make copy of '"BlockConfig.xml"', open this copy and add a line to the start of file (before <config>) copy the content of '"BlockTypes.properties"' to the beginning of '"BlockConfig.xml"' (where you add line). Now you have to use regex to modify this file. You can use https://www.freeformatter.com/regex-tester.html as it allow to handle big text. You have to set option (flags) in regex : only /m and /g. You have to put a regular expression , a text to parse, and a line to replace with. Result on this website can be copy-pasted by click first caracter, go the end of list (scroll bar) and [SHIFT]+ click on last caracter. In all code i write above there is a line of regular expression and one of replace. If no replace line, leave blank (without space).

For xslt you can use : https://xsltfiddle.liberty-development.net/ you content of your file upper left, you past xslt "modifier" upper right, and you get result in bottom left.

Regexp

copy the content of '"BlockConfig.xml"' (get with prorperties on the beginning)

(\n(\w*?)=\d*)(?=[\s\S]*(name="(.*?)".*?type="\2"))

$1=$4

move to end

(Copy the result in the tester field to be parsed !) (#[\s\S]*?(?:\w*?=\d*?)*\s*?)(<Config>[\s\S]*<\/Config>)

$2\r$1

Apply ID and subnames

(Block.*?type=")(\w*?)(?="[\s\S]*?\2=(\d+))|(?:(<Item) count(=)"(\d*)"(>)|(<Element>))(\w*?)(?=<[\s\S]*?\9=\d+=(.*))

$1$4$8$7$3$10$5$6

Fork : work on sub

Now, we have to work on the two futur page separatly. Make two file : one named Main.txt and one named sub.txt (actually with same content) For sub.txt : <\/(?:Item|Element|Chamber.*)>\n\s*<(?:Item>|Element>|Chamber)|(<)(General)(Chamber(>))(\w*).*\n\<Chamber(?=\w)|\n<Element>(.*?)<\/Element>\n(?!<Element)

$1$3$2$4$5$6|

SUB.TXT Remove all data unwanted :

in order : remove all info tag "", starting line white space, remove Useless lines, delete useless data, shorten data names. remove all before and after <element> tags

(No replace here, only remove data)

MAIN.TXT remove data

Xslt

Now we have to remove xml formatting and put categories on the good place. You have to parse both file Main.txt. and Sub.txt

With this two xslt codes (se explain before if needed):

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
	xmlns:xs="http://www.w3.org/2001/XMLSchema"
	exclude-result-prefixes="xs"
	version="3.0">

  <xsl:output method="xml" indent="yes"/>

  <xsl:template match="/*">
      <xsl:copy>
          <xsl:apply-templates select="@*"/>
          <xsl:variable name="sorted-items" as="element(Block)*">
              <xsl:perform-sort select="descendant::Block">
                  <xsl:sort select="@name"/>
              </xsl:perform-sort>
          </xsl:variable>
          <xsl:sequence select="$sorted-items!root(snapshot())"/>
      </xsl:copy>
  </xsl:template>
  
</xsl:stylesheet>

and : (dont forget to copy result in the parse window !)

<xsl:stylesheet version="1.0"  xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:output omit-xml-declaration="yes" indent="yes"/>
    <xsl:strip-space elements="*"/>



    <xsl:template match="*[@* or not(*)] ">
      <xsl:if test="not(*)">
         <xsl:apply-templates select="self::*" mode="path"/>
         <xsl:value-of select="concat('=',., ' ')"/>
         <xsl:text>
</xsl:text>
        </xsl:if>
        <xsl:apply-templates select="@*|*"/>
    </xsl:template>


    <xsl:template match="*" mode="path">
<xsl:choose>
        <xsl:when test="@name">
        <xsl:text>∼∼∼</xsl:text>
        <xsl:value-of select="concat('|', @name, '={{#switch:{{{2}}}')"/>

        </xsl:when>
     <xsl:otherwise>
        <xsl:value-of select="concat('|', name())"/>
   </xsl:otherwise>
</xsl:choose>
    </xsl:template>

    <xsl:template match="@*">
        
<xsl:choose>
        <xsl:when test="name()='name'">
            <xsl:apply-templates select="../ancestor-or-self::*" mode="path"/>
            <xsl:text>
</xsl:text>
            <xsl:value-of select="concat('|link=', ., ' ')"/>
        </xsl:when>
        <xsl:when test="name()='type'">
            <xsl:apply-templates select="self::*" mode="path"/>
	        <xsl:text>
</xsl:text>
            <xsl:value-of select="concat('|', name(), '=', ., ' ')"/>
            <xsl:text>
</xsl:text>
        </xsl:when>
   <xsl:otherwise>
            <xsl:apply-templates select="self::*" mode="path"/>
        	<xsl:text>
</xsl:text>
            <xsl:value-of select="concat('|', name(), '=', ., ' ')"/>
   </xsl:otherwise>
</xsl:choose>
    </xsl:template>
</xsl:stylesheet>

So, now you have Main.txt and Sub.tx without xml formatting Come back to regexp :

Sub.txt : Replace wrong symbole in Chamber created subsection

>

=

Sub.txt make table storage for multivariable blocks Type (consistence, controll(ing/ed), chamber)

\|(Item|CtrlBy|Ctrling|Chamber)=(.*)

|$1=Template:$1box

Main.txt

Write all category in blocks tags and format it a the end (no priority request).

(?<=\|Element)\|(?!Element)(\w*)(?:\|(\w*))?(?:\|(\w*))?(?:\|(\w*))?([\s\S]*?\|Hp=\d*\n)

$5|cat=$1\r|cat2=$2\r|cat3=$3\r|cat4=$4\r

SUB.TXT remove cat

(?<=\|Element)\|(?!Element)(\w*)(?:\|(\w*))?(?:\|(\w*))?(?:\|(\w*))?

MAIN.TXT + SUB.TXT

Divide case in alphabetival nest to light request process \n(\|.*?)?\|Element.*?\W(\|([B-Z])[\s\S]*(?:\n\|Element\|.*?\W\|\3\w*).*)

\r}}\r}}\r|$3=Element)?[\W]{3}(.*\n)\r$2$1\n

Next step on the two files : Remove added position characters, replace by lasts {} and position icon

\|Element.*?[\W]{3}(?=\|)

}}\r

Both MAIN.TXT and SUB.TXT Finally, Write last enclosing fonction.

========

}}([\s\S]*\S)

\r}}

Come back to wiki =

now you have to create a page Main ( in Db/Version/0.xxx.xxx) with content of Main.txt and a page Sub with content of Sub.txt You have to add a line in '"Version"' : -->|0.999.999=0.999.999

Navigation

More

Tools

Namespaces

Views