Home

database

Update multiple checkboxes in a N:M relationship

September 29, 2011 - 10:11am — Anonymous
  1. // Save the pods that were enabled for this room
  2. // $vars['pods'] has values that come from a form postback - from a field of type checkboxes
  3. // in the database, a room(rid) can have zero or multipl

civi db query fail

August 15, 2011 - 3:20pm — Anonymous
  1. <?php
  2.   //$query = "SELECT c.display_name FROM users a, civicrm_uf_match b, civicrm_contact c WHERE a.uid='1' AND a.uid=b.uf_id AND c.id=b.contact_id";
  3.   //$query = "SELECT c.display_name FROM users

Fix for my module is showing bug .. not sure why ..

October 8, 2009 - 10:46pm — Anonymous
  1.        
  2. By fkaufusi
  3.  
  4. Drupal version 6:
  5.  
  6. function user_access($string, $account = NULL, $reset = FALSE) {
  7.   global $user;
  8.   static $perm = array();
  9.   if ($reset) {
  10.     $perm = array();
  11.   }
  12.  
  13.   i

Shell script for taking a copy of a remote database to your local machine.

May 29, 2009 - 3:58am — Anonymous
  1. if [ $1 = "--help" ];
  2.   then
  3.     echo "
  4.   #########
  5.   # USAGE #
  6.   #########
  7.  
  8.   Syntax for running this script is:
  9.     ./devdb2localdb.sh sshuser sshdomain remotedatabaseuser databasename

Fix for settings.php database array for sharing profiles

May 21, 2009 - 7:41am — Anonymous
  1. <?php
  2. //usual local settings:
  3. $db_url = 'mysqli://username:password@localhost/my_drupal_db';
  4.  
  5. $db_prefix = array(
  6.     'default'                   => '',
  7.     'profile_fields'    => 'site1_',

settings.php database array for sharing profiles

May 21, 2009 - 7:29am — Anonymous
  1. <?php
  2. //usual local settings:
  3. $db_url = 'mysqli://username:password@localhost/my_drupal_db';
  4.  
  5. $db_prefix = array(
  6.     'profile_fields'    => 'site1_',
  7.     'profile_values'    => 'site1_',
  8. );
  9. ?>

database helper function for keyed array

February 28, 2009 - 9:58am — Anonymous
  1. /**
  2.  * Database helper function: fetch the entire result set as a keyed array.
  3.  * The first field in the result becomes the keys.

Ignore Slave Server Patch

February 10, 2009 - 12:37am — Anonymous
  1. /**
  2.  * Implementation of hook_comment_insert().
  3.  */
  4. function comment_comment_insert($comment) {
  5.   drupal_set_ignore_slave();
  6. }
  7.  
  8. /*
  9.  * Implementation of hook_comment_update().
  10.  */

database benchmarks

August 19, 2008 - 2:05am — Anonymous
  1. Settings:
  2. block cache: disabled
  3. optimize CSS: enabled
  4. optimize JS: enabled
  5. front page with one node.
  6.  
  7. HEAD:
  8. ====
  9. Page cache: disabled
  10. Requests per second:    9.77 [#/sec] (mean)

New DatabaseCondition

April 18, 2008 - 12:54am — Anonymous
  1. class DatabaseCondition implements QueryConditionInterface, Countable {
  2.  
  3.   protected $conditions = array();
  4.   protected $arguments = array();
  5.  
  6.   protected $updated = TRUE;
Syndicate content