thanks 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. whereas the actual path is

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.

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.

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.

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 ;)

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?

Forget this one - I just re-ran the installer's first page and got my answer ;)

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

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:

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

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

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.

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.

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

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

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.

just a quick question

http://www.oanda.com/convert/fxdaily...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.

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

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.

will this work on vbadanced v2 portal?

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.

We haven't tried yet.

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

Beyond me. Have to wait for CR.

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

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

Fixed both of these, thank you for finding them.

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.

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:
Again thanks folks for being patient with me, I'll get this fixed and we'll go from there.

)O( Cloudrunner )O(

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:

1. Fixed bug where on installation the currency exchanges were not being populated properly.
2. Changed user list on "Add Donator" page in AdminCP to be sorted alphabetically.
3. Fixed Avatar display for custom avatars in the AdminCP.
4. 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!





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(

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.

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

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.

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?

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.

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!).

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

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:

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:

change it to:

(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!