/[drupal]/contributions/modules/storm/stormnote/stormnote.module
ViewVC logotype

Diff of /contributions/modules/storm/stormnote/stormnote.module

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

revision 1.5, Mon Jun 23 16:46:35 2008 UTC revision 1.6, Tue Jul 1 07:47:42 2008 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: stormnote.module,v 1.4 2008/06/18 15:24:52 robertogerola Exp $  // $Id: stormnote.module,v 1.5 2008/06/23 16:46:35 robertogerola Exp $
3    
4  /**  /**
5   * @file   * @file
# Line 193  function stormnote_form(&$node) { Line 193  function stormnote_form(&$node) {
193      '#weight' => -50,      '#weight' => -50,
194    );    );
195    
196    $s = "SELECT n.nid, n.title FROM {stormorganization} sor INNER JOIN {node} n ON sor.nid=n.nid WHERE n.status=1 AND n.type='stormorganization' ORDER BY n.title";    $s = "SELECT n.nid, n.title FROM {node} n INNER JOIN {stormorganization} sor ON sor.vid=n.vid WHERE n.status=1 AND n.type='stormorganization' ORDER BY n.title";
197      $s = db_rewrite_sql($s);
198    $r = db_query(stormorganization_access_sql($s));    $r = db_query(stormorganization_access_sql($s));
199    $organizations = array();    $organizations = array();
200    while ($organization = db_fetch_object($r)) {    while ($organization = db_fetch_object($r)) {
# Line 208  function stormnote_form(&$node) { Line 209  function stormnote_form(&$node) {
209      '#attributes' => array('onchange' => "stormtask_organization_project_tasks(this, 'edit-project-nid', 'edit-parent-nid', true, '-')"),      '#attributes' => array('onchange' => "stormtask_organization_project_tasks(this, 'edit-project-nid', 'edit-parent-nid', true, '-')"),
210    );    );
211    
212    $s = "SELECT n.nid, n.title FROM {stormproject} spr INNER JOIN {node} n ON spr.nid=n.nid WHERE spr.organization_nid=%d AND n.status=1 AND n.type='stormproject' ORDER BY n.title";    $s = "SELECT n.nid, n.title FROM {node} n INNER JOIN {stormproject} spr ON spr.vid=n.vid WHERE spr.organization_nid=%d AND n.status=1 AND n.type='stormproject' ORDER BY n.title";
213    $r = db_query(stormproject_access_sql($s), $node->organization_nid);    $r = db_query(stormproject_access_sql($s), $node->organization_nid);
214    $projects = array();    $projects = array();
215    while ($project = db_fetch_object($r)) {    while ($project = db_fetch_object($r)) {
Legend:
Removed from v.1.5  
changed lines
  Added in v.1.6
  ViewVC Help
Powered by ViewVC 1.1.2