Whodownloaded_IP with Dates [Archive]

View Full Version : Whodownloaded_IP with Dates

Mr Blunt

07-28-2005, 10:00 PM

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!!

https://vborg.vbsupport.ru/external/2010/02/12.gif (https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mr_blunt%40sbcglobal%2enet&item_name=Help%20Rebuild%20My%20PC%20Fund&no_shipping=1&cn=Comments%20Section&tax=0&currency_code=USD&charset=UTF%2d8&charset=UTF%2d8)
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 (http://www.vbulletin.org/) & www.vbulletin.com (http://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:

Log fileid & userid for EVERY download.
Optionally log date, username, filename for easy tracing after deletions.
Optionally log IP's and ALT_IP's (ALT_IP could be the IP behind a proxy).
File deletions won't delete OUR info, so admins can still backtrack.
Customizable width of popup so admins & members get different sizes.
Customizable viewing permissions for the popup.
Customizable phrases for non english forums.
The button to open popup is easy to add to templates.
Click any name in the popup to view user's profile.
Click file date in the popup to view the post where the file is located.
Hover the paperclip by dates to get downloads id# for easy referencing.
Template edits are "additions", not "modifications", so no conflictions.
Powered by one 3rd party database table, a few vBulletin addon fields.
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

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

For non-English forums - EDIT product phrases in the Product XML.
UPLOAD & Overwrite all files from the UPLOAD folder to your server.
IMPORT 'product_blunts_whodl_ip.xml' and select "Allow Overwrite".
MERGE 'style_blunts_whodl_ip.xml' over your styles (ignore version).
SET controls in AdminCP 'Usergroup Permissions'.
SET controls in AdminCP 'vBulletin Options'.
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:

Revert (or remove code from) any templates which you added button to.
Delete file 'includes/xml/bitfield_blunts_whodl_ip.xml' from server.
Delete file 'includes/xml/cpnav_blunts_whodl_ip.xml' from server.
Delete PRODUCT 'Whodownloaded_IP' from AdminCP Products.
Read Screen & Click button if you want to delete data table (optional).
Delete file 'blunts_whodownloaded_ip.php' from server.
Delete file 'admincp/bitfield_blunts_whodl_ip.xml' from server.
Delete file '/images/attach/blunts_whodl_vertical.bmp' from server.
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:

/blunts_whodownloaded_ip.php
/admincp/admin_blunts_whodl_ip.php
/images/attach/blunts_whodl_vertical.bmp
/includes/xml/bitfield_blunts_whodl_ip.xml
/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']">$post[posttime]</if></div>

ADD THIS BELOW IT:
<if condition="$show['blunts_whodl_width']"><div class="smallfont"><input type="button" class="button" value="$vbphrase" 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, 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:
 <if condition="$show['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>

[b]Version History:

v-1.0.0 - July 29th, 2005:

Initial vb350 release which adds ip & date logging to old vb3 hack.
v-1.0.5 - August 9th, 2005:
Prevent logging of non-thumbnail image views (images loaded by showthread).
Use escape_string to clean dB insertion variables during dB writes.
Moved names above users date/IP list.
Added paperclip hover target to show id# of the logged download.
Added phrase 'blunts_whodl_download_id' for use in hover paperclip.
Added vertical button BMP FILE for non-IE users (next to thumbs).
Added vertical button WITH CODE for IE users (next to thumbs).
Tweaked the popup's gui layout to give some nice borders.
Cut the dB reading down to 2 queries.
Began building up the 2 queries & other things for future search features.
Set the php environment & pre-cache templates.
URL input (was attachment=X) is now fid=X (fid is attachmentid or fileid).
v-1.0.7 - August 20th, 2005:
Added the time of download to any dates shown.
Added 'bitfield_blunts_whodl_ip.xml' (upload to 'INCLUDES/XML' folder).
Added 'bluntswhodlpermissions' field to vB's 'usergroup' table.
Added 5 Custom Usergroup Permissions to AdminCP (and phrases for them).
Added 10 Custom vBulletin Options to AdminCP (and phrases for them).
Added comments to the installation process to be echoed back to user.
Added code to seek/transfer data from old whodownloaded hacks to new table.
Repaired the integer fields in our dB table to be INT(10) and UNSIGNED.
Modified the internal product templates again (they install themselves).
Modified STYLE file again (you can keep using v105's if you want to).
Changed all but one global phrase to be in my own 'phrase group'.
Shuffled some things around in the PHP script.
Renamed style and product files to conform with the other underscores.
v-1.1.0 - November 1st, 2005:
Tweaked all of the "product codes" for (hopefully) the final time.
Added a new AdminCP Nav Group (left column) with hotlinks to key features.
Added a search engine for admins who have permission to control plugins.
Added ability for admins to manually edit/delete entries from database.
Importing & Deletion of old 3.0.x data can optionally be done at any time.
Deletion of main database table is now optional during uninstallation.
Found another template that can use a button (modifyattachmentsbit).
v-1.2.0 - December 12th, 2005:
[b]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.
Moved a lot of the install code from the product file to the admin file.
Condensed the rest of the install/uninstall code.
Changed the format of all files from Windows to UNIX.
Updated all the screenshots (zip file has 11 pics so are not shown).
Removed the Beta Tag from the product.
To Do and/or Wish List:
I'm still looking for someone to help me add better language support.
Known Bug List:
Installation messages are english only since code installs before phrases.
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:
Mostly Jelsoft for their dedication and "easy to read & modify" code!!
vbulletin.com, vbulletin.org, & php.com for their excellent resources!!
The MEMBERS and MODS who MAKE these forums great resources!!
Special SHOUT to MarcoH64 and Andreas for help when I needed it.
AND OF COURSE TWTCommish for his original v2 whodownloaded hack!!

https://vborg.vbsupport.ru/external/2010/02/12.gif (https://www.paypal.com/cgi-bin/webscr?cmd=_xclick&business=mr_blunt%40sbcglobal%2enet&item_name=Help%20Rebuild%20My%20PC%20Fund&no_shipping=1&cn=Comments%20Section&tax=0&currency_code=USD&charset=UTF%2d8&charset=UTF%2d8)
mr_blunt@sbcglobal.net

Boofo

07-29-2005, 10:15 PM

Any way to have the button only show for certain usergroups? Maybe a setting? ;)

Mr Blunt

07-29-2005, 10:28 PM

#5 in my to-do list ;)

In the meantime, the plugin is easy to edit.
Might LOOK tough, but it's not.
Edit the Product XML file before installation (or edit the plugin itself after, whichever).

Add something like this in the VIEWING plugin somewhere:
if ($vbulletin->userinfo['usergroupid'] == X OR $vbulletin->userinfo['usergroupid'] == Y)
{
$show['blunts_whodl_width'] = 500;
$show['blunts_whodl_names'] = true;
$show['blunts_whodl_dates'] = true;
$show['blunts_whodl_dates_to_just_poster'] = true;
$show['blunts_whodl_ips'] = true;
$show['blunts_whodl_altips'] = true;
}

Notice everything I just cut n pasted is the the same except for the IF statement itself.

Only thing you have to be careful about is nesting the IF'S.
With my one big nest, the first condition that succeeds will exit the "nest".

And you don't need to use my "one nest" either.
You can have a seperate conditional at the bottom!!

Example you could add a conditional at the end and if that condition is met it will override any previous condition which might/might not have been met.

If that didn't make sense, say so.
:D

laycomp

07-29-2005, 11:46 PM

Wow, great release!

By the look of the screens it looks like you've done a great job on the d/l stats, congratulations man! :D ...I think this calls for "beers on the house!"

Thanks MrBlunt, I look forward to installing this soon :D ...thanks again and I will report back.

Mr Blunt

07-30-2005, 12:30 AM

I'm too much of a perfectionist so I'm still not happy with my work yet.
:p
I really don't like having the usernames underneath the dates.
Just doesn't look right at all IMHO.
But that's just cosmetic stuff that hopefully I'll conquer soon.

Here's my dilema with that if anyone can help:

One username with his count next to it, but many dates so I can't eval the username beforehand because I don't know if his individual count is complete until I check next row's username.

I understand how to build seperate evals but I couldn't figure out how to join them correctly after that user is complete. If I could merge two different evals from within php, then I would create 3 eval vars ... one for name, one for dates, and the third merges the two together and unset the first two after it verifies this is the "next user" .... so that we can start processing on the next name from the long list.

belinea

07-30-2005, 11:49 AM

Great Job Mr. Blunt

Many thanks for this great hack.

belinea

07-30-2005, 04:13 PM

The downloads were correctly logged in vb3_blunts_whodownloaded_ip

But when I click on the "Who downloaded button" I get the following information:

Viewed By: 0 Memebers And 0 Guests
No Users Found

Mr Blunt

07-30-2005, 05:16 PM

Hmmm, I'm stumped.

The "no user found" means your getting to the point in the code where we query my DB table and no data was returned from the table for the attachmentid number which was input.

This means all your settings and permissions are in good shape or we wouldn't have gotten that far into the code.

1) I hope you aren't expecting to see data from downloads PRIOR TO latest installation of v100 (previous versions or not) because I haven't gotten that far yet (#1 & #2 in my to-do list)

2) You say "they were correctly logged" ... Are you saying you went into phpmyadmin and "browsed" through the table manually and verified that the correct attachmentid number (I call it FILEID) and such was written to AND IS currently sitting in my table for the file you downloaded?

3) I hate to quote things that were erased, but my email notification which had your original post mentioned a database error ... and since the error was quoted, it wasn't included in the email so I don't know what the specific error said. If you could repost that database error for me, maybe it will give me a clue as to why my query isn't returning a result (feel free to remove the IP's from the message as I don't need or want that info).

belinea

07-30-2005, 10:15 PM

Now all works fine. I have changed nothing. But it works now. :speechless:

laycomp

07-31-2005, 12:59 AM

Mr. Blunt, I am using vb2 which is already using Commish's Hack. Soon I will attempt to upgrade to vb3. What would be the best way to install your hack so that I can still keep OLD attachments under the watchful eye of your WhoDownloaded IP hack? I have a huge db, 2 gigs ...mmm.. any tips or suggestions?

Regards~

Mr Blunt

07-31-2005, 04:46 AM

belinea,

Happy to hear it's working!! Please speak up if you have any other troubles. Like the readme says, I've never written a bugless first release so that's why I list the file as a "beta" for now. The only way I'll know it's really ready is to hear it from you folks.

I wonder if your first trouble had to do with any caching or cron stuff?? For example I think vB has an option that will only update attachments and/or attachment views on a time schedule .... as opposed to "immediately". My forum is small so I use no-cache headers and and most of my options are set to immediately update .... so this could maybe explain why I haven't encountered an issue like yours yet.

laycomp,

I think the best way to import old data from My and/or Commish's old hack is to just let the data sit exactly where it is until I make a "product update" to import the data for you automatically.

Yes, this means the data won't be available for a "period of time" while I learn more about creating install/uninstall packages ... but I figure that's a small price to pay for safety. Eventually WE WILL get it imported. I'd rather see you go maybe a month without the data than to see it imported now and get messed up and/or unrecoverable.

If I had to take a guess how long??
I'd say chances are good I'll figure it out before vb350 goes gold.
But that is NOT a promise.
Safety comes first in my book.

belinea

07-31-2005, 07:25 AM

belinea,

I wonder if your first trouble had to do with any caching or cron stuff?? For example I think vB has an option that will only update attachments and/or attachment views on a time schedule .... as opposed to "immediately". My forum is small so I use no-cache headers and and most of my options are set to immediately update .... so this could maybe explain why I haven't encountered an issue like yours yet.
I am also using no-cache and immediately update counters. But am using eAccelerator. Of course this PHP caching tool was the problem.

Brinnie

07-31-2005, 09:04 AM

just a question, but what if you have it set to display thumbnails?

belinea

07-31-2005, 05:49 PM

just a question, but what if you have it set to display thumbnails?
You can put the Who-downloaded-Button wherever you want. Look in the Readme (Can the popup button be put in more places?)

Mr Blunt

07-31-2005, 06:49 PM

Well, I finally tried and it's tricky for the images.
The 4 different postbit_attachment.... templates all handle the tr/td's differently.

I didn't edit the 'postbit_attachmentthumbnail' template for you guys yet because I don't like the button being displayed 'next to' the image .... looks really stupid that way.

And just adding a carriage return won't cut it, because some folks use inline images.
Let me see if I can create a "vertical" button for next to images.
;)

Mr Blunt

08-01-2005, 05:55 PM

C.Birch

08-04-2005, 08:27 PM

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:

INSERT INTO blunts_whodownloaded_ip
(
userid,
username,
filename,
fileid,
ipaddress,
alt_ip,
dateline
)
VALUES
(
'212',
'Scott_lee's_Rock',
'chatroom.jpg',
'2617',
'80.41.214.230',
'80.41.214.230',
'1123136477'
);

MySQL Error : 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 's_Rock',
'chatroom.jpg',
'2617',
'80.41.214.230',
'
Error Number : 1064
Date : Thursday, August 4th 2005 @ 06:21:17 AM
Script : http://forums.lisascottlee.com//attachment.php?attachmentid=2617&thumb=1&d=1123102373
Referrer :
IP Address : 80.41.214.230
Username : Scott_lee's_Rock
Classname : vb_database

Mr Blunt

08-04-2005, 10:32 PM

vbulletin allows you to have a ' (single quote) in a username??
Your kidding me!!

Boofo

08-04-2005, 11:24 PM

There's something fishy going on with images, and I think it smells like a vbulletin issue. I can't reproduce a specific circumstance yet, but sometimes image views update and sometimes they don't. This goes for vbulletin's tables and/or my table. For example when you hover over a thumbnail, vbulletin shows image views (that's not me or my code which prints that), and I don't believe the displayed numbers are true.

But neither here nor there....
Here's all the templates edits I've come up with so far.

I found 4 POSTBIT templates that handle the attachments.
These edits work, but I'm still not happy so I'm not updating top post yet.

postbit_attachment: add this just before the final </tr>
<td><if condition="$show['blunts_whodl_width'] AND $show['popups']">
<input type="button" class="button" value="$vbphrase[blunts_whodl_who_downloaded]" onclick="window.open('blunts_whodownloaded_ip.php?$session[sessionurl]attachmentid=$attachment[attachmentid]','blunts_whodownloaded_ip','toolbar=no,scrollbars =yes,resizable=yes, width=$show[blunts_whodl_width],height=450,top=50,left=50'); return false;" /> 
</if></td>

postbit_attachmentmoderated: add this just before the final </tr>
<td><if condition="$show['modattachmentlink'] AND $show['blunts_whodl_width'] AND $show['popups']">
<input type="button" class="button" value="$vbphrase[blunts_whodl_who_downloaded]" onclick="window.open('blunts_whodownloaded_ip.php?$session[sessionurl]attachmentid=$attachment[attachmentid]','blunts_whodownloaded_ip','toolbar=no,scrollbars =yes,resizable=yes, width=$show[blunts_whodl_width],height=450,top=50,left=50'); return false;" /> 
</if></td>

postbit_attachmentimage: add this to the end
<if condition="$show['blunts_whodl_width'] AND $show['popups']">
<img class="button" src="$stylevar[imgdir_button]/blunts_whodl_vertical.bmp" alt="blunts_whodownloaded_ip.php?$session[sessionurl]attachmentid=$attachment[attachmentid]" onclick="window.open('blunts_whodownloaded_ip.php?$session[sessionurl]attachmentid=$attachment[attachmentid]','blunts_whodownloaded_ip','toolbar=no,scrollbars =yes,resizable=yes, width=$show[blunts_whodl_width],height=450,top=50,left=50'); return false;" /> 
</if>

postbit_attachmentthumbnail: FIND THIS
<if condition="$show['br']"> </if>

Just before that, add this:
<if condition="$show['blunts_whodl_width'] AND $show['popups']">
<img class="button" src="$stylevar[imgdir_button]/blunts_whodl_vertical.bmp" alt="blunts_whodownloaded_ip.php?$session[sessionurl]attachmentid=$attachment[attachmentid]" onclick="window.open('blunts_whodownloaded_ip.php?$session[sessionurl]attachmentid=$attachment[attachmentid]','blunts_whodownloaded_ip','toolbar=no,scrollbars =yes,resizable=yes, width=$show[blunts_whodl_width],height=450,top=50,left=50'); return false;" /> 
</if>

This blunts_whodl_vertical.bmp file (inside this zip file) is REQUIRED for the 2 'postbit_attachmentimage' & 'postbit_attachmentthumbnail' template edits!!!

The BMP must be put in your IMAGES/BUTTONS folder for this to work!!!
To use your own button (or change path), edit the SRC="" with your button file's name.

Any pics?

Mr Blunt

08-04-2005, 11:41 PM

Don't goto far!!
And don't bother with those extra template edits or that image as I'm changing that stuff a little.
I think I'm done testing this portion so I'll slap it together and post new version hoepfully tonight.

I'm going to stop tracking NON thumbnail images because it's useless. They load with the showthread page so the count is more like a "who viewed the thread" count which isn't the purpose of this.

However we can track thumbnails, so we shall.
AND I found a way to make a html vertical button (for IE only)!!
Gimme the rest of the night and I'll post v103.

I'd like to find out wassup with this single quotes in a name thing first.
That's pretty major if you ask me!!
If anyone's got a suggestion for that, feel free to speak up!!

laycomp

08-04-2005, 11:46 PM

belinea,

laycomp,

I think the best way to import old data from My and/or Commish's old hack is to just let the data sit exactly where it is until I make a "product update" to import the data for you automatically.

Yes, this means the data won't be available for a "period of time" while I learn more about creating install/uninstall packages ... but I figure that's a small price to pay for safety. Eventually WE WILL get it imported. I'd rather see you go maybe a month without the data than to see it imported now and get messed up and/or unrecoverable.

If I had to take a guess how long??
I'd say chances are good I'll figure it out before vb350 goes gold.
But that is NOT a promise.
Safety comes first in my book.

Mr Blunt, to be sure I understand this, are you suggesting that If I do a forum upgrade (vb2 to vb3) with existing Commish's hack, that I should NOT install your hack until you've made the "product update" data import hack? and so in the meantime, files will just reside without me being able to track downloads?

Mr Blunt

08-05-2005, 12:34 AM

Mr Blunt, to be sure I understand this, are you suggesting that If I do a forum upgrade (vb2 to vb3) with existing Commish's hack, that I should NOT install your hack until you've made the data import? and so in the meantime, files will just reside without me being able to track downloads?
Most hacks aren't transferrable between "major" vb revisions.
vb2 hacks won't work with vb3.
vb3 hacks won't work with vb350.
Whodownloaded_IP is strictly a vb350 hack.

So if you have Commish's old vb2 hack installed, you'd have to get rid of any edits before the upgrade to EITHER vb3 or vb350 ... meaning clean vb files and reverting your old templates.

If you move into vb3.0.8 then you'll have to settle for my super old vb3 hack.

If you move into vb3.5.0 then you have the option of using either of my vb350 whodownloaded hacks (with IP or without), but note that if you choose the OTHER non IP version, then you still aren't saving dates which is "somewhat dumb" if you plan to use this IP version in the future.

Now note:
Files and templates are not "database data".

The "data" that was saved with each download won't get touched while you do the vb upgrade and will remain stored in the database. The only thing that changes when you upgrade vB is it will stop logging downloads from that day forward (until you install a hack for that version) and there won't be a way to view the saved data since your templates and files won't have the "hack" to process the data.

So summary....
New IP hack can be installed on vb350 at any time no matter if you've got old data sitting around or not ... because new IP hack is independent.

We just won't add to the old column anymore.
The old data won't be "viewable today"!!!
Soon it will be viewable ... as if it was never missing.

Let it sit where it is in the database and "I'll import it" when I make the proper install script. Once it's imported, then it will magically be "viewable again". The imported data will be easy to spot because there will be a date from 1969 (since old hack didn't track dateline).

Feel free to install this the same day you upgrade to vb350!!

LAST NOTE:
This is still beta so I do NOT suggest installing it on a live forum just yet.
I'm not saying "you can't", because you can.

If you do, just make darn sure you "CLICK INSTALL" on this thread so you will get a notice when I make a major change to this .... and do not overlook changes I make ... until such time as I remove the "beta checkmark" at the top of the thread.

I have a long agenda (you saw the todo list).
I've already dropped a month of my life into this.
And I expect at least one more month before I finish that list!!
There's still no major flaws that I know of, so that's a plus, LOL.

C.Birch

08-05-2005, 08:40 PM

vbulletin allows you to have a ' (single quote) in a username??
Your kidding me!!

nope im not.

Mr Blunt

08-05-2005, 08:53 PM

I'm on it...
How stupid of me to think you couldn't use a quote in name.
What would the irish do, LOL.

I think $myvar = addslashes($vbulletin->userinfo['username']) should fix it.
I tested it on my forum yesterday and it seems to work fine.

Can anyone with experience verify that this is all I need to do??
And then I just stripslashes() after reading from DB?

What I don't understand is why I don't physically see the slashes in my database fields.
I just see the exact text name in the db.
Is this normal?

Marco van Herwaarden

08-06-2005, 05:35 AM

Addslashes is depreciated in 3.5, please use $vbulletin->db->escape_string instead.

And you will only see something different in the database if you use a special character like a quote.

Mr Blunt

08-06-2005, 06:50 AM

Addslashes is depreciated in 3.5, please use $vbulletin->db->escape_string instead.

And you will only see something different in the database if you use a special character like a quote.
Thanks MarcohH64!!
I really appreciate you following me around and helping me out.

I looked at that function and see it used "during" the db connection.
Does this imply that there's no "special handling" needed for after a db read?

Also while searching vb's code, I notice escape_string() is used for IPADDRESS in places, so I suppose I should do this for 4 of my 6 insertion variables (username, filename, ipaddress, & alt_ip)??

I'm so close with this thing ....
For the past few days I've been learning how to JOIN LEFT, ROFLMAO.
So that is knocking off a couple queries for me now.
I'm getting there....

Marco van Herwaarden

08-06-2005, 06:55 AM

Basicly you should sanitize all 'untrusted' (ie provided by outside sources like user input) variables used in queries.

Mr Blunt

08-09-2005, 12:46 PM

I just posted a new version (v105)!!
This is a crtical update!!
To anyone who had issues - I'M SORRY!!

I also rewrote many parts of the top post so might I suggest re-reading it please. The v105 zip file's readme is the same as the post (as of this writing) so pick one to read. Sometimes I think I spend more time writing the readme's than I do the researching and writing code, LOL, but it's for YOUR own good .... not mine!!

Please see the version history for full list of changes.
The really critical update is for the ENABLE LOGGING plugin.

Boofo,
New screen shots are posted!!

C.Birch and MarcoH64,
Thanks guys for pointing out why and how to better clean things like usernames before trying to write them into the database!! If someone can double check me, I think I have all the bases covered now ... as far as db writes go anyways. I now clean all the non numeric numbers (hope that's sufficient, if not, could someone please say so??).

C.Birch,
Sorry it took me a few days before posting a fix, but I didn't want to post a patch when major release with many changes was so close to being ready.

Laycomp,
Now that I'm feeling good about this version ... Here's my short answer!! No better time than the present to install this. The longer you wait, the less data you'll have to retrieve about those downloads later on. I PROMISE that soon I will figure out how to automate the process with a product update and your old saved data will reappear like it was never gone. Think of the old saved data as simply "not available today, but will be soon".

belinea

08-09-2005, 02:30 PM

Thank you very much for the new Release.

Great Great Great Mr.Blunt !!!!

Boofo

08-09-2005, 03:14 PM

Any way to have the button only show for certain usergroups? Maybe a setting? ;)

Has this been added yet? ;)

Mr Blunt

08-09-2005, 07:40 PM

Boofo

08-09-2005, 08:30 PM

Boofo,

Still #4 in my to-do list.
For the last month, I've been spending about 10 hours every day on this script.
I'm sorry I'm not fast enough to finish that list in a few hours or days.
I'm doing the best I can, believe me.

Oh, no, don't take that wrong. I'm sorry if it came off as anything else but a query. ;)

I just wanted to check is all. You have done a great job so far and I was just seeing what else needed to be done. Take you time, don't kill yourself over it. It's just a hack. ;)

belinea

08-10-2005, 12:39 AM

@Mr.Blunt: Can you also output the Hour, Minutes and Seconds of the download time in the popup windows? Currently there is only the date (day,month and year).

Mr Blunt

08-10-2005, 01:49 AM

No sweat Boofo!!
I like to kill myself over it. Learning is fun to me. I'm just disappointed in myself that it takes me so long. I have to REALLY design one complete hack from scratch before I really begin to understand how sql, php, and vbulletin all mix together ... and this is that first "big one" for me.

belinea,
Yes, that's easy (but finding space for it isn't right now, LOL). The saved 'dateline' is already measured in seconds. Honestly I figured that displaying it that way would be overkill, but now that you mention it, maybe it would have it's advantages .... especially when I add in the ability to search by userid .... so I'll work that in there.

laycomp

08-10-2005, 12:45 PM

That's telling them Mr Blunt, heck, they don't understand, it's not just a hack, it IS the hack! :D

Seeing you're only putting 10 hours a day and a day has 24 hours, I hope you might put some extra time -maybe 4-6 hours?- in creating some type of import so one can bring old data from previous Comish WhoDownloadedThis hack ;) ...this still leaves you with 8-10 free hours a day for eating and sleeping -more then ample time if you ask me. :D

Mr Blunt

08-11-2005, 07:28 PM

Mu5icMan

08-15-2005, 02:44 PM

Is there a way to show all attachments downloaded by a forumid's and list who's downloaded what?

laycomp

08-18-2005, 05:56 AM

I'm not ready to release, but I now have 3 vBulletin Options, 5 Usergroup Permissions, and I have successfully created an install to transfer old hack data to new dB table!!

Give me some time to test and tweak.

Wow Mr Blunt, you are the man! If you need some help testing, let me know :D

Thanks again for the work you're putting into this.

Mr Blunt

08-20-2005, 10:12 AM

Made some real huge breakthroughs in my knowledge base.

:banana:

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

I rewrote the top post yet again to reflect MANY changes.

Please .... I need some feedback on this one!!!
Good and/or Bad!!

I think I took care of all requests except for Mu5icMan's (the big one I've been working towards for a long time) which is still "down the road". I won't speculate on a timeline because it's all a matter of how fast I learn some more things. I COULD do it today, but I'd RATHER study for a while longer so I don't have to rewrite it when I learn the "better way".

Right now I want to make sure I'm on the right track.
This is why input is crucial right now.
I really need a coder to inspect this sucker.
Anyone willing??
:D

belinea

08-20-2005, 02:21 PM

GREAT RELEASE !!!!!!

But I´m missing a feature. I want to hide the "Who Downlaoded" buttons for normal users. Only admins schould see the button.

Mr Blunt

08-20-2005, 07:01 PM

GREAT RELEASE !!!!!!

But I?m missing a feature. I want to hide the "Who Downlaoded" buttons for normal users. Only admins schould see the button.
Your right!!
That was not intended.
I meant to hide it.

Let's see if any other bugs in the next couple days (instead of rapid consecutive releases).

In the meantime....
I'll give you the fix....
Edit the "Enable Viewing" plugin and replace the whole thing with this:

$show['blunts_whodl_canusernames'] = ($vbulletin->options['blunts_whodl_popisactive'] AND ($permissions['bluntswhodlpermissions'] & $vbulletin->bf_ugp['bluntswhodlpermissions']['canusernames'])) ? 1 : 0;
$show['blunts_whodl_candatelines'] = ($vbulletin->options['blunts_whodl_popisactive'] AND ($permissions['bluntswhodlpermissions'] & $vbulletin->bf_ugp['bluntswhodlpermissions']['candatelines'])) ? 1 : 0;
$show['blunts_whodl_canuploaders'] = ($vbulletin->options['blunts_whodl_popisactive'] AND ($permissions['bluntswhodlpermissions'] & $vbulletin->bf_ugp['bluntswhodlpermissions']['canuploaders']) AND $vbulletin->userinfo['userid']) ? 1 : 0;
$show['blunts_whodl_canipaddress'] = ($vbulletin->options['blunts_whodl_popisactive'] AND ($permissions['bluntswhodlpermissions'] & $vbulletin->bf_ugp['bluntswhodlpermissions']['canipaddress'])) ? 1 : 0;
$show['blunts_whodl_canaltips'] = ($vbulletin->options['blunts_whodl_popisactive'] AND ($permissions['bluntswhodlpermissions'] & $vbulletin->bf_ugp['bluntswhodlpermissions']['canaltips'])) ? 1 : 0;
$show['blunts_whodl_width'] = ($show['blunts_whodl_canusernames']) ? ((($show['blunts_whodl_canipaddress'] OR $show['blunts_whodl_canaltips']) AND $vbulletin->options['blunts_whodl_poplarge']) ? $vbulletin->options['blunts_whodl_poplarge'] : $vbulletin->options['blunts_whodl_popsmall']) : 0;

The last line is the only different one ;)
If viewing usernames is disabled for a usergroup, they won't see the button.

belinea

08-20-2005, 10:57 PM

The last line is the only different one ;)
If viewing usernames is disabled for a usergroup, they won't see the button.GREAT, work?s fine.

"WhoDownloaded with IP" is my personal Hack-Of-The-Year.

Roxie

08-21-2005, 04:16 PM

I'm getting an error

Database error in vBulletin 3.5.0 Release Candidate 2:

Invalid SQL:
UPDATE vb3_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Moderators',
`description` = '',
`usertitle` = 'Moderator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '500',
`pmpermissions` = '3',
`pmsendmax` = '20',
`calendarpermissions` = '63',
`wolpermissions` = '29',
`adminpermissions` = '0',
`genericpermissions` = '205256703',
`genericoptions` = '31',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '20000',
`ecdownloadpermissions` = '1',
`supportpermissions` = '0',
`bluntswhodlpermissions` = '7'
WHERE usergroupid=7;

MySQL Error : Unknown column 'supportpermissions' in 'field list'
Error Number : 1054
Date : Sunday, August 21st 2005 @ 01:14:57 PM
Script : http://XXXXXXXXXXXXXX
Referrer : http://XXXXXXXXXXXXXXXXXXXXXXXXx
IP Address : XXXXXXXXXXX
Username : XX
Classname : vb_database

Roxie

08-21-2005, 04:18 PM

Sorry, I meant to say I get that error when trying to save usergroup settings.

Mr Blunt

08-21-2005, 06:09 PM

upload the bitfields file to your server's /includes/xml/

Roxie

08-21-2005, 08:55 PM

That was already done. Any other ideas? Thanks. :)

Mr Blunt

08-22-2005, 01:58 AM

I'm sorry Roxie,
I should have looked at your error closer the first time.

Take a look at the bottom of it ... I'll requote the relevant part of the error.
`supportpermissions` = '0',
`bluntswhodlpermissions` = '7'
WHERE usergroupid=7;

MySQL Error : Unknown column 'supportpermissions' in 'field list'
Error Number : 1054
Date : Sunday, August 21st 2005 @ 01:14:57 PM
Script : http://XXXXXXXXXXXXXX
Referrer : http://XXXXXXXXXXXXXXXXXXXXXXXXx
IP Address : XXXXXXXXXXX
Username : XX
Classname : vb_database

Answer:
My hack pertains to the 'bluntswhodlpermissions' database column, not the other one above it which is the root of your trouble named supportpermissions.

I pulled a search and found a hack that uses that column.
https://vborg.vbsupport.ru/showthread.php?t=94023

I'll take a guess that you either need to upload HIS bitfield file to the server's XML folder or you need to reinstall HIS software from scratch if that database column doesn't exist. His installation script code DOES (at least attempt to) add that column the "first time" you install his 0.4 version.

If uploading their bitfield file isn't the trouble, try asking that hack's thread.
If they can't fix you up, then definately come back and I will.
;)

Roxie

08-22-2005, 03:27 AM

Thanks so much! All is well now. :)

laycomp

08-24-2005, 01:26 AM

[QUOTE=Mr Blunt]Made some real huge breakthroughs in my knowledge base.

:banana:

v-1.0.7 - August 20th, 2005:
Added code to seek/transfer data from old whodownloaded hacks to new table.

Mr Blunt, does this option include the transfer of data from Commish's old hack? or is this option not yet available?

Mr Blunt

08-24-2005, 05:05 AM

That feature "IS" the transfer of data from Commish's old hack.
And it's not an option because .... I just do it ... automatically.

Don't expect any stops during the install.
I seek the data, and if found, I transfer it.
...No matter how much data that may be.

Let me know how long it takes to tranfer your data please, laycomp.

laycomp

08-24-2005, 01:10 PM

Because of large attachment db file we'll first need to take measures in case we run into problems but I'll let you know ...I hope to be able to install some time next week. Thank you.

Mr Blunt

08-24-2005, 01:30 PM

Because of large attachment db file we'll first need to take measures in case we run into problems but I'll let you know ...I hope to be able to install some time next week. Thank you.
Because of...??
Rule #1 of vbulletin is:
ALWAYS make a backup of a database before modifying it.
...No matter how small or large the site is.
.....ALWAYS!!!
:D
As long as you have a backup, reverting to it is simple.
Simple as that.

But I STILL do not recommend attempting this on a live site yet.
At this point, in my estimation, you should be testing with a test site.
This doesn't go for "my hack" ... it goes for vbulletin in general.

If you MUST play with a live site, then I STRONGLY recommend waiting until vbulletin RC3 comes out .... and my subsequent release which will follow it .... so you will be able to read my product's onscreen installation messages!!! Currently this is NOT POSSIBLE but Mike from Jelsoft was kind enough to address this issue and I'll need to see his new fix before I can recode my display messages.

laycomp

08-25-2005, 03:56 AM

hehe... you are right about that!

thanks for the "backup" "backup" and "backup" tips

I'd still like to try, this way it'll get me ready for rc3 and your release.

Anyone else trying this? I don't see many comments from you other folks here.

Allan

10-16-2005, 07:47 PM

work with 3.5 Gold ?

Mr Blunt

10-16-2005, 09:38 PM

Far as I know ... Yes .... but hold off.
I will release next version within the next 7 days.
I promise!!

Here's just a few things you can look forward to

Brand new AdminCP Nav Catagory with a few hotlinks.
Brand new Admin Search capabilities.
Brand new editing /deleting capabilities for each stored download.
Shows total stats for your search.
Sort by any column (ascending or descending).
Pick number of matches to show per page.
Go to 1st, previous, next, or last page with one click.
Hover userid and fileid numbers to see the stored username and filename.
Click download's id number to edit that entry.
Checkbox column for mass deleting.
Ability to import at your own discretion at any time you wish (not that this is a good thing since it's only meant to be a one time shot).

Take note that ALL of that refers to the admin side.
I don't think I've changed the normal interface (in forum posts).

Far as I can tell ... it all works.
But it still needs tweaking.

And I hate releasing too many "different versions" because unfortunately I usually change way too much inbetween versions ... so people give up on trying to follow my code when I release too many versions .... therefore I'm trying hard to not let that happen to this and/or any other products of mine.

All I can say is I learned a buttload in the last couple months and all of my hacks are in the process of being updated (whodownloaded is top priority for me).

Allan

10-16-2005, 09:44 PM

cool ;)

Thank you and courage

Mr Blunt

10-16-2005, 09:50 PM

Allan,

Can you post the last language pack for this?
I'd really like to see one if that is possible.

I think I've doubled the phrases and I'd like to make it as easy for you folks as I can.

Allan

10-17-2005, 11:33 AM

I did not translate the current version (rc2), to speak to you about what version ?, gold ?

Mr Blunt

10-18-2005, 07:30 PM

I did not translate the current version (rc2), to speak to you about what version ?, gold ?
Currently all my phrases are inside my product XML and install with my product.
I only know English, so that's all you will ever get from me.

If you want the next version to "not do this", you have to tell me how you want my files formatted.

Do you want the phrases inside the product AND a seperate language pack?
Do you want them in ONLY a language pack?
Do you want them ONLY in the product XML?

I only asked for a past example because I learn best by examples.

I'm asking because I read a request here at vb.org somewhere (in which Allan posted he wanted to see this happen) that asked authors give a seperate language pack with their products, but it wasn't clear if they should be completely left out of the product.xml file.

If I understand the product system correctly (that means please correct me if I'm wrong), I think I "need" to have my phrases inside the product.xml so they install in the "master language" ... in which case a seperate English language pack would be redundant and even confusing since english forums wouldn't need the file.

Help??

Allan

10-18-2005, 08:20 PM

ONLY a language pack :)

Mr Blunt

10-18-2005, 08:34 PM

Then save me time and show me an example of a product that does this. Either a modified old version of mine ... or some completely different "simple" product ... I don't care which.

Please take into account that I DO NOT want my fellow native english speakers to be forced into installing this "seperate pack" themselves .... meaning the "example" must show me how the product installation script accomplishes this task automatically (assuming the user uploaded the XML of course).

Either post it, link it, or send it to my email.
mr_blunt@sbcglobal.net

Mr Blunt

10-23-2005, 04:22 PM

sigh....

I have what "should be" a finished product but I can't even test it.

I've been in a fight with my hosting company for the last 24 hours and can't even test it.

I've been awake for the last 36 hours and I won't be able to go to sleep until after game 2 of the world series as company is coming over soon.

My schedule for Monday is booked solid.

The last version I tested with worked great. I made some more subtle untested changes in the last day though. I'd rather not release still, but if someone has a deadline ..... SAY SO and I will accomidate you and post what I've got right now which will "probably" work.

So you see what I mean, here's a couple of the last screenshots I saved.
I minimally tested each of the different types of search criteria with no hitches so far.

I'm very sorry this project is taking me so long but I see light at the end of the tunnel.

P.S. - I still haven't had time to do any searching about the language pack thing so I can now guarantee it will NOT be in this next version and will have to wait.

ombossman

10-31-2005, 02:49 PM

Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /includes/class_core.php on line 635

what is problem i use vb 3.5.0 version

Mr Blunt

11-01-2005, 09:17 AM

It's inexcusable to break promises, but that's the way it went.

It was a choice between THAT.
... or fix all my serious bugs (which should all be dead now).
... or release bad software (which I HATE to do).
... for something which I haven't made a dime off of as of yet (would be nice but I know how it goes).

It's not often I get to spend October celebrating my White Sox and their awesome season MUCH LESS do I get to enjoy a week of celebrations after they win it all. I was even one of those 1.7 million people who attended that tickertape parade through downtown Chicago!! Somehow I magically landed 100 foot from the stage at Wacker & LaSalle.

... Something I'll never forget for the rest of my life!!
... What would you have done, LOL!!

Oh well ... This product is pretty much done.
Might need a couple small tweaks, but nothing major.
Sorry it took so long, but hopefully it's worth it.

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!! Please post results !!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Allan

11-01-2005, 09:51 AM

I occupy myself of the French translation ;)

ombossman

11-01-2005, 09:58 AM

Mr Blunt

11-01-2005, 10:17 AM

I occupy myself of the French translation ;)
Thank You Allan!!

You (and/or anyone) can still save me a ton of time if you can show me how you would set up the "whole zip file" (any/all files) to be more language compatible.

One problem area is messages that get used during installation.

Another problem area is messages that get used in Admin File during table deletion (kill) since that happens after product's phrases are deleted.

And then there's still the question of where, when, and how to install all the phrases which I believe NEED to get installed into the "Master Language" before we can overlap those phrases with "customized language packs"??

And then I suppose I need a kind soul from the "right to left" language world to tell me if I have any serious mistakes in the display department (I did try to do a few things to help them already).

One (new or existing) example that addresses all/any of these issues/questions would teach me real quick if anyone can help point me to it.

Mr Blunt

11-01-2005, 10:43 AM

thanks for interesed today imported whodownloaded_ip-v110[vb350] working well but another question style_blunts_whodl_ip.xml howto uplaod or where upload i dont know
Open AdminCP
Click Styles & Templates
Click Download / Upload Styles

- Now the important part -
Scroll down to the "Browse" button and find Style File.
Pick the Parent Style in the "Merge Into Style" dropdown box!!
(sidenote: DO NOT OVERWRITE THE "MASTER STYLE")
Scroll to bottom and Click Import.

If you have multiple parent styles, you have to do this for each parent.
You do NOT have to merge this into any "CHILD" styles of those parent styles.
(That's the point having a parent style).

BUT ... Most of you should manually edit templates instead of the above since I'm sure most of you run a bunch of other products which might also edit these same templates!!

If you want to do that ...

Open AdminCP
Click Styles & Templates
Click Style Manager
Click the EXPAND (<< >>) arrow next to parent style
Click the EXPAND (<< >>) arrow inside the subwindow
Find appropriate template and Double Click it.
Find & add the code for the button to each of those 4 templates as listed in first post.
Don't forget to click save after editing each template.

Let me know how it goes!!

belinea

11-05-2005, 03:35 PM

The "Blunt's Whodownloaded_IP Quick Search Engine" is AMAZING

Mr Blunt

11-05-2005, 07:35 PM

Thank you Belinea.

If anyone notices anything wrong or anything weird or any strange behavior, please speak up because I've finally stopped tweaking this hack ... and my forum is going through a slow period (meaning my members aren't downloading anything) ... so if anything is wrong I will need to be made aware of it so I can look into fixing it.

Can I finally remove the Beta Tag???
I really wish some kind soul would double check my work.

ombossman

11-09-2005, 12:46 PM

this hack 3.5.1 working ?

Mr Blunt

11-09-2005, 04:04 PM

this hack 3.5.1 working ?
Good question.
My real forum and test forum are both using 3.5.1
But I don't have much traffic so it's hard for me to notice.

Far as I can tell, whodownloaded_ip-v110 should work for 3.5.1 and 3.5.0 and probably even 350rc4 and 350rc3 which is when the product system was introduced I think.

v110 was built upon vbulletin 350, so I'm almost certain it's good for that.
After I upgraded to vb351, I ran through all my tests once more (which included uninstalling, installing, and importing a few times) and I found no errors or strange behaviour.

Trouble is I'm only one man.
This is a large script.
I'm human.
Therefore I expect there to still be a mistake or 3.
But if they exist, I can't find them!!!

This is why I am begging for a little help now.
I really need someone to double check me.
The script needs a fresh set of eyes to look at it.

ombossman

11-10-2005, 12:50 PM

[QUOTE=Mr Blunt]Good question.

Thanks for reply and explain because i upload my forum have some bugs

Mr Blunt

11-10-2005, 01:06 PM

Chances are good that I can help you if you can be a little more specific about what type of problems your having.

If you think the problems are due to my script, continue posting details right here so everyone can read it and learn from it.

If you think the problems are due to something else, PM me with some details and I'll try to help or at least try to guide you in a direction.

ombossman

11-11-2005, 09:07 AM

Jiggles

11-11-2005, 09:10 AM

Nice

Mr Blunt

11-11-2005, 03:02 PM

Thanks Jiggles!!

And 2 pm's back at you, ombossman!!
(My first guess was incorrect, so read second one)

Looks like you just need to delete one old bitfield file (includes/xml/bitfield_profileviews.xml) which is still associated with a product you previously uninstalled from your server. That is the cause of your database errors when editing usergroups.

ombossman

11-14-2005, 07:46 AM

mhammed

12-08-2005, 09:29 PM

when in import product i have this

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

any idea?

Mr Blunt

12-09-2005, 03:41 AM

when in import product i have this

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

any idea?
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.

eNforce

12-09-2005, 04:18 AM

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

12-09-2005, 04:38 AM

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

12-09-2005, 04:40 AM

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

12-09-2005, 04:50 AM

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

12-09-2005, 05:59 AM

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

12-09-2005, 01:07 PM

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:

 Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 657 Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 657 Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 657 Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 657 Warning: mysql_query(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 395 Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 837 Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 855 <!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

12-09-2005, 01:33 PM

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

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:

 Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 657 Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 657 Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 657 Warning: mysql_real_escape_string(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 657 Warning: mysql_query(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 395 Warning: mysql_error(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 837 Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in /includes/class_core.php on line 855 <!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

12-09-2005, 07:39 PM

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

12-09-2005, 09:55 PM

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

12-11-2005, 06:43 AM

Thanks Mr. Blunt :)

Mr Blunt

12-11-2005, 06:57 AM

I'm still testing but the major fix is as follows:

1) Go into "Plugin Manager" (not Product Manager).
2) Find "Whodownloaded IP - Enable Logging" plugin and click Edit.
3) At top, Change the Hook to "attachment_display" (1 above attachment_complete).

Or wait another few hours and I'll upload fix.
Sorry for the delays.
I think I found a couple other real minor issues that I'm working on as I type.

mhammed

12-11-2005, 10:58 AM

Mr Blunt

12-11-2005, 11:39 AM

thank you very much. I would wait in what relates to me. but, if you want to think well of those uninstall it.
what is necessary to make?
Your problem is what I'm working on, and is why everyone else has to wait.
I do see the installation bug, but I'm not sure yet on how to fix it.
This is not an easy one to solve.

It appears to me like vB352 addressed an issue pertaining to unused bitfields, like for people who forget to delete the bitfield file after installation, which in turn is screwing around with my installation/uninstallation codes.

Do not install this.
Do not uninstall this.
Even if you really want to!!!

There are only 2 fixes right now.

"Disable" my product until I fix the install/uninstall codes.
...Or...
Edit the plugin called "Enable Logging" and change hook so it says "attachment_display".

Replicators

12-11-2005, 06:50 PM

I take it this hack is for attachments and not external url's?

Would it be possible for a hack like this do the same for external url links?

Mr Blunt

12-12-2005, 09:35 AM

v-1.2.0 - December 12th, 2005:

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.
Moved a lot of the install code from the product file to the admin file.
Condensed the rest of the install/uninstall code.
Changed the format of all files from Windows to UNIX.
Updated all the screenshots (some are not shown).
Removed the Beta Tag from the product.
To Do and/or Wish List:
I'm still looking for someone to help me add better language support.
Known Bug List:
Installation messages are english only since code installs before phrases.
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!!

belinea

12-12-2005, 02:43 PM

GREAT JOB, Mr.Blunt !!!

Mastar

12-12-2005, 02:57 PM

Works flawless so far. Love that you have included the usergroup in the menu. I wish that more of these hack would include a menu where permissions and other options are added.

Thanks!

Mastar

12-12-2005, 03:33 PM

I have 2 quick search engines my ACP https://vborg.vbsupport.ru/attachment.php?attachmentid=39224

Mr Blunt

12-12-2005, 04:19 PM

I have 2 quick search engines my ACP https://vborg.vbsupport.ru/attachment.php?attachmentid=39224
Yes, one engine at top and another engine at bottom. I figure after a few years of downloads, your searches will return large numbers of results, so maybe this will help cut down on scrolling.

Mr Blunt

12-12-2005, 04:35 PM

I take it this hack is for attachments and not external url's?

Would it be possible for a hack like this do the same for external url links?
Sorry, but this only collects information about downloaded attachments.
I don't forsee myself merging a links manager into this, but anything is possible.
The topic is open for discussion though.

bashy

12-13-2005, 09:08 AM

Hi Mr Blunt

Please can you tell me where i can edit the button as it looks a little too long?

Regards

bashy

Mr Blunt

12-13-2005, 09:43 AM

Hi Mr Blunt

Please can you tell me where i can edit the button as it looks a little too long?

Regards

bashy
I wish I could.
That's the best I.E. can do.

Your not going to save a lot, but I suppose you could force the "postbit_attachmentthumbnail" template to use my BMP file instead of the html code (or your own picture).

Find this:

<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>

And change it to this to use my button image file:

<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>

Edit this part to use your own image file:
src="$stylevar[imgdir_attach]/blunts_whodl_vertical.bmp"

Another way would be to change the phrase which gets displayed to something shorter, which is in the same area of code, and then it will shrink to fit .... for IE only of course.

P.S. - I was assuming you meant the vertical button next to images. If the horizontal one is too long, it works the same way so find the similar code for each of the 4 templates we edit instead of just the thumbnails.

bashy

12-13-2005, 10:11 AM

Hi

Ok thanks Mr Blunt, I will give this ago...

It is the normal Who Downloaded Button (horizontal) that needs shortening..

So let me get this right...all i need to do is shorten the phrase, if so how and where, sorry for sound like a thickett..

Just the word "who" would be great...

Regards

Bashy

Mr Blunt

12-13-2005, 10:52 AM

Something like this:

<if condition="is_browser('ie', '5.5')">
<input type="button" class="button" value="who" 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>
See where I put the....
value="who"
Where this used to be:
value="$vbphrase[blunts_whodl_who_downloaded]"

bashy

12-13-2005, 11:34 AM

mhammed

12-13-2005, 01:53 PM

GREAT JOB

thanks

install and work 100%

Mr Blunt

12-13-2005, 09:16 PM

Hi again...

Thanks for this, i have just changed it to what you said but its still showing Who Downloaded, I copied all your text and pasted over so there could not have been any mistakes!

Any ideas?

Sorry for the messing about :(

Bashy
The edit I gave only changes the button for thumbnails in Internet Explorer 5.5+.

Thumbnails in any other browser still use a real picture for the button because other browsers don't have ability to show a vertical html button, so you would have to design your own small button and edit code to insert your image's filename.

For the horizontal buttons, you still have to edit the other 3 templates.
You edit them the same way.
Find the button, change the value parameter.

bashy

12-13-2005, 09:51 PM

Hi m8...

I think im gonna have to leave it as it is.... :o the more i look at it the more appealing it becomes lol.....All is working, so i think im gonna leave it this way :)

Thanks again for your time...

Regards

Bashy

Arios

12-14-2005, 05:46 AM

All seems to work just fine except for when I go to post

The following errors occurred when this message was submitted:

1. You did not specify a username for your post.

Any solution to this?

Bullethead21

12-17-2005, 12:02 PM

Awsome!! Works VERY well! The only complaint I would have is having "Blunts Whodl" in my control panel....dont look right. Other than that, AWSOME!!

nanaimobar

02-14-2006, 09:26 PM

Everything installed easily except when clicking on Quick Search Engine in Admin panel a 404 error occurs. I checked forum url in options panel, was ok, then changed url to main site to see if that made any difference. Didn't. Still get 404 error with main web site address for "Return to site". Database has no errors, and no errors reported by vbulletin.
Suggestions?

Mr Blunt

02-15-2006, 09:50 PM

nanaimobar,

Sounds like you didn't upload all the files that came inside my "upload" folder to your server.

Or that you maybe didn't upload them all to the correct folders.

Or that you did upload them, but maybe your normal "admincp" is not named that, in which case you need to put the contents of that folder (the file named admin_blunts_whodl_ip.php) in whatever that renamed admin folder is.
.

nanaimobar

02-17-2006, 10:27 PM

Hi Mr. Blunt,

I had renamed my admincp folder (I've fined myself 5 dollars for making such a simple mistake as not connecting the dots, so to speak) so I moved your file to the correct folder on my server and....
now I get an error code, which doesn't all paste into here for some reason, that begins with "SCU$" and follows with a dozen or more letters and squiggles that make no sense to me.

All other files are in their correct place as everything else appears in the admin section of vbulletin, and seems to work.

I shall spend this weekend fiddling about and see if I can get this too work and report back.

The Realist

03-02-2006, 10:55 AM

Installed and working 100% on VB 3.5.4.

Nice hack indeed and glad I found it now.

Well done.

Replicators

03-07-2006, 02:44 AM

Everything seems to installed 100% correctly as in no errors at all!!

But nothing works, i get all the options and stuff in the acp, i have it set to on, usergroups are set, but when i go to forum there is no "Who Downloaded" thing anywhere. I looked in the usercp and nothing. The template edits are there, but it seems the forum is ignoring this mod for some reason and i don't know why.

berayiwu5

03-12-2006, 03:23 AM

Thanks for coming up with this hack. But for some reason, "Who Downloaded" doesn't appear beside attachments. Nor does it show up in the Attachments section in my User CP under "Date." I have vBulletin 3.5.4.

Your help is greatly appreciated.

Actually, I don't quite understand step 4 of the installation: "MERGE 'style_blunts_whodl_ip.xml' over your styles (ignore version)." I just imported it using Add/Import from the Product Manager. Does it have something to do with it?

Replicators

03-13-2006, 06:23 AM

I just figured out my problem.

@berayiwu5
You probably have the plugin accelerator installed right? Well rebuild your plugins and it should work fine >8)

berayiwu5

03-13-2006, 01:41 PM

I just figured out my problem.

@berayiwu5
You probably have the plugin accelerator installed right? Well rebuild your plugins and it should work fine >8)

Thanks for your suggestion. No, I haven't installed the plugin accelerator. Is it safe? I can't afford to mess up the database. I only know how to follow instructions. I don't know anything about coding.

berayiwu5

03-15-2006, 02:12 AM

OK. I finally got it working. It's an omission on my part. Thanks. Great hack.

MaLTRaiN

04-11-2006, 02:57 PM

Excuse me... is this retroactive? Thanks..!!!

belinea

06-10-2006, 06:47 PM

Can we expect a vB3.6 compatible version of the WhoDownloaded Hack?

xlegends

09-10-2006, 03:12 PM

Not loggin .gif images. Can solution to this.
Thanks..

Spydertech

09-26-2006, 01:31 AM

Can we expect a vB3.6 compatible version of the WhoDownloaded Hack?

I just installed 3.6.1 (upgrade old 3.0.5 database) - after many nights of modifications, I stumbled on this GREAT hack....

Installed it (manually made edits) and it works fine...

Spyder

Deska

11-01-2006, 06:44 AM

I just installed 3.6.1 (upgrade old 3.0.5 database) - after many nights of modifications, I stumbled on this GREAT hack....

Installed it (manually made edits) and it works fine...

Spyder

Maybe you can share it here please ;)

xlegends

11-01-2006, 12:53 PM

this works fine for me on 363 without any mods.

mhammed

11-06-2006, 06:12 PM

excuse my English.
I noticed that the volume of the database has doubled after one month
can you please create a new button to empty all the fields of the tables if we need to do it.
or to announce the right sql querry to be execute to make the table empty

to do this, i'm obliged to desinstall the hack and reinstall it

thanks

Deska

05-18-2007, 03:39 AM

Is this hack compatible with vBulletin 3.6.7?
Thank you....

da_judge

11-16-2007, 08:53 PM

Dont work with 3.6.8 all versions....

Was nice add on... needs an update and im to stupid to do it lol

da_judge

11-16-2007, 08:53 PM

Is this hack compatible with vBulletin 3.6.7?
Thank you....

Yes 3.6.7 works

nanaimobar

11-30-2007, 04:09 PM

Dont work with 3.6.8 all versions....

Was nice add on... needs an update and im to stupid to do it lol

I agree. This was a great mod that needs to be updated for 3.6.8 and for upcoming 3.7 versions.

Update.

:(Mr. Blunt hasn't been online here since September 2006 so perhaps this mod is dead. Stats are still available for viewing in the admin panel of 3.6.8 patch2

xlegends

04-26-2008, 07:16 AM

Is there any mod out there close to this. This was great..

nanaimobar

09-14-2008, 04:29 PM

Is there any mod out there close to this. This was great..

I have this working on 3.7.3 PL1. I've had this installed since 3.5 version. Had a minor problem when updated to 3.7 but reinstalled/overwrite mod and worked fine since.

If you are having problems then it may be with your database, in that when you installed this mod it failed to create one or more database fields for some reason.

Or you may not have all the required files.

If it is your database you could try uninstalling the mod then reinstalling to see if mod works(if you haven't tried this yet).

Check your database for these fields (as shown in the .txt file included in mod):
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

If you don't know how to create fields then maybe someone reading this will post instructions.

Check for these files:

You should have .xml files for bitfield (bitfield_blunts_whodl_IP.xml) in your includes/xml folder, and cpnav_blunts_whodl_IP.xml in the same folder.

In your images folder you should have blunts_whodl_vertical.bmp. I've included these for you as attachments:

ecihanuysal

01-06-2009, 11:37 PM

how can we optimize this for 3.8.x ?

Hornstar

04-15-2009, 02:13 AM

It is a shame this did not continue. Is anyone interested in taking this over and making it work for 3.8.x ?

da_judge

05-14-2009, 10:48 PM

works for me in 3.8.2

I just gonna try disable for images.. work for just files only