Plugin "most_popular_item"

[DockM@ster]

Hallo,

ich habe mir das Plugin "most_popular_items" installiert und dabei ein kleines Problem gefunden:
Es werden auch Anzeigen gezeigt die abgelaufen sind aber noch in der Datenbank stehen.
Da ich kein Programmierer bin bitte ich euch um Hilfe. Was muss im unter aufgeführten Code geändert werden damit nur aktive Anzeigen gelistet werden?

Code: [Select]

// function for displaying text on the Item page
function popular_ads_start() {

    $num_ads = popular_ads_num_ads(); // SETS HOW MANY POPULAR ADS TO DISPLAY


    $conn = getConnection();
    $results=$conn->osc_dbFetchResults("SELECT fk_i_item_id, i_num_views FROM %st_item_stats ORDER BY fk_i_item_id ASC", DB_TABLE_PREFIX);

    if(count($results)>0) {
    foreach($results as $result){
        $view_count[$result['fk_i_item_id']] += $result['i_num_views']; // Add-up all item views stored in database
    }

    arsort($view_count); // sorts array by highest number of item views first

    foreach($view_count as $item_id=>$views)
    {
        $result=$conn->osc_dbFetchResult("SELECT fk_i_user_id, fk_i_category_id, dt_pub_date, dt_mod_date, f_price, b_active, i_price, fk_c_currency_code, b_premium, s_secret FROM %st_item WHERE pk_i_id = %d", DB_TABLE_PREFIX, $item_id); //Get active status of item

        if($result['b_active']==1){
            //echo 'Item ID: '.$item_id.' Views: '.$views.'<br>'; // display only if item is active
        $index++;

have a nice day...

DockM@ster
[/code]