/************************************************************************/
/* Donations - Paypal financial management module for XOOPS 2 */
/* Copyright (c) 2004 by Xoops2 Donations Module Dev Team */
/* http://dev.xoops.org/modules/xfmod/project/?group_id=1060 */
/* $Id: index.php,v 1.14 2004/10/15 17:54:09 blackdeath_csmc Exp $ */
/************************************************************************/
/* */
/* Based on NukeTreasury for PHP-Nuke - by Dave Lawrence AKA Thrash */
/* NukeTreasury - Financial management for PHP-Nuke */
/* Copyright (c) 2004 by Dave Lawrence AKA Thrash */
/* thrash@fragnastika.com */
/* thrashn8r@hotmail.com */
/* */
/************************************************************************/
/* */
/* This program is free software; you can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/* */
/* This program is distributed in the hope that it will be useful, but */
/* WITHOUT ANY WARRANTY; without even the implied warranty of */
/* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU */
/* General Public License for more details. */
/* */
/* You should have received a copy of the GNU General Public License */
/* along with this program; if not, write to the Free Software */
/* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 */
/* USA */
/************************************************************************/
include '../../../include/cp_header.php';
if ( file_exists("../language/".$xoopsConfig['language']."/main.php") ) {
include "../language/".$xoopsConfig['language']."/main.php";
} else {
include "../language/english/main.php";
}
require("../includes/form.inc");
include("../includes/functions.php");
xoops_cp_header();
adminmain();
$tr_config = configInfo();
//determine the currency
$PP_CURR_CODE = explode('|',$tr_config['pp_curr_code']); // [USD,GBP,JPY,CAD,EUR]
$PP_CURR_CODE = $PP_CURR_CODE[0];
$curr_sign = define_curr($PP_CURR_CODE);
function Treasury()
{
global $tr_config, $xoopsDB, $modversion, $curr_sign;
// Register paging
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_POST['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_POST['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
$query_Recordset1 = "SELECT id, date, DATE_FORMAT(date, '%d-%b-%Y') as fdate, DATE_FORMAT(date, '%d') as day, DATE_FORMAT(date, '%m') as mon, DATE_FORMAT(date, '%Y') as year, num, name, descr, amount FROM ".$xoopsDB->prefix("donations_financial")." order by date DESC";
$query_limit_Recordset1 = "$query_Recordset1 LIMIT $startRow_Recordset1, $maxRows_Recordset1";
$Recordset1 = $xoopsDB->query($query_limit_Recordset1);
$row_Recordset1 = $xoopsDB->fetchArray($Recordset1);
if (isset($_POST['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_POST['totalRows_Recordset1'];
} else {
$all_Recordset1 = $xoopsDB->query($query_Recordset1);
$totalRows_Recordset1 = $xoopsDB->getRowsNum($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
$queryString_Recordset1 = "&totalRows_Recordset1=".$totalRows_Recordset1."#AdminTop";
// Collect IPN reconcile data
// First, get the date of the last time we reconciled
$query_Recordset2 = "SELECT `date` as recdate FROM ".$xoopsDB->prefix("donations_financial")." WHERE name = 'PayPal IPN' ORDER BY date DESC LIMIT 1";
$Recordset2 = $xoopsDB->query($query_Recordset2);
$row_Recordset2 = $xoopsDB->fetchArray($Recordset2);
$recdate = $row_Recordset2['recdate'];
// Get the date of the last donation
$query_Recordset2 = "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";
$Recordset2 = $xoopsDB->query($query_Recordset2);
$row_Recordset2 = $xoopsDB->fetchArray($Recordset2);
$curdate = $row_Recordset2['curdate'];
// Collect the IPN transactions between recdate and curdate
$query_Recordset2 = "SELECT custom, SUM(mc_gross) AS gross, SUM(mc_gross - mc_fee) AS net FROM ".$xoopsDB->prefix("donations_transactions")." WHERE (payment_date > '".$recdate."' AND payment_date <= '".$curdate."') GROUP BY txn_id";
$Recordset2 = $xoopsDB->query($query_Recordset2);
// Iterate over the records skipping the ones that total out to zero(refunds)
$ipn_tot = 0;
$num_ipn = 0;
while( $row_Recordset2 = $xoopsDB->fetchArray($Recordset2) )
{
if( $row_Recordset2['gross'] > 0 )
{
$ipn_tot += $row_Recordset2['net'];
$num_ipn++;
}
}
// Get the register balance
$query_Recordset4 = "SELECT SUM(amount) as total FROM ".$xoopsDB->prefix("donations_financial")."";
$Recordset4 = $xoopsDB->query($query_Recordset4);
$row_Recordset4 = $xoopsDB->fetchArray($Recordset4);
$total = $row_Recordset4['total'];
// Query to remove the Edit/Delete buttons if no results will be listed.
$queryRec = "select * from ".$xoopsDB->prefix("donations_financial")."";
$RecordsetQ = $xoopsDB->query($queryRec);
$numRec = $xoopsDB->getRowsNum($RecordsetQ);
// Output the page
echo "";
echo "0" cellpadding="0" cellspacing="0" align='center'>";
echo "100%">";
echo "option">"._DM_TREASURY_F_REGISTER."
echo "100%">Number of new IPN records: $num_ipn - Totaling ".$curr_sign.$ipn_tot;
echo "
echo "100%" align='center'>";
echo "index.php?op=IpnRec#AdminTop" method="post">";
echo "hidden" name="op" value="IpnRec">"
."submit" value="PayPal IPN reconcile" onClick="return confirm('This action will total up all recent PayPal IPN" . 'n' . "transactions and post them here in the register." . 'nn' . "Are you sure you want to do this now?')">"
."";
echo "
echo "0" align='center'>";
if( $pageNum_Recordset1 > 0 )
{
echo ''
. ''
. ''
. '. $totalRows_Recordset1 . '">'
. '
echo ''
. ''
. '. max(0, $pageNum_Recordset1 - 1) . '">'
. '. $totalRows_Recordset1 . '">'
. '
}
if( $pageNum_Recordset1 < $totalPages_Recordset1 )
{
echo ''
. ''
. '. min($totalPages_Recordset1, $pageNum_Recordset1 + 1) . '">'
. '. $totalRows_Recordset1 . '">'
. '" title="Next Oldest">
echo ''
. ''
. '. $totalPages_Recordset1 . '">'
. '. $totalRows_Recordset1 . '">'
. '|" title="Oldest">
}
echo " ";
echo "1" width="100%" align="center">"
."center" width="4"> "
."center">Date"
."center">Num"
."center">Name"
."center">Description"
."center">Amount ";
$row=0;
do {
$row += 1;
echo ""
."center">";
if($numRec!=0){
echo "javascript: void 0" onclick=""
."document.recedit.id.value = '$row_Recordset1[id]'; "
."document.recedit.StartMonth.value = '$row_Recordset1[mon]'; "
."document.recedit.StartDay.value = '$row_Recordset1[day]'; "
."document.recedit.StartYear.value = '$row_Recordset1[year]'; "
."document.recedit.Num.value = '$row_Recordset1[num]'; "
."document.recedit.Name.value = '$row_Recordset1[name]'; "
."document.recedit.Descr.value = '$row_Recordset1[descr]'; "
."document.recedit.Amount.value = '$row_Recordset1[amount]'; "
."document.recedit.Submit.value = 'Modify'; "
."document.recedit.op.value = 'FinRegEdit'; "
."return false;">"
."0" width="12" height="13" src="../images/admin/treasury_edit.png"> "
."index.php?op=FinRegDel&id=$row_Recordset1[id]">"
."0" width="12" height="13" src="../images/admin/treasury_drop.png" onClick="return confirm('Are you sure you want to delete this record?" . 'nn' . "Are you sure you want to do this now?')""
.">";
}
echo ""
."left">$row_Recordset1[fdate]"
."left" width="8">$row_Recordset1[num]"
."left">$row_Recordset1[name]"
."left">$row_Recordset1[descr]"
."right">;
$amt = sprintf("%10.2f",$row_Recordset1['amount']);
if( $amt < 0 )
echo "color="#FF0000"";
echo ">$curr_sign$amt ";
} while ($row_Recordset1 = $xoopsDB->fetchArray($Recordset1));
echo "100%" align='center'>right">Net Balance $curr_sign";
echo sprintf("%0.2f", $total) . " ";
echo "
echo ""
."center">Date"
."center">Num"
."center">Name"
."center">Description"
."center">Amount "
."index.php" method="post" name="recedit">"
."left">id" type="hidden">";
$Form = new FormSolution; // 2004-04-02 18:40:55 year-month-day
$Form->DateTimeOptionList('month', 'C', 'StartMonth', 'N', 0, 'N');
$Form->DateTimeOptionList('day', 'C', 'StartDay', 'N', 0, 'N');
$Form->DateTimeOptionList('year', 'C','StartYear','N',0,'N',2003, 3, '','the_id');
echo "left" width="8">Num" type="text" size="8">"
."left">Name" type="text">"
."left">Descr" type="text">"
."right">Amount" type="text" size="8"> "
echo " ";
echo "right" colspan="5">"
."reset" value="Reset" onclick=""
."document.recedit.Submit.value = 'Add'; "
."document.recedit.op.value = 'FinRegAdd'; "
."return true;"> "
."hidden" name="op" value="FinRegAdd">Submit" type="submit" value="Add">
."";
echo "";
echo "
}
function FinancialRegAdd()
{
global $tr_config, $modversion, $xoopsDB;
$time = date("h:i:s");
$nTime = $_POST['StartYear'].'-'.$_POST['StartMonth'].'-'.$_POST['StartDay'].' '.$time;
$nTime = strtotime($nTime);
if($nTime == -1)
echo "Invalid Date format
";
else
if( strlen($_POST['Name']) == 0)
echo "The Name field cannot be blank
";
else
if( !is_numeric($_POST['Amount']))
echo "Invalid Amount field
";
else
{
echo "Field passed validation!
";
echo strftime("%Y-%m-%d", $nTime) . " $_POST[Num] $_POST[Name] $_POST[Descr] $_POST[Amount]
";
$insert_Recordset = "INSERT INTO `".$xoopsDB->prefix("donations_financial")."` VALUES "
."(NULL, '" . strftime("%Y-%m-%d %H:%M:%S", $nTime) . "','" . $_POST['Num'] . "','" . $_POST['Name']
."','" . $_POST['Descr'] . "','" . $_POST['Amount'] . "')";
echo "$insert_Recordset";
$rvalue = $xoopsDB->queryF($insert_Recordset);
echo strftime("%Y-%m-%d", $nTime) . " $_POST[Num] $_POST[Name] $_POST[Descr] $_POST[Amount]
$insert_Recordset";
Header("Location: index.php?op=Treasury#AdminTop");
}
}
function FinancialRegDel()
{
global $tr_config, $modversion, $xoopsDB;
echo "Field passed validation!
";
if( !(is_numeric($_GET['id']) && $_GET['id']>0))
{
echo "
Invalid record id specified, operation aborted
";
} else
{
$del_Recordset = "DELETE FROM `".$xoopsDB->prefix("donations_financial")."` WHERE `id`='$_GET[id]' LIMIT 1";
$rvalue = $xoopsDB->queryF($del_Recordset);
Header("Location: index.php?op=Treasury#AdminTop");
}
}
function FinancialRegEdit()
{
global $tr_config, $modversion, $xoopsDB;
$time = date("h:i:s");
$nTime = $_POST['StartYear'].'-'.$_POST['StartMonth'].'-'.$_POST['StartDay'].' '.$time;
$nTime = strtotime($nTime);
//$nTime = strtotime($_POST[Date]);
if($nTime == -1)
echo "Invalid Date format
";
else
if( strlen($_POST['Name']) == 0)
echo "The Name field cannot be blank
";
else
if( !is_numeric($_POST['Amount']))
echo "Invalid Amount field, do not use any characters other than -.0123456789
";
else
{
echo "Field passed validation!
";
echo strftime("%Y-%m-%d", $nTime) . " $_POST[Num] $_POST[Name] $_POST[Descr] $_POST[Amount]
";
$insert_Recordset = "UPDATE `".$xoopsDB->prefix("donations_financial")."` SET date='". strftime("%Y-%m-%d %H:%M:%S", $nTime) . "', num='$_POST[Num]', Name='$_POST[Name]', "
."descr='$_POST[Descr]', amount='$_POST[Amount]' WHERE id='$_POST[id]' LIMIT 1";
echo "$insert_Recordset";
$rvalue = $xoopsDB->queryF($insert_Recordset);
echo "$_POST[id]" . strftime("%Y-%m-%d", $nTime) . " $_POST[Num] $_POST[Name] $_POST[Descr] $_POST[Amount]
$insert_Recordset";
Header("Location: index.php?op=Treasury#AdminTop");
}
}
function Config()
{
global $tr_config, $modversion, $xoopsDB;
?>
function isEmailAddr(email)
{
var result = false;
var theStr = new String(email);
var index = theStr.indexOf("@");
if (index > 0)
{
var pindex = theStr.indexOf(".",index);
if ((pindex > index+1) && (theStr.length > pindex+1))
result = true;
}
return result;
}
function validRequired(formField,fieldLabel)
{
var result = true;
if (formField.value == "")
{
alert('Please enter a value for the "' + fieldLabel +'" field.');
formField.focus();
result = false;
}
return result;
}
function allDigits(str)
{
return inValidCharSet(str,"0123456789");
}
function inValidCharSet(str,charset)
{
var result = true;
// Note: doesn't use regular expressions to avoid early Mac browser bugs
for (var i=0;i
{
result = false;
break;
}
return result;
}
function validInt(formField,fieldLabel,required)
{
var result = true;
if (required && !validRequired(formField,fieldLabel))
result = false;
if (result)
{
// var num = parseInt(formField.value,10);
if (!allDigits(formField.value))
{
if(required)
{
alert('Please enter a number for the "' + fieldLabel +'" field.');
formField.focus();
result = false;
}
else if ( formField.value == "" )
{
return true;
}
else
{
alert('Please enter a number or a blank for the "' + fieldLabel +'" field.');
formField.focus();
result = false;
}
}
}
return result;
}
function validdateURL(formField, value, secure)
{
var match = /https/i.test(value);
if( value != "" && !/^http/i.test(value) )
{
alert('The URL must start with http://');
formField.focus();
return false;
}
if( secure && value != "" && !/^https/i.test(value) )
{
// alert('This should reside on a HTTPS server. Users will be warned about viewing secure and non-secure data on the same page');
return confirm('This URL does not begin with https://nThis image should reside on an HTTPS server.nIf you use this URL, users will receive a warningnabout viewing secure and non-secure data on the same page.nn Are you sure you want to continue?');
}
return true;
}
function checkCancelledURL()
{
if( document.tr_configs.var_pp_image_url.value == "")
alert('There is no URL for a Cancelled payment. If you do not enterna URL for cancelled payments PayPal will also usenthis URL for cancelled payments.');
return true;
}
echo ''
. '' ;
echo '1' width='90%' align='center'>';
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
Wow, a rapid response, I was just on my way back to correct that it was just queries and no errors. I've edited the preferences manual. and the module point correctly to my donor address, I've not yet tested this yet to see if the donation would work or not. As I only have the one paypal account, going to see if my wife will test this for me. I'm concerned that if the settings don't save that the donating users won't get the credit for their donations.
9
I've used the search feature to no avail searching for "Donation Module"
I am using XOOPS 2.0.18.1 with (paypal) Donations Module v1.4. The website is hosed by GoDaddy's Premium Webhosting Plan for Apache / Linux with PHP5 and MySQL4.1
The problem I am having with the module is that it will not save the edits I make to the configuration.
Here are the errors I receive when trying to update the preferences for the module.
All errors (0) queries (37) blocks (0) extra (0) timers (3)
Errors
Queries
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = 'm2ml637nflhrbsc2aj0kb7c880'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_modules WHERE dirname = 'donations'
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT * FROM xoops_donations_config WHERE subtype = ''
SELECT * FROM xoops_donations_config WHERE name = 'swing_day'
SELECT * FROM xoops_donations_config WHERE name = 'dm_title'
SELECT * FROM xoops_donations_config WHERE name = 'dm_num_don'
SELECT * FROM xoops_donations_config WHERE name = 'dm_show_date'
SELECT * FROM xoops_donations_config WHERE name = 'dm_show_amt'
SELECT * FROM xoops_donations_config WHERE name = 'dm_button'
SELECT * FROM xoops_donations_config WHERE name = 'dm_img_width'
SELECT * FROM xoops_donations_config WHERE name = 'dm_img_height'
SELECT * FROM xoops_donations_config WHERE name = 'goal' AND subtype<>'Default'
SELECT * FROM xoops_donations_config WHERE name = 'don_button_top'
SELECT * FROM xoops_donations_config WHERE name = 'don_top_img_width'
SELECT * FROM xoops_donations_config WHERE name = 'don_top_img_height'
SELECT * FROM xoops_donations_config WHERE name = 'don_button_submit'
SELECT * FROM xoops_donations_config WHERE name = 'don_sub_img_width'
SELECT * FROM xoops_donations_config WHERE name = 'don_sub_img_height'
SELECT * FROM xoops_donations_config WHERE name = 'don_name_prompt'
SELECT * FROM xoops_donations_config WHERE name = 'don_name_yes'
SELECT * FROM xoops_donations_config WHERE name = 'don_name_no'
SELECT * FROM xoops_donations_config WHERE name = 'don_show_date'
SELECT * FROM xoops_donations_config WHERE name = 'don_show_amt'
SELECT * FROM xoops_donations_config WHERE name = 'don_text'
SELECT * FROM xoops_donations_config WHERE name = 'don_amt_checked'
SELECT * FROM xoops_donations_config WHERE name = 'don_amount' ORDER BY subtype
SELECT * FROM xoops_donations_config WHERE name = 'receiver_email'
SELECT * FROM xoops_donations_config WHERE name = 'ty_url'
SELECT * FROM xoops_donations_config WHERE name = 'pp_cancel_url'
SELECT * FROM xoops_donations_config WHERE name = 'pp_itemname'
SELECT * FROM xoops_donations_config WHERE name = 'pp_item_num'
SELECT * FROM xoops_donations_config WHERE name = 'pp_image_url'
SELECT * FROM xoops_donations_config WHERE name = 'pp_get_addr'
SELECT * FROM xoops_donations_config WHERE name = 'ipn_log_entries'
Total: 37 queries
10
Thats great to have a compatibility list. but how about a common fix to those problems that arise from users with PHP5 & MySQL5 does no one see the growing number of users with these versions? I can also use MySQL4 but I am stuck with PHP5 how about a common fix for those users using said versions? the key problem seems to be with posting data. is there a change in the get/post method perhaps with more info some users might just release updated versions of the modules that will work in the newer versions of PHP and MySQL
Login
Search
Recent Posts
Who's Online
Donat-O-Meter
Stats
Goal:
AU$15.00
Due Date:
Jul 31
Gross Amount:
AU$0.00
Net Balance:
AU$0.00
Left to go:
AU$15.00
Latest GitHub Commits
