Skip to content

Instantly share code, notes, and snippets.

View mburbea's full-sized avatar

Michael Burbea mburbea

5 followers · 0 following
View GitHub Profile
@mburbea
mburbea / Fab_rules.md
Created July 13, 2020 22:24
Suffix Display name
torso Shirt
head Cap
legs Bottoms
hands Gloves
feet Boots
Male Fab Female Fab In game name
@mburbea
mburbea / gem_buff mapping.csv
Last active July 21, 2020 18:59
simtype buff rarity gem_id gem_hex gem_name buff_id buff_hex buff_name
07C959 499544 Infrequent 510297 07C959 Gem_Physical_01 499544 079F58 Prefix_Damage_Physical_02
07E911 1850755 Infrequent 518417 07E911 Gem_Poison_01 1850755 1C3D83 Prefix_Damage_Poison_02
07E912 502306 Infrequent 518418 07E912 Gem_Bleeding_01 502306 07AA22 Suffix_Damage_Bleeding_01
07E927 499549 Infrequent 518439 07E927 Gem_Piercing_01 499549 079F5D Prefix_Damage_Piercing_02
07E92F 499591 Infrequent 518447 07E92F Gem_Ice_01 499591 079F87 Prefix_Damage_Ice_02
07E937 499596 Infrequent 518455 07E937 Gem_Fire_01 499596 079F8C Prefix_Damage_Fire_02
07E93A 499741 Infrequent 518458 07E93A Gem_Lightning_01 499741 07A01D Prefix_Damage_Lightning_02
07E949 1289751 Rare 518473 07E949 Gem_LifeLeech_01 1289751 13AE17 Suffix_Damage_Lifesteal_01
07E94A 1289758 Rare 518474 07E94A Gem_ManaLeech_01 1289758 13AE1E Suffix_Damage_Manasteal_01
@mburbea
mburbea / unstick.lua
Created August 1, 2020 15:52
args = ...
local q = {0x000438F0000002F0hl,0x000589EF000002F0hl,0x000589F0000002F0hl,0x000589F1000002F0hl,0x000589F2000002F0hl,0x000589F3000002F0hl,0x000589F4000002F0hl,0x000589F5000002F0hl,0x0005CF3D000002F0hl,
0x0005E1B5000002F0hl,0x0006AF9B000002F0hl,0x0006B480000002F0hl,0x0006C198000002F0hl,0x0006F9E6000002F0hl,0x0006FC47000002F0hl,0x00070BF9000002F0hl,0x00070F48000002F0hl,0x00070F49000002F0hl,0x000720DA000002F0hl,
0x0007231E000002F0hl,0x00072373000002F0hl,0x00072819000002F0hl,0x00072F63000002F0hl,0x000734C9000002F0hl,0x000734CF000002F0hl,0x000734D0000002F0hl,0x000734F3000002F0hl,0x0007357A000002F0hl,0x00073D6F000002F0hl,
0x000745F6000002F0hl,0x000767A3000002F0hl,0x0007751F000002F0hl,0x00077520000002F0hl,0x000780BC000002F0hl,0x00078CDF000002F0hl,0x0007A701000002F0hl,0x0007A788000002F0hl,0x0007A7A0000002F0hl,0x0007AFAA000002F0hl,
0x0007B117000002F0hl,0x0007B63A000002F0hl,0x0007E7FF000002F0hl,0x0007F6FF000002F0hl,0x0007FC1F000002F0hl,0x000813FD000002F0hl,0x00081D2C000002F0hl,0x000823B4000002F0hl,0x000827920
@mburbea
mburbea / transfers.sql
Last active August 6, 2020 04:58
;with transfers as (
select account_id = row_number() over (order by 1/0)%400,
transfer_date = eomonth(getutcdate(),-abs(binary_checksum(newid()))%13)
from string_split(space(8000),' ')
),last_12_months as (
select month_end = eomonth(getutcdate(),-n), n
from(values(1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12))f(n)
)
select t.account_id
from transfers t
@mburbea
mburbea / AmalurUniqueDrops.csv
Last active September 19, 2020 15:58
Item Name Count
SkillBook_Alchemy 1
SkillBook_Dispelling 1
SkillBook_Blacksmithing 1
SkillBook_DetectHidden 1
SkillBook_Persuasion 1
SkillBook_Lockpicking 1
SkillBook_Mercantile 1
SkillBook_Sagecraft 1
Assassin's Aegis 1
@mburbea
mburbea / components.json
Created January 2, 2022 23:29
This file has been truncated, but you can view the full file.
[
{
"level": 4,
"type_id": 510297,
"buffs": [
499544
],
"internal_name": "gem_physical_01",
"category": "Gem",
"socket_type": "W",
@mburbea
mburbea / CountIslands.cs
Last active March 13, 2022 19:09
Count Islands
// See https://aka.ms/new-console-template for more information
return CountIslands(new[] { new[] { 1, 1, 0 }, new[] { 1, 0, 1 }, new[] { 0, 1, 1 } }));
static int CountIslands(int[][] m)
{
int count = 0;
for (int i = 0; i < m.Length; i++)
for (int j = 0; j < m[i].Length; j++)
if (m[i][j] == 1)
@mburbea
mburbea / FIndWeightedMedian.sql
Last active March 22, 2022 00:38
/*
drop table if exists #data
select min,max, value = 1e* (abs(binary_checksum(newid()))%1000)
into #data
from (values(0, 9)
,(10, 19)
,(20, 29)
,(30, 39)
,(40, 59)
,(60, 70)
@mburbea
mburbea / solution.cs
Created March 31, 2022 18:47
using System.Diagnostics;
var sw = Stopwatch.StartNew();
int s = FindSmallestMaxPathUDLR64(new[]
{
new []{ 1, 1, 1, 1, 1, 1, 1 },
new []{ 9, 9, 9, 9, 9, 9, 1 },
new []{ 9, 1, 1, 1, 1, 9, 1 },
new []{ 9, 1, 9, 9, 1, 1, 1 },
new []{ 9, 1, 9, 9, 9, 9, 9 },
@mburbea
mburbea / XmlMonitor.cls
Last active June 19, 2024 12:34
VERSION 1.0 CLASS
BEGIN
MultiUse = -1 'True
END
Attribute VB_Name = "XmlMonitor"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit