Skip to content

Instantly share code, notes, and snippets.

Discover gists

@devitfro
devitfro / multi_table_db_hw
Created February 11, 2025 21:52
USE [master]
GO
/****** Object: Database [Storik] Script Date: 11.02.2025 23:49:06 ******/
CREATE DATABASE [Storik]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'Storik', FILENAME = N'C:\datab\Storik.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON
( NAME = N'Storik_log', FILENAME = N'C:\datab\Storik_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF
@laazzee
laazzee / csgo_legacy_download.md
Created February 11, 2025 21:51
Instructions on how to download only csgo_leagcy of Counter-Strike game using DepotDownloader

  1. Download DepotDownloader

  2. Extract zip file and open the Command Prompt within folder containing DepotDownloader.exe

  3. To download csgo_legacy binaries paste this line into the command prompt. You should use the account that has cs2 in the steam library for credentials. Dont forget to set YOUR_STEAMUSERNAME and YOUR_STEAMPASSWORD. In this example, we will be downloading all game files into d:\csgo_legacy folder.

     DepotDownloader.exe -app 730 -depot 732 -manifest 6314304446937576250 -beta csgo_legacy -dir "d:\csgo_legacy" -username YOUR_STEAMUSERNAME -password YOUR_STEAMPASSWORD

  4. To download csgo_legacy assets paste this line into the command prompt

     DepotDownloader.exe -app 730 -depot 731 -manifest 1224088799001669801 -dir "d:\csgo_legacy"
@DomVinyard
DomVinyard / index.html
Created February 11, 2025 21:51
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>CSS-Only Quiz</title>
<style>
body {
font-family: "Segoe UI", Tahoma, Geneva, Verdana, sans-serif;
@spinningcat
spinningcat / matcher-neighbour.pu
Created February 11, 2025 21:51
import time
import pandas as pd
import requests
# Set headers for the OpenStreetMap API request
headers = {
"User-Agent": "MyPythonApp/1.0 (beratn@gmail.com)"
}
# Read the CSV file
@choco-bot
choco-bot / FilesSnapshot.xml
Created February 11, 2025 21:49
Influx-Capacitor v1.0.89 - Failed - Package Tests Results
<?xml version="1.0" encoding="utf-8"?>
<fileSnapshot xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<files>
<file path="C:\ProgramData\chocolatey\lib\Influx-Capacitor\influx-capacitor.nupkg" checksum="F75DC71E586240160984C70C7AC8D7F9" />
<file path="C:\ProgramData\chocolatey\lib\Influx-Capacitor\influx-capacitor.nuspec" checksum="307FA733CC3F7FF84F03FC5E95C44E0A" />
<file path="C:\ProgramData\chocolatey\lib\Influx-Capacitor\tools\chocolateybeforemodify.ps1" checksum="ECAA88F7FA0BF610A5A26CF545DCD3AA" />
<file path="C:\ProgramData\chocolatey\lib\Influx-Capacitor\tools\chocolateyinstall.ps1" checksum="C562D95F282726066EE1BCD74D31A1A5" />
<file path="C:\ProgramData\chocolatey\lib\Influx-Capacitor\tools\chocolateyuninstall.ps1" checksum="778CE51D73774BD945B33C2CBF3E59C8" />
</files>
</fileSnapshot>
@boegelbot
boegelbot / easybuild_test_report_21890_easybuilders_preasybuild-easyconfigs_20254911-UTC-21-49-44.md
Created February 11, 2025 21:49
EasyBuild test report for easybuilders/easybuild-easyconfigs PR(s) #21890

Test report for PR(s) easybuilders/easybuild-easyconfigs#21890

Test result

Build succeeded for 1 out of 10 (10 easyconfigs in total)

Overview of tested easyconfigs (in order)

@boegelbot
boegelbot / nvofbf-2023b_partial.log
Created February 11, 2025 21:49
(partial) EasyBuild log for failed build of /tmp/eb-_np2s481/files_pr21890/n/nvofbf/nvofbf-2023b.eb (PR(s) #21890)
== 2025-02-11 21:49:30,722 one.py:150 DEBUG Not copying '__builtins__' variable from parsed easyconfig
== 2025-02-11 21:49:30,722 types.py:206 DEBUG No type specified for easyconfig parameter 'easyblock', so skipping type check.
== 2025-02-11 21:49:30,722 types.py:214 DEBUG Value type check passed for easyblock parameter value: Toolchain
== 2025-02-11 21:49:30,722 types.py:214 DEBUG Value type check passed for name parameter value: nvofbf
== 2025-02-11 21:49:30,722 types.py:214 DEBUG Value type check passed for version parameter value: 2023b
== 2025-02-11 21:49:30,722 types.py:206 DEBUG No type specified for easyconfig parameter 'homepage', so skipping type check.
== 2025-02-11 21:49:30,722 types.py:214 DEBUG Value type check passed for homepage parameter value: (none)
== 2025-02-11 21:49:30,722 types.py:206 DEBUG No type specified for easyconfig parameter 'description', so skipping type check.
== 2025-02-11 21:49:30,722 types.py:214 DEBUG Value type check passed for description parameter value: NVHPC based t
@boegelbot
boegelbot / FFTW.MPI-3.3.10-nvompi-2023b_partial.log
Created February 11, 2025 21:49
(partial) EasyBuild log for failed build of /tmp/eb-_np2s481/files_pr21890/f/FFTW.MPI/FFTW.MPI-3.3.10-nvompi-2023b.eb (PR(s) #21890)
== 2025-02-11 21:49:26,456 easyblock.py:314 INFO This is EasyBuild 4.9.5.dev0-rd0c5506e7fa4a0cec9bb1517904fd98eaaa221b9 (framework: 4.9.5.dev0-rb37f70756960c1686875974f8381491df280cc00, easyblocks: 4.9.5.dev0-rd0c5506e7fa4a0cec9bb1517904fd98eaaa221b9) on host jsczen3c1.int.jsc-zen3.fz-juelich.de.
== 2025-02-11 21:49:26,456 easyblock.py:320 INFO This is easyblock EB_FFTW_period_MPI from module easybuild.easyblocks.fftwmpi (/home/boegelbot/easybuild/easybuild-easyblocks/easybuild/easyblocks/f/fftwmpi.py)
== 2025-02-11 21:49:26,456 easyblock.py:1069 INFO Build dir set to /tmp/boegelbot/FFTWMPI/3.3.10/nvompi-2023b
== 2025-02-11 21:49:26,456 config.py:707 DEBUG software install path as specified by 'installpath' and 'subdir_software': /project/def-maintainers/boegelbot/rocky9/zen3/software
== 2025-02-11 21:49:26,456 easyconfig.py:2662 DEBUG Determining software installation subdir for FFTW.MPI EasyConfig @ /tmp/eb-_np2s481/files_pr21890/f/FFTW.MPI/FFTW.MPI-3.3.10-nvompi-2023b.eb
== 2025-02-11 21:49:26,456 easyconf
@boegelbot
boegelbot / ScaLAPACK-2.2.0-nvompi-2023b-fb_partial.log
Created February 11, 2025 21:49
(partial) EasyBuild log for failed build of /tmp/eb-_np2s481/files_pr21890/s/ScaLAPACK/ScaLAPACK-2.2.0-nvompi-2023b-fb.eb (PR(s) #21890)
== 2025-02-11 21:49:24,783 easyblock.py:314 INFO This is EasyBuild 4.9.5.dev0-rd0c5506e7fa4a0cec9bb1517904fd98eaaa221b9 (framework: 4.9.5.dev0-rb37f70756960c1686875974f8381491df280cc00, easyblocks: 4.9.5.dev0-rd0c5506e7fa4a0cec9bb1517904fd98eaaa221b9) on host jsczen3c1.int.jsc-zen3.fz-juelich.de.
== 2025-02-11 21:49:24,783 easyblock.py:320 INFO This is easyblock EB_ScaLAPACK from module easybuild.easyblocks.scalapack (/home/boegelbot/easybuild/easybuild-easyblocks/easybuild/easyblocks/s/scalapack.py)
== 2025-02-11 21:49:24,783 easyblock.py:1069 INFO Build dir set to /tmp/boegelbot/ScaLAPACK/2.2.0/nvompi-2023b-fb
== 2025-02-11 21:49:24,783 config.py:707 DEBUG software install path as specified by 'installpath' and 'subdir_software': /project/def-maintainers/boegelbot/rocky9/zen3/software
== 2025-02-11 21:49:24,783 easyconfig.py:2662 DEBUG Determining software installation subdir for ScaLAPACK EasyConfig @ /tmp/eb-_np2s481/files_pr21890/s/ScaLAPACK/ScaLAPACK-2.2.0-nvompi-2023b-fb.eb
== 2025-02-11 21:49:24,784 e
@boegelbot
boegelbot / nvompi-2023b_partial.log
Created February 11, 2025 21:49
(partial) EasyBuild log for failed build of /tmp/eb-_np2s481/files_pr21890/n/nvompi/nvompi-2023b.eb (PR(s) #21890)
== 2025-02-11 21:49:21,867 pyheaderconfigobj.py:210 DEBUG Removing key 'SOURCELOWER_GTGZ' from parsed cfg (constant, not an easyconfig parameter)
== 2025-02-11 21:49:21,867 pyheaderconfigobj.py:210 DEBUG Removing key 'SOURCE_ZIP' from parsed cfg (constant, not an easyconfig parameter)
== 2025-02-11 21:49:21,867 pyheaderconfigobj.py:210 DEBUG Removing key 'SOURCELOWER_ZIP' from parsed cfg (constant, not an easyconfig parameter)
== 2025-02-11 21:49:21,867 pyheaderconfigobj.py:210 DEBUG Removing key 'SOURCE_TAR' from parsed cfg (constant, not an easyconfig parameter)
== 2025-02-11 21:49:21,867 pyheaderconfigobj.py:210 DEBUG Removing key 'SOURCELOWER_TAR' from parsed cfg (constant, not an easyconfig parameter)
== 2025-02-11 21:49:21,867 pyheaderconfigobj.py:210 DEBUG Removing key 'SOURCE_XZ' from parsed cfg (constant, not an easyconfig parameter)
== 2025-02-11 21:49:21,867 pyheaderconfigobj.py:210 DEBUG Removing key 'SOURCELOWER_XZ' from parsed cfg (constant, not an easyconfig parameter)
== 2025-02-11 21:49:21,86