Admin Functions

String -> MD5 Encrypted String function added. To upgrade just reupload convert.php to your admin directory.

----------------------------------------------------------------

2 bugs fixed. To upgrade just reupload the files.

----------------------------------------------------------------

This is a series of four adminstration scripts covering two functions. They are:
Attachment Management
--Find and view attachments with ease, remove with two clicks
--Remove multiple attachments by forum, extension, and other options
Conversion/Encryption Functions
--Converts to and from Unix Timestamp format, which is used by vBulletin in the database
--Encrypt a text string with md5 - useful for comparing a string to an encrypted password in the database

Screenshots

For version: 2.0.3 and above

Files needed: rematt.php, browseatt.php, convert.php, viewatt.php

Files to edit: admin/index.php

Instructions are in the zip file - look for att.txt

DO NOT PM or email me about this hack - it will be ignored!

I will not support you if you edit these files.

You may not redistribute these scripts, edited or unedited, without my prior permission.

Disclaimer: I disclaim all responsibility for your use of this hack. It has been extensively tested but still may screw something up. It is recommended that if you are going to be deleting a lot of attachments you have a recent database backup on hand.

[Silver_2000_)!]

The hack works great trimmed about 1/3 of the attachments BUT the Attachement Table in mysql hasnt shrunk..

I have updated the counters and have tried the repair.php script just for good measure... What am I missing ???

Is there a query required to compact the table or database ?

Thanks in advance...

Doug

[johnr]

Err...Because this hack is like 8 months old and since then 5+ new Vbulletin versions have been released?

Go figure

[Silver_2000_)!]

[QUOTE]Originally posted by johnr
Err...Because this hack is like 8 months old and since then 5+ new Vbulletin versions have been released?

Go figure

[Symbian.info]

Grreat tool !!

[Silver_2000_)!]

The table shrunk ... Great Mod

Doug

[Bison]

Anyone with a ton of attachments really need this gem ofva hack!

(Ten Stars!) :speechless:

[iggy123]

when i try this on 2.3.0 I get the following error

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: SELECT postid,post.attachmentid AS aid,FROM_UNIXTIME(attachment.dateline)
 AS date,filename,attachment.userid AS id,attachment.counter AS countera FROM post,attachment 
WHERE post.attachmentid=attachment.attachmentid  AND
 attachment.userid='1' LIMIT 0,20 mysql error: Column: 'postid' in field list is ambiguous

mysql error number: 1052

Date: Saturday 17th of May 2003 10:44:56 AM

[Milez]

Anyone know a better way to remove all attachments from specified forums, as this hack seems to no longer function on 2.3.0.

[camikazi2k]

everytime i hit remove
i get
Your session hash doesn't match the one in the database. Try logging in again.