Best Posts - uncover your top content [Deleted]
- Thread starter Luke F
- Start date
ForestForTrees
Well-known member
Feel free to ignore this post, as I understand Luke probably won't want to add this feature.
I would LOVE this if it had a good way of finding the best threads rather than the best posts. On my forum, the order and context of posts in a thread really matters, so an addon that is based on SQL queries that looks for the posts with the highest likes really wouldn't work.
Generally, our best threads have lots of posts in them with above average likes. Finding a way to compute that would be very hard, though, so I may have to wait a looooooonng time before I get something like this. The ideal measure for me would be something like "threads with the most total likes per page of posts." In other words threads that maximize "(total likes per thread)/(Round((total posts per thread) / 20) + 1)," where the round function rounds down.
Also having a way to restrict the search to posts made in the last week or month would be amazing.
Anyhoo, those are the functions I would kill for.
I would LOVE this if it had a good way of finding the best threads rather than the best posts. On my forum, the order and context of posts in a thread really matters, so an addon that is based on SQL queries that looks for the posts with the highest likes really wouldn't work.
Generally, our best threads have lots of posts in them with above average likes. Finding a way to compute that would be very hard, though, so I may have to wait a looooooonng time before I get something like this. The ideal measure for me would be something like "threads with the most total likes per page of posts." In other words threads that maximize "(total likes per thread)/(Round((total posts per thread) / 20) + 1)," where the round function rounds down.
Also having a way to restrict the search to posts made in the last week or month would be amazing.
Anyhoo, those are the functions I would kill for.
dethfire
Well-known member
Yeah it should be best threads not random best posts.
@Luke Foreman I had this disabled for awhile due to it increasing my server load. I updated and enabled it last night. I tried to run the cron which timed out. Then I used the rebuild cache option in Applications, which also timed out. I tried to reload it a few times and it ended up crashing MySQL.
Any suggestions? My forum has a ridiculous amount of likes so maybe it's just too much to handle. It's not uncommon to have 30,000 new likes a day.
Any suggestions? My forum has a ridiculous amount of likes so maybe it's just too much to handle. It's not uncommon to have 30,000 new likes a day.
dethfire
Well-known member
.....wow....!
Stuart Wright
Well-known member
That's an incredible number!
It's a little excessive
Are you using this on AVForums? Any issues with it increasing load for you?
Stuart Wright
Well-known member
We have over 70 addons which all slow things down to a degree. Post ratings is really important for us. I think it slows down the forums more than most addons simply because it does so much. Big tables and all that. But obviously it doesn't have such a detrimental effect that it isn't worth it.
Luke F
Well-known member
Unfortunately that isn't possible, as setting the option to zero will disable the per-thread listing entirely
I see. Do you think it can be easily modified? I really think it's beneficial to see the whole thread, which just the best posts first
Luke F
Well-known member
Luke Foreman updated Best Posts - uncover your top content with a new update entry:
Version 1.2.0
Read the rest of this update entry...
Version 1.2.0
Read the rest of this update entry...
rafass
Well-known member
Hello Luke, I'm getting, this error:
Could you please give me a hand to solve it? Thanks!
Code:
Server Error Log
Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) + post.likes, unix_timestamp() from xf_post post where po' at line 4 - library/Zend/Db/Statement/Mysqli.php:77
Generated By: Unknown Account, 46 minutes ago
Stack Trace
#0 /home/foro/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('\r\n\t\t\t\treplace i...')
#1 /home/foro/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '\r\n\t\t\t\treplace i...')
#2 /home/foro/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('\r\n\t\t\t\treplace i...')
#3 /home/foro/public_html/library/Dark/BestPosts/Model.php(93): Zend_Db_Adapter_Abstract->query('\r\n\t\t\t\treplace i...', Array)
#4 /home/foro/public_html/library/Dark/BestPosts/ControllerPublic/Thread.php(24): Dark_BestPosts_Model->updatePositiveRatingCacheForThread(223)
#5 /home/foro/public_html/library/XenForo/FrontController.php(347): Dark_BestPosts_ControllerPublic_Thread->actionBestPosts()
#6 /home/foro/public_html/library/XenForo/FrontController.php(134): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#7 /home/foro/public_html/index.php(13): XenForo_FrontController->run()
#8 {main}
Request State
array(3) {
["url"] => string(50) "https://my-website./threads/thread-tittle/best-posts"
["_GET"] => array(0) {
}
["_POST"] => array(0) {
}
}rafass
Well-known member
How can I fix that error @Luke Foreman ?
Thanks.
Thanks.
Luke F
Well-known member
Only those with permission to view the node will see those post from the node listed in Best Posts
I've PM'd you a patch for this now
Similar threads
