Changeset 444


Ignore:
Timestamp:
Apr 11, 2010, 1:23:53 PM (15 years ago)
Author:
george
Message:
  • Opraveno: Exportování všech zvolených skupin.
Location:
trunk
Files:
1 added
3 edited

Legend:

Unmodified
Added
Removed

  • trunk/export/export.php

    r443 r444  
    248248      {
    249249        // Load string column index list
    250         $DbResult = $this->Database->query('SELECT * FROM `GroupItem` JOIN `GroupItemDBC` ON `GroupItem`.`Id` = `GroupItemDBC`.`GroupItem` AND `GroupItemDBC`.`ClientVersion` = '.$this->ClientVersion['Id'].'  WHERE `GroupItem`.`Group` = '.$Group['Id']);     
     250        $DbResult2 = $this->Database->query('SELECT * FROM `GroupItem` JOIN `GroupItemDBC` ON `GroupItem`.`Id` = `GroupItemDBC`.`GroupItem` AND `GroupItemDBC`.`ClientVersion` = '.$this->ClientVersion['Id'].'  WHERE `GroupItem`.`Group` = '.$Group['Id']);     
    251251        $ColumnIndexes = array();
    252252        $ColumnFormat = array();
    253         while($DbRow = $DbResult->fetch_assoc())
     253        while($DbRow = $DbResult2->fetch_assoc())
    254254        {
    255255          $ColumnFormat[$DbRow['ColumnIndex']] = FORMAT_STRING;
    … …  
    283283        {
    284284          $Line = $SourceDBCFile->GetLine($Row);
    285           /*foreach($TranslationTree[$Group['Id']]['Items'] as $GroupItem)
     285          foreach($TranslationTree[$Group['Id']]['Items'] as $GroupItem)
    286286          {
    287287            if(array_key_exists($GroupItem['Id'], $ColumnIndexes) and array_key_exists($Row, $LookupTable))
    288288              $Line[$ColumnIndexes[$GroupItem['Id']]] = $LookupTable[$Row][$GroupItem['Column']];
    289289          }
    290           */
    291290          $NewDBCFile->SetLine($Row, $Line);
    292291         

  • trunk/log.php

    r417 r444  
    88  if(array_key_exists('type', $_GET)) $Where = ' WHERE `Type` = "'.($_GET['type'] * 1).'"';
    99    else $Where = '';
    10   $sql = 'SELECT *,UNIX_TIMESTAMP(`Date`), (SELECT `User`.`Name` FROM `User` WHERE `User`.`ID` = `Log`.`User`) AS `User` FROM `Log`'.$Where.' ORDER BY `Date` DESC LIMIT 100';
     10  $sql = 'SELECT *, UNIX_TIMESTAMP(`Date`) AS `TimeCreate`, (SELECT `User`.`Name` FROM `User` WHERE `User`.`ID` = `Log`.`User`) AS `User` FROM `Log`'.$Where.' ORDER BY `Date` DESC LIMIT 100';
    1111  $ID = $Database->SQLCommand($sql);
    1212  while($Line = mysql_fetch_assoc($ID))
    … …  
    2020      'Link' => 'http://'.$Config['Web']['Host'].$System->Link('/log.php'),
    2121      'Description' => $LogType['Name'].': '.$Line['Text'].' ('.$Line['Name'].', '.$Line['IP'].')',
    22       'Time' => $Line['UNIX_TIMESTAMP(Date)'],
     22      'Time' => $Line['TimeCreate'],
    2323    );
    2424  }

  • trunk/sql/structure.sql

    r429 r444  
    44--
    55-- Počítač: localhost
    6 -- Vygenerováno: Čtvrtek 08. dubna 2010, 20:17
     6-- Vygenerováno: Neděle 11. dubna 2010, 13:22
    77-- Verze MySQL: 5.1.44
    88-- Verze PHP: 5.3.1
    … …  
    4343  `ReleaseDate` date NOT NULL,
    4444  `Title` varchar(255) NOT NULL,
    45   `DBCColumns_GameTips` text NOT NULL,
    46   `DBCColumns_Spell` text NOT NULL,
    47   `GameTips_Text` int(11) NOT NULL,
    48   `Spell_Name` int(11) NOT NULL,
    49   `Spell_Description` int(11) NOT NULL,
    50   `Spell_Rank` int(11) NOT NULL,
    51   `Spell_ToolTip` int(11) NOT NULL,
    52   `DBCColumns_Achievement` text NOT NULL,
    53   `DBCColumns_Achievement_Category` text NOT NULL,
    54   `DBCColumns_Achievement_Criteria` text NOT NULL,
    55   `Achievement_Name` int(11) NOT NULL,
    56   `Achievement_Description` int(11) NOT NULL,
    57   `Achievement_Reward` int(11) NOT NULL,
    58   `Achievement_Category_Name` int(11) NOT NULL,
    59   `Achievement_Criteria_Text` int(11) NOT NULL,
     45  `Imported` int(11) NOT NULL,
    6046  PRIMARY KEY (`Id`),
    6147  KEY `BuildNumber` (`BuildNumber`),
    6248  KEY `Version` (`Version`),
    63   KEY `ReleaseDate` (`ReleaseDate`)
    64 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    65 
    66 -- --------------------------------------------------------
    67 
    68 --
    69 -- Struktura tabulky `connexion`
    70 --
    71 
    72 CREATE TABLE IF NOT EXISTS `connexion` (
    73   `Id` int(11) NOT NULL AUTO_INCREMENT,
    74   `Name` text NOT NULL,
    75   `Group` int(11) NOT NULL,
    76   PRIMARY KEY (`Id`),
    77   KEY `Group` (`Group`)
    78 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    79 
    80 -- --------------------------------------------------------
    81 
    82 --
    83 -- Struktura tabulky `connexion_item`
    84 --
    85 
    86 CREATE TABLE IF NOT EXISTS `connexion_item` (
    87   `Id` int(11) NOT NULL AUTO_INCREMENT,
    88   `connexion` int(11) NOT NULL,
    89   `entry` int(11) NOT NULL,
    90   PRIMARY KEY (`Id`),
    91   KEY `connexion` (`connexion`,`entry`)
     49  KEY `ReleaseDate` (`ReleaseDate`),
     50  KEY `Imported` (`Imported`)
    9251) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    9352
    … …  
    287246  `MangosColumn` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    288247  `AddonFileName` varchar(255) COLLATE utf8_czech_ci NOT NULL,
    289   `DBCColumnIndex` int(11) NOT NULL DEFAULT '0',
    290248  PRIMARY KEY (`Id`),
    291249  KEY `Group` (`Group`),
    292250  KEY `Visible` (`Visible`)
    293251) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
     252
     253-- --------------------------------------------------------
     254
     255--
     256-- Struktura tabulky `GroupItemDBC`
     257--
     258
     259CREATE TABLE IF NOT EXISTS `GroupItemDBC` (
     260  `Id` int(11) NOT NULL AUTO_INCREMENT,
     261  `ClientVersion` int(11) NOT NULL,
     262  `GroupItem` int(11) NOT NULL,
     263  `ColumnIndex` int(11) NOT NULL,
     264  PRIMARY KEY (`Id`),
     265  UNIQUE KEY `ClientVersion_2` (`ClientVersion`,`GroupItem`),
     266  KEY `ClientVersion` (`ClientVersion`),
     267  KEY `GroupItem` (`GroupItem`)
     268) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    294269
    295270-- --------------------------------------------------------
    … …  
    481456
    482457--
     458-- Struktura tabulky `TextAreaPOI`
     459--
     460
     461CREATE TABLE IF NOT EXISTS `TextAreaPOI` (
     462  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     463  `Entry` int(11) NOT NULL,
     464  `Name` varchar(255) NOT NULL,
     465  `State` text NOT NULL,
     466  `Language` int(11) NOT NULL DEFAULT '0',
     467  `User` int(11) NOT NULL,
     468  `Complete` int(11) NOT NULL,
     469  `CompleteParts` int(11) NOT NULL,
     470  `Take` int(11) NOT NULL,
     471  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     472  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     473  `ModifyTime` datetime NOT NULL,
     474  PRIMARY KEY (`ID`),
     475  KEY `Entry` (`Entry`),
     476  KEY `User` (`User`),
     477  KEY `Take` (`Take`),
     478  KEY `Language` (`Language`),
     479  KEY `Complete` (`Complete`),
     480  KEY `VersionStart` (`VersionStart`),
     481  KEY `VersionEnd` (`VersionEnd`),
     482  KEY `ModifyTime` (`ModifyTime`)
     483) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
     484
     485-- --------------------------------------------------------
     486
     487--
    483488-- Struktura tabulky `TextAreaTriggerTavern`
    484489--
    … …  
    527532  PRIMARY KEY (`ID`),
    528533  KEY `entry` (`Entry`),
     534  KEY `User` (`User`),
     535  KEY `Take` (`Take`),
     536  KEY `Language` (`Language`),
     537  KEY `Complete` (`Complete`),
     538  KEY `VersionStart` (`VersionStart`),
     539  KEY `VersionEnd` (`VersionEnd`),
     540  KEY `ModifyTime` (`ModifyTime`)
     541) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
     542
     543-- --------------------------------------------------------
     544
     545--
     546-- Struktura tabulky `TextCharacterClass`
     547--
     548
     549CREATE TABLE IF NOT EXISTS `TextCharacterClass` (
     550  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     551  `Entry` int(11) NOT NULL,
     552  `Name` varchar(255) NOT NULL,
     553  `ShortCut` varchar(255) NOT NULL,
     554  `Language` int(11) NOT NULL DEFAULT '0',
     555  `User` int(11) NOT NULL,
     556  `Complete` int(11) NOT NULL,
     557  `CompleteParts` int(11) NOT NULL,
     558  `Take` int(11) NOT NULL,
     559  `VersionStart` int(11) NOT NULL,
     560  `VersionEnd` int(11) NOT NULL,
     561  `ModifyTime` datetime NOT NULL,
     562  PRIMARY KEY (`ID`),
     563  KEY `Entry` (`Entry`),
     564  KEY `User` (`User`),
     565  KEY `Take` (`Take`),
     566  KEY `Language` (`Language`),
     567  KEY `Complete` (`Complete`),
     568  KEY `VersionStart` (`VersionStart`),
     569  KEY `VersionEnd` (`VersionEnd`),
     570  KEY `ModifyTime` (`ModifyTime`)
     571) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
     572
     573-- --------------------------------------------------------
     574
     575--
     576-- Struktura tabulky `TextChatChannel`
     577--
     578
     579CREATE TABLE IF NOT EXISTS `TextChatChannel` (
     580  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     581  `Entry` int(11) NOT NULL,
     582  `Name` varchar(255) NOT NULL,
     583  `Language` int(11) NOT NULL DEFAULT '0',
     584  `User` int(11) NOT NULL,
     585  `Complete` int(11) NOT NULL,
     586  `CompleteParts` int(11) NOT NULL,
     587  `Take` int(11) NOT NULL,
     588  `VersionStart` int(11) NOT NULL,
     589  `VersionEnd` int(11) NOT NULL,
     590  `ModifyTime` datetime NOT NULL,
     591  PRIMARY KEY (`ID`),
     592  KEY `Entry` (`Entry`),
    529593  KEY `User` (`User`),
    530594  KEY `Take` (`Take`),
    … …  
    10141078
    10151079--
     1080-- Struktura tabulky `TextSkillLine`
     1081--
     1082
     1083CREATE TABLE IF NOT EXISTS `TextSkillLine` (
     1084  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     1085  `Entry` int(11) NOT NULL,
     1086  `Name` varchar(255) NOT NULL,
     1087  `Description` text NOT NULL,
     1088  `Language` int(11) NOT NULL DEFAULT '0',
     1089  `User` int(11) NOT NULL,
     1090  `Complete` int(11) NOT NULL,
     1091  `CompleteParts` int(11) NOT NULL,
     1092  `Take` int(11) NOT NULL,
     1093  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     1094  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     1095  `ModifyTime` datetime NOT NULL,
     1096  PRIMARY KEY (`ID`),
     1097  KEY `Entry` (`Entry`),
     1098  KEY `User` (`User`),
     1099  KEY `Take` (`Take`),
     1100  KEY `Language` (`Language`),
     1101  KEY `Complete` (`Complete`),
     1102  KEY `VersionStart` (`VersionStart`),
     1103  KEY `VersionEnd` (`VersionEnd`),
     1104  KEY `ModifyTime` (`ModifyTime`)
     1105) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
     1106
     1107-- --------------------------------------------------------
     1108
     1109--
    10161110-- Struktura tabulky `TextSpell`
    10171111--
    … …  
    10461140
    10471141--
     1142-- Struktura tabulky `TextTalentTab`
     1143--
     1144
     1145CREATE TABLE IF NOT EXISTS `TextTalentTab` (
     1146  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     1147  `Entry` int(11) NOT NULL,
     1148  `Name` varchar(255) NOT NULL,
     1149  `Language` int(11) NOT NULL DEFAULT '0',
     1150  `User` int(11) NOT NULL,
     1151  `Complete` int(11) NOT NULL,
     1152  `CompleteParts` int(11) NOT NULL,
     1153  `Take` int(11) NOT NULL,
     1154  `VersionStart` int(11) NOT NULL,
     1155  `VersionEnd` int(11) NOT NULL,
     1156  `ModifyTime` datetime NOT NULL,
     1157  PRIMARY KEY (`ID`),
     1158  KEY `Entry` (`Entry`),
     1159  KEY `User` (`User`),
     1160  KEY `Take` (`Take`),
     1161  KEY `Language` (`Language`),
     1162  KEY `Complete` (`Complete`),
     1163  KEY `VersionStart` (`VersionStart`),
     1164  KEY `VersionEnd` (`VersionEnd`),
     1165  KEY `ModifyTime` (`ModifyTime`)
     1166) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
     1167
     1168-- --------------------------------------------------------
     1169
     1170--
     1171-- Struktura tabulky `TextTotemCategory`
     1172--
     1173
     1174CREATE TABLE IF NOT EXISTS `TextTotemCategory` (
     1175  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     1176  `Entry` int(11) NOT NULL,
     1177  `Name` varchar(255) NOT NULL,
     1178  `Language` int(11) NOT NULL DEFAULT '0',
     1179  `User` int(11) NOT NULL,
     1180  `Complete` int(11) NOT NULL,
     1181  `CompleteParts` int(11) NOT NULL,
     1182  `Take` int(11) NOT NULL,
     1183  `VersionStart` int(11) NOT NULL,
     1184  `VersionEnd` int(11) NOT NULL,
     1185  `ModifyTime` datetime NOT NULL,
     1186  PRIMARY KEY (`ID`),
     1187  KEY `Entry` (`Entry`),
     1188  KEY `User` (`User`),
     1189  KEY `Take` (`Take`),
     1190  KEY `Language` (`Language`),
     1191  KEY `Complete` (`Complete`),
     1192  KEY `VersionStart` (`VersionStart`),
     1193  KEY `VersionEnd` (`VersionEnd`),
     1194  KEY `ModifyTime` (`ModifyTime`)
     1195) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
     1196
     1197-- --------------------------------------------------------
     1198
     1199--
    10481200-- Struktura tabulky `TextTransport`
    10491201--
    … …  
    10631215  PRIMARY KEY (`ID`),
    10641216  KEY `entry` (`Entry`),
     1217  KEY `User` (`User`),
     1218  KEY `Take` (`Take`),
     1219  KEY `Language` (`Language`),
     1220  KEY `Complete` (`Complete`),
     1221  KEY `VersionStart` (`VersionStart`),
     1222  KEY `VersionEnd` (`VersionEnd`),
     1223  KEY `ModifyTime` (`ModifyTime`)
     1224) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
     1225
     1226-- --------------------------------------------------------
     1227
     1228--
     1229-- Struktura tabulky `TextWorldStateUI`
     1230--
     1231
     1232CREATE TABLE IF NOT EXISTS `TextWorldStateUI` (
     1233  `ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
     1234  `Entry` int(11) NOT NULL,
     1235  `Text1` varchar(255) NOT NULL,
     1236  `Text2` varchar(255) NOT NULL,
     1237  `Frame` text NOT NULL,
     1238  `Frame2` text NOT NULL,
     1239  `Language` int(11) NOT NULL DEFAULT '0',
     1240  `User` int(11) NOT NULL,
     1241  `Complete` int(11) NOT NULL,
     1242  `CompleteParts` int(11) NOT NULL,
     1243  `Take` int(11) NOT NULL,
     1244  `VersionStart` int(11) NOT NULL DEFAULT '8606',
     1245  `VersionEnd` int(11) NOT NULL DEFAULT '8606',
     1246  `ModifyTime` datetime NOT NULL,
     1247  PRIMARY KEY (`ID`),
     1248  KEY `Entry` (`Entry`),
    10651249  KEY `User` (`User`),
    10661250  KEY `Take` (`Take`),
Note: See TracChangeset for help on using the changeset viewer.