vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Mark User As Contributor V 2.0 Multi Tier (https://vborg.vbsupport.ru/showthread.php?t=33441)

SaintDog 01-24-2002 10:59 AM

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:

Code:

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 02-08-2002 10:47 AM

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,displayorderVALUES (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,displayorderVALUES (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 02-13-2002 02:57 PM

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 02-25-2002 05:03 AM

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 03-05-2002 12:33 AM

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 03-24-2002 08:07 PM

doesnt look like it works on 2.2.4

everytime i mark a user as a contributor i get:

PHP Code:

mysql errorUnknown column 'showdonation' in 'field list'

mysql error number1054

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 04-01-2002 11:59 AM

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 01-16-2003 05:47 AM

[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 01-16-2003 08:14 AM

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 01-23-2003 08:26 PM

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

darkmaninc 01-23-2003 08:27 PM

i followed the instruction you have at the end here GCPrez and now it gives me that error ? what to do now ?

darkmaninc 01-23-2003 08:32 PM

n/m i got it working doh... forgot to put the settinggroupid in all of them lol :)

darkmaninc 01-23-2003 09:14 PM

geez i can't find this in admin/functions.php
if ($bbuserinfo[adminemail]) {
$allowmailchecked="checked";
$allowmailnotchecked="";
} else {
$allowmailchecked="";
$allowmailnotchecked="checked";
}
also can't find this
$nosessionhash=iif($nosessionhash=="yes",1,0);

I'm using vBulletin 2.2.8 btw :)

darkmaninc 01-23-2003 10:23 PM

ok i've got it working now but here's the problem whatever i set the bronze , silver , gold, platinum settings to they won't show
what's up with that ? but if i set one at 0 it will show then
so what's up with that ?

darkmaninc 01-23-2003 10:32 PM

doh i got it all working now great hack... forgot to set the amount user had donated to get it to show lol

GunsNetwork 05-04-2003 06:24 PM

It seems all my members are showing platinum status.

What varibale is wrong here?

Something is out of whack.

GunsNetwork 05-04-2003 10:56 PM

Nevermind I figured it out.

Thanks

Bison 07-24-2003 01:29 PM

I know I have this thing setup correctly, I have people setup as "gold contributors" but they all come up as "platinmun" ... who's gotta fix for this? :ogre:

Using
Vbulletin 2.30

Bison 07-28-2003 04:55 PM

^^Bump^^

Takamine334 11-27-2004 01:21 AM

Fatal error: Call to undefined function: cpheader() in /www/g/groove_salad/htdocs/BitTorrent/admincp/contribute.php on line 4

I guess this doesn't work for 3.0.3

MTVSlick 02-24-2007 01:38 PM

[QUOTE=Takamine334;576470]Fatal error: Call to undefined function: cpheader() in /www/g/groove_salad/htdocs/BitTorrent/admincp/contribute.php on line 4


I guess this doesn't work for 3.0.3


All times are GMT. The time now is 04:16 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01300 seconds
  • Memory Usage 1,773KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (5)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (21)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete