Skip to content

Instantly share code, notes, and snippets.

View Bocom's full-sized avatar

Benjamin Röjder Delnavaz Bocom

View GitHub Profile
=INDEX( # Returns the content of a cell
# Reference
FILTER( # Returns a filtered version of the source range
Legendaries!A:A, # Condition 1: All Legendaries
Legendaries!B:B = A2 # Condition 2: The Name column matches the name in A2
),
#Row
MATCH( # Returns the relative position of an item in a range
# Search Key
MAX( # Returns the maximum value in a numeric dataset
using System;
namespace SomeAssignment
{
public class ProfessorRating
{
public int Id
{
get;
private set;
@Bocom
Bocom / gist:7047627
Created October 18, 2013 20:20
New Example
label main {
if ($numItems > 0 and has_item "GrandKey") {
show Battler Happy
show Beatrice Happy
say Battler testscript.has_key
}
else {
show Battler
show Beatrice
@Bocom
Bocom / gist:6311456
Last active December 21, 2015 13:18
1. Ladda ner och packa upp https://www.dropbox.com/s/vtswqpug8sewger/DunderchatMCKlient.7z till valfri mapp.
Minecraft Launcher lägger allt sitt i %appdata%\.minecraft
2. Kör Minecraft.exe
3. Logga in och starta spelet en gång och stäng sedan Minecraft.exe
4. Kör minecraftforge-installer-1.6.2-9.10.0.804.jar med valet "Install client"
5. Starta Minecraft.exe igen och välj profilen Forge och starta spelet för att kolla att det installerades rätt.
Du behöver inte stänga Minecraft.exe (tror jag)
6. Kör WDI_0.4.jar och följ instruktionerna.
Ifall du inte har 32-bitars Java måste du installera det (installationsprogrammet kommer säga till)
7. Starta spelet igen genom launchern och se till att fyra moddar har laddats (står i nedre vänstra hörnet) och stäng spelet igen
@Bocom
Bocom / gist:5778721
Created June 14, 2013 01:09
Horrible code made through throwing stuff at the wall
using System;
using System.Collections.Generic;
using System.IO;
namespace NewSceneManager.Dialogue
{
public class DialogueEngine
{
Dictionary<string, DialogueBlock> labels;
List<DialogueCharacter> characters;
@Bocom
Bocom / Example
Last active December 18, 2015 02:09
label main {
if has_item grand_key {
show Battler Happy
show Beatrice Happy
say Battler "This is dialogue that indicates that you have the key! Sweet!"
}
else {
show Battler
show Beatrice
label main:
if has_item grand_key:
jump "has_key"
jump "no_key"
label has_key:
show Battler Happy
show Beatrice Happy
@Bocom
Bocom / gist:4189496
Created December 2, 2012 16:05
The Witches' Tanabata isn't easy-going.
Very soon, it will be Tanabata.
A familiar event, marked by the hanging of pieces of paper, with wishes written on them, on bamboo branches.
It is not often that such wishes are granted, but sometimes, spirits and souls of the dead, or even demons and witches, will find the wishes by chance and grant them......
Ushiromiya Maria was supposed to write one of these at school.
There was plenty of paper, so students were allowed to use several pieces, if they could think of enough wishes.
At first, everyone was excited about writing a lot of them, but after writing 2 or 3, despite their youth, they realized to their surprise that they could only write trivial things, such as 'I want to be rich' or 'I want to become *blank*'.
However, unlike the other children, Maria thought that writing one wish was enough.
'I wish that Mama will come home every day'
@Bocom
Bocom / gist:3241425
Last active October 7, 2015 23:18
Kamen Rider W
This is the order of things:
[W-Time]_Kamen_Rider_W_-_01DVD_[8B57D3DF].mkv
[W-Time]_Kamen_Rider_W_-_02DVD_[53ABDABA].mkv
[W-Time]_Kamen_Rider_W_-_03DVD_[F765B82B].mkv
[W-Time]_Kamen_Rider_W_-_04DVD_[950AE23A].mkv
[W-Time]_Kamen_Rider_W_-_05DVD_[8F5A2659].mkv
[W-Time]_Kamen_Rider_W_-_06DVD_[B59DCB22].mkv
[W-Time]_Kamen_Rider_W_-_07DVD_[2F6ED08D].mkv
[W-Time]_Kamen_Rider_W_-_08DVD_[6548A39B].mkv
[W-Time]_Kamen_Rider_W_-_09HD_[B9813441].mkv
using System;
using System.Collections.Generic;
using Microsoft.Xna.Framework;
using Microsoft.Xna.Framework.Graphics;
namespace WanderfulEngine
{
public enum Direction
{
Down,