View Single Post
Old 04-30-2005, 05:11 PM   #8
vodevil
Green Mole
 
Join Date: Mar 2005
Posts: 11
This is my new modification

Code:
//=================================================
//delete a spider reccord and content file
function PhpDigDelSpiderRow($id_connect,$spider_id,$ftp_id='')
{
global $relative_script_path,$ftp_id;
$query = "DELETE FROM ".PhpDig_DB_PREFIX."engine WHERE spider_id=$spider_id";
$result_id = mysql_query($query,$id_connect);
$query = "DELETE FROM ".PhpDig_DB_PREFIX."spider WHERE spider_id=$spider_id;";
$result_id = mysql_query($query,$id_connect);
// PhpDigDelText($relative_script_path,$spider_id,$ftp_id);
   PhpDigDelText($spider_id,$ftp_id);
}



// =============================
// Ecriture dans Mysql
// print "Erreur d'écriture dans Mysql ! $br";

function PhpDigWriteText($relative_script_path,$spider_id,$text,$ftp_id='') {
global $br;
if (CONTENT_TEXT ==1) {

$file_text_path = mysql(" SELECT * FROM 'PhpDigtext_content' ORDER BY 'spider_id' ");

if($f_handler = $file_text_path ) {
reset($text);
while (list($n_chunk,$text_to_store) = each($text)) {

mysql_query(" INSERT INTO PhpDigtext_content (spider_id, content) VALUES ('$spider_id','$text_to_store')", $id_connect);
  }

}

// Here the mysql case
if (FTP_ENABLE) {
$ftp_id = PhpDigFtpKeepAlive($ftp_id);

// @delete @ftp_delete($ftp_id,$spider_id.'.txt');

$delete = mysql_query(" DELETE 'PhpDigtext_content' WHERE 'spider_id' = '$spider_id' ");
$res_ftp = false;
$try_count = 0;
while (!$res_ftp && $try_count++ < 10) {

  $res_ftp = mysql(" INSERT INTO PhpDigtext_content (spider_id) VALUES ('$spider_id'), $id_connect);
                if (!$res_ftp) {
                            sleep(2);

}

                  if (!$res_ftp) {

                                   echo 'Unable to wgite in ! $br';

         }
 
      }

    }

       else {
              echo 'Warning : Imposible d\'écrire dans Mysql file $file_text_path ! $br';

 }

}

 return $ftp_if;

}

//=================================================
//delete a content_text from a spider_id
function PhpDigDelText($relative_script_path,$spider_id,$ftp_id='')
{
if (CONTENT_TEXT == 1)
{

//there delete the ftp file
if (FTP_ENABLE && $ftp_id)
             @$delete = 1;
}
}



// =============================

function PhpDigFtpConnect()
{
 if (CONTENT_TEXT == 1 && FTP_ENABLE== 1) {
 $count = 0;
 global $br;

 while ($count++ < 10) {

                $ftp_id = 1;


    }
    
    return $ftp_id; 
 
  }
   sleep(2); 
 
}


// =============================
// close ftp if exis

 function PhpDigFtpClose($ftp_id)
{
 if ($ftp_id)
    @ftp_quit($ftp_id);
}

It's work at 98% but this function , cause a bug ,


Code:
//=================================================
//delete a content_text from a spider_id
function phpdigDelText($relative_script_path,$spider_id,$ftp_id='')
{
if (CONTENT_TEXT == 1)
{


$query = "SELECT * FROM 'phpdigtext_content' WHERE spider_id = '$spider_id' ";

$file_text_path =mysql_query($query,$id_connect);


//there delete the ftp file


if (FTP_ENABLE && $ftp_id)
    $delete = mysql_query(" DELETE FROM 'phpdigtext_content' WHERE spider_id=$spider_id ");
}

}
vodevil is offline   Reply With Quote