[Cole2026]

Error in code i dunno if its how my site is setup or what but if anyone else gets an error on the main cmps page do this:

Open File affilateblock.php
Find This

PHP Code:

$faffiliate= $DB_site->query("SELECT sitename,siteurl,affiliate_id,clicksout,clicksin,buttonurl FROM  " . TABLE_PREFIX . " affiliates WHERE active='1' ORDER BY clicksin DESC LIMIT $affsettings[top_limit]"); 


Replace with this

PHP Code:

$faffiliate= $DB_site->query("SELECT sitename,siteurl,affiliate_id,clicksout,clicksin,buttonurl FROM affiliates WHERE active='1' ORDER BY clicksin DESC LIMIT $affsettings[top_limit]");