Skip to content

Instantly share code, notes, and snippets.

Gerard erorus

Block or report user

Report or block erorus

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@erorus
erorus / displays.csv
Created Jul 3, 2017
NPC ID -> Display IDs as of 7.2.5.24330
View displays.csv
id name display1 display2 display3 display4
3 Flesh Eater 987 0 0 0
89 Infernal 72978 0 0 0
304 Felsteed 2346 0 0 0
305 White Stallion 2410 0 0 0
416 Imp 64799 0 0 0
417 Felhunter 77398 0 0 0
444 Lord Piglet 22938 0 0 0
721 Rabbit 328 4626 0 0
1748 Highlord Bolvar Fordragon 5566 0 0 0
@erorus
erorus / migration.md
Last active Mar 6, 2019
Mashery -> Blizzard API Migration
View migration.md

Mashery -> Blizzard API Migration

This is intended for developers who are currently using the Battle.net API via Mashery, and need to migrate to Blizzard's own Battle.net API.

The official migration documentation is here but it's wordy and scattered. This document intends to cut the BS for existing developers as a true migration guide.

It's organized into sections based on the different kinds of API calls.

Game Note

This was written with World of Warcraft APIs in mind. While our hostnames are changing, none of WoW's API paths will change. However, some Starcraft II paths will change, so please reference Blizzard's documentation for further information about that.

@erorus
erorus / itembonus.csv
Last active Feb 5, 2019
7.2.0 item bonus IDs
View itembonus.csv
id quality level previewlevel levelcurve tag tagpriority name namepriority
1 20 Heroic 0
2 4 Pristine 10
3 of Power 0
15 4 20
17
18
19 of the Fireflash 0
20 of the Fireflash 0
21 of the Fireflash 0
@erorus
erorus / mounts.json
Last active Jan 28, 2019
Enhanced Mount Master List 8.1.0.28833
View mounts.json
{
"mounts": [
{
"name": "Abyss Worm",
"spellId": 232519,
"creatureId": -74315,
"itemId": 143643,
"qualityId": 4,
"icon": "inv_serpentmount_green",
"isGround": true,
@erorus
erorus / mount-json-transform.php
Created Jan 15, 2019
Enhanced Mount Master List generation
View mount-json-transform.php
<?php
require_once __DIR__ . '/vendor/autoload.php';
use Erorus\DB2\Reader;
$o = json_decode(file_get_contents(__DIR__ . '/mounts.json'), true);
if (json_last_error() != JSON_ERROR_NONE) {
fwrite(STDERR, "JSON error loading mounts.json: " . json_last_error_msg() . "\n");
exit(1);
@erorus
erorus / method.md
Last active Jan 14, 2019
Global Market Price calc from The Undermine Journal for Wowhead
View method.md

Global Buyout Price Calculation

for Wowhead, via The Undermine Journal

Definitions

  • "Market Price": The cost, per each, to buy the cheapest 15% of the total available quantity of a given item at one instant in time on one realm.
  • "Current Price": The market price at the most recent data snapshot.
  • "Mean Price": A mathematical mean (or "average") of market prices. Sum up all the prices, divide by the count of prices. Simple. This could use the prices of one item on one realm over time, or the current prices of one item across all realms in a region.
  • "Median Price": The midpoint of a sorted list of "market prices". This could use the prices of one item on one realm over time, or the current prices of one item across all realms in a region.
  • "Global Price": The average value of the US and EU region median prices, as observed 8 times across the past 24 hours.
@erorus
erorus / pets.json
Last active Aug 24, 2018
Enhanced Pet Master List 8.0.1.27356
View pets.json
This file has been truncated, but you can view the full file.
{
"pets": [
{
"canBattle": true,
"canObtain": true,
"canTrade": true,
"creatureId": 17254,
"description": "One of Ash'alah's litter, entrusted to you by the Dreamweavers.",
"displayId": 37949,
@erorus
erorus / banners.txt
Last active Jul 3, 2018
Electrum Server Banners for BTC
View banners.txt
--- 13.80.67.162
Welcome to Electrum!
--------------------------------------------------------------------------------
--- 139.162.14.142
Welcome to Electrum!
--------------------------------------------------------------------------------
--- 165.227.22.180
Welcome to yet another ElectrumX full server!
@erorus
erorus / split.php
Created Apr 18, 2018
Split blocks of video transcript into paragraphs
View split.php
<?php
/* quick and dirty paragraph splitter
* by Erorus
*
* this script is fully in the public domain, do what you want with it
*
* intended for use for unformatted video transcripts
* such as ones produced by Ars Technica, e.g.
* https://cdn.arstechnica.net/wp-content/uploads/2018/04/3545034e-f60c-4657-b223-6cde51b5576fcc.txt
@erorus
erorus / titles.csv
Created Apr 7, 2018
WoW character titles 7.3.5.26365
View titles.csv
1 Private %s Private %s 1 0
2 Corporal %s Corporal %s 2 0
3 Sergeant %s Sergeant %s 3 0
4 Master Sergeant %s Master Sergeant %s 4 0
5 Sergeant Major %s Sergeant Major %s 5 0
6 Knight %s Knight %s 6 0
7 Knight-Lieutenant %s Knight-Lieutenant %s 7 0
8 Knight-Captain %s Knight-Captain %s 8 0
9 Knight-Champion %s Knight-Champion %s 9 0
10 Lieutenant Commander %s Lieutenant Commander %s 10 0
You can’t perform that action at this time.