Changeset 2394

Timestamp:

06/25/10 07:57:21 (13 years ago)

Author:

JcDenis

Message:

rateIt 2.0-alpha2

• Fixed (hope so) postgreSQL compatibility
• Fixed high note on 'double' style
• Fixed admin crash on non 2.2

Location:

plugins/rateIt

Files:

• _define.php (modified) (1 diff)
• _prepend.php (modified) (1 diff)
• _public.php (modified) (2 diffs)
• default-templates/js/jquery.rateit.js (modified) (2 diffs)
• inc/class.rateit.php (modified) (1 diff)
• inc/modules/lib.rateit.module.category.public.php (modified) (1 diff)
• inc/modules/lib.rateit.module.cinecturlink2.public.php (modified) (1 diff)
• inc/modules/lib.rateit.module.comment.public.php (modified) (1 diff)
• inc/modules/lib.rateit.module.gallery.admin.php (modified) (1 diff)
• inc/modules/lib.rateit.module.gallery.public.php (modified) (2 diffs)
• inc/modules/lib.rateit.module.post.public.php (modified) (1 diff)
• inc/modules/lib.rateit.module.tag.public.php (modified) (1 diff)
• index.php (modified) (1 diff)
• locales/fr/main.lang.php (modified) (1 diff)
• locales/fr/main.po (modified) (1 diff)
• release.txt (modified) (1 diff)

plugins/rateIt/_define.php

@@ -17 +17 @@
      /* Description*/         "Rating system for your blogs",
      /* Author */             "JC Denis",
-     /* Version */            '2.0-alpha',
+     /* Version */            '2.0-alpha2',
      /* Permissions */        'admin'
 );
-     /* date */          #20100613
+     /* date */          #20100625
 ?>

plugins/rateIt/_prepend.php

@@ -12 +12 @@
 
 if (!defined('DC_RC_PATH')){return;}
+if (version_compare(DC_VERSION,'2.2-alpha','<')){return;}
 
 global $__autoload, $core;

plugins/rateIt/_public.php

@@ -270 +270 @@
           "</script> \n".
           "<script type=\"text/javascript\" src=\"".
-               $core->blog->url.$core->url->getBase('rateItmodule')."/js/jquery.rateit.js\"></script> \n".
+               $core->blog->url.$core->url->getBase('rateItmodule').'/js/jquery.rateit.js">'.
+          "</script> \n".
           "<script type=\"text/javascript\"> \n".
           "//<![CDATA[\n".
@@ -526 +527 @@
           if ($w->show_fullnote && in_array($style,array('twin','simple')))
           {
-               $res .= '<p>'.rateItContext::value('mincount',$type,$id,$rs->mincount).'</p>';
+               $res .= '<p>'.rateItContext::value('maxcount',$type,$id,$rs->maxcount).'</p>';
           }
           

plugins/rateIt/default-templates/js/jquery.rateit.js

@@ -45 +45 @@
                                    $('input.rateit-'+type+'-'+id).rating({readOnly:true});
                                    if ($('input.rateit-'+type+'-'+id).hasClass('rateit-loop-prevent')){
-                                        //$('input.rateit-'+type+'-'+id).rating('disable');
+                                        /*$('input.rateit-'+type+'-'+id).rating('disable');*/
                                    }
                                    else{
@@ -73 +73 @@
                                                        $('*').find('.rateit-fullnote-'+type+'-'+id).each(function(){$(this).text(data.find('item').attr('note')+'/'+data.find('item').attr('quotient'))});
                                                        
-                                                       if (msg_thanks!='')
+                                                       if (msg_thanks!=''){
                                                             $('*').find('.rateit-linker-'+type+'-'+id).each(function(){$(this).empty().append('<p>'+msg_thanks+'</p>')});
-
+                                                       }
                                                   }else{
                                                        alert($(data).find('message').text());

plugins/rateIt/inc/class.rateit.php

@@ -289 +289 @@
           {
                $strReq =
-               'SELECT DISTINCT '.
+               'SELECT '.
                'SUM(RI.rateit_note / RI.rateit_quotient) as rateit_sum, '.
                'MAX(RI.rateit_note / RI.rateit_quotient) as rateit_max, '.
                'MIN(RI.rateit_note / RI.rateit_quotient) as rateit_min, '.
+               'MAX(RI.rateit_time) as rateit_time, '.
                '(SUM(RI.rateit_note / RI.rateit_quotient) / COUNT(RI.rateit_note)) as rateit_avg, ';
                

plugins/rateIt/inc/modules/lib.rateit.module.category.public.php

@@ -66 +66 @@
           $p['columns'][] = 'C.cat_title AS title';
           $p['columns'][] = 'C.cat_id AS id';
-          if (!isset($p['groups'])) $p['groups'] = array();
+          
           $p['groups'][] = 'C.cat_url';
           $p['groups'][] = 'C.cat_title';
+          $p['groups'][] = 'C.cat_id';
+          
           $p['from'] .= ' INNER JOIN '.$core->prefix.'category C ON CAST(C.cat_id as char)=RI.rateit_id ';
 /*

plugins/rateIt/inc/modules/lib.rateit.module.cinecturlink2.public.php

@@ -53 +53 @@
           $p['columns'][] = 'C.link_title AS title';
           $p['columns'][] = 'C.link_id AS id';
-          if (!isset($p['groups'])) $p['groups'] = array();
+          
           $p['groups'][] = 'C.link_id';
           $p['groups'][] = 'C.link_title';
+          
           $p['from'] .= ' INNER JOIN '.$core->prefix.'cinecturlink2 C ON CAST(C.link_id as char)=RI.rateit_id ';
      }

plugins/rateIt/inc/modules/lib.rateit.module.comment.public.php

@@ -51 +51 @@
           
           $p['columns'][] = $core->con->concat("'".$core->blog->url.$core->getPostPublicUrl('post','')."'",'P.post_url').' AS url';
-          $p['columns'][] = 'P.post_title AS title';
+          $p['columns'][] = 'C.comment_author AS title';
           $p['columns'][] = 'C.comment_id AS id';
-          if (!isset($p['groups'])) $p['groups'] = array();
+          
+          $p['groups'][] = 'C.comment_id';
+          $p['groups'][] = 'C.comment_author';
           $p['groups'][] = 'P.post_url';
-          $p['groups'][] = 'P.post_title';
+          
           $p['from'] .= ' INNER JOIN '.$core->prefix.'comment C ON CAST(C.comment_id as char)=RI.rateit_id ';
           $p['from'] .= ' INNER JOIN '.$core->prefix.'post P ON C.comment_id = P.post_id ';

plugins/rateIt/inc/modules/lib.rateit.module.gallery.admin.php

@@ -29 +29 @@
           if ($action == 'save_moule_galitem')
           {
-               $core->blog->settings->rateit->put('rateit_galitem_active',!empty(,$_POST['rateit_galitem_active']),'boolean','rateit addon gallery item enabled',true,false);
+               $core->blog->settings->rateit->put('rateit_galitem_active',!empty($_POST['rateit_galitem_active']),'boolean','rateit addon gallery item enabled',true,false);
                $core->blog->settings->rateit->put('rateit_galitemtpl',!empty($_POST['rateit_galitemtpl']),'boolean','rateit template gallery items page',true,false);
                

plugins/rateIt/inc/modules/lib.rateit.module.gallery.public.php

@@ -104 +104 @@
                $p['columns'][] = 'P.post_title AS title';
                $p['columns'][] = 'P.post_id AS id';
-               if (!isset($p['groups'])) $p['groups'] = array();
+               
                $p['groups'][] = 'P.post_url';
                $p['groups'][] = 'P.post_title';
                $p['groups'][] = 'P.post_id';
+               
                $p['from'] .= ' INNER JOIN '.$core->prefix.'post P ON CAST(P.post_id as char)=RI.rateit_id ';
                $p['sql'] .= "AND post_type='gal' ";
@@ -124 +125 @@
                $p['columns'][] = 'P.post_title AS title';
                $p['columns'][] = 'P.post_id AS id';
-               if (!isset($p['groups'])) $p['groups'] = array();
+               
                $p['groups'][] = 'P.post_url';
                $p['groups'][] = 'P.post_title';
                $p['groups'][] = 'P.post_id';
+               
                $p['from'] .= ' INNER JOIN '.$core->prefix.'post P ON CAST(P.post_id as char)=RI.rateit_id ';
                $p['sql'] .= "AND post_type='galitem' ";

plugins/rateIt/inc/modules/lib.rateit.module.post.public.php

@@ -70 +70 @@
           
           $p['columns'][] = $core->con->concat("'".$core->blog->url.$core->getPostPublicUrl('post','')."'",'P.post_url').' AS url';
-          $p['columns'][] = 'P.post_url AS url';
           $p['columns'][] = 'P.post_title AS title';
           $p['columns'][] = 'P.post_id AS id';
-          if (!isset($p['groups'])) $p['groups'] = array();
+          
           $p['groups'][] = 'P.post_url';
           $p['groups'][] = 'P.post_title';
           $p['groups'][] = 'P.post_id';
+          
           $p['from'] .= ' INNER JOIN '.$core->prefix.'post P ON CAST(P.post_id as char)=RI.rateit_id ';
           $p['sql'] .= " AND P.post_type='post' AND P.post_status = 1 AND P.post_password IS NULL ";

plugins/rateIt/inc/modules/lib.rateit.module.tag.public.php

@@ -67 +67 @@
           $p['columns'][] = 'M.meta_id AS title';
           $p['columns'][] = 'M.meta_id AS id';
-          if (!isset($p['groups'])) $p['groups'] = array();
+          
           $p['groups'][] = 'M.meta_id';
+          
           $p['from'] .= ' INNER JOIN '.$core->prefix.'meta M ON M.meta_id=RI.rateit_id ';
           $p['sql'] .= "AND M.meta_type='tag' ";

plugins/rateIt/index.php

@@ -40 +40 @@
 dcPage::jsVar('jcToolsBox.prototype.text_wait',__('Please wait')).
 dcPage::jsVar('jcToolsBox.prototype.section',$section).
-"\n//]]>\n</script>\n";;
+"\n//]]>\n</script>\n";
 
 # Common menu

plugins/rateIt/locales/fr/main.lang.php

@@ -513 +513 @@
 
 #inc/modules/lib.rateit.module.post.admin.php:68
-$GLOBALS['__l10n']['Limit to one category:'] = 'Limiter à une caégorie :';
+$GLOBALS['__l10n']['Limit to one category:'] = 'Limiter à une catégorie :';
 
 #inc/modules/lib.rateit.module.post.admin.php:72

plugins/rateIt/locales/fr/main.po

@@ -666 +666 @@
 #: inc/modules/lib.rateit.module.post.admin.php:68
 msgid "Limit to one category:"
-msgstr "Limiter à une caégorie :"
+msgstr "Limiter à une catégorie :"
 
 #: inc/modules/lib.rateit.module.post.admin.php:72

plugins/rateIt/release.txt

@@ -1 +1 @@
 x.x.x xxxxxxxx
  - Not added ability to explode post type rating in subcategories
- - Not added other styles of rate (I love /I d'ont love)
+ - Not added rating on other post_type (see plugin muppet)
  - Not added public API
  - Not completed modules behaviors (delete/edit category, tag...)
+
+2.0-alpha2 20100625
+ * Fixed (hope so) postgreSQL compatibility
+ * Fixed high note on 'double' style
+ * Fixed admin crash on non 2.2
 
 2.0-alpha 20100613