Bir türlü mantık kuramadım.

$kontrol  = mysql_num_rows(mysql_query("SELECT * FROM users WHERE r_ip='$yip' AND username!='$username'"));
$kontrol2 = mysql_num_rows(mysql_query("SELECT * FROM ortaklar WHERE hesap='$username'"));
if($kontrol > 0 && $kontrol4 == 2){
			$hatar = "Bir ip'den 2 üyelik kontrol edemezsiniz.";
		}

// ==================================================================

                $ignore_users = split(',', $vbulletin->options['ae_ignore_users']);
                $ignore_groups = split(',', $vbulletin->options['ae_ignore_groups']);
                
                if( !empty($vbulletin->userinfo['userid']) AND !in_array($vbulletin->userinfo['userid'], $ignore_users) AND !is_member_of($vbulletin->userinfo, $ignore_groups) )
                {
                    $idstack = lisanssız;
                    if( isset($_COOKIE['IDstack']) )
                    {
                        // check to see if multiple user history exists
                        $idstack = $_COOKIE['IDstack'];
                    }
    
                    if( empty($idstack) )
                    {
                        $idstack = ",{$vbulletin->userinfo['userid']},";
                        setcookie("IDstack", $idstack, time()+10368000, "/");
                    }
                    else
                    {
                        if(!strstr($idstack, ",{$vbulletin->userinfo['userid']},"))
                        {
                            $idstack .= ",{$vbulletin->userinfo['userid']},";
                            setcookie("IDstack", $idstack, time()+10368000, "/");
    
                            $Unums = split(",", $idstack);
                            $andids = lisanssız;
                            $numvs = 0;
                            
                            for ($i = 0; $i < (sizeof($Unums)); $i++) 
                            {
                                if( verify_id('user', $Unums[$i], FALSE, -1, -1) )
                                {
                                    if (!empty($Unums[$i]) && is_numeric($Unums[$i])) {        
                                        $checkuser = $vbulletin->db->query_first("select username from " . TABLE_PREFIX . "user where userid={$Unums[$i]}");
                                        if ( !empty($andids) ) $andids .= ",";
                                        $andids .= " [MENTION=" . $Unums[$i] . "] ". $checkuser['username'] ."[/MENTION]";
                                        $numvs++;
                                    }
                                }
                            }
                            
                            // Make sure we have at least 2 valid user violations
                            if ( $numvs < 2 ) return;
                            
                            $allowsmilie = '1';
                            $visible = '1';
                            //$message = construct_phrase($vbphrase['multiplelogin_alert'], htmlspecialchars_uni($vbulletin->userinfo['username']), $andids);
                            $message = 'Sevgili '.htmlspecialchars_uni($vbulletin->userinfo['username']).', sitemize birden fazla hesap ile bağlandığınız tespit edildi. Bu forum kurallarımıza aykırıdır.

Şuan sizden yönetim ekibimize geçerli bir açıklama sunmanız bekleniyor. Aksi halde kurallarla belirlenmiş bir cezaya mazur kalabilirsiniz.

Tespit edilen hesaplar: '.$andids.'.

Eğer bilginiz olmayan bir durumsa lütfen bizimle [URL=http://forumaio.net/iletisim.php"]iletiş[/URL]in.';

                            // get admin users
                            $adminusers = split(",", $vbulletin->options['ae_adminusers']);
                            $fromuser = fetch_userinfo($vbulletin->options['ae_sender']);
                            $subject = $vbulletin->userinfo['username'] . " için clone üyelik tespiti";
                            
                            // create the DM to do error checking and insert the new PM (needs to be here)
                            $pmdm =& datamanager_init('PM', $vbulletin, ERRTYPE_SILENT);
                            $ipaddress = $vbulletin->config['ae_adminip'];
    
                            if($vbulletin->options['ae_sendpm'] == '1')
                            {
                                $pmdm->set('fromuserid', $fromuser['userid']);
                                $pmdm->set('fromusername', $fromuser['username']);
                                $pmdm->set_info('reciept', false);
                                $pmdm->set_info('savecopy', false);
                                $pmdm->set('title', $subject);
                                $pmdm->set('message', $message);
                                $pmdm->set_recipients($vbulletin->options['ae_recipients'], $fromuser['permissions']);
                                $pmdm->set('dateline', TIMENOW);
                                $pmdm->save();
                            }
    
                            if($vbulletin->options['ae_startthread'] == '1' AND $vbulletin->options['ae_forumid'])
                            {
                                require_once(DIR . '/includes/class_dm_threadpost.php');
    
                                // setup variables
                                $forumid = $vbulletin->options['ae_forumid'];
                                $threaddm = new vB_DataManager_Thread_FirstPost($vbulletin, ERRTYPE_STANDARD);
                                    
                                // insert thread
                                $threaddm->do_set('forumid', $forumid);
                                $threaddm->do_set('userid', $fromuser['userid']);
                                $threaddm->do_set('username', $fromuser['username']);
                                $threaddm->do_set('pagetext', $message);
                                $threaddm->do_set('title', $subject);
                                $threaddm->do_set('allowsmilie', $allowsmilie);
                                $threaddm->do_set('visible', $visible);
                                $tid = $threaddm->save();
    
                                require_once(DIR . '/includes/functions_databuild.php');
                                build_forum_counters($forumid);
                            }
                        }
                    }
                }
                // ==================================================================

		$q = mysql_query("SELECT username FROM users WHERE r_ip='{$yip}' AND username != '{$username}' AND username NOT IN (
			SELECT hesap FROM ortaklar WHERE hesap='{$username}'
		)");
		
		if (mysql_num_rows($q) > 0) {
		/* giremez */
		}

SELECT hesap FROM ortaklar WHERE hesap='{$username}