Miscellaneous Hacks - 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.

[ageurtse]

reserved by author

[Forum Lover]

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

[ageurtse]

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.

[hakan68]

Thanks installed

[mandingo]

Some problems:



Then I clicked it and got an error.

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

[ageurtse]

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

[mandingo]

tried update,still error and language still Dutch

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

[ageurtse]

sorry, i did uploadt the wrong file

[mandingo]

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.