';
echo 'Donations Module Config
';
echo 'center'>';
ShowTextBox('don_button_top', 'Donations page top button', '', '70', 'onChange="return validdateURL(this,this.value);"');
ShowImgXYBox('don_top_img_width', 'don_top_img_height', 'Image dimensions', '4', 'onChange="return validInt(this,'Image Dimension',0);"');
ShowTextBox('don_button_submit', 'Donations page "submit" button', '', '70', 'onChange="return validdateURL(this,this.value);"');
ShowImgXYBox('don_sub_img_width', 'don_sub_img_height', 'Image dimensions', '4', 'onChange="return validInt(this,'Image Dimension',0);"');
ShowTextBox('don_name_prompt', 'Prompt to use username', '', '70', '');
ShowTextBox('don_name_yes', 'Username request: "YES" Response', '', '50', '');
ShowTextBox('don_name_no', 'Username request: "NO" Response', '', '50', '');
$desc = 'This is where you can appeal to your
users and your community for donations.
Suggestion: Explain why you need donations,
what you do with the money and how you
manage it. Make them comfortable that
they are not throwing their money away.';
$sql = "SELECT * FROM ".$xoopsDB->prefix("donations_config")." WHERE name = 'don_text'";
$Recordset = $xoopsDB->query($sql);
$row = $xoopsDB->fetchArray($Recordset);
$DON_TEXT = $row['text'];
echo ''
."$desc" align="right">Donations page text"
."$desc" align="left">"
."var_don_text-rawtext-txt" cols="100" rows="20">$DON_TEXT ";
ShowTextBox('don_amt_checked', 'Which donation amount below
is checked by default?', '', '4', 'onChange="return validInt(this,'Donation Default',1);"');
echo '
';
$query_Recordset1 = "SELECT * FROM ".$xoopsDB->prefix("donations_config")." WHERE name = 'don_amount' ORDER BY subtype";
$Recordset1 = $xoopsDB->query($query_Recordset1);
$row_Recordset1 = $xoopsDB->fetchArray($Recordset1);
$totalRows_Recordset1 = $xoopsDB->getRowsNum($Recordset1);
$desc = htmlentities($row_Recordset1['text']);
echo 'center'>';
echo 'center' width='100%' colspan='8'>Suggested Donation amounts
';
$row1 = '. $desc . '" align="center">';
$row2 = '. $desc . '" align="center">Amount';
do {
$row1 .= "$desc" align="center">$row_Recordset1[subtype]";
$row2 .= "$desc" align="center">4" name="var_don_amount-$row_Recordset1[subtype]" type="text" value="$row_Recordset1[value]" onChange="return validInt(this,'Suggested Donation Amount #$row_Recordset1[subtype]',1);">";
}
while ($row_Recordset1 = $xoopsDB->fetchArray($Recordset1));
$row1 .= ' ';
$row2 .= ' ';
echo "$row1 $row2";
echo '
';
echo 'center' width='100%'> ';
echo '
';
echo '1' width='90%' align='center'>';
echo 'PayPal Configuration
';
echo 'center'>';
$rsql = "SELECT rank_id, rank_title FROM ".$xoopsDB->prefix('ranks')."";
$rresult = $xoopsDB->query($rsql);
$r_array = array();
while( $r_row = $xoopsDB->fetchRow($rresult) ){
$r_array[] = $r_row;
}
ShowDropBox('paypal_url', 'Please choose which Paypal IPN url you will use.', '', '', '');
ShowTextBox('receiver_email', 'PayPal Receiver Email', '', '40', '');
ShowTextBox('ty_url', "URL for Donation 'Thank You'", '', '80', 'onChange="checkCancelledURL(); return validdateURL(this,this.value);"');
ShowTextBox('pp_cancel_url', 'URL for cancelled donation', '', '80', 'onChange="return validdateURL(this,this.value);"');
ShowTextBox('pp_itemname', 'PayPal Item Name', '', '20', '');
ShowTextBox('pp_item_num', 'PayPal Item Number', '', '20', '');
ShowTextBox('pp_image_url', 'URL of image to display in PayPal', '', '60', '');
ShowYNBox('pp_get_addr', 'Ask user for postal address', '', '', '');
ShowDropBox('pp_curr_code', 'Choose your currency', '', '', '');
$gsql = "SELECT groupid, name FROM ".$xoopsDB->prefix('groups')." WHERE groupid>3";
$gresult = $xoopsDB->query($gsql);
$g_array = array();
while( $g_row = $xoopsDB->fetchRow($gresult) ){
$g_array[] = $g_row;
}
ShowArrayDropBox('assign_group', 'Select a Group to assign donators to.', '', '', '', $g_array);
$rsql = "SELECT rank_id, rank_title FROM ".$xoopsDB->prefix('ranks')."";
$rresult = $xoopsDB->query($rsql);
$r_array = array();
while( $r_row = $xoopsDB->fetchRow($rresult) ){
$r_array[] = $r_row;
}
ShowArrayDropBox('assign_rank', 'Select a Rank to assign donators to.', '', '', '', $r_array);
echo '
';
echo '';
echo 'IPN Logging Options
';
echo ''
.'Logging level'
.''
.'';
echo ';
if($tr_config['ipn_dbg_lvl']==0) echo "selected ";
echo 'value="0">Off';
echo ';
if($tr_config['ipn_dbg_lvl']==1) echo "selected ";
echo 'value="1">Only log errors';
echo ';
if($tr_config['ipn_dbg_lvl']==2) echo "selected ";
echo 'value="2">Log everything';
echo ' ';
ShowTextBox('ipn_log_entries', 'Keep this many log entries', '', '4', '');
$desc = 'This box shows the link to the IPN recorder.
This link must be pasted EXACTLY as it is
into your PayPal IPN profile. You can click
on the "test" link to the right to verify
that the IPN recorder is functioning correctly.';
$desc = htmlentities($desc);
echo ''
."$desc" align="right">IPN link for PayPal"
."$desc" align="left"> ".XOOPS_URL."/modules/xdonations/ipnppd.php
/modules/xdonations/ipnppd.php?dbg=1" target="_blank">Click here to test IPN"
. ' ';
echo '
';
echo 'center' width='100%'> ';
echo '
';
echo '1' width='90%' align='center'>';
echo 'Goal Preferences
';
echo 'center'>';
echo '';
ShowDropBox('use_goal', 'Choose which goal type you would like to use.', '', '', '');
echo '';
$query_Recordset1 = "SELECT * FROM ".$xoopsDB->prefix("donations_config")." WHERE name = 'week_goal' AND subtype<>'Default'";
$Recordset1 = $xoopsDB->query($query_Recordset1);
$row_Recordset1 = $xoopsDB->fetchArray($Recordset1);
$totalRows_Recordset1 = $xoopsDB->getRowsNum($Recordset1);
$desc = htmlentities($row_Recordset1['text']);
echo 'center'>';
echo 'center' width='100%' colspan='13'>Donation goals by week (4 weeks in a month)
';
$row1 = 'Week';
$row2 = 'Goal';
do {
$row1 .= "$desc" align="center">$row_Recordset1[subtype]";
$row2 .= "$desc" align="center">4" name="var_week_goal-$row_Recordset1[subtype]" type="text" value="$row_Recordset1[value]" onChange="return validInt(this,'$row_Recordset1[subtype] Donation Goal',1);">";
}
while ($row_Recordset1 = $xoopsDB->fetchArray($Recordset1));
$row1 .= ' ';
$row2 .= ' ';
echo "$row1 $row2";
echo '';
$query_Recordset1 = "SELECT * FROM ".$xoopsDB->prefix("donations_config")." WHERE name = 'month_goal' AND subtype<>'Default'";
$Recordset1 = $xoopsDB->query($query_Recordset1);
$row_Recordset1 = $xoopsDB->fetchArray($Recordset1);
$totalRows_Recordset1 = $xoopsDB->getRowsNum($Recordset1);
$desc = htmlentities($row_Recordset1['text']);
echo 'center'>';
echo 'center' width='100%' colspan='13'>Donation goals by month
';
$row1 = 'Month';
$row2 = 'Goal';
do {
$row1 .= "$desc" align="center">$row_Recordset1[subtype]";
$row2 .= "$desc" align="center">4" name="var_month_goal-$row_Recordset1[subtype]" type="text" value="$row_Recordset1[value]" onChange="return validInt(this,'$row_Recordset1[subtype] Donation Goal',1);">";
}
while ($row_Recordset1 = $xoopsDB->fetchArray($Recordset1));
$row1 .= ' ';
$row2 .= ' ';
echo "$row1 $row2";
echo '';
echo 'center'>';
ShowTextBox('swing_day', 'Month Swing Day', '175', '4', 'onChange="return validInt(this,'Swing Day',1);"');
echo '';
$query_Recordset1 = "SELECT * FROM ".$xoopsDB->prefix("donations_config")." WHERE name = 'quarter_goal' AND subtype<>'Default'";
$Recordset1 = $xoopsDB->query($query_Recordset1);
$row_Recordset1 = $xoopsDB->fetchArray($Recordset1);
$totalRows_Recordset1 = $xoopsDB->getRowsNum($Recordset1);
$desc = htmlentities($row_Recordset1['text']);
echo 'center'>';
echo 'center' width='100%' colspan='13'>Donation goals by quarter
';
$row1 = 'Quarter';
$row2 = 'Goal';
do {
$row1 .= "$desc" align="center">$row_Recordset1[subtype]";
$row2 .= "$desc" align="center">4" name="var_quarter_goal-$row_Recordset1[subtype]" type="text" value="$row_Recordset1[value]" onChange="return validInt(this,'$row_Recordset1[subtype] Donation Goal',1);">";
}
while ($row_Recordset1 = $xoopsDB->fetchArray($Recordset1));
$row1 .= ' ';
$row2 .= ' ';
echo "$row1 $row2";
echo '
';
echo 'center' width='100%'> ';
echo ' ';
echo '';
}
function ConfigUpdate()
{
global $tr_config, $modversion, $xoopsDB;
echo "
#0000FF">If you see this screen then an SQL error was encountered"
. "You should see a message in #FF0000">RED below indicating what the error is
";
$ERR = 1;
$ilog="";
$ilog .= "
";
foreach( $_POST as $option => $value )
{
/// Look for form variables
if( preg_match("/var_/",$option))
{
$varnm = preg_replace("/var_/","",$option);
// Check for subtype field
if( preg_match("/-(.*)/",$varnm,$subtype) )
{
echo "
subtype = $subtype[1]
";
$temp = $varnm;
$varnm = preg_replace("/-.*/","",$temp);
// Is this is a text field?
if( preg_match("/([^-]*)-txt/",$subtype[1], $subtype2) )
{
if (!get_magic_quotes_gpc()) {
$textarea = addslashes($value);
} else {
$textarea = $value;
}
echo "$varnm $subtype2[1] text=> " . nl2br(htmlspecialchars($textarea)) . "
";
$ERR &= UpdateDb($varnm, $subtype2[1], "0", $textarea);
} else {
echo "$varnm $subtype[1] => $value
";
$ERR &= UpdateDbShort($varnm, $subtype[1], $value, "");
}
} else
{
echo "$varnm => $value
";
$ERR &= UpdateDbShort($varnm, "", $value, "");
}
}
}
// If there were no errors
if( $ERR == 0 )
Header("Location: index.php?op=Config#AdminTop");
}
function IpnRec()
{
global $tr_config, $modversion, $xoopsDB, $curr_sign;
$query_Recordset1 = "select `date` as recdate from ".$xoopsDB->prefix("donations_financial").""
." where name='PayPal IPN' order by date desc limit 1";
$Recordset1 = $xoopsDB->query($query_Recordset1);
$row_Recordset1 = $xoopsDB->fetchArray($Recordset1);
if($row_Recordset1){
$recdate = "payment_date > '".$row_Recordset1['recdate']."' and";
}else{
$recdate = '';
}
$query_Recordset1 = "select `payment_date` as curdate from ".$xoopsDB->prefix("donations_transactions").""
." where payment_status='Completed' and (txn_type='send_money' or txn_type='web_accept')"
." order by payment_date desc limit 1";
$Recordset1 = $xoopsDB->query($query_Recordset1);
$row_Recordset1 = $xoopsDB->fetchArray($Recordset1);
$curdate = $row_Recordset1['curdate'];
$query_Recordset1 = "select sum(mc_gross - mc_fee) as ipn_total, count(*) as numrecs"
." from ".$xoopsDB->prefix("donations_transactions")." where ($recdate payment_date <= '$curdate')"
." and payment_status = 'Completed' and (txn_type='send_money' or txn_type='web_accept')";
$Recordset1 = $xoopsDB->query($query_Recordset1);
$row_Recordset1 = $xoopsDB->fetchArray($Recordset1);
echo "title">Update register with PayPal IPN
";
if( $row_Recordset1['numrecs'] == 0 )
echo "There are no new IPN records to import! ";
else
{
$insert_set = "INSERT INTO `".$xoopsDB->prefix("donations_financial")."` (`date`,`num`,`name`,`descr`,`amount`) VALUES ('$curdate','','PayPal IPN','Auto-Reconcile','".$row_Recordset1['ipn_total']."')";
if($xoopsDB->queryF($insert_set))
echo "$row_Recordset1[numrecs] IPN records have been imported for a total of $curr_sign" . sprintf("%0.2f", $row_Recordset1['ipn_total']);
else
echo " ERROR : There are $row_Recordset1[numrecs] to import, but there was an
"
."error encoutered during db record insertion into Financial table. Insertion
"
."FAILED";
}
echo "
index.php?op=Treasury#AdminTop" method="post">";
echo "hidden" name="op" value="Treasury">"
."submit" value="Return"">"
."form>";
}
function adminmain() {
global $tr_config, $modversion, $xoopsDB;
echo "<table align='center' border='1' cellpadding='2' cellspacing='2' width='90%'>n";
echo "<tr>n";
echo "<td align='center' width='50%'><a href='index.php?op=Treasury'>Treasurya>td>n";
echo "<td align='center' width='50%'><a href='index.php?op=Config'>Configa>td>n";
echo "tr>n";
echo "table>n";
echo "<br>";
}
if(!isset($HTTP_POST_VARS['op'])) {
$op = isset($_GET['op']) ? $_GET['op'] : 'Treasury';
} else {
$op = $_POST['op'];
}
Switch($op)
{
default:
case "Treasury":
Treasury();
break;
case "FinRegAdd":
FinancialRegAdd();
break;
case "FinRegEdit":
FinancialRegEdit();
break;
case "FinRegDel":
FinancialRegDel();
break;
case "Config":
Config();
break;
case "ConfigUpdate":
ConfigUpdate();
break;
case "IpnRec":
IpnRec();
break;
}
xoops_cp_footer();
?>
8
Just got done checking the admin/index.php to make sure that $_post & $_get are not set as globals. They are not. so this isn't the issue.
9
I've tried using Method="POST" rather then method="post" and I've also replace all entries of $_GET with $_POST. I'm still getting no closer the donations working with PHP5.
10
All right, in a despirate move I change my server from php4 rather then php5 now the donations module seems to work just fine, the settings save, which means the donations can be made correctly to me. however. IPN Reconsile is not adding the donation to the list in the treasure so the donors can get credit.
I've even tried using the same email for the donors module as I have in XOOPS admin email address.
and I double checked the url in the IPN config at paypal.com
314 user(s) are online (244 user(s) are browsing Support Forums)
Members: 0
Guests: 314
more...
| Stats |
| Goal: |
$100.00 |
| Due Date: |
Nov 30 |
| Gross Amount: |
$0.00 |
| Net Balance: |
$0.00 |
| Left to go: |
$100.00 |
 |
| | |
