First off, I'm sure this isn't realated to RN or phpnuke treasury directly because I run that combo myself without problems.
I am taking over the webmaster role for a gaming clan and they were using nuke 7.9 with autotheme and a manual donation block.
I tried adding the phpnuke treasury v1.0 and all seems to work until you activate the donate-o-meter block. As soon as you add that block the admin panel breaks. You get a blank page with just the logout/exit icon and the footer text.
If you 'manually' put in the block config url it too is blank with no way to modify anything. I can, at this point see the donate-o-meter correctly on the left side of the website, but it looks like all 'center blocks' go away. Logging out of admin shows the left/right blocks, with no center section. The donate-o-meter block 'looks' fine.
In an effort to have a safer phpnuke I installed a fresh copy of RN76 v2.02.02 and installed the treasury, autotheme (required for the theme we are running). and the same thing happens.
If anyone's run across this or has an idea of what might be causing it I'd really appreciate it!
Only registered users can see links on this board! Get registered or login to the forums!
Gives you the ability to track donations in real time (showing up in a block)
I've found that the PROBLEM must be somewhere at the end of the block, ie the block is not closing correctly, because as part of my troubleshooting it seemed that whatever was after the block died. I put the block at the end of the right side and everything seems to work 'ok' now.
This really points to the block not doing something right, but I'm not a coder and cannot figure it out.
<?php
/************************************************************************/
/* 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 */
/************************************************************************/
if (eregi("block-Donat_o_Meter.php",$_SERVER['PHP_SELF'])) {
Header("Location: index.php");
die();
}
global $user, $cookie, $prefix, $db, $user_prefix;
include("modules/Donations/config.php");
if( !$ipnppd )
{
$content = "There is an error in your SQL configuration. Check modules/Donations/config.php for the correct SQL settings";
}
else
{
global $content;
// Check the current day against the swing day to execute the proper query
if( date('d') >= $swingd )
{
$query_Recordset1 = ' SELECT business, COUNT( mc_gross ) AS count, SUM( mc_gross ) AS gross, SUM( mc_gross - mc_fee ) AS net, DATE_FORMAT( NOW( ) , \'%M\' ) AS mon, '
. ' DATE_FORMAT( SUBDATE( DATE_FORMAT( ADDDATE( NOW( ) , INTERVAL 1 MONTH ) , \'%Y-%c-1\' ) , INTERVAL 1 DAY ) , \' %b %e\' ) AS due_by, '
. ' DATE_FORMAT( NOW( ) , \'%b\' ) AS mon_short'
. ' FROM transactions'
. ' WHERE ( transactions.payment_date >= DATE_FORMAT( NOW( ) , \'%Y-%m-' . $swingd . '\' ) ) '
. ' GROUP BY business';
$query_Recordset3 = 'SELECT custom AS name, option_selection1 as showname, ';
$query_Recordset3 .= 'DATE_FORMAT( payment_date, \'%b-%e\' ) AS date, ';
$query_Recordset3 .= 'CONCAT(\'$\',SUM(mc_gross)) AS amt ';
$query_Recordset3 .= ' FROM transactions'
. ' WHERE ( transactions.payment_date >= DATE_FORMAT( NOW( ) , \'%Y-%m-' . $swingd . '\' ) ) '
. ' GROUP BY txn_id ORDER BY payment_date DESC';
} else
{
$query_Recordset1 = ' SELECT business, COUNT( mc_gross ) AS count, SUM( mc_gross ) AS gross, SUM( mc_gross - mc_fee ) AS net, DATE_FORMAT( SUBDATE( NOW( ) , INTERVAL ' . $swingd . ' '
. ' DAY ) , \'%M\' ) AS mon, \'Now!\' AS due_by, DATE_FORMAT( SUBDATE( NOW( ) , INTERVAL ' . $swingd . ' '
. ' DAY ) , \'%b\' ) AS mon_short'
. ' FROM transactions'
. ' WHERE ( transactions.payment_date < DATE_FORMAT( NOW( ) , \'%Y-%m-' . $swingd . '\' ) ) AND transactions.payment_date > DATE_FORMAT( SUBDATE( NOW( ) , INTERVAL ' . $swingd . ' '
. ' DAY ) , \'%Y-%m-' . $swingd . '\' )'
. ' GROUP BY business ';
$query_Recordset3 = 'SELECT custom AS name, option_selection1 as showname, ';
$query_Recordset3 .= 'DATE_FORMAT( payment_date, \'%b-%e\' ) AS date, ';
$query_Recordset3 .= 'CONCAT(\'$\',SUM(mc_gross)) AS amt ';
$query_Recordset3 .= ' FROM transactions'
. ' WHERE ( transactions.payment_date < DATE_FORMAT( NOW( ) , \'%Y-%m-' . $swingd . '\' ) ) AND transactions.payment_date > DATE_FORMAT( SUBDATE( NOW( ) , INTERVAL ' . $swingd . ' '
. ' DAY ) , \'%Y-%m-' . $swingd . '\' ) '
. ' GROUP BY txn_id ORDER BY payment_date DESC';
}
// Get the donation totals
$Recordset1 = mysql_query($query_Recordset1, $ipnppd) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
//If there are not records, then get "null" data
if( !$row_Recordset1 )
{
$query_Recordset1 = ' SELECT \'\' AS business, \'0\' AS count, \'0\' AS gross, \'0\' AS net, DATE_FORMAT( NOW( ) , \'%M\' ) AS mon, DATE_FORMAT( SUBDATE( DATE_FORMAT( ADDDATE( NOW( ) , INTERVAL 1 '
. ' MONTH ) , \'%Y-%c-1\' ) , INTERVAL 1 '
. ' DAY ) , \' %b %e\' ) AS due_by, DATE_FORMAT( NOW( ) , \'%b\' ) AS mon_short';
$Recordset1 = mysql_query($query_Recordset1, $ipnppd) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
}
// Get the goal
$query_Recordset2 = $sql = 'SELECT * FROM config WHERE name=\'goal\' AND subtype=\'' . $row_Recordset1['mon_short'] . '\'';
$Recordset2= mysql_query($query_Recordset2, $ipnppd) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
// Do we want to display the donators?
if(is_numeric($dmlen) && $dmlen >= 0 )
{
// Get the list of donators
$Recordset3= mysql_query($query_Recordset3, $ipnppd) or die(mysql_error());
// List all the donators
$i = 0;
while ( ($row_Recordset3 = mysql_fetch_assoc($Recordset3)) && ($i != $tr_config[dm_num_don]) )
{
// Refunded transactions will show up with $0 amount
if( $row_Recordset3['amt'] > "$0" )
{
// Observe the user's wish regarding revealing their name
if( strcmp($row_Recordset3['showname'],"Yes") == 0)
$name = $row_Recordset3['name'];
else
$name = "Anonymous";
Hey I appreciate your attempt at least. I couldn't find anything either, but that didn't mean a whole lot. I basically just checked the {}'s and made sure there wasn't something silly in there.
Joined: Aug 29, 2004 Posts: 9136 Location: Arizona
Posted:
Wed May 24, 2006 5:43 am
I use the same block, so it must be a conflict with autotheme. Unfortunately, I too, do not have any experience with autotheme. I had read early on to avoid it so I just never picked it up and that was too long ago to remember why. We'll have to see if others have experience with this.
Joined: Aug 29, 2004 Posts: 9136 Location: Arizona
Posted:
Wed May 24, 2006 7:19 am
What I mean is accessing a module page rather than the admin links. For example, can you get to Downloads module? Need to rule out admin vs. module vs. autotheme conflict.
View next topic View previous topic
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
![[Valid RSS]](http://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
:: 
::
