Changeset 284
- Timestamp:
- Dec 11, 2009, 11:41:03 AM (15 years ago)
- Location:
- trunk
- Files:
-
- 2 added
- 10 edited
-
dictionary.php (modified) (6 diffs)
-
includes/config.sample.php (modified) (1 diff)
-
includes/database.php (added)
-
includes/global.php (modified) (1 diff)
-
includes/global_function.php (modified) (14 diffs)
-
log.php (modified) (5 diffs)
-
sql/data.sql (modified) (3 diffs)
-
sql/structure.sql (modified) (24 diffs)
-
sql/updates/284.sql (added)
-
team.php (modified) (3 diffs)
-
userlist.php (modified) (4 diffs)
-
version.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/dictionary.php
r199 r284 5 5 function GetIDbyName($Table) 6 6 { 7 8 9 10 { 11 12 13 7 global $TranslationTree; 8 9 foreach($TranslationTree as $TableID => $Value) 10 { 11 //echo $Value['TablePrefix'].'='.$Table.'<br>'; 12 if ($Value['TablePrefix'] == $Table) return $TableID; 13 } 14 14 } 15 15 … … 18 18 global $Database, $mode; 19 19 20 21 22 23 24 20 if ($mode == 0) echo ('..Přesné'); 21 if ($mode == 1) echo ('..Všechny přeložené'); 22 if ($mode == 2) echo ('..Nepřeložené'); 23 echo('<div style="overflow: auto; width: 100%; height: 345px;"><table width="98%" class="BaseTable">'); 24 echo('<tr><th>Originál</th>'.'<th>Překlad</th>'); 25 25 $TablesColumn = array 26 26 ( … … 52 52 for($i = 0; $i < count($ArrStr); $i++) 53 53 { 54 55 56 57 58 59 60 61 54 if (strpos($ArrStr[$i],'\'s') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-4); 55 if (strpos($ArrStr[$i],',') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1); 56 if (strpos($ArrStr[$i],'.') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1); 57 if (strpos($ArrStr[$i],'!') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1); 58 if (strpos($ArrStr[$i],'?') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1); 59 60 if (strlen($ArrStr[$i]) > 4) 61 $where .= 'O.'.$Column.' LIKE "%'.addslashes($ArrStr[$i]).'%" OR '; 62 62 } 63 63 $where = substr($where,0,strlen($where)-4); 64 64 $where .= ')'; 65 66 67 68 69 { 70 71 { 72 65 echo ('</tr>'); 66 67 $ID = $Database->SQLCommand($sql.$where.$groupby); 68 while($Line = mysql_fetch_assoc($ID)) 69 { 70 if ($mode == 0) 71 { 72 if (strpos(strtolower($Text),strtolower($Line[$Column])) > 0) 73 73 { 74 75 76 77 78 79 { 80 81 82 83 84 85 } 86 74 echo('<tr><td>'.$Line[$Column].'</td>'); 75 if ($Line['tran'] <> '') echo('<td>'.$Line['tran'].'</td></tr>'); 76 else echo('<td><a target="_NEW2" href="form.php?group='.GetIDbyName($Table).'&ID='.$Line['ID'].'">Překládat</a></td></tr>'); 77 } 78 } else 79 { 80 echo('<tr><td>'.$Line[$Column].'</td>'); 81 if ($Line['tran'] <> '') echo('<td>'.$Line['tran'].'</td></tr>'); 82 else echo('<td><a target="_NEW2" href="form.php?group='.GetIDbyName($Table).'&ID='.$Line['ID'].'">Překládat</a></td></tr>'); 83 } 84 } 85 } 86 echo('</table></div>'); 87 87 } 88 88 … … 107 107 if(array_key_exists('group', $_GET)) 108 108 { 109 110 111 112 113 109 if(array_key_exists('group', $_GET)) $GroupId = $_GET['group']; else $GroupId = 1; 110 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é 111 $Table = $TranslationTree[$GroupId]['TablePrefix']; 112 113 if(array_key_exists('ID', $_GET)) 114 114 { 115 115 $TextID = $_GET['ID']; 116 117 118 119 116 echo ('Přeložené názvy vztahující se k překladu: <a target="_NEW" href="form.php?group='.$GroupId.'&ID='.$TextID.'">'.$TextID.'</a><br />'. 117 '<a href="?mode=1&group='.$GroupId.'&ID='.$TextID.'" title="Zobrazit všechny podobné výsledky">Všechny</a> '. 118 '<a href="?mode=0&group='.$GroupId.'&ID='.$TextID.'" title="Zobrazit pouze přesné výsledky">Přesné</a> '. 119 '<a href="?mode=2&group='.$GroupId.'&ID='.$TextID.'" title="Zobrazit všechny nepřeložené">Nepřeložené</a> '); 120 120 $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT * FROM '.$Table.' Where ID = '.$TextID)); 121 121 if(!$Line) die('Překlad nenalezen.'); 122 123 124 125 126 127 122 123 $Text = ''; 124 foreach($TranslationTree[$GroupId]['Items'] as $Index => $TextItem) 125 $Text .= ' '.$Line[$TextItem['Column']]; 126 GetTranslatNames($Text); 127 } 128 128 } else 129 129 { … … 218 218 $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'; 219 219 } 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'; 220 $sql_page = $sql.' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage']; 221 222 ListPaging('?Page=', '('.$sql.') AS T1', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']); 220 221 $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM ('.$sql.') AS T1'); 222 $DbRow = mysql_fetch_row($DbResult); 223 $PageList = GetPageList($DbRow[0]); 224 225 $sql_page = $sql.' '.$PageList['SQLLimit']; 226 227 echo($PageList['Output']); 223 228 echo('<table width="98%" class="BaseTable"> 224 229 <tr><th>'.$LanguageList[0]['Name'].'</th> … … 244 249 } 245 250 echo('</table>'); 246 ListPaging('?Page=', '('.$sql.') AS T1', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']);251 echo($PageList['Output']); 247 252 echo('</td></tr>'); 248 253 echo('</table></form>'); -
trunk/includes/config.sample.php
r157 r284 15 15 'Charset' => 'utf-8', 16 16 'BaseURL' => 'http://localhost/', 17 18 19 20 21 22 'ItemsPerPage' => 50,23 17 'AdminEmail' => 'admin@localhost', 18 'ShowSQLQuery' => false, 19 'ShowSQLError' => false, 20 'ShowPHPError' => false, 21 'ShowRuntimeInfo' => false, 22 'ItemsPerPage' => 40, 23 'TempFolder' => '../tmp/', 24 24 'GameVersion' => '3.0.3', 25 'VisiblePagingItems' => 20, 25 26 ), 26 27 ); -
trunk/includes/global.php
r283 r284 305 305 } 306 306 307 function GetQueryStringArray($QueryString) 308 { 309 $Result = array(); 310 $Parts = explode('&', $QueryString); 311 foreach($Parts as $Part) 312 { 313 if($Part != '') 314 { 315 $Item = explode('=', $Part); 316 $Result[$Item[0]] = $Item[1]; 317 } 318 } 319 return($Result); 320 } 321 322 function SetQueryStringArray($QueryStringArray) 323 { 324 $Parts = array(); 325 foreach($QueryStringArray as $Index => $Item) 326 { 327 $Parts[] = $Index.'='.$Item; 328 } 329 return(implode('&', $Parts)); 330 } 331 307 332 ?> -
trunk/includes/global_function.php
r255 r284 20 20 function getmonthyears($Days) 21 21 { 22 $month = floor($Days / 30); 23 $year = floor($month / 12); 24 $Days = floor($Days - $month * 30); 25 $month = $month - $year * 12; 26 return($year.'r '.$month.'m '.$Days.'d'); 27 } 28 29 function ListPaging($Address, $Table, $Where, $ItemsPerPage, $CurrentPage) 30 { 31 global $Database; 32 33 echo('<div style="text-align: center">'); 34 $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM '.$Table.' '.$Where)); 35 $ItemCount = $Line[0]; 36 $PageCount = floor($ItemCount / $ItemsPerPage) + 1; 22 $month = floor($Days / 30); 23 $year = floor($month / 12); 24 $Days = floor($Days - $month * 30); 25 $month = $month - $year * 12; 26 return($year.'r '.$month.'m '.$Days.'d'); 27 } 28 29 function GetPageList($TotalCount) 30 { 31 global $Database, $Config; 32 33 $QueryItems = GetQueryStringArray($_SERVER['QUERY_STRING']); 34 35 $ItemPerPage = $Config['Web']['ItemsPerPage']; 36 $Around = round($Config['Web']['VisiblePagingItems'] / 2); 37 $Result = ''; 38 $PageCount = ceil($TotalCount / $ItemPerPage); 39 40 if(array_key_exists('page', $_GET)) $_SESSION['Page'] = $_GET['page'] * 1; 41 if($_SESSION['Page'] < 0) $_SESSION['Page'] = 0; 42 if($_SESSION['Page'] >= $PageCount) $_SESSION['Page'] = $PageCount - 1; 43 $CurrentPage = $_SESSION['Page']; 37 44 38 echo('Počet položek: <strong>'.$ItemCount.'</strong> Zobrazit stránku: '); 39 40 //if($CurrentPage > $PageCount) $CurrentPage = $PageCount; 41 for($Page = 1; $Page <= $PageCount; $Page++) 42 { 43 if($CurrentPage == $Page) echo('<strong>'.$Page.'</strong> '); 44 else echo('<a href="'.$Address.$Page.'">'.$Page.'</a> '); 45 } 46 echo('</div>'); 45 $Result .= 'Počet položek: <strong>'.$TotalCount.'</strong> Stránky: '; 46 47 $Result = ''; 48 if($PageCount > 1) 49 { 50 if($CurrentPage > 0) 51 { 52 $QueryItems['page'] = 0; 53 $Result.= '<a href="?'.SetQueryStringArray($QueryItems).'"><<</a> '; 54 $QueryItems['page'] = ($CurrentPage - 1); 55 $Result.= '<a href="?'.SetQueryStringArray($QueryItems).'"><</a> '; 56 } 57 $PagesMax = $PageCount - 1; 58 $PagesMin = 0; 59 if($PagesMax > ($CurrentPage + $Around)) $PagesMax = $CurrentPage + $Around; 60 if($PagesMin < ($CurrentPage - $Around)) 61 { 62 $Result.= ' .. '; 63 $PagesMin = $CurrentPage - $Around; 64 } 65 for($i = $PagesMin; $i <= $PagesMax; $i++) 66 { 67 if($i == $CurrentPage) $Result.= '<strong>'.($i + 1).'</strong> '; 68 else { 69 $QueryItems['page'] = $i; 70 $Result .= '<a href="?'.SetQueryStringArray($QueryItems).'">'.($i + 1).'</a> '; 71 } 72 } 73 if($PagesMax < ($PageCount - 1)) $Result .= ' .. '; 74 if($CurrentPage < ($PageCount - 1)) 75 { 76 $QueryItems['page'] = ($CurrentPage + 1); 77 $Result.= '<a href="?'.SetQueryStringArray($QueryItems).'">></a> '; 78 $QueryItems['page'] = ($PageCount - 1); 79 $Result.= '<a href="?'.SetQueryStringArray($QueryItems).'">>></a>'; 80 } 81 } 82 $Result = '<div style="text-align: center">'.$Result.'</div>'; 83 return(array('SQLLimit' => ' LIMIT '.$CurrentPage * $ItemPerPage.', '.$ItemPerPage, 84 'Page' => $CurrentPage, 85 'Output' => $Result, 86 )); 47 87 } 48 88 … … 55 95 { 56 96 $start = strpos($s,'<'); 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 97 $end = strpos($s,'>'); 98 if($start != 0) 99 { 100 $end = $start-1; 101 $start = 0; 102 } 103 $line = trim(substr($s,$start,$end+1)); 104 if(strlen($line)>0) 105 if($line[0] == '<') 106 { 107 if($s[$start+1] == '/') 108 { 109 $n = $n - 2; 110 $nn = $n; 111 } else 112 { 113 if(strpos($line,' ')) $cmd = substr($line,1,strpos($line,' ')-1); 114 else $cmd = substr($line,1,strlen($line)-2); 75 115 //echo('['.$cmd.']'); 76 77 78 116 if(strpos($s,'</'.$cmd.'>')) $n = $n + 2; 117 } 118 }// else $line = '['.$line.']'; 79 119 //if($line != '') echo(htmlspecialchars(str_repeat(' ',$nn).$line."\n")); 80 81 82 120 if($line != '') $out .= (str_repeat(' ',$nn).$line."\n"); 121 $s = substr($s,$end+1,strlen($s)); 122 $nn = $n; 83 123 } 84 124 return($out); … … 96 136 if($Selected == $Language['Id']) echo(' selected="selected"'); echo('>'.$Language['Name'].'</option>'); 97 137 } 98 echo('</select>'); 138 echo('</select>'); 99 139 } 100 140 … … 125 165 } else 126 166 { 127 if(!isset($_SERVER['REMOTE_ADDR'])) 128 { 129 return(true); 130 } else { 131 return(false); 132 } 167 return(!isset($_SERVER['REMOTE_ADDR'])); 133 168 } 134 169 } … … 150 185 $DbResult = $Database->SQLCommand('SELECT * FROM `language`'); 151 186 while($DbRow = mysql_fetch_assoc($DbResult)) 152 187 $Result[$DbRow['Id']] = $DbRow; 153 188 return($Result); 154 189 } … … 162 197 while($DbRow = mysql_fetch_assoc($DbResult)) 163 198 { 164 165 199 $DbRow['Items'] = array(); 200 $Result[$DbRow['Id']] = $DbRow; 166 201 } 167 202 $DbResult = $Database->SQLCommand('SELECT * FROM `group_item`'); 168 203 while($DbRow = mysql_fetch_assoc($DbResult)) 169 204 { 170 205 $Result[$DbRow['Group']]['Items'][] = $DbRow; 171 206 } 172 207 return($Result); … … 175 210 $LogTypes = array 176 211 ( 177 // index, indexname , barva , popis 178 array('0', '', 'brown', ''), 179 array('1', 'Překlady', 'green', 'Operace s překladdy'), 180 array('2', 'Stažení', 'brown', 'Stáhnutí souboru'), 181 array('3', 'Uživatelé', 'blue', 'Přihlášení uživatelů, nastavení, registrace'), 182 array('4', 'Moderátor', 'orange', 'Operace administrátorů a moderátorů'), 183 array('10', 'Chyby', 'red', 'Zachycené chybové hlášení'), 184 array('11', 'Import', '#A020F0', 'Záznam změn při importu'), 212 0 => array('Name' => '', 'Color' => 'brown', 'Description' => ''), 213 1 => array('Name' => 'Překlady', 'Color' => 'green', 'Description' => 'Operace s překladdy'), 214 2 => array('Name' => 'Stažení', 'Color' => 'brown', 'Description' => 'Stáhnutí souboru'), 215 3 => array('Name' => 'Uživatelé', 'Color' => 'blue', 'Description' => 'Přihlášení uživatelů, nastavení, registrace'), 216 4 => array('Name' => 'Moderátor', 'Color' => 'orange', 'Description' => 'Operace administrátorů a moderátorů'), 217 10 => array('Name' => 'Chyby', 'Color' => 'red', 'Description' => 'Zachycené chybové hlášení'), 218 11 => array('Name' => 'Import', 'Color' => '#A020F0', 'Description' => 'Záznam změn při importu'), 185 219 ); 186 220 … … 189 223 function WriteLog($Text, $Type) 190 224 { 191 global $Database, $Config ,$_SERVER;225 global $Database, $Config; 192 226 193 if(!isset($_SERVER['REMOTE_ADDR'])) 194 { 195 $user = 0; 196 $ip = 'Konzole'; 197 } else { 198 $user = @$_SESSION['UserID']; 199 $ip = addslashes($_SERVER['REMOTE_ADDR']); 200 } 227 if(!isset($_SERVER['REMOTE_ADDR'])) 228 { 229 $user = 0; 230 $ip = 'Konzole'; 231 } else 232 { 233 $user = @$_SESSION['UserID']; 234 $ip = addslashes($_SERVER['REMOTE_ADDR']); 235 } 201 236 202 237 if($user == '') $user = 0; … … 209 244 $client_files = array 210 245 ( 211 '0'=> 'LocalizationStrings',212 '1'=> 'SpellBufDescription_1',213 '2'=> 'SpellDescription_1',214 '3'=> 'SpellDescription_2',215 '4'=> 'SpellDescription_3',216 '5'=> 'SpellDescription_4',217 '6'=> 'tallent',246 0 => 'LocalizationStrings', 247 1 => 'SpellBufDescription_1', 248 2 => 'SpellDescription_1', 249 3 => 'SpellDescription_2', 250 4 => 'SpellDescription_3', 251 5 => 'SpellDescription_4', 252 6 => 'tallent', 218 253 ); 219 254 … … 231 266 if($Prev) 232 267 { 233 268 $sql = 'SELECT ID FROM '.$Table.' as item WHERE Language = 0 AND NOT EXISTS(SELECT entry FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = item.entry) AND ID < '.$TextID.' ORDER BY ID DESC LIMIT 1'; 234 269 } else 235 270 { 236 271 $sql = 'SELECT ID FROM '.$Table.' as item WHERE Language = 0 AND NOT EXISTS(SELECT entry FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = item.entry) AND ID > '.$TextID.' ORDER BY ID LIMIT 1'; 237 272 } 238 273 … … 240 275 if($Next) 241 276 { 242 243 244 277 if($Prev) echo('<a href="form.php?group='.$GroupId.'&ID='.$Next['ID'].'">Předcházející '.$Next['ID'].'</a> '); 278 else echo('<a href="form.php?group='.$GroupId.'&ID='.$Next['ID'].'">Následující '.$Next['ID'].'</a> '); 279 return 'form.php?group='.$GroupId.'&ID='.$Next['ID']; 245 280 } 246 281 } … … 264 299 $old = str_replace("Â", "", $old); 265 300 $old = str_replace("�", "", $old); 266 301 267 302 268 303 if (($GroupItem['MangosColumn'] <> '') and ($Group['MangosDatabase'] == 'mangos')) … … 282 317 $new = str_replace("�", "", $new); 283 318 284 285 286 287 319 if (($old == 'null') or ($old == 'NULL')) $old = ''; 320 if (($new == 'null') or ($new == 'NULL')) $new = ''; 321 322 288 323 if(($old <> $new) and ($GroupItem['Column'] <> 'Comment')) 289 324 { … … 299 334 { 300 335 global $Database,$BuildNumbers; 301 336 302 337 if (isset($BuildNumbers[$Version]) == false) 303 338 { -
trunk/log.php
r250 r284 1 1 <?php 2 2 3 include('includes/global.php'); 4 include('rss.php'); 3 include_once('includes/global.php'); 5 4 6 5 if(array_key_exists('rss', $_GET)) … … 14 13 { 15 14 $Items[] = array 16 17 'Title' => strip_tags($LogTypes[$Line['type']][ 1].': '.$Line['text'].' ('.$Line['user'].', '.$Line['IP'].')'),15 ( 16 'Title' => strip_tags($LogTypes[$Line['type']]['Name'].': '.$Line['text'].' ('.$Line['user'].', '.$Line['IP'].')'), 18 17 'Link' => $Config['Web']['BaseURL'].'log.php', 19 'Description' => $LogTypes[$Line['type']][ 1].': '.$Line['text'].' ('.$Line['user'].', '.$Line['IP'].')',18 'Description' => $LogTypes[$Line['type']]['Name'].': '.$Line['text'].' ('.$Line['user'].', '.$Line['IP'].')', 20 19 'Time' => $Line['UNIX_TIMESTAMP(date)'], 21 20 ); 22 } 21 } 23 22 24 23 echo(GenerateRSS(array … … 32 31 } else 33 32 { 34 if(array_key_exists('Page', $_GET)) $_SESSION['Page'] = $_GET['Page']; 35 else if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 1; 33 if(array_key_exists('type', $_GET)) $_SESSION['type'] = $_GET['type'] * 1; 34 else if(!array_key_exists('type', $_SESSION)) $_SESSION['type'] = ''; 35 36 36 if(array_key_exists('group', $_GET)) $_SESSION['group'] = $_GET['group']; 37 37 38 if(array_key_exists('type', $_GET)) $_SESSION['type'] = $_GET['type']; 39 else if(!array_key_exists('type', $_SESSION)) $_SESSION['type'] = ''; 40 41 if($_SESSION['type'] <> '') $Type = '&type='.$_SESSION['type']; 42 else { 43 $Type = ''; 44 unset($_SESSION['type'],$_SESSION['group']); 45 } 46 47 $RSSChannels = array(array('Title' => 'Záznamy změn', 'URL' => 'log.php?rss'.$Type)); 38 if($_SESSION['type'] != '') $WhereType = ' `type`='.$_SESSION['type']; 39 else $WhereType = '1=1'; 40 41 $RSSChannels = array(array('Title' => 'Záznamy změn', 'URL' => 'log.php?rss&type='.$_SESSION['type'])); 48 42 ShowPage(); 49 43 … … 54 48 foreach($LogTypes as $Index => $LogItem) 55 49 { 56 echo('<a href="log.php?type='.$ LogItem[0].'" style="color:'.$LogItem[2].'" title="'.$LogItem[3].'">'.$LogItem[1].'</a> ');50 echo('<a href="log.php?type='.$Index.'" style="color:'.$LogItem['Color'].'" title="'.$LogItem['Name'].'">'.$LogItem['Name'].'</a> '); 57 51 } 58 52 } … … 60 54 echo('<br /><br />'); 61 55 62 if(array_key_exists('type', $_SESSION)) $Where = ' WHERE type = "'.$_SESSION['type'].'"';63 56 if(array_key_exists('type', $_SESSION)) $Where = ' WHERE '.$WhereType; 57 else 64 58 { 65 59 if(array_key_exists('group', $_SESSION)) $Where = ' WHERE text LIKE "%'.$TranslationTree[$_SESSION['group']]['Name'].'%"'; 66 60 else $Where = ''; 67 61 } 68 62 if(($Where != '') and (array_key_exists('group', $_SESSION))) $Where .= ' AND text LIKE "%'.$TranslationTree[$_SESSION['group']]['Name'].'%"'; 69 63 70 $sql = 'SELECT *,(SELECT user.user FROM user WHERE user.id = log.user) as user FROM log '.$Where.'ORDER BY date DESC LIMIT '.(($_SESSION['Page'] - 1)*100).',100'; 64 $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `log` '.$Where); 65 $DbRow = mysql_fetch_row($DbResult); 66 $PageList = GetPageList($DbRow[0]); 67 68 $sql = 'SELECT *,(SELECT `user`.`user` FROM `user` WHERE `user`.`id` = `log`.`user`) AS `user` FROM `log` '.$Where.' ORDER BY `date` DESC '.$PageList['SQLLimit']; 71 69 72 ListPaging('?Page=', 'log', $Where, 100, $_SESSION['Page']); 70 echo($PageList['Output']); 71 echo('<table class="BaseTable"><tr><th>Čas</th><th>Text</th><th>Uživatel</th><th>Adresa</th></tr>'); 73 72 $ID = $Database->SQLCommand($sql); 74 73 while($Line = mysql_fetch_assoc($ID)) 75 74 { 76 foreach($LogTypes as $Index => $LogItem) 77 { 78 if($Line['type'] == $LogItem[0]) $color = $LogItem[2]; 79 } 80 echo($Line['date'].': <span style="color:'.$color.'">'.$Line['text'].'</span> ('.$Line['user'].', '.$Line['IP'].')<br />'); 75 echo('<tr><td>'.$Line['date'].'</td><td><span style="color:'.$LogTypes[$Line['type']]['Color'].'">'.$Line['text'].'</span></td><td>'.$Line['user'].'</td><td>'.$Line['IP'].'</td></tr>'); 81 76 } 82 //ListPaging('?Page=', 'log', $Where, $Config['Web']['ItemsPerPage'], $_SESSION['Page']); 77 echo('</table>'); 78 echo($PageList['Output']); 83 79 84 80 ShowFooter(); -
trunk/sql/data.sql
r85 r284 1 -- phpMyAdmin SQL Dump 2 -- version 3.2.3 3 -- http://www.phpmyadmin.net 4 -- 5 -- Počítač: localhost 6 -- Vygenerováno: Pátek 11. prosince 2009, 11:29 7 -- Verze MySQL: 5.0.84 8 -- Verze PHP: 5.2.9 9 10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 11 12 -- 13 -- Databáze: `wowpreklad` 14 -- 1 15 2 16 -- … … 4 18 -- 5 19 6 INSERT INTO `group` (`Id`, `Name`, `TablePrefix`, `MangosDatabase`, `MangosTable`, `MangosTableIndex`, `DBCFileName`, `DBCColumns`, `WowheadName`) VALUES 7 (1, 'Výpravy', 'quests', 'realm2_mangos', 'quest_template', 'entry', '', '', 'quest'), 8 (2, 'Texty knížek', 'page', 'realm2_mangos', 'page_text', 'entry', '', '', ''), 9 (3, 'Slova NPC', 'npc', 'realm2_mangos', 'npc_text', 'ID', '', '', ''), 10 (4, 'Názvy věcí', 'item', 'realm2_mangos', 'item_template', 'entry', '', '', 'item'), 11 (5, 'Názvy herních objektů', 'gameobject', 'realm2_mangos', 'gameobject_template', 'entry', '', '', 'gameobject'), 12 (6, 'Jména bytostí', 'creature', 'realm2_mangos', 'creature_template', 'entry', '', '', 'npc'), 13 (7, 'Zprávy MaNGOSu', 'mangos_string', 'realm2_mangos', 'mangos_string', 'entry', '', '', ''), 14 (8, 'Popis GM příkazů', 'mangos_command', 'realm2_mangos', 'command', 'entry', '', '', ''), 15 (9, 'Klient', 'client', '', '', '', '', '', ''), 16 (10, 'Texty skriptů ScriptDev2', 'sd2_script_texts', 'realm2_scriptdev2', 'script_texts', 'entry', '', '', ''), 17 (11, 'Texty EventAI', 'sd2_eventai_texts', 'realm2_scriptdev2', 'eventai_texts', 'entry', '', '', ''), 18 (12, 'Herní tipy', 'gametips', '', '', '', 'GameTips', 'usuuuuuuuuuuuuuuuu', ''), 19 (13, 'Kouzla', 'spell', '', '', '', 'Spell', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu', 'spell'); 20 INSERT INTO `group` (`Id`, `Name`, `TablePrefix`, `MangosDatabase`, `MangosTable`, `MangosTableIndex`, `DBCFileName`, `WowheadName`, `LuaFileName`, `LuaMPQFolder`, `LastImport`, `LastVersion`) VALUES 21 (1, 'Výpravy', 'quests', 'mangos', 'quest_template', 'entry', '', 'quest', '', '', '0000-00-00 00:00:00', 0), 22 (2, 'Texty knížek', 'page', 'mangos', 'page_text', 'entry', '', '', '', '', '0000-00-00 00:00:00', 0), 23 (3, 'Slova NPC', 'npc', 'mangos', 'npc_text', 'ID', '', '', '', '', '0000-00-00 00:00:00', 0), 24 (4, 'Názvy věcí', 'item', 'mangos', 'item_template', 'entry', '', 'item', '', '', '0000-00-00 00:00:00', 0), 25 (5, 'Názvy herních objektů', 'gameobject', 'mangos', 'gameobject_template', 'entry', '', 'gameobject', '', '', '0000-00-00 00:00:00', 0), 26 (6, 'Jména bytostí', 'creature', 'mangos', 'creature_template', 'entry', '', 'npc', '', '', '0000-00-00 00:00:00', 0), 27 (7, 'Zprávy MaNGOSu', 'mangos_string', 'mangos', 'mangos_string', 'entry', '', '', '', '', '0000-00-00 00:00:00', 0), 28 (8, 'Popis GM příkazů', 'mangos_command', 'mangos', 'command', 'entry', '', '', '', '', '0000-00-00 00:00:00', 0), 29 (10, 'Texty skriptů ScriptDev2', 'sd2_script_texts', 'scriptdev2', 'script_texts', 'entry', '', '', '', '', '0000-00-00 00:00:00', 0), 30 (11, 'Texty EventAI', 'sd2_eventai_texts', 'scriptdev2', 'eventai_texts', 'entry', '', '', '', '', '0000-00-00 00:00:00', 0), 31 (12, 'Herní tipy', 'gametips', '', '', '', 'GameTips', '', '', '', '0000-00-00 00:00:00', 0), 32 (13, 'Kouzla', 'spell', '', '', '', 'Spell', 'spell', '', '', '0000-00-00 00:00:00', 0), 33 (14, 'Rozhraní klienta', 'global_strings', '', '', '', '', '', 'GlobalStrings', 'Interface/FrameXML', '0000-00-00 00:00:00', 0), 34 (15, 'Rozhraní klienta 2', 'glue_strings', '', '', '', '', '', 'GlueStrings', 'Interface/GlueXML', '0000-00-00 00:00:00', 0), 35 (16, 'Možnosti NPC', 'npc_option', 'mangos', 'npc_option', 'id', '', '', '', '', '0000-00-00 00:00:00', 0), 36 (17, 'Doprava', 'transports', 'mangos', 'transports', 'entry', '', '', '', '', '0000-00-00 00:00:00', 0), 37 (18, 'Krčmy', 'areatrigger_tavern', 'mangos', 'areatrigger_tavern', 'id', '', '', '', '', '0000-00-00 00:00:00', 0), 38 (19, 'Teleporty', 'areatrigger_teleport', 'mangos', 'areatrigger_teleport', 'id', '', '', '', '', '0000-00-00 00:00:00', 0), 39 (20, 'Úspěchy', 'achievement', '', '', '', 'Achievement', 'achievement', '', '', '0000-00-00 00:00:00', 0), 40 (21, 'Kategorie úspěchů', 'achievement_category', '', '', '', 'Achievement_Category', '', '', '', '0000-00-00 00:00:00', 0), 41 (22, 'Kritéria úspěchů', 'achievement_criteria', '', '', '', 'Achievement_Criteria', '', '', '', '0000-00-00 00:00:00', 0); 20 42 21 43 -- … … 23 45 -- 24 46 25 INSERT INTO `group_item` (`Id`, `Group`, `Name`, `Column`, `MangosColumn`, `AddonFileName`, `DBCColumnIndex`) VALUES 26 (1, 1, 'Titulek', 'Title', 'Title', '', 0), 27 (2, 1, 'Detaily', 'Details', 'Details', 'QuestDescription', 0), 28 (3, 1, 'Úkol', 'Objectives', 'Objectives', 'QuestObjective', 0), 29 (4, 1, 'Text slíbené odměny', 'OfferRewardText', 'OfferRewardText', 'QuestReward', 0), 30 (5, 1, 'Popis požadovaných předmětů', 'RequestItemsText', 'RequestItemsText', 'QuestProgress', 0), 31 (6, 1, 'Závěrečný text', 'EndText', 'EndText', '', 0), 32 (7, 1, 'Text úkolu 1', 'ObjectiveText1', 'ObjectiveText1', '', 0), 33 (8, 1, 'Text úkolu 2', 'ObjectiveText2', 'ObjectiveText2', '', 0), 34 (9, 1, 'Text úkolu 3', 'ObjectiveText3', 'ObjectiveText3', '', 0), 35 (10, 1, 'Text úkolu 4', 'ObjectiveText4', 'ObjectiveText4', '', 0), 36 (11, 2, 'Obsah', 'Text', 'Text', 'BookPage', 0), 37 (12, 3, 'Text 0.0', 'Text0_0', 'Text0_0', 'NPCText', 0), 38 (13, 3, 'Text 0.1', 'Text0_1', 'Text0_1', 'NPCAction', 0), 39 (14, 3, 'Text 1.0', 'Text1_0', 'Text1_0', '', 0), 40 (15, 3, 'Text 1.1', 'Text1_1', 'Text1_1', '', 0), 41 (16, 3, 'Text 2.0', 'Text2_0', 'Text2_0', '', 0), 42 (17, 3, 'Text 2.1', 'Text2_1', 'Text2_1', '', 0), 43 (18, 3, 'Text 3.0', 'Text3_0', 'Text3_0', '', 0), 44 (19, 3, 'Text 3.1', 'Text3_1', 'Text3_1', '', 0), 45 (20, 3, 'Text 4.0', 'Text4_0', 'Text4_0', '', 0), 46 (21, 3, 'Text 4.1', 'Text4_1', 'Text4_1', '', 0), 47 (22, 3, 'Text 5.0', 'Text5_0', 'Text5_0', '', 0), 48 (23, 3, 'Text 5.1', 'Text5_1', 'Text5_1', '', 0), 49 (24, 3, 'Text 6.0', 'Text6_0', 'Text6_0', '', 0), 50 (25, 3, 'Text 6.1', 'Text6_1', 'Text6_1', '', 0), 51 (26, 3, 'Text 7.0', 'Text7_0', 'Text7_0', '', 0), 52 (27, 3, 'Text 7.1', 'Text7_1', 'Text7_1', '', 0), 53 (28, 4, 'Jméno', 'Name', 'Name', '', 0), 54 (29, 4, 'Popis', 'Description', 'Description', '', 0), 55 (30, 5, 'Jméno', 'Name', 'Name', '', 0), 56 (31, 5, 'Popisek', 'castbarcaption', 'castbarcaption', '', 0), 57 (32, 6, 'Jméno', 'name', 'name', '', 0), 58 (33, 6, 'Druhé jméno', 'subname', 'subname', '', 0), 59 (34, 7, 'Obsah', 'content_default', 'content_default', '', 0), 60 (35, 8, 'Nápověda', 'help', 'help', '', 0), 61 (36, 9, 'Text', 'Text', '', '', 0), 62 (38, 10, 'Výchozí obsah', 'content_default', 'content_default', 'Creature', 0), 63 (39, 10, 'Komentář', 'comment', 'comment', '', 0), 64 (40, 11, 'Výchozí obsah', 'content_default', 'content_default', 'Creature', 0), 65 (41, 11, 'Komentář', 'comment', 'comment', '', 0), 66 (42, 12, 'Text', 'Text', '', '', 1), 67 (43, 13, 'Název', 'Name', '', '', 139), 68 (46, 13, 'Popis', 'Description', '', '', 173), 69 (44, 13, 'Hodnost', 'Rank', '', '', 156), 70 (45, 13, 'Popisek', 'ToolTip', '', '', 190); 47 INSERT INTO `group_item` (`Id`, `Group`, `Name`, `Column`, `Visible`, `MangosColumn`, `AddonFileName`) VALUES 48 (1, 1, 'Titulek', 'Title', 1, 'Title', ''), 49 (2, 1, 'Detaily', 'Details', 1, 'Details', 'QuestDescription'), 50 (3, 1, 'Úkol', 'Objectives', 1, 'Objectives', 'QuestObjective'), 51 (4, 1, 'Text slíbené odměny', 'OfferRewardText', 1, 'OfferRewardText', 'QuestReward'), 52 (5, 1, 'Popis požadovaných předmětů', 'RequestItemsText', 1, 'RequestItemsText', 'QuestProgress'), 53 (6, 1, 'Závěrečný text', 'EndText', 1, 'EndText', ''), 54 (7, 1, 'Text úkolu 1', 'ObjectiveText1', 1, 'ObjectiveText1', ''), 55 (8, 1, 'Text úkolu 2', 'ObjectiveText2', 1, 'ObjectiveText2', ''), 56 (9, 1, 'Text úkolu 3', 'ObjectiveText3', 1, 'ObjectiveText3', ''), 57 (10, 1, 'Text úkolu 4', 'ObjectiveText4', 1, 'ObjectiveText4', ''), 58 (11, 2, 'Obsah', 'Text', 1, 'text', 'BookPage'), 59 (12, 3, 'Text 0.0', 'Text0_0', 1, 'text0_0', 'NPCText'), 60 (13, 3, 'Text 0.1', 'Text0_1', 1, 'text0_1', 'NPCAction'), 61 (14, 3, 'Text 1.0', 'Text1_0', 1, 'text1_0', ''), 62 (15, 3, 'Text 1.1', 'Text1_1', 1, 'text1_1', ''), 63 (16, 3, 'Text 2.0', 'Text2_0', 1, 'text2_0', ''), 64 (17, 3, 'Text 2.1', 'Text2_1', 1, 'text2_1', ''), 65 (18, 3, 'Text 3.0', 'Text3_0', 1, 'text3_0', ''), 66 (19, 3, 'Text 3.1', 'Text3_1', 1, 'text3_1', ''), 67 (20, 3, 'Text 4.0', 'Text4_0', 1, 'text4_0', ''), 68 (21, 3, 'Text 4.1', 'Text4_1', 1, 'text4_1', ''), 69 (22, 3, 'Text 5.0', 'Text5_0', 1, 'text5_0', ''), 70 (23, 3, 'Text 5.1', 'Text5_1', 1, 'text5_1', ''), 71 (24, 3, 'Text 6.0', 'Text6_0', 1, 'text6_0', ''), 72 (25, 3, 'Text 6.1', 'Text6_1', 1, 'text6_1', ''), 73 (26, 3, 'Text 7.0', 'Text7_0', 1, 'text7_0', ''), 74 (27, 3, 'Text 7.1', 'Text7_1', 1, 'text7_1', ''), 75 (28, 4, 'Jméno', 'Name', 1, 'name', ''), 76 (29, 4, 'Popis', 'Description', 1, 'description', ''), 77 (30, 5, 'Jméno', 'Name', 1, 'name', ''), 78 (31, 5, 'Popisek', 'castbarcaption', 1, 'castBarCaption', ''), 79 (32, 6, 'Jméno', 'name', 1, 'name', ''), 80 (33, 6, 'Druhé jméno', 'subname', 1, 'subname', ''), 81 (34, 7, 'Obsah', 'content_default', 1, 'content_default', ''), 82 (35, 8, 'Nápověda', 'help', 1, 'help', ''), 83 (38, 10, 'Výchozí obsah', 'content_default', 1, 'content_default', 'Creature'), 84 (39, 10, 'Komentář', 'comment', 1, 'comment', ''), 85 (40, 11, 'Výchozí obsah', 'content_default', 1, 'content_default', 'Creature'), 86 (41, 11, 'Komentář', 'comment', 1, 'comment', ''), 87 (42, 12, 'Text', 'Text', 1, '', ''), 88 (43, 13, 'Název', 'Name', 1, '', ''), 89 (46, 13, 'Popis', 'Description', 1, '', ''), 90 (44, 13, 'Hodnost', 'Rank', 1, '', ''), 91 (45, 13, 'Popisek', 'ToolTip', 1, '', ''), 92 (47, 14, 'Text', 'Text', 1, '', ''), 93 (48, 14, 'Komentář', 'Comment', 1, '', ''), 94 (49, 15, 'Text', 'Text', 1, '', ''), 95 (50, 15, 'Komentář', 'Comment', 1, '', ''), 96 (51, 14, 'Zkratka', 'ShortCut', 0, '', ''), 97 (52, 15, 'Zkratka', 'ShortCut', 0, '', ''), 98 (53, 8, 'Name', 'Name', 0, 'name', ''), 99 (54, 16, 'Text možnosti', 'OptionText', 1, 'option_text', ''), 100 (55, 17, 'Jméno', 'Name', 1, 'name', ''), 101 (56, 18, 'Jméno', 'Name', 1, 'name', ''), 102 (57, 19, 'Jméno', 'Name', 1, 'name', ''), 103 (58, 20, 'Název', 'Name', 1, '', ''), 104 (59, 20, 'Popis', 'Description', 1, '', ''), 105 (60, 20, 'Odměna', 'Reward', 1, '', ''), 106 (61, 21, 'Název', 'Name', 1, '', ''), 107 (62, 22, 'Kritérium', 'Text', 1, '', ''); 108 109 -- 110 -- Vypisuji data pro tabulku `wow_client_version` 111 -- 112 113 INSERT INTO `wow_client_version` (`Id`, `Version`, `BuildNumber`, `ReleaseDate`, `Title`, `DBCColumns_GameTips`, `DBCColumns_Spell`, `GameTips_Text`, `Spell_Name`, `Spell_Description`, `Spell_Rank`, `Spell_ToolTip`, `DBCColumns_Achievement`, `DBCColumns_Achievement_Category`, `DBCColumns_Achievement_Criteria`, `Achievement_Name`, `Achievement_Description`, `Achievement_Reward`, `Achievement_Category_Name`, `Achievement_Criteria_Text`) VALUES 114 (1, '3.1.3', 9947, '2009-06-02', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 139, 173, 156, 190, 'uuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuu', 'uusuuuuuuuuuuuuuuuuu', 'uuuuuuuuusuuuuuuuuuuuuuuuuuuuuu', 4, 21, 43, 2, 9), 115 (2, '3.1.2', 9901, '2009-05-15', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 116 (3, '3.1.1a', 9835, '2009-04-28', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 117 (4, '3.1.1', 9806, '2009-04-21', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 118 (5, '3.1.0', 9767, '2009-04-14', 'Secrets of Ulduar', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 119 (6, '3.0.9', 9551, '2009-02-10', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuusuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuussssssssssssssssussssssssssssssssussssssssssssssssussssssssssssssssuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 130, 164, 147, 181, '', '', '', 0, 0, 0, 0, 0), 120 (7, '3.0.8a', 9506, '2009-01-27', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 121 (8, '3.0.8', 9464, '2009-01-20', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 122 (9, '3.0.3', 9183, '2008-11-04', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuussssssssssssssssussssssssssssssssussssssssssssssssussssssssssssssssuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 139, 173, 156, 190, '', '', '', 0, 0, 0, 0, 0), 123 (10, '3.0.2', 9056, '2009-10-14', 'Echoes of Doom', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 124 (11, '2.4.3', 8606, '2008-07-15', '', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuussuuuuussssssssssssssssussssssssssssssssussssssssssssssssussssssssssssssssuuuuuuuuuuuuuuussuuuuu', 1, 127, 161, 144, 178, '', '', '', 0, 0, 0, 0, 0), 125 (12, '2.4.2', 8209, '2008-06-13', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 126 (13, '2.4.1', 8125, '2008-04-01', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 127 (14, '2.4.0', 8089, '2008-03-25', 'Fury of the Sunwell', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 128 (15, '2.3.3', 7799, '2008-01-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 129 (16, '2.3.2', 7741, '2008-01-08', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 130 (17, '2.3.0', 7561, '2007-11-13', 'The Gods of Zul''Aman', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 131 (18, '2.2.3', 7359, '2007-10-09', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 132 (19, '2.2.2', 7318, '2007-10-02', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 133 (20, '2.2.0', 7272, '2007-09-25', 'Voice Chat!', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 134 (21, '2.1.3', 6898, '2007-07-10', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 135 (22, '2.1.2', 6803, '2007-06-19', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 136 (23, '2.1.1', 6739, '2007-06-05', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 137 (24, '2.1.0a', 6729, '2007-05-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 138 (25, '2.1.0', 6692, '2007-05-22', 'The Black Temple', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 139 (26, '2.0.12', 6546, '2007-04-03', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 140 (27, '2.0.10', 6448, '2007-03-06', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 141 (28, '2.0.8', 6403, '2007-02-16', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 142 (29, '2.0.7', 6383, '2007-02-13', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 143 (30, '2.0.6', 6337, '2007-01-23', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 144 (31, '2.0.5', 6320, '2007-01-14', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 145 (32, '2.0.4', 6320, '2007-01-12', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 146 (33, '2.0.3', 6299, '2007-01-09', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 147 (34, '2.0.1', 6180, '2006-12-05', 'Before the Storm', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 148 (35, '1.12.2', 6005, '2006-11-13', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 149 (36, '1.12.1', 5875, '2006-09-26', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 150 (37, '1.12.0', 5595, '2006-09-22', 'Drums of War', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 151 (38, '1.11.2', 5464, '2006-07-11', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 152 (39, '1.11.1', 5462, '2006-06-28', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 153 (40, '1.11.0', 5428, '2006-06-20', 'Shadow of the Necropolis', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 154 (41, '1.10.2', 5302, '2006-05-02', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 155 (42, '1.10.1', 5230, '2006-04-11', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 156 (43, '1.10.0', 5195, '2006-03-28', 'Storms of Azeroth', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 157 (44, '1.9.4', 5086, '2006-03-14', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 158 (45, '1.9.3', 5059, '2006-02-07', 'Love is in the Air', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 159 (46, '1.9.2', 4996, '2006-01-12', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 160 (47, '1.9.1', 4983, '2006-01-10', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 161 (48, '1.9.0', 4937, '2006-01-03', 'The Gates of Ahn''Qiraj', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 162 (49, '1.8.4', 4878, '2005-12-05', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 163 (50, '1.8.3', 4807, '2005-11-15', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 164 (51, '1.8.2', 4784, '2005-10-27', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 165 (52, '1.8.1', 4769, '2005-10-25', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 166 (53, '1.8.0', 4735, '2005-10-10', 'Dragons of Nightmare', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 167 (54, '1.7.1', 4695, '2005-09-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 168 (55, '1.7.0', 4671, '2006-09-13', 'Rise of the Blood God', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 169 (56, '1.6.1', 4544, '2005-08-02', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 170 (57, '1.6.0', 4500, '2005-07-12', 'Assault on Blackwing Lair', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 171 (58, '1.5.1', 4449, '2005-06-14', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 172 (59, '1.5.0', 4442, '2005-06-07', 'Battlegrounds', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 173 (60, '1.4.2', 4375, '2005-05-03', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 174 (61, '1.4.1', 4364, '2005-05-03', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 175 (62, '1.4.0', 4341, '2005-04-08', 'The Call to War', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 176 (63, '1.3.2', 4299, '2005-03-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 177 (64, '1.3.1', 4297, '2005-03-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 178 (65, '1.3.0', 4284, '2005-03-07', 'Ruins of the Dire Maul', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 179 (66, '1.2.4', 4222, '2005-02-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 180 (67, '1.2.3', 4211, '2005-02-22', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 181 (68, '1.2.2', 4196, '2005-02-15', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 182 (69, '1.2.1', 4150, '2004-12-21', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 183 (70, '1.2.0', 4149, '2004-12-18', 'Mysteries of Maraudon', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 184 (71, '1.1.2', 4125, '2004-12-06', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 185 (72, '1.1.1', 4062, '2004-11-17', '', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 186 (73, '1.1.0', 4044, '2004-11-07', 'World of Warcraft', '', '', 0, 0, 0, 0, 0, '', '', '', 0, 0, 0, 0, 0), 187 (74, '3.2.0', 10192, '2009-08-08', 'Call of the Crusade', 'usuuuuuuuuuuuuuuuu', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu', 1, 142, 176, 159, 193, 'uuuusuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuuuuusuuuuuuuuuuuuuuuuuu', 'uusuuuuuuuuuuuuuuuuu', 'uuuuuuuuusuuuuuuuuuuuuuuuuuuuuu', 4, 21, 43, 2, 9); -
trunk/sql/structure.sql
r138 r284 1 -- phpMyAdmin SQL Dump 2 -- version 3.2.3 3 -- http://www.phpmyadmin.net 4 -- 5 -- Počítač: localhost 6 -- Vygenerováno: Pátek 11. prosince 2009, 11:26 7 -- Verze MySQL: 5.0.84 8 -- Verze PHP: 5.2.9 9 10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 11 12 -- 13 -- Databáze: `wowpreklad` 14 -- 15 16 -- -------------------------------------------------------- 17 18 -- 19 -- Struktura tabulky `achievement` 20 -- 21 22 CREATE TABLE IF NOT EXISTS `achievement` ( 23 `ID` int(11) unsigned NOT NULL auto_increment, 24 `entry` int(11) NOT NULL, 25 `Language` int(11) NOT NULL default '0', 26 `User` int(11) NOT NULL, 27 `Complete` int(11) NOT NULL, 28 `Take` int(11) NOT NULL, 29 `Name` text NOT NULL, 30 `Description` text NOT NULL, 31 `Reward` text NOT NULL, 32 `VersionStart` int(11) NOT NULL default '8606', 33 `VersionEnd` int(11) NOT NULL default '8606', 34 PRIMARY KEY (`ID`), 35 KEY `entry` (`entry`), 36 KEY `User` (`User`), 37 KEY `Take` (`Take`), 38 KEY `Language` (`Language`), 39 KEY `Complete` (`Complete`), 40 KEY `VersionStart` (`VersionStart`), 41 KEY `VersionEnd` (`VersionEnd`) 42 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 43 44 -- -------------------------------------------------------- 45 46 -- 47 -- Struktura tabulky `achievement_category` 48 -- 49 50 CREATE TABLE IF NOT EXISTS `achievement_category` ( 51 `ID` int(11) unsigned NOT NULL auto_increment, 52 `entry` int(11) NOT NULL, 53 `Language` int(11) NOT NULL default '0', 54 `User` int(11) NOT NULL, 55 `Complete` int(11) NOT NULL, 56 `Take` int(11) NOT NULL, 57 `Name` text NOT NULL, 58 `VersionStart` int(11) NOT NULL default '8606', 59 `VersionEnd` int(11) NOT NULL default '8606', 60 PRIMARY KEY (`ID`), 61 KEY `entry` (`entry`), 62 KEY `User` (`User`), 63 KEY `Take` (`Take`), 64 KEY `Language` (`Language`), 65 KEY `Complete` (`Complete`), 66 KEY `VersionStart` (`VersionStart`), 67 KEY `VersionEnd` (`VersionEnd`) 68 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 69 70 -- -------------------------------------------------------- 71 72 -- 73 -- Struktura tabulky `achievement_criteria` 74 -- 75 76 CREATE TABLE IF NOT EXISTS `achievement_criteria` ( 77 `ID` int(11) unsigned NOT NULL auto_increment, 78 `entry` int(11) NOT NULL, 79 `Language` int(11) NOT NULL default '0', 80 `User` int(11) NOT NULL, 81 `Complete` int(11) NOT NULL, 82 `Take` int(11) NOT NULL, 83 `Text` text NOT NULL, 84 `VersionStart` int(11) NOT NULL default '8606', 85 `VersionEnd` int(11) NOT NULL default '8606', 86 PRIMARY KEY (`ID`), 87 KEY `entry` (`entry`), 88 KEY `User` (`User`), 89 KEY `Take` (`Take`), 90 KEY `Language` (`Language`), 91 KEY `Complete` (`Complete`), 92 KEY `VersionStart` (`VersionStart`), 93 KEY `VersionEnd` (`VersionEnd`) 94 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 95 96 -- -------------------------------------------------------- 97 98 -- 99 -- Struktura tabulky `areatrigger_tavern` 100 -- 101 102 CREATE TABLE IF NOT EXISTS `areatrigger_tavern` ( 103 `ID` int(11) unsigned NOT NULL auto_increment, 104 `entry` int(11) NOT NULL, 105 `Language` int(11) NOT NULL default '0', 106 `User` int(11) NOT NULL, 107 `Complete` int(11) NOT NULL, 108 `Take` int(11) NOT NULL, 109 `Name` text NOT NULL, 110 `VersionStart` int(11) NOT NULL default '8606', 111 `VersionEnd` int(11) NOT NULL default '8606', 112 PRIMARY KEY (`ID`), 113 KEY `entry` (`entry`), 114 KEY `User` (`User`), 115 KEY `Take` (`Take`), 116 KEY `Language` (`Language`), 117 KEY `Complete` (`Complete`), 118 KEY `VersionStart` (`VersionStart`), 119 KEY `VersionEnd` (`VersionEnd`) 120 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=72 ; 121 122 -- -------------------------------------------------------- 123 124 -- 125 -- Struktura tabulky `areatrigger_teleport` 126 -- 127 128 CREATE TABLE IF NOT EXISTS `areatrigger_teleport` ( 129 `ID` int(11) unsigned NOT NULL auto_increment, 130 `entry` int(11) NOT NULL, 131 `Language` int(11) NOT NULL default '0', 132 `User` int(11) NOT NULL, 133 `Complete` int(11) NOT NULL, 134 `Take` int(11) NOT NULL, 135 `Name` text NOT NULL, 136 `VersionStart` int(11) NOT NULL default '8606', 137 `VersionEnd` int(11) NOT NULL default '8606', 138 PRIMARY KEY (`ID`), 139 KEY `entry` (`entry`), 140 KEY `User` (`User`), 141 KEY `Take` (`Take`), 142 KEY `Language` (`Language`), 143 KEY `Complete` (`Complete`), 144 KEY `VersionStart` (`VersionStart`), 145 KEY `VersionEnd` (`VersionEnd`) 146 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=162 ; 147 148 -- -------------------------------------------------------- 149 150 -- 151 -- Struktura tabulky `banner` 152 -- 153 1 154 CREATE TABLE IF NOT EXISTS `banner` ( 2 155 `DateFirst` datetime NOT NULL, 3 156 `DateLast` datetime NOT NULL, 4 `Web` varchar(255) c haracter set utf8 collate utf8_czech_ci NOT NULL,157 `Web` varchar(255) collate utf8_czech_ci NOT NULL, 5 158 `Show` int(11) NOT NULL default '1', 6 `Description` text collate latin2_czech_cs NOT NULL, 159 `Description` text collate utf8_czech_ci NOT NULL, 160 `LastURL` varchar(255) collate utf8_czech_ci NOT NULL, 7 161 UNIQUE KEY `Web` (`Web`), 8 162 KEY `Show` (`Show`) 9 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs; 10 11 -- -------------------------------------------------------- 12 13 -- 14 -- Struktura tabulky `client` 15 -- 16 17 CREATE TABLE IF NOT EXISTS `client` ( 18 `ID` int(11) unsigned NOT NULL auto_increment, 19 `entry` int(11) unsigned NOT NULL, 20 `Text` text character set latin2 collate latin2_czech_cs, 21 `id_text` text character set latin2 collate latin2_czech_cs, 22 `File` int(11) NOT NULL default '0', 23 `Language` int(11) NOT NULL default '0', 24 `User` int(11) NOT NULL, 25 `Complete` int(11) NOT NULL, 26 `Take` int(11) NOT NULL, 27 PRIMARY KEY (`ID`), 28 KEY `entry` (`entry`), 29 KEY `Language` (`Language`), 30 KEY `User` (`User`), 31 KEY `Take` (`Take`), 32 KEY `Complete` (`Complete`) 33 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12394 ; 163 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci; 164 165 -- -------------------------------------------------------- 166 167 -- 168 -- Struktura tabulky `connexion` 169 -- 170 171 CREATE TABLE IF NOT EXISTS `connexion` ( 172 `Id` int(11) NOT NULL auto_increment, 173 `Name` text NOT NULL, 174 `Group` int(11) NOT NULL, 175 PRIMARY KEY (`Id`), 176 KEY `Group` (`Group`) 177 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 178 179 -- -------------------------------------------------------- 180 181 -- 182 -- Struktura tabulky `connexion_item` 183 -- 184 185 CREATE TABLE IF NOT EXISTS `connexion_item` ( 186 `Id` int(11) NOT NULL auto_increment, 187 `connexion` int(11) NOT NULL, 188 `entry` int(11) NOT NULL, 189 PRIMARY KEY (`Id`), 190 KEY `connexion` (`connexion`,`entry`) 191 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 34 192 35 193 -- -------------------------------------------------------- … … 48 206 `Complete` int(11) NOT NULL, 49 207 `Take` int(11) NOT NULL, 50 PRIMARY KEY (`ID`), 51 KEY `entry` (`entry`), 52 KEY `User` (`User`), 53 KEY `Take` (`Take`), 54 KEY `Complete` (`Complete`), 55 KEY `Language` (`Language`) 56 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=52707 ; 208 `VersionStart` int(11) NOT NULL default '8606', 209 `VersionEnd` int(11) NOT NULL default '8606', 210 PRIMARY KEY (`ID`), 211 KEY `entry` (`entry`), 212 KEY `User` (`User`), 213 KEY `Take` (`Take`), 214 KEY `Complete` (`Complete`), 215 KEY `Language` (`Language`), 216 KEY `VersionStart` (`VersionStart`), 217 KEY `VersionEnd` (`VersionEnd`) 218 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=52811 ; 57 219 58 220 -- -------------------------------------------------------- … … 64 226 CREATE TABLE IF NOT EXISTS `dictionary` ( 65 227 `ID` int(11) NOT NULL auto_increment, 66 `AJWord` text character set latin2 collate latin2_czech_cs NOT NULL, 67 `CZWord` text character set latin2 collate latin2_czech_cs NOT NULL, 68 `description` text character set latin2 collate latin2_czech_cs NOT NULL, 69 `user` int(11) NOT NULL, 70 PRIMARY KEY (`ID`) 71 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ; 228 `Entry` int(11) NOT NULL, 229 `Text` varchar(255) NOT NULL, 230 `Language` int(11) NOT NULL, 231 `Description` text NOT NULL, 232 `User` int(11) NOT NULL, 233 PRIMARY KEY (`ID`), 234 KEY `Entry` (`Entry`), 235 KEY `Language` (`Language`) 236 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=157 ; 72 237 73 238 -- -------------------------------------------------------- … … 86 251 `Complete` int(11) NOT NULL, 87 252 `Take` int(11) NOT NULL, 88 PRIMARY KEY (`ID`), 89 KEY `entry` (`entry`), 90 KEY `User` (`User`), 91 KEY `Take` (`Take`), 92 KEY `Complete` (`Complete`), 93 KEY `Language` (`Language`) 94 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35956 ; 253 `VersionStart` int(11) NOT NULL default '8606', 254 `VersionEnd` int(11) NOT NULL default '8606', 255 PRIMARY KEY (`ID`), 256 KEY `entry` (`entry`), 257 KEY `User` (`User`), 258 KEY `Take` (`Take`), 259 KEY `Complete` (`Complete`), 260 KEY `Language` (`Language`), 261 KEY `VersionStart` (`VersionStart`), 262 KEY `VersionEnd` (`VersionEnd`) 263 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=58959 ; 95 264 96 265 -- -------------------------------------------------------- … … 108 277 `Complete` int(11) NOT NULL, 109 278 `Take` int(11) NOT NULL, 110 PRIMARY KEY (`ID`), 111 KEY `entry` (`entry`), 112 KEY `User` (`User`), 113 KEY `Take` (`Take`), 114 KEY `Language` (`Language`), 115 KEY `Complete` (`Complete`) 116 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=189 ; 279 `VersionStart` int(11) NOT NULL default '8606', 280 `VersionEnd` int(11) NOT NULL default '8606', 281 PRIMARY KEY (`ID`), 282 KEY `entry` (`entry`), 283 KEY `User` (`User`), 284 KEY `Take` (`Take`), 285 KEY `Language` (`Language`), 286 KEY `Complete` (`Complete`), 287 KEY `VersionStart` (`VersionStart`), 288 KEY `VersionEnd` (`VersionEnd`) 289 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=262 ; 117 290 118 291 -- -------------------------------------------------------- … … 126 299 `entry` int(11) NOT NULL, 127 300 `Language` int(11) NOT NULL default '0', 128 `Vote` float NOT NULL, 129 `CountVote` int(11) NOT NULL, 130 `User` int(11) NOT NULL, 131 `Complete` int(11) NOT NULL, 132 `Take` int(11) NOT NULL, 133 `ShortCut` text NOT NULL, 301 `User` int(11) NOT NULL, 302 `Complete` int(11) NOT NULL, 303 `Take` int(11) NOT NULL, 304 `ShortCut` varchar(255) NOT NULL, 134 305 `Text` text NOT NULL, 135 306 `Comment` text NOT NULL, 136 PRIMARY KEY (`ID`), 137 KEY `entry` (`entry`), 138 KEY `User` (`User`), 139 KEY `Take` (`Take`), 140 KEY `Language` (`Language`), 141 KEY `Complete` (`Complete`) 142 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7700 ; 307 `VersionStart` int(11) NOT NULL default '8606', 308 `VersionEnd` int(11) NOT NULL default '8606', 309 PRIMARY KEY (`ID`), 310 KEY `entry` (`entry`), 311 KEY `User` (`User`), 312 KEY `Take` (`Take`), 313 KEY `Language` (`Language`), 314 KEY `Complete` (`Complete`), 315 KEY `ShortCut` (`ShortCut`), 316 KEY `VersionStart` (`VersionStart`), 317 KEY `VersionEnd` (`VersionEnd`) 318 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8126 ; 143 319 144 320 -- -------------------------------------------------------- … … 152 328 `entry` int(11) NOT NULL, 153 329 `Language` int(11) NOT NULL default '0', 154 `Vote` float NOT NULL, 155 `CountVote` int(11) NOT NULL, 156 `User` int(11) NOT NULL, 157 `Complete` int(11) NOT NULL, 158 `Take` int(11) NOT NULL, 159 `ShortCut` text NOT NULL, 330 `User` int(11) NOT NULL, 331 `Complete` int(11) NOT NULL, 332 `Take` int(11) NOT NULL, 333 `ShortCut` varchar(255) NOT NULL, 160 334 `Text` text NOT NULL, 161 335 `Comment` text NOT NULL, 162 PRIMARY KEY (`ID`), 163 KEY `entry` (`entry`), 164 KEY `User` (`User`), 165 KEY `Take` (`Take`), 166 KEY `Language` (`Language`), 167 KEY `Complete` (`Complete`) 168 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=713 ; 336 `VersionStart` int(11) NOT NULL default '8606', 337 `VersionEnd` int(11) NOT NULL default '8606', 338 PRIMARY KEY (`ID`), 339 KEY `entry` (`entry`), 340 KEY `User` (`User`), 341 KEY `Take` (`Take`), 342 KEY `Language` (`Language`), 343 KEY `Complete` (`Complete`), 344 KEY `ShortCut` (`ShortCut`), 345 KEY `VersionStart` (`VersionStart`), 346 KEY `VersionEnd` (`VersionEnd`) 347 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=773 ; 169 348 170 349 -- -------------------------------------------------------- … … 182 361 `MangosTableIndex` varchar(255) collate utf8_czech_ci NOT NULL, 183 362 `DBCFileName` varchar(255) collate utf8_czech_ci NOT NULL, 184 `DBCColumns` text collate utf8_czech_ci NOT NULL,185 363 `WowheadName` varchar(255) collate utf8_czech_ci NOT NULL, 186 364 `LuaFileName` varchar(255) collate utf8_czech_ci NOT NULL, 365 `LuaMPQFolder` varchar(255) collate utf8_czech_ci NOT NULL, 366 `LastImport` datetime NOT NULL, 367 `LastVersion` int(11) NOT NULL, 187 368 PRIMARY KEY (`Id`) 188 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 16;369 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=23 ; 189 370 190 371 -- -------------------------------------------------------- … … 199 380 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 200 381 `Column` varchar(255) collate utf8_czech_ci NOT NULL, 382 `Visible` tinyint(1) NOT NULL default '1', 201 383 `MangosColumn` varchar(255) collate utf8_czech_ci NOT NULL, 202 384 `AddonFileName` varchar(255) collate utf8_czech_ci NOT NULL, 203 `DBCColumnIndex` int(11) NOT NULL default '0',204 385 PRIMARY KEY (`Id`) 205 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 51;386 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=63 ; 206 387 207 388 -- -------------------------------------------------------- … … 220 401 `Complete` int(11) NOT NULL, 221 402 `Take` int(11) NOT NULL, 222 PRIMARY KEY (`ID`), 223 KEY `entry` (`entry`), 224 KEY `User` (`User`), 225 KEY `Take` (`Take`), 226 KEY `Complete` (`Complete`), 227 KEY `Language` (`Language`) 228 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=62909 ; 403 `VersionStart` int(11) NOT NULL default '8606', 404 `VersionEnd` int(11) NOT NULL default '8606', 405 PRIMARY KEY (`ID`), 406 KEY `entry` (`entry`), 407 KEY `User` (`User`), 408 KEY `Take` (`Take`), 409 KEY `Complete` (`Complete`), 410 KEY `Language` (`Language`), 411 KEY `VersionStart` (`VersionStart`), 412 KEY `VersionEnd` (`VersionEnd`) 413 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=63050 ; 414 415 -- -------------------------------------------------------- 416 417 -- 418 -- Struktura tabulky `language` 419 -- 420 421 CREATE TABLE IF NOT EXISTS `language` ( 422 `Id` int(11) NOT NULL auto_increment, 423 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 424 `Enabled` tinyint(1) NOT NULL default '1', 425 PRIMARY KEY (`Id`) 426 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 ; 229 427 230 428 -- -------------------------------------------------------- … … 242 440 `IP` text character set latin2 collate latin2_czech_cs NOT NULL, 243 441 PRIMARY KEY (`ID`), 244 KEY `user` (`user`) 245 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14592 ; 442 KEY `user` (`user`), 443 KEY `type` (`type`), 444 KEY `date` (`date`) 445 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=45181 ; 246 446 247 447 -- -------------------------------------------------------- … … 259 459 `Complete` int(11) NOT NULL, 260 460 `Take` int(11) NOT NULL, 261 PRIMARY KEY (`ID`), 262 KEY `entry` (`entry`), 263 KEY `User` (`User`), 264 KEY `Take` (`Take`), 265 KEY `Complete` (`Complete`), 266 KEY `Language` (`Language`) 267 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 461 `Name` varchar(255) NOT NULL, 462 `VersionStart` int(11) NOT NULL default '8606', 463 `VersionEnd` int(11) NOT NULL default '8606', 464 PRIMARY KEY (`ID`), 465 KEY `entry` (`entry`), 466 KEY `User` (`User`), 467 KEY `Take` (`Take`), 468 KEY `Complete` (`Complete`), 469 KEY `Language` (`Language`), 470 KEY `Name` (`Name`), 471 KEY `VersionStart` (`VersionStart`), 472 KEY `VersionEnd` (`VersionEnd`) 473 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=297 ; 268 474 269 475 -- -------------------------------------------------------- … … 281 487 `Complete` int(11) NOT NULL, 282 488 `Take` int(11) NOT NULL, 283 PRIMARY KEY (`ID`), 284 KEY `entry` (`entry`), 285 KEY `User` (`User`), 286 KEY `Take` (`Take`), 287 KEY `Complete` (`Complete`), 288 KEY `Language` (`Language`) 289 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1878 ; 489 `VersionStart` int(11) NOT NULL default '8606', 490 `VersionEnd` int(11) NOT NULL default '8606', 491 PRIMARY KEY (`ID`), 492 KEY `entry` (`entry`), 493 KEY `User` (`User`), 494 KEY `Take` (`Take`), 495 KEY `Complete` (`Complete`), 496 KEY `Language` (`Language`), 497 KEY `VersionStart` (`VersionStart`), 498 KEY `VersionEnd` (`VersionEnd`) 499 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2045 ; 290 500 291 501 -- -------------------------------------------------------- … … 301 511 `Text` text NOT NULL, 302 512 PRIMARY KEY (`Id`) 303 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 8;513 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ; 304 514 305 515 -- -------------------------------------------------------- … … 332 542 `Complete` int(11) NOT NULL, 333 543 `Take` int(11) NOT NULL, 334 PRIMARY KEY (`ID`), 335 KEY `entry` (`entry`), 336 KEY `User` (`User`), 337 KEY `Take` (`Take`), 338 KEY `Complete` (`Complete`), 339 KEY `Language` (`Language`) 340 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779072 ; 544 `VersionStart` int(11) NOT NULL default '8606', 545 `VersionEnd` int(11) NOT NULL default '8606', 546 PRIMARY KEY (`ID`), 547 KEY `entry` (`entry`), 548 KEY `User` (`User`), 549 KEY `Take` (`Take`), 550 KEY `Complete` (`Complete`), 551 KEY `Language` (`Language`), 552 KEY `VersionStart` (`VersionStart`), 553 KEY `VersionEnd` (`VersionEnd`) 554 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779127 ; 555 556 -- -------------------------------------------------------- 557 558 -- 559 -- Struktura tabulky `npc_option` 560 -- 561 562 CREATE TABLE IF NOT EXISTS `npc_option` ( 563 `ID` int(11) unsigned NOT NULL auto_increment, 564 `entry` int(11) NOT NULL, 565 `Language` int(11) NOT NULL default '0', 566 `User` int(11) NOT NULL, 567 `Complete` int(11) NOT NULL, 568 `Take` int(11) NOT NULL, 569 `OptionText` text NOT NULL, 570 `VersionStart` int(11) NOT NULL default '8606', 571 `VersionEnd` int(11) NOT NULL default '8606', 572 PRIMARY KEY (`ID`), 573 KEY `entry` (`entry`), 574 KEY `User` (`User`), 575 KEY `Take` (`Take`), 576 KEY `Language` (`Language`), 577 KEY `Complete` (`Complete`), 578 KEY `VersionStart` (`VersionStart`), 579 KEY `VersionEnd` (`VersionEnd`) 580 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ; 341 581 342 582 -- -------------------------------------------------------- … … 354 594 `Complete` int(11) NOT NULL, 355 595 `Take` int(11) NOT NULL, 356 PRIMARY KEY (`ID`), 357 KEY `entry` (`entry`), 358 KEY `User` (`User`), 359 KEY `Take` (`Take`), 360 KEY `Complete` (`Complete`), 361 KEY `Language` (`Language`) 362 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1746 ; 596 `VersionStart` int(11) NOT NULL default '8606', 597 `VersionEnd` int(11) NOT NULL default '8606', 598 PRIMARY KEY (`ID`), 599 KEY `entry` (`entry`), 600 KEY `User` (`User`), 601 KEY `Take` (`Take`), 602 KEY `Complete` (`Complete`), 603 KEY `Language` (`Language`), 604 KEY `VersionStart` (`VersionStart`), 605 KEY `VersionEnd` (`VersionEnd`) 606 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1783 ; 363 607 364 608 -- -------------------------------------------------------- … … 385 629 `Complete` int(11) NOT NULL default '1', 386 630 `Take` int(11) NOT NULL, 631 `VersionStart` int(11) NOT NULL default '8606', 632 `VersionEnd` int(11) NOT NULL default '8606', 387 633 PRIMARY KEY (`ID`), 388 634 KEY `entry` (`entry`), 389 635 KEY `User` (`User`), 390 636 KEY `complete` (`Complete`), 391 KEY `Language` (`Language`) 392 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10730 ; 637 KEY `Language` (`Language`), 638 KEY `VersionStart` (`VersionStart`), 639 KEY `VersionEnd` (`VersionEnd`) 640 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10862 ; 393 641 394 642 -- -------------------------------------------------------- … … 407 655 `Complete` int(11) NOT NULL, 408 656 `Take` int(11) NOT NULL, 409 PRIMARY KEY (`ID`), 410 KEY `entry` (`entry`), 411 KEY `User` (`User`), 412 KEY `Take` (`Take`), 413 KEY `Complete` (`Complete`), 414 KEY `Language` (`Language`) 415 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=410 ; 657 `VersionStart` int(11) NOT NULL default '8606', 658 `VersionEnd` int(11) NOT NULL default '8606', 659 PRIMARY KEY (`ID`), 660 KEY `entry` (`entry`), 661 KEY `User` (`User`), 662 KEY `Take` (`Take`), 663 KEY `Complete` (`Complete`), 664 KEY `Language` (`Language`), 665 KEY `VersionStart` (`VersionStart`), 666 KEY `VersionEnd` (`VersionEnd`) 667 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=413 ; 416 668 417 669 -- -------------------------------------------------------- … … 430 682 `Complete` int(11) NOT NULL, 431 683 `Take` int(11) NOT NULL, 432 PRIMARY KEY (`ID`), 433 KEY `entry` (`entry`), 434 KEY `User` (`User`), 435 KEY `Take` (`Take`), 436 KEY `Complete` (`Complete`), 437 KEY `Language` (`Language`) 438 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1117 ; 684 `VersionStart` int(11) NOT NULL default '8606', 685 `VersionEnd` int(11) NOT NULL default '8606', 686 PRIMARY KEY (`ID`), 687 KEY `entry` (`entry`), 688 KEY `User` (`User`), 689 KEY `Take` (`Take`), 690 KEY `Complete` (`Complete`), 691 KEY `Language` (`Language`), 692 KEY `VersionStart` (`VersionStart`), 693 KEY `VersionEnd` (`VersionEnd`) 694 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1149 ; 439 695 440 696 -- -------------------------------------------------------- … … 451 707 `IP` text character set latin2 collate latin2_czech_cs NOT NULL, 452 708 PRIMARY KEY (`ID`) 453 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 47;709 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=460 ; 454 710 455 711 -- -------------------------------------------------------- … … 470 726 `Complete` int(11) NOT NULL, 471 727 `Take` int(11) NOT NULL, 472 PRIMARY KEY (`ID`), 473 KEY `entry` (`entry`), 474 KEY `User` (`User`), 475 KEY `Take` (`Take`), 476 KEY `Language` (`Language`), 477 KEY `Complete` (`Complete`) 478 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=42086 ; 728 `VersionStart` int(11) NOT NULL default '8606', 729 `VersionEnd` int(11) NOT NULL default '8606', 730 PRIMARY KEY (`ID`), 731 KEY `entry` (`entry`), 732 KEY `User` (`User`), 733 KEY `Take` (`Take`), 734 KEY `Language` (`Language`), 735 KEY `Complete` (`Complete`), 736 KEY `VersionStart` (`VersionStart`), 737 KEY `VersionEnd` (`VersionEnd`) 738 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=42268 ; 739 740 -- -------------------------------------------------------- 741 742 -- 743 -- Struktura tabulky `tasks` 744 -- 745 746 CREATE TABLE IF NOT EXISTS `tasks` ( 747 `id` int(11) NOT NULL auto_increment, 748 `User` int(11) NOT NULL, 749 `ExportSetting` text NOT NULL, 750 `Active` int(11) NOT NULL default '1', 751 `Downloaded` int(11) NOT NULL default '0', 752 `Date` datetime NOT NULL, 753 PRIMARY KEY (`id`), 754 KEY `User` (`User`) 755 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; 756 757 -- -------------------------------------------------------- 758 759 -- 760 -- Struktura tabulky `team` 761 -- 762 763 CREATE TABLE IF NOT EXISTS `team` ( 764 `ID` int(11) NOT NULL auto_increment, 765 `name` text character set utf8 collate utf8_czech_ci NOT NULL, 766 `description` text character set utf8 collate utf8_czech_ci NOT NULL, 767 PRIMARY KEY (`ID`) 768 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ; 769 770 -- -------------------------------------------------------- 771 772 -- 773 -- Struktura tabulky `transports` 774 -- 775 776 CREATE TABLE IF NOT EXISTS `transports` ( 777 `ID` int(11) unsigned NOT NULL auto_increment, 778 `entry` int(11) NOT NULL, 779 `Language` int(11) NOT NULL default '0', 780 `User` int(11) NOT NULL, 781 `Complete` int(11) NOT NULL, 782 `Take` int(11) NOT NULL, 783 `Name` text NOT NULL, 784 `VersionStart` int(11) NOT NULL default '8606', 785 `VersionEnd` int(11) NOT NULL default '8606', 786 PRIMARY KEY (`ID`), 787 KEY `entry` (`entry`), 788 KEY `User` (`User`), 789 KEY `Take` (`Take`), 790 KEY `Language` (`Language`), 791 KEY `Complete` (`Complete`), 792 KEY `VersionStart` (`VersionStart`), 793 KEY `VersionEnd` (`VersionEnd`) 794 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; 479 795 480 796 -- -------------------------------------------------------- … … 491 807 `LastIP` text character set latin2 collate latin2_czech_cs NOT NULL, 492 808 `LastLogin` datetime NOT NULL default '0000-00-00 00:00:00', 809 `LastLogout` datetime default NULL, 493 810 `Email` text character set latin2 collate latin2_czech_cs NOT NULL, 494 811 `Language` int(11) NOT NULL default '1', … … 496 813 `XP` int(11) NOT NULL, 497 814 `NeedUpdate` int(11) NOT NULL, 498 PRIMARY KEY (`ID`) 499 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=551 ; 500 501 ALTER TABLE `user` ADD `team` INT NOT NULL ; 502 503 ALTER TABLE `user` ADD INDEX ( `team` ) ; 504 505 506 -- -------------------------------------------------------- 507 508 -- 509 -- Struktura tabulky `team` 510 -- 511 512 CREATE TABLE IF NOT EXISTS `team` ( 513 `ID` int(11) NOT NULL auto_increment, 514 `name` text NOT NULL, 515 `description` text NOT NULL, 516 PRIMARY KEY (`ID`) 517 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; 518 519 ALTER TABLE `team` CHANGE `name` `name` TEXT CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL , 520 CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL 521 815 `team` int(11) NOT NULL, 816 `redirecting` int(11) NOT NULL, 817 PRIMARY KEY (`ID`), 818 KEY `team` (`team`), 819 KEY `user` (`user`) 820 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=564 ; 821 822 -- -------------------------------------------------------- 823 824 -- 825 -- Struktura tabulky `verseclient` 826 -- 522 827 523 828 CREATE TABLE IF NOT EXISTS `verseclient` ( … … 530 835 KEY `user` (`user`) 531 836 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 ; 837 838 -- -------------------------------------------------------- 839 840 -- 841 -- Struktura tabulky `wow_client_version` 842 -- 843 844 CREATE TABLE IF NOT EXISTS `wow_client_version` ( 845 `Id` int(11) NOT NULL auto_increment, 846 `Version` varchar(16) NOT NULL, 847 `BuildNumber` int(11) NOT NULL, 848 `ReleaseDate` date NOT NULL, 849 `Title` varchar(255) NOT NULL, 850 `DBCColumns_GameTips` varchar(255) NOT NULL, 851 `DBCColumns_Spell` varchar(255) NOT NULL, 852 `GameTips_Text` int(11) NOT NULL, 853 `Spell_Name` int(11) NOT NULL, 854 `Spell_Description` int(11) NOT NULL, 855 `Spell_Rank` int(11) NOT NULL, 856 `Spell_ToolTip` int(11) NOT NULL, 857 `DBCColumns_Achievement` text NOT NULL, 858 `DBCColumns_Achievement_Category` text NOT NULL, 859 `DBCColumns_Achievement_Criteria` text NOT NULL, 860 `Achievement_Name` int(11) NOT NULL, 861 `Achievement_Description` int(11) NOT NULL, 862 `Achievement_Reward` int(11) NOT NULL, 863 `Achievement_Category_Name` int(11) NOT NULL, 864 `Achievement_Criteria_Text` int(11) NOT NULL, 865 PRIMARY KEY (`Id`) 866 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=75 ; -
trunk/team.php
r252 r284 11 11 echo('<h3>Seznam překladatelských týmů</h3>'); 12 12 13 if(array_key_exists('Page', $_GET)) $_SESSION['Page'] = $_GET['Page'];14 else if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 1;15 13 if(array_key_exists('Order', $_GET)) $_SESSION['Order'] = $_GET['Order']; 16 14 else if(!array_key_exists('Order', $_SESSION)) $_SESSION['Order'] = 'numberuser'; 17 15 if(array_key_exists('Desc', $_GET)) $_SESSION['Desc'] = $_GET['Desc']; 18 16 else if(!array_key_exists('Desc', $_SESSION)) $_SESSION['Desc'] = ''; 19 ListPaging('?Page=', 'team', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']); 17 18 $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `team`'); 19 $DbRow = mysql_fetch_row($DbResult); 20 $PageList = GetPageList($DbRow[0]); 21 22 echo($PageList['Output']); 20 23 echo('<table class="BaseTable">'); 21 24 … … 52 55 echo('</tr>'); 53 56 54 $ID = $Database->SQLCommand('SELECT *, (SELECT COUNT(*) FROM user WHERE user.team = team.ID) AS numberuser FROM team '.$_SESSION['search'].' ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage']);57 $ID = $Database->SQLCommand('SELECT *, (SELECT COUNT(*) FROM user WHERE user.team = team.ID) AS numberuser FROM team '.$_SESSION['search'].' ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' '.$PageList['SQLLimit']); 55 58 while($Line = mysql_fetch_assoc($ID)) 56 59 { … … 62 65 } 63 66 echo('</table>'); 64 65 ListPaging('?Page=', 'team', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']);67 echo($PageList['Output']); 68 66 69 if(Licence(LICENCE_USER)) echo('<br /><div style="text-align: center;"><a href="?action=create">Vytvořit překladatelský tým</a></div>'); 67 70 } -
trunk/userlist.php
r247 r284 8 8 9 9 echo('<h3>Seznam uživatelů</h3>'); 10 if(array_key_exists('Page', $_GET)) $_SESSION['Page'] = $_GET['Page'];11 else if(!array_key_exists('Page', $_SESSION)) $_SESSION['Page'] = 1;12 10 if(array_key_exists('Order', $_GET)) $_SESSION['Order'] = $_GET['Order']; 13 11 else if(!array_key_exists('Order', $_SESSION)) $_SESSION['Order'] = 'NumberTranslate'; … … 32 30 //if($_SESSION['Where'] <> '') echo(' <a href="?action=nofilter">Zrušit filtr uživatelů</a><br />'); 33 31 34 ListPaging('?Page=', 'user', $_SESSION['Where'], $Config['Web']['ItemsPerPage'], $_SESSION['Page']); 32 $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `user`'.$_SESSION['Where']); 33 $DbRow = mysql_fetch_row($DbResult); 34 $PageList = GetPageList($DbRow[0]); 35 36 echo($PageList['Output']); 35 37 echo('<table class="BaseTable">'); 36 38 … … 57 59 } 58 60 59 $Query = 'SELECT ID, user.user, LastLogin, GM, ('.substr($Columns, 0, -3).') as NumberTranslate FROM `user`'.$Joins.' '.$_SESSION['Where'].' ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage'];61 $Query = 'SELECT ID, user.user, LastLogin, GM, ('.substr($Columns, 0, -3).') as NumberTranslate FROM `user`'.$Joins.' '.$_SESSION['Where'].' ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' '.$PageList['SQLLimit']; 60 62 61 63 $ID = $Database->SQLCommand($Query); … … 73 75 } 74 76 echo('</table>'); 75 ListPaging('?Page=', 'user', $_SESSION['Where'], $Config['Web']['ItemsPerPage'], $_SESSION['Page']);77 echo($PageList['Output']); 76 78 77 79 ShowFooter(); -
trunk/version.php
r201 r284 5 5 ShowPage(); 6 6 7 $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `wow_client_version`'); 8 $DbRow = mysql_fetch_row($DbResult); 9 $PageList = GetPageList($DbRow[0]); 10 7 11 echo('<h3>Verze hry</h3>'); 12 echo($PageList['Output']); 8 13 echo('<table class="BaseTable"><tr><th>Verze</th><th>Sestavení</th><th>Datum uvolnění</th><th>Titulek</th></tr>'); 9 $DbResult = $Database->SQLCommand('SELECT * FROM wow_client_version ORDER BY BuildNumber DESC ');14 $DbResult = $Database->SQLCommand('SELECT * FROM wow_client_version ORDER BY BuildNumber DESC '.$PageList['SQLLimit']); 10 15 while($Version = mysql_fetch_assoc($DbResult)) 11 16 { … … 13 18 } 14 19 echo('</table>'); 20 echo($PageList['Output']); 15 21 16 22 ShowFooter();
Note:
See TracChangeset
for help on using the changeset viewer.
