User:MvGulik/tmp
Jump to navigation
Jump to search
No Skills
No skill required (Technically!) (those that are not marked as such already):
(Assuming same for repairing)
- Log Cabin
- Timber House
- Stone Mansion
- Stonestead
- Igloo
- Demijohn
- Sturdy Bed
- Cottage Table
- Rustic Table
- Rustic Chair
- Cloth Chair
- Cottage Throne
- Ram Chair
- Royal Throne
- Arched Chair
- Long Bench
- Fine Sofa
- Garden Bench
- Rocking Chair
- Cushioned Stool
- Royal Stool
- Snowball
- Cold Cut
- Stinging Poultice
- Gray Grease
- Horrible Knot
- Itsy Bitsy Weaver
- Primitive Doll
- Roast Meat
- Roasthopper
- Wooden Shovel
- Chitin Sequins
- (Leather Pocket)
+Foraging Skill: scanned/fixed. +Pottery: scanned
- Lay Brick Paving
+Stone Working:
- Lay Stone Paving
-- Bye bye W14.
image overlaying
- Preferring case (c).
- Actually: Case (c) seems not needed for inventory related images. As these dual image-types are probably only used inside the crafting UI.
- That leaves, a somewhat nasty, vertical offset difference when using non "Overlay-icon" style overlay images.
Gems q10 table test
- Crappy wikitable buggers:
- 1) Breaks "<br>" inside the cells-content breaks simple copy and paste actions on the displayed table. Data that would normally be in one line(row) is now put on multiple lines. (only solution: not using html-breaks. :-/ )
- 2) Any content in the cell-style part ("|foobar|<cell content>" vs "||<cell content>" breaks the tabletool tool processing. (among other issues)
- Only known potential solution would be creating(coding) a dedicated wiki-table code processor. :-/
- A simple Tab-delimited output could work if it strips any html-breaks. CSV (comma-delimited & quoted-text) output would probably be nicer.
[Show/hide] Probably not useful to others.
- Spreadsheet related data: (specific to these Gem tables)
- Strip mediawiki table-code down to data only:
- "
=REGEX(REGEX(REGEX(REGEX(REGEX(REGEX(REGEX(REGEX(REGEX(REGEX(REGEX("
A1,"!\s*scope=""row""\s*\|\s*","","g")
,"style=""background-color:#d8fbd8;""","","g")
,"\?","?","g")
,"\n\|<!-.*->\|\s*","@","g")
,"(\[\[|\]\])","","g")
,"\s*
\s*"," ","g")
,"\s*\|\}\s*","
","g")
,"\|-.*\n","","g")
,"\s*\{\|.*\s*","
","")
," *!! *","@","g")
,"!\s*","","g")
The "@" character needs to be replace with a comma or a Tab. (Tab did no work on my end, and finding the right comma if I used that here ... yea.)
+ There are two data line-breaks. As the used application simply did not support "\n" and "\t" as replacement code (which blows my mind).
- "
- Strip mediawiki table-code down to data only:
- Turning spreadsheet table data back into mediawiki code.
- Merged initial (semi)raw-data input (partial of full table data):
- "...
! scope="row" | Jotun
|<!--Rough....-->| ?
|<!--Smooth...-->| Constitution +6 Agility +3
|<!--Cabochon.-->| # Constitution +12 Agility +6 Farming +12
..."
- "...
- Final process:
- "
=REGEX(REGEX(REGEX(REGEX("
F19,"(?i)([a-z]+( [a-z]+)?) ?\+([0-9?]+) ?(,?)","$1 +$3 <br> ","g")
," ?<br> ?([|\n])","$1","g")
,"\?","<b style=""color:red;"">\?","g")
,"\| ?\# ?\[\[","style=""background-color:#d8fbd8;""| [[","g")
- "
- Merged initial (semi)raw-data input (partial of full table data):



