1 | <?php
|
---|
2 |
|
---|
3 | include('includes/global.php');
|
---|
4 |
|
---|
5 | ShowPage();
|
---|
6 |
|
---|
7 | $TranslationItemPerPage = 200;
|
---|
8 | $GroupId = LoadGroupIdParameter();
|
---|
9 | if(array_key_exists('connexion_id', $_GET)) {
|
---|
10 | $_SESSION['connexion_id'] = $_GET['connexion_id'];
|
---|
11 | }
|
---|
12 | $Table = $TranslationTree[$GroupId]['TablePrefix'];
|
---|
13 | if(array_key_exists('action', $_GET)) $Action = $_GET['action']; else $Action = '';
|
---|
14 |
|
---|
15 | $ID = mysql_fetch_row($Database->SQLCommand('SELECT max(VersionEnd) FROM '.$TranslationTree[$GroupId]['TablePrefix']));
|
---|
16 | $BuildNumber_max = $ID[0];
|
---|
17 |
|
---|
18 | if(array_key_exists('order', $_GET))
|
---|
19 | {
|
---|
20 | $order = $_GET['order'];
|
---|
21 | $desc = $_GET['desc'];
|
---|
22 | $_SESSION['order'] = $_GET['order'];
|
---|
23 | $_SESSION['desc'] = $_GET['desc'];
|
---|
24 | } else
|
---|
25 | {
|
---|
26 | if (isset($_SESSION['order']))
|
---|
27 | {
|
---|
28 | $order = $_SESSION['order'];
|
---|
29 | $desc = $_SESSION['desc'];
|
---|
30 | } else
|
---|
31 | {
|
---|
32 | $order = '';
|
---|
33 | $desc = 'desc';
|
---|
34 | }
|
---|
35 | }
|
---|
36 |
|
---|
37 | if(array_key_exists('limitx', $_GET))
|
---|
38 | {
|
---|
39 | $_SESSION['limitx'] = $_GET['limitx'];
|
---|
40 | $_SESSION['limity'] = $_GET['limity'];
|
---|
41 | } else
|
---|
42 | {
|
---|
43 | if(isset($_SESSION['limitx']) == false)
|
---|
44 | {
|
---|
45 | $_SESSION['limitx'] = '0';
|
---|
46 | $_SESSION['limity'] = $TranslationItemPerPage;
|
---|
47 | }
|
---|
48 | }
|
---|
49 |
|
---|
50 | if(($Action != 'userall') and ($Action != 'grouplist'))
|
---|
51 | echo('Skupina: <strong>'.$TranslationTree[$GroupId]['Name'].'</strong><br />');
|
---|
52 |
|
---|
53 | function WritePages($Address, $Where)
|
---|
54 | {
|
---|
55 | global $Database, $TranslationItemPerPage, $Table;
|
---|
56 |
|
---|
57 | $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM '.$Table.' '.$Where));
|
---|
58 | $CountLists = $Line[0] / $TranslationItemPerPage;
|
---|
59 |
|
---|
60 | echo('Počet položek: <strong>'.$Line[0].'</strong><br />
|
---|
61 | Zobrazit stránku: ');
|
---|
62 |
|
---|
63 | $limitx = 0;
|
---|
64 | for($i = 0; $i < $CountLists; ++$i)
|
---|
65 | {
|
---|
66 | $limity = $TranslationItemPerPage;
|
---|
67 | $limitx = $i * $limity;
|
---|
68 | $Page = $i + 1;
|
---|
69 | if($_SESSION['limitx'] == $limitx) echo('<strong>'.$Page.'</strong> ');
|
---|
70 | else echo('<a href="'.$Address.'&limitx='.$limitx.'&limity='.$limity.'">'.$Page.'</a> ');
|
---|
71 | }
|
---|
72 |
|
---|
73 | if(!array_key_exists('limitx', $_SESSION)) $_SESSION['limitx'] = 0;
|
---|
74 | if($_SESSION['limitx'] > $limitx) $_SESSION['limitx'] = 0;
|
---|
75 | }
|
---|
76 |
|
---|
77 | function WriteQuests($sql, $limit, $address)
|
---|
78 | {
|
---|
79 | global $Database, $order, $desc, $TranslationTree, $GroupId, $Table;
|
---|
80 |
|
---|
81 | // Check if order column exists
|
---|
82 | $Items = $TranslationTree[$GroupId]['Items'];
|
---|
83 | $I = 0;
|
---|
84 | while(($I < count($Items)) and ($Items[$I]['MangosColumn'] != $order)) $I++;
|
---|
85 | if($I >= count($Items)) $order = 'ID';
|
---|
86 |
|
---|
87 | if($limit <> '') $limit = 'LIMIT '.$limit;
|
---|
88 |
|
---|
89 | if($address <> 'selection')
|
---|
90 | {
|
---|
91 | if($order <> '') $order = 'ORDER BY '.$order;
|
---|
92 | if($desc <> 'desc') $desc = 'desc'; else $desc = '';
|
---|
93 | } else
|
---|
94 | {
|
---|
95 | $order = '';
|
---|
96 | $desc = '';
|
---|
97 | }
|
---|
98 |
|
---|
99 | $TableColumns = array(
|
---|
100 | array('Name' => 'ID', 'Title' => 'Pořadové číslo'),
|
---|
101 | array('Name' => 'entry', 'Title' => 'Identifikační číslo'),
|
---|
102 | array('Name' => $TranslationTree[$GroupId]['Items'][0]['Column'], 'Title' => 'Název'),
|
---|
103 | array('Name' => 'VersionStart', 'Title' => 'Verze'),
|
---|
104 | );
|
---|
105 | if($address == 'selection') $TableColumns[] = array('Name' => 'CountQuests', 'Title' => 'Výskyt');
|
---|
106 | else if($address == 'connexion') $TableColumns[] = array('Name' => '', 'Title' => 'Již přeložil');
|
---|
107 | else if($address <> 'notran') $TableColumns[] = array('Name' => 'User', 'Title' => 'Překladatel');
|
---|
108 |
|
---|
109 | $Order = GetOrderTableHeader($TableColumns, 'ID');
|
---|
110 | echo('<table class="BaseTable">');
|
---|
111 | echo($Order['Output']);
|
---|
112 |
|
---|
113 | //print_r($TranslationTree[$GroupId]['Items']);
|
---|
114 | $ID = $Database->SQLCommand($sql.' '.$Order['SQL'].' '.$limit);
|
---|
115 | while($Line = mysql_fetch_assoc($ID))
|
---|
116 | {
|
---|
117 | //print_r($Line);
|
---|
118 | echo('<tr><td><a href="form.php?group='.$GroupId.'&ID='.$Line['ID'].'">'.$Line['ID'].'</a></td>
|
---|
119 | <td>'.$Line['entry'].'</td>
|
---|
120 | <td>'.htmlspecialchars($Line[$TranslationTree[$GroupId]['Items'][0]['Column']]).'</td>
|
---|
121 | <td>'.GetVersionWOW($Line['VersionStart']).'-'.GetVersionWOW($Line['VersionEnd']).'</td>');
|
---|
122 | if($address == 'selection') echo('<td>'.$Line['CountQuest'].'</td>');
|
---|
123 | else if($address <> 'notran') echo('<td>'.$Line['User'].'</td>');
|
---|
124 | echo('</tr>');
|
---|
125 | }
|
---|
126 | echo('</table>');
|
---|
127 | }
|
---|
128 |
|
---|
129 | if($Action == 'notran')
|
---|
130 | {
|
---|
131 | echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&action=filter">Filtr textů</a> ->
|
---|
132 | <a title="Zde můžete začít překládat" href="?group='.$GroupId.'&action=selection">Nepřeložené texty</a> - >
|
---|
133 | <strong>Vypsání nepřeložených textů s limitem na stránku</strong><br /><br />');
|
---|
134 |
|
---|
135 | WritePages('?group='.$GroupId.'&action=notran', 'AS items WHERE items.Language = 0 AND
|
---|
136 | NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = items.entry AND VersionEnd = "'.$BuildNumber_max.'" AND VersionEnd = "'.$BuildNumber_max.'")');
|
---|
137 |
|
---|
138 | WriteQuests('SELECT * FROM '.$Table.' AS items WHERE (items.Language = 0) AND
|
---|
139 | NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry) AND VersionEnd = "'.$BuildNumber_max.'" AND VersionEnd = "'.$BuildNumber_max.'")', $_SESSION['limitx'].','.$_SESSION['limity'], 'notran');
|
---|
140 | } else
|
---|
141 | if($Action == 'connexion')
|
---|
142 | { //SELECT * FROM spell WHERE entry IN(SELECT entry FROM connexion_item WHERE connexion = 1)
|
---|
143 | $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT Name FROM connexion WHERE `Id` = '.$_SESSION['connexion_id']));
|
---|
144 | echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&action=filter">Filtr textů</a> ->
|
---|
145 | <a title="Zde je seznam souvislostí" href="?group='.$GroupId.'&action=connexion">Souvislosti</a> - >
|
---|
146 | <strong>Vypsání souvislostí ze skupiny '.$Line['Name'].'</strong><br /><br />');
|
---|
147 |
|
---|
148 | WritePages('?group='.$GroupId.'&action=connexion', ' WHERE Language = 0 AND entry IN(SELECT entry FROM connexion_item WHERE connexion = '.$_SESSION['connexion_id'].') AND VersionEnd = "'.$BuildNumber_max.'" AND VersionEnd = "'.$BuildNumber_max.'"');
|
---|
149 | WriteQuests('SELECT *, (SELECT sub.User FROM '.$Table.' as sub WHERE sub.entry = '.$Table.'.entry AND Language <> 0 LIMIT 1) as UserID, (SELECT user.user FROM user WHERE user.id = UserID) as User FROM '.$Table.' WHERE Language = 0 AND entry IN(SELECT entry FROM connexion_item WHERE connexion = '.$_SESSION['connexion_id'].') AND VersionEnd = "'.$BuildNumber_max.'" AND VersionEnd = "'.$BuildNumber_max.'"', $_SESSION['limitx'].','.$_SESSION['limity'], 'connexion');
|
---|
150 |
|
---|
151 | } else
|
---|
152 | if($Action == 'connexion_list')
|
---|
153 | { //SELECT * FROM spell WHERE entry IN(SELECT entry FROM connexion_item WHERE connexion = 1)
|
---|
154 | echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&action=filter">Filtr textů</a> ->
|
---|
155 | <a title="Zde je seznam souvislostí" href="?group='.$GroupId.'&action=connexion">Souvislosti</a> - >
|
---|
156 | <strong>Vypsání souvislostí</strong><br /><br />');
|
---|
157 | echo('<table class="BaseTable"><tr><th>Pořadové číslo</th><th>Název</th>');
|
---|
158 | echo('</tr>');
|
---|
159 | $ID = $Database->SQLCommand('SELECT * FROM connexion WHERE `Group` = '.$GroupId);
|
---|
160 | while($Line = mysql_fetch_assoc($ID))
|
---|
161 | {
|
---|
162 | echo('<tr><td><a href="?group='.$GroupId.'&action=connexion&connexion_id='.$Line['Id'].'">'.$Line['Id'].'</a></td>
|
---|
163 | <td>'.$Line['Name'].'</td>');
|
---|
164 | }
|
---|
165 | echo ('</table>');
|
---|
166 | } else
|
---|
167 | if($Action == 'nocomplete')
|
---|
168 | {
|
---|
169 | echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&action=filter">Filtr textů</a> ->
|
---|
170 | <a title="Zde můžete začít překládat" href="?group='.$GroupId.'&action=selection">nedokončené texty</a> - >
|
---|
171 | <strong>Vypsání nedokončených textů s limitem na stránku</strong><br /><br />');
|
---|
172 |
|
---|
173 | WritePages('?group='.$GroupId.'&action=notran', 'AS items WHERE items.Language = 0 AND
|
---|
174 | NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry) AND (sub.Complete = 1) AND VersionEnd = "'.$BuildNumber_max.'") AND
|
---|
175 | EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = items.entry AND (sub.Complete = 0) AND VersionEnd = "'.$BuildNumber_max.'") AND VersionEnd = "'.$BuildNumber_max.'"');
|
---|
176 |
|
---|
177 | WriteQuests('SELECT * FROM '.$Table.' AS items WHERE (items.Language = 0) AND
|
---|
178 | NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry) AND (sub.Complete = 1) AND VersionEnd = "'.$BuildNumber_max.'") AND
|
---|
179 | EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry) AND (sub.Complete = 0) AND VersionEnd = "'.$BuildNumber_max.'") AND VersionEnd = "'.$BuildNumber_max.'"', $_SESSION['limitx'].','.$_SESSION['limity'], 'nocomplete');
|
---|
180 | } else
|
---|
181 | if($Action == 'Translate')
|
---|
182 | {
|
---|
183 | echo('<a title="Zobrazit překlady podle vlasního filtru" href="?group='.$GroupId.'&action=filter">Filtr překladů</a> ->
|
---|
184 | <a title="Přeložené texty, můžete zde hlasovat, nebo opravovat texty" href="?group='.$GroupId.'&action=Translate">Přeložené texty</a><br /><br />');
|
---|
185 |
|
---|
186 | WritePages('?group='.$GroupId.'&action=Translate', 'WHERE '.$Table.'.Language <> 0 AND '.$Table.'.Complete = 1');
|
---|
187 |
|
---|
188 | WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM
|
---|
189 | '.$Table.' WHERE '.$Table.'.Language <> 0 AND '.$Table.'.Complete = 1', $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate');
|
---|
190 | } else
|
---|
191 | if(($Action == 'my') and Licence(LICENCE_USER))
|
---|
192 | {
|
---|
193 | echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&action=filter">Filtr textů</a> ->
|
---|
194 | <a title="Přeložené questy přilášeného uživatele" href="?group='.$GroupId.'&action=my">Moje překlady</a><br /><br />');
|
---|
195 | WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = '.$Table.'.`user`) AS `User` FROM `'.$Table.'` Where `user` = '.$_SESSION['UserID'], '', 'my');
|
---|
196 | } else
|
---|
197 | if(($Action == 'mydevelop') and Licence(LICENCE_USER))
|
---|
198 | {
|
---|
199 | echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&action=filter">Filtr textů</a> ->
|
---|
200 | <a title="Nedokončené texty" href="?group='.$GroupId.'&action=mydevelop">Rozepsané překlady</a><br /><br />');
|
---|
201 | WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` Where `user` = '.$_SESSION['UserID'].' AND `Complete` = 0', '', 'mydevelop');
|
---|
202 | } else
|
---|
203 | if($Action == 'users')
|
---|
204 | {
|
---|
205 | echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&action=filter">Filtr textů</a> ->
|
---|
206 | <strong>Vypsání textů od určitých uživatelů</strong><br /><br />');
|
---|
207 | if(array_key_exists('users', $_POST)) $users = $_POST['users'];
|
---|
208 | else $users = array();
|
---|
209 |
|
---|
210 | $WhereUsers = '';
|
---|
211 | foreach($users as $Index => $User)
|
---|
212 | {
|
---|
213 | if($WhereUsers <> '') $WhereUsers .= ' OR `User` = '.$User;
|
---|
214 | else $WhereUsers .= ' `User` = '.$User;
|
---|
215 | }
|
---|
216 | if($WhereUsers == '') $WhereUsers = '0';
|
---|
217 |
|
---|
218 | WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` WHERE '.$WhereUsers, '', 'users');
|
---|
219 | } else
|
---|
220 | if($Action == 'userall')
|
---|
221 | {
|
---|
222 | $ID = $Database->SQLCommand('SELECT `user` FROM `user` WHERE `id` = '.$_GET['user']);
|
---|
223 | $Line = mysql_fetch_row($ID);
|
---|
224 | echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&action=filter">Filtr textů</a>'.
|
---|
225 | ' -> <strong>Počty překladů uživatele '.$Line[0].': </strong><br /><br />');
|
---|
226 |
|
---|
227 | echo('<table class="BaseTable"><tr><th>Skupina</th><th>Překladů</th></tr>');
|
---|
228 | $Total = 0;
|
---|
229 | foreach($TranslationTree as $Group)
|
---|
230 | if($Group['TablePrefix'] != '')
|
---|
231 | {
|
---|
232 | if(array_key_exists('not', $_GET)) {
|
---|
233 | $sql = 'SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE `Complete` = 0 AND `user`='.$_GET['user'];
|
---|
234 | $ID = $Database->SQLCommand($sql);
|
---|
235 | $Line = mysql_fetch_row($ID);
|
---|
236 | $GroupId = $Group['Id'];
|
---|
237 | echo('<tr><td><a href="?group='.$GroupId.'&action=userid&not&user='.$_GET['user'].'">'.$Group['Name'].'</a></td><td>'.$Line[0].'</td></tr>');
|
---|
238 | $Total += $Line[0];
|
---|
239 | } else {
|
---|
240 | $sql = 'SELECT COUNT(*) FROM `'.$Group['TablePrefix'].'` WHERE `user`='.$_GET['user'];
|
---|
241 | $ID = $Database->SQLCommand($sql);
|
---|
242 | $Line = mysql_fetch_row($ID);
|
---|
243 | $GroupId = $Group['Id'];
|
---|
244 | echo('<tr><td><a href="?group='.$GroupId.'&action=userid&user='.$_GET['user'].'">'.$Group['Name'].'</a></td><td>'.$Line[0].'</td></tr>');
|
---|
245 | $Total += $Line[0];
|
---|
246 | }
|
---|
247 | }
|
---|
248 | echo('<tr><td><strong>Celkem</strong></td><td><strong>'.$Total.'</strong></td></tr>');
|
---|
249 | echo('</table>');
|
---|
250 | } else
|
---|
251 | if($Action == 'grouplist')
|
---|
252 | {
|
---|
253 | echo('<h3>Seznam překladových skupin</h3>');
|
---|
254 | echo('<table class="BaseTable"><tr><th>Jméno</th><th>Zdroj pro import</th><th>Formáty exportu</th><th>Datum posledního importu</th><th>Verze posledního importu</th></tr>');
|
---|
255 | $Total = 0;
|
---|
256 | foreach($TranslationTree as $Group)
|
---|
257 | if($Group['TablePrefix'] != '')
|
---|
258 | {
|
---|
259 | $Export = 'XML';
|
---|
260 | $Import = '';
|
---|
261 | if($Group['MangosTable'] != '')
|
---|
262 | {
|
---|
263 | $Export .= ', SQL';
|
---|
264 | $Import = 'SQL '.$Group['MangosDatabase'].'.'.$Group['MangosTable'];
|
---|
265 | }
|
---|
266 | if($Group['DBCFileName'] != '')
|
---|
267 | {
|
---|
268 | $Export .= ', DBC';
|
---|
269 | $Import = $Group['DBCFileName'].'.dbc';
|
---|
270 | }
|
---|
271 | if($Group['LuaFileName'] != '')
|
---|
272 | {
|
---|
273 | $Export .= ', Lua';
|
---|
274 | $Import = $Group['LuaMPQFolder'].'/'.$Group['LuaFileName'].'.lua';
|
---|
275 | }
|
---|
276 | foreach($Group['Items'] as $Item)
|
---|
277 | if(($Item['AddonFileName'] != '') and (substr($Export, -5) != 'Addon'))
|
---|
278 | {
|
---|
279 | $Export .= ', Addon';
|
---|
280 | }
|
---|
281 | echo('<tr><td><a href="?group='.$Group['Id'].'&action=filter">'.$Group['Name'].'</a></td><td>'.$Import.'</td><td>'.$Export.'</td><td><a title="Změny po posledním importu u vybrané překladové skupiny" href="log.php?group='.$Group['Id'].'&type=11">'.HumanDate($Group['LastImport']).'</a></td><td>'.GetVersionWOW($Group['LastVersion']).'</td></tr>');
|
---|
282 | }
|
---|
283 | echo('</table>');
|
---|
284 | echo('<br /><a title="Záznam změn po importu" href="log.php?type=11">Záznam změn v textech při importu</a>');
|
---|
285 | } else
|
---|
286 | if($Action == 'userid')
|
---|
287 | {
|
---|
288 | if(array_key_exists('user', $_GET))
|
---|
289 | {
|
---|
290 | $ID = $Database->SQLCommand('SELECT `user` FROM `user` WHERE `id` = '.($_GET['user'] * 1));
|
---|
291 | if(mysql_num_rows($ID) > 0)
|
---|
292 | {
|
---|
293 | $Line = mysql_fetch_row($ID);
|
---|
294 | echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&action=filter">Filtr textů</a> -> '.
|
---|
295 | '<strong>Vypis překladů uživatele '.$Line[0].': </strong><br /><br />');
|
---|
296 | if(array_key_exists('not', $_GET))
|
---|
297 | WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` Where `Complete` = 0 AND `user` = '.$_GET['user'], '', 'userid');
|
---|
298 | else WriteQuests('SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` Where `user` = '.$_GET['user'], '', 'userid');
|
---|
299 | } else echo('Nebyl nalezen uživatel se zadaným id');
|
---|
300 | } else echo('Je nutno zadat id uživatele.');
|
---|
301 | } else
|
---|
302 | if($Action == 'search')
|
---|
303 | {
|
---|
304 | if(array_key_exists('search', $_GET)) $Search = $_GET['search'];
|
---|
305 | else $Search = $_POST['search'];
|
---|
306 |
|
---|
307 | $sql = 'SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` WHERE `ID` LIKE "%'.$Search.'%"
|
---|
308 | OR `entry` LIKE "%'.$Search.'%"
|
---|
309 | OR `Language` LIKE "%'.$Search.'%"
|
---|
310 | OR `User` LIKE "%'.$Search.'%"
|
---|
311 | OR `Complete` LIKE "%'.$Search.'%"';
|
---|
312 | foreach($TranslationTree[$GroupId]['Items'] as $Item)
|
---|
313 | {
|
---|
314 | if($Item['Column'] != '') $sql .= ' OR `'.$Item['Column'].'` LIKE "%'.$Search.'%"';
|
---|
315 | }
|
---|
316 |
|
---|
317 | WriteQuests($sql, '', 'search='.$Search);
|
---|
318 | } else
|
---|
319 | if($Action == 'searchentry')
|
---|
320 | {
|
---|
321 | if(array_key_exists('ID', $_GET)) $Search = $_GET['ID'];
|
---|
322 | else if(array_key_exists('ID', $_POST)) $Search = $_POST['ID'];
|
---|
323 | else $Search = '';
|
---|
324 |
|
---|
325 | $sql = 'SELECT *, (SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `'.$Table.'`.`user`) AS `User` FROM `'.$Table.'` WHERE `entry` LIKE "'.$Search.'"';
|
---|
326 |
|
---|
327 | WriteQuests($sql, '', 'searchentry='.$Search);
|
---|
328 | } else
|
---|
329 | if($Action == 'all')
|
---|
330 | {
|
---|
331 | echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&action=filter">Filtr textů</a> ->
|
---|
332 | <a title="Zde můžete začít překládat" href="?group='.$GroupId.'&action=selection">Nepřeložené texty</a> - >
|
---|
333 | <strong>Výpis všech textů s limitem na stránku</strong><br /><br />');
|
---|
334 |
|
---|
335 | WritePages('?group='.$GroupId.'&action=all', ' AS `items` WHERE (`items`.`Language` = 0)');
|
---|
336 |
|
---|
337 | WriteQuests('SELECT * FROM `'.$Table.'` AS `items` WHERE (`items`.`Language` = 0)', $_SESSION['limitx'].','.$_SESSION['limity'], 'all');
|
---|
338 | } else
|
---|
339 | if($Action == 'filter')
|
---|
340 | {
|
---|
341 | echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&action=filter">Filtr textů</a><br /><br /><br />'.
|
---|
342 | '<table class="BaseTable"><tr><th>Odkaz</th><th>Popis</th></tr>'.
|
---|
343 | '<tr><td><a title="Všechny dostupné texty ve skupině" href="?group='.$GroupId.'&action=all">Všechny texty</a></td>'.
|
---|
344 | '<td>Zobrazit všechny dostupné texty ve skupině.</td></tr>'.
|
---|
345 | '<tr><td><a title="Přeložené texty, můžete zde hlasovat, nebo text opravovat" href="?group='.$GroupId.'&action=Translate">Přeložené texty</a></td>'.
|
---|
346 | '<td>Zobrazit pouze již přeložené texty.</td></tr>'.
|
---|
347 | '<tr><td><a title="Nepřeložené texty" href="?group='.$GroupId.'&action=notran">Nepřeložené texty</a></td>'.
|
---|
348 | '<td>Dosud nepřeložené texty, které je potřeba přeložit.</td></tr>'.
|
---|
349 | '<tr><td><a title="Nedokončené texty" href="?group='.$GroupId.'&action=nocomplete">Nedokončené texty</a></td>'.
|
---|
350 | '<td>Texty označené jako rozpracované.</td></tr>');
|
---|
351 |
|
---|
352 | if(Licence(LICENCE_USER))
|
---|
353 | {
|
---|
354 | echo('<tr><td><a title="Nedokončené texty" href="?group='.$GroupId.'&action=mydevelop">Rozepsané texty</a></td>
|
---|
355 | <td>Nedokončené texty přihlášeného uživatele</td></tr>
|
---|
356 | <tr><td><a title="Přeložené texty přihlášeného uživatele" href="?group='.$GroupId.'&action=my">Moje překlady</a></td>
|
---|
357 | <td>Přeložené texty přihlášeného uživatele</td></tr>');
|
---|
358 | }
|
---|
359 |
|
---|
360 | echo('<tr><td><form action="?group='.$GroupId.'&action=users" method="post"><div>'.
|
---|
361 | '<select name="users[]" size="10" multiple="multiple" class="UserList">');
|
---|
362 |
|
---|
363 | $ID = $Database->SQLCommand('SELECT `user`, `ID` FROM `user` WHERE
|
---|
364 | EXISTS(SELECT 1 FROM `'.$Table.'` WHERE `user` = `user`.`ID`) ORDER BY `user`');
|
---|
365 | if($ID)
|
---|
366 | while($Line = mysql_fetch_assoc($ID))
|
---|
367 | echo('<option value="'.$Line['ID'].'">'.$Line['user'].'</option>');
|
---|
368 |
|
---|
369 | echo('</select><br />
|
---|
370 | <input type="submit" value="Vypsat" /></div></form></td>
|
---|
371 | <td>Vypsat pouze od těchto uživatalů<br />
|
---|
372 | Vybrat více uživatelů můžete pomocí CTRL+click</td></tr>');
|
---|
373 |
|
---|
374 | echo('<tr><td><form action="?group='.$GroupId.'&action=search" method="post"><div>'.
|
---|
375 | '<input type="text" name="search" size="8" />'.
|
---|
376 | '<input type="submit" value="Hledat" />'.
|
---|
377 | '</div></form>'.
|
---|
378 | '</td><td>Vyhledat pomocí textu</td></tr>');
|
---|
379 |
|
---|
380 | echo('<tr><td><form action="?group='.$GroupId.'&action=searchentry" method="post"><div>'.
|
---|
381 | '<input type="text" name="ID" size="8" />'.
|
---|
382 | '<input type="submit" value="Hledat" />'.
|
---|
383 | '</div></form>'.
|
---|
384 | '</td><td>Zobrazit podle ID textu v databázi MaNGOSu</td></tr>');
|
---|
385 |
|
---|
386 | echo('</table>');
|
---|
387 | // WriteQuests("SELECT * FROM quests Where user = ".$_SESSION['UserID']." AND Complete = '0'", '', 'mydevelop');
|
---|
388 | }
|
---|
389 |
|
---|
390 | ShowFooter();
|
---|
391 | ?>
|
---|
392 |
|
---|