View Staff Threads 1.0.9a

[Xon]

Xon updated View Staff Threads with a new update entry:

php compatibility update

Remove use of php7 only language features. Restores compatibility with php +5.3

Read the rest of this update entry...

 

[Luis]

Thanks @Xon , now works correctly.

 

[Luis]

Hi @Xon

I have an error with you addon and Widget framework:

Error Info
Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: Not unique table/alias: 'user' - library/Zend/Db/Statement/Mysqli.php:77
Generated By: luis, 1 minute ago
Stack Trace

#0 /home/directory/public_html/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?????SELECT thr...')
#1 /home/directory/public_html/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?????SELECT thr...')
#2 /home/directory/public_html/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?????SELECT thr...')
#3 /home/directory/public_html/library/XenForo/Model.php(219): Zend_Db_Adapter_Abstract->query('?????SELECT thr...', Array, 2)
#4 /home/directory/public_html/library/XenForo/Model/Thread.php(563): XenForo_Model->fetchAllKeyed('?????SELECT thr...', 'thread_id')
#5 /home/directory/public_html/library/WidgetFramework/WidgetRenderer/Threads.php(296): XenForo_Model_Thread->getThreads(Array, Array)
#6 /home/directory/public_html/library/WidgetFramework/WidgetRenderer/Threads.php(178): WidgetFramework_WidgetRenderer_Threads->_getThreads(Array, 'forum_view', Array, Object(XenForo_Template_Public))
#7 /home/directory/public_html/library/WidgetFramework/WidgetRenderer.php(683): WidgetFramework_WidgetRenderer_Threads->_render(Array, 'forum_view', Array, Object(XenForo_Template_Public))
#8 /home/directory/public_html/library/WidgetFramework/Core.php(397): WidgetFramework_WidgetRenderer->render(Array, 'forum_view', Array, Object(XenForo_Template_Public), Object(_WidgetFramework_ArrayOfString))
#9 /home/directory/public_html/library/WidgetFramework/Core.php(316): WidgetFramework_Core->_renderWidgetsFor('forum_view', Array, Object(XenForo_Template_Public), '')
#10 /home/directory/public_html/library/WidgetFramework/Listener.php(126): WidgetFramework_Core->renderWidgetsFor('forum_view', Array, Object(XenForo_Template_Public), Array)
#11 [internal function]: WidgetFramework_Listener::template_post_render('forum_view', '???????????????...', Array, Object(XenForo_Template_Public))
#12 /home/directory/public_html/library/XenForo/CodeEvent.php(58): call_user_func_array(Array, Array)
#13 /home/directory/public_html/library/XenForo/Template/Abstract.php(195): XenForo_CodeEvent::fire('template_post_r...', Array, 'forum_view')
#14 /home/directory/public_html/library/XenForo/Template/Public.php(110): XenForo_Template_Abstract->render()
#15 /home/directory/public_html/library/XenForo/ViewRenderer/HtmlPublic.php(123): XenForo_Template_Public->render()
#16 /home/directory/public_html/library/XenForo/FrontController.php(637): XenForo_ViewRenderer_HtmlPublic->renderContainer(Object(XenForo_Template_Public), Array)
#17 /home/directory/public_html/library/XenForo/FrontController.php(158): XenForo_FrontController->renderView(Object(XenForo_ControllerResponse_View), Object(XenForo_ViewRenderer_HtmlPublic), Array)
#18 /home/directory/public_html/index.php(13): XenForo_FrontController->run()
#19 {main}

Request State

array(3) {
  ["url"] => string(44) "http://my_web/forums/my_forum.6/"
  ["_GET"] => array(0) {
  }
  ["_POST"] => array(0) {
  }
}

The error occurs with:
Renderer -- > Threads --> Widget Type --> New Thread
Renderer -- > Threads --> Widget Type --> Recent Threads
Renderer -- > Threads --> Widget Type --> Latest Replies

With the rest of Widget Type within the Renderer Threads I have not had errors.

Regrds, luis.

 

[Xon]

@Luis this would be a compatibility error where something else is including the 'user' table when it isn't expected. I'll set aside some time tomorrow to have a look.

Which version of Widget framework are you using?

 

[Luis]

Which version of Widget framework are you using?

Latest version --> 2.5.9

 

[Xon]

Xon updated View Staff Threads with a new update entry:

Compatibility update

• Improve compatibility with Widget framework

Read the rest of this update entry...

 

[Luis]

Many thanks for the update Xon, now work correctly.

 

[BobbyWibowo]

Hi Xon, does the 'Staff' flag mean that the user has the 'Display user as Staff' thing enabled?

 

[Xon]

Hi Xon, does the 'Staff' flag mean that the user has the 'Display user as Staff' thing enabled?

Yes.

 

[BobbyWibowo]

Alright, thanks!

 

[Blast]

Does anyone have a screenshot?

 

[Xon]

Xon updated View Staff Threads with a new update entry:

Compatibility update (minor)

• Improve compatibility with a private add-on.

This isn't required unless you have an add-on seeking to alter what threads are allowed to be viewed from the forum list.

Read the rest of this update entry...

 

[Deleted member 56699]

One of the few favorite add-ons I like, also awesome update as well.

 

[Tealk]

Hi,
if i disable "View threads by others" the last post section say (Private) and not the stiky post

 

[Xon]

Hi,
if i disable "View threads by others" the last post section say (Private) and not the stiky post

Yes, this is expected. As the last post section is global and not per user.

 

[Tealk]

@Xon is it possible to change this? I know my Users will confuse this-.-

 

[Xon]

@Tealk it is unlikely I would be able to implement such a major revision any time soon.

 

[Tealk]

@Xon ok thanks for the information

 

[BobbyWibowo]

@Xon Hey, for some reason registered users can see soft-deleted sticky threads by staff if I enabled "view threads by staff" and "view sticky threads" permissions for the registered usergroup (they can also press the small "View" button to view the thread). Seem to work fine for guests despite of the fact that both usergroups have the same exact node permission for the said note. I have rechecked registered usergroup permissions and I confirmed that they didn't have a single permission to view deleted threads enabled.

 

[Xon]

@BobbyWibowo I'ld say this is a flaw in how I'm doing the view stick threads/view threads by staff. I'll poke at this tonight, as it should be a straight forward fix.