[Openfirst-cvscommit] projects/admin editgroups.php,1.3,1.4 editprojects.php,1.2,1.3 edittasks.php,1.3,1.4

[<dav...@us...>]

Update of /cvsroot/openfirst/projects/admin
In directory sc8-pr-cvs1:/tmp/cvs-serv5969/admin

Modified Files:
	editgroups.php editprojects.php edittasks.php 
Log Message:
Fixed commands to use ofirst database functions instead of mysql.

Index: editgroups.php
===================================================================
RCS file: /cvsroot/openfirst/projects/admin/editgroups.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** editgroups.php	13 Oct 2003 23:09:43 -0000	1.3
--- editgroups.php	13 Oct 2003 23:38:34 -0000	1.4
***************
*** 58,71 ****
    }
    
! 	$group_query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! 	$group = mysql_fetch_object($group_query);
  
    // Edit assigned moderators
    if(isset($_POST['editmods'])){
  
! 	mysql_query("UPDATE ofirst_projects_groups SET Moderators = '".$_POST['moderators']."' WHERE ID = '".$_GET['GroupID']."';") or die(mysql_error());
    	
! 	$group_query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! 	$group = mysql_fetch_object($group_query);
  	
  	echo "<br>Moderators list has been updated!";
--- 58,71 ----
    }
    
! 	$group_query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! 	$group = ofirst_dbfetch_object($group_query);
  
    // Edit assigned moderators
    if(isset($_POST['editmods'])){
  
! 	ofirst_dbquery("UPDATE ofirst_projects_groups SET Moderators = '".$_POST['moderators']."' WHERE ID = '".$_GET['GroupID']."';") or die(mysql_error());
    	
! 	$group_query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! 	$group = ofirst_dbfetch_object($group_query);
  	
  	echo "<br>Moderators list has been updated!";
***************
*** 76,83 ****
    if(isset($_POST['editmembers'])){
  
! 	mysql_query("UPDATE ofirst_projects_groups SET Members = '".$_POST['members']."' WHERE ID = '".$_GET['GroupID']."';");
    	
! 	$group_query = mysql_query("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! 	$group = mysql_fetch_object($group_query);
  	
  	echo "<br>Members list has been updated!";
--- 76,83 ----
    if(isset($_POST['editmembers'])){
  
! 	ofirst_dbquery("UPDATE ofirst_projects_groups SET Members = '".$_POST['members']."' WHERE ID = '".$_GET['GroupID']."';");
    	
! 	$group_query = ofirst_dbquery("SELECT * FROM ofirst_projects_groups WHERE ID = '".$_GET['GroupID']."'");
! 	$group = ofirst_dbfetch_object($group_query);
  	
  	echo "<br>Members list has been updated!";

Index: editprojects.php
===================================================================
RCS file: /cvsroot/openfirst/projects/admin/editprojects.php,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** editprojects.php	13 Oct 2003 23:09:43 -0000	1.2
--- editprojects.php	13 Oct 2003 23:38:34 -0000	1.3
***************
*** 56,69 ****
      }
  
! 	$project_query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE ID = '".$_GET['ProjectID']."'");
! 	$project = mysql_fetch_object($project_query);
  
    // Edit assigned members to project
    if(isset($_POST['editmembers'])){
  
! 	mysql_query("UPDATE ofirst_projects_projects SET Assigned = '".$_POST['members']."' WHERE ID = '".$_GET['ProjectID']."';");
    	
! 	$project_query = mysql_query("SELECT * FROM ofirst_projects_projects WHERE ID = '".$_GET['ProjectID']."'");
! 	$project = mysql_fetch_object($project_query);
  	
  	echo "<br>Members list has been updated!";
--- 56,69 ----
      }
  
! 	$project_query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE ID = '".$_GET['ProjectID']."'");
! 	$project = ofirst_dbfetch_object($project_query);
  
    // Edit assigned members to project
    if(isset($_POST['editmembers'])){
  
! 	ofirst_dbquery("UPDATE ofirst_projects_projects SET Assigned = '".$_POST['members']."' WHERE ID = '".$_GET['ProjectID']."';");
    	
! 	$project_query = ofirst_dbquery("SELECT * FROM ofirst_projects_projects WHERE ID = '".$_GET['ProjectID']."'");
! 	$project = ofirst_dbfetch_object($project_query);
  	
  	echo "<br>Members list has been updated!";

Index: edittasks.php
===================================================================
RCS file: /cvsroot/openfirst/projects/admin/edittasks.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -d -r1.3 -r1.4
*** edittasks.php	13 Oct 2003 23:09:43 -0000	1.3
--- edittasks.php	13 Oct 2003 23:38:34 -0000	1.4
***************
*** 55,60 ****
      }
  
! 	$task_query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$_GET['TaskID']."'");
! 	$task = mysql_fetch_object($task_query);
  
  
--- 55,60 ----
      }
  
! 	$task_query = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$_GET['TaskID']."'");
! 	$task = ofirst_dbfetch_object($task_query);
  
  
***************
*** 62,69 ****
    if(isset($_POST['editmembers'])){
  
! 	mysql_query("UPDATE ofirst_projects_tasks SET Assigned = '".$_POST['members']."' WHERE ID = '".$_GET['TaskID']."';");
    	
! 	$task_query = mysql_query("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$_GET['TaskID']."'");
! 	$task = mysql_fetch_object($task_query);
  	
  	echo "<br>Members list has been updated!";
--- 62,69 ----
    if(isset($_POST['editmembers'])){
  
! 	ofirst_dbquery("UPDATE ofirst_projects_tasks SET Assigned = '".$_POST['members']."' WHERE ID = '".$_GET['TaskID']."';");
    	
! 	$task_query = ofirst_dbquery("SELECT * FROM ofirst_projects_tasks WHERE ID = '".$_GET['TaskID']."'");
! 	$task = ofirst_dbfetch_object($task_query);
  	
  	echo "<br>Members list has been updated!";