... new=1 ... display new tag screen
... chg=[wordid] ... display edit screen
... sort=[sortcode] ... sort
... page=[pageno] ... page
... query=[tagtextfilter] ... tag text filter
Manage tags
***************************************************************/
include "connect.inc.php";
include "settings.inc.php";
include "utilities.inc.php";
$currentsort = processDBParam("sort", 'currenttagsort', '1', 1);
$currentpage = processSessParam("page", "currenttagpage", '1', 1);
$currentquery = processSessParam("query", "currenttagquery", '', 0);
$wh_query = convert_string_to_sqlsyntax(str_replace("*", "%", $currentquery));
$wh_query = $currentquery != '' ? ' and (TgText like ' . $wh_query . ' or TgComment like ' . $wh_query . ')' : '';
pagestart('My Term Tags', true);
$message = '';
// MARK ACTIONS
if (isset($_REQUEST['markaction'])) {
$markaction = $_REQUEST['markaction'];
$message = "Multiple Actions: 0";
if (isset($_REQUEST['marked'])) {
if (is_array($_REQUEST['marked'])) {
$l = count($_REQUEST['marked']);
if ($l > 0) {
$list = "(" . $_REQUEST['marked'][0];
for ($i = 1; $i < $l; $i++) {
$list .= "," . $_REQUEST['marked'][$i];
}
$list .= ")";
if ($markaction == 'del') {
}
function notempty($var)
{
return trim($var) != '';
}
function limit20(&$item, $key)
{
$item = mb_substr($item, 0, 20);
}
function savetag($item, $key, $wid)
{
global $tbpref;
runsql('insert into ' . $tbpref . 'tags (TgText) values(' . convert_string_to_sqlsyntax($item) . ')', "");
runsql('insert into ' . $tbpref . 'wordtags (WtWoID, WtTgID) select ' . $wid . ', TgID from ' . $tbpref . 'tags where TgText = ' . convert_string_to_sqlsyntax($item), "");
}
pagestart('Import Terms', true);
$message = '';
// Import
if (isset($_REQUEST['op'])) {
// INSERT
if ($_REQUEST['op'] == 'Import') {
$col[0] = $_REQUEST["Col1"];
$col[1] = $_REQUEST["Col2"];
$col[2] = $_REQUEST["Col3"];
$col[3] = $_REQUEST["Col4"];
$col[4] = $_REQUEST["Col5"];
$overwrite = $_REQUEST["Over"] == '1';
$tabs = $_REQUEST["Tab"];
$sqlct = 0;
$lang = $_REQUEST["LgID"];
$status = $_REQUEST["WoStatus"];
... new=1 ... display new text tag screen
... chg=[wordid] ... display edit screen
... sort=[sortcode] ... sort
... page=[pageno] ... page
... query=[tagtextfilter] ... tag text filter
Manage tags
***************************************************************/
include "connect.inc.php";
include "settings.inc.php";
include "utilities.inc.php";
$currentsort = processDBParam("sort", 'currenttexttagsort', '1', 1);
$currentpage = processSessParam("page", "currenttexttagpage", '1', 1);
$currentquery = processSessParam("query", "currenttexttagquery", '', 0);
$wh_query = convert_string_to_sqlsyntax(str_replace("*", "%", $currentquery));
$wh_query = $currentquery != '' ? ' and (T2Text like ' . $wh_query . ' or T2Comment like ' . $wh_query . ')' : '';
pagestart('My Text Tags', true);
$message = '';
// MARK ACTIONS
if (isset($_REQUEST['markaction'])) {
$markaction = $_REQUEST['markaction'];
$message = "Multiple Actions: 0";
if (isset($_REQUEST['marked'])) {
if (is_array($_REQUEST['marked'])) {
$l = count($_REQUEST['marked']);
if ($l > 0) {
$list = "(" . $_REQUEST['marked'][0];
for ($i = 1; $i < $l; $i++) {
$list .= "," . $_REQUEST['marked'][$i];
}
$list .= ")";
if ($markaction == 'del') {
THE SOFTWARE.
For more information, please refer to [http://unlicense.org/].
***************************************************************/
/**************************************************************
Call: delete_word.php?wid=[wordid]&tid=[textid]
Delete a word
***************************************************************/
require_once 'settings.inc.php';
require_once 'connect.inc.php';
require_once 'dbutils.inc.php';
require_once 'utilities.inc.php';
$tid = $_REQUEST['tid'];
$wid = $_REQUEST['wid'];
$term = get_first_value("select WoText as value from " . $tbpref . "words where WoID = " . $wid);
pagestart("Term: " . $term, false);
$m1 = runsql('delete from ' . $tbpref . 'words where WoID = ' . $wid, '');
adjust_autoincr('words', 'WoID');
echo "<p>OK, term deleted, now unknown (" . $m1 . ").</p>";
?>
<script type="text/javascript">
//<![CDATA[
var context = window.parent.frames['l'].document;
var contexth = window.parent.frames['h'].document;
var title = make_tooltip(<?php
echo prepare_textdata_js($term);
?>
,'','','');
$('.word<?php
echo $wid;
?>
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.
***************************************************************/
/**************************************************************
Call: settings.php?....
... op=Save ... do save
... op=Reset ... do reset to defaults
Preferences / Settings
***************************************************************/
include "connect.inc.php";
include "settings.inc.php";
include "utilities.inc.php";
pagestart('Settings/Preferences', true);
$message = '';
if (isset($_REQUEST['op'])) {
if ($_REQUEST['op'] == 'Save') {
saveSetting('set-text-h-frameheight-no-audio', $_REQUEST['set-text-h-frameheight-no-audio']);
saveSetting('set-text-h-frameheight-with-audio', $_REQUEST['set-text-h-frameheight-with-audio']);
saveSetting('set-text-l-framewidth-percent', $_REQUEST['set-text-l-framewidth-percent']);
saveSetting('set-text-r-frameheight-percent', $_REQUEST['set-text-r-frameheight-percent']);
saveSetting('set-test-h-frameheight', $_REQUEST['set-test-h-frameheight']);
saveSetting('set-test-l-framewidth-percent', $_REQUEST['set-test-l-framewidth-percent']);
saveSetting('set-test-r-frameheight-percent', $_REQUEST['set-test-r-frameheight-percent']);
saveSetting('set-player-skin-name', $_REQUEST['set-player-skin-name']);
saveSetting('set-test-main-frame-waiting-time', $_REQUEST['set-test-main-frame-waiting-time']);
saveSetting('set-test-edit-frame-waiting-time', $_REQUEST['set-test-edit-frame-waiting-time']);
saveSetting('set-test-sentence-count', $_REQUEST['set-test-sentence-count']);
saveSetting('set-term-sentence-count', $_REQUEST['set-term-sentence-count']);
right to use this work for any purpose, without any conditions,
unless such conditions are required by law.
Developed by J. Pierre in 2011.
***************************************************************/
/**************************************************************
Call: insert_word_wellknown.php?tid=[textid]&ord=[textpos]
Ignore single word (new term with status 99)
***************************************************************/
include "connect.inc.php";
include "settings.inc.php";
include "utilities.inc.php";
$word = get_first_value("select TiText as value from textitems where TiWordCount = 1 and TiTxID = " . $_REQUEST['tid'] . " and TiOrder = " . $_REQUEST['ord']);
$wordlc = mb_strtolower($word, 'UTF-8');
$langid = get_first_value("select TxLgID as value from texts where TxID = " . $_REQUEST['tid']);
pagestart("Term: " . $word, false);
$m1 = runsql('insert into words (WoLgID, WoText, WoTextLC, WoStatus, WoStatusChanged,' . make_score_random_insert_update('iv') . ') values( ' . $langid . ', ' . convert_string_to_sqlsyntax($word) . ', ' . convert_string_to_sqlsyntax($wordlc) . ', 99, NOW(), ' . make_score_random_insert_update('id') . ')', 'Term added');
$wid = get_last_key();
echo "<p>OK, you know this term well!</p>";
$hex = strToClassName($wordlc);
?>
<script type="text/javascript">
//<![CDATA[
var context = window.parent.frames['l'].document;
var contexth = window.parent.frames['h'].document;
var title = make_tooltip(<?php
echo prepare_textdata_js($word);
?>
,'*','','99');
$('.TERM<?php
echo $hex;
if (isset($_REQUEST['prefix'])) {
if ($_REQUEST['prefix'] !== '-') {
$tbpref = $_REQUEST['prefix'];
LWTTableSet("current_table_prefix", $tbpref);
header("Location: index.php");
exit;
}
}
$prefix = getprefixes();
if (count($prefix) == 0) {
$tbpref = '';
LWTTableSet("current_table_prefix", $tbpref);
header("Location: index.php");
exit;
}
pagestart('Select Table Set', false);
?>
<table class="tab1" style="width: auto;" cellspacing="0" cellpadding="5">
<tr>
<th class="th1">
<form name="f1" class="inline" action="<?php
echo $_SERVER['PHP_SELF'];
?>
" method="post">
<p>Select: <select name="prefix">
<option value="" <?php
echo $tbpref == '' ? 'selected="selected"' : '';
?>
>Default Table Set</option>
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.
***************************************************************/
/**************************************************************
Call: index.php
LWT Start Screen / Main Menu / Home
***************************************************************/
if (!file_exists('connect.inc.php')) {
die('Fatal Error, cannot find file: "connect.inc.php". Please rename the correct file "connect_[servertype].inc.php" to "connect.inc.php" ([servertype] is the name of your server: xampp, mamp, or easyphp). Please read the documentation: http://lwt.sf.net');
}
include "connect.inc.php";
include "settings.inc.php";
include "utilities.inc.php";
pagestart('Home', false);
$currentlang = getSetting('currentlanguage');
$currenttext = getSetting('currenttext');
$langcnt = get_first_value('select count(*) as value from languages');
if ($langcnt == 0) {
echo '<table class="tab3" cellspacing="0" cellpadding="5"><tr><th class="th1">Hint: The database seems to be empty.<br /><a href="install_demo.php">You may install the LWT demo database, </a><br />or<br /><a href="edit_languages.php?new=1">define the first language you want to learn.</a></th></tr></table>';
}
?>
<script type="text/javascript">
//<![CDATA[
if (! areCookiesEnabled()) document.write('<p class="red">*** Cookies are not enabled! Please enable! ***</p>');
//]]>
</script>
<?php
OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN
CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
THE SOFTWARE.
For more information, please refer to [http://unlicense.org/].
***************************************************************/
/**************************************************************
Call: long_text_import.php?...
op=...
Long Text Import
***************************************************************/
require_once 'settings.inc.php';
require_once 'connect.inc.php';
require_once 'dbutils.inc.php';
require_once 'utilities.inc.php';
pagestart('Long Text Import', true);
$message = '';
$max_input_vars = ini_get('max_input_vars');
if ($max_input_vars === FALSE) {
$max_input_vars = 1000;
}
if ($max_input_vars == '') {
$max_input_vars = 1000;
}
if (isset($_REQUEST['op'])) {
if (substr($_REQUEST['op'], 0, 5) == 'NEXT ') {
$langid = $_REQUEST["LgID"];
$title = stripTheSlashesIfNeeded($_REQUEST["TxTitle"]);
$paragraph_handling = $_REQUEST["paragraph_handling"];
$maxsent = $_REQUEST["maxsent"];
$source_uri = stripTheSlashesIfNeeded($_REQUEST["TxSourceURI"]);
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.
***************************************************************/
/**************************************************************
Call: set_text_mode.php?text=[textid]&mode=0/1
Change the text display mode
***************************************************************/
include "connect.inc.php";
include "settings.inc.php";
include "utilities.inc.php";
$tid = getreq('text') + 0;
$showAll = getreq('mode') + 0;
saveSetting('showallwords', $showAll);
pagestart("Text Display Mode changed", false);
echo '<p><span id="waiting"><img src="icn/waiting.gif" alt="Please wait" title="Please wait" /> Please wait ...</span>';
flush();
?>
<script type="text/javascript">
//<![CDATA[
var method = 1; // 0 (jquery, deactivated, too slow) or 1 (reload)
if (method) window.parent.frames['l'].location.reload();
else {
var context = window.parent.frames['l'].document;
<?php
/**************************************************************
(jquery, deact.)
$sql = 'select TiWordCount as Code, TiText, TiOrder, TiIsNotWord, WoID from (textitems left join words on (TiTextLC = WoTextLC) and (TiLgID = WoLgID)) where TiTxID = ' . $tid . ' order by TiOrder asc, TiWordCount desc';
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.
***************************************************************/
/**************************************************************
Call: check_text.php?...
op=Check ... do the check
Check (parse & split) a Text (into sentences/words)
***************************************************************/
include "connect.inc.php";
include "settings.inc.php";
include "utilities.inc.php";
pagestart('Check a Text', true);
if (isset($_REQUEST['op'])) {
echo '<p><input type="button" value="<< Back" onclick="history.back();" /></p>';
if (strlen(prepare_textdata($_REQUEST['TxText'])) > 65000) {
echo "<p>Error: Text too long, must be below 65000 Bytes.</p>";
} else {
echo checkText($_REQUEST['TxText'], $_REQUEST['TxLgID']);
}
echo '<p><input type="button" value="<< Back" onclick="history.back();" /></p>';
} else {
?>
<form class="validate" action="<?php
echo $_SERVER['PHP_SELF'];
?>
" method="post">
<table class="tab3" cellspacing="0" cellpadding="5">
$dummy = runsql('TRUNCATE ' . $tbpref . 'languages', '');
$dummy = runsql('TRUNCATE ' . $tbpref . 'sentences', '');
$dummy = runsql('TRUNCATE ' . $tbpref . 'tags', '');
$dummy = runsql('TRUNCATE ' . $tbpref . 'tags2', '');
$dummy = runsql('TRUNCATE ' . $tbpref . 'textitems', '');
$dummy = runsql('TRUNCATE ' . $tbpref . 'texts', '');
$dummy = runsql('TRUNCATE ' . $tbpref . 'texttags', '');
$dummy = runsql('TRUNCATE ' . $tbpref . 'words', '');
$dummy = runsql('TRUNCATE ' . $tbpref . 'wordtags', '');
$dummy = runsql('DELETE FROM ' . $tbpref . 'settings where StKey = \'currenttext\'', '');
optimizedb();
get_tags($refresh = 1);
get_texttags($refresh = 1);
$message = "Database content has been deleted (but settings have been kept)";
}
pagestart('Backup/Restore/Empty Database', true);
echo error_message_with_hide($message, 1);
if ($tbpref == '') {
$prefinfo = "(Default Table Set)";
} else {
$prefinfo = "(Table Set: <i>" . tohtml(substr($tbpref, 0, -1)) . "</i>)";
}
?>
<form enctype="multipart/form-data" action="<?php
echo $_SERVER['PHP_SELF'];
?>
" method="post" onsubmit="return confirm('Are you sure?');">
<table class="tab1" cellspacing="0" cellpadding="5">
<tr>
<th class="th1 center">Backup</th>
<td class="td1">
if (isset($_REQUEST['install'])) {
$file = getcwd() . '/install_demo_db.sql.gz';
if (file_exists($file)) {
$handle = gzopen($file, "r");
if ($handle === FALSE) {
$message = "Error: File ' . {$file} . ' could not be opened";
} else {
// $handle OK
$message = restore_file($handle, "Demo Database");
}
// $handle OK
} else {
$message = "Error: File ' . {$file} . ' does not exist";
}
}
pagestart('Install LWT Demo Database', true);
echo error_message_with_hide($message, 1);
$langcnt = get_first_value('select count(*) as value from ' . $tbpref . 'languages');
if ($tbpref == '') {
$prefinfo = "(Default Table Set)";
} else {
$prefinfo = "(Table Set: <i>" . tohtml(substr($tbpref, 0, -1)) . "</i>)";
}
?>
<form enctype="multipart/form-data" action="<?php
echo $_SERVER['PHP_SELF'];
?>
" method="post" onsubmit="return confirm('Are you sure?');">
<table class="tab3" cellspacing="0" cellpadding="5">
<tr>
<th class="th1 center">Install Demo</th>
Developed by J. Pierre in 2011.
***************************************************************/
/**************************************************************
Call: edit_languages.php?....
... refresh=[langid] ... reparse all texts in lang
... del=[langid] ... do delete
... op=Save ... do insert new
... op=Change ... do update
... new=1 ... display new lang. screen
... chg=[langid] ... display edit screen
Manage languages
***************************************************************/
include "connect.inc.php";
include "settings.inc.php";
include "utilities.inc.php";
pagestart('My Languages', true);
$message = '';
// REFRESH
if (isset($_REQUEST['refresh'])) {
$id = $_REQUEST['refresh'] + 0;
$message2 = runsql('delete from sentences where SeLgID = ' . $id, "Sentences deleted");
$message3 = runsql('delete from textitems where TiLgID = ' . $id, "Text items deleted");
adjust_autoincr('sentences', 'SeID');
adjust_autoincr('textitems', 'TiID');
$sql = "select TxID, TxText from texts where TxLgID = " . $id . " order by TxID";
$res = mysql_query($sql);
if ($res == FALSE) {
die("Invalid Query: {$sql}");
}
while ($record = mysql_fetch_assoc($res)) {
$txtid = $record["TxID"];
if ($j < $num_fields - 1) {
$return .= ',';
}
}
// foreach field
$out .= $return . ");\n";
}
// foreach record
}
// foreach table
header('Content-type: application/x-gzip');
header("Content-disposition: attachment; filename=" . $fname);
echo gzencode($out, 9);
exit;
}
pagestart('Backup/Restore LWT Database', true);
echo error_message_with_hide($message, 1);
?>
<form enctype="multipart/form-data" action="<?php
echo $_SERVER['PHP_SELF'];
?>
" method="post">
<table class="tab1" cellspacing="0" cellpadding="5">
<tr>
<th class="th1 center">Backup</th>
<td class="td1">
<p class="smallgray2">
The database <i><?php
echo tohtml($dbname);
?>
</i> will be exported to a gzipped SQL file. Please keep this file in a safe place.<br />If necessary, you can recreate the database via the Restore function below.<br />Important: If the backup file is too large, the restore may not be possible (see limits below).</p>
$wh_tag2 = "group_concat(WtTgID) IS NULL";
} else {
$wh_tag2 = "concat('/',group_concat(WtTgID separator '/'),'/') like '%/" . $currenttag2 . "/%'";
}
}
if ($currenttag1 != '' && $currenttag2 == '') {
$wh_tag = " having (" . $wh_tag1 . ') ';
} elseif ($currenttag2 != '' && $currenttag1 == '') {
$wh_tag = " having (" . $wh_tag2 . ') ';
} else {
$wh_tag = " having ((" . $wh_tag1 . ($currenttag12 ? ') AND (' : ') OR (') . $wh_tag2 . ')) ';
}
}
$no_pagestart = getreq('markaction') == 'exp' || getreq('markaction') == 'exp2' || getreq('markaction') == 'exp3' || getreq('markaction') == 'test' || getreq('markaction') == 'deltag' || getreq('allaction') == 'expall' || getreq('allaction') == 'expall2' || getreq('allaction') == 'expall3' || getreq('allaction') == 'testall' || getreq('allaction') == 'deltagall';
if (!$no_pagestart) {
pagestart('My ' . getLanguage($currentlang) . ' Terms (Words and Expressions)', true);
}
$message = '';
// MARK ACTIONS
if (isset($_REQUEST['markaction'])) {
$markaction = $_REQUEST['markaction'];
$actiondata = stripTheSlashesIfNeeded(getreq('data'));
$message = "Multiple Actions: 0";
if (isset($_REQUEST['marked'])) {
if (is_array($_REQUEST['marked'])) {
$l = count($_REQUEST['marked']);
if ($l > 0) {
$list = "(" . $_REQUEST['marked'][0];
for ($i = 1; $i < $l; $i++) {
$list .= "," . $_REQUEST['marked'][$i];
}
$message = 'Table Set "' . $_REQUEST['newpref'] . '" already exists';
} else {
$tbpref = $_REQUEST['newpref'];
LWTTableSet("current_table_prefix", $tbpref);
header("Location: index.php");
exit;
}
} elseif (isset($_REQUEST['prefix'])) {
if ($_REQUEST['prefix'] !== '-') {
$tbpref = $_REQUEST['prefix'];
LWTTableSet("current_table_prefix", $tbpref);
header("Location: index.php");
exit;
}
}
pagestart('Select, Create or Delete a Table Set', false);
echo error_message_with_hide($message, 0);
if ($fixed_tbpref) {
?>
<table class="tab1" cellspacing="0" cellpadding="5">
<tr>
<td class="td1">
<p>These features are not currently not available.<br /><br />Reason:<br /><b>$tbpref</b> is set to a fixed value in <i>connect.inc.php</i>.<br />Please remove the definition<br /><span class="red"><b>$tbpref = '<?php
echo substr($tbpref, 0, -1);
?>
';</b></span></br />in <i>connect.inc.php</i> to make these features available.<br /> Then try again.</p>
<p class="right"> <br /><input type="button" value="<< Back" onclick="history.back();" /></p>
</td>
</tr>
</table>
OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN
CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
THE SOFTWARE.
For more information, please refer to [http://unlicense.org/].
***************************************************************/
/**************************************************************
Call: all_words_wellknown.php?text=[textid]
Setting all unknown words to Well Known (99)
***************************************************************/
require_once 'settings.inc.php';
require_once 'connect.inc.php';
require_once 'dbutils.inc.php';
require_once 'utilities.inc.php';
$langid = get_first_value("select TxLgID as value from " . $tbpref . "texts where TxID = " . $_REQUEST['text']);
pagestart("Setting all blue words to Well-known", false);
$sql = 'select distinct TiText, TiTextLC from (' . $tbpref . 'textitems left join ' . $tbpref . 'words on (TiTextLC = WoTextLC) and (TiLgID = WoLgID)) where TiIsNotWord = 0 and WoID is null and TiWordCount = 1 and TiTxID = ' . $_REQUEST['text'] . ' order by TiOrder';
$res = do_mysql_query($sql);
$count = 0;
$javascript = "var title='';";
while ($record = mysql_fetch_assoc($res)) {
$term = $record['TiText'];
$termlc = $record['TiTextLC'];
$count1 = 0 + runsql('insert into ' . $tbpref . 'words (WoLgID, WoText, WoTextLC, WoStatus, WoStatusChanged,' . make_score_random_insert_update('iv') . ') values( ' . $langid . ', ' . convert_string_to_sqlsyntax($term) . ', ' . convert_string_to_sqlsyntax($termlc) . ', 99 , NOW(), ' . make_score_random_insert_update('id') . ')', '');
$wid = get_last_key();
if ($count1 > 0) {
$javascript .= "title = make_tooltip(" . prepare_textdata_js($term) . ",'*','','99');";
}
$javascript .= "\$('.TERM" . strToClassName($termlc) . "', context).removeClass('status0').addClass('status99 word" . $wid . "').attr('data_status','99').attr('data_wid','" . $wid . "').attr('title',title);";
$count += $count1;
}
$wh_tag2 = "group_concat(AgT2ID) IS NULL";
} else {
$wh_tag2 = "concat('/',group_concat(AgT2ID separator '/'),'/') like '%/" . $currenttag2 . "/%'";
}
}
if ($currenttag1 != '' && $currenttag2 == '') {
$wh_tag = " having (" . $wh_tag1 . ') ';
} elseif ($currenttag2 != '' && $currenttag1 == '') {
$wh_tag = " having (" . $wh_tag2 . ') ';
} else {
$wh_tag = " having ((" . $wh_tag1 . ($currenttag12 ? ') AND (' : ') OR (') . $wh_tag2 . ')) ';
}
}
$no_pagestart = getreq('markaction') == 'deltag';
if (!$no_pagestart) {
pagestart('My ' . getLanguage($currentlang) . ' Text Archive', true);
}
$message = '';
// MARK ACTIONS
if (isset($_REQUEST['markaction'])) {
$markaction = $_REQUEST['markaction'];
$actiondata = stripTheSlashesIfNeeded(getreq('data'));
$message = "Multiple Actions: 0";
if (isset($_REQUEST['marked'])) {
if (is_array($_REQUEST['marked'])) {
$l = count($_REQUEST['marked']);
if ($l > 0) {
$list = "(" . $_REQUEST['marked'][0];
for ($i = 1; $i < $l; $i++) {
$list .= "," . $_REQUEST['marked'][$i];
}
FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN
CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
THE SOFTWARE.
For more information, please refer to [http://unlicense.org/].
***************************************************************/
/**************************************************************
Call: statistics.php
Display statistics
***************************************************************/
require_once 'settings.inc.php';
require_once 'connect.inc.php';
require_once 'dbutils.inc.php';
require_once 'utilities.inc.php';
pagestart('My Statistics', true);
?>
<h4>Breakdown by Language and Term Status<br />(Click on numbers to see the list of terms)</h4>
<table class="tab3" cellspacing="0" cellpadding="5">
<tr>
<th class="th1">Language</th>
<th class="th1">Total<br /></th>
<th class="th1">Active<br />(1..5)</th>
<th class="th1">Learning<br />(1..4)</th>
<th class="th1">Unknown<br />(1)</th>
<th class="th1">Learning<br />(2)</th>
<th class="th1">Learning<br />(3)</th>
<th class="th1">Learning<br />(4)</th>
<th class="th1">Learned<br />(5)</th>
<th class="th1">Well<br />Known<br />(99)</th>
<th class="th1">Known<br />(5+99)</th>
