Changeset 1512 in ExiteCMS for themes/PLi-Fusion/PLiXmas/php-files/themes/PLiXmas/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/PLiXmas/php-files/themes/PLiXmas/theme_functions.php (modified) (4 diffs)

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

@@ -14 +14 @@
 // include the menu functions to create the header menu bar
 require_once PATH_INCLUDES."menu_include.php";
+
+// include the text image generation function
+require_once PATH_INCLUDES."font2image.php";
 
 // generate the treelist for items in the header menu bar
@@ -54 +57 @@
 +-------------------------------------------------------*/
 function downloadbars() {
-    global $db_prefix;
-    
+    global $db_prefix, $settings;
+
+    // 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'];
+        $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 DESC");
-    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']));
-            $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
@@ -106 +132 @@
     // display the panel with the download statistics
     $i=1;
-    foreach ($download as $key => $value) {
-        $download[$key]['value'] = floor($value['percentage'] * $multiplier);
-        $download[$key]['baseline'] = 65 - $download[$key]['value'];
+    foreach ($downloads as $key => $value) {
+        $downloads[$key]['value'] = floor($value['percentage'] * $multiplier);
         $i++;
     }
-    return $download;
+
+    return $downloads;
 }
 
@@ -117 +143 @@
 | Generate the title for the download bar counter       |
 +-------------------------------------------------------*/
-function bartitle() {
-    global $db_prefix;
+function bartitle($downloads) {
+    global $db_prefix, $settings;
 
-    $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']);
-    if (!isset($bar_title)) $bar_title = "Current Release Downloads";
+    // calculate the total downloads
+    $total = 0;
+    foreach ($downloads as $download) {
+        $total += $download['download_count'];
+    }
 
+    $bar_title = explode("|", $settings['dlstats_title']);
+    $bar_title = sprintf(html_entity_decode(trim($bar_title[0])),$total);
+
+    if (!isset($bar_title)) $bar_title = "Current image downloads ";
+    
     return $bar_title;
 }