| 45 |
$order = 'a.name DESC'; |
$order = 'a.name DESC'; |
| 46 |
} |
} |
| 47 |
|
|
| 48 |
|
$database->setQuery("SELECT id FROM #__menu WHERE link = 'index.php?option=com_contact'"); |
| 49 |
|
$citemid = $database->loadResult(); |
| 50 |
|
|
| 51 |
$query = "SELECT a.name AS title," |
$query = "SELECT a.name AS title," |
| 52 |
. "\n CONCAT_WS( ', ', a.name, a.con_position, a.misc ) AS text," |
. "\n CONCAT_WS( ', ', a.name, a.con_position, a.misc ) AS text," |
| 53 |
. "\n '' AS created," |
. "\n '' AS created," |
| 54 |
. "\n CONCAT_WS( ' / ', '$section', b.title ) AS section," |
. "\n CONCAT_WS( ' / ', '$section', b.title ) AS section," |
| 55 |
. "\n '2' AS browsernav," |
. "\n '2' AS browsernav," |
| 56 |
. "\n CONCAT( 'index.php?option=com_contact&task=view&&contact_id=', a.id ) AS href" |
. "\n CONCAT( 'index.php?option=com_contact&task=view&Itemid=$citemid&contact_id=', a.id ) AS href" |
| 57 |
. "\n FROM #__contact_details AS a" |
. "\n FROM #__contact_details AS a" |
| 58 |
. "\n INNER JOIN #__categories AS b ON b.id = a.catid AND b.access <= '$my->gid'" |
. "\n INNER JOIN #__categories AS b ON b.id = a.catid AND b.access <= '$my->gid'" |
| 59 |
. "\n WHERE ( a.name LIKE '%$text%'" |
. "\n WHERE ( a.name LIKE '%$text%'" |
Parent Directory
| 
Revision Log
| 
Patch
