Paypal Donations for vBulletin 3.0.7

[Cloudrunner]

Due to real life I have ended support of this hack. Please see licensing information below.

Please read the troubleshooting tips below before asking for support.

********************************

Paypal Donations for vBulletin 3.0.7

Hack Provided and coded by )O( Cloudrunner )O( (https://vborg.vbsupport.ru/member.php?u=34914) of The Noble Pagan (http://www.noblepagan.com).

Release version: 1.07
Release Date: 28 June 2005

ChangeLog:
Paypal Donations 1.08



Simple file changes.
fixed problem in template edits.Paypal Donations 1.07

Squashed an uninstaller bug that was plaguing many folks with a bad explode command.
Attempted an adjustment in the graph image maker file pp_image.php
Two Templates require revert for this fix:
donations_goal_bits (required)
adv_portal_donate_goals (required only if you have installed the vBadvance CMPS Module)
Fixed the graph bar color settings to show whether or not you installed the CMPS module.Paypal Donations 1.06




Fixed small bug that displayed all users as donors regardless of their actual donor status.
Repaired typo in AdminCPPaypal Donations 1.05
Fixed phrasing that showed up as loads of '\r\n' on the on the pages.
Added all donors page to system to show all donors
Added functionality so that shy users can hide their donor status from public view
Fixed a division by zero error that shows when a goal is assigned without a goal amount.Paypal Donations 1.04

Fixed bug with the AdminCP that did not allow the user avatars to be displayed when viewing all donors.
Redid templates so that the currency sign changes automagickally to the chosen base currency.
Fixed an error on the installer that placed a dupe entry preventing further installation progress.
Redid installer for ease of updating the system when needed.Paypal Donations 1.03
Fixed bug where on installation the currency exchanges were not being populated properly.
Changed user list on donor add in AdminCP to be sorted alphabetically
Fixed Avatar display for custom avatars in the AdminCP
Fixed short hand INSERTs in the installer. Should work with all versions of DB schemas now.
Special Thanks:
dsboyce8624 (https://vborg.vbsupport.ru/member.php?u=83002)
SLeeeper (https://vborg.vbsupport.ru/member.php?u=85370)
And all of the Alpha Testers that helped out with this Hack!

I couldn't have done it without you.


What it does

Quite simply this hack provides you a way to receive donations from your website's users and provide them with the recognition deserving of a donating member of you community. It uses Paypal exclusively because of Paypal's "Instant Payment Notification" system.

The basics are this:



Your users go to your donations page where you have certain levels of donations available via hyperlinked "buttons".
These buttons take your user to paypal's secure payment processing system where they pay you your donation.
Once payment has been received, paypal sends your server a notification containing certain information pertaining to that specific transaction.
Your server then repeats this information to the verification server (which is hardcoded into the system so that *spoofing* is rendered virtually impossible) which first checks to see if the information was sent by it, then checks the validity of the information.
If everything checks out, it then sends your server a response of "VERIFIED".
When this hack see that word after running the script it inserts all the information into your database so that you can see what was donated, who donated it, and where.
If the server returns a response of "INVALID" then this script drops the information into a separate table so that you can investigate the transaction further to detect fraud attempts.
It also does this on any suspicious entries after a few checks.
Once payment is verified and information has been inserted into the tables, the system then adds a few toys and items for the user to be recognized as a donating user.
What you do with that recognition is up to you. Features




You as the admin have the ability to show as little or as much as you want about what happens with your donations.
Your users will only see what you want them to see.
You can show your donation goals to the public.
Automatic updates EVERY time a user donates or retracts a donation.
This can be run in "dummy" test mode using Paypal's Sandbox site for testing purposes before you go live with it.
Your members who have donated are recognized for doing so in their profile and their postbit.
Your shy users have the ability to hide their donation status from public view in their profile options
vBadvanced CMPS Module Integrated
You can set Goals and have donations count for or against a specific goal
Multiple Currencies are supported automatically and use TODAY's exchange rate to make the donation (vB Cron Enabled)
Everything is controllable in the AdminCP
User-side is 100% phrased
System completely ignores any transaction not placed by it (i.e. Ebay transactions and other PayPal transactions are not included in your transaction history (cuts down on DB bloat)).
Donate Button(s) PNG source provided (Image Credits go to SLeeeper, Thank you for the help!)
You do NOT need to have paypal's IPN pointing at the system. The system tells Paypal WHERE to send the IPN transactions :-}**Coming Soon**





Postbit Awards for certain levels of donations that you decide on
Donation / Donor CategoriesStuff you have to do

Files to upload: 34
Files to modify: 3
Templates to modify: 1 (required) / 2 (Optional)
Queries to run: (The install script does this for you, uninstallation is also provided as well)
Ease of install: easy, simply follow the instructions in the install script.
Time of install: ~5 minutes
***REMEMBER! Add your email address that Paypal has on file in Donations settings. This step is not an option, your payments, although they may be valid, will all be considered invalid if you do not do this! Sign up for Paypal's Premiere Account (Business), and setup IPN.


Paypal Registration

You will need to register with Paypal for a premiere account if you have not already, if you have, but your account is probably a personal account, you will need to upgrade the account to a premiere account. Assuming that you have a premiere account and have been verified, you then go into your profile at http://www.paypal.com and the select Instant Payment Notification. There will be a checkbox that you must check, you do NOT have to point to the script at Paypal, if you choose not to do this, then you will need to make sure that your Notification URL is put in the settings or this script will NOT WORK!

On most systems it will be either:http://www.yourdomain.com/ppverify.php
orhttp://www.yourdomain.com/forum/ppverify.php
That's all there is to setting up Paypal to work with your site!

Install

Upload all the files in the archive into their provided directories

Run the provided install file, setup your settings, after installation, DELETE THE FILE!

This will usually be:http://www.yourdomain.com/forum/admincp/donations_install.php
orhttp://www.yourdomain.com/admincp/donations_install.php
How To Use The System

To begin with, you simply upload all the files into their respective directories (keeping the structure in the archive).

After you upload the files, point your browser to the installation file: donations_install.php and run the installer all the way through, remembering to save your settings at the end (you MUST put in your paypal email, and the path to donate.php, and the path to ppverify.php). Remember, if you have the system set in test mode, you will not be able to process LIVE transactions. If you are going live immediately, then change this setting to no!
After you install, simply delete the donation_install folder and all files within it, and the install file.

Now you are ready to play. The system is 100% phrased on the user viewable side, so you will need to edit some of the phrases to better suit your site, specifically the phrases titled:

your_donations_are_appreciated
all_donations_go_towards_furthering_goals
donation_used_to_further_mission

are the ones that I recommend redoing to suit your site.

After editing the phrases, next comes adding your donation buttons and goals.

Always add your goals first as the buttons can be attached to a specific goal so that the user gets credit for donating towards a specific goal (you can of course add a button that does not attach to a goal for a general coffer fund type of deal, but goals are the preferred method).

After adding a goal, you can then add a button to the site.

The settings for the buttons are self-explanatory for the most part, the only required input from you is the title, and the description of the button. Everything else will work fine without input.

The system defaults to use the USD currency. If you change this currency in the Donations settings, then to get the correct exchange pricing, you need to run the CRON file to update your Exchange Rates table.

To do this simply log into your AdminCP and then do the following:




Scroll down your navigation bar on the left and find the Scheduled tasks navigation group, open that up and click on "Scheduled Task Manager".
Find the CRON named "Donations Currency Exchange Quotes"
To the right of that you will find a button named "Run Now"
Click that button and wait until the system says Done.Once the system has reloaded the exchange rates using your new currency you are ready to go and start collecting donations.

From there, it's all fairly intuitive. The biggest thing to remember is that to use this hack you MUST have a paypal Business or Premiere account, and have turned IPN on in your Paypal profile. If you run into troubles with a transaction, make sure that you are not trying to verify a sandbox transaction with the live Paypal server and vice versa (the test setting). Secondly, this system will notify you of suspect transactions that Paypal refuses to validate. If you get an email stating that a transaction was invalid, it would suit you to investigate it to find out where the transaction came from and why it failed verification. If all is kosher you can add the donor to the AdminCP so that they get credit for the donation.

To assist in this you can edit an invalid transaction to show as valid if the transaction turns out to be kosher. The steps to this are as follows:

Make sure transaction is valid
Edit invalid transaction to show as valid
Edit goal and add that transaction amount to the total
Edit / Add donor (user) to the DB to give creditThis will get the transaction into your database properly and give credit everywhere it is needed for the system to read it properly.






After Install

You will need to add a link somewhere in your navigation system for vBulletin pointing your users to the donations page (if you installed the vBadvanced Module then you have a link on the home page, but you might want to add one in the nav bar as well), as well as setting up your paypal account to give IPN responses to you, you can do this in your Paypal Profile under Instant Payment Notification.

To play in PayPal's Sandbox you will need to be registered with their developer network and setup a few sandbox accounts to play with the sandbox properly. I have throughly tested the sandbox functionality, and it is working until they decide to change coding standards again.

Troubleshooting tips and procedures
Due to the multitude of possible break-points between Paypal and this script I must request that the following be followed before reequesting support on this system from this point forward:




Do some basic troubleshooting on your own first and see if you can find where the break happened. You might be able to fix it from that.
Check to see that you are not sending test transactions to the live Paypal Server (check your testing setting in AdminCP)
Verify that your custom variable is output as<input type="hidden" name="custom" value="donation:*userid*:*goalid*">
Make sure that you COMPLETED the install 100% (if you did not make it to the settings page at the end of the installation, then you did not complete the installation)
Make sure that you have done the two required file edits (you can go back into the installer to verify this)
If you had a donation made, but have not yet received notification at the script side of the house, then the transaction most likely went into the invalid transactions tables, check there if it is there, and you have verified the top three things above post here for support on this. There is a time lag in the invalid transaction notifications. If you receive an invalid transaction you will receive notification by email to the webmaster address in your vB settings. I need the following information in this circumstance:
A post of the contents of the invalid table with identifiable information removed (ie. transaction id, addresses, phone numbers, IP addresses etc.)
The address to your donate.php file
Whether your system is in test mode or live mode
For basic support problems, then I will need the address to your donate.php so that I can verify that your system is kicking out the proper information to send to paypal
Above all else, please try to be as specific as possible, "The system broke..." doesn't do me any good to assist in giving you support, "The system broke at line 58 with the following error" is much better, and I am much more willing to support your problem with this symptom.Lastly, if you have modified the base files in any way, I will NOT give support to this. The files are set in the way that they need to be to run under 90% of server installations. Any other installations that require files to be merged, etc., sorry but you are on yer own in that situation.


FYI: The Paypal Notification is completely seperate from the user being sent back to your site. Thus the reason that the ppverify.php file is NOT a function of donate.php.

How To Get vBadvanced CMPS v1 Module to work with vBadvance CMPS v2
Follow this link to aranthorn's (https://vborg.vbsupport.ru/member.php?u=56991) Instructions on how to get this to work.
https://vborg.vbsupport.ru/showpost.php?p=669033&postcount=231 (https://vborg.vbsupport.ru/showpost.php?p=669033&postcount=231)

Thank you aranthorn (https://vborg.vbsupport.ru/member.php?u=56991)!!!




********************************


I sincerely hope that you enjoy this hack, Please feel free to send feedback to tnp@noblepagan.com!

To view this in action head over to: http://damn.that-sucks.net or http://www.noblepagan.com

Thank you!

)O( Cloudrunner )O(

P.s. Anyone who feels the need to donate (http://www.noblepagan.com/forum/donate.php) to me (*hint hint*) feel free to do so, I won't stop you ;) (yeah, I'm as greedy as the next guy). In fact we are a non-profit organization over at The Noble Pagan, so your donation would be tax-deductible :D.

LICENSE:

As the original author of the Paypal Hacks for vBulletin 3.0.x and 3.5.x I give full authorization to modify, recode, compile and/or reverse engineer the paypal donation hacks to any and all fully licensed members of vBulletin.org. I also give permission to fully distribute any derivative works that are created due to this authorization without need of providing credit or other means of recompense.

I am releasing this authorization in the hopes that someone will be able to carry on the work that was begun.

[dsboyce8624]

Excellent!!!!

Had to be first man.

I changed a few templates for my own liking, but these are some good shots.

I also changed the colors on the bar.

[Marky]

Nice work...
Have you got any screenshots?

[Cloudrunner]

Nice work...
Have you got any screenshots?
Good lord, why is it in almost every release there's someone who asks for screenies within the first ten posts?

As requested, Screenies attached...

[dsboyce8624]

Good lord, why is it in almost every release there's someone who asks for screenies within the first ten posts?

Just kidding, I just released this boss, screenies are coming as soon as I can get em done. For now head over to http://damn.that-sucks.net for a look at the user side of things.

Yeah, and while yer there, register and donate a dollar, I could use the users AND the cash!!!!!

[Cloudrunner]

Yeah, and while yer there, register and donate a dollar, I could use the users AND the cash!!!!!
Greedy :P

[dsboyce8624]

Greedy :P

But honest!

[caimakale]

So I hate to be the first one with a problem, but here it is.

During install, I get to the third step when I encounter this error.

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=USD&format=CSV&dest=Get+Table&sel_list=): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=AUD&format=CSV&dest=Get+Table&sel_list=): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=CAD&format=CSV&dest=Get+Table&sel_list=): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=EUR&format=CSV&dest=Get+Table&sel_list=): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=GBP&format=CSV&dest=Get+Table&sel_list=): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=JPY&format=CSV&dest=Get+Table&sel_list=): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31


What could the problem be???

[Gottcha]

ok....i have a problem...tried to install and am getting database errors

Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO settinggroup VALUES ('donations', '2020', '1')
mysql error: Duplicate entry 'donations' for key 1

tried to uninstall and get the following errors:

Warning: main(./includes/adminfunctions_language.php): failed to open stream: No such file or directory in /home/fragtrad/public_html/forums/admincp/donation_install/donation_uninstall.php on line 15

Fatal error: main(): Failed opening required './includes/adminfunctions_language.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/fragtrad/public_html/forums/admincp/donation_install/donation_uninstall.php on line 15

[dsboyce8624]

Not being the guru here, sounds like a version issue?

[dsboyce8624]

ok....i have a problem...tried to install and am getting database errors

Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO settinggroup VALUES ('donations', '2020', '1')
mysql error: Duplicate entry 'donations' for key 1

tried to uninstall and get the following errors:

Warning: main(./includes/adminfunctions_language.php): failed to open stream: No such file or directory in /home/fragtrad/public_html/forums/admincp/donation_install/donation_uninstall.php on line 15

Fatal error: main(): Failed opening required './includes/adminfunctions_language.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/fragtrad/public_html/forums/admincp/donation_install/donation_uninstall.php on line 15

Is this your first install? If so do you have anything else that added a 'donations' value to your DB?

[Gottcha]

nothing that added a donation value to my site...

can ya tell me how to delete the value from my DB?

[dsboyce8624]

Did you run the install twice or hit refresh?

If you never installed it, as in you weren't a tester, I dunno how you could get that entry.

[Cloudrunner]

So I hate to be the first one with a problem, but here it is.

During install, I get to the third step when I encounter this error.

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=USD&format=CSV&dest=Get+Table&sel_list=): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=AUD&format=CSV&dest=Get+Table&sel_list=): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=CAD&format=CSV&dest=Get+Table&sel_list=): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=EUR&format=CSV&dest=Get+Table&sel_list=): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=GBP&format=CSV&dest=Get+Table&sel_list=): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=JPY&format=CSV&dest=Get+Table&sel_list=): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31


What could the problem be???
you have to be able to pass information back and forth from outside servers for this hack to run. If you run into this problem you will need to uninstall and get a server that will talk to other servers via HTTP properly.

[Cloudrunner]

nothing that added a donation value to my site...


can ya tell me how to delete the value from my DB?
Looking at that right now...gimme a minute.

[Gottcha]

when i first ran the install i ran the first option and it didnt work so i tried the second option and now i get that error....i went into my db and removed all donation tables i saw and when i run the install now i get:

Invalid SQL: UPDATE donation_currency_exchange SET `USD` = '1'
mysql error: Table 'fragtrad_fragtraders.donation_currency_exchange' doesn't exist

[Cloudrunner]

ok....i have a problem...tried to install and am getting database errors

Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO settinggroup VALUES ('donations', '2020', '1')
mysql error: Duplicate entry 'donations' for key 1

tried to uninstall and get the following errors:

Warning: main(./includes/adminfunctions_language.php): failed to open stream: No such file or directory in /home/fragtrad/public_html/forums/admincp/donation_install/donation_uninstall.php on line 15

Fatal error: main(): Failed opening required './includes/adminfunctions_language.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/fragtrad/public_html/forums/admincp/donation_install/donation_uninstall.php on line 15
The duplicate value is there only if you have something else installed in that column with the same name. There is only one line in the system that calls that specific query.

On the uninstall error, where did you place your donations_install.php file?

[Gottcha]

ok i got it all uninstalled and a fresh install seems to be going fine...gimme a minute or so to do the file edits.

[Cloudrunner]

The duplicate value is there only if you have something else installed in that column with the same name. There is only one line in the system that calls that specific query.

On the uninstall error, where did you place your donations_install.php file?
if you goof on an install with ANY hack that includes an installer you must first uninstall that hack then reinstall it using the correct option. period.

gimme me a minute to figure out your uninstall error before you try anything else please.

[dsboyce8624]

if you goof on an install with ANY hack that includes an installer you must first uninstall that hack then reinstall it using the correct option. period.

gimme me a minute to figure out your uninstall error before you try anything else please.

Too late.

I know all about the dangers of installing over an old install.

Yuck.

[Gottcha]

seems to be running fine .... great work

[Cloudrunner]

seems to be running fine .... great work
Aight folks, I've updated the zip file with what should be a better working installer. Made some adjustments to the require_once calls in the installer, all should be good now. Lemme know.

Again, if you have troubles installing on the CRON job installation noted previously that means that you cannot talk via HTTP from server to server, and therefore you lose alot of the functionality of this hack. Thus this hack is essentially unusable for you until you can get your server to talk to the other server that gives the exchange quotes daily. If you cannot do the CRON talk between servers, then the system will not work for you because that means that you will not be able to talk to the Paypal servers either. There's nothing that I can do about that in that case, that is between you and your server host.

[TTG]

Doesn't seem to like 3.0.6 :disappointed:

Database error in vBulletin 3.0.6:

Invalid SQL: ALTER TABLE language ADD phrasegroup_ppdonations MEDIUMTEXT NOT NULL ;
mysql error: Duplicate column name 'phrasegroup_ppdonations'

mysql error number: 1060

Date: Monday 13th of June 2005 01:27:56 AM
Script: http://www.**********/forum/admincp/donations_install.php
Referer: http://www.***********/forum/admincp/donations_install.php
Username: ********
IP Address: **.**.102.40

[Cloudrunner]

Doesn't seem to like 3.0.6 :disappointed:

Database error in vBulletin 3.0.6:

Invalid SQL: ALTER TABLE language ADD phrasegroup_ppdonations MEDIUMTEXT NOT NULL ;
mysql error: Duplicate column name 'phrasegroup_ppdonations'

mysql error number: 1060

Date: Monday 13th of June 2005 01:27:56 AM
Script: http://www.**********/forum/admincp/donations_install.php
Referer: http://www.***********/forum/admincp/donations_install.php
Username: ********
IP Address: **.**.102.40
Points at the title of the hack...

Paypal Donations for vBulletin 3.0.7

[TTG]

Points at the title of the hack...

Installed dozens of hacks supposed to be for 3.0.7 on 3.0.6 with NO problems

[Cloudrunner]

Installed dozens of hacks supposed to be for 3.0.7 on 3.0.6 with NO problems
you can try to uninstall to remove that line from the system and then attempt another install...That error comes from a failed attempt at adding the phrasegroup_ppdonations when it was already there. This is caused either by a failed install or by a previous install...if an install goofs folks you NEED to uninstall before you attempt a reinstall or you WILL get table errors...

[dsboyce8624]

I've installed this too many times over the last few days.

If you get a dupe msg that means you had a hosed install prior.

I learned this lesson the hard way.

[Cloudrunner]

I've installed this too many times over the last few days.

If you get a dupe msg that means you had a hosed install prior.

I learned this lesson the hard way.
I'm gonna fix that problem right now, didn't think I'd run into the problem on a fresh install with folks LOL.

Anyway, I'll get the dupe message on installs fixed and update shortly.

[dsboyce8624]

I'm gonna fix that problem right now, didn't think I'd run into the problem on a fresh install with folks LOL.

Anyway, I'll get the dupe message on installs fixed and update shortly.

Yer a push over. But I guess it'll save problems that could be avoided.

[Gottcha]

how can i add this as a sideblock......do i need vbadvanced to do it?

[dsboyce8624]

how can i add this as a sideblock......do i need vbadvanced to do it?

That'd be the best way, it has the module built in.

Otherwise your gonna have to do some mods by hand.

[Cloudrunner]

how can i add this as a sideblock......do i need vbadvanced to do it?
yes you need vBadvanced to get the sideblock.

[caimakale]

Out of curiosity, how does the way this pulls data from another website differ from my sports or weather module pulling data from a site? I am trying to trouble shoot why I can't get this data to download into my database. I am wondering if that's the problem, or if my webhost is blocking needed ports.

[Cloudrunner]

Out of curiosity, how does the way this pulls data from another website differ from my sports or weather module pulling data from a site? I am trying to trouble shoot why I can't get this data to download into my database. I am wondering if that's the problem, or if my webhost is blocking needed ports.
The cronjob add is a two fold system, during install it tells you whether or not you will be able to use this hack because it pulls the data in the same way that PayPal talks to your server, through port 80 HTTP calls. If it fails, you cannot use the system because Paypal will not be able to talk to your server at all. The second function is during actual use, it updated the exchange rates for the system daily so that should you use the exchanges they are calculated properly for that day.

If the cronjob cannot talk via port 80 via standard HTTP calls, then paypal's verification servers will not be able to talk to your server either, effectively nullifying your ability to use this system.

I wish there was something that I could do to fix that, but alas, I cannot.

[dsboyce8624]

I wish there was something that I could do to fix that, but alas, I cannot.

Man, I thought you could do anything.

[dsboyce8624]

yes you need vBadvanced to get the sideblock.

Well, you could hobble something together yourself, but it'd be way more work, vBadvanced is about a 10 minute install then a whole new world of things to add on.

I'm just about out of things to add on. I have every hack on this site that was remotely useful installed, about 65 of them.

I'm gonna get bored now.

[Cloudrunner]

Hey folks, just a quick note to let you know that if you have been running into errors on install or uninstall, I've created the fix, and updated the zip file here on vb.org.

Just overwrite everything if you are having problems and then uninstall and then install again.

Yes, this should even work for 3.0.6 as well...but I don't know.

Anyway, this should fix all the problems we've had with the initial release of this.

For those problems I apologize, I really didn't plan for those issues because we didn't run into them across the four servers we played with this on.

Forgive me, anyway, please let me know if there are any more problems with this release!

[dsboyce8624]

Now see, if I was really a jerk, I'd ask what a "quick not" was.

<Dennis runs off laughing hysterically>

I promise, I'm completely sober, just in a really good mood.

[Cloudrunner]

Now see, if I was really a jerk, I'd ask what a "quick not" was.

<Dennis runs off laughing hysterically>

I promise, I'm completely sober, just in a really good mood.picky brat LOL

[dsboyce8624]

picky brat LOL

Yeah, but in this situation, picky is what ya need.

[VViper]

This is really good stuff but how do your users actually donate?
I click on the $ button it takes me to the donations page and shows goals and the PAYPAL logo but how do thet actually start a donation process.

I worked it out,
You actually go to Admincp and make a button.
Then they can click on it and make a donation.
Hope this helps someone else.

[Cloudrunner]

This is really good stuff but how do your users actually donate?
I click on the $ button it takes me to the donations page and shows goals and the PAYPAL logo but how do thet actually start a donation process.
by clicking the donation button on the donate page.

the ones you must add in the AdminCP.

[Cloudrunner]

This is really good stuff but how do your users actually donate?
I click on the $ button it takes me to the donations page and shows goals and the PAYPAL logo but how do thet actually start a donation process.

I worked it out,
You actually go to Admincp and make a button.
Then they can click on it and make a donation.
Hope this helps someone else.
I do believe I put that in the notes at in the first post about this system here....I could be wrong though...*goes to look to make sure it's there...yep it's there...*

[dsboyce8624]

I do believe I put that in the notes at in the first post about this system here....I could be wrong though...*goes to look to make sure it's there...yep it's there...*

Now whos the smart ass?

ROFL

[Cloudrunner]

Now whos the smart ass?

ROFL
I'm gonna go with....

ME!

:-P

I'm just playin anyway, you think someone might take offense at that? I hope not...

Oh, for those of you who don't know me, I am opinionated. Some may call me an a$$hole at times, but I will try to fix any problem with this hack that I can, I promised to support it, but (seeing as how my philosophy on life is to say it bluntly) I will call things as I see them.

If I am wrong, I will admit it, but since I can take things with a grain of salt I expect others to do the same. If you find a problem somewhere tell me, and I'll fix it if I can. I expect the same from anyone who installs this as well. If I'm being a jerk, tell me and I'll adjust my shot group. Again, I expect the same from others as well.

Just letting you all know where I'm coming from so we on the same sheet of music here. Now, let's see how this thing works out shall we?

[KevinL]

Set up just fine! Very easy.

Great work guys :)

Silly question though, can I get paypal to open in a new window? You know...so they dont leave my site :laugh:

[dsboyce8624]

Wow, man, you got way serious.

I was just playing!

[dsboyce8624]

Set up just fine! Very easy.

Great work guys :)

Silly question though, can I get paypal to open in a new window? You know...so they dont leave my site :laugh:

You'd have to edit the vBa template to add a
target="_blank"
to the URL.

[Cloudrunner]

Set up just fine! Very easy.

Great work guys :)

Silly question though, can I get paypal to open in a new window? You know...so they dont leave my site :laugh:
if you do that, then the user will end up on your site twice after donating. Plus if they decide to cancel the transaction midway through it, they get returned in the same window, again, having two windows open.

The way the buttons work as well prevent this from happening to my knowledge, but I will check into it and see if there is a way to do that or not.

[Cloudrunner]

Wow, man, you got way serious.

I was just playing!
Nah not serious...just wanted to make sure peeps knew where I was coming from before I ended up pissing someone off LOL

[KevinL]

You'd have to edit the vBa template to add a
target="_blank"
to the URL.
ahhhhhh I was trying to do it in the donations_bits template.

Thanks!

[dsboyce8624]

Oh, I thought he wanted the Donate button to open donate.php in a diff window. But yeah either way, then you end up with two windows on the site since after paypal it returns you to the site.

[Cloudrunner]

You'd have to edit the vBa template to add a
target="_blank"
to the URL.
the button is created via a form tag <input type="button" etc....> I don't know if there is a way to make that open in a new window or not without breaking the system (onClick is already being used). If someone could correct me on this if I'm wrong, please do. I'm not well versed in Javascript.

[KevinL]

if you do that, then the user will end up on your site twice after donating. Plus if they decide to cancel the transaction midway through it, they get returned in the same window, again, having two windows open.

The way the buttons work as well prevent this from happening to my knowledge, but I will check into it and see if there is a way to do that or not.
okie dokie that works for me :)

Edit*

Thanks for the answers guys. Since it returns to the site then there is no reason for it. :)

[dsboyce8624]

Nah not serious...just wanted to make sure peeps knew where I was coming from before I ended up pissing someone off LOL

Listen, you've done this before, I'm a virgin.

I don't think if it were just me, I could handle all the questions at once, much less fix the problems.

So if they can't take a joke now and then . . . well, you know.

[Cloudrunner]

Set up just fine! Very easy.

Finally...sheesh...

LOL

With all the troubles that came up at first I thought this thing would die before it even had a chance ROFL

[dsboyce8624]

Na, just gotta get the steam up.

[TTG]

Yeah .. the crowds at the back 'o the bar go wild .. installed and working like a charm.
One question .. how can I change the $ to ? in the donation goals ?

Clicked install :)

[dsboyce8624]

Yeah .. the crowds at the back 'o the bar go wild .. installed and working like a charm.
One question .. how can I change the $ to ? in the donation goals ?

Clicked install :)

I believe it's in the phrases. One sec.

EDIT: in_donations_towards_our_goal_of is one, just have to weed through to find the rest, and some are in the templates.

[Cloudrunner]

Yeah .. the crowds at the back 'o the bar go wild .. installed and working like a charm.
One question .. how can I change the $ to ? in the donation goals ?

Clicked install :)
it's phrased, just change all the $ calls in the phrases and that should do it. Some are in the templates though...

If you see a variable like this: $$total with the double '$' that's the dollar sign, the second one is the string identifier, you can change that first one without breaking anything. Don't do that to a single '$' though as that will break the variable in the template.

Hope that helps....(thinks about adding this as an auto thing based on the currency format you choose in the AdminCP)...

[Cloudrunner]

yep, I think I'll do that, I like that idea alot...thank you!

[dsboyce8624]

yep, I think I'll do that, I like that idea alot...thank you!

You're welcome!

Dennis smells an upgrade.

[Cloudrunner]

You're welcome!

Dennis smells an upgrade.
* Cloudrunner quirks an eyebrow

you okay? Sniffing too much server innards today?

[dsboyce8624]

* Cloudrunner quirks an eyebrow

you okay? Sniffing too much server innards today?


You said thank you, I was just being polite.

[VViper]

I didnt take offence.

I tend to just scim over stuff when doing things.

Like anyone else.

It was there and i missed it.

Thanks for the quick reply though.

[Cloudrunner]

I didnt take offence.

I tend to just scim over stuff when doing things.

Like anyone else.

It was there and i missed it.

Thanks for the quick reply though.
no problem ;). I'm tired, so the $quick_replies = NULL; until tomorrow evening.

[dsboyce8624]

no problem ;). I'm tired, so the quick replies will be null until tomorrow evening.

Well, unless you count my quickly typed, but not so quick witted replies for a few more hours, and again in the mornin'.

:smoke:

[caimakale]

OK, I am back.

I am still having the problem pulling the exchange rate info. I do get an error on my donate.php page which I am guessing is because of this.

But get this, I have the mod installed perfectly except for that error, I have run several transactions with sandbox, and everything is working perfectly!!!

I think it has something to do with my server running cron jobs.

Are there any settings in the ACP that could be causing this???

[dsboyce8624]

OK, I am back.

I am still having the problem pulling the exchange rate info. I do get an error on my donate.php page which I am guessing is because of this.

But get this, I have the mod installed perfectly except for that error, I have run several transactions with sandbox, and everything is working perfectly!!!

I think it has something to do with my server running cron jobs.

Are there any settings in the ACP that could be causing this???

Show me the error.

[caimakale]

Warning: Division by zero in /modules/donate.php on line 33 is what is displayed on the CMPS page.

Warning: Division by zero in /donate.php on line 147
is on the donate.php page.

I am guessing it is a division by zero error because there aren't any values to pull from the database because I can't run that cron job.

[dsboyce8624]

Probably a good guess.

What do you get in the cron log if you run it manually?

[caimakale]

I get the exact same errors as before, and my database is still empty

[dsboyce8624]

These:

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=USD&format=CSV&dest=Get+Table&sel_list=): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

???

If so, try hitting the URL manually from your box.

What happens?

[caimakale]

Donations Currency Exchange Quotes


Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=USD&format=CSV&dest=Get+Table&sel_list=USD): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=AUD&format=CSV&dest=Get+Table&sel_list=USD): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=CAD&format=CSV&dest=Get+Table&sel_list=USD): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=EUR&format=CSV&dest=Get+Table&sel_list=USD): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=GBP&format=CSV&dest=Get+Table&sel_list=USD): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=JPY&format=CSV&dest=Get+Table&sel_list=USD): failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Done

[dsboyce8624]

See above post.

The second error, bad argument is due to not getting an answer from the first error.

Can you get to the site from you server?

You know you can also disable the exchange rate stuff in the settings on ACP.

[dsboyce8624]

Alright, this'll wait until tomorrow then, gotta hit the sack.

[caimakale]

Thanks, I don't have shell access on my server to try to access the site.

In the ACP the only option is to show the currency box or not, not to actually disable it. And even at that, I think it will still need a number for US dollars.

Get some sleep, I will keep plugging away at it.

[caimakale]

Can anybody who has installed this hack please dump the donation_currency_exchange table from your database and post it here?

I would like to update this and see if it takes care of my error messages.

Thanks

[guvner]

Can anybody who has installed this hack please dump the donation_currency_exchange table from your database and post it here?

I would like to update this and see if it takes care of my error messages.

Thankshere you go :)

[guvner]

Cloudrunner,

Great hack - had the challenge of a previous version haunting my DB, but your early revision fixed it up really well ! :)

A quick question, during the install, there were a couple of optional edits to the postbit and the memberinfo page - where can I find them without running through the install again (which obviously I can't do ;)) - I want to remove the postbit code until it's ready to run officially.

Great work and thank you!

Mike :)

[caimakale]

thanks guvner

[guvner]

LOL- now I'm adding existing donors to the DB - but it's gonna be a nightmare :cheeky:

Is there any way that the drop down box of members could be sorted alphabetically instead of by member no.?

My forum's not that big but I still have nearly 2,000 members and I have to add in over 120 donors - I'm going blind atm trying to find them in that long list :cry:

Also, a little bug - after a "donator is added, on the view donators page, I'm getting the dreaded red X for their avatar - it seems that the admincp has been added to to path to the call the avatar.

i.e. http://www.mysite.com/forum/admincp/image.php?u=52&dateline=1108213260 whereas the actual path is http://www.mysite.com/forum/image.php?u=52&dateline=1108213260

[caimakale]

I don't think you need to. As long as they are registered, it will pull their user # out of the database and put them as a donor.

I just did a test on my site, and the name I donated under, automatically showed up as one of the top donors without me having to add them.

[guvner]

Thanks but that's not what I mean - I'm trying to add in people who have already donated over $1,000, I can't leave them out of this once I go live.

[caimakale]

So I figured out my problem. I could have swore I entered a dollar amount into the goals field, in fact I know I did because when I went back to enter it again, it was the only thing that showed up in internet explorer's "auto complete" dropdown box. So I entered it again and all of my problems disappeared. I added the currency values to the database and everything is working great.

Now I need to figure out the cron job thing. There is a good chance I might get some European donations on my site and this would be a great feature to have. I emailed my webhosting company and I will update when I find a resolution to this problem.

[caimakale]

Thanks but that's not what I mean - I'm trying to add in people who have already donated over $1,000, I can't leave them out of this once I go live.

Yeah, it's probably not a good idea to leave those people out.

Could you send them my way? I could use some $1,000 donations ;)

[guvner]

Mmm - I've had to give up on manually adding them - it's just too difficult.

But I notice that apart from the top 3 - nothing else (amount collected & % of target etc.) is appearing on donate.php even after I've added them - could it be that manually added donations aren't being picked up?

[guvner]

A quick question, during the install, there were a couple of optional edits to the postbit and the memberinfo page - where can I find them without running through the install again (which obviously I can't do ;)) - I want to remove the postbit code until it's ready to run officially Forget this one - I just re-ran the installer's first page and got my answer ;)

[Marky]

Good lord, why is it in almost every release there's someone who asks for screenies within the first ten posts?

As requested, Screenies attached...

Im just curious...
Thanks for the screenies ;)

[artonex]

Hey Cloudrunner i am very greatful for this hack, i had been searching for this for a long time, and thanks for making it a 3.0.7 release, im gonna wait a while untill all bugs are ironed out and the Postbit Awards added. Then i will install this baby :D:D

[dsboyce8624]

Hey Cloudrunner i am very greatful for this hack, i had been searching for this for a long time, and thanks for making it a 3.0.7 release, im gonna wait a while untill all bugs are ironed out and the Postbit Awards added. Then i will install this baby :D:D

What bugs? :banana:

[dsboyce8624]

Well, I had my first real, didn't put it in by hand, donation.

Not only did it feel real good, it worked well.

[xfaethorx]

i manged to install this on one site with no problems

3.06 board as well using 1.02 . it installed with no problems into the vbadvanced in no time at all.

i tried to do it on a 3.07 board from a fresh install and i get the followin sql error, remember this is a fresh install here so i find it really odd that it sees a duplicate value :S

Invalid SQL: INSERT INTO template VALUES (NULL, '-1', 'adv_portal_donate', '<!-- Donations Block -->

<table align=\\\"center\\\" border=\\\"0\\\" cellpadding=\\\"$stylevar[cellpadding]\\\" cellspacing=\\\"$stylevar[cellspacing]\\\" class=\\\"tborder\\\" width=\\\"100%\\\">
<tr>
<td class=\\\"tcat\\\"><span class=\\\"smallfont\\\"><strong>$vba_options[portal_blockbullet] Donations</strong></span></td>
</tr>
$donate_goals_bits
<td class=\\\"$getbgrow\\\" align=\\\"center\\\">
Our Top $vboptions[donate_CMPS_users] Donors
<hr />
<table>
$donate_goals_userbits
</table>
</td>
</tr>
<tr>
<td class=\\\"$getbgrow\\\" align=\\\"center\\\">
<a href=\\\"$vboptions[bburl]/donate.php\\\"><img src=\\\"$stylevar[imgdir_button]/donate_button.gif\\\" border=\\\"0\\\"></a>
</td>
</tr>
</table>
<br />

<!-- End Donations Block -->', '<!-- Donations Block -->

<table align=\"center\" border=\"0\" cellpadding=\"$stylevar[cellpadding]\" cellspacing=\"$stylevar[cellspacing]\" class=\"tborder\" width=\"100%\">
<tr>
<td class=\"tcat\"><span class=\"smallfont\"><strong>$vba_options[portal_blockbullet] Donations</strong></span></td>
</tr>
$donate_goals_bits
<td class=\"$getbgrow\" align=\"center\">
Our Top $vboptions[donate_CMPS_users] Donors
<hr />
<table>
$donate_goals_userbits
</table>
</td>
</tr>
<tr>
<td class=\"$getbgrow\" align=\"center\">
<a href=\"$vboptions[bburl]/donate.php\"><img src=\"$stylevar[imgdir_button]/donate_button.gif\" border=\"0\"></a>
</td>
</tr>
</table>
<br />

<!-- End Donations Block -->', 'template', '1118691219', 'Cloudrunner', '3.0.7')
mysql error: Duplicate entry '-1-0' for key 2

so im stuck getting it to install into vbadvanced, need a bit of help.

[dsboyce8624]

Invalid SQL: INSERT INTO template VALUES (NULL, '-1', 'adv_portal_donate', '<!-- Donations Block -->


Did you have one of the other vBa Donation/PayPal modules installed?

I bet there are like 5 of them, it's possible one used the same name.

If you go into Style Manager does it show a template with that name?

I saw the fresh install part, but it's possible you added other hacks.

Just checking. Also, if you do find it in there, just delete it if it's not needed.

Then try again.

[xfaethorx]

hi thanks for the quick reply,

i dont actually have ANY other paypal hack installed on that board and i've been through the styles and theres nothing there. Now unless its a bork in this db im unsure.

i've tried installing it without using that module and i've hit the problem with calling out to the external website. What bothers me about that is that I can ping that server and i know it can route to it via a web browser but it doesn't seem to work which is odd as hell.

I have full control over that apache box though so if i need to change a setting just let me know what it is. :D

[Aerith_Freak]

Just to mention from earlier with a 3.0.6 error for duplicate phrases:

Database error in vBulletin 3.0.7:

Invalid SQL: ALTER TABLE language ADD phrasegroup_ppdonations MEDIUMTEXT NOT NULL ;
mysql error: Duplicate column name 'phrasegroup_ppdonations'

mysql error number: 1060

Date: Monday 13th of June 2005 09:01:58 PM
Script: http://localhost/dev/zelcom1_350b-end/admincp/donations_install.php
Referer: http://localhost/dev/zelcom1_350b-end/admincp/donations_install.php
Username: aerithfreak
IP Address: 127.0.0.1

Just got that on my localhost on a vB3.0.7 that I installed less than 5 minutes ago and this is the first time running the installer for this hack.

Oh and any plans for this to go onto 3.5.0 once it's released?


EDIT: I uninstalled and installed again, the problem persisted, uninstalled and installed again for a third time and now it works. Oh well, no complaining, as long as it works.

[xfaethorx]

just a quick question

http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=EUR&format=CSV&dest=Get+Table&sel_list=donations

thats the link it goes to and if i surf to it i get a server error from their site, thats not a 404 but an actual formatted error page on their site. could this be causing trouble?

additional:

it takes quite a while to transfer to the site as well so could it be timing out at the php level.

[xfaethorx]

i made a really i made a quick change to the code that checks to make sure its a valid donation link and not just 'donations' (just changed it to USD if it found donations in the link dunno if that will cause major problems later on but i can always revert the code back) any the hack continued to install. but i hit ANOTHER database error, remembering that i've run the uninstaller everytime its failed and it never got this far i get this error now.

Invalid SQL: INSERT INTO template VALUES (NULL, '-1', 'DONATIONS', '$stylevar[htmldoctype]
<html dir=\\\"$stylevar[textdirection]\\\" lang=\\\"$stylevar[languagecode]\\\">
<head>
<!-- no cache headers -->
<meta http-equiv=\\\"Pragma\\\" content=\\\"no-cache\\\" />
<meta http-equiv=\\\"Expires\\\" content=\\\"-1\\\" />
<meta http-equiv=\\\"Cache-Control\\\" content=\\\"no-cache\\\" />
<!-- end no cache headers -->
<title>$vboptions[bbtitle] -- Donations</title>
$headinclude
</head>
<body>
$header
$navbar

<!-- main -->
<table class=\\\"tborder\\\" cellpadding=\\\"$stylevar[cellpadding]\\\" cellspacing=\\\"$stylevar[cellspacing]\\\" border=\\\"0\\\" width=\\\"100%\\\" align=\\\"center\\\">
<thead>
<tr align=\\\"center\\\">
<td class=\\\"tcat\\\" colspan=\\\"3\\\">$vbphrase[how_to_donate]</td>
</tr>
<tr align=\\\"center\\\">
<td class=\\\"thead\\\" colspan=\\\"3\\\">
<span class=\\\"smallfont\\\">$vbphrase[processor_paypal]</span>
</td>
</tr>
</thead>
<tbody>
<tr align=\\\"center\\\">
$donationbits
</tr>
<tr>
<td class=\\\"tfoot\\\" colspan=\\\"3\\\">&nbsp;</td>
</tr>
</tbody>
</table>
<br />
<table border=\\\"0\\\" width=\\\"100%\\\">
<tr valign=\\\"top\\\">
\" . (($vboptions[\'showdonators\'] ==1) ? (\"
<td>
<table class=\\\"tborder\\\" cellpadding=\\\"$stylevar[cellpadding]\\\" cellspacing=\\\"$stylevar[cellspacing]\\\" border=\\\"0\\\" width=\\\"100%\\\" align=\\\"center\\\">
<thead>
<tr align=\\\"center\\\">
<td class=\\\"tcat\\\" colspan=\\\"3\\\">$vbphrase[top_donators]</td>
</tr>
<tr align=\\\"center\\\">
<td class=\\\"thead\\\" colspan=\\\"3\\\">$vbphrase[sorted_by_total_donation]</td>
</tr>
</thead>
<tbody>
<tr align=\\\"center\\\">
$topdonatorbits
</tr>
<tr>
<td class=\\\"tfoot\\\" colspan=\\\"3\\\">&nbsp;</td>
</tr>
</tbody>
</table>
</td>
\") : (\"\")).\"
<td>
\" . (($vboptions[\'showgoals\'] == 1) ? (\"
<table class=\\\"tborder\\\" cellpadding=\\\"$stylevar[cellpadding]\\\" cellspacing=\\\"$stylevar[cellspacing]\\\" border=\\\"0\\\" width=\\\"100%\\\" align=\\\"center\\\">
<thead>
<tr align=\\\"center\\\">
<td class=\\\"tcat\\\" colspan=\\\"2\\\">$vbphrase[our_donation_goals]</td>
</tr>
<tr align=\\\"center\\\">
<td class=\\\"thead\\\" colspan=\\\"2\\\">
$vbphrase[money_goes_towards_goals]<br />
\" . (($vboptions[\'showtotalcollected\'] == 1) ? (\"
\" . (($mc_total > 0) ? (\"
$vbphrase[we_have_collected] $$mc_total $vbphrase[since] $vboptions[donationstartdate]
\") : (\"
$vbphrase[we_have_not_collected]
\")).\"
\") : (\"\")).\"
</td>
</tr>
</thead>
<tbody>
<tr align=\\\"center\\\">
$donationgoalbits
</tr>
<tr>
<td class=\\\"tfoot\\\" colspan=\\\"2\\\">&nbsp;</td>
</tr>
</tbody>
</table>
<br />
\") : (\"\")).\"
<table class=\\\"tborder\\\" cellpadding=\\\"$stylevar[cellpadding]\\\" cellspacing=\\\"$stylevar[cellspacing]\\\" border=\\\"0\\\" width=\\\"100%\\\" align=\\\"center\\\">
<thead>
<tr align=\\\"center\\\">
<td class=\\\"tcat\\\">$vbphrase[your_donations_are_appreciated]</td>
</tr>
<tr align=\\\"center\\\">
<td class=\\\"thead\\\">$vbphrase[all_donations_go_towards_furthering_goals]</td>
</tr>
</thead>
<tbody>
<tr>
<td class=\\\"alt1\\\">
$vbphrase[donation_used_to_further_mission]
</td>
</tr>
\" . (($vboptions[\'501c3\'] == 1) ? (\"
<tr>
<td>
$vbphrase[non_profit]
<br />
$vbphrase[our_tax_id]
<br />
<center><strong>$vboptions[taxid]</strong></center>
</td>
</tr>
\") : (\"\")).\"
<tr>
<td class=\\\"tfoot\\\">&nbsp;</td>
</tr>
</tbody>
</table>
\" . (($vboptions[\'showverifiedseal\'] == 1) ? (\"
<br />
<table class=\\\"tborder\\\" cellpadding=\\\"$stylevar[cellpadding]\\\" cellspacing=\\\"$stylevar[cellspacing]\\\" border=\\\"0\\\" width=\\\"100%\\\" align=\\\"center\\\">
<thead>
<tr align=\\\"center\\\">
<td class=\\\"tcat\\\" colspan=\\\"3\\\">$vbphrase[paypal_verified]</td>
</tr>
</thead>
<tbody>
<tr align=\\\"center\\\">
<td class=\\\"alt1\\\" align=\\\"center\\\">
<a href=\\\"https://www.paypal.com/us/verified/pal=$vboptions[paypal_email]\\\" target=\\\"_blank\\\">
<img src=\\\"$stylevar[imgdir_misc]/paypal_verified.gif\\\" border=\\\"0\\\" alt=\\\"Official PayPal Seal\\\">
</a>
</td>
<td class=\\\"alt2\\\" align=\\\"center\\\" width=\\\"100%\\\">
$vbphrase[what_it_means_to_be_verified]
</td>
</tr>
<tr>
<td class=\\\"tfoot\\\" colspan=\\\"3\\\">&nbsp;</td>
</tr>
</tbody>
</table>
\") : (\"\")).\"
</td>
</tr>
</table>

<!-- /main -->

$footer
</body>
</html>', '$stylevar[htmldoctype]
<html dir=\"$stylevar[textdirection]\" lang=\"$stylevar[languagecode]\">
<head>
<!-- no cache headers -->
<meta http-equiv=\"Pragma\" content=\"no-cache\" />
<meta http-equiv=\"Expires\" content=\"-1\" />
<meta http-equiv=\"Cache-Control\" content=\"no-cache\" />
<!-- end no cache headers -->
<title>$vboptions[bbtitle] -- Donations</title>
$headinclude
</head>
<body>
$header
$navbar

<!-- main -->
<table class=\"tborder\" cellpadding=\"$stylevar[cellpadding]\" cellspacing=\"$stylevar[cellspacing]\" border=\"0\" width=\"100%\" align=\"center\">
<thead>
<tr align=\"center\">
<td class=\"tcat\" colspan=\"3\">$vbphrase[how_to_donate]</td>
</tr>
<tr align=\"center\">
<td class=\"thead\" colspan=\"3\">
<span class=\"smallfont\">$vbphrase[processor_paypal]</span>
</td>
</tr>
</thead>
<tbody>
<tr align=\"center\">
$donationbits
</tr>
<tr>
<td class=\"tfoot\" colspan=\"3\">&nbsp;</td>
</tr>
</tbody>
</table>
<br />
<table border=\"0\" width=\"100%\">
<tr valign=\"top\">
<if condition=\"$vboptions[\'showdonators\'] ==1\">
<td>
<table class=\"tborder\" cellpadding=\"$stylevar[cellpadding]\" cellspacing=\"$stylevar[cellspacing]\" border=\"0\" width=\"100%\" align=\"center\">
<thead>
<tr align=\"center\">
<td class=\"tcat\" colspan=\"3\">$vbphrase[top_donators]</td>
</tr>
<tr align=\"center\">
<td class=\"thead\" colspan=\"3\">$vbphrase[sorted_by_total_donation]</td>
</tr>
</thead>
<tbody>
<tr align=\"center\">
$topdonatorbits
</tr>
<tr>
<td class=\"tfoot\" colspan=\"3\">&nbsp;</td>
</tr>
</tbody>
</table>
</td>
</if>
<td>
<if condition=\"$vboptions[\'showgoals\'] == 1\">
<table class=\"tborder\" cellpadding=\"$stylevar[cellpadding]\" cellspacing=\"$stylevar[cellspacing]\" border=\"0\" width=\"100%\" align=\"center\">
<thead>
<tr align=\"center\">
<td class=\"tcat\" colspan=\"2\">$vbphrase[our_donation_goals]</td>
</tr>
<tr align=\"center\">
<td class=\"thead\" colspan=\"2\">
$vbphrase[money_goes_towards_goals]<br />
<if condition=\"$vboptions[\'showtotalcollected\'] == 1\">
<if condition=\"$mc_total > 0\">
$vbphrase[we_have_collected] $$mc_total $vbphrase[since] $vboptions[donationstartdate]
<else />
$vbphrase[we_have_not_collected]
</if>
</if>
</td>
</tr>
</thead>
<tbody>
<tr align=\"center\">
$donationgoalbits
</tr>
<tr>
<td class=\"tfoot\" colspan=\"2\">&nbsp;</td>
</tr>
</tbody>
</table>
<br />
</if>
<table class=\"tborder\" cellpadding=\"$stylevar[cellpadding]\" cellspacing=\"$stylevar[cellspacing]\" border=\"0\" width=\"100%\" align=\"center\">
<thead>
<tr align=\"center\">
<td class=\"tcat\">$vbphrase[your_donations_are_appreciated]</td>
</tr>
<tr align=\"center\">
<td class=\"thead\">$vbphrase[all_donations_go_towards_furthering_goals]</td>
</tr>
</thead>
<tbody>
<tr>
<td class=\"alt1\">
$vbphrase[donation_used_to_further_mission]
</td>
</tr>
<if condition=\"$vboptions[\'501c3\'] == 1\">
<tr>
<td>
$vbphrase[non_profit]
<br />
$vbphrase[our_tax_id]
<br />
<center><strong>$vboptions[taxid]</strong></center>
</td>
</tr>
</if>
<tr>
<td class=\"tfoot\">&nbsp;</td>
</tr>
</tbody>
</table>
<if condition=\"$vboptions[\'showverifiedseal\'] == 1\">
<br />
<table class=\"tborder\" cellpadding=\"$stylevar[cellpadding]\" cellspacing=\"$stylevar[cellspacing]\" border=\"0\" width=\"100%\" align=\"center\">
<thead>
<tr align=\"center\">
<td class=\"tcat\" colspan=\"3\">$vbphrase[paypal_verified]</td>
</tr>
</thead>
<tbody>
<tr align=\"center\">
<td class=\"alt1\" align=\"center\">
<a href=\"https://www.paypal.com/us/verified/pal=$vboptions[paypal_email]\" target=\"_blank\">
<img src=\"$stylevar[imgdir_misc]/paypal_verified.gif\" border=\"0\" alt=\"Official PayPal Seal\">
</a>
</td>
<td class=\"alt2\" align=\"center\" width=\"100%\">
$vbphrase[what_it_means_to_be_verified]
</td>
</tr>
<tr>
<td class=\"tfoot\" colspan=\"3\">&nbsp;</td>
</tr>
</tbody>
</table>
</if>
</td>
</tr>
</table>

<!-- /main -->

$footer
</body>
</html>', 'template', '1118695264', 'Cloudrunner', '3.0.7')
mysql error: Duplicate entry '-1-0' for key 2

mysql error number: 1062

[dsboyce8624]

I'm not sure why it would say you have a dupe, if you have a virgin DB.

Have you donwloaded the zip since Cloudrunner reworked it?

Maybe try that?

Otherwise you'll have to wait for him, I'm stumped.

[xtreme-mobile]

will this work on vbadanced v2 portal?

[xfaethorx]

hi,

i'm using the current zip as of this thread and i've found whats caused my problem.

for some reason the template database has mangled templates in it from the install

+------------+-------+-------------------+--------------------------------+---------+-------------+--------------+----------+----------+
| templateid | title | template | version | styleid | template_un | templatetype | dateline | username |
+------------+-------+-------------------+--------------------------------+---------+-------------+--------------+----------+----------+
| 8777 | -1 | adv_portal_donate | <!-- Donations Block -->

<t | 0 | template | | 0 | 3.0.7 |
+------------+-------+-------------------+--------------------------------+---------+-------------+--------------+----------+----------+

stumped as to why thats happened can someone tell me if that tables right?!?! this dbs been around since like vb 2 and upgraded everytime so i wonder if somethings gone wrong. Still have to find out WHY that happened.

[dsboyce8624]

will this work on vbadanced v2 portal?

We haven't tried yet.

[xtreme-mobile]

okwill try installing in and see if i can get it to work :D

[dsboyce8624]

hi,

i'm using the current zip as of this thread and i've found whats caused my problem.

for some reason the template database has mangled templates in it from the install

+------------+-------+-------------------+--------------------------------+---------+-------------+--------------+----------+----------+
| templateid | title | template | version | styleid | template_un | templatetype | dateline | username |
+------------+-------+-------------------+--------------------------------+---------+-------------+--------------+----------+----------+
| 8777 | -1 | adv_portal_donate | <!-- Donations Block -->

<t | 0 | template | | 0 | 3.0.7 |
+------------+-------+-------------------+--------------------------------+---------+-------------+--------------+----------+----------+

stumped as to why thats happened can someone tell me if that tables right?!?! this dbs been around since like vb 2 and upgraded everytime so i wonder if somethings gone wrong. Still have to find out WHY that happened.

Beyond me. Have to wait for CR.

[xfaethorx]

lol yeah i stopped there too :D. its probably something odd at my side as i've installed it no problems elsewhere

[Cloudrunner]

Donations Currency Exchange Quotes


Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=USD&format=CSV&dest=Get+Table&sel_list=USD): (http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=USD&format=CSV&dest=Get+Table&sel_list=USD%29:) failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=AUD&format=CSV&dest=Get+Table&sel_list=USD): (http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=AUD&format=CSV&dest=Get+Table&sel_list=USD%29:) failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=CAD&format=CSV&dest=Get+Table&sel_list=USD): (http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=CAD&format=CSV&dest=Get+Table&sel_list=USD%29:) failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=EUR&format=CSV&dest=Get+Table&sel_list=USD): (http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=EUR&format=CSV&dest=Get+Table&sel_list=USD%29:) failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=GBP&format=CSV&dest=Get+Table&sel_list=USD): (http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=GBP&format=CSV&dest=Get+Table&sel_list=USD%29:) failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Warning: file(http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=JPY&format=CSV&dest=Get+Table&sel_list=USD): (http://www.oanda.com/convert/fxdaily?value=1&redirected=1&exch=JPY&format=CSV&dest=Get+Table&sel_list=USD%29:) failed to open stream: Connection refused in /includes/cron/donation_currency_exchange.php on line 29

Warning: implode(): Bad arguments. in /includes/cron/donation_currency_exchange.php on line 31

Done


I think I've fixed that issue....I'll be updating the zip here shortly. Please bear with me, I just got home.

[Cloudrunner]

LOL- now I'm adding existing donors to the DB - but it's gonna be a nightmare :cheeky:

Is there any way that the drop down box of members could be sorted alphabetically instead of by member no.?

My forum's not that big but I still have nearly 2,000 members and I have to add in over 120 donors - I'm going blind atm trying to find them in that long list :cry:

Also, a little bug - after a "donator is added, on the view donators page, I'm getting the dreaded red X for their avatar - it seems that the admincp has been added to to path to the call the avatar.

i.e. http://www.mysite.com/forum/admincp/image.php?u=52&dateline=1108213260 whereas the actual path is http://www.mysite.com/forum/image.php?u=52&dateline=1108213260
Fixed both of these, thank you for finding them.

[Cloudrunner]

lol yeah i stopped there too :D. its probably something odd at my side as i've installed it no problems elsewhere
I'm currently looking at the duplicate entries at install at the moment, not sure exactly what's going on here, but as soon as I figure it out I'll get 1.03 out. Plese be patient, will be shortly.

[Cloudrunner]

+------------+-------+----------+---------+---------+-------------+--------------+----------+----------+
| templateid | title | template | version | styleid | template_un | templatetype | dateline | username |
+------------+-------+----------+---------+---------+-------------+--------------+----------+----------+Your schema is goofed, but I can work around that...was using short-hand for the inserts, looks like I'm going to have to use long-hand to do it right for everyone. Sorry bout that folks, but that is where your errors are coming from. Thank you xfaethorx for finding this issue for me today. I will get this fixed and reworked in the system. It may take a couple of hours, so I will release when that is completed.

Thank you for your patience!

oh, and the schema for the templates DB as I have it for 3.0.7 is:
+------------+---------+-------+----------+-------------+--------------+----------+----------+---------+
| templateid | styleid | title | template | template_un | templatetype | dateline | username | version |
+------------+---------+-------+----------+-------------+--------------+----------+----------+---------+

Again thanks folks for being patient with me, I'll get this fixed and we'll go from there.

)O( Cloudrunner )O(

[Cloudrunner]

This is to let you all know that I have dropped a new archive of the system on vb.org. This archive fixes (hopefully) most of the installation problems some users were experiencing. That being said, I cannot plan for everything so please let me know if you run into any issues.

If you are one of the users who were plagued by the install problems (OF ANY KIND) then please download this update and overwrite everything then uninstall (using the NEWEST installer) the old stuff. After uninstallation, check your forums main page for problems if you had the vBadvanced Module installed. If you had the module installed and you now experience errors with the donations system uninstalled, simply go into your AdminCP and then go to the VBACMPS-->edit Pages and select each page individually and save it without changing anything and this will fix the errors experienced (this shouldn't happen though as I've coded to avoid this specific problem, but hey, you never know). After all is good then go ahead and reinstall the system. All *SHOULD* be good at this point.

Here is what I have addressed in this release:





Fixed bug where on installation the currency exchanges were not being populated properly.
Changed user list on "Add Donator" page in AdminCP to be sorted alphabetically.
Fixed Avatar display for custom avatars in the AdminCP.
Fixed short hand INSERTs in the installer. Should work with all versions of DB schemas now.
Please let me know if you run into anymore issues!



Please Note: If you did not experience any problems installing the hack then you do NOT need to install this update as it only fixes a few things outside of the installer itself. If you want the extra functionality (correct avatar in AdminCP and the alphabetical listing of usernames), then simply upload all the files except the installer and the install directory.



As soon as I am confident that this will install on almost everyone's installation of VB I will continue onto additional functionality.


Thank you for your support of this hack!

Love and Light to you all!

)O( Cloudrunner )O(

[Cloudrunner]

Mmm - I've had to give up on manually adding them - it's just too difficult.

But I notice that apart from the top 3 - nothing else (amount collected & % of target etc.) is appearing on donate.php even after I've added them - could it be that manually added donations aren't being picked up?
The donors and the transactions are kept seperate on purpose so that the transaction data will not get corrupted by random editing and/or adding of transactions to avoid the chance of "spoofing" a transaction by someone other than yourself. The side effect of doing this is that the donors that you add get credit for what they have donated, but the goal amount will not rise accordingly. To make it rise accordingly you must add the amount the donor gave to that goal by simply editing the goal itself and doing a little math on your part.

Again I have done this on purpose to avoid have a problem with unscrupulous people injecting (or attempting to) transactions in the system without notification of such activity. I know it's a pain, but in my view a little work is worth the effort.

1) Add / edit user giving the user their total amount-->Save User
2) Take that amount and add it to the goal with simple math
3) Take the total that you come up with and then edit the goal using that new total as the goal's total-->Save goal

All done, user gets credit and system sees the additional fundage.

[Cloudrunner]

...Oh and any plans for this to go onto 3.5.0 once it's released?...

Yes, once 3.5 is out of Beta I will port this over and both will be updated as I add features.

[Cloudrunner]

This is for those of you who are using the multiple currencies option:

The system defaults to use the USD currency. If you change this currency in the Donations settings, then to get the correct exchange pricing, you need to run the CRON file to update your Exchange Rates table.

To do this simply log into your AdminCP and then do the following:

1) Scroll down your navigation bar on the left and find the Scheduled tasks navigation group, open that up and click on "Scheduled Task Manager".
2) Find the CRON named "Donations Currency Exchange Quotes"
3) To the right of that you will find a button named "Run Now"
4) Click that button and wait until the system says Done.

Once the system has reloaded the exchange rates using your new currency you are ready to go and start collecting donations.

I forgot to add this to the instructions in the first post, that is why I'm sending the update. I will add this to the first post, and the install document as well.

Love and light!

)O( Cloudrunner )O(

P.s. I'm adding the functionality for the system to automagickally change the currency notifier ('$', '€') based on your currency selected on the useer viewable side of the house, this will be in the next update should the fixes to the installer be kosher.

[caimakale]

cloudrunner,

Is this something I need to reinstall or can I just replace the cron file? I have already started receiving donations, and if it's unnecessary, I would rather leave the database alone now. If there are other changes that need to be done, I will re-install the system.

[Cloudrunner]

cloudrunner,

Is this something I need to reinstall or can I just replace the cron file? I have already started receiving donations, and if it's unnecessary, I would rather leave the database alone now. If there are other changes that need to be done, I will re-install the system.
Uninstall / Reinstall so that the system will finish installing what it couldn't cus the file broke midway through it's install course with the settings page where the initial cron is located. I have moved the CRON call to the bottom of the settings page so that the installation *shouldn't* break completely if the CRON fails.

Lemme know if this fixes the problem for you?

[Cloudrunner]

Well folks, it's midnight here and I wake at 0500, so I'm out...post here if there are anymore problems and I will attend to them when I get home from work tomorrow evening.

[xfaethorx]

just installed 1.03 with no problems what so ever on my system! Thanks for the quick turn around cloudrunner most impressed! Look forward to using this hack in anger now ;). cheers (clicks install!).

[artonex]

Yes, once 3.5 is out of Beta I will port this over and both will be updated as I add features.

Thanks for still continuing with this hack for 3.0.7 im sure many are really greatful :D

[guvner]

Thanks Cloudrunner - the alphabetised listing is great!

The avatar URL is still a little off though, mine still has the red X because there's a / missing between the forum dir and image.php as follows:

http://www.mysite.com/forumimage.php?u=52&dateline=1108213260 I had a look at donation_admin.php but really couldn't figure our how to fix it :(

[Cloudrunner]

Thanks Cloudrunner - the alphabetised listing is great!

The avatar URL is still a little off though, mine still has the red X because there's a / missing between the forum dir and image.php as follows:

http://www.mysite.com/forumimage.php?u=52&dateline=1108213260 I had a look at donation_admin.php but really couldn't figure our how to fix it :(
Open donation_admin.php and look for the line that reads:

$avatarurl = $vboptions['bburl']."image.php?".$session['sessionurl']."u=".$row['userid']."&amp;dateline=".$user_row['avatardateline'];

change it to:

$avatarurl = $vboptions['bburl']."/image.php?".$session['sessionurl']."u=".$row['userid']."&amp;dateline=".$user_row['avatardateline'];

(Note the added '/')

Specific line for the edit is line 281

sorry bout that, it'll be in the next update.

Thanx fer keepin me on me toes folks!

[guvner]

Thanks for that, but there's something else that's a little odd. Some of the avatars still show red X's, when I right click and check the properties, all avatars that are called through image.php with all the dateline stuff show up fine, others have a standard URL and still have the red X

e.g.

http://www.yoursite.com/forum/image.php?u=1155&dateline=1116977135 are good

http://www.yoursite.com/forum/images/avatars/49toon.gif show the red X

Now I have no idea what the differences between those 2 calls are, could it be that some are custom avatars?

Sorry to keep buggin you - everything else is sweet :) (if I could only get my damn sandbox working right to test it) :P

[Cloudrunner]

Thanks for that, but there's something else that's a little odd. Some of the avatars still show red X's, when I right click and check the properties, all avatars that are called through image.php with all the dateline stuff show up fine, others have a standard URL and still have the red X

e.g.

http://www.yoursite.com/forum/image.php?u=1155&dateline=1116977135 are good

http://www.yoursite.com/forum/images/avatars/49toon.gif show the red X

Now I have no idea what the differences between those 2 calls are, could it be that some are custom avatars?

Sorry to keep buggin you - everything else is sweet :) (if I could only get my damn sandbox working right to test it) :P
Do me a favor, check that user's (the one(s) giving issues in the Admincp) avatar image on yer main site and give me the two URL's of what is in the AdminCP and the main site so I can see the difference? (I'm at work right now, no access to the code, but I may be able to fix just by using this.)

[mkdevo]

Doesn't seem to like 3.0.6 :disappointed:

Database error in vBulletin 3.0.6:

Invalid SQL: ALTER TABLE language ADD phrasegroup_ppdonations MEDIUMTEXT NOT NULL ;
mysql error: Duplicate column name 'phrasegroup_ppdonations'

mysql error number: 1060

Date: Monday 13th of June 2005 01:27:56 AM
Script: http://www.**********/forum/admincp/donations_install.php
Referer: http://www.***********/forum/admincp/donations_install.php
Username: ********
IP Address: **.**.102.40


i'm getting a similar error in 3.0.7:

Database error in vBulletin 3.0.7:

Invalid SQL: ALTER TABLE language ADD phrasegroup_ppdonations MEDIUMTEXT NOT NULL ; mysql error: Duplicate column name 'phrasegroup_ppdonations'

mysql error number: 1060

this is my first time installing it. i ran the uninstall, tried again, same thing..

any ideas?

[Cloudrunner]

i'm getting a similar error in 3.0.7:



this is my first time installing it. i ran the uninstall, tried again, same thing..

any ideas?
Which version of this hack are you running? (look up at the top there on the installer). Current version is 1.03 and it addresses this issue with a recoded installer. The zip on the first post is the current version of the hack as of 11:30 PM last night.

If the version you are running is anything less than 1.03 then please redownload and the upload overwriting all files, then uninstall and install again. Problem should be addressed. If your version is 1.03 then when I get home this afternoon I will look into addressing this again...

[mkdevo]

Which version of this hack are you running? (look up at the top there on the installer). Current version is 1.03 and it addresses this issue with a recoded installer. The zip on the first post is the current version of the hack.

1.03 it is...

[Cloudrunner]

1.03 it is...
Try this then (again, I'm at work so bear with me...)

Go into the file: ./admincp/donation_install/donation_install_phrases.php and find near the bottom:if (isset($test_language['phrasegroup_ppdonations']) AND !empty($test_language['phrasegroup_ppdonations'])){And replace with:if (isset($test_language['phrasegroup_ppdonations'])){Let me know if this helps, if it does I'll get it in the next update if not then I'll have to look into it abit more when I get home.

[mkdevo]

Try this then (again, I'm at work so bear with me...)

Go into the file: ./admincp/donation_install/donation_install_phrases.php and find near the bottom:if (isset($test_language['phrasegroup_ppdonations']) AND !empty($test_language['phrasegroup_ppdonations'])){And replace with:if (isset($test_language['phrasegroup_ppdonations'])){Let me know if this helps, if it does I'll get it in the next update if not then I'll have to look into it abit more when I get home.

bingo! thank you!

while i haven't tried out the actual mod functionality yet, i was now able to get past that point in the install, so it worked.

[dsboyce8624]

Nothing like a million testers to work out the kinks, eh?

[guvner]

Do me a favor, check that user's (the one(s) giving issues in the Admincp) avatar image on yer main site and give me the two URL's of what is in the AdminCP and the main site so I can see the difference? (I'm at work right now, no access to the code, but I may be able to fix just by using this.)OK, they're just like I wrote above, but here they are again:

Member 1 (with red X in donor admin)http://www.mysite.com/forum/admincp/images/avatars/49toon.gifMember 1 - Normal forum pathhttp://www.mysite.com/forum/images/avatars/49toon.gif

Compared to a member with an avatar that works fine in both areas:

Donor admin pathhttp://www.mysite.com/forum/image.php?u=423&dateline=1113379178Member 2 - Normal forum pathhttp://www.mysite.com/forum/image.php?u=423&dateline=1113379178Any clues there?

[Cloudrunner]

OK, they're just like I wrote above, but here they are again:

Member 1 (with red X in donor admin)http://www.mysite.com/forum/admincp/images/avatars/49toon.gifMember 1 - Normal forum pathhttp://www.mysite.com/forum/images/avatars/49toon.gif

Compared to a member with an avatar that works fine in both areas:

Donor admin pathhttp://www.mysite.com/forum/image.php?u=423&dateline=1113379178Member 2 - Normal forum pathhttp://www.mysite.com/forum/image.php?u=423&dateline=1113379178Any clues there?
Yep ;)

in donation_admin.php find:if ($user_row['avatarid']){
$avatarurl = $user_row['avatarpath'];
} else {
if ($user_row['hascustomavatar']){
if ($vboptions['usefileavatar']){
$avatarurl = $vboptions['avatarurl']."/avatar".$row['userid']."_".$user_row['avatarrevision'].".gif";
} else {
$avatarurl = $vboptions['bburl']."/image.php?".$session['sessionurl']."u=".$row['userid']."&amp;dateline=".$user_row['avatardateline'];
}
} else {
$avatarurl = '';
}
}replace with:if ($user_row['avatarid']){
$avatarurl = $vboptions['bburl']."/".$user_row['avatarpath'];
} else {
if ($user_row['hascustomavatar']){
if ($vboptions['usefileavatar']){
$avatarurl = $vboptions['bburl']."/customavatars/avatar".$row['userid']."_".$user_row['avatarrevision'].".gif";
} else {
$avatarurl = $vboptions['bburl']."/image.php?".$session['sessionurl']."u=".$row['userid']."&amp;dateline=".$user_row['avatardateline'];
}
} else {
$avatarurl = '';
}
}Fixed *Should be anyway*. Will be in next update

Thank you!

[dsboyce8624]

Why would you put it in the update? Wouldn't that ruin all the fun of helping people fix it?

:nervous:

[Cloudrunner]

Why would you put it in the update? Wouldn't that ruin all the fun of helping people fix it?

:nervous:
uh...sure...

dingbat LOL...

[dsboyce8624]

uh...sure...

dingbat LOL...

You leave my mental capacity out of this, I have.

[Cloudrunner]

You leave my mental capacity out of this, I have.
bad thing is I had to think on that for a moment....bad bubba...

[dsboyce8624]

bad thing is I had to think on that for a moment....bad bubba...

<Looking around absently>

Think about what? Who are you?

[Cloudrunner]

New Update -- Version 1.04

All known bugs have been squashed as of this point! YAY!

Alright, installer should be fixed for those of you doing a fresh install. If you had previous errors and never did get the thing totally installed, then upload everything overwriting what you already have and then uninstall / reinstall.

If you were successfull in installing the thing, then just upload everything overwriting what you have and then jump into the installer and you should see the upgrade button now, just click that, and BAM! You're on your way.

If you modified any templates you will need to revert them to get the full functionality of the new templates with the auto-changing currency signs.

Other than that, enjoy!

)O( Cloudrunner )O(

[dsboyce8624]

Damn, every time I get em how I like em, BAM, redo it.

[guvner]

Fixed *Should be anyway*. Will be in next update

Thank you!And so it is - thank you Cloudrunner - great hack and terrific follow through support !

Mike :)

[caimakale]

Beautiful!!!

Here is an update with my install problems.

I ran all the updates including 1.4 and still had the problem grabbing the exchange rates. I called my hosting company, and they had to add www.oanda.com to the firewall to let the info pass through. After they added it, everything worked great.

Here is something I noticed though in all of my searching on this problem. In my webhost error logs, I found this:
PHP Warning: Cannot modify header information - headers already sent by (output started at /home/********/public_html/includes/pp_image.php:46) in /home/********/public_html/includes/pp_image.php on line 47

No errors show on any pages on my site, but this is in my webhost log file a million times. I checked the file for a white space at the end, but everything seems ok.

Any ideas and is anybody else having this problem?

[Cloudrunner]

Damn, every time I get em how I like em, BAM, redo it.
Last time I promise LOL.

Next update won't be for awhile...workin on the categories and awards stuffies now...

oh, and any features you might could think up, lemme know.

[Cloudrunner]

Beautiful!!!

Here is an update with my install problems.

I ran all the updates including 1.4 and still had the problem grabbing the exchange rates. I called my hosting company, and they had to add www.oanda.com to the firewall to let the info pass through. After they added it, everything worked great.

Here is something I noticed though in all of my searching on this problem. In my webhost error logs, I found this:
PHP Warning: Cannot modify header information - headers already sent by (output started at /home/********/public_html/includes/pp_image.php:46) in /home/********/public_html/includes/pp_image.php on line 47

No errors show on any pages on my site, but this is in my webhost log file a million times. I checked the file for a white space at the end, but everything seems ok.

Any ideas and is anybody else having this problem?
I've an idea of where the problem lies, but it's late so am going to bed and will look at it after work tomorrow...

[dsboyce8624]

Last time I promise LOL.

Next update won't be for awhile...workin on the categories and awards stuffies now...

oh, and any features you might could think up, lemme know.

I'm good. for now. Which means for like ten minutes.

I'd like to do a test though. Everybody who reads this, register on my site and donate 5 bucks, if there are problems I'll let you know.

<smile>

[TTG]

Upgrade to 1.04 produces loads of "\r\n" within phrases :-

\r\n To become Verified, a PayPal member in the United States must provide PayPal with proof that he or she has opened an account at a bank or other financial institution.\r\n Because these institutions are required by law to screen account holders, PayPal's verification process increases security when you pay parties you do not know.\r\n Please note that PayPal's verification system does not constitute an endorsement of a member, nor a guarantee of a member's business practices.\r\n You should always consider other indicators when evaluating members, including length of PayPal membership and reputation scores\r\n

[Vman]

How would I set this up for vPortal? I have it all up and running, love the program, but now I want to add the same info and box as Advance Portal Program...what must I do...

Thanks
Vman

[guvner]

oh, and any features you might could think up, lemme know.Some people who have donated are a little modest and have said that they'd prefer to not be publicised in the Top Donators", but I would still like to have the sidebar type feature, so could we add the ability to switch to the "Last 5 Donators" as well?

LOL - still can't get used to using the word "donators" :nervous:

[artonex]

How about making this hack work with http://nochex.com also, cuz some ppl wont use paypal as there scamming f**kers.

[dsboyce8624]

How about making this hack work with http://nochex.com also, cuz some ppl wont use paypal as there scamming f**kers.

I think he **may** be considering that, but I'm not 100% sure.

[mkdevo]

any idea why i would be getting 2 dollar signs before the amount in the 'top donors'?? ie, $$40.00

[mkdevo]

here's another idea for this:

would it be possible to create another block on the donate page, which lists ALL donators, by username? i like the idea of the 'top donators', but i'd also like a place to recognize ALL donators as well (this also wouldn't discourage anyone from making a small donation just because they wouldn't be showing up on the Top x list.)...

[dsboyce8624]

any idea why i would be getting 2 dollar signs before the amount in the 'top donors'?? ie, $$40.00

Some of them are in the phrases and some are hardcoded.

Check on the page and see which you need to change.

[dsboyce8624]

here's another idea for this:

would it be possible to create another block on the donate page, which lists ALL donators, by username? i like the idea of the 'top donators', but i'd also like a place to recognize ALL donators as well (this also wouldn't discourage anyone from making a small donation just because they wouldn't be showing up on the Top x list.)...

I'm sure this could be done by modifying the table that shows the top donors, but if you have a bunch of donations it could really screw up the page.

Perhaps you should create a new page that shows only donors and link to it from donate.php.

[mkdevo]

Some of them are in the phrases and some are hardcoded.

Check on the page and see which you need to change.

i'm not following here...

[dsboyce8624]

i'm not following here...

I assumed you had edited, my fault, there was a request for how to change the "$" to other currency. Brainfart.

Give me a link to look at.

[Cloudrunner]

any idea why i would be getting 2 dollar signs before the amount in the 'top donors'?? ie, $$40.00
Looks to me like you didn't upload all the files from the last archive. This was addressed in the phrasing / templates / donate.php file that was released in the latest release. The $total in the donate template was updated and the old way of notifying it was removed in the donate.php file.

Reminder to all, with any upgrade to my systems you must upload every file given except for the files in the docs folder, otherwise you will run into small annoyances like this. In any upgrade that I do I make subtle changes to both the code and the templates and the phrasing as well. Just an FYI.

[Cloudrunner]

How about making this hack work with http://nochex.com also, cuz some ppl wont use paypal as there scamming f**kers.

I'm gonna go with...


no


simply because I use Paypal and not nochex, and I've had troubles with nochex before...

It's their choice as to whether they use PayPal and this hack or not...It's no hair offa my butt if they don't. I'm simply providing something to the public that my site needed, if they don't need it then they'll either find something else, or design something else to fit their needs.

[Vman]

I need help in creating a "html" for vportal so I can add it to a side block. I would want the donation button, donation bar and top donators....Can someone PLEASE help!

Thanks

Vman
www.bodybuildingcentral.net

[Cloudrunner]

I need help in creating a "html" for vportal so I can add it to a side block. I would want the donation button, donation bar and top donators....Can someone PLEASE help!

Thanks

Vman
www.bodybuildingcentral.net
The code for running the module is located in ./modules/donate.php and the templates are the templates named adv_portal_blah. You can find them in the ./admincp/donation_install/donation_templates.php.

Hope that helps...

[Cloudrunner]

Upgrade to 1.04 produces loads of "\r\n" within phrases :-
I have fixed that...will be in the next update.

[Cloudrunner]

Some people who have donated are a little modest and have said that they'd prefer to not be publicised in the Top Donators", but I would still like to have the sidebar type feature, so could we add the ability to switch to the "Last 5 Donators" as well?

LOL - still can't get used to using the word "donators" :nervous:

Excellent idea, will be done shortly and in the next update...

[Cloudrunner]

here's another idea for this:

would it be possible to create another block on the donate page, which lists ALL donators, by username? i like the idea of the 'top donators', but i'd also like a place to recognize ALL donators as well (this also wouldn't discourage anyone from making a small donation just because they wouldn't be showing up on the Top x list.)...Will work on that as well for the next update. Thank you!

[Vman]

The code for running the module is located in ./modules/donate.php and the templates are the templates named adv_portal_blah. You can find them in the ./admincp/donation_install/donation_templates.php.

Hope that helps...

Thanks
and Blessed Be! ;)
Do As Ye Will And Harm Ye None!!!

[Cloudrunner]

Thanks
and Blessed Be! ;)
Do As Ye Will And Harm Ye None!!!
No problem...

Namaste

)O( Cloudrunner )O(

[Vman]

The code for running the module is located in ./modules/donate.php and the templates are the templates named adv_portal_blah. You can find them in the ./admincp/donation_install/donation_templates.php.

Hope that helps...

I looked all over and did not find any file named adv_portal.
Would you be able to just copy and paste the code and Ill modify it from there for my site....

Thanks again...sorry for the troubles....

[Vman]

Infact when I installed it I did not install it for adv_portal. Im using vPortal....Now if need be, should I just uninstall it and reinstall it using adv_portal option?

[Cloudrunner]

Infact when I installed it I did not install it for adv_portal. Im using vPortal....Now if need be, should I just uninstall it and reinstall it using adv_portal option?
1) The templates are not a file, they are stored in an array called $VBA_templates located in the ./admincp/donation_install/donation_templates.php file as previously stated. Open that file and they are the last three array variables on the page. ie:$VBA_templates = array('adv_portal_donate' => 'BLAHBLAHBLAH',
'adv_portal_donate_goals' => 'blah blah blah',
'adv_portal_donate_goals_users' => 'blasee blah blah');2) If you have vbadvance already installed, and did the non vB install, then just go with the vB install and after the first page is complete, simply close the browser window and do not continue on from there, that will install the templates, phrases and settings for vBadvanced. No need to uninstall, just click the vBa install and then close the window when it is finished.

[dsboyce8624]

He's using vPortal, not vBadvanced. That's why he wants the template code, so he can port it.

I'd upload them, but I haven't installed the latest version yet.

<lazy!!!>

[LEAD_WEIGHT]

vbPortal has its own hacks so why ask for vbadvance when all u need to do is get the one that is @ that site. If u own vbPortal then u would get the same help @ that site. The only difference is that u pay for that proggie and have access to sites hacks, that if u paid for it.

Just ask the members @ vbportal to make one.

[Vman]

vPortal has its own hacks so why ask for vbadvance when all u need to do is get the one that is @ that site. If u own vPortal then u would get the same help @ that site. The only difference is that u pay for that proggie and have access to sites hacks, that if u paid for it.

Just ask the members @ vportal to make one.

vPortal does not make hacks for vBulletin! They make hacks for vPortal... Second I would have not requested this here if there was already a solution to this there...and final #3, I downloaded this PayPal hack from here with support to have it also work with vPortal as well....ALSO NO WHERE IN THE PROFILE OF THIS HACK DID IT STATE IT WAS JUST FOR vbAdvance!....thanks for the post tho!

[twoseven]

You will need to add a link somewhere in your navigation system for vBulletin pointing your users to the donations page (if you installed the vBadvanced Module then you have a link on the home page, but you might want to add one in the nav bar as well)

nowhere does it say that it works with vbportal. also dont be mad when you buy a product then get a hack for free and assume the full features will work in an instant it always doesnt go that way. this hack will work without the portal integration fine. if the authors want to make it vbportal compliant they may but dont assume they will

[Vman]

You will need to add a link somewhere in your navigation system for vBulletin pointing your users to the donations page (if you installed the vBadvanced Module then you have a link on the home page, but you might want to add one in the nav bar as well)

nowhere does it say that it works with vbportal. also dont be mad when you buy a product then get a hack for free and assume the full features will work in an instant it always doesnt go that way. this hack will work without the portal integration fine. if the authors want to make it vbportal compliant they may but dont assume they will

Look, First off Im not mad, If I was you would know!. I don't like being told I should have done somthing when that person has no clue what I have already done!. Im well aware on how hacks work. Im also aware on how to add the direct link, just like it states in the instructions....I simply asked for a vPortal script....and just by you adding the statement you just did, you have done nothing to solve this request but post +++++d!....OK, now you can see that Im mad!!!!... lol......"with support to have it also work with vPortal as well" Most programers will help in dealing with such requests....I have already stated I think this is GREAT HACK and it works perfectly...

Im asking for a very simple request....if you or any other member can not help, then please don't post in this request thread...I don't want wasted chit chat and have the request not be made...

Thank You!

[Vman]

He's using vPortal, not vBadvanced. That's why he wants the template code, so he can port it.

I'd upload them, but I haven't installed the latest version yet.

<lazy!!!>

Ill take whatever you have and Im modify it!.....

[artonex]

I'm gonna go with...


no


simply because I use Paypal and not nochex, and I've had troubles with nochex before...

It's their choice as to whether they use PayPal and this hack or not...It's no hair offa my butt if they don't. I'm simply providing something to the public that my site needed, if they don't need it then they'll either find something else, or design something else to fit their needs.

No worrys i will probably hire you to make me a nochex version of this, ofcourse ill pay you. Speak on msn soon cr :)

[mkdevo]

Looks to me like you didn't upload all the files from the last archive. This was addressed in the phrasing / templates / donate.php file that was released in the latest release. The $total in the donate template was updated and the old way of notifying it was removed in the donate.php file.


d'oh! that's it.. i uploaded everything but the new donate.php and ppverify.php files.. thanks!

[mkdevo]

Will work on that as well for the next update. Thank you!

excellent! thanks CR!

just want to say that your support thus far with this has been incredible! it's nice to know that you listen to your users, and it's very much appreciated.

[dsboyce8624]

Look, First off Im not mad, If I was you would know!. I don't like being told I should have done somthing when that person has no clue what I have already done!. Im well aware on how hacks work. Im also aware on how to add the direct link, just like it states in the instructions....I simply asked for a vPortal script....and just by you adding the statement you just did, you have done nothing to solve this request but post +++++d!....OK, now you can see that Im mad!!!!... lol......"with support to have it also work with vPortal as well" Most programers will help in dealing with such requests....I have already stated I think this is GREAT HACK and it works perfectly...

Im asking for a very simple request....if you or any other member can not help, then please don't post in this request thread...I don't want wasted chit chat and have the request not be made...

Thank You!

I don't know if we can help you with this. Neither of us run it. You're welcome to to port it however you need, I just don't think we can help.

Sorry

[agiacosa]

It would be great if we could connect this to the Subscriptions system in vB. I have my premium memberships tied to that.

[quachvu]

can you add a function that after donate my member are moved to a special group?

[Cloudrunner]

It would be great if we could connect this to the Subscriptions system in vB. I have my premium memberships tied to that.
In what way? The subscriptions are an entirely different beast using different calls to and from Paypal...

[Cloudrunner]

can you add a function that after donate my member are moved to a special group?
I am looking into making this work, but I've a couple of things in front of that on the list of things to make work with this...It will be an option down the road though.

[Madmax4321]

nice work Cloudrunner :)

[rinkrat]

I'm just installing now and I see \r\n all over the place. How can I remove these?

Also, there is no "Donate" link on the Donate page at:
http://www.letsgokings.com/bbs/donate.php

[dsboyce8624]

I'm just installing now and I see \r\n all over the place. How can I remove these?

Edit the phrases that were added by the install.

Cloudrunner will be releasing this fix along with some other things shortly.

Search in Phrase Manager for one of the phrases listed in the first post, once you edit one of those, Phrase Manager will show you all the rest.

These:

your_donations_are_appreciated
all_donations_go_towards_furthering_goals
donation_used_to_further_mission

Sorry about that.

[rinkrat]

Thanks for the quick response!'

Also, there is no "Donate" link on the Donate page at:
http://www.letsgokings.com/bbs/donate.php

[dsboyce8624]

Thanks for the quick response!'

Also, there is no "Donate" link on the Donate page at:
http://www.letsgokings.com/bbs/donate.php

You must first edit your settings in AdminCP, then create a goal if you plan to use goals, then create buttons.

The buttons then appear in donate.php

[rinkrat]

You must first edit your settings in AdminCP, then create a goal if you plan to use goals, then create buttons.

The buttons then appear in donate.php


Aha! Thanks :)

[agiacosa]

In what way? The subscriptions are an entirely different beast using different calls to and from Paypal...

I noticed on one of your sites that you have several options or levels when you donate. One is a premium membership that entitles you to certain things.

I am giving premium members a number of options for donating at a certain level. The subscription system allows them to click on a PayPal button and the system does the rest. They are automatically added to the Premium Members group that grants them all the goodies. In addition, after a year, they are returned to regular member unless they donate again.

I'm saying it would be great to set this up with your system. I think if you are able to automatically subscribe folks to a special group for a specified period of time, that should do it.

[Vman]

I don't know if we can help you with this. Neither of us run it. You're welcome to to port it however you need, I just don't think we can help.

Sorry

Thanks...Ill see what I can do and when I do figure it out, Ill give you guys a copy to add so other vPortal users will be able to use it as well..... :squareeyed:

[dsboyce8624]

Thanks...Ill see what I can do and when I do figure it out, Ill give you guys a copy to add so other vPortal users will be able to use it as well..... :squareeyed:

That'd be appreciated.

[Cloudrunner]

I noticed on one of your sites that you have several options or levels when you donate. One is a premium membership that entitles you to certain things.

I am giving premium members a number of options for donating at a certain level. The subscription system allows them to click on a PayPal button and the system does the rest. They are automatically added to the Premium Members group that grants them all the goodies. In addition, after a year, they are returned to regular member unless they donate again.

I'm saying it would be great to set this up with your system. I think if you are able to automatically subscribe folks to a special group for a specified period of time, that should do it.
I can look into it, but I really don't want to go and reinvent something that is already a part of the resident vBulletin system. Just seems like a waste of time when you can do subscriptions already and regular donations now with my system. Just use them both at the same time...that's what I am going to do...

[Cloudrunner]

Thanks...Ill see what I can do and when I do figure it out, Ill give you guys a copy to add so other vPortal users will be able to use it as well..... :squareeyed:
Once you have it ready and tested properly I can add it to the system, that's not an issue.

[Cloudrunner]

Aha! Thanks :)
RTFP (Read The First Post) ;)

[Vman]

OK, I have it up and running now. I modified it for vPortal. I have not gotten a donation yet to make sure 100% that is it working. This is what needs to be done to create a block for it.

In PortalCP click "Default Sideblocks" then make it a "html" from the drop down menu, choose "Template" to "Yes" then in the script block add:


<thead>
<tr align="center">
<td colspan="2" class="tcat"><strong>Support Our Site </strong></td>
<tbody>

<tr align="center">


<td class="alt1">


<form name="donate" action="https://www.paypal.com/cgi-bin/webscr" method="post">

<input type="hidden" name="notify_url" value="http://www.YOURSITENAME.net/forums/ppverify.php">
<input type="image" src="https://www.paypal.com/en_US/i/btn/x-click-butcc-donate.gif" border="0" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">


<select id="currency_code" name="currency_code">
<option value="USD">US Dollar</option>
<option value="AUD">Australian Dollar</option>

<option value="CAD">Canadian Dollar</option>
<option value="EUR">Euro</option>
<option value="GBP">Pounds Sterling</option>
<option value="JPY">Japanese Yen</option>
</select>


<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="custom" value="donation:1:0">

<input type="hidden" name="item_number" value="69.110.66.144">
<input type="hidden" name="business" value="paypalname@YOURSITENAME.net">
<input type="hidden" name="return" value="http://www.YOURSITENAME.net/forums/donate.php?do=thankyou">
<input type="hidden" name="cancel_return" value="http://www.YOURSITENAME.net/forums/donate.php?do=canceled">
<input type="hidden" name="item_name" value="Site Donation">
<input type="hidden" name="cn" value="">
<input type="hidden" name="cbt" value="">



<input type="hidden" name="rm" value="2">
<input type="hidden" name="quantity" value="1">

<input type="hidden" name="no_shipping" value="1">
<input type="hidden" name="no_note" value="0">
<br />
</if>
</form>
</td>
</tr>
</tbody>
</thead>
<tbody>

<tr align="center">
<td colspan="2" class="alt1">Monthly Donation Goal - $25.00</td>
<tr align="center"><td class="alt2">
We have collected a total of $0.00 in donations towards our goal of $25.00
<br />

<br />
<img src="http://www.YOURSITENAME.net/forums/includes/pp_image.php?do=make_image&fill=00FFFF&border=54FF9F&background=FF00FF&percentage=0&width=150&height=9">
<br />
We have collected a total of 0%
<br />
Thank you!

<table class="tborder" cellpadding="6" cellspacing="1" border="0" width="100%" align="center">
<thead>
<tr align="center">
<td class="tcat" colspan="3">Top Donators</td>
</tr>
<tr align="center">

<td class="thead" colspan="3">Sorted by Total Donations</td>
</tr>
</thead>
<tbody>
<tr align="center">

</tr>
<tr>
<td class="tfoot" colspan="3">&nbsp;</td>

</tr>
</tbody>
</table>
</td>
<br>


To See what it looks like in vPortal vist:

www.bodybuildingcentral.net

Its on the right hand side.....

[Vman]

A donation was made and nothing has change. neither on the main donate.php page...it does not show the donation...I don't know if it takes awhile before it shows up.....

[dsboyce8624]

CR will have to look at your code to see if it follows the logic he has in place.

I'm nowhere near that good.

[Vman]

It appears that there may have been some coding messing from this to make it work....Will work on it and post a new one up when I know FOR A FACT that its working....as for now I wanted to post what I have done to try and port this....

[guvner]

A donation was made and nothing has change. neither on the main donate.php page...it does not show the donation...I don't know if it takes awhile before it shows up.....Same here - finally got back to this after 2 days away and asked one of my mods to test it.

He donated $10 30 minutes ago and despite getting the email from Paypal (below) - nothing has updated anywhere.

Dear XYZ,

This email confirms that you have received a $10.00 AUD from (removed).

View the details of this transaction here: 4NY492-edited-315V
--------------------------------------------------------------------------------

Payment Details

Total Amount: $10.00 AUD

Currency: Australian Dollars

Transaction ID: 4NY492-edited-315V

Item/Product Name: Server Upgrade & Hosting - Australian XP Media Center Community

Item/Product Number: 052004

Buyer: removed

--------------------------------------------------------------------------------
Address Information


Address: removed
23 ABC Street
XYZ
Perth, Western Australia 6030
Australia

Address Status: Unconfirmed

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

Thank you for using PayPal!
The PayPal Team

[caimakale]

If you aren't confirmed (unverified) with paypal, it won't let you get payment until you are.

You can accept payment from anyone, but the until you verify, it won't send info back to your site. I found this out while testing with the sandbox. I received payment, got the confirmation email showing I had received it, but on my board, I didn't have any money there. It did show up as a "Pending Transaction" in the ACP.

Check that, if you have a pending transaction go to PayPal and verify your info or they won't give you the money that has been donated.

[dsboyce8624]

Those Rat Bas^#&%s!

It's all about having an account upgraded from Personal, AND being verified.

It's a PItA but ya gotta do it.

[guvner]

If you aren't confirmed (unverified) with paypal, it won't let you get payment until you are.

You can accept payment from anyone, but the until you verify, it won't send info back to your site. I found this out while testing with the sandbox. I received payment, got the confirmation email showing I had received it, but on my board, I didn't have any money there. It did show up as a "Pending Transaction" in the ACP.

Check that, if you have a pending transaction go to PayPal and verify your info or they won't give you the money that has been donated.I don't understand that - I've been verified with Paypal for 3 years now, this is from my account page:

Status: Australian - Verified

Also, there's nothing in my ACP as pending.

The account isn't personal either - it's a business account with more than $400 a month coming in.

Any more ideas?

[dsboyce8624]

Check that in the settings you have the path to ppverify.php correct, and I suggest putting that same path in the setting on PayPal.

[Vman]

Im verified and this is the message I just got from the donation:

"The Transaction Number is: .

It is suggested that you investigate this transaction to determine if it was incorrectly labeled as invalid, or if it was an attempt at a false transaction."

[caimakale]

Check that in the settings you have the path to ppverify.php correct, and I suggest putting that same path in the setting on PayPal.

I agree. Make sure you have http://www.yourdomain.com/pathtoforums/ppverify.php entered in as your IPN address at PayPal's website as well as that same path in your ACP >> Donate Settings. You also need to make sure that http://www.yourdomain.com/pathtoforums/donate.php is entered correctly. It sounds like one of those three things isn't configured correctly if you aren't getting a response back from paypal when you receive payment. It isn't a delayed thing, it notifies you immediately when you receive payment.

[ultranerds]

Hi,

I've installed this hack, and it looks great <G>

However, due to protection issues on our server (anti-DDos mitigation system), PayPal don't seem to be able to request our ppverify.php file for some reason :/

As a fix.. I've moved the validation code from ppverify.php, into a do_verify() routine in donate.php (inside the "thankyou" part).

Basically, it seems to be working ok... as the transID is being passed back. I added this debugging;

echo "SELECT txn_id FROM ".TABLE_PREFIX."donation_paypalipn WHERE txn_id = '".$txn_id."'";

..which gives;

SELECT txn_id FROM donation_paypalipn WHERE txn_id = '62X17512XV724171B'
Fatal error: Call to a member function on a non-object in /var/home/andy/domain.co.uk/www/donate.php on line 344

Line 344, is this;

$query = $DB_site->query_first("SELECT txn_id FROM ".TABLE_PREFIX."donation_paypalipn WHERE txn_id = '".$txn_id."'");

I'm guessing its something to do with the query_first part not working for some reason?

TIA

Andy

[Lizard306]

This might sound really dumb stupid, but the first post says something about 2 files requiring modification. It just doesnt say which 2. And please dont anyone jump down my throat if you feel I have overlooked something in the instructions. I have re-read it multiple times.

Of course it could be that I am just not getting the point.

thanks anyway

[Marco van Herwaarden]

If i look in the install file, i think you have been instructed to make changes to both the './includes/adminfunctions_template.php' and the './admincp/index.php'

[dsboyce8624]

This might sound really dumb stupid, but the first post says something about 2 files requiring modification. It just doesnt say which 2. And please dont anyone jump down my throat if you feel I have overlooked something in the instructions. I have re-read it multiple times.

Of course it could be that I am just not getting the point.

thanks anyway

Marco is right, it's in the install file.

[caimakale]

Once you have run the donations_install.php file and installed the required templates, database tables, etc...., the very last step will show you the two file modifications.

[mamboking]

Marco is right, it's in the install file.


Hi All,

I am trying this hack v1.04 with vBulletin Version 3.0.3. The install was seamless but I had the phrase problem which I found the sloution and I also do not have a the buttons showing when I launch the donate.php.

I seems there should have been a couple of manual edit but I can't seem to find it in the instructions.

Any help would be appreciated

[mamboking]

I think I found my answer. I just read caimakale reply and checked the install php files and found the instructions for the edits. But I don't remember seeing those instrucions during the install but then again I was half asleep.

After trying to manually read extract the the information I needed from the files, which wasn't happening, i noticed a file called edits only. So I decided to run the install again and low and behold. It gives you the option to review the edits that are need. I was under the impress I was looking for a text file or htm file. So for now I have a functioning system. To all who are wondering. It works with vb 3.03

[ManofManyStangs]

How do I get out of the test rfeature and go live?

[dsboyce8624]

How do I get out of the test rfeature and go live?

In settings, first option.

[ManofManyStangs]

where are the settings located?

[caimakale]

In the Admin Control Panel under Donations Admin.

If you don't have that, then you haven't done the file edits.

[aranthorn]

Excellent hack, had to play with the module setting for vBa CMPS v2, but not in your code.

Bravo!

[dsboyce8624]

Excellent hack, had to play with the module setting for vBa CMPS v2, but not in your code.

Bravo!

If you could break it down for us, I'm sure people would appreciate it.

[Neutral Singh]

Excellent neat hack !! I have been looking of this for a long time. :)

I added some donors, who had already made some donations prior to adding this hack but adding these donors has no effect on goal achieved modules. e.g. suppose i have added some donors, who each have contributed $5 but the the goal bit shows that i have got none donations so far. How do i do it so that donations made prior to this hack are also incorporated and are considered towards achieving the goals?

** Addional Request ** It would be wonderful if this hack could present to the members the option of making recurring payments via Paypal. I have some members who contribute $5 on monthly basis using recurring payments feature within paypal. I think there should be a checkbox option (may be manual) for making recurring payments to the members, who do not like making a donation each time but do make automated recurring payments.

Thanks for a very nice hack.

[Cloudrunner]

A donation was made and nothing has change. neither on the main donate.php page...it does not show the donation...I don't know if it takes awhile before it shows up.....
Morning folks --

Sorr I've been away for a day or so, I do have to spend family time with the rest of the clan though...

anyway, in response to your portal block thing, here's the issue that I see...you are all hard-coded. The donations system is a dynamic system that uses 90% of it's power out of the DB. The tables it uses are:

donation_buttons
donation_goals
donation_donators
donation_paypalipn

if you don't pull from the DB using these tables to get the right values, and are not using the correct "custom" variable i.e.<input type="hidden" name="custom" value="donation:*userid*:*goalid*">then the system will not recognize your donation at all...These values MUST come from the database itself. your best bet is to simply link to the donate.php page to make sure that the system recognizes the donation, while the portal block simply pulls the data off of the DB and gives totals.

On a lighter note, I've adjusted most of the donator naming convention that I was using (seems that my small rebellion was confusing / pissing some folks off), and an update will be coming shortly.

[Cloudrunner]

Excellent neat hack !! I have been looking of this for a long time. :)

I added some donors, who had already made some donations prior to adding this hack but adding these donors has no effect on goal achieved modules. e.g. suppose i have added some donors, who each have contributed $5 but the the goal bit shows that i have got none donations so far. How do i do it so that donations made prior to this hack are also incorporated and are considered towards achieving the goals?To get the donations to show against the goal, you must manually add the total donations against the goal itself in the AdminCP. Just edit a goal and you will see where you can change the total donated there, then the donations will count against your goal. There is a reason for my madness in seperating the donors from the goals ;). That reasoning will become evident in the near future. I'm not willing to spout off the reason just yet.** Addional Request ** It would be wonderful if this hack could present to the members the option of making recurring payments via Paypal. I have some members who contribute $5 on monthly basis using recurring payments feature within paypal. I think there should be a checkbox option (may be manual) for making recurring payments to the members, who do not like making a donation each time but do make automated recurring payments.
The reoccuring option is built into the subscriptions system. I am looking into implementing this though, but it's going to take some time while I try to figure out some of the Paypal quirks with subscriptions...Thanks for a very nice hack.Thank you ;)

[Cloudrunner]

Im verified and this is the message I just got from the donation:

"The Transaction Number is: .

It is suggested that you investigate this transaction to determine if it was incorrectly labeled as invalid, or if it was an attempt at a false transaction."
Hey boss, make SURE that you are not running in test mode. The Paypal servers will NOT verify a test mode system....i.e.

Paypal gets a donation from your script
You are running in test mode so when Paypal sends notification to your server your server tries to place a call to the sandbox.
The sandbox says, I didn't initiate this transaction, therefore, it is invalid...

If that's not the issue, then you must do a little investigating on the system side of things (i.e. post what you have in the invalid table (viewable in the admincp) so that I can see where your issue lies) to find your problem (If posting what's in the inavlid table, please make sure to remove any identifiable information such as phone number, address, names, IP addresses, etc. As well as whether your server is in test mode or not, it will also help to provide a view--source of your donate.php buttons. This will assist in troubleshooting).

Yeah, I like that, I will add that to the first post right now....

[TTG]

Does the latest update remove the numerous \r\n ?

[Cloudrunner]

Does the latest update remove the numerous \r\n ?
Yes, the next update addresses this issue. It will be released tonight I'm hoping...

[Cloudrunner]

Troubleshooting tips and procedures

Due to the multitude of possible break-points between Paypal and this script I must request that the following be followed before reequesting support on this system from this point forward:


Do some basic troubleshooting on your own first and see if you can find where the break happened. You might be able to fix it from that.
Check to see that you are not sending test transactions to the live Paypal Server (check your testing setting in AdminCP)
Verify that your custom variable is output as<input type="hidden" name="custom" value="donation:*userid*:*goalid*">
Make sure that you COMPLETED the install 100% (if you did not make it to the settings page at the end of the installation, then you did not complete the installation)
Make sure that you have done the two required file edits (you can go back into the installer to verify this)
If you had a donation made, but have not yet received notification at the script side of the house, then the transaction most likely went into the invalid transactions tables, check there if it is there, and you have verified the top three things above post here for support on this. There is a time lag in the invalid transaction notifications. If you receive an invalid transaction you will receive notification by email to the webmaster address in your vB settings. I need the following information in this circumstance:
A post of the contents of the invalid table with identifiable information removed (ie. transaction id, addresses, phone numbers, IP addresses etc.)
The address to your donate.php file
Whether your system is in test mode or live mode

For basic support problems, then I will need the address to your donate.php so that I can verify that your system is kicking out the proper information to send to paypal
Above all else, please try to be as specific as possible, "The system broke..." doesn't do me any good to assist in giving you support, "The system broke at line 58 with the following error" is much better, and I am much more willing to support your problem with this symptom.

Lastly, if you have modified the base files in any way, I will NOT give support to this. The files are set in the way that they need to be to run under 90% of server installations. Any other installations that require files to be merged, etc., sorry but you are on yer own in that situation.


FYI: The Paypal Notification is completely seperate from the user being sent back to your site. Thus the reason that the ppverify.php file is NOT a function of donate.php.

[VViper]

Get this error at top of page

Warning: Division by zero in /modules/donate.php on line 33

Any ideas?

[Cloudrunner]

Get this error at top of page

Warning: Division by zero in /modules/donate.php on line 33

Any ideas?
You have a goal in the system without an assigned amount...You can't divide X amount of dollars by a total goal of $0.00.

Thank you for finding this bug...would never have noticed it...but I have addressed it and the fix will be included in the next update. Thank you!

[Vman]

I did the whole sandbox thing and all. The Donation bar did not show a different color of where where we were in the donation goal and I get this error message at the top of the screen:

Warning: Division by zero in /donate.php on line 146

Just FYI!

[caimakale]

Read cloudrunners previous post. You don't have a $$$ amount entered in for the goal. You need to go to your ACP Donations Administration, and select your goal. Edit that goal with the dollar amount of the goal.

That should take care of the problem.

[artonex]

Cloudrunner i thank you for your hard work man this hack is getting better all the time :D

[Cloudrunner]

I did the whole sandbox thing and all. The Donation bar did not show a different color of where where we were in the donation goal and I get this error message at the top of the screen:

Warning: Division by zero in /donate.php on line 146

Just FYI!
* Cloudrunner Points Up to Previous Post

[dsboyce8624]

It's not polite to point.

[Vman]

OK, got that working fine, now how do I refresh it so its back to zero since I did a transaction on paypals sandbox?

[aranthorn]

If you could break it down for us, I'm sure people would appreciate it.

When using a module designed for the vBa CMPS v1 in v2, the default type doesn't carry over. So All I did was:

Go to your admincp--vBa CMPS--Edit Modules--Donations

In the dropdown list for 'Change Module Type' select PHP

File to include:
donate.php

Module parent:
none

Templates Used:
adv_portal_donate, adv_portal_donate_goals, adv_portal_donate_goals_user

Clean File Output
No

Those are my settings, works no problem-o :D

[dsboyce8624]

Thanks.

[Cloudrunner]

OK, got that working fine, now how do I refresh it so its back to zero since I did a transaction on paypals sandbox?
refresh what? The goal? Just edit it manually in the AdminCP and put it's total_donations to 0

[Cloudrunner]

When using a module designed for the vBa CMPS v1 in v2, the default type doesn't carry over. So All I did was:

Go to your admincp--vBa CMPS--Edit Modules--Donations

In the dropdown list for 'Change Module Type' select PHP

File to include:
donate.php

Module parent:
none

Templates Used:
adv_portal_donate, adv_portal_donate_goals, adv_portal_donate_goals_user

Clean File Output
No

Those are my settings, works no problem-o :D
Thank you, I added the instructions to the first post, along with credits...Thank you!

[TTG]

Hundreds of \r\n still in install package !?

[Cloudrunner]

Hundreds of \r\n still in install package !?
I have not updated the install yet...current stable version is 1.04...version 1.05 is still a little buggy, will release that when I've squashed them all.

The fix is actually quite simple.

Go into the file ./admincp/donation_install/donation_phrases.php and just replace all the "\r\n"s with a carriage return.

It is addressed in the next update, but as I stated previously, I haven't yet released the next update due to buggy interface at the moment.

[Vman]

refresh what? The goal? Just edit it manually in the AdminCP and put it's total_donations to 0

Done...thanks

[Cloudrunner]

Quick note to let you guys know that I've released v1.05 of the Paypal Donations System. This fix addresses a few bugs (some of them self induced by me, like the \r\n critter, sorry about that...). It also adds the functionality to give your users the options as to whether or not their donation status is shown in public view. This is done via the user's profile options.

You will have to revert all modified templates for the new functions and to fix issues with the phrasing.

Hopefully this will be the last time a full template revert will be required for an update.

Love and light to you all!!!

)O( Cloudrunner )O(

P.s. Please let me know if you run into any problems...with any change to the updater there is always the chance that I added something that I did not catch during testing.

P.p.s. You will need to upload ALL files and overwrite the old ones for this update to work...But only an upgrade is needed to correct the problems and add the new functionalities.

[guvner]

Still using 1.04 and just figured out why my system didnt update after a donation.

The guy I've been using to test it in live mode has a Paypal account but he uses a credit card because he isn't verified.

I didnt know that of course, but to see if it was still a problem, I just had someone else try, he has funds in his account, is verified and it worked fine.

So it seems that if a donor has a verified PP account it's fine, but if someone uses the credit card option, the return codes didnt register with the system - at least for me

Is this designed behaviour?

[guvner]

OK, I just deleted the test donation I just received, I deleted the donor AND the transactions and whilst the admincp is correct, the progressive amount collected hasn't reverted to the pre-donation amount in donate.php - I know I can adjust it manually but should it have happened automatically?

[TTG]

Whoops .. upgrade to 1.05

Warning: explode(): Empty delimiter. in /admincp/donation_install/donation_upgrade.php on line 21

Database error in vBulletin 3.0.6:

Invalid SQL: ALTER TABLE user ADD donor TINYINT(1) DEFAULT '1' NOT NULL
mysql error: Duplicate column name 'donor'

mysql error number: 1060

Date: Sunday 19th of June 2005 11:21:30 PM
Script: http://www.thetechguys.co.uk/retreat/admincp/donations_install.php
Referer: http://www.thetechguys.co.uk/retreat/admincp/donations_install.php
Username: The Tech Guy
IP Address: 82.43.102.40

[dsboyce8624]

Are you sure you clicked Upgrade and not Install?

[TTG]

Are you sure you clicked Upgrade and not Install?

Yep .. clicked upgrade.

Now I can't access anything .. can't even un-install and start again.

Darn .. just got 1.04 working fine .. :ermm:

[dsboyce8624]

I'd turn off the CMPS Module and wait for the big man.

[Cloudrunner]

OK, I just deleted the test donation I just received, I deleted the donor AND the transactions and whilst the admincp is correct, the progressive amount collected hasn't reverted to the pre-donation amount in donate.php - I know I can adjust it manually but should it have happened automatically?
I have not coded that function in, truth be told, I never even thought about that...will get it in the next one.

[Cloudrunner]

Still using 1.04 and just figured out why my system didnt update after a donation.

The guy I've been using to test it in live mode has a Paypal account but he uses a credit card because he isn't verified.

I didnt know that of course, but to see if it was still a problem, I just had someone else try, he has funds in his account, is verified and it worked fine.

So it seems that if a donor has a verified PP account it's fine, but if someone uses the credit card option, the return codes didnt register with the system - at least for me

Is this designed behaviour?

No that is not the designed behaviour, check to see if the CC requires you to accept that payment in the paypal system itself before it is termed 'Completed'. If paypal requires you to accept a payment manually then it will not send an IPN with 'Completed' until after you have accepted it on the paypal site. Of course, this should be picked up by the system as 'Pending' if your paypal sent an IPN after the transaction occured and if Paypal sent an IPN with 'Pending' as the payment status the system *should* have placed that into the transactions listing, and you *should* have a 'Pending' transaction listed in the admincp...

will look into that in abit....

[Cloudrunner]

Whoops .. upgrade to 1.05

Warning: explode(): Empty delimiter. in /admincp/donation_install/donation_upgrade.php on line 21

Database error in vBulletin 3.0.6:

Invalid SQL: ALTER TABLE user ADD donor TINYINT(1) DEFAULT '1' NOT NULL
mysql error: Duplicate column name 'donor'

mysql error number: 1060

Date: Sunday 19th of June 2005 11:21:30 PM
Script: http://www.thetechguys.co.uk/retreat/admincp/donations_install.php
Referer: http://www.thetechguys.co.uk/retreat/admincp/donations_install.php
Username: The Tech Guy
IP Address: 82.43.102.40

Was not expecting an empty set there, sorry...

Anyway, attached is the correct donation_upgrade.php file.

Upload that into the ./admincp/donation_install/ directory, then put your vbulletin into debug mode (put $debug = 1; in your config.php file just above the line that says // ****** DATABASE SERVER NAME ******) and in the vB settings 'untouchables' change your ppdonations version to 1.04 then take your vBulletin out of debug mode and re-run the installer, you will see the option for the updater now. Try again from there let me know how you fair...

I also updated the archive in the first post to reflect this change in the upgrader code.

[Cloudrunner]

Does anyone know this person? Strange request...don't think it's kosher...

-----Original Message-----
From: Mukke [mukke@warfieldgames.com]
Sent: Thursday, June 16, 2005 9:39 PM
To: tnp@noblepagan.com
Subject: vBulletin PayPal donation script

Hey Cloudrunner
It seems i have a problem.
I wonna download ur hack from vbulletin.org , but i forgot my licency number and password. That's just the worst what could happen.
Maybe u could just mail it to me? Do u agree?
Regards Mukke,

Your thoughts?

[guvner]

quick answer - nope!

He's using Version 2.3.3 so whilst he may have really forgotten it, his best bet would be to contact VB and request the information in the same way that anybody else here would have to.

Not only that but I'm guessing the good folks here at VB.org might have a thing or two to say, after all nothing's visible here (code) without a valid license, and isn't that the point?

[Cloudrunner]

quick answer - nope!

He's using Version 2.3.3 so whilst he may have really forgotten it, his best bet would be to contact VB and request the information in the same way that anybody else here would have to.
Yer alot nicer than I was....