0 ". "ORDER BY group_name ASC"; $res=db_query($sql); $rows=db_numrows($res); Header("Content-type: application/xml"); if (isset($id)) { $id = intval($id); $sql="SELECT unix_group_name,group_name,short_description,homepage,register_time,group_id FROM groups ". "WHERE is_public=1 AND status='A' AND register_time > 0 AND group_id=$id ". "ORDER BY group_name ASC"; $res=db_query($sql); $rows=db_numrows($res); $sql="SELECT user_id FROM user_group WHERE group_id=$id"; $result=db_query($sql); $rows2=db_numrows($result); echo " \n". " \n". " \n". "Instance data for project ".db_result($res, $i, 'group_name')." \n". " \n". " \n"; echo "\n"; echo " ".db_result($res, $i, 'unix_group_name')."\n"; echo " ".db_result($res, $i, 'group_name')."\n"; $desc=db_result($res, $i, 'short_description'); echo " ".strip_tags($desc)."\n"; echo " http://".db_result($res, $i, 'homepage')."\n"; echo " ".date("Y-m-d H:i", db_result($res, $i, 'register_time'))."\n"; $type=db_query("SELECT group_type FROM groups WHERE groups.group_id='$id'"); $restype=db_result($type,0,'group_type'); $ergtype=db_query("select name from project_types where id='$restype'"); echo " ".db_result($ergtype,0,'name')."\n"; //*** members for ($j=0; $j<$rows2; $j++) { $user_id=db_result($result,$j,'user_id'); $realname=db_query("SELECT realname,user_name FROM users WHERE user_id=$user_id"); echo " \n"; } //*** tools $toolsres = db_query("SELECT * FROM toolsgrp,tools WHERE toolsgrp.group_id='$id' AND tools.id=toolsgrp.tool_id"); while ($grpres = db_fetch_array($toolsres)) { echo " ".$grpres['description']."\n"; } //*** packages $sql = "SELECT * FROM frs_package WHERE group_id='$id' AND status_id='1' AND is_public=1 ORDER BY name"; $res_package = db_query( $sql ); $num_packages = db_numrows( $res_package ); for ( $p = 0; $p < $num_packages; $p++ ) { $sql = "SELECT * FROM frs_release WHERE package_id='". db_result($res_package,$p,'package_id') . "' AND status_id=1 ORDER BY release_date DESC, name ASC"; $res_release = db_query( $sql ); $num_releases = db_numrows( $res_release ); for ( $r = 0; $r < $num_releases; $r++ ) { $package_release = db_fetch_array( $res_release ); $sql = "SELECT frs_file.filename AS filename, frs_file.file_size AS file_size, frs_file.file_id AS file_id, frs_file.release_time AS release_time, frs_filetype.name AS type, frs_processor.name AS processor, frs_dlstats_filetotal_agg.downloads AS downloads FROM frs_filetype,frs_processor, frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id WHERE release_id='". $package_release['release_id'] ."' AND frs_filetype.type_id=frs_file.type_id AND frs_processor.processor_id=frs_file.processor_id ORDER BY filename"; $res_file = db_query($sql); $num_files = db_numrows( $res_file ); for ( $f = 0; $f < $num_files; $f++ ) { $file_release = db_fetch_array( $res_file ); echo " \n"; } } } //*** documentation $docres = db_query("SELECT * FROM doc_data WHERE group_id='$id' AND stateid=1"); while ($docerg = db_fetch_array($docres)) { echo " \n"; } print trove_getcatlisting2($id,0,1); echo "\n\n"; } else { echo " \n". " \n". " \n". "Instance data for ontoware.org portal \n". " \n". " \n"; for ($i=0; $i<$rows; $i++) { $group_id=db_result($res,$i,'group_id'); $sql="SELECT user_id FROM user_group WHERE group_id=$group_id"; $result=db_query($sql); $rows2=db_numrows($result); $erg=db_result($res, $i, 'unix_group_name'); echo "\n"; echo " ".md5($erg)."\n"; echo " ".$erg."\n"; echo " ".db_result($res, $i, 'group_name')."\n"; $desc=db_result($res, $i, 'short_description'); echo " ".strip_tags($desc)."\n"; echo " http://".db_result($res, $i, 'homepage')."\n"; echo " ".date("Y-m-d H:i", db_result($res, $i, 'register_time'))."\n"; $type=db_query("SELECT group_type FROM groups WHERE groups.group_id='$group_id'"); $restype=db_result($type,0,'group_type'); $ergtype=db_query("select name from project_types where id='$restype'"); echo " ".db_result($ergtype,0,'name')."\n"; //*** members for ($j=0; $j<$rows2; $j++) { $user_id=db_result($result,$j,'user_id'); echo " \n"; } //*** tools $toolsres = db_query("SELECT * FROM toolsgrp,tools WHERE toolsgrp.group_id='$group_id' AND tools.id=toolsgrp.tool_id"); while ($grpres = db_fetch_array($toolsres)) { echo " ".$grpres['description']."\n"; } $sql = "SELECT * FROM frs_package WHERE group_id='$group_id' AND status_id='1' AND is_public=1 ORDER BY name"; $res_package = db_query( $sql ); $num_packages = db_numrows( $res_package ); for ( $p = 0; $p < $num_packages; $p++ ) { $sql = "SELECT * FROM frs_release WHERE package_id='". db_result($res_package,$p,'package_id') . "' AND status_id=1 ORDER BY release_date DESC, name ASC"; $res_release = db_query( $sql ); $num_releases = db_numrows( $res_release ); for ( $r = 0; $r < $num_releases; $r++ ) { $package_release = db_fetch_array( $res_release ); $sql = "SELECT frs_file.filename AS filename, frs_file.file_size AS file_size, frs_file.file_id AS file_id, frs_file.release_time AS release_time, frs_filetype.name AS type, frs_processor.name AS processor, frs_dlstats_filetotal_agg.downloads AS downloads FROM frs_filetype,frs_processor, frs_file LEFT JOIN frs_dlstats_filetotal_agg ON frs_dlstats_filetotal_agg.file_id=frs_file.file_id WHERE release_id='". $package_release['release_id'] ."' AND frs_filetype.type_id=frs_file.type_id AND frs_processor.processor_id=frs_file.processor_id ORDER BY filename"; $res_file = db_query($sql); $num_files = db_numrows( $res_file ); for ( $f = 0; $f < $num_files; $f++ ) { $file_release = db_fetch_array( $res_file ); echo " \n"; } } } //*** documentation $docres = db_query("SELECT * FROM doc_data WHERE group_id='$group_id' AND stateid=1"); while ($docerg = db_fetch_array($docres)) { echo " \n"; } print trove_getcatlisting2($group_id,0,1); echo "\n"; } } echo ""; ?>