Ignore:
Timestamp:
Apr 7, 2020, 9:53:00 PM (5 years ago)
Author:
chronos
Message:
  • Fixed: Wrong Setup tables initialization.
  • Fixed: Export SQL query compatible with newer SQL server.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/Modules/Export/Export.php

    r869 r879  
    9494
    9595
    96     $Query = 'SELECT * FROM (SELECT '.$Columns.' T.`ID`,T.`Language`,T.`User`,T.`Entry`,T.`VersionEnd`,T.`VersionStart`, `User`.`Name` AS `UserName` FROM `'.$Group['TablePrefix'].'` AS `T`'.
     96    $Query = 'SELECT * FROM (SELECT ANY_VALUE(`TT`.`ID`) AS `TTID` FROM (SELECT '.$Columns.' T.`ID`,T.`Language`,T.`User`,T.`Entry`,T.`VersionEnd`,T.`VersionStart`, `User`.`Name` AS `UserName` FROM `'.$Group['TablePrefix'].'` AS `T`'.
    9797    ' JOIN `ExportUser` ON (`ExportUser`.`User`=`T`.`User`) AND (`ExportUser`.`Export`='.$this->Id.') '.
    9898    ' JOIN `User` ON `User`.`ID`=`T`.`User`'.
    9999    ' JOIN `ExportLanguage` ON (`ExportLanguage`.`Export`='.$this->Id.')'.
    100100    ' WHERE (`Complete` = 1) AND (`VersionStart` <= '.$ExportVersion.') AND (`VersionEnd` >= '.$ExportVersion.')'.
    101     ' ORDER BY `ExportLanguage`.`Sequence`, `ExportUser`.`Sequence`) AS `TT` GROUP BY `TT`.`Entry`';
     101    ' ORDER BY `ExportLanguage`.`Sequence`, `ExportUser`.`Sequence`) AS `TT` GROUP BY `TT`.`Entry`) AS `TK`'.
     102    ' LEFT JOIN `'.$Group['TablePrefix'].'` AS `TJ` ON `TJ`.`ID` = `TK`.`TTID` ';
    102103
    103104    // Build columns for english texts
     
    279280  }
    280281
     282  // Export only if translate have same varible %
    281283  function HaveVarible($String1, $String2, $StartChar = '$')
    282284  {
    283           //Export only if translate have same varible %
    284 
    285285    if (strpos($String1,$StartChar) !== false) {
    286286
Note: See TracChangeset for help on using the changeset viewer.