<?php
require_once('config.php');
global $adb;

$project_id = 393669;
$query = "SELECT cf_1994 FROM vtiger_project WHERE projectid = ?";
$result = $adb->pquery($query, array($project_id));

if ($adb->num_rows($result) > 0) {
    $cf_1994 = $adb->query_result($result, 0, 'cf_1994');
    echo "Project $project_id cf_1994: $cf_1994\n";
    
    // Если это ссылка на контакт, проверим контакт
    if (strpos($cf_1994, 'x') !== false) {
        $contact_id = substr($cf_1994, strpos($cf_1994, 'x') + 1);
        echo "Contact ID: $contact_id\n";
        
        $query2 = "SELECT lastname FROM vtiger_contactdetails WHERE contactid = ?";
        $result2 = $adb->pquery($query2, array($contact_id));
        if ($adb->num_rows($result2) > 0) {
            $contact_name = $adb->query_result($result2, 0, 'lastname');
            echo "Contact name: $contact_name\n";
        }
    }
} else {
    echo "Project $project_id not found\n";
}
?>