 |  |  | |
db_Select("event", "*", "(event_start>='$monthstart' AND event_start<= '$monthend') OR (event_rec_y='$current_month')");
$events = $sql -> db_Rows();
while($row = $sql -> db_Fetch()){
extract($row);
$evf = getdate($event_start);
$tmp = $evf['mday'];
$event_true[$tmp] = $event_category;
}
// -----------------------------------------------------------------------------------------------------------
// set up arrays for calender display ------------------------------------------------------------------
$week = Array(EC_LAN_25,EC_LAN_19,EC_LAN_20,EC_LAN_21,EC_LAN_22,EC_LAN_23,EC_LAN_24);
$months = Array(EC_LAN_0,EC_LAN_1,EC_LAN_2,EC_LAN_3,EC_LAN_4,EC_LAN_5,EC_LAN_6,EC_LAN_7,EC_LAN_8,EC_LAN_9,EC_LAN_10,EC_LAN_11);
$calendar_title = $months[$datearray[mon]-1]." ".$current_year;
// -----------------------------------------------------------------------------------------------------------
$text = "";
if($events){
$text .= EC_LAN_26 . ": ".$events;
}else{
$text .= EC_LAN_27;
}
$start = $monthstart;
$text .= "
";
foreach($week as $day){
$text .= "| ".$day." | ";
}
$text .= " ";
$thismonth = $datearray['mon'];
$thisday = $datearray['mday'];
for($c=0; $c<$firstdayarray['wday']; $c++){
$text .= "
| ";
}
$loop = $firstdayarray['wday'];
for($c=1; $c<=31; $c++){
$dayarray = getdate($start+($c*84460));
if($dayarray['mon'] == $thismonth){
if($thisday == $c){
$text .= "";
}else{
$text .=" | ";
}
if($event_true[($c)]){
$sql -> db_Select("event_cat", "*", "event_cat_id='".$event_true[($c)]."' ");
$icon = $sql -> db_Fetch();
extract($icon);
$img = "![](".$ec_dir."images/".$event_cat_icon.") ";
}else{
$img = "![](".$ec_dir."images/cal1.png) ";
}
$linkut = mktime(0 ,0 ,0 ,$dayarray['mon'], $c, $datearray['year']);
$text .="$img
$c";
if($thisday == $c){
}
$text .= " | \n";
$loop++;
if($loop == 7){
$loop = 0;
$text .= " ";
}
}
}
for($a=($loop+1); $a<=7; $a++){
$text .="| | ";
}
$text .= "
| |
db_Select("download_category", "*", "download_category_parent='0' ")){
$ns -> gen_tablerend(LAN_dl_18, " ".LAN_dl_2." ");
?>
|
|
| |
".LAN_dl_19." |
".LAN_dl_20." |
".LAN_dl_21." |
".LAN_dl_18." |
";
$sql2 = new db; $sql3 = new db;
while($row = $sql-> db_Fetch()){
extract($row);
if(($download_category_class && check_class($download_category_class)) || !$download_category_class || ($download_category_class == 254 && USER) ){
$text .= "|
";
$parent_status == "open";
}else{
$parent_status == "closed";
}
$categories = $sql2 -> db_Select("download_category", "*", "download_category_parent='".$download_category_id."' ");
if(!$categories){
$text .= "|
";
}else{
while($row = $sql2-> db_Fetch()){
extract($row);
$total_filesize=0; $total_downloadcount=0;
if($filecount = $sql3 -> db_Select("download", "*", "download_category='$download_category_id'")){
while($row = $sql3 -> db_Fetch()){
extract($row);
$total_filesize += $download_filesize;
$total_downloadcount += $download_requested;
}
$total_filesize = parsesize($total_filesize);
}
$new = (USER && $sql3 -> db_Count("download", "(*)", "WHERE download_category='$download_category_id' AND download_datestamp>".USERLV) ? "![](".e_IMAGE."generic/new.png) " : "");
if(!$download_category_class || ($download_category_class && check_class($download_category_class))){
$text .= "
";
}
}
}
}
$text .= "
".LAN_dl_36."
";
$ns -> gen_tablerend(LAN_dl_18.$type, $text);
?>
|
|
db_Select("download", "*", "download_category='$id' AND download_active='1'");
if(!$total_downloads){ require_once(FOOTERF); exit; }
$sql -> db_Select("download_category", "*", "download_category_id='$id'");
$row = $sql -> db_Fetch(); extract($row);
$core_total = $sql -> db_Count("download WHERE download_category='$id' AND download_active=1");
$type = $download_category_name." [ ".$download_category_description." ]";
$text = "";
$ns -> gen_tablerend($type, $text);
echo "";
require_once(e_HANDLER."np_class.php");
$ix = new nextprev("download.php", $from, $view, $total_downloads, "Downloads", "list.".$id.".".$view.".".$order.".".$sort);
?>
|
|
![](".e_IMAGE."generic/download.png)
![](".e_IMAGE."rate/star.png)
";
}
if($ratearray[2]){
$text .= "![](".e_IMAGE."rate/".$ratearray[2].".png)
";
}
if($ratearray[2] == ""){ $ratearray[2] = 0; }
$text .= " ".$ratearray[1].".".$ratearray[2]." - ".$ratearray[0]." ";
$text .= ($ratearray[0] == 1 ? "vote" : "votes");
}else{
$text .= LAN_dl_13;
}
$text .= "