Index: /trunk/doc/CHANGES.txt
===================================================================
--- /trunk/doc/CHANGES.txt (リビジョン 55)
+++ /trunk/doc/CHANGES.txt (リビジョン 57)
@@ -1,3 +1,7 @@
 foltia 更新履歴 http://www.dcc-jpl.com/soft/foltia/
+
+07.6.6
+updatem2pfiletable.pl:
+　AutoCommitを使用せずに高速化をした。
 
 07.5.7
Index: /trunk/install/perl/updatem2pfiletable.pl
===================================================================
--- /trunk/install/perl/updatem2pfiletable.pl (リビジョン 54)
+++ /trunk/install/perl/updatem2pfiletable.pl (リビジョン 57)
@@ -28,4 +28,5 @@
 	 $dbh = DBI->connect($data_source,$DBUser,$DBPass) ||die $DBI::error;;
 
+$dbh->{AutoCommit} = 0;
 #　ひとまず消す
 $query =  "DELETE  FROM  foltia_m2pfiles  ";
@@ -36,11 +37,10 @@
 $file =~ s/$recfolderpath\///;
 $query =  "insert into  foltia_m2pfiles values ('$file')";
-	 $sth = $dbh->prepare($query);
-	$sth->execute();
+$oserr = $dbh->do($query);
 # print "$file\n";
 }#while
+$oserr = $dbh->commit;
 
 # foltia_mp4files
-
 #　ひとまず消す
 $query =  "DELETE  FROM  foltia_mp4files  ";
@@ -49,14 +49,8 @@
 
 @mp4filelist = `find ${recfolderpath}/ | grep MP4`;#by foltia dev ticket #5 http://www.dcc-jpl.com/foltia/ticket/5
-# find /home/foltia/php/tv/ | grep MP4
-
-#/home/foltia/php/tv/1057.localized/mp4/M4V-1057-14-20061016-2345.MP4
-#/home/foltia/php/tv/1057.localized/mp4/M4V-1057-15-20061023-2345.MP4
 
 foreach (@mp4filelist) {
 chomp();
 s/$recfolderpath\///;
-# 1057.localized/mp4/M4V-1057-14-20061016-2345.MP4
-# 1057.localized/mp4/M4V-1057-15-20061023-2345.MP4
 @fileline = split (/\//);
 $filetid = $fileline[0];
@@ -64,9 +58,9 @@
 
 $query =  "insert into  foltia_mp4files values ('$filetid','$fileline[2]')";
-	 $sth = $dbh->prepare($query);
-	$sth->execute();
-
+$oserr = $dbh->do($query);
 #print "$filetid;$fileline[2];$query\n"
 # http://www.atmarkit.co.jp/fnetwork/rensai/sql03/sql1.html
 
 }
+$oserr = $dbh->commit;
+
Index: /trunk/install/php/StarlightBreaker /sb-edit.php
===================================================================
--- /trunk/install/php/StarlightBreaker /sb-edit.php (リビジョン 56)
+++ /trunk/install/php/StarlightBreaker /sb-edit.php (リビジョン 57)
@@ -120,6 +120,5 @@
 $subject = getform(subject); 
 $maintext = getform(textarea); 
-//$replaced = preg_replace ('/\n/', '$1<br />',$maintext ) ;
-$maintext = mbereg_replace("\n","<br />\n", $maintext);
+//$maintext = mbereg_replace("\n","<br />\n", $maintext);
 $rate = getform(rank4);
 
@@ -151,5 +150,5 @@
 $subject = $ratechara . $subject;
 
-print "". htmlspecialchars(stripslashes( $subject)) ."<br />\n";
+print "". htmlspecialchars(stripslashes( $subject)) ."\n";
 print "". stripslashes( $maintext) ."<br />\n";
 print "<br />\n";