Mark User As Contributor V 2.0 Multi Tier

This is a modification of MarkB's Mark User As Contributor hack. It allows for 4 different tiers of Contributors based on what you set for donation limits for each tier.

It also allows the user to have the option of being listed as a "contributor" and not be listed in the various levels. Some of my users are happy to show that they support the site, but know their wife/husband won't be happy if they saw they were a platinum donator and such

Updated 1/13 To fix bugs in install file once again

[SaintDog]

If you have the time, is there a way you can just post what we need to do w/o using the installer file? I could do it manually if needed over using the installer file, just need to make sure that I am doing it right.

--------------------

I will give you one bit of feedback that I don't think anyone else has mentioned. In the installed file, once you click install, the error page pops up.

Well, the error is due to the fact that you are not placing data into all the fields (see below):

You are asking it to use the below fields:

settingid
settinggroupid
title
varname
value
description
optioncode
displayorder

Yet you do not use all of those to insert data into, you only use 7 of the 8 fields and it is causing a data error. You are using the below:

NULL,'Bronze Donator','bronze','10','How much of a donation is required to be a bronze level contributor','','1'

I think that is your problem right there, you need to specify what goes in the 8th field that you left out.

That is what the problem is from my point and after viewing it and the error, I think that is the problem.

[kreftt]

thats right.

take a look into your settinggroup table

write down the settingroupid for the donation, in my case 41.

so i change the sql query from

PHP Code:

INSERT INTO setting (settingid,settinggroupid,title,varname,value,description,optioncode,displayorder) VALUES (NULL,'Bronze Donator','bronze','10','How much of a donation is required to be a bronze level contributor','','1') 


to

PHP Code:

INSERT INTO setting (settingid,settinggroupid,title,varname,value,description,optioncode,displayorder) VALUES (NULL,'41','Bronze Donator','bronze','10','How much of a donation is required to be a bronze level contributor','','1') 


this worked for me. simply exchange the 41 in the example with your matching settinggroupid.

kreftt

[maverick1236]

could someone give me text files for these templates?

getinfo_bdonation, getinfo_donation, getinfo_gdonation, getinfo_pdonation, getinfo_sdonation

it would be a big help-tx!!!!!!!!!

[streamzone]

hmm..i am having problems that i just cant figure out with this one. using 2.2.1 and i get this error:

"Invalid SQL: ALTER TABLE `user` CHANGE `donator` SMALLINT UNSIGNED NOT NULL
mysql error: You have an error in your SQL syntax near 'SMALLINT UNSIGNED NOT NULL' at line 1"

i just cant figure it out. any suggestions?

[Lucky]

So does this work in 2.2.2?

There is a lot of confusion in this thread. Can someone please clarify that the installer infact works, and if not can someone post the text files needed to manually install.

TIA

[vertex]

doesnt look like it works on 2.2.4

everytime i mark a user as a contributor i get:

PHP Code:

mysql error: Unknown column 'showdonation' in 'field list'

mysql error number: 1054

Date: Sunday 24th of March 2002 03:59:55 PM
Script: [url]http://www.somethingleet.com/admin/user.php[/url]
Referer: [url]http://www.somethingleet.com/admin/user.php?s=&action=edit&userid=131[/url] 


[vertex]

crappiest hack ever since it totally ****ed up our cookies, it replaced browse board with cookies which we need to keep user's logged in.

[GCPrez]

[QUOTE]Originally posted by masood


Looks like you have similar problem

This involves two MySQL tables, 'settinggroup' and 'setting'. If you browse the 'settinggroup' table (through phpMyAdmin etc.) look for the 'settinggroupid' value corresponding to the "Donator" - should be the last row in this table if you have not installed another hack involving change of this table...

Now this 'settinggroupid' value must match with the 'settinggroupid' in 'setting' table (where corresponding options are defined). If you browse 'setting' table, you can look for Silver, Bronze and Gold rows at the end.

In my case these values did not match, so I could not see the options under Donator in control panel options. I just edited those rows in 'setting' table and bingo!

[GCPrez]

I finally figured it out! :dead:

Here's what I did to work around it...

Run the install, then Login to MySQL and locate your settinggroupid for the Donations block. Since 'contribute.php' tries to install a duplicate of this, it stops and doesn't finish the install.

Take the ID and change all the VALUES in 'contribute.php' file like this:

PHP Code:

[PHP]$DB_site->query("INSERT INTO setting (settingid,settinggroupid,title,varname,value,description,optioncode,displayorder) VALUES (NULL,'Bronze Donator','bronze','10','How much of a donation is required to be a bronze level contributor','','1')"); 


[/PHP]

to:

PHP Code:

$DB_site->query("INSERT INTO setting (settingid,settinggroupid,title,varname,value,description,optioncode,displayorder) VALUES (NULL,'32','Bronze Donator','bronze','10','How much of a donation is required to be a bronze level contributor','','1')"); 


* '32' = (your id)

rerun the install but you might get the same error so you may want to try the upgrade so that it can finish the install.

Because of this, you may now have duplicates blocks setup...just delete them and now it all should be working.

[darkmaninc]

i've tried to do this and this is what i now get
Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,'Silver Donator','silver','25','How much of a donation is required to be a silver level contributor','','2')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136