Well, the error disappeared, but only because I disabled avatars in profile. This is what now my smf.php reads:
list( $avatarurl ) = ppmysql_query_onerow("SELECT value FROM {$Globals['dprefix']}settings WHERE variable='custom_avatar_url'", $db_link);
$avcheck = substr($uavatar, 0, 4);
So, yes I changed it...
But I can still not see an ad and I still get the same error when I click any ad!
I'm looking at my settings in Edit Integration:
This prefix is for PPC database, right? You can check it with the admin login I sent out to you. Let me know if you would like to have a look at my database too. Right now I can still not use PPC as it would never show an ad!!!
I found this in the table cp_settings:
Quote:
|
83 setting83 dprefix smf_
|
So, both prefixes are entered correctly during installation...
BTW there is no variable 'custom_avatar_url' in the smf_settings table, even if PPC find that table...
Look, its OK not to show avatars - I already disabled showing avatars. Just want to make it show the ads! Thanks again.