Android and Backtrack

There is a way to install Backtrack on Android.

PHP/MySQL ending in JSON that Needs Optimization

I am testing this code versus "Insert ... where Select ..." and testing MySQL return codes.

function sql_safe($s) { if (get_magic_quotes_gpc()) $s = stripslashes($s); return mysql_real_escape_string($s); }

$flag = "0"; // set flag to good at the start of program
// The user is coming in as the integer id
$user = trim(sql_safe($_POST["User"]));

if ($user == '') $user = 0;
// The member is coming as the text input
$member = trim(sql_safe($_POST["Member"]));
// could do a sub select query, but broke out for clarity.

if ($member != '') {
$sel=mysql_query("SELECT `idmembers` from `a5035822_mya55`.`members` where `handle` = '$member';") or trigger_error ('Error on select handle'.mysql_error(),E_USER_ERROR);

$r1 = mysql_fetch_array($sel);
//echo "r1 is".$r1['idmembers'];
// make sure not trying to delete the owner userid.
// will perform check on the device first with next version of app

if (($r1['idmembers'] != '') && ($r1['idmembers'] != $user)) {
// No composite key on SETS table so no checking for MySQL ret code 1062.
// Separate check to see if row exists first, then delete if it does.
$memberid = $r1['idmembers'];
$checkSet = MySQL_query("select `member` from sets where owner = $user and member = $memberid;") or trigger_error('Failed on check'. mysql_error(), E_USER_ERROR);
$r2 = MySQL_fetch_array($checkSet);

if ($r2['member'] != '') { $del = mysql_query("delete from sets where owner = $user and member = $memberid;") or trigger_error('Failed on delete'. mysql_error(), E_USER_ERROR);

if (mysql_error() == 0) {
$flag = 0;

} else {
$flag = 3; // no row to delete
}

} else { $flag = 3; }

} else {
$flag = 3;
$memberid = $user;
}

} else { $flag = 5; };
$data = array (
'Flag' => $flag,
);

print(json_encode($data));

NSA, PRISM and Tor

NSA = National Security Agency

PRISM = Planning Tool for Resource Integration, Synchronization, and Management

Tor = The Onion Router.

PRISM vs Tor

Technical Sales

I recently transitioned from strictly programming to retail sales of computers and peripherals. This requires a significant learning curve as my minimalist existence precludes me from possessing the latest technology with all the bells and whistles. For example, I do not get text messages nor do I own a smart phone. Oddly enough, however, folks trust my ability to help them, because I look Asian, where glasses, assess their needs and logically explain what I would do given their requirements.

Microsoft Accounts versus Local Accounts on Windows 8

How To Geek explains.

Failwords

PayPal Says It's Time to Ditch Passwords and PINs http://shar.es/lSu1g via @CIOonline.

So let me get this straight...Hmmm...Let us no longer trust the individual to come up with secure passwords, but rather standardize account authentication through some oversight organization. Does this sound like a good idea or just another liberal ploy to remove individual responsibility in favor of a larger and much smarter collective that knows what is best.

Thank God for these smart people to help me with my life, because I am too stupid to realize the importance of passwords.

Windows 8 shortcuts

The future is touch interface, but keyboards are still essential as evidenced by Windows 8 shortcuts. See 10 useful keys by LifeHacker.