Is there a PHP refactoring tool to tell what functions are never called?
How can I find unused functions in a PHP project
Preventing applications from stealing focus Are there any solutions to prevent applications stealing focus from the active window?   This is especially annoying when I'm starting an application, switch to do something else and the new application starts receiving half a sentence of text. Calculating lat/lons from PostGIS table which has projected coordinate system? I have a PostGIS table in a projected coordinate system (EPSG: 28355 or MGA94 Zone 55). In QGIS (with the PostGIS manager plugin) I calculate a coordinate by performing the following SQL:  UPDATE gisprod.buildings SET easting = x(centroid(the_geom))    Now I want to add a "lat" and "lon" field to this table and calculate the values using the appropriate coordinate system, in this case that would be (EPSG:4283 or GDA94).   Is there a way I can specify in the SQL statement to calculate the x/y coord using a different coordinate system? I am looking for information on Heinrich Märte (my grandfather) and his family. He was born on July 1, 1912 in Sipplingen and died On April 19, 1944 when the military plane crashed in Geierswalde because its engine failed.  I am not sure if his family knows that he fathered my dad. I am hoping someone knows of him or his family. I would love to know how he met my grandmother or any further information on him.   We have always had two photo's of him, but never knew his name. We have only just found out about him and it has opened so many more questions.  How can I determine Heinrich's parents and siblings, and then locate any living family members? Removing Ubuntu from a dual-boot setup with Windows What training do doctors/Healers receive above their school education?   A fresh Hogwarts graduate does not seem to have all the skills required to be a Healer, so s/he would need to be learning those skills somehow/someplace. So how/where do they get those skills?  Also, there is one instance of a doctor being praised for inventing a healing spell. Is there any research system, like funding, trials etc or any other source of innovation? I'm looking to find records in a table that match a specific number that the user enters.  So, the user may enter 12345, but this could be 123zz4-5 in the database. I imagine something like this would work, if PHP functions worked in MySQL. SELECT * FROM foo WHERE preg_replace(&quot;/[^0-9]/&quot;,&quot;&quot;,bar) = '12345'  What's the equivalent function or way to do this with just MySQL? Speed is not important. How to make use of Devel debugging functions on large or complex objects I am having trouble making real use of Devel's debugging functions kint() and dpm() in my modules and twig templates. They work fine for primitive variables, flat arrays and such, but if I want to inspect into some object like an EntityRerefenceFieldItemList they either cause the site to crash (white page) or generate so much data such that the scripts for expanding the list no longer work.  How do I circumvent these problems? What methods can I use to create balance and consistency between a group of differing logos? A regular challenge that I face is balancing two (or more) logos. Whether they need to be equal or one needs to be given priority. Some logos however might be squares, others rectangles, circles, etc...   As a quick sample I snagged a nice high resolution photo from  and pretend its going to be an advertisement that needs to show some footwear brand logos on it. In this case I used Adidas and Saucony.  This is certainly not balanced even though they're height is the same:    Likewise this is not balanced even though they're width is the same:    So then the question becomes when are they in balance, is this balance:    Maybe a little more adjustment, is this balance:    And in these examples I'm only working with two Black Logos. Factor in color and it can get even more difficult to balance. Another issue being when there's tiny text as part of the logo.  So the question is, other than estimating / eye-balling it, what tips, methods or even tools are there to balance different sized logos? Approximation of real number to the power of irrational Say I have two numbers, $c\in\Bbb R^+\,,q\in\Bbb{R\setminus Q}$.  Is there a way to approximate the value of $c^q$?  This question bugging me because of how simple it sound in compare to how complicated it is. First I want to understand what a power of irrational number is, when talking about $\Bbb R^+$(I use this domain for sake of simplicity) we have very well defined actions for power a rational number, we can even use some theorems to get $c^{a/b}=\sqrt[b]{c^a}$, but when I am dealing with irrational number I can not do this.  I know that we have some definition for this because the solution of the equation $2^x=3$ is irrational.  So what exactly does it mean to take something to a irrational power and is there a way to approximate a numeric value for this? Converting spoken word audio files into text I've been working on transcribing a lecture series from audio to text files.  There are just over 20 lectures, and each one is about an hour long.  Using VLC Player, I'm able to slow down the speaker's words to a rate that I can keep up with.  However, it's extremely slow going, and it takes so much concentration that I can barely get through a third of a lecture before I have to take an extended break.  The thought had occurred to me that I would be better served by using some kind of speech recognition software, and then proofreading the computer-generated result.  This is likely to be a one-time thing, so while I don't mind using commercial software to get the job done, it would be preferable if it wasn't too expensive (or free; free is always good).  Command-line solutions are fine, too (:  Any suggestions? Subtracting from a specific column std::auto_ptr to std::unique_ptr Figuring out algorithm/formula for item scaling in WoW Order of finite fields is $p^n$ I just enabled the Blenderkit addon but cannot seem to figure out how to edit the objects. I looked in this reddit thread and amazingly none of the solutions worked for me.  Making it a single user object, data, and materials did not work. I do not see any option to append when adding a model form the Blenderkit asset bar (I even tried saving it and appending the object in another instance of Blender and it still would not let me edit it). And when I right click I do not see an option to make local on outliner collection. I am using Blender 2.83 if that makes a difference but can use 2.9 if need be. Any other solutions? We add negative numbers and zero to natural sequence to make it closed under subtraction, the same thing happens with division (rational numbers) and root of -1 (complex numbers).  Why this trick isn't performed with division by zero? Why is English written and read from left-to-right as opposed to right-to-left, top-to-bottom, or (not even sure any language does this) bottom-to-top? How to print the name of missing files in a folder? Error 404 : While using flag Recently on Stack Overflow I got privilege to flag a post. So when I try to flag a post as duplicate. The diaglog box is not properly loading.         However I am easily able to use other flag option like "other","spam" or "offensive".   "other"        "spam"        "offensive"        I am using Google Chrome Version 28.0.1500.71 and Win XP Operating System. I have tried in firefox as well but it is showing me same problem. I want to typeset a piece of code containing line breaks.  New lines should indent to a specified point in the previous line.  Here is a monospaced example to illustrate what I mean.  Notice how 'case' and 'of' line up below, as well as 'let' and 'in':  swap : forall a, b. Tuple a b -&gt; Tuple b a swap a b x = case x              of tuple a b y z. let x' = tuple b a z y                                in x'   The code I want to typeset is not monospaced, so I can't just use a verbatim environment to get what I want.  The actual LaTeX of the first line, for instance, is  \mathsf{swap} : \forall\alpha,\beta.\;\mathsf{Tuple}\;\alpha\;\beta\to\mathsf{Tuple}\;\beta\;\alpha   How can I align some text to a specific point in the previous line?