b22n

package net.b22n.android.database;

import java.lang.ref.WeakReference;

import android.annotation.SuppressLint;
import android.content.ContentResolver;
import android.content.ContentValues;
import android.database.Cursor;
import android.net.Uri;
import android.os.Handler;

b22n

    public static boolean isYoutubeLink(String link) {
        link = link.trim();
        if (TextUtils.isEmpty(link)) return false;
        String pattern = "(http(?:s?):\\/\\/)?((?:www|m)(\\.))?youtu(?:be\\.com\\/watch\\?v=|\\.be\\/)([\\w\\-\\_]*)(&(amp;)?\u200C​[\\w\\?\u200C​=]*)?";
        return link.matches(pattern);
    }

    public static String extractYoutubeVideoId(String link) {
        link = link.trim();
        if (isYoutubeLink(link)) {

b22n

CREATE FUNCTION `GEO_DISTANCE`(point1 POINT, point2 POINT) RETURNS NUMERIC
RETURN 6371000 * acos(
      cos(radians(X(point2)))
      * cos(radians(X(point1)))
      * cos(radians(Y(point1)) - radians(Y(point2)))
      + sin(radians(X(point2)))
      * sin(radians(X(point1))) 
      );

b22n

CREATE FUNCTION `GEO_DISTANCE_KM`(point1 POINT, point2 POINT) RETURNS NUMERIC
RETURN 6371 * acos(
      cos(radians(X(point2)))
      * cos(radians(X(point1)))
      * cos(radians(Y(point1)) - radians(Y(point2)))
      + sin(radians(X(point2)))
      * sin(radians(X(point1))) 
      );

b22n

#!/bin/bash

for i in $( git tag | grep $1 ); do
  git tag -d $i
  git push origin :refs/tags/$i
done