source: client_files/Generate/search_var.php

<?php
  session_start();
  include('../../includes/config.php');
  include('../../includes/databaseconection.php');
  include('../../includes/global_function.php');

  //připojení do databáze
  $Database = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password']); 
  $Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
  $Database->SelectDatabase($Config['Database']['Database']);    
  
  if (Licence(2)) {  // echo 'Přístup povolen'; 
  } else { die('Přístup zamítnut!'); }

  function set_name($text)
  { 
    global $buffer;
      $text = substr($text, strpos($text, '$g')+2, strlen($text)-strpos($text, '$g'));
      $text = substr($text, 0, strpos($text, ';'));
      $men = substr($text, 0, strpos($text, ':'));
      $women = substr($text, strpos($text, ':')+1, strlen($text)-strpos($text, ':')+1);
      if (isset($buffer[$men]) == false and ($men <> '') and ($women <> '') and (strlen($men) < 10) and (strlen($women) < 10)) 
          {
        $buffer[$men] = $women;
       // echo $men.' '.$women.'<br />';
      }
  } 

    
    $sql = "SELECT `Language` , `Details` , `Objectives` , `OfferRewardText` , `RequestItemsText` , `EndText` , `ObjectiveText1` , `ObjectiveText2` , `ObjectiveText3` , `ObjectiveText4` FROM `quests` WHERE `Details` LIKE '%\$G%' OR `Objectives` LIKE '%\$G%' OR `OfferRewardText` LIKE '%\$G%' OR `RequestItemsText` LIKE '%\$G%' OR `EndText` LIKE '%\$G%' OR `ObjectiveText1` LIKE '%\$G%' OR `ObjectiveText2` LIKE '%\$G%' OR `ObjectiveText3` LIKE '%\$G%' OR `ObjectiveText4` LIKE '%\$G%' OR `Details` LIKE '%\$g%' OR `Objectives` LIKE '%\$g%' OR `OfferRewardText` LIKE '%\$g%' OR `RequestItemsText` LIKE '%\$g%' OR `EndText` LIKE '%\$g%' OR `ObjectiveText1` LIKE '%\$g%' OR `ObjectiveText2` LIKE '%\$g%' OR `ObjectiveText3` LIKE '%\$g%' OR `ObjectiveText4` LIKE '%\$g%'";

  //    echo $sql.'<br /><br />';
    $ID = $Database->SQLCommand($sql);
    while ($Line = mysql_fetch_array($ID)) 
        {
   //   $language = $Line['Language'];
      $text = strtolower($Line['Details']);
      set_name($text);
      $text = strtolower($Line['Objectives']);
      set_name($text);
      $text = strtolower($Line['OfferRewardText']);
      set_name($text);
      $text = strtolower($Line['RequestItemsText']);
      set_name($text);
      $text = strtolower($Line['EndText']);
      set_name($text);
      
    }
   
   $sql = 'SELECT ';
   for ($i=0;$i<8 ;++$i ) 
   {
     for ($j=0;$j<2 ;++$j ) 
         {
            $sql = $sql."text".$i."_$j,";
     }
   }
  $sql = substr($sql, 0, strlen($sql)-1);
  $sql = $sql." FROM npc WHERE ";
   for ($i=0;$i<8 ;++$i ) 
   {
     for ($j=0;$j<2 ;++$j ) 
         {
            $sql = $sql."text".$i."_$j  LIKE '%\$G%' OR ";
     }
   }
   for ($i=0;$i<8 ;++$i ) 
   {
     for ($j=0;$j<2 ;++$j ) 
         {
            $sql = $sql."text".$i."_$j  LIKE '%\$g%' OR ";
     }
   }
  $sql = substr($sql, 0, strlen($sql) - 3);


    $ID = $Database->SQLCommand($sql);
    while ($Line = mysql_fetch_array($ID)) 
        {
     // $language = $Line['Language'];

       for ($i = 0; $i < 8 ;++$i ) 
           {
         for ($j = 0; $j < 2 ;++$j ) 
                 {
           $text = strtolower($Line["text".$i."_$j"]);
           set_name($text);
         }
       }
    }
  
  echo '$var_g = array(<br />';
    foreach ($buffer as $key => $value) 
        {
    //  echo $key.'-'.$value.'<br />';
        echo " array('$key','$value'),<br />";
    }
  echo ');';
    
?>