From 6120a6b9fae4cf85831c547db4a1c3c5d5be765d Mon Sep 17 00:00:00 2001
From: Metabox <vilijanac@gmail.com>
Date: Sun, 4 Aug 2019 05:21:49 +1000
Subject: [PATCH] New Notes table cross SQLite db compatible.

---
 htdocs/cgi-bin/login_ctr.cgi | 17 +++++++++++++----
 1 file changed, 13 insertions(+), 4 deletions(-)

diff --git a/htdocs/cgi-bin/login_ctr.cgi b/htdocs/cgi-bin/login_ctr.cgi
index b93920e..deb4c15 100755
--- a/htdocs/cgi-bin/login_ctr.cgi
+++ b/htdocs/cgi-bin/login_ctr.cgi
@@ -154,9 +154,9 @@ try{
 }
  catch{	 	
 	  print $cgi->header;
-		print "<font color=red><b>SERVER ERROR</b></font>:".$_;
-    print $cgi->end_html;
-		exit;
+	  print "<font color=red><b>SERVER ERROR</b></font>:".$_;
+	  print $cgi->end_html;
+	  exit;
  }
 }
 
@@ -246,7 +246,16 @@ try{
 		}
 	}
 	#
-	#TODO Future table.
+	# Scratch FTS4 implementation if present.
+	#
+	$st = $db->prepare(selSQLTbl('NOTES'));
+	$st->execute();
+	if($st->fetchrow_array()) {
+		$rv = $db->do('DROP TABLE NOTES;');
+		if($rv < 0){print "<p>Error->"& $DBI::errstri &"</p>"};
+	}
+	#
+	# New Implementation as of 1.5, cross SQLite Database compatible.
 	#
 	$st = $db->prepare(selSQLTbl('NOTES'));
 	$st->execute();
-- 
2.34.1