This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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))) | |
); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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))) | |
); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)) { |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |