/[drupal]/contributions/modules/coppa/coppa.module
ViewVC logotype

Diff of /contributions/modules/coppa/coppa.module

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.2, Wed Jul 23 04:02:04 2008 UTC revision 1.3, Wed Jul 23 07:02:10 2008 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: coppa.module,v 1.1 2008/07/22 22:47:21 jgraham Exp $  // $Id: coppa.module,v 1.2 2008/07/23 04:02:04 jgraham Exp $
3    
4  define('COPPA_AGE', 13);  define('COPPA_AGE', 13);
5  define('COPPA_ADD_ELEMENTS', 20);  define('COPPA_ADD_ELEMENTS', 20);
# Line 107  function coppa_info() { Line 107  function coppa_info() {
107   */   */
108  function coppa_sign() {  function coppa_sign() {
109    global $user;    global $user;
110    $result = db_query("SELECT DISTINCT u.uid, u.name, c.status, pv.value, pv.fid FROM {users} u, {coppa} c, {profile_fields} pf, profile_values pv WHERE c.cid=u.uid AND pv.uid = u.uid AND pf.fid = pv.fid AND pf.name = 'profile_dob' AND c.pid = %d", $user->uid);    $result = db_query("SELECT DISTINCT u.uid, u.name, c.status, pv.value, pv.fid
111                          FROM {users} u, {coppa} c, {profile_fields} pf, profile_values pv
112                          WHERE c.cid=u.uid AND pv.uid = u.uid AND pf.fid = pv.fid AND pf.name = 'profile_dob' AND c.pid = %d", $user->uid);
113    
114    $form['children'] = array('#tree' => true);    $form['children'] = array('#tree' => true);
115    
# Line 132  function coppa_sign() { Line 134  function coppa_sign() {
134      }      }
135      else {      else {
136        // unchecked disabled        // unchecked disabled
137        $checked = 0;        $checked = 1;
138        $disabled = 1;        $disabled = 1;
139      }      }
140      $form['children'][$r->uid]['status'] = array('#type' => 'checkbox', '#default_value' => $checked, '#disabled' => $disabled);      $form['children'][$r->uid]['status'] = array('#type' => 'checkbox',
141                                                    '#default_value' => $checked,
142                                                    '#disabled' => $disabled);
143    }    }
144    $form['submit'] = array('#type' => 'submit', '#value' => t('Confirm COPPA'));    $form['submit'] = array('#type' => 'submit', '#value' => t('Confirm COPPA'));
145    
# Line 363  function coppa_manage_relationships() { Line 367  function coppa_manage_relationships() {
367    $form = array();    $form = array();
368    $date_format = 'n j Y'; // m/d/y    $date_format = 'n j Y'; // m/d/y
369    $result = db_query("SELECT cu.uid as cid, cu.name as cname, pu.uid as pid, pu.name as pname, pv.value as dob, c.status    $result = db_query("SELECT cu.uid as cid, cu.name as cname, pu.uid as pid, pu.name as pname, pv.value as dob, c.status
370                        FROM {users} cu, {coppa} c, {users} pu                        FROM {users} cu
371                          JOIN {coppa} c ON cu.uid = c.cid
372                          JOIN {users} pu ON pu.uid = c.pid
373                        LEFT JOIN profile_values pv ON pv.uid = c.cid                        LEFT JOIN profile_values pv ON pv.uid = c.cid
374                        LEFT JOIN profile_fields pf ON pv.fid = pf.fid                        LEFT JOIN profile_fields pf ON pv.fid = pf.fid");
                       WHERE  cu.uid = c.cid AND pu.uid = c.pid");  
375    
376    
377    while ($r = db_fetch_object($result)) {    while ($r = db_fetch_object($result)) {
Legend:
Removed from v.1.2  
changed lines
  Added in v.1.3
  ViewVC Help
Powered by ViewVC 1.1.2