Whodownloaded_IP with Dates

Welcome to Mr Blunt's "Whodownloaded_IP" Series for vBulletin 3.5.2


This is FREE CODE AND CAN BE used, abused, and released as desired!!
I only ask it REMAIN FREE - unless maybe you compensate me as well??
If any code looks familiar, I'm sorry and ASSURE YOU it's coincidence!!

Paypal Donations are graciously accepted if you like this script.
I'm just a broke amateur who enjoys writing free stuff (for now).
Donations goto my - Help Rebuild My PC Fund.
But the script is free if your broke too ... So enjoy it either way!!


mr_blunt@sbcglobal.net

Please email me for comments, questions, or anything else on your mind.
Put the exact word "Whodownloaded" in subject to get by my spam filters!
My nick "Mr Blunt" is also at www.vbulletin.org & www.vbulletin.com
Support thread: https://vborg.vbsupport.ru/showthread.php?t=93167


IMPORTANT KEY NOTES:
This script REQUIRES vBulletin 3.5.0 or above and was tested with vb 3.5.2
Failure to upload all files to server WILL PRODUCE DATABASE ERRORS.
Install "Product" file as a "PRODUCT" ... not as a "PLUGIN" or "STYLE".


Features of Whodownloaded_IP:

1. Log fileid & userid for EVERY download.
2. Optionally log date, username, filename for easy tracing after deletions.
3. Optionally log IP's and ALT_IP's (ALT_IP could be the IP behind a proxy).
4. File deletions won't delete OUR info, so admins can still backtrack.
5. Customizable width of popup so admins & members get different sizes.
6. Customizable viewing permissions for the popup.
7. Customizable phrases for non english forums.
8. The button to open popup is easy to add to templates.
9. Click any name in the popup to view user's profile.
10. Click file date in the popup to view the post where the file is located.
11. Hover the paperclip by dates to get downloads id# for easy referencing.
12. Template edits are "additions", not "modifications", so no conflictions.
13. Powered by one 3rd party database table, a few vBulletin addon fields.
14. Admins can now search database by any criteria (partial terms are OK).

Whodownloaded (PRE-IP-v100) Uninstallation Procedures
JUST IN CASE YOU HAVE ANY OF MY OLD vb3.0.x VERSIONS:
Uninstall any "NON-IP" version before installing this.
vBulletin PHP FILE: attachment.php -- (307 versions edited this)
3rd Party PHP FILE: whodownloaded.php
vBulletin TEMPLATE: postbit_attachment
vBulletin TEMPLATE: headinclude
3rd Party TEMPLATE: whodownloads
3rd Party TEMPLATE: whodownloadsbit
3rd Party TEMPLATE: whodownloads_error
3rd Party TEMPLATE: whodownloads_error_nop
vBulletin DATABASE TABLE: user
3rd Party DATABASE FIELD: user.downloads

1. Revert my old code out of "postbit_attachment" template.
2. Revert my old code out of "headinclude" template (if still there).
3. Revert all other templates listed (that deletes them).
4. Delete the whodownloaded.php file.
5. vB350 gave a new attachment.php so forget about that old file, forever.
6. DO NOT DELETE OLD "downloads" FIELD UNTIL WE TRANSFER DATA TO NEW TABLE!
7. DO NOT DELETE OLD "downloads" FIELD UNLESS NO OTHER HACKS ARE USING IT!!
8. NEVER DELETE VBULLETIN'S "USER" TABLE ... NEVER EVER!!!!!!!!

Whodownloaded_IP Installation/Upgrade Procedures:

1. For non-English forums - EDIT product phrases in the Product XML.
2. UPLOAD & Overwrite all files from the UPLOAD folder to your server.
3. IMPORT 'product_blunts_whodl_ip.xml' and select "Allow Overwrite".
4. MERGE 'style_blunts_whodl_ip.xml' over your styles (ignore version).
5. SET controls in AdminCP 'Usergroup Permissions'.
6. SET controls in AdminCP 'vBulletin Options'.
7. DONE ... Hope You Enjoy It!!!

NOTE: If you have other hacks that edit a same STYLE TEMPLATE, then SKIP STEP #4 AND manually edit templates as listed further down.

Test it and come back to the file's vbulletin.org forum support thread and CLICK INSTALL so I can alert you when this hack gets important updates. NO, I DO NOT SPAM!!! Alerts will only be sent AFTER major changes!!


Whodownloaded_IP Uninstallation Procedures:

1. Revert (or remove code from) any templates which you added button to.
2. Delete file 'includes/xml/bitfield_blunts_whodl_ip.xml' from server.
3. Delete file 'includes/xml/cpnav_blunts_whodl_ip.xml' from server.
4. Delete PRODUCT 'Whodownloaded_IP' from AdminCP Products.
5. Read Screen & Click button if you want to delete data table (optional).
6. Delete file 'blunts_whodownloaded_ip.php' from server.
7. Delete file 'admincp/bitfield_blunts_whodl_ip.xml' from server.
8. Delete file '/images/attach/blunts_whodl_vertical.bmp' from server.
9. Done ... Thank You For Checking It Out!!!

Do NOT uninstall prior versions before v120 is installed.
And the order of steps is important, so please be careful.


Whodownloaded_IP Files To Upload:

1. /blunts_whodownloaded_ip.php
2. /admincp/admin_blunts_whodl_ip.php
3. /images/attach/blunts_whodl_vertical.bmp
4. /includes/xml/bitfield_blunts_whodl_ip.xml
5. /includes/xml/cpnav_blunts_whodl_ip.xml

Whodownloaded_IP Product File Contents:
File Name: product_blunts_whodl_ip.xml
Product ID: blunts_whodl_ip
Title: Whodownloaded_IP
Version: 1.2.0

3rd Party PLUGIN: Whodownloaded IP - Enable Bitfields
3rd Party PLUGIN: Whodownloaded IP - Enable Viewing
3rd Party PLUGIN: Whodownloaded IP - Enable Logging
3rd Party MASTER PHRASES: 65 Phrases with 'blunts_whodl_' prefix
3rd Party MASTER TEMPLATE: blunts_whodownloaded_ip_main
3rd Party MASTER TEMPLATE: blunts_whodownloaded_ip_namebit
3rd Party MASTER TEMPLATE: blunts_whodownloaded_ip_datebit
3rd Party DATABASE TABLE: blunts_whodownloaded_ip
3rd Party DATABASE FIELD: blunts_whodownloaded_ip.whodownloaded_ipid
3rd Party DATABASE FIELD: blunts_whodownloaded_ip.userid
3rd Party DATABASE FIELD: blunts_whodownloaded_ip.username
3rd Party DATABASE FIELD: blunts_whodownloaded_ip.filename
3rd Party DATABASE FIELD: blunts_whodownloaded_ip.fileid
3rd Party DATABASE FIELD: blunts_whodownloaded_ip.ipaddress
3rd Party DATABASE FIELD: blunts_whodownloaded_ip.alt_ip
3rd Party DATABASE FIELD: blunts_whodownloaded_ip.dateline
3rd Party DATABASE FIELD: usergroup.bluntswhodlpermissions
3rd Party DATABASE FIELD: settinggroup.blunts_whodl
3rd Party DATABASE FIELD: settings.blunts_whodl_popisactive
3rd Party DATABASE FIELD: settings.blunts_whodl_poplarge
3rd Party DATABASE FIELD: settings.blunts_whodl_popsmall
3rd Party DATABASE FIELD: settings.blunts_whodl_logwhat


Whodownloaded_IP Style File Contents:
File Name: style_blunts_whodl_ip.xml
OVERWRITES these 4 standard vBulletin templates:

vBulletin Template: modifyattachmentsbit (November 1st, 2005)
vBulletin Template: postbit_attachment (Aug 20th, 2005)
vBulletin Template: postbit_attachmentmoderated (Aug 20th, 2005)
vBulletin Template: postbit_attachmentthumbnail (Aug 20th, 2005)

Use these manual template edit instructions if you use other hacks!!

Template: modifyattachmentsbit
FIND THIS:

<div class="smallfont">$post[postdate] <if condition="!$show['detailedtime']"><span class="time">$post[posttime]</span></if></div>

ADD THIS BELOW IT:

<if condition="$show['blunts_whodl_width']"><div class="smallfont"><input type="button" class="button" value="$vbphrase[blunts_whodl_who_downloaded]" tabindex="1" onclick="window.open('blunts_whodownloaded_ip.php?$session[sessionurl]fid=$post[attachmentid]','blunts_whodownloaded_ip','toolbar=no, scrollbars=yes, resizable=yes, width=$show[blunts_whodl_width], height=450, top=50, left=50'); return false;" title="$vbphrase[blunts_whodl_who_downloaded]: $post[attachmentid]" /></div></if>

Template: postbit_attachment
Template: postbit_attachmentmoderated
FIND THE LAST:

</tr>

ADD THIS BEFORE IT:

<td><if condition="$show['blunts_whodl_width']"><input type="button" class="button" value="$vbphrase[blunts_whodl_who_downloaded]" tabindex="1" onclick="window.open('blunts_whodownloaded_ip.php?$session[sessionurl]fid=$attachment[attachmentid]','blunts_whodownloaded_ip','toolbar=no, scrollbars=yes, resizable=yes, width=$show[blunts_whodl_width], height=450, top=50, left=50'); return false;" title="$vbphrase[blunts_whodl_who_downloaded]: $attachment[attachmentid]" /></if></td>

Template: postbit_attachmentthumbnail
FIND THE LAST:

&nbsp;<if condition="$show['br']"><br /><br /></if>

ADD THIS BEFORE IT:

<if condition="$show['blunts_whodl_width']">
	<if condition="is_browser('ie', '5.5')">
		<input type="button" class="button" value="$vbphrase[blunts_whodl_who_downloaded]" tabindex="1" onclick="window.open('blunts_whodownloaded_ip.php?$session[sessionurl]fid=$attachment[attachmentid]','blunts_whodownloaded_ip','toolbar=no, scrollbars=yes, resizable=yes, width=$show[blunts_whodl_width], height=450, top=50, left=50'); return false;" title="$vbphrase[blunts_whodl_who_downloaded]: $attachment[attachmentid]" style="writing-mode:tb-rl" />
	<else />
		<a href="blunts_whodownloaded_ip.php?$session[sessionurl]fid=$attachment[attachmentid]"<if condition="$show['newwindow']"> target="_blank"</if>><img class="button" src="$stylevar[imgdir_attach]/blunts_whodl_vertical.bmp" alt="$vbphrase[blunts_whodl_who_downloaded]" border="1" title="$vbphrase[blunts_whodl_who_downloaded]: $attachment[attachmentid]" /></a>
	</if>
</if>

Version History:

v-1.0.0 - July 29th, 2005:

1. Initial vb350 release which adds ip & date logging to old vb3 hack.

v-1.0.5 - August 9th, 2005:

1. Prevent logging of non-thumbnail image views (images loaded by showthread).
2. Use escape_string to clean dB insertion variables during dB writes.
3. Moved names above users date/IP list.
4. Added paperclip hover target to show id# of the logged download.
5. Added phrase 'blunts_whodl_download_id' for use in hover paperclip.
6. Added vertical button BMP FILE for non-IE users (next to thumbs).
7. Added vertical button WITH CODE for IE users (next to thumbs).
8. Tweaked the popup's gui layout to give some nice borders.
9. Cut the dB reading down to 2 queries.
10. Began building up the 2 queries & other things for future search features.
11. Set the php environment & pre-cache templates.
12. URL input (was attachment=X) is now fid=X (fid is attachmentid or fileid).

v-1.0.7 - August 20th, 2005:

1. Added the time of download to any dates shown.
2. Added 'bitfield_blunts_whodl_ip.xml' (upload to 'INCLUDES/XML' folder).
3. Added 'bluntswhodlpermissions' field to vB's 'usergroup' table.
4. Added 5 Custom Usergroup Permissions to AdminCP (and phrases for them).
5. Added 10 Custom vBulletin Options to AdminCP (and phrases for them).
6. Added comments to the installation process to be echoed back to user.
7. Added code to seek/transfer data from old whodownloaded hacks to new table.
8. Repaired the integer fields in our dB table to be INT(10) and UNSIGNED.
9. Modified the internal product templates again (they install themselves).
10. Modified STYLE file again (you can keep using v105's if you want to).
11. Changed all but one global phrase to be in my own 'phrase group'.
12. Shuffled some things around in the PHP script.
13. Renamed style and product files to conform with the other underscores.

v-1.1.0 - November 1st, 2005:

1. Tweaked all of the "product codes" for (hopefully) the final time.
2. Added a new AdminCP Nav Group (left column) with hotlinks to key features.
3. Added a search engine for admins who have permission to control plugins.
4. Added ability for admins to manually edit/delete entries from database.
5. Importing & Deletion of old 3.0.x data can optionally be done at any time.
6. Deletion of main database table is now optional during uninstallation.
7. Found another template that can use a button (modifyattachmentsbit).

v-1.2.0 - December 12th, 2005:

1. MANDATORY FIX to correct issues which made 1.1.0 incompatible with vb351+ .... I strongly recommend updating this product before upgrading to vb351 or vb352, if you haven't yet.
2. Moved a lot of the install code from the product file to the admin file.
3. Condensed the rest of the install/uninstall code.
4. Changed the format of all files from Windows to UNIX.
5. Updated all the screenshots (zip file has 11 pics so are not shown).
6. Removed the Beta Tag from the product.

To Do and/or Wish List:

1. I'm still looking for someone to help me add better language support.

Known Bug List:

1. Installation messages are english only since code installs before phrases.
2. Non-IE5.5 shows horizontal href text next to thumbs IF THE BMP isn't found ... which looks REALLY dumb ... so make sure you upload the BMP to the proper folder on your server!!

Credits:

1. Mostly Jelsoft for their dedication and "easy to read & modify" code!!
2. vbulletin.com, vbulletin.org, & php.com for their excellent resources!!
3. The MEMBERS and MODS who MAKE these forums great resources!!
4. Special SHOUT to MarcoH64 and Andreas for help when I needed it.
5. AND OF COURSE TWTCommish for his original v2 whodownloaded hack!!

mr_blunt@sbcglobal.net

[eNforce]

Installation went well, permissions set, plugin enabled in the main. But nothing is showing up on the attachments

I'm running vB 3.5.2 , it it not compatible?

Edit: Apparently the image I was using was too small in resolution or something.. . that's why I saw nothing, it works now with large images and zip etc :tired:

[Mr Blunt]

Originally Posted by eNforce

Installation went well, permissions set, plugin enabled in the main. But nothing is showing up on the attachments

I'm running vB 3.5.2 , it it not compatible?

1) I'll have to download 3.5.2 and play I guess. I didn't know it was out. Thanks for the head's up. You might have to give me a few days if there is a true compatability problem.

2) Upon installation, you won't have any data in the table, so login to your forum and download one from any thread. Afterwards, come back to the admincp and see if the download appears in the quick search. If you have some crons setup do only update things like once an hour .... then of course you'll have to wait for that period of time.

3) If you had a previous 3.0.x version, and your expecting to see the old data immediately, that's not how my v1.1.0 is setup. I made importing an "option" which you will be able to use after you gain access to the search engine (by downloading one file to start things).

If #2 & #3 don't solve the mystery, then it's probably #1.

[eNforce]

Ahh, please read the edit of my previous post, now I feel bad for having you type all that up...

It's up and running fine

During installation it told me I had previously installed it on 3.0.x, I don't even remember that far back! :speechless:

[Mr Blunt]

Don't worry about my typing bro.
I talk a lot.
Glad it's all good.

Feedback would be helpful.
I always like to hear ideas, good and bad.
And I like to fix things.

[mhammed]

Originally Posted by Mr Blunt

It's failing on line 17 of install code 1.0.6
This is where it adds values to each of the new usergroup permission's fields.

Only thing that I can think of is that maybe you don't have permission to "alter database tables" in SQL, meaning the column isn't getting created. You should be able to check this if you can log into phpmyadmin.

If your not the main administrator who installed the forum, please ask him to verify that you have permission to alter tables AND please ask him to try installing the product for you.

If you are the only administrator, and you can't solve this, then PM me with login details for your Forum's AdminCP and your Server's Control Panel (like phpmyadmin).


If you figure out what the problem was, please reply so I'll know the source of that problem in the future.

I am sole owner. I have all the permissions.
I can execute requests SQL from my admincp

in my config.php
$config['SpecialUsers']['canrunqueries'] = '1';

it's me

ok

other thing to make for this permission?

[warrenrees]

There definately appears to be compatibility issues with 3.5.2. Here's what I get when someone downloads the file:

Database error in vBulletin 3.5.2:

Invalid SQL:
INSERT INTO blunts_whodownloaded_ip (userid, username, filename, fileid, ipaddress, alt_ip, dateline)
		VALUES (1427,
			'',
			'',
			2661,
			'',
			'',
			1134139939);

MySQL Error  : 
Error Number : 
Date         : Friday, December 9th 2005 @ 09:52:19 AM
Script       : http://myforum/forum/attachment.php?attachmentid=2661&d=1133518215
Referrer     : http://myforum/forum/showthread.php?t=6349
IP Address   : x.x.x.x
Username     : blabla
Classname    : vb_database

and here's what's attached to files when I download them:

<br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_query(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>395</strong><br /><br /><strong>Warning</strong>: mysql_error(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>837</strong><br /><br /><strong>Warning</strong>: mysql_errno(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>855</strong><br /><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

and then the whole "Database error" stuff. It gets attached to the file.

[bashy]

I have vb 3.5.2 also and i get the exact error!!
Its not showing who has downloaded what either, when i click Who Downloaded, it says 2 downloads of File but no names or IP's also it is not logging downloads at all, and the Quick Search Engine is not finding anything....

Bashy

Originally Posted by warrenrees

There definately appears to be compatibility issues with 3.5.2. Here's what I get when someone downloads the file:

Database error in vBulletin 3.5.2:

Invalid SQL:
INSERT INTO blunts_whodownloaded_ip (userid, username, filename, fileid, ipaddress, alt_ip, dateline)
		VALUES (1427,
			'',
			'',
			2661,
			'',
			'',
			1134139939);

MySQL Error  : 
Error Number : 
Date         : Friday, December 9th 2005 @ 09:52:19 AM
Script       : http://myforum/forum/attachment.php?attachmentid=2661&d=1133518215
Referrer     : http://myforum/forum/showthread.php?t=6349
IP Address   : x.x.x.x
Username     : blabla
Classname    : vb_database

and here's what's attached to files when I download them:

<br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>657</strong><br /><br /><strong>Warning</strong>: mysql_query(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>395</strong><br /><br /><strong>Warning</strong>: mysql_error(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>837</strong><br /><br /><strong>Warning</strong>: mysql_errno(): 7 is not a valid MySQL-Link resource in <strong>/includes/class_core.php</strong> on line <strong>855</strong><br /><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

and then the whole "Database error" stuff. It gets attached to the file.

[belinea]

I also have upgarded to vB3.5.2. I get the same error.

so, I have de-installed the Whodownloaded Plugin and tried to reinstall it. But i get th following error message:

Warning: Invalid argument supplied for foreach() in /admincpanel/plugin.php(1239) : eval()'d code on line 17

The current version of WhoeDownloaded doesn?t support vBulletin3.5.2

Mr.Blunts: Can you have a look at it and release a new version of "WhoDownloaded" ??? Many, many, many thanks.

[Mr Blunt]

I get the error too.
I'll probably have it fixed by morning.

PLEASE DO NOT UNINSTALL!!!
PLEASE DO NOT UNINSTALL!!!
PLEASE DO NOT UNINSTALL!!!
PLEASE DO NOT UNINSTALL!!!

JUST "DISABLE" THE PRODUCT!!!
You do NOT have to worry about anything if you do this.

[warrenrees]

Thanks Mr. Blunt