db_rewrite_sql

Related topics

Namesort iconDescription
Database abstraction layerAllow the use of different database servers using the same code base.

Functions that call db_rewrite_sql()

Namesort iconLocationDescription
blog_blockdrupal/modules/blog/blog.moduleImplementation of hook_block().
blog_blockdrupal/modules/blog/blog.moduleImplementation of hook_block().
blog_feed_lastdrupal/modules/blog/blog.moduleDisplays an RSS feed containing recent blog entries of all users.
blog_feed_lastdrupal/modules/blog/blog.moduleDisplays an RSS feed containing recent blog entries of all users.
blog_feed_userdrupal/modules/blog/blog.moduleDisplays an RSS feed containing recent blog entries of a given user.
blog_feed_userdrupal/modules/blog/blog.moduleDisplays an RSS feed containing recent blog entries of a given user.
blog_page_lastdrupal/modules/blog/blog.moduleDisplays a Drupal page containing recent blog entries of all users.
blog_page_lastdrupal/modules/blog/blog.moduleDisplays a Drupal page containing recent blog entries of all users.
blog_page_userdrupal/modules/blog/blog.moduleDisplays a Drupal page containing recent blog entries of a given user.
blog_page_userdrupal/modules/blog/blog.moduleDisplays a Drupal page containing recent blog entries of a given user.
book_admin_orphandrupal/modules/book/book.moduleMenu callback; displays a listing of all orphaned book pages.
book_admin_orphandrupal/modules/book/book.moduleMenu callback; displays a listing of all orphaned book pages.
book_admin_overviewdrupal/modules/book/book.moduleReturns an administrative overview of all books.
book_admin_overviewdrupal/modules/book/book.moduleReturns an administrative overview of all books.
book_blockdrupal/modules/book/book.moduleImplementation of hook_block().
book_blockdrupal/modules/book/book.moduleImplementation of hook_block().
book_exportdrupal/modules/book/book.moduleMenu callback; Generates various representation of a book page with all descendants and prints the requested representation to output.
book_exportdrupal/modules/book/book.moduleMenu callback; Generates various representation of a book page with all descendants and prints the requested representation to output.
book_locationdrupal/modules/book/book.moduleGiven a node, this function returns an array of 'book node' objects representing the path in the book tree from the root to the parent of the given node.
book_locationdrupal/modules/book/book.moduleGiven a node, this function returns an array of 'book node' objects representing the path in the book tree from the root to the parent of the given node.
book_location_downdrupal/modules/book/book.moduleGiven a node, this function returns an array of 'book node' objects representing the path in the book tree from the given node down to the last sibling of it.
book_location_downdrupal/modules/book/book.moduleGiven a node, this function returns an array of 'book node' objects representing the path in the book tree from the given node down to the last sibling of it.
book_menudrupal/modules/book/book.moduleImplementation of hook_menu().
book_menudrupal/modules/book/book.moduleImplementation of hook_menu().
book_nextdrupal/modules/book/book.moduleFetches the node object of the next page of the book.
book_nextdrupal/modules/book/book.moduleFetches the node object of the next page of the book.
book_prevdrupal/modules/book/book.moduleFetches the node object of the previous page of the book.
book_prevdrupal/modules/book/book.moduleFetches the node object of the previous page of the book.
book_recursedrupal/modules/book/book.moduleTraverses the book tree. Applies the $visit_pre() callback to each node, is called recursively for each child of the node (in weight, title order). Finally appends the output of the $visit_post() callback to the output before returning the generated...
book_recursedrupal/modules/book/book.moduleTraverses the book tree. Applies the $visit_pre() callback to each node, is called recursively for each child of the node (in weight, title order). Finally appends the output of the $visit_post() callback to the output before returning the generated...
book_renderdrupal/modules/book/book.moduleMenu callback; prints a listing of all books.
book_renderdrupal/modules/book/book.moduleMenu callback; prints a listing of all books.
book_tocdrupal/modules/book/book.moduleReturns an array of titles and nid entries of book pages in table of contents order.
book_tocdrupal/modules/book/book.moduleReturns an array of titles and nid entries of book pages in table of contents order.
book_treedrupal/modules/book/book.moduleReturns an HTML nested list (wrapped in a menu-class div) representing the book nodes as a tree.
book_treedrupal/modules/book/book.moduleReturns an HTML nested list (wrapped in a menu-class div) representing the book nodes as a tree.
chatroom_chat_get_from_idcontributions/modules/chatroom/chatroom.moduleReturns a chat room object for $chat_id.
chatroom_chat_get_from_idcontributions/modules/chatroom/chatroom.moduleReturns a chat room object for $chat_id.
chatroom_get_active_chatscontributions/modules/chatroom/chatroom.modulegets a list of active chats
chatroom_get_active_chatscontributions/modules/chatroom/chatroom.modulegets a list of active chats
chatroom_get_chatroom_listcontributions/modules/chatroom/chatroom.modulereturns the list of available chat rooms
chatroom_get_chatroom_listcontributions/modules/chatroom/chatroom.modulereturns the list of available chat rooms
comment_get_recentdrupal/modules/comment/comment.moduleFind a number of recent comments. This is done in two steps. 1. Find the n (specified by $number) nodes that have the most recent comments. This is done by querying node_comment_statistics which has an index on last_comment_timestamp, and is thus a...
comment_get_recentdrupal/modules/comment/comment.moduleFind a number of recent comments. This is done in two steps. 1. Find the n (specified by $number) nodes that have the most recent comments. This is done by querying node_comment_statistics which has an index on last_comment_timestamp, and is thus a...
db_rewrite_sqldrupal/includes/database.incRewrites node, taxonomy and comment queries. Use it for listing queries. Do not use FROM table1, table2 syntax, use JOIN instead.
forum_blockdrupal/modules/forum/forum.moduleImplementation of hook_block().
forum_blockdrupal/modules/forum/forum.moduleImplementation of hook_block().
forum_get_forumsdrupal/modules/forum/forum.moduleReturns a list of all forums for a given taxonomy id
forum_get_forumsdrupal/modules/forum/forum.moduleReturns a list of all forums for a given taxonomy id
node_feeddrupal/modules/node/node.moduleA generic function for generating RSS feeds from a set of nodes.
node_feeddrupal/modules/node/node.moduleA generic function for generating RSS feeds from a set of nodes.
node_page_defaultdrupal/modules/node/node.moduleMenu callback; Generate a listing of promoted nodes.
node_page_defaultdrupal/modules/node/node.moduleMenu callback; Generate a listing of promoted nodes.
poll_blockdrupal/modules/poll/poll.moduleImplementation of hook_block().
poll_blockdrupal/modules/poll/poll.moduleImplementation of hook_block().
statistics_title_listdrupal/modules/statistics/statistics.moduleReturns all time or today top or last viewed node(s).
statistics_title_listdrupal/modules/statistics/statistics.moduleReturns all time or today top or last viewed node(s).
taxonomy_autocompletedrupal/modules/taxonomy/taxonomy.moduleHelper function for autocompletion
taxonomy_autocompletedrupal/modules/taxonomy/taxonomy.moduleHelper function for autocompletion
taxonomy_form_alterdrupal/modules/taxonomy/taxonomy.moduleImplementation of hook_form_alter(). Generate a form for selecting terms to associate with a node.
taxonomy_form_alterdrupal/modules/taxonomy/taxonomy.moduleImplementation of hook_form_alter(). Generate a form for selecting terms to associate with a node.
taxonomy_get_childrendrupal/modules/taxonomy/taxonomy.moduleFind all children of a term ID.
taxonomy_get_childrendrupal/modules/taxonomy/taxonomy.moduleFind all children of a term ID.
taxonomy_get_parentsdrupal/modules/taxonomy/taxonomy.moduleFind all parents of a given term ID.
taxonomy_get_parentsdrupal/modules/taxonomy/taxonomy.moduleFind all parents of a given term ID.
taxonomy_get_term_by_namedrupal/modules/taxonomy/taxonomy.moduleTry to map a string to an existing term, as for glossary use.
taxonomy_get_term_by_namedrupal/modules/taxonomy/taxonomy.moduleTry to map a string to an existing term, as for glossary use.
taxonomy_get_treedrupal/modules/taxonomy/taxonomy.moduleCreate a hierarchical representation of a vocabulary.
taxonomy_get_treedrupal/modules/taxonomy/taxonomy.moduleCreate a hierarchical representation of a vocabulary.
taxonomy_get_vocabulariesdrupal/modules/taxonomy/taxonomy.moduleReturn an array of all vocabulary objects.
taxonomy_get_vocabulariesdrupal/modules/taxonomy/taxonomy.moduleReturn an array of all vocabulary objects.
taxonomy_node_get_termsdrupal/modules/taxonomy/taxonomy.moduleFind all terms associated with the given node, ordered by vocabulary and term weight.
taxonomy_node_get_termsdrupal/modules/taxonomy/taxonomy.moduleFind all terms associated with the given node, ordered by vocabulary and term weight.
taxonomy_node_get_terms_by_vocabularydrupal/modules/taxonomy/taxonomy.moduleFind all terms associated with the given node, within one vocabulary.
taxonomy_node_get_terms_by_vocabularydrupal/modules/taxonomy/taxonomy.moduleFind all terms associated with the given node, within one vocabulary.
taxonomy_overview_termsdrupal/modules/taxonomy/taxonomy.moduleDisplay a tree of all the terms in a vocabulary, with options to edit each one.
taxonomy_overview_termsdrupal/modules/taxonomy/taxonomy.moduleDisplay a tree of all the terms in a vocabulary, with options to edit each one.
taxonomy_select_nodesdrupal/modules/taxonomy/taxonomy.moduleFinds all nodes that match selected taxonomy conditions.
taxonomy_select_nodesdrupal/modules/taxonomy/taxonomy.moduleFinds all nodes that match selected taxonomy conditions.
taxonomy_term_count_nodesdrupal/modules/taxonomy/taxonomy.moduleCount the number of published nodes classified by a term.
taxonomy_term_count_nodesdrupal/modules/taxonomy/taxonomy.moduleCount the number of published nodes classified by a term.
taxonomy_term_pagedrupal/modules/taxonomy/taxonomy.moduleMenu callback; displays all nodes associated with a term.
taxonomy_term_pagedrupal/modules/taxonomy/taxonomy.moduleMenu callback; displays all nodes associated with a term.
theme_forum_topic_navigationdrupal/modules/forum/forum.moduleFormat the next/previous forum topic navigation links.
theme_forum_topic_navigationdrupal/modules/forum/forum.moduleFormat the next/previous forum topic navigation links.
tracker_pagedrupal/modules/tracker/tracker.moduleMenu callback. Prints a listing of active nodes on the site.
tracker_pagedrupal/modules/tracker/tracker.moduleMenu callback. Prints a listing of active nodes on the site.
_forum_newdrupal/modules/forum/forum.moduleFinds the first unread node for a given forum.
_forum_newdrupal/modules/forum/forum.moduleFinds the first unread node for a given forum.
_forum_topics_unreaddrupal/modules/forum/forum.moduleCalculate the number of nodes the user has not yet read and are newer than NODE_NEW_LIMIT.
_forum_topics_unreaddrupal/modules/forum/forum.moduleCalculate the number of nodes the user has not yet read and are newer than NODE_NEW_LIMIT.
_menu_builddrupal/includes/menu.incBuild the menu by querying both modules and the database.
_menu_builddrupal/includes/menu.incBuild the menu by querying both modules and the database.
_node_types_builddrupal/modules/node/node.moduleBuilds and returns the list of available node types.
_node_types_builddrupal/modules/node/node.moduleBuilds and returns the list of available node types.

Functions called by db_rewrite_sql()

Namesort iconLocationDescription
db_distinct_fielddrupal/includes/database.pgsql.incWraps the given table.field entry with a DISTINCT(). The wrapper is added to the SELECT list entry of the given query and the resulting query is returned. This function only applies the wrapper if a DISTINCT doesn't already exist in the query.
db_distinct_fielddrupal/includes/database.pgsql.incWraps the given table.field entry with a DISTINCT(). The wrapper is added to the SELECT list entry of the given query and the resulting query is returned. This function only applies the wrapper if a DISTINCT doesn't already exist in the query.
db_rewrite_sqldrupal/includes/database.incRewrites node, taxonomy and comment queries. Use it for listing queries. Do not use FROM table1, table2 syntax, use JOIN instead.
_db_rewrite_sqldrupal/includes/database.incHelper function for db_rewrite_sql.
_db_rewrite_sqldrupal/includes/database.incHelper function for db_rewrite_sql.