View difference between Paste ID: f37912925 and

-
+<?php
 
 include error_reporting(0);
 
 // Connect to database of your joomla site
 
 $host = 'localhost';
 $dbusername = 'xxx';
 $dbpassword = 'xxxx';
 $dbname = 'xxxx';
 $filename = 'yourfilename.txt';
 
 $conn1 = mysql_connect("$host", "$dbusername", "$dbpassword") or die("Connection Failed");
 mysql_select_db("$dbname" ,$conn1)or die("Connection to LIVE database failed!");
 
 // Set mysql character set
 mysql_query("SET NAMES 'utf8'");
 
 
 // Little clean up function
 function cleanup($srting)
 {
 	$srting = trim($srting);
 	$srting = rtrim($srting);
 	$srting = str_replace('<br>','', $srting);
 	$srting = str_replace('\n','', $srting);
 	$srting = str_replace('\r','', $srting);
 	$srting = str_replace('-','', $srting);
 	$srting = preg_replace('/\s\s+/',' ', $srting);
 	return $srting;
 }
 
 
 function str2upper($text){
    return strtr($text,
    "abcdefghijklmnopqrstuvwxyz".
    "\xB1\xE6\xEA\xB3\xF1\xF3\xB6\xBC\xBF". // ISO 8859-2
    "\xB9\x9C\x9F", // win 1250
    "ABCDEFGHIJKLMNOPQRSTUVWXYZ".
    "\xA1\xC6\xCA\xA3\xD1\xD3\xA6\xAC\xAF". // ISO 8859-2
    "\xA5\x8C\x8F"  // win 1250
    );
 }
 
 $file = file_get_contents("./$filename");
 
 echo "File is loaded! <br />";
 
 flush();
 
 
 
 $a=0;
 $b=12600;  // Number of tearms (lines) in your file
 
 while ($a < $b){
 
 $rows = explode("\t", $file);
 $rows = explode("\t", $rows[$a]);
 $rows = $rows[0];
 
 $ime = explode("(", $rows);
 $ime = $ime[0];
 $naziv = explode("-", $ime);
 $naziv = $naziv[0];
 $naziv = cleanup($naziv);
 $naziv = mysql_real_escape_string($naziv);
 
 
 $slovo = mb_substr($naziv,0,1,'UTF-8');
 $slovo = str2upper($slovo);
 if ($slovo == ' ' or $slovo == '')
 {
 	$slovo = mb_substr($naziv,1,2,'UTF-8');
     $slovo = str2upper($slovo);
 }
 
 $slovo = str_replace('&#269;','&#268;', $slovo);
 $slovo = str_replace('&#263;','&#262;', $slovo);
 $slovo = str_replace('�','�', $slovo);
 $slovo = str_replace('�','�', $slovo);
 $slovo = str_replace('&#273;','&#272;', $slovo);
 
 
 $slovo = mysql_real_escape_string($slovo);
 
 $opis = explode(''.$naziv.'', $rows);
 $opis = explode("\t", $opis[1]);
 $opis = $opis[0];
 $opis = cleanup($opis);
 $opis = mysql_real_escape_string($opis);
 
 $opis_no = strlen($opis);
 
 $date = date('Y-m-d H:i:s');
 
 // Check if term is alredy in databese
 
 $result = mysql_query("SELECT * FROM jos_glossary WHERE tterm = '$naziv' LIMIT 1",$conn1) or die(mysql_error($conn1));
 $row = mysql_fetch_row($result);
 if ($row != '') {$check = 'NO';}
 elseif ($row == '') {$check = 'UPDATE';}
 
 
 // if not update db
 if ($check == 'UPDATE' and $opis_no > 3)
 {
 
 echo '<br />- Slovo: '.$slovo.' -  Ime: '.$naziv.' Opis : '.$opis.'<br />';
 
 
 flush();
 
 $sql = "INSERT INTO `YOUR_DATABASE_PNAME`.`jos_glossary`
 							(
 							 		 `tletter`,
 									 `tterm`,
 									 `tdefinition`,
 									 `tdate`,
 									 `teditdate`,
 									 `published`,
 									 `catid`,
 									 `checked_out`
 
 						 ) VALUES (
 									'$slovo',
 									'$naziv',
 									'$opis',
 									'$date',
 									'$date',
 									'1',
 									'1',
 									'0');";
 
 
 
 mysql_query($sql, $conn1) or die(mysql_error($conn1));
 
 }
 else {
 	$a++;
 	} // IF End
 
 
 $a++;
 }// While end
 
 
 ?>