<tr>
<td class="td1 right" colspan="2">
<input type="button" value="Cancel" onclick="location.href='edit_texttags.php#rec<?php
echo $_REQUEST['chg'];
?>
';" />
<input type="submit" name="op" value="Change" /></td>
</tr>
</table>
</form>
<?php
}
mysql_free_result($res);
} else {
echo error_message_with_hide($message, 0);
get_texttags(1);
// refresh tags cache
$sql = 'select count(T2ID) as value from tags2 where (1=1) ' . $wh_query;
$recno = get_first_value($sql);
if ($debug) {
echo $sql . ' ===> ' . $recno;
}
$maxperpage = getSettingWithDefault('set-tags-per-page');
$pages = $recno == 0 ? 0 : intval(($recno - 1) / $maxperpage) + 1;
if ($currentpage < 1) {
$currentpage = 1;
}
if ($currentpage > $pages) {
$currentpage = $pages;
}
$limit = 'LIMIT ' . ($currentpage - 1) * $maxperpage . ',' . $maxperpage;
function restore_file($handle, $title)
{
global $tbpref;
$message = "";
$lines = 0;
$ok = 0;
$errors = 0;
$drops = 0;
$inserts = 0;
$creates = 0;
$start = 1;
while (!gzeof($handle)) {
$sql_line = trim(str_replace("\r", "", str_replace("\n", "", gzgets($handle, 99999))));
if ($sql_line != "") {
if ($start) {
if (strpos($sql_line, "-- lwt-backup-") === false) {
$message = "Error: Invalid " . $title . " Restore file (possibly not created by LWT backup)";
$errors = 1;
break;
}
$start = 0;
continue;
}
if (substr($sql_line, 0, 3) !== '-- ') {
$res = mysql_query(insert_prefix_in_sql($sql_line));
$lines++;
if ($res == FALSE) {
$errors++;
} else {
$ok++;
if (substr($sql_line, 0, 11) == "INSERT INTO") {
$inserts++;
} elseif (substr($sql_line, 0, 10) == "DROP TABLE") {
$drops++;
} elseif (substr($sql_line, 0, 12) == "CREATE TABLE") {
$creates++;
}
}
// echo $ok . " / " . tohtml(insert_prefix_in_sql($sql_line)) . "<br />";
}
}
}
// while (! feof($handle))
gzclose($handle);
if ($errors == 0) {
reparse_all_texts();
optimizedb();
get_tags($refresh = 1);
get_texttags($refresh = 1);
$message = "Success: " . $title . " restored - " . $lines . " queries - " . $ok . " successful (" . $drops . "/" . $creates . " tables dropped/created, " . $inserts . " records added), " . $errors . " failed.";
} else {
if ($message == "") {
$message = "Error: " . $title . " NOT restored - " . $lines . " queries - " . $ok . " successful (" . $drops . "/" . $creates . " tables dropped/created, " . $inserts . " records added), " . $errors . " failed.";
}
}
return $message;
}
'};" />
<input type="submit" name="op" value="Change" /></td>
</tr>
</table>
</form>
<?php
}
mysql_free_result($res);
} else {
if (substr($message, 0, 24) == "Error: Duplicate entry '" && substr($message, -18) == "' for key 'T2Text'") {
$message = substr($message, 24);
$message = substr($message, 0, strlen($message) - 18);
$message = "Error: Text Tag '" . $message . "' already exists. Please go back and correct this!";
}
echo error_message_with_hide($message, 0);
get_texttags($refresh = 1);
// refresh tags cache
$sql = 'select count(T2ID) as value from ' . $tbpref . 'tags2 where (1=1) ' . $wh_query;
$recno = get_first_value($sql);
if ($debug) {
echo $sql . ' ===> ' . $recno;
}
$maxperpage = getSettingWithDefault('set-tags-per-page');
$pages = $recno == 0 ? 0 : intval(($recno - 1) / $maxperpage) + 1;
if ($currentpage < 1) {
$currentpage = 1;
}
if ($currentpage > $pages) {
$currentpage = $pages;
}
$limit = 'LIMIT ' . ($currentpage - 1) * $maxperpage . ',' . $maxperpage;
function pagestart_nobody($titeltext, $addcss = '')
{
global $debug;
@header('Expires: Wed, 11 Jan 1984 05:00:00 GMT');
@header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT');
@header('Cache-Control: no-cache, must-revalidate, max-age=0');
@header('Pragma: no-cache');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<!-- ***********************************************************
"Learning with Texts" (LWT) is released into the Public Domain.
This applies worldwide.
In case this is not legally possible, any entity is granted the
right to use this work for any purpose, without any conditions,
unless such conditions are required by law.
Developed by J.P. in 2011, 2012.
************************************************************ -->
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=900" />
<link rel="apple-touch-icon" href="img/apple-touch-icon-57x57.png" />
<link rel="apple-touch-icon" sizes="72x72" href="img/apple-touch-icon-72x72.png" />
<link rel="apple-touch-icon" sizes="114x114" href="img/apple-touch-icon-114x114.png" />
<link rel="apple-touch-startup-image" href="img/apple-touch-startup.png">
<meta name="apple-mobile-web-app-capable" content="yes" />
<link rel="stylesheet" type="text/css" href="css/jquery-ui.css">
<link rel="stylesheet" type="text/css" href="css/jquery.tagit.css">
<link rel="stylesheet" type="text/css" href="css/tagit.ui-zendesk.css">
<link rel="stylesheet" type="text/css" href="css/styles.css">
<style type="text/css">
<?php
echo $addcss . "\n";
?>
</style>
<script type="text/javascript" src="js/jquery.js" charset="utf-8"></script>
<script type="text/javascript" src="js/jquery.scrollTo.min.js" charset="utf-8"></script>
<script type="text/javascript" src="js/jquery-ui.min.js" charset="utf-8"></script>
<script type="text/javascript" src="js/tag-it.js" charset="utf-8"></script>
<script type="text/javascript" src="js/sorttable/sorttable.js" charset="utf-8"></script>
<script type="text/javascript" src="js/countuptimer.js" charset="utf-8"></script>
<script type="text/javascript" src="js/overlib/overlib_mini.js" charset="utf-8"></script>
<script type="text/javascript">
//<![CDATA[
<?php
echo "var STATUSES = " . json_encode(get_statuses()) . ";\n";
?>
<?php
echo "var TAGS = " . json_encode(get_tags()) . ";\n";
?>
<?php
echo "var TEXTTAGS = " . json_encode(get_texttags()) . ";\n";
?>
//]]>
</script>
<script type="text/javascript" src="js/pgm.js" charset="utf-8"></script>
<script type="text/javascript" src="js/jq_pgm.js" charset="utf-8"></script>
<title>Learning with Texts :: <?php
echo $titeltext;
?>
</title>
</head>
<body>
<div id="overDiv" style="position:absolute; visibility:hidden; z-index:1000;"></div>
<?php
if ($debug) {
showRequest();
}
}
