[masterross]

Hi Valter,

Could you include option for showing total donations per user?
I wrote this code to show the Total donations per user in Postbit:

Product: VSa - PayPal Donate
Hook Location: postbit_display_start
Title: total_don

PHP Code:

if ($this->post['userid'])
                {
    global $db, $vbulletin;
                    $userdon = $db->query_read("
                        SELECT userid, SUM(amount) AS TotalDon
                        FROM " . TABLE_PREFIX . "vsa_ppdonate
                        WHERE (userid = ".$this->post['userid'].") AND (confirmed=1)
                        GROUP BY userid
                    ");
                
                    while ($array = $db->fetch_array($userdon))
                        {
                        $post['total_dons'] = $array['TotalDon'];
                        }  


                } 


In postbit I use:

<vb:if condition="$post['total_dons']"><dt>Donated so far</dt> <dd> ${vb:raw post.total_dons}</dd></vb:if>

P.S>
Maybe you could include the Top Donators in your Advanced Stats too?


Regards,
Ross