Changeset 366


Ignore:
Timestamp:
Mar 9, 2010, 1:01:14 PM (15 years ago)
Author:
george
Message:
  • Upraveno: Přejmenovány všechny tabulky textů na názvy s prvními velkými písmeny ve slovech plus pro odlišení s prefixem Text.
  • Upraveno: Další SQL dotazy doplněny o SQL uvozovky.
Location:
trunk
Files:
1 added
1 deleted
19 edited

Legend:

Unmodified
Added
Removed

  • trunk/TranslationList.php

    r365 r366  
    187187  global $Database;
    188188 
    189   $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `group`');
     189  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `Group`');
    190190  $DbRow = mysql_fetch_row($DbResult);
    191191  $PageList = GetPageList($DbRow[0]); 
    … …  
    206206  echo($Order['Output']);
    207207
    208   $ID = $Database->SQLCommand('SELECT * FROM `group`'.$Order['SQL'].$PageList['SQLLimit']);
     208  $ID = $Database->SQLCommand('SELECT * FROM `Group`'.$Order['SQL'].$PageList['SQLLimit']);
    209209  while($Group = mysql_fetch_assoc($ID))
    210210  {

  • trunk/action.php

    r365 r366  
    3131    $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `Team` WHERE `Name` LIKE "%'.$Search.'%" OR `Description` LIKE "%'.$Search.'%"'));
    3232  echo('<tr><td><a href="team.php?search='.$Search.'">Týmy</a></td><td>'.$Line[0].'</td></tr>');
    33     $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `verseclient` WHERE `text` LIKE "%'.$Search.'%"'));
     33    $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `CzWoWPackageVersion` WHERE `Text` LIKE "%'.$Search.'%"'));
    3434  echo('<tr><td><a href="download.php?addon">Čeština pro klienta</a></td><td>'.$Line[0].'</td></tr>');
    3535  echo('<tr><td><a href="aowow/?search='.$Search.'">Vyhledávací databáze AoWoW</a></td></tr>');

  • trunk/dictionary.php

    r365 r366  
    4141  foreach($TablesColumn as $Table => $Column)
    4242  { 
    43     $sql = 'SELECT `ID`,'.$Column.',(SELECT `Name` FROM '.$Table.' AS `T` WHERE `O`.`entry` = `T`.`entry` AND `Language` <> 0 LIMIT 1) AS `tran` FROM `'.$Table.'` AS `O` WHERE ';
     43    $sql = 'SELECT `ID`,'.$Column.',(SELECT `Name` FROM '.$Table.' AS `T` WHERE `O`.`Entry` = `T`.`Entry` AND `Language` <> 0 LIMIT 1) AS `Tran` FROM `'.$Table.'` AS `O` WHERE ';
    4444    $groupby = ' GROUP BY `'.$Column.'`';
    4545 
    4646    $ArrStr = explode(' ', $Text);
    47     $where = 'Language = 0 ';
    48     if ($mode == 1) $where .= ' AND EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = O.entry))';
    49     if ($mode == 2) $where .= ' AND NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = O.entry))';
     47    $where = '`Language` = 0 ';
     48    if ($mode == 1) $where .= ' AND EXISTS(SELECT 1 FROM `'.$Table.'` AS `Sub` WHERE (`Sub`.`Language` <> 0) AND (`Sub`.`Entry` = `O`.`Entry`))';
     49    if ($mode == 2) $where .= ' AND NOT EXISTS(SELECT 1 FROM `'.$Table.'` AS `Sub` WHERE (`Sub`.`Language` <> 0) AND (`Sub`.`Entry` = `O`.`Entry`))';
    5050    $where .= ' AND (';
    5151 

  • trunk/download.php

    r365 r366  
    3131   if (array_key_exists('createverse', $_GET) and Licence(LICENCE_ADMIN)) {
    3232    if (array_key_exists('verse', $_POST)) { //ukládání
    33         $Database->SQLCommand('INSERT INTO `verseclient` (`verse` ,`date` ,`text` ,`User`)
     33        $Database->SQLCommand('INSERT INTO `CzWoWPackageVersion` (`Version` ,`Date` ,`Text` ,`User`)
    3434                  VALUES ( "'.$_POST['verse'].'", NOW( ) , "'.$_POST['text'].'", "'.$_SESSION['UserID'].'");');
    3535      WriteLog('Nová verze ('.$_POST['verse'].') češtiny pro clienta uložena.', LOG_TYPE_MODERATOR);
    … …  
    4343      $Tables = 'Texty obsažené v addonu: Přeložené/nepřeložené  ProcentaPřeložených%
    4444        '; 
    45       foreach($ExportSetting['groups'] as $Index) $Tables .= GetPercentOfTable($Index,implode(',', $ExportSetting['users-selection']));
     45      foreach($ExportSetting['groups'] as $Index) $Tables .= GetPercentOfTable($Index, implode(',', $ExportSetting['users-selection']));
    4646     
    4747      $ID = $Database->SQLCommand('SELECT `Name` FROM `User` WHERE `ID` IN('.implode(',', $ExportSetting['users-selection']).')');
    … …  
    6262  echo('<br />Stažený soubor pouze rozbalte a zkopírujte do kořenové složky wow (C:\Program Files\World Of Warcraft\). Hru spouštějte přes soubor WoWME.exe <br /><br />'.
    6363  '<table  class="BaseTable"><tr><th>Verze/datum</th><th>Popis</th></tr>');
    64   $ID = $Database->SQLCommand('SELECT * FROM `verseclient` ORDER BY `Date` DESC');
     64  $ID = $Database->SQLCommand('SELECT * FROM `CzWoWPackageVersion` ORDER BY `Date` DESC');
    6565  while($Line = mysql_fetch_assoc($ID))
    6666  {
    6767    echo('<tr>'.
    68       '<td><strong>'.$Line['verse'].'</strong> <a href="tmp/Addon/CzWoW_'.$Line['verse'].'.zip">Stáhnout</a> <br />'.$Line['date'].'</td>'.
    69       '<td>'.str_replace(chr(13),'<br />',$Line['text']).'</td>');
     68      '<td><strong>'.$Line['Version'].'</strong> <a href="tmp/Addon/CzWoW_'.$Line['Version'].'.zip">Stáhnout</a> <br />'.$Line['Date'].'</td>'.
     69      '<td>'.str_replace("\r", '<br />', $Line['Text']).'</td>');
    7070    echo('</tr>');
    7171  }

  • trunk/export/create_addon.php

    r334 r366  
    104104    $CreatedFileListCount = array();
    105105 
    106     $DbResult = $this->Database->query('SELECT `group`.* FROM `ExportGroup` JOIN `group` ON `group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id.' AND `group`.`TablePrefix` != ""');
     106    $DbResult = $this->Database->query('SELECT `Group`.* FROM `ExportGroup` JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id.' AND `Group`.`TablePrefix` != ""');
    107107    while($Group = $DbResult->fetch_assoc())
    108108    {
    … …  
    123123        $Buffer = 'CZWOW_'.$Column['AddonFileName'].'_count='.$FileIndex.';CZWOW_'.$Column['AddonFileName'].'_'.$FileIndex.'={';
    124124   
    125         $Query = 'SELECT T2.'.$Column['Column'].' AS Translation, T3.'.$Column['Column'].' as Original FROM (SELECT T1.entry, T1.'.$Column['Column'].' FROM (SELECT entry,'.$Column['Column'].' FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND VersionStart <= '.$this->ClientVersion['BuildNumber'].' AND VersionEnd >= '.$this->ClientVersion['BuildNumber'].' AND '.$this->WhereLang.' AND '.$this->WhereUsers.$this->OrderByUserList.') AS T1 GROUP BY T1.entry) as T2 JOIN '.$Group['TablePrefix'].' AS T3 ON (T2.entry = T3.entry) AND (T3.Language = 0)';
     125        $Query = 'SELECT `T2`.`'.$Column['Column'].'` AS `Translation`, `T3`.`'.$Column['Column'].'` AS `Original` FROM (SELECT `T1`.`Entry`, `T1`.`'.$Column['Column'].'` FROM (SELECT `Entry`,`'.$Column['Column'].'` FROM `'.$Group['TablePrefix'].'` WHERE (`Complete` = 1) AND (`VersionStart` <= '.$this->ClientVersion['BuildNumber'].') AND (`VersionEnd` >= '.$this->ClientVersion['BuildNumber'].') AND '.$this->WhereLang.' AND '.$this->WhereUsers.$this->OrderByUserList.') AS `T1` GROUP BY `T1`.`Entry`) AS `T2` JOIN `'.$Group['TablePrefix'].'` AS `T3` ON (`T2`.`Entry` = `T3`.`Entry`) AND (`T3`.`Language` = 0)';
    126126        $DbResult2 = $this->Database->query($Query);
    127127       
    128128       
    129129        if ($this->Database->affected_rows == 0) {
    130                         $ID = $this->Database->query('SELECT MAX(`VersionEnd`) FROM `'.$Group['TablePrefix'].'`');
    131                         $BuildNumber_max = $ID->fetch_assoc();
    132                         $BuildNumber_max = $BuildNumber_max['MAX(`VersionEnd`)'];
    133                        
    134                         $Query = 'SELECT T2.'.$Column['Column'].' AS Translation, T3.'.$Column['Column'].' as Original FROM (SELECT T1.entry, T1.'.$Column['Column'].' FROM (SELECT entry,'.$Column['Column'].' FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND VersionStart <= '.$BuildNumber_max.' AND VersionEnd >= '.$BuildNumber_max.' AND '.$this->WhereLang.' AND '.$this->WhereUsers.$this->OrderByUserList.') AS T1 GROUP BY T1.entry) as T2 JOIN '.$Group['TablePrefix'].' AS T3 ON (T2.entry = T3.entry) AND (T3.Language = 0)';
     130      $ID = $this->Database->query('SELECT MAX(`VersionEnd`) FROM `'.$Group['TablePrefix'].'`');
     131      $BuildNumber_max = $ID->fetch_assoc();
     132      $BuildNumber_max = $BuildNumber_max['MAX(`VersionEnd`)'];
     133     
     134      $Query = 'SELECT `T2`.`'.$Column['Column'].'` AS `Translation`, `T3`.`'.$Column['Column'].'` AS `Original` FROM (SELECT `T1`.`Entry`, `T1`.`'.$Column['Column'].'` FROM (SELECT `Entry`,`'.$Column['Column'].'` FROM `'.$Group['TablePrefix'].'` WHERE (`Complete` = 1) AND (`VersionStart` <= '.$BuildNumber_max.') AND (`VersionEnd` >= '.$BuildNumber_max.') AND '.$this->WhereLang.' AND '.$this->WhereUsers.$this->OrderByUserList.') AS `T1` GROUP BY `T1`.`Entry`) AS `T2` JOIN `'.$Group['TablePrefix'].'` AS `T3` ON (`T2`.`Entry` = `T3`.`Entry`) AND (`T3`.`Language` = 0)';
    135135            $DbResult2 = $this->Database->query($Query);
    136                         
    137                 }
     136      
     137    }
    138138       
    139139        while($Line = $DbResult2->fetch_assoc())
    … …  
    202202  function MakeReadme()
    203203  {
    204     $DbResult = $this->Database->query('SELECT * FROM verseclient ORDER BY DATE DESC');
     204    $DbResult = $this->Database->query('SELECT * FROM `CzWoWPackageVersion` ORDER BY `Date` DESC');
    205205    $Line = $DbResult->fetch_assoc();
    206206
    … …  
    216216 
    217217 Verze:
    218   Verze Addonu: '.$Line['verse'].'
     218  Verze Addonu: '.$Line['Version'].'
    219219  Tato verze je pro verzi hry '.$this->ClientVersion['Version'].'
    220220 
    … …  
    222222 
    223223    ';
    224     $DbResult = $Database->query('SELECT * FROM verseclient ORDER BY DATE
    225 DESC');
     224    $DbResult = $Database->query('SELECT * FROM `CzWoWPackageVersion` ORDER BY `Date` DESC');
    226225    while($Line = $DbResult->fetch_assoc())
    227226    {
    228227      $Buffer .='
    229   Verze: '.$Line['verse'].'
     228  Verze: '.$Line['Version'].'
    230229  =============
    231230  '.$Line['text'].'

  • trunk/export/create_mpq.php

    r277 r366  
    22
    33//wine MPQEditor.exe /console script_create_mpq.txt
    4 echo (exec('wine MPQEditor.exe /console script_create_mpq.txt'));
    5 echo (exec('mkdir ../tmp/mpq'));
    6 echo ('hotovo');
     4echo(exec('wine MPQEditor.exe /console script_create_mpq.txt'));
     5echo(exec('mkdir ../tmp/mpq'));
     6echo('hotovo');
     7
    78?>

  • trunk/export/export.php

    r365 r366  
    6464
    6565
    66     $DbResult = $this->Database->query('SELECT * FROM `wow_client_version` WHERE `Id`='.$this->Export['ClientVersion']);
     66    $DbResult = $this->Database->query('SELECT * FROM `ClientVersion` WHERE `Id`='.$this->Export['ClientVersion']);
    6767    $this->ClientVersion = $DbResult->fetch_assoc();   
    6868  }
    … …  
    8686      "-- Generované tabulky: ";
    8787   
    88     $DbResult = $this->Database->query('SELECT `group`.* FROM `ExportGroup` JOIN `group` ON `group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
     88    $DbResult = $this->Database->query('SELECT `Group`.* FROM `ExportGroup` JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
    8989    while($Group = $DbResult->fetch_assoc())
    9090    {
    … …  
    9393    $Buffer .= "\n\n"; 
    9494
    95     $DbResult = $this->Database->query('SELECT `group`.* FROM `ExportGroup` JOIN `group` ON `group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
     95    $DbResult = $this->Database->query('SELECT `Group`.* FROM `ExportGroup` JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
    9696    while($Group = $DbResult->fetch_assoc())
    9797    {
    … …  
    195195    "  <translation>\n";
    196196
    197     $DbResult = $this->Database->query('SELECT `group`.* FROM `ExportGroup` JOIN `group` ON `group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
     197    $DbResult = $this->Database->query('SELECT `Group`.* FROM `ExportGroup` JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id);
    198198    while($Group = $DbResult->fetch_assoc())
    199199    {
    … …  
    233233    $this->LoadFilters();
    234234
    235     $DbResult = $this->Database->query('SELECT `group`.* FROM `ExportGroup` JOIN `group` ON `group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id.' AND `group`.`DBCFileName` != ""');
     235    $DbResult = $this->Database->query('SELECT `Group`.* FROM `ExportGroup` JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id.' AND `Group`.`DBCFileName` != ""');
    236236    while($Group = $DbResult->fetch_assoc())
    237237    {
    … …  
    278278    $this->LoadFilters();
    279279
    280     $DbResult = $this->Database->query('SELECT `group`.* FROM `ExportGroup` JOIN `group` ON `group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id.' AND `group`.`LuaFileName` != ""');
     280    $DbResult = $this->Database->query('SELECT `Group`.* FROM `ExportGroup` JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$this->Id.' AND `Group`.`LuaFileName` != ""');
    281281    while($Group = $DbResult->fetch_assoc())
    282282    {

  • trunk/export/export_output.php

    r357 r366  
    190190  if(array_key_exists('Regenerate', $_POST))
    191191  {
    192     $Database->SQLCommand('UPDATE ExportTask SET TimeStart = NOW(), TimeFinish = NULL');
     192    $Database->SQLCommand('UPDATE `ExportTask` SET `TimeStart` = NOW(), `TimeFinish` = NULL');
    193193    echo('Soubor zařazen znovu ke zpracování.<br/><br/>');
    194194  }
    195   $DbResult = $Database->SQLCommand('SELECT * FROM ExportTask WHERE Export = '.$ExportId);
     195  $DbResult = $Database->SQLCommand('SELECT * FROM `ExportTask` WHERE `Export` = '.$ExportId);
    196196  $ExportTask = mysql_fetch_assoc($DbResult);
    197197  if($ExportTask['TimeFinish'] > $ExportTask['TimeStart'])
    … …  
    201201    $Export->Id = $ExportId;
    202202    $Export->Init();
    203     $DbResult = $System->Database->query('SELECT `group`.* FROM `ExportGroup` JOIN `group` ON `group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$Export->Id.' AND `group`.`DBCFileName` != ""');
     203    $DbResult = $System->Database->query('SELECT `Group`.* FROM `ExportGroup` JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$Export->Id.' AND `Group`.`DBCFileName` != ""');
    204204    while($Group = $DbResult->fetch_assoc())
    205205    {
    … …  
    234234  echo('<strong>Soubory:</strong><br/>'. 
    235235    'Souhrný archív <a href="'.$SaveFilename.'">CzWoW_Lua.zip</a><br />');
    236   $DbResult = $System->Database->query('SELECT `group`.* FROM `ExportGroup` JOIN `group` ON `group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$Export->Id.' AND `group`.`LuaFileName` != ""');
     236  $DbResult = $System->Database->query('SELECT `Group`.* FROM `ExportGroup` JOIN `Group` ON `Group`.`Id` = `ExportGroup`.`Group` WHERE `ExportGroup`.`Export`='.$Export->Id.' AND `Group`.`LuaFileName` != ""');
    237237  while($Group = $DbResult->fetch_assoc())
    238238  {

  • trunk/export/index.php

    r365 r366  
    127127  if(array_key_exists('ExportId', $_GET))
    128128  {
    129     $DbRows = $Database->SQLCommand('SELECT * FROM Export WHERE Id='.$_GET['ExportId']);
     129    $DbRows = $Database->SQLCommand('SELECT * FROM `Export` WHERE `Id`='.$_GET['ExportId']);
    130130    if(mysql_num_rows($DbRows) > 0)
    131131    {   
    … …  
    148148          if(array_key_exists('sel'.$UserId, $_POST)) $Selected = true;
    149149            else $Selected = false;
    150           $Condition = ' WHERE Export='.$_GET['ExportId'].' AND User='.$UserId;
    151           $DbResult = $Database->SQLCommand('SELECT * FROM ExportUser '.$Condition);
     150          $Condition = ' WHERE `Export`='.$_GET['ExportId'].' AND `User`='.$UserId;
     151          $DbResult = $Database->SQLCommand('SELECT * FROM `ExportUser` '.$Condition);
    152152          if(mysql_num_rows($DbResult) > 0)
    153153          {
    154             if(!$Selected) $Database->SQLCommand('DELETE FROM ExportUser '.$Condition);
    155               else $Database->SQLCommand('UPDATE ExportUser SET Sequence='.$Value.$Condition);
     154            if(!$Selected) $Database->SQLCommand('DELETE FROM `ExportUser` '.$Condition);
     155              else $Database->SQLCommand('UPDATE `ExportUser` SET `Sequence`='.$Value.$Condition);
    156156          } else
    157157          {
    158             if($Selected) $Database->SQLCommand('INSERT INTO ExportUser (Export, User, Sequence) VALUES ('.$_GET['ExportId'].', '.$UserId.', '.$Value.')');
     158            if($Selected) $Database->SQLCommand('INSERT INTO `ExportUser` (`Export`, `User`, `Sequence`) VALUES ('.$_GET['ExportId'].', '.$UserId.', '.$Value.')');
    159159          }         
    160160        }
    … …  
    163163      // Recalculate sequence number
    164164      $Database->SQLCommand('SET @I = 0');
    165       $Database->SQLCommand('UPDATE ExportUser SET Sequence = (@I := @I + 1) WHERE Export='.$_GET['ExportId'].' ORDER BY Sequence;');
     165      $Database->SQLCommand('UPDATE `ExportUser` SET `Sequence` = (@I := @I + 1) WHERE `Export`='.$_GET['ExportId'].' ORDER BY `Sequence`;');
    166166    }
    167167  }
    168168
    169169  $TableColumns = array(
    170     array('Name' => 'user', 'Title' => 'Jméno'),
     170    array('Name' => 'Name', 'Title' => 'Jméno'),
    171171    array('Name' => 'TranslatedCount', 'Title' => 'Překladů'),
    172172    array('Name' => 'XP', 'Title' => 'Úroveň'),
    … …  
    201201  echo($Order['Output']);
    202202
    203   $Query = 'SELECT * FROM ('.$Query.') AS TX '.$Order['SQL'].$PageList['SQLLimit'];
     203  $Query = 'SELECT * FROM ('.$Query.') AS `TX` '.$Order['SQL'].$PageList['SQLLimit'];
    204204  $Database->SQLCommand('SET @I = 0');
    205205  $DbResult = $Database->SQLCommand($Query);
    … …  
    396396  }
    397397
    398   $Query = 'SELECT `group`.*, `ExportGroup`.`Id` AS `ExportGroupId` FROM `group` LEFT JOIN `ExportGroup` ON `ExportGroup`.`Export`='.$_GET['ExportId'].' AND `Group`=`group`.`Id`';
     398  $Query = 'SELECT `Group`.*, `ExportGroup`.`Id` AS `ExportGroupId` FROM `Group` LEFT JOIN `ExportGroup` ON `ExportGroup`.`Export`='.$_GET['ExportId'].' AND `Group`=`Group`.`Id`';
    399399
    400400  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM ('.$Query.') AS X');
    … …  
    505505  $Export = mysql_fetch_assoc($DbResult);
    506506
    507   $Query = 'SELECT `wow_client_version`.* FROM `ExportVersion` LEFT JOIN `wow_client_version` ON `wow_client_version`.`Id`=`ExportVersion`.`ClientVersion` WHERE `ExportType`='.$Export['OutputType'];
     507  $Query = 'SELECT `ClientVersion`.* FROM `ExportVersion` LEFT JOIN `ClientVersion` ON `ClientVersion`.`Id`=`ExportVersion`.`ClientVersion` WHERE `ExportType`='.$Export['OutputType'];
    508508
    509509  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM ('.$Query.') AS `X`');

  • trunk/export/process_aowow_export.php

    r365 r366  
    6464
    6565// Update news date
    66 $Database2->query("UPDATE `aowow_news` SET `text_loc0` = 'Poslední aktualizace dat ".Date ("d. n. Y, H:i:s")." ', `text_loc8` = 'Poslední aktualizace dat ".Date ("d. n. Y, H:i:s")." ' WHERE `aowow_news`.`id` =3");
     66$Database2->query('UPDATE `aowow_news` SET `text_loc0` = "Poslední aktualizace dat '.date('d. n. Y, H:i:s').'", `text_loc8` = "Poslední aktualizace dat '.date('d. n. Y, H:i:s').'" WHERE `aowow_news`.`id` =3');
    6767
    6868?>

  • trunk/export/process_task.php

    r357 r366  
    1212while(1)
    1313{
    14   $DbResult = $Database->SQLCommand('SELECT ExportTask.Export, Export.Id AS ExportId FROM ExportTask LEFT JOIN Export ON Export.Id = ExportTask.Export WHERE ExportTask.TimeFinish IS NULL');
     14  $DbResult = $Database->SQLCommand('SELECT `ExportTask`.`Export`, `Export`.`Id` AS `ExportId` FROM `ExportTask` LEFT JOIN `Export` ON `Export`.`Id` = `ExportTask`.`Export` WHERE `ExportTask`.`TimeFinish` IS NULL');
    1515  while($DbRow = mysql_fetch_assoc($DbResult))
    1616  {
    … …  
    3434          echo('Hotovo');
    3535        } else echo('Funkce pro tvorbu Zip souboru není podporována!');
    36         $Database->SQLCommand('UPDATE ExportTask SET TimeFinish=NOW() WHERE Export='.$Export->Id);
     36        $Database->SQLCommand('UPDATE `ExportTask` SET `TimeFinish`=NOW() WHERE `Export`='.$Export->Id);
    3737      } catch (Exception $e)
    3838      {
    … …  
    4141    } else
    4242    {
    43       $Database->SQLCommand('DELETE FROM ExportTask WHERE Export='.$DbRow['Export']);
     43      $Database->SQLCommand('DELETE FROM `ExportTask` WHERE `Export`='.$DbRow['Export']);
    4444      echo('Export '.$DbRow['Export'].' nenalezen. Jeho úloha smazána.'."\n");
    4545    }

  • trunk/import/cmd.php

    r357 r366  
    2020  if(strpos($parameter, '=') !== false)
    2121  {
    22     $index = substr($parameter,0,strpos($parameter, '='));
    23   $parameter = substr($parameter,strpos($parameter, '=')+1);
    24   //echo ($index.'  ----  '.$parameter);
     22    $index = substr($parameter, 0, strpos($parameter, '='));
     23    $parameter = substr($parameter, strpos($parameter, '=') + 1);
     24    //echo ($index.'  ----  '.$parameter);
    2525    $_GET[$index] = $parameter;
    2626  }

  • trunk/import/import_dbc.php

    r365 r366  
    11<?php
    2 /*
    3 DELETE FROM `gametips` WHERE ID > 266;
    4 DELETE FROM `spell` WHERE ID > 43672;
    5 UPDATE `gametips` SET VersionStart = 8606,VersionEnd = 8606;
    6 UPDATE `spell` SET VersionStart = 8606,VersionEnd = 8606;
    7 DELETE FROM `Log` WHERE Type = 11;
    8 */ 
    9  
    102
    11 
    12 function ImportDBC($import_version,$GroupId)
     3function ImportDBC($import_version, $GroupId)
    134{
    145  global $Database, $TranslationTree, $Config;
     6 
    157  $BuildNumber = GetBuildNumber($import_version);
    168
    179  echo('Načítání textů z DBC souborů...');
    1810  $Group = $TranslationTree[$GroupId];
    19     if(($Group['DBCFileName'] != '') and ($Group['TablePrefix'] != ''))
    20     {
    21       echo('<br />'.$Group['Name'].'<br />');
     11  if(($Group['DBCFileName'] != '') and ($Group['TablePrefix'] != ''))
     12  {
     13    echo('<br />'.$Group['Name'].'<br />');
    2214    $DBCFile = new DBCFile();
    2315    $DBCFile->OpenFile('../source/'.$import_version.'/dbc/'.$Group['DBCFileName'].'.dbc', GetDBCColumns($import_version,$Group['DBCFileName']));
    … …  
    2618    $Count = 0;
    2719    for($i = 0; $i < $ItemCount; $i++)
     20    {
     21      foreach($Group['Items'] as $GroupItem)
    2822      {
    29         foreach($Group['Items'] as $GroupItem)
    30         {
    31           $Value[$GroupItem['Column']] = addslashes($DBCFile->GetString($i, GetDBCColumnIndex($import_version,$Group['DBCFileName'],$GroupItem['Column'])));
    32         }
     23        $Value[$GroupItem['Column']] = addslashes($DBCFile->GetString($i, GetDBCColumnIndex($import_version,$Group['DBCFileName'],$GroupItem['Column'])));
     24      }
    3325   
    34         $Columns = '';
    35         foreach($Group['Items'] as $GroupItem)
    36         {
    37           $Columns .= ', '.$GroupItem['Column'].' ';
    38         }
    39           $Columns = substr($Columns, 1);
     26      $Columns = '';
     27      foreach($Group['Items'] as $GroupItem)
     28      {
     29        $Columns .= ', '.$GroupItem['Column'].' ';
     30      }
     31      $Columns = substr($Columns, 1);
    4032   
    41         $ItemId = $DBCFile->GetUint($i, 0); 
    42         $DbResult2 = $Database->SQLCommand('SELECT VersionEnd, ID, entry, '.$Columns.' FROM '.$Group['TablePrefix'].' WHERE entry='.$ItemId.' AND Language=0 ORDER BY VersionStart DESC LIMIT 1');
    43         if(isset($DbResult2) and (mysql_num_rows($DbResult2) > 0))
     33      $ItemId = $DBCFile->GetUint($i, 0); 
     34      $DbResult2 = $Database->SQLCommand('SELECT `VersionEnd`, `ID`, `Entry`, '.$Columns.' FROM `'.$Group['TablePrefix'].'` WHERE `Entry`='.$ItemId.' AND `Language`=0 ORDER BY `VersionStart` DESC LIMIT 1');
     35      if(isset($DbResult2) and (mysql_num_rows($DbResult2) > 0))
    4436      {
    45             // Update existed text
    46             $DbRow2 = mysql_fetch_assoc($DbResult2);
    47             if(HaveSameText($Group, $DbRow2, $Value))
    48             {
    49         if ($DbRow2['VersionEnd'] <> $BuildNumber) {
    50                 $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET VersionEnd = "'.$BuildNumber.'" WHERE ID='.$DbRow2['ID']);
    51           echo(', ');
    52         } else
    53           echo('. ');
    54             } else
    55             {       
    56               $Columns = 'entry, language, VersionStart, VersionEnd';
    57               $Values = $DbRow2['entry'].', 0, '.$BuildNumber.', '.$BuildNumber;
    58               foreach($Group['Items'] as $GroupItem)
    59               {
    60                 $Columns .= ', `'.$GroupItem['Column'].'`';
    61                 $Values .= ', "'.$Value[$GroupItem['Column']].'"';
    62               }
    63               $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')');
    64               echo('# ');
    65               WriteLog('Text <a href="form.php?group='.$Group['Id'].'&amp;ID='.mysql_insert_id().'">'.mysql_insert_id().'</a> ('.$DbRow2['entry'].') ze skupiny '.$Group['Name'].' byl v nové verzi '.$import_version.' změněn.', LOG_TYPE_IMPORT);
    66             }       
    67      
     37        // Update existed text
     38        $DbRow2 = mysql_fetch_assoc($DbResult2);
     39        if(HaveSameText($Group, $DbRow2, $Value))
     40        {
     41          if ($DbRow2['VersionEnd'] <> $BuildNumber)
     42          {
     43            $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET `VersionEnd` = "'.$BuildNumber.'" WHERE `ID`='.$DbRow2['ID']);
     44            echo(', ');
     45          } else echo('. ');
     46        } else
     47        {       
     48          $Columns = '`Entry`, `Language`, `VersionStart`, `VersionEnd`';
     49          $Values = $DbRow2['entry'].', 0, '.$BuildNumber.', '.$BuildNumber;
     50          foreach($Group['Items'] as $GroupItem)
     51          {
     52            $Columns .= ', `'.$GroupItem['Column'].'`';
     53            $Values .= ', "'.$Value[$GroupItem['Column']].'"';
     54          }
     55          $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')');
     56          echo('# ');
     57          WriteLog('Text <a href="form.php?group='.$Group['Id'].'&amp;ID='.mysql_insert_id().'">'.mysql_insert_id().'</a> ('.$DbRow2['entry'].') ze skupiny '.$Group['Name'].' byl v nové verzi '.$import_version.' změněn.', LOG_TYPE_IMPORT);
     58        }             
    6859      } else
    6960      {   
    70             // Insert new text
    71             $Columns = 'entry, language, VersionStart, VersionEnd';
    72             $Values = $ItemId.', 0, '.$BuildNumber.', '.$BuildNumber;
    73             foreach($Group['Items'] as $GroupItem)
    74             {
    75               $Columns .= ', `'.$GroupItem['Column'].'`';
    76               $Values .= ', "'.$Value[$GroupItem['Column']].'"';
    77             }
    78             $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')');
    79             echo('+ ');
    80             $NewCount++;
    81             WriteLog('Text <a href="form.php?group='.$Group['Id'].'&amp;ID='.mysql_insert_id().'">'.mysql_insert_id().'</a> ('.$ItemId.') ze skupiny '.$Group['Name'].' byl v nové verzi '.$import_version.' přidán.', LOG_TYPE_IMPORT);
     61        // Insert new text
     62        $Columns = '`Entry`, `Language`, `VersionStart`, `VersionEnd`';
     63        $Values = $ItemId.', 0, '.$BuildNumber.', '.$BuildNumber;
     64        foreach($Group['Items'] as $GroupItem)
     65        {
     66          $Columns .= ', `'.$GroupItem['Column'].'`';
     67          $Values .= ', "'.$Value[$GroupItem['Column']].'"';
     68        }
     69        $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')');
     70        echo('+ ');
     71        $NewCount++;
     72        WriteLog('Text <a href="form.php?group='.$Group['Id'].'&amp;ID='.mysql_insert_id().'">'.mysql_insert_id().'</a> ('.$ItemId.') ze skupiny '.$Group['Name'].' byl v nové verzi '.$import_version.' přidán.', LOG_TYPE_IMPORT);
    8273   
    8374      }
    84         $Count++;
    85       }   
     75      $Count++;
     76    }   
    8677    echo('<br />Celkem: '.$Count.'  Nových: '.$NewCount.'<br />');
    87       $Database->SQLCommand('UPDATE `group` SET LastVersion = "'.$BuildNumber.'", LastImport = NOW() WHERE Id='.$GroupId);
     78    $Database->SQLCommand('UPDATE `Group` SET `LastVersion` = "'.$BuildNumber.'", `LastImport` = NOW() WHERE `Id`='.$GroupId);
    8879  }
    8980  echo('<strong>Dokončeno.</strong>');

  • trunk/import/import_lua.php

    r363 r366  
    3535          $Columns = substr($Columns, 1);
    3636
    37           $DbResult2 = $Database->SQLCommand('SELECT `VersionEnd`, `ID`, `entry`, '.$Columns.' FROM '.$Group['TablePrefix'].' WHERE `ShortCut`="'.$Value['ShortCut'].'" AND (`Language`=0) ORDER BY `VersionStart` DESC LIMIT 1');
     37          $DbResult2 = $Database->SQLCommand('SELECT `VersionEnd`, `ID`, `Entry`, '.$Columns.' FROM `'.$Group['TablePrefix'].'` WHERE `ShortCut`="'.$Value['ShortCut'].'" AND (`Language`=0) ORDER BY `VersionStart` DESC LIMIT 1');
    3838          if(isset($DbResult2) and (mysql_num_rows($DbResult2) > 0))
    3939          {
    … …  
    5050            } else
    5151            {       
    52               $Columns = '`entry`, `language`, `VersionStart`, `VersionEnd`';
    53               $Values = $DbRow2['entry'].', 0, '.$BuildNumber.', '.$BuildNumber;
     52              $Columns = '`Entry`, `Language`, `VersionStart`, `VersionEnd`';
     53              $Values = $DbRow2['Entry'].', 0, '.$BuildNumber.', '.$BuildNumber;
    5454              foreach($Group['Items'] as $GroupItem)
    5555              {
    … …  
    5959              $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')');
    6060              echo('# ');
    61               WriteLog('Text <a href="form.php?group='.$Group['Id'].'&amp;ID='.mysql_insert_id().'">'.mysql_insert_id().'</a> ('.$DbRow2['entry'].') ze skupiny '.$Group['Name'].' byl v nové verzi '.$import_version.' změněn.', LOG_TYPE_IMPORT);
     61              WriteLog('Text <a href="form.php?group='.$Group['Id'].'&amp;ID='.mysql_insert_id().'">'.mysql_insert_id().'</a> ('.$DbRow2['Entry'].') ze skupiny '.$Group['Name'].' byl v nové verzi '.$import_version.' změněn.', LOG_TYPE_IMPORT);
    6262            }       
    6363          } else
    … …  
    6565            // Insert new text
    6666            $Entry = 1;
    67             $DbResult = $Database->SQLCommand('SELECT MAX(`entry`) FROM `'.$Group['TablePrefix'].'`');
     67            $DbResult = $Database->SQLCommand('SELECT MAX(`Entry`) FROM `'.$Group['TablePrefix'].'`');
    6868            if(mysql_num_rows($DbResult) > 0)
    6969            {
    … …  
    7171              $Entry += $DbRow[0];
    7272            }           
    73             $Columns = '`entry`, `language`, `VersionStart`, `VersionEnd`';
     73            $Columns = '`Entry`, `Language`, `VersionStart`, `VersionEnd`';
    7474            $Values = $Entry.', 0, '.$BuildNumber.', '.$BuildNumber;
    7575            foreach($Group['Items'] as $GroupItem)
    … …  
    8787      }
    8888      echo('<br />Celkem: '.$Count.'  Nových: '.$NewCount.'<br />');
    89       $Database->SQLCommand('UPDATE `group` SET LastVersion = "'.$BuildNumber.'", LastImport = NOW() WHERE Id='.$Group['Id']);
     89      $Database->SQLCommand('UPDATE `Group` SET `LastVersion` = "'.$BuildNumber.'", `LastImport` = NOW() WHERE `Id`='.$Group['Id']);
    9090    }   
    9191  }

  • trunk/import/import_sql_mangos.php

    r357 r366  
    104104        $Columns = substr($Columns, 1);
    105105
    106         if($Group['Id'] == 8)$DbResult2 = $Database->SQLCommand('SELECT VersionEnd, ID, entry, '.$Columns.' FROM '.$Group['TablePrefix'].' WHERE Name="'.$Value['name'].'" AND (Language=0) ORDER BY VersionStart DESC LIMIT 1');
    107         else $DbResult2 = $Database->SQLCommand('SELECT VersionEnd, ID, entry, '.$Columns.' FROM '.$Group['TablePrefix'].' WHERE entry='.$Value[$Group['MangosTableIndex']].' AND (Language=0) ORDER BY VersionStart DESC LIMIT 1');
     106        if($Group['Id'] == 8)$DbResult2 = $Database->SQLCommand('SELECT `VersionEnd`, `ID`, `Entry`, '.$Columns.' FROM `'.$Group['TablePrefix'].'` WHERE `Name`="'.$Value['name'].'" AND (`Language`=0) ORDER BY `VersionStart` DESC LIMIT 1');
     107        else $DbResult2 = $Database->SQLCommand('SELECT `VersionEnd`, `ID`, `Entry`, '.$Columns.' FROM `'.$Group['TablePrefix'].'` WHERE `Entry`='.$Value[$Group['MangosTableIndex']].' AND (`Language`=0) ORDER BY `VersionStart` DESC LIMIT 1');
    108108        if(isset($DbResult2) and (mysql_num_rows($DbResult2) > 0))
    109109        {
    … …  
    114114            if ($DbRow2['VersionEnd'] <> $BuildNumber)
    115115            {
    116               $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET VersionEnd = "'.$BuildNumber.'" WHERE ID='.$DbRow2['ID']);
     116              $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET `VersionEnd` = "'.$BuildNumber.'" WHERE `ID`='.$DbRow2['ID']);
    117117              echo(', ');
    118118            } else echo('. ');
    119119          } else
    120120          {       
    121             $Columns = 'entry, language, VersionStart, VersionEnd';
    122             $Values = $DbRow2['entry'].', 0, '.$BuildNumber.', '.$BuildNumber;
     121            $Columns = '`Entry`, `Language`, `VersionStart`, `VersionEnd`';
     122            $Values = $DbRow2['Entry'].', 0, '.$BuildNumber.', '.$BuildNumber;
    123123            foreach($Group['Items'] as $GroupItem)
    124124            {
    … …  
    131131              $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')');
    132132              echo('# ');
    133               WriteLog('Text <a href="form.php?group='.$Group['Id'].'&amp;ID='.mysql_insert_id().'">'.mysql_insert_id().'</a> ('.$DbRow2['entry'].') ze skupiny '.$Group['Name'].' byl v nové verzi '.$import_version.' změněn.', LOG_TYPE_IMPORT);
     133              WriteLog('Text <a href="form.php?group='.$Group['Id'].'&amp;ID='.mysql_insert_id().'">'.mysql_insert_id().'</a> ('.$DbRow2['Entry'].') ze skupiny '.$Group['Name'].' byl v nové verzi '.$import_version.' změněn.', LOG_TYPE_IMPORT);
    134134            } else echo('. ');       
    135135          }       
    … …  
    141141          {
    142142            $Entry = 1;
    143             $DbResult = $Database->SQLCommand('SELECT MAX(`entry`) FROM `'.$Group['TablePrefix'].'`');
     143            $DbResult = $Database->SQLCommand('SELECT MAX(`Entry`) FROM `'.$Group['TablePrefix'].'`');
    144144            if(mysql_num_rows($DbResult) > 0)
    145145            {
    … …  
    151151          }
    152152
    153           $Columns = 'entry, language, VersionStart, VersionEnd';
     153          $Columns = '`Entry`, `Language`, `VersionStart`, `VersionEnd`';
    154154          $Values = $Entry.', 0, '.$BuildNumber.', '.$BuildNumber;
    155155          foreach($Group['Items'] as $GroupItem)
    … …  
    168168  }
    169169  echo('<br />Celkem: '.$Count.'  Nových: '.$NewCount.'<br />');
    170   $Database->SQLCommand('UPDATE `group` SET LastVersion = "'.$BuildNumber.'", LastImport = NOW() WHERE Id='.$GroupId);
     170  $Database->SQLCommand('UPDATE `Group` SET `LastVersion` = "'.$BuildNumber.'", `LastImport` = NOW() WHERE `Id`='.$GroupId);
    171171}
    172172

  • trunk/import/update_version.php

    r215 r366  
    99  {
    1010    echo('<br />'.$Group['Name'].' ');     
    11     $DbResult = $Database->SQLCommand('SELECT gs_tran.ID, gs_tran.VersionEnd AS VersionEnd_tran, gs_orig.VersionEnd AS VersionEnd_orig FROM '.$Group['TablePrefix'].' AS gs_tran JOIN '.$Group['TablePrefix'].' AS gs_orig ON gs_orig.ID = gs_tran.Take WHERE gs_tran.VersionEnd <> gs_orig.VersionEnd');
     11    $DbResult = $Database->SQLCommand('SELECT `gs_tran`.`ID`, `gs_tran`.`VersionEnd` AS `VersionEnd_tran`, `gs_orig`.`VersionEnd` AS `VersionEnd_orig` FROM `'.$Group['TablePrefix'].'` AS `gs_tran` JOIN `'.$Group['TablePrefix'].'` AS `gs_orig` ON `gs_orig`.`ID` = `gs_tran`.`Take` WHERE `gs_tran`.`VersionEnd` <> `gs_orig`.`VersionEnd`');
    1212    while($DbRow = mysql_fetch_assoc($DbResult))
    1313    {
    14       $Database->SQLCommand('UPDATE '.$Group['TablePrefix'].' SET VersionEnd = '.$DbRow['VersionEnd_orig'].' WHERE ID = '.$DbRow['ID']);
     14      $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET `VersionEnd` = '.$DbRow['VersionEnd_orig'].' WHERE `ID` = '.$DbRow['ID']);
    1515      echo('. ');
    1616    } 

  • trunk/includes/global_function.php

    r365 r366  
    256256 
    257257  $Result = array();
    258   $DbResult = $Database->SQLCommand('SELECT * FROM `group` ORDER BY `name`');
     258  $DbResult = $Database->SQLCommand('SELECT * FROM `Group` ORDER BY `Name`');
    259259  while($DbRow = mysql_fetch_assoc($DbResult))
    260260  {
    … …  
    262262    $Result[$DbRow['Id']] = $DbRow;
    263263  }
    264   $DbResult = $Database->SQLCommand('SELECT * FROM `group_item`');
     264  $DbResult = $Database->SQLCommand('SELECT * FROM `GroupItem`');
    265265  while($DbRow = mysql_fetch_assoc($DbResult))
    266266  {
    … …  
    378378  if(isset($BuildNumbers[$Version]) == false)
    379379  {
    380     $sql = 'SELECT `BuildNumber` FROM `wow_client_version` WHERE `Version` = "'.$Version.'"';
     380    $sql = 'SELECT `BuildNumber` FROM `ClientVersion` WHERE `Version` = "'.$Version.'"';
    381381    $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
    382382    $BuildNumbers[$Version] = $DbRow['BuildNumber'];
    … …  
    391391  if(isset($VersionsWOW[$BuildNumber]) == false)
    392392  {
    393     $sql = 'SELECT `Version` FROM `wow_client_version` WHERE `BuildNumber` = "'.$BuildNumber.'"';
     393    $sql = 'SELECT `Version` FROM `ClientVersion` WHERE `BuildNumber` = "'.$BuildNumber.'"';
    394394    $Version = mysql_fetch_assoc($Database->SQLCommand($sql));
    395395    $VersionsWOW[$BuildNumber] = $Version['Version'];
    … …  
    404404  if(isset($DBCColumns[$Version][$DBCFileName]) == false)
    405405  {
    406     $sql = 'SELECT `DBCColumns_'.$DBCFileName.'` AS `DBCColumns` FROM `wow_client_version` WHERE `Version` = "'.$Version.'"';
     406    $sql = 'SELECT `DBCColumns_'.$DBCFileName.'` AS `DBCColumns` FROM `ClientVersion` WHERE `Version` = "'.$Version.'"';
    407407    $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
    408408    $DBCColumns[$Version][$DBCFileName] = $DbRow['DBCColumns'];
    … …  
    417417  if(isset($DBCColumnIndex[$Version][$DBCFileName][$Column]) == false)
    418418  {
    419     $sql = 'SELECT `'.$DBCFileName.'_'.$Column.'` AS `DBCColumns` FROM `wow_client_version` WHERE `Version` = "'.$Version.'"';
     419    $sql = 'SELECT `'.$DBCFileName.'_'.$Column.'` AS `DBCColumns` FROM `ClientVersion` WHERE `Version` = "'.$Version.'"';
    420420    $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
    421421    $DBCColumnIndex[$Version][$DBCFileName][$Column] = $DbRow['DBCColumns'];

  • trunk/sql/updates/364.sql

    r365 r366  
    5151ALTER TABLE  `spell` CHANGE  `entry`  `Entry` INT( 11 ) NOT NULL;
    5252ALTER TABLE  `transports` CHANGE  `entry`  `Entry` INT( 11 ) NOT NULL;
    53 ALTER TABLE  `sd2_script_texts` CHANGE  `entry`  `Entry` INT( 11 ) NOT NULL;
    54 ALTER TABLE  `sd2_script_texts` CHANGE  `entry`  `Entry` INT( 11 ) NOT NULL;
    55 ALTER TABLE  `sd2_script_texts` CHANGE  `entry`  `Entry` INT( 11 ) NOT NULL;
    5653

  • trunk/version.php

    r295 r366  
    55ShowPage();
    66
    7 $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `wow_client_version`');
     7$DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `ClientVersion`');
    88$DbRow = mysql_fetch_row($DbResult);
    99$PageList = GetPageList($DbRow[0]);   
    … …  
    2222echo($Order['Output']);
    2323
    24 $DbResult = $Database->SQLCommand('SELECT * FROM wow_client_version '.$Order['SQL'].$PageList['SQLLimit']);
     24$DbResult = $Database->SQLCommand('SELECT * FROM ClientVersion '.$Order['SQL'].$PageList['SQLLimit']);
    2525while($Version = mysql_fetch_assoc($DbResult))
    2626{
Note: See TracChangeset for help on using the changeset viewer.