Skip to content

Instantly share code, notes, and snippets.

Suffix Display name
torso Shirt
head Cap
legs Bottoms
hands Gloves
feet Boots
Male Fab Female Fab In game name
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
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
;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
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
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)
/*
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)
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 },
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