The Arcive of Official vBulletin Modifications Site.

Who Downloaded This Attachment · **Released**: 06-26-2009

I no longer support my hacks. Please feel free to update them and release new versions elsewhere as long as I get the credit for the original modification.

/*=============================================*\
|| Who Downloaded This Attachment
||
|| Author : Anton Kanevsky
|| Works on : vBulletin 3.5.x - 3.8.x
|| Released : Jun 27, 2009
||
|| Time required to install: ~30 seconds
|| Difficulty: easy
\*=============================================*/

DESCRIPTION

Allows users to see detailed information about who has downloaded attachments.

STATISTICS

File Uploads: 1
Products to Install: 1

FEATURES

General:

Displays a list of users with information about the number of downloads and last downloaded time.
Allows to specify which usergroups can use the feature.

VERSION HISTORY

1.1.0
[F] Fixed a bug in the product xml file.

1.1.0
[+] Officially compatible with 3.5.x - 3.8.x.
[+] Removed all file and template edits.
[+] Added usergroup permission to specify which usergroups can use the feature.
[+] The last downloaded time for each user is now displayed.

1.0.2
[F] Compatibility with 3.5.2's modified attachments.php.

1.0.1
[+] Each user now has a number of downloads displayed next to him/her.

1.0.0
First Release

The installation manual is contained within the attached file.

IF YOU LIKE MY HACK, PLEASE CLICK INSTALL

akanevsky · #2 06-27-2009, 03:24 PM

First Post Reserved.

saadessa · #3 06-27-2009, 04:08 PM

I Will Try Thank You

deadlySniper · #4 06-27-2009, 04:23 PM

Nice, thanks.

saadessa · #5 06-27-2009, 04:23 PM

AFTER TRY TO GIVE permission

GIVE THIS ERROR

PHP Code:


			
Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Administrators',
    `description` = '',
    `usertitle` = 'Administrator',
    `opentag` = '',
    `closetag` = '',
    `passwordexpires` = '180',
    `passwordhistory` = '360',
    `forumpermissions` = '16777215',
    `genericpermissions` = '2147483583',
    `attachlimit` = '0',
    `psiwd_options` = '1',
    `pmquota` = '50',
    `pmpermissions` = '7',
    `pmsendmax` = '5',
    `pmthrottlequantity` = '0',
    `calendarpermissions` = '63',
    `wolpermissions` = '31',
    `adminpermissions` = '3',
    `genericpermissions2` = '1',
    `genericoptions` = '55',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '65535',
    `avatarmaxwidth` = '80',
    `avatarmaxheight` = '80',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '237567',
    `sigpicmaxwidth` = '500',
    `sigpicmaxheight` = '100',
    `sigpicmaxsize` = '10000',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '0',
    `albumpermissions` = '255',
    `albumpicmaxwidth` = '600',
    `albumpicmaxheight` = '600',
    `albumpicmaxsize` = '100000',
    `albummaxpics` = '100',
    `albummaxsize` = '0',
    `usercsspermissions` = '63',
    `visitormessagepermissions` = '63',
    `socialgrouppermissions` = '65535',
    `maximumsocialgroups` = '5',
    `groupiconmaxsize` = '65535',
    `uscpermissions` = '0'
WHERE usergroupid=6;

MySQL Error   : Unknown column 'psiwd_options' in 'field list'
Error Number  : 1054
Request Date  : Saturday, June 27th 2009 @ 01:18:46 PM
Error Date    : Saturday, June 27th 2009 @ 01:18:46 PM

BigDog56 · #6 06-27-2009, 04:34 PM

Quote:

Originally Posted by saadessa

AFTER TRY TO GIVE permission

GIVE THIS ERROR

PHP Code:


			
Invalid SQL:

UPDATE usergroup SET



### UPDATE QUERY GENERATED BY fetch_query_sql() ###

    `title` = 'Administrators',

    `description` = '',

    `usertitle` = 'Administrator',

    `opentag` = '',

    `closetag` = '',

    `passwordexpires` = '180',

    `passwordhistory` = '360',

    `forumpermissions` = '16777215',

    `genericpermissions` = '2147483583',

    `attachlimit` = '0',

    `psiwd_options` = '1',

    `pmquota` = '50',

    `pmpermissions` = '7',

    `pmsendmax` = '5',

    `pmthrottlequantity` = '0',

    `calendarpermissions` = '63',

    `wolpermissions` = '31',

    `adminpermissions` = '3',

    `genericpermissions2` = '1',

    `genericoptions` = '55',

    `profilepicmaxwidth` = '100',

    `profilepicmaxheight` = '100',

    `profilepicmaxsize` = '65535',

    `avatarmaxwidth` = '80',

    `avatarmaxheight` = '80',

    `avatarmaxsize` = '20000',

    `signaturepermissions` = '237567',

    `sigpicmaxwidth` = '500',

    `sigpicmaxheight` = '100',

    `sigpicmaxsize` = '10000',

    `sigmaxrawchars` = '0',

    `sigmaxchars` = '0',

    `sigmaxlines` = '0',

    `sigmaxsizebbcode` = '7',

    `sigmaximages` = '0',

    `albumpermissions` = '255',

    `albumpicmaxwidth` = '600',

    `albumpicmaxheight` = '600',

    `albumpicmaxsize` = '100000',

    `albummaxpics` = '100',

    `albummaxsize` = '0',

    `usercsspermissions` = '63',

    `visitormessagepermissions` = '63',

    `socialgrouppermissions` = '65535',

    `maximumsocialgroups` = '5',

    `groupiconmaxsize` = '65535',

    `uscpermissions` = '0'

WHERE usergroupid=6;



MySQL Error   : Unknown column 'psiwd_options' in 'field list'

Error Number  : 1054

Request Date  : Saturday, June 27th 2009 @ 01:18:46 PM

Error Date    : Saturday, June 27th 2009 @ 01:18:46 PM

Getting the same thing

PHP Code:


			
Database error in vBulletin 3.8.3:



Invalid SQL:

UPDATE ravensfo_usergroup SET



### UPDATE QUERY GENERATED BY fetch_query_sql() ###

    `title` = 'Administrator/Owner',

    `description` = 'Owner of forum',

    `usertitle` = 'Owner',

    `opentag` = '<span style=\"color: red;\">',

    `closetag` = '</span>',

    `passwordexpires` = '180',

    `passwordhistory` = '360',

    `ispublicgroup` = '0',

    `canoverride` = '0',

    `credit_ibp_passcost` = '1',

    `credit_ibp_accesscost` = '0',

    `credit_ibp_discount` = '0',

    `credit_thanks_gain` = '100',

    `credit_thanks_lose` = '-10',

    `credit_thanks_give` = '5',

    `credit_thanks_take` = '-5',

    `fcpermissions` = '13',

    `ugphelpcenter` = '8191',

    `vbblog_general_permissions` = '524286',

    `vbblog_customblocks` = '5',

    `vbblog_custompages` = '5',

    `vbblog_entry_permissions` = '24575',

    `vbblog_comment_permissions` = '2014',

    `creditpermissions` = '628',

    `credit_induction` = '200',

    `credit_referral` = '100',

    `credit_refbonus` = '0',

    `credit_paycheck` = '100',

    `credit_active` = '100',

    `credit_birthday` = '100',

    `credit_repgive` = '10',

    `credit_reputation` = '15',

    `credit_infraction` = '-10',

    `credit_thread` = '50',

    `credit_threadrate` = '10',

    `credit_post` = '1',

    `credit_ownthreadpost` = '3',

    `credit_postsize` = '1',

    `credit_ownthreadview` = '1',

    `credit_ownthreadrate` = '1',

    `credit_ownthreadreply` = '2',

    `credit_ownprofileview` = '10',

    `credit_pollmake` = '10',

    `credit_pollvote` = '3',

    `credit_attachment` = '100',

    `credit_sendpm` = '0',

    `credit_addevent` = '3',

    `credit_addprofpic` = '0',

    `credit_profile` = '0',

    `credit_donmaxuser` = '-1',

    `credit_pastotpost` = '-1',

    `credit_pastotuser` = '-1',

    `credit_pasawuser` = '-1',

    `credit_pasawthread` = '-1',

    `credit_saveint` = '0.1',

    `credit_maxsave` = '-1',

    `credit_loanint` = '0.195',

    `credit_maxloan` = '1000',

    `credit_totloan` = '5',

    `credit_goodgroup` = '0',

    `credit_midgroup` = '0',

    `credit_badgroup` = '0',

    `credit_maxtickets` = '10',

    `credit_lotdiscount` = '0',

    `forumpermissions` = '16777215',

    `genericpermissions` = '2147483647',

    `attachlimit` = '0',

    `psiwd_options` = '1',

    `pmquota` = '5000',

    `pmpermissions` = '7',

    `pmsendmax` = '5',

    `pmthrottlequantity` = '100',

    `calendarpermissions` = '63',

    `wolpermissions` = '31',

    `adminpermissions` = '3',

    `genericpermissions2` = '1',

    `genericoptions` = '63',

    `profilepicmaxwidth` = '500',

    `profilepicmaxheight` = '500',

    `profilepicmaxsize` = '1000000000',

    `avatarmaxwidth` = '250',

    `avatarmaxheight` = '250',

    `avatarmaxsize` = '2000000000',

    `signaturepermissions` = '245759',

    `sigpicmaxwidth` = '700',

    `sigpicmaxheight` = '700',

    `sigpicmaxsize` = '1000000',

    `sigmaxrawchars` = '0',

    `sigmaxchars` = '0',

    `sigmaxlines` = '0',

    `sigmaxsizebbcode` = '7',

    `sigmaximages` = '5',

    `albumpermissions` = '255',

    `albumpicmaxwidth` = '700',

    `albumpicmaxheight` = '700',

    `albumpicmaxsize` = '1000000',

    `albummaxpics` = '110',

    `albummaxsize` = '0',

    `usercsspermissions` = '63',

    `visitormessagepermissions` = '63',

    `socialgrouppermissions` = '65535',

    `maximumsocialgroups` = '5',

    `groupiconmaxsize` = '1000000000',

    `awardpermissions` = '1',

    `op_user_html_markup_permissions` = '2047',

    `sk_hiddenpermissions` = '1',

    `trgpermissions` = '15',

    `trmperms` = '15',

    `radiotvpermissions` = '2047',

    `unreq_perms` = '3'

WHERE usergroupid=13;



MySQL Error   : Unknown column 'psiwd_options' in 'field list'

Error Number  : 1054

Request Date  : Saturday, June 27th 2009 @ 12:33:46 PM

Error Date    : Saturday, June 27th 2009 @ 12:33:46 PM

Script        : http://ravensforums.com/forums/admincp/usergroup.php?do=update

Referrer      : http://ravensforums.com/forums/admincp/usergroup.php?do=edit&usergroupid=13

IP Address    : 76.11.135.45

Username      : Jeff

Classname     : vB_Database

MySQL Version : 5.1.30

Paul M · #7 06-27-2009, 05:00 PM

The version in the xml is 1.1.0

The install code for the database updates this mod requires is set to 9.9.9 - so Im pretty sure it will not be run, hence the database errors.

akanevsky · #8 06-27-2009, 05:47 PM

Quote:

Originally Posted by Paul M

The version in the xml is 1.1.0

The install code for the database updates this mod requires is set to 9.9.9 - so Im pretty sure it will not be run, hence the database errors.

That's not true. I do this on all my mods and it works. That's just another way of saying '*'. However, there is a syntax error in the installation code, hence why the product does not work. I will fix that shortly.

EDIT: Released version 1.1.1.

Paul M · #9 06-27-2009, 06:17 PM

Quote:

Originally Posted by Psionic Vision

That's not true. I do this on all my mods and it works. That's just another way of saying '*'.

Fair enough, didnt know that - why not just put "*" more obvious then.

Strange tho - why are you running the database install/update code everytime ?

ctrlbrk · #10 06-27-2009, 06:36 PM

Thanks Psionic Vision!

Tagged, this looks promising! Waiting for others to work out the bugs

Mike

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08643 seconds Memory Usage 2,434KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (10)post_thanks_box (1)post_thanks_box_bit (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (10)post_thanks_postbit_info (9)postbit (3)postbit_attachment (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

Благодарность от:
mohammadxxx

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!