# MySQL

# Begin the Editing of the MySQL File
open (FILE,"$mysql") || die "Can't Open $mysql: $!\n";
@LINES=<FILE>;
close(FILE);
$SIZE=@LINES;

# Open Link File to Output
open (MYSQL,">$mysql") || die "Can't Open $mysql: $!\n";

for ($i=0;$i<=$SIZE;$i++) {
   $_=$LINES[$i];
   if (/<!--begin-->/) {


      if ($entry_order eq '1') {
        
      }

{
         print MYSQL "INSERT INTO `mysql_db` (`Title`, `Email`, `City`, `State`, `Country`, `URL`, `Date`, `Description`, `rid`, `dt_create`, `publish`, ) VALUES (";
      }


      if ($line_breaks == 1) {
         $FORM{'Title'} =~ s/\cM\n/\n/g;
      }

      print MYSQL "$FORM{'Title'}";

print MYSQL ", ";

      if ( $FORM{'Email'} ){
	my $email_name = $dbh->quote($FORM{'Email'});

#         if ($linkmail eq '1') {
            print MYSQL $email_name;

#         }
#         else {
#            print MYSQL "$FORM{'Email'}";
#         }

         print MYSQL ", ";
      }

      if ( $FORM{'City'} ){
         print MYSQL "$FORM{'City'}";
      }
     {
         print MYSQL ", ";
      }
      if ( $FORM{'State'} ){
         print MYSQL "$FORM{'State'}";
      }
{
         print MYSQL ", ";
      }
      if ( $FORM{'Country'} ){
         print MYSQL "$FORM{'Country'}";
      }
{
         print MYSQL ", ";
      }

if ($FORM{'URL'}) {
         print MYSQL "$FORM{'URL'}";
      }
      else {
         print MYSQL "$FORM{'URL'}";
      }
{
         print MYSQL ", ";
      }

if ($separator eq '1') {
         print MYSQL "'$date'";
      }
      else {
         print MYSQL "'$date'";
      }
{
         print MYSQL ", ";
      }
      
if ( $FORM{'Description'} ){
         print MYSQL "$FORM{'Description'}, '', NOW(), 0) \n\n";


      }

           if ($entry_order eq '0') {
         print MYSQL "<!--begin-->\n";
      }

   }
   else {
      print MYSQL $_;
   }
}

close (MYSQL);

my $content;
open FILE, '<', $mysql; # Open a filehandle FILE to $mysql 

while (<FILE>) {
   chomp; # delete any EOL character(s)
   $content .= $_; # Add the next line to the previous parts
}

$sth=$dbh->prepare($content);
$sth->execute();

close (MYSQL);

$dbh->disconnect;