Files
crm.clientright.ru/check_project_web.php

34 lines
927 B
PHP
Raw Permalink Normal View History

<?php
require_once('config.php');
global $adb;
$project_id = 393669;
// Простой запрос для проверки существования проекта
$query = "SELECT projectname FROM vtiger_project WHERE projectid = ?";
$result = $adb->pquery($query, array($project_id));
if ($adb->num_rows($result) > 0) {
$project_name = $adb->query_result($result, 0, 'projectname');
echo "Project $project_id exists: $project_name\n";
} else {
echo "Project $project_id not found\n";
}
// Проверим все поля проекта
$query2 = "SELECT * FROM vtiger_project WHERE projectid = ?";
$result2 = $adb->pquery($query2, array($project_id));
if ($adb->num_rows($result2) > 0) {
$row = $adb->fetch_array($result2);
echo "\nAll fields:\n";
foreach ($row as $field => $value) {
if (!empty($value) && $value !== '0') {
echo "$field: $value\n";
}
}
}
?>