Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/domains/lavocat.ca/private_html/scripts/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient();

async function checkDannyProfile() {
  try {
    const user = await prisma.user.findUnique({
      where: { email: 'dannywperez@msn.com' },
      select: {
        id: true,
        email: true,
        name: true,
        role: true,
        username: true,
        profilePicture: true,
        bio: true,
        title: true,
        specialization: true,
        yearsOfExperience: true,
        officeLocation: true,
        availability: true,
        hourlyRate: true,
        proBono: true,
        averageRating: true,
        totalCases: true,
        wonCases: true,
        isVerified: true,
        xpPoints: true,
        level: true,
        createdAt: true,
        updatedAt: true
      }
    });

    if (!user) {
      console.log('❌ User dannywperez@msn.com not found in database');
      return;
    }

    console.log('✅ Danny Perez Profile Data:');
    console.log('================================');
    console.log(`ID: ${user.id}`);
    console.log(`Email: ${user.email}`);
    console.log(`Name: ${user.name}`);
    console.log(`Role: ${user.role}`);
    console.log(`Username: ${user.username || 'NOT SET'}`);
    console.log(`Profile Picture: ${user.profilePicture || 'NOT SET'}`);
    console.log(`Bio: ${user.bio || 'NOT SET'}`);
    console.log(`Title: ${user.title || 'NOT SET'}`);
    console.log(`Specialization: ${user.specialization || 'NOT SET'}`);
    console.log(`Years of Experience: ${user.yearsOfExperience || 'NOT SET'}`);
    console.log(`Office Location: ${user.officeLocation || 'NOT SET'}`);
    console.log(`Availability: ${user.availability || 'NOT SET'}`);
    console.log(`Hourly Rate: ${user.hourlyRate || 'NOT SET'}`);
    console.log(`Pro Bono: ${user.proBono || 'NOT SET'}`);
    console.log(`Average Rating: ${user.averageRating || 'NOT SET'}`);
    console.log(`Total Cases: ${user.totalCases || 'NOT SET'}`);
    console.log(`Won Cases: ${user.wonCases || 'NOT SET'}`);
    console.log(`Is Verified: ${user.isVerified || 'NOT SET'}`);
    console.log(`XP Points: ${user.xpPoints || 'NOT SET'}`);
    console.log(`Level: ${user.level || 'NOT SET'}`);
    console.log(`Created: ${user.createdAt}`);
    console.log(`Updated: ${user.updatedAt}`);
    console.log('================================');

  } catch (error) {
    console.error('❌ Error checking Danny profile:', error);
  } finally {
    await prisma.$disconnect();
  }
}

checkDannyProfile();