[Fmsystem-commits] [7305] added org, group, contact and arena info to WS-function

[Erik Holm-Larsen]

Revision: 7305
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=7305
Author:   erikhl
Date:     2011-05-26 07:24:29 +0000 (Thu, 26 May 2011)
Log Message:
-----------
added org, group, contact and arena info to WS-function

Modified Paths:
--------------
    trunk/activitycalendar/inc/class.soactivity.inc.php

Modified: trunk/activitycalendar/inc/class.soactivity.inc.php
===================================================================
--- trunk/activitycalendar/inc/class.soactivity.inc.php 2011-05-26 07:23:24 UTC 
(rev 7304)
+++ trunk/activitycalendar/inc/class.soactivity.inc.php 2011-05-26 07:24:29 UTC 
(rev 7305)
@@ -562,14 +562,14 @@
        {
                if(isset($group_id))
                {
-                       $this->db->query("SELECT * FROM bb_group_contact WHERE 
id={$id}", __LINE__, __FILE__);
+                       $this->db->query("SELECT * FROM bb_group_contact WHERE 
id={$cont_pers}", __LINE__, __FILE__);
                        while($this->db->next_record()){
                                $result = 
array($this->db->f('name'),$this->db->f('phone'),$this->db->f('email'));
                        }
                }
                else if(isset($org_id))
                {
-                       $this->db->query("SELECT * FROM bb_organization_contact 
WHERE id={$id}", __LINE__, __FILE__);
+                       $this->db->query("SELECT * FROM bb_organization_contact 
WHERE id={$cont_pers}", __LINE__, __FILE__);
                        while($this->db->next_record()){
                                $result = 
array($this->db->f('name'),$this->db->f('phone'),$this->db->f('email'));
                        }
@@ -581,7 +581,7 @@
        {
                if(isset($org_id))
                {
-                       $this->db->query("SELECT * FROM bb_organization WHERE 
id={$id}", __LINE__, __FILE__);
+                       $this->db->query("SELECT * FROM bb_organization WHERE 
id={$org_id}", __LINE__, __FILE__);
                        while($this->db->next_record()){
                                $result = 
array($this->db->f('name'),$this->db->f('shortname'),$this->db->f('homepage'),$this->db->f('phone'),$this->db->f('email'));
                        }
@@ -592,7 +592,7 @@
        {
                if(isset($group_id))
                {
-                       $this->db->query("SELECT * FROM bb_group WHERE 
id={$id}", __LINE__, __FILE__);
+                       $this->db->query("SELECT * FROM bb_group WHERE 
id={$group_id}", __LINE__, __FILE__);
                        while($this->db->next_record()){
                                $result = 
array($this->db->f('name'),$this->db->f('shortname'),$this->db->f('description'),$this->db->f('organization_id'));
                        }
@@ -603,7 +603,7 @@
        {
                if(isset($arena_id))
                {
-                       $this->db->query("SELECT * FROM activity_arena WHERE 
id={$id}", __LINE__, __FILE__);
+                       $this->db->query("SELECT * FROM activity_arena WHERE 
id={$arena_id}", __LINE__, __FILE__);
                        while($this->db->next_record()){
                                $result = 
array($this->db->f('arena_name'),$this->db->f('address'));
                        }