NNTmux / newznab-tmux

misc/testing/spotnab.php

Indentation +9 added lines, -9 removed lines

@@ -324,17 +324,17 @@
 if(array_key_exists("F", $options) ||
 	array_key_exists("fetch-backfill", $options)){
 	$days = array_key_exists("F", $options)?$options["F"]:$options["fetch-backfill"];
-    try{
-    	$days = abs(intval($days));
-    }catch(Exception $e){
+	try{
+		$days = abs(intval($days));
+	}catch(Exception $e){
 		$days = -1;
-    }
+	}
 
-    if($days <= 0){
-    	echo "Error: A SpotNab fetch backfill requires you specify the number of days to look back.\n";
-    	echo "Syntax: php spontnab.php -F=<days>\n";
-        exit(1);
-    }
+	if($days <= 0){
+		echo "Error: A SpotNab fetch backfill requires you specify the number of days to look back.\n";
+		echo "Syntax: php spontnab.php -F=<days>\n";
+		exit(1);
+	}
 	echo "Fetching $days day(s) back ... ";
 	$spotnab = new SpotNab();
 	$spotnab->fetch(time()-($days*86400));

Spacing +65 added lines, -65 removed lines

@@ -212,7 +212,7 @@ 
 
 $options = getopt($shortopts, $longopts);
 
-function display_help(){
+function display_help() {
 	echo "\n";
 	echo "SpotNab v0.97.4, Author: l2g\n";
 	echo "Syntax: spotnab.php <action>\n";
@@ -265,28 +265,28 @@ 
 	echo "\n";
 }
 
-if(!$options){ display_help(); exit(1);}
-if(!count($options)){ display_help(); exit(1);}
+if (!$options) { display_help(); exit(1); }
+if (!count($options)) { display_help(); exit(1); }
 
 $delete_broken_releases = false;
-if(array_key_exists("G", $options) ||
-	array_key_exists("populate-fix-gid", $options)){
+if (array_key_exists("G", $options) ||
+	array_key_exists("populate-fix-gid", $options)) {
 	echo "Updating GID in releases table + fix ...";
 	$spotnab = new SpotNab();
-	$spotnab->processGID(0,5000,true);
+	$spotnab->processGID(0, 5000, true);
 	echo "Done\n";
 }
 
-if(array_key_exists("g", $options) ||
-	array_key_exists("populate-gid", $options)){
+if (array_key_exists("g", $options) ||
+	array_key_exists("populate-gid", $options)) {
 	echo "Updating GID in releases table ...";
 	$spotnab = new SpotNab();
 	$spotnab->processGID();
 	echo "Done\n";
 }
 
-if(array_key_exists("r", $options) ||
-	array_key_exists("soft-reset", $options)){
+if (array_key_exists("r", $options) ||
+	array_key_exists("soft-reset", $options)) {
 	echo "Soft Reseting Spotnab... ";
 	$spotnab = new SpotNab();
 	$spotnab->soft_reset();
@@ -294,79 +294,79 @@ 
 }
 
 $force_keygen_save = false;
-if(array_key_exists("K", $options) ||
-	array_key_exists("force-keygen", $options)){
+if (array_key_exists("K", $options) ||
+	array_key_exists("force-keygen", $options)) {
 	$spotnab = new SpotNab();
 	$spotnab->keygen(true, true);
 }
-else if(array_key_exists("k", $options) ||
-	array_key_exists("keygen", $options)){
+else if (array_key_exists("k", $options) ||
+	array_key_exists("keygen", $options)) {
 	$spotnab = new SpotNab();
 	$spotnab->keygen(true);
 }
 
-if(array_key_exists("p", $options) ||
-	array_key_exists("post", $options)){
+if (array_key_exists("p", $options) ||
+	array_key_exists("post", $options)) {
 	echo "Posting... ";
 	$spotnab = new SpotNab();
 	$spotnab->post();
 	echo "Done\n";
 }
 
-if(array_key_exists("d", $options) ||
-	array_key_exists("discover", $options)){
+if (array_key_exists("d", $options) ||
+	array_key_exists("discover", $options)) {
 	echo "Discovering... ";
 	$spotnab = new SpotNab();
 	$spotnab->fetch_discovery();
 	echo "Done\n";
 }
 
-if(array_key_exists("F", $options) ||
-	array_key_exists("fetch-backfill", $options)){
-	$days = array_key_exists("F", $options)?$options["F"]:$options["fetch-backfill"];
-    try{
+if (array_key_exists("F", $options) ||
+	array_key_exists("fetch-backfill", $options)) {
+	$days = array_key_exists("F", $options) ? $options["F"] : $options["fetch-backfill"];
+    try {
     	$days = abs(intval($days));
-    }catch(Exception $e){
+    } catch (Exception $e) {
 		$days = -1;
     }
 
-    if($days <= 0){
+    if ($days <= 0) {
     	echo "Error: A SpotNab fetch backfill requires you specify the number of days to look back.\n";
     	echo "Syntax: php spontnab.php -F=<days>\n";
         exit(1);
     }
 	echo "Fetching $days day(s) back ... ";
 	$spotnab = new SpotNab();
-	$spotnab->fetch(time()-($days*86400));
+	$spotnab->fetch(time() - ($days * 86400));
 	echo "Done\n";
 
 
-}else if (array_key_exists("f", $options) ||
-	array_key_exists("fetch", $options)){
+} else if (array_key_exists("f", $options) ||
+	array_key_exists("fetch", $options)) {
 	echo "Fetching... ";
 	$spotnab = new SpotNab();
 	$spotnab->fetch();
 	echo "Done\n";
 }
 
-if(array_key_exists("b", $options) ||
-	array_key_exists("broadcast", $options)){
+if (array_key_exists("b", $options) ||
+	array_key_exists("broadcast", $options)) {
 	echo "Broadcasting... ";
 	$spotnab = new SpotNab();
 	$spotnab->post_discovery();
 	echo "Done\n";
 }
 
-if(array_key_exists("t", $options) ||
-	array_key_exists("test", $options)){
+if (array_key_exists("t", $options) ||
+	array_key_exists("test", $options)) {
 	$spotnab = new SpotNab();
 
-	if($spotnab->has_openssl())
+	if ($spotnab->has_openssl())
 	{
 		printf("%s INFO - Testing SSL Key Generator ...",
 					date("Y-m-d H:i:s"));
 		$keys = $spotnab->keygen(false);
-		if(is_array($keys) &&
+		if (is_array($keys) &&
 			array_key_exists("pubkey", $keys) &&
 			array_key_exists("prvkey", $keys))
 		{
@@ -374,8 +374,8 @@ 
 			$pubkey = $spotnab->decompstr($keys['pubkey']);
 			$refc = $spotnab->getRandomStr(80);
 			$refd = $spotnab->decrypt($spotnab->encrypt($refc, $prvkey), $pubkey);
-			echo ($refc == $refd)?"Successful!\n":"Failed!\n";
-		}else{
+			echo ($refc == $refd) ? "Successful!\n" : "Failed!\n";
+		} else {
 			echo "Failed!\n";
 		}
 
@@ -383,11 +383,11 @@ 
 				date("Y-m-d H:i:s"));
 		$preMsg = $spotnab->getRandomStr(800);
 		$postMsg = $spotnab->decrypt($spotnab->encrypt($preMsg));
-		if($postMsg === false){
+		if ($postMsg === false) {
 			echo "Failed!\n";
-		}else if(!strcmp($preMsg, $postMsg)){
+		} else if (!strcmp($preMsg, $postMsg)) {
 				echo "Successful!\n";
-		}else{
+		} else {
 			echo "Failed!\n";
 		}
 
@@ -406,7 +406,7 @@ 
 					'comment' => 'testing comment 1',
 					'username' => 'l2g',
 					'is_visible' => 1,
-					'postdate_utc' => $spotnab->local2utc(time()-86400)
+					'postdate_utc' => $spotnab->local2utc(time() - 86400)
 				),
 				array(
 					'gid' => 'ABCDEFHIJKLMNOPQRSTUVWXYZ0123456',
@@ -414,19 +414,19 @@ 
 					'username' => 'l2g-hater',
 					'is_visible' => 1,
 					'comment' => 'testing comment 2',
-					'postdate_utc' => $spotnab->local2utc(time()-86000)
+					'postdate_utc' => $spotnab->local2utc(time() - 86000)
 				)
 			)
 		);
 		$article = $spotnab->encodePost($before, Null, true);
-		if($article !== false){
+		if ($article !== false) {
 			$after = $spotnab->decodePost($article[1]);
-			if($before === $after){
+			if ($before === $after) {
 				echo "Successful!\n";
-			}else{
+			} else {
 				echo "Failed!\n";
 			}
-		}else{
+		} else {
 			echo "Failed!\n";
 		}
 		printf("%s INFO - Testing big message encode/decode ...",
@@ -439,26 +439,26 @@ 
 			'postdate_utc' => $spotnab->local2utc(),
 			'comments' => []
 		);
-		for($i=0;$i<3000;$i++){
+		for ($i = 0; $i < 3000; $i++) {
 			// Build large post
-			$before['comments'][] =array(
+			$before['comments'][] = array(
 				'gid' => 'ABCDEFHIJKLMNOPQRSTUVWXYZ0123456',
 				'cid' => 'ABCDEFHIJKLMNOPQRSTUVWXYZ0123456',
-				'comment' => $refc = $spotnab->getRandomStr(rand(15,200)),
+				'comment' => $refc = $spotnab->getRandomStr(rand(15, 200)),
 				'username' => 'bb',
 				'is_visible' => 1,
-				'postdate_utc' => $spotnab->local2utc(time()-86400)
+				'postdate_utc' => $spotnab->local2utc(time() - 86400)
 			);
 		}
 		$article = $spotnab->encodePost($before, Null, true);
-		if($article !== false){
+		if ($article !== false) {
 			$after = $spotnab->decodePost($article[1]);
-			if($before === $after){
+			if ($before === $after) {
 				echo "Successful!\n";
-			}else{
+			} else {
 				echo "Failed!\n";
 			}
-		}else{
+		} else {
 			echo "Failed!\n";
 		}
 
@@ -473,21 +473,21 @@ 
 			// We want to find new content, so to make our header
 			// new, we need to take our ref time and back down
 			// one second so it can be processed..
-			'ref' => $article[2]['Epoch']-1
+			'ref' => $article[2]['Epoch'] - 1
 		));
 
 		// Fake headers (use debug information from encodePost)
 		$headers = array($article[2]);
 
 		$matched = $spotnab->process_comment_headers($headers, $hash, false);
-		if($matched !== false){
+		if ($matched !== false) {
 			$inserted = $matched[0];
 			$updated = $matched[1];
-			echo ($matched > 0)?"Successful!\n":"Failed!\n";
-		}else{
+			echo ($matched > 0) ? "Successful!\n" : "Failed!\n";
+		} else {
 			echo "Failed\n";
 		}
-	}else{
+	} else {
 		printf("%s WARNING - openssl is not correctly installed; broadcasts and posts will be disabled.\n",
 				date("Y-m-d H:i:s"));
 	}
@@ -496,36 +496,36 @@ 
 				date("Y-m-d H:i:s"));
 	$refa = $spotnab->utc2local();
 	$refb = $spotnab->utc2local($spotnab->local2utc($refa));
-	echo ($refa == $refb)?"Successful!\n":"Failed!\n";
+	echo ($refa == $refb) ? "Successful!\n" : "Failed!\n";
 	printf("%s INFO - Testing UTC/Local conversions [2/6]...",
 				date("Y-m-d H:i:s"));
 	$refa = $spotnab->local2utc();
 	$refb = $spotnab->local2utc($spotnab->utc2local($refa));
-	echo ($refa == $refb)?"Successful!\n":"Failed!\n";
+	echo ($refa == $refb) ? "Successful!\n" : "Failed!\n";
 	printf("%s INFO - Testing UTC/Local conversions [3/6]...",
 				date("Y-m-d H:i:s"));
 	$refa = $spotnab->local2utc(date("Y-m-d H:i:s"));
 	$refb = $spotnab->local2utc($spotnab->utc2local($refa));
-	echo ($refa == $refb)?"Successful!\n":"Failed!\n";
+	echo ($refa == $refb) ? "Successful!\n" : "Failed!\n";
 	printf("%s INFO - Testing UTC/Local conversions [4/6]...",
 				date("Y-m-d H:i:s"));
 	$refa = $spotnab->utc2local(time());
 	$refb = $spotnab->utc2local($spotnab->local2utc($refa));
-	echo ($refa == $refb)?"Successful!\n":"Failed!\n";
+	echo ($refa == $refb) ? "Successful!\n" : "Failed!\n";
 	printf("%s INFO - Testing UTC/Local conversions [5/6]...",
 				date("Y-m-d H:i:s"));
 	$refa = $spotnab->local2utc(time());
 	$refb = $spotnab->local2utc($spotnab->utc2local($refa));
-	echo ($refa == $refb)?"Successful!\n":"Failed!\n";
+	echo ($refa == $refb) ? "Successful!\n" : "Failed!\n";
 	printf("%s INFO - Testing UTC/Local conversions [6/6]...",
 				date("Y-m-d H:i:s"));
 	$refa = $spotnab->utc2local(gmdate("Y-m-d H:i:s"));
 	$refb = $spotnab->utc2local($spotnab->local2utc($refa));
-	echo ($refa == $refb)?"Successful!\n":"Failed!\n";
+	echo ($refa == $refb) ? "Successful!\n" : "Failed!\n";
 }
 
-if(array_key_exists("o", $options) ||
-	array_key_exists("clean-orphan-comments", $options)){
+if (array_key_exists("o", $options) ||
+	array_key_exists("clean-orphan-comments", $options)) {
 	echo "Removing orphan comments...";
 	$spotnab = new SpotNab();
 	printf("%d record(s) removed.\n", $spotnab->orphan_comment_clean());

Braces +37 added lines, -39 removed lines

@@ -212,7 +212,8 @@ 
 
 $options = getopt($shortopts, $longopts);
 
-function display_help(){
+function display_help()
+{
 	echo "\n";
 	echo "SpotNab v0.97.4, Author: l2g\n";
 	echo "Syntax: spotnab.php <action>\n";
@@ -270,7 +271,7 @@ 
 
 $delete_broken_releases = false;
 if(array_key_exists("G", $options) ||
-	array_key_exists("populate-fix-gid", $options)){
+	array_key_exists("populate-fix-gid", $options)) {
 	echo "Updating GID in releases table + fix ...";
 	$spotnab = new SpotNab();
 	$spotnab->processGID(0,5000,true);
@@ -278,7 +279,7 @@ 
 }
 
 if(array_key_exists("g", $options) ||
-	array_key_exists("populate-gid", $options)){
+	array_key_exists("populate-gid", $options)) {
 	echo "Updating GID in releases table ...";
 	$spotnab = new SpotNab();
 	$spotnab->processGID();
@@ -286,7 +287,7 @@ 
 }
 
 if(array_key_exists("r", $options) ||
-	array_key_exists("soft-reset", $options)){
+	array_key_exists("soft-reset", $options)) {
 	echo "Soft Reseting Spotnab... ";
 	$spotnab = new SpotNab();
 	$spotnab->soft_reset();
@@ -295,18 +296,17 @@ 
 
 $force_keygen_save = false;
 if(array_key_exists("K", $options) ||
-	array_key_exists("force-keygen", $options)){
+	array_key_exists("force-keygen", $options)) {
 	$spotnab = new SpotNab();
 	$spotnab->keygen(true, true);
-}
-else if(array_key_exists("k", $options) ||
-	array_key_exists("keygen", $options)){
+} else if(array_key_exists("k", $options) ||
+	array_key_exists("keygen", $options)) {
 	$spotnab = new SpotNab();
 	$spotnab->keygen(true);
 }
 
 if(array_key_exists("p", $options) ||
-	array_key_exists("post", $options)){
+	array_key_exists("post", $options)) {
 	echo "Posting... ";
 	$spotnab = new SpotNab();
 	$spotnab->post();
@@ -314,7 +314,7 @@ 
 }
 
 if(array_key_exists("d", $options) ||
-	array_key_exists("discover", $options)){
+	array_key_exists("discover", $options)) {
 	echo "Discovering... ";
 	$spotnab = new SpotNab();
 	$spotnab->fetch_discovery();
@@ -322,15 +322,15 @@ 
 }
 
 if(array_key_exists("F", $options) ||
-	array_key_exists("fetch-backfill", $options)){
+	array_key_exists("fetch-backfill", $options)) {
 	$days = array_key_exists("F", $options)?$options["F"]:$options["fetch-backfill"];
-    try{
+    try {
     	$days = abs(intval($days));
-    }catch(Exception $e){
+    } catch(Exception $e) {
 		$days = -1;
     }
 
-    if($days <= 0){
+    if($days <= 0) {
     	echo "Error: A SpotNab fetch backfill requires you specify the number of days to look back.\n";
     	echo "Syntax: php spontnab.php -F=<days>\n";
         exit(1);
@@ -341,8 +341,8 @@ 
 	echo "Done\n";
 
 
-}else if (array_key_exists("f", $options) ||
-	array_key_exists("fetch", $options)){
+} else if (array_key_exists("f", $options) ||
+	array_key_exists("fetch", $options)) {
 	echo "Fetching... ";
 	$spotnab = new SpotNab();
 	$spotnab->fetch();
@@ -350,7 +350,7 @@ 
 }
 
 if(array_key_exists("b", $options) ||
-	array_key_exists("broadcast", $options)){
+	array_key_exists("broadcast", $options)) {
 	echo "Broadcasting... ";
 	$spotnab = new SpotNab();
 	$spotnab->post_discovery();
@@ -358,24 +358,22 @@ 
 }
 
 if(array_key_exists("t", $options) ||
-	array_key_exists("test", $options)){
+	array_key_exists("test", $options)) {
 	$spotnab = new SpotNab();
 
-	if($spotnab->has_openssl())
-	{
+	if($spotnab->has_openssl()) {
 		printf("%s INFO - Testing SSL Key Generator ...",
 					date("Y-m-d H:i:s"));
 		$keys = $spotnab->keygen(false);
 		if(is_array($keys) &&
 			array_key_exists("pubkey", $keys) &&
-			array_key_exists("prvkey", $keys))
-		{
+			array_key_exists("prvkey", $keys)) {
 			$prvkey = $spotnab->decompstr($keys['prvkey']);
 			$pubkey = $spotnab->decompstr($keys['pubkey']);
 			$refc = $spotnab->getRandomStr(80);
 			$refd = $spotnab->decrypt($spotnab->encrypt($refc, $prvkey), $pubkey);
 			echo ($refc == $refd)?"Successful!\n":"Failed!\n";
-		}else{
+		} else {
 			echo "Failed!\n";
 		}
 
@@ -383,11 +381,11 @@ 
 				date("Y-m-d H:i:s"));
 		$preMsg = $spotnab->getRandomStr(800);
 		$postMsg = $spotnab->decrypt($spotnab->encrypt($preMsg));
-		if($postMsg === false){
+		if($postMsg === false) {
 			echo "Failed!\n";
-		}else if(!strcmp($preMsg, $postMsg)){
+		} else if(!strcmp($preMsg, $postMsg)) {
 				echo "Successful!\n";
-		}else{
+		} else {
 			echo "Failed!\n";
 		}
 
@@ -419,14 +417,14 @@ 
 			)
 		);
 		$article = $spotnab->encodePost($before, Null, true);
-		if($article !== false){
+		if($article !== false) {
 			$after = $spotnab->decodePost($article[1]);
-			if($before === $after){
+			if($before === $after) {
 				echo "Successful!\n";
-			}else{
+			} else {
 				echo "Failed!\n";
 			}
-		}else{
+		} else {
 			echo "Failed!\n";
 		}
 		printf("%s INFO - Testing big message encode/decode ...",
@@ -439,7 +437,7 @@ 
 			'postdate_utc' => $spotnab->local2utc(),
 			'comments' => []
 		);
-		for($i=0;$i<3000;$i++){
+		for($i=0;$i<3000;$i++) {
 			// Build large post
 			$before['comments'][] =array(
 				'gid' => 'ABCDEFHIJKLMNOPQRSTUVWXYZ0123456',
@@ -451,14 +449,14 @@ 
 			);
 		}
 		$article = $spotnab->encodePost($before, Null, true);
-		if($article !== false){
+		if($article !== false) {
 			$after = $spotnab->decodePost($article[1]);
-			if($before === $after){
+			if($before === $after) {
 				echo "Successful!\n";
-			}else{
+			} else {
 				echo "Failed!\n";
 			}
-		}else{
+		} else {
 			echo "Failed!\n";
 		}
 
@@ -480,14 +478,14 @@ 
 		$headers = array($article[2]);
 
 		$matched = $spotnab->process_comment_headers($headers, $hash, false);
-		if($matched !== false){
+		if($matched !== false) {
 			$inserted = $matched[0];
 			$updated = $matched[1];
 			echo ($matched > 0)?"Successful!\n":"Failed!\n";
-		}else{
+		} else {
 			echo "Failed\n";
 		}
-	}else{
+	} else {
 		printf("%s WARNING - openssl is not correctly installed; broadcasts and posts will be disabled.\n",
 				date("Y-m-d H:i:s"));
 	}
@@ -525,7 +523,7 @@ 
 }
 
 if(array_key_exists("o", $options) ||
-	array_key_exists("clean-orphan-comments", $options)){
+	array_key_exists("clean-orphan-comments", $options)) {
 	echo "Removing orphan comments...";
 	$spotnab = new SpotNab();
 	printf("%d record(s) removed.\n", $spotnab->orphan_comment_clean());

Upper-Lower-Casing +1 added lines, -1 removed lines

@@ -335,7 +335,7 @@
     	echo "Syntax: php spontnab.php -F=<days>\n";
         exit(1);
     }
-	echo "Fetching $days day(s) back ... ";
+	echo "fetching $days day(s) back ... ";
 	$spotnab = new SpotNab();
 	$spotnab->fetch(time()-($days*86400));
 	echo "Done\n";

misc/testing/DB/setUserPasswordHash.php

Upper-Lower-Casing +1 added lines, -1 removed lines

@@ -54,7 +54,7 @@
 	if ($result === false || $hash === false) {
 		$pdo->log->error('An error occured during update attempt.' . PHP_EOL);
 	} else {
-		$pdo->log->headerOver("Updated {$user['username']}'s password hash to: ") . $pdo->log->primary("$hash");
+		$pdo->log->headerOver("updated {$user['username']}'s password hash to: ") . $pdo->log->primary("$hash");
 	}
 } else {
 	$pdo->log->error("Unable to find {$field} '{$identifier}' in the users. Cannot change password.");

misc/testing/DB/change_USP_provider.php

Upper-Lower-Casing +1 added lines, -1 removed lines

@@ -53,7 +53,7 @@
 foreach ($arr as &$value) {
 	$rel = $pdo->queryExec("TRUNCATE TABLE $value");
 	if ($rel !== false) {
-		echo $pdo->log->header("Truncating $value completed.");
+		echo $pdo->log->header("truncating $value completed.");
 	}
 }
 unset($value);

misc/testing/DB/setUserPasswordHashesToEmail.php

Upper-Lower-Casing +1 added lines, -1 removed lines

@@ -30,7 +30,7 @@
   It is intended for use ONLY if you have a *lot* of users, as this is not
 secure (a user's email addresses may be known to other users). If you only have
 a few users then run setUsersPasswordHash.php for each of them instead.
-WARNING;
+warning;
 $usage = "\nUsage: php {$argv[0]} <IUnderStandTheRisks>";
 
 echo $colorCLI->warning($warning);

misc/testing/DB/resetdb.php

Braces +11 added lines, -7 removed lines

@@ -11,15 +11,17 @@ 
 Utility::clearScreen();
 $pdo = new DB();
 
-if (!isset($argv[1]) || (isset($argv[1]) && $argv[1] !== 'true'))
+if (!isset($argv[1]) || (isset($argv[1]) && $argv[1] !== 'true')) {
 	exit($pdo->log->error("\nThis script removes all releases and release related files. To run:\nphp resetdb.php true\n"));
+}
 
 echo $pdo->log->warning("This script removes all releases, nzb files, samples, previews , nfos, truncates all article tables and resets all groups.");
 echo $pdo->log->header("Are you sure you want reset the DB?  Type 'DESTROY' to continue:  \n");
 echo $pdo->log->warningOver("\n");
 $line = fgets(STDIN);
-if (trim($line) != 'DESTROY')
+if (trim($line) != 'DESTROY') {
 	exit($pdo->log->error("This script is dangerous you must type DESTROY for it function."));
+}
 
 echo "\n";
 echo $pdo->log->header("Thank you, continuing...\n\n");
@@ -41,9 +43,10 @@ 
 ];
 foreach ($arr as &$value) {
 	$rel = $pdo->queryExec("TRUNCATE TABLE $value");
-	if ($rel !== false)
-		echo $pdo->log->primary("Truncating ${value} completed.");
-}
+	if ($rel !== false) {
+			echo $pdo->log->primary("Truncating ${value} completed.");
+	}
+	}
 unset($value);
 
 $sql = "SHOW table status";
@@ -53,8 +56,9 @@ 
 	$tbl = $row['name'];
 	if (preg_match('/binaries_\d+/', $tbl) || preg_match('/parts_\d+/', $tbl) || preg_match('/collections_\d+/', $tbl) || preg_match('/partrepair_\d+/', $tbl) || preg_match('/\d+_binaries/', $tbl) || preg_match('/\d+_collections/', $tbl) || preg_match('/\d+_parts/', $tbl) || preg_match('/\d+_partrepair_\d+/', $tbl)) {
 		$rel = $pdo->queryDirect(sprintf('DROP TABLE %s', $tbl));
-		if ($rel !== false)
-			echo $pdo->log->primary("Dropping ${tbl} completed.");
+		if ($rel !== false) {
+					echo $pdo->log->primary("Dropping ${tbl} completed.");
+		}
 	}
 }
 

Upper-Lower-Casing +2 added lines, -2 removed lines

@@ -42,7 +42,7 @@ 
 foreach ($arr as &$value) {
 	$rel = $pdo->queryExec("TRUNCATE TABLE $value");
 	if ($rel !== false)
-		echo $pdo->log->primary("Truncating ${value} completed.");
+		echo $pdo->log->primary("truncating ${value} completed.");
 }
 unset($value);
 
@@ -54,7 +54,7 @@ 
 	if (preg_match('/binaries_\d+/', $tbl) || preg_match('/parts_\d+/', $tbl) || preg_match('/collections_\d+/', $tbl) || preg_match('/partrepair_\d+/', $tbl) || preg_match('/\d+_binaries/', $tbl) || preg_match('/\d+_collections/', $tbl) || preg_match('/\d+_parts/', $tbl) || preg_match('/\d+_partrepair_\d+/', $tbl)) {
 		$rel = $pdo->queryDirect(sprintf('DROP TABLE %s', $tbl));
 		if ($rel !== false)
-			echo $pdo->log->primary("Dropping ${tbl} completed.");
+			echo $pdo->log->primary("dropping ${tbl} completed.");
 	}
 }
 

misc/testing/DB/convert_to_tpg_alt.php

Upper-Lower-Casing +4 added lines, -4 removed lines

@@ -40,13 +40,13 @@ 
 if ($collections_rows instanceof \Traversable) {
 	foreach ($collections_rows as $row) {
 		$groupName = $groups->getNameByID($row['group_id']);
-		echo $pdo->log->header("Processing ${groupName}");
+		echo $pdo->log->header("processing ${groupname}");
 		//collection
 		$pdo->queryExec("INSERT IGNORE INTO collections_" . $row['group_id'] . " (subject, fromname, date, xref, totalfiles, group_id, collectionhash, dateadded, filecheck, filesize, releaseid) "
 			. "SELECT subject, fromname, date, xref, totalfiles, group_id, collectionhash, dateadded, filecheck, filesize, releaseid FROM collections WHERE group_id = ${row['group_id']}");
 		$collections = $pdo->queryOneRow("SELECT COUNT(*) AS cnt FROM collections where group_id = " . $row['group_id']);
 		$ncollections = $pdo->queryOneRow("SELECT COUNT(*) AS cnt FROM collections_" . $row['group_id']);
-		echo $pdo->log->primary("Group ${groupName}, Collections = ${collections['cnt']} [${ncollections['cnt']}]");
+		echo $pdo->log->primary("group ${groupname}, Collections = ${collections['cnt']} [${ncollections['cnt']}]");
 
 		//binaries
 		$pdo->queryExec("INSERT IGNORE INTO binaries_${row['group_id']} (name, filenumber, totalparts, currentparts, binaryhash, partcheck, partsize, collection_id) "
@@ -55,7 +55,7 @@ 
 			. "INNER JOIN collections_${row['group_id']} n ON c.collectionhash = n.collectionhash AND c.group_id = ${row['group_id']}");
 		$binaries = $pdo->queryOneRow("SELECT COUNT(*) AS cnt FROM binaries b INNER JOIN collections c ON  b.collection_id = c.id where c.group_id = ${row['group_id']}");
 		$nbinaries = $pdo->queryOneRow("SELECT COUNT(*) AS cnt FROM binaries_${row['group_id']}");
-		echo $pdo->log->primary("Group ${groupName}, Binaries = ${binaries['cnt']} [${nbinaries['cnt']}]");
+		echo $pdo->log->primary("group ${groupname}, Binaries = ${binaries['cnt']} [${nbinaries['cnt']}]");
 
 		//parts
 		$pdo->queryExec("INSERT IGNORE INTO parts_${row['group_id']} (messageid, number, partnumber, size, binaryid, collection_id) "
@@ -65,7 +65,7 @@ 
 			. "INNER JOIN collections_${row['group_id']} c on c.id = n.collection_id AND c.group_id = ${row['group_id']}");
 		$parts = $pdo->queryOneRow("SELECT COUNT(*) AS cnt FROM parts p INNER JOIN binaries b ON p.binaryid = b.id INNER JOIN collections c ON b.collection_id = c.id WHERE c.group_id = ${row['group_id']}");
 		$nparts = $pdo->queryOneRow("SELECT COUNT(*) AS cnt FROM parts_${row['group_id']}");
-		echo $pdo->log->primary("Group ${groupName}, Parts = ${parts['cnt']} [${nparts['cnt']}]\n");
+		echo $pdo->log->primary("group ${groupname}, Parts = ${parts['cnt']} [${nparts['cnt']}]\n");
 		$i++;
 	}
 }

misc/testing/DB/convert_mysql_tables.php

Upper-Lower-Casing +18 added lines, -18 removed lines

@@ -11,16 +11,16 @@ 
 
 if (isset($argv[1]) && isset($argv[2]) && $argv[2] == "fmyisam") {
 	$tbl = $argv[1];
-	printf($cli->header("Converting $tbl"));
+	printf($cli->header("converting $tbl"));
 	$pdo->queryExec("ALTER TABLE $tbl ENGINE=MYISAM ROW_FORMAT=FIXED");
 } else if (isset($argv[1]) && isset($argv[2]) && $argv[2] == "dmyisam") {
 	$tbl = $argv[1];
-	printf($cli->header("Converting $tbl"));
+	printf($cli->header("converting $tbl"));
 	$pdo->queryExec("ALTER TABLE $tbl ENGINE=MYISAM ROW_FORMAT=DYNAMIC");
 } else if (isset($argv[1]) && isset($argv[2]) && $argv[2] == "cinnodb") {
 	$tbl = $argv[1];
 	if ($ftinnodb || (!$ftinnodb && $tbl !== 'release_search_data' && $tbl !== 'bookinfo' && $tbl !== 'consoleinfo' && $tbl !== 'musicinfo')) {
-		printf($cli->header("Converting $tbl"));
+		printf($cli->header("converting $tbl"));
 		$pdo->queryExec("ALTER TABLE $tbl ENGINE=INNODB ROW_FORMAT=COMPRESSED");
 	} else {
 		printf($cli->header("Not converting bookinfo / consoleinfo / musicinfo / release_search_data as your INNODB version does not support fulltext indexes"));
@@ -28,7 +28,7 @@ 
 } else if (isset($argv[1]) && isset($argv[2]) && $argv[2] == "dinnodb") {
 	$tbl = $argv[1];
 	if ($ftinnodb || (!$ftinnodb && $tbl !== 'release_search_data' && $tbl !== 'bookinfo' && $tbl !== 'consoleinfo' && $tbl !== 'musicinfo')) {
-		printf($cli->header("Converting $tbl"));
+		printf($cli->header("converting $tbl"));
 		$pdo->queryExec("ALTER TABLE $tbl ENGINE=INNODB ROW_FORMAT=DYNAMIC");
 	} else {
 		printf($cli->header("Not converting bookinfo / consoleinfo / musicinfo / release_search_data as your INNODB version does not support fulltext indexes"));
@@ -38,7 +38,7 @@ 
 	$tables = $pdo->query($sql);
 	foreach ($tables as $row) {
 		$tbl = $row['name'];
-		printf($cli->header("Converting $tbl"));
+		printf($cli->header("converting $tbl"));
 		$pdo->queryExec("ALTER TABLE $tbl ENGINE=MYISAM ROW_FORMAT=FIXED");
 	}
 } else if (isset($argv[1]) && $argv[1] == "dmyisam") {
@@ -46,7 +46,7 @@ 
 	$tables = $pdo->query($sql);
 	foreach ($tables as $row) {
 		$tbl = $row['name'];
-		printf($cli->header("Converting $tbl"));
+		printf($cli->header("converting $tbl"));
 		$pdo->queryExec("ALTER TABLE $tbl ENGINE=MYISAM ROW_FORMAT=DYNAMIC");
 	}
 } else if (isset($argv[1]) && $argv[1] == "dinnodb") {
@@ -55,7 +55,7 @@ 
 	foreach ($tables as $row) {
 		$tbl = $row['name'];
 		if ($tbl !== 'release_search_data' && $tbl !== 'bookinfo' && $tbl !== 'consoleinfo' && $tbl !== 'musicinfo') {
-			printf($cli->header("Converting $tbl"));
+			printf($cli->header("converting $tbl"));
 			$pdo->queryExec("ALTER TABLE $tbl ENGINE=INNODB ROW_FORMAT=DYNAMIC");
 		}
 	}
@@ -64,7 +64,7 @@ 
 		$tables = $pdo->query($sql);
 		foreach ($tables as $row) {
 			$tbl = $row['name'];
-			printf($cli->header("Converting $tbl"));
+			printf($cli->header("converting $tbl"));
 			$pdo->queryExec("ALTER TABLE $tbl ENGINE=INNODB ROW_FORMAT=DYNAMIC");
 		}
 	} else {
@@ -76,7 +76,7 @@ 
 	foreach ($tables as $row) {
 		$tbl = $row['name'];
 		if ($tbl !== 'release_nfos' && $tbl !== 'release_search_data' && $tbl !== 'bookinfo' && $tbl !== 'consoleinfo' && $tbl !== 'musicinfo') {
-			printf($cli->header("Converting $tbl"));
+			printf($cli->header("converting $tbl"));
 			$pdo->queryExec("ALTER TABLE $tbl ENGINE=INNODB ROW_FORMAT=COMPRESSED");
 		}
 	}
@@ -84,7 +84,7 @@ 
 	$tables = $pdo->query($sql);
 	foreach ($tables as $row) {
 		$tbl = $row['name'];
-		printf($cli->header("Converting $tbl"));
+		printf($cli->header("converting $tbl"));
 		$pdo->queryExec("ALTER TABLE $tbl ENGINE=INNODB ROW_FORMAT=DYNAMIC");
 	}
 	if ($ftinnodb) {
@@ -92,7 +92,7 @@ 
 		$tables = $pdo->query($sql);
 		foreach ($tables as $row) {
 			$tbl = $row['name'];
-			printf($cli->header("Converting $tbl"));
+			printf($cli->header("converting $tbl"));
 			$pdo->queryExec("ALTER TABLE $tbl ENGINE=INNODB ROW_FORMAT=COMPRESSED");
 		}
 	} else {
@@ -104,7 +104,7 @@ 
 	foreach ($tables as $row) {
 		$tbl = $row['name'];
 		if ($tbl !== 'release_nfos' && $tbl !== 'release_search_data' && $tbl !== 'bookinfo' && $tbl !== 'consoleinfo' && $tbl !== 'musicinfo' && !preg_match('/parts/', $tbl)) {
-			printf($cli->header("Converting $tbl"));
+			printf($cli->header("converting $tbl"));
 			$pdo->queryExec("ALTER TABLE $tbl ENGINE=INNODB ROW_FORMAT=COMPRESSED");
 		}
 	}
@@ -112,14 +112,14 @@ 
 	$tables = $pdo->query($sql);
 	foreach ($tables as $row) {
 		$tbl = $row['name'];
-		printf($cli->header("Converting $tbl"));
+		printf($cli->header("converting $tbl"));
 		$pdo->queryExec("ALTER TABLE $tbl ENGINE=INNODB ROW_FORMAT=DYNAMIC");
 	}
 	$sql = 'SHOW TABLE STATUS WHERE Name LIKE "parts%" AND (Engine != "MyISAM" || Row_format != "Dynamic")';
 	$tables = $pdo->query($sql);
 	foreach ($tables as $row) {
 		$tbl = $row['name'];
-		printf($cli->header("Converting $tbl"));
+		printf($cli->header("converting $tbl"));
 		$pdo->queryExec("ALTER TABLE $tbl ENGINE=MyISAM ROW_FORMAT=DYNAMIC");
 	}
 	if ($ftinnodb) {
@@ -127,7 +127,7 @@ 
 		$tables = $pdo->query($sql);
 		foreach ($tables as $row) {
 			$tbl = $row['name'];
-			printf($cli->header("Converting $tbl"));
+			printf($cli->header("converting $tbl"));
 			$pdo->queryExec("ALTER TABLE $tbl ENGINE=INNODB ROW_FORMAT=COMPRESSED");
 		}
 	} else {
@@ -137,7 +137,7 @@ 
 	$arr = array("parts", "binaries", "collections");
 	foreach ($arr as $row) {
 		$tbl = $row;
-		printf($cli->header("Converting $tbl"));
+		printf($cli->header("converting $tbl"));
 		$pdo->queryExec("ALTER TABLE $tbl ENGINE=MYISAM ROW_FORMAT=FIXED");
 	}
 } else if (isset($argv[1]) && $argv[1] == "mariadb-tokudb") {
@@ -145,7 +145,7 @@ 
 	foreach ($tables as $row) {
 		$tbl = $row['name'];
 		if ($tbl !== 'release_search_data') {
-			printf($cli->header("Converting $tbl"));
+			printf($cli->header("converting $tbl"));
 			$sql = "ALTER TABLE $tbl ENGINE=TokuDB Compression=tokudb_lzma";
 			$pdo->queryExec($sql);
 			$pdo->queryExec("OPTIMIZE TABLE $tbl");
@@ -156,7 +156,7 @@ 
 	foreach ($tables as $row) {
 		$tbl = $row['name'];
 		if ($tbl !== 'release_search_data') {
-			printf($cli->header("Converting $tbl"));
+			printf($cli->header("converting $tbl"));
 			$sql = "ALTER TABLE $tbl ENGINE=TokuDB row_format=tokudb_lzma";
 			$pdo->queryExec($sql);
 			$pdo->queryExec("OPTIMIZE TABLE $tbl");

misc/testing/DB/reset_truncate.php

Spacing +1 added lines, -1 removed lines

@@ -27,7 +27,7 @@
 		$tables = $pdo->query($sql);
 		foreach ($tables as $row) {
 			$tbl = $row['name'];
-			if (preg_match('/collections_\d+/', $tbl) ||  preg_match('/binaries_\d+/', $tbl) || preg_match('/parts_\d+/', $tbl) || preg_match('/partrepair_\d+/', $tbl) || preg_match('/\d+_collections/', $tbl) || preg_match('/\d+_binaries/', $tbl) || preg_match('/\d+_parts/', $tbl) || preg_match('/\d+_partrepair_\d+/', $tbl)) {
+			if (preg_match('/collections_\d+/', $tbl) || preg_match('/binaries_\d+/', $tbl) || preg_match('/parts_\d+/', $tbl) || preg_match('/partrepair_\d+/', $tbl) || preg_match('/\d+_collections/', $tbl) || preg_match('/\d+_binaries/', $tbl) || preg_match('/\d+_parts/', $tbl) || preg_match('/\d+_partrepair_\d+/', $tbl)) {
 				if ($argv[1] == "drop") {
 					$rel = $pdo->queryDirect(sprintf('DROP TABLE %s', $tbl));
 					if ($rel !== false) {

Upper-Lower-Casing +3 added lines, -3 removed lines

@@ -13,7 +13,7 @@ 
 	foreach ($arr as &$value) {
 		$rel = $pdo->queryExec("TRUNCATE TABLE $value");
 		if ($rel !== false) {
-			echo $pdo->log->primary("Truncating ${value} completed.");
+			echo $pdo->log->primary("truncating ${value} completed.");
 		}
 	}
 	unset($value);
@@ -31,12 +31,12 @@ 
 				if ($argv[1] == "drop") {
 					$rel = $pdo->queryDirect(sprintf('DROP TABLE %s', $tbl));
 					if ($rel !== false) {
-						echo $pdo->log->primary("Dropping ${tbl} completed.");
+						echo $pdo->log->primary("dropping ${tbl} completed.");
 					}
 				} else {
 					$rel = $pdo->queryDirect(sprintf('TRUNCATE TABLE %s', $tbl));
 					if ($rel !== false) {
-						echo $pdo->log->primary("Truncating ${tbl} completed.");
+						echo $pdo->log->primary("truncating ${tbl} completed.");
 					}
 				}
 			}

misc/testing/DB/mysqldump_tables.php

Spacing +30 added lines, -30 removed lines

@@ -24,7 +24,7 @@ 
 
 function newname($filename)
 {
-	rename($filename, dirname($filename)."/".basename($filename,".gz")."_".date("Y_m_d_His", filemtime($filename)).".gz");
+	rename($filename, dirname($filename) . "/" . basename($filename, ".gz") . "_" . date("Y_m_d_His", filemtime($filename)) . ".gz");
 }
 
 function builddefaultsfile()
@@ -42,7 +42,7 @@ 
 				."password = " . DB_PASSWORD;
 
 	$filehandle = fopen("mysql-defaults.txt", "w+");
-	if(!$filehandle) {
+	if (!$filehandle) {
 		exit("Unable to write mysql defaults file! Exiting");
 	} else {
 		fwrite($filehandle, $filetext);
@@ -67,16 +67,16 @@ 
 //generate defaults file used to store database login information so it is not in cleartext in ps command for mysqldump
 builddefaultsfile();
 
-if((isset($argv[1]) && $argv[1] == "db") && (isset($argv[2]) && $argv[2] == "dump") && (isset($argv[3]) && file_exists($argv[3]))) {
-	$filename = $argv[3]."/".$dbname.".gz";
+if ((isset($argv[1]) && $argv[1] == "db") && (isset($argv[2]) && $argv[2] == "dump") && (isset($argv[3]) && file_exists($argv[3]))) {
+	$filename = $argv[3] . "/" . $dbname . ".gz";
 	echo $pdo->log->header("Dumping $dbname.");
 	if (file_exists($filename)) {
 		newname($filename);
 	}
-	$command = "mysqldump --defaults-file=mysql-defaults.txt $exportopts -h$dbhost $use "."$dbname | gzip -9 > $filename";
+	$command = "mysqldump --defaults-file=mysql-defaults.txt $exportopts -h$dbhost $use " . "$dbname | gzip -9 > $filename";
 	system($command);
-} else if((isset($argv[1]) && $argv[1] == "db") && (isset($argv[2]) && $argv[2] == "restore") && (isset($argv[3]) && file_exists($argv[3]))) {
-	$filename = $argv[3]."/".$dbname.".gz";
+} else if ((isset($argv[1]) && $argv[1] == "db") && (isset($argv[2]) && $argv[2] == "restore") && (isset($argv[3]) && file_exists($argv[3]))) {
+	$filename = $argv[3] . "/" . $dbname . ".gz";
 	if (file_exists($filename)) {
 		echo $pdo->log->header("Restoring $dbname.");
 		$command = "zcat < $filename | mysql --defaults-file=mysql-defaults.txt -h$dbhost $use $dbname";
@@ -84,26 +84,26 @@ 
 		system($command);
 		$pdo->queryExec("SET FOREIGN_KEY_CHECKS=1");
 	}
-} else if((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "dump") && (isset($argv[3]) && file_exists($argv[3]))) {
+} else if ((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "dump") && (isset($argv[3]) && file_exists($argv[3]))) {
 	$sql = "SHOW tables";
 	$tables = $pdo->query($sql);
-	foreach($tables as $row) {
-		$tbl = $row['Tables_in_'.DB_NAME];
-		$filename = $argv[3]."/".$tbl.".gz";
+	foreach ($tables as $row) {
+		$tbl = $row['Tables_in_' . DB_NAME];
+		$filename = $argv[3] . "/" . $tbl . ".gz";
 		echo $pdo->log->header("Dumping $tbl.");
 		if (file_exists($filename)) {
 			newname($filename);
 		}
-		$command = "mysqldump --defaults-file=mysql-defaults.txt $exportopts -h$dbhost $use "."$dbname $tbl | gzip -9 > $filename";
+		$command = "mysqldump --defaults-file=mysql-defaults.txt $exportopts -h$dbhost $use " . "$dbname $tbl | gzip -9 > $filename";
 		system($command);
 	}
-} else if((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "restore") && (isset($argv[3]) && file_exists($argv[3]))) {
+} else if ((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "restore") && (isset($argv[3]) && file_exists($argv[3]))) {
 	$sql = "SHOW tables";
 	$tables = $pdo->query($sql);
 	$pdo->queryExec("SET FOREIGN_KEY_CHECKS=0");
-	foreach($tables as $row) {
-		$tbl = $row['Tables_in_'.DB_NAME];
-		$filename = $argv[3]."/".$tbl.".gz";
+	foreach ($tables as $row) {
+		$tbl = $row['Tables_in_' . DB_NAME];
+		$filename = $argv[3] . "/" . $tbl . ".gz";
 		if (file_exists($filename)) {
 			echo $pdo->log->header("Restoring $tbl.");
 			$command = "zcat < $filename | mysql --defaults-file=mysql-defaults.txt -h$dbhost $use $dbname";
@@ -111,22 +111,22 @@ 
 		}
 	}
 	$pdo->queryExec("SET FOREIGN_KEY_CHECKS=1");
-} else if((isset($argv[1]) && $argv[1] == "test") && (isset($argv[2]) && $argv[2] == "dump") && (isset($argv[3]) && file_exists($argv[3]))) {
+} else if ((isset($argv[1]) && $argv[1] == "test") && (isset($argv[2]) && $argv[2] == "dump") && (isset($argv[3]) && file_exists($argv[3]))) {
 	$arr = array("parts", "binaries", "missed_parts", "groups");
 	foreach ($arr as &$tbl) {
-		$filename = $argv[3]."/".$tbl.".gz";
+		$filename = $argv[3] . "/" . $tbl . ".gz";
 		echo $pdo->log->header("Dumping $tbl..");
 		if (file_exists($filename)) {
 			newname($filename);
 		}
-		$command = "mysqldump --defaults-file=mysql-defaults.txt $exportopts -h$dbhost $use "."$dbname $tbl | gzip -9 > $filename";
+		$command = "mysqldump --defaults-file=mysql-defaults.txt $exportopts -h$dbhost $use " . "$dbname $tbl | gzip -9 > $filename";
 		system($command);
 	}
-} else if((isset($argv[1]) && $argv[1] == "test") && (isset($argv[2]) && $argv[2] == "restore") && (isset($argv[3]) && file_exists($argv[3]))) {
+} else if ((isset($argv[1]) && $argv[1] == "test") && (isset($argv[2]) && $argv[2] == "restore") && (isset($argv[3]) && file_exists($argv[3]))) {
 	$arr = array("parts", "binaries", "missed_parts", "groups");
 	$pdo->queryExec("SET FOREIGN_KEY_CHECKS=0");
 	foreach ($arr as &$tbl) {
-		$filename = $argv[3]."/".$tbl.".gz";
+		$filename = $argv[3] . "/" . $tbl . ".gz";
 		if (file_exists($filename)) {
 			echo $pdo->log->header("Restoring $tbl.");
 			$command = "zcat < $filename | mysql --defaults-file=mysql-defaults.txt -h$dbhost $use $dbname";
@@ -134,25 +134,25 @@ 
 		}
 	}
 	$pdo->queryExec("SET FOREIGN_KEY_CHECKS=1");
-} else if((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "outfile") && (isset($argv[3]) && file_exists($argv[3]))) {
+} else if ((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "outfile") && (isset($argv[3]) && file_exists($argv[3]))) {
 	$sql = "SHOW tables";
 	$tables = $pdo->query($sql);
-	foreach($tables as $row) {
-		$tbl = $row['Tables_in_'.DB_NAME];
-		$filename = $argv[3].$tbl.".csv";
+	foreach ($tables as $row) {
+		$tbl = $row['Tables_in_' . DB_NAME];
+		$filename = $argv[3] . $tbl . ".csv";
 		echo $pdo->log->header("Dumping $tbl.");
 		if (file_exists($filename)) {
 			newname($filename);
 		}
 		$pdo->queryDirect(sprintf("SELECT * INTO OUTFILE %s FROM %s", $pdo->escapeString($filename), $tbl));
 	}
-} else if((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "infile") && (isset($argv[3]) && is_dir($argv[3]))) {
+} else if ((isset($argv[1]) && $argv[1] == "all") && (isset($argv[2]) && $argv[2] == "infile") && (isset($argv[3]) && is_dir($argv[3]))) {
 	$sql = "SHOW tables";
 	$tables = $pdo->query($sql);
 	$pdo->queryExec("SET FOREIGN_KEY_CHECKS=0");
-	foreach($tables as $row) {
-		$tbl = $row['Tables_in_'.DB_NAME];
-		$filename = $argv[3].$tbl.".csv";
+	foreach ($tables as $row) {
+		$tbl = $row['Tables_in_' . DB_NAME];
+		$filename = $argv[3] . $tbl . ".csv";
 		if (file_exists($filename)) {
 			echo $pdo->log->header("Restoring $tbl.");
 			$pdo->queryExec(sprintf("LOAD DATA INFILE %s INTO TABLE %s", $pdo->escapeString($filename), $tbl));
@@ -177,6 +177,6 @@ 
 	. "php $argv[0] all infile /path/to/restore/from      ...: To restore all tables, using INFILE.\n\n");
 }
 
-if(file_exists("mysql-defaults.txt")) {
+if (file_exists("mysql-defaults.txt")) {
 	@unlink("mysql-defaults.txt");
 }

Upper-Lower-Casing +8 added lines, -8 removed lines

@@ -69,7 +69,7 @@ 
 
 if((isset($argv[1]) && $argv[1] == "db") && (isset($argv[2]) && $argv[2] == "dump") && (isset($argv[3]) && file_exists($argv[3]))) {
 	$filename = $argv[3]."/".$dbname.".gz";
-	echo $pdo->log->header("Dumping $dbname.");
+	echo $pdo->log->header("dumping $dbname.");
 	if (file_exists($filename)) {
 		newname($filename);
 	}
@@ -78,7 +78,7 @@ 
 } else if((isset($argv[1]) && $argv[1] == "db") && (isset($argv[2]) && $argv[2] == "restore") && (isset($argv[3]) && file_exists($argv[3]))) {
 	$filename = $argv[3]."/".$dbname.".gz";
 	if (file_exists($filename)) {
-		echo $pdo->log->header("Restoring $dbname.");
+		echo $pdo->log->header("restoring $dbname.");
 		$command = "zcat < $filename | mysql --defaults-file=mysql-defaults.txt -h$dbhost $use $dbname";
 		$pdo->queryExec("SET FOREIGN_KEY_CHECKS=0");
 		system($command);
@@ -90,7 +90,7 @@ 
 	foreach($tables as $row) {
 		$tbl = $row['Tables_in_'.DB_NAME];
 		$filename = $argv[3]."/".$tbl.".gz";
-		echo $pdo->log->header("Dumping $tbl.");
+		echo $pdo->log->header("dumping $tbl.");
 		if (file_exists($filename)) {
 			newname($filename);
 		}
@@ -105,7 +105,7 @@ 
 		$tbl = $row['Tables_in_'.DB_NAME];
 		$filename = $argv[3]."/".$tbl.".gz";
 		if (file_exists($filename)) {
-			echo $pdo->log->header("Restoring $tbl.");
+			echo $pdo->log->header("restoring $tbl.");
 			$command = "zcat < $filename | mysql --defaults-file=mysql-defaults.txt -h$dbhost $use $dbname";
 			system($command);
 		}
@@ -115,7 +115,7 @@ 
 	$arr = array("parts", "binaries", "missed_parts", "groups");
 	foreach ($arr as &$tbl) {
 		$filename = $argv[3]."/".$tbl.".gz";
-		echo $pdo->log->header("Dumping $tbl..");
+		echo $pdo->log->header("dumping $tbl..");
 		if (file_exists($filename)) {
 			newname($filename);
 		}
@@ -128,7 +128,7 @@ 
 	foreach ($arr as &$tbl) {
 		$filename = $argv[3]."/".$tbl.".gz";
 		if (file_exists($filename)) {
-			echo $pdo->log->header("Restoring $tbl.");
+			echo $pdo->log->header("restoring $tbl.");
 			$command = "zcat < $filename | mysql --defaults-file=mysql-defaults.txt -h$dbhost $use $dbname";
 			system($command);
 		}
@@ -140,7 +140,7 @@ 
 	foreach($tables as $row) {
 		$tbl = $row['Tables_in_'.DB_NAME];
 		$filename = $argv[3].$tbl.".csv";
-		echo $pdo->log->header("Dumping $tbl.");
+		echo $pdo->log->header("dumping $tbl.");
 		if (file_exists($filename)) {
 			newname($filename);
 		}
@@ -154,7 +154,7 @@ 
 		$tbl = $row['Tables_in_'.DB_NAME];
 		$filename = $argv[3].$tbl.".csv";
 		if (file_exists($filename)) {
-			echo $pdo->log->header("Restoring $tbl.");
+			echo $pdo->log->header("restoring $tbl.");
 			$pdo->queryExec(sprintf("LOAD DATA INFILE %s INTO TABLE %s", $pdo->escapeString($filename), $tbl));
 		}
 	}