'
'//////////////////////////////////////////////////////////////////////////////// CHECK FEATURES
'
dim feature(500)
sql="SELECT * FROM features ORDER BY id DESC LIMIT 1"
set rslastfeat=vanillaconn.execute(sql)
for feat=1 to rslastfeat("id")
    sql="SELECT * FROM features WHERE active=1 AND id=" & feat
    set rsfeat=vanillaconn.execute(sql)
    if rsfeat.eof then
        feature(feat)=0
    else
        sql="SELECT * FROM sites_features WHERE active=1 AND feat_id=" & feat & " AND site_id=" & rssite("id")
        set rsfeat2=vanillaconn.execute(sql)
        if rsfeat2.eof then
            feature(feat)=0
        else
            feature(feat)=1
        end if
        rsfeat2.close
    end if
    rsfeat.close
next
rslastfeat.close

dim ecom_feature(500)
sql="SELECT * FROM ecom_features ORDER BY id DESC LIMIT 1"
set rslastfeat=vanillaconn.execute(sql)
for feat=1 to rslastfeat("id")
    sql="SELECT * FROM ecom_features WHERE active=1 AND id=" & feat
    set rsfeat=vanillaconn.execute(sql)
    if rsfeat.eof then
        ecom_feature(feat)=0
    else
        sql="SELECT * FROM sites_ecom_features WHERE active=1 AND feat_id=" & feat & " AND site_id=" & rssite("id")
        set rsfeat2=vanillaconn.execute(sql)
        if rsfeat2.eof then
            ecom_feature(feat)=0
        else
            ecom_feature(feat)=1
        end if
        rsfeat2.close
    end if
    rsfeat.close
next
rslastfeat.close