donations block??

Worker Joined: Aug 27, 2006 Posts: 172

I will have to check o monday because i don;t have the access from here.

New Member Joined: Oct 09, 2006 Posts: 15

I have a php file that could be the one to change, but not really sure, i can send a copy to your mail address, if you would like a look, i did try to post it he, but because its a php script, the forum banned me, and i had to send a mail to admin of site. so pm your mail addy and i'll send it to you if you like?

New Member Joined: Feb 02, 2007 Posts: 24

This is lengthy but may help you a little. Some steps will be skipped due to it having been pre-installed. This comes in the downloaded version 1.1.

Quote:

======
Setup Instructions
======
Unpack all the file unders "html" into your Nuke root

Extract the sql/Treasury.sql and drop it into mysql.
Note: the database for this mod was intended to reside outside of your Nuke
database in a separate database. The thought here is that the
financial records would require special attention in regards to
backups. A separate db just makes those backups easier. You can
put the table inside whatever database you'd like(including Nuke),
however there's no support for a table prefix at this time.

Edit the modules/Donations/config.php and enter the approporiate
sql credentials.

Go to the Nuke Admin panel and enable the "Donat_o_Meter" block
and the "Donations" module. Make sure the Donatometer displays
correctly and check the link to the Donations module on the
"Make a Donation" button.

======
PayPal
======
In the admin panel, click the Treasury icon and then click on the
"Config" button. Scroll down towards the bottom in the PayPal
Configuration box and find and find the option "PayPal Receiver Email".
Enter the email address registered in your PayPal account that you
would like to receive donation on. I highly recommend you have a special
email address for this. This mod will show all payments made to this
address, whether they came from this mod, or not. Click on a Submit
button once you have entered the email address.
This should take you back to the Treasury panel, click onthe config
button again scroll down to the bottom and find the box labeled
"IPN link for PayPal". The URL to the right should be the complete URL
that points to the IPN file PayPal needs. Click on the link provided
to test the IPN file. Keep this window open during the next step as we
will need to copy out the IPN URL.
Assuming the files tests ok, we now want to open up our PayPal
account. Find your account "Profile" in PayPal and look for:
"Instant Payment Notification Preferences". In there you should see
2 options: one to enable IPN and the other called:
"Instant Payment Notification (IPN) URL". In this field you'll enter
the complete URL listed in the previous window on the Treasury config
page. it should be something like this:
[ Only registered users can see links on this board! Get registered or login! ]

If your Nuke site is not in the root, then:
[ Only registered users can see links on this board! Get registered or login! ]

"nukename" is, of course, whatever folder you have under your site root.

Your IPN is enabled!

==================
Nuke Configuration
==================
The NukeTreasury includes a plethora of configurable options.
To get started all you need to configure is the "PayPal Receiver Email"
which we did above. All the other options are gravy. Each option
has a tool tip that describes it's use. Practically every option
involved in this mod is configurable. It was designed so that no
file editing was required. The Donatometer block and Donations module
are pulled from template files located in modules/Donations. If you
like you can edit these html templates to further customize this mod.
I tried to lay out the tags as clearly as I could to ease customization.
The text listed in the Donations module is actually stored in the
database and you can customize it on the Treasury Config page. This
text block can contain any HTML markup you like and remember it's HTML
(so you need 's for line breaks, for example)

==============
NOTES on usage
==============
-The PayPal IPN is a live transaction and can only occur when the
payment is actually made. There is no way to receive IPN's for past
transactions. This is inherent in the PayPal IPN design.
-Refunds are properly handled. If you have logging enabled, and you
refund a payment you will see a log entry:
"Valid IPN, but not interested in this transaction"
This a normal log entry for a refund. The PayPal actually sends 2
IPN's that relate to a single refund. This mod only needs one of the 2.
The log entry is for the second, un-needed IPN.

============
Known Issues
============
-The Treasury admin panel can only be accessed with "Super User" privs.
This is primarily because Nuke is not easily adapted to allow customized
admin panel priviledges. This would require a php code change when
no php code changes are required at all for this mod.
-The IPN transactions and log is only viewable directly from the database,
and through tools such as phpmyadmin.

=======
Testing
=======
-Once you have this mod fully configured you should make a test
donation. You can do this by making a normal donation that you can
later refund in full. In PayPal, looking at the details of the
transaction for the donation you just made, you should see a link
where you can refund the payment. You can make and refund as many
payments as you like without any cash penalty.

Have fun!

New Member Joined: Feb 22, 2007 Posts: 17

shotokan wrote:

/* Database configuration */
$hostname_ipnppd = "localhost";
$database_ipnppd = "db-name";
$username_ipnppd = "db-user";
$password_ipnppd = "db-pass";

and publish your here.

Is this config exactly what I should see or do i substitute appropriate items into quotes?

Posted: Fri Feb 23, 2007 8:20 pm

When I do an IPN test I get this error.

Quote:

Warning: main(../config.php ) [function.main]: failed to open stream: No such file or directory in /home/wa5pshiv/public_html/nuke/modules/Donations/ipn/ipnppd.php on line 9

Warning: main(../config.php ) [function.main]: failed to open stream: No such file or directory in /home/wa5pshiv/public_html/nuke/modules/Donations/ipn/ipnppd.php on line 9

Warning: main(../config.php ) [function.main]: failed to open stream: No such file or directory in /home/wa5pshiv/public_html/nuke/modules/Donations/ipn/ipnppd.php on line 9

Warning: main() [function.include]: Failed opening '../config.php ' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/wa5pshiv/public_html/nuke/modules/Donations/ipn/ipnppd.php on line 9
Debug mode activated

PHP-Nuke Treasury mod

PayPal Instant Payment Notification script

See below for status:
----------------------------------------------------------------

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'wa5pshiv'@'localhost' (using password: NO) in /home/wa5pshiv/public_html/nuke/modules/Donations/ipn/ipnppd.php on line 29
Access denied for user 'wa5pshiv'@'localhost' (using password: NO)

Posted: Fri Feb 23, 2007 9:50 pm

Looks like it wants the file config.php in
modules/Donations/config.php
Do you have that file?

Posted: Fri Feb 23, 2007 10:18 pm

Yes, here is the top of the ipnppd.php file

Quote:

<?php
/************************************************************************/
/* NukeTreasury - Financial management for PHP-Nuke */
/************************************************************************/

/* NOTE: This file is accessed by PayPal directly, and not through PHP-Nuke */

include("../config.php
");
$ERR = 0;
$log = "";
$loglvl = $tr_config[ipn_dbg_lvl];
define(_ERR, 1);
define(_INF, 2);

Here is my config.php file. I think my problem is with what I highlighted red. But I don't know enough to fix it.

Quote:

<?php
/************************************************************************/
/* NukeTreasury - Financial management for PHP-Nuke */
/************************************************************************/

/* Database configuration */
/* Database configuration */

$hostname_ipnppd = "localhost";
$database_ipnppd = "wa5pshiv_wa5psdonator";
$username_ipnppd = "wa5pshiv@localhost";
$password_ipnppd = "no";

$board_config = array();
global $ipnppd;

$ipnppd = mysql_pconnect($hostname_ipnppd, $username_ipnppd, $password_ipnppd);
if( $ipnppd )
{
mysql_select_db($database_ipnppd, $ipnppd);
$query_cfg = "SELECT * FROM config WHERE subtype = ''";
$cfgset = mysql_query($query_cfg, $ipnppd);

while ( $cfgset && $row = mysql_fetch_assoc($cfgset))
{
$tr_config[$row['name']] = $row['value'];
}
} else
{
echo " NukeTreasury FATAL ERROR: Unable to connect to SQL database. Please check your settings in modules/Donations/config.php ";
}

?>

Posted: Sat Feb 24, 2007 12:15 am

Are you sure the username is correct? It isn't an email address, it probably doesn't need the @localhost

Posted: Sat Feb 24, 2007 2:06 am

where would I verify I have the right name??

Posted: Sat Feb 24, 2007 1:50 pm

kypdr wrote:

where would I verify I have the right name??

All this info is provided by your wesite host. The database name and password you created when you set up your site.

Should be similar to this.

$hostname_ipnppd = "'mysql1234.secureserver.net'";
$database_ipnppd = "DatabaseName";
$username_ipnppd = "YourUserName";
$password_ipnppd = "YourPassword";

These are NOT your website login names, UNLESS you used the same info for your database as you do to login.

Posted: Sat Feb 24, 2007 3:34 pm

Quote:

wa5pshiv_waspsdonator

Users in waspsdonator
wa5pshiv_admin (Privileges: ALL PRIVILEGES)

Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:*****_*******:localhost","wa5pshiv_*****","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "wa5pshiv_*****", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("*****_*******");

does this make sense looking at the above?

Quote:

$hostname_ipnppd = "mysql:*****_*******";
$database_ipnppd = "******";
$username_ipnppd = "*****";
$password_ipnppd = "******";

Posted: Sat Feb 24, 2007 6:14 pm

it looks right.. as long as you got all the info from your host.

Posted: Sat Feb 24, 2007 6:55 pm

Please edit your posts to remove sensetive information - unless of course you really want hackers to use that information.

Posted: Mon Feb 26, 2007 3:57 pm

lilc420 wrote:

it looks right.. as long as you got all the info from your host.

But I'm still getting the error.

BTW; Guardian2003 TY for the slap in the face about my post. Wasn't thinking when I did that.

Posted: Mon Feb 26, 2007 4:28 pm

Who hosts your website?

Posted: Mon Feb 26, 2007 7:36 pm

Branzone.com it uses cpanel.

Posted: Mon Feb 26, 2007 8:26 pm

I am not familiar with them. You may need to contact them and ask them for the correct info. or how to find it. I think something is still not correct... or your host is blocking a port or something.

Also, did you make all your changes on the PayPal website?

Posted: Mon Feb 26, 2007 10:31 pm

I just had to activate the IPN and put in the correct URL at Paypal, correct?

Posted: Mon Feb 26, 2007 10:36 pm

Not sure.. it should have instructions in the readme. I think maybe your LocalHost is still wrong.. should be something like Mysql##.something.net

Look in your myphpadmin for a connection string.. or maybe in your Cpanel under database. You connection string will have all info you need in it.

Posted: Mon Feb 26, 2007 11:06 pm

In MySQL account maintainance

Connection Strings

Quote:

PERL DBI->connect("DBI:mysql:*****_*****:localhost"

Quote:

PHP $dbh=mysql_connect ("localhost", "*****_****", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("******_*********");

This is under myphpadmin at top.

Quote:

Server: localhost Database: *******_********

New Member Joined: Jul 08, 2007 Posts: 9

Hey ppl,

Don't know if anyone still cares about this posting or not, but I've worked for days on this, and finally got it to work correctly.

Hey kypdr, in regards to your login information, you should be able to see what your site is currently using by reviewing the "config.php" in the site root. Near the top it should give you the host, dbname & password. They recommend using a seperate database for this block/module, however it does work correctly if you use the standard Nuke database, simply make sure there is no prefix on the tables (ie. Nuke_finanical -> should simply be financial, without the nuke_).

To all other ppl, if your "Test IPN" comes back as successful, I'd recommend double checking your Paypal account to ensure that the Instant Notifications are still active. From time to time it seems Paypal resets these.... why??? I have no idea. Even with the IPN disabled on the Paypal site, the Test IPN WILL come back as successful (though it shouldn't if you ask me).

Again, don't know if anyone cares anymore, but hope this helps a little.

Peace Chizo OUT