RobotLab Card Game Up On Kickstarter

Tabletop Gaming News - 12 January 2017 - 8:00am
Who wouldn’t want a robot companion? You could have them do some of the chores around the apartment, have yourself some wild adventures, and do all those cool things you see in the movies. But you gotta build your robot first. And if you’re going to build your own robot, you might as well make […]
Categories: Game Theory & Design

The Future of Games in the Past - by Ben Wander Blogs - 12 January 2017 - 7:45am
How history can lead to a good future for video games.
Categories: Game Theory & Design

Simple mechanics, complex puzzle creation - Part 4: Interesting challenges - by Andrea Baldiraghi Blogs - 12 January 2017 - 7:43am
We conclude this series investigating what are interesting characteristics of a level and determine if we can now answer our original question: "Can computer-aided puzzle design help us create fair, fun and interesting challenges?"
Categories: Game Theory & Design

What To Expect - Video Game Cybersecurity In 2017 - by Matthew Cook Blogs - 12 January 2017 - 7:42am
Matt Cook shares his predictions for cybersecurity in online games for 2017, and discusses potential threats for the coming year.
Categories: Game Theory & Design

The Walking Dead, Choices, and Kenny - by Stanislav Costiuc Blogs - 12 January 2017 - 7:38am
Let's look at the nature of choices in Telltale's The Walking Dead, and how they affect the experience and characters.
Categories: Game Theory & Design

Fantasy Flight Games Posts Elder Sign: Omens of the Deep Preview

Tabletop Gaming News - 12 January 2017 - 7:00am
I have to admit something: I never want to go out into the ocean. There’s just too many things out there in it that I don’t know anything about and it kinda creeps me out. Simply not for me. That sort of fear of the water can be brought right to my tabletop, if I […]
Categories: Game Theory & Design

Drupal Blog: Nominations are now open for the 2017 Aaron Winborn Award

Planet Drupal - 12 January 2017 - 6:27am

The Drupal Community Working Group is pleased to announce that nominations for the 2017 Aaron Winborn Award are now open. This annual award recognizes an individual who demonstrates personal integrity, kindness, and above-and-beyond commitment to the Drupal community. It will include a scholarship and stipend to attend DrupalCon and recognition in a plenary session at the event.

Nominations are open to not only well-known Drupal contributors, but also people who have made a big impact in their local or regional community. If you know of someone who has made a big difference to any number of people in our community, we want to hear about it.

This award was created in honor of long-time Drupal contributor Aaron Winborn, whose battle with Amyotrophic lateral sclerosis (ALS) (also referred to as Lou Gehrig's Disease) came to an end on March 24, 2015. Based on a suggestion by Hans Riemenschneider, the Community Working Group, with the support of the Drupal Association, launched the Aaron Winborn Award.

Nominations are open until March 1, 2017. A committee consisting of the Community Working Group members and past award winners will select a winner from the submissions. Members of this committee and previous winners are exempt from winning the award.

Previous winners of the award are:

*  2015: Cathy Theys  
*  2016: Gábor Hojtsy  

If you know someone amazing who should benefit from this award please nominate them at

Categories: Drupal

Privateer Press Previews April Releases

Tabletop Gaming News - 12 January 2017 - 6:00am
We’ve got some new Warmachine and Hordes releases available from Privateer Press today. But even as you head out to fortify your forces with some new figures, there’s always some more new figures on the horizon. Privateer Press has let us know what they’ll be coming out with in April. Check ’em out. From the […]
Categories: Game Theory & Design

OSTraining: Contribute Your Code on, Part 6: Review Process

Planet Drupal - 12 January 2017 - 6:00am

Previously we talked about connecting and checking that you are connected to your sandbox project, uploading your project and checking it against Paraview. 

{snippet drupalcontributionlinks}

Now, in Part 6, we're going to look at getting your theme reviewed. This is perhaps the trickiest and slowest part of the whole contribution process, so pay close attention. We're going to help you do everything possible to ensure a speedy and successful application submission. 

Categories: Drupal - Thoughts: Drupal 8 adoption and what 2017 is likely to bring

Planet Drupal - 12 January 2017 - 5:17am

It’s now over a year since the release of Drupal 8, the first new version of the open source content management framework in five years. It represented a significant rethinking of the platform when it launched in November 2015 and 2017 is likely to be another significant year for Drupal 8 with further updates and developments expected. As Dries Buytaert, the founder and lead developer of Drupal outlined in a blog last September:

“The only way to stay competitive is to have the best product and to help people adopt it more seamlessly. This means that we have to continue to be able to reinvent ourselves and that we need to make the resulting changes less scary and easier to absorb. We decided that we wanted more frequent releases of Drupal, with new features, API additions, and an easy upgrade path.”

One of the most common questions we get asked is, “How is Drupal 8 doing and what can we expect in the future?". Understandably, this is important to many organisations currently using previous versions and the Drupal community that has a stake in its success. But it’s also important to new users looking to migrate over.

There’s a significant amount of interest because, as with any new update, organisations have to decide whether the framework is right for them. While Drupal 8 is still maturing, adoption rates are now growing fast. This year we migrated the Ixis website to Drupal 8, which you can read more about our experience here.

User growth and high profile successes

2016 saw progress in a variety of key areas including user growth, as well as a number of high-profile successes and this is likely to continue in 2017. As with all new updates, it has taken some time for Drupal 8 to gain traction in terms of the number of users but there has been a clear upward trajectory over the course of the year. There are currently 120,000 Drupal 8 projects, and while Drupal 7 is currently running more than 1 million, this still represents significant growth one year in, especially with adoption rates starting to increase, as outlined on

The wide range of prominent Drupal 8 projects that have launched in the past year have helped to showcase the power of the new platform. These include:

  • - Millions of fans around the globe rely on the NBA's Drupal 8 website to livestream games, read stats and standings, and stay up to date on their favourite team.

  • Nasdaq - Drupal 8 is used as the basis for its next generation Investor Relations Website Platform. IR websites are where public companies share their most sensitive and critical news and information with their shareholders, institutional investors, the media and analysts.
The migration question

Although the Drupal 7 user base remains solid and the platform will be supported for a long time, there is an end-of-life in sight for it. This is expected to be in two to three years time but might be even sooner, with some sources predicting an end to Drupal 7 development as soon as October 2017. Either way, Drupal 8 promising a host of further improvements, with Drupal 8.2 already available, many organisations are beginning to look at early migration. The good thing about Drupal 8 is that it comes bundled with a suite of tools to assist with the migration of your content from previous versions, making the task less daunting than it might initially seem. With its ‘continuous innovation’ mission statement a migration to Drupal 8 in 2017 will provide the best possible access to the latest functionality and improvements, helping to unlock the framework’s true potential.

For more information about Drupal 8 contact us on or call 01925 320 041.

Categories: Drupal

Appointment scheduling

New Drupal Modules - 12 January 2017 - 3:55am

Appointment scheduling is a configurable module that lets you set a calendar (days and active hours) and receive reservations requests for the available dates, for different offices.

Categories: Drupal Blog: AGILEDROP: Top Drupal 8 Books

Planet Drupal - 12 January 2017 - 1:53am
The purpose of a great content is first to be explored and then to be read. Therefore, being listed on a first page on search engines is a key thing. Shortly, you will be able to read how to Search Engine Optimize your Drupal 8 website. But before Drupal SEO Book is released – you can pre-order it here or wait until 15th January – we will look at the best books Drupal 8 has to offer. The first choice is Drupal 8 Development Cookbook by Matt Glaman, which enjoys the best feedback from readers. The book is appropriate for web developers and site builders. It contains the whole chapter for… READ MORE
Categories: Drupal


New Drupal Modules - 12 January 2017 - 12:28am

The Simplify_menu module uses a TwigExtension to gain access to Drupal's main menu's (or any other menu for that matter), render array so it can be accessed from a twig template. Among the many advantages of having full control of the menu's render array in a twig template is the ability to customize the markup for your menus to ensure they are accessible and comply with standards.

Categories: Drupal

Mike Crittenden: Exporting and importing big Drupal databases

Planet Drupal - 11 January 2017 - 8:15pm
Exporting and importing big Drupal databases

Once your site's database dump file gets to be 1GB or more, phrases like "oh, just download and import a DB dump" can't really be taken for granted anymore. So here are some tips for dealing with large databases, especially those of the Drupal variety.


Before we can import, we must export. With a big DB, you don't want to just do a regular old mysqldump > outfile.sql and call it a day. Here are some tips.

Find the size before exporting

It can sometimes be useful to see how big the export is going to be before you actually export anything. That way, you can know ahead of time if you need to be doing this or that to reduce the size, or if it won't matter since the whole thing won't be that big anyway.

Here's a query you can run to see the size per DB table:

SELECT TABLE_SCHEMA, TABLE_NAME, DATA_LENGTH / POWER(1024,1) Data_KB, DATA_LENGTH / POWER(1024,2) Data_MB, DATA_LENGTH / POWER(1024,3) Data_GB FROM information_schema.tables WHERE table_schema NOT IN   ('information_schema','performance_schema','mysql') ORDER BY DATA_LENGTH;

And here's another query you can run to see what the total size for the entire DB is: 

SELECT Data_BB / POWER(1024,1) Data_KB, Data_BB / POWER(1024,2) Data_MB, Data_BB / POWER(1024,3) Data_GB FROM (SELECT SUM(data_length)   Data_BB FROM information_schema.tables WHERE table_schema NOT IN   ('information_schema','performance_schema','mysql')); Dump without unnecessary data

For those cases where you need the database structure for all of the tables, but you don't need the data for all of them, here's a technique you can use. This will grab the entire DB structure, but lets you exclude data for any tables that you want. For example, search_index, cache_*, or sessions tables will be good places to cut out some fat.

# First we export the table structure. mysqldump --no-data database_name > /export.sql # Grab table data, excluding tables we don't need. mysqldump --no-create-info   --ignore-table=database_name.table_name1   --ignore-table=database_name.table_name2   database_name >> export.sql

Just replace "table_name1" and "table_name2" with the tables that you want to skip, and you're golden. Also note that you can use the % character as a wildcard, so for example, you could ignore "cache%" for all cache tables.

After you do that, you'll have a single export.sql file that contains the DB structure for all tables and the DB data for all tables except the ones you excluded. Then, you'll probably want to compress it...

Compress all the things

This one may go without saying, but if you're not compressing your database dumps then either they're really tiny, or you're dumber than a dummy. 

drush sql-dump --gzip --result-file=db.sql

Compare that with the regular old:

drush sql-dump --result-file=db.sql

...and you're going to see a huge difference.

Or if you already have the SQL dump that you need to compress, you can compress the file directly using:

gzip -v db.sql

That will output a db.sql.gz file for you.


Now you have a nice clean compressed DB dump with everything you need and nothing you don't, and you're ready to import. Here are a few ways to ease the pain.

Import a compressed dump directly

Instead of having to decompress the dump before importing, you can do it inline:

gunzip -c db.sql.gz | drush sqlc Exclude data when importing

If you receive a DB dump that has a lot of data you don't need (caches, sessions, search index, etc.), then you can just ignore that stuff when importing it as well. Here's a little one-liner for this:

gunzip -c db.sql.gz | grep -Ev "^INSERT INTO \`(cache_|search_index|sessions)" | drush sqlc

What this is doing is using "grep" as a middleman and saying "skip any lines that are insertion lines for these specific tables we don't care about". You can edit what's in the parenthesis to add/remove tables as needed.

Monitor import progress

There's nothing worse than just sitting and waiting and having no idea how far along the import has made it. Monitoring progress makes a long import seem faster, because there's no wondering. 

If you have the ability to install it (from Homebrew or apt-get or whatever), the "pv" (Pipe Viewer) command is great here:

pv db.sql | drush sqlc

Or if your database is compressed:

pv db.sql.gz | gunzip | drush sqlc

Using "pv" will show you a progress bar and a completion percentage. It's pretty awesome.

If you don't have "pv" then you can settle for the poor man's version:

watch "mysql database_name -Be 'SHOW TABLES' | tail -n2"

That slick little guy will show you the table that is currently importing, and auto-updates as it runs, so you can at least see how far through the table list it has gone.

Tools and Resource

In this post I tried to focus on commands that everyone already has. If this just isn't cutting it for you, then look into these tools which could help even more:

  • SyncDB - a couple Drush commands that split DB dumps into separate files and import them in parallel, drastically speeding things up
  • Drush SQL Sync Pipe - an alternative to "drush sql-sync" that uses pipes where possible to speed things up
mcrittenden Wed, 01/11/2017 - 23:15
Categories: Drupal

To help players train, Riot adds debug-esque 'Practice Tool' to League

Social/Online Games - Gamasutra - 11 January 2017 - 4:46pm

Riot Games is gearing up to add a new "Practice Tool" to League of Legends, a single-player mode that affords players remarkable game state editing tools they can use to quickly practice strategies. ...

Categories: Game Theory & Design

Fantasy Flight Games Announces New Star Wars: Destiny Boosters

Tabletop Gaming News - 11 January 2017 - 3:00pm
Star Wars: Destiny is the new card and dice game from Fantasy Flight where players build their own fantasy team and attack their opponents using equipment and abilities taken from all over the Star Wars universe. The initial release was pretty well tied in with The Force Awakens. Well, we’ve had another Star Wars movie […]
Categories: Game Theory & Design

Palantir: New Years Resolution: Spend More Time With Family and Friends

Planet Drupal - 11 January 2017 - 2:11pm
New Years Resolution: Spend More Time With Family and Friends brandt Wed, 01/11/2017 - 16:11 Allison Manley Jan 11, 2017

In this five-part series, every Monday in January we’ll explore a New Year’s resolution and how it can apply to your web project.

Stay connected with the latest news on web strategy, design, and development.

Sign up for our newsletter.

Surrounding oneself with a community of friends and family that offer needed support is important to us all. Palantir spent twenty years building our own culture and community right here at the office! But we’ve also been active members in the Drupal community for 12 years:

  • We’ve made contributions to every facet of the Drupal project: Core development, contributed modules, themes, financial assistance, training, documentation, conference organizing, and one Palantiri is a member of the Drupal Board.
  • This means we have a long history of helping organizations level up so they can become Drupal contributors and participants as well.
  • The collaboration in the open source community is one of the reasons Palantiri love Drupal so much.
Upcoming Events

Are you looking to get involved in the Drupal community? Some ideas:

Besides the Drupal and Open Source communities, Palantir works in some specific verticals that have their own rich and robust communities. We’re still finalizing exactly where we’ll be in 2017, but we know for sure you’ll find us at the following conferences so we can connect with friends in those industries and offer them support as needed:

Next week’s resolution: get organized. 

We'd love to help you keep your 2017 resolution.

Let's chat.
Categories: Drupal

Vanguard of War Board Game Up On Kickstarter

Tabletop Gaming News - 11 January 2017 - 2:00pm
Well, it would seem as though we’re surrounded. There’s a seemingly endless army of demons outside the tower and all of them want to come in. We don’t want them to come in because demons never wipe their feet and we just got new carpeting. So it’s up to the four of us to defend […]
Categories: Game Theory & Design

Apply now for the Amplifying New Voices program ahead of GDC 2017!

Social/Online Games - Gamasutra - 11 January 2017 - 1:30pm

Organizers of the Game Developers Conference want to remind everyone that the deadline to apply (or nominate someone else) for the Amplifying New Voices bootcamp at GDC 2017 is next week! ...

Categories: Game Theory & Design


Subscribe to As If Productions aggregator