vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Paypal Donations for vBulletin 3.0.7 (https://vborg.vbsupport.ru/showthread.php?t=82978)

b00k 07-19-2005 12:39 PM

**NOTE RESOLVED**
edited the profile.php of root as well as some template entries. :ermm:

Just couldnt get this to work correctly. So i ran the unintall and now ive ran into a problem.

Quote:

Invalid SQL:
UPDATE user SET
styleid = 2,
showvbcode = 1,
pmpopup = 0,
maxposts = -1,
daysprune = 0,
timezoneoffset = '-5',
startofweek = 1,
languageid = 0,
threadedmode = 0,
autosubscribe = 1,
showdonor = 0,
options = 2263
WHERE userid = 1

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

mysql error number: 1054
This occurs when i try to change my Forum Skin from the edit options feature, however if i use the Quick Style Chooser no problems.

Can someone please advise me of how to correct this. Thank you.

Cloudrunner 07-20-2005 04:03 PM

Remove the columns Donor and Showdonor respectively from the user table. Any idea what occurred?

Cloudrunner 07-20-2005 04:04 PM

Quote:

Originally Posted by mkdevo
cloud - not sure if you saw this before... ^^

All PSDs of the images that we've created are included, the trophies are borrowed from somewhere, I don't even know where, so they are not included, because I don't have em. Sorry

cmiller1014 07-21-2005 09:45 PM

Can you manually enter info for people who have donated like the 3.5 version?

Cloudrunner 07-22-2005 12:14 AM

Quote:

Originally Posted by cmiller1014
Can you manually enter info for people who have donated like the 3.5 version?

yep.

trancetopia 07-22-2005 07:46 PM

This is one hell of a great hack..

I have found a little problem, maybe a bug.

When vieweing the posts, the donate_donor.gif image only appear for the last person entered in the donator table and does not appear for any of the others.

I have only three donators and added these manually via the admin if this makes any difference.

Hope you can help.

Thanks,
Paul

Cloudrunner 07-22-2005 09:05 PM

Quote:

Originally Posted by trancetopia
This is one hell of a great hack..

I have found a little problem, maybe a bug.

When vieweing the posts, the donate_donor.gif image only appear for the last person entered in the donator table and does not appear for any of the others.

I have only three donators and added these manually via the admin if this makes any difference.

Hope you can help.

Thanks,
Paul

check your user table to see if those three members have the showdonor column set to 1, if the users have set their status to showdonor=0 then it will not show. To show that image, the usertable needs to have set BOTH donor=1 and showdonor=1, if either of these are '0', then nothing will show.

check that and then let me know wht you come up with.

cmiller1014 07-23-2005 12:21 AM

Agreed, great hack. Ive got it installed and working great!

trancetopia 07-23-2005 08:01 AM

Quote:

Originally Posted by Cloudrunner
check your user table to see if those three members have the showdonor column set to 1, if the users have set their status to showdonor=0 then it will not show. To show that image, the usertable needs to have set BOTH donor=1 and showdonor=1, if either of these are '0', then nothing will show.

check that and then let me know wht you come up with.

Hi Cloudrunner,

I just check both the doner and showdoner columns for these members and they are all flagged as 'True'.

Is there anything else you need me to check?

Thanks,
Paul

Mith 07-23-2005 03:54 PM

Hi I'm having a problem accessing modules.php, i get the following error


Fatal error: Call to a member function on a non-object in /usr/local/psa/home/vhosts/****.com/http/forums/donate.php on line 14

line 14 says this:
Code:

$query_users = $DB_site->query("SELECT donor.userid, donor.total, user.username, user.showdonor
I can't see a table called donor anywhere.. is that related? (i have a vb3_user but no vb3_donor)

Also the VBACMPS module doesn't show correctly.. how would i set that up from scratch? (using 2.0 vba cmps)
Any help appreciated.


All times are GMT. The time now is 05:08 PM.

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.01587 seconds
  • Memory Usage 1,745KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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