<?php set_time_limit(0); //init Joomla Framework define( '_JEXEC', 1 ); define( 'JPATH_BASE', dirname(".")); define( 'DS', DIRECTORY_SEPARATOR ); ?><html>
<head> <title>Joomfish Upgrade from joomla 1.5 to joomla 2.5 deverloped by http://joomquery.com </title> </head> <body style="text-align:center;"> <div style="width:980px; margin:0 auto; text-align:center"> <?php require_once ( JPATH_BASE .DS.'includes'.DS.'defines.php' ); require_once ( JPATH_BASE .DS.'includes'.DS.'framework.php' ); require_once( JPATH_CONFIGURATION .DS.'configuration.php' ); require_once ( JPATH_BASE .DS.'includes'.DS.'database.php' ); require_once ( JPATH_LIBRARIES .DS.'joomla'.DS.'import.php' ); //require_once ( JPATH_BASE .DS.'libraries'.DS.'joomla'.DS.'factory.php' );
//DB Connection $Config = new JConfig();
$option['driver'] = $Config->dbtype; // Database driver name $option['host'] = $Config->host; // Database host name $option['user'] = $Config->user; // User for database authentication $option['password'] = $Config->password; // Password for database authentication $option['database'] = $Config->db; // Database name $option['prefix'] = $Config->dbprefix; // Database prefix (may be empty) //echo $Config->dbprefix; $db = & JDatabase::getInstance($option); $query = $db->getQuery(true);
$query = "SELECT * FROM "."music_jf_content ORDER by id";
$db->setQuery($query); $rows = $db->loadObjectList();
echo 'Total: '.count($rows).'Rows'; if($rows){ foreach ($rows as $row){ $insert_query = "INSERT INTO j25_falang_content VALUES (".$row->id.";'".$row->language_id."';'".$row->reference_id."';'".$row->reference_table."';'".$row->reference_field."';'".$row->value."';'".$row->original_value."';'".$row->original_text."';'".$row->modified."';'".$row->modified_by."';'".$row->published."';)";
setQuery($insert_query); echo '<p style="color:green"><span>'.$row->id.' </span><span>'.$row->reference_table.' </span><span>'.$row->modified.'</span></p><br />'; } } //jos_jf_tableinfo $query_tableinfo = "SELECT * FROM "."music_jf_tableinfo ORDER by id"; $db->setQuery($query_tableinfo); $rows_tableinfo = $db->loadObjectList(); if($rows_tableinfo){ foreach ($rows_tableinfo as $row){ $insert_query_tableinfo = "INSERT INTO j25_falang_tableinfo VALUES (".$row->id.";'".$row->joomlatablename."';'".$row->tablepkID."')";
setQuery($insert_query_tableinfo); //echo '<p style="color:green"><span>'.$row->id.' </span><span>'.$row->reference_table.' </span><span>'.$row->modified.'</span></p><br />'; } } ?> <p> This script developed by Mr Lamvt <br /> Website:<a href="http://joomquery.com" title="Joomla free templates">JoomQuery.Com</a> <br /> Website:<a href="http://www.softbuzz.net" title="Download your favorite software! - softbuzz.net">SoftBuzz.Net</a> <br />
</p> </div> </body> </html>