1,498
edits
User talk:Zawza46: Difference between revisions
→Weapons (KHD) sandboxes
| (2 intermediate revisions by 2 users not shown) | |||
| Line 25: | Line 25: | ||
::[[User:Zawza46]] <small>([[User talk:Zawza46|talk]])</small> 21:03 January 28 2024 (UTC) | ::[[User:Zawza46]] <small>([[User talk:Zawza46|talk]])</small> 21:03 January 28 2024 (UTC) | ||
::Alright. I'm not sure what image sizes would be best, so for now I'll add them in 30px and we can work them out later. [[User:Immblueversion|Immblueversion]] ([[User talk:Immblueversion|talk]]) 14:18, 29 January 2024 (UTC) | ::Alright. I'm not sure what image sizes would be best, so for now I'll add them in 30px and we can work them out later. [[User:Immblueversion|Immblueversion]] ([[User talk:Immblueversion|talk]]) 14:18, 29 January 2024 (UTC) | ||
A little while back, I got the Magic and Defense stats backwards on the sandbox, since I was following the in-game stat order and ''Ultimania'' guide (Magic before Defense) instead of what's on [[Template:InfoWeapon358]] (Defense before Magic). I've already fixed them all to match the sandbox categories, but do you think they should be listed by in-game order after all? If so, I volunteer to change it. | |||
For consistency, [[Template:InfoWeapon358]] can easily be changed just by swapping the Magic and Defense categories, and all the weapon pages will fix themselves. [[User:Immblueversion|Immblueversion]] ([[User talk:Immblueversion|talk]]) 17:52, 14 February 2024 (UTC) | |||
:The idea was thrown around in Discord, and it seems like using game/Ultimania order is ideal (actually, the accessory infobox does that already, not sure why Keyblades were different to begin with). But I'd rather not make you, Zawza, or anyone else manually swap hundreds of columns in a page 250,000 bytes large, so I wrote an excel formula real quick to do it for us automatically. | |||
::<small>Putting this in small text, since I doubt anyone knows or cares about Excel stuff, but if you were curious: I made it copy every line and swap the order only if the current row is a certain number of lines after the ''nihongo'' template. The exact formula, shown here for line 50, is: <code>=IF(OR(ISNUMBER(SEARCH("nihongo",A45)),ISNUMBER(SEARCH("nihongo",A46)))),A52,IF(OR(ISNUMBER(SEARCH("nihongo",A43)),ISNUMBER(SEARCH("nihongo",A44))),A48,A50))</code>. Such is the joy of working with spreadsheets.</small> | |||
:Anyway, the sandbox should be all good to go. —<span style="font-family:'Times New Roman'; font-size:110%>[[User:Aid1043|<span style="color:#9932CC">Aid</span>]][[User talk:Aid1043|<span style="color:#9932CC">1043</span>]]</span> 07:03, 15 February 2024 (UTC) | |||
::That was swell of you. Thanks! [[User:Immblueversion|Immblueversion]] ([[User talk:Immblueversion|talk]]) 13:08, 15 February 2024 (UTC) | |||