Add-On Releases - Donations Progress Image (Wiki lookalike)

If you like it click

Installation Time: <2 mins
Files: 2
Products: 1
VB Version: This actually works on 3.6.4 (not sure about 3.5)

Description:

THIS HACK IS AN ADDITION TO [PayPal Donations]

This Hack will get your dontations stats (i.e. goal total, total donated and percentage) and write them to your Donations Image. It calls the stats from
your Database and writes them to an image called donations.jpg

This hack uses the PHP-GD Function, so be shure you have this enabled on your server. If you don?t be shure about this, ask your host or look in your PHP-Info.

Installation Instructions:

1. Upload donationsimage.php to your /includes/cron/ dir
2. Upload donations.jpg to your forum dir / (CHMOD 777 the donations.jpg)
3. Install the product and run the scheduled task called "Donations Image"
4. go to yourforum/donations.jpg

Examples:

[Example of Use]

FAQ: N/A

If you like it click

To add extra stats look in the signature.php for more info.

[Mr Chad]

you want both?

[Ahsin1]

yeh i want both

[Mr Chad]

find:

PHP Code:

$query_goals = $vbulletin->db->query("SELECT * FROM ".TABLE_PREFIX."donation_goals WHERE active = '1' ORDER BY title ASC LIMIT 0,2");
while ($row = $vbulletin->db->fetch_array($query_goals)){
$amount = $row['amount'];
$amount_formatted = number_format($row['amount'], 2, '.', ',');
$goal_total = $row['total_donated'];
$goal_total_formatted = number_format($row['total_donated'], 2, '.', ',');
if ($row['amount'] > 0){
  $percentage = round(($goal_total/$amount)*100, 2);
} else {
  $percentage = '0';
}
} 


replace with:

PHP Code:

$amount = 0;
$goal_total = 0;
$query_goals = $vbulletin->db->query("SELECT * FROM ".TABLE_PREFIX."donation_goals WHERE active = '1' ORDER BY title ASC LIMIT 0,2");
while ($row = $vbulletin->db->fetch_array($query_goals)){
$amount = $amount + $row['amount'];
$amount_formatted = number_format($row['amount'], 2, '.', ',');
$goal_total = $goal_total + $row['total_donated'];
$goal_total_formatted = number_format($row['total_donated'], 2, '.', ',');
if ($row['amount'] > 0){
  $percentage = round(($goal_total/$amount)*100, 2);
} else {
  $percentage = '0';
}
} 


i have not tested this so please respond with results.

[Ahsin1]

Working Perfect Thanks a lot for ur help

[Mr Chad]

Originally Posted by Ahsin1

Working Perfect Thanks a lot for ur help

glad to hear

[masons]

can I pay someone to fix mine up a little bit? I dont know how to make it appear on the left site column instead of at the top without it messing up the column width.

Also why is it showing $53 when it should be $20?

[Mr Chad]

Originally Posted by masons

can I pay someone to fix mine up a little bit? I dont know how to make it appear on the left site column instead of at the top without it messing up the column width.

Also why is it showing $53 when it should be $20?

can you export your donation_goals table and post it here (from your database).

[masons]

Hi, Here it is!

-- phpMyAdmin SQL Dump
-- version 2.9.0.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 31, 2007 at 01:32 AM
-- Server version: 5.0.24
-- PHP Version: 4.4.4
--
-- Database: `peter_mason`
--

-- --------------------------------------------------------

--
-- Table structure for table `donation_goals`
--

CREATE TABLE `donation_goals` (
`id` int(255) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`amount` decimal(10,2) NOT NULL default '0.00',
`total_donated` decimal(10,2) NOT NULL default '0.00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `donation_goals`
--

INSERT INTO `donation_goals` (`id`, `title`, `description`, `amount`, `total_donated`, `active`) VALUES
(2, 'Running of servers', 'We like to think of this site as a community, as such we hope we can all share in the cost of running this.', '200.00', '0.00', 1);

Also, I really dont know how to make the information look better and placed in the left column, any advise is welcome!

[Mr Chad]

hmm did you CHMOD the image 777 ? because there seems to be no donations so there is no reason for it to say any amount of money. also connect the donation buttons to your goal or it will not be recorded. I'm not sure what you mean abt your left column.

[frandy]

Is it possible to change the color/style of the image? Like have a gradient in the background? change the positioning of the text etc?