little help here pls

Greeting , people i like to remove the folowing queries (i dont use them) can someone tell me from were ?

SELECT g1.group_id, g1.name
FROM jos_core_acl_aro_groups g1
LEFT JOIN jos_core_acl_aro_groups g2 ON g2.lft >= g1.lft
WHERE g2.group_id =25
ORDER BY g1.name

SELECT f.* FROM jos_comprofiler_fields f
INNER JOIN jos_comprofiler_tabs AS t ON (f.tabid = t.tabid)
WHERE f.published = 1 AND f.profile != 0 AND t.enabled = 1 AND t.useraccessgroupid IN (24,19,20,23,30,29,21,18,17,25,28,-2,-1)
ORDER BY t.position, t.ordering, f.ordering

Sorry, I do not understand what you are asking.

Remove them from where?

You can't just remove queries from CB.. those queries are performing an ACL and access check. So no, doesn't matter where, but no. If you still want them removed you'll need to find them and remove them at your own risk. Sorry, we do not help with self-destructive changes nor do we assist with core edits.

Post edited by: krileon, at: 2010/12/21 19:08

Is not a "self-destructive change" this features actually ar doing wath ?
To display simple tabs i dont need my GID or access check , i put my own rules on tabs or plugins.
Why do we need to conect to 3 tables wen in jos_users we have the "gid" and the query

I just want to reduce the huge numbers of queries thats all never mind "removed" and nothing bad happend

Post edited by: cemainickam, at: 2010/12/21 21:12

The query is getting a list of parent or child ACL groups. You can't just remove this. You're welcome to search and find where the query is being executed and removing it, but you'll probably break your entire CB install.

Also reduction of queries is not going to help your sites performance. PHP load is what slows a site down (try uninstalling some un-necessary extensions), MYSQL is quite fast.

Simply because you do not understand what it does doesn't give just cause to remove it. However, it is your installation and you are free to do as you wish, but please if the edits are performed do not come requesting assistance if a problem occurs as we can not provide help once a core edit has been made.

is not an answer ... maybe you dont know , if you do then just post it here

I do know, but I won't be advising you on how to break our extension and your installation.. that is counter productive as you'd likely return wondering why XYZ is not working and waste many hours of our time trying to fix it.

You'll need to find and make these adjustments your self. All of CBs library can be found at administrator/components/com_comprofiler/library/cb/.

no need to play the smart one or to be arrogant like nant

Slandering one of our team members is also no way of receiving assistance.. Nick simply stated he didn't understand what you were asking.

Thread locked.

Post edited by: krileon, at: 2010/12/21 21:24