vb.org Archive - Who Downloaded This Attachment?

Page 3 of 13

Last »

Show 40 post(s) from this thread on one page

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

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Who Downloaded This Attachment? (https://vborg.vbsupport.ru/showthread.php?t=36900)

WallStreat

04-03-2002 03:56 AM

1. A suggestion: to store the dowload info into a new table instead of creating a new field in the user table.

2. The new whodownloaded table could contain the following info:
- attachmentid
- userid
- dateline
- ip

3. This way, we can also find out how many a particular user downloaded the same attachment, the date & time downloaded or the ip address (if needed for control purpose)

4. Moreover this can prevent bloating the $bbuserinfo variable as the download field can get quite big

TWTCommish

04-03-2002 03:59 AM

Well, I'd thought of all that already, hence this line in my original post:

Quote:

This may be expanded later into a more comprehensive, expanded "download center," but for now, it's just a small hack. :)

I may consider expanding this down the line, but for now it's just a small addition. I'm not worried about the $bbuserinfo variable, however. Variables can hold an awful lot of text without becoming any real kind of problem. I think it'd have to be disgustingly large to cause "bloating" to the point of difficulty.

If anyone else seconds the idea to expand this hack, say so... :)

WallStreat

04-03-2002 04:29 AM

anyway this is a great hack, well done :)

Crazy Mofo

04-12-2002 07:18 AM

hi i get a 404 error :(

Jadelit

04-12-2002 07:46 AM

OK I have a Mutiple Attachments hack installed... when I click on the like.. I get this error...

Code:

Invalid SQL: SELECT counter FROM attachment WHERE attachmentid = undefined

mysql error: Unknown column 'undefined' in 'where clause'



mysql error number: 1054

what does this mean..

TWTCommish

04-12-2002 12:16 PM

I don't know how you got the text "undefined" there. Did you modify any of the files?

As for the 404 error: make sure you upload the whodownloaded.php file to the main forums directory!

squawell

04-12-2002 01:56 PM

nice job!!

did u ever think add the download times numbers??

TWTCommish

04-12-2002 01:58 PM

Yeah, I thought of it, but decided to just start simple. I might expand this big time later on...if I ever finish the other 3 or so hacks I'm working on. LOL.

TECK	04-12-2002 03:34 PM

great hack. :)
i'll use it but a little modified. i'll make it visible only for mods and admins.

wooolF[RM]

04-12-2002 11:45 PM

]Your SQL-query has been executed successfully

SQL-query :
ALTER TABLE user ADD COLUMN downloads TEXT NOT NULL

Clicking on link (I have downloaded file to be sure it have some records)

New window pop-ups ->>>

Database error in vBulletin 2.2.4:

Invalid SQL: SELECT u.userid, u.username FROM user u WHERE u.downloads LIKE "56%" OR u.downloads LIKE "%56%" OR u.downloads LIKE "%56" ORDER BY u.username ASC
mysql error: Unknown column 'u.downloads' in 'where clause'

mysql error number: 1054

Date: Saturday 13th of April 2002 02:42:16 AM
Script: http://blablabla/forum/whodownloaded...ttachmentid=56
Referer:

Any help please?... I rechecked twice if I edited/added everything right...

All times are GMT. The time now is 08:43 AM.

Page 3 of 13

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01176 seconds Memory Usage 1,734KB 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 (1)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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: