Exemple #1
0
function do_export()
{
    global $DB, $VERSION, $D, $BOM, $ex_isgz;
    $rt = str_replace('`', '', $_REQUEST['t']);
    $t = explode(",", $rt);
    $th = array_flip($t);
    $ct = count($t);
    $z = db_row("show variables like 'max_allowed_packet'");
    $MAXI = floor($z['Value'] * 0.8);
    if (!$MAXI) {
        $MAXI = 838860;
    }
    $aext = '';
    $ctp = '';
    $ex_isgz = $_REQUEST['gz'] ? 1 : 0;
    if ($ex_isgz) {
        $aext = '.gz';
        $ctp = 'application/x-gzip';
    }
    ex_start();
    if ($ct == 1 && $_REQUEST['et'] == 'csv') {
        ex_hdr($ctp ? $ctp : 'text/csv', "{$t['0']}.csv{$aext}");
        if ($DB['chset'] == 'utf8') {
            ex_w($BOM);
        }
        $sth = db_query("select * from `{$t['0']}`");
        $fn = mysql_num_fields($sth);
        for ($i = 0; $i < $fn; $i++) {
            $m = mysql_fetch_field($sth, $i);
            ex_w(qstr($m->name) . ($i < $fn - 1 ? "," : ""));
        }
        ex_w($D);
        while ($row = mysql_fetch_row($sth)) {
            ex_w(to_csv_row($row));
        }
        ex_end();
        exit;
    }
    ex_hdr($ctp ? $ctp : 'text/plain', "{$DB['db']}" . ($ct == 1 && $t[0] ? ".{$t['0']}" : ($ct > 1 ? '.' . $ct . 'tables' : '')) . ".sql{$aext}");
    ex_w("-- phpMiniAdmin dump {$VERSION}{$D}-- Datetime: " . date('Y-m-d H:i:s') . "{$D}-- Host: {$DB['host']}{$D}-- Database: {$DB['db']}{$D}{$D}");
    ex_w("/*!40030 SET NAMES {$DB['chset']} */;{$D}/*!40030 SET GLOBAL max_allowed_packet=16777216 */;{$D}{$D}");
    $sth = db_query("show tables from `{$DB['db']}`");
    while ($row = mysql_fetch_row($sth)) {
        if (!$rt || array_key_exists($row[0], $th)) {
            do_export_table($row[0], 1, $MAXI);
        }
    }
    ex_w("{$D}-- phpMiniAdmin dump end{$D}");
    ex_end();
    exit;
}
Exemple #2
0
function do_export()
{
    global $DB, $VERSION;
    $rt = $_REQUEST['t'];
    $t = split(",", $rt);
    $th = array_flip($t);
    $ct = count($t);
    $z = db_array("show variables like 'max_allowed_packet'");
    $MAXI = floor($z[0]['Value'] * 0.8);
    if (!$MAXI) {
        $MAXI = 838860;
    }
    if ($ct == 1 && $_REQUEST['et'] == 'csv') {
        header('Content-type: text/csv');
        header("Content-Disposition: attachment; filename=\"{$t['0']}.csv\"");
        $csv_data = "First Name,Last Name,Email,ClickBank ID,Registered\n";
        $sth = db_query("select * from `{$t['0']}`");
        $fn = mysql_num_fields($sth);
        for ($i = 0; $i < $fn; $i++) {
            $m = mysql_fetch_field($sth, $i);
            echo qstr($m->name) . ($i < $fn - 1 ? "," : "");
        }
        echo "\n";
        while ($row = mysql_fetch_row($sth)) {
            echo to_csv_row($row);
        }
        exit;
    }
    header('Content-type: text/plain');
    header("Content-Disposition: attachment; filename=\"{$DB['db']}" . ($ct == 1 && $t[0] ? ".{$t['0']}" : ($ct > 1 ? '.' . $ct . 'tables' : '')) . ".sql\"");
    echo "-- phpMiniAdmin dump {$VERSION}\n-- Datetime: " . date('Y-m-d H:i:s') . "\n-- Host: {$DB['host']}\n-- Database: {$DB['db']}\n\n/*!40030 SET max_allowed_packet={$MAXI} */;\n\n";
    $sth = db_query("show tables from {$DB['db']}");
    while ($row = mysql_fetch_row($sth)) {
        if (!$rt || array_key_exists($row[0], $th)) {
            do_export_table($row[0], 1, $MAXI);
        }
    }
    exit;
}
Exemple #3
0
function do_export(){
 global $DB,$VERSION,$D,$BOM,$ex_isgz;
 $rt=str_replace('`','',$_REQUEST['t']);
 $t=explode(",",$rt);
 $th=array_flip($t);
 $ct=count($t);
 $z=db_row("show variables like 'max_allowed_packet'");
 $MAXI=floor($z['Value']*0.8);
 if(!$MAXI)$MAXI=838860;
 $aext='';$ctp='';

 $ex_super=($_REQUEST['sp'])?1:0;
 $ex_isgz=($_REQUEST['gz'])?1:0;
 if ($ex_isgz) {
    $aext='.gz';$ctp='application/x-gzip';
 }
 ex_start();

 if ($ct==1&&$_REQUEST['et']=='csv'){
  ex_hdr($ctp?$ctp:'text/csv',"$t[0].csv$aext");
  if ($DB['chset']=='utf8') ex_w($BOM);

  $sth=db_query("select * from `$t[0]`");
  $fn=mysql_num_fields($sth);
  for($i=0;$i<$fn;$i++){
   $m=mysql_fetch_field($sth,$i);
   ex_w(qstr($m->name).(($i<$fn-1)?",":""));
  }
  ex_w($D);
  while($row=mysql_fetch_row($sth)) ex_w(to_csv_row($row));
  ex_end();
  exit;
 }

 ex_hdr($ctp?$ctp:'text/plain',"$DB[db]".(($ct==1&&$t[0])?".$t[0]":(($ct>1)?'.'.$ct.'tables':'')).".sql$aext");
 ex_w("-- phpMiniAdmin dump $VERSION$D-- Datetime: ".date('Y-m-d H:i:s')."$D-- Host: $DB[host]$D-- Database: $DB[db]$D$D");
 ex_w("/*!40030 SET NAMES $DB[chset] */;$D");
 $ex_super && ex_w("/*!40030 SET GLOBAL max_allowed_packet=16777216 */;$D$D");
 ex_w("/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;$D$D");

 $sth=db_query("show tables from `$DB[db]`");
 while($row=mysql_fetch_row($sth)){
   if (!$rt||array_key_exists($row[0],$th)) do_export_table($row[0],1,$MAXI);
 }

 ex_w("/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;$D$D");
 ex_w("$D-- phpMiniAdmin dump end$D");
 ex_end();
 exit;
}