vb.org Archive - Whodownloaded

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

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - Whodownloaded_IP with Dates (https://vborg.vbsupport.ru/showthread.php?t=93167)

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.

Quote:

Originally Posted by Mr Blunt

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.

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

Quote:

Originally Posted by Brinnie

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

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.
;)

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.

*** removed my proposed edits because I like what's in v105 ***

This blunts_whodl_vertical.bmp file (inside this zip file) is REQUIRED for the 'postbit_attachmentthumbnail' template edit!!!

*** removed the first button image I posted because it was ugly ***
*** please use the one that's included with the v105 zip ***

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

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//atta...1&d=1123102373
Referrer :
IP Address : 80.41.214.230
Username : Scott_lee's_Rock
Classname : vb_database

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

Quote:

Originally Posted by Mr Blunt

HTML Code:

 <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;" />&nbsp;

</if></td>

postbit_attachmentmoderated: add this just before the final </tr>

HTML Code:

 <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;" />&nbsp;

</if></td>

postbit_attachmentimage: add this to the end

HTML Code:

<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;" />&nbsp;

</if>

postbit_attachmentthumbnail: FIND THIS

HTML Code:

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

Just before that, add this:

HTML Code:

<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;" />&nbsp;

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

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

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_html_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02690 seconds Memory Usage 1,771KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_html_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: