Paypal Donations for vBulletin 3.0.7

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( of The Noble Pagan.

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 AdminCP

Paypal 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
SLeeeper
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 Categories

Stuff 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

or

http://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/admi...ns_install.php

or

http://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:

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.

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:

1. Make sure transaction is valid
2. Edit invalid transaction to show as valid
3. Edit goal and add that transaction amount to the total
4. Edit / Add donor (user) to the DB to give credit

This 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:

1. 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.
2. Check to see that you are not sending test transactions to the live Paypal Server (check your testing setting in AdminCP)
3. Verify that your custom variable is output as

   <input type="hidden" name="custom" value="donation:*userid*:*goalid*">

4. 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)
5. Make sure that you have done the two required file edits (you can go back into the installer to verify this)
6. 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:
   1. A post of the contents of the invalid table with identifiable information removed (ie. transaction id, addresses, phone numbers, IP addresses etc.)
   2. The address to your donate.php file
   3. Whether your system is in test mode or live mode
7. 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
8. 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 Instructions on how to get this to work.
https://vborg.vbsupport.ru/showpost.php?p=669033&postcount=231

Thank you aranthorn!!!

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

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

LICENSE:

Originally Posted by Brandon J. Briggs aka. Cloudrunner

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]

Originally Posted by TheWebJunkie

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

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.

[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...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?