Tutorials

Convert timestring to number Google Spreadsheet

by No3x on 7th May 2017 in Common, Tutorials • 0 Comments

function toMS(input) {
  const sRegex = /\d+s/g;
  const msRegex = /\d+ms/g;
  const usRegex = /\d+us/g;
  
  Logger.log("Running toMS with parameter: " + input);

  var sToMs = 0;
  var msToMs = 0;
  var usToMs = 0;
  
  while((seg = sRegex.exec(input)) !== null) {
    sToMs += parseInt(seg) * 1000;
  } 
  while((seg = msRegex.exec(input)) !== null) {
    msToMs += parseInt(seg);
  }
  while((seg = usRegex.exec(input)) !== null) {
    usToMs += parseInt(seg) / 1000;
  }
  
  usToMs += msToMs + sToMs;
  
  return usToMs;
}

function toUS(input) {
  return toMS(input) * 1000;
}

function toMS(input) {

const sRegex = /\d+s/g;

const msRegex = /\d+ms/g;

const usRegex = /\d+us/g;

Logger.log("Running toMS with parameter: " + input);

var sToMs = 0;

var msToMs = 0;

var usToMs = 0;

while((seg = sRegex.exec(input)) !== null) {

sToMs += parseInt(seg) * 1000;

}

while((seg = msRegex.exec(input)) !== null) {

msToMs += parseInt(seg);

}

while((seg = usRegex.exec(input)) !== null) {

usToMs += parseInt(seg) / 1000;

}

usToMs += msToMs + sToMs;

return usToMs;

}

function toUS(input) {

return toMS(input) * 1000;

}

JavaFX Gluon Ignite Guice Inject Controller

by No3x on 19th November 2016 in Java • 0 Comments

I had to inject a whole controller into another controller with the guice implementation of gluon ignite. I will show an approach doing so. This is applicable if you have set the controller id in your fxml. Otherwise this snipped requires slightly modifications. I assume you have ignite already running and injecting stuff already but facing the “inject a controller… Read more →

Bootstrap Shortcodes for WordPress Alternatives

by No3x on 28th June 2016 in WordPress • 0 Comments

Sometimes there are support request on the WordPress plugin bootstrap shortcodes to provide advanced bootstrap components (e.g. table builder). There are 2 reasons bootstrap shortcodes is not that advanced as you might assume: You can’t edit generated shortcodes – it’s not a visual builder There are some components missing I think it’s sufficient for some people that want to take… Read more →

VNC Server / VNC Viewer

by No3x on 30th July 2015 in Common, Tutorials • 0 Comments

Als Alternative zu RDP unter Windows bietet sich das VNC Protokoll an, das unter Linux weit verbreitet ist. Dieses bietet erheblich mehr Konfigurationsmöglichkeiten gegenüber RDP, die jedoch nicht zwangsläufig anfasst werden müssen. Gute Erfahrung habe ich mit der Software Real VNC gemacht – diese hat VNC Server für Windows, Mac, Linux und zusätzlich VNC Viewer für die genannten und weiterhin Android, iOS… Read more →

Generate Javadoc with UML Diagrams

by No3x on 25th March 2015 in Java • 0 Comments

It is very useful to have UML Diagrams integrated into your javadoc – they give you a neat visual overview of the contents of you sourcecode. I want to show you how to integrate this into an automated build. I implemented this with an ant target and my IDE Netbeans. Add this to your build.xml in the root of your… Read more →

Don’t Stick to hta Applications

by No3x on 26th February 2015 in Common • 0 Comments

If you have the burden to work on hta applications you might get into conflict with incompatibilities. So am I. I wanted to migrate a hta application from 2012 with bootsrap 2 to bootstrap 3. Bootstrap 3 doesn’t support IE 7 any more and also the fix with Respond.js doesn’t work in local files. So what now? I found node… Read more →

Revoke PGP key

by No3x on 5th August 2014 in Common • 0 Comments

Follow this tutorial if you want to revoke a pgp key. All you need for this is your private key and eventually the pass phrase to open it. At first you need to install pgp on your machine. I have installed GnuPG. Change to the install dir or add to PATH.

cd C:\Program Files (x86)\GNU\GnuPG

1	cd C:\Program Files (x86)\GNU\GnuPG

Next import your private key:

gpg2 --import priv.asc

1	gpg2 --import priv.asc

check if… Read more →

Find broken shortcodes

by No3x on 4th August 2014 in WordPress • 0 Comments

If you recently changed your theme and used shortcodes from it or disabled plugins you maybe want to find all leftovers of them because they are not translated any more. You will find things like [shortcode attribute=”bla”] all over website. Obviously you don’t want to review each post on your website to find them manually. So there comes a little… Read more →

sort functions – access class member

by No3x on 1st August 2014 in php • 0 Comments

If you want to sort a class member with the functions uasort, uksort, usort (the u stands for user-defined comparison function) you have to take care of some things. bool uksort ( array &$array , callable $key_compare_func ) The function takes as first parameter the array you want to sort as reference. Thereby no copy is made to the function stack and any changes are directly made on… Read more →

WordPress change post_date for tests

by No3x on 29th July 2014 in WordPress • 0 Comments

If you want to create a post via the post factory in you tests you can do it like this:

function test_getPostsInYear() {
$post1_id = $this->factory->post->create( array( 'post_date' => date( '2010-04-08 13:46:43' ) ) );
$post2_id = $this->factory->post->create( array( 'post_date' => date( '2014-04-08 13:46:43' ) ) );
..

function test_getPostsInYear() {

$post1_id = $this->factory->post->create( array( 'post_date' => date( '2010-04-08 13:46:43' ) ) );

$post2_id = $this->factory->post->create( array( 'post_date' => date( '2014-04-08 13:46:43' ) ) );

Make sure to pass a date! Unix timestamps or other formats won’t work. This creates 2 posts with different dates. You can test the function getPostsInYear(2014) as follows:

$result = $this->plugin->getPostsInYear( 2014 );
$post_ids = array();
foreach ( $result as $post ) {
	$post_ids[] = $post->ID;
}
		
$this->assertNotContains( $post1_id, $post_ids );
$this->assertContains( $post2_id, $post_ids );

$result = $this->plugin->getPostsInYear( 2014 );

$post_ids = array();

foreach ( $result as $post ) {

$post_ids[] = $post->ID;

}

$this->assertNotContains( $post1_id, $post_ids );

$this->assertContains( $post2_id, $post_ids );

Post1 should not be returned by getPostsInYear( 2014 ) because… Read more →