features_boxes.php File Reference

Go to the source code of this file.

Functions
	show_features_boxes ()
	show_sitestats ()
	show_newest_projects ($group_type, $limit)
	show_votes ($limit=10)

---

Function Documentation

show_features_boxes (   )

Definition at line 28 of file features_boxes.php. References $count, $HTML, $j, $result, $return, db_fetch_array(), db_numrows(), db_query(), people_show_category_list(), show_newest_projects(), show_sitestats(), show_votes(), type_id, and utils_link(). { GLOBAL $HTML; #### General Stats $return .= $HTML->box_top(utils_link($GLOBALS['sys_home']."stats/", sprintf(_("%s Statistics"),$GLOBALS['sys_name']),"sortbutton")); $return .= show_sitestats(); $return .= $HTML->box_bottom(); #### Job offers Stats $jobs = people_show_category_list(); if ($jobs) { $return .= "<br />\n"; $return .= $HTML->box_top(_("Help Wanted"),'',1); $return .= $jobs; $return .= $HTML->box_bottom(1); } ### Popular items $votes = show_votes(); if ($votes) { $return .= "<br />\n"; $return .= $HTML->box_top(_("Most Popular Items"),'',1); $return .= $votes; $return .= $HTML->box_bottom(1); } #### Group Type Stats $result = db_query("SELECT type_id,name FROM group_type ORDER BY type_id"); # try to find out how many latest registered groups per group type # we should print, depending on how many groups we have. $limit = 10; $count = db_numrows($result); # If count of group types > 25, print 2 latest groups per type # If count of group types < 2, print 25 latest groups per type # Else, print (35/count of groups) latest groups per type if ($count > 25) { $limit = 2; } elseif ($count < 2) { $limit = 25; } else { $limit = round(35 / $count); } while ($eachtype = db_fetch_array($result)) { $return .= "<br />\n"; $return .= $HTML->box_top(sprintf(_("Newest %s Projects"),$eachtype['name']),'',1); $return .= show_newest_projects($group_type=$eachtype['type_id'], $limit); global $j; $return .= '<div class="'.utils_get_alt_row_color($j).'"><span class="smaller"><a href="'.$GLOBALS['sys_home'].'search/?type_of_search=soft&amp;words=%%%&amp;type='.$eachtype['type_id'].'">['; $return .= sprintf( _("all %s projects"),$eachtype['name'] ) ; $return .= ']</a></span></div>'; $return .= $HTML->box_bottom(1); } return $return; }

show_newest_projects (  $  group_type, $  limit )

Definition at line 124 of file features_boxes.php. References $j, $return, $sql, db_error(), db_fetch_array(), db_numrows(), db_query(), and nbsp. Referenced by show_features_boxes(). { global $j; $sql = "SELECT group_id,unix_group_name,group_name,register_time FROM groups " . "WHERE is_public=1 AND status='A' AND type=$group_type " . "ORDER BY register_time DESC LIMIT $limit"; $res_newproj = db_query( $sql ); $sql_type = "SELECT type_id,base_host FROM group_type WHERE type_id=$group_type"; $res_newproj_type = db_query($sql_type); $row_newproj_type = db_fetch_array($res_newproj_type); if ($row_newproj_type['base_host']) { $base_url = 'http'.(session_issecure()?'s':'').'://'.$row_newproj_type['base_host']; } if (!$res_newproj || db_numrows($res_newproj) < 1) { return db_error(); } else { while ( $row_newproj = db_fetch_array($res_newproj) ) { if ( $row_newproj['register_time'] ) { # It would be best to have only Month + Day, but php locale # implementations cant do that, apparently. Feel free to # improve. $return .= '<div class="'.utils_get_alt_row_color($j).'"><span class="smaller">&nbsp;&nbsp;- <a href="'.$base_url.$GLOBALS['sys_home']."projects/$row_newproj[unix_group_name]/\">" . $row_newproj[group_name].'</a>, '.format_date('minimal',$row_newproj['register_time']).'</span></div>'; $j++; } } } return $return; }

show_sitestats (   )

Definition at line 98 of file features_boxes.php. References $i, $result, $return, db_fetch_array(), db_query(), nbsp, stats_getprojects_active(), stats_getprojects_bytype_active(), stats_getprojects_pending(), stats_getusers(), and type_id. Referenced by show_features_boxes(). { $return .= '<span class="smaller">'; $users = stats_getusers(); $return .= sprintf(ngettext("%s registered user", "%s registered users", $users), "<strong>$users</strong>"); $return .= '</span></div>'; $return .= '<div class="'.utils_get_alt_row_color(0).'"><span class="smaller">'; $projects = stats_getprojects_active(); $return .= sprintf(ngettext("%s hosted project", "%s hosted projects", $projects), "<strong>$projects</strong>").'</span></div>'; $result = db_query("SELECT type_id,name FROM group_type ORDER BY type_id"); while ($eachtype = db_fetch_array($result)) { $i++; $return .= '<div class="'.utils_get_alt_row_color($i).'"><span class="smaller">'; $return .= '&nbsp;&nbsp;- <a href="'.$GLOBALS['sys_home'].'search/?type_of_search=soft&amp;words=%%%&amp;type='.$eachtype['type_id'].'" class="center">'; $return .= stats_getprojects_bytype_active($eachtype['type_id']); $return .= ' '.$eachtype['name'].'</a>'; $return .= '</span></div>'; } $pending = stats_getprojects_pending(); $return .= '<div class="'.utils_get_alt_row_color(($i+1)).'"><span class="smaller">&nbsp;&nbsp;'; $return .= sprintf(ngettext("+ %s registration pending", "+ %s registrations pending", $pending), $pending).'</span>'; return $return; }

show_votes (  $  limit = 10  )

Definition at line 162 of file features_boxes.php. References $count, $prefix, $result, $return, $rows, $sql, db_numrows(), db_query(), db_result, nbsp, and summary. Referenced by show_features_boxes(). { # Find out interesting bugs and store them in a hash # Closed and private items are ignored. $trackers = array("bugs", "task", "support", "patch"); $item_vote = array(); $item_summary = array(); # not enough space! #$item_group_id = array(); while (list(,$tracker) = each($trackers)) { $sql = "SELECT bug_id,group_id,summary,vote FROM $tracker WHERE vote >=35 AND privacy=1 AND status_id=1 ORDER BY vote DESC LIMIT $limit"; $result=db_query($sql); $rows=db_numrows($result); if ($result && $rows > 0) { $results = 1; for ($j=0; $j<$rows; $j++) { # Create item unique name $thisitem = $tracker.'#'.db_result($result,$j,'bug_id'); # Store data $item_vote[$thisitem] = db_result($result,$j,'vote'); $item_summary[$thisitem] = db_result($result,$j,'summary'); # not enough space! #$item_group_id[$thisitem] = db_result($result,$j,'group_id'); } } } # Break here if we have no results if (!$results) { return false; } # Otherwise, sort items in rank and print the first 10 ones unset($return, $count); arsort($item_vote); foreach ($item_vote as $thisitem => $vote) { $count++; if ($count > $limit) { break; } list($tracker, $item_id) = explode("#", $thisitem); $prefix = utils_get_tracker_prefix($tracker); # if the summar item is large (>30), only show the first # 30 characters of the story if (strlen($item_summary[$thisitem]) > 30) { $item_summary[$thisitem] = substr($item_summary[$thisitem], 0, 30); $item_summary[$thisitem] = substr($item_summary[$thisitem], 0, strrpos($item_summary[$thisitem], ' ')); $item_summary[$thisitem] .= "..."; } $return .= '<div class="'.utils_get_alt_row_color($count).'">'. '<span class="smaller">&nbsp;&nbsp;- '. '<a href="'.$GLOBALS['sys_home'].$tracker.'/?func=detailitem&amp;item_id='.$item_id.'">'. $prefix .' #'.$item_id.'</a>'. _(": ").'&nbsp;'. '<a href="'.$GLOBALS['sys_home'].$tracker.'/?func=detailitem&amp;item_id='.$item_id.'">'.stripslashes($item_summary[$thisitem]).'</a>,'. '&nbsp;'.sprintf(ngettext("%s vote", "%s votes", $vote), $vote). # not enough space! #', '.group_getname($item_group_id[$thisitem]). '</span></div>'; } return $return; }

---