Forumlar / Cotonti / Extensions / Top donations plugin

Kingsley
#29797 2011-06-06 10:38

Hi,

Finally found the time to start with php, but im kinda stuck because i do not know where to look :(

I wrote a small plugin for displaying top 5 donations om the main. but it won't display the output for some reason, although the output is retreived. This is my code:

 

"<?PHP
/* ====================
[BEGIN_SED_EXTPLUGIN]
Code=recentdonations
Part=
File=recentdonations
Hooks=standalone
Tags= header.tpl {PLUGIN_RECENTDONATIONS}
Order=10
[END_SED_EXTPLUGIN]
==================== */

/**
 * Displays top5 latest donations
 *
 * @author Kingsley
 * @copyright Copyright (c) Madkings.nl 2011
 * @license BSD
 */


if (!defined('SED_CODE') || !defined('SED_PLUG')) { die('Wrong URL.'); }

// table where donations are
$donations ='cot_donations';

$sql1 = sed_sql_query("SELECT `donation_username`, `donation_date`, `donation_amount` FROM $donations ORDER BY donation_date DESC LIMIT 5");
$total1 = sed_sql_numrows($sql1);

$html .= '<table class="cells">';
while ($row = sed_sql_fetcharray($sql1))
{
    
    $html .= '<tr><td>'. $row['donation_username'].'</td>';
    $html .= '<td>'. $row['donation_date'].'</td>';
    $html .= '<td>'. $row['donation_amount'].'</td></tr>';
}
$html.= '</table>';

$t-> assign(array(
    "PLUGIN_RECENTDONATIONS" => $html,
));



?>

and the setup:

<?PHP
/* ====================
[BEGIN_SED_EXTPLUGIN]
Code=recentdonations
Name=Recent Donations
Description=Lists of latest donations
Version=0.1
Date=2011-june-03
Author=Kingsley
Copyright= Madkings.nl
Notes=BSD License
SQL=
Auth_guests=R
Lock_guests=W12345A
Auth_members=R
Lock_members=W12345A
[END_SED_EXTPLUGIN]

==================== */

/**
 * Displays lists of latest donations
 *
 * @author Kingsley
 * @copyright Copyright (c) Madkings.nl 2011
 * @license BSD
 */

defined('SED_CODE') or die('Wrong URL');

?>

Can some-one please tell me what I am overlooking? thank you