[tamarian]

Originally Posted by Cold Steel

I'm getting errors, too:


I'm unable to edit subscriptions.

I have the ucash/ustore hack installed, as well as the recurring paypal hack.

The "foreach" error is not a problem, but the mysql error is a problem. I've made an update to the first post.

You just need to re-do step 2 with this code:

PHP Code:

    // ###################### thankyou #######################
    function thankyou(){
          global $DB_site,  $stylevar, $vboptions, $vbphrase;
    
        require_once('./global.php');
    
        $latestcontributers = $DB_site->query("SELECT username, status, regdate,   subscriptionlog.userid
                    FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog
                    LEFT  JOIN " . TABLE_PREFIX . "user AS user
                    USING ( userid )
                    WHERE user.userid = subscriptionlog.userid
                    AND STATUS = '1'
                    ORDER  BY  regdate  DESC
                    LIMIT 5");
    
        $latest_str = "";
        while ($contributer = $DB_site->fetch_array($latestcontributers))
        {
            eval ('$latest_str .= ", ' . fetch_template('thanksbit') . '";');
        }
        $latest_str = substr($latest_str , 2);
        $latest_str = addslashes($latest_str);
 $DB_site->query("UPDATE " . TABLE_PREFIX . "template SET template=\"$latest_str\", template_un=\"$latest_str\" WHERE title='thanks'");
    }