Databaseinfo - Revision history

Arkahys: version changes, have to change regex code. Add some more explain

2020-04-01T07:31:44Z

version changes, have to change regex code. Add some more explain

Arkahys at 06:19, 1 April 2020

2020-04-01T06:19:37Z

Arkahys: /* Structure of database */

2018-07-28T23:46:24Z

‎Structure of database

Arkahys: /* Structure of database */

2018-07-26T23:55:05Z

‎Structure of database

Arkahys: /* Get the database from game files : */

2018-05-21T16:05:56Z

‎Get the database from game files :

Arkahys: /* Get the database from game files : */

2018-05-21T16:02:52Z

‎Get the database from game files :

Arkahys: /* Sub.txt : make table storage for multivariable blocks Type : consistence,chamber and */

2018-05-16T20:12:45Z

‎Sub.txt : make table storage for multivariable blocks Type : consistence,chamber and

Arkahys: /* Sub.txt : make table storage for multivariable blocks Type : consistence,chamber */

2018-05-16T20:08:20Z

‎Sub.txt : make table storage for multivariable blocks Type : consistence,chamber

Arkahys: /* MAIN.TXT remove data */

2018-05-16T19:51:08Z

‎MAIN.TXT remove data

Arkahys: /* SUB.TXT Remove all data unwanted : */

2018-05-16T19:45:30Z

‎SUB.TXT Remove all data unwanted :

@@ Line 71: / Line 71: @@
 ==== DIVIDE IN TWO FILE, work on sub : order subTable data====
 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)
+create two text file : one named Main.txt and one named sub.txt
 Apply this on sub.txt only :
@@ Line 81: / Line 82: @@
 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
-<pre>\n<Element>(?=[A-Z])|\s*?<(?=!--)[\s\S]*?-->|(?<=\n)\s*?(?=<)|\n.*(?:<Armour>|Consistence\/>|<Hitpoints>|<ArmorEffect[\s\S]*?\/\/ArmorEffect|<StructureHP|<Animate|<InShop|<ReactorH|<Mass|Placable|LightSource|Deprec|<ProducedIn|<BasicResource|<ArmorHP|Transpar|Orientatio|<CubatomCom[\s\S]*?\<\/CubatomCom|<InventoryGroup|<BlockComputerR|<Slab|<StyleId|<ReactorGeneralI|<Enterable|<IndividualS|<HasActivat|<BlockSty|<LightSource>|<RecipeBuyRe[\s\S]*?ipeBuyResource>|<Door>|SensorInput|<ResourceInjec|LightSourceColo|ExtendedText|OnlyDrawnI|LodShapeFr|LowHpSett|FactoryBakeTime|OldHitpoint|CanActivate|Physical).*|(?<=Desc)ription(?=>)|(?<! C)(?<=C)on(?=troll)|(?<! Contr)(?<=Contr)ol|(?<=CombinationControll)er|(?<=Controll)ed(?=By)|(?<=[a-z0-9])<\/Element>\n|(?<=\/Chamber)AppliesTo|(?<=[0-9a-z])<\/Element>\n|Combination(?=Control)|(?<=Exp)losion(?=Absorbtion)|(?<=ExplosionAbsorb)tion|icon="[0-9]*"\s|type=".*?"|<Config>\s|(?<=GeneralChamber>)[\s]*<Chamber>[\s\S]*<\/Chamber>(?=\s*?<Block icon="914")|(?<=\s<\/Element>)\s+<Recipes[\s\S]*</pre>
+<pre>\n<Element>(?=[A-Z])|\s*?<(?=!--)[\s\S]*?-->|(?<=\n)\s*?(?=<)|\n.*(?:<Armour>|Consistence\/>|<Hitpoints>|<ArmorEffect[\s\S]*?\/\/ArmorEffect|<StructureHP|<Animate|<InShop|<ReactorH|<Mass|Placable|LightSource|Deprec|<ProducedIn|<BasicResource|<ArmorHP|Transpar|Orientatio|<CubatomCom[\s\S]*?\<\/CubatomCom|<InventoryGroup|<BlockComputerR|<Slab|<StyleId|<ReactorGeneralI|<Enterable|<IndividualS|<HasActivat|<BlockSty|<LightSource>|<RecipeBuyRe[\s\S]*?ipeBuyResource>|<Door>|SensorInput|<ResourceInjec|LightSourceColo|ExtendedText|OnlyDrawnI|LodShapeFr|LowHpSett|FactoryBakeTime|OldHitpoint|CanActivate|Physical).*|(?<=Desc)ription(?=>)|(?<! C)(?<=C)on(?=troll)|(?<! Contr)(?<=Contr)ol|(?<=CombinationControll)er|(?<=Controll)ed(?=By)|(?<=\|)\s*?<Element>|(?<=\/Chamber)AppliesTo|(?<=[0-9a-z])<\/Element>\n|Combination(?=Control)|(?<=Exp)losion(?=Absorbtion)|(?<=ExplosionAbsorb)tion|icon="[0-9]*"\s|type=".*?"|<Config>\s|(?<=GeneralChamber>)[\s]*<Chamber>[\s\S]*<\/Chamber>(?=\s*?<Block icon="914")|(?<=\s<\/Element>)\s+<Recipes[\s\S]*</pre>

@@ Line 50: / Line 50: @@
 Regex :
-<pre>(\n([\w\(\)]*?)=\d*)(?=[\s\S]*(name="(.*?)".*?type="\2"))</pre>
+<pre>(\n([\w\(\)\\\/]*?)=\d*)(?=[\s\S]*(name="(.*?)".*?type="\2"))</pre>
 Replace with :

@@ Line 2: / Line 2: @@
 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
 <big>'"DbParser"'</big> rename unwanted type, handle image options and send to <big>'"Db"'</big>
-<big>'"Db"'</big> choose the page (Main and Sub) who have the requested data and ask to Version wich version (folder ) go to.
+<big>'"Db"'</big>  (and DbSub) choose the template (Main and Sub, databases) who have the requested data and ask to Version wich version (folder ) go to.
 <big>'"Version"'</big> give <big>'"LastVersion"'</big>or the version ask.
 <big>'"LastVersion"'</big> store the default version.
-<big>'"Main"'</big> and <big>'"Sub"'</big> are stored in 0.xxx.xxx and share data of each blocks to light process.
+<big>'"Main"'</big> and <big>'"Sub"'</big> are stored in 0.xxx.xxx and share data of each blocks to light process.  ie : tempalte/Db/0.201.133/Main
 == Update Database ==

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

@@ Line 43: / Line 43: @@
 Regex :
-<pre>(\n([\w()]*?)=\d*)(?=[\s\S]*(name="(.*?)".*?type="\2"))</pre>
+<pre>(\n([\w\(\)]*?)=\d*)(?=[\s\S]*(name="(.*?)".*?type="\2"))</pre>
 Replace with :
@@ Line 51: / Line 51: @@
 (Copy the result in the tester field to be parsed !)
 Regex :
-<pre>(#[\s\S]*?(?:\w*?=\d*?)*\s*?)(<Config>[\s\S]*<\/Config>)</pre>
+<pre>(#[\s\S]*?(?:[\w\(\)]*?=\d*?)*\s*?)(<Config>[\s\S]*<\/Config>)</pre>
 Replace with :
 <pre>$2\r$1</pre>
@@ Line 58: / Line 58: @@
 ==== Apply ID and subnames ====
 Regex :
-<pre>(Block.*?type=")([\w()]*?)(?="[\s\S]*?\2=(\d+))|(?:(<Item count="\d*">)|(<Element>))(\w*?)(?=<[\s\S]*?\6=\d+=(.*))</pre>
+<pre>(Block.*?type=")([\w\(\)]*?)(?="[\s\S]*?\2=(\d+))|(?:(<Item count="\d*">)|(<Element>))(\w*?)(?=<[\s\S]*?\6=\d+=(.*))</pre>
 Replace with :
 <pre>$5$1$4$7$3</pre>

@@ Line 188: / Line 188: @@
 <pre>|$1$3={{tablebox|{{{1}}}|{{{3}}}|{{{4}}}|$2$4}}</pre>
-nd step :
+still Sub.txt 2nd step :
-<pre>(textureId)=((\|? ?\d*)*)</pre>
+<pre>\|(textureId)=((\|? ?\d+)*) ?</pre>
 <pre>|$1={{3dblock|{{{1}}}|{{{3}}}|{{{4}}}|$2}}</pre>

@@ Line 182: / Line 182: @@
 <pre>|$1={{tablebox|{{{2}}}|{{{3}}}|{{{4}}}|$2}}</pre>
-==== Sub.txt : make table storage for multivariable blocks Type : consistence,chamber ====
+==== Sub.txt : make table storage for multivariable blocks Type : consistence,chamber and ====
 <pre>\|(Item|Chamber)=(.*)</pre>
-<pre>|$1={{tablebox|{{{1}}}|{{{3}}}|{{{4}}}|$2}}</pre>
+<pre>|$1$3={{tablebox|{{{1}}}|{{{3}}}|{{{4}}}|$2$4}}</pre>
 ==== Main.txt ====

@@ Line 80: / Line 80: @@
 ==== MAIN.TXT remove data ====
-<pre>\s*?<(?=!--)[\s\S]*?-->|(?<=\n)\s*?(?=<)|(?<=GeneralChamber>)[\s]*<Chamber>[\s\S]*<\/Chamber>(?=\s*?<Block icon="914")|\n.*(?:Consistence\/>|<Description>|<BasicResourceF|<Consistence[\s\S]*?mConsistence\/|<CubatomCom[\s\S]*?\<\/CubatomCom|<ControlledB[\s\S]*?\/ControlledBy>|<Controlling[\s\S]*?\/Controlling>|<RecipeBuyRe[\s\S]*?ipeBuyResource>|<InventoryGroup|<BlockComputerR|<Slab|<StyleId|<\w*?Chamber\w*?>.*<\/\w*?Chamber\w*?>|<ReactorGeneralI|<Enterable|<InRecip|<IndividualS|<HasActivat|<Door>|SensorInput|<ResourceInjec|ExtendedText|OnlyDrawnI|LodShapeFr|LowHpSett|OldHitpoint|ExplosionAbsorbtion|CombinationController|BlockResourceType|Price|Orientation|CanActivate|Physical|Volume).*|(?<=Hitp)oints|(?<=H)it(?=points>)|(?<=Armo)u(?=r>)|(?<=Armor)Value|\n.*<\/?EffectArmor>|ProducedIn|(?<=Light)Source|(?<=SideTex)turesPointTo(?=Orient)|(?<=SideTexturesPointToOrient)ation|(?<=C)ombinationCon(?=troller)|rmor(?=HPContribution)|A(?=ArmorHPContribution)|(?<=ArmorHP)Contribution|tructure(?=HPContribution)|(?<=StructureHP)Contribution|<Config>|(?<=\s<\/Element>)\s+<Recipes[\s\S]*</pre>
+<pre>\s*?<(?=!--)[\s\S]*?-->|(?<=\n)\s*?(?=<)|(?<=GeneralChamber>)[\s]*<Chamber>[\s\S]*<\/Chamber>(?=\s*?<Block icon="914")|\n.*(?:Consistence\/>|<Description>|<BasicResourceF|<Consistence[\s\S]*?mConsistence\/|<CubatomCom[\s\S]*?\<\/CubatomCom|<ControlledB[\s\S]*?\/ControlledBy>|<Controlling[\s\S]*?\/Controlling>|<RecipeBuyRe[\s\S]*?ipeBuyResource>|<InventoryGroup|<BlockComputerR|<Slab|<StyleId|<\w*?Chamber\w*?>.*<\/\w*?Chamber\w*?>|<ReactorGeneralI|<Enterable|<InRecip|<Door>|SensorInput|<ResourceInjec|ExtendedText|OnlyDrawnI|LodShapeFr|LowHpSett|OldHitpoint|ExplosionAbsorbtion|CombinationController|BlockResourceType|Price|Orientation|CanActivate|Physical|Volume).*|(?<=Hitp)oints|(?<=H)it(?=points>)|(?<=Armo)u(?=r>)|(?<=Armor)Value|\n.*<\/?EffectArmor>|ProducedIn|(?<=Light)Source|(?<=SideTex)turesPointTo(?=Orient)|(?<=SideTexturesPointToOrient)ation|(?<=C)ombinationCon(?=troller)|rmor(?=HPContribution)|(?<=Indiv)idual(?=Sides)|A(?=ArmorHPContribution)|textureId.*?" |(?<=ArmorHP)Contribution|tructure(?=HPContribution)|(?<=StructureHP)Contribution|<Config>|(?<=\s<\/Element>)\s+<Recipes[\s\S]*</pre>
 ==== Xslt====

← Older revision		Revision as of 19:45, 16 May 2018
Line 74:		Line 74:
	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		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

−	<pre>\n<Element>(?=[A-Z])\|\s?<(?=!--)[\s\S]?-->\|(?<=\n)\s?(?=<)\|\n.(?:<Armour>\|Consistence\/>\|<Hitpoints>\|<ArmorEffect[\s\S]?\/\/ArmorEffect\|<StructureHP\|<Animate\|<InShop\|<ReactorH\|<Mass\|Placable\|LightSource\|Deprec\|<ProducedIn\|<BasicResource\|<ArmorHP\|Transpar\|Orientatio\|<CubatomCom[\s\S]?\<\/CubatomCom\|<InventoryGroup\|<BlockComputerR\|<Slab\|<StyleId\|<ReactorGeneralI\|<Enterable\|<IndividualS\|<HasActivat\|<BlockSty\|<LightSource>\|<RecipeBuyRe[\s\S]?ipeBuyResource>\|<Door>\|SensorInput\|<ResourceInjec\|LightSourceColo\|ExtendedText\|OnlyDrawnI\|LodShapeFr\|LowHpSett\|FactoryBakeTime\|OldHitpoint\|CanActivate\|Physical).\|(?<=Desc)ription(?=>)\|(?<! C)(?<=C)on(?=troll)\|(?<! Contr)(?<=Contr)ol\|(?<=CombinationControll)er\|(?<=Controll)ed(?=By)\|(?<=[a-z0-9])<\/Element>\n\|(?<=\/Chamber)AppliesTo\|(?<=[0-9a-z])<\/Element>\n\|Combination(?=Control)\|(?<=Exp)losion(?=Absorbtion)\|(?<=ExplosionAbsorb)tion~~\|textureId="[0-9 ,]"\s~~\|icon="[0-9]"\s\|type=".?"\|<Config>\s\|(?<=GeneralChamber>)[\s]<Chamber>[\s\S]<\/Chamber>(?=\s?<Block icon="914")\|(?<=\s<\/Element>)\s+<Recipes[\s\S]*</pre>	+	<pre>\n<Element>(?=[A-Z])\|\s?<(?=!--)[\s\S]?-->\|(?<=\n)\s?(?=<)\|\n.(?:<Armour>\|Consistence\/>\|<Hitpoints>\|<ArmorEffect[\s\S]?\/\/ArmorEffect\|<StructureHP\|<Animate\|<InShop\|<ReactorH\|<Mass\|Placable\|LightSource\|Deprec\|<ProducedIn\|<BasicResource\|<ArmorHP\|Transpar\|Orientatio\|<CubatomCom[\s\S]?\<\/CubatomCom\|<InventoryGroup\|<BlockComputerR\|<Slab\|<StyleId\|<ReactorGeneralI\|<Enterable\|<IndividualS\|<HasActivat\|<BlockSty\|<LightSource>\|<RecipeBuyRe[\s\S]?ipeBuyResource>\|<Door>\|SensorInput\|<ResourceInjec\|LightSourceColo\|ExtendedText\|OnlyDrawnI\|LodShapeFr\|LowHpSett\|FactoryBakeTime\|OldHitpoint\|CanActivate\|Physical).\|(?<=Desc)ription(?=>)\|(?<! C)(?<=C)on(?=troll)\|(?<! Contr)(?<=Contr)ol\|(?<=CombinationControll)er\|(?<=Controll)ed(?=By)\|(?<=[a-z0-9])<\/Element>\n\|(?<=\/Chamber)AppliesTo\|(?<=[0-9a-z])<\/Element>\n\|Combination(?=Control)\|(?<=Exp)losion(?=Absorbtion)\|(?<=ExplosionAbsorb)tion\|icon="[0-9]"\s\|type=".?"\|<Config>\s\|(?<=GeneralChamber>)[\s]<Chamber>[\s\S]<\/Chamber>(?=\s?<Block icon="914")\|(?<=\s<\/Element>)\s+<Recipes[\s\S]</pre>