117 lines
2.9 KiB
PHP
117 lines
2.9 KiB
PHP
<?php
|
|
include "db.php";
|
|
include "table.php";
|
|
|
|
$db_host = "web2-db";
|
|
$db_uname = "mark";
|
|
$db_pass = "hugger1";
|
|
$db_dbname = "schoolappointments";
|
|
|
|
echo("Connecting to: $db_host\n");
|
|
db_close($_DB);
|
|
|
|
$_DB = mysql_connect($db_host, $db_uname, $db_pass)
|
|
or die("Cannot connect to database host: " . mysql_error());
|
|
mysql_select_db($db_dbname)
|
|
or die("The \"$db_dbname\" database does not exist: " . mysql_error());
|
|
|
|
|
|
db_query("SET NAMES utf8");
|
|
db_query("SET CHARACTER SET utf8");
|
|
|
|
|
|
|
|
$file = readline("File: ");
|
|
if (strlen($file) == 0) $file = "school.form.php";
|
|
|
|
$fp = fopen("new-file.php","w");
|
|
|
|
if (strlen($file) && is_file($file)) {
|
|
$lines = file($file);
|
|
echo(count($lines)."\n");
|
|
|
|
$inPHP = false;
|
|
$inScript = false;
|
|
|
|
for ($i = 0; $i < count($lines); $i++) {
|
|
$oline = $lines[$i];
|
|
$line = trim($oline);
|
|
|
|
if ($line == "<?php") $inPHP = true;
|
|
if ($line == "?>") {
|
|
$inPHP = false;
|
|
fwrite($fp,$oline);
|
|
continue;
|
|
}
|
|
|
|
if ($inPHP) {
|
|
fwrite($fp,$oline);
|
|
continue;
|
|
}
|
|
|
|
if (strpos($line,"<script") !== FALSE) $inScript = true;
|
|
if (strpos($line,"</script") !== FALSE) {
|
|
$inScript = false;
|
|
fwrite($fp,$oline);
|
|
continue;
|
|
}
|
|
|
|
if ($inScript) {
|
|
fwrite($fp,$oline);
|
|
continue;
|
|
}
|
|
|
|
if ($line == "-->") {
|
|
fwrite($fp,$oline);
|
|
continue;
|
|
}
|
|
|
|
$line = str_replace(":","",$line);
|
|
$line = str_replace(" "," ",$line);
|
|
|
|
$line = trim(strip_tags($line));
|
|
if (strlen($line) == 0) {
|
|
fwrite($fp,$oline);
|
|
continue;
|
|
}
|
|
|
|
$phrase = db_escape_string($line);
|
|
|
|
$query = "SELECT * FROM language_text WHERE english = '$phrase'";
|
|
$results = db_query($query);
|
|
if (db_num_rows($results)) {
|
|
$r = db_fetch_assoc($results);
|
|
$message_id = $r['message_id'];
|
|
|
|
$nline = str_replace($line,"<?php displayLanguageText('$message_id'); ?>",$oline);
|
|
fwrite($fp,$nline);
|
|
}
|
|
else {
|
|
$phrase = trim($line);
|
|
$phrase = str_replace(' '," ",$phrase);
|
|
$phrase = str_replace(' '," ",$phrase);
|
|
$phrase = str_replace('"',"",$phrase);
|
|
$phrase = str_replace("'","",$phrase);
|
|
$phrase = str_replace('--',"-",$phrase);
|
|
$phrase = str_replace('--',"-",$phrase);
|
|
|
|
if (strlen($phrase) > 100) {
|
|
echo("$phrase\n");
|
|
$phrase = substr($phrase,0,100);
|
|
$b = strrpos($phrase,' ');
|
|
$phrase = trim(substr($phrase,0,$b));
|
|
echo("$phrase\n");
|
|
}
|
|
|
|
$message_id = "TEXT-" . strtoupper(str_replace(' ','-',$phrase));
|
|
$query = "INSERT INTO language_text (message_id,english) VALUES('$message_id','".db_escape_string($line)."')";
|
|
db_query($query);
|
|
|
|
$nline = str_replace($line,"<?php displayLanguageText('$message_id'); ?>",$oline);
|
|
fwrite($fp,$nline);
|
|
}
|
|
}
|
|
}
|
|
|
|
?>
|