Example #1
0
     }
 }
 if ($installer->hasPermissions($update["privileges"])) {
     $sql_file = "protected/update_{$version}.sql";
     if (!file_exists($sql_file)) {
         $installer->addErrorMessage("Could not open sql file: " . $sql_file . ".  If this file does not exist you must download new install files.");
     } else {
         //run the file - checking for errors at each SQL execution
         $f = fopen($sql_file, "r");
         $contents = fread($f, filesize($sql_file));
         $statements = explode(';', $contents);
         //Process the sql file by statements
         foreach ($statements as $statement) {
             if (strlen(trim($statement)) > 3) {
                 //replace the DATABASE_NAME parameter with what was actually input
                 $statement = str_replace("_DATABASE_NAME_", $installer->getDatabaseName(), $statement);
                 $result = mysql_query($statement);
                 if (!$result) {
                     $installer->addErrorMessage(mysql_error() . "<br /><br />For statement: " . $statement);
                     break;
                 }
             }
         }
         if (!$installer->hasErrorMessages()) {
             $installer->addMessage("Update {$version} was successfully applied.");
             header('Location: index.php');
             exit;
         }
     }
 } else {
     if (!$installer->hasErrorMessages()) {