<?
  ob_start ();
  session_start ();
  include '../ayarlar.php';
  if (session_is_registered ('admingirdi'))
  {
    $dbhost = $host;
    $dbuname = $usr;
    $dbpass = $sifre;
    $dbname = $db;
    global $prefix;
    global $db;
    global $dbpass;
    global $dbhost;
    switch ($_GET['op'])
    {
      case 'yedek':
      {
        @set_time_limit (600);
        $crlf = '
';
        switch ($lang)
        {
          case french:
          {
            $strNoTablesFound = 'Aucune table n\'a été trouvée dans cette base.';
            $strHost = 'Serveur';
            $strDatabase = 'Base de données';
            $strTableStructure = 'Structure de la table';
            $strDumpingData = 'Contenu de la table';
            $strError = 'Erreur';
            $strSQLQuery = 'requête SQL';
            $strMySQLSaid = 'MySQL a répondu:';
            $strBack = 'Retour';
            $strFileName = 'Sauvegarde BD';
            $strName = 'Sauvegarde de la base de données';
            $strDone = 'effectuée le';
            $strat = 'à';
            $strby = 'par';
            $date_jour = date ('d-m-Y');
            break;
          }

          default:
          {
            $strNoTablesFound = 'Database de Tablo Bulunamadi.';
            $strHost = 'Host';
            $strDatabase = 'Database';
            $strTableStructure = 'Tablo';
            $strDumpingData = 'Tablo Icerigi';
            $strError = 'Hata';
            $strSQLQuery = 'SQL-Sorgusu';
            $strMySQLSaid = 'MySQL: ';
            $strBack = 'Geri';
            $strFileName = 'Sql Yedegi';
            $strName = 'SQL Yedegi';
            $strDone = 'Tarih';
            $strat = 'Saat';
            $strby = ' Professional SesliChat Yönetim Paneli';
            $date_jour = date ('m-d-Y');
            break;
          }
        }

        header ('' . 'Content-disposition: filename=' . $strFileName . ' ' . $dbname . ' ' . $date_jour . '.sql');
        header ('Content-type: application/octetstream');
        header ('Pragma: no-cache');
        header ('Expires: 0');
        $client = $_SERVER['HTTP_USER_AGENT'];
        if (ereg ('[^(]*\\((.*)\\)[^)]*', $client, $regs))
        {
          $os = $regs[1];
          if (eregi ('Win', $os))
          {
            $crlf = '
';
          }
        }

        function my_handler ($sql_insert)
        {
          global $crlf;
          echo '' . $sql_insert . ';' . $crlf;
        }

        function get_table_content ($db, $table, $handler)
        {
          ($result = mysql_db_query ($db, '' . 'SELECT * FROM ' . $table) OR mysql_die ());
          $i = 0;
          while ($row = mysql_fetch_row ($result))
          {
            $table_list = '(';
            for ($j = 0; $j < mysql_num_fields ($result); ++$j)
            {
              $table_list .= mysql_field_name ($result, $j) . ', ';
            }

            $table_list = substr ($table_list, 0, -2);
            $table_list .= ')';
            if (isset ($GLOBALS['showcolumns']))
            {
              $schema_insert = '' . 'INSERT INTO ' . $table . ' ' . $table_list . ' VALUES (';
            }
            else
            {
              $schema_insert = '' . 'INSERT INTO ' . $table . ' VALUES (';
            }

            for ($j = 0; $j < mysql_num_fields ($result); ++$j)
            {
              if (!isset ($row[$j]))
              {
                $schema_insert .= ' NULL,';
                continue;
              }
              else
              {
                if ($row[$j] != '')
                {
                  $schema_insert .= ' \'' . addslashes ($row[$j]) . '\',';
                  continue;
                }
                else
                {
                  $schema_insert .= ' \'\',';
                  continue;
                }

                continue;
              }
            }

            $schema_insert = ereg_replace ('' . ',$', '', $schema_insert);
            $schema_insert .= ')';
            $handler (trim ($schema_insert));
            ++$i;
          }

          return true;
        }

        function get_table_def ($db, $table, $crlf)
        {
          $schema_create = '';
          $schema_create .= '' . 'CREATE TABLE ' . $table . ' (' . $crlf;
          ($result = mysql_db_query ($db, '' . 'SHOW FIELDS FROM ' . $table) OR mysql_die ());
          while ($row = mysql_fetch_array ($result))
          {
            $schema_create .= '' . '   ' . $row['Field'] . ' ' . $row['Type'];
            if ((isset ($row['Default']) AND (!empty ($row['Default']) OR $row['Default'] == '0')))
            {
              $schema_create .= '' . ' DEFAULT \'' . $row['Default'] . '\'';
            }

            if ($row['Null'] != 'YES')
            {
              $schema_create .= ' NOT NULL';
            }

            if ($row['Extra'] != '')
            {
              $schema_create .= '' . ' ' . $row['Extra'];
            }

            $schema_create .= '' . ',' . $crlf;
          }

          $schema_create = ereg_replace (',' . $crlf . ('' . '$'), '', $schema_create);
          ($result = mysql_db_query ($db, '' . 'SHOW KEYS FROM ' . $table) OR mysql_die ());
          while ($row = mysql_fetch_array ($result))
          {
            $kname = $row['Key_name'];
            if (($kname != 'PRIMARY' AND $row['Non_unique'] == 0))
            {
              $kname = '' . 'UNIQUE|' . $kname;
            }

            if (!isset ($index[$kname]))
            {
              $index[$kname] = array ();
            }

            $index[$kname][] = $row['Column_name'];
          }

          while (list ($x, $columns) = @each ($index))
          {
            $schema_create .= '' . ',' . $crlf;
            if ($x == 'PRIMARY')
            {
              $schema_create .= '   PRIMARY KEY (' . implode ($columns, ', ') . ')';
              continue;
            }
            else
            {
              if (substr ($x, 0, 6) == 'UNIQUE')
              {
                $schema_create .= '   UNIQUE ' . substr ($x, 7) . ' (' . implode ($columns, ', ') . ')';
                continue;
              }
              else
              {
                $schema_create .= '' . '   KEY ' . $x . ' (' . implode ($columns, ', ') . ')';
                continue;
              }

              continue;
            }
          }

          $schema_create .= '' . $crlf . ')';
          return stripslashes ($schema_create);
        }

        function mysql_die ($error = '')
        {
          echo '' . '<b> ' . $strError . ' </b><p>';
          if ((isset ($sql_query) AND !empty ($sql_query)))
          {
            echo '' . $strSQLQuery . ': <pre>' . $sql_query . '</pre><p>';
          }

          if (empty ($error))
          {
            echo $strMySQLSaid . mysql_error ();
          }
          else
          {
            echo $strMySQLSaid . $error;
          }

          echo '' . '<br><a href="javascript:history.go(-1)">' . $strBack . '</a>';
          exit ();
        }

        global $dbhost;
        global $dbuname;
        global $dbpass;
        global $dbname;
        mysql_pconnect ($dbhost, $dbuname, $dbpass);
        if (!(@mysql_select_db ('' . $dbname)))
        {
          exit ('Unable to select database');
          (bool)true;
        }

        $tables = mysql_list_tables ($dbname);
        $num_tables = @mysql_num_rows ($tables);
        if ($num_tables == 0)
        {
          echo $strNoTablesFound;
          break;
        }
        else
        {
          $i = 0;
          $heure_jour = date ('H:i');
          print '' . '# ========================================================' . $crlf;
          print '' . '#' . $crlf;
          print '' . '# ' . $strName . ' : ' . $dbname . $crlf;
          print '' . '# ' . $strDone . ' ' . $date_jour . ' ' . $strat . ' ' . $heure_jour . ' ' . $strby . ' ' . $name . ' !' . $crlf;
          print '' . '#' . $crlf;
          print '' . '# ========================================================' . $crlf;
          print '' . $crlf;
          while ($i < $num_tables)
          {
            $table = mysql_tablename ($tables, $i);
            print $crlf;
            print '' . '# --------------------------------------------------------' . $crlf;
            print '' . '#' . $crlf;
            print '' . '# ' . $strTableStructure . ' \'' . $table . '\'' . $crlf;
            print '' . '#' . $crlf;
            print $crlf;
            echo get_table_def ($dbname, $table, $crlf) . ('' . ';' . $crlf . $crlf);
            print '' . '#' . $crlf;
            print '' . '# ' . $strDumpingData . ' \'' . $table . '\'' . $crlf;
            print '' . '#' . $crlf;
            print $crlf;
            get_table_content ($dbname, $table, 'my_handler');
            ++$i;
          }

          break;
        }
      }
    }
  }

  ob_end_flush ();
?>