Bypass node_access table

This is caused by http://api.drupal.org/api/function/node_db_rewrite_sql/6

It rewrites the output of queryies runned with db_rewrite_sql. Really be sure, you know what you are doing, the users could see nodes, which they shouldn't be able.

It would be better if you extend the views_plugin_query_default class and change the execute method and remove the call to db_rewrite_sql

Hello,

Does anyone have any examples on how to override the views_plugin_query_default class or point me to some documentation/existing modules that implement this functionality? I want to implement my own execute method to work around the native views_pre_execute hook where I want to control the Sql that is executed. I cannot find a starting point so if someone could point me in the right direction, I would greatly appreciate it.

THanks,
G

Starting point:

1. Implement hook_views_api
2. implement hook_views_data_alter:
   There you change

     $data['yourtable']['table']['base']['query class'] = 'yourqueryclass';
   

3. In your query class extend the default one, but don't do the db_rewrite_sql

Thats it.

There is already another issue with the same request. It would be cool if someone could find it :)

thank you for the quick response. I will post my example once I am completed for others and I will look for the other issue and post the link once I find it.

Sorry I am newer to php so please forgive the following..

Do I need to implement all of the other methods of the default class similar to an interface in java or c# or can I only override the execute functionality?

G

You can use

class yourclass extends views_plugin_query_default {
}

Then you don't have to write all methods. Just like every other polymorphismn.

Hello

Thank you for the help.

I have not located a similar example so please forgive my ignorance and I have not found any documentation on the hook views_data_alter. Most other examples that implement the views_data_alter hook implement handlers for relationships or filters. I am not trying to use either of these concepts and was hoping you could provide some more guidance.

I understand the extending piece of the class thank you. However, I am trying to filter the nodes in the view to include matching nodes based on the user driveeen preference set in the the user profile.

So for my hook definition I assume I would use the following in the modulename_views.inc:

$data['node']['table']['base']['query class'] = 'yourqueryclass';

and then include the query class in the modulename_views.inc.

Could you please verify my thoughts and add any suggestions?

Thanks
G

I am really interested in this; I need to list inside a node a list of other nodes which shouldn't be visible for the user. Is there a way to "dissable" db_rewrite_sql() and just call db_query() for a view?

enboig: That's really the same question as the issue poster. There is a patch for 3.x which allows this.

But sadly by design this is only for 3.x

This issue has been addressed in views 3.x.