Please Log in to join the conversation.
$atid = 0;
if (!empty($_COOKIE["atid"])) {
$cookiecontent = unserialize(base64_decode($_COOKIE["atid"]));
$atid = (int)$cookiecontent["atid"] ;
}
//test
//$atid = 2173;
global $_CB_database;
$query = "SELECT " . $_CB_database->NameQuote( 'user_id' ) . " FROM " . $_CB_database->NameQuote( '__affiliate_tracker_accounts' ) . " WHERE " . $_CB_database->NameQuote( 'id' ) . " = " . $atid ." LIMIT 1";
$_CB_database->setQuery( $query );
return (int)$_CB_database->loadResult();
Please Log in to join the conversation.
You're missing the #. So it should be #__affiliate_tracker_accounts for it to auto replace the table prefix.$_CB_database->NameQuote( '__affiliate_tracker_accounts' )
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.