1.5.0 Rating Statistics and...
Moderator: Thorsten
1.5.0 Rating Statistics and...
Hi!
I just upgraded from 1.4.11 to 1.5.0. It appears that when an item has been given more than one type of rating, the ratings are split into separate entries rather than averaged. I'll look into it a bit more later, but is this a bug or a feature?
Also, I know this probably isn't the right forum for such requests, but have you considered making an option for logging into the FAQ outside of admin mode? Basically something that allows admins to mark an article as accessable for logged in users only, so articles could be stored that one might not want open to everyone. Admin mode doesn't display articles in the same way that a user would view them, otherwise that would be perfect. Perhaps the logged in accounts could even use SSL if the entire FAQ wasn't behind SSL.
I really like the way the FAQ works and the interface for creating articles, it would be great if it had this sort of functionality. Thank you again for such an excellent method for sharing information!
I just upgraded from 1.4.11 to 1.5.0. It appears that when an item has been given more than one type of rating, the ratings are split into separate entries rather than averaged. I'll look into it a bit more later, but is this a bug or a feature?
Also, I know this probably isn't the right forum for such requests, but have you considered making an option for logging into the FAQ outside of admin mode? Basically something that allows admins to mark an article as accessable for logged in users only, so articles could be stored that one might not want open to everyone. Admin mode doesn't display articles in the same way that a user would view them, otherwise that would be perfect. Perhaps the logged in accounts could even use SSL if the entire FAQ wasn't behind SSL.
I really like the way the FAQ works and the interface for creating articles, it would be great if it had this sort of functionality. Thank you again for such an excellent method for sharing information!
Hi,
both things will be implemented in version 1.6 which I started some days ago.
bye
Thorsten
both things will be implemented in version 1.6 which I started some days ago.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Hi Thorsten,
Great! It sounds like the next version's going to be even better. The ability to place an article in more than one category is already an excellent improvement. Incidentally, here's a screen shot of the statistics behavior I was talking about earlier:
http://xyzzy.dyn.dhs.org/images/rating-statistics.png
It only seems to happen when there are different ratings for an item (that is, maybe one 75% and one 100%).
Great! It sounds like the next version's going to be even better. The ability to place an article in more than one category is already an excellent improvement. Incidentally, here's a screen shot of the statistics behavior I was talking about earlier:
http://xyzzy.dyn.dhs.org/images/rating-statistics.png
It only seems to happen when there are different ratings for an item (that is, maybe one 75% and one 100%).
Hi,
your page isn't available.
bye
Thorsten
your page isn't available.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Hi Thorsten,
I had a bit of spare time and decided to look into the code that handles the grouping of the ratings in "admin/stat.ratings.php". I found that this works well enough for my purposes:
I won't pretend to be familiar enough with the code to know why the grouping was being done with all the other elements, but it seems to work ok once I changed it to this. For reference, this is what I removed from the select statement:
I hope this helps!
I had a bit of spare time and decided to look into the code that handles the grouping of the ratings in "admin/stat.ratings.php". I found that this works well enough for my purposes:
Code: Select all
$result = $db->query('SELECT '.SQLPREFIX.'faqdata.id, '.SQLPREFIX.'faqdata.lang, '.SQLPREFIX.'faqdata.active, '.SQLPREFIX.'faqcategoryrelations.category_id, '.SQLPREFIX.'faqdata.thema, AVG('.SQLPREFIX.'faqvoting.vote) AS num, count(*) FROM '.SQLPREFIX.'faqvoting, '.SQLPREFIX.'faqdata LEFT JOIN '.SQLPREFIX.'faqcategoryrelations ON '.SQLPREFIX.'faqdata.id = '.SQLPREFIX.'faqcategoryrelations.record_id AND '.SQLPREFIX.'faqdata.lang = '.SQLPREFIX.'faqcategoryrelations.record_lang WHERE '.SQLPREFIX.'faqdata.id = '.SQLPREFIX.'faqvoting.artikel GROUP BY
'.SQLPREFIX.'faqdata.id ORDER BY '.SQLPREFIX.'faqcategoryrelations.category_id'
);
Code: Select all
, '.SQLPREFIX.'faqdata.lang, '.SQLPREFIX.'faqdata.active, '.SQLPREFIX
.'faqcategoryrelations.category_id, '.SQLPREFIX.'faqdata.thema, '.SQLPREFIX.'faqvoting.vote, '.SQLPREFIX.'faqvoting.usr
Hi,
thanks a lot, I'll fix this in 1.5.1!
bye
Thorsten
thanks a lot, I'll fix this in 1.5.1!
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Hi,
it's fixed now in 1.5.1 and 1.6.0-dev.
bye
Thorsten
it's fixed now in 1.5.1 and 1.6.0-dev.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
i'have the same problem in 1.5.2Thorsten wrote: it's fixed now in 1.5.1 and 1.6.0-dev.
Laurent J.V. Dubois
Your French Sales Partner
Your French Sales Partner
Hi,
please test a stable snapshot tomorrow. This bug should be fixed in this version.
bye
Thorsten
please test a stable snapshot tomorrow. This bug should be fixed in this version.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist