<?
////////////////////////////
//Configuration Variables//
//////////////////////////
$flatfiledb = "vendas.cgi";
$dbhost = "localhost";
$dbname = "***";
$dbuser = "***";
$dbpass = "***";
$email = "***";
/////////////////////////
//End Config Variables//
///////////////////////
class zipfile
{
var $datasec = array(); // array to store compressed data
var $ctrl_dir = array(); // central directory
var $eof_ctrl_dir = "\x50\x4b\x05\x06\x00\x00\x00\x00"; //end of Central directory record
var $old_offset = 0;
function add_dir($name)
// adds "directory" to archive - do this before putting any files in directory!
// $name - name of directory... like this: "path/"
// ...then you can add files using add_file with names like "path/file.txt"
{
$name = str_replace("\\", "/", $name);
$fr = "\x50\x4b\x03\x04";
$fr .= "\x0a\x00"; // ver needed to extract
$fr .= "\x00\x00"; // gen purpose bit flag
$fr .= "\x00\x00"; // compression method
$fr .= "\x00\x00\x00\x00"; // last mod time and date
$fr .= pack("V",0); // crc32
$fr .= pack("V",0); //compressed filesize
$fr .= pack("V",0); //uncompressed filesize
$fr .= pack("v", strlen($name) ); //length of pathname
$fr .= pack("v", 0 ); //extra field length
$fr .= $name;
// end of "local file header" segment
// no "file data" segment for path
// "data descriptor" segment (optional but necessary if archive is not served as file)
$fr .= pack("V",$crc); //crc32
$fr .= pack("V",$c_len); //compressed filesize
$fr .= pack("V",$unc_len); //uncompressed filesize
// add this entry to array
$this -> datasec[] = $fr;
$new_offset = strlen(implode("", $this->datasec));
// ext. file attributes mirrors MS-DOS directory attr byte, detailed
// at http://support.microsoft.com/support/kb/articles/Q125/0/19.asp
// now add to central record
$cdrec = "\x50\x4b\x01\x02";
$cdrec .="\x00\x00"; // version made by
$cdrec .="\x0a\x00"; // version needed to extract
$cdrec .="\x00\x00"; // gen purpose bit flag
$cdrec .="\x00\x00"; // compression method
$cdrec .="\x00\x00\x00\x00"; // last mod time & date
$cdrec .= pack("V",0); // crc32
$cdrec .= pack("V",0); //compressed filesize
$cdrec .= pack("V",0); //uncompressed filesize
$cdrec .= pack("v", strlen($name) ); //length of filename
$cdrec .= pack("v", 0 ); //extra field length
$cdrec .= pack("v", 0 ); //file comment length
$cdrec .= pack("v", 0 ); //disk number start
$cdrec .= pack("v", 0 ); //internal file attributes
$ext = "\x00\x00\x10\x00";
$ext = "\xff\xff\xff\xff";
$cdrec .= pack("V", 16 ); //external file attributes - 'directory' bit set
$cdrec .= pack("V", $this -> old_offset ); //relative offset of local header
$this -> old_offset = $new_offset;
$cdrec .= $name;
// optional extra field, file comment goes here
// save to array
$this -> ctrl_dir[] = $cdrec;
}
function add_file($data, $name)
// adds "file" to archive
// $data - file contents
// $name - name of file in archive. Add path if your want
{
$name = str_replace("\\", "/", $name);
//$name = str_replace("\\", "\\\\", $name);
$fr = "\x50\x4b\x03\x04";
$fr .= "\x14\x00"; // ver needed to extract
$fr .= "\x00\x00"; // gen purpose bit flag
$fr .= "\x08\x00"; // compression method
$fr .= "\x00\x00\x00\x00"; // last mod time and date
$unc_len = strlen($data);
$crc = crc32($data);
$zdata = gzcompress($data);
$zdata = substr( substr($zdata, 0, strlen($zdata) - 4), 2); // fix crc bug
$c_len = strlen($zdata);
$fr .= pack("V",$crc); // crc32
$fr .= pack("V",$c_len); //compressed filesize
$fr .= pack("V",$unc_len); //uncompressed filesize
$fr .= pack("v", strlen($name) ); //length of filename
$fr .= pack("v", 0 ); //extra field length
$fr .= $name;
// end of "local file header" segment
// "file data" segment
$fr .= $zdata;
// "data descriptor" segment (optional but necessary if archive is not served as file)
$fr .= pack("V",$crc); //crc32
$fr .= pack("V",$c_len); //compressed filesize
$fr .= pack("V",$unc_len); //uncompressed filesize
// add this entry to array
$this -> datasec[] = $fr;
$new_offset = strlen(implode("", $this->datasec));
// now add to central directory record
$cdrec = "\x50\x4b\x01\x02";
$cdrec .="\x00\x00"; // version made by
$cdrec .="\x14\x00"; // version needed to extract
$cdrec .="\x00\x00"; // gen purpose bit flag
$cdrec .="\x08\x00"; // compression method
$cdrec .="\x00\x00\x00\x00"; // last mod time & date
$cdrec .= pack("V",$crc); // crc32
$cdrec .= pack("V",$c_len); //compressed filesize
$cdrec .= pack("V",$unc_len); //uncompressed filesize
$cdrec .= pack("v", strlen($name) ); //length of filename
$cdrec .= pack("v", 0 ); //extra field length
$cdrec .= pack("v", 0 ); //file comment length
$cdrec .= pack("v", 0 ); //disk number start
$cdrec .= pack("v", 0 ); //internal file attributes
$cdrec .= pack("V", 32 ); //external file attributes - 'archive' bit set
$cdrec .= pack("V", $this -> old_offset ); //relative offset of local header
// echo "old offset is ".$this->old_offset.", new offset is $new_offset<br>";
$this -> old_offset = $new_offset;
$cdrec .= $name;
// optional extra field, file comment goes here
// save to central directory
$this -> ctrl_dir[] = $cdrec;
}
function file() { // dump out file
$data = implode("", $this -> datasec);
$ctrldir = implode("", $this -> ctrl_dir);
return
$data.
$ctrldir.
$this -> eof_ctrl_dir.
pack("v", sizeof($this -> ctrl_dir)). // total # of entries "on this disk"
pack("v", sizeof($this -> ctrl_dir)). // total # of entries overall
pack("V", strlen($ctrldir)). // size of central dir
pack("V", strlen($data)). // offset to start of central dir
"\x00\x00"; // .zip file comment length
}
}
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die("Unable to connect to database.");
$seldb = mysql_select_db($dbname) or die("Unable to select database.");
if(isset($_POST['update'])){
$zipfile = new zipfile();
$time = date("m-d-Y H:i:s");
$entries = file($flatfiledb);
mysql_query("DELETE FROM `vendas`");
$count=0;
$filedata = "";
foreach($entries as $value){
$count++;
$filedata .= $value;
$values = explode("|", $value);
$query = sprintf("INSERT INTO `vendas` SET `id`='%s',`date`='%s',`empresa`='%s',`url`='%s',`i nfo`='%s',`bairro`='%s',`tipo`='%s',`quartos`='%s' ,`situacao`='%s',`preco`='%s',`descricao`='%s',`ci dade`='%s',`estado`='%s',`field13`='%s',`field14`= '%s',`cep`='%s',`email`='%s',`destaque`='%s',`sist ema`='%s',`field19`='%s',`field20`='%s',`field21`= '%s',`field22`='%s',`mostraimovel`='%s',`status`=' %s',`userid`='%s';", mysql_real_escape_string($values[0]),mysql_real_escape_string($values[1]),mysql_real_escape_string($values[2]),mysql_real_escape_string($values[3]),mysql_real_escape_string($values[4]),mysql_real_escape_string($values[5]),mysql_real_escape_string($values[6]),mysql_real_escape_string($values[7]),mysql_real_escape_string($values[8]),mysql_real_escape_string($values[9]),mysql_real_escape_string($values[10]),mysql_real_escape_string($values[11]),mysql_real_escape_string($values[12]),mysql_real_escape_string($values[13]),mysql_real_escape_string($values[14]),mysql_real_escape_string($values[15]),mysql_real_escape_string($values[16]),mysql_real_escape_string($values[17]),mysql_real_escape_string($values[18]),mysql_real_escape_string($values[19]),mysql_real_escape_string($values[20]),mysql_real_escape_string($values[21]),mysql_real_escape_string($values[22]),
mysql_real_escape_string($values[23]),mysql_real_escape_string($values[24]),mysql_real_escape_string($values[25]));
$result = mysql_query($query);
if(!$result){
die("Unable to insert entries into database" . mysql_error());
}
}
$zipfile -> add_dir("backup/");
$zipfile->add_file($filedata, "backup/backup.cgi");
header("Content-type: application/octet-stream");
header("Content-disposition: attachment; filename=backup.zip");
print base64_encode($zipfile -> file());
die();
$headers = 'MIME-Version: 1.0' . "\n";
$headers .= 'Content-Type: multipart/mixed; boundary="----=_NextPart_001_0011_1234ABCD.4321FDAC"' . "\n";
$message = '
------=_NextPart_001_0011_1234ABCD.4321FDAC
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Attached is the backup for ' . $time . '
------=_NextPart_001_0011_1234ABCD.4321FDAC
Content-Type: application/octet-stream; name="';
$message .= "backup.zip";
$message .= '"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="';
$message .= "backup.zip";
$message .= '"
';
$message .= "$encoded";
$message .= '
------=_NextPart_001_0011_1234ABCD.4321FDAC--
';
mail($email,"Database Backup for " . $time,$message, $headers);
print "Database updated and now has " . $count . " entries!<br />";
print "<a href=\"./backup/" . $time . ".cgi\" target=\"_blank\">Database Backup</a><br />";
}
else{
?>
<form action="<?=$_SERVER['PHP_SELF']?>" method="POST">
<input type="submit" value="Update Database" name="update">
</form>
<?
}
?>
Can anyone find anything wrong with that..? http://codewalkers.com/seecode/65.html that's the class i'm using -- found it with google. There's nothing wrong with the part that updates the database, only with the last mailing part. I get the email and such with an attachment titled backup.zip... but it errors.
! C:\Documents and Settings\Harish\Local Settings\Temp\backup.zip: Unexpected end of archive