$num fields in line $row:
\n";
//$row++;
//for ($c=0; $c < $num; $c++) {
echo $data[1] . "**".$data[7]."
\n";
$query="INSERT INTO `recensement` ( `Id_saisie` , `Id_forum` , `Pseudo` , `Avatar` , `An` , `Type` , `Numero` , `Année` , `Region` , `Modele` )
VALUES (";
$query.="'".$data[1]."',";
$query.="'".$data[7]."',";
$query.="'',";
$query.="'',";
$query.="'".$data[2]."',";
$query.="'".$data[3]."',";
$query.="'".$data[4]."',";
$query.="'".substr ( $data[5] , 0,2 )."',";
$query.="'".$data[9]."',";
$query.="'".$data[12]."'";;
$query.=");";
mysql_query ( $query );
$query='UPDATE recensement INNER JOIN phpbb_users ON
recensement.Id_forum=phpbb_users.user_id SET recensement.Pseudo = phpbb_users.username';
mysql_query ( $query );
$query='UPDATE recensement INNER JOIN phpbb_users ON
recensement.Id_forum=phpbb_users.user_id SET recensement.Avatar = phpbb_users.user_avatar';
mysql_query ( $query );
$query='UPDATE recensement SET Avatar = "inconnu.bmp" WHERE Avatar = ""';
mysql_query ( $query );
// }
}
fclose($handle);
/*
// connexion
@mysql_connect($host,$user,$pass)
or die("Impossible de se connecter 1");
@mysql_select_db($bdd)
or die("Impossible de se connecter 2");
$query="SELECT * FROM `phpbb_posts_text`WHERE `post_text` LIKE '%[img%%'";
$post_texte=mysql_query($query);
while ($val_post_texte= mysql_fetch_array($post_texte))
{
echo($val_post_texte['post_id'].'
');
// Your code here
$flag=0;
$post_id=$val_post_texte['post_id'];
$page =$val_post_texte['post_text'];;
$img=explode("[img:",$page);
for($i=0;$i640) $flag=1;
}
// suppression balise [img
//Grande image
if ($flag==1)
{
$patterns[0] = '/\[img:..........\]/';
$replacements[0] = '
';
}
else
{
$patterns[0] = '/\[img:..........\]/';
$replacements[0] = '
';
}
//changer les ' par \'
$patterns[2] = "/'/";
$replacements[2] = "\\'";
$page=preg_replace($patterns, $replacements, $page);
$flag=0;
echo $page;
$query="UPDATE `phpbb_posts_text` SET `post_text` = '".$page."'"." WHERE `post_id` = '".$post_id."';";
$fic_id=fopen("update.sql","a");
fwrite($fic_id,$query);
fclose($fic_id);
};
//echo $query;*/
?>