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

$project_id = 393669;

// Получаем все поля проекта
$query = "SELECT * FROM vtiger_project WHERE projectid = ?";
$result = $adb->pquery($query, array($project_id));

if ($adb->num_rows($result) > 0) {
    echo "Project $project_id data:\n";
    $row = $adb->fetch_array($result);
    
    // Выводим все поля, которые содержат cf_
    foreach ($row as $field => $value) {
        if (strpos($field, 'cf_') === 0 && !empty($value)) {
            echo "$field: $value\n";
        }
    }
    
    // Проверим также основные поля
    echo "\nBasic fields:\n";
    echo "projectname: " . $row['projectname'] . "\n";
    echo "linktoaccountscontacts: " . $row['linktoaccountscontacts'] . "\n";
    
} else {
    echo "Project $project_id not found\n";
}

// Также проверим через crmentity
$query2 = "SELECT * FROM vtiger_crmentity WHERE crmid = ?";
$result2 = $adb->pquery($query2, array($project_id));

if ($adb->num_rows($result2) > 0) {
    echo "\nCrmentity data:\n";
    $row2 = $adb->fetch_array($result2);
    echo "smownerid: " . $row2['smownerid'] . "\n";
    echo "createdtime: " . $row2['createdtime'] . "\n";
}
?>