Tidy firebird installation on Linux

2 files changed, 7 insertions, 3 deletions

diff --git a/create_firebird_database.php b/create_firebird_database.php
index 5c65334..38a35d5 100644
--- a/create_firebird_database.php
+++ b/create_firebird_database.php
@@ -13,7 +13,7 @@
 	
   Set tabs to 4 for best viewing.
   Added by Lester Caine to provide an in-line generation of Firebird(/Interbase) database
-  Firebird requires the database to exist before it can be connected to as part of it's 
+  Firebird requires the database to exist before it can be connected to as part of it's
   security system
   Still need to be extended to allow selection of OS tmp directory, 
   and path to Firebird bin directory 
@@ -36,7 +36,11 @@
 
 		$sql = str_replace("\r\n", "\n", $sql);
 		$sql .= "\n";
-		$tmp_name = $_ENV["TMP"].'/'.uniqid('').'.sql';
+		if( isset($_ENV["TMP"])) {
+			$tmp_name = $_ENV["TMP"].'/'.uniqid('').'.sql';
+		} else {
+			$tmp_name = '/tmp/'.uniqid('').'.sql';
+		}
 
 		if ($fp = fopen ($tmp_name, 'a')) {
 			fwrite($fp, $sql);
diff --git a/get_databases_inc.php b/get_databases_inc.php
index ac26b30..66f8cd4 100644
--- a/get_databases_inc.php
+++ b/get_databases_inc.php
@@ -49,7 +49,7 @@ if( function_exists( 'fbird_connect' ) ) {
 		if ( is_windows() )
 			$fbpath = 'c:\Program Files\Firebird\Firebird_2_1\bin\isql';
 		else
-			$fbpath = '/usr/lib64/firebird/bin/isql';
+			$fbpath = '/opt/firebird/bin/isql';
 	}
 	$gBitSmarty->assign( 'fbpath', $fbpath );
 	if ( empty($gBitDbName) ) { $gBitDbName = 'bitweaver'; }