Changeset 68 for trunk/WordPress/plugin/transposh/transposh.php

Timestamp:

03/17/2009 09:07:25 AM (3 years ago)

Author:

ofer

Message:

Initial commit of auto-translate feature

File:

• trunk/WordPress/plugin/transposh/transposh.php (modified) (19 diffs)

trunk/WordPress/plugin/transposh/transposh.php

@@ -42 +42 @@
 
 //Database version
-define("DB_VERSION", "1.01");
+define("DB_VERSION", "1.02");
 
 //Constant used as key in options database
@@ -221 +221 @@
  * Fetch translation from db or cache.
  * Returns the translated string or NULL if not available.
+ * TODO: // will an array work?
  */
 function fetch_translation($original)
@@ -230 +231 @@
     if(ENABLE_APC && function_exists('apc_fetch'))
     {
-        $cached = apc_fetch($original . $lang, $rc);
+        $cached = apc_fetch($original .'___'. $lang, $rc);
         if($rc === TRUE)
         {
@@ -243 +244 @@
     if($row !== FALSE)
     {
-        $translated = $row->translated;
-        $translated = stripslashes($translated);
-
-        logger("db result for $original >>> $translated ($lang)" , 3);
+        $translated_text = stripslashes($row->translated);
+        $translated = array($translated_text, $row->source);
+
+        logger("db result for $original >>> $translated_text ($lang) ({$row->source})" , 3);
     }
 
@@ -260 +261 @@
 
         //update cache
-        $rc = apc_store($original . $lang, $cache_entry, 3600);
+        $rc = apc_store($original .'___'. $lang, $cache_entry, 3600);
         if($rc === TRUE)
         {
@@ -298 +299 @@
     $js .= "\n<script type=\"text/javascript\" src=\"$overlib_dir/overlibmws_shadow.js\"></script>";
 
-    $js .= "\n<script type=\"text/javascript\" src=\"$plugin_url/js/transposh.js\"></script>\n";
-    $js .= "\n<script type=\"text/javascript\" src=\"http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js\"></script>\n";
-    $js .= "\n<script type=\"text/javascript\" src=\"http://www.google.com/jsapi\"></script>\n";
-    $js .= "\n<script type=\"text/javascript\">google.load(\"language\", \"1\");</script>\n";
+    $js .= "\n<script type=\"text/javascript\" src=\"$plugin_url/js/transposh.js\"></script>";
+    $js .= "\n<script type=\"text/javascript\" src=\"http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js\"></script>";
+    $js .= "\n<script type=\"text/javascript\" src=\"http://www.google.com/jsapi\"></script>";
+    $js .= "\n<script type=\"text/javascript\">google.load(\"language\", \"1\");</script>";
+    global $lang, $home_url;
+    $post_url = $home_url . '/index.php';
+    $js .= "\n<script type=\"text/javascript\">var transposh_post_url='$post_url';var transposh_target_lang='$lang';$(document).ready(function() {do_auto_translate();});</script>";
 
     echo $js;
@@ -313 +317 @@
          placed within the img tag for use on client side operation (jquery)
  */
-function get_img_tag($original, $translation, $segment_id, $is_translated = FALSE)
+function get_img_tag($original, $translation, $source, $segment_id, $is_translated = FALSE)
 {
     global $plugin_url, $lang, $home_url;
@@ -330 +334 @@
     }
 
+    if ($source == 1) {
+        $add_img = "_auto";
+    }
+
     $img = "<img src=\"$plugin_url/translate$add_img.png\" alt=\"translate\" id=\"" . IMG_PREFIX . "$segment_id\"
-           onclick=\"translate_dialog('$original','$translation','$lang','$url', '$segment_id'); return false;\"
+           onclick=\"translate_dialog('$original','$translation','$segment_id'); return false;\"
            onmouseover=\"hint('$original'); return true;\"
            onmouseout=\"nd()\" />";
@@ -395 +403 @@
     $translation = $_POST['translation'];
     $lang = $_POST['lang'];
+    $source = $_POST['source'];
 
     if(!isset($original) || !isset($translation) || !isset($lang))
     {
-        logger("Enter " . __FILE__ . " missing params: $original , $translation, $lang," .
-               $ref, 0);
+        logger("Enter " . __FILE__ . " missing params: $original , $translation, $lang," . $ref, 0);
         return;
     }
@@ -413 +421 @@
     $translation = $wpdb->escape(htmlspecialchars(stripslashes(urldecode($translation))));
 
-    $update = "REPLACE INTO  $table_name (original, translated, lang)
-                VALUES ('" . $original . "','" . $translation . "','" . $lang . "')";
+    //TODO: Check more escaping...
+
+    $update = "REPLACE INTO  $table_name (original, translated, lang, source)
+                VALUES ('" . $original . "','" . $translation . "','" . $lang . "','" . $source . "')";
 
     $result = $wpdb->query($update);
@@ -420 +430 @@
     if($result !== FALSE)
     {
-        update_transaction_log($original, $translation, $lang);
+        update_transaction_log($original, $translation, $lang, $source);
 
         //Delete entry from cache
         if(ENABLE_APC && function_exists('apc_store'))
         {
-            apc_delete($original . $lang);
+            apc_delete($original .'___'. $lang);
         }
         logger("Inserted to db '$original' , '$translation', '$lang' " , 3);
@@ -443 +453 @@
  *
  */
-function update_transaction_log(&$original, &$translation, &$lang)
+function update_transaction_log(&$original, &$translation, &$lang, $source)
 {
         global $wpdb, $user_ID;
@@ -458 +468 @@
         }
 
-    $log = "INSERT INTO ".$wpdb->prefix.TRANSLATIONS_LOG." (original, translated, lang, translated_by)
-                VALUES ('" . $original . "','" . $translation . "','" . $lang . "','".$loguser."')";
+    $log = "INSERT INTO ".$wpdb->prefix.TRANSLATIONS_LOG." (original, translated, lang, translated_by, source)
+                VALUES ('" . $original . "','" . $translation . "','" . $lang . "','".$loguser."','".$source."')";
 
     $result = $wpdb->query($log);
@@ -465 +475 @@
     if($result === FALSE)
     {
-        logger("Error !!! failed to update transaction log:  $loguser, $original ,$translation, $lang" , 0);
-    }
-
-}
-
+        logger("Error !!! failed to update transaction log:  $loguser, $original ,$translation, $lang, $source" , 0);
+    }
+}
 
 /*
@@ -510 +518 @@
 }
 
-
 /*
  * Page generation completed - flush buffer.
@@ -518 +525 @@
     ob_flush();
 }
-
 
 /*
@@ -580 +586 @@
     return $qvars;
 }
-
 
 /*
@@ -609 +614 @@
         dbDelta($sql);
 
+                // TODO: remove this?
         //Verify that newly created table is ready for use.
         //$insert = "INSERT INTO " . $table_name . " (original, translated, lang) " .
@@ -634 +640 @@
                                                   translated VARCHAR(256),
                                                   translated_by VARCHAR(15),
+                                                  source TINYINT NOT NULL,
                                                   timestamp TIMESTAMP,
                                                   PRIMARY KEY (original, lang, timestamp)) ";