Check if a field is publish or not

Check if a field is publish or not

Hi,

in one of my plugin i need to know if a field is publish or not

for no the only solution i found is a sql query :

[code:1]$cb_plfile_publish = "SELECT published FROM #__comprofiler_fields WHERE name='cb_plfile'";
$_CB_database->setQuery( $cb_plfile_publish );
$cb_plfile_publish = $_CB_database->loadResult();[/code:1]

is there a more simple way to have this information ? i want to reduce sql query.


Thanks for your support !

any idea ?

Can an admin asnwer ? Thanks!

bab2on wrote:

Can an admin asnwer ? Thanks!

You're already using likely the most lightweight way of doing so.

Why are you needing to frequently check if a field is published or not? If you want to reduce the queries you should cache the result in a static variable.

Also depends on where you're trying to obtain a fields status; if outside of CB you can use CB API after including it (see tutorials in signature).

Hi, Thanks for answering.

I need to check this because my plugin have several parameters set by some fields allow or not by the administrator, the plugin react differently according to those settings.

those setting can be change at any time by the admin, so the plugin each time is call have to check this.


For static variable don't know well this ... so i have to check if it can do the job.


and it's inside CB (plugin for CB)