ID; $project_data = $wpdb->get_row($sql); if ($project_data) { return true; } else { return false; } } function IsTargetReached($postid) { global $post, $wpdb; //do we have project data? $sql = 'SELECT * FROM `pd_pledges` where `projectid` =' . $postid; $pledge = $wpdb->get_row($sql); if ($pledge) { //the current total $current_total = pledgepriveget_amount($postid); //get target total $sql2 = 'SELECT required_amount FROM `pd_projects` WHERE `postid` = ' . $postid; $targettotal = $wpdb->get_row($sql2); if ($targettotal) { $the_target = $targettotal->required_amount; } else { $the_target = 0; } // = or > than the required amount? if ($current_total >= $the_target) { return true; } else { return false; } } return false; } function pledgeprivepost($content) { global $post, $wpdb; //if not, get from db $sql = 'SELECT * FROM `pd_projects` WHERE `postid` = ' . $post->ID; $project_data = $wpdb->get_row($sql); if ($project_data) { //get total (derived for now...until writing, when total will be calc'd) $project_total = pledgepriveget_amount($post->ID); //figure out days left $projectdate = strtotime($project_data->target_date); $daysleft = getdaysleft($projectdate); $sql = 'SELECT guid FROM `wp_posts` WHERE `id` = ' . $post->ID; $permalink_data = $wpdb->get_var($sql); if ($permalink_data) { $permalink = $permalink_data; } $pledgemeta = "
"; $pledgemeta .= "
"; $pledgemeta .= "Required Amount: " . money_format('$%#4n',$project_data->required_amount) . "
"; $pledgemeta .= "Total to date: " . money_format('$%#4n',$project_total) . "
"; $pledgemeta .= "Required by: " . date("F j, Y", $projectdate) . " " . $daysleft; $pledgemeta .= "		"; if ( IsTargetReached($post->ID) ) { $pledgemeta .= "FUNDED!!"; } else { $pledgemeta .= "\"Click"; } $pledgemeta .= "
"; } $content = $pledgemeta . $content; return $content; } function getdaysleft($targetdate) { $daysleft = floor(($targetdate - time())/86400); if ($daysleft < 0) { $daysleft = ""; } else { $daysleft++; if ($daysleft <= 1) { $daysleft = "(" . $daysleft . " day left!!)"; } else { $daysleft = "(" . $daysleft . " days left!!)"; } } return $daysleft; } function isapproved($commentid) { global $wpdb; $sql = "SELECT wp_comments.comment_approved FROM wp_comments WHERE wp_comments.comment_ID = " . $commentid; $approved = $wpdb->get_row($sql); if ($approved) { return $approved->comment_approved; } else { return 0; } } function pledgepriveget_amount($postid) { global $wpdb; //$sql = 'SELECT SUM(`amount`) as the_total FROM `pd_pledges` where `projectid` =' . $postid; $sql = "SELECT SUM( `amount` ) AS the_total FROM pd_pledges, wp_comments WHERE projectid = " . $postid . " AND pd_pledges.commentid = wp_comments.comment_ID AND pd_pledges.confirmed = '1'"; $pledgetotal = $wpdb->get_row($sql); if ($pledgetotal) { return $pledgetotal->the_total; } else { return 0; } } function DisplayGuage($postid) { global $wpdb; $return = ''; $container = 200; $level = 0; $current_total = 0; //do we have project data? $sql = 'SELECT * FROM `pd_pledges` where `projectid` =' . $postid; $pledge = $wpdb->get_row($sql); if ($pledge) { //the current total $current_total = pledgepriveget_amount($postid); //get target total $sql2 = 'SELECT required_amount FROM `pd_projects` WHERE `postid` = ' . $postid; $targettotal = $wpdb->get_row($sql2); if ($targettotal) { $the_target = $targettotal->required_amount; } else { $the_target = 0; } // = or > than the required amount? if ($current_total >= $the_target) { //get total pledged (if zero, need to handle well) //build guage $return = '
$ ' . $current_total . ' raised
to date!!
'; $return .= '
'; $return .= '
'; //$return .= '
'; $return .= '

'; $return .= "Target
reached"; $return .= '

'; } else { //figure out the sizes for the gauge display $percentcomplete = round(($current_total / $the_target) * 100); $level = $container * ($percentcomplete / 100); $topmargin = $container - $level; if ($percentcomplete <= 10) { //build guage $return = '
$ ' . $current_total . ' raised
to date!!
'; $return .= '
'; $return .= '
'; $return .= '
'; $return .= '

'; $return .= $percentcomplete . "%"; $return .= '

'; return $return; } //get total pledged (if zero, need to handle well) if ($current_total != 0) { //build guage $return = '
$ ' . $current_total . ' raised
to date!!
'; $return .= '
'; $return .= '
'; $return .= '
'; $return .= '

'; $return .= $percentcomplete . "%"; $return .= '

'; } } } else //no project defined { //do nothing /* $level = 20; $current_total = 0; $topmargin = $container - $level; $percentcomplete = 0; //build guage $return = '
$ ' . $current_total . ' raised
to date!!
'; $return .= '
'; $return .= '
'; $return .= '
'; $return .= '

'; $return .= $percentcomplete . "%"; $return .= '

'; */ } return $return; } function pledgepriveget_min($postid) { global $wpdb; $sql = 'SELECT mindonation FROM pd_projects WHERE postid = ' . $postid; $result = $wpdb->get_row($sql); if ($result) { $mindonation = $result->mindonation; } else { $mindonation = 0; } return $mindonation; } function pledgepriveget_max($postid) { global $wpdb; $sql = 'SELECT maxdonation FROM pd_projects WHERE postid = ' . $postid; $result = $wpdb->get_row($sql); if ($result) { $maxdonation = $result->maxdonation; } else { $maxdonation = 0; } return $maxdonation; } function pledgepriveget_percentcomplete($postid) { global $wpdb; //get current total $the_total = pledgepriveget_amount($postid); //get target total $sql = 'SELECT required_amount FROM `pd_projects` WHERE `postid` = ' . $postid; $targettotal = $wpdb->get_row($sql); if ($targettotal) { $the_target = $targettotal->required_amount; } else { $the_target = 0; } $percentage = ($the_total / $the_target) * 100; if ($percentage != 0) { return $percentage; } else { return 0; } } function pledgepriveget_ppemail($postid) { global $wpdb; $sql = 'SELECT ppemail FROM `pd_projects` WHERE `postid` = ' . $postid; $result = $wpdb->get_row($sql); if ($result) { $the_ppemail = $result->ppemail; } else { $the_ppemail = 0; } return $the_ppemail; } function pledgeprive_contriblist($postid) { global $wpdb, $post; $return = ''; $sql = 'SELECT * FROM pd_projects WHERE postid = ' . $post->ID; $project_data = $wpdb->get_row($sql); if ($project_data) { $return .= '
'; $return .= '
Contributors:
'; $return .= '
'; $return .= '
'; $return .= ''; //anon total: $sql = 'SELECT sum( pd_pledges.amount ) AS the_amount FROM pd_pledges, wp_comments WHERE pd_pledges.anon = "yes" AND pd_pledges.showcontrib = "yes" AND pd_pledges.commentid = wp_comments.comment_ID AND pd_pledges.confirmed = "1" AND pd_pledges.projectid = ' . $postid . ' GROUP BY wp_comments.comment_author ORDER BY wp_comments.comment_date DESC'; $anonamount = $wpdb->get_row($sql); if( $anonamount->the_amount <> 0 ) { $return .= '» anon $ ' . $anonamount->the_amount . "
"; } $sql = 'SELECT pd_pledges.anon, pd_pledges.showcontrib, sum( pd_pledges.amount ) AS the_amount, wp_comments.comment_author AS the_username, wp_comments.comment_author_url AS the_url FROM pd_pledges, wp_comments WHERE pd_pledges.anon = "no" AND pd_pledges.projectid = ' . $postid . ' AND pd_pledges.commentid = wp_comments.comment_ID AND pd_pledges.confirmed = "1" GROUP BY wp_comments.comment_author ORDER BY wp_comments.comment_date DESC'; $contriblist = $wpdb->get_results($sql); if( $contriblist ) { foreach( $contriblist as $listitem ) { if ($listitem->the_amount > 0) { if ($listitem->showcontrib <> 'yes') { $the_amount = 'N/A'; }else{ $the_amount = $listitem->the_amount; } if ($listitem->the_url != '') { $return .= '» ' . $listitem->the_username . ' $ ' . $the_amount . "
"; } else { $return .= '» ' . $listitem->the_username . ' $ ' . $the_amount . "
"; } } } } else { $return = 'No contributions yet.'; } $return .= ''; $return .= '
'; $return .= '
'; $return .= '
'; $return .= ''; } return $return; } function pledgeprivecomment_amount($comment_id) { global $wpdb; $sql = 'SELECT amount, showcontrib, currency, other_amount, confirmed FROM pd_pledges WHERE commentid = ' . $comment_id; // die( print_r($sql)); $pledgeamount = $wpdb->get_row($sql); $return = ''; if ($pledgeamount) { if ($pledgeamount->amount <> 0) { $return = '
'; $return .= '
'; if ($pledgeamount->showcontrib == 'yes') { $currency = ''; $amount = $pledgeamount->amount; if ($pledgeamount->confirmed == 1) { $return .= '

$ ' . $amount . $currency. '

'; } else { $return .= '

pending

'; } } else { $return .= '

not disclosed

'; } $return .= '
'; $return .= '
'; } } return $return; } function getnextcommentid() { global $wpdb; $nextcomment = ''; $sql = 'SELECT MAX(`comment_ID`)+1 as commentid FROM `wp_comments`'; $nextcommentrow = $wpdb->get_row($sql); if ($nextcommentrow) { $nextcomment = $nextcommentrow->commentid; } return $nextcomment; } function isanon($comment_id) { global $wpdb; $anon = false; $sql = 'SELECT `anon` FROM `pd_pledges` WHERE `commentid` = ' . $comment_id; $anonrow = $wpdb->get_row($sql); if ($anonrow) { if ($anonrow->anon == 'yes') { $anon = true; } else { $anon = false; } } else { $anon = false; } return $anon; } function hideamount($comment_id) { global $wpdb; $hide = false; $sql = 'SELECT `showcontrib` FROM `pd_pledges` WHERE `commentid` = ' . $comment_id; $hiderow = $wpdb->get_row($sql); if ($hiderow) { if ($hiderow->showcontrib == 'yes') { $hide = false; } else { $hide = true; } } else { $hide = true; } return $hide; } function pdproject_widget() { global $post, $wpdb; $pd_projtargetdate = ""; $pd_projtargetamnt = ""; $ppemail = ''; $pd_projmin = ''; $pd_projmax = ''; //call up existing project info if it exists. if ($post->ID){ $sql = 'SELECT required_amount, target_date, mindonation, maxdonation, ppemail FROM pd_projects WHERE postid=' . $post->ID; $this_project = $wpdb->get_row($sql); if ($this_project) { $pd_projtargetdate = $this_project->target_date; $pd_projtargetamnt = $this_project->required_amount; $ppemail = $this_project->ppemail; $pd_projmin = $this_project->mindonation; $pd_projmax = $this_project->maxdonation; } else { $pd_projtargetdate = ''; $pd_projtargetamnt = ''; $ppemail = ''; $pd_projmin = ''; $pd_projmax = ''; } } $widget = ''; $widget .= '
'; $widget .= ''; $widget .= ''; $widget .= ''; //min and max donation settings $widget .= ''; $widget .= ''; $widget .= '
Project Target Date: (example: YYYY-MM-DD)
Project Target Amount:
Paypal Email to send pledges to:
Donation Minimum:
Donation Maximum:
'; $widget .= '

'; echo '
' . '

PledgeDrive Plugin - Project Settings/Info for post# ' . $post->ID . '

' . $widget . '
'; return; } function pdproject_save($postID) { global $wpdb, $table_prefix; $pd_projtargetdate = trim(strip_tags($_POST['pd_projtargetdate'])); $pd_projtargetamnt = trim(strip_tags($_POST['pd_projtargetamnt'])); $ppemail = trim(strip_tags($_POST['ppemail'])); $pd_projmin = trim(strip_tags($_POST['pd_projmin'])); $pd_projmax = trim(strip_tags($_POST['pd_projmax'])); if (($pd_projtargetdate) and ($pd_projtargetamnt)) { $sql = 'SELECT id FROM pd_projects WHERE postid=' . $postID; $projectsid = $wpdb->get_var($sql); if (is_null($projectsid)) { $sql = 'INSERT INTO pd_projects (required_amount, target_date, mindonation, maxdonation, ppemail, postid) VALUES (' . $pd_projtargetamnt . ', "' . $pd_projtargetdate . '", ' . $pd_projmin . ', ' . $pd_projmax . ', "' . $ppemail . '", ' . $postID . ')'; $wpdb->query($sql); }else{ $sql = 'UPDATE pd_projects SET required_amount=' . $pd_projtargetamnt . ', target_date= \'' . $pd_projtargetdate . '\', mindonation= ' . $pd_projmin . ', maxdonation= ' . $pd_projmax . ', ppemail= \'' . $ppemail . '\' WHERE postid=' . $postID; //die( __($sql)); $wpdb->query($sql); } } } /* function pdproject_validatepledge($commentdata) { global $post; //print_r($commentdata); //Array ( [comment_post_ID] => 33 [comment_author] => Devlon //[comment_author_email] => duthied@gmail.com [comment_author_url] => http:// [comment_content] => rrr $err_message = ''; $the_amount = trim(strip_tags($_REQUEST['amount'])); $the_ppemail = trim(strip_tags($_REQUEST['pp_email'])); if (($the_ppemail == '') AND ($the_amount == '')) { //both are empty, pass through, comment only return $commentdata; } else { if ((($the_ppemail <> '') AND ($the_amount == '')) OR (($the_ppemail == '') AND ($the_amount <> ''))) { //missing one or the other if ($the_ppemail == '') { $err_message .= '» Please enter your Paypal email address
'; } if ($the_amount == '') { $err_message .= '» Please enter an amount that you\'d like to donate
'; } $donation_min = pledgepriveget_min($post->ID); $donation_max = pledgepriveget_max($post->ID); if ( ($the_amount < $donation_min) or ($the_amount > $donation_max) ) { $err_message .= '» The minimum donation is $' . $donation_min . ' and the maximum is $' . $donation_min . ', please make sure your amount is with the min and max.
'; } } } //if (!IsNumeric(the_amount)) //{ // err_message = "» Please enter only numbers for the amount that you'd like to donate
"; //} if ($err_message != '') { $err_message = '

Please use your browser\'s back button and correct the following errors:

' . $err_message; die( __($err_message)); } return $commentdata; } */ /* preprocess_comment preprocessing a comment, called with the comment passed as an array. Should return a array. The indices of the array are comment, comment_post_ID, user_ID, user_ip, user_domain, user_agent, author, email, url, approved. */ function pdproject_comenttesting($commentid) { global $wpdb; $the_amount = trim(strip_tags($_REQUEST['amount'])); if ($the_amount == '') { return; } $the_ppemail = trim(strip_tags($_REQUEST['pp_email'])); $the_email = trim(strip_tags($_REQUEST['email'])); $the_amount = trim(strip_tags($_REQUEST['amount'])); $thepostid = trim(strip_tags($_REQUEST['comment_post_ID'])); $username = trim(strip_tags($_REQUEST['author'])); $paymentcurrency = trim(strip_tags($_REQUEST['paymentcurrency'])); $hide_pledgeamnt = trim(strip_tags($_REQUEST['hide_pledgeamnt'])); $anon_donation = trim(strip_tags($_REQUEST['anon_donation'])); $item_number_1 = trim(strip_tags($_REQUEST['item_number_1'])); //post to db //get userid, if none exists, create... $sql = "SELECT id FROM `pd_users` WHERE `email` = '" . $the_email . "'"; $userid_row = $wpdb->get_row($sql); if ($userid_row) { $userid = $userid_row->id; } else { //no rows returned? Create a user... //$commentid = getnextcommentid(); $sql = 'INSERT INTO `pd_users` (username, email) VALUES("' . $username . '","' . $the_email . '")'; $result = $wpdb->query($sql); if (!$result) { die( __('Error executing save on pledge info.
' . $sql)); } //get the id $sql = "SELECT id FROM `pd_users` WHERE `email` = '" . $the_email . "'"; $userid_row = $wpdb->get_row($sql); if ($userid_row) { $userid = $userid_row->id; } } //save the pledge record! $the_amount = $wpdb->escape($the_amount); $sql = 'INSERT INTO `pd_pledges` (amount, userid, projectid, source, commentid, anon, showcontrib, currency, ppemail, uniqid) VALUES(' . $the_amount . ',' . $userid . ',' . $thepostid . ',"paypal",' . $commentid . ', "' . $anon_donation . '", "' . $hide_pledgeamnt . '", "USD", "' . $the_email . '", "' . $item_number_1 . '")'; $result = $wpdb->query($sql); if (!$result) { die( __('Error executing save on pledge info.')); } return; } function pdproject_admin_menu() { add_submenu_page('options-general.php', 'PledgeDrive', 'PledgeDrive', 8, 'PledgeDrive', 'pdproject_submenu'); } //returns an array of the project names and id function pdproject_getprojectlist() { $sql = 'SELECT wp_posts.post_title AS thetitle, pd_projects.id AS theid FROM pd_projects, wp_posts WHERE pd_projects.postid = wp_posts.id'; $projectlist = $wpdb->get_results($sql); if ($projectlist) { return $projectlist; } return ''; } // The admin page function pdproject_submenu() { global $wpdb; if ($_REQUEST['save']) { if ($_REQUEST['sorting'] == "oldfirst") { $oldfirst = true; update_option('sorting', "oldfirst"); $sorting = "oldfirst"; } elseif ($_REQUEST['sorting'] == "newfirst") { $newfirst = true; update_option('sorting', "newfirst"); $sorting = "newfirst"; } update_option('ppemail', trim(strip_tags($_REQUEST['ppemail']))); $ppemail = get_option('ppemail'); } else { $sorting = get_option('sorting'); $ppemail = get_option('ppemail'); if ($sorting == "oldfirst") { $oldfirst = true; } elseif ($sorting == "newfirst") { $newfirst = true; } } ?>

PledgeDrive Options

Sort comments/pledges: />  Oldest First
/>  Newest First

Information Saved.

"; } ?>


Pick a project title and click the button to get the list of Pledges and thier payment status:

   




debug   |   ipn success log


Contact info, site link, etc.