source: trunk/action.php@ 542

<?php

include_once('includes/global.php');

function Search()
{
  global $System, $TranslationTree, $Config;
  
  if(array_key_exists('search', $_GET)) $Search = $_GET['search'];
  else if(array_key_exists('search', $_POST)) $Search = $_POST['search'];
  else $Search = '';

  $Output = '<table class="BaseTable"><tr><th>Skupina</th><th>Výsledků</th></tr>';
  foreach($TranslationTree as $Group) 
  {
    $Table = $Group['TablePrefix'];
  
    $sql = 'SELECT COUNT(*) FROM `'.$Table.'` WHERE '.
    ' (`ID` LIKE "%'.$Search.'%")'.
    ' OR (`Entry` LIKE "%'.$Search.'%")';
    foreach($Group['Items'] as $Item) 
    {
      if($Item['Column'] != '') $sql .= ' OR `'.$Item['Column'].'` LIKE "%'.$Search.'%"';
    }
    $DbResult = $System->Database->query($sql);
    $Line = $DbResult->fetch_row();
    $Output .= '<tr><td><a href="TranslationList.php?group='.$Group['Id'].'&amp;user=0&amp;state=0&amp;text='.$Search.'&amp;entry=">'.$Group['Name'].'</a></td><td>'.$Line[0].'</td></tr>';
  }
  
  $DbResult = $System->Database->query('SELECT count(*) FROM `User` WHERE `Name` LIKE "%'.$Search.'%"');
  $Line = $DbResult->fetch_row();
  $Output .= '<tr><td><a href="userlist.php?search='.$Search.'">Uživatelé</a></td><td>'.$Line[0].'</td></tr>';
  
  $DbResult = $System->Database->query('SELECT count(*) FROM `Team` WHERE `Name` LIKE "%'.$Search.'%" OR `Description` LIKE "%'.$Search.'%"');
  $Line = $DbResult->fetch_row();
  $Output .= '<tr><td><a href="team.php?search='.$Search.'">Týmy</a></td><td>'.$Line[0].'</td></tr>';
  
  $DbResult = $System->Database->query('SELECT count(*) FROM `CzWoWPackageVersion` WHERE `Text` LIKE "%'.$Search.'%"');
  $Line = $DbResult->fetch_row();
  $Output .= '<tr><td><a href="download.php?addon">Čeština pro klienta</a></td><td>'.$Line[0].'</td></tr>';
  $Output .= '<tr><td><a href="aowow/?search='.$Search.'">Vyhledávací databáze AoWoW</a></td></tr>';
  
  $DbResult = $System->Database->query('SELECT count(*) FROM `Dictionary` WHERE (`Text` LIKE "%'.$Search.'%" OR `Description` LIKE "%'.$Search.'%") AND `Language` = '.$Config['OriginalLanguage']);
  $Line = $DbResult->fetch_row();
  $Output .= '<tr><td><a href="dictionary.php?search='.$Search.'">Slovníček</a></td><td>'.$Line[0].'</td></tr>';
  
  $Output .= '</table>';
  return($Output);
}

function DatabaseKit()
{
  global $System, $TranslationTree, $User, $Config;
  
  if($User->Licence(LICENCE_ADMIN)) 
  {
    $Output = '<form action="?action=dbkit" method="post">'.
      'Najít: <input type="text" name="find" /><br />'.
      'Nahradit: <input type="text" name="replace" /><br />'.
      '<input type="submit" value="Najít/nahradit" /><br />'.
      '</form><br />'.
      '<a href="?action=dbkit&amp;Take">Opravit data v sloupci Take</a><br />'.
      '<a href="?action=dbkit&amp;ShortCut">Opravit data v sloupci ShortCut</a><br />';
  
    $Output .= '<br /><form action="?action=dbkit" method="post">'.
      'Vymazat log typ : <input type="text" name="Type" /> '.
      '<input type="submit" value="Vymazat" /><br />'.
      '</form><br />';

    if(array_key_exists('Type', $_POST)) 
    {
      $sql = 'DELETE FROM `Log` WHERE `Type` = '.$_POST['Type'];
      $System->Database->query($sql);
      WriteLog('Vymazán log '.$_POST['Type'], LOG_TYPE_MODERATOR);
      $Output .= ' Vymazán log '.$_POST['Type'];
    }
    
    if(array_key_exists('find', $_POST)) 
    {
      $Output .= 'Začínám nahrazovat: <br />';
      $find = $_POST['find'];
      $replace = $_POST['replace'];
      
      foreach($TranslationTree as $Group) 
      {
        $Table = $Group['TablePrefix'];
        $Output .= $Table.' ';
    
        $sql = 'SELECT * FROM '.$Table.' WHERE (`Language` <> '.$Config['OriginalLanguage'].') AND (';
        foreach($Group['Items'] as $Item) 
        {
          if($Item['Column'] != '') $sql .= '`'.$Item['Column'].'` LIKE "%'.$find.'%" OR ';
        }
        $sql = substr($sql,0,strlen($sql)-4);
        $sql .= ')';
      
        $DbResult = $System->Database->query($sql);
        while ($Line = $DbResult->fetch_assoc()) 
        {
          $sql = 'UPDATE '.$Table.' SET ';
          foreach($Group['Items'] as $Item) 
          {
            $Column_text = addslashes(str_replace($find, $replace, $Line[$Item['Column']]));
            $sql .= ' '.$Item['Column'].' = "'.$Column_text.'",';
          }
          $sql = substr($sql,0,strlen($sql)-1);
          $sql .= ' WHERE `ID` = '.$Line['ID'];
          $System->Database->query($sql);
          $Output .= '.';
        }
    
        $Output .= ' <strong>Hotovo</strong> <br />';
        if($DbResult->num_rows > 0) 
        {
          WriteLog('Použita oprava DB ovlivněno '.$DbResult->num_rows.' řádků z tabulky '.$Table.', "'.$find.'" nahrazeno za "'.$replace.'"', LOG_TYPE_MODERATOR);
          $Output .= ' Použita oprava DB ovlivněno '.$DbResult->num_rows.' řádků z tabulky '.$Table.', "'.$find.'" nahrazeno za "'.$replace.'"<br />';
        }
      }
    }
  
    // Oprava dat v sloupci Take
    if(array_key_exists('Take',$_GET)) 
    {
      $Output .= 'Začínám opravovat Take: <br />';
    
      foreach($TranslationTree as $Group) 
      {
        $Table = $Group['TablePrefix'];
        $Output .= $Table.' ';
    
        $sql = 'SELECT `ID`, `Entry` AS EntryTran, `Take`, '.
       '(SELECT `ID` FROM `'.$Table.'` WHERE (`Language = '.$Config['OriginalLanguage'].') AND (`Entry` = `EntryTran`) LIMIT 1) AS `IDOrig` '.
       'FROM `'.$Table.'` AS `Tran` WHERE (`Language` <> '.$Config['OriginalLanguage'].') AND ((`Take` IS NULL) OR '.
       '(`ID` = `Take`) OR NOT EXISTS(SELECT 1 FROM `'.$Table.'` WHERE `ID` = `Tran`.`Take`))';
      
        $DbResult = $System->Database->query($sql);
        while($Line = $DbResult->fetch_assoc()) 
        {
          $sql = 'UPDATE `'.$Table.'` SET `Take` = '.$Line['IDOrig'].' WHERE `ID` = '.$Line['ID'];
          $System->Database->query($sql);
          $Output .= '.';
        }
    
        $Output .= ' <strong>Hotovo</strong> <br />';
        if($DbResult->num_rows > 0) 
        {
          WriteLog('Použita oprava DB na sloupec Take '.$DbResult->num_rows.' řádků z tabulky '.$Table, LOG_TYPE_MODERATOR);
          $Output .= ' Použita oprava DB na sloupec Take '.$DbResult->num_rows.' řádků z tabulky '.$Table.'<br />';
        }
      }
    } 
    // Oprava dat ShortCut
    if(array_key_exists('ShortCut', $_GET)) 
    {
      $Output .= 'Začínám opravovat Take: <br />';        
      
      $Tables = array('TextGlobalString', 'TextGlueString');  

      foreach($Tables as $Table) 
      {      
        $Output .= $Table.' ';
        $sql = 'SELECT `gs_orig`.`ID`, `gs_tran`.`Entry`, `gs_tran`.`ShortCut` AS `ShortCut_tran`, '.
          '`gs_orig`.`ShortCut`  AS `ShortCut_orig` FROM `'.$Table.'` AS `gs_tran` '.
          'JOIN `'.$Table.'` AS `gs_orig` ON `gs_orig`.`Entry` = `gs_tran`.`Entry` WHERE '.
          '`gs_tran`.`Language` <> '.$Config['OriginalLanguage'].' AND `gs_tran`.`ShortCut` <> `gs_orig`.`ShortCut`';     
        $DbResult = $System->Database->query($sql);
        while ($Line = $DbResult->fetch_assoc()) 
        {
          $sql = 'UPDATE `'.$Table.'` SET `ShortCut` = '.$Line['ShortCut_orig'].' WHERE `ID` = '.$Line['ID'];
          $System->Database->query($sql);
          $Output .= '.';
        }
    
        $Output = ' <strong>Hotovo</strong> <br />';
        if($DbResult->num_rows > 0) 
        {
          WriteLog('Použita oprava DB na sloupec ShortCut '.$DbResult->num_rows.' řádků z tabulky '.$Table, LOG_TYPE_MODERATOR);
          $Output .= ' Použita oprava DB na sloupec ShortCut '.$DbResult->num_rows.' řádků z tabulky '.$Table.'<br />';
        }
      }
    } 
  } else $Output = ShowMessage('Nemáte oprávnění.', MESSAGE_CRITICAL);
  return($Output);   
}

function Delete()
{
  global $System, $User, $Config;
  
  if($User->Licence(LICENCE_MODERATOR)) 
  {
    $TextID = $_GET['ID'];       
    $System->Database->query('DELETE FROM `'.$Table.'` WHERE `ID` = '.$TextID.' AND `Language` <> '.$Config['OriginalLanguage']);
    $Output = ShowMessage('Překlad byl smazán.');   
    WriteLog('Překlad byl smazán! <a href="form.php?group='.$GroupID.'&amp;ID='.$TextID.'">'.$TextID.'</a>', LOG_TYPE_MODERATOR);
  } else $Output = ShowMessage('Nemáte oprávnění', MESSAGE_CRITICAL);
  return($Output); 
}

function ShoutBox()
{
  global $System, $User;
  
  $Output = '';
  if($User->Licence(LICENCE_USER))
  {
    if(!array_key_exists('add', $_POST)) 
    {
      $Output .= '<form action="action.php?action=shoutbox" method="post">'.
        '<fieldset><legend>Nová zpráva kecátka</legend>'.
        'Uživatel: ';
      if($User->Licence(LICENCE_USER)) $Output .= '<b>'.$User->Name.'</b><br />'; 
      else $Output .= '<input type="text" name="user" /><br />';
      $Output .= 'Text zprávy: <br/>
      <textarea onkeydown="ResizeTextArea(this)" name="text" cols="40"></textarea> <br/>
      <input type="submit" name="add" value="Odeslat" /><br /></fieldset>
      </form>';
    } else 
    {
      if(array_key_exists('text', $_POST)) 
      {
        $Text = $_POST['text'];
        if(trim($Text) == '') $Output .= ShowMessage('Nelze vložit prázdnou zprávu.', MESSAGE_WARNING);
        else
        {
          // Protection against mutiple post of same message
          $DbResult = $System->Database->query('SELECT `Text` FROM `ShoutBox` WHERE (`User` = "'.$User->Id.'") ORDER BY `Date` DESC LIMIT 1');
          if($DbResult->num_rows > 0) 
          {
            $DbRow = $DbResult->fetch_assoc();          
          } else $DbRow['Text'] = '';
        
          if($DbRow['Text'] == $Text) $Output .= ShowMessage('Nelze vložit stejnou zprávu vícekrát za sebou.', MESSAGE_WARNING);
          else 
          {
            $System->Database->query('INSERT INTO `ShoutBox` ( `User`, `UserName` , `Text` , `Date` , `IP` ) '.
              ' VALUES ('.$User->Id.', "'.$User->Name.'", "'.$Text.'", NOW(), "'.$_SERVER['REMOTE_ADDR'].'")');
            $Output .= ShowMessage('Zpráva vložena.');   
          }
        }
      } else $Output .= ShowMessage('Nezadán text pro novou zprávu.', MESSAGE_CRITICAL);   
    }
    $Output .= '<br/>';
  } else $Output .= ShowMessage('Pro vkládaní zpráv musíte byt registrováni.', MESSAGE_CRITICAL);
  $Output .= ShoutBoxView();
  return($Output);
}

function ShoutBoxView()
{
  global $System, $User;
    
  $DbResult = $System->Database->query('SELECT COUNT(*) FROM `ShoutBox`');
  $DbRow = $DbResult->fetch_row();
  $PageList = GetPageList($DbRow[0]);    

  $Output = '<h3>Kecátko</h3>'.$PageList['Output']; 
  if($User->Licence(LICENCE_USER)) $Output .= ' <a href="action.php?action=shoutbox">Vložit</a>';
  $Output .= '<div class="shoutbox">';
  $DbResult = $System->Database->query('SELECT * FROM `ShoutBox` ORDER BY `ID` DESC '.$PageList['SQLLimit']);
  while($Line = $DbResult->fetch_assoc())
    $Output .= '<div><strong>'.$Line['UserName'].'</strong>: '.MakeActiveLinks($Line['Text']).'</div>';
  $Output .= '</div>'.$PageList['Output'];
  return($Output); 
}

function ShowNewsHistory()
{
  global $System, $User;
  
  $DbResult = $System->Database->query('SELECT COUNT(*) FROM `News`');
  $DbRow = $DbResult->fetch_row();
  $PageList = GetPageList($DbRow[0]);    

  $Output = '<h3>Novinky</h3>'.$PageList['Output']; 
  if($User->Licence(LICENCE_ADMIN)) $Output .= ' <a href="admin/?action=addnew">Vložit</a>';
  $Output .= '<div class="shoutbox">';
  $DbResult = $System->Database->query('SELECT `News`.`Time`, `News`.`Text`, `News`.`Title`, '.
        '`User`.`Name` AS `User` FROM `News` JOIN `User` ON `User`.`Id`=`News`.`User` ORDER BY `News`.`Time` DESC '.$PageList['SQLLimit']);
  while($Line = $DbResult->fetch_assoc())
    $Output .= '<div><strong>'.$Line['Title'].' ('.HumanDate($Line['Time']).')</strong><br/> '.$Line['Text'].' ('.$Line['User'].')</div>';
  $Output .= '</div>'.$PageList['Output'];
  return($Output); 
}

if(array_key_exists('group', $_GET)) $GroupId = LoadGroupIdParameter();
  else $GroupId = 1;
//$Table = $TranslationTree[$GroupId]['TablePrefix'];
$Action = '';
if(array_key_exists('action', $_GET)) $Action = $_GET['action'];

if($Action == 'shoutbox') $Output = ShoutBox();
else if($Action == 'news') $Output = ShowNewsHistory();
else if($Action == 'search') $Output = Search();
else if($Action == 'delete') $Output = Delete();
else if($Action == 'dbkit') $Output = DatabaseKit();
else if($Action == 'ShoutBoxView') $Output = ShoutBoxView();
else $Output = ShowMessage('Nebyla zadána žádná akce.', MESSAGE_CRITICAL);

ShowPage($Output);      

?>