Distances in the Solar system is vast, almost beyond comprehension for the typical mortal mind. The distance from New York to Los Angeles are just under 4,000 km. This can be done in 2 to 3 days if travelling by land, or roughly 5 hours by air. The distance from Earth to the Moon is on average around 380,000 km. With current spacecrafts this takes around 3 days. Mars is 6 – 9 months depending on the relative positions of the planets. And it only gets worse from here. The average distances from the Sun to the planets in the solar system is shown here in millions of kilometers, and is very rounded up/down. If two planets are on opposite sides of the Sun, the distances between the two will actually be the sum of the distance to the Sun for each of them.
Thomas Due Tdue21
Tdue21
/ speeds-and-distances.md
Created
July 12, 2025 16:26
Distances and Speeds in Trinity Continuum: Æon
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <# | |
| .SYNOPSIS | |
| Tail command for show the last lines of a file. | |
| .PARAMETER Path | |
| File to tail. | |
| .PARAMETER Lines | |
| Number of lines to show. Default is 20. |
Tdue21
/ SBO_ItemsWithQueryGroups.SQL
Last active
October 14, 2021 11:22
An UNPIVOT example that makes it possible to list items with enabled query groups more readable.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| declare @itemCode NVARCHAR(30) = ''; | |
| WITH ItemQueryGroups AS ( | |
| SELECT ItemCode, QueryGroup, QueryEnabled FROM ( | |
| SELECT ItemCode, | |
| QryGroup1 AS [1], QryGroup2 AS [2], QryGroup3 AS [3], QryGroup4 AS [4], QryGroup5 AS [5], QryGroup6 AS [6], QryGroup7 AS [7], QryGroup8 AS [8], | |
| QryGroup9 AS [9], QryGroup10 AS [10], QryGroup11 AS [11], QryGroup12 AS [12], QryGroup13 AS [13], QryGroup14 AS [14], QryGroup15 AS [15], QryGroup16 AS [16], | |
| QryGroup17 AS [17], QryGroup18 AS [18], QryGroup19 AS [19], QryGroup20 AS [20], QryGroup21 AS [21], QryGroup22 AS [22], QryGroup23 AS [23], QryGroup24 AS [24], | |
| QryGroup25 AS [25], QryGroup26 AS [26], QryGroup27 AS [27], QryGroup28 AS [28], QryGroup29 AS [29], QryGroup30 AS [30], QryGroup31 AS [31], QryGroup32 AS [32], | |
| QryGroup33 AS [33], QryGroup34 AS [34], QryGroup35 AS [35], QryGroup36 AS [36], QryGroup37 AS [37], QryGroup38 AS [38], QryGroup39 AS [39], QryGroup40 AS [40], |
Tdue21
/ CalcMod10.sql
Created
October 7, 2021 08:00
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT SSCC = SequenceNo + -- SequenceNo MUST be 17 digits. | |
| CAST((10 - ( | |
| (CAST(SUBSTRING(SequenceNo, 1, 1) AS INT) * 3) + -- Step 1: Multiply value of each odd position by 3 and even position by 1. | |
| (CAST(SUBSTRING(SequenceNo, 2, 1) AS INT) * 1) + -- Step 2: Add the results together | |
| (CAST(SUBSTRING(SequenceNo, 3, 1) AS INT) * 3) + -- Step 3: Substract the modulus of 10 from 10. | |
| (CAST(SUBSTRING(SequenceNo, 4, 1) AS INT) * 1) + -- | |
| (CAST(SUBSTRING(SequenceNo, 5, 1) AS INT) * 3) + -- Example: | |
| (CAST(SUBSTRING(SequenceNo, 6, 1) AS INT) * 1) + -- Value: 31111111276080386(8) | |
| (CAST(SUBSTRING(SequenceNo, 7, 1) AS INT) * 3) + -- Multiply: | |
| (CAST(SUBSTRING(SequenceNo, 8, 1) AS INT) * 1) + -- 3 1 1 1 1 1 1 1 2 7 6 0 8 0 3 8 6 |
Tdue21
/ SqlServerTableSizes.sql
Created
June 26, 2021 16:41
Shows list all tables in current databases with row sizes for each.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- ********************************************************************* | |
| -- Shows list all tables in current databases with row sizes for each. | |
| -- ********************************************************************* | |
| -- Temporary table for storing information | |
| declare @t1 table ( | |
| TableName nvarchar(50) not null, | |
| RowSize int not null default 0, | |
| [RowCount] int not null default 0, |
Tdue21
/ ModListSwitcher.ps1
Created
February 1, 2020 19:38
Powershell script for switching between various modlists for Conan Exiles servers.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Param( | |
| [string]$fileName = $null, | |
| [string]$uri = "https://gist.githubusercontent.com/Tdue21/3aff4a285071a234589bdc1cc05b64c4/raw/", | |
| [string]$hostAddress = $(throw "HostAddress parameter is required."), | |
| [string]$hostPort = $(throw "HostPort parameter is required.") | |
| ) | |
| $modPath = "$PSScriptRoot\Mods\" | |
| $destination = Join-Path $modPath -ChildPath "modlist.txt" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| *..\..\..\..\workshop\content\440900\880454836/Pippi.pak | |
| *..\..\..\..\workshop\content\440900\925197087/DyeMoreBetterer.pak | |
| *..\..\..\..\workshop\content\440900\1699858371/DungeonMasterTools.pak | |
| *..\..\..\..\workshop\content\440900\1407413080/CNC.pak | |
| *..\..\..\..\workshop\content\440900\1657329055/WdV_Tattoo_und_Narben.pak | |
| *..\..\..\..\workshop\content\440900\2010870025/HighHeels.pak | |
| *..\..\..\..\workshop\content\440900\1934607107/DudesDelightfulDecorations.pak | |
| *..\..\..\..\workshop\content\440900\1393280692/Barbare.pak | |
| *..\..\..\..\workshop\content\440900\1966733568/immersivearmor.pak | |
| *..\..\..\..\workshop\content\440900\933782986/ExilesExtreme.pak |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Preparing to run build script... | |
| Running build script... | |
| Module directory does not exist. | |
| NuGet.config not found. | |
| Analyzing build script... | |
| Analyzing C:/Development/Work/XXXX/Trunk/Build/Build.cake... | |
| Analyzing C:/Development/Work/XXXX/Trunk/Build/Classes.cake... | |
| Analyzing C:/Development/Work/XXXX/Trunk/Build/Utilities.cake... | |
| Processing build script... | |
| Installing addins... |
Tdue21
/ gist:1a66ef2549e1b647d69909b6d59803ff
Created
June 7, 2018 08:01
RegEx for removing pattern from end of line
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Remove file info from end of line from search result from FileLocator Lite. | |
| \.csproj(.*)$ |