Magento database configuration file changed

MySQL database connection details such as hostname, database name, username etc of a Magento, you find that information into the file:

/app/etc/local.xml

Find the below lines in the file

<connection>
<host><![CDATA[hostname]]></host>
<username><![CDATA[Database Username]]></username>
<password><![CDATA[Database Password]]></password>
<dbname><![CDATA[Database Name]]></dbname>
<active>1</active>
</connection>

Virtuemart - Change Ascending / descending sort default on Browse page

Make a change to the file located in,

administrator/components/com_virtuemart/html/shop_browse_queries.php

Line #23

$DescOrderBy = $vmInputFilter->safeSQL( $vm_mainframe->getUserStateFromRequest( "browse{$keyword}{$category_id}{$manufacturer_id}DescOrderBy", 'DescOrderBy', "ASC" ) );

Change to:

$DescOrderBy = $vmInputFilter->safeSQL( $vm_mainframe->getUserStateFromRequest( "browse{$keyword}{$category_id}{$manufacturer_id}DescOrderBy", 'DescOrderBy', "DESC" ) );