Home

sql

New db layer - cache_set

August 22, 2008 - 11:51am — weitzman
  1. INSERT INTO {cache_registry} (serialized, created, expire, headers, DATA, cid) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_inser

code for gor to see

June 15, 2008 - 6:15am — Anonymous
  1. function client_search_result($sstr = NULL) {
  2.  
  3.   if (!$sstr) {
  4.       drupal_set_message("Search cant be empty", error);
  5.       drupal_goto('clients');
  6.   } else {

SQL INSERT Issue

June 3, 2008 - 8:42am — Anonymous
  1. /**
  2.  * create_process_status
  3.  * Description: Creates a record for FID in media_process_status table
  4.  * @param  $fid, $type
  5.  */
  6. function create_process_status($fid, $type) {

Fix for VotingAPI + Views buggy query

March 31, 2008 - 11:46am — Anonymous
  1. SELECT DISTINCT(node.nid), votingapi_vote_vote_points.timestamp AS votingapi_vote_vote_points_timestamp FROM node node LEFT JOIN votingapi_cache votingapi_cache_vote_points_count ON node.nid = votinga

VotingAPI + Views buggy query

March 20, 2008 - 12:24pm — Anonymous
  1. SELECT DISTINCT(node.nid), votingapi_vote_vote_points.timestamp AS votingapi_vote_vote_points_timestamp FROM node node LEFT JOIN votingapi_cache votingapi_cache_vote_points_count ON node.nid = votinga

sql

February 12, 2008 - 12:31pm — Anonymous
  1. SELECT a.title, b.field_direccin_fsica_value
  2. FROM node a, content_type_instituciones b,
  3. term_node d,
  4. term_node e,
  5. term_node f,
  6. term_node g,
  7. term_node h,
  8. term_node i,
  9. term_node j,

sql to confirm contributers to drupal6

February 11, 2008 - 8:43pm — Anonymous
  1. CREATE TEMPORARY TABLE contributors
  2. SELECT n.uid
  3. FROM project_issues i INNER JOIN node n ON i.nid = n.nid
  4. INNER JOIN files f ON i.nid = f.nid
  5. WHERE i.pid = 9609
Syndicate content