Hi
You have (3) options, (1) add a column to the user table, (2) add a new table that is cleaned out everyday that will hold the counter or (3) add a hidden user profile field and set the default value to what you want to allow for downloads!
option (1) would add 1 query for each download request, but if you need to upgrade or try to install a back up of your forum you will have to remove/reinstall that column!
option (2) would add 2 queries for each download request (SELECT/UPDATE) but if you need to reinstall a backup it will not cause you any problem
option (3) uses the same logic as option (1)!
The reason why I explained the options, is that I always try to add mods without having to alter the database to the level that it will cause more hassle later on!
Then you will need to do (2) template edits, (3) script edits, if you want to add this as a option in the Admin Panel (Attachments), or (1) script edit if you just want to hardcode the download limit!
Tell what way you want to do it, and I will show you how!
Note: If the user is over their limit, then the download links will also not be shown in the postbit! This saves having to show them a error message when they are over their limit. If someone tries to direct link to a attachment and are over the limit they will get the error message!
Sonia
|