I've been moving along my progression line at a brisk pace in Terraria lately, all the way up to a full set of Crimsonite Armor and weapons, a Minishark (I prefer it until I get a better supply of stars for the Star Canon), and basically all the meteorite equipment I want. I'm ready to take on the Dungeon, but there's one biome I have yet to fully explore...

My Underground Ice Biome.

This is a bit ironic, since I decided to move my home on top of that biome, but I only ever explored the depths of it a little bit one time, and while that got me a nice Ice Boomerang and a Frost In A Bottle, I hardly ever use the Boomerang anymore and I don't think I'll need more than one X in a bottle from there.

Is there any reason to further explore my underground Ice Biome? Are there any unique items I'd be missing by going straight to the dungeon and, from there, the sky and eventually down to Hell?

I have a "share on Twitter" button on my website that allows users to easily share a tweet with the web page. The page features a photo, and we would really like to have users tweet the photo itself out.

Is it possible to build "tweet this photo" functionality from my website?

If I fill the image URL into the tweet, Twitter shows a link to the image, but not the image itself. Users can upload photo to twitter that get shown fully in Twitter.

I'm working on a project - the site is currently set up with a 'language' toggle on the homepage (gives the option of the site in Eng, and two other languages). However, not all the pages in the languages (other then English) actually have translations on the site (so they've chosen to translate some 'main' areas of the site in the two other languages). This presents a really inconsistent user experience. Also, we know that people don't look for a language, they prefer looking for where they're based (as the reason why they want to view the site in their language is because they're after offices/project information in that area) - that's based on user testing we've carried out.

We have suggested only translating the Location/Office pages and then building up into Country sites in the future (they have limited budget for translation atm).

The client has challenged: "What we have at the moment is symbols visible from the homepage of the site to view top level pages in a different language. If we go country first, and the point of access to these translated pages is from country pages, how does this work from a UX point of view? How does the user sitting in Peru who lands on the homepage know that there is translated content available?"

My answer is to explain again about the inconsistent (current) user experience and the fact that if someone is googling in Peru for Peru language content on their Company, Google would hopefully pick up the page that's translated and take them directly there.

Has anyone come across this issue before? Any advice on what else could be done/advice to give the client or best practice to do in the interim (as they can't do Country/Language sites straight away due to budget). IP detection is out of the scope too.

Thank you in advance.

I'm working on a boilerplate component that's supposed to generate a working sort-of "getting started" project structure. Think of it, in a web app context, of a component that will generate a Controller, a View and the routes configuration so that once you call it, you can immediately go to the browser, type the route and you'll get the output.

In this boilerplate, one of my class has the responsibility of providing the content of every file it generates (the content of the controller file, the content of the routes file, the content of the views fie, etc).

With such a responsibility, wheareas one method should return the content foo, the test should verify that, in fact, 'foo' is returned.

It ends up looking like this:

// SUT
function getFooFileContent() {
    return 'foo';
}

// test
function testGetFooFileContent() {
    string expected = 'foo';

    string result = sut.getFooFileContent();

    assertEquals(expected, result);
}

The people I'm explaining the reason for this test are new to unit testing, so it's normal for them not to grasp at first sight why is this OK, and have doubts whether this test actually has a value to begin with.

Since I'm in charge of introducing unit testing to my team, I want to explain this backed up by resources that explain this "type" of test in particular, so that I have a solid argument rather than asking them to just accept that kind of test.

PS: For the record, when I started with unit testing (self taught, no mentor sadly), I had the same doubt. In my case I just accepted the test and got to understand its value over the years, when I could finally see the fact that tests are supposed to bind functionality to specifications. It's hard to see that when you're starting.

Update 1:

Due to the fact of my question marked as duplicated for the common should I test a getter/setter? I say:

This is not really a getter and the question is not about whether is worth it or not. The class specification is to provide a template text for a boilerplate. The implementation could very well evolve into having it read the text from a non *.php file, and, in that case, a test would have value as it would bind the specification to the functionality.

The question is how to explain the fact that, even with the current implementation (the one that is just returning a string block) the test itself is correct. I'm specifically asking for resources that backup that argument.

In this excellent answer I learned how to extract a series of individual frames from a movie clip node.

This solution suits me well - there is a python script, and a few nodes, and it runs automatically.

Is there a way I could extract the audio from a clip - either the whole thing, or possibly just between two frame number limits, using a similarly simple technique in Blender? For me simple is python and nodes - I am not an advanced user, and something I can automate and customize is the most useful in my case.

I've have tried to examine the attributes of the vidNode but didn't find anything that looked like audio:

S = bpy.context.scene
n = S.node_tree

vidNode = n.nodes['Movie Clip']

enter image description here

Long story, but briefly I am debating knocking down a paper wasp nest. I don't want to kill the wasps, because (1) they're beneficial wasps, and (2) I would not have even known they were there, except I came face-to-face with the nest (~1 foot) and they didn't act remotely aggressive at all (karma).

My concern is that I've been out of town for a couple weeks, and I don't know if the nest has been under my deck all year and they were actually relatively sedate, or if the nest has developed recently. I mow regularly, and my big concern is that the noise of the mower and weed eater is going to agitate the wasps into stinging.

The wasp nest is under my deck, and my dog crosses the deck to get to the back yard frequently. I also have a toddler, but we generally play with him in the front yard, which is separated from the back yard by a fence.

So, tl;dr - A wasp nest is a little smaller than a baseball and covered in about 15 wasps. Has this nest been under my deck all year (and I can mow without worry as I have in the past), or has this nest sprung up since I stopped mowing (about 2 weeks) and I should remove it before I mow again?

I am looking for a game mechanic for a game I am designing, that would let players randomly select other players, but that by the end of the game all the players were selected equally.

My first instinct was the destiny deck from Cosmic Encounters. In that game there is a deck with a few cards representing each player. On their turn the player draws a card, and interacts with the selected opponent. The limitation of this solution is that sometimes players select themselves. Cosmic encounters solves this by having rules for how to interact with yourself, but my game lacks this. Even if i was to simply put the card on the bottom of the deck and draw a new one, there is a chance with the last card being left of the last player who must take the last turn. At this point selecting another player randomly would unbalance the game, giving them an extra time they are selected. Is there any other mechanic that can be used to solve this? (I am in no way set on using cards. Any mechanic would be OK)

If I say \usepackage{lastpage} I got \xdef\[email protected]{53} at the end of .aux-file. I tested and

\xdef\[email protected]{53}

\newcount\tmp
\advance\tmp \[email protected] \relax
\advance\tmp -1 \relax
This document has \the\tmp {} pages (not counting titlepage).

works. However

\advance\tmp \[email protected] \relax

Does not. So how can I get values defined in some LaTeX package "to plain TeX", i.e. to be used with plain TeX commands like \advance?

After reading following blogs, I understand that hash match aggregate causes blocking. Using appropriate indexes it can be made as stream aggregate.

  1. Blocking/non-blocking aggregate operators
  2. The blocking nature of aggregates - Rob Farley
  3. Hash Aggregate-Craig Freedman

I have a database that has over 200 tables which has been created years back. I am trying to find all queries with group by that is currently working with hash match aggregate operator. One possibility I found is using dmv like below. But I don't know how to filter it to list only queries with hash match aggregate operators. How to achieve this? Also, on a big picture level, what are the other options to get this information other than following dmv?

SELECT cp.objtype AS ObjectType,
    OBJECT_NAME(st.objectid,st.dbid) AS ObjectName,
    cp.usecounts AS ExecutionCount,
    st.TEXT AS QueryText,
    qp.query_plan AS QueryPlan
FROM sys.dm_exec_cached_plans AS cp
CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) AS qp
CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) AS st
WHERE st.TEXT LIKE '%GROUP%'

I know that vegetable is a count noun, but Which one of the quantifiers do we use with vegetables. How much vegetables do our bodies need? How many vegetables do our bodies need?