$Value) { //echo $Value['TablePrefix'].'='.$Table.'
'; if ($Value['TablePrefix'] == $Table) return $TableID; } } function GetTranslatNames($Text) { global $Database, $mode; if ($mode == 0) echo ('..Přesné'); if ($mode == 1) echo ('..Všechny přeložené'); if ($mode == 2) echo ('..Nepřeložené'); echo('

'); echo(''.''); $TablesColumn = array ( 'gameobject' => 'Name', 'creature' => 'name', 'item' => 'Name', 'transports' => 'Name', 'areatrigger_teleport' => 'Name', 'areatrigger_tavern' => 'Name', ); /* $TablesID = array('gameobject' => 5, 'creature' => 6, 'item' => 4, 'transports' => 'Name', 'areatrigger_teleport' => 'Name', 'areatrigger_tavern' => 'Name',); */ foreach($TablesColumn as $Table => $Column) { $sql = 'SELECT ID,'.$Column.',(SELECT Name FROM '.$Table.' as T WHERE O.entry = T.entry AND Language <> 0 LIMIT 1) as tran FROM '.$Table.' as O WHERE '; $groupby = ' GROUP BY '.$Column; $ArrStr = explode(' ', $Text); $where = 'Language = 0 '; if ($mode == 1) $where .= ' AND EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = O.entry))'; if ($mode == 2) $where .= ' AND NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = O.entry))'; $where .= ' AND ('; for($i = 0; $i < count($ArrStr); $i++) { if (strpos($ArrStr[$i],'\'s') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-4); if (strpos($ArrStr[$i],',') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1); if (strpos($ArrStr[$i],'.') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1); if (strpos($ArrStr[$i],'!') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1); if (strpos($ArrStr[$i],'?') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1); if (strlen($ArrStr[$i]) > 4) $where .= 'O.'.$Column.' LIKE "%'.addslashes($ArrStr[$i]).'%" OR '; } $where = substr($where,0,strlen($where)-4); $where .= ')'; echo (''); $ID = $Database->SQLCommand($sql.$where.$groupby); while($Line = mysql_fetch_assoc($ID)) { if ($mode == 0) { if (strpos(strtolower($Text),strtolower($Line[$Column])) > 0) { echo(''); if ($Line['tran'] <> '') echo(''); else echo(''); } } else { echo(''); if ($Line['tran'] <> '') echo(''); else echo(''); } } } echo('

Originál	Překlad
'.$Line[$Column].'	'.$Line['tran'].'
Překládat
'.$Line[$Column].'	'.$Line['tran'].'
Překládat

'); } if(array_key_exists('Page', $_GET)) $_SESSION['Page'] = $_GET['Page']; else if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 1; if(!isset($_SESSION['language'])) { if(Licence(LICENCE_USER)) { $DbResult = $Database->SQLCommand('SELECT Language FROM user WHERE ID='.$_SESSION['UserID']); $User = mysql_fetch_assoc($DbResult); $_SESSION['language'] = $User['Language']; } else $_SESSION['language'] = 1; } if(array_key_exists('language', $_GET)) $_SESSION['language'] = $_GET['language']; ShowPage(); echo('

Slovníček

'); if(array_key_exists('group', $_GET)) { if(array_key_exists('group', $_GET)) $GroupId = $_GET['group']; else $GroupId = 1; if(array_key_exists('mode', $_GET)) $mode = $_GET['mode']; else $mode = 0; //0 = přesné názvy, 1=všechny názvy, 2=nepřeložené $Table = $TranslationTree[$GroupId]['TablePrefix']; if(array_key_exists('ID', $_GET)) { $TextID = $_GET['ID']; echo ('Přeložené názvy vztahující se k překladu: '.$TextID.'
'. 'Všechny '. 'Přesné '. 'Nepřeložené '); $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT * FROM '.$Table.' Where ID = '.$TextID)); if(!$Line) die('Překlad nenalezen.'); $Text = ''; foreach($TranslationTree[$GroupId]['Items'] as $Index => $TextItem) $Text .= ' '.$Line[$TextItem['Column']]; GetTranslatNames($Text); } } else { if(array_key_exists('action', $_GET)) { if(($_GET['action'] == 'insert') and Licence(LICENCE_USER)) { echo(''); } else if(($_GET['action'] == 'save') and Licence(LICENCE_USER)) { $DbResult = $Database->SQLCommand('SELECT * FROM `dictionary` WHERE `Text` = "'.$_POST['Original'].'" AND Language=0'); if(mysql_num_rows($DbResult) > 0) { $DbRow = mysql_fetch_assoc($DbResult); $Entry = $DbRow['Entry']; } else { $DbResult = $Database->SQLCommand('SELECT MAX(Entry) FROM dictionary'); $DbRow = mysql_fetch_row($DbResult); $Entry = $DbRow[0] + 1; $Database->SQLCommand('INSERT INTO `dictionary` ( `Text` , `Entry` , `Description` , `User`, `Language` ) VALUES ("'.$_POST['Original'].'", "'.$Entry.'", "", 0, 0);'); } $DbResult = $Database->SQLCommand('SELECT Id FROM `dictionary` WHERE `Entry` = '.$Entry.' AND Language='.$_SESSION['language'].' AND User='.$_SESSION['UserID']); if(mysql_num_rows($DbResult) > 0) { $DbRow = mysql_fetch_assoc($DbResult); $Database->SQLCommand('UPDATE `dictionary` SET `Text`="'.$_POST['Translated'].'", `Description` = "'.$_POST['Description'].'" WHERE Id='.$DbRow['Id']); } else $Database->SQLCommand('INSERT INTO `dictionary` ( `Text` , `Entry` , `Description` , `User`, `Language` ) VALUES ("'.$_POST['Translated'].'", "'.$Entry.'", "'.$_POST['Description'].'", '.$_SESSION['UserID'].', '.$_SESSION['language'].')'); echo('Záznam byl uložen!'); } else if(($_GET['action'] == 'remove') and Licence(LICENCE_USER)) { $Database->SQLCommand('DELETE FROM dictionary WHERE User='.$_SESSION['UserID'].' AND Language='.$_SESSION['language'].' AND Entry='.$_GET['entry']); } else if(($_GET['action'] == 'modify') and Licence(LICENCE_USER)) { $DbResult = $Database->SQLCommand('SELECT * FROM dictionary WHERE User='.$_SESSION['UserID'].' AND Entry='.$_GET['entry'].' AND Language='.$_SESSION['language']); $DbRow = mysql_fetch_assoc($DbResult); $DbResult = $Database->SQLCommand('SELECT * FROM dictionary WHERE User=0 AND Entry='.$_GET['entry'].' AND Language=0'); $DbRow2 = mysql_fetch_assoc($DbResult); echo(''); } } echo('

'. ''); if(array_key_exists('search', $_GET)) $Search = $_GET['search']; else $Search = ''; echo(''); echo(''); echo(''); echo('

'); if(Licence(LICENCE_USER)) echo(' Vložit slovo'); echo('

Jazyk: '); foreach($LanguageList as $Language) if($Language['Enabled'] == 1) { if($Language['Id'] == $_SESSION['language']) echo(''); echo(' '.$Language['Name'].''); if($Language['Id'] == $_SESSION['language']) echo(''); } echo('

'); //

'); if($Search <> '') { $sql = 'SELECT `user`.`user` AS `UserName`, `user`. `ID` AS `UserID`, `T3`.`Entry`, `T3`.`Original`, `T3`.`Translated`, `T3`.`Description` FROM (SELECT T2.User, `T1`.Language, `T1`.`Text` AS Original, `T2`.`Text` AS `Translated`, `T2`.`Description`, `T1`.`Entry` AS `Entry` FROM `dictionary` AS `T1` JOIN `dictionary` AS `T2` ON `T2`.`Entry` = `T1`.`Entry` AND `T2`.`Language` = '.$_SESSION['language'].' WHERE LOWER(T1.Text) LIKE LOWER("%'.$Search.'%") OR LOWER(T1.Description) LIKE LOWER("%'.$Search.'%") ) AS T3 JOIN `user` ON `user`.`ID` = `T3`.`User` WHERE `T3`.`Language` = 0'; } else $sql = 'SELECT `user`.`user` AS `UserName`, `ID` AS `UserID`, `T3`.`Entry`, `T3`.`Original`, `T3`.`Translated`, `T3`.`Description` FROM (SELECT T2.User, `T1`.Language, `T1`.`Text` AS Original, `T2`.`Text` AS `Translated`, `T2`.`Description`, `T1`.`Entry` AS `Entry` FROM `dictionary` AS `T1` JOIN `dictionary` AS `T2` ON `T2`.`Entry` = `T1`.`Entry` AND `T2`.`Language` = '.$_SESSION['language'].') AS T3 JOIN `user` ON `user`.`ID` = `T3`.`User` WHERE `T3`.`Language` = 0'; $sql_page = $sql.' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage']; ListPaging('?Page=', '('.$sql.') AS T1', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']); echo(''); if(Licence(LICENCE_USER)) echo(''); echo(''); $ID = $Database->SQLCommand($sql_page); while ($Line = mysql_fetch_assoc($ID)) { echo(''); if(Licence(LICENCE_USER)) { if($Line['UserID'] == $_SESSION['UserID']) echo(''); else echo(''); } echo(''); } echo('

'.$LanguageList[0]['Name'].'	'.$LanguageList[$_SESSION['language']]['Name'].'	Popis	Překladatel	Akce
'.$Line['Original'].'	'.$Line['Translated'].'	'.$Line['Description'].'	'.$Line['UserName'].'	Smazat Upravit

'); ListPaging('?Page=', '('.$sql.') AS T1', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']); echo('

'); } ShowFooter(); ?>