public function _initRef()
{
$request = JO_Request::getInstance();
if ($request->getRequest('ref')) {
$db = JO_Db::getDefaultAdapter();
if (is_null(JO_Cookie::get('referral'))) {
$query = $db->select()->from('users')->where('username = ?', $request->getRequest('ref'))->limit(1, 0);
$ref_user = $db->fetchRow($query);
if ($ref_user) {
JO_Cookie::set('referral', $ref_user['user_id'], 2628000);
$db->insert('users_referals_count', array('user_id' => 0, 'referal_id' => (int) $ref_user['user_id'], 'datetime' => new JO_Db_Expr('NOW()'), 'order_type' => 'gast'));
} else {
JO_Cookie::delete('referral');
}
} else {
$cookie = JO_Cookie::get('referral');
JO_Cookie::set('referral', $cookie, 2628000);
}
}
}
