[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[GNUnet-SVN] r1655 - in Extractor-docs/WWW: . download gnu.org
|
From: |
grothoff |
|
Subject: |
[GNUnet-SVN] r1655 - in Extractor-docs/WWW: . download gnu.org |
|
Date: |
Sat, 13 Aug 2005 19:17:53 -0700 (PDT) |
Author: grothoff
Date: 2005-08-13 19:15:17 -0700 (Sat, 13 Aug 2005)
New Revision: 1655
Added:
Extractor-docs/WWW/download/libextractor-0.5.3.tar.gz
Removed:
Extractor-docs/WWW/example.php
Extractor-docs/WWW/example2.php
Extractor-docs/WWW/header.patch
Extractor-docs/WWW/update0_1_0.php
Extractor-docs/WWW/update0_2_0.php
Modified:
Extractor-docs/WWW/download.php3
Extractor-docs/WWW/gnu.org/requirements.html
Extractor-docs/WWW/index.php
Extractor-docs/WWW/oldnews.php3
Extractor-docs/WWW/plugins_list
Log:
release
Added: Extractor-docs/WWW/download/libextractor-0.5.3.tar.gz
===================================================================
(Binary files differ)
Property changes on: Extractor-docs/WWW/download/libextractor-0.5.3.tar.gz
___________________________________________________________________
Name: svn:mime-type
+ application/octet-stream
Modified: Extractor-docs/WWW/download.php3
===================================================================
--- Extractor-docs/WWW/download.php3 2005-08-14 02:14:40 UTC (rev 1654)
+++ Extractor-docs/WWW/download.php3 2005-08-14 02:15:17 UTC (rev 1655)
@@ -34,8 +34,8 @@
ANCHOR("tar");
H2("Tar Package");
W("Latest version is %s.",
- extlink_("download/libextractor-0.5.1.tar.gz",
- "libextractor-0.5.1.tar.gz"));
+ extlink_("download/libextractor-0.5.3.tar.gz",
+ "libextractor-0.5.3.tar.gz"));
BR();
W("Latest Java-binding is %s.",
extlink_("download/libextractor-java-0.5.1.tar.gz",
Deleted: Extractor-docs/WWW/example.php
===================================================================
--- Extractor-docs/WWW/example.php 2005-08-14 02:14:40 UTC (rev 1654)
+++ Extractor-docs/WWW/example.php 2005-08-14 02:15:17 UTC (rev 1655)
@@ -1,29 +0,0 @@
-<?php
-include("i18nhtml.inc.php");
-DOCTYPE("HTML");
-echo "<html><head>";
-TITLE("Example page");
-echo "</head><body>";
-H1("Some document title");
-W("A sentence to translate.");
-W("A sentence with an argument '%s' that cannot be translated.",
- "foo");
-W("A sentence with two arguments '%s' and '%s' that cannot be translated.",
- ARRAY("foo", "bar"));
-P(); // <p>
-W("A sentence with a %s that CAN be translated.",
- extlink_("http://gnunet.org/i18nHTML/";, "link text"));
-W("A %s to another translatable page.",
- intlink_("http://gnunet.org/i18nHTML/index";, "link")); // .php is added
automatically!
-BR(); // <br>
-echo W_("A function returning the translation.");
-W("For more functions, look into i18nhtml.inc.");
-
-HR();
-W("And finally put the language selection bar somewhere:");
-generateLanguageBar(); // allow user to select other languages
-P();
-W("Oh, and put the footer to allow the editor mode:");
-generateFooter();
-echo "</body></html>";
-?>
\ No newline at end of file
Deleted: Extractor-docs/WWW/example2.php
===================================================================
--- Extractor-docs/WWW/example2.php 2005-08-14 02:14:40 UTC (rev 1654)
+++ Extractor-docs/WWW/example2.php 2005-08-14 02:15:17 UTC (rev 1655)
@@ -1,61 +0,0 @@
-<?php
-include("i18nhtml.inc.php"); // do this 1st, add translation support
-DOCTYPE("HTML","Transitional"); // tell the user agent document format
-setTranslateLinkMarker("***"); // make translation marker more visible
-editOnlyUntranslatedText(); // restrict translations to
untranslated strings
-
-echo "<html><head>";
-TITLE("Another Example Page");
-echo "</head><body>";
-
-HR();
-generateLanguageBar(); // allow user to select other languages
-HR();
-
-H1("header1");
-H2("header2");
-H3("header3");
-H2("header2 again");
-H3("yet another sub header");
-H3("and again, I think you get the idea");
-P(); // <p>
-W("A sentence to translate.");
-W("A sentence with an argument '%s' that cannot be translated.",
- "foo");
-W("A sentence with two arguments '%s' and '%s' that cannot be translated.",
- ARRAY("foo", "bar"));
-P(); // <p>
-echo "This is untranslated text\n";
-BR(); // <br>
-echo "another way to translate text, note each W chunk represents a ";
-echo "single translatable chunk so similar to above, but split into ";
-echo "multiple translation chunks.<br>";
-$myvar = W_("A sentence with an argument ");
-$myvar = $myvar . "foo" . W_(" that cannot be translated.");
-echo $myvar;
-P(); // <p>
-echo "here we have text that is translated, but not easily edited";
-echo "unless it happens to match some other text.<br>";
-$myvar = TRANSLATE_("A sentence with an argument ");
-$myvar = $myvar . "foo" . TRANSLATE_(" that is not translatable.");
-echo $myvar;
-W("A sentence with a %s that CAN be translated.",
- extlink_("http://gnunet.org/i18nHTML/";, "link text"));
-W("A %s to another translatable page.",
- intlink_("http://gnunet.org/i18nHTML/index";, "link")); // .php is added
automatically!
-BR(); // <br>
-echo W_("A function returning the translation.");
-W("For more functions, look into i18nhtml.inc.");
-P();
-
-HR();
-$t = "Notice how we don't have to escape or quote(\") ampersands & nor other";
-$t = $t . "HTML entities. <<<--->>> and such even work. This looks like
&\n";
-W($t);
-HR();
-
-P();
-W("Insert footer to allow entering translation edit mode:");
-generateFooter();
-echo "</body></html>";
-?>
Modified: Extractor-docs/WWW/gnu.org/requirements.html
===================================================================
--- Extractor-docs/WWW/gnu.org/requirements.html 2005-08-14 02:14:40 UTC
(rev 1654)
+++ Extractor-docs/WWW/gnu.org/requirements.html 2005-08-14 02:15:17 UTC
(rev 1655)
@@ -3,8 +3,5 @@
<a href="http://www.freebsd.org/";>FreeBSD</a>,
<a href="http://www.openbsd.org/";>OpenBSD</a>,
<a href="http://www.netbsd.org/";>NetBSD</a>, OS X, Windows XP or
Solaris.</li>
- <li><a href="http://www.gnu.org/software/gmp/";>GNU MP Bignum Library</a>
(>= 4.0.0)</li>
- <li><a href="http://www.gnu.org/directory/security/libgcrypt.html";>libgcrypt
(>= 1.2.0)</a></li>
- <li><a href="http://www.gtk.org/";>gtk+</A> (>= 2.4)</li>
- <li><a href="http://www.gnu.org/software/libextractor/";>libextractor</a>
(>= 0.4.2)</li>
+ <li><a href="http://www.gtk.org/";>gtk+</A> (>= 2.6)</li>
</ul>
Deleted: Extractor-docs/WWW/header.patch
===================================================================
--- Extractor-docs/WWW/header.patch 2005-08-14 02:14:40 UTC (rev 1654)
+++ Extractor-docs/WWW/header.patch 2005-08-14 02:15:17 UTC (rev 1655)
@@ -1,19 +0,0 @@
-@@ -78,7 +78,7 @@
- /* RPM - Copyright (C) 1995-2001 Red Hat Software */
-
- #include <stdio.h>
--#include <rpmio.h>
-+#include "rpmio.h"
-
- #ifdef __cplusplus
- extern "C" {
-@@ -713,7 +713,7 @@
- }
-
- #if !defined(__HEADER_PROTOTYPES__)
--#include <hdrinline.h>
-+#include "hdrinline.h"
- #endif
-
- #ifdef __cplusplus
-
Modified: Extractor-docs/WWW/index.php
===================================================================
--- Extractor-docs/WWW/index.php 2005-08-14 02:14:40 UTC (rev 1654)
+++ Extractor-docs/WWW/index.php 2005-08-14 02:15:17 UTC (rev 1655)
@@ -37,6 +37,8 @@
H2("Recent News");
P();
echo "<dl>";
+DTDD("Sat Aug 13 19:08:46 PDT 2005 | libextractor v0.5.3 released.",
+ "This release fixes various bugs in the EXIV2, OO and OLE2 plugins. A
static, relocatable version of glib is no longer required.");
DTDD("Thu Jul 14 22:31:28 CEST 2005 | libextractor v0.5.2 released.",
"This release adds support for exiv2. The API was extended to support
in-memory metadata extraction (no file required). Also new are functions to
encode and decode the binary metadata of a thumbnail. Various plugins were
changed to allow for the in-memory metadata extraction. A minor compile error
was fixed.");
DTDD("Mon Jul 4 18:24:18 CEST 2005 | libextractor v0.5.1 released.",
@@ -47,31 +49,6 @@
"This release fixes some bugs in the ID3, PDF, PNG and REAL extractors.
The REAL extractor now also handles the new Helix formats. libextractor can
now also be used to extract thumbnails from images (using ImageMagick).");
DTDD("Wed Jan 26 19:51:44 EST 2005 | libextractor v0.4.1 released.",
"This release fixes a security issue (inherited from xpdf). It also
extracts more meta-data from files of TAR or QuickTime format.");
-DTDD("Sat Dec 25 21:42:26 CET 2004 | libextractor v0.4.0 released.",
- "This release improves support for character sets (plugins are now
expected to convert to UTF-8). It also improves support for mp3 (adding
genres) and png (handling of compressed comments).");
-DTDD("Sat Nov 13 13:23:23 EST 2004 | libextractor v0.3.11 released.",
- "This release fixes bugs in the dvi, man, ID3v2.3, ole2 and pdf
extractors.");
-DTDD("Sun Oct 18 13:23:35 EST 2004 | libextractor v0.3.10 released.",
- "This release adds support for ID3v2.3 and ID3v2.4. It fixes bugs in the
tar, man, deb, mp3 and ole2 extractors.");
-DTDD("Sat Oct 17 18:12:11 EST 2004 | libextractor v0.3.9 released.",
- "This release adds support for the man, tar (including tar.gz) and deb
formats. It fixes bugs in the id3v2 and jpeg extractors. The size of jpeg
images is now also extracted. This version adds support for 64-bit file
sizes.");
-DTDD("Sat Oct 02 20:00:04 EST 2004 | libextractor v0.3.8 released.",
- "This release adds support for dvi (from TeX). The plugins are now installed
in a separate plugin directory. libextractor now works under OS X (10.3).");
-DTDD("Fri Sep 23 23:30:33 EST 2004 | libextractor v0.3.7 released.",
- "This release adds support for StarOffice formats, ID3v2 tags and the
Ripe160MD hash function. It also improves the performance of the HTML and ZIP
extractors.");
-DTDD("Fri Sep 10 20:10:38 EST 2004 | libextractor v0.3.6 released.",
- "This release adds support for OpenOffice formats, hash functions (md5,
sha-1) and fixes some build problems.");
-DTDD("Mon Aug 30 23:18:49 IST 2004 | libextractor v0.3.5 released.",
- "This release adds support for OLE2 (WinWord, PowerPoint, Excel formats)
and fixes various minor bugs. For OLE2 support you will have to have glib 2.0
installed (yes, that is glib from GTK/Gnome, not glibc!).");
-DTDD("Thu Aug 26 20:27:24 IST 2004 | Bugtracking using Mantis enabled.",
- "You can now report and view bug-reports about libextractor on %s.",
- extlink_("https://gnunet.org/mantis/","Mantis";));
-DTDD("Wed Aug 25 19:02:07 IST 2004 | libextractor v0.3.4 released.",
- "This release fixes a minor linking error (<tt>-lm</tt> for
<tt>floor</tt>), improves performance and adds support for GNU gettext
(internationalization).");
-DTDD("Wed May 31 19:22:07 EST 2004 | libextractor v0.3.3 released.",
- "This release fixes various minor bugs (segmentation faults and
non-termination of mpeg and riff extractors for malformed files) and adds
support for WAV files.");
-DTDD("Wed May 31 19:22:07 EST 2004 | libextractor v0.3.2 released.",
- "This release fixes various minor bugs (plugins misbehaving for malformed
files) and improves portability to Cygwin/MinGW.");
echo "</dl>";
P();
W("%s",
Modified: Extractor-docs/WWW/oldnews.php3
===================================================================
--- Extractor-docs/WWW/oldnews.php3 2005-08-14 02:14:40 UTC (rev 1654)
+++ Extractor-docs/WWW/oldnews.php3 2005-08-14 02:15:17 UTC (rev 1655)
@@ -5,44 +5,48 @@
$author="Vids Samanta";
$page="oldnews";
include("html_header.php3");
+echo "<dl>";
+DTDD("Sat Dec 25 21:42:26 CET 2004 | libextractor v0.4.0 released.",
+ "This release improves support for character sets (plugins are now
expected to convert to UTF-8). It also improves support for mp3 (adding
genres) and png (handling of compressed comments).");
+DTDD("Sat Nov 13 13:23:23 EST 2004 | libextractor v0.3.11 released.",
+ "This release fixes bugs in the dvi, man, ID3v2.3, ole2 and pdf
extractors.");
+DTDD("Sun Oct 18 13:23:35 EST 2004 | libextractor v0.3.10 released.",
+ "This release adds support for ID3v2.3 and ID3v2.4. It fixes bugs in the
tar, man, deb, mp3 and ole2 extractors.");
+DTDD("Sat Oct 17 18:12:11 EST 2004 | libextractor v0.3.9 released.",
+ "This release adds support for the man, tar (including tar.gz) and deb
formats. It fixes bugs in the id3v2 and jpeg extractors. The size of jpeg
images is now also extracted. This version adds support for 64-bit file
sizes.");
+DTDD("Sat Oct 02 20:00:04 EST 2004 | libextractor v0.3.8 released.",
+ "This release adds support for dvi (from TeX). The plugins are now installed
in a separate plugin directory. libextractor now works under OS X (10.3).");
+DTDD("Fri Sep 23 23:30:33 EST 2004 | libextractor v0.3.7 released.",
+ "This release adds support for StarOffice formats, ID3v2 tags and the
Ripe160MD hash function. It also improves the performance of the HTML and ZIP
extractors.");
+DTDD("Fri Sep 10 20:10:38 EST 2004 | libextractor v0.3.6 released.",
+ "This release adds support for OpenOffice formats, hash functions (md5,
sha-1) and fixes some build problems.");
+DTDD("Mon Aug 30 23:18:49 IST 2004 | libextractor v0.3.5 released.",
+ "This release adds support for OLE2 (WinWord, PowerPoint, Excel formats)
and fixes various minor bugs. For OLE2 support you will have to have glib 2.0
installed (yes, that is glib from GTK/Gnome, not glibc!).");
+DTDD("Thu Aug 26 20:27:24 IST 2004 | Bugtracking using Mantis enabled.",
+ "You can now report and view bug-reports about libextractor on %s.",
+ extlink_("https://gnunet.org/mantis/","Mantis";));
+DTDD("Wed Aug 25 19:02:07 IST 2004 | libextractor v0.3.4 released.",
+ "This release fixes a minor linking error (<tt>-lm</tt> for
<tt>floor</tt>), improves performance and adds support for GNU gettext
(internationalization).");
+DTDD("Wed May 31 19:22:07 EST 2004 | libextractor v0.3.3 released.",
+ "This release fixes various minor bugs (segmentation faults and
non-termination of mpeg and riff extractors for malformed files) and adds
support for WAV files.");
+DTDD("Wed May 31 19:22:07 EST 2004 | libextractor v0.3.2 released.",
+ "This release fixes various minor bugs (plugins misbehaving for malformed
files) and improves portability to Cygwin/MinGW.");
+DTDD("Wed Apr 28 19:29:24 EST 2004 | libextractor v0.3.1 released.",
+ "This release adds support for ELF and fixes various minor bugs,
including a memory leak in the PDF code and a problem with possible
non-termination of the RIFF parser. Also the missing Java header file is now
packaged properly.");
+DTDD("Mon Apr 12 08:28:55 EST 2004 | libextractor v0.3.0 released.",
+ "This release adds extractors for MPEG and RIFF (also known as AVI).
libextractor and all of its plugins should now be reentrant. Various bugs
including memory leaks and possible segfaults were fixed. The man-pages were
updated and automated testcases were added. The library initializations
sequence was streamlined and where possible a <tt>const</tt> modifier was added
to function prototypes. A Java interface to libextractor is now included and
the corresponding JNI functions are build into libextractor (if <tt>jni.h</tt>
is found by configure).");
+DTDD("Sun Apr 4 20:24:39 EST 2004 | Libextractor v0.2.7 released.",
+ "This release improves portability to Win32 (mingw), fixes various minor
problems and adds support for TIFF. For PNG and GIF the dimensions of the
image are now also extracted.");
+DTDD("Thu Oct 16 23:11:42 EST 2003 | Libextractor v0.2.6 released.",
+ "This release fixes various portability issues. 0.2.6 works under OSX
and the binary extraction plugins were fixed to work properly on all supported
platforms. Memory requirements for compiling libextractor have been reduced
dramatically (now needs only about 100 MB). Various minor bugs were fixed.");
+DTDD("Wed Jul 16 21:36:55 EST 2003 | Libextractor v0.2.5
released.","libextractor 0.2.5 fixes some bugs in the binary extraction plugin.
Also it no longer needs aspell or pspell since it now does spell checking
its-self using a %s",
+ extlink_("http://gnunet.org/download/bloomfilter.ps","bloomfilter";));
+DTDD("Mon Jun 30 23:16:34 EST 2003 | Libextractor v0.2.4 released.",
+ "libextractor 0.2.4 contains a new generic plugin for the extraction of
ascii text from binaries. The plugin can use spell checkers to validate
keywords. Performance of extraction was greatly improved by limiting the pdf
extractor to process only well formed pdf files.");
+DTDD("Fri Apr 11 18:54:47 EST 2003 | Bugfix in dynamic libs and rpm plugin,
added ASF and QT plugins",
+ "v0.2.3 released with new plugins for ASF and QT. Also removed dependecy
on rpmdevel, rpm code is now integrated in the rpm plugin. Also fixed some
issues with dynamic libraries.");
+echo "</dl>";
?>
-<dl>
-<dt>Wed Apr 28 19:29:24 EST 2004 | libextractor v0.3.1 released.</dt>
-<dd>This release adds support for ELF and fixes various minor bugs,
- including a memory leak in the PDF code and a problem with
- possible non-termination of the RIFF parser. Also the missing
- Java header file is now packaged properly.</dd>
-<dt>Mon Apr 12 08:28:55 EST 2004 | libextractor v0.3.0 released.</dt>
-<dd>This release adds extractors for MPEG and RIFF (also known as AVI).
libextractor
- and all of its plugins should now be reentrant. Various bugs
- including memory leaks and possible segfaults were fixed.
- The man-pages were updated and automated testcases were added. The
- library initializations sequence was streamlined and where
- possible a <tt>const</tt> modifier was added to function prototypes. A
- Java interface to libextractor is now included and the corresponding JNI
functions
- are build into libextractor (if <tt>jni.h</tt> is found by configure).</dd>
-<dt>Sun Apr 4 20:24:39 EST 2004 | Libextractor v0.2.7 released.</dt>
-<dd>This release improves portability to Win32 (mingw), fixes various minor
problems and adds
- support for TIFF. For PNG and GIF the dimensions of the image are now
also extracted.</dd>
-<dt>Thu Oct 16 23:11:42 EST 2003 | Libextractor v0.2.6 released.</dt>
-<dd>This release fixes various portability issues. 0.2.6 works under OSX and
the binary extraction
- plugins were fixed to work properly on all supported platforms. Memory
requirements for
- compiling libextractor have been reduced dramatically (now needs only
about 100 MB).
- Various minor bugs were fixed.</dd>
-<dt>Wed Jul 16 21:36:55 EST 2003 | Libextractor v0.2.5 released.</dt>
-<dd>libextractor 0.2.5 fixes some bugs in the binary extraction plugin. Also
it no longer needs
-aspell or pspell since it now does spell checking its-self using a <a
href="http://gnunet.org/download/bloomfilter.ps";>bloomfilter</a>.</dd>
-<dt>Mon Jun 30 23:16:34 EST 2003 | Libextractor v0.2.4 released.</dt>
-<dd>libextractor 0.2.4 contains a new generic plugin for the extraction of
ascii text from binaries. The
-plugin can use spell checkers to validate keywords. Performance of extraction
was greatly improved
-by limiting the pdf extractor to process only well formed pdf files.</dd>
-
-
-<dt>Fri Apr 11 18:54:47 EST 2003 | Bugfix in dynamic libs and rpm plugin,
added ASF and QT plugins </dt>
-<dd>v0.2.3 released with new plugins for ASF and QT. Also removed
-dependecy on rpmdevel, rpm code is now integrated in the rpm plugin. Also
-fixed some issues with dynamic libraries.</dd>
-</dl>
<ul>
<li>Wed Feb 26 04:29:32 EST 2003
<p>Added zip plugin by Julia Wolf, and fixed a bug in linking.
Modified: Extractor-docs/WWW/plugins_list
===================================================================
--- Extractor-docs/WWW/plugins_list 2005-08-14 02:14:40 UTC (rev 1654)
+++ Extractor-docs/WWW/plugins_list 2005-08-14 02:15:17 UTC (rev 1655)
@@ -9,6 +9,7 @@
MP3 (ID3v1 and ID3v2),
OGG,
WAV,
+EXIV2,
JPEG,
GIF,
PNG,
Deleted: Extractor-docs/WWW/update0_1_0.php
===================================================================
--- Extractor-docs/WWW/update0_1_0.php 2005-08-14 02:14:40 UTC (rev 1654)
+++ Extractor-docs/WWW/update0_1_0.php 2005-08-14 02:15:17 UTC (rev 1655)
@@ -1,50 +0,0 @@
-<?php
-include("i18nhtml.inc");
-?>
-# This script merely generates the SQL statements<br>
-# to do the update. You'll have to run the SQL<br>
-# commands yourself to prevent accidental data loss.<br>
-# <pre>
-<?php
-echo "use $i18nHTMLsqlDB;\n";
-$query = "SELECT * FROM map";
-$result = mysql_query($query, $connection);
-$num = 0;
-$loss = 0;
-if ($result)
- $num = mysql_numrows($result);
-for ($ii=0;$ii<$num;$ii++) {
- $row = mysql_fetch_array($result);
- $la = mysql_real_escape_string($row["lang"]);
- $src = mysql_real_escape_string($row["name"]); // urlencoded
- $dst = $row["translation"]; // possibly urlencoded
- $rank = $row["ranking"];
- $rtrans = mysql_real_escape_string(to_unicode(urldecode($dst)));
- // detect "bad" translations (where conversion failed)
- // if more than 5 values in [0..9] follow => bad conversion
- $txtCnt = count_chars(urldecode($src), 1);
- $tCnt = count_chars($rtrans, 1);
-
- // 3426
- if (! ( ereg("&#[0-9]{6}", $rtrans) ||
- ($txtCnt[ord('%')] != $tCnt[ord('%')]) ||
- ( ( ($la != "Japanese") &&
- ($la != "Traditional chinese") &&
- ($la != "Russian") &&
- ($la != "Ukrainian") &&
- (ereg("&#[0-9]{4}", $rtrans)) ) ) ) ) {
- $dst = mysql_real_escape_string($dst);
- if ($rtrans != $dst) {
- $subquery = "UPDATE map SET translation=\"$rtrans\" WHERE name=\"$src\"
AND lang=\"$la\" AND translation=\"$dst\" AND ranking=$rank;\n";
- echo "$subquery\n";
- }
- } else {
- $subquery = "DELETE FROM map WHERE name=\"$src\" AND lang=\"$la\" AND
translation=\"$dst\" AND ranking=$rank;\n";
- echo "$subquery\n";
- $loss++;
- }
- }
-echo "# Lost $loss out of $num translations.\n";
-?>
-# </pre>
-# end of conversion
Deleted: Extractor-docs/WWW/update0_2_0.php
===================================================================
--- Extractor-docs/WWW/update0_2_0.php 2005-08-14 02:14:40 UTC (rev 1654)
+++ Extractor-docs/WWW/update0_2_0.php 2005-08-14 02:15:17 UTC (rev 1655)
@@ -1,36 +0,0 @@
-<?php
-include("i18nhtml.inc");
-?>
-# This script merely generates the SQL statements<br>
-# to do the update. You'll have to run the SQL<br>
-# commands yourself to prevent accidental data loss.<br>
-# <pre>
-<?php
-echo "use $i18nHTMLsqlDB;\n";
-$query = "SELECT * FROM map";
-$result = mysql_query($query, $connection);
-$num = 0;
-$loss = 0;
-if ($result)
- $num = mysql_numrows($result);
-for ($ii=0;$ii<$num;$ii++) {
- $row = mysql_fetch_array($result);
- $la = mysql_real_escape_string($row["lang"]);
- $src = $row["name"]; // urlencoded
- $src_sql = mysql_real_escape_string($src);
- $dst_sql = mysql_real_escape_string($row["translation"]);
- $rank = $row["ranking"];
- $rname = fix(urldecode($src));
- $rname_sql = mysql_real_escape_string(fix(urldecode($src)));
- // detect "bad" translations (where conversion failed)
- // if more than 5 values in [0..9] follow => bad conversion
- $txtCnt = count_chars(urldecode($src), 1);
- $tCnt = count_chars($rtrans, 1);
-
- $dst = mysql_real_escape_string($dst);
- $subquery = "UPDATE map SET name=\"$rname_sql\" WHERE name=\"$src_sql\" AND
lang=\"$la\" AND translation=\"$dst_sql\" AND ranking=$rank;\n";
- echo "$subquery";
-}
-?>
-# </pre>
-# end of conversion
| [Prev in Thread] |
Current Thread |
[Next in Thread] |
- [GNUnet-SVN] r1655 - in Extractor-docs/WWW: . download gnu.org,
grothoff <=