vb.org Archive - Miscellaneous Hacks - show all attachments from selected user

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Miscellaneous Hacks - show all attachments from selected user (https://vborg.vbsupport.ru/showthread.php?t=233261)

show all attachments from selected user

This mod shows all attachments submited by the selected user.

history
- v1.20 some fixes for vb 4.0.2, and tab position selection
- v1.10 Some small leftovers changed
- v1.10 RC2 added usergroup permision
- v1.10 RC1 added lightbox

Todo in next version
- information displaying when hovering over picture
- information displaying when showen in lightbox

Wish list
[S]- add permisions <- not realy a need for me (maybe a will add this later)
[/S]- add selection box for admins to delete a attachment <- this can be done in backend.

installation,

see readme file inside the zip file.

Will it be possible to put a select option so that admins can delete those if they want to? Tagged.

that is not planned, now at this moment i'm working on the upgrade of our board.
if that is done and it run's smooth'i will whatch into it.

Some problems:

http://internetdomainnamedotcom.com/...s/46bekijk.jpg

Then I clicked it and got an error.

HTML Code:

Database error in vBulletin 4.0.1:



Invalid SQL:



                        SELECT attachment.attachmentid, attachment.contentid, attachment.userid, post.postid, post.threadid, post.visible,thread.forumid,

                        thread.title, thread.open

                        FROM vb3_attachment as attachment 

                        LEFT JOIN vb3_post AS post ON (post.postid = attachment.contentid)

                        LEFT JOIN vb3_thread as thread on(post.threadid = thread.threadid)

                        LEFT JOIN vb3_deletionlog AS deletionlog ON(attachment.contentid = deletionlog.primaryid AND type = 'post')

                        WHERE attachment.userid = 1

                        AND (

                        thread.forumid IN(0,47,26,43,17,22,45,23,1,28,31,36,35,2,37,25,4,8,13,15,20,27,39,5,33,11,24,3,6,14,29,12,34,7,18)

                        AND thread.visible = 1 

                        AND post.visible = 1 

                        AND deletionlog.primaryid IS NULL);



MySQL Error   : Table 'xxxxxxx.vb3_attachment' doesn't exist

Error Number  : 1146

Request Date  : Saturday, January 16th 2010 @ 10:52:16 AM

Error Date    : Saturday, January 16th 2010 @ 10:52:16 AM

Script        : http://xxxxxxxxxxxxxxxxxx?1=&tab=AJGattach

Referrer      : http://xxxxxxxxxxxxxxxxxxxxxxxxxx

IP Address    : xxx.xxxx.xxxx

Username      : Mitch

Classname     : vB_Database

MySQL Version : 5.1.30

i found what is wrong, i'm going to work on a fix.

for now you can alter in the plugin AJGattach member profile tab the prefix before the table names.
this is in my case vb3_ you can alter this by hand as a work a round.

when i finished it i will reupload the new file.

above problem is solved

:( tried update,still error and language still Dutch

HTML Code:

Database error in vBulletin 4.0.1:



Invalid SQL:



                        SELECT attachment.attachmentid, attachment.contentid, attachment.userid, post.postid, post.threadid, post.visible,thread.forumid,

                        thread.title, thread.open

                        FROM vb3_attachment as attachment 

                        LEFT JOIN vb3_post AS post ON (post.postid = attachment.contentid)

                        LEFT JOIN vb3_thread as thread on(post.threadid = thread.threadid)

                        LEFT JOIN vb3_deletionlog AS deletionlog ON(attachment.contentid = deletionlog.primaryid AND type = 'post')

                        WHERE attachment.userid = 125

                        AND (

                        thread.forumid IN(0,47,26,43,17,22,45,23,1,28,31,36,35,2,37,25,4,8,13,15,20,27,39,5,33,11,24,3,6,14,29,12,34,7,18)

                        AND thread.visible = 1 

                        AND post.visible = 1 

                        AND deletionlog.primaryid IS NULL);



MySQL Error   : Table 'xxxxxxxxxxx.vb3_attachment' doesn't exist

Error Number  : 1146

Request Date  : Saturday, January 16th 2010 @ 12:01:03 PM

Error Date    : Saturday, January 16th 2010 @ 12:01:03 PM

Script        : http://xxxxxxxxxxxxxxxxxxxxxxxxxx?125=&tab=AJGattach

Referrer      : http://xxxxxxxxxxxxxxxxxxx/3835-Best-of-Pride-Episode-1-List-of-Fights-Shown

IP Address    : xx.xxxx.xxxx.xxx.x.x.x.x

Username      : Mitch

Classname     : vB_Database

MySQL Version : 5.1.30

sorry, i did uploadt the wrong file

Hi,it's me again.
It works!!

but:
click for screenshot

Not sure if this is a me thing or a you thing.
Sorry if i'm being a pain. :(

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_html_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01162 seconds Memory Usage 1,739KB 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 (2)bbcode_html_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)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
Messages: