forked from fidesio-xavier-masson/AChecker
-
Notifications
You must be signed in to change notification settings - Fork 1
/
dump_lang.php
38 lines (29 loc) · 1.24 KB
/
dump_lang.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
<?php
//define(AC_INCLUDE_PATH, 'include/');
//include(AC_INCLUDE_PATH.'vitals.inc.php');
$lang_db = mysql_connect('localhost:3306', 'root', '');
mysql_select_db('achecker', $lang_db);
$sql = "SELECT * FROM AC_language_text WHERE language_code='eng' ORDER BY `variable`, `term`";
$result = mysql_query($sql, $lang_db) or die(mysql_error());
$text = "# Table structure for table 'language_text'
CREATE TABLE `language_text` (
`language_code` varchar(20) NOT NULL default '',
`variable` varchar(30) NOT NULL default '',
`term` varchar(50) NOT NULL default '',
`text` blob NOT NULL,
`revised_date` datetime NOT NULL default '0000-00-00 00:00:00',
`context` text,
PRIMARY KEY (`language_code`,`variable`,`term`),
UNIQUE KEY `idx_unique_lang_term` (`language_code`,`term`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- Dumping data for table `language_text`
";
while($row = mysql_fetch_assoc($result)) {
$row['text'] = mysql_real_escape_string($row['text']);
$row['context'] = mysql_real_escape_string($row['context']);
$text .= "INSERT INTO `language_text` VALUES ('eng', '$row[variable]','$row[term]','$row[text]','$row[revised_date]','$row[context]');\n";
}
$fh = fopen('install/db/language_text.sql', 'w');
fwrite($fh, $text);
fclose($fh);
?>