--- lotgd-1.0.2.orig/translatortool.php	2005-02-11 10:43:19.000000000 -0500
+++ lotgd-1.0.2/translatortool.php	2005-06-07 15:41:16.000000000 -0400
@@ -65,7 +65,7 @@
 		}elseif(db_num_rows($result)==1){
 			$row = db_fetch_assoc($result);
 			// MySQL is case insensitive so we need to do it here.
-			if ($row['intext'] == $text){
+			if ($row['intext'] == stripslashes($text)){
 				$sql = "UPDATE ".db_prefix("translations")." SET author='{$session['user']['login']}', version='$logd_version', uri='$uri', outtext='$trans' WHERE tid={$row['tid']}";
 			}else{
 				$sql = "INSERT INTO " . db_prefix("translations") . " (language,uri,intext,outtext,author,version) VALUES ('" . LANGUAGE . "','$uri','$text','$trans','{$session['user']['login']}','$logd_version ')";
@@ -76,11 +76,17 @@
 			$rows = array();
 			while ($row = db_fetch_assoc($result)){
 				// MySQL is case insensitive so we need to do it here.
-				if ($row['intext'] == $text){
-					$rows['tid']=$row['tid'];
+				if ($row['intext'] == stripslashes($text)){
+					array_push($rows,$row['tid']);
 				}
 			}
-			$sql = "UPDATE ".db_prefix("translations")." SET author='{$session['user']['login']}', version='$logd_version', uri='$page', outtext='$trans' WHERE tid IN (".join(",",$rows).")";
+			if (count($rows)>0){
+				$sql = "UPDATE ".db_prefix("translations")." SET author='{$session['user']['login']}', version='$logd_version', uri='$page', outtext='$trans' WHERE tid IN (".join(",",$rows).")";
+			}else{
+				$sql = "INSERT INTO " . db_prefix("translations") . " (language,uri,intext,outtext,author,version) VALUES ('" . LANGUAGE . "','$uri','$text','$trans','{$session['user']['login']}','$logd_version ')";
+				$sql1 = "DELETE FROM " . db_prefix("untranslated") . " WHERE intext='$text' AND language='" . LANGUAGE . "' AND namespace='$url'";
+				db_query($sql1);
+			}
 		}
 	}
 	db_query($sql);