OSCload 2.0 oscommerce new generation Code

<?php
/*
  Released under the GNU General Public License
*/

require('includes/application_top.php');
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_JOOMLINK_ARTICLES);

// joomla connection
$db_link='joomlink';
tep_db_connect(JOOM_DB_SERVER, JOOM_DB_USERNAME, JOOM_DB_PASSWORD,JOOM_DB_DATABASE,$db_link);

// query stuff
$articles_query = "
		SELECT
		con.id,
		con.title AS contitle,
		con.introtext,
		sec.title AS sectitle,
		cat.title AS cattitle
		FROM
		".JOOM_DB_PREFIX."content con,
		".JOOM_DB_PREFIX."categories cat,
		".JOOM_DB_PREFIX."sections sec
		WHERE
		con.state = '1' AND
		con.sectionid = sec.id AND
		con.catid = cat.id
		ORDER BY
		con.modified DESC,
		con.created DESC
		LIMIT ".(int)JOOMLINK_MAXARTICLE;
$articles = mysql_query($articles_query);

$joomla_menu_query = "
		SELECT
		id
		FROM
		".JOOM_DB_PREFIX."menu
		WHERE
		menutype = 'mainmenu' AND
		link = 'index.php?option=com_content&view=frontpage'
		LIMIT 1";
$joomla_menu = tep_db_fetch_array(mysql_query($joomla_menu_query));


//close joomla db
tep_db_close($db_link);
//switch back to osc 
tep_db_connect();


$content = CONTENT_JOOMLINK_ARTICLES;
require(DIR_WS_TEMPLATES . TEMPLATE_NAME . '/' . TEMPLATENAME_MAIN_PAGE);
require(DIR_WS_INCLUDES . 'application_bottom.php');

?>