AAAAhome/academiac/www/administrator/components/com_chronoforms/versions/db_updates.php000060400000002472151372314630025152 0ustar00getTableFields(array($table_name), false); $table_fields = $results[$table_name]; $table_fields = array_keys($table_fields); //add new columns $columns = array( 'app' => "VARCHAR( 100 ) NOT NULL DEFAULT ''" ); foreach($columns as $f => $data){ if(!in_array($f, $table_fields)){ $sql = "ALTER TABLE `#__chronoforms` ADD `".$f."` ".$data.";"; $database->setQuery($sql); if (!$database->query()) { JError::raiseWarning(100, $database->getErrorMsg()); }else{ $updates++; } } } $mainframe->enqueueMessage("Applied '".$updates."' Database updates successfully."); } } ?>