Хак. Поднятие анкеты в поиске за рейтинг. версия 1.9

<tr>
                        <td valign="top" class="">
                            <div><strong>{$LANG.BIRTH}:</strong></div>
                            <div><small>{$LANG.NOPUBLISH_TEXT}</small></div>
                        </td>
                        <td valign="top" class="">{php}$inCore=cmsCore::getInstance(); echo $inCore->getDateForm('birthdate'){/php}</td>
</tr>

<tr>
                <td valign="top"><strong>Пол:</strong></td>
                <td valign="top">
                    <select name="gender" id="gender" style="width:200px">
                        <option value="m" {if $gender=='m'} selected {/if}>Мужской</option>
                        <option value="f" {if $gender=='f'} selected {/if}>Женский</option>
                    </select>
               <span class="regstar">*</span>
                </td>
            </tr>
             <tr>
                        <td valign="top" class="" width="269">
                            <div><strong>Ваш город:</strong></div>
                            <small>Указав город вы сможете искать своих земляков</small>
                        </td>
                        <td valign="top" class="">
                            <input name="city" id="city" class="text-input" type="text" size="30" value="{$city}" />
                            <span class="regstar">*</span>
                        </td>
 </tr>
 

 
if ($cfg['ask_icq']){
            $icq = $inCore->request('icq', 'str', '');
			$icq = preg_replace('/([^0-9])/i', '', $icq);
        } else {
            $icq = '';
        }

$gender = $inCore->request('gender', 'str', '');
$city = $inCore->request('city', 'str', '');
if(!$city) {$msg .= 'Необходимо указать город
';}

$sql = "INSERT INTO cms_user_profiles (user_id, city, description, showmail, showbirth, showicq, karma, imageurl, allow_who, gender)
                                VALUES (".$new_user_id.", '$city', '', '0', '0', '1', '0', '', 'all', '$gender')";
 

$sql1 = "SELECT MAX(position) as c FROM cms_user_profiles";
$result1111 = $inDB->query($sql1);
$result1111 = $inDB->fetch_assoc($result1111);
$pos23 = 1 + $result1111['c'];
$sql1 = "UPDATE cms_user_profiles SET position = '$pos23' WHERE id = '$new_user_id'";
$inDB->query($sql1);	

ALTER TABLE `cms_user_profiles` ADD  `position` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `city`

UPDATE `cms_user_profiles` SET POSITION = id

public function getPostion($pos, $gen){
	$sql = "SELECT COUNT(p.id) as c
                        FROM cms_user_profiles p 
		WHERE position >= ".$pos." AND gender = '".$gen."'";
 
        $result = $this->inDB->query($sql);
        $result = $this->inDB->fetch_assoc($result);
 
        return $result['c'];
 
}

///////////////////////////////////////////// для анкет
if ($usr['gender'] == 'm' || $usr['gender'] == 'f' ) { $usr['position'] = $model->getPostion($usr['position'], $usr['gender']); }
else {$usr['position'] =0;}
 
///////////////////////// для анкет(конец);

 if($orderby == 'karma') { $orderby = 'karma'; $link['selected'] = 'positive'; }
        if($orderby == 'rating') { $orderby = 'rating'; $link['selected'] = 'rating';}
        if($orderby == 'regdate') { $orderby = 'regdate'; $link['selected'] = 'latest'; }
        if($orderby == 'man') { $orderby = 'position'; $order= 'AND p.gender = \'m\''; $link['selected'] = 'man';}
        if($orderby == 'woman') { $orderby = 'position';$order= 'AND p.gender = \'f\''; $link['selected'] = 'woman';}

if (!@$_SESSION['usr_online']){
 
                        $sql = "SELECT
                                    u.id as id,
                                    u.login,
                                    u.nickname,
                                    u.logdate as flogdate,
                            u.is_deleted as is_deleted,
                    u.birthdate, u.rating,
                                    u.status as microstatus,
                    p.city, p.karma as karma, p.imageurl,
                                    p.gender as gender
                    FROM cms_users u
                                    LEFT JOIN cms_user_profiles p ON p.user_id = u.id
                                    WHERE  u.is_locked = 0 AND u.is_deleted = 0 ".$order."
                                        ORDER BY ".$orderby." ".$orderto."
                                        LIMIT ".(($page-1)*$perpage).", $perpage";
                } else {
 
                $sql = "SELECT
                                    o.user_id as id,
                                    u.login,
                                    u.nickname,
                                        u.logdate as flogdate,
                            u.is_deleted as is_deleted,
                    u.birthdate, u.rating,
                                    u.status as microstatus,
                    p.city, p.karma as karma, p.imageurl,
                                    p.gender as gender
                                    FROM cms_online o
                    LEFT JOIN cms_users u ON  u.id = o.user_id
                                    LEFT  JOIN cms_user_profiles p ON p.user_id = u.id
                                    WHERE ".$orderby." u.is_locked = 0 AND u.is_deleted = 0  ".$order."
                    GROUP BY o.user_id
                                        ORDER BY ".$orderby." ".$orderto."
                                        LIMIT ".(($page-1)*$perpage).", $perpage";
                }
        } else {
                $sql = $querysql;
    }

$link['man']    = '/users/man.html';
 $link['woman']    = '/users/woman.html';