11 January, 2019

A Corner of Mantica - Small Kings of War campaign including Kings of War Vanguard

Okay, long time no post. Time to remedy that. I just finished version 1.0 of something I have been working on for quite a while.

I am an RPG and tabletop fan. Formerly I played Warhammer 40k, then after Games Workshop killed Warhammer Fantasy, I got some fantasy armies and started playing that a bit. Then I discovered Kings of War by Mantic and since then I am in love with that company and their products.
By now I earn all the KoW books, I have the Warpath&Firefight books, I have their Zombies game and I have quite sooome models including an only-partly-assembled Forces of Nature starter force.
But my actual love is for their Kings of War franchise.
I love the way they designed their game so that its OK that you can use your Games Workshop models for Kings of War!

Last year they started a Kickstarter Campaign for their Kings of War Vanguard rules. Those are the skirmish rules. Much like what Kill Team is for 40k.

When they made the kickstarter I just NEEDED to put down a Giant Pledge! I tried their free alpha rules, and I loved them. And I just so much looked forward to the campaign rules they promised!

This year it was shipped. Since I got my Vanguard Kickstarter (i think i actually even started a bit earlier) I worked on a small Kings of War campaign that has the vanguard system integrated. actually i played around with the idea to create a tabletop campaign for quite some time. When the Edge of the Abyss campaign book came out, and I read about it I was just amazed. For one, I wanted to particpate. and for the other part, I wondered how hard it was to write such a book.
so now was the time for me to do one for myself.
i created a campaign tree, chose scenarios, wrote the fluff, put in the ilustrations in, created the map... I was curious to see how much work it would be to create such a thing. And I am surprised to see how much time sinks into it.

it totals 31 pages. i've not played it yet, but am looking forward to doing it.
When you play through it you get 6 Vanguard games and 3 KoW games out of it and how you perform effects the outcome.

you can take a look at it / download it here.
or download it as a PDF here.

i realized that i am a bit rusted in writing non-technical english text, therefore i am happy for any corrections / suggestions esp. by native speakers.
I think I especially had my trouble with what to write with capital letters. "Elven settlement" or "elven settlement"...

too bad I wasn't able to put it up on the mantic forum before they closed it, but i lamented that there already anyway.

Next thing I look forward to from them is their Mantica RPG. When I first read the KoW book, I immediately thought "WOW, this would make a great RPG setting!". Back at that point I was GM-ing a Savage Worlds Hellfrost Campaign. It never got finished and currently I do not do RPGs, but my original intent was to place the next campaign in the world of Mantica by using Savage Worlds system and use some Hellfrost rules and other material for being able to include the Tabletop game aspect into the RPG as well. I thought Savage Worlds would be great for that. Well, altogether I am also a big fan of Savage Worlds and because a friend of mine who is in my RPG group also plays tabletop with me occasionally I thought that would work out nicely for me.

Now with a Mantica RPG coming, I so hope it will be Savage Worlds. Especially after seeing the Vanguard Rules, I think both systems have quite some philosophies in common. One, this "rules lite" approach, and then of course the exploding dice... but I digress. This post should actually be about the campaign ;)

03 April, 2017

How to help you find out when you logged on / off of your computer (the easy way)

I actually have created me a keylogger that gets started for this kind of stuff, but if you need to do it without using a program then: 

just edit the security policy to audit logon successes. Run SECPOL.MSC and select audit Policy under the Local Policies in the tree view on the left. Enable auditing for logon events. Now these events will show up in the event viewer and can be viewed remotely.

i might post a blog about my keylogger -which i actually call ActivityLogger- at a later stage. its a neat tool that helps me keep track of my active times during the day in from of the pc

02 December, 2016

So you want to use Sqlite with EF 6?

You know about normal SQL databases and wanna start playing around with SQLite and have a rough understanding what SQLite is. For working with it you desire to use EF from the start on.
And you want to use the "Database First" Approach and create your model the sqlite database.

Thats how I wanted to do it. Unfortunately, using DB-first approach with sqlite is very tricky and volatile. I managed to do it... only to find that 2 months later my Visual Studio wasnt able to do the same thing again because the "Data Provider" inside my visual studio had forgotten the installed sqlite... and i needed to do the procedure again.

so my actual suggestion is.... if you want to use SQLite with EF then.... don't. 

For now, for small applications I need a local DB started to use Dapper together with SQLite instead and use Code-First. Its really much easier. If you follow the steps in this excellent article during reading you will have a working ORM solution with a running SQL database in under 5 minutes.

With that suggestion and warning out of the way and you still want to use EF together with SQLite...

Then here is your cookbook.

(This at least worked for me after many failed attempts)

Create your VS solution (I still use VS2013); open Nuget Manager, search for and add:

System.Data.SQLite (x86/x64) Version 1.0.103

(I had troubles with other versions).
Ignore all other things you find on this topic on the web.


SQLite/SQL Server Compact Toolbox

then install

Change the target framework for your projects to 4.5.1 in the "Properties" of the project in your soluion

Download and install "DB Browser for SQLite"
I use version 3.9.0

Open DB Browser for SQLite and create a new database and save it. Lets call it Db.sqlite

Add the newly created database to your visual studio project (via Add>Existing Item...);
You might want to actually add a copy of the original Db.sqlite....

now add a new "ADO.NET Entity Data Model" object to your project. Click "EF Designer from data..." go to "New Connection", under "Data source:" press "Change", and select System.Data.SQLite Database File; connect to your DB.sqlite and you are ready to go

12 September, 2016

von fast allen habe ich glückwünsche bekommen. nur die eine die mir noch wirklich wichtig wäre habe ich aus nachvollziehbaren gründen nicht bekommen

07 September, 2016

04 August, 2016

Quickstart to start game development with Javascript 

So you want to start making some games for the web and want to dive right into it?
You have some understanding about programming and maybe even game development but this whole Web-Thing and setup for being able to use the new Javascript is just a hassle for you you dont want to dive right into?

Then this blog post is for you.

Setting up the toolchain for making easy javascript coding for the browser is a knowledge in itself... and it doesnt have much to do too much with programming. so enthusiasts might be put off.

Unfortunately the current ecosystem makes it hard for newcomers to modern javascript.

Following this link you will get a completely set-up toolchain to be able to create your own HTML5 games using Pixi and Howler.

Its crude and the toolchain doesnt support tests but it will get the job done. You can even use it to make simple deployments.it should make it possible for you to get the tutorials you find on the web run or use as the base for a small game.

How to use it:

Check out the readme on the github page. Basically you will have to install npm/node, then navigate to the directory of the project provided here and run the following commands:

>npm install

Done. Now start coding.

You will notice that after running "gulp" on the commandline, that command will not complete. He will open up a new tab in chrome (you DO have chrome installed right?!) but never stops execution. This is intended. Gulp is watching for any file changes done in the project. If he finds changes, he makes a build.
That means, as soon as you make changes to a javascript file or the html file, the build process runs.
For all you out there using WebStorm, I also included a webstorm setup to get you going. All that is by no means perfect, but a good starting point. included 2 media files are all common assets that can be found on the internet.

Please note that kudos must go to Falconerd whose gulpfile I used as a base of this project.

12 March, 2015

How to allow Jenkins installation access to your MS SQL Server

if you want to run integration tests against the database and your tests shall be automated with jenkins, then you will need to add the jenkins service (normally you will install jenkins as a windows service) as an sql database user.

so how to find out how the user is called?

open your jenkins installation and go to its system properties.

you can either reach it via the URL


or you navigate to it through by clicking "manage jenkins" > "system information"

there, scroll down. you will find 2 entries:

USERDOMAIN and USERNAME (if your server is part of a domain of course). Example for this would be: CompanyDomain\ServerName$

now, add a new SQL User in sqlexpress by opening sql server managment studio, navigating to security/logins and say "new login..." by right click. use "windows authentication" and enter as the login name <ValueOfUserDomain>\<ValueOfUserName>.
So in our example you would add COMPANYDOMAIN\SERVERNAME$ into here.

Now you of course might also need to give this user appropriate permissions to do stuff, but i leave all that to you!

Happy coding