Forums

This is a modified version of the extension Chronoconnectivity V2 RC3 Chronoengine to allow the management of multi-table query.

Substantive changes were made ​​to the file in the original version is in this position components / com_chronoconnectivity / libraries / connection.php . The changes are as follows.

198 line has been commented and replaced by the following where you removed the reference to the single connection configuration shown in Table

/ / $ Query = "SELECT * FROM". $ MyConnection-> connectionrow-> tablenames;
$ query = "SELECT * FROM";

Line 214 has been inserted in the variable $ total global statement, which represents the number of records found by the query. This will have the variable $ total fields in the connection header, footer and body avoiding to insert new code for calculating the record that is already done by the component.

global $ mainframe, $ total; {/} codecitation

Line 229 was replaced by the following commentary and where you removed the reference to the single connection configuration shown in Table

/ / $ Database-> setQuery ("SELECT count (*) FROM". $ MyConnection-> connectionrow-> tablenames. "." Trim ($ WHERE));
$ database-> setQuery ("SELECT count (*) FROM" ".." trim ($ WHERE));

Other changes concern the amendment of all references to chronconnectivity that have been replaced with chronoconnectivity2 in all files of the original extension in order to give full autonomy in the new joomla.

These changes will now be able to enter in the SQL WHERE clause conditions of not only where but the inclusion of all the tables you want in the query definition. Virtually everything that is normally in the query FROM onwards. This is evident if we look at the changed rows. Practically can now be placed not only WHERE but any command is necessary to define the query. So the field name WHERE SQL connection must be understood in this new meaning.