New Posting Features - Download Credit System

Author: tnguy3n (Thinh Nguyen)
Live Demo: http://www.all4actions.net
Description:
This hack allows admin to set a specific amount of credit required to download each attachment. Admin can assign which forums this hack to take effect, excluding usergroups not to be restricted by it, resetting user's credit ...
Users can earn credits by making threads/replies, or sharing their files (upload). This hack may become handy in some ways, it forces members on your board to post more to earn credits, also to prevent leechers.
Default settings of of Download Credit System is off. Go to Admincp -> vBulletin Options -> Download Credit System to activate it.

VERSION v.1.1 is newest release. If you installed previous version, please reverse it (actually, just 3 files: includes/functions_newpost.php, attachment.php, newattachment.php), then re-install new one.

Features:
- Ability to reset users credits
- Exceptional Groups
- Credit System Applied To Specific Forums
- Credits Per Post
- Credit Per Thread
- Credit Per Attachment
- Download Cost (users download their own attachments at no cost)
- Pet Owning Cost **

Planned features: (next release)
- ucash/ushop integration
- paypal integration

Queries (run installer http://yoursite/forum/admincp/credit..._installer.php)
File Modification: 4
Template mod: 2
Installation Time: 3-5 mins
Tested in vb 3.0.3 -> 3.0.7

Pls click INSTALL button if you use it.

[Skyline_GT]

Originally Posted by MarcoH64

You must be running a hack that has modified your setting table then.

I wonde what can I do?

[Marco van Herwaarden]

What MySQL version are you running?

[Skyline_GT]

4.0.23-standard

[Marco van Herwaarden]

Could you post which fields are in your setting table?

[Skyline_GT]

settingid settinggroupid title varname value description optioncode displayorder grouptitle defaultvalue advanced volatile

if you mean fields in the setting table.

[Marco van Herwaarden]

Yes this is what i mean.

The first 3 fields are NOT standard vB fields. They have been added by you or some hack that you have installed, and are the cause of this problem. I am afraid that this modification to the table will be causing you a lot of problems. Anyway you can figure out where these fields come from, and what they are used for?

[Skyline_GT]

arg.... this is not good.. I wonder is it possible to make it work for my table?

[Skyline_GT]

also, they have nothing there.
the title colume are all blank and the settinggroupid are all 0 and the settingid starts from 3154 to 3984

[Wential]

Great job Tnguy3n! I just installed this and it's exactly what I needed to encourage posting. Big favor though? Is there any way to integrate this with PhotoPost to subtract credits when someone views a file and adds credits when they upload? I would willingly compensate you for this add-on, just PM me the details.

[Wential]

I got the credit system to remove credits for PhotoPost showphoto. I'll show you what I did and you guys can perfect it. My version only removes 1 credit per photo/file view.

In ShowPhoto.php find

// end pages/nav ###

Add the following after it (on mine it's line 948)

PHP Code:

// Begin credit download reduction
{
                                $DB_site->query_first("UPDATE vb3_user
                                        SET credits = credits - 1
                                        WHERE userid = $bbuserinfo[userid]
                                ");
                        }
// End credit download reduction