Bytefreaks.net – a place for hacks

Applications

Delete a paste from a private hosted Stikked installation

7 April 2016 in Stikked tagged mysql / stikked by Tux

To delete a paste from a Stikked installation that you have database access do the following:

Visit the post you like to delete: e.g http://example.com/stikked/htdocs/view/267c4d64
From this URI we need to get the part after view which is the pid (paste ID) of the paste you want to delete. In this case we get 267c4d64.

Then, you need to login to your MySQL DB. In case you are connecting via a terminal you would be using a similar command to this:

mysql -D MY_DB -h MY_HOST -u MY_USER -p

Replace MY_DB, MY_HOST and MY_USER with your credentials, afterwards you will be prompted for you password (if any).

Once in the MySQL console, issue the following:

DELETE FROM `pastes` WHERE `pid` = "267c4d64";

The above line will find the paste we want to delete and perform the deletion.

If you want to see the structure of the pastes table issue the following: SHOW COLUMNS FROM `pastes`;

Type exit to exit the MySQL console.

[Video] Android OpenCV – Face Detection and Recognition Demo

5 March 2016 in Android / Face Recognition tagged android / face detection / face recognition / jni / ndk / opencv by Tux

Android OpenCV – Face Detection and Recognition Demo using Android NDK/JNI to load OpenCV library.

Google Play: https://play.google.com/store/apps/details?id=net.bytefreaks.opencvfacerecognition

Our application is based on the ‘Face Detection’ sample of OpenCV. The sample that is available for download from http://sourceforge.net/projects/opencvlibrary/files/opencv-android/, you will notice that there are many versions there, we used version 2.4.11. Refer to this (http://docs.opencv.org/2.4/doc/tutorials/introduction/android_binary_package/O4A_SDK.html) introduction for more information.