The Arcive of 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, 02:24 PM

First Post Reserved.

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

I Will Try Thank You

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

Nice, thanks.

saadessa · #5 06-27-2009, 03: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, 03: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, 04: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, 04: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, 05: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, 05:36 PM

Thanks Psionic Vision!

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

Mike

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