Ask your WordPress questions! Pay money and get answers fast! (more info)

Choose amount

  • SOLVED

At my website I'm using WP donate plugin (http://www.nonprofitcms.org/2010/12/wordpress-donate-plugin.) to manage donation campaigns.
How donors might choose sum of their donations from the list of dynamically created options?

Answers (3)

2011-06-16

Fahad Murtaza answers:

This code will edit your existing database, please run it so that you can enter comma separated values to display in drop down



ALTER TABLE `wp_campaigns` CHANGE `camp_goal_amt` `camp_goal_amt` VARCHAR( 100 ) NULL DEFAULT '0'



So that your database table is altered to save new fields as comma separated.

Now change line # 1162 an comment out like following



/* if( ! is_numeric($_POST["camp_goal_amt"] ) ){
$_POST['notice']= "Please enter valid goal amount.";
return false;
}
*/



and line # 1109




/*if( ! is_numeric($_POST["camp_goal_amt"] ) ){
$_POST['notice']= "Please enter valid goal amount.";
return false;
}*/



So these are the lines which validate your data entry to be an integer which in case of comma separated input will be different.

[[LINK href="http://www.webpagescreenshot.info/img/583932-6162011114403pm.png"]] This is how [[/LINK]] it looked after I did this. Now being able to save as comma separated values, you can save new values which you will parse in the front end form to be displayed as drop down.

I have pasted below the code for mydonate.php which I modified to show these comma separated values as drop down and tested with the actual payment on paypal



<?php
# /*
# Plugin Name: WordPress Donation Plugin with Goals and Paypal IPN by NonprofitCMS.org
# Plugin URI: http://www.nonprofitcms.org/2010/12/wordpress-donate-plugin/
# Description: The NonprofitCMS WordPress Donate Plugin allows you to create unlimited donation campaigns with goals, capture donor information and gives a donation thermometer for each campaign! Visit plugin website for premium version which removes credits link and provides ability to export to CSV.
# Author: NonprofitCMS
# Version: 1.0
# Author URI: http://www.nonprofitcms.org
# */

if( $_GET['page'] == 'ViewAllHandle' && ( $_GET['doaction'] || $_GET['delete'] ) )
{
global $wpdb;
$tb = $wpdb->prefix.'campaigns';

if( $_GET['action'] == 'delete' || $_GET['delete']) {

if( $_GET['action'] ) { $dIDs = $wpdb->escape($_GET['donor']); }

$mngpg = get_option('siteurl').'/wp-admin/admin.php?page=ViewAllHandle';


if( $_GET['delete'] ) { $dIDs[] = $wpdb->escape($_GET['delete']); }

foreach( $dIDs as $dID ) {
$del = "DELETE FROM $tb WHERE camp_id = $dID LIMIT 1";
//echo $del; //exit;
$wpdb->query($del);
$msg = 2;
} // End of foreach loop

header("Location : $mngpg&msg=2");
}

}


$donate_version = "1.0";

include_once('dpay-widget.php');

if( !class_exists('MyWpDonate') )
{
class MyWpDonate{

function MyWpDonate() { //constructor

//ACTIONS
//Add Menu in Left Side bar
add_action( 'admin_menu', array($this, 'my_plugin_menu') );

// add_action( 'admin_head', array($this, 'icon_css') );

#Update Settings on Save
if( $_POST['action'] == 'camp_add' )
add_action( 'init', array($this,'SaveNewCampaign') );


if( $_POST['action'] == 'camp_edit' )
add_action( 'init', array($this,'SaveEditCampaign') );


# Update General Settings
if( $_POST['action'] == 'pay_update' )
add_action( 'init', array($this,'saveGeneralSettings') );


#Save Default Settings
//add_action( 'init', array($this, 'DefaultSettings') );
#Uninstall Donate Plus
if( $_POST['action'] == 'dplus_delete' )
add_action( 'init', array($this,'UninstallDP') );

//SHORTCODES
#Add Form Shortcode
add_shortcode('wpdonatebuy', array($this, 'MyDonatePage') );

add_shortcode('wpdonategoal', array($this, 'showdonategoal') );

add_shortcode('wpdonatecollected', array($this, 'donationcollection') );

add_shortcode('wpdonatemeter', array($this, 'donatemeter') );

add_shortcode('confirmdonation', array($this, 'confirmdonation') );

add_shortcode('wpdonatorlist', array($this, 'donatorlist') );

add_action( 'wp_head', array($this, 'email_js') );

//INSTALL TABLE
#Runs the database installation for the wp_donations table
register_activation_hook( __FILE__, array($this, 'MyDonateInstall') );


}

function my_plugin_menu() {

global $objDonate;

add_menu_page('Donation Goals', 'Donation Goals', 'manage_options', 'MyDonate', array($objDonate, 'ViewAllCampaign'), 'div' );
add_submenu_page( 'MyDonate', 'Donation Goals | View All Campaigns', 'View All Campaigns', 'manage_options', 'ViewAllHandle', array($objDonate, 'ViewAllCampaign'));
add_submenu_page( 'MyDonate', 'Donation Goals | Add Campaign', 'Add Campaign', 'manage_options', 'AddCampaignHandle', array($objDonate, 'AddCampaign'));
add_submenu_page( 'MyDonate', 'Donation Goals | General Settings', 'General Settings', 'manage_options', 'GeneralSettings', array($objDonate, 'GeneralSttings'));

//add_menu_page('Page title', 'Top-level menu title', 'manage_options', 'my-top-level-handle', 'my_magic_function');
//add_submenu_page( 'my-top-level-handle', 'Page title', 'Sub-menu title', 'manage_options', 'my-submenu-handle', 'my_magic_function');

}



function email_js() {

echo '<link type="text/css" rel="stylesheet" href="' . get_bloginfo('wpurl') . '/wp-content/plugins/donation-goals-paypal-ipn-nonprofitcms-free/mydonate.css" />';
}




// View All Campaign


function ViewAllCampaign()
{

if (!current_user_can('manage_options')) {
wp_die( __('You do not have sufficient permissions to access this page.') );
}


if($_GET["dID"] != "" ) {

$this->ViewDonation();

} else {

global $wpdb;

$table_name = $wpdb->prefix.'campaigns';
$mngpg = get_option('siteurl').'/wp-admin/admin.php?page=ViewAllHandle';
$editpg=get_option('siteurl').'/wp-admin/admin.php?page=AddCampaignHandle';

$campaigns = $wpdb->get_results("SELECT * FROM $table_name ORDER BY camp_id DESC");

if( $_GET['s'] ):
$s = $wpdb->escape($_GET['s']);
$sq = "SELECT * FROM $table_name WHERE camp_name LIKE '%$s%' ORDER BY camp_id DESC";
$campaigns = $wpdb->get_results($sq);
endif;

$don_table_name = $wpdb->prefix.'donation';

?>
<div class="wrap">
<h2><?php _e('View All Campaigns');?></h2>
<?php
if( $_REQUEST['delete'] != "" || $_REQUEST["action"]=="delete" ) {
echo '<div id="message" class="updated fade"><p><strong>Campaign successfully deleted.</strong></p></div><br>';
}
?>

<form id="donate-filter" action="<?php echo $mngpg;?>" method="get">

<input type="hidden" name="page" value="ViewAllHandle" />

<p class="search-box">
<label class="screen-reader-text" for="page-search-input"><?php _e('Search Campaign');?></label>
<input type="text" id="donate-search-input" name="s" value="<?php echo $_GET["s"]; ?>" />
<input type="submit" value="<?php _e('Search Campaign');?>" class="button" />

</p>

<div class="tablenav">

<div class="alignleft actions">
<select name="action">
<option value="-1" selected="selected"><?php _e('Bulk Actions');?></option>
<option value="delete"><?php _e('Delete');?></option>
</select>
<input type="submit" value="<?php _e('Apply');?>" name="doaction" id="doaction" class="button-secondary action" />
</div>

<br class="clear" />
</div>

<div class="clear"></div>

<table class="widefat page fixed" cellspacing="0">
<thead>
<tr>
<th scope="col" id="cb" class="manage-column column-cb check-column" style=""><input type="checkbox" /></th>
<th scope="col" id="campid" class="manage-column column-donorname" style=""><?php _e('Campaign ID');?></th>
<th scope="col" id="campname" class="manage-column column-amount" style=""><?php _e('Campaign name');?></th>
<th scope="col" id="campdate" class="manage-column column-comment" style=""><?php _e('Date');?></th>
<th scope="col" id="campgoal" class="manage-column column-date" style=""><?php _e('Goal Amount');?></th>
<th scope="col" id="campamt" class="manage-column column-date" style=""><?php _e('Amount Received');?></th>
<th scope="col" id="campact" class="manage-column column-date" style=""><?php _e('Action');?></th>

</tr>
</thead>

<tfoot>
<tr>

<th scope="col" class="manage-column column-cb check-column" style=""><input type="checkbox" /></th>
<th scope="col" class="manage-column column-donorname" style=""><?php _e('Campaign ID');?></th>
<th scope="col" class="manage-column column-amount" style=""><?php _e('Campaign name');?></th>
<th scope="col" class="manage-column column-comment" style=""><?php _e('Date');?></th>
<th scope="col" class="manage-column column-date" style=""><?php _e('Goal Amount');?></th>
<th scope="col" class="manage-column column-date" style=""><?php _e('Amount Received');?></th>
<th scope="col" class="manage-column column-date" style=""><?php _e('Action');?></th>
</tr>
</tfoot>

<tbody>
<?php
foreach( $campaigns as $campaign ):
if( $alt ) $alt = false; else $alt = 'alternate';

$donate_rw = $wpdb->get_results("SELECT sum(don_amt) as totalreceive FROM $don_table_name WHERE don_camp_id=".$campaign->camp_id);
//print_r($donate_rw);
?>
<tr class="<?php echo $alt;?> iedit">
<th scope="row" class="check-column"><input type="checkbox" name="donor[]" value="<?php echo $campaign->camp_id;?>" /></th>

<td class="donorname">

<strong><a class="row-title" href="<?php echo $mngpg.'&amp;dID='.$campaign->camp_id;?>" title="<?php _e('View Detail'); echo $campaign->camp_id;?>"><?php
$c_id='';
if(strlen($campaign->camp_id) ==1){
$c_id="C00".$campaign->camp_id;
} else if(strlen($campaign->camp_id)==2){
$c_id="C0".$campaign->camp_id;
} else {
$c_id="C".$campaign->camp_id;
}
echo $c_id;
?></a></strong>
<div class="row-actions">
<span class="edit"><a href="<?php echo $mngpg.'&amp;dID='.$campaign->camp_id;?>" title="<?php _e('View Detail');?>"><?php _e('View Detail');?></a>
</div>
</td>
<td class="amount"><?php echo $campaign->camp_name;?></td>
<td class="amount"><?php echo $campaign->camp_create_date;?></td>
<td class="comment"><?php echo "$".$campaign->camp_goal_amt;?></td>
<td class="date"><?php if( $donate_rw[0]->totalreceive != "") { echo "$".$donate_rw[0]->totalreceive; } else { echo "$0"; };?></td>

<td class="date">
<span class="edit"><a href="<?php echo $editpg.'&amp;edit='.$campaign->camp_id;?>" title="<?php _e('Edit this Campaign');?>"><?php _e('Edit');?></a> | </span><span class="delete"><a class="submitdelete" title="<?php _e('Delete this Campaign');?>" href="<?php echo $mngpg.'&amp;delete='.$campaign->camp_id;?>"><?php _e('Delete');?></a> </span>

</td>
</tr>

<?php
endforeach;
?>

</tbody>
</table>
</form>

</div>

<?php
} //end of if

} // end of viewallcampagin function

// view donation fnction for display donations of a campaign

function ViewDonation()
{
global $wpdb;

$dId= $_GET["dID"];

$table_name = $wpdb->prefix.'campaigns';

$DtableName = $wpdb->prefix.'donation';

$mngpg = get_option('siteurl').'/wp-admin/admin.php?page=ViewAllHandle&dID='.$dId;

$editpg=get_option('siteurl').'/wp-admin/admin.php?page=AddCampaignHandle';

$campaigns = $wpdb->get_results("SELECT * FROM $table_name WHERE camp_id=$dId");

$donations = $wpdb->get_results("SELECT * FROM $DtableName WHERE don_camp_id=$dId");

if( $_GET['s'] ):
$s = $wpdb->escape($_GET['s']);
$sq = "SELECT * FROM $DtableName WHERE don_first_name LIKE '%$s%' OR don_last_name LIKE '%$s%' OR don_email LIKE '%$s%' ORDER BY don_id ASC";
$donations = $wpdb->get_results($sq);
endif;
?>

<div class="wrap">
<h2><?php echo "View all donation for campaign : ".$dId." - ".$campaigns[0]->camp_name;?></h2>




<div style="width: 400px; float: right;">

<form id="donate-filter" action="<?php echo $mngpg;?>" method="get">

<input type="hidden" name="page" value="ViewAllHandle&amp;dID=<?php echo $dId; ?>" />

<p class="search-box" style="float: right;">
<label class="screen-reader-text" for="page-search-input"><?php _e('Search Donation');?></label>
<input type="text" id="donate-search-input" name="s" value="" />
<input type="submit" value="<?php _e('Search Donation');?>" class="button" />

</p>

</form>
<div style="float: left;">&nbsp;</div>
<div style=" clear: both;"></div>
</div>

<div class="tablenav">

<!--<div class="alignleft actions">
<select name="action">
<option value="-1" selected="selected"><?php //_e('Bulk Actions');?></option>
<option value="delete"><?php //_e('Delete');?></option>
</select>
<input type="submit" value="<?php //_e('Apply');?>" name="doaction" id="doaction" class="button-secondary action" />
</div> -->

<br class="clear" />
</div>

<div class="clear"></div>

<table class="widefat page fixed" cellspacing="0">
<thead>
<tr>

<th scope="col" id="donid" class="manage-column column-donorname" style=""><?php _e('Donation ID');?></th>
<th scope="col" id="dondate" class="manage-column column-amount" style=""><?php _e('Date');?></th>
<th scope="col" id="amtreceived" class="manage-column column-comment" style=""><?php _e('Amount Received');?></th>
<th scope="col" id="donfirstname" class="manage-column column-date" style=""><?php _e('First Name');?></th>
<th scope="col" id="donlastname" class="manage-column column-date" style=""><?php _e('Last Name');?></th>
<th scope="col" id="donlastname" class="manage-column column-date" style=""><?php _e('Transaction Id');?></th>
<th scope="col" id="donemail" class="manage-column column-date" style=""><?php _e('Email');?></th>

</tr>
</thead>

<tfoot>
<tr>
<th scope="col" class="manage-column column-donorname" style=""><?php _e('Donation ID');?></th>
<th scope="col" class="manage-column column-amount" style=""><?php _e('Date');?></th>
<th scope="col" class="manage-column column-comment" style=""><?php _e('Amount Received');?></th>
<th scope="col" class="manage-column column-date" style=""><?php _e('First Name');?></th>
<th scope="col" class="manage-column column-date" style=""><?php _e('Last Name');?></th>
<th scope="col" class="manage-column column-date" style=""><?php _e('Transaction Id');?></th>
<th scope="col" class="manage-column column-date" style=""><?php _e('Email');?></th>
</tr>
</tfoot>

<tbody>
<?php
if( $wpdb->num_rows > 0 ) {
foreach( $donations as $donation ):
if( $alt ) $alt = false; else $alt = 'alternate';
?>
<tr class="<?php echo $alt;?> iedit">

<td >
<?php
$d_id='';
if(strlen($donation->don_id) ==1){
$d_id="D00".$donation->don_id;
} else if(strlen($donation->don_id)==2){
$d_id="D0".$donation->don_id;
} else {
$d_id="D".$campaign->don_id;
}
echo $d_id;
?>

</td>
<td ><?php echo $donation->don_date;?></td>
<td ><?php echo "$".$donation->don_amt;?></td>
<td ><?php echo $donation->don_first_name;?></td>
<td ><?php echo $donation->don_last_name;?></td>
<td ><?php echo $donation->txn_id;?></td>

<td>

<?php echo $donation->don_email;?>
</td>
</tr>

<?php
endforeach;
} else {

?>
<tr height="40px;">
<td colspan="6" style="padding:10 0 0 10;" >Donations not available</td>

</tr>
<?php } ?>
</tbody>
</table>

</div>

<?php

} // end of view donation function

// Add Campaign form display

function AddCampaign()
{

if (!current_user_can('manage_options')) {
wp_die( __('You do not have sufficient permissions to access this page.') );
}

if( $_GET["edit"] != "" ){
$this->EditCampaign();
} else {
?>
<div class="campaignName">
<h3>Add Campaign</h3>

<?php
if( $_POST['notice'] ) {
echo '<div id="message" class="updated fade"><p><strong>' . $_POST['notice'] . '</strong></p></div><br>';
}
?>

<form name="campform" id="campform" method="post" action="" >

<table width="50%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="35%">Campaign Name</td>
<td width="65%"><input type="text" name="camp_name" id="camp_name" /></td>
</tr>
<tr>
<td>Goal Amount (USD)</td>
<td><input type="text" name="camp_goal_amt" id="camp_goal_amt" /></td>
</tr>

<tr>
<td>Description</td>
<td><textarea name="camp_descr" rows="3" cols="40"></textarea></td>
</tr>

</table>

<br />
<table width="50%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="35%">Include these fields</td>
<td width="65%">&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_title" id="camp_field_title" /> <label for="camp_field_title">Title</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_first_name" id="camp_field_first_name" />
<label for="camp_field_first_name">First Name</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_last_name" id="camp_field_last_name" />
<label for="camp_field_last_name">Last Name</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_country" id="camp_field_country" />
<label for="camp_field_country">Country</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_address" id="camp_field_address" />
<label for="camp_field_address">Address Lines</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_city" id="camp_field_city" />
<label for="camp_field_city">City</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_state" id="camp_field_state" />
<label for="camp_field_state">State</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_zip" id="camp_field_zip" />
<label for="camp_field_zip">ZIP</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_phone" id="camp_field_phone" />
<label for="camp_field_phone">Phone</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_email" id="camp_field_email" />
<label for="camp_field_email">E-mail</label></td>
</tr>

<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_anonymous" id="camp_field_anonymous" />
<label for="camp_field_anonymous">Would you like to remain anonymous?</label></td>
</tr>

<tr height="20px;">
<td colspan="2" >&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>
<input type="submit" class="button-primary" name="button" id="button" value="Create Campaign" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
<input name="action" value="camp_add" type="hidden" />

</form>

</div>
<?php
} //end of if

} //end of add campaign function

// Edit Campaign Function

function EditCampaign()
{

global $wpdb;
$table_name = $wpdb->prefix.'campaigns';

$cID = $_GET['edit'];
$CampRow = $wpdb->get_row("SELECT * FROM $table_name WHERE camp_id=$cID");
?>

<div class="wrap">
<h3>Edit Campaign</h3>
<form name="campform" id="campform" method="post" action="" >
<?php if( function_exists( 'wp_nonce_field' )) wp_nonce_field( 'update-options'); ?>

<?php
if( $_POST['notice'] ) {
echo '<div id="message" class="updated fade"><p><strong>' . $_POST['notice'] . '</strong></p></div>';
}
?>
<table width="50%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="35%">Campaign Name</td>
<td width="65%"><input type="text" name="camp_name" value="<?php echo $CampRow->camp_name; ?>" id="camp_name" /></td>
</tr>
<tr>
<td>Goal Amount (USD)</td>
<td><input type="text" name="camp_goal_amt" id="camp_goal_amt" value="<?php echo $CampRow->camp_goal_amt; ?>" /></td>
</tr>

<tr>
<td>Description</td>
<td><textarea name="camp_descr" rows="3" cols="40"><?php echo $CampRow->camp_descr; ?></textarea></td>
</tr>

</table>
<br />
<br />
<table width="50%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="35%">Include these fields</td>
<td width="65%">&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_title" <?php if($CampRow->camp_field_title == 1 ) { echo "checked=\"checked\""; } ?> id="camp_field_title" /> <label for="camp_field_title">Title</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_first_name" id="camp_field_first_name" <?php if($CampRow->camp_field_first_name == 1 ) { echo "checked=\"checked\""; } ?> />
<label for="camp_field_first_name">First Name</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_last_name" id="camp_field_last_name" <?php if($CampRow->camp_field_last_name == 1 ) { echo "checked=\"checked\""; } ?> />
<label for="camp_field_last_name">Last Name</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_country" id="camp_field_country" <?php if($CampRow->camp_field_country == 1 ) { echo "checked=\"checked\""; } ?> />
<label for="camp_field_country">Country</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_address" id="camp_field_address" <?php if($CampRow->camp_field_address == 1 ) { echo "checked=\"checked\""; } ?> />
<label for="camp_field_address">Address Lines</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_city" id="camp_field_city" <?php if($CampRow->camp_field_city == 1 ) { echo "checked=\"checked\""; } ?> />
<label for="camp_field_city">City</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_state" id="camp_field_state" <?php if($CampRow->camp_field_state == 1 ) { echo "checked=\"checked\""; } ?> />
<label for="camp_field_state">State</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_zip" id="camp_field_zip" <?php if($CampRow->camp_field_zip == 1 ) { echo "checked=\"checked\""; } ?> />
<label for="camp_field_zip">ZIP</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_phone" id="camp_field_phone" <?php if($CampRow->camp_field_phone == 1 ) { echo "checked=\"checked\""; } ?> />
<label for="camp_field_phone">Phone</label></td>
</tr>


<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_email" id="camp_field_email" <?php if($CampRow->camp_field_email == 1 ) { echo "checked=\"checked\""; } ?> />
<label for="camp_field_email">E-mail</label></td>
</tr>

<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_anonymous" id="camp_field_anonymous" <?php if($CampRow->camp_field_anonymous == 1 ) { echo "checked=\"checked\""; } ?> />
<label for="camp_field_anonymous">Would you like to remain anonymous?</label></td>
</tr>

<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>

<tr height="20px;" >
<td>&nbsp;</td>
<td>
<input type="submit" name="button" class="button-primary" id="button" value="Save Changes" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
<input name="action" value="camp_edit" type="hidden" />
<input type="hidden" value="<?php echo $CampRow->camp_id;?>" name="cID" />
</form>

</div>

<?php
} // end of editCampaign Function


function GeneralSttings()
{

$emailId = get_option( 'paypal_email_id' );

$payMsg = get_option( 'paypal_email_msg' );

$confirmUrl = get_option( 'wpconfirm_url' );

$fromAddress = get_option( 'from_address' );

$emailSubject = get_option( 'email_subject' );


?>
<div class="campaignName">
<h3>General Settings</h3>
<?php if ( !empty($_POST ) ) { ?>
<div id="message" class="updated fade"><p><strong><?php _e('Settings saved.') ?></strong></p></div><br />
<?php } ?>
<form name="generalform" id="generalform" method="post" action="" >

<table width="50%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="35%">PayPal Account Email Address</td>
<td width="65%"><input type="text" name="paypal_email_id" value="<?php _e($emailId); ?>" id="paypal_email_id" /></td>
</tr>

<tr>
<td style="vertical-align: text-bottom;">Email From Address</td>
<td><input type="text" name="from_address" value="<?php _e($fromAddress); ?>" id="from_address" /></td>
</tr>

<tr>
<td style="vertical-align: text-bottom;">Email Subject</td>
<td><input type="text" name="email_subject" value="<?php _e($emailSubject); ?>" id="email_subject" /></td>
</tr>

<tr>
<td style="vertical-align: text-bottom;">Email Text</td>
<td><textarea name="paypal_email_msg" rows="5" cols="40"><?php _e($payMsg); ?></textarea></td>
</tr>




<tr>
<td style="vertical-align: text-bottom;">Confirmation Return URL</td>
<td><input type="text" name="wpconfirm_url" style="width:320px;" value="<?php _e($confirmUrl); ?>" id="wpconfirm_url" />
</td>
</tr>


<tr>
<td colspan="2" >&nbsp;</td>
</tr>

<tr height="20px;" >
<td>&nbsp;</td>
<td>
<input type="submit" name="button" id="button" class="button-primary" value="<?php echo _e("Save Changes"); ?>" /></td>
</tr>

</table>

<input name="action" value="pay_update" type="hidden" />

</form>

</div>

<?php

} // end of General Setting function


// Show Donate page In front Area

function MyDonatePage( $arr )
{
//echo "Rajendra KUmar Jangid";
// print_r( $arr );
// echo $arr["id"];
if($arr["cid"] == "" ) {
echo "Please Enter Campaign Id";
die();
}

global $wpdb;
$table_name = $wpdb->prefix.'campaigns';
$wpdb->flush();

$CampRow = $wpdb->get_row("SELECT * FROM $table_name WHERE camp_id=".$arr["cid"]);

$defaultAmt=0;
$paypal_currency="USD";

$emailId = get_option( 'paypal_email_id' );

$notify = str_replace(ABSPATH, trailingslashit(get_option('siteurl')), dirname(__FILE__)).'/paypal.php';
$img_urlz = array( '1'=>'https://www.paypal.com/en_US/i/btn/btn_donate_LG.gif', '2'=>'https://www.paypal.com/en_US/i/btn/btn_donate_SM.gif', '3'=>'https://www.paypal.com/en_US/i/btn/btn_donateCC_LG.gif', '4'=>$dplus['custom_button']);
//$button = $img_urlz[$dplus['button_img']];

$button = "https://www.paypal.com/en_US/i/btn/btn_donate_LG.gif";


if( $dplus['wall_url'] == 'sidebar') $wall = get_option('siteurl');
else $wall = get_permalink($dplus['wall_url']);
if( strpos($wall, '?') === false )
$tyurl = $wall.'?thankyou=true';
else
$tyurl = $wall.'&amp;thankyou=true';

$tyurl=get_option( 'wpconfirm_url' );

$verifyurlz = array( '1' => 'https://www.paypal.com/cgi-bin/webscr', '2'=> 'http://www.belahost.com/pp/', '3'=>'https://www.sandbox.paypal.com/cgi-bin/webscr');

if( $wpdb->num_rows > 0 ) {

$output = '<form id="mydonate" action="'.$verifyurlz[1].'" method="post"><div class="mydonatebox">';



if($CampRow->camp_field_title == 1 ){
$output .='<p class="donate_amount"><strong><label>'.__($CampRow->camp_name).'</label></strong></p>';
}


//$output .='<p class="donate_amount"><label for="amount">'.__($CampRow->camp_descr).'</label> </p>';
//<p class="donate_amount"><label for="amount">'.__('Amount $').':</label> <input type="text" name="amount" id="amount" value="'.$defaultAmt.'" /></p>';

$output .='<input type="hidden" id="cmd" name="cmd" value="_donations">';

if($CampRow->camp_field_first_name == 1 ){
$output .='<p class="donate_amount"><label for="amount">'.__('First Name').':</label><input type="text" name="first_name" id="first_name" /></p>';
}

if($CampRow->camp_goal_amt !='' ){

$donate_values = $CampRow->camp_goal_amt;
$values= explode(',',$donate_values);
$output .='<p class="donate_amount"><label for="amount">'.__('Select Amount').':</label>';
$output .='<select name="amount">';

foreach ($values as $value) :
$output .='<option value="'.$value.'">'.$value.'</option>';
endforeach;

$output .='</select></p>';


}
if($CampRow->camp_field_last_name == 1 ){
$output .='<p class="donate_amount"><label for="amount">'.__('Last Name').':</label><input type="text" name="last_name" id="last_name" /></p>';
}

if($CampRow->camp_field_email == 1 ){
$output .='<p class="donate_amount"><label for="amount">'.__('Email').':</label><input type="text" name="email" id="email" /></p>';
}

if($CampRow->camp_field_country == 1 ){
$output .='<p class="donate_amount"><label for="amount">'.__('Country').':</label><input type="text" name="country" id="country" /></p>';
}


if($CampRow->camp_field_address == 1 ){
$output .='<p class="donate_amount"><label for="amount">'.__('Address').':</label><input type="text" name="address1" id="address1" /></p>';
}


if($CampRow->camp_field_city == 1 ){
$output .='<p class="donate_amount"><label for="amount">'.__('City').':</label><input type="text" name="city" id="city" /></p>';
}


if($CampRow->camp_field_state == 1 ){
$output .='<p class="donate_amount"><label for="amount">'.__('State').':</label><input type="text" name="state" id="state" /></p>';
}

if($CampRow->camp_field_zip == 1 ){
$output .='<p class="donate_amount"><label for="amount">'.__('Zip').':</label><input type="text" name="zip" id="zip" /></p>';
}


if($CampRow->camp_field_phone == 1 ){
$output .='<p class="donate_amount"><label for="amount">'.__('Phone').':</label><input type="text" name="night_phone_a" id="night_phone_a" /></p>';
}



$output .= '
<input type="hidden" name="notify_url" value="'.$notify.'">
<input type="hidden" name="item_name" value="'.$CampRow->camp_name.'">
<input type="hidden" name="business" value="'.$emailId.'">
<input type="hidden" name="return" value="'.$tyurl.'">
<input type="hidden" name="custom" value="'.$CampRow->camp_id.'#'.$CampRow->camp_name.'">
<input type="hidden" name="currency_code" value="'.$paypal_currency.'">
<input type="hidden" name="bn" value="PP-DonationsBF:btn_donateCC_LG.gif:NonHosted">
<p class="submit"><input type="image" src="'.$button.'" border="0" name="submit" alt="">
<img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1"><br/>
</p>
</div></form><br/>';
} else {

$output= "Campaign Not Available";
}
return $output;

}


function showdonategoal( $arr )
{

if($arr["cid"] == "" ) {
echo "Please Enter Campaign Id";
die();
}

global $wpdb;
$table_name = $wpdb->prefix.'campaigns';
$wpdb->flush();

$CampRow = $wpdb->get_row("SELECT * FROM $table_name WHERE camp_id=".$arr["cid"]);

if( $wpdb->num_rows > 0 ) {

$output =$CampRow->camp_goal_amt .'</p>';

} else {
$output= "Campaign Not Available";
}

return $output;
}


// this calculate donation amount

function donationcollection( $arr )
{

if($arr["cid"] == "" ) {
echo "Please Enter Campaign Id";
die();
}

global $wpdb;
$table_name = $wpdb->prefix.'donation';
$wpdb->flush();

$amt=0;

$CampRow = $wpdb->get_row("SELECT sum(don_amt) as totalamt FROM $table_name WHERE don_camp_id=".$arr["cid"]);

if( $wpdb->num_rows > 0 ) {

if($CampRow->totalamt != "" ) {

$amt=$CampRow->totalamt;

}

$output =$amt.'</p>';

} else {
$output= "Campaign Not Available";
}

return $output;
}

//Display donars List if arg pass the

function donatorlist( $arr )
{

global $wpdb;
$wpdb->flush();

$sql="SELECT
wp_donation.don_id,
wp_donation.don_camp_id,
wp_donation.don_amt,
wp_donation.don_first_name,
wp_donation.don_last_name,
wp_donation.don_email,
wp_donation.don_address,
wp_donation.don_country,
wp_donation.don_city,
wp_donation.don_state,
wp_donation.don_zip,
wp_donation.don_phone,
wp_donation.txn_id,
wp_donation.don_date,
wp_campaigns.camp_field_anonymous
FROM
wp_donation
Inner Join wp_campaigns ON wp_donation.don_camp_id = wp_campaigns.camp_id
WHERE
wp_campaigns.camp_field_anonymous <> '1'";

if( $arr["cid"] != "" ) {
$sql .=" AND wp_donation.don_camp_id = '".$arr["cid"]."'";
}

$donorLists = $wpdb->get_results($sql);

if( $wpdb->num_rows > 0 ) {

$i=1;
$output ='<div class="donorList">
<table width="350" border="0" cellspacing="0" cellpadding="0">
<thead>
<tr>
<th align="left">Name</th>
<th align="left">Amount</th>
<th align="left">Date</th>
</tr>
</thead>
<tbody>';

foreach($donorLists as $donorList ) {

if($i%2==0) {
$cls="class='odd'";
} else {
$cls='';
}

$output .='<tr><td '.$cls.'>'.$donorList->don_first_name.' '.$donorList->don_last_name.'</td>';
$output .='<td '.$cls.'>$'.$donorList->don_amt.'</td>';
$output .='<td '.$cls.'>'.$donorList->don_date.'</td>';
$output .= '</tr>';
$i++;
}

$output .='</tbody></table></div>';


} else {
$output= "No donations have been made as of yet.";
}

return $output;
}




// this calculate donation amount

function donatemeter( $arr )
{
if($arr["cid"] == "" ) {
echo "Please Enter Campaign Id";
die();
}

global $wpdb;

$table_name = $wpdb->prefix.'campaigns';
$wpdb->flush();

$CampRow = $wpdb->get_row("SELECT * FROM $table_name WHERE camp_id=".$arr["cid"]);

if( $wpdb->num_rows > 0 ) {

$goal = $CampRow->camp_goal_amt;

$wpdb->flush();
$table_name = $wpdb->prefix.'donation';


$CampRow = $wpdb->get_row("SELECT sum(don_amt) as totalamt FROM $table_name WHERE don_camp_id=".$arr["cid"]);

if( $wpdb->num_rows > 0 ) {

if($CampRow->totalamt != "" ) {
$current = $CampRow->totalamt;
} else {
$current =0;
}
} else {
$current = 0 ;
}




if($arr["displayname"] != "" ){
echo $arr["displayname"]."<br/>";
}

echo '<img src="http://chart.apis.google.com/chart?chf=bg,s,65432100&chxr=1,0,'.$goal.'&chxs=0,676767,9.5|1,FF9900,9.5,0,l,676767&chs=300x150&cht=gm&chds=0,'.$goal.'&chd=t:'.$current.'&chdl=%24'.$current.'+/+%24'.$goal.'&chdlp=b&chl=%24'.$current.'&chma=0,0,15" width="300" height="150" alt="" />';

// echo '<img src="'.$pgUrl.'?current='.$current.'&goal='.$goal.'" />';

//ob_start();

} else {

$output= "Campaign does not exist";

}

} // end of donateMeter


function confirmdonation()
{
$confNo='';

// print_r($_REQUEST);

$confNo = $_REQUEST["txn_id"];

$emilsent=$_REQUEST["payer_email"];

$conf='<div class="donationConfDiv">
<h3>Your donation is now complete.</h3>
<p>Confirmation number: '.$confNo.'
An e-mail with your donation details has been sent to '.$emilsent.' and you can <a href="#">print your donation receipt</a>.<br />
<br />
</div>';

return $conf;
}




// Save Add New Campaign

function SaveNewCampaign()
{
//print_r( $_POST );

if( $_POST["camp_name"]=="" ) {
$_POST['notice']= "Please enter campaign name.";
return false;
}

if( $_POST["camp_goal_amt"] == "" ){
$_POST['notice']= "Please enter goal amount.";
return false;
}

/*if( ! is_numeric($_POST["camp_goal_amt"] ) ){
$_POST['notice']= "Please enter valid goal amount.";
return false;
}*/


global $wpdb;
$table_name= $wpdb->prefix.'campaigns';

$data = array();

$data["camp_name"]=$wpdb->escape($_POST["camp_name"]);
$data["camp_goal_amt"]=$wpdb->escape($_POST["camp_goal_amt"]);
$data["camp_descr"]=$wpdb->escape($_POST["camp_descr"]);

$data["camp_field_title"]= strtolower($_POST["camp_field_title"]) == "on" ? "1" : "0" ;
$data["camp_field_first_name"]= strtolower($_POST["camp_field_first_name"]) == "on" ? "1" : "0" ;
$data["camp_field_last_name"]= strtolower($_POST["camp_field_last_name"]) == "on" ? "1" : "0" ;
$data["camp_field_country"]= strtolower($_POST["camp_field_country"]) == "on" ? "1" : "0" ;
$data["camp_field_address"]= strtolower($_POST["camp_field_address"]) == "on" ? "1" : "0" ;
$data["camp_field_city"]= strtolower($_POST["camp_field_city"]) == "on" ? "1" : "0" ;
$data["camp_field_state"]= strtolower($_POST["camp_field_state"]) == "on" ? "1" : "0" ;
$data["camp_field_zip"]= strtolower($_POST["camp_field_zip"]) == "on" ? "1" : "0" ;
$data["camp_field_phone"]= strtolower($_POST["camp_field_phone"]) == "on" ? "1" : "0" ;
$data["camp_field_email"]= strtolower($_POST["camp_field_email"]) == "on" ? "1" : "0" ;
$data["camp_field_anonymous"]= strtolower($_POST["camp_field_anonymous"]) == "on" ? "1" : "0" ;
$data["camp_create_date"]= date("Y-m-d");

$rows_affected = $wpdb->insert( $table_name, $data );

if($rows_affected === 1 ){
$_POST['notice']= "Compaign successfully added.";
} else {
$_POST['notice']= "Compaign successfully not added.";
}
}


//Save Campaign Chages

function SaveEditCampaign()
{

if( $_POST["camp_name"]=="" ) {
$_POST['notice']= "Please enter campaign name.";
return false;
}

if( $_POST["camp_goal_amt"] == "" ){
$_POST['notice']= "Please enter goal amount.";
return false;
}

/* if( ! is_numeric($_POST["camp_goal_amt"] ) ){
$_POST['notice']= "Please enter valid goal amount.";
return false;
}
*/
global $wpdb;
$table_name= $wpdb->prefix.'campaigns';

check_admin_referer('update-options');

$data = array();

$data["camp_name"]=$wpdb->escape($_POST["camp_name"]);
$data["camp_goal_amt"]=$wpdb->escape($_POST["camp_goal_amt"]);
$data["camp_descr"]=$wpdb->escape($_POST["camp_descr"]);

$data["camp_field_title"]= strtolower($_POST["camp_field_title"]) == "on" ? "1" : "0" ;
$data["camp_field_first_name"]= strtolower($_POST["camp_field_first_name"]) == "on" ? "1" : "0" ;
$data["camp_field_last_name"]= strtolower($_POST["camp_field_last_name"]) == "on" ? "1" : "0" ;
$data["camp_field_country"]= strtolower($_POST["camp_field_country"]) == "on" ? "1" : "0" ;
$data["camp_field_address"]= strtolower($_POST["camp_field_address"]) == "on" ? "1" : "0" ;
$data["camp_field_city"]= strtolower($_POST["camp_field_city"]) == "on" ? "1" : "0" ;
$data["camp_field_state"]= strtolower($_POST["camp_field_state"]) == "on" ? "1" : "0" ;
$data["camp_field_zip"]= strtolower($_POST["camp_field_zip"]) == "on" ? "1" : "0" ;
$data["camp_field_phone"]= strtolower($_POST["camp_field_phone"]) == "on" ? "1" : "0" ;
$data["camp_field_email"]= strtolower($_POST["camp_field_email"]) == "on" ? "1" : "0" ;
$data["camp_field_anonymous"]= strtolower($_POST["camp_field_anonymous"]) == "on" ? "1" : "0" ;


$rows_affected = $wpdb->update( $table_name, $data , array( 'camp_id' => $_POST["cID"] ) );

if($rows_affected === 1 ){
$_POST['notice'] = "Changes successfully saved";
} else {
$_POST['notice'] = "Changes successfully not saved";
}
}

//Save General Settinga


function saveGeneralSettings()
{
if( get_option( 'paypal_email_id' ) ) {
update_option( 'paypal_email_id', $_POST["paypal_email_id"] );
} else {
add_option( 'paypal_email_id', $_POST["paypal_email_id"] );
}


if( get_option( 'from_address' ) ) {
update_option( 'from_address', $_POST["from_address"] );
} else {
add_option( 'from_address', $_POST["from_address"] );
}

if( get_option( 'email_subject' ) ) {
update_option( 'email_subject', $_POST["email_subject"] );
} else {
add_option( 'email_subject', $_POST["email_subject"] );
}


if( get_option( 'paypal_email_msg' ) ) {
update_option( 'paypal_email_msg', $_POST["paypal_email_msg"] );
} else {
add_option( 'paypal_email_msg', $_POST["paypal_email_msg"] );
}


if( get_option( 'wpconfirm_url' ) ) {
update_option( 'wpconfirm_url', $_POST["wpconfirm_url"] );
} else {
add_option( 'wpconfirm_url', $_POST["wpconfirm_url"] );
}

$_POST['notice'] = __('Settings Saved');

}


// Install Plugin

function MyDonateInstall()
{

global $wpdb, $dplus_db_version;

// Create Campaign Table

$table_name = $wpdb->prefix . "campaigns";

if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) {
$sql = "CREATE TABLE $table_name (
camp_id bigint(20) NOT NULL AUTO_INCREMENT,
camp_name varchar(250) DEFAULT NULL,
camp_goal_amt double(10,2) DEFAULT '0.00',
camp_descr text,
camp_field_title tinyint(2) DEFAULT '0',
camp_field_first_name tinyint(2) DEFAULT '0',
camp_field_last_name tinyint(2) DEFAULT '0',
camp_field_country tinyint(2) DEFAULT '0',
camp_field_address tinyint(2) DEFAULT '0',
camp_field_city tinyint(2) DEFAULT '0',
camp_field_state tinyint(2) DEFAULT '0',
camp_field_zip tinyint(2) DEFAULT '0',
camp_field_phone tinyint(2) DEFAULT '0',
camp_field_email tinyint(2) DEFAULT '0',
camp_field_anonymous tinyint(2) DEFAULT '0',
camp_create_date date DEFAULT NULL,
PRIMARY KEY (camp_id)
);";

require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
dbDelta($sql);

}

// Create Campaign Table

$table_name = $wpdb->prefix . "donation";

if($wpdb->get_var("SHOW TABLES LIKE '$table_name'") != $table_name) {
$sql = "CREATE TABLE $table_name (
don_id bigint(20) NOT NULL AUTO_INCREMENT,
don_camp_id bigint(20) DEFAULT NULL,
don_amt double(10,2) DEFAULT '0.00',
don_first_name varchar(250) DEFAULT NULL,
don_last_name varchar(250) DEFAULT NULL,
don_email varchar(250) DEFAULT NULL,
don_address text,
don_country varchar(50) DEFAULT NULL,
don_city varchar(30) DEFAULT NULL,
don_state varchar(30) DEFAULT NULL,
don_zip varchar(30) DEFAULT NULL,
don_phone varchar(30) DEFAULT NULL,
txn_id varchar(50) DEFAULT NULL,
don_date date DEFAULT NULL,
PRIMARY KEY (don_id)
);";

require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
dbDelta($sql);
}
add_option("donate_version", $donate_version);

}




}//END Class DonatePlus
} //End of Class Check If

if( class_exists('MyWpDonate') )
$objDonate = new MyWpDonate();

function MyDonateForm( $arr ){
global $objDonate;
echo $objDonate->MyDonatePage( $arr );
}

?>


[[LINK href="http://www.webpagescreenshot.info/img/185219-6172011124528am.png"]]Here is how it looks on front end[[/LINK]]

Enjoy!


I have also attached the complete zip version of the plugin.

If you want, I can make it so on install, it creates the fields for you the right way or a new version of the plugin, which on activation will do the mods for you.

Let me know. If you have it working already, just replacing the code with mine will work for you. You will just need to run the SQL that I gave in start.



Hopeful that it helps you. I put atleast 1.5 hours into it :)

Update: Hi Dmitriy, I will make it more useful to you in my next update, in response to your question regarding addition of new fields.

Regards,
Fahd Murtaza


Fahad Murtaza comments:

But one thing, if you change the field to CSV input, this will effect your goals calculation. I can help you with that as well.


Dmitriy Son comments:

Thanks!!!


Fahad Murtaza comments:

Did it work?


Fahad Murtaza comments:

I just saw in your email that you want separate fields for each donation. I think you get the idea from my post above and can make some mods yourself.


Dmitriy Son comments:

just one thing. i don't want to change goal amount. it's constant. so I just add new field for sum options not changing goal amount. users choose sum of their contribution, not goal amount. However you win!


Dmitriy Son comments:

*won


Fahad Murtaza comments:

Glad that I helped. You can add a new field and changed all the settings.


Dmitriy Son comments:

Fahd, one more queston: how to make it in separate fields?

2011-06-16

Jarret Minkler answers:

Open the plugin template

for the text field for the amount change it to a select tag retaining the name=".." and id="..." if there is one.

it might be ..

<input type="text" name="amount"> just change it to ..

<select name="amount"><option value="10">10</option> ... </select>

You can then use php to populate the options


Dmitriy Son comments:

yep, the problem is i don't know how to populate it. via foreach construct? how to insert created values to my mysql database. what type of the mysql field? how the function looks?


Jarret Minkler comments:

Sure, you could do for loop

<select name="amount">
<?php for ($x=10; $x<=100; $x+=10) : ?>
<option value="<?php echo $x; ?>"><?php echo $x; ?></option>
<?php endfor; ?>
</select>

For example .. or foreach
<?php $values = array(10, 20, 30, 40, 50); // example values ?>
<select name="amount">
<?php foreach ($values as $x) : ?>
<option value="<?php echo $x; ?>"><?php echo $x; ?></option>
<?php endforeach; ?>
</select>


Dmitriy Son comments:

Jarret, thanks! How will it look inside the following function? I wrote something that doesn't work. May i add values in range of $1 to $10K?

function AddCampaign()
{

if (!current_user_can('manage_options')) {
wp_die( __('You do not have sufficient permissions to access this page.') );
}

if( $_GET["edit"] != "" ){
$this->EditCampaign();
} else {
?>
<div class="campaignName">
<h3>Add Campaign</h3>

<?php
if( $_POST['notice'] ) {
echo '<div id="message" class="updated fade"><p><strong>' . $_POST['notice'] . '</strong></p></div><br>';
}
?>

<script type="text/javascript" src="http://mywebsite.com/donations/addnewsum.js"></script>
<form name="campform" id="campform" method="post" action="" >

<table width="50%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="35%">Campaign Name</td>
<td width="65%"><input type="text" name="camp_name" id="camp_name" /></td>
</tr>
<tr>
<td>Goal Amount (GBP)</td>
<td><input type="text" name="camp_goal_amt" id="camp_goal_amt" /></td>
</tr>
<tr>
<td>Sums</td>
<td>
<div id="camp_sum_list">
<?php $camp_sum_num = attribute_escape($post["camp_sum_num"]);
$camp_sum = array();
for ($i = 0; $i < $camp_sum_num; $i++) {
$sum_value = attribute_escape($post["camp_sum_" . $i]);
if ($camp_sum_value != null && $sum_value != "") {
$camp_sums[] = $camp_sum_value;
}
} ?>
<?php $id = 0; ?>
<?php foreach ($camp_sums as $camp_sum) : ?>
<div id="camp_sum_<?php echo $id; ?>">
<input type="text" class="sum_option" name="camp_sum_<?php echo $id; ?>" value="<?php echo $sum; ?>" size="40"/><a href="#" onClick="return removeFormTextField('camp_sum_list', 'camp_sum_<?php echo $id; ?>')">Remove</a>
</div>
<?php $id++; ?>
<?php endforeach; ?>
</td>
</tr>
<tr>
<td colspan="2">
<input type="hidden" name="camp_sum_num" value="<?php echo count($camp_sums);?>" id="camp_sum_num"/>
<div id="add-new-sum"><a class="button" href="#" onclick="return addFormTextField('camp_sum_num', 'camp_sum_list', 'camp_sum_', 'sum_option');">Add new</a></div>
</td>
</tr>
<tr>
<td>Description</td>
<td><textarea name="camp_descr" rows="3" cols="40"></textarea></td>
</tr>

</table>

<br />
<table width="50%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="35%">Include these fields</td>
<td width="65%">&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_title" id="camp_field_title" /> <label for="camp_field_title">Title</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_first_name" id="camp_field_first_name" />
<label for="camp_field_first_name">First Name</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_last_name" id="camp_field_last_name" />
<label for="camp_field_last_name">Last Name</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_country" id="camp_field_country" />
<label for="camp_field_country">Country</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_address" id="camp_field_address" />
<label for="camp_field_address">Address Lines</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_city" id="camp_field_city" />
<label for="camp_field_city">City</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_state" id="camp_field_state" />
<label for="camp_field_state">State</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_zip" id="camp_field_zip" />
<label for="camp_field_zip">ZIP</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_phone" id="camp_field_phone" />
<label for="camp_field_phone">Phone</label></td>
</tr>
<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_email" id="camp_field_email" />
<label for="camp_field_email">E-mail</label></td>
</tr>

<tr>
<td>&nbsp;</td>
<td><input type="checkbox" name="camp_field_anonymous" id="camp_field_anonymous" />
<label for="camp_field_anonymous">Would you like to remain anonymous?</label></td>
</tr>

<tr height="20px;">
<td colspan="2" >&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>
<input type="submit" class="button-primary" name="button" id="button" value="Create Campaign" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
</table>
<input name="action" value="camp_add" type="hidden" />

</form>
</div>
<?php
} //end of if

} //end of add campaign function


What should I add to that function?
function SaveEditCampaign()
{

if( $_POST["camp_name"]=="" ) {
$_POST['notice']= "Please enter campaign name.";
return false;
}

if( $_POST["camp_goal_amt"] == "" ){
$_POST['notice']= "Please enter goal amount.";
return false;
}

if( ! is_numeric($_POST["camp_goal_amt"] ) ){
$_POST['notice']= "Please enter valid goal amount.";
return false;
}

global $wpdb;
$table_name= $wpdb->prefix.'campaigns';

check_admin_referer('update-options');

$data = array();

$data["camp_name"]=$wpdb->escape($_POST["camp_name"]);
$data["camp_goal_amt"]=$wpdb->escape($_POST["camp_goal_amt"]);
<b>$data["camp_sum_num"]=$wpdb->escape($_POST["camp_sum_num"]);</b>
$data["camp_descr"]=$wpdb->escape($_POST["camp_descr"]);

$data["camp_field_title"]= strtolower($_POST["camp_field_title"]) == "on" ? "1" : "0" ;
$data["camp_field_first_name"]= strtolower($_POST["camp_field_first_name"]) == "on" ? "1" : "0" ;
$data["camp_field_last_name"]= strtolower($_POST["camp_field_last_name"]) == "on" ? "1" : "0" ;
$data["camp_field_country"]= strtolower($_POST["camp_field_country"]) == "on" ? "1" : "0" ;
$data["camp_field_address"]= strtolower($_POST["camp_field_address"]) == "on" ? "1" : "0" ;
$data["camp_field_city"]= strtolower($_POST["camp_field_city"]) == "on" ? "1" : "0" ;
$data["camp_field_state"]= strtolower($_POST["camp_field_state"]) == "on" ? "1" : "0" ;
$data["camp_field_zip"]= strtolower($_POST["camp_field_zip"]) == "on" ? "1" : "0" ;
$data["camp_field_phone"]= strtolower($_POST["camp_field_phone"]) == "on" ? "1" : "0" ;
$data["camp_field_email"]= strtolower($_POST["camp_field_email"]) == "on" ? "1" : "0" ;
$data["camp_field_anonymous"]= strtolower($_POST["camp_field_anonymous"]) == "on" ? "1" : "0" ;


$rows_affected = $wpdb->update( $table_name, $data , array( 'camp_id' => $_POST["cID"] ) );

if($rows_affected === 1 ){
$_POST['notice'] = "Changes successfully saved";
} else {
$_POST['notice'] = "Changes not saved";
}
}


Jarret Minkler comments:

This doesn't look right, this is the admin template rather than the template for the form for the site.


Dmitriy Son comments:

i know. admin adds as many sum options as he likes and INSERT ones into the table 'campaigns' when click on send button, then users select one option ($5/10/100/130/1000) in the dropdown list and INSERT it into the certain field of the table 'donations'.

2011-06-16

Dan | gteh answers:

Use this plugin instead: Donation Can http://treehouseapps.com/donation-can/

I use it on a site I built for a client. Lots of options and lets you have a dropdown for your donation amounts, and an option to let them fill in their own amount if you want to

It also has a much nicer widget for displaying your goal and amount donated.


Dmitriy Son comments:

thanks. it's too complicated thing. i want something simpler with similar features.


Dan | gteh comments:

It's actually much easier to configure than the one you are using and does not require you to have to edit any PHP or MySQL to get it working.

All you do is install the plugin, insert your paypal settings, and then 'Create Cause' and enter in the amounts you want in the dropdown menu.

It supports short-codes and widgets

I can configure it for you if you'd like