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
blogapi_mt_validate_termsmodules/blogapi/blogapi.moduleBlogging API helper - find allowed taxonomy terms for a node type.
blog_blockmodules/blog/blog.moduleImplementation of hook_block().
blog_feed_lastmodules/blog/blog.moduleDisplays an RSS feed containing recent blog entries of all users.
blog_feed_usermodules/blog/blog.moduleDisplays an RSS feed containing recent blog entries of a given user.
blog_page_lastmodules/blog/blog.moduleDisplays a Drupal page containing recent blog entries of all users.
blog_page_usermodules/blog/blog.moduleDisplays a Drupal page containing recent blog entries of a given user.
book_admin_orphanmodules/book/book.moduleMenu callback; displays a listing of all orphaned book pages.
book_admin_overviewmodules/book/book.moduleReturns an administrative overview of all books.
book_blockmodules/book/book.moduleImplementation of hook_block().
book_exportmodules/book/book.moduleMenu callback; Generates various representation of a book page with all descendants and prints the requested representation to output.
book_locationmodules/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_downmodules/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_menumodules/book/book.moduleImplementation of hook_menu().
book_nextmodules/book/book.moduleFetches the node object of the next page of the book.
book_prevmodules/book/book.moduleFetches the node object of the previous page of the book.
book_recursemodules/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_rendermodules/book/book.moduleMenu callback; prints a listing of all books.
book_tocmodules/book/book.moduleReturns an array of titles and nid entries of book pages in table of contents order.
book_treemodules/book/book.moduleReturns an HTML nested list (wrapped in a menu-class div) representing the book nodes as a tree.
comment_get_recentmodules/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_sqlincludes/database.incRewrites node, taxonomy and comment queries. Use it for listing queries. Do not use FROM table1, table2 syntax, use JOIN instead.
forum_blockmodules/forum/forum.moduleImplementation of hook_block().
forum_get_forumsmodules/forum/forum.moduleReturns a list of all forums for a given taxonomy id
node_feedmodules/node/node.moduleA generic function for generating RSS feeds from a set of nodes.
node_page_defaultmodules/node/node.moduleMenu callback; Generate a listing of promoted nodes.
poll_blockmodules/poll/poll.moduleImplementation of hook_block().
statistics_title_listmodules/statistics/statistics.moduleReturns all time or today top or last viewed node(s).
taxonomy_autocompletemodules/taxonomy/taxonomy.moduleHelper function for autocompletion
taxonomy_form_altermodules/taxonomy/taxonomy.moduleImplementation of hook_form_alter(). Generate a form for selecting terms to associate with a node.
taxonomy_get_childrenmodules/taxonomy/taxonomy.moduleFind all children of a term ID.
taxonomy_get_parentsmodules/taxonomy/taxonomy.moduleFind all parents of a given term ID.
taxonomy_get_term_by_namemodules/taxonomy/taxonomy.moduleTry to map a string to an existing term, as for glossary use.
taxonomy_get_treemodules/taxonomy/taxonomy.moduleCreate a hierarchical representation of a vocabulary.
taxonomy_get_vocabulariesmodules/taxonomy/taxonomy.moduleReturn an array of all vocabulary objects.
taxonomy_node_get_termsmodules/taxonomy/taxonomy.moduleFind all terms associated with the given node, ordered by vocabulary and term weight.
taxonomy_node_get_terms_by_vocabularymodules/taxonomy/taxonomy.moduleFind all terms associated with the given node, within one vocabulary.
taxonomy_overview_termsmodules/taxonomy/taxonomy.moduleDisplay a tree of all the terms in a vocabulary, with options to edit each one.
taxonomy_select_nodesmodules/taxonomy/taxonomy.moduleFinds all nodes that match selected taxonomy conditions.
taxonomy_term_count_nodesmodules/taxonomy/taxonomy.moduleCount the number of published nodes classified by a term.
taxonomy_term_pagemodules/taxonomy/taxonomy.moduleMenu callback; displays all nodes associated with a term.
theme_forum_topic_navigationmodules/forum/forum.moduleFormat the next/previous forum topic navigation links.
tracker_pagemodules/tracker/tracker.moduleMenu callback. Prints a listing of active nodes on the site.
_forum_newmodules/forum/forum.moduleFinds the first unread node for a given forum.
_forum_topics_unreadmodules/forum/forum.moduleCalculate the number of nodes the user has not yet read and are newer than NODE_NEW_LIMIT.
_menu_buildincludes/menu.incBuild the menu by querying both modules and the database.
_node_types_buildmodules/node/node.moduleBuilds and returns the list of available node types.

Functions called by db_rewrite_sql()

Namesort iconLocationDescription
db_distinct_fieldincludes/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_sqlincludes/database.incRewrites node, taxonomy and comment queries. Use it for listing queries. Do not use FROM table1, table2 syntax, use JOIN instead.
_db_rewrite_sqlincludes/database.incHelper function for db_rewrite_sql.
 
 

All source code and documentation on this site is released under the terms of the GNU General Public License, version 2 and later. Drupal is a registered trademark of Dries Buytaert.