Michael Joseph, Jam Warehouse (Pty) Ltd, South Africa * @package dmslib */ /** * Performs an id field lookup on the specified table. * * @param $tableName the name of table to perform the id lookup. * @param $fieldName the db field to return. * @param $fieldValue the value to perform the lookup for * @return the id of the row in the db with $fieldName=$fieldValue */ function lookupID($tableName, $fieldName, $fieldValue){ $sql = new Owl_DB(); $query = "select id from $tableName where $fieldName = '$fieldValue'"; //echo "lookup.inc::lookupID: about to execute $query
"; if ($sql->query($query)) { if ($sql->next_record()) { return $sql->f("id"); } else { $_SESSION["errorMessage"] = "id retrieval failed."; return false; } } else { $_SESSION["errorMessage"] = "lookup query ($query) failed."; return false; } } /** * Retrieves the groups that the user is a member of * * @param $userID the user to lookup groups for * @return an array containing the groupsIDs the user is a member of */ function lookupGroupIDs($userID) { global $default; $groupIDs = array(); $sql = new Owl_DB; $sql->query("select group_id from $default->owl_groups_users_table where user_id = '$userID'"); while($sql->next_record()) { $groupIDs[] = $sql->f("group_id"); } return $groupIDs; } function arrayToString($array) { ob_start(); print_r($array); $arrToStr = ob_get_contents(); ob_end_clean(); return $arrToStr; } ?>