Changeset 236

Timestamp:

07/28/10 10:35:12 (19 months ago)

Author:

fuze

Message:

Модуль популярные статьи: добавлен выбор категории

Location:

branches/fuze

Files:

• admin/modules/mod_bestcontent/backend.php (modified) (2 diffs)
• modules/mod_bestcontent/module.php (modified) (2 diffs)

branches/fuze/admin/modules/mod_bestcontent/backend.php

@@ -37 +37 @@
                 $cfg['showlink'] = $_REQUEST['showlink'];
                 $cfg['showdesc'] = $_REQUEST['showdesc'];
+                $cfg['cat_id'] = $_REQUEST['cat_id'];
 
+                if (!isset($_REQUEST['subs'])) { $cfg['subs'] = 0; } else { $cfg['subs'] = 1; }
+                
         $inCore->saveModuleConfig($_REQUEST['id'], $cfg);
                 $msg = 'Íàñòðîéêè ñîõðàíåíû.';
 
         }
-        
+        if (!isset($cfg['subs'])) { $cfg['subs'] = 0;}
         if (@$msg) { echo '<p class="success">'.$msg.'</p>'; }
 
@@ -67 +70 @@
 Íåò</td>
     </tr>
+        <tr>
+            <td valign="top"><strong>Ìàòåðèàëû èç ðàçäåëà:</strong> </td>
+            <td valign="top"><div><select name="cat_id" id="cat_id">
+              <option value="-1">-- Âñå ðàçäåëû --</option>
+              <?php
+                  if (isset($cfg['cat_id'])) {
+                        echo $inCore->getListItemsNS('cms_category', $cfg['cat_id']);
+                    } else {
+                       echo $inCore->getListItemsNS('cms_category');
+                    }
+              ?>
+            </select></div>
+              <div style="margin-top:5px">
+                <table border="0" cellspacing="0" cellpadding="0">
+                  <tr>
+                    <td><input name="subs" type="checkbox" value="1" <?php if (@$cfg['subs']) { echo 'checked'; } ?>/></td>
+                    <td>Âìåñòå ñ ïîäðàçäåëàìè </td>
+                  </tr>
+                </table>
+            </div></td>
+     </tr>
   </table>
   <p>

branches/fuze/modules/mod_bestcontent/module.php

@@ -23 +23 @@
                         return;
                 }
+                if (!isset($cfg['subs'])) { $cfg['subs'] = 1; }
                 $today = date("Y-m-d H:i:s");
+                if ($cfg['cat_id'] != '-1') {
+                        if (!$cfg['subs']){
+                                //âûáèðàåì èç êàòåãîðèè
+                                $catsql = ' AND c.category_id = '.$cfg['cat_id'];
+                        } else {
+                                //âûáèðàåì èç êàòåãîðèè è ïîäêàòåãîðèé
+                                $rootcat = $inDB->get_fields('cms_category', 'id='.$cfg['cat_id'], 'NSLeft, NSRight');
+                                $catsql = "AND (c.category_id = cat.id AND cat.NSLeft >= {$rootcat['NSLeft']} AND cat.NSRight <= {$rootcat['NSRight']})";
+                        }               
+                } else { $catsql = 'AND c.category_id = cat.id'; } 
+
 
                 $sql = "SELECT c.*, c.pubdate as fpubdate, 
                         IFNULL(r.total_rating, 0) as points,
                                                 u.nickname as author, u.login as author_login
-                                FROM cms_users u, cms_content c
+                                FROM cms_category cat, cms_users u, cms_content c
                                 LEFT JOIN cms_ratings_total r ON r.item_id=c.id AND r.target='content'
                                 WHERE c.published = 1 AND c.user_id = u.id AND c.canrate = 1
                 AND (c.is_end=0 OR (c.is_end=1 AND c.enddate >= '$today' AND c.pubdate <= '$today')) 
+                                ".$catsql."
                                 GROUP BY r.item_id
                                 ORDER BY points DESC";
@@ -37 +50 @@
                 $sql .= "\n" . "LIMIT ".$cfg['shownum'];
         
-                $result = $inDB->query($sql) or die('<pre>'.$sql.'</pre>'.mysql_error());
+                $result = $inDB->query($sql);
                 
                 if ($inDB->num_rows($result)){