Changeset 1512 in ExiteCMS for themes/PLi-Fusion/PLiThemeCentered/php-files/themes/PLiThemeCentered/theme_functions.php

Timestamp:

07/02/08 18:58:52 (4 years ago)

Author:

hverton

Message:

updated the PLi themes to work with the new download_statistics module

File:

• themes/PLi-Fusion/PLiThemeCentered/php-files/themes/PLiThemeCentered/theme_functions.php (modified) (5 diffs)

themes/PLi-Fusion/PLiThemeCentered/php-files/themes/PLiThemeCentered/theme_functions.php

@@ -52 +52 @@
     }
 }
+/*
+[download_id] => 35
+            [download_title] => DM500
+            [download_description] => PLi® Iolite 2008 Edition - for the Dreambox DM500
+            [download_url] => http://downloads.pli-images.org/dm500/pli-Iolite-dm500-20071230-4014.zip
+            [download_cat] => 8
+            [download_license] => GPL
+            [download_os] => tuxbox - Enigma1
+            [download_version] => Iolite 2008 Edition
+            [download_filesize] => 5,878Mb
+            [download_bar] => 1
+            [download_datestamp] => 1199046320
+            [download_count] => 2138
+            [image_url] => /files/cache/pli-images.dev.vnvadvies.nl.PLiTheme.977ecf39a1186353f643b8b55ce34d5c.png
+            [image_height] => 10
+            [image_width] => 28
+            [percentage] => 5
+            [value] => 7
+ */
 
 /*------------------------------------------------------+
@@ -58 +77 @@
 function downloadbars() {
     global $db_prefix, $settings;
-    
+
     // define the font2image array
     $font2png = array();
@@ -78 +97 @@
     $font2png['return_link'] = true;
 
+    // define the download records we want a bar graph from
+    $downloads = array();
+
+    $total = 0;
+    // get the defined download bars
+    $result = dbquery("SELECT * FROM ".$db_prefix."dlstats_counters ORDER BY dlsc_order");
+    while ($data = dbarray($result)) {
+        // start with a count of zero
+        $download = array('download_count' => 0);
+        // check if we need to get a local download counter
+        if ($data['dlsc_download_id']) {
+            $result2 = dbquery("SELECT d.*, c.download_cat_access FROM ".$db_prefix."downloads d LEFT JOIN ".$db_prefix."download_cats c ON d.download_cat = c.download_cat_id WHERE d.download_id = '".$data['dlsc_download_id']."'");
+            if ($data2 = dbarray($result2)) {
+                // check if this user has the right to download it
+                $access = true;
+                $cat_id = $data2['download_cat'];
+                while(true) {
+                    // check if the user has access to this download item
+                    $data3 = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id = '".$cat_id."'"));
+                    if (!checkgroup($data3['download_cat_access'])) {
+                        $access = false;
+                        break;
+                    }
+                    // if this was a sub-category, check the parent as well
+                    $cat_id = $data3['download_parent'];
+                    // if no more parents are present, end the loop
+                    if ($cat_id == 0) break;
+                }
+                // if the user has access, add the info from the download record
+                if ($access) {
+                    $download = array_merge($download, $data2);
+                }
+            }
+        }
+        // check if we need to add file counters
+        $files = explode("\n", $data['dlsc_files']);
+        foreach($files as $file) {
+            $result2 = dbquery("SELECT * FROM ".$db_prefix."dlstats_files WHERE dlsf_file = '".trim($file)."'");
+            if ($data2 = dbarray($result2)) {
+                // get the counter
+                $download['download_count'] += $data2['dlsf_counter'];
+            }
+        }
+        // and add some data from the counter definition
+        $download['download_title'] = $data['dlsc_name'];
+        $download['download_description'] = $data['dlsc_description'];
+        // make sure the title is properly formatted and fits
+        if (strlen($download['download_title']) > 6) $download['download_title'] = substr($download['download_title'],0,6);
+        $download['download_title'] = strtoupper(trim($download['download_title']));
+        $font2png['font_text'] = $download['download_title'];
+        $download['image_url'] = font2image($font2png);
+        $size = getimagesize(PATH_ROOT.$download['image_url']);
+        $download['image_height'] =$size[1];
+        $download['image_width'] = $size[0];
+        $total += $download['download_count'];
+        $downloads[] = $download;
+    }
+
     // define the max width of a bar in pixels
     $barheight = 65;
-    
-    // define the download records we want a bar graph from
-    $download = array();
-
-    // get the download statistics for the required download records
-    $total = 0;
-    $result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_bar > '0' ORDER BY download_bar ASC");
-    while ($data = dbarray($result)) {
-        $access = true;
-        $cat_id = $data['download_cat'];
-        while(true) {
-            // check if the user has access to this download item
-            $data2 = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id = '".$cat_id."'"));
-            if (!checkgroup($data2['download_cat_access'])) {
-                $access = false;
-                break;
-            }
-            // if this was a sub-category, check the parent as well
-            $cat_id = $data2['download_parent'];
-            // if no more parents are present, end the loop
-            if ($cat_id == 0) break;
-            
-        }
-        // if the user has access, add this download to the bar panel
-        if ($access) {
-            if (strlen($data['download_title']) > 6) $data['download_title'] = substr($data['download_title'],0,6);
-            $data['download_title'] = strtoupper(trim($data['download_title']));
-            $font2png['font_text'] = $data['download_title'];
-            $data['image_url'] = font2image($font2png);
-            $download[] = $data;
-            $total += $data['download_count'];
-        }
-    }
 
     // calculate the percentages of the grand total of all the entries listed (in $total)
     $maxperc = 0;
-    foreach ($download as $key => $value) {
+    foreach ($downloads as $key => $value) {
         if ($total == 0)
-            $download[$key]['percentage'] = 0;
+            $downloads[$key]['percentage'] = 0;
         else
-            $download[$key]['percentage'] = floor($value['download_count'] / $total * 100);
+            $downloads[$key]['percentage'] = floor($value['download_count'] / $total * 100);
         // add 1 to make sure 'percentage' is never zero (to work around a Firefox DIV bug)
-        $download[$key]['percentage']++;
-        $maxperc = max($maxperc, $download[$key]['percentage']);
+        $downloads[$key]['percentage']++;
+        $maxperc = max($maxperc, $downloads[$key]['percentage']);
     }
     // calculate the percentage multiplier to fill out the bars nicely
@@ -130 +174 @@
     // display the panel with the download statistics
     $i=1;
-    foreach ($download as $key => $value) {
-        $download[$key]['value'] = floor($value['percentage'] * $multiplier);
+    foreach ($downloads as $key => $value) {
+        $downloads[$key]['value'] = floor($value['percentage'] * $multiplier);
         $i++;
     }
-    return $download;
+
+    return $downloads;
 }
 
@@ -149 +194 @@
     }
 
-    $result = dbquery("SELECT download_cat_name FROM ".$db_prefix."download_cats WHERE download_cat_id = '0'");
-    if ($data = dbarray($result)) {
-        if ($data['download_cat_name'] != "") {
-            $bar_title = trim($data['download_cat_name']). " : ".$total."  | ";
-        }
-    }
+    $bar_title = sprintf(html_entity_decode($settings['dlstats_title']),$total);
+
     if (!isset($bar_title)) $bar_title = "Current image downloads ";