vb.org Archive
Page 3 of 8 12 3 45 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Show Thread Enhancements - Latest x Threads by User (https://vborg.vbsupport.ru/showthread.php?t=211394)

cykelmyggen 04-17-2009 06:10 PM
Quote:
Originally Posted by Honk0815 (Post 1793266)
nice addon...

And i Found 1 Bug...

If I wanna open / view a thread which was created by a person who is deleted, the server reads an SQL ERROR.

Code:
Datenbankfehler in vBulletin 3.8.2:

Invalid SQL:

                        SELECT
                                thread.threadid, thread.title, thread.lastpost, thread.forumid,
                                thread.replycount, thread.lastposter, thread.dateline, thread.prefixid,
                IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
                                thread.visible, user.username, user.userid, user.usergroupid,
                                IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
                                forum.title_clean as forum_title, post.pagetext AS preview, post.allowsmilie, post.postid
                                FROM thread AS thread
                                LEFT JOIN user AS user ON (user.username = thread.lastposter)
                                LEFT JOIN forum as forum ON (thread.forumid = forum.forumid)
                                LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
                                WHERE thread.visible = '1' AND post.visible = '1' AND thread.open!='10'
                                AND thread.postuserid IN ()
                                AND thread.forumid NOT IN (0)
                                ORDER BY thread.dateline DESC
                                LIMIT 5;

MySQL-Fehler  : 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 ')
                                AND thread.forumid NOT IN (0)
                                ORDER BY thread.dateline DESC
                                L' at line 13
Can you Please fix this?
I'm getting this one too. Hopefully this issue will be fixed on this great plugin:up:

ry215 04-17-2009 06:16 PM
Quote:
Originally Posted by cykelmyggen (Post 1793454)
I'm getting this one too. Hopefully this issue will be fixed on this great plugin:up:
cykelmyggen

Join Date: Oct 2006
Location: Europe
Version: 3.8.002
Installed: Apr 2009
Posts: 69
Design: Green Hornet,Fixed


Quote:
-v3.8.003: Fixed DB Error when view a thread created by a deleted user

cykelmyggen 04-17-2009 07:07 PM
Thanks for the fast DB error fix:up:

H3C x Nevz 04-17-2009 07:38 PM
Great mod - installed. I have a couple questions, though. In the profile, how would you:
- Change the title of the tab from "Latest Threads" to something else?
- Move it to, say, the second tab?
- Search in only certain forums, for example, forumid #26?
Thanks.

NAZIA 04-18-2009 11:29 AM
Thanks for sharing great hack...

Hasann 04-18-2009 12:40 PM
nice mod thought but there is something wrong if you go and check to another members profile you can see your own latest threads at another member profiles :)

ry215 04-18-2009 01:33 PM
Quote:
Originally Posted by Hasann (Post 1793881)
nice mod thought but there is something wrong if you go and check to another members profile you can see your own latest threads at another member profiles :)
Thanks Hasann!

Fixed :D

Honk0815 04-18-2009 03:41 PM
1 Attachment(s)
Can you deactivatet this on PM system?

Once I get a PM by a member, I read this panel.

The name also be lacking in this field ..

I have a screen ...

josef1 04-19-2009 06:54 AM
thanks,
installed and works fine after upgrading to latest version

but where we can control the location of the latest threads ?? as it shows table after thread starter only while i want to move it to the end of thread page

sensimilla 04-19-2009 12:10 PM
Great idea,thanks.


All times are GMT. The time now is 01:19 PM.
Page 3 of 8 12 3 45 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01031 seconds
  • Memory Usage 1,743KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete