• 02-12-2009, 23:36:17
    #1
    Üyeliği durduruldu
    Merhaba Arkadaşlar Acil Yardıma İhtiyacım Var..

    <?
      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 ();
    ?>
  • 03-12-2009, 15:46:39
    #2
    Üyeliği durduruldu
    bu kodlarin görevi derken?
  • 03-12-2009, 16:33:09
    #3
    Üyeliği durduruldu
    veritabanı yedeklemesi yapan bir scripte benziyor