Showing posts from October, 2019

Get The Password for a Quickbooks QBW File

A C Program to Recover Your Quickbooks Pro 5.0 File
Sure it's old, but I will share it with the world. It works with Quickbooks 5.0. The password is stored at offset 7635 and is "scrambled" by swapping nibbles. You can compile this using the GNU C compiler on almost linux distro.  Then bring your QB file over and run this little program to expose your password.

/* -*-C-*-********************************************************************************* File: get-qb-pw.c* RCS: $Id: $* Description: get the "quick books pro" password* Author: Eric Blossom* Created: Tue Aug 18 14:09:30 1998* Modified: Tue Aug 18 17:39:22 1998 (eric)* Language: C* Package: N/A* Status: Experimental (Do Not Distribute)*********************************************************************************//* * This has been tested only on QuickBooks Pro version 5.0 */#include <stdio.h> main (int argc, char**argv) { FILE*…

How to Install OpenVPN

How to Install Open VPN on Ubuntu See this great blog entry.

A MySQL Wrapper for mysqli - old skool mysql

A Wrapper for mysqli to Enable Old Skool Mysql
Get this cool mysql wrapper from github to retrofit your old skool mysql / php code to work on php7 where mysql has been replaced by mysqli.   If you are seeing this error in your old php5 code, and you have calls to old mysql functions all of the place, you can quickly retrofit your programs.

1 2 3 4 5 6 7PHP Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /opt/bitnami/apache2/htdocs/lib/class.db.php:29 Stack trace: #0 /opt/bitnami/apache2/htdocs/lib/class.db.php(24): Db->connect()#1 /opt/bitnami/apache2/htdocs/common/config.php(21): Db->Db('localhost', 'dbadmin', 'Sick1234', 'demodatabase')#2 /opt/bitnami/apache2/htdocs/mysql-test.php(6): include('/opt/bitnami/ap...')#3 {main} thrown in /opt/bitnami/apache2/htdocs/lib/class.db.php on line 29
where line 29 has this bit of code

27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 /* Estab…

How to Restore Legacy mysql to php7 - when you really hate mysqli

How to put MySQL functions back into PHP 7PHP 7 will go “release candidate” on August 20th 2015 which is very exciting because it will instantly be twice as fast as PHP 5.6 (and all previous versions). PHP7 gives HHVM a run for the money and takes 5 minutes to compile instead of hours for HHVM. But there is a catch – if you have any legacy code that uses the mysql_* functions, they will stop working entirely in PHP 7. Not just a warning, not just deprecated, but gone, fatal. Sorry guys. However, there is another work around to restore your old mysql without breaking the bank.  My other alternative is to use a mysqli wrapper. See my other blog post:. However, it is easy to get them back without using a wrapper or modifying your code…
I wouldn’t plan on using this solution far past 2016 but it will keep your legacy code running in the meanwhile. Simply compile the mysql function as a php pecl extension and add one line to your php.ini First get the mysql extension source which was removed in…

How to Convert Apple QuickTime .MOV files to H264 on Ubuntu command line like a boss

Convert Your Bloated Apple QuickTime .MOV videos to H264 .MP4 with ffmpeg Everybody knows that Apple QuickTime is an outdated and bloated video format that requires extra codecs to play on Windows 7 and 10, plus you need Apple Itunes or Apple QuickTime to play it back.  On Windows 7 and 10, you also need VLC media player or the codec pack to play it back with Windows Media player.  It's so bloated that a 3 minute video can easily fill up 1 GB of disk space.  Plus native QuickTime can easily fill up your icloud account.  Furthermore, it's an outdated format that will soon be obsolete. So, convert the videos to H264 video to compress down to 1/10 the file size and be playable on Windows Media Player and be ready for upload to YouTube.  Compress it and reduce the frame rate with ffmpeg to reduce the file size by 95% or more.

First thing you need is Ubuntu 14 to 16+ LTS running on a decent core i7 machine with at least 4 cores. Then once you get that, you need to use apt to insta…