Coline Carle coline-carle
coline-carle
/ database.go
Created
October 15, 2018 21:39
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
| func (db *DB) DeleteAllAchievementsAndCategoriesWithTransaction(tx Tx) error { | |
| const sqlStatement = ` | |
| DELETE FROM achievements_categories | |
| ` | |
| _, err := tx.Exec(sqlStatement) | |
| return err | |
| } |
coline-carle
/ init.vim
Created
September 14, 2018 08:31
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
| packadd minpac | |
| call minpac#init() | |
| call minpac#add('tpope/vim-unimpaired') | |
| call minpac#add('tpope/vim-dispatch') | |
| call minpac#add('tpope/vim-projectionist') | |
| call minpac#add('tpope/vim-obsession') | |
| call minpac#add('radenling/vim-dispatch-neovim') | |
| call minpac#add('mhinz/vim-grepper') | |
| call minpac#add('itchyny/lightline.vim') | |
| call minpac#add('w0rp/ale') |
coline-carle
/ fetch.sh
Created
July 9, 2018 22:49
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
| curl -L -o database.json.bz2 http://clientupdate-v6.cursecdn.com/feed/addons/432/v10/complete.json.bz2 && bzip2 database.json.bz2 |
coline-carle
/ lemonde.css
Last active
April 29, 2018 15:23
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
| @-moz-document domain("lemonde.fr") { | |
| .services, .vous, .audience, #teaser_article .bordt1, #header-page, #footer, #footer-page, #header, #en_ce_moment, #footer_services, #ultimedia_wrapper, .fb_iframe_widget, .toolbar, iframe, .conteneur_barre_outils, .meme_sujet, .liste_reactions { | |
| display: none !important; | |
| } | |
| .container_18 .grid_10 { | |
| width: 700px; | |
| margin-left: 60px; | |
| } | |
| .container_18 .grid_12 { | |
| width: 100%; |
coline-carle
/ realms.json
Created
March 1, 2018 18:58
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
| [ | |
| { | |
| "type": "PvP", | |
| "name": "Eredar", | |
| "slug": "eredar", | |
| "locale": "de_DE", | |
| "language": "German", | |
| "timezone": "+01:00 (CET)" | |
| } | |
| ] |
coline-carle
/ realms.json
Last active
March 1, 2018 18:52
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
| { | |
| "id": 319, | |
| "name": "View Connected Realm", | |
| "slug": "319", | |
| "progressionStats": [ | |
| 12, | |
| 11, | |
| 6, | |
| 4, | |
| 7, |
coline-carle
/ realm-name-score.csv
Created
February 24, 2018 01:35
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
| Aegwynn | 33116.378268832654 | |
|---|---|---|
| Aerie Peak | 799.0579921007461 | |
| Agamaggan | 13965.774730478988 | |
| Aggra (Português) | 26219.836837055496 | |
| Aggramar | 7867.593370677374 | |
| Ahn'Qiraj | 12385.177397595515 | |
| Al'Akir | 19386.371993076147 | |
| Alexstrasza | 13564.321126044993 | |
| Alleria | 27050.313722522416 | |
| Alonsus | 15397.339872055165 |
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
| defp pinned_raid_with_members(query) do | |
| query | |
| |> where(pinned: true) | |
| |> join(:left, [raid], registrations in assoc(raid, :registrations)) | |
| |> join(:left, [raid, registrations], member in assoc(registrations, :member)) | |
| |> preload([raid, registrations, member], registrations: {registrations, member: member}) | |
| end |
coline-carle
/ database.lua
Created
February 15, 2018 01:11
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
| local clusterData = | |
| { | |
| [121] = { | |
| alliance = 12844.0, | |
| horde = 26991.0, | |
| realms = { | |
| "Aegwynn", | |
| "Bonechewer", | |
| "Daggerspine", | |
| "Gurubashi", |
coline-carle
/ database.lua
Created
February 14, 2018 22:55
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
| local clusterData = | |
| { | |
| [121] = { | |
| alliance = 12844.0, | |
| horde = 26991.0, | |
| realms = { | |
| "Aegwynn", | |
| "Bonechewer", | |
| "Daggerspine", | |
| "Gurubashi", |
NewerOlder