<?
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 ();
?> Bu Kodların Görevi Ne
2
●389
- 02-12-2009, 23:36:17Üyeliği durdurulduMerhaba Arkadaşlar Acil Yardıma İhtiyacım Var..
- 03-12-2009, 16:33:09Üyeliği durdurulduveritabanı yedeklemesi yapan bir scripte benziyor