function import()
{
$app = JFactory::getApplication();
//DB Connection
$Config = new JConfig();
$host = $Config->host;
$user = $Config->user;
$pass = $Config->password;
$name = $Config->db;
$prefix = $Config->dbprefix;
$return = "";
$link = mysql_connect($host, $user, $pass);
mysql_select_db($name, $link);
if ($_FILES["file"]["error"] > 0) {
$str = "Error: " . $_FILES["file"]["error"] . "<br />";
$app->enqueueMessage($str);
} else {
$str = "<br /><br />Upload: " . $_FILES["file"]["name"] . "<br />";
$str .= "Type: " . $_FILES["file"]["type"] . "<br />";
$str .= "Size: " . $_FILES["file"]["size"] / 1024 . " Kb<br />";
$str .= "Stored in: " . $_FILES["file"]["tmp_name"] . " <br /><br />";
$app->enqueueMessage($str);
// let's pretend that connection to server is established
// and database chosen...
/*$sql = explode(';#%%', file_get_contents ($_FILES["file"]["tmp_name"]));
$n = count ($sql) - 1;
for ($i = 0; $i < $n; $i++) {
$query = $sql[$i];
echo $query."<br>";
$result = mysql_query ($query) or die ('<p>Query: <br><tt>' . $query . '</tt><br>failed. MySQL error: ' . mysql_error());
}
*/
$file_content = file($_FILES["file"]["tmp_name"]);
$cont = 0;
foreach ($file_content as $sql_line) {
if (trim($sql_line) != "" && strpos($sql_line, "--") == false) {
//echo $sql_line.'<br/><br/>';
mysql_query($sql_line);
$cont++;
}
}
$app->enqueueMessage(JTEXT::_("IMPORT OK") . ":" . $cont . " SQL");
}
// Load the submenu.
fieldsattachHelper::addSubmenu(JRequest::getCmd('view', 'fieldsattach'));
parent::display();
}
